MySQL, something loads data, and something doesnt.
#1

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?

Is there something wrong with my public here?

Код 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;
}
Reply
#2

You should use cache_get_field_content 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).

Also, what MySQL version are you running?
Reply
#3

MySQL r20.
Reply
#4

Anyone? Please, i've been running with this issue for weeks
Reply
#5

FIXED ALREADY.

- To people who getting problems with this, here's is how I fixed it:

I simply counted my rows and edited it as it was, cuz I made it buggy.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)