18.10.2016, 14:49
why i can add players who are not connected?
what is wrong
Код HTML:
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(handle,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(handle, str1, sizeof(str1), "INSERT INTO `friends` (`PlayerID`,`FriendID`,`FriendName`) VALUES('%d','%d','%s')",PlayerInfo[playerid][pSQLID],PlayerInfo[id][pSQLID],PlayerInfo[id][pSQLID]); mysql_tquery(handle,str1,"",""); SendClientMessage(playerid, COLOR_YELLOW, "Prieten adaugat!"); } else if(!IsNumeric(text)) { new find = 0; foreach(new i : Player) { 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(handle,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(handle, str1, sizeof(str1), "INSERT INTO `friends` (`PlayerID`,`FriendID`,`FriendName`) VALUES('%d','%d','%s')",PlayerInfo[playerid][pSQLID],PlayerInfo[i][pSQLID],PlayerInfo[i][pSQLID]); mysql_tquery(handle,str1,"",""); SendClientMessage(playerid, COLOR_YELLOW, "Prieten adaugat!"); } } } else { SendClientMessage(playerid, COLOR_WHITE, "ID invalid. Poti adauga doar playerii care-s online in lista de prieteni."); return 1; } } } } }