[MYSQL] Failed To Exeute Query[Help] - 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] Failed To Exeute Query[Help] (/showthread.php?tid=242932)
+- 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] Failed To Exeute Query[Help] (/showthread.php?tid=242932)
[MYSQL] Failed To Exeute Query[Help] - bkart - 20.03.2011
Hi,
My gamemode have a restart problem.I looked server_log.txt but I don't see problem.But I looked mysql_log.txt I saw the following errors:
Код:
[Sun Mar 20 20:00:14 2011] MySQL Server Version 5.0.77. [Sun Mar 20 20:01:12 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:03:44 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Fernando_Ramir' at line 1. [Sun Mar 20 20:03:44 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Fernando_Ramir' at line 1. [Sun Mar 20 20:03:47 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:03:47 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:04:31 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:06:04 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domin' at line 1. [Sun Mar 20 20:06:04 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domin' at line 1. [Sun Mar 20 20:07:50 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:08:35 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:08:35 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:12:08 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:12:38 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:12:38 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:20:45 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:22:02 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:22:02 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:23:19 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Leanton_Mont' at line 1. [Sun Mar 20 20:23:19 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Leanton_Mont' at line 1. [Sun Mar 20 20:40:14 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:41:25 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:41:25 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:47:24 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:48:00 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:48:00 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:52:34 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 20:53:03 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 20:53:03 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:00:39 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:39 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:45 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:45 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:45 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:50 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:51 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:00:51 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:01:23 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:01:23 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:01:23 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_King' at line 1. [Sun Mar 20 21:01:26 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 21:03:20 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:03:20 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:20:46 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_Kingsto' at line 1. [Sun Mar 20 21:20:46 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Tyrone_Kingsto' at line 1. [Sun Mar 20 21:25:11 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Leanton_Montford' at line 1. [Sun Mar 20 21:25:11 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Leanton_Montford' at line 1. [Sun Mar 20 21:30:09 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 21:31:12 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:31:12 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:53:07 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 21:54:54 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:54:54 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 21:58:20 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Dare' at line 1. [Sun Mar 20 21:58:20 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Dare' at line 1. [Sun Mar 20 21:59:24 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Dares' at line 1. [Sun Mar 20 21:59:24 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Dares' at line 1. [Sun Mar 20 22:01:15 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Darest' at line 1. [Sun Mar 20 22:01:15 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Isaiah_Darest' at line 1. [Sun Mar 20 22:05:42 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Fernando_Ramire' at line 1. [Sun Mar 20 22:05:42 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Fernando_Ramire' at line 1. [Sun Mar 20 22:33:41 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1. [Sun Mar 20 22:34:28 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 22:34:28 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Domi' at line 1. [Sun Mar 20 23:01:16 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Dominic_Pearc' at line 1.
1- Cause of the reset problem ?
2- Is it important ?
3- How can I fix the problem?
Thank you in advance.Waiting your answers&idea..
Re: [MYSQL] Failed To Exeute Query[Help] - WackoX - 20.03.2011
Post the query, we're not wizards.
Re: [MYSQL] Failed To Exeute Query[Help] - bkart - 21.03.2011
Ok,Sorry:
My Login Query:
Код:
public OnPlayerLogin(playerid,password[])
{
MySQL_BaglantiKontrol();
new Query[200], Pname[24], escpname[24]; //Creates the Query string and the Pname
GetPlayerName(playerid, Pname, 24); //Gets the players name
mysql_real_escape_string(Pname, escpname); //escapes the string so you cant MySQL inject
format(Query, sizeof(Query), "SELECT * FROM users WHERE username='%s' AND Sifre='%s'", escpname, password);
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows())
{
SendClientMessage(playerid, COLOR_HATA,"(( HATA: Hatali sifre girdiniz, tekrar deneyiniz ))");
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_INPUT , "Giris Yap", "Devam etmek icin lutfen giris yapiniz.", "Giris", "Iptal");
return 1;
}
else
{
new line[600];
if(mysql_fetch_row(line))
{
new d[14][24];
new d2[96];
new Float: d3[10];
sscanf(line, "p<|>ds[24]s[24]ddddddddddddddfffddddfdddddddddddddddddddddffffffddddddddddddddddddddddddds[64]s[64]s[64]s[64]s[64]s[64]ddddds[30]s[30]s[30]s[30]s[30]s[30]ddddddddddddddddddddddddd",
d2[0], d[0], d[1],d2[1], d2[2], d2[3], d2[4], d2[5], d2[6], d2[7], d2[8], d2[9], d2[10], d2[11], d2[12], d2[13], d2[14],
d3[0], d3[1], d3[2], d2[15], d2[16], d2[17],
d2[18], d3[3],d2[19],d2[20],d2[21],d2[22],d2[23],d2[24],d2[25],d2[26],d2[27],d2[28],d2[29],d2[30],d2[31],d2[32],d2[33],d2[34],d2[35],d2[36],d2[37],d2[38],d2[39],d3[4],d3[5],d3[6],d3[7],d3[8],d3[9],d2[40],
d2[41],d2[42],d2[43],d2[44],d2[45],d2[46],d2[47],d2[48],d2[49],d2[50],d2[51],d2[52],d2[53],d2[54],d2[55],d2[56],d2[57],d2[58],d2[59],d2[60],
d2[61],d2[62],d2[63],d2[64],d[2],d[3],d[4],d[5],d[6],d[7],d2[65],d2[66],d2[67],d2[68],d2[69],d[8],d[9],d[10],d[11],d[12],d[13],d2[70],d2[71],d2[72],
d2[73],d2[74],d2[75],d2[76],d2[77],d2[78],d2[79],d2[80],d2[81],d2[82],d2[83],d2[84],d2[85],d2[86],d2[87],d2[88],d2[89],d2[90],d2[91],d2[92],d2[93],d2[94]);
PlayerInfo[playerid][pSQLID] = d2[0];
PlayerInfo[playerid][pLevel] = d2[1];
PlayerInfo[playerid][pAdmin] = d2[2];
PlayerInfo[playerid][pPara] = d2[3];
PlayerInfo[playerid][pLocked] = d2[4];
PlayerInfo[playerid][pSustur] = d2[5];
PlayerInfo[playerid][pVatNo] = d2[6];
PlayerInfo[playerid][pExp] = d2[7];
PlayerInfo[playerid][pOyunSaati] = d2[8];
PlayerInfo[playerid][pSkin] = d2[9];
PlayerInfo[playerid][pMobile] = d2[10];
PlayerInfo[playerid][pKontorum] = d2[11];
PlayerInfo[playerid][pSkin2] = d2[12];
PlayerInfo[playerid][pSkin3] = d2[13];
PlayerInfo[playerid][pSkinSecim] = d2[14];
PlayerInfo[playerid][pPos_x] = d3[0];
PlayerInfo[playerid][pPos_y] = d3[1];
PlayerInfo[playerid][pPos_z] = d3[2];
PlayerInfo[playerid][pInterior] = d2[15];
PlayerInfo[playerid][pVWorld] = d2[16];
PlayerInfo[playerid][pBankaPara] = d2[17];
PlayerInfo[playerid][pHesapNo] = d2[18];
PlayerInfo[playerid][pHealth] = d3[3];
PlayerInfo[playerid][pIlkGiris] = d2[19];
PlayerInfo[playerid][pUlke] = d2[20];
PlayerInfo[playerid][pYas] = d2[21];
PlayerInfo[playerid][pCinsiyet] = d2[22];
PlayerInfo[playerid][pTelsiz] = d2[23];
PlayerInfo[playerid][pFrekans] = d2[24];
PlayerInfo[playerid][pAraba1] = d2[25];
PlayerInfo[playerid][pAraba2] = d2[26];
PlayerInfo[playerid][pAraba3] = d2[27];
PlayerInfo[playerid][pAraba4] = d2[28];
PlayerInfo[playerid][pAraba5] = d2[29];
PlayerInfo[playerid][pYedekAnahtar] = d2[30];
PlayerInfo[playerid][pEhliyet] = d2[31];
PlayerInfo[playerid][pTemizRaporu] = d2[32];
PlayerInfo[playerid][pMeslek1] = d2[33];
PlayerInfo[playerid][pMeslek2] = d2[34];
PlayerInfo[playerid][pEvrak] = d2[35];
PlayerInfo[playerid][pKiraSure] = d2[36];
PlayerInfo[playerid][pKiraAnahtar] = d2[37];
PlayerInfo[playerid][pAmodel] = d2[38];
PlayerInfo[playerid][pAbone] = d2[39];
PlayerInfo[playerid][pAfX] = d3[4];
PlayerInfo[playerid][pAfY] = d3[5];
PlayerInfo[playerid][pAfZ] = d3[6];
PlayerInfo[playerid][pAfRotX] = d3[7];
PlayerInfo[playerid][pAfRotY] = d3[8];
PlayerInfo[playerid][pAfRotZ] = d3[9];
PlayerInfo[playerid][pEvAnahtari] = d2[40];
EvGiris[playerid] = d2[41];
PlayerInfo[playerid][pStil1] = d2[42];
PlayerInfo[playerid][pStil2] = d2[43];
PlayerInfo[playerid][pStil3] = d2[44];
PlayerInfo[playerid][pStil4] = d2[45];
PlayerInfo[playerid][pStil5] = d2[46];
PlayerInfo[playerid][pDukkanAnahtari] = d2[47];
DukkanGiris[playerid] = d2[48];
PlayerInfo[playerid][pBalikYemi] = d2[49];
PlayerInfo[playerid][pOlta] = d2[50];
PlayerInfo[playerid][pBalik1] = d2[51];
PlayerInfo[playerid][pBalik2] = d2[52];
PlayerInfo[playerid][pBalik3] = d2[53];
PlayerInfo[playerid][pBalik4] = d2[54];
PlayerInfo[playerid][pBalik5] = d2[55];
PlayerInfo[playerid][pBalik6] = d2[56];
PlayerInfo[playerid][pBalik7] = d2[57];
PlayerInfo[playerid][pBalik8] = d2[58];
PlayerInfo[playerid][pAcikmak] = d2[59];
PlayerInfo[playerid][pSusamak] = d2[60];
PlayerInfo[playerid][pIsDergisi] = d2[61];
PlayerInfo[playerid][pJeton] = d2[62];
PlayerInfo[playerid][pCakmak] = d2[63];
PlayerInfo[playerid][pSigara] = d2[64];
strmid(PlayerInfo[playerid][pDovme1], d[2], 0, strlen(d[2]), 255);
strmid(PlayerInfo[playerid][pDovme2], d[3], 0, strlen(d[3]), 255);
strmid(PlayerInfo[playerid][pDovme3], d[4], 0, strlen(d[4]), 255);
strmid(PlayerInfo[playerid][pDovme4], d[5], 0, strlen(d[5]), 255);
strmid(PlayerInfo[playerid][pDovme5], d[6], 0, strlen(d[6]), 255);
strmid(PlayerInfo[playerid][pDovme6], d[7], 0, strlen(d[7]), 255);
PlayerInfo[playerid][pHangiInt] = d2[65];
PlayerInfo[playerid][pMember] = d2[66];
PlayerInfo[playerid][pLeader] = d2[67];
PlayerInfo[playerid][pRutbe] = d2[68];
PlayerInfo[playerid][pYedekBenzin] = d2[69];
strmid(PlayerInfo[playerid][pRehberIsim1], d[8], 0, strlen(d[8]), 255);
strmid(PlayerInfo[playerid][pRehberIsim2], d[9], 0, strlen(d[9]), 255);
strmid(PlayerInfo[playerid][pRehberIsim3], d[10], 0, strlen(d[10]), 255);
strmid(PlayerInfo[playerid][pRehberIsim4], d[11], 0, strlen(d[11]), 255);
strmid(PlayerInfo[playerid][pRehberIsim5], d[12], 0, strlen(d[12]), 255);
strmid(PlayerInfo[playerid][pRehberIsim6], d[13], 0, strlen(d[13]), 255);
PlayerInfo[playerid][pNumara1] = d2[70];
PlayerInfo[playerid][pNumara2] = d2[71];
PlayerInfo[playerid][pNumara3] = d2[72];
PlayerInfo[playerid][pNumara4] = d2[73];
PlayerInfo[playerid][pNumara5] = d2[74];
PlayerInfo[playerid][pNumara6] = d2[75];
PlayerInfo[playerid][pSilahlarim] = d2[76];
PlayerInfo[playerid][pSilahlarim2] = d2[77];
PlayerInfo[playerid][pSilahlarim3] = d2[78];
PlayerInfo[playerid][pSilahlarim4] = d2[79];
PlayerInfo[playerid][pSilahlarim5] = d2[80];
PlayerInfo[playerid][pMermilerim] = d2[81];
PlayerInfo[playerid][pMermilerim2] = d2[82];
PlayerInfo[playerid][pMermilerim3] = d2[83];
PlayerInfo[playerid][pMermilerim4] = d2[84];
PlayerInfo[playerid][pMermilerim5] = d2[85];
PlayerInfo[playerid][pHapisSure] = d2[86];
PlayerInfo[playerid][pCantam] = d2[87];
PlayerInfo[playerid][pSopa] = d2[88];
PlayerInfo[playerid][pMusta] = d2[89];
PlayerInfo[playerid][pSpraycan] = d2[90];
PlayerInfo[playerid][pBilardo] = d2[91];
PlayerInfo[playerid][pBicak] = d2[92];
PlayerInfo[playerid][pHapis] = d2[93];
PlayerInfo[playerid][pZar] = d2[94];
mysql_free_result();
strmid(PlayerInfo[playerid][pSifre], password, 0, strlen(password), 255);
}
}
Код:
public KarakterKaydet(playerid)
{
if(GirisYapti[playerid])
{
new query[2000];
new pname[24]; GetPlayerName(playerid,pname,24);
new Float:x,Float:y,Float:z,inte,vw;
new Float:can;
GetPlayerHealth(playerid,can);
GetPlayerPos(playerid,x,y,z);
inte = GetPlayerInterior(playerid);
vw = GetPlayerVirtualWorld(playerid);
format(query,sizeof(query),"UPDATE `users` SET \
`Sifre`='%s',\
`Level`='%d',\
`Para`='%d',\
`Locked`='%d',\
`Sustur`='%d',\
`VatNo`='%d',\
`Exp`='%d',\
`OyunSaati`='%d',\
`Skin`='%d',\
`Mobile`='%d',\
`Kontorum`='%d',\
`Skin2`='%d',\
`Skin3`='%d',\
`SkinSecim`='%d',\
`PosX`='%f',\
`PosY`='%f',\
`PosZ`='%f',\
`Interior`='%d',\
`VirWorld`='%d',\
`BPara`='%d',\
`HesapNo`='%d',\
`Health`='%f',\
`IlkGiris`='%d',\
`Ulke`='%d',\
`Yas`='%d',\
`Cinsiyet`='%d', \
`Telsiz`='%d', \
`Frekans`='%d',",
PlayerInfo[playerid][pSifre],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pPara],
PlayerInfo[playerid][pLocked],
PlayerInfo[playerid][pSustur],
PlayerInfo[playerid][pVatNo],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pOyunSaati],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pMobile],
PlayerInfo[playerid][pKontorum],
PlayerInfo[playerid][pSkin2],
PlayerInfo[playerid][pSkin3],
PlayerInfo[playerid][pSkinSecim],
x,
y,
z,
inte,
vw,
PlayerInfo[playerid][pBankaPara],
PlayerInfo[playerid][pHesapNo],
can,
PlayerInfo[playerid][pIlkGiris],
PlayerInfo[playerid][pUlke],
PlayerInfo[playerid][pYas],
PlayerInfo[playerid][pCinsiyet],
PlayerInfo[playerid][pTelsiz],
PlayerInfo[playerid][pFrekans]);
format(query,sizeof(query),"%s `Araba1`='%d', \
`Araba2`='%d', \
`Araba3`='%d', \
`Araba4`='%d', \
`Araba5`='%d', \
`YedekAnahtar`='%d', \
`Ehliyet`='%d', \
`TemizRaporu`='%d', \
`Meslek1`='%d', \
`Meslek2`='%d', \
`Evrak`='%d', \
`KiraSure`='%d', \
`KiraAnahtar`='%d', \
`AModel`='%d', \
`ABone`='%d', \
`AfX`='%f', \
`AfY`='%f', \
`AfZ`='%f', \
`ARotX`='%f', \
`ARotY`='%f', \
`ARotZ`='%f', \
`EvAnahtari`='%d', \
`EvGiris`='%d', \
`Stil1`='%d', \
`Stil2`='%d', \
`Stil3`='%d',",
query,
PlayerInfo[playerid][pAraba1],
PlayerInfo[playerid][pAraba2],
PlayerInfo[playerid][pAraba3],
PlayerInfo[playerid][pAraba4],
PlayerInfo[playerid][pAraba5],
PlayerInfo[playerid][pYedekAnahtar],
PlayerInfo[playerid][pEhliyet],
PlayerInfo[playerid][pTemizRaporu],
PlayerInfo[playerid][pMeslek1],
PlayerInfo[playerid][pMeslek2],
PlayerInfo[playerid][pEvrak],
PlayerInfo[playerid][pKiraSure],
PlayerInfo[playerid][pKiraAnahtar],
PlayerInfo[playerid][pAmodel],
PlayerInfo[playerid][pAbone],
PlayerInfo[playerid][pAfX],
PlayerInfo[playerid][pAfY],
PlayerInfo[playerid][pAfZ],
PlayerInfo[playerid][pAfRotX],
PlayerInfo[playerid][pAfRotY],
PlayerInfo[playerid][pAfRotZ],
PlayerInfo[playerid][pEvAnahtari],
EvGiris[playerid],
PlayerInfo[playerid][pStil1],
PlayerInfo[playerid][pStil2],
PlayerInfo[playerid][pStil3]);
format(query,sizeof(query),"%s `Stil4`='%d', \
`Stil5`='%d', \
`DukkanAnahtari`='%d', \
`DukkanGiris`='%d', \
`BalikYemi`='%d', \
`Olta`='%d', \
`Balik1`='%d', \
`Balik2`='%d', \
`Balik3`='%d', \
`Balik4`='%d', \
`Balik5`='%d', \
`Balik6`='%d', \
`Balik7`='%d', \
`Balik8`='%d', \
`Acikma`='%d', \
`Susama`='%d', \
`IsDergisi`='%d', \
`Jeton`='%d', \
`Cakmak`='%d', \
`Sigara`='%d', \
`Dovme1`='%s', \
`Dovme2`='%s', \
`Dovme3`='%s', \
`Dovme4`='%s', \
`Dovme5`='%s', \
`Dovme6`='%s', \
`HangiInt`='%d',",
query,
PlayerInfo[playerid][pStil4],
PlayerInfo[playerid][pStil5],
PlayerInfo[playerid][pDukkanAnahtari],
DukkanGiris[playerid],
PlayerInfo[playerid][pBalikYemi],
PlayerInfo[playerid][pOlta],
PlayerInfo[playerid][pBalik1],
PlayerInfo[playerid][pBalik2],
PlayerInfo[playerid][pBalik3],
PlayerInfo[playerid][pBalik4],
PlayerInfo[playerid][pBalik5],
PlayerInfo[playerid][pBalik6],
PlayerInfo[playerid][pBalik7],
PlayerInfo[playerid][pBalik8],
PlayerInfo[playerid][pAcikmak],
PlayerInfo[playerid][pSusamak],
PlayerInfo[playerid][pIsDergisi],
PlayerInfo[playerid][pJeton],
PlayerInfo[playerid][pCakmak],
PlayerInfo[playerid][pSigara],
PlayerInfo[playerid][pDovme1],
PlayerInfo[playerid][pDovme2],
PlayerInfo[playerid][pDovme3],
PlayerInfo[playerid][pDovme4],
PlayerInfo[playerid][pDovme5],
PlayerInfo[playerid][pDovme6],
PlayerInfo[playerid][pHangiInt]);
format(query,sizeof(query),"%s \
`Member`='%d', \
`Leader`='%d', \
`Rutbe`='%d', \
`YedekBenzin`='%d', \
`RehberIsim1`='%s', \
`RehberIsim2`='%s', \
`RehberIsim3`='%s', \
`RehberIsim4`='%s', \
`RehberIsim5`='%s', \
`RehberIsim6`='%s', \
`Numara1`='%d', \
`Numara2`='%d', \
`Numara3`='%d', \
`Numara4`='%d', \
`Numara5`='%d', \
`Numara6`='%d',",
query,
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pRutbe],
PlayerInfo[playerid][pYedekBenzin],
PlayerInfo[playerid][pRehberIsim1],
PlayerInfo[playerid][pRehberIsim2],
PlayerInfo[playerid][pRehberIsim3],
PlayerInfo[playerid][pRehberIsim4],
PlayerInfo[playerid][pRehberIsim5],
PlayerInfo[playerid][pRehberIsim6],
PlayerInfo[playerid][pNumara1],
PlayerInfo[playerid][pNumara2],
PlayerInfo[playerid][pNumara3],
PlayerInfo[playerid][pNumara4],
PlayerInfo[playerid][pNumara5],
PlayerInfo[playerid][pNumara6]);
format(query,sizeof(query),"%s \
`Silahlarim`='%d', \
`Silahlarim2`='%d', \
`Silahlarim3`='%d', \
`Silahlarim4`='%d', \
`Silahlarim5`='%d', \
`Mermilerim`='%d', \
`Mermilerim2`='%d', \
`Mermilerim3`='%d', \
`Mermilerim4`='%d', \
`Mermilerim5`='%d', \
`HapisSure`='%d', \
`Cantam`='%d', \
`Sopa`='%d', \
`Musta`='%d', \
`Spraycan`='%d', \
`Bilardo`='%d', \
`Bicak`='%d', \
`Hapis`='%d', \
`Zar`='%d' WHERE `username`='%s'",
query,
PlayerInfo[playerid][pSilahlarim],
PlayerInfo[playerid][pSilahlarim2],
PlayerInfo[playerid][pSilahlarim3],
PlayerInfo[playerid][pSilahlarim4],
PlayerInfo[playerid][pSilahlarim5],
PlayerInfo[playerid][pMermilerim],
PlayerInfo[playerid][pMermilerim2],
PlayerInfo[playerid][pMermilerim3],
PlayerInfo[playerid][pMermilerim4],
PlayerInfo[playerid][pMermilerim5],
PlayerInfo[playerid][pHapisSure],
PlayerInfo[playerid][pCantam],
PlayerInfo[playerid][pSopa],
PlayerInfo[playerid][pMusta],
PlayerInfo[playerid][pSpraycan],
PlayerInfo[playerid][pBilardo],
PlayerInfo[playerid][pBicak],
PlayerInfo[playerid][pHapis],
PlayerInfo[playerid][pZar],
pname);
mysql_query(query);
mysql_free_result();
}
return 1;
}
Re: [MYSQL] Failed To Exeute Query[Help] - THE_KNOWN - 21.03.2011
omsfg thats big. anyway show the query (formatting part). i think you have a problem near the name ('%' perhaps?)
Re: [MYSQL] Failed To Exeute Query[Help] - bkart - 21.03.2011
Quote:
|
Originally Posted by THE_KNOWN
 omsfg thats big. anyway show the query (formatting part). i think you have a problem near the name ('%' perhaps?)
|
Re: [MYSQL] Failed To Exeute Query[Help] - bkart - 21.03.2011
Problem Solved.Thanks.