15.11.2016, 13:46
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 ?
this are the dialogs do i have when you want to ad and when is added
this are the dialogs do i have when you want to ad and when is added
Код 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."); } } } }