Benötige Hilfe beim Anti Question Mod in PHP Admin

Henny81Opel · Beitrag von **Henny81Opel** » 14.05.2007 19:42

Hallo,

kann mir jemand beim einrichten der Tabellen mittels PHP Admin des Anti Question Mod behilflich sein? Wäre sehr nett, da ich mich nicht gut mit PHP auskenne, jedoch gerne den Mod installieren möchte, um in Zukunft die unerwünschten Benutzerregistrieren abzublocken.

Fussball-Experte.com · Beitrag von **Fussball-Experte.com** » 14.05.2007 22:22

Hi,
denke mal das du den ABQ Mod meinst.
Was musst du denn da großartiges in deiner Datenbank machen,
was du nicht selber erlernen kannst.
Du musst nur beim phpmyadmin diesen Befehl rein kopieren und ausführen:

Code: Alles auswählen

CREATE TABLE phpbb_anti_bot_quest_config (
 config_name VARCHAR(255) NOT NULL,
 config_value VARCHAR(255) NOT NULL,
 PRIMARY KEY (config_name) 
);

INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_register', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_guest', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('abq_variable_name', 'abq_0001');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('IndiQuests_CaseSensitive', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('IndiQuests_ImagePHP', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Individuel_Questions', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Ratio_Auto_Indi_Questions', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_01', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_02', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_03', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_04', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_05', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_06', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_07', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_08', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_09', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_10', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_11', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_12', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_13', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_14', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_15', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_16', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_17', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_18', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_19', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_20', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_21', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_22', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_23', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_24', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_25', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_26', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_27', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_28', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_29', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_30', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_31', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_32', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_33', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuestion_34', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('max_Effects', '3');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_SeparatingLines', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_BGText', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_Grid', '2');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_FilledGrid', '1');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_GridHeight', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_GridWidth', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_Ellipses', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_Arcs', '2');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Effect_Lines', '2');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuests_LargeNumbers', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuests_MultiplicationSymbol', '*');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('AutoQuests_MultipleChoise', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('agreed_variable_name', 'ab_var');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('agreed_variable_value', 'agreed');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('email_variable_name', 'ab_email');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('multiimages', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('fontsize', '20');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('ImageFormat', '20');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('JPG_Quality', '80');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_R1', '210');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_R2', '230');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_G1', '210');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_G2', '230');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_B1', '210');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BG_B2', '230');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question1_R', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question1_G', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question1_B', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question2_R', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question2_G', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_Question2_B', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_R1', '225');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_G1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_G2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_B1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid1_B2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_R1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_R2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_G1', '225');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_B1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid2_B2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_R1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_R2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_G1', '90');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_G2', '110');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_B1', '225');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid3_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_R1', '130');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_R2', '170');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_G1', '130');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_G2', '170');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_B1', '130');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Grid4_B2', '170');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_R1', '200');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_G1', '200');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_B1', '200');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_FilledGrid_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_R1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_G1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_B1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Ellipses_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_R1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_G1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_B1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_PartialEllipses_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_R1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_G1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_B1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Lines_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_R1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_R2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_G1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_G2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_B1', '120');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Arcs_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_R1', '180');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_R2', '220');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_G1', '180');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_G2', '220');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_B1', '180');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_BGText_B2', '220');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_R1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_R2', '100');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_G1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_G2', '100');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_B1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_Text_B2', '255');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_R1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_R2', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_G1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_G2', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_B1', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('Color_SeparatingLines_B2', '50');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('lib_gd', '3');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('lib_ft', '2');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('show_counter', '2');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('counter_vari', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('counter_quest_reg', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('counter_quest_post', '0');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('lockregister', '3');
INSERT INTO phpbb_anti_bot_quest_config (config_name, config_value) VALUES ('lockguestposts', '8');

CREATE TABLE phpbb_anti_bot_quest_confirm (
 confirm_id CHAR(32) NOT NULL,
 session_id CHAR(32) NOT NULL,
 answer VARCHAR(255) NOT NULL,
 line1 VARCHAR(255) NOT NULL,
 line2 VARCHAR(255) NOT NULL,
 line3 VARCHAR(255) NOT NULL,
 line4 VARCHAR(255) NOT NULL,
 color CHAR(1) NOT NULL,
 whichform CHAR(1) NOT NULL,
 start_time INT(11) NOT NULL,
 PRIMARY KEY (confirm_id) 
);

CREATE TABLE phpbb_anti_bot_quest_regconfirm (
 confirm_id CHAR(32) NOT NULL,
 session_id CHAR(32) NOT NULL,
 start_time INT(11) NOT NULL,
 PRIMARY KEY (session_id) 
);

CREATE TABLE phpbb_anti_bot_quest (
 id MEDIUMINT(8) NOT NULL,
 question TEXT NOT NULL,
 answer1 VARCHAR(255) NOT NULL,
 answer2 VARCHAR(255) NOT NULL,
 answer3 VARCHAR(255) NOT NULL,
 answer4 VARCHAR(255) NOT NULL,
 answer5 VARCHAR(255) NOT NULL,
 anti_bot_img VARCHAR(255) NOT NULL,
 lang VARCHAR(255) NOT NULL,
 bbcodeuid VARCHAR(10) NOT NULL,
 wronganswer01 VARCHAR(255) NOT NULL,
 wronganswer02 VARCHAR(255) NOT NULL,
 wronganswer03 VARCHAR(255) NOT NULL,
 wronganswer04 VARCHAR(255) NOT NULL,
 wronganswer05 VARCHAR(255) NOT NULL,
 wronganswer06 VARCHAR(255) NOT NULL,
 wronganswer07 VARCHAR(255) NOT NULL,
 wronganswer08 VARCHAR(255) NOT NULL,
 wronganswer09 VARCHAR(255) NOT NULL,
 wronganswer10 VARCHAR(255) NOT NULL,
 imagequestion char(1) NOT NULL,
 PRIMARY KEY (id)
);

INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('1', 'Which of these four is a planet?\r\nAmerica, Cat, Earth, University', 'Earth', '', '', '', '', '', 'english', 'b7d1788b14', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('2', 'Which of these four is an animal?\r\nCar, Europe, Horse, Mountain', 'Horse', '', '', '', '', '', 'english', '0a8929fb6a', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('3', 'What is the result of three multiplied by three?\r\n(Do not use numbers in your answer. e.g. If the result is 5, then write five.)', 'nine', 'Nine', '', '', '', '', 'english', 'aef9c3dd22', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('4', 'Shows the picture fire? Yes or no', 'Yes', 'yes', '', '', '', 'example2.jpg', 'english', '4b5116a301', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('5', 'What kind of fruit is shown on the picture?', 'Apple', 'apple', '', '', '', 'example5.jpg', 'english', '4f531943b6', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('6', 'Can you see an airplane on the photo?', 'No', 'no', '', '', '', 'example2.jpg', 'english', '30fcf0fd26', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('7', 'How many blue lines can you count on the image?', '4', 'four', 'Four', '', '', 'example3.gif', 'english', 'adc7dc3e28', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('8', 'How many red lines can you see on the image?', '5', 'five', 'Five', '', '', 'example3.gif', 'english', '9134e7320c', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('9', 'What is the result of...', '5', 'five', 'Five', '', '', 'example4.jpg', 'english', '37b6dd7e9b', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO phpbb_anti_bot_quest (id, question, answer1, answer2, answer3, answer4, answer5, anti_bot_img, lang, bbcodeuid, wronganswer01, wronganswer02, wronganswer03, wronganswer04, wronganswer05, wronganswer06, wronganswer07, wronganswer08, wronganswer09, wronganswer10, imagequestion) VALUES ('10', 'How many arrows can you find?', '6', 'six', 'Six', '', '', 'example1.jpg', 'english', '50dd984877', '', '', '', '', '', '', '', '', '', '', '');

Greetz

Henny81Opel · Beitrag von **Henny81Opel** » 15.05.2007 21:32

Ja genau den Mod meine ich.

Wie gehts das denn? Wie füge ich den Code in PHPMyAdmin ein? Kannst Du mir das bitte erklären?

Beitrag von **Dr.Death** » 15.05.2007 21:39

Nein, lese einfach folgende, bereits vorhandene Anleitungen:

KB:18 ( Punkt 12 )
KB:122

Henny81Opel · Beitrag von **Henny81Opel** » 17.05.2007 13:08

Ja vielen Dank, ich habe den Artikel gelesen. Dort finde ich wie ich mit PHP Admin umgehe. Aber welche Befehl muss ich ausführen, wo ich den Code einfügen kann.

Bitte um Hilfe!

OliverMBL · Beitrag von **OliverMBL** » 17.05.2007 13:37

Hallo,

du loggst dich einfach in dein phpMyAdmin ein. Oben links hast du ein Menü in dem es auch ein Button "SQL" gibt.

Wenn du da drauf klickst, kannst du in das freie Fenster deinen Code einfügen.

Auf OK klicken und die neue Tabelle ist erstellt

Henny81Opel · Beitrag von **Henny81Opel** » 17.05.2007 15:29

Hallo, vielen Dank. Ich habe alles Dateien bearbeitet.

Nun erscheint folgende Fehlermeldung:

Warning: include(./language/lang_german/lang_abq.php) [function.include]: failed to open stream: No such file or directory in /var/www/html/web416/html/bb/includes/functions.php on line 402

Warning: include() [function.include]: Failed opening './language/lang_german/lang_abq.php' for inclusion (include_path='.:/usr/share/pear') in /var/www/html/web416/html/bb/includes/functions.php on line 402

Parse error: syntax error, unexpected '/' in /var/www/html/web416/html/bb/includes/usercp_register.php on line 90

Wo könnte der Fehler liegen?

Beitrag von **Dr.Death** » 17.05.2007 20:14

Laut Fehlermeldung hast du die mitgelieferte Datei lang_abq.php nicht in den Sprach Ordner languages/lang_german/ hochgeladen !

Henny81Opel · Beitrag von **Henny81Opel** » 17.05.2007 21:32

Ich habe wie beschrieben die Datei hochgeladen. Die fehlte, du hattest recht.

Jetzt bekomme ich wenn man sich registieren will, diese Fehlermeldung:

Parse error: syntax error, unexpected '/' in /var/www/html/web416/html/bb/includes/usercp_register.php on line 90

Woran könnte das liegen?

Beitrag von **Dr.Death** » 17.05.2007 21:50

hm... Glaskugel beschwör....huch... kaputt.

An einem unsauberen MOD Einbau in der
usercp_register.php Zeile 90

Verlinke uns doch mal die Datei als TXT Datei... dann können wir einen direkten Blick darauf werfen....