MySQL
#1

pawn Код:
stock SaveAccountVariables(playerid)
{
    new Float:a, intid, vw, Float:x, Float:y, Float:z, szQuery[1024];
    GetPlayerPos(playerid, x,y,z);
    vw = GetPlayerVirtualWorld(playerid);
    intid = GetPlayerInterior(playerid);
    GetPlayerFacingAngle(playerid, a);
    format(szQuery, sizeof(szQuery), "UPDATE `Stats` SET `AdminLevel` = %d, `seeds` = %d, `weed` = %d, `pSkin` = %d, `pTier` = %d, `pFaction` = %d, `pLastx` = %f, `pLasty` = %f, `pLastz` = %f, `pRank` = '%s', `pIP` = '%s', `pInterior` = %d, `pVirtualWorld` = %d, `Money` = %d, `pLasta` = %f AND `BanReason` = '%s' WHERE `pDatabaseID` = %d",
    pInfo[playerid][AdminLevel], pInfo[playerid][seeds], pInfo[playerid][weed], GetPlayerSkin(playerid), pInfo[playerid][pTier], pInfo[playerid][pFaction],x,y,z, pInfo[playerid][pRank], pInfo[playerid][pIP], intid, vw, GetPlayerMoney(playerid), a, pInfo[playerid][BanReason], pInfo[playerid][pDatabaseID]);
    mysql_function_query(1, szQuery, false, "", "");
}
There's my saving function, however when a player disconnects and this is called, it's just printing 0 on every float/integer and nothing on the strings, why is this?
Reply


Messages In This Thread
MySQL - by BigGroter - 04.05.2013, 22:11
Re: MySQL - by Vince - 04.05.2013, 22:19
Re: MySQL - by BigGroter - 04.05.2013, 22:35
Re: MySQL - by BigGroter - 04.05.2013, 23:34
Re: MySQL - by BigGroter - 05.05.2013, 11:27
Re: MySQL - by BigGroter - 05.05.2013, 18:14
Re: MySQL - by BigGroter - 06.05.2013, 18:53
Re: MySQL - by BigGroter - 07.05.2013, 14:00

Forum Jump:


Users browsing this thread: 2 Guest(s)