Query was empty??? MYSQL HELP
#1

Код:
forward OnAccountLoad(playerid);
public OnAccountLoad(playerid)
{
	cache_get_field_content(0, "pName", pData[playerid][pName], mysql, 24);
	pData[playerid][pLevel] = cache_get_field_content_int(0, "pLevel");
	cache_get_field_content(0, "pPass", pData[playerid][pPass], mysql, 129);
	cache_get_field_content(0, "pRegisterIP", pData[playerid][pRegisterIP], mysql, 35);
	pData[playerid][pAdmin] = cache_get_field_content_int(0, "pAdmin");
	pData[playerid][pAdminJelszo] = cache_get_field_content_int(0, "pAdminJelszo");
	pData[playerid][pAdminBelepve] = cache_get_field_content_int(0, "pAdminBelepve");
	pData[playerid][pMoney] = cache_get_field_content_int(0, "pMoney");
	pData[playerid][pHoursPlayed] = cache_get_field_content_int(0, "pHoursPlayed");
	pData[playerid][pSkin] = cache_get_field_content_int(0, "pSkin");
	pData[playerid][pGender] = cache_get_field_content_int(0, "pGender");
	pData[playerid][pKor] = cache_get_field_content_int(0, "pKor");
	pData[playerid][pSuly] = cache_get_field_content_int(0, "pSuly");
	pData[playerid][pMagassag] = cache_get_field_content_int(0, "pMagassag");
	pData[playerid][pInterior] = cache_get_field_content_int(0, "pInterior");
	pData[playerid][pVirtualWorld] = cache_get_field_content_int(0, "pVirtualWorld");
	pData[playerid][pMask] = cache_get_field_content_int(0, "pMask");
	pData[playerid][pVIP] = cache_get_field_content_int(0, "pVIP");
	pData[playerid][pMutolva] = cache_get_field_content_int(0, "pMutolva");
	pData[playerid][pRadioChannel] = cache_get_field_content_int(0, "pRadioChannel");
	pData[playerid][pRadio] = cache_get_field_content_int(0, "pRadio");
	pData[playerid][pHelper] = cache_get_field_content_int(0, "pHelper");
	pData[playerid][pHospital] = cache_get_field_content_int(0, "pHospital");
	pData[playerid][pHospitalLevel] = cache_get_field_content_int(0, "pHospitalLevel");
	pData[playerid][pPhNumber] = cache_get_field_content_int(0, "pPhNumber");
	pData[playerid][pPhCase] = cache_get_field_content_int(0, "pPhCase");
	pData[playerid][pHasBankCard] = cache_get_field_content_int(0, "pHasBankCard");
	pData[playerid][pBankMoney] = cache_get_field_content_int(0, "pBankMoney");
	pData[playerid][pBanned] = cache_get_field_content_int(0, "pBanned");
	pData[playerid][pBanAppealable] = cache_get_field_content_int(0, "pBanAppealable");
 	cache_get_field_content(0, "pBanReason", pData[playerid][pBanReason], mysql, 130);
	pData[playerid][pBannedBy] = cache_get_field_content_int(0, "pBannedBy");
	cache_get_field_content(0, "pBanDate", pData[playerid][pBanDate], mysql, 35);
	pData[playerid][pWarnings] = cache_get_field_content_int(0, "pWarnings");
	pData[playerid][pMuted] = cache_get_field_content_int(0, "pMuted");
	pData[playerid][pFrozen] = cache_get_field_content_int(0, "pFrozen");
	pData[playerid][pTutorialFinished] = cache_get_field_content_int(0, "pTutorialFinished");
	pData[playerid][pPassport] = cache_get_field_content_int(0, "pPassport");
	pData[playerid][pDriversLicense] = cache_get_field_content_int(0, "pDriversLicense");
	pData[playerid][pFlyingLicense] = cache_get_field_content_int(0, "pFlyingLicense");
	pData[playerid][pTaxiLicense] = cache_get_field_content_int(0, "pTaxiLicense");
	pData[playerid][pWeaponLicense] = cache_get_field_content_int(0, "pWeaponLicense");
	pData[playerid][pBoatLicense] = cache_get_field_content_int(0, "pBoatLicense");
	format(pData[playerid][pRegisterDate], 1, "");
	format(pData[playerid][pLastLoginDate], 1, "");
	pData[playerid][pUpgradesLeft] = cache_get_field_content_int(0, "pUpgradesLeft");
	pData[playerid][pStrengthUpgrade] = cache_get_field_content_int(0, "pStrengthUpgrade");
	pData[playerid][pHealthUpgrade] = cache_get_field_content_int(0, "pHealthUpgrade");
	pData[playerid][pWalkStyle] = cache_get_field_content_int(0, "pWalkStyle");
	pData[playerid][pChatStyle] = cache_get_field_content_int(0, "pChatStyle");
	pData[playerid][pFaction] = cache_get_field_content_int(0, "pFaction");
	pData[playerid][pFactionRank] = cache_get_field_content_int(0, "pFactionRank");
	pData[playerid][pFactionSkin] = cache_get_field_content_int(0, "pFactionSkin");
	pData[playerid][pUsingFactionSkin] = cache_get_field_content_int(0, "pUsingFactionSkin");
	pData[playerid][pCanManageFaction] = cache_get_field_content_int(0, "pCanManageFaction");
	pData[playerid][pBadge] = cache_get_field_content_int(0, "pBadge");
	pData[playerid][pWearsBadge] = cache_get_field_content_int(0, "pWearsBadge");
	pData[playerid][pPosX] = cache_get_field_content_float(0, "pPosX");
	pData[playerid][pPosY] = cache_get_field_content_float(0, "pPosY");
	pData[playerid][pPosZ] = cache_get_field_content_float(0, "pPosZ");
	pData[playerid][pPosA] = cache_get_field_content_float(0, "pPosA");

	gPlayerLogged[playerid] = 1;
    GivePlayerMoney(playerid, pData[playerid][pMoney]);
    SpawnPlayer(playerid);
    return 1;
}
I Login the game and Load charachters and write error:

Код:
[12:48:23] EID:1065 >> ERRMSG: Query was empty >> ERRCLBK: OnAccountLoad >> ERRQRY:
What's the problem?
Reply
#2

Show us where you call the query (mysql_tquery, mysql_pquery or mysql_function_query)
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)