sql stats

[xDede]

Kaip per plugina, tarkim sutalpinti ilga koda?

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))")

arba

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])

arba

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])

bandziau taip, bet raso kad per ilgas kodas

[aaarnas]

Vienas dalykas, tai tiek daug stulpelių tokiu atveju turėti nėra geras variantas. Reikėtų matyt saugoti viską viename string surofmatuojant ir skaidant. Nebent pagal galimybes kito būdo nėra.

O sutalpinama skaidant viską per kelis formatex:

Code: Select all

new query[500], lenlen += foramtex(query[len], charsmax(query)-len, "Txt")len += foramtex(query[len], charsmax(query)-len, "Txt2")