Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: Voltage poslato Decembar 15, 2011, 14:14:50 POSLE PODNE

Naslov: [Pomoc] MySQL Save
Poruka od: Voltage poslato Decembar 15, 2011, 14:14:50 POSLE PODNE
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): /
Naslov: Odg: [Pomoc] MySQL Save
Poruka od: [TG:RP]$--L84S--$ poslato Decembar 15, 2011, 18:29:48 POSLE PODNE
pa postavi kako si uradio pa cemo ti napraviti...
Naslov: Odg: [Pomoc] MySQL Save
Poruka od: Voltage poslato Decembar 15, 2011, 18:37:06 POSLE PODNE
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);