CMD:setmessage(playerid,params[])
{
new Message[128], string[128], query[128];
if(sscanf(params,"s[128]", Message)) return SendClientMessage(playerid, -1, "Usage: /setmessage [custom_message]");
format(string, sizeof(string), "You have set your Join Message to: %s", Message);
SendClientMessage(playerid, -1, string);
format(PlayerInfo[playerid][personalmsg], 128, "%s", Message);
//save player account
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `SCORE`= %i , `Admin` = '%i' , `personalmsg` = '%e' WHERE `ID` = '%d'", GetPlayerScore(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][personalmsg], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
print(query);
return 1;
}
|
DIALOG_STYLE_INPUT and OnDialogResponse. Use the query in on dialog response
|
CMD:setmessage(playerid,params[])
{
ShowPlayerDialog(playerid,97,DIALOG_STYLE_INPUT,"Set Message","Enter the new join message you want to set","Set","Cancel");
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == 97)
{
if(response)
{
new string[128];
format(string, sizeof(string), "You have set your Join Message to: %s", inputtext);
SendClientMessage(playerid, -1, string);
format(PlayerInfo[playerid][personalmsg], 128, "%s", inputtext);
//save player account
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `SCORE`= %i , `Admin` = '%i' , `personalmsg` = '%e' WHERE `ID` = '%d'", GetPlayerScore(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][personalmsg], PlayerInfo[playerid][ID]);
mysql_query(mysql, query);
print(query);
}
}
return 1;
}
|
Here you go.
PHP код:
|
|
Are you using it in a FS or gamemode?
And did the dialog appeared? |