next »

[Anubis]

Hm... there are a lot of entries in the DB after one day of using this plugin. I think it would be better to delete some chat entries after a day. Currently this plugin does not cleaning anything, right?

[flinkaflenkaflrsk]

Hm... there are a lot of entries in the DB after one day of using this plugin. I think it would be better to delete some chat entries after a day. Currently this plugin does not cleaning anything, right?

but doesnt it then miss its goal since it supposed to be to search back instead of in the log?

[Anubis]

Well... I could store chat log files at the another machine. Just imagine size of your DB after six months or maybe one or two years.

[xlr8or]

Execute this SQL statement in your B3 database with ie. phpMyAdmin:

Code:

TRUNCATE 'chatlog';

But I have a strong feeling that a button will be added to Echelon within those two year...

[Anubis]

But I have a strong feeling that a button will be added to Echelon within those two year...

Sounds good

[-Chaotic-]

Currently can this plugin be used in conjuction with Echelon for webviewing or can you only read the lines through phpmyadmin?

[xlr8or]

Currently can this plugin be used in conjuction with Echelon for webviewing or can you only read the lines through phpmyadmin?

http://www.bigbrotherbot.com/forums/index.php?topic=423.msg2812#msg2812

[wurst]

hey, theres some rudimentary php output. and i brought my forums headers around it.
here u can test: http://www.dswp.de/player_chatlog.php
all is a bit klickomentary, if u need files just gimme a sign 

im sry that i dont understand that much of php, we should bring some kind of column sorting into that etcetcetc.
btw: i just see xl8ors comment that they included. ui nice i check this evening!

@magoo:
ye, its a big table but compared to xlr opponents or bodyparts its relative small.
i could immagine that words exclusion could reduce the size. i have for example ca.38015 records, 5450 times its "gg" or "GG" or "Gg" or "gG"
b3 collects since july 29 (2weeks), average players online is 26.
regular cleanup would sure make it an install-and-forget. btw, hows that issue handeled in xlr/echelon? should be same to prevent dead links etc...

gg

[Anubis]

Ye... it would be much better to have self cleanup chat's older than .... a week, 2 weeks, month... While performing truncate database I'll erase all the tables

IMO it's really worthy to have such feature.

..install-and-forget...

[Courgette]

I'll think of something for the next release of the plugin.

conf could be something like :

Code:

<configuration plugin="chatlogger">
  <settings name="purge">
    <!-- how long do you want the history to be kept for.
      0 : keep chat log history for ever (default value)
      1d : purge all chat older than one day
      3m : three month
      1y : one year
      ...
    -->
    <set name="max_age">1y</set>
   
    <!-- The purge action takes place once a day at the time define below (default time is midnight) : -->
    <set name="hour">3</set><!-- between 0 and 23 -->
    <set name="min">45</set><!-- between 0 and 59 -->
  </settings>
</configuration>

In this example, everyday at 3:45 am all chat messages older than a year would be erased.

[Anubis]

Would be nice

Another issue. There is an error. For me it's a bit strange. I can't see the reason why it's appearing and what it causes:

080812 23:21:31   DEBUG   AdminPlugin: OnSay handle 5:"do kolby""
080812 23:21:31   VERBOSE   Parsing Event: Say: ChatloggerPlugin
080812 23:21:31   DEBUG   ChatloggerPlugin: ALL, 25976, Czeluskin, do kolby"
080812 23:21:31   DEBUG   ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1218576091, "ALL", 25976, "Czeluskin", 3, "do kolby"")
080812 23:21:31   ERROR   Query failed - <class '_mysql_exceptions.ProgrammingError'>: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"do kolby"")\' at line 1')
080812 23:21:31   ERROR   handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('/home/cod4/b3/b3/parser.py', 520, 'handleEvents', 'hfunc.parseEvent(event)'), ('/home/cod4/b3/b3/plugin.py', 130, 'parseEvent', 'self.onEvent(event)'), ('/home/cod4/b3/b3/plugins/chatlogger.py', 58, 'onEvent', 'chat.save()'), ('/home/cod4/b3/b3/plugins/chatlogger.py', 97, 'save', 'if (cursor.rowcount > 0):')]

like here:

080812 14:28:59   DEBUG   AdminPlugin: OnSay handle 5:"sorki""
080812 14:28:59   VERBOSE   Parsing Event: Say: ChatloggerPlugin
080812 14:28:59   DEBUG   ChatloggerPlugin: ALL, 32751, Borol pl, sorki"
080812 14:28:59   DEBUG   ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1218544139, "ALL", 32751, "Borol pl", 3, "sorki"")
080812 14:28:59   ERROR   Query failed - <class '_mysql_exceptions.ProgrammingError'>: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"sorki"")\' at line 1')
080812 14:28:59   ERROR   handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('/home/cod4/b3/b3/parser.py', 520, 'handleEvents', 'hfunc.parseEvent(event)'), ('/home/cod4/b3/b3/plugin.py', 130, 'parseEvent', 'self.onEvent(event)'), ('/home/cod4/b3/b3/plugins/chatlogger.py', 58, 'onEvent', 'chat.save()'), ('/home/cod4/b3/b3/plugins/chatlogger.py', 97, 'save', 'if (cursor.rowcount > 0):')]

[Kellerkind]

I can't see the reason why it's appearing and what it causes:
like here:

Looks like missing quotation mark escape.
do "kolby"" sorki"
Your Player should not Type NULL" OR 1=1' -- and You should advise your player to write not " UNION update [...] set gid=128 where [...]   too. 

[Anubis]

how to convince them to not use those words? It's obvious if I tell somebody not to do smth, he will do it for sure.

[wurst]

ui. 

[Courgette]

new release v0.1.0
see first message for new download link

[Tags:]

Jump to: Please select a destination: ----------------------------- General Category ----------------------------- => Servers => News => General Discussion ----------------------------- Support Forums ----------------------------- => Installation Support => General Usage Support => Game specific Support ===> CoD2 ===> CoD4 ===> CoD5 ===> UrT ===> Other games ----------------------------- Add-Ons ----------------------------- => Installers => Plugins ===> Releases! => XLR ===> XLR Releases! => Configurations ----------------------------- Community Developers ----------------------------- => Plugin Developers => The Code Bin