bbAntiSpam: Discuss how to stop web spam

The forum is retired.

bbAntiSpam Forum Index - phpBB spam - bbantispam

Author Message
Fred Gross
Guest





Posted: Sun Sep 09, 2007 2:18 am    Post subject: bbantispam  

When I use Control Panel on my web hosts site, the MySQL options only show me existing users and give me the ability to delete existing databases. I dont see anyway to add tables.

I am stuck at this point. Any suggestions on how to proceed with this last task?

#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_textual_confirmation (
id INTEGER NOT NULL AUTO_INCREMENT,
question TEXT NOT NULL,
answers TEXT NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES ('Are you human?', 'yes\nja\noui');
INSERT INTO phpbb_textual_confirmation(question,answers) VALUES ('Say hello', 'hello\nhi\nhallo');
Slacker
Guest





Posted: Sun Sep 09, 2007 3:35 pm    Post subject:  

Do your host have phpMyAdmin? I use it mainly for those purposes. If you have enough of web space available, you should also be able to install phpMyAdmin there. I have done it and it worked,
Fred
Guest





Posted: Sun Sep 09, 2007 11:52 pm    Post subject: spambots  

Slacker wrote:
Do your host have phpMyAdmin? I use it mainly for those purposes. If you have enough of web space available, you should also be able to install phpMyAdmin there. I have done it and it worked,


Yes, it works great. Thanks.
admin
Site Admin


Joined: 18 Apr 2006
Posts: 805
Location: Saint-Petersburg, Russia

Posted: Mon Sep 10, 2007 1:56 am    Post subject:  

The most simple way to create tables for Textual Confirmation is described here: executing SQL. But it's always useful to have phpMyAdmin installed.
_________________
Oleg Parashchenko, bbAntiSpam
Do you love our tools? Please sponsor further development!

Ok.