Raised This Month: $51 Target: $400
 12% 

Chat Logging to DB


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
pendragon
Senior Member
Join Date: Mar 2004
Location: In a bubble
Old 11-09-2004 , 18:24   Chat Logging to DB
Reply With Quote #1

Function:
- log all chat messages to a table on a sql server database
- a seperate command to purge database entries (if not too difficult)

example:
DBname
  • TableName
    • username
    • STEAMID
    • IP
    • TimeStamp
    • Chat
    • ChatMethod

where:
chat= text said
ChatMethod= say, TeamSay, csay, tsay, scrollsay, adminchat, etc.

---------------End Request---------------------

I would like to get feedback from people.
__________________
pendragon is offline
Send a message via ICQ to pendragon
lantz69
AMX Mod X Beta Tester
Join Date: Mar 2004
Location: Sweden, Skåne
Old 02-12-2005 , 06:17  
Reply With Quote #2

I also would like that.

Then you could build a neat webinterface and search special people who are abusing the language.
__________________
Using: Amxmodx 1.8.1.xxxx, cstrike
http://www.vanilla.se/
lantz69 is offline
nightscreem
Veteran Member
Join Date: Jul 2004
Location: Belgium
Old 02-12-2005 , 08:07  
Reply With Quote #3

yes someone code this plz
and maybe put a install guide with it because i
don't know how i can make those things
__________________
- Bye bye!
nightscreem is offline
f1del1ty.oXi
Veteran Member
Join Date: Nov 2004
Old 02-12-2005 , 13:08  
Reply With Quote #4

Quote:
Originally Posted by lantz69
I also would like that.

Then you could build a neat webinterface and search special people who are abusing the language.
What about mic, which yuo can't do anything about? I barely ever use chat, because I use my mic.

I think this plugin is a good idea, but in theory, if your server is hit often and alot, this'll be a massive database, because what your saying is that for EVERY chat, a new row is added and the same STEAM ID is recorded. So there will be probably 50 or so rows for one person in a map, if they stay for 3 maps that's 150, times probably like 16 players, that's 2400 rows right there, not even in one day. It would create a pain for the database and most likely lag the server depending on how many players are on and how much they chat.

good idea, but I don't think it's worth it. It'd be better to actually make a program that would take every log in your logs folder and search it for something, instead of using a database. =\
__________________
f1del1ty.oXi is offline
TotalNoobScripter
Senior Member
Join Date: Aug 2004
Old 02-12-2005 , 13:38  
Reply With Quote #5

im not so good about php, but inorder to prevent the mysql database from getting to big, could you use php from, for instance, your website to access the sql database, retrieve data from the SQL database, and save it as a .txt or .html document? That way when you want to see the chat messages online, the php will read from the .txt and the .html files, writting the page to be written. It would be even easier if AMXX could do php, but I'm not sure. I also do not know how to code php
TotalNoobScripter is offline
Send a message via AIM to TotalNoobScripter
slurpycof
Senior Member
Join Date: Nov 2004
Old 02-18-2005 , 13:51  
Reply With Quote #6

Here you go. Please try it out and offer any suggestions for improvement. I made a command to delete each type of chat so that you could delete the regular say easily since that will be most of your entries and still keep your admin stuff for later reading if needed. I am sure that I can make this cleaner code once I learn more, but since I am not a coder and this is my 2nd plugin, I think it gets the job done.

http://forums.alliedmods.net/showthread.php?p=#93699
________
Honda CH150

Last edited by slurpycof; 01-19-2011 at 05:00.
slurpycof is offline
slurpycof
Senior Member
Join Date: Nov 2004
Old 02-23-2005 , 21:43  
Reply With Quote #7

Did anyone try this out?
________
CBX

Last edited by slurpycof; 01-19-2011 at 05:02.
slurpycof is offline
mercury
Member
Join Date: Jun 2004
Old 07-28-2005 , 21:53  
Reply With Quote #8

link is broken
anyone know such plugin or a software parser maybe?
mercury is offline
slurpycof
Senior Member
Join Date: Nov 2004
Old 07-28-2005 , 22:14  
Reply With Quote #9

I deleted the post of it since all of the people that downloaded it had zero to say about it and I got no feedback. It dropped my rating for it down to a 0. Here it is if you want to try it out.
Attached Files
File Type: sma Get Plugin or Get Source (sql_storechat.sma - 924 views - 10.4 KB)
slurpycof is offline
mercury
Member
Join Date: Jun 2004
Old 07-28-2005 , 22:28  
Reply With Quote #10

great! thanks!! i'll check it out!

it will be very useful if there will be a php-web script to search by any field you need. date, nick, ip.. as simple as possible! then i can add some style to this page!

usually i have to open logs in text-editor and search by "say".. it's really boring..

thank you!
mercury is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 21:43.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode