[pomoc]posao spremanje

[Aldin Begovic]

mod:xdrive
opis problema:imam problem neznam da napravim da mi sprema Posao u sql bazu ! npr zaposlim se i imam posao odem relog i nemam vise posao ! evo pogledajte kako sam pokusao napravit ali bezuspjesno !!

Kod [Izaberi] Proširi

stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
{
if(GetPVarInt(playerid,"Logiran") == 1)
{
new Spliter[256];
SetPVarInt(playerid,"Novac",GetPlayerMoney(playerid));
    format(Spliter,sizeof(Spliter),
"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,\
%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
GetPVarInt(playerid,"Novac"),GetPVarInt(playerid,"AdminLvl"),GetPVarInt(playerid,"Level"),
GetPVarInt(playerid,"Smrti"),GetPVarInt(playerid,"Ubojstva"),GetPVarInt(playerid,"Registriran"),
GetPVarInt(playerid,"PlayerTeam"),GetPVarInt(playerid,"Godine"),GetPVarInt(playerid,"Spol"),
GetPVarInt(playerid,"Skin"),GetPVarInt(playerid,"GSkin"),GetPVarInt(playerid,"BankovniRacun"),
GetPVarInt(playerid,"Lider"),GetPVarInt(playerid,"Clan"),GetPVarInt(playerid,"Rank"),
GetPVarInt(playerid,"TBanDani"),GetPVarInt(playerid,"TBanSati"),GetPVarInt(playerid,"Banned"),
GetPVarInt(playerid,"Warn"),GetPVarInt(playerid,"Respekta"),GetPVarInt(playerid,"PayBodovi"),
GetPVarInt(playerid,"Drzava"),GetPVarInt(playerid, "SpawnChange"),GetPVarInt(playerid, "Vrijeme"),GetPVarInt(playerid, "Droga"),
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));
SQLUpdatePlayerAccount(GlavnaBaza, playerid, Spliter);
    //printf("[zBlock]: Spremanje/Update accounta %s zavrseno!",name);
    }
}
return 1;
}
//======================:: SQL BAZA ::==========================================
//======================:: SQL BAZA IGRACA ::===================================
stock StvoriPlayerBazu(DB:db)
{
if(db)
{
db_free_result(db_query(db, "CREATE TABLE IF NOT EXISTS `igraci`\
( `ime` TEXT NOT NULL DEFAULT '',\
`lozinka` TEXT NOT NULL DEFAULT '',\
`string` TEXT NOT NULL DEFAULT '',\
  PRIMARY KEY ( `ime`) )"));
  db_free_result(db_query(db, "CREATE TABLE IF NOT EXISTS `kuce`\
( `ID` INTEGER NOT NULL DEFAULT 0,\
`string` TEXT NOT NULL DEFAULT '',\
  PRIMARY KEY ( `ID`) )"));
  db_free_result(db_query(db, "CREATE TABLE IF NOT EXISTS `stan`\
( `ID` INTEGER NOT NULL DEFAULT 0,\
`string` TEXT NOT NULL DEFAULT '',\
  PRIMARY KEY ( `ID`) )"));
  db_free_result(db_query(db, "CREATE TABLE IF NOT EXISTS `vozila`\
( `ID` INTEGER NOT NULL DEFAULT 0,\
`string` TEXT NOT NULL DEFAULT '',\
  PRIMARY KEY ( `ID`) )"));
}
}
stock SQLRegistracijaIgraca(DB:db, playerid, lozinka[], STR_PODATCI[])
{
if(IsPlayerConnected(playerid))
{
new ime[24],string[128 + MAX_PLAYER_NAME];
new DBResult:result;
GetPlayerName(playerid, ime, sizeof(ime));
format(string, sizeof(string), "SELECT * FROM `igraci`  WHERE ( `ime` = '%s')", ime);
result = db_query(db, string);
if(db_num_rows(result) != 0)
{
    printf("[debug] Doslo je do greske!: Racun %s je vec registriran!",ime);
}
else
{
format(string, sizeof(string), "INSERT INTO `igraci` ( `ime`, `lozinka`, `string`)  VALUES ( '%s','%s','%s')", ime,lozinka,STR_PODATCI);
db_free_result(db_query(db, string));
}
}
return 0;
}
stock SQLUpdatePlayerAccount(DB:db, playerid, STR_PODATCI[])
{
if(IsPlayerConnected(playerid))
{
new ime[24],string[128 + MAX_PLAYER_NAME];
new DBResult:result;
GetPlayerName(playerid, ime, sizeof(ime));
format(string, sizeof(string), "SELECT * FROM `igraci`  WHERE ( `ime` = '%s')", ime);
result = db_query(db, string);
if(db_num_rows(result))
{
    db_get_field(result, 0, string, sizeof(string));
    db_free_result(result);
      format(string, sizeof(string), "UPDATE `igraci` SET `string` = '%s' WHERE ( `ime` = '%s')",STR_PODATCI,ime);
        db_free_result(db_query(db, string));
}
}
return 0;
}

stock SQLLoadPlayerAccount(DB:db,lozinka[],playerid)
{
if(IsPlayerConnected(playerid))
{
new DBResult:rezultat, red,str[256];
new ime[24],string[128 + MAX_PLAYER_NAME];
GetPlayerName(playerid, ime, sizeof(ime));
format(string, sizeof(string), "SELECT * FROM `igraci`  WHERE ( `ime` = '%s' AND `lozinka` = '%s')", ime, lozinka);
rezultat = db_query(db,  string);
red = db_num_rows(rezultat);
if(red)
{
    new string1[256];
   
      db_get_field_assoc(rezultat, "string", str, sizeof(str));
    strmid(string1,str,0,256);
new reload[256];
strmid(reload,string1,0,256);
new Stavka[28];
sscanf(reload,
"p<,>dddddddddd\
dddddddddddddddd",
Stavka[0], Stavka[1], Stavka[2],
Stavka[3], Stavka[4], Stavka[5],
Stavka[6], Stavka[7], Stavka[8],
Stavka[9], Stavka[10], Stavka[11],
Stavka[12], Stavka[13], Stavka[14],
Stavka[15], Stavka[16], Stavka[17],
Stavka[18], Stavka[19] ,Stavka[20],
    Stavka[21],Stavka[22],Stavka[23], Stavka[24],
    Stavka[26], Stavka[27]);
           
SetPVarInt(playerid,"Novac",Stavka[0]);
SetPVarInt(playerid,"AdminLvl",Stavka[1]);
SetPVarInt(playerid,"Level",Stavka[2]);
SetPVarInt(playerid,"Smrti",Stavka[3]);
SetPVarInt(playerid,"Ubojstva",Stavka[4]);
SetPVarInt(playerid,"Registriran",Stavka[5]);
SetPVarInt(playerid,"PlayerTeam",Stavka[6]);
SetPVarInt(playerid,"Godine",Stavka[7]);
SetPVarInt(playerid,"Spol",Stavka[8]);
SetPVarInt(playerid,"Skin",Stavka[9]);
SetPVarInt(playerid,"GSkin",Stavka[10]);
SetPVarInt(playerid,"BankovniRacun",Stavka[11]);
SetPVarInt(playerid,"Lider",Stavka[12]);
SetPVarInt(playerid,"Clan",Stavka[13]);
SetPVarInt(playerid,"Rank",Stavka[14]);
SetPVarInt(playerid,"TBanDani",Stavka[15]);
SetPVarInt(playerid,"TBanSati",Stavka[16]);
SetPVarInt(playerid,"Banned",Stavka[17]);
SetPVarInt(playerid,"Warn",Stavka[18]);
SetPVarInt(playerid,"Respekta",Stavka[19]);
SetPVarInt(playerid,"PayBodovi",Stavka[20]);
SetPVarInt(playerid,"Drzava",Stavka[21]);
SetPVarInt(playerid,"SpawnChange",Stavka[22]);
SetPVarInt(playerid,"Droga",Stavka[23]);
SetPVarInt(playerid,"Game Sage",Stavka[24]);
SetPVarInt(playerid,"Vrijeme",Stavka[25]);
SetPVarInt(playerid,"Ugovor",Stavka[26]);
SetPVarInt(playerid,"Posao",Stavka[27]);

db_free_result(db_query(db, string));
SetPVarInt(playerid,"Logiran",1);
}
else
{
new loginstring[512];
new loginname[64];
            SendClientMessage(playerid, COLOR_SCRVENA, "Pogresna lozinka! Molimo upiÅ¡ite tacnu lozinku vaseg racuna!");
GetPlayerName(playerid, ime, sizeof(ime));
  printf("[debug]%s je upisao pogresnu lozinku!", ime);
            format(loginstring,sizeof(loginstring),"{00C0FF}______________________________________________\n\n{FF0000}Pogresana lozinka!\n\n{00FF00}Ukoliko tri puta pogrijesite svoj password\nVas account ce biti zakljucan\n\n{FF0000}Molimo pazljivo upisite svoju lozinku\n{00C0FF}______________________________________________",loginname);
        ShowPlayerDialog(playerid,LOGIN,DIALOG_STYLE_PASSWORD,"{00C0FF}Street4life - Logiranje",loginstring,"Prijava","Izadji");
SetPVarInt(playerid,"Logiran",0);
gPlayerLogTries[playerid] += 1;
        if(gPlayerLogTries[playerid] == 3) { Ban(playerid); }


}
}
return 0;
}
//---------------------------------------------------------------------------takodje posakusao sam napravit komandu posao sa ovim pvar al ne radi bas najbolje. Npr mozes se zaposlit odakle zelis sa bilo koje lokacije :S takodje ovo sto trazi level :S

Kod [Izaberi] Proširi

CMD:posao(playerid, params[])
{
new Player;

if(GetPVarInt(playerid, "Level") > 1) return SendClientMessage(playerid,COLOR_RED, "Vec Imas posao !!");
    if(GetPVarInt(playerid,"Posao") == 1) return SendClientMessage(playerid,COLOR_RED, "Nemas level  !!");
    if(IsPlayerInRangeOfPoint(playerid, 3.0, 1682.2202,-1820.0387,13.5469)) return SendClientMessage(playerid, 0xFF0000AA, "Nisi na mjestu za zaposljavanje!!!");

    else
    {
        SetPVarInt(playerid, "Posao", 7);
        SendClientMessage(Player, 0x00FF00AA, "Zaposlio si se");

    }
    return 1;
}

Hvala

[[TG:RP]$--L84S--$]

Stavi :

Kod [Izaberi] Proširi

GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Posao"));
Zato sto si stavio  SetPVarInt(playerid, "Posao", 7);

[Aldin Begovic]

to da stavim gore gdje sprema :S ili komanda odo pokusat

[[TG:RP]$--L84S--$]

to da stavim gore gdje sprema :S ili komanda odo pokusat

to zamijeni sa ovim dijelom sta si ti stavio : GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));

[Aldin Begovic]

kada to zamjenim sa ovim izbaci mi waringe
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));
number of arguments does not match definition

[[TG:RP]$--L84S--$]

kada to zamjenim sa ovim izbaci mi waringe
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));
number of arguments does not match definition

-.- rekao sam ti da taj dio zamijenis sa ovime :

Kod [Izaberi] Proširi

GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor");

[Aldin Begovic]

pa dzo zamjenim al waringe izbaci de mi ti zamjeni i posalji tj kao sto sam ja postao mozda se nismo bas najj sprorazumili

[Aldin Begovic]

stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
   {
   if(GetPVarInt(playerid,"Logiran") == 1)
      {
         new Spliter[256];
         SetPVarInt(playerid,"Novac",GetPlayerMoney(playerid));
          format(Spliter,sizeof(Spliter),
         "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,\
         %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
         GetPVarInt(playerid,"Novac"),GetPVarInt(playerid,"AdminLvl"),GetPVarInt(playerid,"Level"),
         GetPVarInt(playerid,"Smrti"),GetPVarInt(playerid,"Ubojstva"),GetPVarInt(playerid,"Registriran"),
         GetPVarInt(playerid,"PlayerTeam"),GetPVarInt(playerid,"Godine"),GetPVarInt(playerid,"Spol"),
         GetPVarInt(playerid,"Skin"),GetPVarInt(playerid,"GSkin"),GetPVarInt(playerid,"BankovniRacun"),
         GetPVarInt(playerid,"Lider"),GetPVarInt(playerid,"Clan"),GetPVarInt(playerid,"Rank"),
         GetPVarInt(playerid,"TBanDani"),GetPVarInt(playerid,"TBanSati"),GetPVarInt(playerid,"Banned"),
         GetPVarInt(playerid,"Warn"),GetPVarInt(playerid,"Respekta"),GetPVarInt(playerid,"PayBodovi"),
         GetPVarInt(playerid,"Drzava"),GetPVarInt(playerid, "SpawnChange"),GetPVarInt(playerid, "Vrijeme"),GetPVarInt(playerid, "Droga"),
         GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Posao"));
         SQLUpdatePlayerAccount(GlavnaBaza, playerid, Spliter);
            //printf("[zBlock]: Spremanje/Update accounta %s zavrseno!",name);
       }
   }
return 1;
}
//ovdje da ubacim :S ?

[Aldin Begovic]

Sto se nerazumes lik ti kaze a ti ne razumes Pa naravno tamo 

pa ljudino stavio sam al izbaci mi warnige :S nisam glup toliko znam sta mi kaze al waring izbaci i ne radi :S

[[TG:RP]$--L84S--$]

Kod [Izaberi] Proširi

stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
   {
   if(GetPVarInt(playerid,"Logiran") == 1)
      {
         new Spliter[256];
         SetPVarInt(playerid,"Novac",GetPlayerMoney(playerid));
          format(Spliter,sizeof(Spliter),
         "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,\
         %d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
         GetPVarInt(playerid,"Novac"),GetPVarInt(playerid,"AdminLvl"),GetPVarInt(playerid,"Level"),
         GetPVarInt(playerid,"Smrti"),GetPVarInt(playerid,"Ubojstva"),GetPVarInt(playerid,"Registriran"),
         GetPVarInt(playerid,"PlayerTeam"),GetPVarInt(playerid,"Godine"),GetPVarInt(playerid,"Spol"),
         GetPVarInt(playerid,"Skin"),GetPVarInt(playerid,"GSkin"),GetPVarInt(playerid,"BankovniRacun"),
         GetPVarInt(playerid,"Lider"),GetPVarInt(playerid,"Clan"),GetPVarInt(playerid,"Rank"),
         GetPVarInt(playerid,"TBanDani"),GetPVarInt(playerid,"TBanSati"),GetPVarInt(playerid,"Banned"),
         GetPVarInt(playerid,"Warn"),GetPVarInt(playerid,"Respekta"),GetPVarInt(playerid,"PayBodovi"),
         GetPVarInt(playerid,"Drzava"),GetPVarInt(playerid, "SpawnChange"),GetPVarInt(playerid, "Vrijeme"),GetPVarInt(playerid, "Droga"),GetPVarInt(playerid,"Posao");
         SQLUpdatePlayerAccount(GlavnaBaza, playerid, Spliter);
            //printf("[zBlock]: Spremanje/Update accounta %s zavrseno!",name);
       }
   }
return 1;
}

[Aldin Begovic]

opet nece cc  ko me navrati da radim sa sql ccc