1. it would be great to have a checkbox for turning off e-mail notification to the site admin. it's an interesting read in the beginning, but it really fills up your mailbox..
2. will you come up with a version of the mod for phpBB3?
Could not insert question/answer pair!
DEBUG MODE
SQL Error : 1146 Table 'icmodified.TEXTUAL_CONFIRMATION_TABLE' doesn't exist
INSERT INTO TEXTUAL_CONFIRMATION_TABLE(question,answers) VALUES('hi
','hi')
Line : 113
File : admin_tc.php
Code: Select all
#
#-----[ 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');
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_textual_confirmation (
id INTEGER NOT NULL AUTO_INCREMENT,
question TEXT NOT NULL,
answers TEXT NOT NULL,
PRIMARY KEY (id)
);
ERROR: syntax error at or near "AUTO_INCREMENT" at character 70
Code: Select all
CREATE TABLE phpbb_textual_confirmation (
id SERIAL,
question TEXT NOT NULL,
answers TEXT NOT NULL,
PRIMARY KEY (id)
);
NOTICE: CREATE TABLE will create implicit sequence "phpbb_textual_confirmation_id_seq" for "serial" column "phpbb_textual_confirmation.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "phpbb_textual_confirmation_pkey" for table "phpbb_textual_confirmation"
olpa wrote: GilaMonster, I think you are playing with phpmysqladmin. The easiest way is to find an SQL console there to execute arbitrary SQL queries. I don't use phpmysqladmin, therefore can't suggest where it is. Probably this topic can help: How to use phpMyadmin.
To all who said thanks: thanks for the kind words!
Code: Select all
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');
Code: Select all
CREATE TABLE phpbb_textual_confirmation (
id SERIAL,
question TEXT NOT NULL,
answers TEXT NOT NULL,
CONSTRAINT phpbb_textual_confirmation_pk PRIMARY KEY (id)
);