If you're trying to add an accent to your text, you first need to get the accent from the database which could be done as a simple query such as:
Код:
format(query, sizeof(query), "SELECT 'Accent' from '%TABLENAME%' WHERE Name = '%s'", GetPlayerName(playerid, pName, sizeof(pName));
mysql_query(query);
Then, you will then need to set it, for this; I would use an enumerator so that you can use it again and again if needed.
Код:
enum PlayerData
{
Accent[128]
}
new Player_Data[MAX_PLAYERS][PlayerData]
and set it by adding it to the end of the first query..
Код:
query here
Player_Data[playerid][Accent] = query;
Then after this, you will need to add it to the beggining of your proxydetector i.e.
Код:
format(string, sizeof(string), "%s [Accent: %s]: %s", GetPlayerName(playerid, pName, sizeof(pName), Player_Data[playerid][Accent], text);
ProxyDetector(playerid, color, string, Float:range)
And for the dialog thing.. just make a dialog which then sends the query
Код:
format(query, sizeof(query), "INSERT INTO accounts (Accent) VALUES ('%s') WHERE Name = '%s'", inputtext, GetPlayerName(playerid, pName, sizeof(pName));
This is clearly a rough draft of what you need to do and it will need some things changing however this will get you started.