MySQL Problems ...
#9

and the SQL Log:

Код:
SELECT id FROM players WHERE LOWER(Name) = LOWER('Adi') LIMIT 1
SELECT reason FROM bans WHERE ip = '79.114.122.229'
SELECT * FROM bans WHERE player = 2
SELECT Locked FROM players WHERE id=2 LIMIT 1
SELECT COUNT(*) FROM players WHERE Name='Adi'
SELECT Password FROM players WHERE id = 2 LIMIT 1
SELECT * FROM players WHERE Name='Adi'
SELECT * FROM playerleveling WHERE Name='Adi'
SELECT * FROM playerprofile WHERE Name='Adi'
SELECT * FROM playerobjects WHERE Name='Adi'
SELECT * FROM playercriminalr WHERE Name='Adi'
SELECT * FROM playerskill WHERE Name='Adi'
SELECT * FROM playerkeyslyc WHERE Name='Adi'
SELECT * FROM playerignorel WHERE Name='Adi'
SELECT * FROM playerothers WHERE Name='Adi'
SELECT id FROM players WHERE LOWER(Name) = LOWER('Administrator') LIMIT 1
SELECT reason FROM bans WHERE ip = '79.114.124.20'
SELECT * FROM bans WHERE player = 1
SELECT Locked FROM players WHERE id=1 LIMIT 1
SELECT COUNT(*) FROM players WHERE Name='Administrator'
SELECT Password FROM players WHERE id = 1 LIMIT 1
SELECT * FROM players WHERE Name='Administrator'
SELECT * FROM playerleveling WHERE Name='Administrator'
SELECT * FROM playerprofile WHERE Name='Administrator'
SELECT * FROM playerobjects WHERE Name='Administrator'
SELECT * FROM playercriminalr WHERE Name='Administrator'
SELECT * FROM playerskill WHERE Name='Administrator'
SELECT * FROM playerkeyslyc WHERE Name='Administrator'
SELECT * FROM playerignorel WHERE Name='Administrator'
SELECT * FROM playerothers WHERE Name='Administrator'
UPDATE players SET `Sex`=1, `Age`=17, `Origin`=1, `Money`=900, `Bank`=1234, `Leader`=0, `Member`=0, `FMember`=255, `FRank`=0, `Rank`=0, `pSHealth`=0.000000, `pHealth`=100.000000, `Interior`=0, `Local`=255, `Team`=6, `Skin`=23, `ShopSkin`=3, `Char`=49, `Job`=0, `Locked`=0, `Tutorial`=1, `Registered`=1 WHERE Name='Adi'
UPDATE playerleveling SET PlayerLevel=10, AdminLevel=1337, UpgradePoints=0, ConnectedTime=0, Respect=0, PayDay=0, PayDayHad=2, Paycheck=2200 WHERE Name='Adi'
UPDATE playerprofile SET DateReg='10.5.2010', BornDay=24, BornMonth=12, Birthday=0, Question='Nobody', QuestionVar=1, WarnName1='Nobody', WarnName2='Nobody', WarnReason1='Empty', WarnReason2='Empty', WarnDate1='0.0.0', WarnDate2='0.0.0', Muted=0, MuteTime=0, Warnings=0, Married=0, Mto='' WHERE Name='Adi'
UPDATE playerobjects SET PhoneNr=5854, Phonebook=0, LottoNr=50, Fishes=51, BiggestFish=0, Materials=0, Drugs=0, Gun1=0, Gun2=0, Gun3=0, Gun4=0, Ammo1=0, Ammo2=0, Ammo3=0, Ammo4=0, Fuel=0, Walkie=0, HouseMaterials=0, HouseDrugs=0, Injections=0, ATF=0, Beer=0, Wine=0, Sprunk=0, Smoke=0, CardPassword=1234 WHERE Name='Adi'
UPDATE playercriminalr SET Crimes=0, Kills=0, Deaths=1, Arrested=0, WantedDeaths=0, HeadValue=0, Jailed=0, JailTime=0, ContractTime=0, Wins=0, Loses=0, JailCell=0, WantedLevel=1, WantedPoints=0 WHERE Name='Adi'
UPDATE playerskill SET DetSkill=0, SexSkill=0, LawSkill=0, MechSkill=0, JackSkill=0, CarSkill=0, NewsSkill=0, DrugsSkill=0, FishSkill=0, CarTime=0, AlcoholPerk=0, DrugPerk=0, MiserPerk=0, PainPerk=0, TraderPerk=0, FightStyle=0, FindTime=0, PistolSkill=0, SDPistolSkill=0, DeagleSkill=0, ShotgunSkill=0, MP5Skill=0, AK47Skill=0, M4Skill=0, SniperSkill=0 WHERE Name='Adi'
UPDATE playerkeyslyc SET House=255, Bizz=4, CarLic=1, FlyLic=1, BoatLic=1, FishLic=1, ShamalLic=1, Passport=1, GunLic=1, ForbbidenLic=0 WHERE Name='Adi'
UPDATE playerignorel SET Ignore1='Empty', Ignore2='Empty', Ignore3='Empty', Ignore4='Empty', Ignore5='Empty', Ignore6='Empty', Ignore7='Empty', Ignore8='Empty', Ignore9='Empty', Ignore10='Empty' WHERE Name='Adi'
UPDATE playerothers SET Mission=0, MSG='Empty', DriveRoom=0, LockBank=0, RoadBlock=0, CopSpawn=0, TaxiSpawn=0, MedicSpawn=0, SchoolSpawn=0, NewsSpawn=0, HouseSpawn=1, MolotovTime=0, MolotovCocktail=0, WhisperColor=21, Coordonator=0, VIP=1 WHERE Name='Adi'
SELECT id FROM players WHERE LOWER(Name) = LOWER('Adi') LIMIT 1
SELECT reason FROM bans WHERE ip = '79.114.122.229'
SELECT * FROM bans WHERE player = 2
SELECT Locked FROM players WHERE id=2 LIMIT 1
SELECT COUNT(*) FROM players WHERE Name='Adi'
SELECT Password FROM players WHERE id = 2 LIMIT 1
SELECT * FROM players WHERE Name='Adi'
SELECT * FROM playerleveling WHERE Name='Adi'
SELECT * FROM playerprofile WHERE Name='Adi'
SELECT * FROM playerobjects WHERE Name='Adi'
SELECT * FROM playercriminalr WHERE Name='Adi'
SELECT * FROM playerskill WHERE Name='Adi'
SELECT * FROM playerkeyslyc WHERE Name='Adi'
SELECT * FROM playerignorel WHERE Name='Adi'
SELECT * FROM playerothers WHERE Name='Adi'
UPDATE players SET `Sex`=0, `Age`=0, `Origin`=0, `Money`=1900, `Bank`=0, `Leader`=0, `Member`=0, `FMember`=0, `FRank`=0, `Rank`=0, `pSHealth`=0.000000, `pHealth`=100.000000, `Interior`=0, `Local`=255, `Team`=6, `Skin`=23, `ShopSkin`=3, `Char`=49, `Job`=0, `Locked`=0, `Tutorial`=1, `Registered`=0 WHERE Name='Administrator'
UPDATE playerleveling SET PlayerLevel=0, AdminLevel=0, UpgradePoints=0, ConnectedTime=0, Respect=0, PayDay=0, PayDayHad=2, Paycheck=2517 WHERE Name='Administrator'
UPDATE playerprofile SET DateReg='10.5.2010', BornDay=24, BornMonth=12, Birthday=0, Question='Nobody', QuestionVar=1, WarnName1='Nobody', WarnName2='Nobody', WarnReason1='Empty', WarnReason2='Empty', WarnDate1='0.0.0', WarnDate2='0.0.0', Muted=0, MuteTime=0, Warnings=0, Married=0, Mto='' WHERE Name='Administrator'
UPDATE playerobjects SET PhoneNr=5854, Phonebook=0, LottoNr=50, Fishes=52, BiggestFish=0, Materials=0, Drugs=0, Gun1=0, Gun2=0, Gun3=0, Gun4=0, Ammo1=0, Ammo2=0, Ammo3=0, Ammo4=0, Fuel=0, Walkie=0, HouseMaterials=0, HouseDrugs=0, Injections=0, ATF=0, Beer=0, Wine=0, Sprunk=0, Smoke=0, CardPassword=1234 WHERE Name='Administrator'
UPDATE playercriminalr SET Crimes=0, Kills=0, Deaths=0, Arrested=0, WantedDeaths=0, HeadValue=0, Jailed=0, JailTime=0, ContractTime=0, Wins=0, Loses=0, JailCell=0, WantedLevel=1, WantedPoints=0 WHERE Name='Administrator'
UPDATE playerskill SET DetSkill=0, SexSkill=0, LawSkill=0, MechSkill=0, JackSkill=0, CarSkill=0, NewsSkill=0, DrugsSkill=0, FishSkill=0, CarTime=0, AlcoholPerk=0, DrugPerk=0, MiserPerk=0, PainPerk=0, TraderPerk=0, FightStyle=0, FindTime=0, PistolSkill=0, SDPistolSkill=0, DeagleSkill=0, ShotgunSkill=0, MP5Skill=0, AK47Skill=0, M4Skill=0, SniperSkill=0 WHERE Name='Administrator'
UPDATE playerkeyslyc SET House=255, Bizz=4, CarLic=1, FlyLic=1, BoatLic=1, FishLic=1, ShamalLic=1, Passport=1, GunLic=1, ForbbidenLic=0 WHERE Name='Administrator'
UPDATE playerignorel SET Ignore1='Empty', Ignore2='Empty', Ignore3='Empty', Ignore4='Empty', Ignore5='Empty', Ignore6='Empty', Ignore7='Empty', Ignore8='Empty', Ignore9='Empty', Ignore10='Empty' WHERE Name='Administrator'
UPDATE playerothers SET Mission=0, MSG='Empty', DriveRoom=0, LockBank=0, RoadBlock=0, CopSpawn=0, TaxiSpawn=0, MedicSpawn=0, SchoolSpawn=0, NewsSpawn=0, HouseSpawn=1, MolotovTime=0, MolotovCocktail=0, WhisperColor=21, Coordonator=0, VIP=1 WHERE Name='Administrator'
Reply


Messages In This Thread
MySQL Problems ... - by FlashInTheNighT - 24.10.2010, 08:44
Re: MySQL Problems ... - by Retardedwolf - 24.10.2010, 08:46
Re: MySQL Problems ... - by iJumbo - 24.10.2010, 08:46
Re: MySQL Problems ... - by FlashInTheNighT - 24.10.2010, 08:55
Re: MySQL Problems ... - by iJumbo - 24.10.2010, 09:06
Re: MySQL Problems ... - by FlashInTheNighT - 24.10.2010, 14:09
Re: MySQL Problems ... - by vection - 24.10.2010, 15:01
Re: MySQL Problems ... - by FlashInTheNighT - 24.10.2010, 15:42
Re: MySQL Problems ... - by FlashInTheNighT - 24.10.2010, 16:28
Re: MySQL Problems ... - by FlashInTheNighT - 28.10.2010, 20:48

Forum Jump:


Users browsing this thread: 1 Guest(s)