[TheLeech]

Ok so the forum name loads if I make it in the database but doesn't save.

Код:

COMMAND:forumname(playerid, params[])
{
    if (GetPVarInt(playerid, "PlayerLogged") == 0) return SendClientMessage(playerid, COLOR_WHITE, "You must be logged in to use this.");
    new fname[124];
    new query[4096];
    if(sscanf(params, "s[128]", fname)) return SendClientMessage(playerid, COLOR_GREY, "USAGE: /forumname [Name]");
    mysql_format(handlesql, query, sizeof(query), "UPDATE `accounts` SET ForumName=%e, WHERE ID=%i", fname, PlayerInfo[playerid][pID]);
	mysql_pquery(handlesql, query);
	mysql_format(handlesql, query, sizeof(query), "SELECT ForumName FROM `accounts` WHERE Name='%e'", PlayerInfo[playerid][pUsername]);
	mysql_pquery(handlesql, query, "OnAccountLoadMain", "d", playerid);
	return 1;
}

forward OnAccountLoadMain(playerid);
public OnAccountLoadMain(playerid)
{
	printf("OnAccountLoadMain is called [ID %i]", playerid);
	cache_get_field_content(0, "ForumName", oocname[playerid], 79);
	printf("Forumname: %s is loaded.", oocname[playerid]);
	return 1;
}

[TwinkiDaBoss]

PHP код:

cache_get_field_content(0, "ForumName", oocname[playerid], CONNECTION HANDLER, 79); 


Add a connection handler to your get_field_content

[TheLeech]

Quote:

Originally Posted by TwinkiDaBoss PHP код: cache_get_field_content(0, "ForumName", oocname[playerid], CONNECTION HANDLER, 79);  Add a connection handler to your get_field_content

its also not saving the forum name for some reason.

[TheLeech]

The error is.

[18:29:56] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' WHERE ID=3' at line 1

[prineside]

PHP код:

COMMAND:forumname(playerid, params[])
{
    if (GetPVarInt(playerid, "PlayerLogged") == 0) return SendClientMessage(playerid, COLOR_WHITE, "You must be logged in to use this.");
    new fname[124];
    new query[4096];
    if(sscanf(params, "s[128]", fname)) return SendClientMessage(playerid, COLOR_GREY, "USAGE: /forumname [Name]");
    mysql_format(handlesql, query, sizeof(query), "UPDATE `accounts` SET ForumName=%e WHERE ID=%i", fname, PlayerInfo[playerid][pID]); // Remove "," here
    mysql_pquery(handlesql, query);
    mysql_format(handlesql, query, sizeof(query), "SELECT ForumName FROM `accounts` WHERE Name='%e'", PlayerInfo[playerid][pUsername]);
    mysql_pquery(handlesql, query, "OnAccountLoadMain", "d", playerid);
    return 1;
}

forward OnAccountLoadMain(playerid);
public OnAccountLoadMain(playerid)
{
    printf("OnAccountLoadMain is called [ID %i]", playerid);
    cache_get_field_content(0, "ForumName", oocname[playerid], 79);
    printf("Forumname: %s is loaded.", oocname[playerid]);
    return 1;
} 


[TheLeech]

Quote:

Originally Posted by prineside PHP код: COMMAND:forumname(playerid, params[]) {     if (GetPVarInt(playerid, "PlayerLogged") == 0) return SendClientMessage(playerid, COLOR_WHITE, "You must be logged in to use this.");     new fname[124];     new query[4096];     if(sscanf(params, "s[128]", fname)) return SendClientMessage(playerid, COLOR_GREY, "USAGE: /forumname [Name]");     mysql_format(handlesql, query, sizeof(query), "UPDATE `accounts` SET ForumName=%e WHERE ID=%i", fname, PlayerInfo[playerid][pID]); // Remove "," here     mysql_pquery(handlesql, query);     mysql_format(handlesql, query, sizeof(query), "SELECT ForumName FROM `accounts` WHERE Name='%e'", PlayerInfo[playerid][pUsername]);     mysql_pquery(handlesql, query, "OnAccountLoadMain", "d", playerid);     return 1; } forward OnAccountLoadMain(playerid); public OnAccountLoadMain(playerid) {     printf("OnAccountLoadMain is called [ID %i]", playerid);     cache_get_field_content(0, "ForumName", oocname[playerid], 79);     printf("Forumname: %s is loaded.", oocname[playerid]);     return 1; }

its now saying

19:06:20] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Panda' in 'field list'
[19:06:24] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Panda' in 'field list'
[19:06:28] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Montana' in 'field list'

[Vince]

Strings (%e) must be enclosed in single quotes (') otherwise they will be treated as a column name, as is so nicely demonstrated above.

[prineside]

Print "query" variable and check if it's formated with quotes (all strings must be surrounded by single quotes in SQL). If no, then

PHP код:

... SET ForumName='%e' ...