have moved these to a separate hidden forum "Trash" and needed two SQL commands for that - one to update topics table and one to update posts table.
You see, phpBB has some redundancy in data to improve performance. If you do not pay attention to this, things might get bad.
cordob wrote:vsego wrote:have moved these to a separate hidden forum "Trash" and needed two SQL commands for that - one to update topics table and one to update posts table.
Would you mind sharing those commands pse; I am a novice sql-er.
Code: Select all
update phpbb_topics set forum_id=<trash forum id> where topic_title like '%lesbians%'; update phpbb_posts set forum_id=<trash forum id> where post_username='Pepotamo1985';
cordob wrote: Whilst I was at dinner he revisited the bot was back and posted some more. Have now enabled the visual verification, hope that helps against another user. Don't understand how he got thru though, as I set it to need an email from me when starting. Apparently sidestepped that too.
cordob wrote: Btw don't need anything "lesbian" on my forum, got a lesbian sister, she's OK
Darth Wong wrote: The problem with the "don't allow guest posting" remedy is that many forums (including mine) have a "test" forum in which people who are having trouble registering can post questions and get help registering. That's why I think that "visual confirmation for guest posting" idea is really good, although I'm not sure how to go about making that happen.
Clive wrote: My changes didnt work on my server at home but on my main domain it is all set up, I am still trying to get a handle on setting up gd and true type or even trying to figure out if I have it... I have php 4.3.3 at home and gd files are present but dont know what to do with them YET...
Code: Select all
apt-get install php-gd
Graham wrote: a) TO prevent automated registrations enable the visual confirmation which is present in version 2.0.11
b) Make sure that all of your forums are set to not allow guest posting
c) If you have done both of the above, please provide us with some more information (eg the Suppport Request Template forum at the top of the support forum) to allow us to assist further