Thread: Populate Your Priv_Members Table

Note: Please see the latest script in a more recent post.


For proper operation of membership levels, your priv_members table needs to be populated with your users.

If you have problems with membership levels in CLEAN, please check your priv_members table and see if each of your users has an entry.

There are three ways for an entry to be made:

1) On join.

2) On edit from admin panel (with the fixed clean code, this now works - it was broken in v4.0 patch 2)

3) use a script.

The script is attached...

This script NEEDS to be edited before running it on your system. Please look at it carefully and understand it's operation before running it.

Smoge

While I am in Shanghai - I will re-write this code...

It needs some checks and improvements to make it more useful.

Why is this code needed?

Well - first off, you guys running v4.0 Patch 2 (or before), if you set a user level in the admin panel - the aeDating code was not writing to the priv_members table correctly... this is a bigger problem if you did an upgrade.

I need to change this code so it does not change the users you have already given higher access to - and keeps this info.

For example, I know GJGUY needs this code on his site....

Smoge

Ok - I re-wrote this code - it is not perfect - but closer to what we need.

This release warns you of what you are about to do - to make sure you understand what it does.

It also takes the current membership info for each user (level and number of days) from the Profiles table - and inserts records into priv_members based on this.

Some Notes:

I will delete your current data in priv_members so you end up with a clean, correct table.

It sets your Pdate (purchase date) to the current day. You may need to deal with this if you have paying members.

Upload it and run it from your aeDating root directory... follow the instructions on the screen.

http://www.yourdomain.com/populate_priv_members.php

When you are done - you should delete it from your server, so you don't run it by mistake in the future.

Smoge