/offmembers

[Pavel-KZ]

Здравствуйте сделал команду /offmembers на MySQL R6

YCMD:offmembers(playerid, params[], help)
{
    new Names[MAX_PLAYER_NAME];
    new OffMembers;
    new Rank;
    new Vxod[32];
    new OnlineLid[32];
    if(PlayerInfo[playerid][pLogin] == 0) return true;
	if(PlayerInfo[playerid][pLeader] == 0) return SendClientMessage(playerid, COLOR_GRAD1, "Вам недоступна эта функция!");
	SendClientMessage(playerid, 0x059BD3FF, "Список игроков: [Ник] [Ранг] [Последний вход] [Время игры]");
    format(YCMDstr, sizeof(YCMDstr), "SELECT * FROM `accounts` WHERE pMember = '%d'",PlayerInfo[playerid][pMember]);
	mysql_query(YCMDstr);
	mysql_store_result();
	if(mysql_fetch_row_format(YCMDstr))
	{
	    BaseGet("Name",Names);
		BaseGetInt("pLogin",OffMembers);
		BaseGetInt("pRank",Rank);
		BaseGet("pOnline",Vxod);
		BaseGet("pOnlineLid",OnlineLid);
		if(OffMembers == 0)
		{
			format(YCMDstr, sizeof(YCMDstr), "[%s] [%d] [%s] [%s]",Names, Rank,Vxod,OnlineLid);
			SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
		}
	    while(mysql_next_row())
	    {
			BaseGet("Name",Names);
			BaseGetInt("pLogin",OffMembers);
			BaseGetInt("pRank",Rank);
			BaseGet("pOnline",Vxod);
			BaseGet("pOnlineLid",OnlineLid);
			if(OffMembers == 0)
			{
				format(YCMDstr, sizeof(YCMDstr), "[%s] [%d] [%s] [%s]",Names, Rank,Vxod,OnlineLid);
				SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
			}
		}
	}
	else SendClientMessage(playerid, COLOR_GRAD1,"Не найдено совпадений");
	mysql_free_result();
	return true;
}

Screen: