myslq sistem problem - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: myslq sistem problem (/showthread.php?tid=302031)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: myslq sistem problem (/showthread.php?tid=302031)
myslq sistem problem - EleMenTalL - 07.12.2011
Hy, i need someone to help me with the mysql sistem, i can`t get it run..
i don`t get error etc, my sistem register players on db etc
but after register i don`t get a box where to put my password and login, and if i re-connect, the server put me again to register and so on..
I need someone that know how to make a mysql sistem, who is interest to help me to replace my current mysql sistem please pm me.
Re: myslq sistem problem - Thresholdold - 07.12.2011
When a player registers is it saving to your scriptfiles? It sounds like when a player registers, it doesn't get saved in their accounts...
Re: myslq sistem problem - THE_KNOWN - 07.12.2011
Post your OnPlayerConnect dialogs with the Account checking code.
Re: myslq sistem problem - EleMenTalL - 07.12.2011
Quote:
|
public OnPlayerConnect(playerid) { new plname[MAX_PLAYER_NAME]; GetPlayerName(playerid, plname, sizeof(plname)); AFK[playerid]=0; if(Security != 0) { SendClientMessage(playerid, COLOR_YELLOW, "Host has broken one of the Agreement rules, action has been taken."); Kick(playerid); return 1; } { PermisAnunt[playerid] = 1; // Cand jucatorul se conecteaza, ii atribuim valoarea 1 pentru ca acesta sa poata da anunt. } TextDrawShowForPlayer(playerid, Ceas0); TextDrawShowForPlayer(playerid, Ceas1); TextDrawShowForPlayer(playerid, Ceas2); TextDrawShowForPlayer(playerid, Zi); TextDrawShowForPlayer(playerid, luna); TextDrawShowForPlayer(playerid, an); TextDrawShowForPlayer(playerid, Data3); TextDrawShowForPlayer(playerid, Data4); SetVehicleNumberPlate(examc, " School"); ResetPlayerCash(playerid); //Resetting the players cash variable to zero. gActivePlayers[playerid]++; numplayers++; new string[MAX_PLAYER_NAME]; SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0; SelectCharID[playerid] = 0; SelectCharPlace[playerid] = 0; ChosenSkin[playerid] = 0; GettingJob[playerid] = 0; GuardOffer[playerid] = 999; GuardPrice[playerid] = 0; ApprovedLawyer[playerid] = 0; CallLawyer[playerid] = 0; WantLawyer[playerid] = 0; KickPlayer[playerid] = 0; CurrentMoney[playerid] = 0; UsedFind[playerid] = 0; CP[playerid] = 0; Robbed[playerid] = 0; SpawnChange[playerid] = 1; CarOffer[playerid] = 999; CarPrice[playerid] = 0; CarID[playerid] = 0; CarCalls[playerid] = 0; RobbedTime[playerid] = 0; MoneyMessage[playerid] = 0; Condom[playerid] = 0; Rope[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; MapIconsShown[playerid] = 0; DrugOffer[playerid] = 999; PlayerCuffed[playerid] = 0; PlayerCuffedTime[playerid] = 0; DrugPrice[playerid] = 0; RegistrationStep[playerid] = 0; OnCK[playerid] = 999; GettingCK[playerid] = 999; DrugGram[playerid] = 0; ConnectedToPC[playerid] = 0; OrderReady[playerid] = 0; JailPrice[playerid] = 0; MedicTime[playerid] = 0; MedicBill[playerid] = 0; GotHit[playerid] = 0; WantedPoints[playerid] = 0; WantedPoints[playerid] = 0; GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0; OnDuty[playerid] = 0; /*WantedLevel[playerid] = 0;*/ tactical[playerid] = 0; swat[playerid] = 0; TestFishes[playerid] = 0; BoxWaitTime[playerid] = 0; SchoolSpawn[playerid] = 0; ChangePos2[playerid][1] = 0; SafeTime[playerid] = 60; TransportDuty[playerid] = 0; PlayerTied[playerid] = 0; BusCallTime[playerid] = 0; TaxiCallTime[playerid] = 0; MedicCallTime[playerid] = 0; MechanicCallTime[playerid] = 0; BusrouteEast[playerid][0] = 0; BusrouteWest[playerid][0] = 0; BusShowLocation[playerid][0] = 0; BusShowLocationC[playerid] = 0; FindTimePoints[playerid] = 0; FindTime[playerid] = 0; JobDuty[playerid] = 0; Mobile[playerid] = 255; Music[playerid] = 0; BoxOffer[playerid] = 999; PlayerBoxing[playerid] = 0; Spectate[playerid] = 255; PlayerDrunk[playerid] = 0; PlayerDrunkTime[playerid] = 0; Unspec[playerid][sLocal] = 255; FishCount[playerid] = 0; WritingPaper[playerid] = 0; WritingPaperNumber[playerid] = 999; WritingLine[playerid] = 0; BringingPaper[playerid] = 0; GotPaper[playerid] = 0; PaperOffer[playerid] = 999; /*ConsumingMoney[playerid] = 0;*/ ScriptMoney[playerid] = 0; ScriptMoneyUpdated[playerid] = 0; for (new c=0; c<13; c++) ScriptWeapons[playerid][c] = 0; ScriptWeaponsUpdated[playerid] = 0; gLastCar[playerid] = 0; FirstSpawn[playerid] = 1; gOoc[playerid] = 0; gNews[playerid] = 0; BigEar[playerid] = 0; gDice[playerid] = 0; gFam[playerid] = 0; gSpeedo[playerid] = 0; gGas[playerid] = 1; gPlayerLogged[playerid] = 0; gPlayerLogTries[playerid] = 0; gPlayerAccount[playerid] = 0; gPlayerSpawned[playerid] = 0; PlayerKarting[playerid] = 0; PlayerInKart[playerid] = 0; PlayerTazeTime[playerid] = 0; PlayerStoned[playerid] = 0; StartTime[playerid] = 0; TicketOffer[playerid] = 999; TicketMoney[playerid] = 0; MatsHolding[playerid] = 0; TutTime[playerid] = 0; gPlayerMission[playerid] = 0; TaxiAccepted[playerid] = 999; BusAccepted[playerid] = 999; PlayerInfo[playerid][pCash] = dollah; NoFuel[playerid] = 0; HireCar[playerid] = 299; GangCar[playerid] = 512; PlayersChannel[playerid] = 999; TransportValue[playerid] = 0; TransportMoney[playerid] = 0; TransportTime[playerid] = 0; TransportCost[playerid] = 0; TransportDriver[playerid] = 999; Locator[playerid] = 0; PlayerOnMission[playerid] = 0; MissionCheckpoint[playerid] = 0; WatchingTV[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; GivePlayerCash(playerid,PlayerInfo[playerid][pCash]); tactical[playerid] = 0; swat[playerid] = 0; authorizetactical = 0; PizzaCallTime[playerid] = 0; bPizza[playerid] = 0; sPizza[playerid] = 0; FarmerVar[playerid] = 0; FarmerPickup[playerid][0] = 0; JustDied[playerid] = 0; KnockedDown[playerid] = 0; UnidentifedCall[playerid] = 0; LicenseOffer[playerid] = 999; Robbed[playerid] = 0; LicensePrice[playerid] = 0; LicenseType[playerid] = 0; UsingDrugs[playerid] = 0; AfterTutorial[playerid] = 0; OwnableCarOffer[playerid] = 999; OwnableCarID[playerid] = 0; OwnableCarPrice[playerid] = 0; BlindFold[playerid] = 0; PlayerIsSweeping[playerid] = 0; AdminDuty[playerid] = 0; JustReported[playerid] = 0; PlayerNeedsHelp[playerid] = 0; AdminSpec[playerid] = 0; IsSmoking[playerid] = 0; UsingSmokeAnim[playerid] = 0; ReduceTime[playerid] = 0; RobbedTime[playerid] = 0; CreatingGun[playerid] = 0; CreatingGunAmmo[playerid] = 0; CreatingGunPrice[playerid] = 0; IsPuttingMaterials[playerid] = 0; IsTakingGun[playerid] = 0; InAFoodPlace[playerid] = 0; PlayerInfo[playerid][pLevel] = 0; PlayerInfo[playerid][pAdmin] = 0; PlayerInfo[playerid][pDonateRank] = 0; PlayerInfo[playerid][gPupgrade] = 0; PlayerInfo[playerid][pConnectTime] = 0; PlayerInfo[playerid][pRobSkill] = 0; PlayerInfo[playerid][pRob] = 0; PlayerInfo[playerid][pReg] = 0; PlayerInfo[playerid][pSex] = 0; PlayerInfo[playerid][pAge] = 0; PlayerInfo[playerid][pOrigin] = 0; PlayerInfo[playerid][pExp] = 0; PlayerInfo[playerid][pAccount] = 0; PlayerInfo[playerid][pAccf] = 0; PlayerInfo[playerid][pCrimes] = 0; PlayerInfo[playerid][pDeaths] = 0; PlayerInfo[playerid][pArrested] = 0; PlayerInfo[playerid][pWantedDeaths] = 0; PlayerInfo[playerid][pWantedLevel] = 0; PlayerInfo[playerid][pWantedPoints] = 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][pWantedPoints] = 0; PlayerInfo[playerid][pLeader] = 0; PlayerInfo[playerid][pMember] = 0; PlayerInfo[playerid][pCLeader] = 0; PlayerInfo[playerid][pCMember] = 0; PlayerInfo[playerid][pFMember] = 255; PlayerInfo[playerid][pRank] = 0; PlayerInfo[playerid][pCRank] = 0; PlayerInfo[playerid][pChar] = 0; PlayerInfo[playerid][pContractTime] = 0; PlayerInfo[playerid][pDetSkill] = 0; PlayerInfo[playerid][pSexSkill] = 0; PlayerInfo[playerid][pBoxSkill] = 0; PlayerInfo[playerid][pLawSkill] = 0; PlayerInfo[playerid][pMechSkill] = 0; PlayerInfo[playerid][pJackSkill] = 0; PlayerInfo[playerid][pCarSkill] = 0; PlayerInfo[playerid][pNewsSkill] = 0; PlayerInfo[playerid][pDrugsSkill] = 0; PlayerInfo[playerid][pCookSkill] = 0; PlayerInfo[playerid][pFishSkill] = 0; PlayerInfo[playerid][pSHealth] = 0.0; PlayerInfo[playerid][pHealth] = 50.0; PlayerInfo[playerid][pPos_x] = 1612.3240; PlayerInfo[playerid][pPos_y] = -2330.1670; PlayerInfo[playerid][pPos_z] = 13.5469; PlayerInfo[playerid][pInt] = 0; PlayerInfo[playerid][pLocal] = 255; PlayerInfo[playerid][pTeam] = 3; PlayerInfo[playerid][pModel] = 7; new randphone = 1000 + random(8999);//minimum 1000 max 9999 //giving one at the start PlayerInfo[playerid][pPnumber] = randphone; PlayerInfo[playerid][pPcarkey] = 999; PlayerInfo[playerid][pPcarkey2] = 999; PlayerInfo[playerid][pPcarkey3] = 999; PlayerInfo[playerid][pPhousekey] = 255; PlayerInfo[playerid][pGangKey] = 255; PlayerInfo[playerid][pPbiskey] = 255; PlayerInfo[playerid][pCarLic] = 0; PlayerInfo[playerid][pTow] = 1; PlayerInfo[playerid][pFlyLic] = 0; PlayerInfo[playerid][pBoatLic] = 0; PlayerInfo[playerid][pFishLic] = 0; PlayerInfo[playerid][pGunLic] = 0; PlayerInfo[playerid][pGun1] = 0; PlayerInfo[playerid][pGun2] = 0; PlayerInfo[playerid][pGun3] = 0; PlayerInfo[playerid][pGun4] = 0; PlayerInfo[playerid][pAmmo1] = 0; PlayerInfo[playerid][pAmmo2] = 0; PlayerInfo[playerid][pAmmo3] = 0; PlayerInfo[playerid][pAmmo4] = 0; PlayerInfo[playerid][pCarTime] = 0; PlayerInfo[playerid][pPayDay] = 0; PlayerInfo[playerid][pPayDayHad] = 0; PlayerInfo[playerid][pWatch] = 0; PlayerInfo[playerid][pCrashed] = 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][pMissionNr] = 0; PlayerInfo[playerid][pWarns] = 0; PlayerInfo[playerid][pFwarn] = 0; PlayerInfo[playerid][pFuel] = 0; PlayerInfo[playerid][pVirWorld] = 0; PlayerInfo[playerid][pRequestingBackup] = 0; PlayerInfo[playerid][pRoadblock] = 0; PlayerInfo[playerid][pFishTool] = 0; PlayerInfo[playerid][pInvWeapon] = 0; PlayerInfo[playerid][pInvAmmo] = 0; PlayerInfo[playerid][pLighter] = 0; PlayerInfo[playerid][pCigarettes] = 0; PlayerInfo[playerid][pMask] = 0; PlayerInfo[playerid][pMaskuse] = 0; PlayerInfo[playerid][pHideNumber] = 0; PlayerInfo[playerid][pSpeaker] = 0; PlayerInfo[playerid][pLocked] = 0; PlayerInfo[playerid][pPunish] = 0; PlayerInfo[playerid][pMatsLic] = 0; PlayerInfo[playerid][pSQLID] = 0; PlayerInfo[playerid][pRented] = 0; PlayerInfo[playerid][pAlarm] = 0; ClearCrime(playerid); ClearFishes(playerid); ClearCooking(playerid); ClearGroceries(playerid); ClearMarriage(playerid); SetPlayerColor(playerid,COLOR_GRAD2); HouseEntered[playerid] = 255; for(new h = 184; h < sizeof(CarInfo); h++) { SetVehicleParamsForPlayer(h,playerid,0,CarInfo[h][cLock]); } GetPlayerName(playerid, plname, sizeof(plname)); format(string, sizeof(string), "users/%s.ini", plname); SendClientMessage(playerid, COLOR_YELLOW, "Bun venit pe Star Gaming"); if(IsGameStarted == 1) { if(CashboxOwner == INVALID_PLAYER_ID) { if(mode == 1) { SetPlayerCheckpoint(playerid, CashboxX, CashboxY, CashboxZ, 1); } } } if(fexist(string)) { gPlayerAccount[playerid] = 1; new loginstring[128]; new loginname[64]; GetPlayerName(playerid,loginname,sizeof(loginname) ); format(loginstring,sizeof(loginstring),"{FFFFFF}We lcome, {FFAF00}%s\n{FFFFFF}That nick is registered.\nYou can now login:",loginname); ShowPlayerDialog(playerid,12346,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit"); return 1; } else { gPlayerAccount[playerid] = 0; new regstring[128]; new regname[64]; GetPlayerName(playerid,regname,sizeof(regname)); format(regstring,sizeof(regstring),"{FFFFFF}Welcom e, {FFAF00}%s\n{FFFFFF}You dont have an account.\nPlease register:",regname); ShowPlayerDialog(playerid,12345,DIALOG_STYLE_INPUT ,"Register",regstring,"Register","Exit"); return 1; } //MySQLCheckConnection(); // Check if the account exists new sqlaccountstatus = MySQLCheckAccount(plname); if(sqlaccountstatus != 0) { // Check if the account is locked if (MySQLCheckAccountLocked(sqlaccountstatus) != 0) { SendClientMessage(playerid, COLOR_LIGHTRED, "This account has been locked and cannot be accessed. Please contact an admin."); Kick(playerid); return 0; } gPlayerAccount[playerid] = 1; PlayerInfo[playerid][pSQLID] = sqlaccountstatus; } else { gPlayerAccount[playerid] = 0; } return 1; } |
Quote:
|
forward MySQLCheckAccount(sqlplayersname[]); forward MySQLCheckAccountLocked(sqlplayerid); forward MySQLCheckIPBanned(ip[]); |
Quote:
|
public MySQLCheckAccount(sqlplayersname[]) { new query[128]; new escstr[MAX_PLAYER_NAME]; samp_mysql_real_escape_string(sqlplayersname, escstr); format(query, sizeof(query), "SELECT id FROM players WHERE LOWER(Name) = LOWER('%s') LIMIT 1", escstr); samp_mysql_query(query); samp_mysql_store_result(); if (samp_mysql_num_rows()==0) { return 0; } else { new strid[32]; new intid; samp_mysql_fetch_row(strid); intid = strval(strid); return intid; } } |
Quote:
|
public MySQLCreateAccount(newplayersname[], newpassword[]) // by iReal { new query[128]; new sqlplyname[64]; new sqlpassword[64]; samp_mysql_real_escape_string(newplayersname, sqlplyname); samp_mysql_real_escape_string(newpassword, sqlpassword); format(query, sizeof(query), "INSERT INTO players (Name, Password) VALUES ('%s', '%s')", sqlplyname, sqlpassword); samp_mysql_query(query); new newplayersid = MySQLCheckAccount(newplayersname); if (newplayersid != 0) { return newplayersid; } return 0; } |
Quote:
|
public OnPlayerRegister(playerid, password[]) { if(IsPlayerConnected(playerid)) { MySQLCheckConnection(); new playername3[MAX_PLAYER_NAME]; GetPlayerName(playerid, playername3, sizeof(playername3)); new newaccountsqlid = MySQLCreateAccount(playername3, password); if (newaccountsqlid != 0) { PlayerInfo[playerid][pSQLID] = newaccountsqlid; //PlayerInfo[playerid][pKey] = password; strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255); OnPlayerUpdateEx(playerid); SendClientMessage(playerid, COLOR_YELLOW, "Account registered, you can now log in (/login [password])."); return 1; } else { SendClientMessage(playerid, COLOR_DARKNICERED, "There was an error creating your account. You will be disconnected now."); Kick(playerid); return 0; } } return 0; } |
Quote:
|
public OnPlayerUpdateEx(playerid) // by iReal • Version 1.1 • { if(IsPlayerConnected(playerid)) { if(gPlayerLogged[playerid]) { MySQLCheckConnection(); new query[MAX_STRING]; format(query, MAX_STRING, "UPDATE players SET "); MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]); PlayerInfo[playerid][pCash] = GetPlayerCash(playerid); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PlayerLevel", PlayerInfo[playerid][pLevel]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "AdminLevel", PlayerInfo[playerid][pAdmin]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DonateRank", PlayerInfo[playerid][pDonateRank]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "UpgradePoints", PlayerInfo[playerid][gPupgrade]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "ConnectedTime", PlayerInfo[playerid][pConnectTime]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Registered", PlayerInfo[playerid][pReg]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Sex", PlayerInfo[playerid][pSex]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Age", PlayerInfo[playerid][pAge]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Origin", PlayerInfo[playerid][pOrigin]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CK", PlayerInfo[playerid][pCK]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Muted", PlayerInfo[playerid][pMuted]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Respect", PlayerInfo[playerid][pExp]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Money", PlayerInfo[playerid][pCash]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Bank", PlayerInfo[playerid][pAccount]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Crimes", PlayerInfo[playerid][pCrimes]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Kills", PlayerInfo[playerid][pKills]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Deaths", PlayerInfo[playerid][pDeaths]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Arrested", PlayerInfo[playerid][pArrested]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "WantedDeaths", PlayerInfo[playerid][pWantedDeaths]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Phonebook", PlayerInfo[playerid][pPhoneBook]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LottoNr", PlayerInfo[playerid][pLottoNr]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Fishes", PlayerInfo[playerid][pFishes]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BiggestFish", PlayerInfo[playerid][pBiggestFish]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Job", PlayerInfo[playerid][pJob]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Paycheck", PlayerInfo[playerid][pPayCheck]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "HeadValue", PlayerInfo[playerid][pHeadValue]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Jailed", PlayerInfo[playerid][pJailed]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "JailTime", PlayerInfo[playerid][pJailTime]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Materials", PlayerInfo[playerid][pMats]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Drugs", PlayerInfo[playerid][pDrugs]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Leader", PlayerInfo[playerid][pLeader]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Member", PlayerInfo[playerid][pMember]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FMember", PlayerInfo[playerid][pFMember]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Rank", PlayerInfo[playerid][pRank]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Chara", PlayerInfo[playerid][pChar]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "ContractTime", PlayerInfo[playerid][pContractTime]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DetSkill", PlayerInfo[playerid][pDetSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "SexSkill", PlayerInfo[playerid][pSexSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BoxSkill", PlayerInfo[playerid][pBoxSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LawSkill", PlayerInfo[playerid][pLawSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "MechSkill", PlayerInfo[playerid][pMechSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "JackSkill", PlayerInfo[playerid][pJackSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarSkill", PlayerInfo[playerid][pCarSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "NewsSkill", PlayerInfo[playerid][pNewsSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DrugsSkill", PlayerInfo[playerid][pDrugsSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CookSkill", PlayerInfo[playerid][pCookSkill]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishSkill", PlayerInfo[playerid][pFishSkill]); MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "pSHealth", PlayerInfo[playerid][pSHealth]); GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]); MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "pHealth", PlayerInfo[playerid][pHealth]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Inte", PlayerInfo[playerid][pInt]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Local", PlayerInfo[playerid][pLocal]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Team", PlayerInfo[playerid][pTeam]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Model", PlayerInfo[playerid][pModel]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Model", GetPlayerSkin(playerid)); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PhoneNr", PlayerInfo[playerid][pPnumber]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "House", PlayerInfo[playerid][pPhousekey]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Car", PlayerInfo[playerid][pPcarkey]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Bizz", PlayerInfo[playerid][pPbiskey]); if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0)) { PlayerInfo[playerid][pPos_x] = 1684.9; PlayerInfo[playerid][pPos_y] = -2244.5; PlayerInfo[playerid][pPos_z] = 13.5; } if(Spectate[playerid] != 255) { 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 Float  , Float:y, Float:z;GetPlayerPos(playerid,x,y,z); PlayerInfo[playerid][pPos_x] = x; PlayerInfo[playerid][pPos_y] = y; PlayerInfo[playerid][pPos_z] = z; MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "Pos_x", PlayerInfo[playerid][pPos_x]); MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "Pos_y", PlayerInfo[playerid][pPos_y]); MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "Pos_z", PlayerInfo[playerid][pPos_z]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarLic", PlayerInfo[playerid][pCarLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FlyLic", PlayerInfo[playerid][pFlyLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BoatLic", PlayerInfo[playerid][pBoatLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishLic", PlayerInfo[playerid][pFishLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "GunLic", PlayerInfo[playerid][pGunLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun1", PlayerInfo[playerid][pGun1]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun2", PlayerInfo[playerid][pGun2]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun3", PlayerInfo[playerid][pGun3]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun4", PlayerInfo[playerid][pGun4]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo1", PlayerInfo[playerid][pAmmo1]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo2", PlayerInfo[playerid][pAmmo2]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo3", PlayerInfo[playerid][pAmmo3]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo4", PlayerInfo[playerid][pAmmo4]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarTime", PlayerInfo[playerid][pCarTime]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PayDay", PlayerInfo[playerid][pPayDay]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PayDayHad", PlayerInfo[playerid][pPayDayHad]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Watch", PlayerInfo[playerid][pWatch]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Crashed", PlayerInfo[playerid][pCrashed]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Wins", PlayerInfo[playerid][pWins]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Loses", PlayerInfo[playerid][pLoses]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "AlcoholPerk", PlayerInfo[playerid][pAlcoholPerk]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DrugPerk", PlayerInfo[playerid][pDrugPerk]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "MiserPerk", PlayerInfo[playerid][pMiserPerk]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PainPerk", PlayerInfo[playerid][pPainPerk]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "TraderPerk", PlayerInfo[playerid][pTraderPerk]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Tutorial", PlayerInfo[playerid][pTut]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Mission", PlayerInfo[playerid][pMissionNr]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Warnings", PlayerInfo[playerid][pWarns]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "VirWorld", PlayerInfo[playerid][pVirWorld]); if(PlayerInfo[playerid][pDonateRank] < 1) { PlayerInfo[playerid][pFuel] = 0; } MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Fuel", PlayerInfo[playerid][pFuel]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Married", PlayerInfo[playerid][pMarried]); MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "MarriedTo", PlayerInfo[playerid][pMarriedTo]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Locked", PlayerInfo[playerid][pLocked]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "MatsLic", PlayerInfo[playerid][pMatsLic]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Rented", PlayerInfo[playerid][pRented]); MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Alarm", PlayerInfo[playerid][pAlarm]); MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]); } } return 1; } |
Re: myslq sistem problem - EleMenTalL - 09.12.2011
Need help~
Re: myslq sistem problem - MadeMan - 09.12.2011
Remove this
pawn Код:
if(fexist(string))
{
gPlayerAccount[playerid] = 1;
new loginstring[128];
new loginname[64];
GetPlayerName(playerid,loginname,sizeof(loginname) );
format(loginstring,sizeof(loginstring),"{FFFFFF}We lcome, {FFAF00}%s\n{FFFFFF}That nick is registered.\nYou can now login:",loginname);
ShowPlayerDialog(playerid,12346,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit");
return 1;
}
else
{
gPlayerAccount[playerid] = 0;
new regstring[128];
new regname[64];
GetPlayerName(playerid,regname,sizeof(regname));
format(regstring,sizeof(regstring),"{FFFFFF}Welcom e, {FFAF00}%s\n{FFFFFF}You dont have an account.\nPlease register:",regname);
ShowPlayerDialog(playerid,12345,DIALOG_STYLE_INPUT ,"Register",regstring,"Register","Exit");
return 1;
}
pawn Код:
MySQLCheckConnection();
// Check if the account exists
new sqlaccountstatus = MySQLCheckAccount(plname);
if(sqlaccountstatus != 0)
{
// Check if the account is locked
if (MySQLCheckAccountLocked(sqlaccountstatus) != 0)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "This account has been locked and cannot be accessed. Please contact an admin.");
Kick(playerid);
return 0;
}
gPlayerAccount[playerid] = 1;
PlayerInfo[playerid][pSQLID] = sqlaccountstatus;
new loginstring[128];
new loginname[64];
GetPlayerName(playerid,loginname,sizeof(loginname) );
format(loginstring,sizeof(loginstring),"{FFFFFF}Welcome, {FFAF00}%s\n{FFFFFF}That nick is registered.\nYou can now login:",loginname);
ShowPlayerDialog(playerid,12346,DIALOG_STYLE_INPUT ,"Login",loginstring,"Login","Exit");
}
else
{
gPlayerAccount[playerid] = 0;
new regstring[128];
new regname[64];
GetPlayerName(playerid,regname,sizeof(regname));
format(regstring,sizeof(regstring),"{FFFFFF}Welcome, {FFAF00}%s\n{FFFFFF}You dont have an account.\nPlease register:",regname);
ShowPlayerDialog(playerid,12345,DIALOG_STYLE_INPUT ,"Register",regstring,"Register","Exit");
}
Re: myslq sistem problem - EleMenTalL - 10.12.2011
Thanks man, it worked !
Thanks again.
It can be closed now.