AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   StatsX and MySQL (https://forums.alliedmods.net/showthread.php?t=28191)

smgl 05-09-2006 12:04

StatsX and MySQL
 
Quote:

BAILOPAN:

Personally, I would take the stats_logging route with SQLX. An sqlstats_logging plugin would be fairly easy to make. If you make a thread in the Scripting section, I can give you some pointers.
Where are those lines of code where stats are written into csstats.dat?? In Module? :/

SubStream 05-10-2006 08:47

are you asking what the name of the plugin is which writes stats into there?

smgl 05-10-2006 11:24

yes.

And another problem. I'm now editing stats_logging plugin to store data into mysql, but i've got problem - for some reason that i don't know function 'update_stats' isn't executed and i can't see 'UPDATE STATS!!!!!!' in my server window. But there is 'AAAAAA!NAME:......'

Code:
/* AMX Mod X *   Stats Logging Plugin * * by the AMX Mod X Development Team *  originally developed by JustinHoMi * * This file is part of AMX Mod X. * * *  This program is free software; you can redistribute it and/or modify it *  under the terms of the GNU General Public License as published by the *  Free Software Foundation; either version 2 of the License, or (at *  your option) any later version. * *  This program is distributed in the hope that it will be useful, but *  WITHOUT ANY WARRANTY; without even the implied warranty of *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU *  General Public License for more details. * *  You should have received a copy of the GNU General Public License *  along with this program; if not, write to the Free Software Foundation, *  Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * *  In addition, as a special exception, the author gives permission to *  link the code of this program with the Half-Life Game Engine ("HL *  Engine") and Modified Game Libraries ("MODs") developed by Valve, *  L.L.C ("Valve"). You must obey the GNU General Public License in all *  respects for all of the code used other than the HL Engine and MODs *  from Valve. If you modify this file, you may extend this exception *  to your version of the file, but you are not obligated to do so. If *  you do not wish to do so, delete this exception statement from your *  version. */ #include <amxmodx> #include <csx> #include <dbi> new g_pingSum[33] new g_pingCount[33] new g_inGame[33] public plugin_init() {     register_plugin("CS Stats Logging", AMXX_VERSION_STR, "AMXX Dev Team") } public update_stats(id) {     server_cmd ( "UPDATE STATS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!");     new table[33] = "test_stats";     if (!g_inGame[id])         return PLUGIN_HANDLED;     g_inGame[id] = 0        new szTeam[16], szName[32], szAuthid[32], szIp[32] , iStats[8], iHits[8], datetime[33];     get_user_ip ( id , szIp , 31 );     get_user_team(id, szTeam, 15)     get_user_name(id, szName, 31)     get_user_authid(id, szAuthid, 31)     get_time ( "%Y-%m-%d %H:%M:%S" , datetime , 32 );     get_user_stats(id, iStats, iHits)         new query[456]; //format( query, 455 , "INSERT INTO %s VALUES('%s' , '%s' , '%s' , %d , %d , %d , %d , %d , %d . %d , %s )  ON DUPLICATE KEY UPDATE authid='%s',date='%s',kills=kills+%d,tk=tk+%d,deaths=deaths+%d,hits=hits+%d,shots=shots+%d,hs=hs+%d,dmg=dmg+%d,ip='%s'", //      table, szAuthid, szName, datetime, iStats[0], iStats[3], iStats[1], iStats[5], iStats[4], iStats[2], iStats[6], szIp );     server_print ( "QUERY FORMAT BEGIN" );     format( query, 455 , "REPLACE INTO %s VALUES('%s' , '%s' , '%s' , %d , %d , %d , %d , %d , %d . %d , %s )" ,         table, szAuthid, szName, datetime, iStats[0], iStats[3], iStats[1], iStats[5], iStats[4], iStats[2], iStats[6], szIp );     server_print ( "QUERY FORMAT END" );     new Sql:db,error[33];     db = dbi_connect ( "127.0.0.1" , "root" , "rut" , "amx" , error , 32 );     if(db == SQL_FAILED) {         server_print ( "[AMX] Stats_Logging: Cannot connect to SQL" );         return PLUGIN_HANDLED;     }     server_print ( "QUERY SEND" );     dbi_query ( db , "%s", query );     dbi_close ( db );     server_print ( "QUERY: %s" , query );     server_print ( "cmd end" );     return PLUGIN_CONTINUE; } public plugin_end() {     new players[32],pl_num;     get_players ( players , pl_num , "" , "" );     new i;     for(i=0;i<pl_num;i++) {         update_stats ( players[i] );     } } public client_disconnect(id) {     if (!g_inGame[id])         return             g_inGame[id] = 0         if (is_user_bot(id))     {         return     }     remove_task(id)         new szTeam[16], szName[32], szAuthid[32], iStats[8], iHits[8];     new iUserid = get_user_userid(id)         get_user_team(id, szTeam, 15)     get_user_name(id, szName, 31)     get_user_authid(id, szAuthid, 31)             get_user_stats(id, iStats, iHits)     /*for (new i = 1 ; i < 31 ; ++i)     {         if (get_user_stats(id, iStats, iHits))         {             xmod_get_wpnname(i, szWeapon, 23)                         log_message("^"%s<%d><%s><%s>^" triggered ^"weaponstats^" (weapon ^"%s^") (shots ^"%d^") (hits ^"%d^") (kills ^"%d^") (headshots ^"%d^") (tks ^"%d^") (damage ^"%d^") (deaths ^"%d^")",                         szName, iUserid, szAuthid, szTeam, szWeapon, iStats[4], iStats[5], iStats[0], iStats[2], iStats[3], iStats[6], iStats[1])             log_message("^"%s<%d><%s><%s>^" triggered ^"weaponstats2^" (weapon ^"%s^") (head ^"%d^") (chest ^"%d^") (stomach ^"%d^") (leftarm ^"%d^") (rightarm ^"%d^") (leftleg ^"%d^") (rightleg ^"%d^")",                         szName, iUserid, szAuthid, szTeam, szWeapon, iHits[1], iHits[2], iHits[3], iHits[4], iHits[5], iHits[6], iHits[7])         }     }     */     server_print ( "AAAAAAAAAAAAAAAAA^nNAME:%s^nTEAM:%s^nKILLS:%d^nDEATHS:%d^nHS:%d^nTKS:%d^nSHOTS:%d^nHITS:%d^nDMG:%d^n^n " , szName, szTeam , iStats[0] , iStats[1] , iStats[2] , iStats[3] , iStats[4] , iStats[5] , iStats[6] );     update_stats(id);     new iTime = get_user_time(id, 1)         log_message("^"%s<%d><%s><%s>^" triggered ^"time^" (time ^"%d:%02d^")", szName, iUserid, szAuthid, szTeam, (iTime / 60), (iTime % 60))     log_message("^"%s<%d><%s><%s>^" triggered ^"latency^" (ping ^"%d^")", szName, iUserid, szAuthid, szTeam, (g_pingSum[id] / (g_pingCount[id] ? g_pingCount[id] : 1))) } public client_connect(id) {     g_inGame[id] = 0 } public client_putinserver(id) {     g_inGame[id] = 1     if (!is_user_bot(id))     {         g_pingSum[id] = g_pingCount[id] = 0         if (task_exists(id))             remove_task(id)         set_task(19.5, "getPing", id, "", 0, "b")     } } public getPing(id) {     new iPing, iLoss         get_user_ping(id, iPing, iLoss)     g_pingSum[id] += iPing     ++g_pingCount[id] }


All times are GMT -4. The time now is 05:01.

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