MySQL errors in log.
#2

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);
}
Reply


Messages In This Thread
MySQL errors in log. - by Creax - 13.11.2013, 19:05
Re: MySQL errors in log. - by WopsS - 14.11.2013, 04:27
Re: MySQL errors in log. - by Creax - 14.11.2013, 08:05
Re: MySQL errors in log. - by Creax - 14.11.2013, 17:47

Forum Jump:


Users browsing this thread: 1 Guest(s)