[Xeon™]

PHP Code:

COMMAND:setname(playerid, params[]) 
{ 
    new otherID, name[120],query[300]; 
    if(!adminLevel(playerid, 1)) 
        return 0; 
    if(sscanf(params, "us[100]", otherID, name)) 
    { 
        //Usage(playerid, "pm <playerid> <message>"); 
        SendClientMessage(playerid, COLOR_RED, "SYNTAX: /setname (playerid) (new name)"); 
    } 
    else 
    { 
        mysql_format(koneksi, query, sizeof(query), "SELECT * FROM `player` WHERE `name` = '%s' LIMIT 1", name);
        new Cache:getcache = mysql_query(koneksi, query); 
        if(cache_num_rows() > 0) 
        { 
           SendClientMessage(playerid,COLOR_RED,"Player with that name already exists."); 
        } 
        else 
        { 
           mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `name` = '%s' where `id` = '%d'",name,Player[otherID][pID]); 
           mysql_query(koneksi, query, false); 
        } 
        cache_delete(getcache);
    } 
    return 1; 
}