[DerickClark]

When i /setmessage then leave the server. and come back to the server it loaded good
but in my database under personalmsg it's blank. not display in database
Database photo:

User Account
Stucture

When the account loaded:

Код:

forward OnAccountLoad(playerid);
public OnAccountLoad(playerid)
{
    cache_get_value_name_int(0, "personalmsg", PlayerInfo[playerid][personalmsg]);
    return true;
}

Server Prints:

Код:

UPDATE `accounts` SET `Score`= 71415, `Admin`= 2 , `personalmsg`= test WHERE `ID` = '1'

OnPlayerDisconnect:

Код:

mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `Score`= %i, `Admin`= %i , `personalmsg`= %s WHERE `ID` = '%d'", GetPlayerScore(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][personalmsg], PlayerInfo[playerid][ID]);

Command:

Код:

CMD:setmessage(playerid,params[])
{
	new Message[128], string[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);

	return 1;
}

[saffierr]

Hmm, are you sure you have set personalmsg in the table as 'VARCHAR' ?

[DerickClark]

Quote:

Originally Posted by saffierr Hmm, are you sure you have set personalmsg in the table as 'VARCHAR' ?

yes



Saved in database - worked!

Loaded in database - worked!

display in database - failed! [Reason: under personalmsg it's blank.]

[saffierr]

Check your mysql_log.txt

[DerickClark]

Quote:

Originally Posted by saffierr Check your mysql_log.txt

Код:

[20:27:38] [plugins/mysql] error #1054 while executing query "UPDATE `accounts` SET `Score`= 0, `Admin`= 0 , `personalmsg`= Test WHERE `ID` = '5'": Unknown column 'Test' in 'field list'

[X337]

Код:

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]);

You need to put quotes for string type in mysql query.
And also use '%e' instead of '%s' as players can set their personalmsg.

[DerickClark]

Quote:

Originally Posted by X337 Код: 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]); You need to put quotes for string type in mysql query. And also use '%e' instead of '%s' as players can set their personalmsg.

I have a problem. If i delete my account in database The ID count don't reset to 0 it adds up,

[saffierr]

That is Auto_Increment bro

You can send a query to the table:

PHP код:

ALTER TABLE `table` AUTO_INCREMENT = 0 


[DerickClark]

Quote:

Originally Posted by X337 Код: 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]); You need to put quotes for string type in mysql query. And also use '%e' instead of '%s' as players can set their personalmsg.

Код:

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]);

Код:

[21:06:31] [plugins/mysql] error #1054 while executing query "UPDATE `accounts` SET `Score`= 0, `Admin`= 0 , `personalmsg`= test WHERE `ID` = '9'": Unknown column 'test' in 'field list'

@saffierr

SQL query:

Код:

Error
SQL query:


ALTER TABLE `table` AUTO_INCREMENT = 0
MySQL said: Documentation

#1146 - Table 'tw_server.table' doesn't exist

[saffierr]

Did you actually use the name 'table' for your table lol?
Replace 'table' with `accounts`