continue
Специалист
Парни помогите первисти комнаду и код
PHP:
new rows = sql_num_rows(r);
if(rows)
{
new id = sql_get_field_assoc_int(r, "id");
new query[128];
format(query, 128, "SELECT `time`, `reason` FROM `ban` WHERE `takeid` = '%d'",id);
new Result:bantest = sql_query(zConn, query, QUERY_CACHED);
if(sql_num_rows(bantest))
{
new result[64];
sql_fetch_row(bantest,"|",result);
new time, reason[128];
sscanf(result,"p<|>is[128]",time,reason);
time = time - gCurDay;
if(time <= 0) {
format(query, 128, "DELETE FROM `ban` WHERE `takeid` = '%d'",id);
sql_query(zConn, query);
}
else
{
if(time == -1) format(query,sizeof(query),"Вы забанены по причине: '%s'",reason);
else format(query,sizeof(query),"Вы забанены по причине: '%s'. Осталось дней: %d",reason,time);
SendClientMessage(playerid,CBADINFO,query);
sql_free_result(r);
NewKick(playerid);
return 1;
}
}
PHP:
if(!strcmp(cmd, "/showall", true))
{
if(!pData[playerid][pFraction]) return SendClientMessage(playerid,CGRAY,"Вы не состоите во организации");
new query[2046];
if(pData[playerid][pSubfraction]) {
if(pData[playerid][pRank] < gFractionRankCount[pData[playerid][pFraction]-1]-1) return SendClientMessage(playerid,CGRAY,"Команда доступна только лидеру организации.");
format(query, sizeof(query), "SELECT `nickname`,`rank`,`level` FROM `accounts` WHERE `fraction` = %d AND `subfraction` = %d ORDER BY `rank`", pData[playerid][pFraction], pData[playerid][pSubfraction]);
}
else {
if(pData[playerid][pRank] < gFractionRankCount[pData[playerid][pFraction]-1]) return SendClientMessage(playerid,CGRAY,"Команда доступна только лидеру организации.");
format(query, sizeof(query), "SELECT `nickname`,`rank`,`level` FROM `accounts` WHERE `fraction` = %d AND `subfraction` = 0 ORDER BY `rank`", pData[playerid][pFraction], pData[playerid][pSubfraction]);
}
new Result:r = sql_query(zConn, query, QUERY_CACHED);
if(sql_num_rows(r)) {
format(query, sizeof(query), "Уровень\tИмя игрока\tРанг\n\n");
new nn[MAX_PLAYER_NAME], rank, lvl;
for(new i; i<sql_num_rows(r); i++)
{
sql_get_field_ex(r, i, 0, nn);
rank = sql_get_field_int_ex(r, i, 1);
lvl = sql_get_field_int_ex(r, i, 2);
format(query, sizeof(query), "%s\t%d\t%s\t\t%d\n",query, lvl,nn, rank);
}
ShowPlayerDialog(playerid, 0000, 0, "Список сотрудников:",query,"Ок", "");
}
else SendClientMessage(playerid, CGRAY, "Произошла ошибка базы данных");
sql_free_result(r);
return 1;
}