GTA:BLKN

[pomoc]posao spremanje

Započeo Aldin Begovic
•26. Jan. 2012.• Zaključano
991
pregleda
11
postova
Aldin Begovic
4
Aldin Begovic
Made Man
26. Jan. 2012.
#1
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 !!
stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
	{
	if(GetPVarInt(playerid,"Logiran") == 1)
		{
			new Spliter;
			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(": 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,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(" 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,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;
	new ime,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;
 		  	
	    	db_get_field_assoc(rezultat, "string", str, sizeof(str));
  			strmid(string1,str,0,256);
			new reload;
			strmid(reload,string1,0,256);
			new Stavka;
			sscanf(reload,
			"p<,>dddddddddd\
			dddddddddddddddd",
			Stavka, Stavka, Stavka,
			Stavka, Stavka, Stavka,
 			Stavka, Stavka, Stavka,
 			Stavka, Stavka, Stavka,
 			Stavka, Stavka, Stavka,
 			Stavka, Stavka, Stavka,
 			Stavka, Stavka ,Stavka,
		    Stavka,Stavka,Stavka, Stavka,
		    Stavka, Stavka);
          
			SetPVarInt(playerid,"Novac",Stavka);
			SetPVarInt(playerid,"AdminLvl",Stavka);
			SetPVarInt(playerid,"Level",Stavka);
			SetPVarInt(playerid,"Smrti",Stavka);
			SetPVarInt(playerid,"Ubojstva",Stavka);
			SetPVarInt(playerid,"Registriran",Stavka);
			SetPVarInt(playerid,"PlayerTeam",Stavka);
			SetPVarInt(playerid,"Godine",Stavka);
			SetPVarInt(playerid,"Spol",Stavka);
			SetPVarInt(playerid,"Skin",Stavka);
			SetPVarInt(playerid,"GSkin",Stavka);
			SetPVarInt(playerid,"BankovniRacun",Stavka);
			SetPVarInt(playerid,"Lider",Stavka);
			SetPVarInt(playerid,"Clan",Stavka);
			SetPVarInt(playerid,"Rank",Stavka);
			SetPVarInt(playerid,"TBanDani",Stavka);
			SetPVarInt(playerid,"TBanSati",Stavka);
			SetPVarInt(playerid,"Banned",Stavka);
			SetPVarInt(playerid,"Warn",Stavka);
			SetPVarInt(playerid,"Respekta",Stavka);
			SetPVarInt(playerid,"PayBodovi",Stavka);
			SetPVarInt(playerid,"Drzava",Stavka);
			SetPVarInt(playerid,"SpawnChange",Stavka);
			SetPVarInt(playerid,"Droga",Stavka);
			SetPVarInt(playerid,"Game Sage",Stavka);
			SetPVarInt(playerid,"Vrijeme",Stavka);
			SetPVarInt(playerid,"Ugovor",Stavka);
			SetPVarInt(playerid,"Posao",Stavka);
			
			db_free_result(db_query(db, string));
			SetPVarInt(playerid,"Logiran",1);
		}
		else
		{
			new loginstring;
			new loginname;
            SendClientMessage(playerid, COLOR_SCRVENA, "Pogresna lozinka! Molimo upiÅ¡ite tacnu lozinku vaseg racuna!");
			GetPlayerName(playerid, ime, sizeof(ime));
		  	printf("%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 += 1;
	        if(gPlayerLogTries == 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 
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
Luis
5
[TG:RP]$--L84S--$
Godfather
26. Jan. 2012.
#2
Stavi : 
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Posao"));

Zato sto si stavio  SetPVarInt(playerid, "Posao", 7);
Aldin Begovic
4
Aldin Begovic
Made Man
26. Jan. 2012.
#3
to da stavim gore gdje sprema :S ili komanda 😄 odo pokusat
Luis
5
[TG:RP]$--L84S--$
Godfather
26. Jan. 2012.
#4
Aldin Begovic wrote on January 26, 2012, 6:09 pm:
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
4
Aldin Begovic
Made Man
26. Jan. 2012.
#5
kada to zamjenim sa ovim izbaci mi waringe
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));
number of arguments does not match definition
Luis
5
[TG:RP]$--L84S--$
Godfather
26. Jan. 2012.
#6
Aldin Begovic wrote on January 26, 2012, 6:27 pm:
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 : 
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor");
Aldin Begovic
4
Aldin Begovic
Made Man
26. Jan. 2012.
#7
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
4
Aldin Begovic
Made Man
26. Jan. 2012.
#8
stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
{
if(GetPVarInt(playerid,"Logiran") == 1)
{
new Spliter;
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(": Spremanje/Update accounta %s zavrseno!",name);
    }
}
return 1;
}
//ovdje da ubacim :S ?
Aldin Begovic
4
Aldin Begovic
Made Man
26. Jan. 2012.
#9
-αиσиумσυѕ- wrote on January 26, 2012, 6:47 pm:
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 😄
Luis
5
[TG:RP]$--L84S--$
Godfather
26. Jan. 2012.
#10
stock UpdatePlayerAccount(playerid)
{
if(IsPlayerConnected(playerid))
  {
  if(GetPVarInt(playerid,"Logiran") == 1)
      {
        new Spliter;
        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(": Spremanje/Update accounta %s zavrseno!",name);
      }
  }
return 1;
}
Aldin Begovic
4
Aldin Begovic
Made Man
26. Jan. 2012.
#11
opet nece cc  ko me navrati da radim sa sql ccc

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha