SA-MP Forums Archive
SearchBan [MySQL] - 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: SearchBan [MySQL] (/showthread.php?tid=613519)


Sban [MySQL] - Shinja - 28.07.2016

The command:

PHP код:
CMD:sban(playerid, params[])
{
    new n[24], admin[24], IP[16], reason[56], Day[2], Year[4], Month[2], Hour[2], Minute[2], Second[2];
    if(pAdmin[playerid] < 2) return SendClientMessage(playerid, 0xCD0000FF, "Invalid command. Please use {FFF8CF}/cmds {CD0000}to list all available commands.");
     if(sscanf(params, "s[24]", n)) return SendClientMessage(playerid, -1, "{0008F7}USAGE: {FFFFFF}/SBAN NAME");
     new query[200];
    format(query, sizeof(query),"SELECT Admin,Player,Reason,IP,Day,Month,Year,Hour,Minute,Second FROM `Bans` WHERE `Player`='%s'", n);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(rows == 1)
    {
          while(mysql_fetch_row(query))
          {
            mysql_fetch_field_row(admin, "Admin");
            mysql_fetch_field_row(IP, "IP");
            mysql_fetch_field_row(reason, "Reason");
            mysql_fetch_field_row(Day, "Day");
            mysql_fetch_field_row(Month, "Month");
            mysql_fetch_field_row(Year, "Year");
            mysql_fetch_field_row(Hour, "Hour");
            mysql_fetch_field_row(Minute, "Minute");
            mysql_fetch_field_row(Second, "Second");
          }
        new string[224], name[24];
        GetPlayerName(playerid, name, sizeof(name));
        format(string,sizeof(string),"{0008F7}[Administration]: {FF0095}%s {C90076}have used {FF0095}SBAN", name);
        SendToAdmins(-1, string);
        format(string, sizeof(string), "{9384CF}Account: %s Banned by %s on %d:%d:%d the %d/%d/%d for %s", n, admin, Hour, Minute, Second, Day,Month, Year, reason);
        SendClientMessage(playerid, -1, string);
    }
    if(!rows)
    {
        SendClientMessage(playerid, 0xCD0000FF, "Account no banned or not exists");
    }
    return 1;
} 
This loop isn't getting info from database right way

PHP код:
while(mysql_fetch_row(query))
          {
            mysql_fetch_field_row(admin, "Admin");
            mysql_fetch_field_row(IP, "IP");
            mysql_fetch_field_row(reason, "Reason");
            mysql_fetch_field_row(Day, "Day");
            mysql_fetch_field_row(Month, "Month");
            mysql_fetch_field_row(Year, "Year");
            mysql_fetch_field_row(Hour, "Hour");
            mysql_fetch_field_row(Minute, "Minute");
            mysql_fetch_field_row(Second, "Second");
          } 
Why? and how to fix it?

Re: SearchBan [MySQL] - Shinja - 28.07.2016

Bump

Re: Sban [MySQL] - Pizzy - 29.07.2016

Quote:
Originally Posted by Shinja
Посмотреть сообщение
The command:

PHP код:
CMD:sban(playerid, params[])
{
    new n[24], admin[24], IP[16], reason[56], Day[2], Year[4], Month[2], Hour[2], Minute[2], Second[2];
    if(pAdmin[playerid] < 2) return SendClientMessage(playerid, 0xCD0000FF, "Invalid command. Please use {FFF8CF}/cmds {CD0000}to list all available commands.");
     if(sscanf(params, "s[24]", n)) return SendClientMessage(playerid, -1, "{0008F7}USAGE: {FFFFFF}/SBAN NAME");
     new query[200];
    format(query, sizeof(query),"SELECT Admin,Player,Reason,IP,Day,Month,Year,Hour,Minute,Second FROM `Bans` WHERE `Player`='%s'", n);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(rows == 1)
    {
          while(mysql_fetch_row(query))
          {
            mysql_fetch_field_row(admin, "Admin");
            mysql_fetch_field_row(IP, "IP");
            mysql_fetch_field_row(reason, "Reason");
            mysql_fetch_field_row(Day, "Day");
            mysql_fetch_field_row(Month, "Month");
            mysql_fetch_field_row(Year, "Year");
            mysql_fetch_field_row(Hour, "Hour");
            mysql_fetch_field_row(Minute, "Minute");
            mysql_fetch_field_row(Second, "Second");
          }
        new string[224], name[24];
        GetPlayerName(playerid, name, sizeof(name));
        format(string,sizeof(string),"{0008F7}[Administration]: {FF0095}%s {C90076}have used {FF0095}SBAN", name);
        SendToAdmins(-1, string);
        format(string, sizeof(string), "{9384CF}Account: %s Banned by %s on %d:%d:%d the %d/%d/%d for %s", n, admin, Hour, Minute, Second, Day,Month, Year, reason);
        SendClientMessage(playerid, -1, string);
    }
    if(!rows)
    {
        SendClientMessage(playerid, 0xCD0000FF, "Account no banned or not exists");
    }
    return 1;
} 
This loop isn't getting info from database right way
What do you mean by this?

What is it returning? Or are you referring to how the information didn't show up "right away" - in terms of how long it takes to display?

Re: SearchBan [MySQL] - Shinja - 29.07.2016

Already fixed. Thanks!