The_Dok
Компетентный
Здравствуйте уважаемые форумчане. У меня две проблемы связаны с аккаунтами (регистрация на mysql r5)
Перейдём к делу,
1. На сервере максимум один игрок может зарегистрироваться, а второму игроку не высвечивается окно регистрации, после рестарта, опять так же.
В логе сервера:
2. Не сохраняются аккаунты. (в базе создаётся аккаунт с паролем)
Дам много +сиков. Если надо что нибудь скинуть, говорите. Скину.
Перейдём к делу,
1. На сервере максимум один игрок может зарегистрироваться, а второму игроку не высвечивается окно регистрации, после рестарта, опять так же.
В логе сервера:
PHP:
[12:00:27] MySQL: Подключение удалось.
PHP:
stock SaveAccount(playerid)
{
if(PlayerInfo[playerid][pLogged] == true)
{
CheckMySQLConnection();
new str[4000];
new sqlname[MAX_PLAYER_NAME];
mysql_real_escape_string(PlayerInfo[playerid][pName1], sqlname);
format(str, sizeof(str), "UPDATE `Accounts` SET `Nickname`= '%s',`Level`= '%i', `LastSkin`= '%i', `Dostup`= '%i', `DostupL`= '%i', `Admin`= '%i', `Helper`= '%i', `Givem`= '%i', `dak` = '%i', `DonateRank` = '%i', `Pupgrade` = '%i', `Reg`= '%i',",
sqlname,
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pLastSkin],
PlayerInfo[playerid][pDostup],
PlayerInfo[playerid][pDostupL],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pGivem],
PlayerInfo[playerid][pdak],
PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][gPupgrade],
PlayerInfo[playerid][pReg]);
format(str, sizeof(str), "%s `Sex` = '%i',`Exp` = '%i',`Money`= '%i',`Account` = '%i',`Crimes` = '%i',`Arrested`= '%i',`WantedDeaths`= '%i',`Job` = '%i',`PayCheck` = '%i',`HeadValue` = '%i',`Jailed` = '%i',`JailTime` = '%i',`Mats` = '%i',`Drugs` = '%i',`Leader` = '%i',",
str,
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pAccount],
PlayerInfo[playerid][pCrimes],
PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck],
PlayerInfo[playerid][pHeadValue],
PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader]);
format(str, sizeof(str), "%s `Member` = '%i',`Rank` = '%i',`Char` = '%i',`DetSkill` = '%i',`DrugsSkill` = '%i',`TruckSkill` = '%i',`MatsSkill` = '%i',`LawSkill` = '%i',`MechSkill` = '%i',",
str,
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pDetSkill],
PlayerInfo[playerid][pDrugsSkill],
PlayerInfo[playerid][pTruckSkill],
PlayerInfo[playerid][pMatsSkill],
PlayerInfo[playerid][pLawSkill],
PlayerInfo[playerid][pMechSkill]);
format(str, sizeof(str), "%s `JackSkill` = '%i',`CarSkill`= '%i',`AviaSkill` = '%i',`PizzaSkill` = '%i',`Muted` = '%i',`FMuted` = '%i',`MutedTime` = '%i',`Blocked` = '%i',`FMutedTime` = '%i',`Zmats` = '%i',`Zdrugs` = '%i',`tMats` = '%i',`tDrugs` = '%i',`SHealth` = '%i',`Health` = '%i',`Local` = '%i',`Team` = '%i',",
str,
PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pCarSkill],
PlayerInfo[playerid][pAviaSkill],
PlayerInfo[playerid][pPizzaSkill],
PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pFMuted],
PlayerInfo[playerid][pMutedTime],
PlayerInfo[playerid][pBlocked],
PlayerInfo[playerid][pFMutedTime],
PlayerInfo[playerid][pZmats],
PlayerInfo[playerid][pZdrugs],
PlayerInfo[playerid][ptMats],
PlayerInfo[playerid][ptDrugs],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pLocal],
PlayerInfo[playerid][pTeam]);
format(str, sizeof(str), "%s `Phousekey` = '%i',`Pbiskey`= '%i',`CarLic` = '%i',`FlyLic` = '%i',`BoatLic` = '%i',`GunLic` = '%i',`MotoLic` = '%i',`CarTime` = '%i',`PayDay` = '%i',`AlcoholPerk` = '%i',`MiserPerk` = '%i',`PainPerk` = '%i',`TraderPerk` = '%i',`Warns` = '%i',`Wanted` = '%i',`FWarns` = '%i',`AWarns` = '%i',`HWarns` = '%i', `FlatKey` = '%i', WHERE `ID` = '%i',",
str,
PlayerInfo[playerid][pPhousekey],
PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pCarLic],
PlayerInfo[playerid][pFlyLic],
PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pMotoLic],
PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pPayDay],
PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pMiserPerk],
PlayerInfo[playerid][pPainPerk],
PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pWarns],
PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pFWarns],
PlayerInfo[playerid][pAWarns],
PlayerInfo[playerid][pHWarns],
PlayerInfo[playerid][pFlatKey],
PlayerInfo[playerid][pID]);
format(str, sizeof(str), "%s `Boi` = '%i',`Dice`= '%i',`KFuel` = '%i',`Gold` = '%i',`Hourgame` = '%i',`Time` = '%i',`Player` = '%i',`Windm` = '%i',`Winderby` = '%i',`LottoNr` = '%i',`Robbed` = '%i',`Otkavia` = '%i',`Otkpizza` = '%i',",
str,
PlayerInfo[playerid][pBoi],
PlayerInfo[playerid][pDice],
PlayerInfo[playerid][pKFuel],
PlayerInfo[playerid][pGold],
PlayerInfo[playerid][pHourgame],
PlayerInfo[playerid][pTime],
PlayerInfo[playerid][pPlayer],
PlayerInfo[playerid][pWindm],
PlayerInfo[playerid][pWinderby],
PlayerInfo[playerid][pLottoNr],
PlayerInfo[playerid][pRobbed],
PlayerInfo[playerid][pOtkavia],
PlayerInfo[playerid][pOtkpizza]);
format(str, sizeof(str), "%s `Otkdrugs` = '%i',`Otkmats`= '%i',`Day` = '%i',`Month` = '%i',`Year` = '%i',`Spawn` = '%i',`NPC` = '%i',`Azs` = '%i'",
str,
PlayerInfo[playerid][pOtkdrugs],
PlayerInfo[playerid][pOtkmats],
PlayerInfo[playerid][pDay],
PlayerInfo[playerid][pMonth],
PlayerInfo[playerid][pSpawn],
PlayerInfo[playerid][pNPC],
PlayerInfo[playerid][pAzs]);
mysql_query(str);
}
return 1;
}
Последнее редактирование:
