SA-MP Forums Archive
mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: mysql (/showthread.php?tid=78276)



mysql - insider1 - 18.05.2009

pawn Код:
new query[256];
format(query,sizeof(query),"UPDATE `igralci` SET `pCash`= '%d', `pAccount`='%d', `pAdmin`='%d', `pLevel`='%d', `pExp`='%d', `gPupgrade`='%d', `pKills`='%d', `pCB`='%d', `pHW`='%d', `pSR`='%d', `pWA`='%d' WHERE (`ime` = '%s')",PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pCB],
PlayerInfo[playerid][pHW],
PlayerInfo[playerid][pSR],
PlayerInfo[playerid][pWA],
string);
samp_mysql_query(query);
format(query,sizeof(query),"UPDATE `igralci` SET `pPEN`='%d', `pGun1`='%d', `pGun2`='%d', `pGun3`='%d', `pGun4`='%d', `pGun5`='%d', `pGun6`='%d', `pAmmo1`='%d', `pAmmo2`='%d', `pAmmo3`='%d', `pAmmo4`='%d' WHERE (`ime` = '%s')",
PlayerInfo[playerid][pPEN],
PlayerInfo[playerid][pGun1],
PlayerInfo[playerid][pGun2],
PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4],
PlayerInfo[playerid][pGun5],
PlayerInfo[playerid][pGun6],
PlayerInfo[playerid][pAmmo1],
PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4],
string);
samp_mysql_query(query);

format(query,sizeof(query),"UPDATE `igralci` SET `pAmmo5`='%d', `pAmmo6`='%d', `pSHealth`='%d', `pHealth`='%d', `pPos_x`='%d', `pPos_y`='%d', `pPos_z`='%d', `pInt`='%d', `pLocal`='%d', `pTeam`='%d' WHERE (`ime` = '%s')",
PlayerInfo[playerid][pAmmo5],
PlayerInfo[playerid][pAmmo6],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pPos_x],
PlayerInfo[playerid][pPos_y],
PlayerInfo[playerid][pPos_z],
PlayerInfo[playerid][pInt],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam],
string);
samp_mysql_query(query);
format(query,sizeof(query),"UPDATE `igralci` SET `pModel`='%d', `pPnumber`='%d', `pPhousekey`='%d', `pPbiskey`='%d', `pTVec`='%d', `pMedic`='%d', `pCop`='%d', `pReg`='%d', `pGang`='%d', `pGangLeader`='%d' WHERE (`ime` = '%s') ",
PlayerInfo[playerid][pModel],
PlayerInfo[playerid][pPnumber],
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pTVec],
PlayerInfo[playerid][pMedic],
PlayerInfo[playerid][pCop],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pGang],
PlayerInfo[playerid][pGangLeader],
string);
samp_mysql_query(query);
format(query,sizeof(query),"UPDATE `igralci` SET `gBasekey`='%d', `gPack`='%d', `warning`='%d', `placa`='%d', `job`='%d', `jobexp`='%d', `flyingl`='%d', `ftry`='%d', `carl`='%d', `cary`='%d', `gunl`='%d', `taxil`='%d', `tmcar`='%d' WHERE (`ime` = '%s')",
PlayerInfo[playerid][gBasekey],
PlayerInfo[playerid][gPack],
PlayerInfo[playerid][warning],
PlayerInfo[playerid][placa],
PlayerInfo[playerid][job],
PlayerInfo[playerid][jobexp],
PlayerInfo[playerid][flyingl],
PlayerInfo[playerid][ftry],
PlayerInfo[playerid][carl],
PlayerInfo[playerid][cary],
PlayerInfo[playerid][gunl],
PlayerInfo[playerid][taxil],
PlayerInfo[playerid][tmcar],
string);
samp_mysql_query(query);
}
Could someone tell me how would scruture of this query need to look like, that server would'nt lag?


Re: mysql - MenaceX^ - 18.05.2009

There's no way to show you how, you should learn how to set up tables and such..


Re: mysql - insider1 - 18.05.2009

Is there any good tutorial guideance,...?


Re: mysql - FUNExtreme - 18.05.2009

Make your query's smaller. It will decrease lagg but not much