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'
