[Pomoc] MySQL Save

Započeo Voltage, Decembar 15, 2011, 14:14:50 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 2 gostiju pregledaju ovu temu.

Skripta koju koristim: 0
Detaljan opis problema: Znaci imam da snima npr. level i napravio sam po primjeru toga da snima posao ali kada se regam nesnima account, a kada obrisem to za posao snima.
Dio skripte: Recite sta vam treba
Neke slike/video za lakse dobivanje pomoci(neobavezno): /



Virtual Reality Roleplay
Register & Login System - Dialog [100%]
Car Dealership System - Dialog [100%]
Trunk System - Dialog [100%]
Fuel, Registarske Oznake, Engine, DMV System [100%]
Animations [100%]
Admin & GameMaster System [100%]
Save Tunning System [100%]
Job System - In Progress [8%]

pa postavi kako si uradio pa cemo ti napraviti...

pInfo

pPosao,

OnPlayerDisconnect

format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, level=%d, posao=%d, vip=%d, kma=%d, rank=%d, kills=%d, deaths=%d, muted=%d, jailed=%d, frozen=%d, mutedtimes=%d, jailedtimes=%d, frozentimes=%d, banned=%d, bannedby='%s', logins=%d, posx=%f, posy=%f, posz=%f, posa=%f  WHERE user='%s'",

PlayerInfo[playerid][pPosao],


MySQL Login

mysql_fetch_field_row(savingstring, "posao"); PlayerInfo[playerid][pPosao] = strval(savingstring);

MySQL Register

format(query, sizeof(query), "INSERT INTO playerdata (user, password, score, money, level, posao, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa, IP) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', 0, 0, 0, 0, 0, '%s')", pname, passwordstring, Bannedby, IP);



Virtual Reality Roleplay
Register & Login System - Dialog [100%]
Car Dealership System - Dialog [100%]
Trunk System - Dialog [100%]
Fuel, Registarske Oznake, Engine, DMV System [100%]
Animations [100%]
Admin & GameMaster System [100%]
Save Tunning System [100%]
Job System - In Progress [8%]