Ajuto rconlogs!

[Blade]

Salutare baieti eu am o proeblema eu am pus un sistem de salvare a logurilor cand un jucator forloseste /rcon login {parola}, da imi face spam in baza de date! Oare de la ce sa fie va la stringul meu!

 

 

 

String:

 

public OnRconLoginAttempt(ip[], password[], success)

{

    if(!success) //If the password was incorrect

    {

        printf("FAILED RCON LOGIN BY IP %s USING PASSWORD %s",ip, password);

        new pip[16];

        for(new i=0; i<MAX_PLAYERS; i++) //Loop through all players

        {

            GetPlayerIp(i, pip, sizeof(pip));

            if(!strcmp(ip, pip, true)) //If a player's IP is the IP that failed the login

            {

                //SendClientMessage(i, 0xFFFFFFFF, "Wrong Password. Bye!"); //Send a message

                //Ban(i); //They are now banned.

            }

        }

    }

    else

    {

        for(new i=0; i<MAX_PLAYERS; i++)

        {

            new pName[30];

            new query[512];

        

   GetPlayerName(i, pName, sizeof(pName));

 

mysql_format(sqldb, query, sizeof(query) ,"INSERT INTO `rconlogs` (`ID`,`Admin`,`Password`, `Time`, `IP`) VALUES ('','%e','%s',CURRENT_TIMESTAMP,'%e')", pName, password, ip);

mysql_query(sqldb, query);

}

    }

return 1;

}

 

 

Uitati ce spam imi face in baza de date:

Edited December 29, 2014 by Blade

[WopsS]

Adaugi

new pip[16];
GetPlayerIp(i, pip, sizeof(pip));
if(!strcmp(ip, pip, true)) //If a player's IP is the IP that failed the login
{
      // Aici
}

in loc de

new pName[30];
new query[512];
  
 GetPlayerName(i, pName, sizeof(pName));
 
mysql_format(sqldb, query, sizeof(query) ,"INSERT INTO `rconlogs` (`ID`,`Admin`,`Password`, `Time`, `IP`) VALUES ('','%e','%s',CURRENT_TIMESTAMP,'%e')", pName, password, ip);
mysql_query(sqldb, query);

si in ea, unde scrie // Aici pui

new pName[30];
new query[512];
  
 GetPlayerName(i, pName, sizeof(pName));
 
mysql_format(sqldb, query, sizeof(query) ,"INSERT INTO `rconlogs` (`ID`,`Admin`,`Password`, `Time`, `IP`) VALUES ('','%e','%s',CURRENT_TIMESTAMP,'%e')", pName, password, ip);
mysql_query(sqldb, query);

[kwnx]

Asta nu cumva e o problema de scripting? )

[97fresh]

dap

 

asa mi se pare si mie:))

[NoNamed]

Posteaza la Ajutor Scripting, aici se posteaza altfel de probleme .

Edited January 1, 2015 by NoNamed