Frequently Asked Questions: script questions: phpfanbase customize: page: 2
-
1
I want to link directly to my entire member list without going through the country section. Can that be done?
Yes. Simply link to “members.php?id=all” instead of just “members.php” and that should display your entire member list.
May 29, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Customize, Scripts
-
2
How do I delete a member from my list?
Go into the Edit Members screen, and type their ID into the ID box. If you don’t know the ID, type in their name in the name box, or their email in the email box. Click submit, and if the next screen displays more than one member, scroll down until you find the one you want to delete. Click on the little arrow next to Update and select Delete from the dropdown. Click the Submit button, and that’s all! Your member has been deleted!

May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Customize, Scripts
-
3
When the approval email is sent to a member and the email address turns out to be not valid or non-existent, do I get a “failure” notification?
That depends on how your server is set up. Usually, this will not be the case, since the email will technically come from PHP, and not through your email program, but your server can be configured to do this. If this is not happening on your server, and you would like it to, ask your host about it.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Customize, Scripts
-
4
Why is Holland not listed in the country list?
It is, it’s listed as The Netherlands, which is its official name.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Customize, Scripts
-
5
Someone who has joined a bunch of my fanlistings changed their email/URL. Is there a fast way to go through the whole database and change their info?
You can go to phpMyAdmin and use UPDATE statements in MySQL, but it doesn’t work for an entire database, though, it’s only per table.
For someone who changed their email, you could use:
UPDATE table SET email = "newaddress@blog.com" WHERE email = "oldaddress@blog.com";
For someone who changed their url:
UPDATE table SET url = "http://newurl.com" WHERE url = "http://oldurl.com";
For someone who changed both email and url:
UPDATE table SET email = "newaddress@blog.com", url = "http://newurl.com" WHERE email = "oldaddress@blog.com" AND url = "http://oldurl.com";
You need to login to phpMyAdmin for this, and click the SQL tab. Just paste this directly into the text box, and of course, replace table and the email addresses/URLs with the right ones. You’ll have to do this for every fanlisting table, though.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Customize, Scripts