LoadAccount(playerid)
{
format(query, sizeof(query), "SELECT * FROM "TABLE_ACCOUNT" WHERE `ID` = '%i'", PlayerInfo[playerid][pID]);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_row(query) == 1)
{
mysql_fetch_row_format(query, "|");
new guns[56],ammo[56],notice[8], status, gunskill[30];
sscanf(query, "p<|>is[32]s[32]s[64]s[16]s[16]s[32]iis[32]s[16]fiiiiis[32]iiiiis[40]iiiiiiiiiiiis[40]is[40]s[30]iis[32]is[32]s[32]iis[8]iiiis[16]iiiiiiiiiiis[56]s[56]i",
PlayerInfo[playerid][pID],
PlayerInfo[playerid][pName],
PlayerInfo[playerid][pPassword],
PlayerInfo[playerid][pMail],
PlayerInfo[playerid][pIp],
PlayerInfo[playerid][pEndIp],
PlayerInfo[playerid][pSuperKey],
PlayerInfo[playerid][pGuardKey],
PlayerInfo[playerid][pGuardMail],
PlayerInfo[playerid][pReferal],
PlayerInfo[playerid][pDataReg],
PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pAdmin],
PlayerInfo[playerid][pAdminPassword],
PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pLeader],
PlayerInfo[playerid][pRang],
PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pTogs],
PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pNumberPhone],
PlayerInfo[playerid][pMobilecash],
PlayerInfo[playerid][pMute],
PlayerInfo[playerid][pMuteReport],
PlayerInfo[playerid][pWarn],
PlayerInfo[playerid][pWarnTime],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pMats],
PlayerInfo[playerid][pWantedLevel],
PlayerInfo[playerid][pJails],
PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pLics],
gunskill,
PlayerInfo[playerid][pJerrycan],
PlayerInfo[playerid][pTools],
PlayerInfo[playerid][pNewlyWedsTo],
PlayerInfo[playerid][pNewlyWeds],
PlayerInfo[playerid][pCrimeWho],
PlayerInfo[playerid][pCrime],
PlayerInfo[playerid][pCheck],
PlayerInfo[playerid][pScrDonate],
notice,
PlayerInfo[playerid][pExpTime],
PlayerInfo[playerid][pEnterHour],
PlayerInfo[playerid][pFarm],
PlayerInfo[playerid][pFarmJob],
PlayerInfo[playerid][pEndEnter],
status,
PlayerInfo[playerid][pHourFractions],
PlayerInfo[playerid][pReputation],
PlayerInfo[playerid][pDepen],
PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pDolg],
PlayerInfo[playerid][pUseKrisha],
PlayerInfo[playerid][pKrisha],
PlayerInfo[playerid][pEat],
PlayerInfo[playerid][pStatusVip],
PlayerInfo[playerid][pEscape],
PlayerInfo[playerid][pBrunt],
guns,
ammo,
PlayerInfo[playerid][pPass]);
LoadCars(playerid);
mysql_free_result();
//
SetPVarString(playerid,"mysqlgun",guns);
SetPVarString(playerid,"mysqlammo",ammo);
sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[3]",PlayerInfo[playerid][pLic]);
sscanf(PlayerInfo[playerid][pTogs], "p<,>a<i>[3]",PlayerInfo[playerid][pTog]);
sscanf(PlayerInfo[playerid][pJails], "p<,>a<i>[3]",PlayerInfo[playerid][pJail]);
sscanf(gunskill, "p<,>a<i>[6]",PlayerInfo[playerid][pGunSkill]);
sscanf(notice, "p<,>a<i>[3]",PlayerInfo[playerid][pNotice]);
//
gPlayerLogged[playerid] = true;
GetPlayerHouse(playerid);
GetPlayerBizz(playerid);
GetPlayerFarm(playerid);
//
SetSpawnInfo(playerid, 255, 1, 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
//Ïîñëåäíèé IP
new ip[16];
GetPlayerIp(playerid, ip, sizeof(ip));
SetPlayerStr(PlayerInfo[playerid][pName],"EndIp",ip);
//Ïîñëåäíèé âõîä
new data[16] ,Year, Month, Day;
getdate(Year, Month, Day);
format(data, sizeof(data), "%02d.%02d.%d", Day, Month, Year);
SetPlayerStr(PlayerInfo[playerid][pName],"EndEnter",data);
///
format(nsa, sizeof(nsa), "Авторизация прошла успешно. Ваше имя: %s. Номер вашего аккаунта: %d", sn, PlayerInfo[playerid][pID]);
SCM(playerid, -1, nsa);
if(PlayerInfo[playerid][pStatusVip] >= 1) SCM(playerid, COLOR_YELLOW3, "Добро пожаловать, VIP игрок.");
///
if(PlayerInfo[playerid][pNotice][0] == 1)
{
SCM(playerid, COLOR_LIGHTRED,"[НАЛОГОВАЯ] Ваш дом был продан государству!");
SCM(playerid, COLOR_LIGHTRED,"[НАЛОГОВАЯ] Полученные деньги были переведены на банковский счет!");
PlayerInfo[playerid][pNotice][0] = 0;
SetPVarInt(playerid,"Notice", 1);
}
if(PlayerInfo[playerid][pNotice][1] == 1)
{
SCM(playerid, COLOR_LIGHTRED,"[НАЛОГОВАЯ] Ваш бизнес был продан государству!");
SCM(playerid, COLOR_LIGHTRED,"[НАЛОГОВАЯ] Полученные деньги были переведены на банковский счет!");
PlayerInfo[playerid][pNotice][1] = 0;
SetPVarInt(playerid,"Notice", 1);
}
if(PlayerInfo[playerid][pNotice][2] == 1)
{
SCM(playerid, COLOR_LIGHTGREEN,"[ПОЗДРАВЛЕНИЯ] Спасибо вам, что вы пригласили игрока на наш сервер!");
SCM(playerid, COLOR_LIGHTGREEN,"[ПОЗДРАВЛЕНИЯ] В качестве подарка Вы получаете 100 очков доната!");
SCM(playerid, COLOR_LIGHTGREEN,"[ПОЗДРАВЛЕНИЯ] Зовите друзей! Вместе играть веселее!");
PlayerInfo[playerid][pNotice][2] = 0;
SetPVarInt(playerid,"Notice", 1);
}
if(PlayerInfo[playerid][pGuardMail] == 0)
{
SCM(playerid, COLOR_LIGHTRED, "Внимание! У Вас низкая степень защиты безопасности!");
SCM(playerid, COLOR_LIGHTRED, "Мы рекомендуем Вам обезопасить Ваш аккаунт от взлома. Используйте: /menu => Безопасность");
}
if(GetPVarInt(playerid,"Notice") == 1)
{
format(notice,sizeof(notice),"%d,%d,%d",PlayerInfo[playerid][pNotice][0],PlayerInfo[playerid][pNotice][1],PlayerInfo[playerid][pNotice][2]);
UpdatePlayerTableStr(playerid, "Notice",notice);
}
UpdatePlayerTableInt(playerid, "Status", 1);
//
CreateEatTextDraw(playerid);
UpdatePlayerHunger(playerid);
return 1;
}
else
{
SPD(playerid,8,DIALOG_STYLE_MSGBOX,"Неверный пароль","Не удается войти на сервер. Неверный пароль.\n\n› Возможно, нажата клавиша CAPS-lock?\n› Возможно у Вас включена неправильная раскладка? (русская)\n› Попробуйте набрать свой пароль в текстовом редакторе и скопировать в графу ниже.","Повтор","Выйти");
gPlayerLogTries[playerid] --;
if(gPlayerLogTries[playerid] < 1)
{
SPD(playerid,0,DIALOG_STYLE_MSGBOX,"Неверный пароль","› Вы исчерпали все попытки входа на сервер.\n› Вы были отсоединены от сервера.\n\nДля выхода используйте {ffffff}(/q)uit.","Выйти","");
Kicked(playerid);
return true;
}
}
return 1;
}
LoadAccount
LoadAccount(playerid)