mysql problem
#1

My clan tag won't update in the database

case DIALOG_CLANTAG:
{
if(!response) return SendClientMessage(playerid, COLOR_GREY, "You canceled the clan creation");
new string[128];
PlayerInfo[playerid][pClanRank] = 7;
PlayerInfo[playerid][pClanMember] = 1;
PlayerInfo[playerid][pPremiumPoints] -= 500;
UpdateVariable(playerid, pClanRankx);
UpdateVariable(playerid, pClanMemberx);
UpdateVariable(playerid, pPremiumPointsx);
mysql_format(mysql, szQuery, 256, "INSERT INTO `clans` (`ClanTag`) VALUES ('%e')", inputtext);
new Cache: result = mysql_query(mysql, szQuery);
cache_delete(result);
format(string, sizeof(string), "You've set the clan tag to {0000ff}%s",inputtext);
SendClientMessage(playerid, -1, string);
}
Reply


Messages In This Thread
mysql problem - by bosmania - 27.02.2019, 18:25
Re: mysql problem - by SymonClash - 27.02.2019, 18:58
Re: mysql problem - by bosmania - 28.02.2019, 10:37
Re: mysql problem - by bosmania - 28.02.2019, 12:22
Re: mysql problem - by bosmania - 28.02.2019, 12:29

Forum Jump:


Users browsing this thread: 1 Guest(s)