1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive

Threaded Mode
[MYSQL] Failed To Exeute Query[Help]
bkart
Little Clucker
**
Posts: 35
Threads: 8
Joined: Jun 2009
Reputation: 0
#1

20.03.2011, 22:24
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.
I want to learn:
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..
Find
Reply
WackoX
Huge Clucker
****
Posts: 374
Threads: 11
Joined: Feb 2011
Reputation: 0
#2

20.03.2011, 22:56
Post the query, we're not wizards.
Find
Reply
bkart
Little Clucker
**
Posts: 35
Threads: 8
Joined: Jun 2009
Reputation: 0
#3

21.03.2011, 05:12
( Последний раз редактировалось bkart; 21.03.2011 в 13:51. )
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);
	   }
	}
And My Register Query:
Код:
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;
}
Edit:Query Updated.
Find
Reply
THE_KNOWN
Gangsta
****
Posts: 702
Threads: 94
Joined: Dec 2010
Reputation: 0
#4

21.03.2011, 09:13
omsfg thats big. anyway show the query (formatting part). i think you have a problem near the name ('%' perhaps?)
Find
Reply
bkart
Little Clucker
**
Posts: 35
Threads: 8
Joined: Jun 2009
Reputation: 0
#5

21.03.2011, 13:55
( Последний раз редактировалось bkart; 21.03.2011 в 15:27. )
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?)
But this is Login query.
Find
Reply
bkart
Little Clucker
**
Posts: 35
Threads: 8
Joined: Jun 2009
Reputation: 0
#6

21.03.2011, 19:13
Problem Solved.Thanks.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help
  4. Help Archive