Сохранение аккаунта(MySQL).

[Мартин]

Добрый день! Проблемы в том, что некоректно сохраняется аккаунт. После регистрации аккаунт создается в БД, но кроме пароля ничего не сохраняется, а если создать второй аккаунт, то на первом появляется все то, что нужно. Соответственно так же и со вторым, при создание второго аккаунта он пустой, а если создать третий, то на втором появляется все, что должно быть.

Спойлер: Паблик сохранения

stock bool: SaveAccount(const playerid)
{
    if(IsPlayerConnected(playerid))
     {
    new query[2047];
    GetPlayerHealth(playerid, PlayerInfo[playerid][pHealth]);
    PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
    PlayerInfo[playerid][pVirtual] = GetPlayerVirtualWorld(playerid);
    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
    format(query,sizeof (query),"UPDATE `players` SET\
    `Level`=%d,\
    `Admin`=%d,\
    `DonateRank`=%d,\
    `ConnectTime`=%d,\
    `SuppMuteTime`=%d,\
    `ReportMuteTime`=%d,\
    `BMuteTime`=%d,\
    `Reg`=%d,\
    `Sex`=%d,\
    `Age`=%d,\
    `AgeTime`=%d,\
    `TimeAge`=%d,",
    PlayerInfo[playerid][pLevel],
    PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pDonateRank],
    PlayerInfo[playerid][pConnectTime],
    PlayerInfo[playerid][pSuppMuteTime],
    PlayerInfo[playerid][pReportMuteTime],
    PlayerInfo[playerid][pBMuteTime],
    PlayerInfo[playerid][pReg],
    PlayerInfo[playerid][pSex],
    PlayerInfo[playerid][pAge],
    PlayerInfo[playerid][pAgeTime],
    PlayerInfo[playerid][pTimeAge]);
    format(query,sizeof (query),"%s `LivingAt`='%s',\
    `FirstName`='%s',\
    `LastName`='%s',\
    `BornAt`='%s',\
    `Pasport`=%d,\
    `BageNum`=%d,\
    `Tested`=%d,\
    `Exp`=%d,",
    query,
    PlayerInfo[playerid][pLivingAt],
    PlayerInfo[playerid][pFirstName],
    PlayerInfo[playerid][pLastName],
    PlayerInfo[playerid][pBornAt],
    PlayerInfo[playerid][pPasport],
    PlayerInfo[playerid][pBageNum],
    PlayerInfo[playerid][pTested],
    PlayerInfo[playerid][pExp]);
    format(query,sizeof (query),"%s `Cash`=%d,\
    `Account`=%d,\
    `Crimes`=%d,\
    `Wanted`=%d,\
    `Sud`=%d,\
    `Arrested`=%d,\
    `Job`=%d,\
    `AFK`=%d,\
    `HeadValue`=%d,\
    `Jailed`=%d,\
    `JailTime`=%d,\
    `JailPrice`=%d,\
    `AJailed`=%d,\
    `AJailTime`=%d,",
    query,
    PlayerInfo[playerid][pCash],
    PlayerInfo[playerid][pAccount],
    PlayerInfo[playerid][pCrimes],
    PlayerInfo[playerid][pWanted],
    PlayerInfo[playerid][pSud],
    PlayerInfo[playerid][pArrested],
    PlayerInfo[playerid][pJob],
    PlayerInfo[playerid][pAFK],
    PlayerInfo[playerid][pHeadValue],
    PlayerInfo[playerid][pJailed],
    PlayerInfo[playerid][pJailTime],
    PlayerInfo[playerid][pJailPrice],
    PlayerInfo[playerid][pAJailed],
    PlayerInfo[playerid][pAJailTime]);
    format(query,sizeof (query),"%s `Turma`=%d,\
    `Drugs`=%d,\
    `WeedTime`=%d,\
    `WeedStage`=%d,\
    `STD`=%d,\
    `Seed`=%d,",
    query,
    PlayerInfo[playerid][pTurma],
    PlayerInfo[playerid][pDrugs],
    PlayerInfo[playerid][pWeedTime],
    PlayerInfo[playerid][pWeedStage],
    PlayerInfo[playerid][pSTD],
    PlayerInfo[playerid][pSeed]);
    format(query,sizeof (query),"%s `Leader`=%d,\
    `Member`=%d,\
    `Rank`=%d,\
    `RankName`='%s',\
    `FMember`=%d,\
    `FamilyRank`='%s',\
    `FamilyCreate`=%d,\
    `Char`=%d,\
    `Model`=%d,\
    `Model2`=%d,\
    `Model3`=%d,\
    `ContractTime`=%d,\
    `JackSkill`=%d,\
    `CarSkill`=%d,",
    query,
    PlayerInfo[playerid][pLeader],
    PlayerInfo[playerid][pMember],
    PlayerInfo[playerid][pRank],
    PlayerInfo[playerid][pRankName],
    PlayerInfo[playerid][pFMember],
    PlayerInfo[playerid][pFamilyRank],
    PlayerInfo[playerid][pFamilyCreate],
    PlayerInfo[playerid][pChar],
    PlayerInfo[playerid][pModel],
    PlayerInfo[playerid][pModel2],
    PlayerInfo[playerid][pModel3],
    PlayerInfo[playerid][pContractTime],
    PlayerInfo[playerid][pJackSkill],
    PlayerInfo[playerid][pCarSkill]);
    format(query,sizeof (query),"%s `Health`=%.1f,\
    `SHealth`=%.1f,\
    `Int`=%d,\
    `Virtual`=%d,\
    `Local`=%d,\
    `Team`=%d,\
    `Spawn`=%d,\
    `Pnumber`=%d,\
    `Mobile`=%d,",
    query,
    PlayerInfo[playerid][pHealth],
    PlayerInfo[playerid][pSHealth],
    PlayerInfo[playerid][pInt],
    PlayerInfo[playerid][pVirtual],
    PlayerInfo[playerid][pLocal],
    PlayerInfo[playerid][pTeam],
    PlayerInfo[playerid][pSpawn],
    PlayerInfo[playerid][pPnumber],
    PlayerInfo[playerid][pMobile]);
    format(query,sizeof (query),"%s `Phousekey`=%d,\
    `Pbiskey`=%d,\
    `Pos_x`=%.1f,\
    `Pos_y`=%.1f,\
    `Pos_z`=%.1f,",
    query,
    PlayerInfo[playerid][pPhousekey],
    PlayerInfo[playerid][pPbiskey],
    PlayerInfo[playerid][pPos_x],
    PlayerInfo[playerid][pPos_y],
    PlayerInfo[playerid][pPos_z]);
    format(query,sizeof (query),"%s `CarLic`=%d,\
    `TruckLic`=%d,\
    `MotoLic`=%d,\
    `BusLic`=%d,\
    `FlyLic`=%d,\
    `BoatLic`=%d,\
    `FishLic`=%d,\
    `GunLic`=%d,\
    `GunLicAllow`=%d,",
    query,
    PlayerInfo[playerid][pCarLic],
    PlayerInfo[playerid][pTruckLic],
    PlayerInfo[playerid][pMotoLic],
    PlayerInfo[playerid][pBusLic],
    PlayerInfo[playerid][pFlyLic],
    PlayerInfo[playerid][pBoatLic],
    PlayerInfo[playerid][pFishLic],
    PlayerInfo[playerid][pGunLic],
    PlayerInfo[playerid][pGunLicAllow]);
    format(query,sizeof (query),"%s `PayDay`=%d,\
    `Tut`=%d,\
    `Warns`=%d,\
    `Fuel`=%d,\
    `Married`=%d,\
    `MarriedTo`='%s',",
    query,
    PlayerInfo[playerid][pPayDay],
    PlayerInfo[playerid][pTut],
    PlayerInfo[playerid][pWarns],
    PlayerInfo[playerid][pFuel],
    PlayerInfo[playerid][pMarried],
    PlayerInfo[playerid][pMarriedTo]);
    format(query,sizeof (query),"%s `Condom`=%d,\
    `Beremenna`=%d,\
    `BeremennaTime`=%d,\
    `Kid1Name`='%s',\
    `Kid1Sex`=%d,\
    `Kid1Age`=%d,\
    `Kid2Name`='%s',\
    `Ked2Sex`=%d,\
    `Kid2Age`=%d,\
    `Kid3Name`='%s',\
    `Kid3Sex`=%d,\
    `Kid3Age`=%d,",
    query,
    PlayerInfo[playerid][pCondom],
    PlayerInfo[playerid][pBeremenna],
    PlayerInfo[playerid][pBeremennaTime],
    PlayerInfo[playerid][pKid1Name],
    PlayerInfo[playerid][pKid1Sex],
    PlayerInfo[playerid][pKid1Age],
    PlayerInfo[playerid][pKid2Name],
    PlayerInfo[playerid][pKid2Sex],
    PlayerInfo[playerid][pKid2Age],
    PlayerInfo[playerid][pKid3Name],
    PlayerInfo[playerid][pKid3Sex],
    PlayerInfo[playerid][pKid3Age]);
    format(query,sizeof (query),"%s `Bond`=%d,\
    `Winston`=%d,\
    `LS`=%d,\
    `Marlboro`=%d,\
    `Sprite`=%d,\
    `Vodka`=%d,\
    `Cognak`=%d,\
    `Vino`=%d,\
    `Bear`=%d,\
    `Cola`=%d,",
    query,
    PlayerInfo[playerid][pBond],
    PlayerInfo[playerid][pWinston],
    PlayerInfo[playerid][pLS],
    PlayerInfo[playerid][pMarlboro],
    PlayerInfo[playerid][pSprite],
    PlayerInfo[playerid][pVodka],
    PlayerInfo[playerid][pCognak],
    PlayerInfo[playerid][pVino],
    PlayerInfo[playerid][pBear],
    PlayerInfo[playerid][pCola]);
    format(query,sizeof (query),"%s `RPD`=%d,\
    `SeatBelt`=%d,\
    `Bounty`=%d,\
    `Snickers`=%d,\
    `Pringles`=%d,\
    `Masked`=%d,\
    `Mask`=%d,\
    `Pensija`=%d,\
    `Prava`=%d,\
    `Banned`=%d,\
    `Lang`=%d,",
    query,
    PlayerInfo[playerid][pRPD],
    PlayerInfo[playerid][pSeatBelt],
    PlayerInfo[playerid][pBounty],
    PlayerInfo[playerid][pSnickers],
    PlayerInfo[playerid][pPringles],
    PlayerInfo[playerid][pMasked],
    PlayerInfo[playerid][pMask],
    PlayerInfo[playerid][pPensija],
    PlayerInfo[playerid][pPrava],
    PlayerInfo[playerid][pBanned],
    PlayerInfo[playerid][pLang]);
    format(query,sizeof (query),"%s `Italian`=%d,\
    `Japanese`=%d,\
    `China`=%d,\
    `German`=%d,\
    `Espanol`=%d,\
    `Russian`=%d,\
    `Race`=%d,\
    `Draka`=%d,\
    `Kunfu`=%d,\
    `Kneehead`=%d,\
    `Grabkick`=%d,",
    query,
    PlayerInfo[playerid][pItalian],
    PlayerInfo[playerid][pJapanese],
    PlayerInfo[playerid][pChina],
    PlayerInfo[playerid][pGerman],
    PlayerInfo[playerid][pEspanol],
    PlayerInfo[playerid][pRussian],
    PlayerInfo[playerid][pRace],
    PlayerInfo[playerid][pDraka],
    PlayerInfo[playerid][pKunfu],
    PlayerInfo[playerid][pKneehead],
    PlayerInfo[playerid][pGrabkick]);
    format(query,sizeof (query),"%s `TA`=%d,\
    `Rope`=%d,\
    `SK`=%d,\
    `SD`=%d,\
    `Clock`=%d,",
    query,
    PlayerInfo[playerid][pTA],
    PlayerInfo[playerid][pRope],
    PlayerInfo[playerid][pSK],
    PlayerInfo[playerid][pSD],
    PlayerInfo[playerid][pClock]);
    format(query,sizeof (query),"%s `InvWeapon`=%d,\
    `InvAmmo`=%d,\
    `InvWeapon2`=%d,\
    `InvAmmo2`=%d,\
    `InvWeapon3`=%d,\
    `InvAmmo3`=%d,\
    `Sil`=%d,",
    query,
    PlayerInfo[playerid][pInvWeapon],
    PlayerInfo[playerid][pInvAmmo],
    PlayerInfo[playerid][pInvWeapon2],
    PlayerInfo[playerid][pInvAmmo2],
    PlayerInfo[playerid][pInvWeapon3],
    PlayerInfo[playerid][pInvAmmo3],
    PlayerInfo[playerid][pSil]);
    format(query,sizeof (query),"%s `Bandana1`=%d,\
    `Bandana2`=%d,\
    `Bandana3`=%d,\
    `Bandana4`=%d,\
    `Bandana5`=%d,\
    `Radio`=%d,\
    `RadioNick`='%s',\
    `SQ`=%d,\
    `BreakSkill`=%d,\
    `LastCar`=%d,\
    `Hunger`=%d,\
    `Water`=%d,\
    `NeSdal`=%d,\
    `Salary`=%d WHERE `ID`='%d' LIMIT 1",
    query,
    PlayerInfo[playerid][pBandana1],
    PlayerInfo[playerid][pBandana2],
    PlayerInfo[playerid][pBandana3],
    PlayerInfo[playerid][pBandana4],
    PlayerInfo[playerid][pBandana5],
    PlayerInfo[playerid][pRadio],
    PlayerInfo[playerid][pRadioNick],
    PlayerInfo[playerid][pSQ],
    PlayerInfo[playerid][pBreakSkill],
    PlayerInfo[playerid][pLastCar],
    PlayerInfo[playerid][pHunger],
    PlayerInfo[playerid][pWater],
    PlayerInfo[playerid][pNeSdal],
    PlayerInfo[playerid][pSalary],
    PlayerInfo[playerid][pID]);
    mysql_query(query);
    new name[24]; GetPlayerName(playerid, name, sizeof(name));
    printf("SavePlayer(ID: %d, Name: %s, DB ID: %d)", playerid, name, PlayerInfo[playerid][pID]);
    return true;
    }
    return false;
}

Спойлер: Структура

CREATE TABLE IF NOT EXISTS `players` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(24) NOT NULL,
  `Pass` varchar(32) NOT NULL,
  `Level` int(1) NOT NULL default '1',
  `Admin` int(5) NOT NULL default '0',
  `DonateRank` int(5) NOT NULL default '0',
  `ConnectTime` int(5) NOT NULL default '0',
  `SuppMuteTime` int(5) NOT NULL default '0',
  `ReportMuteTime` int(5) NOT NULL default '0',
  `BMuteTime` int(5) NOT NULL default '0',
  `Reg` int(5) NOT NULL default '0',
  `Sex` int(5) NOT NULL default '0',
  `Age` int(5) NOT NULL default '0',
  `AgeTime` int(5) NOT NULL default '0',
  `TimeAge` int(5) NOT NULL default '0',
  `LivingAt` varchar(24) NOT NULL default 'None',
  `FirstName` varchar(24) NOT NULL default 'None',
  `LastName` varchar(24) NOT NULL default 'None',
  `BornAt` varchar(24) NOT NULL default 'None',
  `Pasport` int(5) NOT NULL default '0',
  `BageNum` int(5) NOT NULL default '0',
  `Tested` int(5) NOT NULL default '0',
  `Exp` int(5) NOT NULL default '0',
  `Cash` int(5) NOT NULL default '0',
  `Account` int(5) NOT NULL default '0',
  `Crimes` int(5) NOT NULL default '0',
  `Wanted` int(5) NOT NULL default '0',
  `Sud` int(5) NOT NULL default '0',
  `Arrested` int(5) NOT NULL default '0',
  `Job` int(5) NOT NULL default '0',
  `AFK` int(5) NOT NULL default '0',
  `HeadValue` int(5) NOT NULL default '0',
  `Jailed` int(5) NOT NULL default '0',
  `JailTime` int(5) NOT NULL default '0',
  `JailPrice` int(5) NOT NULL default '0',
  `AJailed` int(5) NOT NULL default '0',
  `AJailTime` int(5) NOT NULL default '0',
  `Turma` int(5) NOT NULL default '0',
  `Drugs` int(5) NOT NULL default '0',
  `WeedTime` int(5) NOT NULL default '0',
  `WeedStage` int(5) NOT NULL default '0',
  `STD` int(5) NOT NULL default '0',
  `Seed` int(5) NOT NULL default '0',
  `Leader` int(5) NOT NULL default '0',
  `Member` int(5) NOT NULL default '0',
  `Rank` int(5) NOT NULL default '0',
  `RankName` varchar(24) NOT NULL default 'None',
  `FMember` int(5) NOT NULL default '0',
  `FamilyRank` varchar(24) NOT NULL default 'None',
  `FamilyCreate` int(5) NOT NULL default '0',
  `Char` int(5) NOT NULL default '0',
  `Model` int(5) NOT NULL default '0',
  `Model2` int(5) NOT NULL default '0',
  `Model3` int(5) NOT NULL default '0',
  `ContractTime` int(5) NOT NULL default '0',
  `JackSkill` int(5) NOT NULL default '0',
  `CarSkill` int(5) NOT NULL default '0',
  `Health` float(4,1) NOT NULL default '0.0',
  `SHealth` float(4,1) NOT NULL default '0.0',
  `Int` int(5) NOT NULL default '0',
  `Virtual` int(5) NOT NULL default '0',
  `Local` int(5) NOT NULL default '0',
  `Team` int(5) NOT NULL default '0',
  `Spawn` int(5) NOT NULL default '0',
  `Pnumber` int(5) NOT NULL default '0',
  `Mobile` int(5) NOT NULL default '0',
  `Phousekey` int(5) NOT NULL default '0',
  `Pbiskey` int(5) NOT NULL default '0',
  `Pos_x` float(5,1) NOT NULL default '2246.6',
  `Pos_y` float(5,1) NOT NULL default '2246.6',
  `Pos_z` float(5,1) NOT NULL default '2246.6',
  `CarLic` int(5) NOT NULL default '0',
  `TruckLic` int(5) NOT NULL default '0',
  `MotoLic` int(5) NOT NULL default '0',
  `BusLic` int(5) NOT NULL default '0',
  `FlyLic` int(5) NOT NULL default '0',
  `BoatLic` int(5) NOT NULL default '0',
  `FishLic` int(5) NOT NULL default '0',
  `GunLic` int(5) NOT NULL default '0',
  `GunLicAllow` int(5) NOT NULL default '0',
  `PayDay` int(5) NOT NULL default '0',
  `Tut` int(5) NOT NULL default '0',
  `Warns` int(5) NOT NULL default '0',
  `Fuel` int(5) NOT NULL default '0',
  `Married` int(5) NOT NULL default '0',
  `MarriedTo` varchar(24) NOT NULL default 'None',
  `Condom` int(5) NOT NULL default '0',
  `Beremenna` int(5) NOT NULL default '0',
  `BeremennaTime` int(5) NOT NULL default '0',
  `Kid1Name` varchar(24) NOT NULL default 'None',
  `Kid1Sex` int(5) NOT NULL default '0',
  `Kid1Age` int(5) NOT NULL default '0',
  `Kid2Name` varchar(24) NOT NULL default 'None',
  `Ked2Sex` int(5) NOT NULL default '0',
  `Kid2Age` int(5) NOT NULL default '0',
  `Kid3Name` varchar(24) NOT NULL default 'None',
  `Kid3Sex` int(5) NOT NULL default '0',
  `Kid3Age` int(5) NOT NULL default '0',
  `Bond` int(5) NOT NULL default '0',
  `Winston` int(5) NOT NULL default '0',
  `LS` int(5) NOT NULL default '0',
  `Marlboro` int(5) NOT NULL default '0',
  `Sprite` int(5) NOT NULL default '0',
  `Vodka` int(5) NOT NULL default '0',
  `Cognak` int(5) NOT NULL default '0',
  `Vino` int(5) NOT NULL default '0',
  `Bear` int(5) NOT NULL default '0',
  `Cola` int(5) NOT NULL default '0',
  `RPD` int(5) NOT NULL default '0',
  `SeatBelt` int(5) NOT NULL default '0',
  `Bounty` int(5) NOT NULL default '0',
  `Snickers` int(5) NOT NULL default '0',
  `Pringles` int(5) NOT NULL default '0',
  `Masked` int(5) NOT NULL default '0',
  `Mask` int(5) NOT NULL default '0',
  `Pensija` int(5) NOT NULL default '0',
  `Prava` int(5) NOT NULL default '0',
  `Banned` int(5) NOT NULL default '0',
  `Lang` int(5) NOT NULL default '0',
  `Italian` int(5) NOT NULL default '0',
  `Japanese` int(5) NOT NULL default '0',
  `China` int(5) NOT NULL default '0',
  `German` int(5) NOT NULL default '0',
  `Espanol` int(5) NOT NULL default '0',
  `Russian` int(5) NOT NULL default '0',
  `Race` int(5) NOT NULL default '0',
  `Draka` int(5) NOT NULL default '0',
  `Kunfu` int(5) NOT NULL default '0',
  `Kneehead` int(5) NOT NULL default '0',
  `Grabkick` int(5) NOT NULL default '0',
  `TA` int(5) NOT NULL default '0',
  `Rope` int(5) NOT NULL default '0',
  `SK` int(5) NOT NULL default '0',
  `SD` int(5) NOT NULL default '0',
  `Clock` int(5) NOT NULL default '0',
  `InvWeapon` int(5) NOT NULL default '0',
  `InvAmmo` int(5) NOT NULL default '0',
  `InvWeapon2` int(5) NOT NULL default '0',
  `InvAmmo2` int(5) NOT NULL default '0',
  `InvWeapon3` int(5) NOT NULL default '0',
  `InvAmmo3` int(5) NOT NULL default '0',
  `Sil` int(5) NOT NULL default '0',
  `Bandana1` int(5) NOT NULL default '0',
  `Bandana2` int(5) NOT NULL default '0',
  `Bandana3` int(5) NOT NULL default '0',
  `Bandana4` int(5) NOT NULL default '0',
  `Bandana5` int(5) NOT NULL default '0',
  `Radio` int(5) NOT NULL default '0',
  `RadioNick` varchar(24) NOT NULL default 'None',
  `SQ` int(5) NOT NULL default '0',
  `BreakSkill` int(5) NOT NULL default '0',
  `LastCar` int(5) NOT NULL default '0',
  `Hunger` int(5) NOT NULL default '0',
  `Water` int(5) NOT NULL default '0',
  `NeSdal` int(5) NOT NULL default '0',
  `Salary` int(5) NOT NULL default '0',
  KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

Хостинг gamerhost.su