hey guys i have a friend sistem that isn't working properly i can add people who are not on the server , can someone help me out ?
Код HTML:
if(dialogid == DIALOG_FRIENDS)
{
if(response)
{
if(listitem == 0)
{
ShowPlayerDialog(playerid, DIALOG_ADDFRIENDS, DIALOG_STYLE_INPUT, "Add friend", "Type ID of the player you want to add as a friend:", "Add Friend", "Exit");
}
if(listitem > 0)
{
new query[256],name[30],result[30],idd,status,title[50];
format(query, sizeof(query), "SELECT name, id, Status FROM `users` WHERE `id`='%d'",Selected[playerid][listitem]);
new Cache: membresult = mysql_query(SQL,query);
for(new i, j = cache_get_row_count (); i != j; ++i)
{
cache_get_field_content(i, "name", result); format(name, 30, result);
idd = cache_get_field_content_int(i, "id");
status = cache_get_field_content_int(i, "Status");
Selected2[playerid] = idd;
if(status > 0)
{
format(title, sizeof(title), "[online] %s", name);
}
else if(status == 0)
{
format(title, sizeof(title), "[offline] %s", name);
}
}
cache_delete(membresult);
ShowPlayerDialog(playerid, DIALOG_FRIENDS2, DIALOG_STYLE_LIST, title, "Remove Friend\nView phone number", "Select", "Exit");
}
}
}
if(dialogid == DIALOG_ADDFRIENDS)
{
if(response)
{
new text[50];
mysql_real_escape_string(inputtext, text);
if(IsNumeric(text))
{
new str1[256],id = strval(text);
if(id == playerid) return SendClientMessage(playerid, COLOR_WHITE, "Nu te poti adauga singur in lista de prieteni.");
format(str1, sizeof(str1), "SELECT * FROM `friends` WHERE `FriendID`='%d' AND `PlayerID`='%d'",PlayerInfo[id][pSQLID],PlayerInfo[playerid][pSQLID]);
new Cache: membresult = mysql_query(SQL,str1);
if(cache_get_row_count () > 0)
{
SendClientMessage(playerid, COLOR_WHITE, "Acel jucator este deja in lista ta de prieteni.");
return 1;
}
cache_delete(membresult);
mysql_format(SQL, str1, sizeof(str1), "INSERT INTO `friends` (`PlayerID`,`FriendID`,`FriendName`) VALUES('%d','%d','%s')",PlayerInfo[playerid][pSQLID],PlayerInfo[id][pSQLID],PlayerInfo[id][pNormalName]);
mysql_tquery(SQL,str1,"","");
SendClientMessage(playerid, COLOR_YELLOW, "Prieten adaugat!");
}
else if(!IsNumeric(text))
{
new find = 0;
foreach(Player, i)
{
if(IsPlayerConnected(i))
{
if(find == 0)
{
new name[30],str1[256];
GetPlayerName(i, name, sizeof(name));
if(strfind(name, text) != -1)
{
find = 1;
if(i == playerid) return SendClientMessage(playerid, COLOR_WHITE, "Nu te poti adauga singur in lista de prieteni.");
format(str1, sizeof(str1), "SELECT * FROM `friends` WHERE `FriendID`='%d' AND `PlayerID`='%d'",PlayerInfo[i][pSQLID],PlayerInfo[playerid][pSQLID]);
new Cache: membresult = mysql_query(SQL,str1);
if(cache_get_row_count () > 0)
{
SendClientMessage(playerid, COLOR_WHITE, "Acel jucator este deja in lista ta de prieteni.");
return 1;
}
cache_delete(membresult);
mysql_format(SQL, str1, sizeof(str1), "INSERT INTO `friends` (`PlayerID`,`FriendID`,`FriendName`) VALUES('%d','%d','%s')",PlayerInfo[playerid][pSQLID],PlayerInfo[i][pSQLID],PlayerInfo[i][pNormalName]);
mysql_tquery(SQL,str1,"","");
SendClientMessage(playerid, COLOR_YELLOW, "Prieten adaugat!");
}
}
}
else return SendClientMessage(playerid, COLOR_WHITE, "ID invalid. Poti adauga doar playerii care-s online in lista de prieteni.");
}
if(find == 0)
{
SendClientMessage(playerid, COLOR_WHITE, "ID invalid. Poti adauga doar playerii care-s online in lista de prieteni.");
}
}
}
}