public OnPlayerConnect(playerid) { MySQLCheckConnection(); HideDateAndTimeForPlayer(playerid); UpdatePlayerRecord(); new GetUserName[MAX_PLAYER_NAME]; GetPlayerName(playerid, GetUserName, sizeof(GetUserName)); AFK[playerid]= 0; AntiFlood_InitPlayer(playerid); //texdrawurile nu are rost sa le pun /* [ Set default variable for player ] */ SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0; SelectCharID[playerid] = 0; SelectCharPlace[playerid] = 0; ChosenSkin[playerid] = 0; ApprovedAvocat[playerid] = 0; CallAvocat[playerid] = 0; WantAvocat[playerid] = 0; CP[playerid] = 0; TruckerCP[playerid] = 0; TruckerCash[playerid] = 0; BusLsCP[playerid] = 0; BusLvCP[playerid] = 0; GunoierLsCP[playerid] = 0; GunoierLvCP[playerid] = 0; TowCP[playerid] = 0; CheckpointRaceRemove[playerid] = 0; CheckpointRemove[playerid] = 0; Robbed[playerid] = 0; RobbedTime[playerid] = 0; SpawnChange[playerid] = 1; CarOffer[playerid] = 999; CarPrice[playerid] = 0; CarID[playerid] = 0; MoneyMessage[playerid] = 0; Condom[playerid] = 0; STDPlayer[playerid] = 0; SexOffer[playerid] = 999; SexPrice[playerid] = 0; RepairOffer[playerid] = 999; RepairPrice[playerid] = 0; RepairCar[playerid] = 0; TalkingLive[playerid] = 255; LiveOffer[playerid] = 999; TakingLesson[playerid] = 0; RefillOffer[playerid] = 999; RefillPrice[playerid] = 0; DrugOffer[playerid] = 999; DrugPrice[playerid] = 0; DrugGram[playerid] = 0; PlayerCuffed[playerid] = 0; PlayerCuffedTime[playerid] = 0; RegistrationStep[playerid] = 0; OnCK[playerid] = 999; GettingCK[playerid] = 999; ConnectedToPC[playerid] = 0; OrderReady[playerid] = 0; JailPrice[playerid] = 0; MedicBill[playerid] = 0; GotHit[playerid] = 0; GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0; OnDuty[playerid] = 0; tactical[playerid] = 0; swat[playerid] = 0; ChangePos2[playerid][1] = 0; SafeTime[playerid] = 60; PlayerTied[playerid] = 0; MedicCallTime[playerid] = 0; MechanicCallTime[playerid] = 0; FindTimePoints[playerid] = 0; FindTime[playerid] = 0; JobDuty[playerid] = 0; Mobile[playerid] = 255; Spectate[playerid] = 255; PlayerDrunk[playerid] = 0; PlayerDrunkTime[playerid] = 0; Unspec[playerid][sLocal] = 255; FishCount[playerid] = 0; ScriptMoney[playerid] = 0; ScriptMoneyUpdated[playerid] = 0; for (new c=0; c<13; c++) ScriptWeapons[playerid][c] = 0; gLastCar[playerid] = 0; gOoc[playerid] = 0; gNews[playerid] = 1; BigEar[playerid] = 0; gDice[playerid] = 0; gFam[playerid] = 1; gGas[playerid] = 1; gPlayerLogged[playerid] = 0; gPlayerLogTries[playerid] = 0; gPlayerAccount[playerid] = 0; gPlayerSpawned[playerid] = 0; PlayerTazeTime[playerid] = 0; PlayerStoned[playerid] = 0; TicketOffer[playerid] = 999; TicketMoney[playerid] = 0; MatsHolding[playerid] = 0; TutorialTime[playerid] = 0; ChatUsersPremium[playerid] = 1; NoFuel[playerid] = 0; CheckPlayerForHack[playerid] = 1; HireCar[playerid] = 299; SpawnPlayerAfterCheck[playerid] = 0; PlayerPaintballing[playerid] = 0; PlayerPaintballKills[playerid] = 0; Fishes[playerid][pLastFish] = 0; Fishes[playerid][pFishID] = 0; ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999; authorizeswat = 0; authorizetactical = 0; BugRefill[playerid] = 0; BugRepair[playerid] = 0; BugTicket[playerid] = 0; KnockedDown[playerid] = 0; UnidentifedCall[playerid] = 0; LicenseOffer[playerid] = 999; LicensePrice[playerid] = 0; LicenseType[playerid] = 0; UsingDrugs[playerid] = 0; AfterTutorial[playerid] = 0; AfterTutorial1[playerid] = 0; OwnableCarOffer[playerid] = 999; OwnableCarID[playerid] = 0; OwnableCarPrice[playerid] = 0; BlindFold[playerid] = 0; JustReported[playerid] = 0; PlayerAdminHelp[playerid] = 0; PlayerAgentHelp[playerid] = 0; AdminSpec[playerid] = 0; IsSmoking[playerid] = 0; UsingSmokeAnim[playerid] = 0; ReduceTime[playerid] = 0; Radar[playerid] = 0; SpeedLimit[playerid] = 0; PlayerCheckMoneyHack[playerid] = 0; PlayerWeaponProtection[playerid] = 0; TaxiCallTime[playerid] = 0; TaxiAccepted[playerid] = 999; TransportDuty[playerid] = 0; TransportValue[playerid] = 0; TransportMoney[playerid] = 0; TransportTime[playerid] = 0; TransportCost[playerid] = 0; TransportDriver[playerid] = 999; CheckKicked[playerid] = 0; WeaponToPlayer[playerid] = 999; WeaponOffer[playerid] = 999; WeaponIdOffer[playerid] = 0; WeaponPrice[playerid] = 0; WeaponAmount[playerid] = 0; WeaponMaterials[playerid] = 0; MatsToPlayer[playerid] = 999; MatsOffer[playerid] = 999; MatsPrice[playerid]= 0; MatsAmount[playerid]= 0; RobSession[playerid] = 0; PlayerInfo[playerid][pSQLID] = 0; PlayerInfo[playerid][pLevel] = 0; PlayerInfo[playerid][pAdmin] = 0; PlayerInfo[playerid][pPremiumAccount] = 0; PlayerInfo[playerid][gPupgrade] = 0; PlayerInfo[playerid][pConnectTime] = 0; PlayerInfo[playerid][pReg] = 0; PlayerInfo[playerid][pSex] = 0; PlayerInfo[playerid][pAge] = 0; PlayerInfo[playerid][pMuteTime] = 0; PlayerInfo[playerid][pExp] = 0; PlayerInfo[playerid][pAccount] = 0; PlayerInfo[playerid][pCrimes] = 0; PlayerInfo[playerid][pDeaths] = 0; PlayerInfo[playerid][pArrested] = 0; PlayerInfo[playerid][pWantedPoints] = 0; PlayerInfo[playerid][pWantedDeaths] = 0; PlayerInfo[playerid][pPhoneBook] = 0; PlayerInfo[playerid][pLottoNr] = 0; PlayerInfo[playerid][pFishes] = 0; PlayerInfo[playerid][pBiggestFish] = 0; PlayerInfo[playerid][pJob] = 0; PlayerInfo[playerid][pPayCheck] = 0; PlayerInfo[playerid][pHeadValue] = 0; PlayerInfo[playerid][pJailed] = 0; PlayerInfo[playerid][pJailTime] = 0; PlayerInfo[playerid][pMats] = 0; PlayerInfo[playerid][pDrugs] = 0; PlayerInfo[playerid][pLeader] = 0; PlayerInfo[playerid][pMember] = 0; PlayerInfo[playerid][pFMember] = 255; PlayerInfo[playerid][pRank] = 0; PlayerInfo[playerid][pChar] = 0; PlayerInfo[playerid][pContractTime] = 0; PlayerInfo[playerid][pDetSkill] = 0; PlayerInfo[playerid][pSexSkill] = 0; PlayerInfo[playerid][pLawSkill] = 0; PlayerInfo[playerid][pMechSkill] = 0; PlayerInfo[playerid][pJackSkill] = 0; PlayerInfo[playerid][pNewsSkill] = 0; PlayerInfo[playerid][pDrugsSkill] = 0; PlayerInfo[playerid][pCookSkill] = 0; PlayerInfo[playerid][pFishSkill] = 0; PlayerInfo[playerid][pRobSkill] = 0; PlayerInfo[playerid][pInt] = 15; PlayerInfo[playerid][pLocal] = 255; PlayerInfo[playerid][pTeam] = 3; PlayerInfo[playerid][pModel] = 62; new randphone = 100000 + random(999999); PlayerInfo[playerid][pPnumber] = randphone; PlayerInfo[playerid][pPhousekey] = 255; PlayerInfo[playerid][pPcarkey1] = -1; PlayerInfo[playerid][pPcarkey2] = -1; PlayerInfo[playerid][pCurentKey] = -1; PlayerInfo[playerid][pPbiskey] = 255; PlayerInfo[playerid][pCarLic] = 0; PlayerInfo[playerid][pFlyLic] = 0; PlayerInfo[playerid][pBoatLic] = 0; PlayerInfo[playerid][pFishLic] = 0; PlayerInfo[playerid][pGunLic] = 0; PlayerInfo[playerid][pMatsLic] = 0; PlayerInfo[playerid][pCarLicS] = 0; PlayerInfo[playerid][pFlyLicS] = 0; PlayerInfo[playerid][pBoatLicS] = 0; PlayerInfo[playerid][pFishLicS] = 0; PlayerInfo[playerid][pGunLicS] = 0; PlayerInfo[playerid][pMatsLicS] = 0; PlayerInfo[playerid][pGun1] = 0; PlayerInfo[playerid][pGun2] = 0; PlayerInfo[playerid][pGun3] = 0; PlayerInfo[playerid][pGun4] = 0; PlayerInfo[playerid][pGun5] = 0; PlayerInfo[playerid][pGun6] = 0; PlayerInfo[playerid][pAmmo1] = 0; PlayerInfo[playerid][pAmmo2] = 0; PlayerInfo[playerid][pAmmo3] = 0; PlayerInfo[playerid][pAmmo4] = 0; PlayerInfo[playerid][pAmmo5] = 0; PlayerInfo[playerid][pAmmo6] = 0; PlayerInfo[playerid][pPayDay] = 0; PlayerInfo[playerid][pPayDayHad] = 0; PlayerInfo[playerid][pWins] = 0; PlayerInfo[playerid][pLoses] = 0; PlayerInfo[playerid][pAlcoholPerk] = 0; PlayerInfo[playerid][pDrugPerk] = 0; PlayerInfo[playerid][pMiserPerk] = 0; PlayerInfo[playerid][pPainPerk] = 0; PlayerInfo[playerid][pTraderPerk] = 0; PlayerInfo[playerid][pTut] = 0; PlayerInfo[playerid][pWarns] = 0; PlayerInfo[playerid][pFACWarns] = 0; PlayerInfo[playerid][pFpunish] = 0; PlayerInfo[playerid][pAdjustable] = 0; PlayerInfo[playerid][pFuel] = 0; PlayerInfo[playerid][pRequestingBackup] = 0; PlayerInfo[playerid][pAlawyer] = 0; PlayerInfo[playerid][pLimba] = 1; PlayerInfo[playerid][pTow] = 1; PlayerInfo[playerid][pGlasses] = 0; PlayerInfo[playerid][pMaskuse] = 0; PlayerInfo[playerid][pPos_x] = 2246.6; PlayerInfo[playerid][pPos_y] = -1161.9; PlayerInfo[playerid][pPos_z] = 1029.7; PlayerInfo[playerid][pSHealth] = 0.0; PlayerInfo[playerid][pHealth] = 50.0; PlayerInfo[playerid][pArmour] = 0.0; /* [ Load Function's ] */ ClearCrime(playerid); ClearFishes(playerid); SetPlayerColor(playerid, COLOR_GRAD2); HouseEntered[playerid] = 255; /* [ MySQL Check Account ] */ new BanDetails[255], PlayerIP[16], year, month,day, hour, minute, second new QuerySelect_Here[255], QueryUpdate_Here[255]; getdate(year, month, day); gettime(hour, minute, second); GetPlayerIp(playerid, PlayerIP, sizeof(PlayerIP)); format(QuerySelect_Here, sizeof(QuerySelect_Here), "SELECT * FROM banuri WHERE BanIpPermanently = 1 AND PlayerIP = '%s'", PlayerIP); mysql_query(QuerySelect_Here); mysql_store_result(); new sqlaccountstatus = MySQLCheckAccount(GetUserName); MySQLCheckAccountDetails(sqlaccountstatus, playerid); MySQLCheckLanguageAccount(sqlaccountstatus, playerid) if(sqlaccountstatus != 0) { if(MySQLCheckAccountLocked(sqlaccountstatus, playerid) != 0) { if(PlayerInfo[playerid][pBanAccountPermanently] == 1) { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned permanently by Admin %s, reason: %s. Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason], PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } if(PlayerInfo[playerid][pBanTemporaly] == 1) { if(PlayerInfo[playerid][pBanYearExpired] != 0) { if(PlayerInfo[playerid][pBanYearExpired] <= year) { if(PlayerInfo[playerid][pBanYearExpired] < year) { format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "DELETE FROM banuri WHERE LOWER(Name) = LOWER('%s')", GetUserName); mysql_query(QueryUpdate_Here); } else if(PlayerInfo[playerid][pBanYearExpired] == year) { if(PlayerInfo[playerid][pBanMonthExpired] < month) { format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "DELETE FROM banuri WHERE LOWER(Name) = LOWER('%s')", GetUserName); mysql_query(QueryUpdate_Here); } else if(PlayerInfo[playerid][pBanMonthExpired] == month) { if(PlayerInfo[playerid][pBanDayExpired] < day) { format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "DELETE FROM banuri WHERE LOWER(Name) = LOWER('%s')", GetUserName); mysql_query(QueryUpdate_Here); } else if(PlayerInfo[playerid][pBanDayExpired] == day) { if(PlayerInfo[playerid][pBanHourExpired] < hour) { format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "DELETE FROM banuri WHERE LOWER(Name) = LOWER('%s')", GetUserName); mysql_query(QueryUpdate_Here); } else if(PlayerInfo[playerid][pBanHourExpired] == hour) { if(PlayerInfo[playerid][pBanMinuiteExpired] < minute) { format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "DELETE FROM banuri WHERE LOWER(Name) = LOWER('%s')", GetUserName); mysql_query(QueryUpdate_Here); } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } else { TogglePlayerSpectating(playerid, 1); format(BanDetails, sizeof(BanDetails), "This account (%s) is banned by Admin %s, reason: %s.", PlayerInfo[playerid][pName], PlayerInfo[playerid][pAdminBan], PlayerInfo[playerid][pBanReason]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban received at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourReceived], PlayerInfo[playerid][pBanMinuiteReceived], PlayerInfo[playerid][pBanSecoundReceived], PlayerInfo[playerid][pBanDayReceived], PlayerInfo[playerid][pBanMonthReceived], PlayerInfo[playerid][pBanYearReceived]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); format(BanDetails, sizeof(BanDetails), "Ban expired at: %d:%d:%d %d/%d/%d.", PlayerInfo[playerid][pBanHourExpired], PlayerInfo[playerid][pBanMinuiteExpired], PlayerInfo[playerid][pBanSecoundExpired], PlayerInfo[playerid][pBanDayExpired], PlayerInfo[playerid][pBanMonthExpired], PlayerInfo[playerid][pBanYearExpired]); SendClientMessage(playerid, COLOR_LIGHTBLUE, BanDetails); SendClientMessage(playerid, COLOR_LIGHTBLUE, "Post an unban request on our forum: www.pro-gaming.ro"); SetTimerEx("KickPublic", 1000, 0, "d", playerid); return 0; } } } } gPlayerAccount[playerid] = 1; PlayerInfo[playerid][pSQLID] = sqlaccountstatus; TogglePlayerSpectating(playerid, 1); new InfoDialogString_Here[500]; if(PlayerInfo[playerid][pLimba] == 1) { format(InfoDialogString_Here, sizeof(InfoDialogString_Here), "- {BECBFC}Bun venit inapoi, {95A3FF}%s{BECBFC}.\n\n{BECBFC}- Acest cont este inregistrat.\n\n{BECBFC}- Id-ul contului: [%d].\n{BECBFC}- Ultima logare: [%s].\n{BECBFC}- Data inregistrarii: [%s].\n\n{BECBFC}- Va rugam sa introduceti parola contului dvs. оn cгsuta de mai jos.", GetUserName, PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pUltLog], PlayerInfo[playerid][pDateReg]); ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logare cont", InfoDialogString_Here, "Login", "Exit"); } else if(PlayerInfo[playerid][pLimba] == 2) { format(InfoDialogString_Here, sizeof(InfoDialogString_Here), "- {BECBFC}Welcome back, {95A3FF}%s{BECBFC}.\n\n{BECBFC}- This account is registered.\n\n{BECBFC}- Account ID: [%d].\n{BECBFC}- Last login: [%s].\n{BECBFC}- Joined date: [%s].\n\n{BECBFC}- Please enter your account password in the box below.", GetUserName, PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pUltLog], PlayerInfo[playerid][pDateReg]); ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Account login", InfoDialogString_Here, "Login", "Exit"); } } else { gPlayerAccount[playerid] = 0; TogglePlayerSpectating(playerid, 1); new InfoDialogString_Here[500]; format(InfoDialogString_Here, sizeof(InfoDialogString_Here),"- {BECBFC}Welcome, {95A3FF}%s{BECBFC}.\n\n- {BECBFC}This account is not registered.\n\n- {BECBFC}Please choose a password for this account.", GetUserName); ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", InfoDialogString_Here, "Register", "Exit"); } return 1; } /* [ Server Stats STOCK ] */ stock GetOnlinePlayers() { new count; for (new i = 0; i < MAX_PLAYERS; i ++) count += IsPlayerConnected(i); return count; } stock UpdatePlayerRecord() { new GetPlayerRecord = ServerStats[1][ssplayersrecord]; new recordplayers = GetOnlinePlayers(); if(recordplayers <= GetPlayerRecord) return; UpdateRecordDate(); new QueryUpdate_Here[255]; ServerStats[1][ssplayersrecord] = recordplayers; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET playersrecord = '%d' WHERE id = '1'", ServerStats[1][ssplayersrecord]); mysql_query(QueryUpdate_Here); } stock UpdateRecordDate() { new QueryUpdate_Here[255], FormatString_Here[64]; new d,m,mo,y,h,s; getdate(y,mo,d); gettime(h,m,s); format(FormatString_Here, sizeof(FormatString_Here), "%02d/%02d/%d %02d:%02d", d,mo,y,h,m); ServerStats[1][ssrecorddate] = FormatString_Here; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET recorddate = '%s' WHERE id = '1'", ServerStats[1][ssrecorddate]); mysql_query(QueryUpdate_Here); } stock UpdateAccountNumber() { new QueryUpdate_Here[255]; new accounts = ServerStats[1][ssacounts]+1; ServerStats[1][ssacounts] = accounts; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET accounts = '%d' WHERE id = '1'", ServerStats[1][ssacounts]); mysql_query(QueryUpdate_Here); } stock UpdateBannedNumber() { new QueryUpdate_Here[255]; new bannednumber = ServerStats[1][ssbanned]+1; ServerStats[1][ssbanned] = bannednumber; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET banned = '%d' WHERE id = '1'", ServerStats[1][ssbanned]); mysql_query(QueryUpdate_Here); } stock UpdateNewestPlayer(playerid) { new NewestPLAYER[24], QueryUpdate_Here[255]; GetPlayerName(playerid, NewestPLAYER, sizeof(NewestPLAYER)); ServerStats[1][ssnewest] = NewestPLAYER; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET newest = '%s' WHERE id = '1'", NewestPLAYER); mysql_query(QueryUpdate_Here); } stock UpdateCarsNumber() { new QueryUpdate_Here[255]; new newcars = ServerStats[1][sscars]+1; ServerStats[1][sscars] = newcars; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE serverstats SET cars = '%d' WHERE id = '1'", ServerStats[1][sscars]); mysql_query(QueryUpdate_Here); }
public OnPlayerLogin(playerid,password[]) { MySQLCheckConnection(); new GetUserName[MAX_PLAYER_NAME], hour, minute, second, year, month, day, string128[128], string256[256], parolacript[129], zero1[5], zero2[5], zero3[5], zero4[5], AccountIP[32]; new QueryUpdate_Here[255]; gettime(hour, minute, second); getdate(year, month, day); WP_Hash(parolacript, sizeof(parolacript), password); MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]); if(!strcmp(PlayerInfo[playerid][pKey],parolacript, false) && strlen(parolacript) != 0) { new QuerySelect_Here[768]; format(QuerySelect_Here, sizeof(QuerySelect_Here), "SELECT * FROM players WHERE id = '%d'", PlayerInfo[playerid][pSQLID]); mysql_query(QuerySelect_Here); mysql_store_result(); if(mysql_num_rows()) if(mysql_fetch_row_format(QuerySelect_Here, "|")) { sscanf(QuerySelect_Here, "p<|>e<is[24]s[130]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiis[24]s[128]s[128]s[24]ffffffis[24]ii>", PlayerInfo[playerid]); } MySQLCheckAccountDetails(PlayerInfo[playerid][pSQLID], playerid); } else { new AttemptsRemaining[20]; if(gPlayerLogTries[playerid] == 0) { AttemptsRemaining = "3/3"; } else if(gPlayerLogTries[playerid] == 1) { AttemptsRemaining = "2/3"; } else if(gPlayerLogTries[playerid] == 2) { AttemptsRemaining = "1/3"; } GetPlayerName(playerid, GetUserName, sizeof(GetUserName)); format(string256, sizeof(string256), "- Incorrect password for this account: [{95A3FF}%s{BECBFC}].\n\n- Attempts remaining: [%s].\n\n- Please enter your password carefully.", GetUserName, AttemptsRemaining); ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Conectare cont", string256, "Logare", "Iesire"); gPlayerLogTries[playerid] += 1; if(gPlayerLogTries[playerid] == 4) { Ban(playerid); } return true; } if(hour < 10) { zero1 = "0"; } if(minute < 10) { zero2 = "0"; } if(day < 10) { zero3 = "0"; } if(month < 10) { zero4 = "0"; } format(string128, sizeof(string128), "%s%d:%s%d %s%d.%s%d.%d", zero1, hour, zero2, minute, zero3, day, zero4, month, year); strmid(PlayerInfo[playerid][pUltLog], string128, 0, strlen(string128), 255); GetPlayerIp(playerid, AccountIP, sizeof(AccountIP)); PlayerInfo[playerid][pPlayerOnline] = 1; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE players SET UltLog = '%s', ip = '%s', PlayerOnline = '%d' WHERE id = '%d'", PlayerInfo[playerid][pUltLog], AccountIP, PlayerInfo[playerid][pPlayerOnline], PlayerInfo[playerid][pSQLID]); mysql_query(QueryUpdate_Here); if(PlayerInfo[playerid][pLeader] >= 1) { LeaderInfo[PlayerInfo[playerid][pLeader]][lStats] = 1; format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE leaders SET stats = '%d' WHERE id = '%d'", LeaderInfo[PlayerInfo[playerid][pLeader]][lStats], LeaderInfo[PlayerInfo[playerid][pLeader]][lId]); mysql_query(QueryUpdate_Here); } if(PlayerInfo[playerid][pReg] == 0) { PlayerInfo[playerid][pLevel] = 1; PlayerInfo[playerid][pInt] = 0; PlayerInfo[playerid][pHealth] = 100; PlayerInfo[playerid][pLocal] = 255; PlayerInfo[playerid][pTeam] = 3; PlayerInfo[playerid][pModel] = 74; new randphone = 1000000 + random(8999999); PlayerInfo[playerid][pPnumber] = randphone; PlayerInfo[playerid][pPhousekey] = 255; PlayerInfo[playerid][pPbiskey] = 255; PlayerInfo[playerid][pWantedLevel] = 0; PlayerInfo[playerid][pReg] = 1; PlayerInfo[playerid][pLevel] = ServerConfig[1][sPStartLevel]; PlayerInfo[playerid][pCash] = ServerConfig[1][sPMoneyCash]; PlayerInfo[playerid][pAccount] = ServerConfig[1][SPBankCash]; format(string128, sizeof(string128), "%d/%d/%d %d:%d:%d", day, month, year, hour, minute, second); strmid(PlayerInfo[playerid][pDateReg], string128, 0, strlen(string128), 255); format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE players SET PlayerLevel = '1', Interior = '0', pHealth = '100', Local = '255' WHERE id = '%d'", PlayerInfo[playerid][pSQLID]); mysql_query(QueryUpdate_Here); format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE players SET Team = '3', Model = '250', PhoneNr = '%d', House = '255' WHERE id = '%d'", PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pSQLID]); mysql_query(QueryUpdate_Here); format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE players SET Bizz = '255', WantedLevel = '0', Registered = '1', DateReg = '%s' WHERE id = '%d'", PlayerInfo[playerid][pDateReg], PlayerInfo[playerid][pSQLID]); mysql_query(QueryUpdate_Here); format(QueryUpdate_Here, sizeof(QueryUpdate_Here), "UPDATE players SET PlayerLevel = '%d', Money = '%d', Bank = '%d' WHERE id = '%d'", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount], PlayerInfo[playerid][pSQLID]); mysql_query(QueryUpdate_Here); } if(PlayerInfo[playerid][pLevel] == -999) { Ban(playerid); } ClearChatbox(playerid, 10); if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "SERVER: Bun Venit %s !", PlayerInfo[playerid][pName]); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "SERVER: Welcome %s !", PlayerInfo[playerid][pName]); } SendClientMessage(playerid, COLOR_WHITE, string128); if (PlayerInfo[playerid][pAdmin] > 0) { if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "SERVER: Te-ai logat cu level %d admin !", PlayerInfo[playerid][pAdmin]); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "SERVER: You are logged in as a Level %d Admin !", PlayerInfo[playerid][pAdmin]); } SendClientMessage(playerid, COLOR_WHITE, string128); } if (PlayerInfo[playerid][pAgent] >= 1) { if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "SERVER: Te-ai logat cu agent !"); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "SERVER: You are logged in as a Agent !"); } SendClientMessage(playerid, COLOR_WHITE, string128); } if (PlayerInfo[playerid][pPremiumAccount] >= 1) { if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "SERVER: Tu esti un utilizator premium !"); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "SERVER: You are a Premium Account user !"); } SendClientMessage(playerid, COLOR_WHITE, string128); } if (PlayerInfo[playerid][pWantedLevel] > 0) { if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "SERVER: Ai primit inapoi %d puncte de urmarire !", PlayerInfo[playerid][pWantedLevel]); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "SERVER: You have received back %d wanted points !", PlayerInfo[playerid][pWantedLevel]); } SendClientMessage(playerid, COLOR_LIGHTRED, string128); } if(PlayerInfo[playerid][pLevel] >= 0) { GetPlayerName(playerid, GetUserName, sizeof(GetUserName)); format(string128, sizeof(string128), "%s was logged on server with ip %s.", GetUserName, AccountIP); ABroadCast(COLOR_ORANGE, string128, 1); } if(PlayerInfo[playerid][pPcarkey1] == -1) { PlayerInfo[playerid][pCurentKey] = PlayerInfo[playerid][pPcarkey2]; } else if(PlayerInfo[playerid][pPcarkey2] == -1) { PlayerInfo[playerid][pCurentKey] = PlayerInfo[playerid][pPcarkey1]; } gPlayerLogged[playerid] = 1; TogglePlayerSpectating(playerid, 0); SetSpawnInfo(playerid, PlayerInfo[playerid][pTeam], PlayerInfo[playerid][pModel], PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], 1.0, -1, -1, -1, -1, -1, -1); SpawnPlayer(playerid); GivePlayerMoney(playerid, -GetPlayerMoney(playerid)); SetPlayerCash(playerid); DisablePlayerCheckpoint(playerid); StopAudioStreamForPlayer(playerid); SetPlayerVirtualWorld(playerid, 0); TextDrawHideForPlayer(playerid, SrvStats[1]); TextDrawHideForPlayer(playerid, SrvStats[2]); if(gTeam[playerid] == 0) { gTeam[playerid] = 3; } else { gTeam[playerid] = PlayerInfo[playerid][pTeam]; } if(PlayerInfo[playerid][pLimba] == 1) { format(string128, sizeof(string128), "~n~~n~~n~~n~~n~~n~~n~~n~~w~Bun Venit ~y~%s !", PlayerInfo[playerid][pName]); } else if(PlayerInfo[playerid][pLimba] == 2) { format(string128, sizeof(string128), "~n~~n~~n~~n~~n~~n~~n~~n~~w~Welcome ~y~%s !", PlayerInfo[playerid][pName]); } GameTextForPlayer(playerid, string128, 4000, 5); DateProp(playerid); foreach(Player, i) { if(IsPlayerConnected(i)) { if(PlayerInfo[i][pMaskuse] == 1) { ShowPlayerNameTagForPlayer(playerid, i, 0); } } } return true; }
is not defined now but I tried to define it, and the problem wasn't solved.
|