MySQL Problem (again) - 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)
+--- Thread: MySQL Problem (again) (/showthread.php?tid=507525)
+- 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)
+--- Thread: MySQL Problem (again) (/showthread.php?tid=507525)
MySQL Problem (again) - AiRaLoKa - 18.04.2014
hi all...
i got a problem with mysql
all of the players info is loaded, but some info won't save...
strings that won't save is "pPUH" and "dunno"
thhis is my MySQL Login stock
Код:
stock MySQL_Login(playerid)
{
new Query[800], dunno;
format(Query, sizeof(Query), "SELECT * FROM `PlayerData` WHERE Username = '%s'", pName(playerid));
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Query, "|");
//sscanf(Query, "e<p<|>s[24]s[128]iiiiii",pInfo[playerid]);
sscanf(Query, "p<|>s[24]s[128]iiiiiiiiiiiiii",
pInfo[playerid][pUsername],
pInfo[playerid][pPassword],
pInfo[playerid][pLanguage],
pInfo[playerid][pSkin],
pInfo[playerid][pGodmode],
AutoRepair[playerid],
pInfo[playerid][pMoney],
pInfo[playerid][pAdminLevel],
pInfo[playerid][pVipLevel],
pInfo[playerid][pHour],
pInfo[playerid][pMin],
pInfo[playerid][pSec],
pInfo[playerid][pKills],
pInfo[playerid][pDeaths],
pInfo[playerid][pPUH],
dunno);
printf("%s",Query);
pInfo[playerid][pLogged] = 1;
CheckBan(playerid);
SetPlayerSkin(playerid, pInfo[playerid][pSkin]);
SetPlayerScore(playerid, dunno);
playedtimer[playerid] = SetTimerEx("TimeOnServer", 1000, 1, "i", playerid);
new Float:kd = floatdiv(pInfo[playerid][pKills], pInfo[playerid][pDeaths]);
new str1[300],str2[300];
format(str1,sizeof(str1),"User Name %s\nKill Deah Ratio %0.2f (KDR)\nPlayed for %i Hours %i Mins %i Secs\nMoney %i\nAdmin Level %i\nVip Level %i\nWarnings %i\nKill %i\nDeaths %i\nPickup Found %i",
pName(playerid),kd,pInfo[playerid][pHour],pInfo[playerid][pMin],pInfo[playerid][pSec],pInfo[playerid][pMoney],pInfo[playerid][pAdminLevel],pInfo[playerid][pVipLevel],pInfo[playerid][pWarnings],pInfo[playerid][pKills],pInfo[playerid][pDeaths],pInfo[playerid][pPUH]);
format(str1,sizeof(str1),"Nama Pengguna %s\nKill Deah Rasio %0.2f (KDR)\nBermain selama %i Jam %i Menit %i Detik\nCash %i\nLevel Admin %i\nLevel Vip %i\nPeringatan %i\nMati %i\nMembunuh %i\nMenemukan Pickup %i",
pName(playerid),kd,pInfo[playerid][pHour],pInfo[playerid][pMin],pInfo[playerid][pSec],pInfo[playerid][pMoney],pInfo[playerid][pAdminLevel],pInfo[playerid][pVipLevel],pInfo[playerid][pWarnings],pInfo[playerid][pKills],pInfo[playerid][pDeaths],pInfo[playerid][pPUH]);
ShowPlayerDialogLang(playerid, DIALOG_STATISTIC, DIALOG_STYLE_MSGBOX, "Stats","Statistik", str1, str2, "Play","Main","","");
PlayerLang[playerid] = pInfo[playerid][pLanguage];
mysql_free_result();
return 1;
}
Re: MySQL Problem (again) - AiRaLoKa - 18.04.2014
bump!
anyone?
i need your help as soon as possible
Re: MySQL Problem (again) - nmader - 18.04.2014
I would try to help; however I prefer to format it in a string, it is much more legible.
Re: MySQL Problem (again) - AiRaLoKa - 18.04.2014
Fixed....
thanks to nmader for the sugestion
i changed it into mysql_fetch_field_row(). It take so much time and annoying...
here is the new script
Код:
stock MySQL_Login(playerid)
{
new Query[800],savestr[50];
format(Query, sizeof(Query), "SELECT * FROM `PlayerData` WHERE Username = '%s'", pName(playerid));
mysql_query(Query);
mysql_store_result();
while(mysql_fetch_row_format(Query, "|"))
{
//sscanf(Query, "e<p<|>s[24]s[128]iiiiii",pInfo[playerid]);
sscanf(Query, "p<|>s[24]s[128]",
pInfo[playerid][pUsername],
pInfo[playerid][pPassword]);
mysql_fetch_field_row(savestr, "pLanguage"); pInfo[playerid][pLanguage] = strval(savestr);
mysql_fetch_field_row(savestr, "pSkin"); pInfo[playerid][pSkin] = strval(savestr);
mysql_fetch_field_row(savestr, "pGodmode"); pInfo[playerid][pGodmode] = strval(savestr);
mysql_fetch_field_row(savestr, "pAutoR"); AutoRepair[playerid] = strval(savestr);
mysql_fetch_field_row(savestr, "pMoney"); pInfo[playerid][pMoney] = strval(savestr);
mysql_fetch_field_row(savestr, "pAdminLevel"); pInfo[playerid][pAdminLevel] = strval(savestr);
mysql_fetch_field_row(savestr, "pVipLevel"); pInfo[playerid][pVipLevel] = strval(savestr);
mysql_fetch_field_row(savestr, "pHour"); pInfo[playerid][pHour] = strval(savestr);
mysql_fetch_field_row(savestr, "pMin"); pInfo[playerid][pMin] = strval(savestr);
mysql_fetch_field_row(savestr, "pSec"); pInfo[playerid][pSec] = strval(savestr);
mysql_fetch_field_row(savestr, "pKills"); pInfo[playerid][pKills] = strval(savestr);
mysql_fetch_field_row(savestr, "pDeaths"); pInfo[playerid][pDeaths] = strval(savestr);
mysql_fetch_field_row(savestr, "pPUH"); pInfo[playerid][pPUH] = strval(savestr);
mysql_fetch_field_row(savestr, "pScore"); pInfo[playerid][pScore] = strval(savestr); SetPlayerScore(playerid, pInfo[playerid][pScore]);
pInfo[playerid][pLogged] = 1;
CheckBan(playerid);
SetPlayerSkin(playerid, pInfo[playerid][pSkin]);
playedtimer[playerid] = SetTimerEx("TimeOnServer", 1000, 1, "i", playerid);
new Float:kd = floatdiv(pInfo[playerid][pKills], pInfo[playerid][pDeaths]);
new str1[300],str2[300];
format(str1,sizeof(str1),"User Name %s\nKill Deah Ratio %0.2f (KDR)\nPlayed for %i Hours %i Mins %i Secs\nMoney %i\nAdmin Level %i\nVip Level %i\nWarnings %i\nKill %i\nDeaths %i\nPickup Found %i",
pName(playerid),kd,pInfo[playerid][pHour],pInfo[playerid][pMin],pInfo[playerid][pSec],pInfo[playerid][pMoney],pInfo[playerid][pAdminLevel],pInfo[playerid][pVipLevel],pInfo[playerid][pWarnings],pInfo[playerid][pKills],pInfo[playerid][pDeaths],pInfo[playerid][pPUH]);
format(str1,sizeof(str1),"Nama Pengguna %s\nKill Deah Rasio %0.2f (KDR)\nBermain selama %i Jam %i Menit %i Detik\nCash %i\nLevel Admin %i\nLevel Vip %i\nPeringatan %i\nMati %i\nMembunuh %i\nMenemukan Pickup %i",
pName(playerid),kd,pInfo[playerid][pHour],pInfo[playerid][pMin],pInfo[playerid][pSec],pInfo[playerid][pMoney],pInfo[playerid][pAdminLevel],pInfo[playerid][pVipLevel],pInfo[playerid][pWarnings],pInfo[playerid][pKills],pInfo[playerid][pDeaths],pInfo[playerid][pPUH]);
PlayerLang[playerid] = pInfo[playerid][pLanguage];
ShowPlayerDialogLang(playerid, DIALOG_STATISTIC, DIALOG_STYLE_MSGBOX, "Stats","Statistik", str1, str2, "Play","Main","","");
}
mysql_free_result();
return 1;
}