[zeth98]

Hei guys I taked this filterscript from the forum https://sampforum.blast.hk/showthread.php?tid=446329
And don't have the function to delete maybe help me?

format(Querys,sizeof(Querys),"DELETE FROM friendlist WHERE fr_name = %s", giveplayerid);
mysql_query(Querys);

giveplayerid is the name who I typed

[zeth98]

what mysql function i need to use?

[Sinox]

Try this:

Код:

format(Querys,sizeof(Querys),"DELETE FROM friendlist WHERE fr_name = '%s'", giveplayerid);

[zeth98]

Quote:

Originally Posted by Sinox Try this: Код: format(Querys,sizeof(Querys),"DELETE FROM friendlist WHERE fr_name = '%s'", giveplayerid);

If i am friend with 3 player and one delete me i deleted from all player friend list.

[mamorunl]

fr_name should probably be a string? So GetPlayerName()? Also: add in an additional parameter: "AND <my_id>=%d". Or however your database is set up.

[zeth98]

Quote:

format(string,sizeof(string),"DELETE FROM friendlist WHERE fr_name = '%s' AND username = '%s' ",(result),PlayerName(playerid)); mysql_query(string);

Thanks it work