Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: [Euro Samp]Shadow poslato Septembar 21, 2013, 15:10:08 POSLE PODNE

Naslov: [pomoc]ban info
Poruka od: [Euro Samp]Shadow poslato Septembar 21, 2013, 15:10:08 POSLE PODNE
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
Naslov: Odg: [pomoc]ban info
Poruka od: [Euro Samp]Shadow poslato Septembar 21, 2013, 16:22:12 POSLE PODNE
mozes malo detaljnije?pls  :)
Naslov: Odg: [pomoc]ban info
Poruka od: [Euro Samp]Shadow poslato Septembar 21, 2013, 21:05:10 POSLE PODNE
ZNA KO??
Naslov: Odg: [pomoc]ban info
Poruka od: [Euro Samp]Shadow poslato Septembar 22, 2013, 10:20:12 PRE PODNE
*BUMP*
Naslov: Odg: [pomoc]ban info
Poruka od: Vuzimir poslato Septembar 22, 2013, 19:31:12 POSLE PODNE
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
Naslov: Odg: [pomoc]ban info
Poruka od: [Euro Samp]Shadow 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);
}
Naslov: Odg: [pomoc]ban info
Poruka od: Vuzimir poslato Septembar 23, 2013, 14:44:57 POSLE PODNE
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;
}