Problem😄anem sebi lidera preko scripting fajlsa udjem u igricu ukucam /sviclanovi i nista neizbaci
CMD:sviclanovi(playerid, params[])
{
new otext;
new clan1;
new clan2;
new clan3;
new clan4;
new clan5;
new clan6;
new clan7;
new clan8;
new clan9;
new clan10;
new clan11;
new clan12;
new lider2;
new lider1;
if(PlayerInfo == 0){SendClientMessage(playerid,-1,"Samo Lideri");}
if(PlayerInfo != 0)
{
if(PlayerInfo == 1) { otext = "LSPD"; }
else if(PlayerInfo == 2) { otext = "FBI"; }
else if(PlayerInfo == 3) { otext = "MD"; }
else if(PlayerInfo == 4) { otext = "LCN"; }
else if(PlayerInfo == 5) { otext = "Y"; }
else if(PlayerInfo == 6) { otext = "GSF"; }
else if(PlayerInfo == 7) { otext = "ESL"; }
else if(PlayerInfo == 8){ otext = "Hitman"; }
else if(PlayerInfo == 9) { otext = "CNN"; }
else if(PlayerInfo == 10) { otext = "BB"; }
new query;
new string2b;
new string2a;
new string2s;
new string2c;
new DBResult:qresult;
format(string2s,sizeof(string2s),"LSPD");
format(query,sizeof(query),"SELECT CLAN1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
qresult = db_query(Database,query);
new DBResult:clan2r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan2r = db_query(Database,query);
new DBResult:clan3r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN3 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan3r = db_query(Database,query);
new DBResult:clan4r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN4 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan4r = db_query(Database,query);
new DBResult:clan5r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN5 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan5r = db_query(Database,query);
new DBResult:clan6r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN6 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan6r = db_query(Database,query);
new DBResult:clan7r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN7 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan7r = db_query(Database,query);
new DBResult:clan8r;
//format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN8 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan8r = db_query(Database,query);
new DBResult:clan9r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN9 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan9r = db_query(Database,query);
new DBResult:clan10r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN10 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan10r = db_query(Database,query);
new DBResult:clan11r;
//format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN11 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan11r = db_query(Database,query);
new DBResult:clan12r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT CLAN11 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
clan12r = db_query(Database,query);
new DBResult:lider1r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
lider1r = db_query(Database,query);
new DBResult:lider2r;
// format(PlayerInfo,sizeof(PlayerInfo),"LSPD");
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", otext);
lider2r = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,clan1,128);
db_get_field(clan2r,0,clan2,128);
db_get_field(clan3r,0,clan3,128);
db_get_field(clan4r,0,clan4,128);
db_get_field(clan5r,0,clan5,128);
db_get_field(clan6r,0,clan6,128);
db_get_field(clan7r,0,clan7,128);
db_get_field(clan8r,0,clan8,128);
db_get_field(clan9r,0,clan9,128);
db_get_field(clan10r,0,clan10,128);
db_get_field(clan11r,0,clan11,128);
db_get_field(clan12r,0,clan12,128);
db_get_field(lider1r,0,lider1,128);
db_get_field(lider2r,0,lider2,128);
//format(string22,sizeof(string22),"Lideri:|%s|%s|",clan13,clan14);
// SendClientMessage(playerid,0xAFAFAFAA,string22);
// format(string2,sizeof(string2),"Clanovi:|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|",clan1,clan2,clan3,clan4,clan5,clan6,clan7,clan8,clan9,clan10,clan11,clan12);
// SendClientMessage(playerid,0xAFAFAFAA,clan1s);
format(string2b, sizeof(string2b),"Lideri:|%s|%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,string2b);
format(string2a,sizeof(string2a),"Clanovi:1-%s|2-%s|3-%s|4-%s|5-%s|6-%s|",clan1,clan2,clan3,clan4,clan5,clan6);
SendClientMessage(playerid,0xE8C061FF,string2a);
format(string2c,sizeof(string2c),"Clanovi:7-%s|8-%s|9-%s|10-%s|11-%s|12-%s|",clan7,clan8,clan9,clan10,clan11,clan12);
}
db_free_result(qresult);
}
return 1;
}tako i za
CMD:svilideri(playerid, params[])
{
new idx;
new query;
if(PlayerInfo >= 1338)
{
temp = strtok(params, idx);
if(!strlen(temp)) {
SendClientMessage(playerid,-1,"/svilideri [Broj Organizacije]");
SendClientMessage(playerid,-1,"*Napomena: Broj u [ ] je broj lidera za smjeniti");
}
new number = strval(temp);
if(number < 1 || number > 12) { SendClientMessage(playerid, -1, "Organizacija je od 1-10"); return 1; }
if(number == 1)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"LSPD");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri LSPD-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 2)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"FBI");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri FBI-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 3)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"MD");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri MD-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 4)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"LCN");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri LCN-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 5)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"Y");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri Yakuze:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 6)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"GSF");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri GSF-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 7)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"ESL");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri ESL-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 8)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"Hitman");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri Hitman-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 9)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"CNN");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri CNN-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
if(number == 10)
{
new DBResult:qresult;
new DBResult:qresult2;
new string2s;
new finalstring;
new lider1;
new lider2;
format(string2s,sizeof(string2s),"BB");
format(query,sizeof(query),"SELECT LEADER1 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult = db_query(Database,query);
format(query,sizeof(query),"SELECT LEADER2 FROM `ORGANIZACIJE` WHERE ORGANIZACIJA = '%s'", string2s);
qresult2 = db_query(Database,query);
if(db_num_rows(qresult))
{
db_get_field(qresult,0,lider1,128);
db_get_field(qresult2,0,lider2,128);
format(finalstring,sizeof(finalstring),"Lideri BB-a:|1|-%s||2|-%s|",lider1,lider2);
SendClientMessage(playerid,0xE8C061FF,finalstring);
}
}
}
else
{
SendClientMessage(playerid, COLOR_GRAD1, "{FFFFFF}[{F81414}ClioX{FFFFFF}]{CCCCCC}Admini 1338+ samo");
}
return 1;
}