15.01.2016, 22:19
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 MySQL said: Documentation
I donґt know much about mysql, but i get evertime this error...
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5 MySQL said: Documentation
I donґt know much about mysql, but i get evertime this error...
PHP код:
CREATE TABLE IF NOT EXISTS `accounts` (
`UserID` int(11) NOT NULL,
`Username` varchar(255) DEFAULT NULL,
`Password` varchar(129) DEFAULT NULL,
`LastIP` varchar(16) NOT NULL DEFAULT '-1',
`Adminlevel` int(4) NOT NULL,
`Money` int(10) NOT NULL,
`RegTime` int(20) NOT NULL,
`LastOn` int(20) NOT NULL,
`Level` int(4) NOT NULL,
`Gender` int(11) NOT NULL,
`Age` int(3) NOT NULL,
`Health` float NOT NULL,
`Armour` float NOT NULL,
`Skin` int(3) NOT NULL,
`Country` varchar(255) NOT NULL,
`Test` int(11) NOT NULL DEFAULT '0',
`Faction` int(11) NOT NULL,
`FactionRank` int(11) NOT NULL,
`FactionRankName` varchar(255) NOT NULL,
`Suspect` varchar(255) NOT NULL,
`Arrest` int(11) NOT NULL,
`PrisonSelect` int(6) NOT NULL DEFAULT '0',
`PrisonTime` int(6) NOT NULL DEFAULT '0',
`AdminPrisonCount` int(11) NOT NULL DEFAULT '0',
`SecondsLoggedIn` int(11) NOT NULL,
`PlayingHours` int(11) NOT NULL,
`AdminCode` int(255) NOT NULL,
`PhoneN` int(6) NOT NULL,
`PhoneCredit` int(11) NOT NULL,
`PhoneBook` int(11) NOT NULL DEFAULT '0',
`House` int(11) NOT NULL DEFAULT '0',
`Hotel` int(11) NOT NULL DEFAULT '0',
`Hospitalized` int(11) NOT NULL DEFAULT '0',
`OnDuty` int(11) NOT NULL DEFAULT '0',
`DutyClothes` int(11) NOT NULL DEFAULT '0',
`LastSkin` int(11) NOT NULL,
`LastX` float NOT NULL,
`LastY` float NOT NULL,
`LastZ` float NOT NULL,
`LastA` float NOT NULL,
`LastInt` int(11) NOT NULL,
`LastWorld` int(11) NOT NULL,
`InFactionHQ` int(11) NOT NULL,
`InHouse` int(11) NOT NULL,
`Helper` int(11) NOT NULL DEFAULT '0',
`Moderator` int(11) NOT NULL DEFAULT '0',
`BankPincode` varchar(5) DEFAULT '0',
`BankNumber` int(11) NOT NULL DEFAULT '0',
`BankMoney` int(11) NOT NULL DEFAULT '0',
`ExperiencePoints` int(11) NOT NULL,
`ExperiencePointsNeeded` int(11) NOT NULL DEFAULT '8',
`Coins` int(11) NOT NULL DEFAULT '0',
`WalkieTalkie` int(11) NOT NULL DEFAULT '0',
`WalkieFrequency` int(11) NOT NULL DEFAULT '0',
`HasMask` int(11) NOT NULL DEFAULT '0',
`Banned` int(11) NOT NULL DEFAULT '0',
`Bans` int(11) NOT NULL DEFAULT '0',
`Kicks` int(11) DEFAULT '0',
`WeaponSlot0` int(11) NOT NULL DEFAULT '0',
`WeaponSlot1` int(11) NOT NULL DEFAULT '0',
`WeaponSlot2` int(11) NOT NULL DEFAULT '0',
`WeaponSlot3` int(11) NOT NULL DEFAULT '0',
`WeaponSlot4` int(11) NOT NULL DEFAULT '0',
`WeaponSlot5` int(11) NOT NULL DEFAULT '0',
`WeaponSlot6` int(11) NOT NULL DEFAULT '0',
`WeaponSlot7` int(11) NOT NULL DEFAULT '0',
`WeaponSlot8` int(11) NOT NULL DEFAULT '0',
`WeaponSlot9` int(11) NOT NULL DEFAULT '0',
`WeaponSlot10` int(11) NOT NULL DEFAULT '0',
`WeaponSlot11` int(11) NOT NULL DEFAULT '0',
`WeaponSlot0Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot1Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot2Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot3Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot4Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot5Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot6Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot7Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot8Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot9Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot10Ammo` int(11) NOT NULL DEFAULT '0',
`WeaponSlot11Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot0` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot1` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot2` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot3` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot4` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot5` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot6` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot7` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot8` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot9` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot10` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot11` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot0Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot1Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot2Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot3Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot4Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot5Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot6Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot7Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot8Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot9Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot10Ammo` int(11) NOT NULL DEFAULT '0',
`DutyWeaponSlot11Ammo` int(11) NOT NULL DEFAULT '0',
`AntiCheatExemption` int(11) NOT NULL DEFAULT '0',
`Email` varchar(255) NOT NULL,
`Warns` int(11) NOT NULL DEFAULT '0',
`Badge` int(11) NOT NULL DEFAULT '0',
`SecretWord` varchar(128) NOT NULL,
`DisconnectReason` int(11) NOT NULL,
`Business` int(11) NOT NULL DEFAULT '-1',
`FightStyle` int(11) NOT NULL DEFAULT '0',
`SpawnedPersonalCar` int(11) NOT NULL DEFAULT '-1',
`DRIVINGLC` int(11) NOT NULL DEFAULT '0',
`FIREARMSLC` int(11) NOT NULL DEFAULT '0',
`BOATLC` int(11) NOT NULL DEFAULT '0',
`BIKELC` int(11) NOT NULL DEFAULT '0',
`LastDateOn` varchar(255) NOT NULL,
`Offline` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `accounts`
--
INSERT INTO `accounts` (`UserID`, `Username`, `Password`, `LastIP`, `Adminlevel`, `Money`, `RegTime`, `LastOn`, `Level`, `Gender`, `Age`, `Health`, `Armour`, `Skin`, `Country`, `Test`, `Faction`, `FactionRank`, `FactionRankName`, `Suspect`, `Arrest`, `PrisonSelect`, `PrisonTime`, `AdminPrisonCount`, `SecondsLoggedIn`, `PlayingHours`, `AdminCode`, `PhoneN`, `PhoneCredit`, `PhoneBook`, `House`, `Hotel`, `Hospitalized`, `OnDuty`, `DutyClothes`, `LastSkin`, `LastX`, `LastY`, `LastZ`, `LastA`, `LastInt`, `LastWorld`, `InFactionHQ`, `InHouse`, `Helper`, `Moderator`, `BankPincode`, `BankNumber`, `BankMoney`, `ExperiencePoints`, `ExperiencePointsNeeded`, `Coins`, `WalkieTalkie`, `WalkieFrequency`, `HasMask`, `Banned`, `Bans`, `Kicks`, `WeaponSlot0`, `WeaponSlot1`, `WeaponSlot2`, `WeaponSlot3`, `WeaponSlot4`, `WeaponSlot5`, `WeaponSlot6`, `WeaponSlot7`, `WeaponSlot8`, `WeaponSlot9`, `WeaponSlot10`, `WeaponSlot11`, `WeaponSlot0Ammo`, `WeaponSlot1Ammo`, `WeaponSlot2Ammo`, `WeaponSlot3Ammo`, `WeaponSlot4Ammo`, `WeaponSlot5Ammo`, `WeaponSlot6Ammo`, `WeaponSlot7Ammo`, `WeaponSlot8Ammo`, `WeaponSlot9Ammo`, `WeaponSlot10Ammo`, `WeaponSlot11Ammo`, `DutyWeaponSlot0`, `DutyWeaponSlot1`, `DutyWeaponSlot2`, `DutyWeaponSlot3`, `DutyWeaponSlot4`, `DutyWeaponSlot5`, `DutyWeaponSlot6`, `DutyWeaponSlot7`, `DutyWeaponSlot8`, `DutyWeaponSlot9`, `DutyWeaponSlot10`, `DutyWeaponSlot11`, `DutyWeaponSlot0Ammo`, `DutyWeaponSlot1Ammo`, `DutyWeaponSlot2Ammo`, `DutyWeaponSlot3Ammo`, `DutyWeaponSlot4Ammo`, `DutyWeaponSlot5Ammo`, `DutyWeaponSlot6Ammo`, `DutyWeaponSlot7Ammo`, `DutyWeaponSlot8Ammo`, `DutyWeaponSlot9Ammo`, `DutyWeaponSlot10Ammo`, `DutyWeaponSlot11Ammo`, `AntiCheatExemption`, `Email`, `Warns`, `Badge`, `SecretWord`, `DisconnectReason`, `Business`, `FightStyle`, `SpawnedPersonalCar`, `DRIVINGSLC`, `FIREARMSLC`, `BOATLC`, `BIKELC`, `LastOnDate`, `Offline`);