1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support

Threaded Mode
MySQL help
Yvax
Big Clucker
***
Posts: 108
Threads: 18
Joined: Jul 2010
Reputation: 0
#1

25.11.2010, 11:36
Hi,I'm using CW:RP gamemode to test something and I have a problem with the mysql system.As you know the gamemode uses an old mysql plugin,and everytime I try to start the server,it crashes.In the server log appears that MYSQL is connected.
LOG:
Код:
SA-MP Dedicated Server
----------------------
v0.3b R2, ©2005-2010 SA-MP Team

[14:43:50] 
[14:43:50] Server Plugins
[14:43:50] --------------
[14:43:50]  Loading plugin: sampmysql
[14:43:50] 
/*************************************************/
/* SAMP-MySQL v0.15 Plugin loaded successfully ! */
/*************************************************/

[14:43:50]   Loaded.
[14:43:50]  Loaded 1 plugins.

[14:43:50] 
[14:43:50] Filter Scripts
[14:43:50] ---------------
[14:43:50]   Loading filter script 'base.amx'...
[14:43:50] 
--Base FS loaded.

[14:43:50]   Loading filter script 'gl_actions.amx'...
[14:43:50]   Loading filter script 'gl_property.amx'...
[14:43:50] 
-----------------------------------
[14:43:50] Grand Larceny Property Filterscript		
[14:43:50] -----------------------------------

[14:43:50]   Loading filter script 'gl_realtime.amx'...
[14:43:50]   Loaded 4 filter scripts.

[14:43:50] MYSQL: Attempting to connect to server...
[14:43:50] 
Connection to MySQL database: Successfull !
[14:43:50] MYSQL: Database connection established.
I also tryed to upgrade to G-Stylezz MYSQL plugin but when someone connects to the server his account resets.I mean...everytime you join the server you start from the beggining,losing you stats.

So,I need some help with any problem.If you can solve the first one I'll use that plugin,but if you have an answer to the second one,I'll use the G-Stylezz plugin.

Thanks!
Find
Reply
Auxxx
Big Clucker
***
Posts: 99
Threads: 3
Joined: Oct 2010
Reputation: 0
#2

25.11.2010, 11:49
Make sure, that you are using the right libmySQL. Sometimes people seem to forget little things like that... Also there are some important code changes. Did you just switch the plugin or edited the the script too ?
Find
Reply
Yvax
Big Clucker
***
Posts: 108
Threads: 18
Joined: Jul 2010
Reputation: 0
#3

25.11.2010, 12:02
I edited the script too,but the account resets when you connect.

I don't know what's the problem with the old mysql plugin,it worked some time ago.
Find
Reply
Yvax
Big Clucker
***
Posts: 108
Threads: 18
Joined: Jul 2010
Reputation: 0
#4

25.11.2010, 14:07
Okay,forget the problem with the old sampmysql plugin.I upgraded to G-Stylezz plugin(R5) but everytime I connect my account resets.I don't know what's the problem...

Here is my OnPlayerConnect:
Код:
public OnPlayerConnect(playerid)
{
	new plname[MAX_PLAYER_NAME];
	GetPlayerName(playerid, plname, sizeof(plname));

	if (strlen(plname) < 2)
	{
		Ban(playerid);
		return 1;
	}

	new chr, tokick=0;
	for (new i=0; i<strlen(plname); i++)
	{
	    chr = plname[i];
	    if (chr < 65) tokick = 1;
	    if (chr > 122) tokick = 1;
	    if (chr >= 91 && chr < 95) tokick = 1;
	    if (chr == 96) tokick = 1;
	}

	if (tokick == 1)
	{
	    SendClientMessage(playerid, COLOR_YELLOW, "Your player name doesn't look like RP (Firstname_Lastname), please change it");
	    Kick(playerid);
	}

	if(Security != 0) // what the hell is this?
	{
	    SendClientMessage(playerid, COLOR_YELLOW, "Host has broken one of the Agreement rules, action has been taken.");
	    Kick(playerid);
	    return 1;
 	}

/*	new string[256];
	// Check if the player is IP banned
	new playerip[16];
	GetPlayerIp(playerid, playerip, sizeof(playerip));
	new playeripbancheck = MySQLCheckIPBanned(playerip);
	if (playeripbancheck != 0)
	{
		new bannedreason[64];
		switch (playeripbancheck)
		{
			case 1:
				bannedreason = "manual ban by an admin";

			case 2:
				bannedreason = "manual control panel ban";

			case 3:
				bannedreason = "money cheat detected";

			case 4:
				bannedreason = "weapon cheat detected";

			default:
				bannedreason = "unknown";
		}
		format(string, sizeof(string), "You are banned from the server for the following reason: %s", bannedreason);
		SendClientMessage(playerid, COLOR_YELLOW, string);
		SendClientMessage(playerid, COLOR_YELLOW, "Please contact an admin if this message is in error.");
		Kick(playerid);
		return 1;
	}*/

	new namestring = strfind(plname, "_", true);
	if(namestring == -1)
	{
		SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Immigration: Your name is not acceptable.");
		SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Hint: Your name must be in the format Firstname_Lastname.");
		Kick(playerid);
		return 1;
	}
/*
	for(new h = 0; h < sizeof(CarInfo); h++)
	{
		SetVehicleParamsForPlayer(h,playerid,0,CarInfo[h][cLock]);
	}
*/
	gActivePlayers[playerid]++;
	numplayers++;
	//new string[MAX_PLAYER_NAME];
	UsedDrugs[playerid] = 0; OverDosed[playerid] = 0;
	NosDelay[playerid] = 0;
	SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0; LearnTime[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] = 9999999999999999;*/ UsedFind[playerid] = 0;
	CP[playerid] = 0; Robbed[playerid] = 0; SpawnChange[playerid] = 1;
	CarOffer[playerid] = 999; CarPrice[playerid] = 0; BegOffer[playerid] = 999; BegPrice[playerid] = 0; CarID[playerid] = 0; CarCalls[playerid] = 0; BrowsingCar[playerid] = 0;
	RobbedTime[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; LessonExitedVehicle[playerid] = 0; drivingtestexittmr[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;
	WantedPoints[playerid] = 0; GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0;
	OnDuty[playerid] = 0; tactical[playerid] = 0; swat[playerid] = 0; copspawn[playerid] = 1; timesrobbed[playerid] = 0; WantedLevel[playerid] = 0; TestFishes[playerid] = 0;
	BoxWaitTime[playerid] = 0; SchoolSpawn[playerid] = 0; ChangePos2[playerid][1] = 0;
	SafeTime[playerid] = 60; TransportDuty[playerid] = 0; PlayerTied[playerid] = 0; AdminDuty[playerid] = 0; TesterDuty[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; PlayerFull[playerid] = 0; PlayerFullTime[playerid] = 0;
	Unspec[playerid][sLocal] = 255; FishCount[playerid] = 0; OwnableCarOffer[playerid] = 999; OwnableCarID[playerid] = 0; OwnableCarPrice[playerid] = 0;
	WritingPaper[playerid] = 0; WritingPaperNumber[playerid] = 999; WritingLine[playerid] = 0; BringingPaper[playerid] = 0; GotPaper[playerid] = 0;
	PaperOffer[playerid] = 999; AlreadyStarting[playerid] = 0;
    //ConsumingMoney[playerid] = 0; BlockMoneyCheck[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] = 2; gGas[playerid] = 0;
	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;
	TutStep[playerid] = -1;
	gPlayerMission[playerid] = 0; TaxiAccepted[playerid] = 999; BusAccepted[playerid] = 999;
	PlayerInfo[playerid][pCash] = dollah; NoFuel[playerid] = 0;
	HireCar[playerid] = 299; HirePlane[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; DKT[playerid] = 0; pTest[playerid] = 0; pTestFly[playerid] = 0; pTestBoat[playerid] = 0;
	ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999;
	SafeGivePlayerMoney(playerid,PlayerInfo[playerid][pCash]); tactical[playerid] = 0; swat[playerid] = 0; authorizeswat = 0; authorizetactical = 0; CostumeReady[playerid] = 0;
	PizzaCallTime[playerid] = 0; ScratchTimer[playerid] = 0; FishTimer[playerid] = 0;
	bPizza[playerid] = 0; sPizza[playerid] = 0;
	InAFoodPlace[playerid] = 0;
	PlayerInfo[playerid][pLevel] = 0;
	PlayerInfo[playerid][pAdmin] = 0;
	PlayerInfo[playerid][pTester] = 0;
	PlayerInfo[playerid][pFreq] = 0;
	PlayerInfo[playerid][pWT] = 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] = 1;
	PlayerInfo[playerid][pExp] = 0;
	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][pJobLeader] = 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][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] = 100.0;
	PlayerInfo[playerid][pPos_x] = NOOB_X;
	PlayerInfo[playerid][pPos_y] = NOOB_Y;
	PlayerInfo[playerid][pPos_z] = NOOB_Z;
	PlayerInfo[playerid][pInt] = 0;
	PlayerInfo[playerid][pVirtualWorld] = 0;
	PlayerInfo[playerid][pLocal] = 255;
	PlayerInfo[playerid][pModel] = NOOB_SKIN;
	new randphone = 1000 + random(8999);//minimum 100000  max 999999 //giving one at the start
	PlayerInfo[playerid][pPnumber] = randphone;
	PlayerInfo[playerid][pPhousekey] = 255;
	PlayerInfo[playerid][pPapptkey] = 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][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][pMissionNr] = 0;
	PlayerInfo[playerid][pWarns] = 0;
	PlayerInfo[playerid][pFuel] = 0;
	PlayerInfo[playerid][pAdjustable] = 0;
	PlayerInfo[playerid][pCallNumber] = 0;
	PlayerInfo[playerid][pRequestingBackup] = 0;
	PlayerInfo[playerid][pRoadblock] = 0;
	PlayerInfo[playerid][pSQLID] = 0;
	PlayerInfo[playerid][pLocked] = 0;
	PlayerInfo[playerid][pJustice] = 0;
	PlayerInfo[playerid][pLinked] = 0;
	PlayerInfo[playerid][pDeagle] = 0;
	PlayerInfo[playerid][pShotgun] = 0;
	PlayerInfo[playerid][pRifle] = 0;
	PlayerInfo[playerid][pSDPistol] = 0;
	PlayerInfo[playerid][pMP5] = 0;
	PlayerInfo[playerid][pM4] = 0;
	PlayerInfo[playerid][pAK47] = 0;
	ClearCrime(playerid);
	ClearFishes(playerid);
	ClearCooking(playerid);
	ClearGroceries(playerid);
	ClearMarriage(playerid);
	SetPlayerColor(playerid,COLOR_GRAD2);

	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;
	}
	SendClientMessage(playerid, COLOR_YELLOW, "Please wait...");
	return 1;
}
If you need smoething else,please ask for it...I really don't know what's the problem and why are the accounts resetting.
Find
Reply
Auxxx
Big Clucker
***
Posts: 99
Threads: 3
Joined: Oct 2010
Reputation: 0
#5

25.11.2010, 14:52
I dont think all this shit should be there, because it's setting those variable valus to zero (0) when player connects and that causes the "resetting". I have'nt look throught the whole script, but I guess, that this is the problem...

pawn Код:
UsedDrugs[playerid] = 0; OverDosed[playerid] = 0;
    NosDelay[playerid] = 0;
    SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0; LearnTime[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] = 9999999999999999;*/ UsedFind[playerid] = 0;
    CP[playerid] = 0; Robbed[playerid] = 0; SpawnChange[playerid] = 1;
    CarOffer[playerid] = 999; CarPrice[playerid] = 0; BegOffer[playerid] = 999; BegPrice[playerid] = 0; CarID[playerid] = 0; CarCalls[playerid] = 0; BrowsingCar[playerid] = 0;
    RobbedTime[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; LessonExitedVehicle[playerid] = 0; drivingtestexittmr[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;
    WantedPoints[playerid] = 0; GoChase[playerid] = 999; GetChased[playerid] = 999; PlacedNews[playerid] = 0;
    OnDuty[playerid] = 0; tactical[playerid] = 0; swat[playerid] = 0; copspawn[playerid] = 1; timesrobbed[playerid] = 0; WantedLevel[playerid] = 0; TestFishes[playerid] = 0;
    BoxWaitTime[playerid] = 0; SchoolSpawn[playerid] = 0; ChangePos2[playerid][1] = 0;
    SafeTime[playerid] = 60; TransportDuty[playerid] = 0; PlayerTied[playerid] = 0; AdminDuty[playerid] = 0; TesterDuty[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; PlayerFull[playerid] = 0; PlayerFullTime[playerid] = 0;
    Unspec[playerid][sLocal] = 255; FishCount[playerid] = 0; OwnableCarOffer[playerid] = 999; OwnableCarID[playerid] = 0; OwnableCarPrice[playerid] = 0;
    WritingPaper[playerid] = 0; WritingPaperNumber[playerid] = 999; WritingLine[playerid] = 0; BringingPaper[playerid] = 0; GotPaper[playerid] = 0;
    PaperOffer[playerid] = 999; AlreadyStarting[playerid] = 0;
    //ConsumingMoney[playerid] = 0; BlockMoneyCheck[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] = 2; gGas[playerid] = 0;
    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;
    TutStep[playerid] = -1;
    gPlayerMission[playerid] = 0; TaxiAccepted[playerid] = 999; BusAccepted[playerid] = 999;
    PlayerInfo[playerid][pCash] = dollah; NoFuel[playerid] = 0;
    HireCar[playerid] = 299; HirePlane[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; DKT[playerid] = 0; pTest[playerid] = 0; pTestFly[playerid] = 0; pTestBoat[playerid] = 0;
    ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999;
    SafeGivePlayerMoney(playerid,PlayerInfo[playerid][pCash]); tactical[playerid] = 0; swat[playerid] = 0; authorizeswat = 0; authorizetactical = 0; CostumeReady[playerid] = 0;
    PizzaCallTime[playerid] = 0; ScratchTimer[playerid] = 0; FishTimer[playerid] = 0;
    bPizza[playerid] = 0; sPizza[playerid] = 0;
    InAFoodPlace[playerid] = 0;
    PlayerInfo[playerid][pLevel] = 0;
    PlayerInfo[playerid][pAdmin] = 0;
    PlayerInfo[playerid][pTester] = 0;
    PlayerInfo[playerid][pFreq] = 0;
    PlayerInfo[playerid][pWT] = 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] = 1;
    PlayerInfo[playerid][pExp] = 0;
    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][pJobLeader] = 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][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] = 100.0;
    PlayerInfo[playerid][pPos_x] = NOOB_X;
    PlayerInfo[playerid][pPos_y] = NOOB_Y;
    PlayerInfo[playerid][pPos_z] = NOOB_Z;
    PlayerInfo[playerid][pInt] = 0;
    PlayerInfo[playerid][pVirtualWorld] = 0;
    PlayerInfo[playerid][pLocal] = 255;
    PlayerInfo[playerid][pModel] = NOOB_SKIN;
    new randphone = 1000 + random(8999);//minimum 100000  max 999999 //giving one at the start
    PlayerInfo[playerid][pPnumber] = randphone;
    PlayerInfo[playerid][pPhousekey] = 255;
    PlayerInfo[playerid][pPapptkey] = 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][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][pMissionNr] = 0;
    PlayerInfo[playerid][pWarns] = 0;
    PlayerInfo[playerid][pFuel] = 0;
    PlayerInfo[playerid][pAdjustable] = 0;
    PlayerInfo[playerid][pCallNumber] = 0;
    PlayerInfo[playerid][pRequestingBackup] = 0;
    PlayerInfo[playerid][pRoadblock] = 0;
    PlayerInfo[playerid][pSQLID] = 0;
    PlayerInfo[playerid][pLocked] = 0;
    PlayerInfo[playerid][pJustice] = 0;
    PlayerInfo[playerid][pLinked] = 0;
    PlayerInfo[playerid][pDeagle] = 0;
    PlayerInfo[playerid][pShotgun] = 0;
    PlayerInfo[playerid][pRifle] = 0;
    PlayerInfo[playerid][pSDPistol] = 0;
    PlayerInfo[playerid][pMP5] = 0;
    PlayerInfo[playerid][pM4] = 0;
    PlayerInfo[playerid][pAK47] = 0;
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#6

25.11.2010, 14:56
Ever thought about opening the mysql_log.txt?
Find
Reply
Yvax
Big Clucker
***
Posts: 108
Threads: 18
Joined: Jul 2010
Reputation: 0
#7

25.11.2010, 14:57
( Последний раз редактировалось Yvax; 25.11.2010 в 15:38. )
mysql_log.txt is empty


LE:

Here is my mysql_log.txt
It seems to be fine...
Код:
[18:46:13]  

[18:46:13] ---------------------------

[18:46:13] MySQL Debugging activated (11/25/10)

[18:46:13] ---------------------------

[18:46:13]  

[18:46:44] >> mysql_ping( Connection handle: 1 )

[18:46:44] CMySQLHandler::Ping() - Connection is still alive.

[18:46:44] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:44] CMySQLHandler::EscapeString(Marco_Diaz); - Escaped 10 characters to Marco_Diaz.

[18:46:44] >> mysql_query( Connection handle: 1 )

[18:46:44] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(Name) = LOWER('Marco_Diaz') LIMIT 1) - Successfully executed.

[18:46:44] >> mysql_store_result( Connection handle: 1 )

[18:46:44] CMySQLHandler::StoreResult() - Result was stored.

[18:46:44] >> mysql_num_rows( Connection handle: 1 )

[18:46:44] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:46:44] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:44] CMySQLHandler::FetchRow() - Return: 496

[18:46:44] >> mysql_free_result( Connection handle: 1 )

[18:46:44] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:44] >> mysql_query( Connection handle: 1 )

[18:46:44] CMySQLHandler::Query(SELECT Locked FROM players WHERE id=496 LIMIT 1) - Successfully executed.

[18:46:44] >> mysql_store_result( Connection handle: 1 )

[18:46:44] CMySQLHandler::StoreResult() - Result was stored.

[18:46:44] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:44] CMySQLHandler::FetchRow() - Return: 0

[18:46:44] >> mysql_free_result( Connection handle: 1 )

[18:46:44] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:52] >> mysql_ping( Connection handle: 1 )

[18:46:52] CMySQLHandler::Ping() - Connection is still alive.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(SELECT COUNT(*) FROM players WHERE Name='Marco_Diaz') - Successfully executed.

[18:46:52] >> mysql_store_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::StoreResult() - Result was stored.

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - Return: 1

[18:46:52] >> mysql_free_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 496 LIMIT 1) - Successfully executed.

[18:46:52] >> mysql_store_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::StoreResult() - Result was stored.

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - Return: duty

[18:46:52] >> mysql_free_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(SELECT * FROM players WHERE id = 496 LIMIT 1) - Successfully executed.

[18:46:52] >> mysql_store_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::StoreResult() - Result was stored.

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - Return: 496|Marco_Diaz|duty|1|0|0|0|0|1|0|0|1|0|0|0|500|0|0|0|0|0|0|0|0|0|0|0|10|0|0|0|0|0|0|0|255|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0.000000|100.000000|0|1|7|7717|255|255|255|1627.018920|-2330.354003|-2.679699|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one|0|1|0|0|0|0|0|0|0|0.0.0.0|0.0.0.0|0|0|0|0

[18:46:52] >> mysql_free_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(81.196.86.137); - Escaped 13 characters to 81.196.86.137.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(INSERT INTO logins (time,ip,userid) VALUES (UNIX_TIMESTAMP(),'81.196.86.137',496)) - Successfully executed.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(SELECT * FROM profiles WHERE Name='Marco_Diaz') - Successfully executed.

[18:46:52] >> mysql_store_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::StoreResult() - Result was stored.

[18:46:52] >> mysql_num_rows( Connection handle: 1 )

[18:46:52] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:46:52] >> mysql_fetch_row_format( Connection handle: 1 )

[18:46:52] CMySQLHandler::FetchRow() - Return: Marco_Diaz|0|0|0||0

[18:46:52] >> mysql_free_result( Connection handle: 1 )

[18:46:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[18:46:52] >> mysql_ping( Connection handle: 1 )

[18:46:52] CMySQLHandler::Ping() - Connection is still alive.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(duty); - Escaped 4 characters to duty.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET Password='duty',PlayerLevel=1,AdminLevel=0,TesterLevel=0,DonateRank=0,UpgradePoints=0,ConnectedTime=0,Registered=1,Sex=0,Age=0,Origin=1,CK=0,Muted=0,Respect=0,Money=500,Bank=0,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=7,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=0,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(1627.018920); - Escaped 11 characters to 1627.018920.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2330.354003); - Escaped 12 characters to -2330.354003.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2.679699); - Escaped 9 characters to -2.679699.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0,pSHealth='0.000000',pHealth='100.000000',Inte=0,Local=1,Model=7,PhoneNr=9126,House=255,Appt=255,Bizz=255,Freq=0,WT=0,Pos_x='1627.018920',Pos_y='-2330.354003',Pos_z='-2.679699',CarLic=1,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,Deagle=0,Shotgun=0,Rifle=0,SDPistol=0,MP5=0,M4=0,AK47=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=0,Mission=0,Warnings=0,Adjustable=0,Fuel=0,Married=0,Locked=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_ping( Connection handle: 1 )

[18:46:52] CMySQLHandler::Ping() - Connection is still alive.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(duty); - Escaped 4 characters to duty.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET Password='duty',PlayerLevel=1,AdminLevel=0,TesterLevel=0,DonateRank=0,UpgradePoints=0,ConnectedTime=0,Registered=1,Sex=0,Age=0,Origin=1,CK=0,Muted=0,Respect=0,Money=500,Bank=0,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=7,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=0,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(1627.018920); - Escaped 11 characters to 1627.018920.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2330.354003); - Escaped 12 characters to -2330.354003.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2.679699); - Escaped 9 characters to -2.679699.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0,pSHealth='0.000000',pHealth='100.000000',Inte=0,Local=1,Model=7,PhoneNr=9126,House=255,Appt=255,Bizz=255,Freq=0,WT=0,Pos_x='1627.018920',Pos_y='-2330.354003',Pos_z='-2.679699',CarLic=1,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,Deagle=0,Shotgun=0,Rifle=0,SDPistol=0,MP5=0,M4=0,AK47=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=0,Mission=0,Warnings=0,Adjustable=0,Fuel=0,Married=0,Locked=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_ping( Connection handle: 1 )

[18:46:52] CMySQLHandler::Ping() - Connection is still alive.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(duty); - Escaped 4 characters to duty.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET Password='duty',PlayerLevel=1,AdminLevel=0,TesterLevel=0,DonateRank=0,UpgradePoints=0,ConnectedTime=0,Registered=1,Sex=0,Age=0,Origin=1,CK=0,Muted=0,Respect=0,Money=500,Bank=0,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=7,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=0,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(1627.018920); - Escaped 11 characters to 1627.018920.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2330.354003); - Escaped 12 characters to -2330.354003.

[18:46:52] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:52] CMySQLHandler::EscapeString(-2.679699); - Escaped 9 characters to -2.679699.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0,pSHealth='0.000000',pHealth='100.000000',Inte=0,Local=1,Model=7,PhoneNr=9126,House=255,Appt=255,Bizz=255,Freq=0,WT=0,Pos_x='1627.018920',Pos_y='-2330.354003',Pos_z='-2.679699',CarLic=1,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,Deagle=0,Shotgun=0,Rifle=0,SDPistol=0,MP5=0,M4=0,AK47=0 WHERE id=496) - Successfully executed.

[18:46:52] >> mysql_query( Connection handle: 1 )

[18:46:52] CMySQLHandler::Query(UPDATE players SET CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=0,Mission=0,Warnings=0,Adjustable=0,Fuel=0,Married=0,Locked=0 WHERE id=496) - Successfully executed.

[18:46:53] >> mysql_ping( Connection handle: 1 )

[18:46:53] CMySQLHandler::Ping() - Connection is still alive.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(duty); - Escaped 4 characters to duty.

[18:46:53] >> mysql_query( Connection handle: 1 )

[18:46:53] CMySQLHandler::Query(UPDATE players SET Password='duty',PlayerLevel=1,AdminLevel=0,TesterLevel=0,DonateRank=0,UpgradePoints=0,ConnectedTime=0,Registered=1,Sex=0,Age=0,Origin=1,CK=0,Muted=0,Respect=0,Money=500,Bank=0,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=8,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=0,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0 WHERE id=496) - Successfully executed.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(0.000000); - Escaped 8 characters to 0.000000.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(100.000000); - Escaped 10 characters to 100.000000.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(1627.018920); - Escaped 11 characters to 1627.018920.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(-2330.354003); - Escaped 12 characters to -2330.354003.

[18:46:53] >> mysql_real_escape_string( Connection handle: 1 )

[18:46:53] CMySQLHandler::EscapeString(-2.679699); - Escaped 9 characters to -2.679699.

[18:46:53] >> mysql_query( Connection handle: 1 )

[18:46:53] CMySQLHandler::Query(UPDATE players SET LawSkill=0,MechSkill=0,JackSkill=0,CarSkill=0,NewsSkill=0,DrugsSkill=0,CookSkill=0,FishSkill=0,pSHealth='0.000000',pHealth='100.000000',Inte=0,Local=1,Model=7,PhoneNr=9126,House=255,Appt=255,Bizz=255,Freq=0,WT=0,Pos_x='1627.018920',Pos_y='-2330.354003',Pos_z='-2.679699',CarLic=1,FlyLic=0,BoatLic=0,FishLic=0,GunLic=0,Gun1=0,Gun2=0,Gun3=0,Gun4=0,Ammo1=0,Ammo2=0,Ammo3=0,Ammo4=0,Deagle=0,Shotgun=0,Rifle=0,SDPistol=0,MP5=0,M4=0,AK47=0 WHERE id=496) - Successfully executed.

[18:46:53] >> mysql_query( Connection handle: 1 )

[18:46:53] CMySQLHandler::Query(UPDATE players SET CarTime=0,PayDay=0,PayDayHad=0,CDPlayer=0,Wins=0,Loses=0,AlcoholPerk=0,DrugPerk=0,MiserPerk=0,PainPerk=0,TraderPerk=0,Tutorial=0,Mission=0,Warnings=0,Adjustable=0,Fuel=0,Married=0,Locked=0 WHERE id=496) - Successfully executed.
Find
Reply
Auxxx
Big Clucker
***
Posts: 99
Threads: 3
Joined: Oct 2010
Reputation: 0
#8

26.11.2010, 11:35
All of those queries that will UPDATE players table, will set the value's to default, that would be 0 (zero)...

For example:

Код:
[18:46:52] CMySQLHandler::Query(UPDATE players SET Password='duty',PlayerLevel=1,AdminLevel=0,TesterLevel=0,DonateRank=0,UpgradePoints=0,ConnectedTime=0,Registered=1,Sex=0,Age=0,Origin=1,CK=0,Muted=0,Respect=0,Money=500,Bank=0,Crimes=0,Kills=0,Deaths=0,Arrested=0,WantedDeaths=0,Phonebook=0,LottoNr=0,Fishes=0,BiggestFish=0,Job=0,Paycheck=7,HeadValue=0,Jailed=0,JailTime=0,Materials=0,Drugs=0,Leader=0,Member=0,FMember=255,Rank=0,Chara=0,ContractTime=0,DetSkill=0,SexSkill=0,BoxSkill=0 WHERE id=496) - Successfully executed.
I'm pretty sure, that this is causing all the trouble...
Find
Reply
Auxxx
Big Clucker
***
Posts: 99
Threads: 3
Joined: Oct 2010
Reputation: 0
#9

27.11.2010, 17:07
Have you managed to fix this problem ?

Quote:

This forum requires that you wait 120 seconds between posts. Please try again in 53 seconds.
Quote:

This forum requires that you wait 120 seconds between posts. Please try again in 2 seconds.
Facepalm .
Find
Reply
Yvax
Big Clucker
***
Posts: 108
Threads: 18
Joined: Jul 2010
Reputation: 0
#10

01.12.2010, 08:06
( Последний раз редактировалось Yvax; 01.12.2010 в 08:22. )
No,I haven't managed to solve it,everytime I connect the account resets.I don't know what's the problem,and I don't know why MySQL updates and sets everything to 0...

If you have a solution please post here,
Thanks

LE:I found out that it is caused by OnPlayerUpdate(playerid),but I don't know why it's doing that...
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Server
  3. Server Support