[pomoc]posao spremanje

Započeo Aldin Begovic, Januar 26, 2012, 18:58:31 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

Štampaj
Idi dole Stranice1
Korisničke akcije

Aldin Begovic

*

Januar 26, 2012, 18:58:31 POSLE PODNE
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[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 
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
Poslednja Izmena: Januar 26, 2012, 19:01:41 POSLE PODNE od [TG]$--L84S--$

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

*

#1
Januar 26, 2012, 19:03:14 POSLE PODNE
Stavi : 
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Posao"));

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

Aldin Begovic

*

#2
Januar 26, 2012, 19:09:06 POSLE PODNE
to da stavim gore gdje sprema :S ili komanda :D odo pokusat

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

*

#3
Januar 26, 2012, 19:11:06 POSLE PODNE
Citat: Aldin Begovic poslato Januar 26, 2012, 19:09:06 POSLE PODNE
to da stavim gore gdje sprema :S ili komanda :D odo pokusat
to zamijeni sa ovim dijelom sta si ti stavio : GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));

Aldin Begovic

*

#4
Januar 26, 2012, 19:27:27 POSLE PODNE
kada to zamjenim sa ovim izbaci mi waringe
GetPVarInt(playerid,"Posao"),GetPVarInt(playerid, "Ugovor"));
number of arguments does not match definition

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

*

#5
Januar 26, 2012, 19:28:47 POSLE PODNE
Citat: Aldin Begovic poslato Januar 26, 2012, 19:27:27 POSLE PODNE
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");
Poslednja Izmena: Januar 26, 2012, 19:48:08 POSLE PODNE od [TG]$--L84S--$

Aldin Begovic

*

#6
Januar 26, 2012, 19:38:50 POSLE PODNE
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

*

#7
Januar 26, 2012, 19:43:43 POSLE PODNE
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

*

#8
Januar 26, 2012, 19:49:28 POSLE PODNE
Citat: -αиσиумσÏ...Ñ•- poslato Januar 26, 2012, 19:47:17 POSLE PODNE
Sto se nerazumes lik ti kaze a ti ne razumes :D 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 :D

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

*

#9
Januar 26, 2012, 19:51:10 POSLE PODNE 
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

*

#10
Januar 26, 2012, 20:02:01 POSLE PODNE
opet nece cc  ko me navrati da radim sa sql ccc
Poslednja Izmena: Januar 26, 2012, 23:10:19 POSLE PODNE od Aldin Begovic
Štampaj
Idi gore Stranice1
Korisničke akcije