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.