MySql Prob.
#1

idk why its occuring to me and idk to solve it. Im using BlueG's R7 mysql plugin.
Im sure that line is the one causing Problems.

The Whole Callback
pawn Код:
public SavePlayer(playerid)
{
    new IP[20];
    GetPlayerIp(playerid, IP, 20);
    new Query[500];
    new QueryFinal[1500] = "UPDATE `playerdata` SET ";
    format(Query, sizeof(Query), "`username`='%s',`Deaths`='%d',`ArmstreaksInHand`='%d', `TimePlayer`='%d', `Rank`='%d', `Achievements`='%d', `HeadShots`='%d', `LongShots`='%d', `IP`='%s', `Kills`='%d',`Cash`='%d', `ArmstreakRecieved`='%d',`PlayerXP`='%d',`PlayerRankNumber`='%d' WHERE `Username`='%s'", ReturnPlayerName(playerid),PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArmstreak],PlayerInfo[playerid][pTimePlayer],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pAchievements],PlayerInfo[playerid][pHeadShots], PlayerInfo[playerid][pLongShots], IP, PlayerInfo[playerid][pKills],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pArmstreakRecieved],PlayerInfo[playerid][pXP],PlayerInfo[playerid][pRankNumber],ReturnPlayerName(playerid));
    strcat(QueryFinal, Query);
    mysql_tquery(conn, QueryFinal, false, "OnQuerySend", "");
    return 1;
}
That whole line
pawn Код:
format(Query, sizeof(Query), "`username`='%s',`Deaths`='%d',`ArmstreaksInHand`='%d', `TimePlayer`='%d', `Rank`='%d', `Achievements`='%d', `HeadShots`='%d', `LongShots`='%d', `IP`='%s', `Kills`='%d',`Cash`='%d', `ArmstreakRecieved`='%d',`PlayerXP`='%d',`PlayerRankNumber`='%d' WHERE `Username`='%s'", ReturnPlayerName(playerid),PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArmstreak],PlayerInfo[playerid][pTimePlayer],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pAchievements],PlayerInfo[playerid][pHeadShots], PlayerInfo[playerid][pLongShots], IP, PlayerInfo[playerid][pKills],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pArmstreakRecieved],PlayerInfo[playerid][pXP],PlayerInfo[playerid][pRankNumber],ReturnPlayerName(playerid));
Prob:
pawn Код:
DDM.pwn(362) : error 017: undefined symbol "cache_get_data"
DDM.pwn(361) : warning 203: symbol is never used: "field"
DDM.pwn(378) : error 017: undefined symbol "cache_get_data"
DDM.pwn(377) : warning 203: symbol is never used: "field"
DDM.pwn(388) : error 017: undefined symbol "mysql_tquery"
DDM.pwn(397) : error 075: input line too long (after substitutions)
DDM.pwn(398) : error 017: undefined symbol "playeri"
DDM.pwn(399) : error 017: undefined symbol "d"
DDM.pwn(399) : error 029: invalid expression, assumed zero
DDM.pwn(399) : error 029: invalid expression, assumed zero
DDM.pwn(399) : fatal error 107: too many error messages on one line
its just because of that line (it worked before but after i got a new HDD and forgot to save a bkup D: )
Im stuck in this line for some time.

Made a post in "Little Coding Question" but i couldn't get a fix. Hope someone help me with this

Tried R33, R5 and R7 with tquery and mysql_function_query
Reply


Messages In This Thread
MySql Prob. - by newbie scripter - 17.04.2014, 13:01
Re: MySql Prob. - by newbie scripter - 18.04.2014, 05:27
Re: MySql Prob. - by Conradus - 18.04.2014, 06:55
Re: MySql Prob. - by iZN - 18.04.2014, 07:10
Re: MySql Prob. - by newbie scripter - 18.04.2014, 08:09
Re: MySql Prob. - by iZN - 18.04.2014, 10:21
Re: MySql Prob. - by newbie scripter - 21.04.2014, 10:32
Re: MySql Prob. - by RajatPawar - 21.04.2014, 10:35
Re: MySql Prob. - by newbie scripter - 21.04.2014, 10:39
Re: MySql Prob. - by newbie scripter - 22.04.2014, 11:34

Forum Jump:


Users browsing this thread: 2 Guest(s)