sql stats
Posted: 2013 May 12 19:47
Kaip per plugina, tarkim sutalpinti ilga koda?
pvz:
arba
arba
bandziau taip, bet raso kad per ilgas kodas 
pvz:
Code: Select all
Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS stats (steamid varchar(32),nick varchar(32),AWPK INT(11),AWPD INT(11),AK47K INT(11),AK47D INT(11),M4A1K INT(11),M4A1D INT(11),GALILK INT(11),GALILD INT(11),FAMASK INT(11),FAMASD INT(11),MP5K INT(11),MP5D INT(11),DGLK INT(11),DGLD INT(11),GLK INT(11),GLD INT(11),USK INT(11),USD INT(11),GRK INT(11),GRD INT(11),KNK INT(11),KND INT(11),KTK INT(11),KTD INT(11),VSK INT(11),VSD INT(11),W INT(11),P INT(11),V INT(11),A INT(11),M INT(11),G INT(11))")Code: Select all
format(szTemp,charsmax(szTemp),"INSERT INTO `stats` ( `steamid` , `nick` , `AWPK`, `AWPD`, `AK47K`, `AK47D`, `M4A1K`, `M4A1D`, `GALILK`, `GALILD`, `FAMASK`, `FAMASD`, `MP5K`, `MP5D`, `DGLK`, `DGLD`, `GLK`, `GLD`, `USK`, `USD`, `GRK`, `GRD`, `KNK`, `KND`, `KTK`, `KTD`, `VSK`, `VSD`, `W`, `P`, `V`, `A`, `M`, `G`)VALUES ('%s','%s','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');",szSteamId,g_szName[id])Code: Select all
format(szTemp,charsmax(szTemp),"UPDATE `stats` SET `AWPK`, `AWPD`, `AK47K`, `AK47D`, `M4A1K`, `M4A1D`, `GALILK`, `GALILD`, `FAMASK`, `FAMASD`, `MP5K`, `MP5D`, `DGLK`, `DGLD`, `GLK`, `GLD`, `USK`, `USD`, `GRK`, `GRD`, `KNK`, `KND`, `KTK`, `KTD`, `VSK`, `VSD`, `W`, `P`, `V`, `A`, `M`, `G` = '%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i','%i' WHERE `stats`.`steamid`,`nick` = '%s','%s';",kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id],kills[id], szSteamId, g_szName[id])