Balkan SA:MP

Skripta koju koristim: Moja od 0
Detaljan opis problema: Pa zapoceo sam reg/log sis na SQL i napravio sam sve ali zavrsnica me zeza, nece da mi spremi u bazu kad se registrujem
SavePlayer(playerid)
{
new Query[2506],name[ MAX_PLAYER_NAME ],ip[ 16 ];
GetPlayerName(playerid, name, sizeof(name)); GetPlayerIp(playerid, ip, sizeof(ip));

format(Query, sizeof(Query), "INSERT INTO `saKorisnici` (`saNick`, `saSifra`, `saIP`, `saEmail`, `saLevel`, `saNovac`,`saAdminLvl`, `saSpol`, `saGodine`,`saRegistrovan`) VALUES('%s','%s','%s','%s', '%d','%d','%d','%d','%d')", DB_Escape(name), SNInfo[playerid][saPass], DB_Escape(ip),SNInfo[playerid][saEmail], SNInfo[playerid][saLevel], SNInfo[playerid][saNovac],SNInfo[playerid][saAdmLvl],SNInfo[playerid][saSpol],SNInfo[playerid][saGodine],SNInfo[playerid][saRegistrovan]);
db_query(gwrp, Query);

format(Query, sizeof(Query), "INSERT INTO `saKorisnici` (`saSkin`,`saPorijeklo`,`saPocetniTut`,`saLastLogin`,`saSpawn`) VALUES('%d','%d','%d','%s','%d')", SNInfo[playerid][saSkin],SNInfo[playerid][saPorijeklo],SNInfo[playerid][saPocetniTut],SNInfo[playerid][saLastLogin],SNInfo[playerid][saSpawn]);
db_query(gwrp, Query);

return true;
}
Dio skripte:
Neke slike/video za lakse dobivanje pomoci(neobavezno):

Gde ti je UPDATE?

Citat: Dobrica poslato Jul 31, 2017, 17:50:35 POSLE PODNE
Gde ti je UPDATE?

gdje trebam update staviti?

Evo kako mi sad spremi sredio sam da sprema ali ovako mi spremi

http://imgur.com/a/HZOy4

Prvenstveno cu ti dati primer kako da radis save, ovako kako si ti poceo nikad ti ni nece spremati kako valja.

Tvoje je ovako..


SavePlayer(playerid)
{
new Query[2506],name[ MAX_PLAYER_NAME ],ip[ 16 ];
GetPlayerName(playerid, name, sizeof(name)); GetPlayerIp(playerid, ip, sizeof(ip));

format(Query, sizeof(Query), "INSERT INTO `saKorisnici` (`saNick`, `saSifra`, `saIP`, `saEmail`, `saLevel`, `saNovac`,`saAdminLvl`, `saSpol`, `saGodine`,`saRegistrovan`) VALUES('%s','%s','%s','%s', '%d','%d','%d','%d','%d')", DB_Escape(name), SNInfo[playerid][saPass], DB_Escape(ip),SNInfo[playerid][saEmail], SNInfo[playerid][saLevel], SNInfo[playerid][saNovac],SNInfo[playerid][saAdmLvl],SNInfo[playerid][saSpol],SNInfo[playerid][saGodine],SNInfo[playerid][saRegistrovan]);
db_query(gwrp, Query);

format(Query, sizeof(Query), "INSERT INTO `saKorisnici` (`saSkin`,`saPorijeklo`,`saPocetniTut`,`saLastLogin`,`saSpawn`) VALUES('%d','%d','%d','%s','%d')", SNInfo[playerid][saSkin],SNInfo[playerid][saPorijeklo],SNInfo[playerid][saPocetniTut],SNInfo[playerid][saLastLogin],SNInfo[playerid][saSpawn]);
db_query(gwrp, Query);

return true;
}

A treba ovako..


SavePlayer(playerid)
{
new Query[2506],name[ MAX_PLAYER_NAME ],ip[ 16 ];
GetPlayerName(playerid, name, sizeof(name)); GetPlayerIp(playerid, ip, sizeof(ip));

    format(Query,charsmax(Query),"`saSifra`='%e', `saIP`='%e', `saEmail`='%e', `saLevel`='%i', `saNovac`='%i', `saAdminLvl`='%i', `saSpol`='%i', `saGodine`='%i', `saRegistrovan`='%i', `saSkin`='%i', `saPorijeklo`='%i',`saPocetniTut`='%i', `saLastLogin`='%e', `saSpawn`='%i'",
SNInfo[playerid][saPass], DB_Escape(ip),SNInfo[playerid][saEmail], SNInfo[playerid][saLevel], SNInfo[playerid][saNovac],SNInfo[playerid][saAdmLvl],
SNInfo[playerid][saSpol],SNInfo[playerid][saGodine],SNInfo[playerid][saRegistrovan],
SNInfo[playerid][saSkin],SNInfo[playerid][saPorijeklo],SNInfo[playerid][saPocetniTut],SNInfo[playerid][saLastLogin],SNInfo[playerid][saSpawn]);

format(Query,charsmax(Query),"UPDATE `saKorisnici` SET %s WHERE `saNick`='%s'",Query,DB_Escape(name));
db_query(gwrp,Query);
return true;
}


@Dobrica ovdje se radi o registraciji, šta ćeš updejtovati ako nemaš usera u bazi??

Citat: MEDO poslato Jul 31, 2017, 20:07:10 POSLE PODNE
@Dobrica ovdje se radi o registraciji, šta ćeš updejtovati ako nemaš usera u bazi??

Da bi insertovao podatke, ide preko formata kada formatira sve, na kraju mora da update?
Ispravi me ako gresim.

@Dobrica

Nope INSERT INTO Korisnici

S ovim već ubacuješ novi red u tablicu Korisnici nema potrebe ništa updejtovati

Update koristiš kad već imaš podatake u bazu koje hoćeš da urediš tj. updejtuješ