Помогите оптимизировать код
Приветствую. Не подскажите? Как можно максимально оптимизировать и сократить данный код:
PHP код:
case 5859:
{
new vsegostr = PlayerInfo[playerid][pVsegostr];
new stranica = PlayerInfo[playerid][pStranica];
if(!response) return ShowPlayerDialog(playerid,5858,DIALOG_STYLE_LIST,"OFFMEMBERS","- Весь состав\n- По рангу","Далее","Отмена");
if(PlayerInfo[playerid][pOrderRank] == 0)
{
switch(listitem)
{
case 0:
{
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 1:
{
if(stranica == 0) return 1;
if(vsegostr == 1) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 2:
{
if(stranica == 0) return 1;
if(vsegostr == 2) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 3:
{
if(stranica == 0) return 1;
if(vsegostr == 3) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 4:
{
if(stranica == 0) return 1;
if(vsegostr == 4) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 5:
{
if(stranica == 0) return 1;
if(vsegostr == 5) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 6:
{
if(stranica == 0) return 1;
if(vsegostr == 6) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 7:
{
if(stranica == 0) return 1;
if(vsegostr == 7) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 8:
{
if(stranica == 0) return 1;
if(vsegostr == 8) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 9:
{
if(stranica == 0) PlayerInfo[playerid][pStranica] += 8;
if(vsegostr == 9 && stranica > 0) PlayerInfo[playerid][pStranica] -= 8;
if(vsegostr == 10 && stranica > 0) PlayerInfo[playerid][pStranica] += 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 10:
{
switch(stranica)
{
default:
{
PlayerInfo[playerid][pStranica] -= 8;
}
}
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
}
}
else
{
switch(listitem)
{
case 0:
{
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 1:
{
if(stranica == 0) return 1;
if(vsegostr == 1) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 2:
{
if(stranica == 0) return 1;
if(vsegostr == 2) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 3:
{
if(stranica == 0) return 1;
if(vsegostr == 3) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 4:
{
if(stranica == 0) return 1;
if(vsegostr == 4) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 5:
{
if(stranica == 0) return 1;
if(vsegostr == 5) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 6:
{
if(stranica == 0) return 1;
if(vsegostr == 6) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 7:
{
if(stranica == 0) return 1;
if(vsegostr == 7) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 8:
{
if(stranica == 0) return 1;
if(vsegostr == 8) PlayerInfo[playerid][pStranica] -= 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 9:
{
if(stranica == 0) PlayerInfo[playerid][pStranica] += 8;
if(vsegostr == 9 && stranica > 0) PlayerInfo[playerid][pStranica] -= 8;
if(vsegostr == 10 && stranica > 0) PlayerInfo[playerid][pStranica] += 8;
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
case 10:
{
switch(PlayerInfo[playerid][pStranica])
{
default:
{
PlayerInfo[playerid][pStranica] -= 8;
}
}
mysql_format(dbHandle, strings, 128, "SELECT * FROM `accounts` WHERE `Member` = '%d' ORDER BY `accounts`.`Rank` ASC LIMIT %d , 8", PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pStranica]);
mysql_function_query(dbHandle, strings, true, "OnPlayerSelectOffmembers", "i", playerid);
return true;
}
}
}
ShowPlayerDialogUninvite(playerid, inputtext);
}