thankyou
Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
Most of the plugins here are made by B3 users and the authors may not visit frequently. If you need support for plugins or if questions remain unanswered, you will have to contact the author directly. Read the full Support Disclaimer here

NOTE: Do not attach plugins to your forumtopics! Attachements are periodically removed by maintenance tasks. Upload your plugins to our Downloads section instead!

Author Topic: chatlogger plugin  (Read 81806 times)

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #15 on: August 03, 2008, 02:11:21 AM »
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?

Offline flinkaflenkaflrsk

  • Sr. Member
  • ****
  • Posts: 238
Re: chatlogger plugin v0.0.1
« Reply #16 on: August 03, 2008, 11:38:57 AM »
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?

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #17 on: August 03, 2008, 08:52:48 PM »
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.

Offline xlr8or

  • [ www.xlrstats.com ]
  • Project Lead
  • Hero Member
  • *
  • Posts: 2057
    • The Art of Tactical Gaming
Re: chatlogger plugin v0.0.1
« Reply #18 on: August 03, 2008, 09:31:02 PM »
Execute this SQL statement in your B3 database with ie. phpMyAdmin:
Code: [Select]
TRUNCATE 'chatlog';
But I have a strong feeling that a button will be added to Echelon within those two year... ;)

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #19 on: August 03, 2008, 11:11:40 PM »
But I have a strong feeling that a button will be added to Echelon within those two year... ;)

Sounds good :)

Offline -Chaotic-

  • Full Member
  • ***
  • Posts: 65
    • The Walking Dead
Re: chatlogger plugin v0.0.1
« Reply #20 on: August 04, 2008, 05:40:16 PM »
Currently can this plugin be used in conjuction with Echelon for webviewing or can you only read the lines through phpmyadmin?

Offline xlr8or

  • [ www.xlrstats.com ]
  • Project Lead
  • Hero Member
  • *
  • Posts: 2057
    • The Art of Tactical Gaming
Re: chatlogger plugin v0.0.1
« Reply #21 on: August 04, 2008, 07:20:00 PM »
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

Offline wurst

  • Jr. Member
  • **
  • Posts: 22
Re: chatlogger plugin v0.0.1
« Reply #22 on: August 12, 2008, 10:37:24 AM »
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 :D
« Last Edit: August 12, 2008, 10:56:52 AM by wurst »

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #23 on: August 12, 2008, 07:03:21 PM »
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...

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: chatlogger plugin v0.0.1
« Reply #24 on: August 12, 2008, 08:13:38 PM »
I'll think of something for the next release of the plugin.

conf could be something like :
Code: [Select]
<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.

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #25 on: August 12, 2008, 11:46:21 PM »
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:
Quote
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:
Quote
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):')]

Offline Kellerkind

  • Jr. Member
  • **
  • Posts: 46
    • Internationaloldstars.de
Re: chatlogger plugin v0.0.1
« Reply #26 on: August 13, 2008, 08:01:04 AM »
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.  ::)
« Last Edit: August 13, 2008, 08:04:18 AM by Kellerkind »
B3 CoDII:  82.98.201.199:28960 (Jenny)
B3 CoDIV: 82.98.201.199:28961 (Nadja)

Used Plugins:
Xlrstats, Echolon, Pubbans, Pingkicker, Rotationsmgr, Chatplugin, Poweradmin2&4, Spreemsg, Configmgr,  Clantag control

Offline Anubis

  • Sr. Member
  • ****
  • Posts: 228
    • g4g.pl
Re: chatlogger plugin v0.0.1
« Reply #27 on: August 13, 2008, 04:56:48 PM »
how to convince them to not use those words? :D It's obvious if I tell somebody not to do smth, he will do it for sure.

Offline wurst

  • Jr. Member
  • **
  • Posts: 22
Re: chatlogger plugin v0.0.1
« Reply #28 on: August 14, 2008, 01:12:28 PM »
ui.  ::)

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: chatlogger plugin v0.0.1
« Reply #29 on: August 14, 2008, 01:45:14 PM »
new release v0.1.0
see first message for new download link

 


Rate this page +1 at Google Search