06.03.2017, 09:07
try
PHP код:
CMD:delaccount(playerid, params[]){
new aName[MAX_PLAYER_NAME], szFieldName[MAX_PLAYER_NAME], query[256], string[128];
if(Character[playerid][Admin] < 4) return System_Scm(playerid, "You do not have permission to perform this command.", TYPE_ERROR);
if(sscanf(params, "s[24]", aName)) return System_Scm(playerid, "/delaccount [Account Name]", TYPE_NOTICE);
foreach(new i: Player){
if(!strcmp(aName, GetPlayerNameEx(playerid))) {
format(string, sizeof(string), "Account [%s] is being used by Player ID [%d]", aName, i);
System_Scm(playerid, string, TYPE_ERROR);
return 1;
}
}
mysql_format(MHande,query,sizeof(query),"SELECT `Username` FROM `character` WHERE `Username` = '%e'",aName);
mysql_query(MHandle, query);
new rows;
cache_get_row_count(rows);
if(rows != 0) {
mysql_format(MHandle, query, sizeof(query), "DELETE FROM `character` WHERE (`Username` = '%e') LIMIT 1", aName);
mysql_query(MHandle, query);
format(string, sizeof(string), "[%s] deleted [%s]", GetPlayerNameEx(playerid), aName);
foreach(new i: Player) {
if(Character[i][Admin] > 0) System_Scm(playerid, string, TYPE_SUCCESS);
}
return 1;
}
}
else
{
format(string, sizeof(string), "Can't find account [%s]", aName);
System_Scm(playerid, string, TYPE_ERROR);
}
return 1;
}