С переводом команды

[vitalik6243]

Здраствуйте у меня такой вопрос вот команда написана на MySQL R7 но я его не понимаю

CMD:leaders(playerid, params[])
{ 
    mysql_function_query(mysql, "SELECT * FROM  `rls_akk` WHERE  `Leader` !=0 ORDER BY  `rls_akk`.`Leader` DESC", true, "Leaders", "i", playerid); 
    return true;
}
forward Leaders(playerid, query[]) 
public Leaders(playerid, query[]) 
{ 
    new rows, fields; 
    cache_get_data(rows, fields); 
    if(rows) 
    {   
        new vresult[64];  
           new name[24],leader;
        new str[128],sctring[2046],ttextt[32],leadertt[32];
        while(--rows >= 0) 
        {  
            cache_get_field_content(rows,"Leader", vresult);leader = strval(vresult); 
            cache_get_field_content(rows,"Name", name);
            switch (leader)
            {
                case 1:leadertt = "LSPD:\t";
                case 2:leadertt = "FBI:\t";
                case 3:leadertt = "SFa:\t";
                case 4:leadertt = "МЧС SF:";
                case 5:leadertt = "LCN:";
                case 6:leadertt = "Yakuza:";
                case 7:leadertt = "Мэрия:\t";
                case 8:leadertt = "Байкеры:";
                case 9:leadertt = "SF NEWS:";
                case 10:leadertt = "SFPD:\t";
                case 11:leadertt = "Инструкторы:";
                case 12:leadertt = "Ballas:\t";
                case 13:leadertt = "Vagos:";
                case 14:leadertt = "РМ:\t";
                case 15:leadertt = "Grove Street:";
                case 17:leadertt = "The Aztecas:";
                case 18:leadertt = "The Rifa:";
                case 19:leadertt = "Зона 51:";
                case 21:leadertt = "LVPD:\t";
                case 23:leadertt = "Хитманы:";
                case 25:leadertt = "ДПС:\t";
            }  
            if(IsPlayerConnected(GetPlayerID(name))) { ttextt = "{2CE40C}Онлайн{FFFFFF}"; }
            else if(!IsPlayerConnected(GetPlayerID(name))) { ttextt = "{E40C0C}Оффлайн{FFFFFF}"; } 
            format(str,sizeof(str),"{FFFFFF}%s\t\t %s (%s)\n",leadertt,name,ttextt); strcat(sctring,str); 
        }
        ShowPlayerDialog(playerid,00000,DIALOG_STYLE_MSGBOX,"Лидеры организаций:\t",sctring,"Готово","");
    } 
    else SendMes(playerid, 0xFF0000AA, "Данные не найдены."); 
    return true; 
}

А теперь такой вопрос я ее перевел на R6 правильно ли я это сделал?

CMD:leaders(playerid, params[])
{
    format(CMDstr, sizeof(CMDstr), "SELECT * FROM  `accounts` WHERE  `Leader` !=0 ORDER BY  `accounts`.`Leader` DESC", playerid);
	mysql_store_result();
	if(mysql_num_rows() > 0)
	{
		new vresult[64];
        new name[24],leader;
        new str[128],sctring[2046],ttextt[32],leadertt[32];
		for (new i = 1;i <= mysql_num_rows();i ++)
		{
			BaseGet("Leader", vresult);leader = strval(vresult);
            BaseGet("Name", name);
            switch (leader)
            {
                case 1:leadertt = "LSPD:\t";
                case 2:leadertt = "FBI:\t";
                case 3:leadertt = "SFa:\t";
                case 4:leadertt = "МЧС SF:";
                case 5:leadertt = "LCN:";
                case 6:leadertt = "Yakuza:";
                case 7:leadertt = "Мэрия:\t";
                case 8:leadertt = "Байкеры:";
                case 9:leadertt = "SF NEWS:";
                case 10:leadertt = "SFPD:\t";
                case 11:leadertt = "Инструкторы:";
                case 12:leadertt = "Ballas:\t";
                case 13:leadertt = "Vagos:";
                case 14:leadertt = "РМ:\t";
                case 15:leadertt = "Grove Street:";
                case 17:leadertt = "The Aztecas:";
                case 18:leadertt = "The Rifa:";
                case 19:leadertt = "Зона 51:";
                case 21:leadertt = "LVPD:\t";
                case 23:leadertt = "Хитманы:";
                case 25:leadertt = "ДПС:\t";
            }
            if(IsPlayerConnected(GetPlayerID(name))) { ttextt = "{2CE40C}Онлайн{FFFFFF}"; }
            else if(!IsPlayerConnected(GetPlayerID(name))) { ttextt = "{E40C0C}Оффлайн{FFFFFF}"; }
            format(str,sizeof(str),"{FFFFFF}%s\t\t %s (%s)\n",leadertt,name,ttextt); strcat(sctring,str);
        }
        ShowPlayerDialog(playerid,00000,DIALOG_STYLE_MSGBOX,"Лидеры организаций:\t",sctring,"Готово","");
    }
    else SendClientMessage(playerid, 0xFF0000AA, "Данные не найдены.");
    mysql_free_result();
    return true;
}