phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

Benötige Hilfe beim Anti Question Mod in PHP Admin

https://www.phpbb.de/community/viewtopic.php?t=148282

Seite 1 von 3

Benötige Hilfe beim Anti Question Mod in PHP Admin

Verfasst: 14.05.2007 19:42
von Henny81Opel
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.

Verfasst: 14.05.2007 22:22
von Fussball-Experte.com
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

Verfasst: 15.05.2007 21:32
von Henny81Opel
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?

Verfasst: 15.05.2007 21:39
von Dr.Death
Nein, lese einfach folgende, bereits vorhandene Anleitungen:

KB:18 ( Punkt 12 )
KB:122

Verfasst: 17.05.2007 13:08
von Henny81Opel
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!

Verfasst: 17.05.2007 13:37
von OliverMBL
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 ;)

Verfasst: 17.05.2007 15:29
von Henny81Opel
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?

Verfasst: 17.05.2007 20:14
von Dr.Death
Laut Fehlermeldung hast du die mitgelieferte Datei lang_abq.php nicht in den Sprach Ordner languages/lang_german/ hochgeladen !

Verfasst: 17.05.2007 21:32
von Henny81Opel
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?

Verfasst: 17.05.2007 21:50
von Dr.Death
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....
Alle Zeiten sind UTC+02:00
Seite 1 von 3

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de