MySQL ban SELECT error - Printable Version

MySQL ban SELECT error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL ban SELECT error (/showthread.php?tid=629125)

MySQL ban SELECT error - Banditul18 - 20.02.2017

Hello, i make a kind of ban system but when i try to check the databse this error happens:

PHP код:



(error #1054) Unknown column 'Banditul' in 'where clause' (Query: "SELECT * FROM `bans` WHERE (`BanName` = `Banditul` OR `IP` = '127.0.0.1') LIMIT 1")

SELECT statement at OnPlayerConnect:

PHP код:



mysql_format(g_SQL, query, sizeof(query),"SELECT * FROM `bans` WHERE (`BanName` = `%e` OR `IP` = '%e') LIMIT 1",APlayerData[playerid][PlayerName],IP);

    mysql_tquery(g_SQL, query, "BanCheck","i",playerid);

The callback:

PHP код:



forward BanCheck(playerid);

public BanCheck(playerid)

{

    new admin[24], pname[24],Reason[60], string[60],bantime;

    new rows = cache_num_rows();

    if(rows) 

    {


        for(new row; row < rows; row++) 

        {

              cache_get_field_content(row, "AdminName", admin, g_SQL, sizeof(admin));

              cache_get_field_content(row, "BanName", pname, g_SQL, sizeof(pname));

              cache_get_field_content(row, "Reason", Reason, g_SQL, sizeof(Reason));

              bantime = cache_get_field_content_int(row, "BanTime", g_SQL);

          }

      }


    SendClientMessage(playerid, C_RED,"Esti banat pe acest server!");

    SendClientMessage(playerid, C_RED,"___________________");

    format(string, sizeof(string),"Admin: %s", admin);

    SendClientMessage(playerid, C_RED, string);

    format(string, sizeof(string),"Nume: %s", pname);

    SendClientMessage(playerid, C_RED, string);

    format(string, sizeof(string),"Motiv: %s", Reason);

    SendClientMessage(playerid, C_RED, string);

    format(string, sizeof(string),"Timp ramas: %s", CalculateBanTime(bantime));

    SendClientMessage(playerid, C_RED, string);

    SendClientMessage(playerid, C_RED,"___________________");

    SendClientMessage(playerid, C_RED, "Daca crezi ca ai primit ban pe nedrept fa o poza(F8) si posteaza-o pe forum la sectiuena serverului.");

    SendClientMessage(playerid, C_RED, "www.gamelive.ro/forum");

    SetTimerEx("TimedKick", 500, false, "i", playerid);


    return 1;

}

And the actual table:
http://imgur.com/KMTDrWe

Re: MySQL ban SELECT error - StrikerZ - 20.02.2017

PHP код:



mysql_format(g_SQL, query, sizeof(query),"SELECT * FROM `bans` WHERE (`BanName` = '%e' OR `IP` = '%e') LIMIT 1",APlayerData[playerid][PlayerName],IP); 
    mysql_tquery(g_SQL, query, "BanCheck","i",playerid);

Re: MySQL ban SELECT error - Banditul18 - 20.02.2017

Quote:

Originally Posted by Sunehildeep

PHP код:



mysql_format(g_SQL, query, sizeof(query),"SELECT * FROM `bans` WHERE (`BanName` = '%e' OR `IP` = '%e') LIMIT 1",APlayerData[playerid][PlayerName],IP); 

    mysql_tquery(g_SQL, query, "BanCheck","i",playerid);

Thanks
Well now i see, this is kinda stupid from me.....