phpBB
Started by
Ryan
, Sep 15 2005 02:44 PM
#1
Posted 15 September 2005 - 02:44 PM
#2
Posted 19 September 2005 - 08:57 PM
Hi rmurphy.
The answer is yes -- if you have something like phpMyAdmin installed or your host server provides it for your use for a client-side application to access your database(s) manually, then yes you can do it.
phpMyAdmin is not only very nice for doing routine database maintenance functions, but also serves nicely for doing these type things manually when no other tool is available... So by using phpMyAdmin you can access your database using the server info, database name, username, and password.
When you normally view the phpBB topic in IE or Foxfire you will see and can note the topic# at the end of the URL listing.
When viewing the database with phpMyAdmin and looking at the "users" table (often listed as phpbb_users) you can and should find the new username you want to change that post to.
Look by using phpMyAdmin and find the user in the phpbb_users table and look at the user's user_id and make a note of it (the actual user_id number).
Now look in the phpbb_topics table and find the topics_id which will match the topic# noted in the URL listing when viewed by IE or Foxfire. There you will see the topic info to confirm the correlation (informational for consistency of understanding).
Now look in the phpbb_posts table and sort by topics_id and scroll through them until you find the topic_id corresponding to the topic s/he posted in (noted at the end of the URL). If they were a Guest (anonymous) poster, then it will show up as a -1 for the poster_id of a "Guest" (Anonymous) poster. Change that -1 poster_id (same as the user_id) to the new user's actual user_id ... You may want to double check the phpbb_posts_text table and the post_id to ensure that the text matches the post you are wanting to modify.
After you make the change to the new user_id (poster_id), then you should view the topic again (refresh the page) and see if the new user's name is listed as desired instead of the "Guest" username.
Now having done all this, you may want to set the permissions in phpBB Admin panel to only allow registered members to post (this is optional, but often recommended to mitigate anonymous posting in a forum)...
This process seems and is tedious (especially for a "large" board) and is not done often, but should get the job done for you OK. You may learn a little about phpMyAdmin and phpBB too, which is a good thing to know for database repairs, optimizations, etc.
Good Luck!
The answer is yes -- if you have something like phpMyAdmin installed or your host server provides it for your use for a client-side application to access your database(s) manually, then yes you can do it.
phpMyAdmin is not only very nice for doing routine database maintenance functions, but also serves nicely for doing these type things manually when no other tool is available... So by using phpMyAdmin you can access your database using the server info, database name, username, and password.
When you normally view the phpBB topic in IE or Foxfire you will see and can note the topic# at the end of the URL listing.
When viewing the database with phpMyAdmin and looking at the "users" table (often listed as phpbb_users) you can and should find the new username you want to change that post to.
Look by using phpMyAdmin and find the user in the phpbb_users table and look at the user's user_id and make a note of it (the actual user_id number).
Now look in the phpbb_topics table and find the topics_id which will match the topic# noted in the URL listing when viewed by IE or Foxfire. There you will see the topic info to confirm the correlation (informational for consistency of understanding).
Now look in the phpbb_posts table and sort by topics_id and scroll through them until you find the topic_id corresponding to the topic s/he posted in (noted at the end of the URL). If they were a Guest (anonymous) poster, then it will show up as a -1 for the poster_id of a "Guest" (Anonymous) poster. Change that -1 poster_id (same as the user_id) to the new user's actual user_id ... You may want to double check the phpbb_posts_text table and the post_id to ensure that the text matches the post you are wanting to modify.
After you make the change to the new user_id (poster_id), then you should view the topic again (refresh the page) and see if the new user's name is listed as desired instead of the "Guest" username.
Now having done all this, you may want to set the permissions in phpBB Admin panel to only allow registered members to post (this is optional, but often recommended to mitigate anonymous posting in a forum)...
This process seems and is tedious (especially for a "large" board) and is not done often, but should get the job done for you OK. You may learn a little about phpMyAdmin and phpBB too, which is a good thing to know for database repairs, optimizations, etc.
Good Luck!
#3
Posted 21 September 2005 - 09:33 AM
Thanks, i will try this later after i get some sleep...i just pulled an all nighter for an exam.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users