ChatLog v1.3.7 (Extended) - Page 12

Jamesfo0 · *Last edited by Jamesfo0; 07-24-2010 at 06:59.*

just set the id in the source.

If you run multiple servers try putting sm_chatlogex_id 1 in your autoexec and server.cfg like logaddress

You also know it creates a config file in your cfg/sourcemod directory called sm_chatlogex.cfg

Code:

// This file was auto-generated by SourceMod (v1.3.3)
// ConVars for plugin "chatlogex.smx"


// 7 [default] causes ChatLogEx to clean the database input rows older than set value days. Set to 0 to leave all messages uncleaned.
// -
// Default: "7"
sm_chatlogex_cleandays "7"

// "default" [default] The database configuration to use for logging this server's chat to.
// -
// Default: "default"
sm_chatlogex_db "default"

// 1 [default] causes ChatLogEx to log messages post-processing by other addons. This means chat messages will be logged as they are seen by players, and wont include @commands or censored chat. 0 means ChatLog will directly log 'say' commands, which will i
// -
// Default: "1"
sm_chatlogex_filtermode "1"

// The id to use for logging this server's chat to the database. Must be set for this plugin to function.
// -
// Default: ""
sm_chatlogex_id "1"

// 4 [default] max players in co-op gamemode. This value is displayed on 'players online' messages.
// -
// Default: "4"
sm_chatlogex_mpcoop "4"

// 16 [default] max players in other gamemodes (other games than Left4Dead). This value is displayed on 'players online' messages.
// -
// Default: "16"
sm_chatlogex_mpdefault "16"

// 4 [default] max players in survival gamemode. This value is displayed on 'players online' messages.
// -
// Default: "4"
sm_chatlogex_mpsurvival "4"

// 1 [default] max players are taken from MaxClients property. Overrides all other sm_chatlogex_mp* cvars. This value is displayed on 'players online' messages.
// -
// Default: "1"
sm_chatlogex_mpusemaxclients "1"

// 8 [default] max players in versus gamemode. This value is displayed on 'players online' messages.
// -
// Default: "8"
sm_chatlogex_mpversus "8"

// 0 [default] causes ChatLogEx to log messages when a bot got killed by a player. In L4D this value effects the logs of computer controlled special infected (Boomer, Smoker, etc). Does not override sm_chatlogex_srvmsgs.
// -
// Default: "0"
sm_chatlogex_showbotkills "0"

// 1 [default] causes ChatLogEx to log server messages when player connects or disconnects. Effects the visibility of showing how many players are connected to the server. Does not override sm_chatlogex_srvmsgs.
// -
// Default: "1"
sm_chatlogex_showplayercon "1"

// 1 [default] causes ChatLogEx to log server messages.
// -
// Default: "1"
sm_chatlogex_srvmsgs "1"

turk89 · *Last edited by turk89; 07-24-2010 at 21:51.*

This plugin seems to be very useful, but I can't get it to work. I will now show you what I have done step by step.

Step 1
I have created a MySQL database called chatlogex via. XAMPP

Step 2
I have uploaded those two files from the .zip to: http://localhost/chatlogex/ via. XAMPP

Step 3
I have installed the plugin (.smx file) by saving the file here: \cstrike\addons\sourcemod\plugins

Step 4
My databases.cfg now looks like:

Code:

"Databases"
{
    "driver_default"        "mysql"
    
    "sourcebans"
    {
        "driver"               "default"
        "host"                 "localhost"
        "database"             "sourcebans"
        "user"                 "my_username"
        "pass"                 "my_password"
        //"timeout"            "0"
        //"port"               "3306"
    }
    
   "chatlogex"
    {
        "driver"              "default"
        "host"                "localhost"
        "database"            "chatlogex"
        "user"                "my_username"
        "pass"                "my_password"
    }

    "storage-local"
    {
        "driver"              "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"              "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"           "0"
        //"port"              "0"
    }
}

As you can see, I have added the part with chatlogex

Step 5
Starting the Dedicated Server and this is my error log from \cstrike\addons\sourcemod\logs:

Code:

L 07/25/2010 - 03:34:28: SourceMod error session started
L 07/25/2010 - 03:34:28: Info (map "de_dust2") (file "errors_20100725.log")
L 07/25/2010 - 03:34:28: [SM] Plugin encountered error 25: Call was aborted
L 07/25/2010 - 03:34:28: [SM] Native "SetFailState" reported: Database failure: Could not find database conf "default"
L 07/25/2010 - 03:34:28: [SM] Displaying call stack trace for plugin "chatlogex.smx":
L 07/25/2010 - 03:34:28: [SM]   [0]  Line 746, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Connect()

From server console: 17 <Error> "ChatLogEx" (1.3.7) by muukis (original author Nephyrin)

Did I miss something?

gH0sTy · 07-25-2010 , 06:15 Re: ChatLog v1.3.7 (Extended)

Code:

L 07/25/2010 - 03:34:28: [SM] Native "SetFailState" reported: Database failure: Could not find database conf "default"

The plugin is looking for the "default" Database in your databases.cfg.
Open the sm_chatlogex.cfg in you cfg/sourcemod folder and set sm_chatlogex_db to "chatlogex"

turk89 · *Last edited by turk89; 07-25-2010 at 13:59.*

Thank you.

ineedh3lp · 08-31-2010 , 07:13 Re: ChatLog v1.3.7 (Extended)

Hi. I think there's something wrong... I keep getting this error messages. Could someone please advice me on what to do to fix it?

Code:

'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:54: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xF8\x06 con...' for column 'text' at row 1
L 08/31/2010 - 14:12:54: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', '', 'Player ø connected', -1, 'MihaiS Gangbang Garden', -1)
L 08/31/2010 - 14:12:54: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:54: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:54: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()

Skyrider · 10-25-2010 , 16:21 Re: ChatLog v1.3.7 (Extended)

Possible this plugin can have pages?

muukis · 10-26-2010 , 03:51 Re: ChatLog v1.3.7 (Extended)

Quote:

Originally Posted by ineedh3lp

Hi. I think there's something wrong... I keep getting this error messages. Could someone please advice me on what to do to fix it?

Code:

'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xE0\x06' for column 'text' at row 1
L 08/31/2010 - 14:12:44: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('Console', '', 'à', 0, 'MihaiS Gangbang Garden', 0)
L 08/31/2010 - 14:12:44: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:44: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:44: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()
L 08/31/2010 - 14:12:54: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query Failed! Incorrect string value: '\xF8\x06 con...' for column 'text' at row 1
L 08/31/2010 - 14:12:54: [custom_VERSUS_COMPETITIVE_testing\chatlogex.smx] Query: INSERT INTO chatlogs (name, steamid, text, team, srvid, type) VALUES ('', '', 'Player ø connected', -1, 'MihaiS Gangbang Garden', -1)
L 08/31/2010 - 14:12:54: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 08/31/2010 - 14:12:54: [SM] Displaying call stack trace for plugin "custom_VERSUS_COMPETITIVE_testing\chatlogex.smx":
L 08/31/2010 - 14:12:54: [SM]   [0]  Line 770, /home/groups/alliedmodders/forums/files/5/2/0/8/2/47687.attach::sql_Query()

The player name consists characters that fail in the query. The field type varchar should be replaced with a blob... and there was probably something else too that was required to be done. I'll see if I have the time to fix this.

Quote:

Originally Posted by FF|Skyrider

Possible this plugin can have pages?

What do you mean by pages (in the plugin)?

Skyrider · 10-26-2010 , 05:27 Re: ChatLog v1.3.7 (Extended)

Pages in the web front, so instead of showing 1000 messages per time, it creates pages so you can check out the whole long rather than a small bit of it. Search function would be awesome as well :d (name, ID, chat word)

ineedh3lp · 12-07-2010 , 23:05 Re: ChatLog v1.3.7 (Extended)

Hello!

I would like to merge the php of this plugin with the index of the l4d stats, so it shows the chat-log under the stats (on the same page). Is that possible, and if it is, please show me how.

Thank you!

EDIT: I did try to include one in the other, but I get an error from the chatlog module and the page looks funky.

matrixmark · 12-08-2010 , 04:59 Re: ChatLog v1.3.7 (Extended)

Quote:

Originally Posted by ineedh3lp

Hello!

I would like to merge the php of this plugin with the index of the l4d stats, so it shows the chat-log under the stats (on the same page). Is that possible, and if it is, please show me how.

Thank you!

EDIT: I did try to include one in the other, but I get an error from the chatlog module and the page looks funky.

Hmm <iframe> would probably work