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 78912 times)

Offline oddball118

  • Beta Testers
  • Full Member
  • *
  • Posts: 60
    • 4thID Clan
Re: chatlogger plugin v0.2.0
« Reply #75 on: August 18, 2009, 04:49:28 AM »
Heres my cop out for echelon support. Its a bit of a throw together. I'm working on a more effective version of this.

Add this section near the top of your chats.php file. under all the authorisation.
Code: [Select]
$srv = "csh";
<?php
if (isset($_GET['srv'])) {
  $srv = (get_magic_quotes_gpc()) ? $_GET['srv'] : addslashes($_GET['srv']);
}

if ($srv == "srv1") {
$chatlog_table = "chatlog";
$srv_name = "Server 1 Name Here";
}
elseif ($srv == "srv2") {
$chatlog_table = "chatlog2";
$srv_name = "Server 2 Name Here";
}
elseif ($srv == "srv3") {
$chatlog_table = "chatlog3";
$srv_name = "Server 3 Name Here";
}
?>

Then you need to navigate to the SQL Query line, its in the top of the text and you need to edit it to match this.
Code: [Select]
$query_rs_chats = sprintf("SELECT * FROM %s ORDER BY %s %s", $chatlog_table,$xlorderby_rs_chats,$xlorder_rs_chats);

Then in the HTML area add this in somewhere, wherever it looks good on the page for you. Note I wrote this in XHTML
Code: [Select]
<form method="get" action="chats.php">
              <input type="radio" name="srv" value="srv1" id="srv1" <?php if($srv == "srv1") echo "checked=\"checked\""; ?> /><label for="srv1">Server 1 Name</label>
              <input type="radio" name="srv" value="srv2" id="srv2" <?php if($srv == "srv2") echo "checked=\"checked\""; ?> /><label for="srv2">Server 2 Name</label>
              <input type="radio" name="srv" value="srv3" id="srv3" <?php if($srv == "srv3") echo "checked=\"checked\""; ?> /><label for="srv3">Server 3 Name</label>
       <input type="submit" name="Submit" value="Show Chat Logs" />
            </form>

You can see that I have repeated the bitty thing srv1, srv2, srv3, to what ever you want. For example I run a 24/7 Crossfire Server, and I gave the abbreiation of crs to that server so the code looks like.

Code: [Select]
<?php
elseif ($srv == "crs") {
$chatlog_table = "chatlog2";
$srv_name = "Crossfire";
} ?>


and


<input type="radio" name="srv" value="crs" id="crs" <?php if($srv == "crs") echo "checked=\"checked\""; ?> /><label for="crs">Crossfire</label>

Thats my dirty quick and fix. Hope that helps.
Eire.32


Any update on this?  Looks pretty good.  Thanks for all your hard work.

Offline eire.32

  • Echelon v2. Dev.
  • Former Dev. (senate)
  • Full Member
  • *****
  • Posts: 114
    • e32designs.com
Re: chatlogger plugin v0.2.0
« Reply #76 on: August 18, 2009, 04:19:25 PM »
I'm currently working on that page so instead of stupid if statements it will be more dynamic. So you list all your mysql_tables, server_name and the like in arrays then it loops it. Still in the works but I do have the inc_clientchat.php done though! I'll post soon enough.Courgette I realy can't thank you enough for this amazing plugin!
Eire.32
Eire.32

Offline oddball118

  • Beta Testers
  • Full Member
  • *
  • Posts: 60
    • 4thID Clan
Re: chatlogger plugin v0.2.0
« Reply #77 on: August 18, 2009, 11:25:01 PM »
Great.  I can hardly wait.  Thanks for the quick response. 

Offline intrebulon

  • Full Member
  • ***
  • Posts: 84
    • Knight Of Fury Clan
Re: chatlogger plugin v0.2.0
« Reply #78 on: October 08, 2009, 12:59:57 AM »
i was wondering about talkback.  i can't get it working. chatlogger and echelon are fine, there are no errors.  chatlogger even logs my talkback but the talk back does not reach the players in-game.

I'm running separate databases for all my servers on a remote webserver, where echelon and xlrstats are also hosted.  all b3 files, logs and configs are on the gameserver itself.  everything is working 100% except for talkback from echelon to the servers.  banning works fine from echelon, so i don't understand why talkback doesn't as i assume it uses the same type of connectivity to the gameserver.  i'm using latest versions of everything, echelon, chatlogger, xlrstats (not that it has anything to do with this) and the bot itself.

any ideas?  i have no error logs to post because there are no associated errors, the talkback simply isn't reaching the server.  server is not firewalled in any way.  we have full untethered RDP access to the box (win2k3 server).

i would install a webserver on the game box, but i do not want visitor traffic and the extra load on the gameserver.

on another note, my 2 cents on multi server setup.  you can see how i set mine up above.  This allows me to use one bot installation and configure everything on a per server basis.  It also eliminates the problem of having multiple servers logging chat to one table, which seems silly because there is no easy way to determine what happened on which server.  instead of one giant database i have several smaller ones that are easier to manage and backup.

I don't understand why anyone would use a single b3 database for multiple servers.  It kind of defeats the purpose of being able to easily track down who said what, on what server, when, and what name they were using at that time, as far as echelon is concerned, it also allows for per server statistics.

The only minor drawback i have experienced with this setup is that if you ban someone on one server through echelon, you will have to add the ban manually to the other servers if you choose to do so, where the player in question may not have even ever connected to those other servers.

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #79 on: October 08, 2009, 10:37:05 AM »
echelon talkback sends rcon queries to your gameserver. Check the rcon settings in the echelon config file.

About multiserver setup and chatloger : in the chatloger config file, you can define a different mysql table name, hence having a separate chat table for each of your server even if your bots are sharing the same database.

Offline Bakes

  • B3 Contrib/Support
  • Hero Member
  • *
  • Posts: 1226
Re: chatlogger plugin v0.2.0
« Reply #80 on: October 08, 2009, 05:42:30 PM »
I don't understand why anyone would use a single b3 database for multiple servers.  It kind of defeats the purpose of being able to easily track down who said what, on what server, when, and what name they were using at that time, as far as echelon is concerned, it also allows for per server statistics.

Well, if I wanted for my admin privileges to reach across all servers, and for people who are banned on one server to be banned from all, and for aliases to stick, etc, then it's useful to be using one database.

Offline Merph

  • Beta Testers
  • Jr. Member
  • *
  • Posts: 25
not work utf-8
« Reply #81 on: January 07, 2010, 01:54:14 PM »
b3 - 1.2.2 Python
MySQL - 5.1.37
Python - python-2.6.4

b3_run.py
Code: [Select]
#!/usr/local/bin/python
# -*- coding: utf-8 -*-

All .py  files are saved - utf-8 (BOM)

if MySQL
Code: [Select]
default-character-set=cp1251
character-set-server=cp1251
collation-server=cp1251_general_ci
init-connect="SET NAMES cp1251"
skip-character-set-client-handshake
then b3.log
Code: [Select]
100107 15:09:24	CONSOLE	65:29 say;7e1cdb24d9579392240b4c8592c4fc99;2;Merph;?? ????????!!!
100107 15:09:24 VERBOSE Queueing event Say ?? ????????!!!
100107 15:09:24 VERBOSE Parsing Event: Say: CensorPlugin
100107 15:09:24 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100107 15:09:24 VERBOSE Parsing Event: Say: AdminPlugin
100107 15:09:24 DEBUG AdminPlugin: OnSay handle 5:"?? ????????!!!"
100107 15:09:24 VERBOSE Parsing Event: Say: ChatloggerPlugin
100107 15:09:24 DEBUG ChatloggerPlugin: ALL, 2, Merph, ?? ????????!!!
100107 15:09:24 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1262866164, "ALL", 2, "Merph", -1, "?? ????????!!!")
100107 15:09:24 DEBUG ChatloggerPlugin: rowcount: 1, id:21
100107 15:09:29 CONSOLE 65:34 Q;7e1cdb24d9579392240b4c8592c4fc99;2;Merph
in MySQL

Echelon but does not work with this encoding

if MySQL
Code: [Select]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"
skip-character-set-client-handshake

then b3.log
Code: [Select]
100107 15:15:18	CONSOLE	71:24 say;7e1cdb24d9579392240b4c8592c4fc99;2;Merph;?? ????????!!!
100107 15:15:18 VERBOSE Queueing event Say ?? ????????!!!
100107 15:15:18 VERBOSE Parsing Event: Say: CensorPlugin
100107 15:15:18 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100107 15:15:18 VERBOSE Parsing Event: Say: AdminPlugin
100107 15:15:18 DEBUG AdminPlugin: OnSay handle 5:"?? ????????!!!"
100107 15:15:18 VERBOSE Parsing Event: Say: ChatloggerPlugin
100107 15:15:18 DEBUG ChatloggerPlugin: ALL, 2, Merph, ?? ????????!!!
100107 15:15:18 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1262866518, "ALL", 2, "Merph", -1, "?? ????????!!!")
100107 15:15:18 ERROR STDERR
Warning (from warnings module):
  File "D:\b3\b3\storage.py", line 225
    cursor.execute(query)
Warning: Incorrect string value: '\xED\xE5 \xF0\xE0\xE1...' for column 'msg' at row 1

in MySQL did not write



no longer know what to do :(






Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: not work utf-8
« Reply #82 on: January 07, 2010, 02:16:24 PM »
have you tried to tried to convert the chatlog table to utf8_unicode_ci in phpmyadmin ?
Go to the chatlog page, click the 'operations' tab, and there you can convert the table interclassement.

Tell us if this work

Also, is this error crashing the bot ? or does the bot continues but just fail to save to the chatlog table ?

FYI:
Code: [Select]
#!/usr/local/bin/python
# -*- coding: utf-8 -*-
only means that the python file is written using UTF8. It does not mean that characters read from your game log file will be understood as UTF8

Code: [Select]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"
skip-character-set-client-handshake
Those are the default settings for your mysql server and does not apply to already created databases or tables. Further more, you can set a default encoding for a database but specify a different one for some tables.
« Last Edit: January 07, 2010, 02:22:54 PM by Courgette »

Offline Merph

  • Beta Testers
  • Jr. Member
  • *
  • Posts: 25
Re: not work utf-8
« Reply #83 on: January 07, 2010, 08:32:56 PM »
have you tried to tried to convert the chatlog table to utf8_unicode_ci in phpmyadmin ?
Go to the chatlog page, click the 'operations' tab, and there you can convert the table interclassement.

Tell us if this work
I've tried, the result of the same
b3 continues to work, but the error does not show in b3.log, but also in the Cyrillic alphabet doesn't


Code: [Select]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci
init-connect="SET NAMES utf8"
skip-character-set-client-handshake
Those are the default settings for your mysql server and does not apply to already created databases or tables. Further more, you can set a default encoding for a database but specify a different one for some tables.
This is understandable
It was not clear why cp1251 in table record goes
and in UTF8 no
« Last Edit: January 07, 2010, 08:35:39 PM by Merph »

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #84 on: January 07, 2010, 08:50:15 PM »
Can you email me a gameserver log containing cyrilic characters by email ? Mail it to courgette [at] ubu-team (dot) org

Note that I need your gameserver log file, not the b3 log file to reproduce your issue.

Offline Merph

  • Beta Testers
  • Jr. Member
  • *
  • Posts: 25
Re: chatlogger plugin v0.2.0
« Reply #85 on: January 07, 2010, 09:18:01 PM »
done

Offline oddball118

  • Beta Testers
  • Full Member
  • *
  • Posts: 60
    • 4thID Clan
Re: chatlogger plugin v0.2.0
« Reply #86 on: February 20, 2010, 03:26:34 AM »
Well this is strange.  All of a sudden the chatlogger stopped working.  I worked fine for so long then it went dead.  Any ideas why this would happen?  The funny thing is that I can send messages via Echelon too.  All other parts of B3 work fine.  Thanks for all your fine work.  

Game: CoD
OS:  Windows Server 2008

I attached a log.


Quote
100219 20:16:58   BOT       www.BigBrotherBot.com (b3) v1.2.1 [nt] (Daniel)
100219 20:16:58   BOT       Python: 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)]
100219 20:16:58   BOT       Starting CodParser server for 67.212.178.212:28960
100219 20:16:58   BOT       --------------------------------------------
100219 20:16:58   BOT       Attempting to connect to database mysql://b3user:[email protected]/b3_4thid_cod_crouch...
100219 20:16:58   BOT       Connected to database [1 times]
100219 20:16:58   BOT       Game log C:\mygamefiles\4thidcrouch\games_mp.log
100219 20:16:58   BOT       Starting bot reading file C:\mygamefiles\4thidcrouch\games_mp.log
100219 20:16:58   VERBOSE   RCON sending (67.212.178.212:28960) status
100219 20:16:59   BOT       Loading Plugin #1 chatlogger [C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_chatlogger.xml]
100219 20:16:59   INFO   Could not find built in plugin chatlogger, trying external plugin directories.
No module named chatlogger
100219 20:16:59   BOT       ChatloggerPlugin: Loading config C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_chatlogger.xml for ChatloggerPlugin
100219 20:16:59   DEBUG   ChatloggerPlugin: Using default value (chatlog) for db_table
100219 20:16:59   DEBUG   ChatloggerPlugin: max age : 0 => 0 days
100219 20:16:59   INFO   ChatloggerPlugin: chat log messages are kept forever
100219 20:16:59   DEBUG   Register Event: Stop Process: ChatloggerPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: ChatloggerPlugin
100219 20:16:59   BOT       Plugin chatlogger (0.2.0 - Courgette) loaded
100219 20:16:59   BOT       Loading Plugin #2 censor [C:\b3\4thid\cod\crouch\b3\conf\plugin_censor.xml]
100219 20:16:59   BOT       CensorPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_censor.xml for CensorPlugin
100219 20:16:59   DEBUG   Register Event: Stop Process: CensorPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: CensorPlugin
100219 20:16:59   BOT       Plugin censor (2.1.0 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #3 spamcontrol [C:\b3\4thid\cod\crouch\b3\conf\plugin_spamcontrol.xml]
100219 20:16:59   BOT       SpamcontrolPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_spamcontrol.xml for SpamcontrolPlugin
100219 20:16:59   DEBUG   Register Event: Stop Process: SpamcontrolPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: SpamcontrolPlugin
100219 20:16:59   BOT       Plugin spamcontrol (1.1.2 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #4 admin [C:\b3\4thid\cod\crouch\b3\conf\plugin_admin.xml]
100219 20:16:59   BOT       AdminPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_admin.xml for AdminPlugin
100219 20:16:59   DEBUG   Register Event: Stop Process: AdminPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: AdminPlugin
100219 20:16:59   BOT       Plugin admin (1.4.3 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #5 stats [C:\b3\4thid\cod\crouch\b3\conf\plugin_stats.xml]
100219 20:16:59   BOT       StatsPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_stats.xml for StatsPlugin
100219 20:16:59   DEBUG   AdminPlugin: Command "mapstats (mstats)" registered with cmd_mapstats for level (1, 100)
100219 20:16:59   DEBUG   AdminPlugin: Command "testscore (ts)" registered with cmd_testscore for level (1, 100)
100219 20:16:59   DEBUG   AdminPlugin: Command "topstats (tstats)" registered with cmd_topstats for level (9, 100)
100219 20:16:59   DEBUG   Register Event: Stop Process: StatsPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: StatsPlugin
100219 20:16:59   BOT       Plugin stats (1.2.3 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #7 adv [C:\b3\4thid\cod\crouch\b3\conf\plugin_adv.xml]
100219 20:16:59   BOT       AdvPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_adv.xml for AdvPlugin
100219 20:16:59   VERBOSE   Added crontab <bound method AdvPlugin.adv of <b3.plugins.adv.AdvPlugin instance at 0x0294D5A8>> (43325328) - 0s [0, 4, 8, 12, 16, 20, 24, 28, 32, 36, 40, 44, 48, 52, 56]m -1h -1d -1M -1DOW
100219 20:16:59   DEBUG   Register Event: Stop Process: AdvPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: AdvPlugin
100219 20:16:59   BOT       Plugin adv (1.1.3 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #8 statusftp [C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_statusftp.xml]
100219 20:16:59   INFO   Could not find built in plugin statusftp, trying external plugin directories.
No module named statusftp
100219 20:16:59   BOT       StatusftpPlugin: Loading config C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_statusftp.xml for StatusftpPlugin
100219 20:16:59   VERBOSE   Added crontab <bound method StatusftpPlugin.update of <statusftp.StatusftpPlugin instance at 0x02956A08>> (43619888) -
  • s -1m -1h -1d -1M -1DOW

100219 20:16:59   DEBUG   Register Event: Stop Process: StatusftpPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: StatusftpPlugin
100219 20:16:59   BOT       Plugin statusftp (0.1.0 - Courgette) loaded
100219 20:16:59   BOT       Loading Plugin #9 welcome [C:\b3\4thid\cod\crouch\b3\conf\plugin_welcome.xml]
100219 20:16:59   BOT       WelcomePlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_welcome.xml for WelcomePlugin
100219 20:16:59   DEBUG   Register Event: Stop Process: WelcomePlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: WelcomePlugin
100219 20:16:59   BOT       Plugin welcome (1.0.6 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #10 publist [C:\b3\4thid\cod\crouch\b3\conf\plugin_publist.xml]
100219 20:16:59   BOT       PublistPlugin: Loading config C:\b3\4thid\cod\crouch\b3\conf\plugin_publist.xml for PublistPlugin
100219 20:16:59   BOT       PublistPlugin: No config file found for PublistPlugin. (was not required either)
100219 20:16:59   DEBUG   Register Event: Stop Process: PublistPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: PublistPlugin
100219 20:16:59   BOT       Plugin publist (1.1.11 - ThorN) loaded
100219 20:16:59   BOT       Loading Plugin #11 xlrstats [C:\b3\4thid\cod\crouch\b3\extplugins\conf\xlrstats.xml]
100219 20:16:59   INFO   Could not find built in plugin xlrstats, trying external plugin directories.
No module named xlrstats
100219 20:16:59   BOT       XlrstatsPlugin: Loading config C:\b3\4thid\cod\crouch\b3\extplugins\conf\xlrstats.xml for XlrstatsPlugin
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (0) for settings::onemaponly
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_playerstats) for tables::playerstats
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_weaponstats) for tables::weaponstats
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_weaponusage) for tables::weaponusage
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_bodyparts) for tables::bodyparts
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_playerbody) for tables::playerbody
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_opponents) for tables::opponents
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_mapstats) for tables::mapstats
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_playermaps) for tables::playermaps
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_actionstats) for tables::actionstats
100219 20:16:59   DEBUG   XlrstatsPlugin: Using default value (xlr_playeractions) for tables::playeractions
100219 20:16:59   DEBUG   Register Event: Stop Process: XlrstatsPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: XlrstatsPlugin
100219 20:16:59   BOT       Plugin xlrstats (1.0.0 - Tim ter Laak / Mark Weirath) loaded
100219 20:16:59   BOT       Loading Plugin #13 topkiller [C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_topkiller.xml]
100219 20:16:59   INFO   Could not find built in plugin topkiller, trying external plugin directories.
No module named topkiller
100219 20:16:59   BOT       TopkillerPlugin: Loading config C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_topkiller.xml for TopkillerPlugin
100219 20:16:59   DEBUG   TopkillerPlugin: Loading Configuration Started
100219 20:16:59   DEBUG   Register Event: Stop Process: TopkillerPlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: TopkillerPlugin
100219 20:16:59   BOT       Plugin topkiller (1.0.4 - Anubis) loaded
100219 20:16:59   BOT       Loading Plugin #14 ctime [C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_ctime.xml]
100219 20:16:59   INFO   Could not find built in plugin ctime, trying external plugin directories.
No module named ctime
100219 20:16:59   BOT       CtimePlugin: Loading config C:\b3\4thid\cod\crouch\b3\extplugins\conf\plugin_ctime.xml for CtimePlugin
100219 20:16:59   DEBUG   Register Event: Stop Process: CtimePlugin
100219 20:16:59   DEBUG   Register Event: Program Exit: CtimePlugin
100219 20:16:59   BOT       Plugin ctime (1.0.5 - Anubis) loaded
100219 20:16:59   VERBOSE   0 cid changed from None to -1
100219 20:16:59   VERBOSE   RCON sending (67.212.178.212:28960) say ^0(^24thID Bot^0)^7: ^8www.BigBrotherBot.com ^0(^8b3^0) ^9v1.2.1 [nt] ^9(^3Daniel^9)^3 ^2[ONLINE]
100219 20:16:59   DEBUG   Client Connected: [-1] World - WORLD ({})
100219 20:16:59   DEBUG   Storage: getClient <b3.clients.Client object at 0x0280E370>
100219 20:16:59   BOT       Client found in storage 1, welcome back World
100219 20:16:59   DEBUG   Storage: setClient <b3.clients.Client object at 0x0280E370>
100219 20:16:59   DEBUG   Storage: setClient data {'time_add': 1260832263, 'time_edit': 1266632219, 'name': 'World', 'group_bits': 1, 'ip': '', 'auto_login': 1, 'greeting': '', 'pbid': 'WORLD', 'connections': 32, 'mask_level': 0, 'guid': 'WORLD', 'id': 1}
100219 20:16:59   DEBUG   Client Authorized: [-1] World - WORLD
100219 20:16:59   BOT       Starting Plugin chatlogger
100219 20:16:59   DEBUG   Register Event: Say: ChatloggerPlugin
100219 20:16:59   DEBUG   Register Event: Team Say: ChatloggerPlugin
100219 20:16:59   DEBUG   Register Event: Private Message: ChatloggerPlugin
100219 20:16:59   BOT       Starting Plugin censor
100219 20:16:59   DEBUG   Register Event: Say: CensorPlugin
100219 20:16:59   DEBUG   Register Event: Team Say: CensorPlugin
100219 20:16:59   BOT       Starting Plugin spamcontrol
100219 20:16:59   DEBUG   Register Event: Say: SpamcontrolPlugin
100219 20:16:59   DEBUG   Register Event: Team Say: SpamcontrolPlugin
100219 20:16:59   DEBUG   AdminPlugin: Command "spamins (None)" registered with cmd_spamins for level (20, 100)
100219 20:16:59   BOT       Starting Plugin admin
100219 20:16:59   DEBUG   Register Event: Say: AdminPlugin
100219 20:16:59   DEBUG   Register Event: Private Message: AdminPlugin

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #87 on: February 20, 2010, 04:13:12 PM »
It would be more helpful if your log would show people chatting.

Offline oddball118

  • Beta Testers
  • Full Member
  • *
  • Posts: 60
    • 4thID Clan
Re: chatlogger plugin v0.2.0
« Reply #88 on: February 22, 2010, 03:40:23 AM »
I see some error messages in this part:

Code: [Select]
100221 20:34:50	VERBOSE	Parsing Event: Say: ChatloggerPlugin
100221 20:34:50 DEBUG ChatloggerPlugin: ALL, 144, 4thIDCol.Bishop, DANG just looked there too
100221 20:34:50 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806090, "ALL", 144, "4thIDCol.Bishop", 3, "DANG just looked there too")
100221 20:34:50 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:34:50 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object
100221 20:35:04 CONSOLE 8357:20 say;1346880;13;4thID{B}MSG.SkinCrawler;Grim, Bishop, killing on the sabbath.......................
100221 20:35:04 VERBOSE Queueing event Say Grim, Bishop, killing on the sabbath.......................
100221 20:35:04 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:04 DEBUG ChatloggerPlugin: ALL, 173, 4thID{B}MSG.SkinCrawler, Grim, Bishop, killing on the sabbath.......................
100221 20:35:04 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806104, "ALL", 173, "4thID{B}MSG.SkinCrawler", -1, "Grim, Bishop, killing on the sabbath.......................")
100221 20:35:04 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:04 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:04 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:04 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:04 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:04 DEBUG AdminPlugin: OnSay handle 5:"Grim, Bishop, killing on the sabbath......................."
100221 20:35:08 CONSOLE 8357:24 say;1615888;7;4thIDCol.Bishop;:o]
100221 20:35:08 VERBOSE Queueing event Say :o]
100221 20:35:08 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:08 DEBUG ChatloggerPlugin: ALL, 144, 4thIDCol.Bishop, :o]
100221 20:35:08 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806108, "ALL", 144, "4thIDCol.Bishop", 3, ":o]")
100221 20:35:08 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:08 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:08 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:08 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:08 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:08 DEBUG AdminPlugin: OnSay handle 5:":o]"
100221 20:35:08 CONSOLE 8357:24 say;1491288;6;4THIDMaj.GRIM;Hey
100221 20:35:08 VERBOSE Queueing event Say Hey
100221 20:35:08 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:08 DEBUG ChatloggerPlugin: ALL, 94, 4THIDMaj.GRIM, Hey
100221 20:35:08 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806108, "ALL", 94, "4THIDMaj.GRIM", 3, "Hey")
100221 20:35:08 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:08 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:08 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:08 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:08 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:08 DEBUG AdminPlugin: OnSay handle 5:"Hey"
100221 20:35:10 CONSOLE 8357:26 D;1720376;5;axis;4thID_THE SARGE;1491288;6;allies;^44THID^1Maj.GRIM;sten_mp;49;MOD_PISTOL_BULLET;torso_lower
100221 20:35:10 VERBOSE Queueing event Client Damage (49.0, 'sten_mp', 'torso_lower', 'MOD_PISTOL_BULLET')
100221 20:35:10 VERBOSE Parsing Event: Client Damage: StatsPlugin
100221 20:35:10 VERBOSE Parsing Event: Client Damage: TopkillerPlugin
100221 20:35:10 DEBUG TopkillerPlugin: Damage: 4THIDMaj.GRIM count: 25 damage: 49 total damage: 4366
100221 20:35:10 CONSOLE 8357:26 D;1720376;5;axis;4thID_THE SARGE;1491288;6;allies;^44THID^1Maj.GRIM;sten_mp;49;MOD_PISTOL_BULLET;torso_lower
100221 20:35:10 VERBOSE Queueing event Client Damage (49.0, 'sten_mp', 'torso_lower', 'MOD_PISTOL_BULLET')
100221 20:35:10 VERBOSE Parsing Event: Client Damage: StatsPlugin
100221 20:35:10 VERBOSE Parsing Event: Client Damage: TopkillerPlugin
100221 20:35:10 DEBUG TopkillerPlugin: Damage: 4THIDMaj.GRIM count: 25 damage: 49 total damage: 4415
100221 20:35:10 CONSOLE 8357:26 K;1720376;5;axis;4thID_THE SARGE;1491288;6;allies;^44THID^1Maj.GRIM;sten_mp;49;MOD_PISTOL_BULLET;torso_lower
100221 20:35:10 VERBOSE Queueing event Client Kill (49.0, 'sten_mp', 'torso_lower', 'MOD_PISTOL_BULLET')
100221 20:35:10 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:10 VERBOSE stats vshift 0.291338582677
100221 20:35:10 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:10 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:10 DEBUG TopkillerPlugin: Kill: 4THIDMaj.GRIM count: 26 damage: 49 total damage: 4464 headshots:3
100221 20:35:11 CONSOLE 8357:27 K;1840185;12;allies;^5Acme_^1Soldier1;1606483;9;axis;Ballsey LaRoo;mosin_nagant_mp;600;MOD_HEAD_SHOT;head
100221 20:35:11 VERBOSE Queueing event Client Kill (600.0, 'mosin_nagant_mp', 'head', 'MOD_HEAD_SHOT')
100221 20:35:11 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:11 VERBOSE stats vshift 0.353333333333
100221 20:35:11 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:11 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:11 DEBUG TopkillerPlugin: Kill: Ballsey LaRoo count: 12 damage: 600 total damage: 2666 headshots:2
100221 20:35:17 CONSOLE 8357:33 D;1819793;10;allies;^44thID^7{B}^1PVT.Frenchy;1606483;9;axis;Ballsey LaRoo;mp44_mp;47;MOD_PISTOL_BULLET;left_leg_lower
100221 20:35:17 VERBOSE Queueing event Client Damage (47.0, 'mp44_mp', 'left_leg_lower', 'MOD_PISTOL_BULLET')

100221 20:35:21 CONSOLE 8357:37 say;1904085;4;4thID{B}SGT.Heflin;^4Nice Shot.
100221 20:35:21 VERBOSE Queueing event Say ^4Nice Shot.
100221 20:35:21 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:21 DEBUG ChatloggerPlugin: ALL, 172, 4thID{B}SGT.Heflin, ^4Nice Shot.
100221 20:35:21 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806121, "ALL", 172, "4thID{B}SGT.Heflin", 2, "^4Nice Shot.")
100221 20:35:21 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:21 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:21 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:21 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:21 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:21 DEBUG AdminPlugin: OnSay handle 5:"^4Nice Shot."
100221 20:35:22 CONSOLE 8357:37 Item;1819793;10;4thID{B}PVT.Frenchy;item_health
100221 20:35:22 CONSOLE 8357:38 D;1491288;6;allies;^44THID^1Maj.GRIM;1720376;5;axis;4thID_THE SARGE;mp40_mp;49;MOD_PISTOL_BULLET;right_leg_upper
100221 20:35:22 VERBOSE Queueing event Client Damage (49.0, 'mp40_mp', 'right_leg_upper', 'MOD_PISTOL_BULLET')
100221 20:35:22 VERBOSE Parsing Event: Client Damage: StatsPlugin
100221 20:35:22 VERBOSE Parsing Event: Client Damage: TopkillerPlugin
100221 20:35:22 DEBUG TopkillerPlugin: Damage: 4thID_THE SARGE count: 16 damage: 49 total damage: 2578
100221 20:35:23 CONSOLE 8357:39 D;1491288;6;allies;^44THID^1Maj.GRIM;1720376;5;axis;4thID_THE SARGE;mp40_mp;49;MOD_PISTOL_BULLET;right_arm_upper
100221 20:35:23 VERBOSE Queueing event Client Damage (49.0, 'mp40_mp', 'right_arm_upper', 'MOD_PISTOL_BULLET')
100221 20:35:23 VERBOSE Parsing Event: Client Damage: StatsPlugin
100221 20:35:23 VERBOSE Parsing Event: Client Damage: TopkillerPlugin
100221 20:35:23 DEBUG TopkillerPlugin: Damage: 4thID_THE SARGE count: 16 damage: 49 total damage: 2627
100221 20:35:23 CONSOLE 8357:39 K;1491288;6;allies;^44THID^1Maj.GRIM;1720376;5;axis;4thID_THE SARGE;mp40_mp;225;MOD_HEAD_SHOT;head
100221 20:35:23 VERBOSE Queueing event Client Kill (225.0, 'mp40_mp', 'head', 'MOD_HEAD_SHOT')
100221 20:35:23 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:23 VERBOSE stats vshift 1.1328125
100221 20:35:23 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:23 CONSOLE 8357:39 Item;1720376;5;4thID_THE SARGE;item_health
100221 20:35:23 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:23 DEBUG TopkillerPlugin: Kill: 4thID_THE SARGE count: 17 damage: 225 total damage: 2852 headshots:3
100221 20:35:25 CONSOLE 8357:41 Weapon;1840185;12;Acme_Soldier1;sten_mp
100221 20:35:27 CONSOLE 8357:43 Item;1720376;5;4thID_THE SARGE;item_health
100221 20:35:32 CONSOLE 8357:47 Weapon;1904085;4;4thID{B}SGT.Heflin;mp44_mp
100221 20:35:32 CONSOLE 8357:48 Item;1720376;5;4thID_THE SARGE;item_health
100221 20:35:34 CONSOLE 8357:50 K;1720376;5;axis;4thID_THE SARGE;1491288;6;allies;^44THID^1Maj.GRIM;mk1britishfrag_mp;100;MOD_GRENADE_SPLASH;none
100221 20:35:34 VERBOSE Queueing event Client Kill (100.0, 'mk1britishfrag_mp', 'none', 'MOD_GRENADE_SPLASH')
100221 20:35:34 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:34 VERBOSE stats vshift 0.349593495935
100221 20:35:34 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:34 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:34 DEBUG TopkillerPlugin: Kill: 4THIDMaj.GRIM count: 28 damage: 100 total damage: 4949 headshots:4
100221 20:35:40 CONSOLE 8357:56 Weapon;1720376;5;4thID_THE SARGE;mp40_mp
100221 20:35:41 CONSOLE 8357:57 K;1720376;5;axis;4thID_THE SARGE;1819793;10;allies;^44thID^7{B}^1PVT.Frenchy;kar98k_mp;132;MOD_RIFLE_BULLET;torso_lower
100221 20:35:41 VERBOSE Queueing event Client Kill (132.0, 'kar98k_mp', 'torso_lower', 'MOD_RIFLE_BULLET')
100221 20:35:41 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:41 VERBOSE stats vshift 0.279411764706
100221 20:35:41 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:41 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:41 DEBUG TopkillerPlugin: Kill: 4thID{B}PVT.Frenchy count: 14 damage: 132 total damage: 2090 headshots:1
100221 20:35:45 CONSOLE 8358:00 D;1606483;9;axis;Ballsey LaRoo;1491288;6;allies;^44THID^1Maj.GRIM;sten_mp;49;MOD_PISTOL_BULLET;left_arm_lower
100221 20:35:45 VERBOSE Queueing event Client Damage (49.0, 'sten_mp', 'left_arm_lower', 'MOD_PISTOL_BULLET')
100221 20:35:45 VERBOSE Parsing Event: Client Damage: StatsPlugin
100221 20:35:45 VERBOSE Parsing Event: Client Damage: TopkillerPlugin
100221 20:35:45 DEBUG TopkillerPlugin: Damage: 4THIDMaj.GRIM count: 28 damage: 49 total damage: 4998
100221 20:35:45 CONSOLE 8358:01 Item;1606483;9;Ballsey LaRoo;item_health
100221 20:35:45 CONSOLE 8358:01 K;1904085;4;axis;^44thID^7{B}^1SGT.Heflin;1819793;10;allies;^44thID^7{B}^1PVT.Frenchy;kar98k_mp;132;MOD_RIFLE_BULLET;right_leg_upper
100221 20:35:45 VERBOSE Queueing event Client Kill (132.0, 'kar98k_mp', 'right_leg_upper', 'MOD_RIFLE_BULLET')
100221 20:35:45 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:45 VERBOSE stats vshift 0.205479452055
100221 20:35:45 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:45 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:45 DEBUG TopkillerPlugin: Kill: 4thID{B}PVT.Frenchy count: 15 damage: 132 total damage: 2222 headshots:1
100221 20:35:45 CONSOLE 8358:01 K;1491288;6;allies;^44THID^1Maj.GRIM;1606483;9;axis;Ballsey LaRoo;mosin_nagant_mp;132;MOD_RIFLE_BULLET;torso_lower
100221 20:35:45 VERBOSE Queueing event Client Kill (132.0, 'mosin_nagant_mp', 'torso_lower', 'MOD_RIFLE_BULLET')
100221 20:35:45 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:45 VERBOSE stats vshift 0.458904109589
100221 20:35:45 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:45 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:45 DEBUG TopkillerPlugin: Kill: Ballsey LaRoo count: 13 damage: 132 total damage: 2845 headshots:2
100221 20:35:48 CONSOLE 8358:03 say;1491288;6;4THIDMaj.GRIM;vns
100221 20:35:48 VERBOSE Queueing event Say vns
100221 20:35:48 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:48 DEBUG ChatloggerPlugin: ALL, 94, 4THIDMaj.GRIM, vns
100221 20:35:48 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806148, "ALL", 94, "4THIDMaj.GRIM", 3, "vns")
100221 20:35:48 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:48 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:48 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:48 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:48 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:48 DEBUG AdminPlugin: OnSay handle 5:"vns"
100221 20:35:51 CONSOLE 8358:07 Weapon;1720376;5;4thID_THE SARGE;mp40_mp
100221 20:35:52 CONSOLE 8358:08 Item;1819793;10;4thID{B}PVT.Frenchy;item_health
100221 20:35:52 CONSOLE 8358:08 K;1819793;10;allies;^44thID^7{B}^1PVT.Frenchy;1346880;13;axis;^44thID^7{B}^1MSG.SkinCrawler;kar98k_mp;600;MOD_HEAD_SHOT;head
100221 20:35:52 VERBOSE Queueing event Client Kill (600.0, 'kar98k_mp', 'head', 'MOD_HEAD_SHOT')
100221 20:35:52 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:35:52 VERBOSE stats vshift 0.77
100221 20:35:52 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:35:52 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:35:52 DEBUG TopkillerPlugin: Kill: 4thID{B}MSG.SkinCrawler count: 1 damage: 600 total damage: 600 headshots:1
100221 20:35:52 CONSOLE 8358:08 Weapon;1346880;13;4thID{B}MSG.SkinCrawler;kar98k_mp
100221 20:35:53 CONSOLE 8358:09 say;1606483;9;Ballsey LaRoo;thx
100221 20:35:53 VERBOSE Queueing event Say thx
100221 20:35:53 VERBOSE Parsing Event: Say: ChatloggerPlugin
100221 20:35:53 DEBUG ChatloggerPlugin: ALL, 400, Ballsey LaRoo, thx
100221 20:35:53 DEBUG ChatloggerPlugin: query: INSERT INTO chatlog (msg_time, msg_type, client_id, client_name, client_team, msg) VALUES (1266806153, "ALL", 400, "Ballsey LaRoo", 2, "thx")
100221 20:35:53 ERROR Query failed - <class '_mysql_exceptions.IntegrityError'>: (1062, "Duplicate entry '62685' for key 1")
100221 20:35:53 ERROR handler ChatloggerPlugin could not handle event Say: AttributeError: 'NoneType' object has no attribute 'rowcount' [('C:\\b3\\4thid\\cod4\\aliens\\b3\\parser.py', 711, 'handleEvents', 'hfunc.parseEvent(event)'), ('C:\\b3\\4thid\\cod4\\aliens\\b3\\plugin.py', 143, 'parseEvent', 'self.onEvent(event)'), ('b3\\extplugins\\chatlogger.py', 156, 'onEvent', 'chat.save()'), ('b3\\extplugins\\chatlogger.py', 207, 'save', 'if (cursor.rowcount > 0):')]
100221 20:35:53 VERBOSE Parsing Event: Say: CensorPlugin
100221 20:35:53 VERBOSE Parsing Event: Say: SpamcontrolPlugin
100221 20:35:53 VERBOSE Parsing Event: Say: AdminPlugin
100221 20:35:53 DEBUG AdminPlugin: OnSay handle 5:"thx"
100221 20:36:00 VERBOSE RCON sending (67.212.178.212:28960) status
100221 20:36:00 VERBOSE RCON sending (67.212.178.212:28960) say ^0(^24thID Bot^0)^7: ^2Please speak English while playing in this server.
100221 20:36:00 VERBOSE StatusftpPlugin: Building XML status
100221 20:36:00 DEBUG StatusftpPlugin: Writing XML status to C:\b3\status_xml\4thid\cod\crouch\status.xml
100221 20:36:01 CONSOLE 8358:17 K;1840185;12;allies;^5Acme_^1Soldier1;1606483;9;axis;Ballsey LaRoo;mosin_nagant_mp;132;MOD_RIFLE_BULLET;torso_upper
100221 20:36:01 VERBOSE Queueing event Client Kill (132.0, 'mosin_nagant_mp', 'torso_upper', 'MOD_RIFLE_BULLET')
100221 20:36:01 VERBOSE Parsing Event: Client Kill: StatsPlugin
100221 20:36:01 VERBOSE stats vshift 0.302547770701
100221 20:36:01 VERBOSE Parsing Event: Client Kill: XlrstatsPlugin
100221 20:36:01 VERBOSE Parsing Event: Client Kill: TopkillerPlugin
100221 20:36:01 DEBUG TopkillerPlugin: Kill: Ballsey LaRoo count: 14 damage: 132 total damage: 2977 headshots:2
« Last Edit: February 22, 2010, 11:13:21 AM by Courgette »

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4882
    • Github repository
Re: chatlogger plugin v0.2.0
« Reply #89 on: February 22, 2010, 11:15:43 AM »
do you have different bots sharing the same database ?

Try to run the following SQL query in phpmyadmin (or whatever mysql client you use) :
Code: sql [Select]
REPAIR TABLE chatlog QUICK; 


If it does not work, try :
Code: sql [Select]
DELETE FROM chatlog WHERE `id`= 62685;
« Last Edit: February 22, 2010, 01:48:36 PM by Courgette »

 


Rate this page +1 at Google Search