LogEye (IP/HWID tracker: ARSSE/BakaAdmin/SoldatServer support)

[SyavX]

Version 0.1.53 (10 May 2011):
+ Added search results export feature (customizable Txt & HTML formats)
+ Added search results sorting feature
~ Fixed search by GUID case sensitivity bug (made insensitive)
~ Fixed few GUI bugs
% Modified minor GUI settings

Note: You can customize both Txt & HTML output formats. Run and close new version of LogEye.exe to see new settings in LogEye.ini file.

As for Baka Admin support... maybe next time.

See first post for the download link...

[SyavX]

Version 0.1.55 (15 Jun 2011):
+ Added "help", "ip <ip>", "guid <guid>", "serv <server>", "date <date>" command line switches
~ Fixed search results sorting bug
% Modified WhoisURL setting (new export format placeholders could be used in addition to the %ip)
% Modified MSAC GUIDs parser (to support both new and old formats)*


* - Due to MSAC server logs format change, LogEye didn't identify GUIDs since 2011-04-21...
It took so long to fix this bug because I didn't even notice that format change by myself and no one informed me about this bug untill today (when I've got a report via email).

So, here is a tip for those who want to update their databases with unidentified GUIDs:
In case you have used QuickUpdate to scan servers with MSAC, you need to change last update date manually, using QuickUpdate settings dialog to make sure all records with new MSAC GUID lines are saved in your databases. I recommend to use date equals or less "2011-04-20", because MSAC server logs format has been changed on 2011-04-21)


As for new command line switches ("ip <ip>", "guid <guid>", "serv <server>", "date <date>"), you can use them with "db <path>" switch to search for specific information in your database on application start.

Code: [Select]

LogEye.exe /db MyDatabase.db /upd /date "2011" /serv "MyServ"

P.S. Btw, I'm wondering why there are still some ppl using 0.1.50 and 0.1.51 versions (as I can see from updater stats)...

See first post for the download link...

[Bonecrusher]

Hey syavx, I downloaded logeye as you suggested on sctfl forums and it does really good job so far:) I was wondering if you could add an option to delete logs older than and then select how many days. That would be good

[SyavX]

Do you mean deleting logs (records) from database or files from log folders?

[Prodigyx]

Do you mean deleting logs (records) from database or files from log folders?

Both.

Add "Optimize" function from IP Tracker app. Very useful option to delete chat text and leaves only important information in the logs files(joining game with nick, IP, GUID).

[KEEN]

ye, the optimize option make the searches more faster

[SyavX]

2KEEN:
The main feature of LogEye is execution of it's own database while searching, but not all log files every time. That's why search takes milliseconds, not minutes.
The time wasted on optimization will be the same as the scanning time (don't forget that you need to scan logs only once), so it will not help you to make things going faster.

But as Prodigyx said, optimization could be added because of other reasons.



Thanks for the feedback, I'll try to add this features in next version(s)...

[KEEN]

ahh its true, u scan it if you need to update the db, i got it

gj dude

[Prodigyx]

Soldat Server 2.7.X log files support?

Update LogEye pls.

[SyavX]

Version 0.1.60 (26 Oct 2011):
+ Added HWID field (based on Hardware Identifiers from SoldatServer 2.7.0 and above)
+ Added "hwid <hwid>" command line switch and "%hwid" export format placeholder
+ Added shortcuts for search fields focusing ([Alt + 1] for IP, [Alt + 2] for HWID, etc.)
% Modified parser to work with Soldat 1.6.0+ (ARSSE/SoldatServer) logs

N.B. Since the LogEye's databases structure has been updated to support HWIDs, you will be asked to confirm file's structure update while openning/updating a database with an old structure (databases from 0.1.46 - 0.1.55 versions). You could find a database backup named as 'YourDatabase.db.bak' in a same folder.

P.S. Sorry for the delay with update...

See first post for the download link...

[SyavX]

Version 0.2.0 (22 Feb 2013):
+ Added 64-bit version
+ Added BakaAdmin logs support
+ Added Drag&Drop support for database open function
+ Added infotips for a toolbar buttons
+ Added keyboard shortcuts for a toolbar buttons
+ Added shortcut [Alt + X] for reseting all search fields
+ Added proper GUI resizing
+ Added restore window position feature
% Modified search results sorting (made it bi-directional)
% Modified log files detection algorithm
~ Fixed search results sorting bug with an empty results list
~ Fixed bug when manually disabled servers were processed incorrectly
~ Fixed bug with behaviour of Uncheck all option in servers list context menu

Note: BakaAdmin should be closed before the logs scan or database update because BA locks it's files so they can't be read by LogEye.

Upd: attachment has been updated because there was a wrong version included into archive...

See first post for the download link...

[Prodigyx]

I made a webpage for search players using LogEye database .db file (SQLite). I'm admin in 5 Soldat Servers and the database has 84 MB of size, so uploading my database to FTP is very slow. I reduced database size from 84 MB to 57 MB with these steps:

1. I removed id and guid fields from table records. id because we dont need this field for search and guid is deprecated. date and time field (TEXT fields) are now joined into a INTEGER fild with Unix time format.

SQLite database do not let us modify table fields, so we must create a new table, rename the old table, copy/convert data from this old table to the new table, delete old table and rename our new table to original name:

ALTER TABLE records RENAME TO records_old;

CREATE TABLE records(ip TEXT NOT NULL,hwid TEXT,name TEXT NOT NULL,datetimeunix INTEGER, UNIQUE(ip, name, datetimeunix) ON CONFLICT IGNORE);

INSERT INTO records (ip,hwid,name,datetimeunix) SELECT ip,hwid,name,strftime("%s", date||" "||time) as datetimeunix FROM records_old;

DROP TABLE records_old;

2. Download sqlite3.exe command line and use the VACUUM command to rebuild the entire database, so the database will be smaller:

sqlite3 database.db "VACUUM;"

I suggest Logeye use this database structure by default to provide smaller database =)

[SyavX]

The TEXT datatype was used for date & time fields for the reasons of convenience and performance with complex wildcards search.

You successfully demonstrated that additional manipulations with LogEye's databases could be done without any problem. With a simple batch file in your case

So, default database structure will not be changed.

[Prodigyx]

The TEXT datatype was used for date & time fields for the reasons of convenience and performance with complex wildcards search.

You successfully demonstrated that additional manipulations with LogEye's databases could be done without any problem. With a simple batch file in your case

So, default database structure will not be changed.

You can perform complex datetime wildcards search with unix date time format field

[Bistoufly]

I get some graphical artifacts around the boxes of the top part of the GUI since version 0.2


Screenshot current version (0.2.0.14)




Screenshot previous version (0.1.60.0)




 

[SyavX]

Version 0.3.0 (02 May 2015):
+ Added native Linux binaries (32/64-bit versions)*
+ Added open database file via Drag&Drop onto LogEye executable in Explorer [Windows]
- Removed deprecated MSAC GUIDs support
~ Fixed GUI controls glitches (reported by Bistoufly) [Windows]
% Modified database structure (based on Prodigyx' suggestions)
% Modified database format validation (checking for SQLite3 header now)
% Modified [Alt + 1..5] and [Alt + X] shortcuts to [Ctrl + 1..5] and [Ctrl + X]
% Modified icons set

* ? Linux 32-bit binary does not support results sorting feature (until I figure out how to fix it)

N.B. Since the LogEye's databases structure has been changed (again), you will be asked to confirm file's structure update while openning/updating a database with an old structure (databases from versions 0.1.46 - 0.2.0). You could find a database backup named as 'YourDatabase.db.bak' in the same folder.

See first post for the download link...

[jrgp]

Sorry to necropost, but I have a question for SyavX: what is this app written in, and what cross platform UI toolkit are you using?

I'm guessing C++, with wxwidgets as it has the same UI on windows and linux and the linux binaries are linked against gtk.

[SyavX]

It was written in PureBasic (same as all latest versions of my Soldat related tools), GUI was made with PB's native functions plus some platform-dependent APIs (e.g. for nesting checkboxes into toolbar, listview headers sorting, etc.).

[jrgp]

It was written in PureBasic (same as all latest versions of my Soldat related tools), GUI was made with PB's native functions plus some platform-dependent APIs (e.g. for nesting checkboxes into toolbar, listview headers sorting, etc.).

Wow, that's not what I expected to hear. But thanks for the info