14.05.2015, 01:45
I have no clue whats going on but this is the problem:
I could not have described it better myself. I tried changing it to this:
but some indices especially toward the bottom of the list here do not get updated into the database. Anyone have any thoughts?
The database is an actual DB file in the scriptfiles. not actually hosted could this be why it's not working properly?
Quote:
|
Originally Posted by MCZOFT
 my server doesnt save all the information in the database (acounts.db)
he Saves the database till the Arrest " PHP код:
PHP код:
PHP код:
PHP код:
|
PHP код:
stock OnPlayerSave(playerid)
{
if (IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
if (gPlayerLogged[playerid] != 0 && gPlayerSpawned[playerid] == 1)
{
new playername[24];
GetPlayerName(playerid, playername, sizeof(playername));
if (SQL_AccountExists(playername))
{
if(gmx == 0)
{
GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
GetPlayerArmour(playerid, PlayerInfo[playerid][pArmor]);
}
PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
PlayerInfo[playerid][pVirtualWorld] = GetPlayerVirtualWorld(playerid);
GetPlayerPos(playerid, PlayerInfo[playerid][pSPos_x], PlayerInfo[playerid][pSPos_y], PlayerInfo[playerid][pSPos_z]);
GetPlayerFacingAngle(playerid, PlayerInfo[playerid][pSPos_r]);
new index = SQL_PrepareUpdate(playername);
if (index != -1)
{
SQL_UpdateString(index, "Username", playername);
SQL_UpdateString(index, "Password", PlayerInfo[playerid][pKey]);
SQL_UpdateInt(index, "Level",PlayerInfo[playerid][pLevel]);
SQL_UpdateInt(index, "AdminLevel",PlayerInfo[playerid][pAdmin]);
SQL_UpdateInt(index, "Band",PlayerInfo[playerid][pBand]);
SQL_UpdateInt(index, "PermBand",PlayerInfo[playerid][pPermBand]);
SQL_UpdateInt(index, "Warnings",PlayerInfo[playerid][pWarns]);
SQL_UpdateInt(index, "TruckerCooldown",PlayerInfo[playerid][pTruckerCooldown]);
SQL_UpdateInt(index, "Disabled",PlayerInfo[playerid][pDisabled]);
SQL_UpdateInt(index, "DonateRank",PlayerInfo[playerid][pDonateRank]);
SQL_UpdateInt(index, "FactionBanned",PlayerInfo[playerid][pFactionBanned]);
SQL_UpdateInt(index, "LaserOwner",PlayerInfo[playerid][pLaserOwner]);
SQL_UpdateInt(index, "FCard",PlayerInfo[playerid][pFcard]);
SQL_UpdateInt(index, "Inbuilding",PlayerInfo[playerid][Inbuilding]);
SQL_UpdateInt(index, "BanAppealer",PlayerInfo[playerid][pBanAppealer]);
SQL_UpdateInt(index, "GangMod",PlayerInfo[playerid][pGangMod]);
SQL_UpdateInt(index, "buildingInterior", PlayerInfo[playerid][buildingInterior]);
SQL_UpdateInt(index, "buildingExterior", PlayerInfo[playerid][buildingExterior]);
SQL_UpdateFloat(index, "cExtX", PlayerInfo[playerid][cExtX]);
SQL_UpdateFloat(index, "cExtY", PlayerInfo[playerid][cExtY]);
SQL_UpdateFloat(index, "cExtZ", PlayerInfo[playerid][cExtZ]);
SQL_UpdateFloat(index, "cIntX", PlayerInfo[playerid][cIntX]);
SQL_UpdateFloat(index, "cIntY", PlayerInfo[playerid][cIntY]);
SQL_UpdateFloat(index, "cIntZ", PlayerInfo[playerid][cIntZ]);
SQL_UpdateInt(index, "FactionMod",PlayerInfo[playerid][pFactionMod]);
SQL_UpdateInt(index, "UpgradePoints",PlayerInfo[playerid][gPupgrade]);
SQL_UpdateInt(index, "Inmotel",PlayerInfo[playerid][Inmotel]);
SQL_UpdateInt(index, "motelInterior", PlayerInfo[playerid][motelInterior]);
SQL_UpdateInt(index, "motelExterior", PlayerInfo[playerid][motelExterior]);
SQL_UpdateFloat(index, "mExtX", PlayerInfo[playerid][mExtX]);
SQL_UpdateFloat(index, "mExtY", PlayerInfo[playerid][mExtY]);
SQL_UpdateFloat(index, "mExtZ", PlayerInfo[playerid][mExtZ]);
SQL_UpdateFloat(index, "mIntX", PlayerInfo[playerid][mIntX]);
SQL_UpdateFloat(index, "mIntY", PlayerInfo[playerid][mIntY]);
SQL_UpdateFloat(index, "mIntZ", PlayerInfo[playerid][mIntZ]);
SQL_UpdateInt(index, "ConnectedTime",PlayerInfo[playerid][pConnectTime]);
SQL_UpdateFloat(index, "dExtX", PlayerInfo[playerid][dExtX]);
SQL_UpdateFloat(index, "dExtY", PlayerInfo[playerid][dExtY]);
SQL_UpdateFloat(index, "dExtZ", PlayerInfo[playerid][dExtZ]);
SQL_UpdateFloat(index, "dAngle", PlayerInfo[playerid][dAngle]);
SQL_UpdateInt(index, "Registered",PlayerInfo[playerid][pReg]);
SQL_UpdateInt(index, "Sex",PlayerInfo[playerid][pSex]);
SQL_UpdateInt(index, "Developer",PlayerInfo[playerid][pDeveloper]);
SQL_UpdateInt(index, "Mapper",PlayerInfo[playerid][pMapper]);
SQL_UpdateInt(index, "Division",PlayerInfo[playerid][pDivision]);
SQL_UpdateInt(index, "Tester",PlayerInfo[playerid][pTester]);
SQL_UpdateInt(index, "Age",PlayerInfo[playerid][pAge]);
SQL_UpdateInt(index, "RPBoost",PlayerInfo[playerid][pRPBoost]);
SQL_UpdateInt(index, "Origin",PlayerInfo[playerid][pOrigin]);
SQL_UpdateInt(index, "ATMcard",PlayerInfo[playerid][pATMcard]);
SQL_UpdateInt(index, "GreenCard",PlayerInfo[playerid][pGreenCard]);
SQL_UpdateInt(index, "SocialNumber",PlayerInfo[playerid][pSocialNumber]);
SQL_UpdateInt(index, "Muted",PlayerInfo[playerid][pMuted]);
SQL_UpdateInt(index, "Respect",PlayerInfo[playerid][pExp]);
SQL_UpdateInt(index, "Money",PlayerInfo[playerid][pCash]);
SQL_UpdateInt(index, "ATMExterior", PlayerInfo[playerid][ATMExterior]);
SQL_UpdateInt(index, "MAPBExterior", PlayerInfo[playerid][MAPBExterior]);
SQL_UpdateInt(index, "GSTATIONExterior", PlayerInfo[playerid][GSTATIONExterior]);
SQL_UpdateInt(index, "HSSignExterior", PlayerInfo[playerid][HSSignExterior]);
SQL_UpdateInt(index, "CasinoWinnings",PlayerInfo[playerid][pCasinoWinnings]);
SQL_UpdateInt(index, "Bank",PlayerInfo[playerid][pAccount]);
SQL_UpdateInt(index, "Crimes",PlayerInfo[playerid][pCrimes]);
SQL_UpdateString(index, "Accent",Accent[playerid]);
SQL_UpdateInt(index, "ATMID",PlayerInfo[playerid][ATMID]);
SQL_UpdateInt(index, "Kills",PlayerInfo[playerid][pKills]);
SQL_UpdateInt(index, "Deaths",PlayerInfo[playerid][pDeaths]);
SQL_UpdateInt(index, "TrashSkill",PlayerInfo[playerid][pTrashSkill]); // Trashman
SQL_UpdateInt(index, "CHits",PlayerInfo[playerid][pCHits]);
SQL_UpdateInt(index, "BriefCase",PlayerInfo[playerid][pBriefCase]);
SQL_UpdateInt(index, "BCash",PlayerInfo[playerid][pBCash]);
SQL_UpdateInt(index, "BCrack",PlayerInfo[playerid][pBCrack]);
SQL_UpdateInt(index, "BPot",PlayerInfo[playerid][pBPot]);
SQL_UpdateInt(index, "FHits",PlayerInfo[playerid][pFHits]);
SQL_UpdateInt(index, "Arrested",PlayerInfo[playerid][pArrested]);
SQL_UpdateInt(index, "Job",PlayerInfo[playerid][pJob]);
SQL_UpdateInt(index, "Job2",PlayerInfo[playerid][pJob2]);
SQL_UpdateFloat(index, "SPos_x",PlayerInfo[playerid][pSPos_x]);
SQL_UpdateFloat(index, "SPos_y",PlayerInfo[playerid][pSPos_y]);
SQL_UpdateFloat(index, "SPos_z",PlayerInfo[playerid][pSPos_z]);
SQL_UpdateFloat(index, "SPos_r",PlayerInfo[playerid][pSPos_r]);
SQL_Update(index);
new index1 = SQL_PrepareUpdate(playername);
SQL_UpdateInt(index1, "PlayerVehicleModel1",PlayerInfo[playerid][PlayerVehicleModel1]);
SQL_UpdateFloat(index1, "PlayerVehicleFacing1",PlayerInfo[playerid][PlayerVehicleFacing1]);
SQL_UpdateInt(index1, "PlayerVehicle1Color",PlayerInfo[playerid][pPlayerVehicle1Color]);
SQL_UpdateInt(index1, "PlayerVehicle1Color2",PlayerInfo[playerid][pPlayerVehicle1Color2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosX1",PlayerInfo[playerid][PlayerVehiclePosX1]);
SQL_UpdateFloat(index1, "PlayerVehiclePosY1",PlayerInfo[playerid][PlayerVehiclePosY1]);
SQL_UpdateFloat(index1, "PlayerVehiclePosZ1",PlayerInfo[playerid][PlayerVehiclePosZ1]);
SQL_UpdateInt(index1, "PlayerVehicle1PaintJob",PlayerInfo[playerid][PlayerVehicle1PaintJob]);
SQL_UpdateInt(index1, "PlayerVehicle1Nos",PlayerInfo[playerid][PlayerVehicle1Nos]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot0",PlayerInfo[playerid][PlayerVehicle1ModSlot0]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot1",PlayerInfo[playerid][PlayerVehicle1ModSlot1]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot2",PlayerInfo[playerid][PlayerVehicle1ModSlot2]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot3",PlayerInfo[playerid][PlayerVehicle1ModSlot3]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot4",PlayerInfo[playerid][PlayerVehicle1ModSlot4]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot5",PlayerInfo[playerid][PlayerVehicle1ModSlot5]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot6",PlayerInfo[playerid][PlayerVehicle1ModSlot6]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot7",PlayerInfo[playerid][PlayerVehicle1ModSlot7]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot8",PlayerInfo[playerid][PlayerVehicle1ModSlot8]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot9",PlayerInfo[playerid][PlayerVehicle1ModSlot9]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot10",PlayerInfo[playerid][PlayerVehicle1ModSlot10]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot11",PlayerInfo[playerid][PlayerVehicle1ModSlot11]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot12",PlayerInfo[playerid][PlayerVehicle1ModSlot12]);
SQL_UpdateInt(index1, "PlayerVehicle1ModSlot13",PlayerInfo[playerid][PlayerVehicle1ModSlot13]);
SQL_UpdateInt(index1, "VehLock1",PlayerInfo[playerid][pVehLock1]);
SQL_UpdateInt(index1, "VehLocked1",PlayerInfo[playerid][pVehLocked1]);
SQL_UpdateInt(index1, "PlayerVehicle1Interior",PlayerInfo[playerid][PlayerVehicle1Interior]);
SQL_UpdateInt(index1, "PlayerVehicle1VirWorld",PlayerInfo[playerid][PlayerVehicle1VirWorld]);
SQL_UpdateInt(index1, "PlayerVehicleModel2",PlayerInfo[playerid][PlayerVehicleModel2]);
SQL_UpdateFloat(index1, "PlayerVehicleFacing2",PlayerInfo[playerid][PlayerVehicleFacing2]);
SQL_UpdateInt(index1, "PlayerVehicle2Color",PlayerInfo[playerid][pPlayerVehicle2Color]);
SQL_UpdateInt(index1, "PlayerVehicle2Color2",PlayerInfo[playerid][pPlayerVehicle2Color2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosX2",PlayerInfo[playerid][PlayerVehiclePosX2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosY2",PlayerInfo[playerid][PlayerVehiclePosY2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosZ2",PlayerInfo[playerid][PlayerVehiclePosZ2]);
SQL_UpdateInt(index1, "PlayerVehicle2PaintJob",PlayerInfo[playerid][PlayerVehicle2PaintJob]);
SQL_UpdateInt(index1, "PlayerVehicle2Nos",PlayerInfo[playerid][PlayerVehicle2Nos]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot0",PlayerInfo[playerid][PlayerVehicle2ModSlot0]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot1",PlayerInfo[playerid][PlayerVehicle2ModSlot1]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot2",PlayerInfo[playerid][PlayerVehicle2ModSlot2]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot3",PlayerInfo[playerid][PlayerVehicle2ModSlot3]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot4",PlayerInfo[playerid][PlayerVehicle2ModSlot4]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot5",PlayerInfo[playerid][PlayerVehicle2ModSlot5]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot6",PlayerInfo[playerid][PlayerVehicle2ModSlot6]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot7",PlayerInfo[playerid][PlayerVehicle2ModSlot7]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot8",PlayerInfo[playerid][PlayerVehicle2ModSlot8]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot9",PlayerInfo[playerid][PlayerVehicle2ModSlot9]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot10",PlayerInfo[playerid][PlayerVehicle2ModSlot10]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot11",PlayerInfo[playerid][PlayerVehicle2ModSlot11]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot12",PlayerInfo[playerid][PlayerVehicle2ModSlot12]);
SQL_UpdateInt(index1, "PlayerVehicle2ModSlot13",PlayerInfo[playerid][PlayerVehicle2ModSlot13]);
SQL_UpdateInt(index1, "VehLock2",PlayerInfo[playerid][pVehLock2]);
SQL_UpdateInt(index1, "VehLocked2",PlayerInfo[playerid][pVehLocked2]);
SQL_UpdateInt(index1, "PlayerVehicle2Interior",PlayerInfo[playerid][PlayerVehicle2Interior]);
SQL_UpdateInt(index1, "PlayerVehicle2VirWorld",PlayerInfo[playerid][PlayerVehicle2VirWorld]);
SQL_UpdateInt(index1, "PlayerVehicleModel3",PlayerInfo[playerid][PlayerVehicleModel3]);
SQL_UpdateFloat(index1, "PlayerVehicleFacing3",PlayerInfo[playerid][PlayerVehicleFacing3]);
SQL_UpdateInt(index1, "PlayerVehicle3Color",PlayerInfo[playerid][pPlayerVehicle3Color]);
SQL_UpdateInt(index1, "PlayerVehicle3Color2",PlayerInfo[playerid][pPlayerVehicle3Color2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosX3",PlayerInfo[playerid][PlayerVehiclePosX3]);
SQL_UpdateFloat(index1, "PlayerVehiclePosY3",PlayerInfo[playerid][PlayerVehiclePosY3]);
SQL_UpdateFloat(index1, "PlayerVehiclePosZ3",PlayerInfo[playerid][PlayerVehiclePosZ3]);
SQL_UpdateInt(index1, "PlayerVehicle3PaintJob",PlayerInfo[playerid][PlayerVehicle3PaintJob]);
SQL_UpdateInt(index1, "PlayerVehicle3Nos",PlayerInfo[playerid][PlayerVehicle3Nos]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot0",PlayerInfo[playerid][PlayerVehicle3ModSlot0]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot1",PlayerInfo[playerid][PlayerVehicle3ModSlot1]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot2",PlayerInfo[playerid][PlayerVehicle3ModSlot2]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot3",PlayerInfo[playerid][PlayerVehicle3ModSlot3]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot4",PlayerInfo[playerid][PlayerVehicle3ModSlot4]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot5",PlayerInfo[playerid][PlayerVehicle3ModSlot5]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot6",PlayerInfo[playerid][PlayerVehicle3ModSlot6]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot7",PlayerInfo[playerid][PlayerVehicle3ModSlot7]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot8",PlayerInfo[playerid][PlayerVehicle3ModSlot8]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot9",PlayerInfo[playerid][PlayerVehicle3ModSlot9]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot10",PlayerInfo[playerid][PlayerVehicle3ModSlot10]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot11",PlayerInfo[playerid][PlayerVehicle3ModSlot11]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot12",PlayerInfo[playerid][PlayerVehicle3ModSlot12]);
SQL_UpdateInt(index1, "PlayerVehicle3ModSlot13",PlayerInfo[playerid][PlayerVehicle3ModSlot13]);
SQL_UpdateInt(index1, "VehLock3",PlayerInfo[playerid][pVehLock3]);
SQL_UpdateInt(index1, "VehLocked3",PlayerInfo[playerid][pVehLocked3]);
SQL_UpdateInt(index1, "PlayerVehicle3Interior",PlayerInfo[playerid][PlayerVehicle3Interior]);
SQL_UpdateInt(index1, "PlayerVehicle3VirWorld",PlayerInfo[playerid][PlayerVehicle3VirWorld]);
SQL_UpdateInt(index1, "PlayerVehicleModel4",PlayerInfo[playerid][PlayerVehicleModel4]);
SQL_UpdateFloat(index1, "PlayerVehicleFacing4",PlayerInfo[playerid][PlayerVehicleFacing4]);
SQL_UpdateInt(index1, "PlayerVehicle4Color",PlayerInfo[playerid][pPlayerVehicle4Color]);
SQL_UpdateInt(index1, "PlayerVehicle4Color2",PlayerInfo[playerid][pPlayerVehicle4Color2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosX4",PlayerInfo[playerid][PlayerVehiclePosX4]);
SQL_UpdateFloat(index1, "PlayerVehiclePosY4",PlayerInfo[playerid][PlayerVehiclePosY4]);
SQL_UpdateFloat(index1, "PlayerVehiclePosZ4",PlayerInfo[playerid][PlayerVehiclePosZ4]);
SQL_UpdateInt(index1, "PlayerVehicle4PaintJob",PlayerInfo[playerid][PlayerVehicle4PaintJob]);
SQL_UpdateInt(index1, "PlayerVehicle4Nos",PlayerInfo[playerid][PlayerVehicle4Nos]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot0",PlayerInfo[playerid][PlayerVehicle4ModSlot0]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot1",PlayerInfo[playerid][PlayerVehicle4ModSlot1]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot2",PlayerInfo[playerid][PlayerVehicle4ModSlot2]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot3",PlayerInfo[playerid][PlayerVehicle4ModSlot3]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot4",PlayerInfo[playerid][PlayerVehicle4ModSlot4]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot5",PlayerInfo[playerid][PlayerVehicle4ModSlot5]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot6",PlayerInfo[playerid][PlayerVehicle4ModSlot6]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot7",PlayerInfo[playerid][PlayerVehicle4ModSlot7]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot8",PlayerInfo[playerid][PlayerVehicle4ModSlot8]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot9",PlayerInfo[playerid][PlayerVehicle4ModSlot9]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot10",PlayerInfo[playerid][PlayerVehicle4ModSlot10]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot11",PlayerInfo[playerid][PlayerVehicle4ModSlot11]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot12",PlayerInfo[playerid][PlayerVehicle4ModSlot12]);
SQL_UpdateInt(index1, "PlayerVehicle4ModSlot13",PlayerInfo[playerid][PlayerVehicle4ModSlot13]);
SQL_UpdateInt(index1, "VehLock4",PlayerInfo[playerid][pVehLock4]);
SQL_UpdateInt(index1, "VehLocked4",PlayerInfo[playerid][pVehLocked4]);
SQL_UpdateInt(index1, "PlayerVehicle4Interior",PlayerInfo[playerid][PlayerVehicle4Interior]);
SQL_UpdateInt(index1, "PlayerVehicle4VirWorld",PlayerInfo[playerid][PlayerVehicle4VirWorld]);
SQL_UpdateInt(index1, "PlayerVehicleModel5",PlayerInfo[playerid][PlayerVehicleModel5]);
SQL_UpdateFloat(index1, "PlayerVehicleFacing5",PlayerInfo[playerid][PlayerVehicleFacing5]);
SQL_UpdateInt(index1, "PlayerVehicle5Color",PlayerInfo[playerid][pPlayerVehicle5Color]);
SQL_UpdateInt(index1, "PlayerVehicle5Color2",PlayerInfo[playerid][pPlayerVehicle5Color2]);
SQL_UpdateFloat(index1, "PlayerVehiclePosX5",PlayerInfo[playerid][PlayerVehiclePosX5]);
SQL_UpdateFloat(index1, "PlayerVehiclePosY5",PlayerInfo[playerid][PlayerVehiclePosY5]);
SQL_UpdateFloat(index1, "PlayerVehiclePosZ5",PlayerInfo[playerid][PlayerVehiclePosZ5]);
SQL_UpdateInt(index1, "PlayerVehicle5PaintJob",PlayerInfo[playerid][PlayerVehicle5PaintJob]);
SQL_UpdateInt(index1, "PlayerVehicle5Nos",PlayerInfo[playerid][PlayerVehicle5Nos]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot0",PlayerInfo[playerid][PlayerVehicle5ModSlot0]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot1",PlayerInfo[playerid][PlayerVehicle5ModSlot1]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot2",PlayerInfo[playerid][PlayerVehicle5ModSlot2]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot3",PlayerInfo[playerid][PlayerVehicle5ModSlot3]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot4",PlayerInfo[playerid][PlayerVehicle5ModSlot4]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot5",PlayerInfo[playerid][PlayerVehicle5ModSlot5]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot6",PlayerInfo[playerid][PlayerVehicle5ModSlot6]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot7",PlayerInfo[playerid][PlayerVehicle5ModSlot7]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot8",PlayerInfo[playerid][PlayerVehicle5ModSlot8]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot9",PlayerInfo[playerid][PlayerVehicle5ModSlot9]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot10",PlayerInfo[playerid][PlayerVehicle5ModSlot10]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot11",PlayerInfo[playerid][PlayerVehicle5ModSlot11]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot12",PlayerInfo[playerid][PlayerVehicle5ModSlot12]);
SQL_UpdateInt(index1, "PlayerVehicle5ModSlot13",PlayerInfo[playerid][PlayerVehicle5ModSlot13]);
SQL_UpdateInt(index1, "VehLock5",PlayerInfo[playerid][pVehLock5]);
SQL_UpdateInt(index1, "VehLocked5",PlayerInfo[playerid][pVehLocked5]);
SQL_UpdateInt(index1, "PlayerVehicle5Interior",PlayerInfo[playerid][PlayerVehicle5Interior]);
SQL_UpdateInt(index1, "PlayerVehicle5VirWorld",PlayerInfo[playerid][PlayerVehicle5VirWorld]);
SQL_UpdateInt(index1, "CarTime",PlayerInfo[playerid][pCarTime]);
SQL_UpdateInt(index1, "Phonebook",PlayerInfo[playerid][pPhoneBook]);
SQL_UpdateInt(index1, "HouseTicket",PlayerInfo[playerid][pHouseTicket]);
SQL_UpdateInt(index1, "BusinessTicket",PlayerInfo[playerid][pBusinessTicket]);
SQL_UpdateInt(index1, "VehicleTicket",PlayerInfo[playerid][pVehicleTicket]);
SQL_UpdateInt(index1, "GateTicket",PlayerInfo[playerid][pGateTicket]);
SQL_UpdateInt(index1, "GarageTicket",PlayerInfo[playerid][pGarageTicket]);
SQL_UpdateInt(index1, "BoomBox",PlayerInfo[playerid][pBoomBox]);
SQL_UpdateInt(index1, "LottoNr",PlayerInfo[playerid][pLottoNr]);
SQL_UpdateInt(index1, "Fishes",PlayerInfo[playerid][pFishes]);
SQL_UpdateInt(index1, "BiggestFish",PlayerInfo[playerid][pBiggestFish]);
//job
SQL_UpdateInt(index1, "Paycheck",PlayerInfo[playerid][pPayCheck]);
SQL_UpdateInt(index1, "HeadValue",PlayerInfo[playerid][pHeadValue]);
SQL_UpdateInt(index1, "BHHeadValue",PlayerInfo[playerid][pBHHeadValue]);
SQL_UpdateInt(index1, "Jailed",PlayerInfo[playerid][pJailed]);
SQL_Update(index1);
new index2 = SQL_PrepareUpdate(playername);
SQL_UpdateString(index2, "JailedReason",PlayerInfo[playerid][pJailedReason]);
SQL_UpdateInt(index2, "JailTime",PlayerInfo[playerid][pJailTime]);
SQL_UpdateInt(index2, "Gun parts",PlayerInfo[playerid][pMats]);
SQL_UpdateInt(index2, "Pot",PlayerInfo[playerid][pPot]);
SQL_UpdateInt(index2, "Bong",PlayerInfo[playerid][pBong]);
SQL_UpdateInt(index2, "Pipe",PlayerInfo[playerid][pPipe]);
SQL_UpdateInt(index2, "Paper",PlayerInfo[playerid][pPaper]);
SQL_UpdateInt(index2, "Crack",PlayerInfo[playerid][pCrack]);
SQL_UpdateInt(index2, "Leader",PlayerInfo[playerid][pLeader]);
SQL_UpdateInt(index2, "Member",PlayerInfo[playerid][pMember]);
SQL_UpdateInt(index2, "FMember",PlayerInfo[playerid][pFMember]);
SQL_UpdateInt(index2, "Rank",PlayerInfo[playerid][pRank]);
SQL_UpdateInt(index2, "DetSkill",PlayerInfo[playerid][pDetSkill]);
SQL_UpdateInt(index2, "SexSkill",PlayerInfo[playerid][pSexSkill]);
SQL_UpdateInt(index2, "BoxSkill",PlayerInfo[playerid][pBoxSkill]);
SQL_UpdateInt(index2, "LawSkill",PlayerInfo[playerid][pLawSkill]);
SQL_UpdateInt(index2, "MechSkill",PlayerInfo[playerid][pMechSkill]);
SQL_UpdateInt(index2, "JackSkill",PlayerInfo[playerid][pJackSkill]);
SQL_UpdateInt(index2, "CarSkill",PlayerInfo[playerid][pCarSkill]);
SQL_UpdateInt(index2, "NewsSkill",PlayerInfo[playerid][pNewsSkill]);
SQL_UpdateInt(index2, "DrugsSkill",PlayerInfo[playerid][pDrugsSkill]);
SQL_UpdateInt(index2, "ArmsSkill",PlayerInfo[playerid][pArmsSkill]);
SQL_UpdateInt(index2, "House",PlayerInfo[playerid][pPhousekey]);
SQL_UpdateInt(index2, "InGarage",PlayerInfo[playerid][InGarage]);
SQL_UpdateInt(index2, "HouseExterior", PlayerInfo[playerid][HouseInterior]);
SQL_UpdateInt(index2, "HouseInterior", PlayerInfo[playerid][HouseInterior]);
SQL_UpdateFloat(index2, "hExtX", PlayerInfo[playerid][hExtX]);
SQL_UpdateFloat(index2, "hExtY", PlayerInfo[playerid][hExtY]);
SQL_UpdateFloat(index2, "hExtZ", PlayerInfo[playerid][hExtZ]);
SQL_UpdateFloat(index2, "hIntX", PlayerInfo[playerid][hIntX]);
SQL_UpdateFloat(index2, "hIntY", PlayerInfo[playerid][hIntY]);
SQL_UpdateFloat(index2, "hIntZ", PlayerInfo[playerid][hIntZ]);
SQL_UpdateInt(index2, "SmugglerSkill",PlayerInfo[playerid][pSmugglerSkill]);
SQL_UpdateInt(index2, "FishSkill",PlayerInfo[playerid][pFishSkill]);
SQL_UpdateInt(index2, "FightingStyle",PlayerInfo[playerid][pFightingStyle]);
SQL_UpdateFloat(index2, "pHealth",PlayerInfo[playerid][pHealth]);
SQL_UpdateFloat(index2, "pArmor",PlayerInfo[playerid][pArmor]);
SQL_UpdateInt(index2, "pSHealth",PlayerInfo[playerid][pSHealth]);
SQL_UpdateInt(index2, "Int",PlayerInfo[playerid][pInt]);
SQL_UpdateInt(index2, "Local",PlayerInfo[playerid][pLocal]);
SQL_UpdateInt(index2, "VirtualWorld",PlayerInfo[playerid][pVirtualWorld]);
SQL_UpdateInt(index2, "Model",PlayerInfo[playerid][pModel]);
SQL_UpdateInt(index2, "Tikis",PlayerInfo[playerid][pTikis]);
SQL_UpdateInt(index2, "Clothes",PlayerInfo[playerid][pClothes]);
SQL_UpdateInt(index2, "PhoneNr",PlayerInfo[playerid][pPnumber]);
SQL_UpdateInt(index2, "Apartment",PlayerInfo[playerid][pPaptkey]);
SQL_UpdateInt(index2, "CarLic",PlayerInfo[playerid][pCarLic]);
SQL_UpdateInt(index2, "FlyLic",PlayerInfo[playerid][pFlyLic]);
SQL_UpdateInt(index2, "BoatLic",PlayerInfo[playerid][pBoatLic]);
SQL_UpdateInt(index2, "FishLic",PlayerInfo[playerid][pFishLic]);
SQL_UpdateInt(index2, "GunLic",PlayerInfo[playerid][pGunLic]);
SQL_UpdateInt(index2, "Gun0",PlayerInfo[playerid][pGun0]);
SQL_UpdateInt(index2, "Gun1",PlayerInfo[playerid][pGun1]);
SQL_UpdateInt(index2, "Gun2",PlayerInfo[playerid][pGun2]);
SQL_UpdateInt(index2, "Gun3",PlayerInfo[playerid][pGun3]);
SQL_UpdateInt(index2, "InBusiness",PlayerInfo[playerid][InBusiness]);
SQL_UpdateInt(index2, "BusinessInterior", PlayerInfo[playerid][BusinessInterior]);
SQL_UpdateInt(index2, "BusinessExterior", PlayerInfo[playerid][BusinessExterior]);
SQL_UpdateInt(index2, "Bizz",PlayerInfo[playerid][pPbiskey]);
SQL_UpdateInt(index2, "Garage",PlayerInfo[playerid][pGarageKey]);
SQL_UpdateInt(index2, "GarageII",PlayerInfo[playerid][pGarageKey2]);
SQL_UpdateInt(index2, "House",PlayerInfo[playerid][pHouseKey]);
SQL_UpdateInt(index2, "HouseII",PlayerInfo[playerid][pHouseKey2]);
SQL_UpdateInt(index2, "HouseIII",PlayerInfo[playerid][pHouseKey3]);
SQL_UpdateInt(index2, "HouseIIII",PlayerInfo[playerid][pHouseKey4]);
SQL_UpdateInt(index2, "GateKey",PlayerInfo[playerid][pGateKey]);
SQL_UpdateInt(index2, "GateKeyIA",PlayerInfo[playerid][pGateKey2]);
SQL_UpdateInt(index2, "GateKeyIB",PlayerInfo[playerid][pGateKey3]);
SQL_UpdateInt(index2, "GateKeyIC",PlayerInfo[playerid][pGateKey4]);
SQL_UpdateInt(index2, "GateKeyID",PlayerInfo[playerid][pGateKey5]);
SQL_UpdateInt(index2, "GateKeyIE",PlayerInfo[playerid][pGateKey6]);
SQL_UpdateInt(index2, "GateKeyIF",PlayerInfo[playerid][pGateKey7]);
SQL_UpdateInt(index2, "GateKeyIG",PlayerInfo[playerid][pGateKey8]);
SQL_UpdateInt(index2, "GateKeyIH",PlayerInfo[playerid][pGateKey9]);
SQL_UpdateInt(index2, "GateKeyII",PlayerInfo[playerid][pGateKey10]);
SQL_UpdateFloat(index2, "bExtX", PlayerInfo[playerid][bExtX]);
SQL_UpdateFloat(index2, "bExtY", PlayerInfo[playerid][bExtY]);
SQL_UpdateFloat(index2, "bExtZ", PlayerInfo[playerid][bExtZ]);
SQL_UpdateFloat(index2, "bIntX", PlayerInfo[playerid][bIntX]);
SQL_UpdateFloat(index2, "bIntY", PlayerInfo[playerid][bIntY]);
SQL_UpdateFloat(index2, "bIntZ", PlayerInfo[playerid][bIntZ]);
SQL_UpdateInt(index2, "Gun4",PlayerInfo[playerid][pGun4]);
SQL_UpdateInt(index2, "Gun5",PlayerInfo[playerid][pGun5]);
SQL_UpdateInt(index2, "Gun6",PlayerInfo[playerid][pGun6]);
SQL_UpdateInt(index2, "Gun7",PlayerInfo[playerid][pGun7]);
SQL_UpdateInt(index2, "Gun8",PlayerInfo[playerid][pGun8]);
SQL_UpdateInt(index2, "Gun9",PlayerInfo[playerid][pGun9]);
SQL_UpdateInt(index2, "Gun10",PlayerInfo[playerid][pGun10]);
SQL_UpdateInt(index2, "Gun11",PlayerInfo[playerid][pGun11]);
SQL_UpdateInt(index2, "Gun12",PlayerInfo[playerid][pGun12]);
SQL_UpdateInt(index2, "CarTime",PlayerInfo[playerid][pCarTime]);
SQL_UpdateInt(index2, "DrugsTime",PlayerInfo[playerid][pDrugsTime]);
SQL_UpdateInt(index2, "LawyerTime",PlayerInfo[playerid][pLawyerTime]);
SQL_UpdateInt(index2, "LawyerFreeTime",PlayerInfo[playerid][pLawyerFreeTime]);
SQL_UpdateInt(index2, "MechTime",PlayerInfo[playerid][pMechTime]);
SQL_UpdateInt(index2, "SexTime",PlayerInfo[playerid][pSexTime]);
SQL_UpdateInt(index2, "PayDay",PlayerInfo[playerid][pPayDay]);
SQL_UpdateInt(index2, "PayDayHad",PlayerInfo[playerid][pPayDayHad]);
SQL_UpdateInt(index2, "Check",PlayerInfo[playerid][pCheck]);
SQL_UpdateInt(index2, "CDPlayer",PlayerInfo[playerid][pCDPlayer]);
SQL_UpdateInt(index2, "Dice",PlayerInfo[playerid][pDice]);
SQL_UpdateInt(index2, "Screw",PlayerInfo[playerid][pScrew]);
SQL_UpdateInt(index2, "Rope",PlayerInfo[playerid][pRope]);
SQL_UpdateInt(index2, "AKmagazine",PlayerInfo[playerid][pAKmagazine]);
SQL_UpdateInt(index2, "CSGmagazine",PlayerInfo[playerid][pCSGmagazine]);
SQL_UpdateInt(index2, "Demagazine",PlayerInfo[playerid][pDemagazine]);
SQL_UpdateInt(index2, "Cigars",PlayerInfo[playerid][pCigars]);
SQL_UpdateInt(index2, "GoldBars",PlayerInfo[playerid][pGoldBars]);
SQL_UpdateInt(index2, "Sprunk",PlayerInfo[playerid][pSprunk]);
SQL_UpdateInt(index2, "WT",PlayerInfo[playerid][pWT]);
SQL_UpdateInt(index2, "WTc",PlayerInfo[playerid][pWTc]);
SQL_UpdateInt(index2, "Bombs",PlayerInfo[playerid][pBombs]);
SQL_UpdateInt(index2, "Scope",PlayerInfo[playerid][pScope]);
SQL_UpdateInt(index2, "OwnsMask",PlayerInfo[playerid][pOwnsMask]);
SQL_UpdateInt(index2, "Wins",PlayerInfo[playerid][pWins]);
SQL_UpdateInt(index2, "Loses",PlayerInfo[playerid][pLoses]);
SQL_UpdateInt(index2, "Tutorial",PlayerInfo[playerid][pTut]);
SQL_UpdateInt(index2, "OnDuty",PlayerInfo[playerid][pOnDuty]);
SQL_UpdateInt(index2, "Hospital",PlayerInfo[playerid][pHospital]);
SQL_UpdateInt(index2, "Adjustable",PlayerInfo[playerid][pAdjustable]);
SQL_UpdateInt(index2, "Married",PlayerInfo[playerid][pMarried]);
SQL_UpdateString(index2, "MarriedTo",PlayerInfo[playerid][pMarriedTo]);
SQL_UpdateString(index2, "NormalName",PlayerInfo[playerid][pNormalName]);
SQL_UpdateString(index2, "AdminName",PlayerInfo[playerid][pAdminName]);
SQL_UpdateString(index2, "HelperName",PlayerInfo[playerid][pHelperName]);
SQL_UpdateInt(index2, "AdminDuty",PlayerInfo[playerid][pAdminDuty]);
SQL_UpdateString(index2, "ContractBy",PlayerInfo[playerid][pContractBy]);
SQL_UpdateString(index2, "IP",PlayerInfo[playerid][pIP]);
SQL_UpdateInt(index2, "WantedLevel",PlayerInfo[playerid][pWantedLevel]);
SQL_UpdateInt(index2, "NewbieMuted",PlayerInfo[playerid][pNewbieMuted]);
SQL_UpdateInt(index2, "RHmuted",PlayerInfo[playerid][prhmuted]);
SQL_UpdateInt(index2, "ReportMuted",PlayerInfo[playerid][pReportMuted]);
SQL_UpdateInt(index2, "AdvertiseMuted",PlayerInfo[playerid][pAdvertiseMuted]);
SQL_UpdateInt(index2, "SafeSpawn",PlayerInfo[playerid][pSafeSpawn]);
//sspos
SQL_UpdateInt(index2, "AidKit",PlayerInfo[playerid][pAidKit]);
SQL_UpdateInt(index2, "HelperLevel",PlayerInfo[playerid][pHelper]);
SQL_UpdateInt(index2, "Mask",HasBoughtMask[playerid]);
SQL_UpdateInt(index2, "Blindfolds",PlayerInfo[playerid][pBlindfolds]);
SQL_UpdateInt(index2, "Speedo",gSpeedo[playerid]);
SQL_UpdateInt(index2, "Seeds",PlayerInfo[playerid][pSeeds]);
SQL_UpdateInt(index2, "Famed", PlayerInfo[playerid][pFamed]);
SQL_Update(index2);
}
else printf("Warning: Could not update '%s'.", PlayerName(playerid));
}
SavePlayerClothing(playerid);
}
}
return 1;
}
The database is an actual DB file in the scriptfiles. not actually hosted could this be why it's not working properly?