[AiRaLoKa]

hi all...

i got a littleproblem here (it's actually big problem for player). when player change his name, and then relog, his statistic reseted :/
i don't know what's wrong :/

pawn Код:

CMD:changename(playerid, params[])
{
    new newname[25], Query[128], Query2[256], rows, fields, hid;
    if(sscanf(params,"s[24]",newname)) return SendClientMessage(playerid, COLOR_RED, "[USAGE]: /changename [newname(max:24 char)]");
    if(pInfo[playerid][ChangeNameTime] > 2) return SendClientMessageLang(playerid, COLOR_RED, ""Err" You can only change your nickname 3 time each login!", ""Err" Anda hanya bisa mengganti nickname anda 3 kali setiap login!");
    if(strlen(newname) > 24) return SendClientMessage(playerid, COLOR_RED, "[USAGE]: /changename [newname(max:24 char)]");
    if(IsBadNameString(newname)) return SendClientMessageLang(playerid, COLOR_RED, ""Err" Bad name format!", ""Err" Format nama anda salah!");
    mysql_format(dbHandle,Query, sizeof(Query), "SELECT * FROM `PlayerData` WHERE `Username` = '%s'", newname);
    mysql_query(dbHandle,Query);
    cache_get_data(rows, fields);
    if(rows)
    {
        return SendClientMessageLang(playerid, COLOR_RED, ""Err" This name already used! Try another!", ""Err" Nama ini sudah terpakai! Coba yang lain!");
    }
    else if(!rows)
    {
        mysql_format(dbHandle,Query2, sizeof(Query2), "UPDATE `PlayerData` SET `Username` = '%s' WHERE `Username` = '%s'", newname, pName(playerid));
        mysql_query(dbHandle,Query2,false);
        mysql_format(dbHandle,Query2, sizeof(Query2), "SELECT * FROM `House` WHERE `Name` = '%s'", pName(playerid));
        mysql_query(dbHandle,Query2);
        cache_get_data(rows, fields);
        if(rows)
        {
            mysql_format(dbHandle,Query2, sizeof(Query2), "UPDATE `House` SET `Name` = '%s' WHERE `Name` = '%s'", newname, pName(playerid));
            mysql_query(dbHandle,Query2,false);

            hid = cache_get_field_content_int(0, "Houseid");
            format(hInfo[hid][Name], 24, newname);
        }
        mysql_format(dbHandle,Query2, sizeof(Query2), "SELECT * FROM `Weapon` WHERE `Username` = '%s'", pName(playerid));
        mysql_query(dbHandle,Query2);
        cache_get_data(rows, fields);
        if(rows)
        {
            mysql_format(dbHandle,Query2, sizeof(Query2), "UPDATE `Weapon` SET `Username` = '%s' WHERE `Username` = '%s'", newname, pName(playerid));
            mysql_query(dbHandle,Query2,false);
        }
        mysql_format(dbHandle,Query2, sizeof(Query2), "SELECT * FROM `SavedVeh` WHERE `Name` = '%s'", pName(playerid));
        mysql_query(dbHandle,Query2);
        cache_get_data(rows, fields);
        if(rows)
        {
            mysql_format(dbHandle,Query2, sizeof(Query2), "UPDATE `SavedVeh` SET `Name` = '%s' WHERE `Name` = '%s'", newname, pName(playerid));
            mysql_query(dbHandle,Query2,false);
        }
        mysql_format(dbHandle,Query2, sizeof(Query2), "SELECT * FROM `SprayTags` WHERE `Name` = '%s'", pName(playerid));
        mysql_query(dbHandle,Query2);
        cache_get_data(rows, fields);
        if(rows)
        {
            mysql_format(dbHandle,Query2, sizeof(Query2), "UPDATE `SprayTags` SET `Name` = '%s' WHERE `Name` = '%s'", newname, pName(playerid));
            mysql_query(dbHandle,Query2,false);
        }
        new file[128],filenew[128];
        format(file, sizeof(file), "Player Objects/%s.ini", pName(playerid));
        format(filenew, sizeof(filenew), "Player Objects/%s.ini", newname);
        
        if(dini_Exists(file))
        {
            frename(file,filenew);
        }
        new str1[128],str2[128];
        format(str1,sizeof str1, ""Inf" %s has changed his name become %s",pName(playerid),newname);
        format(str2,sizeof str2, ""Inf" %s telah mengubah namanya menjadi %s",pName(playerid),newname);
        SendClientMessageToAllLang(0xFFFFFFFF, str1, str2);
        SendClientMessageLang(playerid, COLOR_GREEN, ""Inf" Don't forget to change your name at your SAMP Client on next login!", ""Inf" Jangan lupa untuk mengubah nama anda di SAMP Client anda pada saat login selanjutnya!");
        SetPlayerName(playerid, newname);
        pInfo[playerid][ChangeNameTime]++;
        SaveStats(playerid);
    }
    return 1;
}