14.11.2013, 04:27
You must put ' at 0 and 1!
pawn Код:
stock AddFriend(playerid, friend[]) {
new query[256];
format(query, sizeof(query), "INSERT INTO `Znajomi` (`Nick`, `Znajomy`, `Akceptowane`) VALUES('%s', '%s', '0')", GetPlayerNick(playerid), friend);
mysql_query(query);
}
stock RemoveFriend(playerid, friend[]) {
new query[256];
format(query, sizeof(query), "DELETE FROM `Znajomi` WHERE (`Nick` = '%s' AND `Znajomy` = '%s') OR (`Znajomy` = '%s' AND `Nick` = '%s')", GetPlayerNick(playerid), friend, GetPlayerNick(playerid), friend);
mysql_query(query);
}
stock IsInvitedFriend(playerid, friend[]) {
new query[256];
new bool:isfriend = false;
format(query, sizeof(query), "SELECT * FROM `Znajomi` WHERE (`Nick` = '%s' AND `Znajomy` = '%s' AND `Akceptowane` = '0') OR (`Nick` = '%s' AND `Znajomy` = '%s' AND `Akceptowane` ='0')",
GetPlayerNick(playerid), friend, friend, GetPlayerNick(playerid));
mysql_query(query);
mysql_store_result();
isfriend = mysql_num_rows()>0;
mysql_free_result();
return isfriend;
}
stock IsAcceptedFriend(playerid, friend[]) {
new query[256];
new bool:isfriend = false;
format(query, sizeof(query), "SELECT * FROM `Znajomi` WHERE (`Nick` = '%s' AND `Znajomy` = '%s' AND `Akceptowane` = '1') OR (`Nick` = '%s' AND `Znajomy` = '%s' AND `Akceptowane` = '1') ",
GetPlayerNick(playerid), friend, friend, GetPlayerNick(playerid));
mysql_query(query);
mysql_store_result();
isfriend = mysql_num_rows()>0;
mysql_free_result();
return isfriend;
}
stock AcceptFriend(playerid, friend[]) {
new query[256];
format(query, sizeof(query), "UPDATE `Znajomi` SET `Akceptowane` = '1' WHERE (`Nick` = '%s' AND `Znajomy` = '%s') OR (`Nick` = '%s' AND `Znajomy` = '%s')",
GetPlayerNick(playerid), friend, friend, GetPlayerNick(playerid));
mysql_query(query);
}