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
Question
Jimmi
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):
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