Obsah fóra » Software » Programovanie a tvorba webu » Redakčné systémy » ochrana fora pred spamami a "spamovymi uzivatelmi"

ochrana fora pred spamami a "spamovymi uzivatelmi"

Stránka: 1 z 1

[ Príspevkov: 5 ]

Autor

Správa

kpr

Užívateľ

Registrovaný: 11.06.05
Príspevky: 17
Témy: 5 | 5

Napísal

kpr: 22.05.2007 12:33 | ochrana fora pred spamami a "spamovymi uzivatelmi"

V mojom fore sa zacalo objavovat viac spamov nez prispevkov, a tiez bolo vela zaregistrovanych spamovych uzivatelov (neexistujuci uzivatelia). Pouzil som tento mode
http://www.phpbbhacks.com/download/6697
kt. som videl, ze s uspechom pouzivaju na inom fore.

Aj ked som postupoval podla navodu vypisuje to

Fatal error: Call to a member function on a non-object in /domains1/lh299700/public/www_root/forum_zmodern,nefunguje/includes/functions.php on line 289

289 riadok je oznaceny [ b ] [ /b ]

Kód:

   // Anti Bot Question Mod - Start
   include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_abq.' . $phpEx);

   $abq_config = array();
   $sql = "SELECT *
      FROM " . ANTI_BOT_QUEST_CONFIG_TABLE;
[b]   if( !($result = $db->sql_query($sql)) )[/b]   {
      message_die(CRITICAL_ERROR, "Could not query anti bot question mod config information", "", __LINE__, __FILE__, $sql);
   }

   while ( $row = $db->sql_fetchrow($result) )
   {
      $abq_config[$row['config_name']] = $row['config_value'];
   }
   // Anti Bot Question Mod - End

Neviete niekto poradit, kde je chyba?

V návode sa ďalej píše

Citácia:

After installation the Anti Bot Question MOD (ABQ) is deactivated.
You must activate ABQ manually after installation. ABQ can be activated
as follow:
ACP > Anti Bot Question MOD > Configuration (Anti Bot Question MOD activate/deaktivate)
You may select if ABQ is activated for registrations and/or guest posting.

ACP = Administration Control Panel

Kde najdem ACP = Administration Control Panel, predpokladam, ze v sekcii ADMIN - ale tam sa momentalne nedostanem kvoli vyssie uvedenemu fatal error.

Diky za pomoc.

Tominator

Užívateľ

Užívateľ

Registrovaný: 21.02.07
Prihlásený: 21.02.10
Príspevky: 3984
Témy: 96 | 96

Napísal

Tominator: 23.05.2007 20:57 | ochrana fora pred spamami a "spamovymi uzivatelmi"

máš to zakorenené v MYSQL databáze; ACP je Administstračný panel tada tam kde vytváraš nové sekcie, meniš skupiny, ... a v bočnom menu

kpr

Užívateľ

Registrovaný: 11.06.05
Príspevky: 17
Témy: 5 | 5

Napísal autor témy Offline

kpr: 23.05.2007 23:31 | ochrana fora pred spamami a "spamovymi uzivatelmi"

Tominator píše:

máš to zakorenené v MYSQL databáze

Podla manualu som nechal vytvorit v phpMyAdmin toto

Citácia:

# EN:
# Run the following SQL statement to update your phpBB database.
# You can use phpMyAdmin or a similar tool to run this update.
#
# IMPORTANT: If you have changed the table prefix from the default of phpBB2,
# °°°°°°°°°° please be sure to replace phpbb with your prefix BEFORE running this update.
#

ale viac sql nerozumiem, takze ak to ma nejaku chybu, neviem to najst. Vies kde moze byt chyba?

Kód:

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

Murtagh

Užívateľ

Užívateľ

Registrovaný: 18.09.07
Prihlásený: 26.07.24
Príspevky: 369
Témy: 66 | 66
Bydlisko: Liesek

Napísal

Murtagh: 13.12.2010 22:56 | ochrana fora pred spamami a "spamovymi uzivatelmi"

kpr píše:

Kód:

   // Anti Bot Question Mod - Start
   include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_abq.' . $phpEx);

   $abq_config = array();
   $sql = "SELECT *
      FROM " . ANTI_BOT_QUEST_CONFIG_TABLE;
[b]   if( !($result = $db->sql_query($sql)) )[/b]   {
      message_die(CRITICAL_ERROR, "Could not query anti bot question mod config information", "", __LINE__, __FILE__, $sql);
   }

   while ( $row = $db->sql_fetchrow($result) )
   {
      $abq_config[$row['config_name']] = $row['config_value'];
   }
   // Anti Bot Question Mod - End

Neviete niekto poradit, kde je chyba?

V návode sa ďalej píše

Citácia:

Kde najdem ACP = Administration Control Panel, predpokladam, ze v sekcii ADMIN - ale tam sa momentalne nedostanem kvoli vyssie uvedenemu fatal error.

Diky za pomoc.

ten fatal error mi vypisuje ties...ako ho mam odstranit??

prohibit

Užívateľ

Užívateľ

Registrovaný: 03.01.11
Prihlásený: 21.02.11
Príspevky: 54
Témy: 1 | 1

Napísal

prohibit: 04.01.2011 12:20 | ochrana fora pred spamami a "spamovymi uzivatelmi"

nechce sa mi pozerat ten mod, ale podla tej chyby to vyzera ze nemate deklarovany objekt $db. Mate na zaciatku tej funkcie global $db?

Stránka: 1 z 1

[ Príspevkov: 5 ]

ochrana fora pred spamami a "spamovymi uzivatelmi"

Obsah fóra » Software » Programovanie a tvorba webu » Redakčné systémy » ochrana fora pred spamami a "spamovymi uzivatelmi"

Témy		Odpovede	Zobrazenia	Posledný príspevok
Podobné témy
	Ochrana fora v Redakčné systémy	4	748	16.11.2006 23:26 JanoF
	ochrana pred rovnakymi obrazkami v PHP, ASP	1	496	09.04.2012 21:59 BX
	ochrana pred sql injection v PHP, ASP	28	1523	12.12.2008 0:49 rooobertek
	Ochrana pred SQL injection v PHP, ASP	16	1594	14.06.2008 17:08 lostwarrior
	ochrana disku pred otrasmi v Operačné systémy Unix a Linux	5	650	03.11.2008 22:17 rooobertek
	ochrana dieťaťa pred nevhodnou stránkou v Sieťové a internetové programy	6	727	17.04.2017 21:54 tairikuokami
	Ochrana CNC stroja pred vírusom v Siete	5	435	13.10.2020 22:57 maiob
	Ochrana pred vírusmi a hrozbami v Antivíry a antispywary	1	755	19.03.2021 17:58 Vinchenzo
	Moje dokumenty - ochrana pred zmenou ich obsahu v Operačné systémy Microsoft	2	411	08.11.2012 10:35 dodos
	Ochrana stranky pred "naklikavacmi" v Ostatné	0	526	28.06.2010 22:53 scrysurn
	Aka ochrana zariadenia (bleskoistka, prep. ochrana) v Siete	2	528	06.10.2012 18:38 peto007
	spam ochrana, sql ochrana v PHP, ASP	14	919	08.01.2011 23:56 Feko
	Rezidentná ochrana vs. rezidentná ochrana v Antivíry a antispywary	6	1207	23.04.2008 22:56 strongy
	Fora v Krčma	19	1951	04.02.2010 0:34 andymc
	Presunutie fora v Redakčné systémy	3	884	04.01.2007 19:09 masterdead
	Prehladnost fora [ Choď na stránku: 1 ... 4, 5, 6 ] v Správy pre vedenie fóra	152	10545	19.11.2005 8:34 Tommy

Podobné témy