[aake]

This plugin save chat message to MySQL Database

installing the plugin:
1. Copy chat_logger_sql.amxx file to plugins folder
2. Add line chat_logger_sql.amxx to plugins.ini file
3 Copy ChatLoggerSQL_NoSaveWords.ini file to your config folder.

Plugins upgrade 14-04-2008:
Added to plugin:
1. Plugin has been chanced so it will automaticaly create database if it doesn't excist yet.
2. Added feature that will not save any selected messages to database. This funciont will search unwanted words from ChatLoggerSQL_NoSaveWords.ini file. If any words writen in file will match to chat messages, the message will not be saved into database.


PHP Example http://naputtaja.no-ip.biz/chat_log/

[Hawk552]

Surprisingly useful, but you should close the SQL connection. You never have to open it in the first place as threaded querying demands only the tuple.

I'm going to approve it for now, but please make that change.

[chris]

Wow nice job!

[Min2liz]

What need to add that dont insert into MySQL for example /cp /tp and so on. I trying

if (message != '/cp' && message != '/tp') { format(query,1000,"INSERT into %s (name,authid,ip,alive,team,date,time,message, cmd) values ('%s','%s','%s','%d','%s','%s','%s','%s','%s' )",table,name,authid,ip,is_user_alive(id),TEA MNAME[_:team],datestr,timestr,message,cmd) }

and get errors like:
Error: Invalid character constant on line 99
Error: Undefined symbol "cp" on line 99
Error: Undefined symbol "tp" on line 99
Warning: Loose indentation on line 98

I'm totaly newbie on amxx scripting :/

[illu.sports | Leader]

If I open www.mydomain.com/chatlog/index.php i get this:

[Curryking]

Very nice plugin, I love it. Thanks! (http://forums.team-bbq.org/bbq_chatlog.php)

Future request: Is it possible to log also the map which is currently played?

e.g.

2008-05-17 15:24:20 <de_dust> <STEAM_0:1:28635> <62.226.64.232> Curryking : hello world

Curry

[illu.sports | Leader]

Could someone tell me how to install the sql-part of the plugin?
I get the following errors:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /mnt/web5/10/62/51539562/htdocs/illusports/chatlog/index.php on line 28

and:
Table 'Databasename.amx_chat_log' doesn't exist

Hope for help
Mark

[Curryking]

Originally Posted by illu.sports | Leader [...] [/B]and: Table 'Databasename.amx_chat_log' doesn't exist [...]

Just install the plugin properly and after the next mapchange/restart the plugin will automatically create the needed tables (as long as you have the SQL database with amxx running, of course )

Another feature request: Sometimes the plugin logs messages with no content. Would be nice if thouse could be excluded/wouldn't be logged anymore...

Messages like this:

2008-05-17 15:24:20 <STEAM_0:1:28635> <62.226.64.232> Curryking :

Regards, Curry

[illu.sports | Leader]

These empty messages I think is when someone types something, deletes it and pushes Enter.
You now u wanna write something and then think mhh, i think i shouldnt write that

[Maurice]

This plugin code got some bugs, compile error codes 217 and 225. I don't know if it will make any troubles but preffer plugins without compile error messages.