abq problem...

damax · Mesaj de **damax** » 06-Apr-2007, 14:54:36

Salutare,

am instalat abq MOD si trebuie sa bag in baza de date urmatoarele:

INSERT INTO `phpbb_anti_bot_quest_config` ( `config_name` , `config_value` ) VALUES ('af_malzeichen', '*');
INSERT INTO `phpbb_anti_bot_quest_config` ( `config_name` , `config_value` ) VALUES ('af_use_select', '0');

ALTER TABLE `phpbb_anti_bot_quest` 
ADD `wronganswer01` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer02` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer03` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer04` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer05` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer06` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer07` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer08` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer09` VARCHAR( 255 ) NOT NULL ,
ADD `wronganswer10` VARCHAR( 255 ) NOT NULL ;

Nimic mai simplu insa SQL-ul spune :

Cod: Selectaţi tot

#1146 - Table 'uage_srv_ro.phpbb_anti_bot_quest_config' doesn't exist

Gasisem la un moment dat ce anume trebuie sa fac, dar acum caut de o ora si deja ma enerveaza situatia. Deci va rog care stie sa-mi dea o rezolvare a problemei..

Multumesc si Sarbatori Fericite tuturor!!

Tickapa · Mesaj de **Tickapa** » 06-Apr-2007, 15:04:20

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

Ai creat tabelul?

damax · Mesaj de **damax** » 06-Apr-2007, 15:11:36

da acum am creat tabelele cu pricina totul e in regula....sau nu:D

Faza e ca desi am instalat MOD-ul acum din ACP la ABQ nu imi apar decat niste tabele si atat...

Ma gandeam ca trebuie sa fac update-ul (modificarea fisierelor .php, dar cand dau find la ce trebuie...nu imi gaseste ..) mai ales la posting.php...

Nu am continuat pentru ca m-au luat toti dracii...

Tickapa · Mesaj de **Tickapa** » 06-Apr-2007, 15:14:54

damax, nu doar tabelul acela trebuia... eu l-am dat doar ca exemplu. Uite aici tot ce trebuie sa executi in phpmyadmin.

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', '', '', '', '', '', '', '', '', '', '', '');

damax · Mesaj de **damax** » 06-Apr-2007, 16:04:57

Logic ca am dat toate astea...merci oricum.

Cu toate astea din pacate nu mai functioneaza deloc inregistrarea, cu adevarat merge dar nu cum trebuie.

E posibil sa fi gresit eu ceva...putin probabil...dar ...

Cine vrea sa se inscrie acum nu o mai poate face, practic apare doar background-ul...deci am stricat forumul..

Tickapa · Mesaj de **Tickapa** » 06-Apr-2007, 16:07:03

damax, dezinstaleaza MOD-ul, vezi daca merge inregistrarea si pe urma incearca sa-l instalezi iar. Dar fara graba ca sa nu gresesti iar ceva.

damax · Mesaj de **damax** » 06-Apr-2007, 17:00:18

L-am dezinstalat, merge inregistrarea...nu mai incerc nika...ma duc sa vada daca a crescut pasca in cuptor...

EDIT:

Deci fratilor, printre vinuri, cozonaci, si oua rosii, haideti sa lamurim si problema cu instalarea MOD-ului asta:

1. Am copiat toate fisierele .php din root, fiecare unde trebuie.
2. Am creat cica tabelele in baza de date prin phpMyAdmin
3. Ar mai fi o problema, la modificarile anumitor fisiere .php, de exemplu la find.......after add:

Exemplu :

Cod: Selectaţi tot

#
#-----[ FIND ]------------------------------------------
#
			$username = $row['username'];
			$user_id = $row['user_id'];

si am gasit:

Cod: Selectaţi tot

{
		if ( $row = $db->sql_fetchrow($result) )
		{
			if ( !$row['user_active'] )
			{
				message_die(GENERAL_MESSAGE, $lang['No_send_account_inactive']);
			}

			 $username = $row['username'];
			 $user_id = $row['user_id'];

Apoi:

Cod: Selectaţi tot

#
#-----[ AFTER, ADD ]------------------------------------------
#
			if ( $ctracker_config->settings['pw_reset_feature'] == 1 )
			{
				if ( $row['ct_last_pw_reset'] >= time() )
				{
					message_die(GENERAL_MESSAGE, sprintf($lang['ctracker_pwreset_info'], $ctracker_config->settings['pwreset_time']));
				}
			}

de unde sa continue codul?

$user_id = $row['user_id'];<----- de aici?

sau inainte de ";"

$user_id = $row['user_id']<----- ;

EDIT 2:

Cod: Selectaţi tot

Could not delete stale anti bot question data

DEBUG MODE

SQL Error : 1146 Table 'uage_srv_ro.ANTI_BOT_QUEST_CONFIRM_TABLE' doesn't exist

DELETE FROM ANTI_BOT_QUEST_CONFIRM_TABLE WHERE start_time < 1175881045 AND session_id <> 'dc0545b7751bb4346a9d760b0c894982'

Line : 65
File : functions_abq.php

Eroarea asta o primesc cand vreau sa raspund la un topic sau sa creez alt topic...mentionez ca am sters si tabele din baza de date...

Ce sa-i mai fac?

EDIT 3:

Acum nu mai da nicio eroare....nu mai zice nimic...e backgroundul...deci mai varza...

Mai e careva pe aici?

Mesaj de **flowers** » 07-Apr-2007, 01:41:56

Pui codul dupa

Cod: Selectaţi tot

$user_id = $row['user_id'];

Cod: Selectaţi tot

Could not delete stale anti bot question data

DEBUG MODE

SQL Error : 1146 Table 'uage_srv_ro.ANTI_BOT_QUEST_CONFIRM_TABLE' doesn't exist

DELETE FROM ANTI_BOT_QUEST_CONFIRM_TABLE WHERE start_time < 1175881045 AND session_id <> 'dc0545b7751bb4346a9d760b0c894982'

Line : 65
File : functions_abq.php

Nu ai facut bine modificarile in fisiere.

Aliniuz · Mesaj de **Aliniuz** » 07-Apr-2007, 13:49:50

Nu ai executat comenzile SQL .

damax · Mesaj de **damax** » 07-Apr-2007, 14:17:19

Oke...ce e de facut...eu am sters tabelele din baza de date si toate fisierele upload-ate...
Forumul e tot in starea descrisa mai sus, respectiv imposibilitatea de a raspunde la un topic sau de acrea topicuri noi..

phpBB România • forumul phpBB in limba romana. Opinii, implementari, ajutor, instructiuni si download.

abq problem...

abq problem...

Cine este conectat