Hello,

I have purchased and install the cookie password product the other day. I have about 100 users that I have inserted into the database pp29_users and when I look at the table I see the users. When I load the admin.php it doesn't display any of the users I have added manually. What is the trick to bulk loading user accounts into the system?

Thanks,

TCox

They must belong to a group too, like users for example. Otherwise they wont show up.

Right after I typed it in I added a group id to each user and they showed up. The problem I am having now is with passwords. I used the following sql code to update the user's passwords:

UPDATE pp29_users SET password=PASSWORD("password1") WHERE login='maint';

The statement above is for one of the users and when I execute the query phpmyadmin reports back that no rows are affected. I can apply this to any of the existing users in the pp29_users table. I was able to insert the passwords to begin with but when I try to login it fails.

Is there any special trick to updating passwords?

Thanks again,

TCox

Create a php file called for example updatepassword.php and upload it to the same directory as your settings.php. The file should look like this:

Only run the file once and delete it from your server after.

This script requires that you've uploaded the user passwords as clear text (i.e. readable by humans). All passwords except for the admin password will be encrypted.

/Bylla

Thanks Bylla for the information. I was able to bulk load all of the users and set the passwords. The only way I can protect my pages is to put the settings file in the root webdocs directory. Is there a better option?

On some servers that's the only solution. protection.php will search for settings.php and if it can only find it in the root webdocs directory, then that's the only solution.

/Bylla