If(newkeys & KEY_YES)
{
if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
if(IsPlayerConnected(playerid))
{
new online[1000],offline[1000],query[300],result[30],name[30],idd,mid=1,aim2[2000];
format(query, sizeof(query), "SELECT * FROM `friends` WHERE `PlayerID` = '%d' AND `Status`='1'",PlayerInfo[playerid][pSQLID]);
new Cache: membresult = mysql_query(SQL,query);
for(new i, j = cache_get_row_count (); i != j; ++i)
{
idd = cache_get_field_content_int(i, "FriendID");
cache_get_field_content(i, "FriendName", result); format(name, 30, result);
Selected[playerid][mid] = idd;
format(online, sizeof(online), "%s{228404}[online]{FFFFFF} %s\n",online,name);
mid++;
}
cache_delete(membresult);
format(query, sizeof(query), "SELECT * FROM `friends` WHERE `PlayerID` = '%d' AND `Status`='0'",PlayerInfo[playerid][pSQLID]);
new Cache: membresult1 = mysql_query(SQL,query);
for(new i, j = cache_get_row_count (); i != j; ++i)
{
idd = cache_get_field_content_int(i, "FriendID");
cache_get_field_content(i, "FriendName", result); format(name, 30, result);
Selected[playerid][mid] = idd;
format(offline, sizeof(offline), "%s{BB172D}[offline]{FFFFFF} %s\n",offline,name);
mid++;
}
cache_delete(membresult1);
format(aim2,sizeof(aim2),"{F89B0E}[+] Add Friend\n%s%s",online, offline);
ShowPlayerDialog(playerid, DIALOG_FRIENDS, DIALOG_STYLE_LIST, "Friends", aim2, "Select", "Exit");
}
}