[pomoc]ban info


Započeo [Euro Samp]Shadow, Septembar 21, 2013, 15:10:08 POSLE PODNE

prethodna tema - sledeća tema

0 članova i 1 gost pregledaju ovu temu.

skripta koju koristim:NL
detaljan opis problema :imam za ban i sad sam namjestio kako je u databazi za banovi jer prije mi je pisalo
ID bana:0
administrator:0
razlog bana 0
i tako i sad sam ja stavio ovako
    case THREAD_BANINFO:
	    {
	        mysql_store_result();
		    if(mysql_num_rows() == 0)
			{
				SCM(extraid, CRVENA, "Vas korisnicki racun je iskljucen sa servera, ali informacije o iskljucenju nazalost nisu dostupne.");
				SCM(extraid, BELA, "Ukoliko smatrate da je doslo do greske, zatrazite skidanje bana na nasem forumu: www.vg-samp.mojkgb.com/forum");
				SetTimer("KICK",  1000, 0);
				return 1;
			}
			new lajn[155], ajdi, banovani[24], admin[24], rizon[64], dejt[32], ajpi[16];
   			GetPlayerIp(extraid, ajpi, 16);
		    if(mysql_fetch_row(lajn)) sscanf(lajn, "p<|>is[24]s[24]s[64]s[32]", ajdi, banovani, admin, rizon, dejt);
			mysql_free_result();
		    for(new i = 0; i < 20; i++) SCM(extraid, BELA, " ");
		    SCM(extraid, CRVENA, 		"______________________________________________________________________________");
		    SCM(extraid, CRVENA, 		"______________________________________________________________________________");
		    SCM(extraid, SVETLOCRVENA, 	"[ISKLJUCENJE SA SERVERA] Vas korisnicki racun je nazalost iskljucen sa servera na neodredjeno.");
		    SCMF(extraid, BELA,          "Ban: #%d", ajdi);
		    SCMF(extraid, BELA,   		"Vase ime: %s", banovani);
		    SCMF(extraid, BELA,          "Administrator: %s", admin);
		    SCMF(extraid, BELA,   		"Razlog iskljucenja: %s", rizon);
		    SCMF(extraid, BELA,   		"Vasa IP adresa: %s | Vreme i datum: %s", ajpi, dejt);
		    SCM(extraid, BELA,   		"Ukoliko smatrate da je doslo do greske, zatrazite skidanje bana na forumu.");
		    SCM(extraid, ZUTA,   		"Link do foruma: www.vg-samp.mojkgb.com/forum");
			SetTimerEx("KICK", 1000, 0, "i", extraid);
	    }

i sad kad ulazim napisem lozinku i tu di bi mi trebalo doc taj ban info pise mi samo NEmozete se spavnati dok se ne ulogujete




Citat: [USS-RPG]Buljan poslato Septembar 22, 2013, 10:20:12 PRE PODNE
*BUMP*

daj mi svoj THREAD_PRIJAVA

znaci ti se ulogujes i pise ti da se nemozes spavnati prije logina a treba ti doci THREAD_BANINFO

My Bike KTM 450 SXF 2008

eto prijava
case THREAD_PRIJAVA:
		{
		    mysql_store_result();
		    if(mysql_num_rows() == 0) return SCM(extraid, CRVENA, "Greska pri ucitavanju accounta, pokusajte ponovo..."), Kick(extraid), mysql_free_result();
		    new linija[850];
		    mysql_fetch_row(linija);
		    mysql_free_result();
		    ProcitajLiniju(extraid, linija);
			new hIme[MAX_PLAYER_NAME], ime[MAX_PLAYER_NAME];
			ImeIgraca(extraid, hIme);
			RPIme(extraid, ime);
		    if(PI[extraid][Banovan] == 1)
			{
			    new cupit[100];
			    format(cupit, 100, "SELECT * FROM `Banovi` WHERE `Ime` = '%s' ORDER BY `ID` DESC LIMIT 1", hIme);
			    mysql_query(cupit, THREAD_BANINFO, extraid);
				return 1;
			}
			if(PI[extraid][GM] > 0 || PI[extraid][Admin] > 0)
			{
			    SPD(extraid, 261, DIALOG_STYLE_PASSWORD, "Login [drugi deo - PIN]", "{FFFFFF}Vi ste admin/gm, unesite svoj PIN kod.\n\n{FF0000}Imate pravo na samo jedan pokusaj, ako pogresite dobijate ban!", "Potvrdi", "");
			    return 1;
			}
			hIgracUlogovan[extraid] = 1;
			hIgracevNalogPostoji[extraid] = 1;
			GivePlayerMoney(extraid, PI[extraid][Novac]);
			SetPlayerScore(extraid, PI[extraid][Nivo]);
			SetPlayerFightingStyle(extraid, PI[extraid][BorbeniStil]);
			if(PI[extraid][TrazeniNivo] < 0) PI[extraid][TrazeniNivo] = 0;
			if(PI[extraid][TrazeniNivo] > 6) PI[extraid][TrazeniNivo] = 6;
			SetPlayerWantedLevel(extraid, PI[extraid][TrazeniNivo]);
			TextDrawShowForPlayer(extraid, Sat);
			//voziloprovera[extraid] = SetTimerEx("ProveriJelUVozilu", 1500, true, "d", extraid);
			new exp = (PI[extraid][Nivo] * 2) + 2;
			new randx = random(sizeof(Vicevi)), upitblabla[64];
			new Izbacen = 0;
			if(PI[extraid][Clan] > 0 && PI[extraid][Lider] == 0)
			{
			    if(PI[extraid][Clan] == 1 && strcmp(PDInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 2 && strcmp(FBIInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 3 && strcmp(SWATInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 4 && strcmp(MDInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 5 && strcmp(SCFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 6 && strcmp(WTMInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 7 && strcmp(MayorInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 8 && strcmp(HAInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 9 && strcmp(CNNInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 10 && strcmp(TCInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 11 && strcmp(GSFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 12 && strcmp(LSBInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 13 && strcmp(NGRInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 14 && strcmp(BMCInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 15 && strcmp(ICFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 16 && strcmp(VLAInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 17 && strcmp(RMInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				if(PI[extraid][MestoUOrg] < 1 || PI[extraid][MestoUOrg] > 20) Izbacen = 1;
			}
			if(PI[extraid][Lider] > 0)
			{
			    if(PI[extraid][Lider] == 1 && strcmp(PDInfo[1][Lider], hIme, false) && strcmp(PDInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 2 && strcmp(FBIInfo[1][Lider], hIme, false) && strcmp(FBIInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 3 && strcmp(SWATInfo[1][Lider], hIme, false) && strcmp(SWATInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 4 && strcmp(MDInfo[1][Lider], hIme, false) && strcmp(MDInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 5 && strcmp(SCFInfo[1][Lider], hIme, false) && strcmp(SCFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 6 && strcmp(WTMInfo[1][Lider], hIme, false) && strcmp(WTMInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 7 && strcmp(MayorInfo[1][Lider], hIme, false) && strcmp(MayorInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 8 && strcmp(HAInfo[1][Lider], hIme, false) && strcmp(HAInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 9 && strcmp(CNNInfo[1][Lider], hIme, false) && strcmp(CNNInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 10 && strcmp(TCInfo[1][Lider], hIme, false) && strcmp(TCInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 11 && strcmp(GSFInfo[1][Lider], hIme, false) && strcmp(GSFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 12 && strcmp(LSBInfo[1][Lider], hIme, false) && strcmp(LSBInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 13 && strcmp(NGRInfo[1][Lider], hIme, false) && strcmp(NGRInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 14 && strcmp(BMCInfo[1][Lider], hIme, false) && strcmp(BMCInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 15 && strcmp(ICFInfo[1][Lider], hIme, false) && strcmp(ICFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 16 && strcmp(VLAInfo[1][Lider], hIme, false) && strcmp(VLAInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 17 && strcmp(RMInfo[1][Lider], hIme, false) && strcmp(RMInfo[2][Lider], hIme, false)) Izbacen = 1;
			    if(Izbacen == 0)
			    {
					if(PI[extraid][Lider] == 1) PI[extraid][Skin] = PD_LIDER;
					else if(PI[extraid][Lider] == 2) PI[extraid][Skin] = FBI_LIDER;
					else if(PI[extraid][Lider] == 3) PI[extraid][Skin] = SWAT_LIDER;
					else if(PI[extraid][Lider] == 5) PI[extraid][Skin] = SCF_LIDER;
					else if(PI[extraid][Lider] == 6) PI[extraid][Skin] = WTM_LIDER;
					else if(PI[extraid][Lider] == 7) PI[extraid][Skin] = MAYOR_LIDER;
					else if(PI[extraid][Lider] == 8) PI[extraid][Skin] = HA_LIDER;
					else if(PI[extraid][Lider] == 9) PI[extraid][Skin] = CNN_LIDER;
					else if(PI[extraid][Lider] == 11) PI[extraid][Skin] = GSF_LIDER;
					else if(PI[extraid][Lider] == 12) PI[extraid][Skin] = LSB_LIDER;
					else if(PI[extraid][Lider] == 13) PI[extraid][Skin] = NGR_LIDER;
					else if(PI[extraid][Lider] == 14) PI[extraid][Skin] = BMC_LIDER;
					else if(PI[extraid][Lider] == 15) PI[extraid][Skin] = ICF_LIDER;
					else if(PI[extraid][Lider] == 16) PI[extraid][Skin] = VLA_LIDER;
					else if(PI[extraid][Lider] == 17) PI[extraid][Skin] = RM_LIDER;
				}
			}
			SCM(extraid, PLAVA, "_____________________________________________________________");
			SCM(extraid, PLAVA, "   Vortex Gaming Roleplay server");
			SCMF(extraid, ZELENA2,        " - Dobrodosli %s, ljepo Vas je opet videti na serveru!", ime);
			format(CmdString, 128,		" Nivo: [%d] | Novac: [$%d] | Iskustvo: [%d/%d] | Sati igre: [%d] | Gm: [%d] | Admin: [%d]", PI[extraid][Nivo], PI[extraid][Novac], PI[extraid][Iskustvo], exp, PI[extraid][SatiIgre], PI[extraid][GM], PI[extraid][Admin]);
			SCM(extraid, CRVENA,        CmdString);
			new datumregistracije[32], poslednjaaktivnost[32], imez[MAX_PLAYER_NAME];
			if(mysql_fetch_row(linija))
		   	{
      			sscanf(linija, "p<|>s[24]s[32]s[32]", imez, datumregistracije, poslednjaaktivnost);
			}
			mysql_free_result();
			format(CmdString, 128,		" Vasa zadnja aktivnost na serveru bila je : ,Datum registracije je :", PI[extraid][PoslednjaAktivnost],PI[extraid][DatumRegistracije]);
			SCM(extraid, SVETLOZELENA,        CmdString);
			SCMF(extraid, RADIO_BOJA,  " Vic dana: %s", Vicevi[randx]);
			if(PI[extraid][GOLD] > 0) SCMF(extraid, SVETLOPLAVA, "* Imate jos %d GOLD GOLD-a.", PI[extraid][GOLD]);
			if(Izbacen == 1)
			{
				PI[extraid][Clan] = 0;
	        	PI[extraid][Rank] = 0;
          		PI[extraid][Lider] = 0;
		        if(PI[extraid][Pol] == 0) { PI[extraid][Skin] = 212; h_SetPlayerSkin(extraid, 212); }
				else if(PI[extraid][Pol] == 1) { PI[extraid][Skin] = 211; h_SetPlayerSkin(extraid, 211); }
				SCM(extraid, TAMNOCRVENA, "* Izbaceni ste iz svoje organizacije/mafije/bande!");
				format(upit, 200, "UPDATE `Igraci` SET `Clan` = '0', `Lider` = '0', `Rank` = '0', `Skin` = '%d' WHERE `Ime` = '%s'", PI[extraid][Skin], hIme);
				mysql_query(upit, THREAD_OSTALO);
			}
			SCM(extraid, PLAVA, "_____________________________________________________________");
			if(PI[extraid][GM] > 0)
			{
			    format(CmdString, 64, "| VG GameMaster | %s je usao na server.", ime);
			    StaffPoruka(ZELENA2, CmdString);
			}
			if(PI[extraid][Admin] > 0 && PI[extraid][Admin] < HEAD)
			{
			    format(CmdString, 64, "| VG Admin | %s je usao na server.", ime);
			    StaffPoruka(SVETLOPLAVA, CmdString);
			}
			if(PI[extraid][Admin] >= HEAD)
			{
			    foreach(Player, i)
			    {
			        if(PI[i][Admin] >= HEAD || IsPlayerAdmin(i))
			        {
					    format(CmdString, 75, "| VG HeadAdmin | %s je usao na server.", ime);
					    SCM(i, TAMNOLJUBICASTA, CmdString);
					}
				}
			}
			if(PI[extraid][Kuca] != -1)
			{
			    if(strcmp(Kuce[PI[extraid][Kuca]][Vlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Kuca koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Kuce` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Kuca]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Stan] != -1)
			{
			    if(strcmp(Stanx[PI[extraid][Stan]][sVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Stan koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Stanovi` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Stan]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Vikendica] != -1)
			{
			    if(strcmp(Vikendice[PI[extraid][Vikendica]][vVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Vikendica koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Vikendice` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Vikendica]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Garaza] != -1)
			{
			    if(strcmp(Garaze[PI[extraid][Garaza]][gVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Garaza koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Garaze` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Garaza]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Firma] != -1)
			{
			    if(strcmp(Firme[PI[extraid][Firma]][fVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Firma koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Firme` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Firma]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][GM] < 0  && PI[extraid][Admin] < 0)
            {
            GRESKA(extraid);
        	return 1;
            }
			if(PI[extraid][JFirma] != -1)
			{
			    if(strcmp(JFirme[PI[extraid][JFirma]][jfVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}JFirma koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `JFirme` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][JFirma]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Hotel] != -1)
			{
			    if(strcmp(Hoteli[PI[extraid][Hotel]][hVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Hotel koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Hoteli` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Hotel]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Auto1] != -1)
			{
			    new i = PI[extraid][Auto1];
				if(strcmp(VInfo[i][hVlasnik], ime, true))
		  		{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Automobil (1) koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(VInfo[i][ownedvehicle]);
					VInfo[i][ownedvehicle] = CreateVehicle_H(VInfo[i][hModel], VInfo[i][hPozX], VInfo[i][hPozY], VInfo[i][hPozZ], VInfo[i][hPozA], VInfo[i][hBoja1], VInfo[i][hBoja2], 1000);
					LinkVehicleToInterior(VInfo[i][ownedvehicle], VInfo[i][hent]);
					SetVehicleVirtualWorld(VInfo[i][ownedvehicle], VInfo[i][hvw]);
					SetVehicleNumberPlate(VInfo[i][ownedvehicle], VInfo[i][hTablice]);
					SetVehicleToRespawn(VInfo[i][ownedvehicle]);
					IgracevAuto1[extraid] = i;
					format(upitblabla, 64, "UPDATE `Automobili` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Motor] != -1)
			{
			    new i = PI[extraid][Motor];
		  		if(strcmp(MInfo[i][mVlasnik], ime, true))
		  		{
			    	SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Motor koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(MInfo[i][mownedvehicle]);
				    MInfo[i][mownedvehicle] = CreateVehicle_H(MInfo[i][mModel], MInfo[i][mPozX], MInfo[i][mPozY], MInfo[i][mPozZ], MInfo[i][mPozA], MInfo[i][mBoja1], MInfo[i][mBoja2], 1000);
					LinkVehicleToInterior(MInfo[i][mownedvehicle], MInfo[i][ment]);
					SetVehicleVirtualWorld(MInfo[i][mownedvehicle], MInfo[i][mvw]);
					SetVehicleToRespawn(MInfo[i][mownedvehicle]);
					IgracevMotor[extraid] = i;
					format(upitblabla, 64, "UPDATE `Motori` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Bicikla] != -1)
			{
			    new i = PI[extraid][Bicikla];
				if(strcmp(BInfo[i][bhVlasnik], ime, true))
				{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Bicikla koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(BInfo[i][bownedvehicle]);
				    BInfo[i][bownedvehicle] = CreateVehicle_H(BInfo[i][bhModel], BInfo[i][bhPozX], BInfo[i][bhPozY], BInfo[i][bhPozZ], BInfo[i][bhPozA], BInfo[i][bhBoja1], BInfo[i][bhBoja2], 1000);
					LinkVehicleToInterior(BInfo[i][bownedvehicle], BInfo[i][bhent]);
					SetVehicleVirtualWorld(BInfo[i][bownedvehicle], BInfo[i][bhvw]);
					SetVehicleToRespawn(BInfo[i][bownedvehicle]);
					IgracevaBicikla[extraid] = i;
					format(upitblabla, 64, "UPDATE `Bicikle` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Plovilo] != -1)
			{
			    new i = PI[extraid][Plovilo];
		 		if(strcmp(PInfo[i][phVlasnik], ime, true))
				{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Plovilo koje se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(PInfo[i][pownedvehicle]);
			    	PInfo[i][pownedvehicle] = CreateVehicle_H(PInfo[i][phModel], PInfo[i][phPozX], PInfo[i][phPozY], PInfo[i][phPozZ], PInfo[i][phPozA], PInfo[i][phBoja1], PInfo[i][phBoja2], 1000);
					IgracevoPlovilo[extraid] = i;
					format(upitblabla, 64, "UPDATE `Plovila` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Letelica] != -1)
			{
			    new i = PI[extraid][Letelica];
				if(strcmp(LInfo[i][lhVlasnik], ime, true))
		  		{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Letelica koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(LInfo[i][lownedvehicle]);
			    	LInfo[i][lownedvehicle] = CreateVehicle_H(LInfo[i][lhModel], LInfo[i][lhPozX], LInfo[i][lhPozY], LInfo[i][lhPozZ], LInfo[i][lhPozA], LInfo[i][lhBoja1], LInfo[i][lhBoja2], 1000);
					IgracevaLetelica[extraid] = i;
					format(upitblabla, 64, "UPDATE `Letelice` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Zatvoren] == 1)
		    {
				ResetPlayerWeaponsEx(extraid);
				new rand = random(sizeof(Celije));
				SetPlayerPos_H(extraid, Celije[rand][0], Celije[rand][1], Celije[rand][2]);
				SetPlayerFacingAngle(extraid, Celije[rand][3]);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Zavezan] == 1)
			{
				ResetPlayerWeaponsEx(extraid);
				new rand = random(sizeof(Celije));
				SetPlayerPos_H(extraid, Celije[rand][0], Celije[rand][1], Celije[rand][2]);
				SetPlayerFacingAngle(extraid, Celije[rand][3]);
				PI[extraid][Zatvoren] = 1;
				PI[extraid][ZatvorenVreme] = 3200;
				PI[extraid][Zavezan] = 0;
				SCM(extraid, CRVENA, "VGSecurity | {FF6347}Zato sto ste izasli iz igre za vreme hapsenja ili dok ste bili zavezani, automatski idete u zatvor!");
				new imex[MAX_PLAYER_NAME];
				RPIme(extraid, imex);
				format(CmdString, sizeof CmdString, "| Komanda: /zatvor | Izvrsio: VGSecurity | Igrac: %s | Razlog: Umiranje pri hapsenju/otmici", imex);
				UpisiLog(FAJL_KAZNELOG, CmdString);
				new kkk[MAX_PLAYER_NAME], kk[128];
				ImeIgraca(extraid, kkk);
				format(kk, 128, "UPDATE `Igraci` SET `Zavezan` = '0' WHERE `Ime` = '%s'", kkk);
				mysql_query(kk, THREAD_OSTALO);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Zatvoren] == 2)
			{
				SetPlayerPos_H(extraid, 107.2300,1920.6311,18.5208);
				SetPlayerWorldBounds(extraid, 337.5694,101.5826,1940.9759,1798.7453);
				ResetPlayerWeaponsEx(extraid);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Clan] == 3 || PI[extraid][Clan] == 7) hNaDuznosti[extraid] = 1;
			new ip[16], logstring[256];
			ImeIgraca(extraid, hIme);
		 	GetPlayerIp(extraid, ip, sizeof ip);
		   	format(logstring, sizeof logstring, "| LOGIN | Igrac: %s | IP: %s", hIme, ip);
			UpisiLog(FAJL_SLOGINLOG, logstring);
		}

Citat: [USS-RPG]Buljan poslato Septembar 23, 2013, 07:10:46 PRE PODNE
eto prijava
case THREAD_PRIJAVA:
		{
		    mysql_store_result();
		    if(mysql_num_rows() == 0) return SCM(extraid, CRVENA, "Greska pri ucitavanju accounta, pokusajte ponovo..."), Kick(extraid), mysql_free_result();
		    new linija[850];
		    mysql_fetch_row(linija);
		    mysql_free_result();
		    ProcitajLiniju(extraid, linija);
			new hIme[MAX_PLAYER_NAME], ime[MAX_PLAYER_NAME];
			ImeIgraca(extraid, hIme);
			RPIme(extraid, ime);
		    if(PI[extraid][Banovan] == 1)
			{
			    new cupit[100];
			    format(cupit, 100, "SELECT * FROM `Banovi` WHERE `Ime` = '%s' ORDER BY `ID` DESC LIMIT 1", hIme);
			    mysql_query(cupit, THREAD_BANINFO, extraid);
				return 1;
			}
			if(PI[extraid][GM] > 0 || PI[extraid][Admin] > 0)
			{
			    SPD(extraid, 261, DIALOG_STYLE_PASSWORD, "Login [drugi deo - PIN]", "{FFFFFF}Vi ste admin/gm, unesite svoj PIN kod.\n\n{FF0000}Imate pravo na samo jedan pokusaj, ako pogresite dobijate ban!", "Potvrdi", "");
			    return 1;
			}
			hIgracUlogovan[extraid] = 1;
			hIgracevNalogPostoji[extraid] = 1;
			GivePlayerMoney(extraid, PI[extraid][Novac]);
			SetPlayerScore(extraid, PI[extraid][Nivo]);
			SetPlayerFightingStyle(extraid, PI[extraid][BorbeniStil]);
			if(PI[extraid][TrazeniNivo] < 0) PI[extraid][TrazeniNivo] = 0;
			if(PI[extraid][TrazeniNivo] > 6) PI[extraid][TrazeniNivo] = 6;
			SetPlayerWantedLevel(extraid, PI[extraid][TrazeniNivo]);
			TextDrawShowForPlayer(extraid, Sat);
			//voziloprovera[extraid] = SetTimerEx("ProveriJelUVozilu", 1500, true, "d", extraid);
			new exp = (PI[extraid][Nivo] * 2) + 2;
			new randx = random(sizeof(Vicevi)), upitblabla[64];
			new Izbacen = 0;
			if(PI[extraid][Clan] > 0 && PI[extraid][Lider] == 0)
			{
			    if(PI[extraid][Clan] == 1 && strcmp(PDInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 2 && strcmp(FBIInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 3 && strcmp(SWATInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 4 && strcmp(MDInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 5 && strcmp(SCFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 6 && strcmp(WTMInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 7 && strcmp(MayorInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 8 && strcmp(HAInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 9 && strcmp(CNNInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 10 && strcmp(TCInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 11 && strcmp(GSFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 12 && strcmp(LSBInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 13 && strcmp(NGRInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 14 && strcmp(BMCInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 15 && strcmp(ICFInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 16 && strcmp(VLAInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				else if(PI[extraid][Clan] == 17 && strcmp(RMInfo[PI[extraid][MestoUOrg]][Mesto], hIme, false)) Izbacen = 1;
				if(PI[extraid][MestoUOrg] < 1 || PI[extraid][MestoUOrg] > 20) Izbacen = 1;
			}
			if(PI[extraid][Lider] > 0)
			{
			    if(PI[extraid][Lider] == 1 && strcmp(PDInfo[1][Lider], hIme, false) && strcmp(PDInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 2 && strcmp(FBIInfo[1][Lider], hIme, false) && strcmp(FBIInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 3 && strcmp(SWATInfo[1][Lider], hIme, false) && strcmp(SWATInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 4 && strcmp(MDInfo[1][Lider], hIme, false) && strcmp(MDInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 5 && strcmp(SCFInfo[1][Lider], hIme, false) && strcmp(SCFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 6 && strcmp(WTMInfo[1][Lider], hIme, false) && strcmp(WTMInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 7 && strcmp(MayorInfo[1][Lider], hIme, false) && strcmp(MayorInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 8 && strcmp(HAInfo[1][Lider], hIme, false) && strcmp(HAInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 9 && strcmp(CNNInfo[1][Lider], hIme, false) && strcmp(CNNInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 10 && strcmp(TCInfo[1][Lider], hIme, false) && strcmp(TCInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 11 && strcmp(GSFInfo[1][Lider], hIme, false) && strcmp(GSFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 12 && strcmp(LSBInfo[1][Lider], hIme, false) && strcmp(LSBInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 13 && strcmp(NGRInfo[1][Lider], hIme, false) && strcmp(NGRInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 14 && strcmp(BMCInfo[1][Lider], hIme, false) && strcmp(BMCInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 15 && strcmp(ICFInfo[1][Lider], hIme, false) && strcmp(ICFInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 16 && strcmp(VLAInfo[1][Lider], hIme, false) && strcmp(VLAInfo[2][Lider], hIme, false)) Izbacen = 1;
			    else if(PI[extraid][Lider] == 17 && strcmp(RMInfo[1][Lider], hIme, false) && strcmp(RMInfo[2][Lider], hIme, false)) Izbacen = 1;
			    if(Izbacen == 0)
			    {
					if(PI[extraid][Lider] == 1) PI[extraid][Skin] = PD_LIDER;
					else if(PI[extraid][Lider] == 2) PI[extraid][Skin] = FBI_LIDER;
					else if(PI[extraid][Lider] == 3) PI[extraid][Skin] = SWAT_LIDER;
					else if(PI[extraid][Lider] == 5) PI[extraid][Skin] = SCF_LIDER;
					else if(PI[extraid][Lider] == 6) PI[extraid][Skin] = WTM_LIDER;
					else if(PI[extraid][Lider] == 7) PI[extraid][Skin] = MAYOR_LIDER;
					else if(PI[extraid][Lider] == 8) PI[extraid][Skin] = HA_LIDER;
					else if(PI[extraid][Lider] == 9) PI[extraid][Skin] = CNN_LIDER;
					else if(PI[extraid][Lider] == 11) PI[extraid][Skin] = GSF_LIDER;
					else if(PI[extraid][Lider] == 12) PI[extraid][Skin] = LSB_LIDER;
					else if(PI[extraid][Lider] == 13) PI[extraid][Skin] = NGR_LIDER;
					else if(PI[extraid][Lider] == 14) PI[extraid][Skin] = BMC_LIDER;
					else if(PI[extraid][Lider] == 15) PI[extraid][Skin] = ICF_LIDER;
					else if(PI[extraid][Lider] == 16) PI[extraid][Skin] = VLA_LIDER;
					else if(PI[extraid][Lider] == 17) PI[extraid][Skin] = RM_LIDER;
				}
			}
			SCM(extraid, PLAVA, "_____________________________________________________________");
			SCM(extraid, PLAVA, "   Vortex Gaming Roleplay server");
			SCMF(extraid, ZELENA2,        " - Dobrodosli %s, ljepo Vas je opet videti na serveru!", ime);
			format(CmdString, 128,		" Nivo: [%d] | Novac: [$%d] | Iskustvo: [%d/%d] | Sati igre: [%d] | Gm: [%d] | Admin: [%d]", PI[extraid][Nivo], PI[extraid][Novac], PI[extraid][Iskustvo], exp, PI[extraid][SatiIgre], PI[extraid][GM], PI[extraid][Admin]);
			SCM(extraid, CRVENA,        CmdString);
			new datumregistracije[32], poslednjaaktivnost[32], imez[MAX_PLAYER_NAME];
			if(mysql_fetch_row(linija))
		   	{
      			sscanf(linija, "p<|>s[24]s[32]s[32]", imez, datumregistracije, poslednjaaktivnost);
			}
			mysql_free_result();
			format(CmdString, 128,		" Vasa zadnja aktivnost na serveru bila je : ,Datum registracije je :", PI[extraid][PoslednjaAktivnost],PI[extraid][DatumRegistracije]);
			SCM(extraid, SVETLOZELENA,        CmdString);
			SCMF(extraid, RADIO_BOJA,  " Vic dana: %s", Vicevi[randx]);
			if(PI[extraid][GOLD] > 0) SCMF(extraid, SVETLOPLAVA, "* Imate jos %d GOLD GOLD-a.", PI[extraid][GOLD]);
			if(Izbacen == 1)
			{
				PI[extraid][Clan] = 0;
	        	PI[extraid][Rank] = 0;
          		PI[extraid][Lider] = 0;
		        if(PI[extraid][Pol] == 0) { PI[extraid][Skin] = 212; h_SetPlayerSkin(extraid, 212); }
				else if(PI[extraid][Pol] == 1) { PI[extraid][Skin] = 211; h_SetPlayerSkin(extraid, 211); }
				SCM(extraid, TAMNOCRVENA, "* Izbaceni ste iz svoje organizacije/mafije/bande!");
				format(upit, 200, "UPDATE `Igraci` SET `Clan` = '0', `Lider` = '0', `Rank` = '0', `Skin` = '%d' WHERE `Ime` = '%s'", PI[extraid][Skin], hIme);
				mysql_query(upit, THREAD_OSTALO);
			}
			SCM(extraid, PLAVA, "_____________________________________________________________");
			if(PI[extraid][GM] > 0)
			{
			    format(CmdString, 64, "| VG GameMaster | %s je usao na server.", ime);
			    StaffPoruka(ZELENA2, CmdString);
			}
			if(PI[extraid][Admin] > 0 && PI[extraid][Admin] < HEAD)
			{
			    format(CmdString, 64, "| VG Admin | %s je usao na server.", ime);
			    StaffPoruka(SVETLOPLAVA, CmdString);
			}
			if(PI[extraid][Admin] >= HEAD)
			{
			    foreach(Player, i)
			    {
			        if(PI[i][Admin] >= HEAD || IsPlayerAdmin(i))
			        {
					    format(CmdString, 75, "| VG HeadAdmin | %s je usao na server.", ime);
					    SCM(i, TAMNOLJUBICASTA, CmdString);
					}
				}
			}
			if(PI[extraid][Kuca] != -1)
			{
			    if(strcmp(Kuce[PI[extraid][Kuca]][Vlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Kuca koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Kuce` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Kuca]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Stan] != -1)
			{
			    if(strcmp(Stanx[PI[extraid][Stan]][sVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Stan koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Stanovi` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Stan]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Vikendica] != -1)
			{
			    if(strcmp(Vikendice[PI[extraid][Vikendica]][vVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Vikendica koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Vikendice` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Vikendica]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Garaza] != -1)
			{
			    if(strcmp(Garaze[PI[extraid][Garaza]][gVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Garaza koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Garaze` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Garaza]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Firma] != -1)
			{
			    if(strcmp(Firme[PI[extraid][Firma]][fVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Firma koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Firme` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Firma]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][GM] < 0  && PI[extraid][Admin] < 0)
            {
            GRESKA(extraid);
        	return 1;
            }
			if(PI[extraid][JFirma] != -1)
			{
			    if(strcmp(JFirme[PI[extraid][JFirma]][jfVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}JFirma koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `JFirme` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][JFirma]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Hotel] != -1)
			{
			    if(strcmp(Hoteli[PI[extraid][Hotel]][hVlasnik], ime, true))
			    {
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Hotel koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					format(upitblabla, 64, "UPDATE `Hoteli` SET `Usao` = '1' WHERE `ID` = '%d'", PI[extraid][Hotel]);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Auto1] != -1)
			{
			    new i = PI[extraid][Auto1];
				if(strcmp(VInfo[i][hVlasnik], ime, true))
		  		{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Automobil (1) koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(VInfo[i][ownedvehicle]);
					VInfo[i][ownedvehicle] = CreateVehicle_H(VInfo[i][hModel], VInfo[i][hPozX], VInfo[i][hPozY], VInfo[i][hPozZ], VInfo[i][hPozA], VInfo[i][hBoja1], VInfo[i][hBoja2], 1000);
					LinkVehicleToInterior(VInfo[i][ownedvehicle], VInfo[i][hent]);
					SetVehicleVirtualWorld(VInfo[i][ownedvehicle], VInfo[i][hvw]);
					SetVehicleNumberPlate(VInfo[i][ownedvehicle], VInfo[i][hTablice]);
					SetVehicleToRespawn(VInfo[i][ownedvehicle]);
					IgracevAuto1[extraid] = i;
					format(upitblabla, 64, "UPDATE `Automobili` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Motor] != -1)
			{
			    new i = PI[extraid][Motor];
		  		if(strcmp(MInfo[i][mVlasnik], ime, true))
		  		{
			    	SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Motor koji se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(MInfo[i][mownedvehicle]);
				    MInfo[i][mownedvehicle] = CreateVehicle_H(MInfo[i][mModel], MInfo[i][mPozX], MInfo[i][mPozY], MInfo[i][mPozZ], MInfo[i][mPozA], MInfo[i][mBoja1], MInfo[i][mBoja2], 1000);
					LinkVehicleToInterior(MInfo[i][mownedvehicle], MInfo[i][ment]);
					SetVehicleVirtualWorld(MInfo[i][mownedvehicle], MInfo[i][mvw]);
					SetVehicleToRespawn(MInfo[i][mownedvehicle]);
					IgracevMotor[extraid] = i;
					format(upitblabla, 64, "UPDATE `Motori` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Bicikla] != -1)
			{
			    new i = PI[extraid][Bicikla];
				if(strcmp(BInfo[i][bhVlasnik], ime, true))
				{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Bicikla koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(BInfo[i][bownedvehicle]);
				    BInfo[i][bownedvehicle] = CreateVehicle_H(BInfo[i][bhModel], BInfo[i][bhPozX], BInfo[i][bhPozY], BInfo[i][bhPozZ], BInfo[i][bhPozA], BInfo[i][bhBoja1], BInfo[i][bhBoja2], 1000);
					LinkVehicleToInterior(BInfo[i][bownedvehicle], BInfo[i][bhent]);
					SetVehicleVirtualWorld(BInfo[i][bownedvehicle], BInfo[i][bhvw]);
					SetVehicleToRespawn(BInfo[i][bownedvehicle]);
					IgracevaBicikla[extraid] = i;
					format(upitblabla, 64, "UPDATE `Bicikle` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Plovilo] != -1)
			{
			    new i = PI[extraid][Plovilo];
		 		if(strcmp(PInfo[i][phVlasnik], ime, true))
				{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Plovilo koje se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(PInfo[i][pownedvehicle]);
			    	PInfo[i][pownedvehicle] = CreateVehicle_H(PInfo[i][phModel], PInfo[i][phPozX], PInfo[i][phPozY], PInfo[i][phPozZ], PInfo[i][phPozA], PInfo[i][phBoja1], PInfo[i][phBoja2], 1000);
					IgracevoPlovilo[extraid] = i;
					format(upitblabla, 64, "UPDATE `Plovila` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Letelica] != -1)
			{
			    new i = PI[extraid][Letelica];
				if(strcmp(LInfo[i][lhVlasnik], ime, true))
		  		{
			        SCM(extraid, CRVENA, "VGSecurity | {FFFFFF}Letelica koja se nalazi u Vasem nalogu nije vise u Vasem vlasnistvu!");
				}
				else
				{
					DestroyVehicle(LInfo[i][lownedvehicle]);
			    	LInfo[i][lownedvehicle] = CreateVehicle_H(LInfo[i][lhModel], LInfo[i][lhPozX], LInfo[i][lhPozY], LInfo[i][lhPozZ], LInfo[i][lhPozA], LInfo[i][lhBoja1], LInfo[i][lhBoja2], 1000);
					IgracevaLetelica[extraid] = i;
					format(upitblabla, 64, "UPDATE `Letelice` SET `Usao` = '1' WHERE `ID` = '%d'", i);
					mysql_query(upitblabla, THREAD_OSTALO);
				}
			}
			if(PI[extraid][Zatvoren] == 1)
		    {
				ResetPlayerWeaponsEx(extraid);
				new rand = random(sizeof(Celije));
				SetPlayerPos_H(extraid, Celije[rand][0], Celije[rand][1], Celije[rand][2]);
				SetPlayerFacingAngle(extraid, Celije[rand][3]);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Zavezan] == 1)
			{
				ResetPlayerWeaponsEx(extraid);
				new rand = random(sizeof(Celije));
				SetPlayerPos_H(extraid, Celije[rand][0], Celije[rand][1], Celije[rand][2]);
				SetPlayerFacingAngle(extraid, Celije[rand][3]);
				PI[extraid][Zatvoren] = 1;
				PI[extraid][ZatvorenVreme] = 3200;
				PI[extraid][Zavezan] = 0;
				SCM(extraid, CRVENA, "VGSecurity | {FF6347}Zato sto ste izasli iz igre za vreme hapsenja ili dok ste bili zavezani, automatski idete u zatvor!");
				new imex[MAX_PLAYER_NAME];
				RPIme(extraid, imex);
				format(CmdString, sizeof CmdString, "| Komanda: /zatvor | Izvrsio: VGSecurity | Igrac: %s | Razlog: Umiranje pri hapsenju/otmici", imex);
				UpisiLog(FAJL_KAZNELOG, CmdString);
				new kkk[MAX_PLAYER_NAME], kk[128];
				ImeIgraca(extraid, kkk);
				format(kk, 128, "UPDATE `Igraci` SET `Zavezan` = '0' WHERE `Ime` = '%s'", kkk);
				mysql_query(kk, THREAD_OSTALO);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Zatvoren] == 2)
			{
				SetPlayerPos_H(extraid, 107.2300,1920.6311,18.5208);
				SetPlayerWorldBounds(extraid, 337.5694,101.5826,1940.9759,1798.7453);
				ResetPlayerWeaponsEx(extraid);
				SetPlayerInterior_H(extraid, 0);
				SetPlayerVirtualWorld_H(extraid, 0);
			}
			if(PI[extraid][Clan] == 3 || PI[extraid][Clan] == 7) hNaDuznosti[extraid] = 1;
			new ip[16], logstring[256];
			ImeIgraca(extraid, hIme);
		 	GetPlayerIp(extraid, ip, sizeof ip);
		   	format(logstring, sizeof logstring, "| LOGIN | Igrac: %s | IP: %s", hIme, ip);
			UpisiLog(FAJL_SLOGINLOG, logstring);
		}


pfff nezz do cega je ovdje je sve uredu, probaj nesto napraviti kada se konektuje da provjeri dali je banovan..Dodaj ovo pod OnPlayerConnect;
if(PI[extraid][Banovan] == 1)
			{
			    new cupit[100];
			    format(cupit, sizeof(cupit), "SELECT * FROM `Banovi` WHERE `Ime` = '%s' ORDER BY `ID` DESC LIMIT 1", hIme);
			    mysql_query(cupit, THREAD_BANINFO, extraid);
				return 1;
			}

My Bike KTM 450 SXF 2008