21.03.2011, 05:12
(
Последний раз редактировалось bkart; 21.03.2011 в 13:51.
)
Ok,Sorry:
My Login Query:
And My Register Query:
Edit:Query Updated.
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; }