Дима_98
Умник
Здраствуйте. У меня к вам попрос. Мод SRP-Ukraine. В мануалах нашел команду смотреть всех лидеров сервера для админов. Вопрос будет ли работать эта команда, правильно ли идет запрос в БД. Подскажите пожалуйста.
PHP:
cmd:aleaders(playerid, params[])
{
if(PlayerInfo[playerid][pAlcoInvenxua] > 1) return mysql_format(connects,string,sizeof(string),"SELECT * FROM `accounts` WHERE `pLeader` = '%d'", PlayerInfo[playerid]);
return true;
}
PHP:
forward Leaders(playerid, query[]);
public Leaders(playerid, query[])
{
new rows = cache_num_rows();
if(rows)
{
new online[20];
new name[24],leader;
new ttextt[32],leadertt[32];
stringer = "";
while(--rows >= 0)
{
leader = cache_get_field_content_int (rows, "pLRInections");
cache_get_field_content(rows,"Name", name, connects, 24);
cache_get_field_content(rows, "pGetonDate", online, connects, 20);
switch (leader)
{
case 1: leadertt = "{2641FE}LSPD\t\t";
case 2: leadertt = "{313131}ФБР\t\t";
case 3: leadertt = "{33AA33}Армия: Авианосец";
case 4: leadertt = "{A52A2A}МЧС\t\t";
case 5: leadertt = "{DDA701}LCN\t\t";
case 6: leadertt = "{FF0000}Yakuza\t\t";
case 7: leadertt = "{114D71}Мэрия\t\t";
case 8: leadertt = "{B313E7}Casino Rich";
case 10: leadertt = "{2641FE}SFPD\t\t";
case 11: leadertt = "{139BEC}Инструкторы";
case 12: leadertt = "{8813E7}The Ballas\t";
case 13: leadertt = "{DBD604}The Vagos\t";
case 14: leadertt = "{B4B5B7}Русская мафия";
case 15: leadertt = "{009F00}The Grove\t";
case 16: leadertt = "{40848B}San News\t";
case 17: leadertt = "{01FCFF}The Aztecas\t";
case 18: leadertt = "{83BFBF}The Rifa\t\t";
case 19: leadertt = "{33AA33}Армия: Зона 51";
case 21: leadertt = "{2641FE}LVPD\t\t";
case 23: leadertt = "{708090}Хитман\t\t";
case 24: leadertt = "{F45000}Street Racers ";
case 25: leadertt = "{2E8B57}SWAT\t\t";
case 26: leadertt = "{708090}Правительство";
case 27: leadertt = "{33AA33}Военно Морской Флот";
default: leadertt = "{FFD300}Неизвестно";
}
if(IsPlayerConnected(GetPlayerID(name))) { ttextt = "[{2CE40C}Онлайн{FFFFFF}]"; }
else if(!IsPlayerConnected(GetPlayerID(name))) { ttextt = "[{E40C0C}Оффлайн{FFFFFF}]"; }
format(stringer1,BIG_SIZE,"{FFFFFF}%s {ffffff}%s {ffffff}%s Дата последнего посещения: %s\n",leadertt,name,ttextt,online); strcat(stringer,stringer1);
}
SPD(playerid,7822,DIALOG_STYLE_MSGBOX,"Лидеры организаций:\t",stringer,"Готово","");
}
else SendClientMessage(playerid, 0xFF0000AA, "Данные не найдены.");
return true;
}