Jump to content
Autentificarea cu Google și Facebook nu mai este disponibilă. ×
  • 0

Sistem monitorizare staff


Question

Posted

Problema intalnita (descriere):Am facut un sistem de monitorizare staff.Am facut comanda /showstaffactvity si ca sa le resetez activitatea /resetstaffactivity dar /resetstaffactivity nu merge...
Ero(area / rile) / warning-(ul / urile):

[13:21:18] CMySQLHandler::Query(DELETE * FROM `logExecCmds` WHERE `Player` = 'Jimmi') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `logExecCmds` WHERE `Player` = 'Jimmi'' at line 1)

[13:21:18] >> mysql_store_result( Connection handle: 1 )

[13:21:18] CMySQLHandler::StoreResult() - No data to store.

[13:21:18] OnQueryError() - Called.

[13:21:22] >> mysql_query( Connection handle: 1 )


Liniile de cod / sursa / script-ul(obligatoriu):
Imagini / Video (optional):
Ati incercat sa rezolvati singur?:Da

CMD:resetstaffactivity(playerid, params[])
{
    if(IsPlayerConnected(playerid))
    {
        new jucator,numejucator[32],query[128];
        if(sscanf(params, "u", jucator)) return SendClientMessage(playerid, COLOR_GRAD2, "{00FF00}Folosire:{FFFFFF} /resetstaffactivity [PlayerID/PartOfName]");
        GetPlayerName(jucator, numejucator, sizeof(numejucator));
      format(query, sizeof(query), "DELETE * FROM `logExecCmds` WHERE `Player` = '%s'", numejucator);
      mysql_query(query);
        mysql_store_result();
        }
    return 1;
}

2 answers to this question

Recommended Posts

  • 0
Posted
format(query, sizeof(query), "DELETE * FROM `logExecCmds` WHERE `Player` = '%s'", numejucator);

Incearca asa:

format(query, sizeof(query), "DELETE FROM logExecCmds WHERE Player = '%s'", numejucator);
  • Upvote 1
Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.