1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Account problem [MySQL]
Warm
Little Clucker
**
Posts: 33
Threads: 9
Joined: Aug 2013
Reputation: 0
#1

15.02.2014, 06:49
Hello everyone. I have a problem with my accounts. After i register my account i'm leaving the server and reconnect with other nickname but this account not registering he log in same account(first account).
What do i do ? I don't know were lines i post ...
Find
Reply
Shockey HD
Gangsta
****
Posts: 684
Threads: 122
Joined: Jul 2011
Reputation: 0
#2

15.02.2014, 08:31
If you mean they are logging in with the same stats you need to reset variables.

OnPlayerDisconnect reset variables.
Find
Reply
Warm
Little Clucker
**
Posts: 33
Threads: 9
Joined: Aug 2013
Reputation: 0
#3

15.02.2014, 08:35
I gave OnPlayerDisconnect this variables for save account etc.

Код:
if(gPlayerLogged[playerid])
	{
	    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);
	    PlayerInfo[playerid][pInt] = GetPlayerInterior(playerid);
	 	format(query, sizeof(query), "UPDATE players SET Money=%d, Interior=%d WHERE id=%d",
  		PlayerInfo[playerid][pCash],
		PlayerInfo[playerid][pInt],
		sqlid);
	    mysql_query(query);
	    OnPlayerDataSave(playerid);
		SQLLog(query);
		print("Player Update Completed");
	}
That i have, for Mysql
Find
Reply
Yashas
Gangsta
*****
Posts: 882
Threads: 50
Joined: Jun 2012
Reputation: 0
#4

15.02.2014, 08:40
You need to reset all the variables on Disconnect or at Connect.What happens is you registered and left the server.And you join again you get the same playerid.If you don't reset all the information of the previously logged in player, then the same information will be used for the newly connected player.

Just do this:
Clear all your player variables at Disconnect so that the new player how would take that playerid will have a fresh set of variables.
Find
Reply
Warm
Little Clucker
**
Posts: 33
Threads: 9
Joined: Aug 2013
Reputation: 0
#5

15.02.2014, 09:00
Hmm, i have made a stock with default variables from OnPlayerConnect
Код:
stock ResetVariables(playerid)
{
    gPlayerLogged[playerid] = 0;
	Seatbelt[playerid] = 0;
	JustReported[playerid] = 0;
	PlayerNeedsHelp[playerid] = 0;
	UsedCrack[playerid] = 0;
	CrackOffer[playerid] = 999;
	CrackPrice[playerid] = 0;
	CrackGram[playerid] = 0;
	STIPlayer[playerid] = 0;
	gActivePlayers[playerid]++;
	cblls[playerid] = 1; clsv[playerid] = 1; cgst[playerid] = 1; cvla[playerid] = 1; dnb[playerid] = 1; sffr[playerid] = 1;
	numplayers += 1;
	new plname[MAX_PLAYER_NAME];
	new playersip[64];
	new string[MAX_PLAYER_NAME];
	GetPlayerIp(playerid,playersip,sizeof(playersip));
	WantedLevel[playerid] = 0;
	WantedPoints[playerid] = 0;
	AdminSecurity[playerid] = 0; ToolKit[playerid] = 0;   gVip[playerid] = 0;
	SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0; PlayerIsHarvesting[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; SpawnChange[playerid] = 1; PlayerRacing[playerid] = 0; PlayerRacing2[playerid] = 0;
	CarOffer[playerid] = 999; CarPrice[playerid] = 0; CarID[playerid] = 0; CarCalls[playerid] = 0;
 	MoneyMessage[playerid] = 0; Condom[playerid] = 0; BigEar[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; NeedMedicTime[playerid] = 0; MedicBill[playerid] = 0; GotHit[playerid] = 0;
    GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0; PlayerInfo[playerid][pGarbageTime] = 0;PlayerInfo[playerid][pToyTime] = 0;
	OnDuty[playerid] = 0; TestFishes[playerid] = 0; PlayerInfo[playerid][pPizzaTime] = 0;
	BoxWaitTime[playerid] = 0; ChangePos2[playerid][1] = 0;GarbageEndTime[playerid] = 0; GarbageTime[playerid] = 0; BinTime[playerid] = 0;//garbaje
	SafeTime[playerid] = 60; TransportDuty[playerid] = 0; PlayerTied[playerid] = 0;
	BusCallTime[playerid] = 0; TaxiCallTime[playerid] = 0; MedicCallTime[playerid] = 0; MechanicCallTime[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;
    gLastCar[playerid] = 0; FirstSpawn[playerid] = 0;
	gOoc[playerid] = 0; gNews[playerid] = 0; gDice[playerid] = 0; gFam[playerid] = 0;
	gSpeedo[playerid] = 0; gGas[playerid] = 0;// gNewb = 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; BigEar[playerid] = 0;
	HireCar[playerid] = 299; 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; FarmerVar[playerid] = 0; FarmerPickup[playerid][0] = 0;
	ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999;
	GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
	PlayerInfo[playerid][pLevel] = 1;
	PlayerInfo[playerid][pAdmin] = 0;
	PlayerInfo[playerid][pHelper] = 0;
	PlayerInfo[playerid][pDonateRank] = 0;
	PlayerInfo[playerid][gPupgrade] = 0;
	PlayerInfo[playerid][pConnectTime] = 0;
	PlayerInfo[playerid][pReg] = 0;
	PlayerInfo[playerid][pSex] = 0;
	PlayerInfo[playerid][pAge] = 0;
	PlayerInfo[playerid][pOrigin] = 0;
	PlayerInfo[playerid][pExp] = 8;
	PlayerInfo[playerid][pAccount] = 0;
	PlayerInfo[playerid][pCrimes] = 0;
	PlayerInfo[playerid][pDeaths] = 0;
	PlayerInfo[playerid][pArrested] = 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] = 4;
	PlayerInfo[playerid][pHeadValue] = 0;
	PlayerInfo[playerid][pClubMember] = 0;
	PlayerInfo[playerid][pWeed] = 0;
	PlayerInfo[playerid][pBounty] = 0;
	PlayerInfo[playerid][pClubLeader] = 0;
	PlayerInfo[playerid][pClubWarns] = 0;
	PlayerInfo[playerid][pCoin] = 0;
	PlayerInfo[playerid][pMisiuniF] = 0;
	PlayerInfo[playerid][pClubRank] = 0;
	PlayerInfo[playerid][pJailed] = 0;
	PlayerInfo[playerid][pJailTime] = 0;
	PlayerInfo[playerid][pMats] = 0;
	PlayerInfo[playerid][pDrugs] = 0;
	PlayerInfo[playerid][pWeed] = 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][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] = 2246.6;
	PlayerInfo[playerid][pPos_y] = -1161.9;
	PlayerInfo[playerid][pPos_z] = 1029.7;
	PlayerInfo[playerid][pInt] = 15;
	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][pPhousekey] = 255;
	PlayerInfo[playerid][pPbiskey] = 255;
	PlayerInfo[playerid][pCarLic] = 1;
	PlayerInfo[playerid][pFlyLic] = 0;
	PlayerInfo[playerid][pBoatLic] = 0;
	PlayerInfo[playerid][pFishLic] = 0;
	PlayerInfo[playerid][pGunLic] = 0;
	PlayerInfo[playerid][pGun1] = 0;
	PlayerInfo[playerid][pCredit] = 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][pCDPlayer] = 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][pFWarns] = 0;
	PlayerInfo[playerid][pFuel] = 0;
	PlayerInfo[playerid][pVirWorld] = 0;
	PlayerInfo[playerid][pAdjustable] = 0;
	PlayerInfo[playerid][pPassport] = 0;
	PlayerInfo[playerid][pArmalvl3] = 0;
	PlayerInfo[playerid][pMaskuse] = 0;
	PlayerInfo[playerid][pRobSkill] = 0;
	PlayerInfo[playerid][pRob] = 0;
	PlayerInfo[playerid][pCrack] = 0;
	PlayerInfo[playerid][pGarbageTime] = 0;
	PlayerInfo[playerid][pPizzaTime] = 0;
	PlayerInfo[playerid][pToyTime] = 0;
	PlayerInfo[playerid][pCabinetTime] = 0;
	PlayerInfo[playerid][pReprezentant] = 0;
	PlayerInfo[playerid][pReprezentant2] = 0;
	PlayerInfo[playerid][pRobTime] = 0;
	PlayerInfo[playerid][pDGun1] = 0; //dgun
	PlayerInfo[playerid][pDGun2] = 0; //dgun
	PlayerInfo[playerid][pDGun3] = 0; //dgun
	PlayerInfo[playerid][pDGun4] = 0; //dgun
	PlayerInfo[playerid][pDGun5] = 0; //dgun
	PlayerInfo[playerid][pPguns1] = 0; //pguns
	PlayerInfo[playerid][pPguns2] = 0; //pguns
	HouseEntered[playerid] = 255;
	pgun[playerid] = 0; //dgun
	ClearFishes(playerid);
	ClearCooking(playerid);
	ClearGroceries(playerid);
	ClearMarriage(playerid);
	return 1;
}
Now i have another problem with password of account, i don't know how to reset account password.
When i join the server write password from register and at login doesen't work password. After relog and then work password ...
Find
Reply
Warm
Little Clucker
**
Posts: 33
Threads: 9
Joined: Aug 2013
Reputation: 0
#6

15.02.2014, 12:01
Anyone ? I stuck here ..
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help