Raised This Month: $ Target: $400
 0% 

Solved Print online players


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Airkish
AlliedModders Donor
Join Date: Apr 2016
Location: Lithuania
Old 05-26-2018 , 03:10   Re: Scoreboard to MYSQL
Reply With Quote #1

Quote:
Originally Posted by 4ever16 View Post
Found one bug. When i change nickname the scoreboard doesnt change for that user. It just leaves the old one and doesnt update the user who changed the nick.

BTW this i what i got so far. Oldschool style.

It's aint bug, I just forgot of nick change cuz on my server it was blocked.

Update - player's team on mysql now changes on team change event rather then roundstart.
Try this:

PHP Code:
#include < amxmodx > 
#include < sqlx > 
#include < cstrike > 
#include < hamsandwich > 

/* Database */ 
new Host[ ] = "" 
new User[ ] =  "" 
new Pass[ ] =  "" 
new Db[ ] =  "" 

new MySQL_Query512 
new 
Handle:MySQL_Tuple 
new Handle:MySQL_Connection 
new bool:g_Loaded33 ] = false 
new Kills[33], Deaths[33]; 
new 
Team[33], OldName[33][32]

new 
g_logfile[64]; 

new const 
VERSION[ ] = "0.0.2" 

public plugin_init( ) { 
    
register_plugin"Scoreboard to MySQL"VERSION"Airkish" 
    
register_clcmd("say /rs""ResetScore"
    
register_event"TeamInfo""event_team_info""a" );


public 
client_putinserverid 

    
OldName[id] = "";
    
set_task(5.0"Presql_Load"id
    
g_Loadedid ] = false 


public 
client_infochanged(id

    new 
newname[32],oldname[32
    
get_user_info(id"name"newname,31
    
get_user_name(idoldname31
    
    if(!
equali(newnameoldname))
    {
        
OldName[id] = oldname;
        
MySQL_UpdateName(id);
        return 
PLUGIN_HANDLED;
    }
    return 
PLUGIN_CONTINUE;
}

public 
Presql_Load(id) { 
    if ( 
cs_get_user_team(id) == CS_TEAM_T) { 
        
Team[id] = 1
    } 
    else if ( 
cs_get_user_team(id) == CS_TEAM_CT ) { 
        
Team[id] = 2
    } 
    else { 
        
Team[id] = 3
    } 
    
MySQL_Load(id


public 
client_death(KillerVictimwpnindexhitplaceTK

    if(
Killer == Victim) {  
        
Deaths[Killer]++;  
        
MySQL_Update(Killer); 
        return 
PLUGIN_HANDLED
    } 
    
Kills[Killer]++; 
    
Deaths[Victim]++; 
    
MySQL_Update(Killer
    
MySQL_Update(Victim

    return 
PLUGIN_CONTINUE


public 
ResetScore(id) { 
    
Kills[id] = 0
    
Deaths[id] = 0
    
MySQL_Update(id); 


public 
event_team_info()
{
    new 
id read_data);
        
    new 
team[12];
    
read_data2teamsizeof team );
    
    switch( 
team[0] )
    {
        case 
'C': {
            
Team[id] = 1;
        }
        case 
'T': {
            
Team[id] = 2;
        }
        case 
'S': {
            
Team[id] = 3;
        }
    }
    
MySQL_Update(id);
}

public 
client_disconnectedid 

    
OldName[id] = "";
    if( 
g_Loadedid ] ) 
        
MySQL_Deleteid 


public 
plugin_precache( ) 

    
get_time("online_players_%Y%m%d.log"g_logfilecharsmax(g_logfile)); 
    
log_errors("-------------------- == --------------------"); 

    
MySQL_Tuple SQL_MakeDbTupleHostUserPassDb 
    
#if AMXX_VERSION_NUM >= 183 
        
SQL_SetCharset(MySQL_Tuple,"utf8"); 
    
#endif 
     
    
new ErrorCode 
    MySQL_Connection 
SQL_ConnectMySQL_TupleErrorCodeMySQL_QuerycharsmaxMySQL_Query ) ) 
     
    if( 
MySQL_Connection == Empty_Handle 
        
set_fail_stateMySQL_Query 
     
    
SQL_ThreadQueryMySQL_Tuple"SQL_TrashHandler""CREATE TABLE IF NOT EXISTS online_players (username VARCHAR(128) COLLATE utf8_lithuanian_ci NOT NULL, kills INT(11), deaths INT(11), team INT(1) )" )   

    
SQL_ThreadQueryMySQL_Tuple"SQL_TrashHandler""DELETE FROM online_players" )   


public 
MySQL_Loadid )  

    new 
Temp
    
Temp] = id 
     
    formatex
MySQL_QuerycharsmaxMySQL_Query ), "SELECT * FROM `online_players` WHERE `username` = '%s'"get_user_name_ex(id) ) 
    
SQL_ThreadQueryMySQL_Tuple"Load_PlayerInfo"MySQL_QueryTempsizeofTemp ) ) 

                                                                                 
public 
Load_PlayerInfoFailStateHandle:QueryError[ ], ErrcodeData[ ], DataSize )  

    if( 
FailState == TQUERY_CONNECT_FAILED )  
    { 
        new 
Players32 ], PlayersNum 
        get_players
PlayersPlayersNum"ch" 
         
        for( new 
iPlayersNumi++ ) 
            
log_errors"Load - Could not connect to SQL database.  [%d] %s"ErrcodeError 
    } 
             
    else if( 
FailState == TQUERY_QUERY_FAILED 
    { 
        new 
Players32 ], PlayersNum 
        get_players
PlayersPlayersNum"ch" 
         
        for( new 
iPlayersNumi++ ) 
        { 
            
log_errors"Load Query failed. [%d] %s"ErrcodeError 
        } 
    } 
    new 
id Data
     
    if( !
is_user_connectedid ) ) 
        return 
         
    if( 
SQL_NumResultsQuery ) < )  
    { 
        
formatexMySQL_QuerycharsmaxMySQL_Query ), "INSERT INTO `online_players` (`username`, `kills`, `deaths`, `team`) VALUES ('%s', '%d', '%d', '%d')"get_user_name_ex(id), Kills[id], Deaths[id], Team[id]) 
        
SQL_ThreadQueryMySQL_Tuple"SQL_TrashHandler"MySQL_Query 
        
log_errors("%s"MySQL_Query
        
g_Loadedid ] = true 
    



public 
MySQL_Updateid ) { 
    
formatexMySQL_QuerycharsmaxMySQL_Query ), "UPDATE `online_players` SET `kills` = '%d', `deaths` = '%d', `team` = '%d' WHERE `username` = '%s'"Kills[id], Deaths[id], Team[id], get_user_name_ex(id) ) 
    
SQL_ThreadQuery(MySQL_Tuple"SQL_TrashHandler"MySQL_Query);     


public 
MySQL_UpdateName(id) {
    
replace_all(OldName[id], 32"'""\'"); 
    
replace_all(OldName[id], 32"^"", "\^""); 

    
formatexMySQL_QuerycharsmaxMySQL_Query ), "UPDATE `online_players` SET `username` = '%s' WHERE `username` = '%s'"get_user_name_ex(id), OldName[id] ) 
    
SQL_ThreadQuery(MySQL_Tuple"SQL_TrashHandler"MySQL_Query);   
}

public 
MySQL_Delete( const id )  

    
formatexMySQL_QuerycharsmaxMySQL_Query ), "DELETE from `online_players` WHERE `username` = '%s'"get_user_name_ex(id) ) 
    
SQL_ThreadQuery(MySQL_Tuple"SQL_TrashHandler"MySQL_Query); 


public 
SQL_TrashHandlerFailState,Handle:QueryError[ ], Errcode,Data[ ], DataSize )   
{  
    if( 
FailState == TQUERY_CONNECT_FAILED 
        
log_errors"Load - Could not connect to SQL database.  [%d] %s"ErrcodeError )  
         
    else if( 
FailState == TQUERY_QUERY_FAILED 
        
log_errors"Load Query failed. [%d] %s"ErrcodeError 
     
    
SQL_FreeHandleQuery 


public 
plugin_end( )  
{    
    
SQL_FreeHandleMySQL_Connection 


stock log_errors(const szText[], any:...) 

    static 
szMessage[256]; 
    
vformat(szMessage256szText2); 
     
    
log_to_file(g_logfileszMessage); 
     
    return 
PLUGIN_HANDLED


stock get_user_name_ex(id

    new 
szName[33]; 
    
get_user_name(idszNamecharsmax(szName)); 

    
replace_all(szNamecharsmax(szName), "'""\'"); 
    
replace_all(szNamecharsmax(szName), "^"", "\^""); 

    return 
szName


Last edited by Airkish; 05-26-2018 at 03:16.
Airkish is offline
sekac
Senior Member
Join Date: Nov 2016
Old 05-26-2018 , 06:10   Re: Scoreboard to MYSQL
Reply With Quote #2

So is it possible to have live score preview on your website with this? Useful for tournaments and such.
sekac is offline
4ever16
Veteran Member
Join Date: Apr 2015
Old 05-26-2018 , 08:17   Re: Scoreboard to MYSQL
Reply With Quote #3

Quote:
Originally Posted by sekac View Post
So is it possible to have live score preview on your website with this? Useful for tournaments and such.
Yes but 1.6 tournaments you ciding right?
4ever16 is offline
ish12321
Veteran Member
Join Date: May 2016
Old 05-26-2018 , 09:03   Re: Scoreboard to MYSQL
Reply With Quote #4

Quote:
Originally Posted by sekac View Post
So is it possible to have live score preview on your website with this? Useful for tournaments and such.
In tournaments if you give realtime details on site, players can get info about their opponent team probably.
__________________
['O|s|G'] | Death Wins a.k.a Ish Chhabra was here
ish12321 is offline
sekac
Senior Member
Join Date: Nov 2016
Old 05-26-2018 , 11:43   Re: Scoreboard to MYSQL
Reply With Quote #5

Quote:
Originally Posted by ish12321 View Post
In tournaments if you give realtime details on site, players can get info about their opponent team probably.
You mean the info that's available to everyone by pressing tab?
sekac is offline
Old 05-26-2018, 09:49
4ever16
This message has been deleted by 4ever16.
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 10:35.


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