[Share] New La2_logd Server ( Perl edition)

**KEMBL** · 13-02-06

Hi all, there perl version of Lin2Logd server.
Whats differenses from off version:

1) No more resident La2 server in the memory (+ RAM)
2) You can setup your own log insertion period ( only 30 mins, in standart L2Logd.exe)
3) You can insert logs offline to prefered DB
4) You can configure this server to insert only what you needs
5) You can insert several log dirs at once, by running prefered count of this servers.
6) No-db mode, where all logs print to STDOUT, you can collect it ( > la2.sql ) to *.sql file, and insert it by MS Query Analyzer
7) You can run server in silent mode (without any STDOUT).
8) Have got error log file
9) More correct work with authd logs, than in standart l2logd server (so users IP wil appear in L2Admin Action Logs)

... and more options in next future ( minor cheat detection for example );

+) More correct lin_CheckLogTimeTable2 procedure (audit logs adds)

All You needs, is:
1) Instal ActiveState Perl
2) Install DBD::ODBC
3) Configure la2_logd.pl ( see in to file, section SERVER CONFIG)
4) Restart L2server, whithout L2Logd, and add start this script like perl.exe la2_logd.pl

usage: la2_logd.pl [-a|-sa|-ca|etc...](without args it work with all logs, l2logd except)
la2_logd.pl -c (work with only cached logs)
la2_logd.pl -a (work with only authd logs)
la2_logd.pl -s (work with only l2server logs)
la2_logd.pl -n (work with only l2npc logs)
la2_logd.pl -l (work with only l2logd logs, not used by default)
la2_logd.pl -na (work with only l2npc logs, type audit)
la2_logd.pl -ci (work with only cached logs, in type (system))
la2_logd.pl -sa (work with only l2server logs, type audit)

There you can see two screens, it shows how server work flows.
This version was tested on more than 18Gb logs (half month), without any serious errors.

You can feel free to use this script at your own needs, it is not complex, and have more comments.

If you have got hex fix from login two users with one char (for self selling and dupe resources), so please share it. Torune's patch is great, but ability for char cloning still exists.

<rus>Новый сервер логов, позволяет гораздо гибче настроить процесс их вставки, позволяет регулировать переодичность, тип вставляемых логов, выдает данные в sql формате, для последующей вставки через альтернативные MsSQL интерфейсы (Query Analyzer), учтены косяки оригинального логсервера. Народ, не жмитесь, поделитесь у кого есть хексом на дюп вещей. Ловить таких в логах хорошо, но лучше убрать причину.</rus>