Poorly coded...
Code:
public client_infochanged(pPlayer)
{
new szName[32];
get_user_name(pPlayer, szName, charsmax(szName));
if(!equali(szName, g_szOldName[pPlayer]))
{
formatex(g_szOldName[pPlayer], charsmax(g_szOldName[]), "%s", szName);
MySQL_UpdateName(pPlayer);
}
}
MySQL_UpdateName(pPlayer)
{
new szQuery[32], szName[32];
get_user_name(pPlayer, szName, charsmax(szName));
replace_all(g_szOldName[pPlayer], charsmax(g_szOldName[]), "'", "\'");
replace_all(g_szOldName[pPlayer], charsmax(g_szOldName[]), "^"", "\^"");
replace_all(szName, charsmax(szName), "'", "\'");
replace_all(szName, charsmax(szName), "^"", "\^"");
formatex(szQuery, charsmax(szQuery), "UPDATE `online_players` SET `username` = '%s' WHERE `username` = '%s'", szName, g_szOldName[pPlayer]);
SQL_ThreadQuery(MySQL_Tuple, "SQL_TrashHandler", szQuery);
}