[BETA] CodeCrush Log System (v.0.4.2alpha) (Dec-07)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
corduroy73
Registered User
Posts: 1
Joined: Fri Oct 12, 2007 4:48 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by corduroy73 »

Hello, the link to download this mod seems to have an error. Anyone else?
quibuz
Registered User
Posts: 34
Joined: Tue Jun 20, 2006 7:53 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by quibuz »

corduroy73 wrote:Hello, the link to download this mod seems to have an error. Anyone else?
I hope Criss will fix his site soon and i can't wait to see more of this mod. :D
just as long as his site is down here is a mirror.
MakePB
Registered User
Posts: 67
Joined: Sat May 21, 2005 3:21 pm
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by MakePB »

linnysue wrote:Sorry if this is a repeat question. I searched this thread and nothing similar came up for the csv file question.
I installed v.0.4.1 of the CodeCrush MOD the other day. Everything seemed to go well and all seems to work, except I get this error message:

**** CodeCrush DB Interface ****
File /var/www/phpBB2/ip-to-country.csv does not exist!


I uploaded the ip-to-country.csv file, but it's not recognized. I set permissions to 777. The file is saved as: UTF-8
Line break type: convert to Windows style

The path is httpdocs/forum/ip-to-country.csv

I checked with my server host and there are no restrictions on csv files or file limitations.
I'm a newbie at installing MODS so I don't understand database edits at all. I did click on install buttons in the logs_install.php browser page. Said all was ok on all files.

Not sure where to go from here. Help!

P.S. - I just discovered that in the "page" feature, I am only able to use the probe feature, not any of the javascript links.
If your site is on shared hosting It should be something like

Code: Select all

/home/yourloginame/public_html/yourforum/ip-to-country.csv
By yourloginname check what is your ftp login name and by yourforum check what is name of directory of your forum and then replace it. If your forum is installed into root directory then it will be without yourforum.Thus

Code: Select all

/home/yourloginame/public_html/ip-to-country.csv
If login of your web site is for example linnysue and your forum is installed into root then right path will be

Code: Select all

/home/linnysue/public_html/ip-to-country.csv
If you use phpBB2 directory then it will be

Code: Select all

/home/linnysue/public_html/phpBB2/ip-to-country.csv
Of course you need to upload ip-to-country.csv file into right directory!

Hope this help!
User avatar
ScriptingBase
Registered User
Posts: 6
Joined: Wed Oct 17, 2007 7:31 pm
Location: Heidelberg (Germany)

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by ScriptingBase »

This mod looks relly interesting. When I have enough time, I'll test it. ;)
Greetings ;)

Sorry for my terrible English :oops:
REAgentForeclosures
Registered User
Posts: 50
Joined: Tue May 01, 2007 9:14 pm
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by REAgentForeclosures »

Any idea on when the screenshots for v0.4.1 might be back up?
- reCAPTCHA MOD - Replace phpBB's CAPTCHA with the much better reCAPTCHA
- reCAPTCHA Guest Post MOD - Adds reCAPTCHA to guest posts, eliminating spam

SPAM Registrations and/or Posts since installation of the above mods: 0
How secure is reCAPTCHA? VERY ;)
reCAPTCHA = "Digitizing Books One Word at a Time"
linnysue
Registered User
Posts: 48
Joined: Fri Sep 21, 2007 3:16 am
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by linnysue »

This is the error message I get when I click on the "Visits Log." It used to work. Now the visits log is useless.
Could not prune entries

DEBUG MODE

SQL Error : 1016 Can't open file: 'morgellonssanctum_ip_log1.MYI' (errno: 145)

DELETE FROM morgellonssanctum_ip_log1 WHERE logged < 20070905000000

Line : 180
File : admin_logs_system.php
MakePB
Registered User
Posts: 67
Joined: Sat May 21, 2005 3:21 pm
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by MakePB »

linnysue wrote:This is the error message I get when I click on the "Visits Log." It used to work. Now the visits log is useless.
Could not prune entries

DEBUG MODE

SQL Error : 1016 Can't open file: 'morgellonssanctum_ip_log1.MYI' (errno: 145)

DELETE FROM morgellonssanctum_ip_log1 WHERE logged < 20070905000000

Line : 180
File : admin_logs_system.php
Please see exactly same error and the way how i solved it a couple pages a go (page 49):

http://www.phpbb.com/community/viewtopi ... &start=720

I hope that it will help you to solve your problem.

Apart most common from SQL Error : 1016 issue i would like to know author that i got a lot trouble a couple months a go when i tried to move my board to another hosting.
Going through phpMyAdmin and tried to save my databases but for some strange reason they were not completely saved. I tried at least 5 times to save it and always got incomplete copy of databases.
After starting investigation trough opening saved database into editor i saw that each time error was caused by CodeCrush Log System logs. Strange!
FInally i must delete all logs from CodeCrush to be able to complete task.

CodeCrush is great but you must know that mod seems to be still buggy and sometime very annoying. Hopefully all issues will be fixed by next release.
linnysue
Registered User
Posts: 48
Joined: Fri Sep 21, 2007 3:16 am
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by linnysue »

I think I'd like to just remove this MOD altogether. How do I remove it from the database? I haven't ever gone into my database and afraid to do so.
paul-collins
Registered User
Posts: 38
Joined: Tue Mar 01, 2005 2:17 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by paul-collins »

Sorry if this has been answered, but at 52 pages you can't really find stuff in this thread.

I've installed the log system on an MS SQL Server 2000 db, and can't get it to show me any data. I don't know if it's because the phpBB isn't actually putting data into the table or if it can't pull it back out. I don't have direct access to the table...

I had to modify the schema file a bit, because
(a) SQL Server doesn't like unsigned (so I deleted any ref to unsigned)
(b) SQL Server doesn't like column widths defined for the various *int variables (so I deleted the (#) portions)
(c) SQL Server doesn't like mediumint (so I changed them to int )
(d) SQL Server doesn't like not null auto_increment (so I changed them to identity)

Once I made those changes, the logs_install.php worked fine. The config population bit of the schema worked fine, too...

Any thoughts? Have I created useable tables, and does the switch to identity from not null auto_increment caused difficulties with the php files?
paul-collins
Registered User
Posts: 38
Joined: Tue Mar 01, 2005 2:17 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by paul-collins »

I've found out that the tables are not populating... Any hints?
paul-collins
Registered User
Posts: 38
Joined: Tue Mar 01, 2005 2:17 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by paul-collins »

Fixed it myself, thank you very much.

First, found the sql translator here:

http://sql.phpmix.com/

translated the logs_schema.sql from MySQL to MS-SQL (you have to separate out the primary key command from the column definition), dropped the old tables, and re-ran logs_install.php and got it working.

For the record, here's the MS SQL version of logs_schema.sql.

Code: Select all

CREATE TABLE phpbb_ip_config (
    config_name VARCHAR(255) NOT NULL DEFAULT (''),
    config_value VARCHAR(255) NOT NULL DEFAULT (''),
    config_type CHAR(1) NULL,
    config_desc VARCHAR(255) NOT NULL DEFAULT (''),
    CONSTRAINT phpbb_ip_config_pk PRIMARY KEY (config_name) ON [PRIMARY]
)  ON [PRIMARY];

CREATE TABLE phpbb_ip_exc (
    exc_id INTEGER NOT NULL IDENTITY(1, 1),
    username VARCHAR(128) NOT NULL DEFAULT (''),
    browser VARCHAR(128) NOT NULL DEFAULT (''),
    ip VARCHAR(128) NOT NULL DEFAULT (''),
    log_code VARCHAR(32) NOT NULL DEFAULT (''),
    CONSTRAINT phpbb_ip_exc_pk PRIMARY KEY (exc_id) ON [PRIMARY],
    CHECK (exc_id>=0)
)  ON [PRIMARY];

CREATE TABLE phpbb_ip_country (
    ip1 BIGINT NOT NULL DEFAULT (0),
    ip2 BIGINT NOT NULL DEFAULT (0),
    iso2 CHAR(2) NOT NULL DEFAULT (''),
    iso3 CHAR(3) NOT NULL DEFAULT (''),
    country VARCHAR(255) NOT NULL DEFAULT ('')
)  ON [PRIMARY];

CREATE TABLE phpbb_ip_sessions (
    md5_sum CHAR(32) NOT NULL DEFAULT (''),
    session_start BIGINT NULL,
    CONSTRAINT phpbb_ip_sessions_pk PRIMARY KEY (md5_sum) ON [PRIMARY]
)  ON [PRIMARY];

CREATE TABLE phpbb_ip_log1 (
    log_id INTEGER NOT NULL IDENTITY(1, 1),
    logged BIGINT NOT NULL DEFAULT (0),
    username VARCHAR(25) NULL,
    user_id INTEGER NULL,
    user_ip VARCHAR(40) NULL,
    user_sid CHAR(32) NULL,
    ip_resolved VARCHAR(255) NULL,
    ip_domain VARCHAR(255) NULL,
    ip_country VARCHAR(3) NULL,
    env_agent VARCHAR(255) NULL,
    env_x_forwarded_for VARCHAR(255) NULL,
    env_remote_ip VARCHAR(24) NULL,
    env_via VARCHAR(255) NULL,
    env_proxy_connection VARCHAR(255) NULL,
    env_referer VARCHAR(255) NULL,
    req_method VARCHAR(1) NULL,
    page_name VARCHAR(32) NULL,
    page_dir VARCHAR(64) NULL,
    page_query_str VARCHAR(255) NULL,
    generic_id1 INTEGER NULL DEFAULT (0),
    generic_id2 INTEGER NULL DEFAULT (0),
    log_code VARCHAR(32) NULL,
    error_code SMALLINT NULL DEFAULT (0),
    error_log INTEGER NULL DEFAULT (0),
    log_msg TEXT NULL,
    log_data TEXT NULL,
    CONSTRAINT phpbb_ip_log1_pk PRIMARY KEY (log_id) ON [PRIMARY],
    CHECK (log_id>=0),
    CHECK (logged>=0),
    CHECK (error_log>=0)
)  ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

CREATE TABLE phpbb_ip_log2 (
    log_id INTEGER NOT NULL IDENTITY(1, 1),
    logged BIGINT NOT NULL DEFAULT (0),
    username VARCHAR(25) NULL,
    user_id INTEGER NULL,
    user_ip VARCHAR(40) NULL,
    user_sid CHAR(32) NULL,
    ip_resolved VARCHAR(255) NULL,
    ip_domain VARCHAR(255) NULL,
    ip_country VARCHAR(3) NULL,
    env_agent VARCHAR(255) NULL,
    env_x_forwarded_for VARCHAR(255) NULL,
    env_remote_ip VARCHAR(24) NULL,
    env_via VARCHAR(255) NULL,
    env_proxy_connection VARCHAR(255) NULL,
    env_referer VARCHAR(255) NULL,
    req_method VARCHAR(1) NULL,
    page_name VARCHAR(32) NULL,
    page_dir VARCHAR(64) NULL,
    page_query_str VARCHAR(255) NULL,
    generic_id1 INTEGER NULL DEFAULT (0),
    generic_id2 INTEGER NULL DEFAULT (0),
    log_code VARCHAR(32) NULL,
    log_msg TEXT NULL,
    log_data TEXT NULL,
    CONSTRAINT phpbb_ip_log2_pk PRIMARY KEY (log_id) ON [PRIMARY],
    CHECK (log_id>=0),
    CHECK (logged>=0)
)  ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

CREATE TABLE phpbb_ip_log3 (
    log_id INTEGER NOT NULL IDENTITY(1, 1),
    logged BIGINT NOT NULL DEFAULT (0),
    username VARCHAR(25) NULL,
    user_id INTEGER NULL,
    user_ip VARCHAR(40) NULL,
    user_sid CHAR(32) NULL,
    ip_resolved VARCHAR(255) NULL,
    ip_domain VARCHAR(255) NULL,
    ip_country VARCHAR(3) NULL,
    env_agent VARCHAR(255) NULL,
    env_x_forwarded_for VARCHAR(255) NULL,
    env_remote_ip VARCHAR(24) NULL,
    env_via VARCHAR(255) NULL,
    env_proxy_connection VARCHAR(255) NULL,
    env_referer VARCHAR(255) NULL,
    req_method VARCHAR(1) NULL,
    page_name VARCHAR(32) NULL,
    page_dir VARCHAR(64) NULL,
    page_query_str VARCHAR(255) NULL,
    generic_id1 INTEGER NULL DEFAULT (0),
    generic_id2 INTEGER NULL DEFAULT (0),
    log_code VARCHAR(32) NULL,
    log_msg TEXT NULL,
    log_data TEXT NULL,
    CONSTRAINT phpbb_ip_log3_pk PRIMARY KEY (log_id) ON [PRIMARY],
    CHECK (log_id>=0),
    CHECK (logged>=0)
)  ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

CREATE TABLE phpbb_ip_log4 (
    log_id INTEGER NOT NULL IDENTITY(1, 1),
    logged BIGINT NOT NULL DEFAULT (0),
    username VARCHAR(25) NULL,
    user_id INTEGER NULL,
    user_ip VARCHAR(40) NULL,
    user_sid CHAR(32) NULL,
    ip_resolved VARCHAR(255) NULL,
    ip_domain VARCHAR(255) NULL,
    ip_country VARCHAR(3) NULL,
    env_agent VARCHAR(255) NULL,
    env_x_forwarded_for VARCHAR(255) NULL,
    env_remote_ip VARCHAR(24) NULL,
    env_via VARCHAR(255) NULL,
    env_proxy_connection VARCHAR(255) NULL,
    env_referer VARCHAR(255) NULL,
    req_method VARCHAR(1) NULL,
    page_name VARCHAR(32) NULL,
    page_dir VARCHAR(64) NULL,
    page_query_str VARCHAR(255) NULL,
    generic_id1 INTEGER NULL DEFAULT (0),
    generic_id2 INTEGER NULL DEFAULT (0),
    log_code VARCHAR(32) NULL,
    error_code SMALLINT NULL DEFAULT (0),
    error_log INTEGER NULL DEFAULT (0),
    log_msg TEXT NULL,
    log_data TEXT NULL,
    CONSTRAINT phpbb_ip_log4_pk PRIMARY KEY (log_id) ON [PRIMARY],
    CHECK (log_id>=0),
    CHECK (logged>=0),
    CHECK (error_log>=0)
)  ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

CREATE TABLE phpbb_ip_log5 (
    log_id INTEGER NOT NULL IDENTITY(1, 1),
    logged BIGINT NOT NULL DEFAULT (0),
    username VARCHAR(25) NULL,
    user_id INTEGER NULL,
    user_ip VARCHAR(40) NULL,
    user_sid CHAR(32) NULL,
    ip_resolved VARCHAR(255) NULL,
    ip_domain VARCHAR(255) NULL,
    ip_country VARCHAR(3) NULL,
    env_agent VARCHAR(255) NULL,
    env_x_forwarded_for VARCHAR(255) NULL,
    env_remote_ip VARCHAR(24) NULL,
    env_via VARCHAR(255) NULL,
    env_proxy_connection VARCHAR(255) NULL,
    env_referer VARCHAR(255) NULL,
    req_method VARCHAR(1) NULL,
    page_name VARCHAR(32) NULL,
    page_dir VARCHAR(64) NULL,
    page_query_str VARCHAR(255) NULL,
    generic_id1 INTEGER NULL DEFAULT (0),
    generic_id2 INTEGER NULL DEFAULT (0),
    log_code VARCHAR(32) NULL,
    error_code SMALLINT NULL DEFAULT (0),
    error_log INTEGER NULL DEFAULT (0),
    log_msg TEXT NULL,
    log_data TEXT NULL,
    CONSTRAINT phpbb_ip_log5_pk PRIMARY KEY (log_id) ON [PRIMARY],
    CHECK (log_id>=0),
    CHECK (logged>=0),
    CHECK (error_log>=0)
)  ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

# Config options - originally in phpbb_config - moved to log_config!
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('major_version','0','Log Major Version','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('minor_version','4','Log Minor Version','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('revision','1','Log Revision','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_filepath','/var/www/phpBB2/ip-to-country.csv','Country csv-file (path)','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_delim',',','Country csv delimiter','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('csv_fields','ip1,ip2,iso2,iso3,country','Country csv fields','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('countries_updated','0','Last Update (Country db)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('ip_lookup_url','http://samspade.org/whois/','URL used to lookup IPs (ex: http://samspade.org/whois/)','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_bbsession','1','Use experimental phpBB session check','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_time','3600','Visit-Log session duration in seconds','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('log_dateformat','Y M d H:i','Log timestamps Format','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('per_page','50','Number of log entries listed per page','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('auto_prune','1','Automatic pruning of logs when viewed','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('auto_prune_age','60','Pruning threshold in days','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_proxy_url','http://codecrush.com/prox.php','Proxy Probe URL','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_proxy_ports','80,2301,3128,6588,8000,8080','List of Proxy Ports to probe','s');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('use_gethostbyaddr','0','Calling gethostbyaddr() can be very slow','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_anon','1','Log Anonymous Users','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_visits','1','Log Visits On/Off (1/0)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_actions','1','Log Actions On/Off (1/0)','i');
insert into phpbb_ip_config(config_name,config_value,config_desc,config_type) VALUES('cc_log_admins','','Comma delimited list of user_ids allowed to Configure/Delete logs (Anyone if empty)','s');
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by Darlantan »

Glad you got it working paul. MSSQL is not my strong point.

I'm too swamped with other projects right now to make any progress on this mod, but not abandoning it.
One of the projects I currently work on will need something like this at a later stage, which probably means I'll take the time to port/rewrite it for phpBB3.

I will likely not make any additions to this mod for phpBB2, so I've packed up what is my last development-version: http://www.codecrush.com/repository/d_i ... alpha1.zip

It hasn't really been tested much, but varies little in regards to the installation procedure compared to 0.4.1,
so I'm guessing it should work fine. It should have several speed improvements over 0.4.1 and an attempt at fixing the country-flags installation problem.
deny
Registered User
Posts: 565
Joined: Wed May 14, 2003 9:14 am
Contact:

Re: [BETA] CodeCrush Log System (v.0.4.2alpha) (Dec-07)

Post by deny »

What is difference between 0.4.1 and 0.4.2 alpha?
Is it worth to upgrade or they are only minor changes?
I do not see any explanations what is new comparing to version 0.4.1 and i do not see how to upgrade from version 0.4.1 to version 0.4.2!?
Every device on the Internet has its own IP address. Find Location of any IP with IPAddressLocation.org because everything can be located and traced.
RedTrinity
Registered User
Posts: 1327
Joined: Sat May 06, 2006 3:32 am

Re: [BETA] CodeCrush Log System (v.0.4.1) (updated 20th-Nov-06)

Post by RedTrinity »

Darlantan wrote: One of the projects I currently work on will need something like this at a later stage, which probably means I'll take the time to port/rewrite it for phpBB3.
Yay, very happy to hear that! It has been in demand for a few months now for PHPBB3.
cavallino
Registered User
Posts: 317
Joined: Thu Aug 04, 2005 7:06 am

Re: [BETA] CodeCrush Log System (v.0.4.2alpha) (Dec-07)

Post by cavallino »

I had installed 0.4.1 and to install this I deleted all the previous sql entries and files and installed this as new.
Anyway, with this 0.4.2 i dont see anymore the country flags in the logs and also all the tables are messed up and the cells are too little, i cannot even read properly the entries... (the fonts are half cutted by cells size)

so despite solving the csv flags import (which now works correctly) this version, at least for me, is a little step backward.
Post Reply

Return to “[2.0.x] MODs in Development”