1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Business key doesnt load. -MYSQL +1
HK
Big Clucker
***
Posts: 163
Threads: 30
Joined: Nov 2013
Reputation: 0
#1

27.02.2014, 17:05
pawn Код:
cache_get_field_content(0, "bizkey", query);
        PlayerInfo[playerid][pBizKey] = strval(query);
Hello guys this line in my onaccountload doesnt load the business key after restart from the server, you guys know why? since I cant findout to solve it, all other things loads and saves fine.
Find
Reply
venomlivno8
Big Clucker
***
Posts: 96
Threads: 25
Joined: Jan 2013
Reputation: 0
#2

27.02.2014, 17:07
SQLite or MySQL?
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#3

27.02.2014, 17:10
#e:
Brainfart, completely wrong answer. The handle is third argument, not first. Sorry!

But use cache_get_row_int. What do the logs say?
Find
Reply
CuervO
High-roller
*****
Posts: 1,164
Threads: 20
Joined: Oct 2008
Reputation: 0
#4

27.02.2014, 17:15
Quote:
Originally Posted by Misiur
Посмотреть сообщение
Default MySQL handle is 1, 0 means connection isn't set. Better yet, keep the mysql_connect handle in a global variable.

pawn Код:
PlayerInfo[playerid][pBizKey] = cache_get_field_content_int(1, "bizkey", query);
pawn Код:
//To make things better:
new gDbhandle;
//(...)
gDbhandle = mysql_connect(...);
//(...)
PlayerInfo[playerid][pBizKey] = cache_get_field_content_int(gDbhandle, "bizkey", query);
cache does not work by dbhandle, there's no need since the data from the last dbhandle is stored there. 0 Is the number of the row.

@OP: Show us the query used to select the data.
Find
Reply
HK
Big Clucker
***
Posts: 163
Threads: 30
Joined: Nov 2013
Reputation: 0
#5

27.02.2014, 17:23
pawn Код:
public SavePlayerStats(playerid)
{
    if(playerid != INVALID_PLAYER_ID && PlayerIsOn(playerid) && PlayerLogged(playerid))
    {
        SavePlayerPos(playerid);
        new tickets[256];
        FormatPlayerTickets(playerid, tickets);
        new drugs[256];
        FormatPlayerDrugs(playerid, drugs);
        format(query, sizeof(query), "UPDATE `users` SET `registered` = %d, `cash` = %d, `bank` = %d, `skin` = %d, `sex` = %d, `age` = %d, `origin` = '%s', `level` = %d, `exp` = %d, `hours` = %d, `admin` = %d, `helper` = %d, `int` = %d, `world` = %d WHERE `name` = '%s'",
        PlayerInfo[playerid][pRegistered],
        PlayerInfo[playerid][pCash],
        PlayerInfo[playerid][pBank],
        PlayerInfo[playerid][pSkin],
        PlayerInfo[playerid][pSex],
        PlayerInfo[playerid][pAge],
        PlayerInfo[playerid][pOrigin],
        PlayerInfo[playerid][pLevel],
        PlayerInfo[playerid][pExp],
        PlayerInfo[playerid][pHours],
        PlayerInfo[playerid][pAdmin],
        PlayerInfo[playerid][pHelper],
        PlayerInfo[playerid][pInt],
        PlayerInfo[playerid][pWorld],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `jailed` = %d, `jailtime` = %d, `banned` = %d, `warns` = %d, `donate` = %d, `carlic` = %d, `weplic` = %d, `flylic` = %d, `posx` = %f, `posy` = %f, `posz` = %f, `posa` = %f WHERE `name` = '%s'",
        PlayerInfo[playerid][pJailed],
        PlayerInfo[playerid][pJailTime],
        PlayerInfo[playerid][pBanned],
        PlayerInfo[playerid][pWarns],
        PlayerInfo[playerid][pDonateRank],
        PlayerInfo[playerid][pCarLic],
        PlayerInfo[playerid][pWepLic],
        PlayerInfo[playerid][pFlyLic],
        PlayerInfo[playerid][pPosX],
        PlayerInfo[playerid][pPosY],
        PlayerInfo[playerid][pPosZ],
        PlayerInfo[playerid][pPosA],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `died` = %d, `fightstyle` = %d, `pen` = %d, `note1` = '%s', `note1s` = %d, `note2` = '%s', `note2s` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pDied],
        PlayerInfo[playerid][pFightStyle],
        PlayerInfo[playerid][pPen],
        PlayerInfo[playerid][pNote1],
        PlayerInfo[playerid][pNote1s],
        PlayerInfo[playerid][pNote2],
        PlayerInfo[playerid][pNote2s],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `note3` = '%s', `note3s` = %d, `attributes` = '%s', `paycheck` = %d, `paycheckmoney` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pNote3],
        PlayerInfo[playerid][pNote3s],
        PlayerInfo[playerid][pAttributes],
        PlayerInfo[playerid][pPayCheckMade],
        PlayerInfo[playerid][pPayCheckMoney],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `melee` = %d, `wep1`= %d, `wep2` = %d, `ammo1` = %d, `ammo2`= %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pUpgrade],
        PlayerInfo[playerid][pPayDayTime],
        PlayerInfo[playerid][pSHealth],
        PlayerInfo[playerid][pCellPhone],
        PlayerInfo[playerid][pNumber],
        PlayerInfo[playerid][pSavings],
        PlayerInfo[playerid][pHouseKey],
        PlayerInfo[playerid][pMeleeWep],
        GetPrimaryWeapon(playerid),
        GetSecondaryWeapon(playerid),
        GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm1]),
        GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm2]),
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `radio` = %d, `channel` = %d, `ownedchannel` = %d, `authed` = %d, `crashed` = %d, `mask` = %d, `accenton` = %d, `accent` = '%s', `bmx` = %d, `carkey` = %d, `vehicles` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pRadio] ,
        PlayerInfo[playerid][pChannel],
        PlayerInfo[playerid][pOwnedChannel],
        PlayerInfo[playerid][pAuthed],
        PlayerInfo[playerid][pCrashed],
        PlayerInfo[playerid][pMask],
        PlayerInfo[playerid][pAccentOn],
        PlayerInfo[playerid][pAccent],
        PlayerInfo[playerid][pBMX],
        PlayerInfo[playerid][pCarKey],
        PlayerInfo[playerid][pVehicles],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `veh1` = '%s', `veh2` = '%s', `veh3` = '%s', `vehslot` = %d, `hunger` = %.1f, `sparekey` = %d, `lighter` = %d, `cigars` = %d, `bizkey` = %d, `workon` = %d WHERE `name` = '%s'", 
        PlayerVehicle[playerid][pVeh1],
        PlayerVehicle[playerid][pVeh2],
        PlayerVehicle[playerid][pVeh3],
        PlayerInfo[playerid][pVehSlot],
        PlayerInfo[playerid][pHunger],
        PlayerInfo[playerid][pSpareKey],
        PlayerInfo[playerid][pLighter],
        PlayerInfo[playerid][pCigars],
        PlayerInfo[playerid][pBizKey],
        PlayerInfo[playerid][pWorkOn],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `walk` = %d, `armour` = %.1f, `hasarmour` = %d, `faction` = %d, `rank` = %d, `badgenumber` = %d, `drivewarns` = %d, `jailtime2` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pWalk],
        GetArmour(playerid),
        PlayerInfo[playerid][pHasArmour],
        PlayerInfo[playerid][pFaction],
        PlayerInfo[playerid][pRank],
        PlayerInfo[playerid][pBadgeNumber],
        PlayerInfo[playerid][pDriveWarns],
        PlayerInfo[playerid][pJailTime2],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `arrested` = %d, `chat` = %d, `swat` = %d, `slot` = %d, `tickets` = '%s', `job` = %d, `jobrank` = %d, `career` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pArrested],
        PlayerInfo[playerid][pTalk],
        PlayerInfo[playerid][pSwat],
        PlayerInfo[playerid][pSlot],
        tickets,
        PlayerInfo[playerid][pJob],
        PlayerInfo[playerid][pJobRank],
        PlayerInfo[playerid][pCareer],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `sidejob` = %d, `spawntype` = %d, `prisoned` = %d, `drugs` = '%s' WHERE `name` = '%s'", 
        PlayerInfo[playerid][pSideJob],
        PlayerInfo[playerid][pSpawnType],
        PlayerInfo[playerid][pPrisoned],
        drugs,
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
        format(query, sizeof(query), "UPDATE `users` SET `seeds` = %d WHERE `name` = '%s'", 
        PlayerInfo[playerid][pSeeds],
        GetName(playerid));
        mysql_function_query(dbHandle, query, false, "", "");
        //=========================================================================================================
    }
    return 1;
}

public OnAccountLoad(playerid)
{
    new tickets[256], drugs[256];
    cache_get_field_content(0, "id", query);
        PlayerInfo[playerid][pDatabaseID] = strval(query);
        cache_get_field_content(0, "registered", query);
        PlayerInfo[playerid][pRegistered] = strval(query);
        cache_get_field_content(0, "cash", query);
        PlayerInfo[playerid][pCash] = strval(query);
        cache_get_field_content(0, "bank", query);
        PlayerInfo[playerid][pBank] = strval(query);
        cache_get_field_content(0, "skin", query);
        PlayerInfo[playerid][pSkin] = strval(query);
        cache_get_field_content(0, "sex", query);
        PlayerInfo[playerid][pSex] = strval(query);
        cache_get_field_content(0, "age", query);
        PlayerInfo[playerid][pAge] = strval(query);
        cache_get_field_content(0, "origin", query);
        format(PlayerInfo[playerid][pOrigin], 256, query);
        cache_get_field_content(0, "level", query);
        PlayerInfo[playerid][pLevel] = strval(query);
        cache_get_field_content(0, "exp", query);
        PlayerInfo[playerid][pExp] = strval(query);
        cache_get_field_content(0, "hours", query);
        PlayerInfo[playerid][pHours] = strval(query);
        cache_get_field_content(0, "admin", query);
        PlayerInfo[playerid][pAdmin] = strval(query);
        cache_get_field_content(0, "helper", query);
        PlayerInfo[playerid][pHelper] = strval(query);
        cache_get_field_content(0, "int", query);
        PlayerInfo[playerid][pInt] = strval(query);
        cache_get_field_content(0, "world", query);
        PlayerInfo[playerid][pWorld] = strval(query);
        cache_get_field_content(0, "jailed", query);
        PlayerInfo[playerid][pJailed] = strval(query);
        cache_get_field_content(0, "jailtime", query);
        PlayerInfo[playerid][pJailTime] = strval(query);
        cache_get_field_content(0, "banned", query);
        PlayerInfo[playerid][pBanned] = strval(query);
        cache_get_field_content(0, "warns", query);
        PlayerInfo[playerid][pWarns] = strval(query);
        cache_get_field_content(0, "donate", query);
        PlayerInfo[playerid][pDonateRank] = strval(query);
        cache_get_field_content(0, "carlic", query);
        PlayerInfo[playerid][pCarLic] = strval(query);
        cache_get_field_content(0, "weplic", query);
        PlayerInfo[playerid][pWepLic] = strval(query);
        cache_get_field_content(0, "flylic", query);
        PlayerInfo[playerid][pFlyLic] = strval(query);
        cache_get_field_content(0, "posx", query);
        PlayerInfo[playerid][pPosX] = floatstr(query);
        cache_get_field_content(0, "poxy", query);
        PlayerInfo[playerid][pPosY] = floatstr(query);
        cache_get_field_content(0, "posz", query);
        PlayerInfo[playerid][pPosZ] = floatstr(query);
        cache_get_field_content(0, "posa", query);
        PlayerInfo[playerid][pPosA] = floatstr(query);
        cache_get_field_content(0, "died", query);
        PlayerInfo[playerid][pDied] = strval(query);
        cache_get_field_content(0, "pen", query);
        PlayerInfo[playerid][pPen] = strval(query);
        cache_get_field_content(0, "note1", query);
        PlayerInfo[playerid][pNote1] = strval(query);
        cache_get_field_content(0, "note1s", query);
        PlayerInfo[playerid][pNote1s] = strval(query);
        cache_get_field_content(0, "note2", query);
        PlayerInfo[playerid][pNote2] = strval(query);
        cache_get_field_content(0, "note2s", query);
        PlayerInfo[playerid][pNote2s] = strval(query);
        cache_get_field_content(0, "note3", query);
        PlayerInfo[playerid][pNote3] = strval(query);
        cache_get_field_content(0, "note3s", query);
        PlayerInfo[playerid][pNote3s] = strval(query);
        cache_get_field_content(0, "attributes", query);
        PlayerInfo[playerid][pAttributes] = strval(query);
        cache_get_field_content(0, "paycheck", query);
        PlayerInfo[playerid][pPayCheckMade] = strval(query);
        cache_get_field_content(0, "paycheckmoney", query);
        PlayerInfo[playerid][pPayCheckMoney] = strval(query);
        cache_get_field_content(0, "upgrade", query);
        PlayerInfo[playerid][pUpgrade] = strval(query);
        cache_get_field_content(0, "paydaytime", query);
        PlayerInfo[playerid][pPayDayTime] = strval(query);
        cache_get_field_content(0, "spawnhealth", query);
        PlayerInfo[playerid][pSHealth] = floatstr(query);
        cache_get_field_content(0, "cellphone", query);
        PlayerInfo[playerid][pCellPhone] = strval(query);
        cache_get_field_content(0, "number", query);
        PlayerInfo[playerid][pNumber] = strval(query);
        cache_get_field_content(0, "savings", query);
        PlayerInfo[playerid][pSavings] = strval(query);
        cache_get_field_content(0, "housekey", query);
        PlayerInfo[playerid][pHouseKey] = strval(query);
        cache_get_field_content(0, "melee", query);
        PlayerInfo[playerid][pMeleeWep] = strval(query);
        cache_get_field_content(0, "wep1", query);
        PlayerInfo[playerid][pPerm1] = strval(query);
        cache_get_field_content(0, "wep2", query);
        PlayerInfo[playerid][pPerm2] = strval(query);
        cache_get_field_content(0, "ammo1", query);
        PlayerInfo[playerid][pAmmo1] = strval(query);
        cache_get_field_content(0, "ammo2", query);
        PlayerInfo[playerid][pAmmo2] = strval(query);
        cache_get_field_content(0, "radio", query);
        PlayerInfo[playerid][pRadio] = strval(query);
        cache_get_field_content(0, "channel", query);
        PlayerInfo[playerid][pChannel] = strval(query);
        cache_get_field_content(0, "ownedchannel", query);
        PlayerInfo[playerid][pOwnedChannel] = strval(query);
        cache_get_field_content(0, "authed", query);
        PlayerInfo[playerid][pAuthed] = strval(query);
        cache_get_field_content(0, "crashed", query);
        PlayerInfo[playerid][pCrashed] = strval(query);
        cache_get_field_content(0, "mask", query);
        PlayerInfo[playerid][pMask] = strval(query);
        cache_get_field_content(0, "bmx", query);
        PlayerInfo[playerid][pBMX] = strval(query);
        cache_get_field_content(0, "carkey", query);
        PlayerInfo[playerid][pCarKey] = strval(query);
        cache_get_field_content(0, "veh1", query);
        PlayerVehicle[playerid][pVeh1] = strval(query);
        cache_get_field_content(0, "veh2", query);
        PlayerVehicle[playerid][pVeh2] = strval(query);
        cache_get_field_content(0, "veh3", query);
        PlayerVehicle[playerid][pVeh3] = strval(query);
        cache_get_field_content(0, "vehicles", query);
        PlayerInfo[playerid][pVehicles] = strval(query);
        cache_get_field_content(0, "vehslot", query);
        PlayerInfo[playerid][pVehSlot] = strval(query);
        cache_get_field_content(0, "sparekey", query);
        PlayerInfo[playerid][pSpareKey] = strval(query);
        cache_get_field_content(0, "lighter", query);
        PlayerInfo[playerid][pLighter] = strval(query);
        cache_get_field_content(0, "cigars", query);
        PlayerInfo[playerid][pCigars] = strval(query);
        cache_get_field_content(0, "bizkey", query);
        PlayerInfo[playerid][pBizKey] = strval(query);
        cache_get_field_content(0, "workon", query);
        PlayerInfo[playerid][pWorkOn] = strval(query);
        cache_get_field_content(0, "walk", query);
        PlayerInfo[playerid][pWalk] = strval(query);
        cache_get_field_content(0, "armour", query);
        PlayerInfo[playerid][pArmour] = floatstr(query);
        cache_get_field_content(0, "hasarmour", query);
        PlayerInfo[playerid][pHasArmour] = strval(query);
        cache_get_field_content(0, "faction", query);
        PlayerInfo[playerid][pFaction] = strval(query);
        cache_get_field_content(0, "rank", query);
        PlayerInfo[playerid][pRank] = strval(query);
        cache_get_field_content(0, "badgenumber", query);
        PlayerInfo[playerid][pBadgeNumber] = strval(query);
        cache_get_field_content(0, "drivewarns", query);
        PlayerInfo[playerid][pDriveWarns] = strval(query);
        cache_get_field_content(0, "jailtime2", query);
        PlayerInfo[playerid][pJailTime2] = strval(query);
        cache_get_field_content(0, "arrested", query);
        PlayerInfo[playerid][pArrested] = strval(query);
        cache_get_field_content(0, "chat", query);
        PlayerInfo[playerid][pTalk] = strval(query);
        cache_get_field_content(0, "swat", query);
        PlayerInfo[playerid][pSwat] = strval(query);
        cache_get_field_content(0, "slot", query);
        PlayerInfo[playerid][pSlot] = strval(query);
        cache_get_field_content(0, "tickets", query);
        AssignPlayerTickets(playerid, tickets);
        cache_get_field_content(0, "job", query);
        PlayerInfo[playerid][pJob] = strval(query);
        cache_get_field_content(0, "jobrank", query);
        PlayerInfo[playerid][pJobRank] = strval(query);
        cache_get_field_content(0, "career", query);
        PlayerInfo[playerid][pCareer] = strval(query);
        cache_get_field_content(0, "spawntype", query);
        PlayerInfo[playerid][pSpawnType] = strval(query);
        cache_get_field_content(0, "prisoned", query);
        PlayerInfo[playerid][pPrisoned] = strval(query);
        cache_get_field_content(0, "drugs", query);
        AssignPlayerDrugs(playerid, drugs);
        cache_get_field_content(0, "seeds", query);
        PlayerInfo[playerid][pSeeds] = strval(query);
    return 1;
}
Find
Reply
CuervO
High-roller
*****
Posts: 1,164
Threads: 20
Joined: Oct 2008
Reputation: 0
#6

27.02.2014, 17:25
While both functions are usefull I meant the part where the OnAccountLoad is being called. Also, is BizKey actually being saved to the database? The variable used on the moment of saving could be wrongly set.
Find
Reply
HK
Big Clucker
***
Posts: 163
Threads: 30
Joined: Nov 2013
Reputation: 0
#7

27.02.2014, 17:29
Quote:
Originally Posted by Misiur
Посмотреть сообщение
#e:
Brainfart, completely wrong answer. The handle is third argument, not first. Sorry!

But use cache_get_row_int. What do the logs say?
This wont work at all dude, since its giving me errors. Can someone help me with this problem please...
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#8

27.02.2014, 17:43
cache_get_row_int/cache_get_field_content_int is faster than cache_get_row/cache_get_field_content + strval. Please provide OnAccountLoad as @CuervO pointed out, and if you can, mysql_log as well.
Find
Reply
HK
Big Clucker
***
Posts: 163
Threads: 30
Joined: Nov 2013
Reputation: 0
#9

27.02.2014, 17:52
pawn Код:
public OnAccountLoad(playerid)
{
    new tickets[256], drugs[256];
    cache_get_field_content(0, "id", query);
        PlayerInfo[playerid][pDatabaseID] = strval(query);
        cache_get_field_content(0, "registered", query);
        PlayerInfo[playerid][pRegistered] = strval(query);
        cache_get_field_content(0, "cash", query);
        PlayerInfo[playerid][pCash] = strval(query);
        cache_get_field_content(0, "bank", query);
        PlayerInfo[playerid][pBank] = strval(query);
        cache_get_field_content(0, "skin", query);
        PlayerInfo[playerid][pSkin] = strval(query);
        cache_get_field_content(0, "sex", query);
        PlayerInfo[playerid][pSex] = strval(query);
        cache_get_field_content(0, "age", query);
        PlayerInfo[playerid][pAge] = strval(query);
        cache_get_field_content(0, "origin", query);
        format(PlayerInfo[playerid][pOrigin], 256, query);
        cache_get_field_content(0, "level", query);
        PlayerInfo[playerid][pLevel] = strval(query);
        cache_get_field_content(0, "exp", query);
        PlayerInfo[playerid][pExp] = strval(query);
        cache_get_field_content(0, "hours", query);
        PlayerInfo[playerid][pHours] = strval(query);
        cache_get_field_content(0, "admin", query);
        PlayerInfo[playerid][pAdmin] = strval(query);
        cache_get_field_content(0, "helper", query);
        PlayerInfo[playerid][pHelper] = strval(query);
        cache_get_field_content(0, "int", query);
        PlayerInfo[playerid][pInt] = strval(query);
        cache_get_field_content(0, "world", query);
        PlayerInfo[playerid][pWorld] = strval(query);
        cache_get_field_content(0, "jailed", query);
        PlayerInfo[playerid][pJailed] = strval(query);
        cache_get_field_content(0, "jailtime", query);
        PlayerInfo[playerid][pJailTime] = strval(query);
        cache_get_field_content(0, "banned", query);
        PlayerInfo[playerid][pBanned] = strval(query);
        cache_get_field_content(0, "warns", query);
        PlayerInfo[playerid][pWarns] = strval(query);
        cache_get_field_content(0, "donate", query);
        PlayerInfo[playerid][pDonateRank] = strval(query);
        cache_get_field_content(0, "carlic", query);
        PlayerInfo[playerid][pCarLic] = strval(query);
        cache_get_field_content(0, "weplic", query);
        PlayerInfo[playerid][pWepLic] = strval(query);
        cache_get_field_content(0, "flylic", query);
        PlayerInfo[playerid][pFlyLic] = strval(query);
        cache_get_field_content(0, "posx", query);
        PlayerInfo[playerid][pPosX] = floatstr(query);
        cache_get_field_content(0, "poxy", query);
        PlayerInfo[playerid][pPosY] = floatstr(query);
        cache_get_field_content(0, "posz", query);
        PlayerInfo[playerid][pPosZ] = floatstr(query);
        cache_get_field_content(0, "posa", query);
        PlayerInfo[playerid][pPosA] = floatstr(query);
        cache_get_field_content(0, "died", query);
        PlayerInfo[playerid][pDied] = strval(query);
        cache_get_field_content(0, "pen", query);
        PlayerInfo[playerid][pPen] = strval(query);
        cache_get_field_content(0, "note1", query);
        PlayerInfo[playerid][pNote1] = strval(query);
        cache_get_field_content(0, "note1s", query);
        PlayerInfo[playerid][pNote1s] = strval(query);
        cache_get_field_content(0, "note2", query);
        PlayerInfo[playerid][pNote2] = strval(query);
        cache_get_field_content(0, "note2s", query);
        PlayerInfo[playerid][pNote2s] = strval(query);
        cache_get_field_content(0, "note3", query);
        PlayerInfo[playerid][pNote3] = strval(query);
        cache_get_field_content(0, "note3s", query);
        PlayerInfo[playerid][pNote3s] = strval(query);
        cache_get_field_content(0, "attributes", query);
        PlayerInfo[playerid][pAttributes] = strval(query);
        cache_get_field_content(0, "paycheck", query);
        PlayerInfo[playerid][pPayCheckMade] = strval(query);
        cache_get_field_content(0, "paycheckmoney", query);
        PlayerInfo[playerid][pPayCheckMoney] = strval(query);
        cache_get_field_content(0, "upgrade", query);
        PlayerInfo[playerid][pUpgrade] = strval(query);
        cache_get_field_content(0, "paydaytime", query);
        PlayerInfo[playerid][pPayDayTime] = strval(query);
        cache_get_field_content(0, "spawnhealth", query);
        PlayerInfo[playerid][pSHealth] = floatstr(query);
        cache_get_field_content(0, "cellphone", query);
        PlayerInfo[playerid][pCellPhone] = strval(query);
        cache_get_field_content(0, "number", query);
        PlayerInfo[playerid][pNumber] = strval(query);
        cache_get_field_content(0, "savings", query);
        PlayerInfo[playerid][pSavings] = strval(query);
        cache_get_field_content(0, "housekey", query);
        PlayerInfo[playerid][pHouseKey] = strval(query);
        cache_get_field_content(0, "melee", query);
        PlayerInfo[playerid][pMeleeWep] = strval(query);
        cache_get_field_content(0, "wep1", query);
        PlayerInfo[playerid][pPerm1] = strval(query);
        cache_get_field_content(0, "wep2", query);
        PlayerInfo[playerid][pPerm2] = strval(query);
        cache_get_field_content(0, "ammo1", query);
        PlayerInfo[playerid][pAmmo1] = strval(query);
        cache_get_field_content(0, "ammo2", query);
        PlayerInfo[playerid][pAmmo2] = strval(query);
        cache_get_field_content(0, "radio", query);
        PlayerInfo[playerid][pRadio] = strval(query);
        cache_get_field_content(0, "channel", query);
        PlayerInfo[playerid][pChannel] = strval(query);
        cache_get_field_content(0, "ownedchannel", query);
        PlayerInfo[playerid][pOwnedChannel] = strval(query);
        cache_get_field_content(0, "authed", query);
        PlayerInfo[playerid][pAuthed] = strval(query);
        cache_get_field_content(0, "crashed", query);
        PlayerInfo[playerid][pCrashed] = strval(query);
        cache_get_field_content(0, "mask", query);
        PlayerInfo[playerid][pMask] = strval(query);
        cache_get_field_content(0, "bmx", query);
        PlayerInfo[playerid][pBMX] = strval(query);
        cache_get_field_content(0, "carkey", query);
        PlayerInfo[playerid][pCarKey] = strval(query);
        cache_get_field_content(0, "veh1", query);
        PlayerVehicle[playerid][pVeh1] = strval(query);
        cache_get_field_content(0, "veh2", query);
        PlayerVehicle[playerid][pVeh2] = strval(query);
        cache_get_field_content(0, "veh3", query);
        PlayerVehicle[playerid][pVeh3] = strval(query);
        cache_get_field_content(0, "vehicles", query);
        PlayerInfo[playerid][pVehicles] = strval(query);
        cache_get_field_content(0, "vehslot", query);
        PlayerInfo[playerid][pVehSlot] = strval(query);
        cache_get_field_content(0, "sparekey", query);
        PlayerInfo[playerid][pSpareKey] = strval(query);
        cache_get_field_content(0, "lighter", query);
        PlayerInfo[playerid][pLighter] = strval(query);
        cache_get_field_content(0, "cigars", query);
        PlayerInfo[playerid][pCigars] = strval(query);
        cache_get_field_content(0, "bizkey", query);
        PlayerInfo[playerid][pBizKey] = strval(query);
        cache_get_field_content(0, "workon", query);
        PlayerInfo[playerid][pWorkOn] = strval(query);
        cache_get_field_content(0, "walk", query);
        PlayerInfo[playerid][pWalk] = strval(query);
        cache_get_field_content(0, "armour", query);
        PlayerInfo[playerid][pArmour] = floatstr(query);
        cache_get_field_content(0, "hasarmour", query);
        PlayerInfo[playerid][pHasArmour] = strval(query);
        cache_get_field_content(0, "faction", query);
        PlayerInfo[playerid][pFaction] = strval(query);
        cache_get_field_content(0, "rank", query);
        PlayerInfo[playerid][pRank] = strval(query);
        cache_get_field_content(0, "badgenumber", query);
        PlayerInfo[playerid][pBadgeNumber] = strval(query);
        cache_get_field_content(0, "drivewarns", query);
        PlayerInfo[playerid][pDriveWarns] = strval(query);
        cache_get_field_content(0, "jailtime2", query);
        PlayerInfo[playerid][pJailTime2] = strval(query);
        cache_get_field_content(0, "arrested", query);
        PlayerInfo[playerid][pArrested] = strval(query);
        cache_get_field_content(0, "chat", query);
        PlayerInfo[playerid][pTalk] = strval(query);
        cache_get_field_content(0, "swat", query);
        PlayerInfo[playerid][pSwat] = strval(query);
        cache_get_field_content(0, "slot", query);
        PlayerInfo[playerid][pSlot] = strval(query);
        cache_get_field_content(0, "tickets", query);
        AssignPlayerTickets(playerid, tickets);
        cache_get_field_content(0, "job", query);
        PlayerInfo[playerid][pJob] = strval(query);
        cache_get_field_content(0, "jobrank", query);
        PlayerInfo[playerid][pJobRank] = strval(query);
        cache_get_field_content(0, "career", query);
        PlayerInfo[playerid][pCareer] = strval(query);
        cache_get_field_content(0, "spawntype", query);
        PlayerInfo[playerid][pSpawnType] = strval(query);
        cache_get_field_content(0, "prisoned", query);
        PlayerInfo[playerid][pPrisoned] = strval(query);
        cache_get_field_content(0, "drugs", query);
        AssignPlayerDrugs(playerid, drugs);
        cache_get_field_content(0, "seeds", query);
        PlayerInfo[playerid][pSeeds] = strval(query);
    return 1;
}
pawn Код:
[19:43:12] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:43:12] [DEBUG] ProcessQueryThread(OnPlayerSpawnVehicle) - Executing query SELECT * FROM `ownedvehicles` WHERE `owner` = 'Holger_Test' AND `slot` = 1...
[19:43:13] [DEBUG] ProcessQueryThread(OnPlayerSpawnVehicle) - Query was successful.
[19:43:13] [DEBUG] ProcessQueryThread(OnPlayerSpawnVehicle) - Data caching enabled.
[19:43:13] [DEBUG] CMySQLHandler::StoreResult() - Result was stored.
[19:43:13] [DEBUG] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:43:13] [DEBUG] ProcessQueryThread(OnPlayerSpawnVehicle) - Data being passed to ProcessTick().
[19:43:13] [DEBUG] OnPlayerSpawnVehicle(ii) - Callback is being called...
[19:43:13] [DEBUG] >> cache_get_data(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_float(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_float(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_float(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_float(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:43:13] [DEBUG] >> cache_get_row(Connection handle: 1)
[19:43:13] [DEBUG] ProcessTick() - The cache has been cleared.
[19:46:20] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:20] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:20] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `bizkey` = -1 WHERE `name` = 'Paul_Test'...
[19:46:21] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:21] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:21] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:21] [DEBUG] ProcessQueryThread(GivePlayerBizMoney) - Executing query SELECT `cash` FROM `users` WHERE `name` = 'Paul_Test'...
[19:46:21] [DEBUG] ProcessQueryThread(GivePlayerBizMoney) - Query was successful.
[19:46:21] [DEBUG] ProcessQueryThread(GivePlayerBizMoney) - Data caching enabled.
[19:46:21] [DEBUG] CMySQLHandler::StoreResult() - Result was stored.
[19:46:21] [DEBUG] CMySQLHandler::FreeResult() - Result was successfully freed.
[19:46:21] [DEBUG] ProcessQueryThread(GivePlayerBizMoney) - Data being passed to ProcessTick().
[19:46:21] [DEBUG] GivePlayerBizMoney(ii) - Callback is being called...
[19:46:21] [DEBUG] >> cache_get_data(Connection handle: 1)
[19:46:21] [DEBUG] >> cache_get_row_int(Connection handle: 1)
[19:46:21] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:21] [DEBUG] ProcessTick() - The cache has been cleared.
[19:46:21] [DEBUG] ProcessQueryThread(OnAdminSellBusiness) - Executing query UPDATE `business` SET `owner` = 'The State', `owned` = 0, `locked` = 1, `cash` = 0, `entrance` = 0 WHERE `id` = 30...
[19:46:21] [DEBUG] ProcessQueryThread(OnAdminSellBusiness) - Query was successful.
[19:46:21] [DEBUG] ProcessQueryThread(OnAdminSellBusiness) - Data caching enabled.
[19:46:21] [WARNING] CMySQLHandler::StoreResult() - No data to store.
[19:46:21] [DEBUG] ProcessQueryThread(OnAdminSellBusiness) - Data being passed to ProcessTick().
[19:46:21] [DEBUG] OnAdminSellBusiness(i) - Callback is being called...
[19:46:21] [DEBUG] ProcessTick() - The cache has been cleared.
[19:46:21] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `cash` = 250 WHERE `name` = 'Paul_Test'...
[19:46:21] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:21] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `owned` = 1, `locked` = 1, `price`= 100000, `levelbuy`= 20, `interior` = 17, `world` = 26, `cash` = 0, `type` = 3, `entrance` = 0 WHERE `id` = 30...
[19:46:44] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:44] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:46:44] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `owner` = 'Holger_Test', `info` = '24-7 Store', `name` = '~b~ The Mexican 24/7', `entermsg` = 'HINT: /buy to buy goods from the shop.' WHERE `id` = 30...
[19:46:44] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:44] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:44] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `posx` = 1951.680053, `posy` = -2041.349975, `posz` = 13.546899, `exitx` = -25.884500, `exity` = -185.869003, `exitz` = 1003.549987, `radio` = 0 WHERE `id` = 30...
[19:46:44] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:44] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:44] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `registered` = 1, `cash` = 264777, `bank` = 10000, `skin` = 283, `sex` = 1, `age` = 47, `origin` = 'White', `level` = 20, `exp` = 0, `hours` = 0, `admin` = 2013, `helper` = 0, `int` = 0, `world` = 0 WHERE `name` = 'Holger_Test'...
[19:46:44] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:44] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:44] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `jailed` = 0, `jailtime` = 0, `banned` = 0, `warns` = 0, `donate` = 0, `carlic` = 0, `weplic` = 0, `flylic` = 0, `posx` = 1952.112426, `posy` = -2041.188354, `posz` = 13.546875, `posa` = 73.731658 WHERE `name` = 'Holger_Test'...
[19:46:44] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:44] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `died` = 0, `fightstyle` = 0, `pen` = 0, `note1` = '', `note1s` = 0, `note2` = '', `note2s` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [ERROR] ProcessQueryThread() - Unknown column 'note1' in 'field list' (error ID: 1054)
[19:46:45] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `note3` = '', `note3s` = 0, `attributes` = '', `paycheck` = 0, `paycheckmoney` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [ERROR] ProcessQueryThread() - Unknown column 'note3' in 'field list' (error ID: 1054)
[19:46:45] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `upgrade` = 0, `paydaytime` = 8, `spawnhealth` = 0.0, `cellphone` = 1, `number` = 7503898, `savings` = 0, `housekey` = -1, `melee` = 0, `wep1`= 0, `wep2` = 0, `ammo1` = 0, `ammo2`= 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:45] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `radio` = 0, `channel` = 0, `ownedchannel` = 0, `authed` = 0, `crashed` = 0, `mask` = 0, `accenton` = 0, `accent` = 'None', `bmx` = 0, `carkey` = 71, `vehicles` = 1 WHERE `name` = 'Holger_Test'...
[19:46:45] [ERROR] ProcessQueryThread() - Unknown column 'channel' in 'field list' (error ID: 1054)
[19:46:45] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `veh1` = 'Nebula', `veh2` = '', `veh3` = '', `vehslot` = 1, `hunger` = 100.0, `sparekey` = 0, `lighter` = 0, `cigars` = 0, `bizkey` = 26, `workon` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [ERROR] ProcessQueryThread() - Unknown column 'veh1' in 'field list' (error ID: 1054)
[19:46:45] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `walk` = 0, `armour` = 0.0, `hasarmour` = 0, `faction` = 1, `rank` = 18, `badgenumber` = 44850, `drivewarns` = 0, `jailtime2` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:45] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `arrested` = 0, `chat` = 0, `swat` = 0, `slot` = 1, `tickets` = '0|0|0|0|0|0|0|0|0|0', `job` = 1, `jobrank` = 1, `career` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:45] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `sidejob` = 0, `spawntype` = 2, `prisoned` = 0, `drugs` = '0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0' WHERE `name` = 'Holger_Test'...
[19:46:45] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:45] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:46:45] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `seeds` = 0 WHERE `name` = 'Holger_Test'...
[19:46:45] [DEBUG] ProcessQueryThread() - Query was successful.
[19:46:45] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:26] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:26] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:26] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `owned` = 1, `locked` = 0, `price`= 100000, `levelbuy`= 20, `interior` = 17, `world` = 26, `cash` = 5600, `type` = 3, `entrance` = 0 WHERE `id` = 30...
[19:52:26] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:26] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:26] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:26] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:27] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] >> mysql_query_callback(Connection handle: 1)
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `owner` = 'Holger_Test', `info` = '24-7 Store', `name` = '~b~ The Mexican 24/7', `entermsg` = 'HINT: /buy to buy goods from the shop.' WHERE `id` = 30...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `business` SET `posx` = 1951.680053, `posy` = -2041.349975, `posz` = 13.546899, `exitx` = -25.884500, `exity` = -185.869003, `exitz` = 1003.549987, `radio` = 0 WHERE `id` = 30...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `color1` = 1, `color2` = 1, `parkx` = 1703.180053, `parky` = -1509.010009, `parkz` = 13.389300, `parka` = 0.000000 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `plate` = 'HT87223', `owner` = 'Holger_Test', `owned` = 1, `broken` = 0 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `alarm` = 0, `lock` = 0, `immob` = 0, `insurances` = 2, `destroys` = 0, `gps` = 0, `fuel` = 48, `registered` = 1 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `weapons` = '0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0' WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `comp0` = 0, `comp1` = 0, `comp2` = 0, `comp3` = 0, `comp4` = 0, `comp5` = 0, `comp6` = 0 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `comp7` = 0, `comp8` = 0, `comp9` = 0, `comp10` = 0, `comp11` = 0, `comp12` = 0, `comp13` = 0, `paintjob` = 3 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:28] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:28] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `radio` = 0, `tickets` = '0|0|0|0|0|0|0|0|0|0', `dupkey` = 8234718, `comps` = 0 WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:28] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `ownedvehicles` SET `drugs` = '0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0' WHERE `owner` = 'Holger_Test' AND `id` = 3...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `registered` = 1, `cash` = 259177, `bank` = 10000, `skin` = 29, `sex` = 1, `age` = 47, `origin` = 'White', `level` = 20, `exp` = 0, `hours` = 0, `admin` = 2013, `helper` = 0, `int` = 0, `world` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `jailed` = 0, `jailtime` = 0, `banned` = 0, `warns` = 0, `donate` = 0, `carlic` = 0, `weplic` = 0, `flylic` = 0, `posx` = 1915.326782, `posy` = -2063.583496, `posz` = 13.546502, `posa` = 252.711120 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `died` = 0, `fightstyle` = 0, `pen` = 0, `note1` = '', `note1s` = 0, `note2` = '', `note2s` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [ERROR] ProcessQueryThread() - Unknown column 'note1' in 'field list' (error ID: 1054)
[19:52:29] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `note3` = '', `note3s` = 0, `attributes` = '', `paycheck` = 0, `paycheckmoney` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [ERROR] ProcessQueryThread() - Unknown column 'note3' in 'field list' (error ID: 1054)
[19:52:29] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `upgrade` = 0, `paydaytime` = 8, `spawnhealth` = 0.0, `cellphone` = 1, `number` = 7503898, `savings` = 0, `housekey` = -1, `melee` = 0, `wep1`= 24, `wep2` = 30, `ammo1` = 66, `ammo2`= 98 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `radio` = 0, `channel` = 0, `ownedchannel` = 0, `authed` = 0, `crashed` = 0, `mask` = 0, `accenton` = 0, `accent` = 'None', `bmx` = 0, `carkey` = 71, `vehicles` = 1 WHERE `name` = 'Holger_Test'...
[19:52:29] [ERROR] ProcessQueryThread() - Unknown column 'channel' in 'field list' (error ID: 1054)
[19:52:29] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `veh1` = 'Nebula', `veh2` = '', `veh3` = '', `vehslot` = 1, `hunger` = 100.0, `sparekey` = 0, `lighter` = 5, `cigars` = 1, `bizkey` = 26, `workon` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [ERROR] ProcessQueryThread() - Unknown column 'veh1' in 'field list' (error ID: 1054)
[19:52:29] [DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `walk` = 0, `armour` = 0.0, `hasarmour` = 0, `faction` = 1, `rank` = 18, `badgenumber` = 44850, `drivewarns` = 0, `jailtime2` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `arrested` = 0, `chat` = 0, `swat` = 0, `slot` = 1, `tickets` = '0|0|0|0|0|0|0|0|0|0', `job` = 1, `jobrank` = 1, `career` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `sidejob` = 0, `spawntype` = 2, `prisoned` = 0, `drugs` = '0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0|0=0' WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
[19:52:29] [DEBUG] ProcessQueryThread() - Executing query UPDATE `users` SET `seeds` = 0 WHERE `name` = 'Holger_Test'...
[19:52:29] [DEBUG] ProcessQueryThread() - Query was successful.
[19:52:29] [DEBUG] ProcessQueryThread() - Data being passed to ProcessTick().
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#10

27.02.2014, 17:58
The log doesn't contain the select query. If you can, provide the query you execute (with callback OnAccountLoad).

Important note: You have some errors in log, find all lines starting from "ERROR" and fix them.
Sidenote: Run your updates in a transaction to get better performance.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help