[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.
Post Reply
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

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

Post by Darlantan »

This is a Log mod that I originally made for personal use.
As of "version" 0.4.1 it is now capable of logging not only visitors, but also actions performed in your forums (Can be turned off). "Easily" extendable to log new actions from a central schema php-file.

[Current status - version 0.4.2]:
since the release of phpBB3 and me being swamped with work, I'm making my latest development-version available for download: http://www.codecrush.com/repository/d_i ... alpha1.zip
When I get the time I'll port/rewrite it for phpBB3. Due to server hardware issues, my forum is currently down, as well as screenshots.


[Current status - version 0.4.1]:
- I've got 0.4.1 installed and running on 3 different sites/servers
- possible overhead, needs feedback
- Dead-easy to install. Only 2 files to edit and 6 lines of code to add. Comes with an "installer" for the database tables, or a sql-schema file if you prefer (includes/logs_schema.sql)
- I'm busier than ever, but will try my best to respond to bugs in this thread or at my forums

Download version 0.4.1 - CodeCrush Log System

Screenshots v. 0.4.1
ImageImageImageImage
ImageImageImageImage
ImageImage

[Older versions (CC IP Log)]:
Status of 0.3.2:
- deprecated as work continues on 0.4.x (CodeCrush Log System)
- quite stable, little overhead
- 1 bug as mentioned here: XSS Problem in CC IP Log

Preview image(s) version 0.3.1:
ImageImageImage

Install procedure:
- Copy the files in place
- browse to the logs_install.php, read it (for more details) and click the button(s)
- Read logs_install.txt and make the necessary manual edits
- Delete logs_install.txt and logs_install.php from your web space

Upgraders!
There is no upgrade from 0.3.x to 0.4.1! This is due to major database table changes. Moving data from the old tablestructure to the new would likely require server-tools/scripts. I've provided a modified admin-page to view the old logs. (The logs_install.php page should invisibly drop the old tables, except the cc_ip_log table)
Please backtrace whatever steps you made when installing 0.3.x (- download link still provided for 0.3.2)

Known issues:
- 2 bugs 0.4.1: sorting/pagination and Excludes. Possible fix on page 50.
- some people get logged multiple times, disregarding the log-session-duration setting. Any help to figure this one out would be appreciated. Might not be an issue with this mod, but could be browser/phpBB-related. My tests so far indicate this being a browser/proxy/user-connection issue.


Changed in 0.4.1
- large rewrite
- XSS bug fixed
- IP-Country flags
- Action logging (ACP, "moderations", errors..)
- Backups, Statistics and CSV-exports have been stripped (for now)
- Even simpler installation
- Name Change! CodeCrush IP Log -> CodeCrush Log System (to reflect changes)
- Log Config access configurable

Changed in 0.3.2
- some bug-fixes
- now logs cookie-info regarding other users from same computer
- provided simple addon for logging of failed login attempts/banned users
- file export/backup now exports/imports complete dataset
- Exclusion now works
- Session-based timer to control how often someone is logged (in addition to the cookie-one)

Changed in 0.3.1
- log-procedure rewritten, now called as a function.
UPGRADERS: you must make changes to sessions.php - see ccip_install.txt
- logs users upon registration
- Select user- and ip-popup for the view-log page filter fields
- enhanced log-exclusion - now using regexps and can exclude by browser-string (old exclusion table gets wiped)
- fixed a couple bugs
- Cookie-based flagging of multiple users from same computer
- Cookie-based timer to control how often someone is logged
- Semi-automatic log-pruning

Changed in 0.3.0:
- much better proxy logging
- rewrote large parts of the code
- logs referral info
- slightly better simple-statistics (might still be abit buggy though)
- phpBB ban integration
- logs ACP logins (filterable viewage)
- improved pagination feat

Changed in 0.2.9:
- also logs proxy IPs (thanks to richard_5421 for suggesting it)

Changed in 0.2.8:
- bug fixes mostly related to php global variables
- new feature to exclude username<->IP combinations from getting logged

Changed in 0.2.7:
- bug fixes related to PHP/SQL versions
- some more config options
- new tool to backup log to files on your server
- new delete options
- new logic to prevent "double instances" of log-entries
Last edited by Darlantan on Fri Dec 21, 2007 12:58 pm, edited 24 times in total.
totoelectro
Registered User
Posts: 358
Joined: Tue Dec 11, 2001 8:47 am
Location: Nimes (South of France)
Contact:

Post by totoelectro »

Work fine in my board !! thank's :wink: Darlantan :D
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Post by Darlantan »

hehe,
glad someone like it :)

I've been asked by the users on one of the sites I develop,
to add 1 or 2 more features to it.

I'll update here if that happens :)
Bear_nG
Registered User
Posts: 125
Joined: Fri Apr 05, 2002 9:22 am
Location: Brisbane, Australia
Contact:

Post by Bear_nG »

EXCELLENT

Thanks!
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

ooooh, nice! I like it to! Good job

Feature Requests would be:
* turning logging on/off
* download or even better export function to a csv-file (for importing in excel and such programms.)

edit:

* and how about including the referrer ?

:D
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Post by Darlantan »

thanx for the feedback gang :)

excellent requests too.

turning logging on/off would
require another table in the database.
(or adding a row to phpbb_config)
I don't like messing up the original
phpbb-tables though ;)

Exporting to csv.. cool idea.
I'll definately look into this one.

Including referrer. I actually tried that
at first, but referrer isn't set on my server.
*eye roll* Well for some reason it caused
the forum to hang. Maybe I'll take another
look though :)
User avatar
morpheus2matrix
Former Team Member
Posts: 9171
Joined: Wed Apr 10, 2002 7:31 pm
Location: France
Contact:

Post by morpheus2matrix »

i have a question : where is store the log file ??

And, how big can it be (e.g : what is the size of the log file for a forum which have 100 members for example )??

Bye
Former phpBB MOD-Team Member -

Forgive my bad English :(

No support by PM/Email - Thanks - You can thanks me here :) - Pay me for installing MOD's :lol:
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

It is stored in the database, not a file.

It does not depend on the size of your forum, but on how busy it gets. Not every access, but every visit is getting an entry.

On size I cannot say anything right now, becauser it has only been running for a short time (75 entries, 8kb according to phpmyadmin).
User avatar
morpheus2matrix
Former Team Member
Posts: 9171
Joined: Wed Apr 10, 2002 7:31 pm
Location: France
Contact:

Post by morpheus2matrix »

ok thx
Former phpBB MOD-Team Member -

Forgive my bad English :(

No support by PM/Email - Thanks - You can thanks me here :) - Pay me for installing MOD's :lol:
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Post by Darlantan »

Thanx for the help Serious :)

I'm releasing a new version of this IP_Log_Mod now.
It's got quite a bit more code, so let me know if you
find any bugs.

Download:
http://www.codecrush.com/repository/cc_ip_mod2.zip

Screenshot (144k):
http://www.codecrush.com/repository/screen_ip_mod2.jpg
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

Excellent, I like! :)

Works like a charm.

Now that you you actually messed with the config table...you could make an option for turning on/off :rolleyes: :D ;) *SCNR*

BTW: You got mail.
DorG
Registered User
Posts: 412
Joined: Thu Mar 21, 2002 6:40 am

he

Post by DorG »

Kewl mod, now i can get a look who visited my site and maybe did soemthing wrong, can you alsoo make something that gives a page with all urls someone has typed to access forbidden things on your site, keeps trying to get something important, sounds weird, example:

A user tries this url www.yoursite.com/forum/phpmyadmin He tries to get in my sql but ofcourse it ain't located there, so he get error page, can I put those not found site in a list so I know who tried to hack me ;-)
---
- <
---
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

If you want to see (tried) accessed pages you are probably looking for another mod: [RELEASE] Enhanced IP Logger.
The one here is only logging the visits. So if a user surfs on your page for 30 min. he will still be shown only one time in the logs.

But even with the other mod (which is tracking every page-access) something like you described would not work, because phpmyadmin is not part of phpBB. Since this is a mod to phpBB it does not work across your site, but only on pages that are part of phpBB /or better pages that call the sessions.php[this mod] or the pageheader ).
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Post by Darlantan »

lol
ya Serious, I completely forgot about the on/off-bit.

and yea, the other guy's mod tracks users through
every (phpBB) page. That wasn't exactly what I
needed for my site, so I created this one.

DorG: there is a way to track visitors and see what
pages they access. Atleast if you're running Apache.
/var/log/apache/access.log

It might be an idea for the future to implement a
feature that checks users against accessed pages
etc. But right now I have to work on finishing a
school project. ;)

Besides, I should possibly give the phpBB people
time to review version 1 & 2 before I bug them
with a version 3. hehe :)
Darlantan
Registered User
Posts: 369
Joined: Wed Mar 13, 2002 1:37 pm

Post by Darlantan »

I found a small bug in admin_ip_log.php

If you selected to show 2 or more IPs only,
the SQL-call would fail.
This is now fixxed:
http://www.codecrush.com/repository/cc_ip_mod2.zip

If you've already installed this mod, then you only need to copy
the new admin_ip_log.php from the zip-file to correct the error.

:)
Post Reply

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