[Andii S.]

ich habe auch gleich einen hinweis in meinem footer eingebaut

[BroatcasT]

So dann sind auch schon mal die nächsten 2 Features fertig geworden...
(Ansicht im ersten und 2ten Post)

[BroatcasT]

Ab sofort stehen die Beta realeses zum Download bereit.
(Erhältlich im ersten und 1ten Post)

Bitte seit so freundlich und hinterlast als Beta Tester eine Nachricht

[problemkind]

hochgeladen und folgendes bekommen, sobald ich bei Einstellungen auf Cracker Tracker gehe....

Code:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1146 - Table 'mybb_ctracker_config' doesn't exist
Query:
    SELECT ct_config_value FROM mybb_ctracker_config WHERE `ct_config_name` = 'last_checksum_scan'

[Andii S.]

um die beta zu installieren, müssen die querrys von hand ausgeführt werden.

Code:

CREATE TABLE `mybb_ctracker_config` (
  `ct_config_name` varchar(255) NOT NULL,
  `ct_config_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`ct_config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('ipblock_enabled','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('ipblock_logsize','100');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('auto_recovery','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('vconfirm_guest','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('autoban_mails','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('detect_misconfiguration','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('search_time_guest','30');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('search_time_user','20');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('search_count_guest','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('search_count_user','4');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('massmail_protection','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('reg_protection','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('reg_blocktime','30');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('reg_lastip','0.0.0.0');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pwreset_time','20');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('massmail_time','20');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('spammer_time','30');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('spammer_postcount','4');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('spammer_blockmode','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('loginfeature','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_reset_feature','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('reg_last_reg','1155944976');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('login_history','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('login_history_count','10');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('login_ip_check','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_validity','30');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_complex_min','4');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_complex_mode','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_control','0');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('pw_complex','0');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('last_file_scan','0');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('last_checksum_scan','1247842058');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('logsize_logins','100');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('logsize_spammer','100');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('reg_ip_scan','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('global_message','Hello world!');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('global_message_type','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('logincount','2');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('search_feature_enabled','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('spam_attack_boost','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('spam_keyword_det','1');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('footer_layout','3');
INSERT INTO mybb_ctracker_config (ct_config_name,ct_config_value) VALUES ('last_backup','0');

Code:

CREATE TABLE `mybb_ctracker_filescanner` (
  `id` smallint(5) NOT NULL,
  `filepath` text,
  `safety` smallint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Code:

CREATE TABLE `mybb_ctracker_filechk` (
  `filepath` text,
  `hash` varchar(32) default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Code:

CREATE TABLE `mybb_ctracker_ipblocker` (
  `id` mediumint(8) unsigned NOT NULL,
  `ct_blocker_value` varchar(250) default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('1','*WebStripper*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('2','*NetMechanic*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('3','*CherryPicker*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('4','*EmailCollector*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('5','*EmailSiphon*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('6','*WebBandit*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('7','*EmailWolf*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('8','*ExtractorPro*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('9','*SiteSnagger*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('10','*CheeseBot*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('11','*ia_archiver*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('12','*Website Quester*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('13','*WebZip*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('14','*moget*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('15','*WebSauger*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('16','*WebCopier*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('17','*WWW-Collector*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('18','*InfoNaviRobot*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('19','*Harvest*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('20','*Bullseye*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('21','*LinkWalker*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('22','*LinkextractorPro*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('23','*WebProxy*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('24','*BlowFish*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('25','*WebEnhancer*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('26','*TightTwatBot*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('27','*LinkScan*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('28','*WebDownloader*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('29','lwp');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('30','*BruteForce*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('31','lwp-*');
INSERT INTO mybb_ctracker_ipblocker (id,ct_blocker_value) VALUES ('32','*anonym*');

Code:

CREATE TABLE `mybb_ctracker_loginhistory` (
  `ct_user_id` int(10) default NULL,
  `ct_login_ip` varchar(16) default '',
  `ct_login_time` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ich hoffe dir damit weiterhelfen zu können,... und immer drann denken datenbank backupen vor irgendwelchen änderungen

[problemkind]

Dann muss ich eigentlich nur... mybb_ ändern Denn das sollte ja auch nicht Orginal sein, habe hier nur die Ziffern ersetzt :=)

Vielen Dank, ich werde es später wenn ich Zeit habe ausprobieren

[BroatcasT]

So hab den Donwload mal geupdated ... der SQL Dump ist jetzt enthalten

[problemkind]

Klappt soweit, aber kann sein das das zutrifft....

Andere Server brechen den Vorgang ab, da er recht performanceintensiv ist.

Bei mir fängt er erst garnicht an, wenn ich auf "Erstelle oder aktualisiere Prüfsummen" klicke.
kann das sein das ich ein paar CMOD Rechte bei meinen FTP Programm verteilen muss ?
Standard ist 644, daran habe ich nichts geändert bei den Ctracker Dateien.

[BroatcasT]

Zu den chmods kann ich dir momentan leider noch nichts sagen, ich entwickel das script local auf meiner Windoof Kiste, wenn dann ein Betatester auf nem Lin System läuft kann er mir gern einmal berichten welche chmods benötigt werden.

Edit
Teste einfach mal die ctracker.php auf 777 zu setzen wenns dann noch nicht geht die functions_ctracker.php auch noch, dort werden zumindest ftp direktive aufgerufen wodurch die Prüfsummen erstellt werden sollen...

[Andii S.]

chmod ist bei mir überall auf 644, prüfsummen erstellen und prüfen klappt auch.