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

Chat Logger SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Maurice
Senior Member
Join Date: Nov 2006
Location: Netherlands
Old 05-28-2008 , 19:55   Re: Chat Logger SQL
Reply With Quote #11

After testing the plugin i've notice a bug in the web part, when you try to look back in the history with the calander feature it just shows the last chat messages. I guess i will have 3000 chat messages per day and after some weeks the website part will first shown hundreds of tab pages (the feature that make it possible to see only 200 messages on your screen). If i take 30 days * 3000 chat messages, this will create 450 tab pages...

The website part should make difference with days and only show tab pages from one day. When another day want to be read this should be choiced with the calender feature.
__________________
Luck? Luck is only one feeling of amazement concerning a seemingly incidental circumstance which one himself must create.

Last edited by Maurice; 05-28-2008 at 20:47.
Maurice is offline
chimmychenka
Junior Member
Join Date: May 2008
Old 05-29-2008 , 07:28   Re: Chat Logger SQL
Reply With Quote #12

I'm a noob at sql

how do i fix this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/chimmy/public_html/chimmy/index.php on line 6
Access denied for user 'root'@'localhost' (using password: YES)
chimmychenka is offline
Maurice
Senior Member
Join Date: Nov 2006
Location: Netherlands
Old 05-29-2008 , 19:53   Re: Chat Logger SQL
Reply With Quote #13

Your server and the database are on the same machine? And is your server ip allowed to read/write to the database?
__________________
Luck? Luck is only one feeling of amazement concerning a seemingly incidental circumstance which one himself must create.

Last edited by Maurice; 05-29-2008 at 19:55.
Maurice is offline
Rirre
Veteran Member
Join Date: Nov 2006
Old 08-14-2008 , 14:39   Re: Chat Logger SQL
Reply With Quote #14

Can someone update this, support all HL mods, admin login & choose which gameserver he want to see the logs from.
This is very useful if there's more admins than the owner to look at chat logs
I really need this for more than just CS.

Last edited by Rirre; 08-14-2008 at 15:03.
Rirre is offline
mauirixxx
Member
Join Date: Mar 2006
Old 10-28-2008 , 21:51   Re: Chat Logger SQL
Reply With Quote #15

I wish someone would port this to sourcemod

I'm no coder, but I know you could make a cvar that dictates which server is which, for a multi game server setup. It would be similar to how the MyScal plugin in sourcemod works for figuring out which game server to apply configs for in a multi server setup.

<EDIT> for instance, maybe register "amx_chat_logger_server" and assign it a numerical value - it would be up to the server ops to ensure they number their servers correctly. Maybe you could add a second table to map server names to server numbers? </EDIT>

Also, some players don't seem to get logged - I'm assuming because of their name? I was watching my servers console while playing and saw that on one particular player, the chat logging would fail it's insert every time he typed.

Last edited by mauirixxx; 10-28-2008 at 21:58. Reason: ideas for plugin change
mauirixxx is offline
Send a message via AIM to mauirixxx Send a message via MSN to mauirixxx Send a message via Yahoo to mauirixxx
SeToY
SourceMod Donor
Join Date: Jul 2006
Location: Germany
Old 11-20-2008 , 13:09   Re: Chat Logger SQL
Reply With Quote #16

Is this addon still being developed?
__________________
Success is a lousy teacher. It seduces smart people into thinking they can't lose.
- Bill Gates

Quote:
Originally Posted by Hawk552
SeToY is a retard, scumbag and asshole and you shouldn't pretend that he isn't.
SeToY is offline
axelgaard
Junior Member
Join Date: Feb 2007
Old 11-03-2009 , 03:48   Re: Chat Logger SQL
Reply With Quote #17

in the
Quote:
$dbname = "amx";
should it say the amx? or should i write something else for it to work proberly? as now i get mine to connect to the database, tho it wont show anything from the amx table...
axelgaard is offline
Old 05-02-2010, 17:16
Fronix
This message has been deleted by Fronix.
Fronix
Junior Member
Join Date: Mar 2009
Old 05-02-2010 , 17:22   Re: Chat Logger SQL
Reply With Quote #18

Code:
     new CsTeams:team = cs_get_user_team(id)
     get_user_authid(id,authid,15)  
     get_user_name(id,name,31)
     get_user_ip(id, ip, 15, 1)
to

Code:
     new CsTeams:team = cs_get_user_team(id)
     get_user_authid(id,authid,18)  
     get_user_name(id,name,31)
     get_user_ip(id, ip, 15, 1)
__________________
"C++ would make a decent teaching language if we could teach the ++ part without the C part." — Michael B. Feldman.

Fronix is offline
jEJOX^^
New Member
Join Date: Jul 2010
Old 07-06-2010 , 19:11   Re: Chat Logger SQL
Reply With Quote #19

In English:
Hi. I can not run the chat log. I am just learning SQL, so you do not know what to do.

Console throws me this error: [chat_logger_sql.amxx] Chat log SQL: Could not connect to SQL database.

forgive if the translation is wrong but I speak Spanish.

En Español:
hola. no puedo hacer funcionar el chat log. recien estoy aprendiendo SQL, por lo que no se que hacer.

la consola me tira este error: [chat_logger_sql.amxx] Chat log SQL: Could not connect to SQL database.

perdonen si esta mal la traduccion pero yo hablo español

Last edited by jEJOX^^; 07-08-2010 at 21:10.
jEJOX^^ is offline
ionutz3d
Junior Member
Join Date: Aug 2010
Old 08-28-2010 , 13:22   Re: Chat Logger SQL
Reply With Quote #20

My server and the database are not on the same machine. And how i find if my server ip is allowed to read/write to the database? If you want to explain the steps of the instalation please?
ionutz3d 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 01:20.


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