MySQL help - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL help (/showthread.php?tid=193214)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL help (/showthread.php?tid=193214)
MySQL help - Yvax - 25.11.2010
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.
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!
Re: MySQL help - Auxxx - 25.11.2010
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 ?
Re: MySQL help - Yvax - 25.11.2010
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.
Re: MySQL help - Yvax - 25.11.2010
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;
}
Re: MySQL help - Auxxx - 25.11.2010
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;
Re: MySQL help - Vince - 25.11.2010
Ever thought about opening the mysql_log.txt?
Re: MySQL help - Yvax - 25.11.2010
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.
Re: MySQL help - Auxxx - 26.11.2010
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.
Re: MySQL help - Auxxx - 27.11.2010
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. |
Re: MySQL help - Yvax - 01.12.2010
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...