MySQL, something loads data, and something doesnt. -
Hello guys, i'm almost DONE with my new GM, but now im facing an seriously problem, something like admin levels is saving inside my database and DO loading when I connect again.
But something such as a house key ((which getting saved into the database, I can see my key inside it)) doenst load?
Код HTML:
public OnAccountLoad(playerid)
{
new tickets[256], drugs[256];
PlayerInfo[playerid][pDatabaseID] = cache_get_row_int(0, 0);
PlayerInfo[playerid][pRegistered] = cache_get_row_int(0, 4);
PlayerInfo[playerid][pCash] = cache_get_row_int(0, 5);
PlayerInfo[playerid][pBank] = cache_get_row_int(0, 6);
PlayerInfo[playerid][pSkin] = cache_get_row_int(0, 7);
PlayerInfo[playerid][pSex] = cache_get_row_int(0, 8);
PlayerInfo[playerid][pAge] = cache_get_row_int(0, 9);
cache_get_row(0, 10, PlayerInfo[playerid][pOrigin], dbHandle, 128);
PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 11);
PlayerInfo[playerid][pExp] = cache_get_row_int(0, 12);
PlayerInfo[playerid][pHours] = cache_get_row_int(0, 13);
PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 14);
PlayerInfo[playerid][pHelper] = cache_get_row_int(0, 15);
PlayerInfo[playerid][pInt] = cache_get_row_int(0, 16);
PlayerInfo[playerid][pWorld] = cache_get_row_int(0, 17);
PlayerInfo[playerid][pJailed] = cache_get_row_int(0, 18);
PlayerInfo[playerid][pJailTime] = cache_get_row_int(0, 19);
PlayerInfo[playerid][pBanned] = cache_get_row_int(0, 20);
PlayerInfo[playerid][pWarns] = cache_get_row_int(0, 21);
PlayerInfo[playerid][pDonateRank] = cache_get_row_int(0, 22);
PlayerInfo[playerid][pCarLic] = cache_get_row_int(0, 23);
PlayerInfo[playerid][pWepLic] = cache_get_row_int(0, 24);
PlayerInfo[playerid][pFlyLic] = cache_get_row_int(0, 25);
PlayerInfo[playerid][pPosX] = cache_get_row_float(0, 26);
PlayerInfo[playerid][pPosY] = cache_get_row_float(0, 27);
PlayerInfo[playerid][pPosZ] = cache_get_row_float(0, 28);
PlayerInfo[playerid][pPosA] = cache_get_row_float(0, 29);
PlayerInfo[playerid][pDied] = cache_get_row_int(0, 30);
PlayerInfo[playerid][pFightStyle] = cache_get_row_int(0, 31);
PlayerInfo[playerid][pPen] = cache_get_row_int(0, 32);
cache_get_row(0, 33, PlayerInfo[playerid][pNote1], dbHandle, 128);
PlayerInfo[playerid][pNote1s] = cache_get_row_int(0, 34);
cache_get_row(0, 35, PlayerInfo[playerid][pNote2], dbHandle, 128);
PlayerInfo[playerid][pNote2s] = cache_get_row_int(0, 36);
cache_get_row(0, 37, PlayerInfo[playerid][pNote3], dbHandle, 128);
PlayerInfo[playerid][pNote3s] = cache_get_row_int(0, 38);
cache_get_row(0, 39, PlayerInfo[playerid][pAttributes], dbHandle, 128);
PlayerInfo[playerid][pPayCheckMade] = cache_get_row_int(0, 40);
PlayerInfo[playerid][pPayCheckMoney] = cache_get_row_int(0, 41);
PlayerInfo[playerid][pUpgrade] = cache_get_row_int(0, 42);
PlayerInfo[playerid][pPayDayTime] = cache_get_row_int(0, 43);
PlayerInfo[playerid][pSHealth] = cache_get_row_float(0, 44);
PlayerInfo[playerid][pCellPhone] = cache_get_row_int(0, 45);
PlayerInfo[playerid][pNumber] = cache_get_row_int(0, 46);
PlayerInfo[playerid][pSavings] = cache_get_row_int(0, 47);
PlayerInfo[playerid][pHouseKey] = cache_get_row_int(0, 48);
PlayerInfo[playerid][pMeleeWep] = cache_get_row_int(0, 49);
PlayerInfo[playerid][pPerm1] = cache_get_row_int(0, 50);
PlayerInfo[playerid][pPerm2] = cache_get_row_int(0, 51);
PlayerInfo[playerid][pAmmo1] = cache_get_row_int(0, 52);
PlayerInfo[playerid][pAmmo2] = cache_get_row_int(0, 53);
PlayerInfo[playerid][pRadio] = cache_get_row_int(0, 54);
PlayerInfo[playerid][pChannel] = cache_get_row_int(0, 55);
PlayerInfo[playerid][pOwnedChannel] = cache_get_row_int(0, 56);
PlayerInfo[playerid][pAuthed] = cache_get_row_int(0, 57);
PlayerInfo[playerid][pCrashed] = cache_get_row_int(0, 58);
PlayerInfo[playerid][pMask] = cache_get_row_int(0, 59);
PlayerInfo[playerid][pAccentOn] = cache_get_row_int(0, 60);
cache_get_row(0, 61, PlayerInfo[playerid][pAccent], dbHandle, 128);
PlayerInfo[playerid][pBMX] = cache_get_row_int(0, 62);
PlayerInfo[playerid][pCarKey] = cache_get_row_int(0, 63);
cache_get_row(0, 64, PlayerVehicle[playerid][pVeh1], dbHandle, 255);
cache_get_row(0, 65, PlayerVehicle[playerid][pVeh2], dbHandle, 255);
cache_get_row(0, 66, PlayerVehicle[playerid][pVeh3], dbHandle, 255);
PlayerInfo[playerid][pVehicles] = cache_get_row_int(0, 67);
PlayerInfo[playerid][pVehSlot] = cache_get_row_int(0, 68);
PlayerInfo[playerid][pHunger] = cache_get_row_float(0, 69);
PlayerInfo[playerid][pSpareKey] = cache_get_row_int(0, 70);
PlayerInfo[playerid][pLighter] = cache_get_row_int(0, 71);
PlayerInfo[playerid][pCigars] = cache_get_row_int(0, 72);
PlayerInfo[playerid][pBizKey] = cache_get_row_int(0, 73);
PlayerInfo[playerid][pWorkOn] = cache_get_row_int(0, 74);
PlayerInfo[playerid][pWalk] = cache_get_row_int(0, 75);
PlayerInfo[playerid][pArmour] = cache_get_row_float(0, 76);
PlayerInfo[playerid][pHasArmour] = cache_get_row_int(0, 77);
PlayerInfo[playerid][pFaction] = cache_get_row_int(0, 78);
PlayerInfo[playerid][pRank] = cache_get_row_int(0, 79);
PlayerInfo[playerid][pBadgeNumber] = cache_get_row_int(0, 80);
PlayerInfo[playerid][pDriveWarns] = cache_get_row_int(0, 81);
PlayerInfo[playerid][pJailTime2] = cache_get_row_int(0, 82);
PlayerInfo[playerid][pArrested] = cache_get_row_int(0, 83);
PlayerInfo[playerid][pTalk] = cache_get_row_int(0, 84);
PlayerInfo[playerid][pSwat] = cache_get_row_int(0, 85);
PlayerInfo[playerid][pSlot] = cache_get_row_int(0, 86);
cache_get_row(0, 87, tickets, dbHandle, 255);
AssignPlayerTickets(playerid, tickets);
PlayerInfo[playerid][pJob] = cache_get_row_int(0, 88);
PlayerInfo[playerid][pJobRank] = cache_get_row_int(0, 89);
PlayerInfo[playerid][pCareer] = cache_get_row_int(0, 90);
PlayerInfo[playerid][pSideJob] = cache_get_row_int(0, 91);
PlayerInfo[playerid][pSpawnType] = cache_get_row_int(0, 92);
PlayerInfo[playerid][pPrisoned] = cache_get_row_int(0, 93);
cache_get_row(0, 94, drugs, dbHandle, 255);
AssignPlayerDrugs(playerid, drugs);
PlayerInfo[playerid][pSeeds] = cache_get_row_int(0, 95);
return 1;
}
Re: MySQL, something loads data, and something doesnt. - Emmet_ - 05.12.2013
and specify the field name. I'm assuming that you're using "*" to fetch all of the data from that row, so sometimes the order can get mixed up (I suppose).
Re: MySQL, something loads data, and something doesnt. -
Re: MySQL, something loads data, and something doesnt. -
Re: MySQL, something loads data, and something doesnt. -
FIXED ALREADY.