J1iT8MPH

1new const szTables[][] = 
2{
3	"CREATE TABLE IF NOT EXISTS `mix_players` (`player_id` varchar(32) NOT NULL, `player_name` varchar(64), `kills` int(16) NOT NULL, `deaths` int(16) NOT NULL, `headshots` int(16), `m_aces` int(16), `aces` int(16), `mix_played` int(16) NOT NULL, `mix_won` int(16) NOT NULL, `mix_lost` int(16) NOT NULL, `mix_draw` int(16) NOT NULL, `points` int(16) NOT NULL, `last_online` varchar(64), PRIMARY KEY (`player_id`))",	
4	"CREATE TABLE IF NOT EXISTS `today` (`player_id2` varchar(32) NOT NULL, `player_name2` varchar(64), `kills2` int(16) NOT NULL, `deaths2` int(16) NOT NULL, `headshots2` int(16), `m_aces2` int(16), `aces2` int(16), `mix_played2` int(16) NOT NULL, `mix_won2` int(16) NOT NULL, `mix_lost2` int(16) NOT NULL, `mix_draw2` int(16) NOT NULL, `points2` int(16) NOT NULL, `last_online2` varchar(64), PRIMARY KEY (`player_id2`))"	
5
6}
7
8
9
10
11
12
13
14public SavePlayer(id)
15{    
16    if (pPoints[id] < 0)
17        pPoints[id] < 0;
18    
19    new Name[64], steam[35];
20    get_user_name(id, Name, 34);
21    
22    get_user_authid(id, steam, 34);
23    
24    new szQuery[3800];
25    formatex( szQuery, 3799, "REPLACE INTO `mix_players` (`player_id`, `player_name`, `kills`, `deaths`, `headshots`, `aces`, `m_aces`, `mix_played`, `mix_lost`, `mix_won`, `mix_draw`, `points`, `last_online`) VALUES ('%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', NOW());", steam, GetSecureName(Name), pKills[id], pDeaths[id], pHeadshots[id], pAces[id], pMiniAces[id], pMixPlayed[id], pMixLost[id], pMixWon[id], pMixDraw[id], pPoints[id]);
26    SQL_ThreadQuery( g_hTuple, "QuerySetData", szQuery);
27    
28    formatex( szQuery, 3799, "REPLACE INTO `today` (`player_id2`, `player_name2`, `kills2`, `deaths2`, `headshots2`, `aces2`, `m_aces2`, `points2`, `last_online2`) VALUES ('%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', NOW());", steam, GetSecureName(Name), pTempKills[id], pTempDeaths[id], pTempHeadshots[id], pTempAces[id], pTempMiniAces[id], pTempPoints[id]);
29    SQL_ThreadQuery( g_hTuple, "QuerySetData", szQuery);
30        
31    #if AMXX_VERSION_NUM >= 183 
32        SQL_SetCharset(g_hTuple,"utf8"); // WTF?
33    #endif
34}