I'd like to know if the script is related to why i've got crash, the register/login system is here.
Код:
public OnPlayerRegister(playerid, password[])
{
if(IsPlayerConnected(playerid))
{
new playername3[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername3, sizeof(playername3));
new Str[200];
mysql_format(SQL,Str,sizeof(Str),"INSERT INTO `users` (`name`,`password`) VALUES ('%s','%s')",playername3,password);
mysql_tquery(SQL,Str,"","");
strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255);
PlayerInfo[playerid][pCash] = GetPlayerCash(playerid);
GetPlayerHealthEx(playerid,PlayerInfo[playerid][pHealth]);
if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
{
PlayerInfo[playerid][pPos_x] = 2246.6;
PlayerInfo[playerid][pPos_y] = -1161.9;
PlayerInfo[playerid][pPos_z] = 1029.7;
}
if(Spectate[playerid] != -1)
{
PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
}
new str[128];
mysql_format(SQL,str,128,"UPDATE users SET `pHealth`='%.1f' WHERE `name`='%s'",PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pNormalName]);
mysql_tquery(SQL,str,"","");
ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"SERVER: Login","Welcome to Yellow Bugged Server.\n\nPlease enter your password below!","Login","Cancel");
return 1;
}
return 1;
}
public OnPlayerLogin(playerid,password[])
{
new playername2[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername2, sizeof(playername2));
GameTextForPlayer(playerid, "~w~LOADING...~n~~y~CHECKING THE PASSWORD", 700, 3);
new playerip[16];
GetPlayerIp(playerid,playerip,sizeof(playerip));
if(NumIp(playerip, playerid) >= 3 && !IsBotOnIP(playerip))
{
SendClientMessage(playerid, COLOR_LIGHTRED, "There are already 2 players connected with same IP.");
Kick(playerid);
return 1;
}
new qstr[256];
format(qstr,100,"SELECT * FROM users WHERE `name`='%s' AND `password`='%s'",playername2,password);
new Cache: pass = mysql_query(SQL,qstr);
if(cache_get_row_count() > 0)
{
cache_get_field_content(0, "password", PlayerInfo[playerid][pKey], SQL, 130);
cache_get_field_content(0, "name", PlayerInfo[playerid][pNormalName], SQL, 130);
PlayerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
PlayerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "Admin");
PlayerInfo[playerid][pHelper] = cache_get_field_content_int(0, "Helper");
PlayerInfo[playerid][pPremiumAccount] = cache_get_field_content_int(0, "Premium");
PlayerInfo[playerid][pBeta] = cache_get_field_content_int(0, "Beta");
PlayerInfo[playerid][pSupport] = cache_get_field_content_int(0, "Support");
PlayerInfo[playerid][pManagerLideri] = cache_get_field_content_int(0, "ManagerLideri");
PlayerInfo[playerid][pManagerLideriSupport] = cache_get_field_content_int(0, "ManagerLideriSupport");
PlayerInfo[playerid][pManagerDepartamente] = cache_get_field_content_int(0, "ManagerDepartamente");
PlayerInfo[playerid][pManagerTaxi] = cache_get_field_content_int(0, "ManagerTaxi");
PlayerInfo[playerid][pManagerInstructori] = cache_get_field_content_int(0, "ManagerInstructori");
PlayerInfo[playerid][pManagerMedici] = cache_get_field_content_int(0, "ManagerMedici");
PlayerInfo[playerid][pManagerHitman] = cache_get_field_content_int(0, "ManagerHitman");
PlayerInfo[playerid][pPremiumPoints] = cache_get_field_content_int(0, "PremiumPoints");
PlayerInfo[playerid][pConnectTime] = cache_get_field_content_int(0, "ConnectedTime");
PlayerInfo[playerid][pReg] = cache_get_field_content_int(0, "Registered");
PlayerInfo[playerid][pSex] = cache_get_field_content_int(0, "Sex");
PlayerInfo[playerid][pAge] = cache_get_field_content_int(0, "Age");
PlayerInfo[playerid][pGasCan] = cache_get_field_content_int(0, "GasCan");
PlayerInfo[playerid][pOrigin] = cache_get_field_content_int(0, "Origin");
PlayerInfo[playerid][pMuted] = cache_get_field_content_int(0, "Muted");
PlayerInfo[playerid][pMuteTime] = cache_get_field_content_int(0, "MuteTime");
PlayerInfo[playerid][pExp] = cache_get_field_content_int(0, "Respect");
PlayerInfo[playerid][pCash] = cache_get_field_content_int(0, "Money");
PlayerInfo[playerid][pAccount] = cache_get_field_content_int(0, "Bank");
PlayerInfo[playerid][pCrimes] = cache_get_field_content_int(0, "Crimes");
PlayerInfo[playerid][pKills] = cache_get_field_content_int(0, "Kills");
PlayerInfo[playerid][pDeaths] = cache_get_field_content_int(0, "Deaths");
PlayerInfo[playerid][pArrested] = cache_get_field_content_int(0, "Arrested");
PlayerInfo[playerid][pWantedDeaths] = cache_get_field_content_int(0, "WantedDeaths");
PlayerInfo[playerid][pPhoneBook] = cache_get_field_content_int(0, "Phonebook");
PlayerInfo[playerid][pWantedLevel] = cache_get_field_content_int(0, "WantedLevel");
PlayerInfo[playerid][pFishes] = cache_get_field_content_int(0, "Fishes");
PlayerInfo[playerid][pJob] = cache_get_field_content_int(0, "Job");
PlayerInfo[playerid][pPayCheck] = cache_get_field_content_int(0, "Paycheck");
PlayerInfo[playerid][pHeadValue] = cache_get_field_content_int(0, "HeadValue");
PlayerInfo[playerid][pJailed] = cache_get_field_content_int(0, "Jailed");
PlayerInfo[playerid][pJailTime] = cache_get_field_content_int(0, "JailTime");
PlayerInfo[playerid][pMats] = cache_get_field_content_int(0, "Materials");
PlayerInfo[playerid][pDrugs] = cache_get_field_content_int(0, "Drugs");
PlayerInfo[playerid][pLeader] = cache_get_field_content_int(0, "Leader");
PlayerInfo[playerid][pMember] = cache_get_field_content_int(0, "Member");
PlayerInfo[playerid][pRank] = cache_get_field_content_int(0, "Rank");
PlayerInfo[playerid][pFACWarns] = cache_get_field_content_int(0, "FWarn");
PlayerInfo[playerid][pFpunish] = cache_get_field_content_int(0, "FPunish");
PlayerInfo[playerid][pLawyer] = cache_get_field_content_int(0, "Acceptpoints");
PlayerInfo[playerid][pFishSkill] = cache_get_field_content_int(0, "FishSkill");
PlayerInfo[playerid][pSpawnChange] = cache_get_field_content_int(0, "SpawnChange");
PlayerInfo[playerid][pRobSkill] = cache_get_field_content_int(0, "RobSkill");
PlayerInfo[playerid][pTruckSkill] = cache_get_field_content_int(0, "TruckSkill");
PlayerInfo[playerid][pTruckTimes] = cache_get_field_content_int(0, "TruckTimes");
PlayerInfo[playerid][pTruckRem] = cache_get_field_content_int(0, "TruckRem");
PlayerInfo[playerid][pFarmSkill] = cache_get_field_content_int(0, "FarmSkill");
PlayerInfo[playerid][pFarmTimes] = cache_get_field_content_int(0, "FarmTimes");
PlayerInfo[playerid][pFarmRem] = cache_get_field_content_int(0, "FarmRem");
PlayerInfo[playerid][pPizzaSkill] = cache_get_field_content_int(0, "PizzaSkill");
PlayerInfo[playerid][pPizzaTimes] = cache_get_field_content_int(0, "PizzaTimes");
PlayerInfo[playerid][pPizzaRem] = cache_get_field_content_int(0, "PizzaRem");
PlayerInfo[playerid][pArmsSkill] = cache_get_field_content_int(0, "ArmsSkill");
PlayerInfo[playerid][pArmsTimes] = cache_get_field_content_int(0, "ArmsTimes");
PlayerInfo[playerid][pArmsRem] = cache_get_field_content_int(0, "ArmsRem");
PlayerInfo[playerid][pBusSkill] = cache_get_field_content_int(0, "BusSkill");
PlayerInfo[playerid][pBusTimes] = cache_get_field_content_int(0, "BusTimes");
PlayerInfo[playerid][pBusRem] = cache_get_field_content_int(0, "BusRem");
PlayerInfo[playerid][pFishTimes] = cache_get_field_content_int(0, "FishTimes");
PlayerInfo[playerid][pFishRem] = cache_get_field_content_int(0, "FishRem");
PlayerInfo[playerid][pRobRem] = cache_get_field_content_int(0, "RobRem");
PlayerInfo[playerid][pRobTimes] = cache_get_field_content_int(0, "RobTimes");
PlayerInfo[playerid][pHealth] = cache_get_field_content_float(0, "pHealth");
PlayerInfo[playerid][pInt] = cache_get_field_content_int(0, "Inter");
PlayerInfo[playerid][pLocal] = cache_get_field_content_int(0, "Local");
PlayerInfo[playerid][pTeam] = cache_get_field_content_int(0, "Team");
PlayerInfo[playerid][pModel] = cache_get_field_content_int(0, "Model");
PlayerInfo[playerid][pPnumber] = cache_get_field_content_int(0, "PhoneNr");
PlayerInfo[playerid][pPhousekey] = cache_get_field_content_int(0, "House");
PlayerInfo[playerid][pPbiskey] = cache_get_field_content_int(0, "Bizz");
PlayerInfo[playerid][pPos_x] = cache_get_field_content_float(0, "Pos_x");
PlayerInfo[playerid][pPos_y] = cache_get_field_content_float(0, "Pos_y");
PlayerInfo[playerid][pPos_z] = cache_get_field_content_float(0, "Pos_z");
PlayerInfo[playerid][pRob] = cache_get_field_content_int(0, "Rob");
PlayerInfo[playerid][pCarLicT] = cache_get_field_content_int(0, "CarLicT");
PlayerInfo[playerid][pCarLic] = cache_get_field_content_int(0, "CarLic");
PlayerInfo[playerid][pCarLicSuspend] = cache_get_field_content_int(0, "CarLicSuspend");
PlayerInfo[playerid][pGunLicSuspend] = cache_get_field_content_int(0, "GunLicSuspend");
PlayerInfo[playerid][pFlyLicT] = cache_get_field_content_int(0, "FlyLicT");
PlayerInfo[playerid][pFlyLic] = cache_get_field_content_int(0, "FlyLic");
PlayerInfo[playerid][pBoatLicT] = cache_get_field_content_int(0, "BoatLicT");
PlayerInfo[playerid][pBoatLic] = cache_get_field_content_int(0, "BoatLic");
PlayerInfo[playerid][pGunLicT] = cache_get_field_content_int(0, "GunLicT");
PlayerInfo[playerid][pGunLic] = cache_get_field_content_int(0, "GunLic");
PlayerInfo[playerid][pPayDay] = cache_get_field_content_int(0, "PayDay");
PlayerInfo[playerid][pTut] = cache_get_field_content_int(0, "Tutorial");
PlayerInfo[playerid][pWarns] = cache_get_field_content_int(0, "Warnings");
PlayerInfo[playerid][pRented] = cache_get_field_content_int(0, "Rented");
PlayerInfo[playerid][pFuel] = cache_get_field_content_int(0, "Fuel");
PlayerInfo[playerid][pWTalkie] = cache_get_field_content_int(0, "WTalkie");
cache_get_field_content(0, "Email", PlayerInfo[playerid][pEmail], SQL, 255);
cache_get_field_content(0, "RegisterDate", PlayerInfo[playerid][pRegistredDate], SQL, 255);
PlayerInfo[playerid][pClan] = cache_get_field_content_int(0, "Clan");
PlayerInfo[playerid][pHitT] = cache_get_field_content_int(0, "HitT");
PlayerInfo[playerid][pCRank] = cache_get_field_content_int(0, "CRank");
PlayerInfo[playerid][pCWarns] = cache_get_field_content_int(0, "ClanWarns");
PlayerInfo[playerid][pPhone] = cache_get_field_content_int(0, "Phone");
PlayerInfo[playerid][pSQLID] = cache_get_field_content_int(0, "id");
PlayerInfo[playerid][pPcarkey] = cache_get_field_content_int(0, "Carkey");
PlayerInfo[playerid][pmotokey] = cache_get_field_content_int(0, "motokey");
PlayerInfo[playerid][pprcarkey2] = cache_get_field_content_int(0, "prcarkey2");
PlayerInfo[playerid][pPPluscarkey] = cache_get_field_content_int(0, "pluscarkey");
PlayerInfo[playerid][pPPluscarkey2] = cache_get_field_content_int(0, "pluscarkey2");
PlayerInfo[playerid][pPlusSlot1] = cache_get_field_content_int(0, "PlusSlot1");
PlayerInfo[playerid][pPlusSlot2] = cache_get_field_content_int(0, "PlusSlot2");
PlayerInfo[playerid][phelikey] = cache_get_field_content_int(0, "helikey");
PlayerInfo[playerid][pprcarkey] = cache_get_field_content_int(0, "prcarkey");
cache_get_field_content(0, "Victim", PlayerInfo[playerid][pVictim], SQL, 255);
cache_get_field_content(0, "Accused", PlayerInfo[playerid][pAccused], SQL, 255);
cache_get_field_content(0, "Crime1", PlayerInfo[playerid][pCrime1], SQL, 255);
cache_get_field_content(0, "Crime2", PlayerInfo[playerid][pCrime2], SQL, 255);
cache_get_field_content(0, "Crime3", PlayerInfo[playerid][pCrime3], SQL, 255);
PlayerInfo[playerid][pBTemp] = cache_get_field_content_int(0, "BTemp");
PlayerInfo[playerid][pBYear] = cache_get_field_content_int(0, "BYear");
PlayerInfo[playerid][pBMonth] = cache_get_field_content_int(0, "BMonth");
PlayerInfo[playerid][pBDay] = cache_get_field_content_int(0, "BDay");
cache_get_field_content(0, "BBy", PlayerInfo[playerid][pBBy], SQL, 255);
cache_get_field_content(0, "BReason", PlayerInfo[playerid][pBReason], SQL, 255);
PlayerInfo[playerid][pStatus] = cache_get_field_content_int(0, "Status");
PlayerInfo[playerid][pALeader] = cache_get_field_content_int(0, "ALeader");
PlayerInfo[playerid][pLanguage] = cache_get_field_content_int(0, "Language");
PlayerInfo[playerid][pClanTag] = cache_get_field_content_int(0, "ClanTag");
PlayerInfo[playerid][pFWorks] = cache_get_field_content_int(0, "FWorks");
PlayerInfo[playerid][pVirtualPD] = cache_get_field_content_int(0, "VirtualPD");
PlayerInfo[playerid][pGlasses] = cache_get_field_content_int(0, "Glasses");
PlayerInfo[playerid][pFactionTime] = cache_get_field_content_int(0, "FactionTime");
PlayerInfo[playerid][pCredits] = cache_get_field_content_int(0, "CreditsF");
PlayerInfo[playerid][pNMuted] = cache_get_field_content_int(0, "NMuted");
PlayerInfo[playerid][pHelpedPlayers] = cache_get_field_content_int(0, "HelpedPlayers");
PlayerInfo[playerid][pCommands] = cache_get_field_content_int(0, "Commands");
PlayerInfo[playerid][pHost] = cache_get_field_content_int(0, "Host");
PlayerInfo[playerid][pPhoneBlock] = cache_get_field_content_int(0, "PhoneBlock");
PlayerInfo[playerid][pHiddenColor] = cache_get_field_content_int(0, "HiddenColor");
PlayerInfo[playerid][pGiftTime] = cache_get_field_content_int(0, "GiftTime");
PlayerInfo[playerid][pHats] = cache_get_field_content_int(0, "Hats");
PlayerInfo[playerid][pFightStyle] = cache_get_field_content_int(0, "FightStyle");
PlayerInfo[playerid][pHUD1] = cache_get_field_content_int(0, "HUD1");
PlayerInfo[playerid][pHUD2] = cache_get_field_content_int(0, "HUD2");
PlayerInfo[playerid][pHUD3] = cache_get_field_content_int(0, "HUD3");
for(new ev=0; ev<50; ev++)
{
new strb[30];
format(strb, sizeof(strb),"Quest%d",ev);
QEvent[playerid][ev] = cache_get_field_content_int(0, strb);
}
}
else
{
new stringyy[320],
loginname[64];
GetPlayerName(playerid,loginname,sizeof(loginname));
gPlayerLogTries[playerid] -= 1;
if(gPlayerLogTries[playerid] == 1 || gPlayerLogTries[playerid] == 0)
{
format(stringyy,sizeof(stringyy),"{FF0000}Incorrect password. You have %d remaining login attempts left.", gPlayerLogTries[playerid]);
SendClientMessage(playerid, COLOR_RED, stringyy);
}
ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"SERVER: Login","Welcome to the s4uriK RPG Server.\n\nPlease enter your password below!","Login","Cancel");
if(gPlayerLogTries[playerid] == -1)
{
new stringkick[256];
format(stringkick, sizeof(stringkick), "AdmWarn: {FFFFFF}%s has been kicked for entering the wrong password 2 times.",loginname);
ABroadCast(COLOR_RED2,stringkick,1);
KickEx(playerid);
}
return 1;
}
