indnike
Умник
Здравствуйте, помогите пожалуйста решить проблему со структурой аккаунтов
Вот структура
Вот ошибки при загрузки структуры
Связь со мной
VK:
Skype: gerain_17
Вот структура
-- phpMyAdmin SQL Dump
-- version 3.5.3
--
--
-- РҐРѕСЃС‚: 127.0.0.1
-- Время создания: Апр 15 2015 г., 17:21
-- Версия сервера: 5.1.66
-- Версия PHP: 5.4.23-pl0-gentoo
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- База данных: `indnike_FS-RP`
--
-- --------------------------------------------------------
--
-- Структура таблицы `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`pLevel` int(11) NOT NULL AUTO_INCREMENT,
`pPhousekey` varchar(32) COLLATE cp1251_bin NOT NULL,
`pPhousekey2` varchar(32) COLLATE cp1251_bin NOT NULL,
`pPbiskey` int(11) NOT NULL,
`pAdmin` int(11) NOT NULL,
`pHelper` int(11) NOT NULL,
`pForma` int(11) NOT NULL,
`pJobHeal` int(11) NOT NULL,
`pJobHealLeader` int(11) NOT NULL,
`pFuelcar` float NOT NULL,
`pText` int(11) NOT NULL,
`pHP` varchar(127) COLLATE cp1251_bin NOT NULL,
`pGod` varchar(128) COLLATE cp1251_bin NOT NULL,
`pSatiety` varchar(128) COLLATE cp1251_bin NOT NULL,
`pCheckip` int(11) NOT NULL,
`pPhoneBook` int(11) NOT NULL,
`pDirectory` int(11) NOT NULL,
`pAlcoholPerk` int(11) NOT NULL,
`pCar` int(11) NOT NULL,
`pDonatemoney` int(11) NOT NULL,
`pDonateRank` int(11) NOT NULL,
`pReg` int(11) NOT NULL,
`pSex` int(11) NOT NULL,
`pArrested` int(11) NOT NULL,
`pMuted` int(11) NOT NULL,
`pCrimes` int(11) NOT NULL,
`pExp` int(11) NOT NULL,
`pCash` int(11) NOT NULL,
`pKills` int(11) NOT NULL,
`pDeaths` int(11) NOT NULL,
`pPayCheck` int(11) NOT NULL,
`pJailed` int(11) NOT NULL,
`pCheat` int(11) NOT NULL,
`pJailTime` int(11) NOT NULL,
`pMats` int(11) NOT NULL,
`pDrugs` int(11) NOT NULL,
`pLeader` int(11) NOT NULL,
`pMember` int(11) NOT NULL,
`pRank` int(11) NOT NULL,
`pJob` int(11) NOT NULL,
`pCarLic` int(11) NOT NULL,
`pBizLic` int(11) NOT NULL,
`pFlyLic` int(11) NOT NULL,
`pBoatLic` int(11) NOT NULL,
`pFishLic` float NOT NULL,
`pGunLic` float NOT NULL,
`pSlot1` int(11) NOT NULL,
`pSlot2` int(11) NOT NULL,
`pSlot3` int(11) NOT NULL,
`pSlot4` int(11) NOT NULL,
`pSlot5` int(11) NOT NULL,
`pSlot6` int(11) NOT NULL,
`pSlot7` int(11) NOT NULL,
`pSlot8` int(11) NOT NULL,
`pSlot9` int(11) NOT NULL,
`pSlot10` int(11) NOT NULL,
`pSlot11` int(11) NOT NULL,
`pSlotammo1` int(11) NOT NULL,
`pSlotammo2` int(11) NOT NULL,
`pSlotammo3` int(11) NOT NULL,
`pSlotammo4` int(11) NOT NULL,
`pSlotammo5` int(11) NOT NULL,
`pSlotammo6` int(11) NOT NULL,
`pSlotammo7` int(11) NOT NULL,
`pSlotammo8` int(11) NOT NULL,
`pSlotammo9` int(11) NOT NULL,
`pSlotammo10` int(11) NOT NULL,
`pSlotammo11` int(11) NOT NULL,
`pGunSkill1` int(11) NOT NULL,
`pGunSkill2` int(11) NOT NULL,
`pGunSkill3` int(11) NOT NULL,
`pGunSkill4` int(11) NOT NULL,
`pGunSkill5` int(11) NOT NULL,
`pGunSkill6` int(11) NOT NULL,
`ptaxiexp` int(11) NOT NULL,
`ptaxilvl` int(11) NOT NULL,
`pDLevel` int(11) NOT NULL,
`pDExp` int(11) NOT NULL,
`pDMgruz` int(11) NOT NULL,
`pDgruz` int(11) NOT NULL,
`pKazpay` int(11) NOT NULL,
`pChar` int(11) NOT NULL,
`pChar1` int(11) NOT NULL,
`pChar2` int(11) NOT NULL,
`pViborChar` int(11) NOT NULL,
`pSHealth` float NOT NULL,
`pHealth` float NOT NULL,
`pInt` int(11) NOT NULL,
`pLocal` int(11) NOT NULL,
`pModel` int(11) NOT NULL,
`pPnumber` int(11) NOT NULL,
`pPayDay` int(11) NOT NULL,
`pPayDayHad` int(11) NOT NULL,
`pTut` int(11) NOT NULL,
`pWarns` int(11) NOT NULL,
`punWarns` int(11) NOT NULL,
`punWarnstime` int(11) NOT NULL,
`pFuel` int(11) NOT NULL,
`pMarried` int(11) NOT NULL,
`pMarriedTo` varchar(128) COLLATE cp1251_bin NOT NULL,
`pMushrooms` int(11) NOT NULL,
`pFishes` float NOT NULL,
`pFishesPach` int(11) NOT NULL,
`pMuteTime` int(11) NOT NULL,
`pMobile` int(11) NOT NULL,
`pBank` int(11) NOT NULL,
`pLocked` int(11) NOT NULL,
`pBanDay` int(11) NOT NULL,
`pBanMounth` int(11) NOT NULL,
`pKrisha` int(11) NOT NULL,
`pUseKrisha` int(11) NOT NULL,
`pDolg` int(11) NOT NULL,
`pBoxSkill` int(11) NOT NULL,
`pKongfuSkill` int(11) NOT NULL,
`pKickboxSkill` int(11) NOT NULL,
`pDostup` int(11) NOT NULL,
`pZakonp` int(11) NOT NULL,
`pAddiction` int(11) NOT NULL,
`pMats` int(11) NOT NULL,
`pNarcoLomka` int(11) NOT NULL,
`pProcentsёint(11) NOT NULL,
`pWheels` int(11) NOT NULL,
`pPaintJob` int(11) NOT NULL,
`pSpoiler` int(11) NOT NULL,
`pBumper1` int(11) NOT NULL,
`pBumper2` int(11) NOT NULL,
`pColor1` int(11) NOT NULL,
`pColor2` int(11) NOT NULL,
`pNitro` int(11) NOT NULL,
`pHydrawlic` int(11) NOT NULL,
`pMestoJail` int(11) NOT NULL,
`pHousecash` int(11) NOT NULL,
`pKvartiraKey` int(11) NOT NULL,
`pWantedLevel` int(11) NOT NULL,
`pChas` int(11) NOT NULL,
`pMin` int(11) NOT NULL,
`pSkilla` int(11) NOT NULL,
`pRecognition` int(11) NOT NULL,
`pRobHouse` int(11) NOT NULL,
`pRobCar` int(11) NOT NULL,
`pEmail` int(11) NOT NULL,
`pOnline` int(11) NOT NULL,
`pKicka` int(11) NOT NULL,
`pBana` int(11) NOT NULL,
`pWarna` int(11) NOT NULL,
`pMpa` int(11) NOT NULL,
`pOnlineLid` int(11) NOT NULL,
PRIMARY KEY (`pID`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- version 3.5.3
--
Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!
--
-- РҐРѕСЃС‚: 127.0.0.1
-- Время создания: Апр 15 2015 г., 17:21
-- Версия сервера: 5.1.66
-- Версия PHP: 5.4.23-pl0-gentoo
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- База данных: `indnike_FS-RP`
--
-- --------------------------------------------------------
--
-- Структура таблицы `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`pLevel` int(11) NOT NULL AUTO_INCREMENT,
`pPhousekey` varchar(32) COLLATE cp1251_bin NOT NULL,
`pPhousekey2` varchar(32) COLLATE cp1251_bin NOT NULL,
`pPbiskey` int(11) NOT NULL,
`pAdmin` int(11) NOT NULL,
`pHelper` int(11) NOT NULL,
`pForma` int(11) NOT NULL,
`pJobHeal` int(11) NOT NULL,
`pJobHealLeader` int(11) NOT NULL,
`pFuelcar` float NOT NULL,
`pText` int(11) NOT NULL,
`pHP` varchar(127) COLLATE cp1251_bin NOT NULL,
`pGod` varchar(128) COLLATE cp1251_bin NOT NULL,
`pSatiety` varchar(128) COLLATE cp1251_bin NOT NULL,
`pCheckip` int(11) NOT NULL,
`pPhoneBook` int(11) NOT NULL,
`pDirectory` int(11) NOT NULL,
`pAlcoholPerk` int(11) NOT NULL,
`pCar` int(11) NOT NULL,
`pDonatemoney` int(11) NOT NULL,
`pDonateRank` int(11) NOT NULL,
`pReg` int(11) NOT NULL,
`pSex` int(11) NOT NULL,
`pArrested` int(11) NOT NULL,
`pMuted` int(11) NOT NULL,
`pCrimes` int(11) NOT NULL,
`pExp` int(11) NOT NULL,
`pCash` int(11) NOT NULL,
`pKills` int(11) NOT NULL,
`pDeaths` int(11) NOT NULL,
`pPayCheck` int(11) NOT NULL,
`pJailed` int(11) NOT NULL,
`pCheat` int(11) NOT NULL,
`pJailTime` int(11) NOT NULL,
`pMats` int(11) NOT NULL,
`pDrugs` int(11) NOT NULL,
`pLeader` int(11) NOT NULL,
`pMember` int(11) NOT NULL,
`pRank` int(11) NOT NULL,
`pJob` int(11) NOT NULL,
`pCarLic` int(11) NOT NULL,
`pBizLic` int(11) NOT NULL,
`pFlyLic` int(11) NOT NULL,
`pBoatLic` int(11) NOT NULL,
`pFishLic` float NOT NULL,
`pGunLic` float NOT NULL,
`pSlot1` int(11) NOT NULL,
`pSlot2` int(11) NOT NULL,
`pSlot3` int(11) NOT NULL,
`pSlot4` int(11) NOT NULL,
`pSlot5` int(11) NOT NULL,
`pSlot6` int(11) NOT NULL,
`pSlot7` int(11) NOT NULL,
`pSlot8` int(11) NOT NULL,
`pSlot9` int(11) NOT NULL,
`pSlot10` int(11) NOT NULL,
`pSlot11` int(11) NOT NULL,
`pSlotammo1` int(11) NOT NULL,
`pSlotammo2` int(11) NOT NULL,
`pSlotammo3` int(11) NOT NULL,
`pSlotammo4` int(11) NOT NULL,
`pSlotammo5` int(11) NOT NULL,
`pSlotammo6` int(11) NOT NULL,
`pSlotammo7` int(11) NOT NULL,
`pSlotammo8` int(11) NOT NULL,
`pSlotammo9` int(11) NOT NULL,
`pSlotammo10` int(11) NOT NULL,
`pSlotammo11` int(11) NOT NULL,
`pGunSkill1` int(11) NOT NULL,
`pGunSkill2` int(11) NOT NULL,
`pGunSkill3` int(11) NOT NULL,
`pGunSkill4` int(11) NOT NULL,
`pGunSkill5` int(11) NOT NULL,
`pGunSkill6` int(11) NOT NULL,
`ptaxiexp` int(11) NOT NULL,
`ptaxilvl` int(11) NOT NULL,
`pDLevel` int(11) NOT NULL,
`pDExp` int(11) NOT NULL,
`pDMgruz` int(11) NOT NULL,
`pDgruz` int(11) NOT NULL,
`pKazpay` int(11) NOT NULL,
`pChar` int(11) NOT NULL,
`pChar1` int(11) NOT NULL,
`pChar2` int(11) NOT NULL,
`pViborChar` int(11) NOT NULL,
`pSHealth` float NOT NULL,
`pHealth` float NOT NULL,
`pInt` int(11) NOT NULL,
`pLocal` int(11) NOT NULL,
`pModel` int(11) NOT NULL,
`pPnumber` int(11) NOT NULL,
`pPayDay` int(11) NOT NULL,
`pPayDayHad` int(11) NOT NULL,
`pTut` int(11) NOT NULL,
`pWarns` int(11) NOT NULL,
`punWarns` int(11) NOT NULL,
`punWarnstime` int(11) NOT NULL,
`pFuel` int(11) NOT NULL,
`pMarried` int(11) NOT NULL,
`pMarriedTo` varchar(128) COLLATE cp1251_bin NOT NULL,
`pMushrooms` int(11) NOT NULL,
`pFishes` float NOT NULL,
`pFishesPach` int(11) NOT NULL,
`pMuteTime` int(11) NOT NULL,
`pMobile` int(11) NOT NULL,
`pBank` int(11) NOT NULL,
`pLocked` int(11) NOT NULL,
`pBanDay` int(11) NOT NULL,
`pBanMounth` int(11) NOT NULL,
`pKrisha` int(11) NOT NULL,
`pUseKrisha` int(11) NOT NULL,
`pDolg` int(11) NOT NULL,
`pBoxSkill` int(11) NOT NULL,
`pKongfuSkill` int(11) NOT NULL,
`pKickboxSkill` int(11) NOT NULL,
`pDostup` int(11) NOT NULL,
`pZakonp` int(11) NOT NULL,
`pAddiction` int(11) NOT NULL,
`pMats` int(11) NOT NULL,
`pNarcoLomka` int(11) NOT NULL,
`pProcentsёint(11) NOT NULL,
`pWheels` int(11) NOT NULL,
`pPaintJob` int(11) NOT NULL,
`pSpoiler` int(11) NOT NULL,
`pBumper1` int(11) NOT NULL,
`pBumper2` int(11) NOT NULL,
`pColor1` int(11) NOT NULL,
`pColor2` int(11) NOT NULL,
`pNitro` int(11) NOT NULL,
`pHydrawlic` int(11) NOT NULL,
`pMestoJail` int(11) NOT NULL,
`pHousecash` int(11) NOT NULL,
`pKvartiraKey` int(11) NOT NULL,
`pWantedLevel` int(11) NOT NULL,
`pChas` int(11) NOT NULL,
`pMin` int(11) NOT NULL,
`pSkilla` int(11) NOT NULL,
`pRecognition` int(11) NOT NULL,
`pRobHouse` int(11) NOT NULL,
`pRobCar` int(11) NOT NULL,
`pEmail` int(11) NOT NULL,
`pOnline` int(11) NOT NULL,
`pKicka` int(11) NOT NULL,
`pBana` int(11) NOT NULL,
`pWarna` int(11) NOT NULL,
`pMpa` int(11) NOT NULL,
`pOnlineLid` int(11) NOT NULL,
PRIMARY KEY (`pID`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bin AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Вот ошибки при загрузки структуры
Ошибка
SQL-запрос:
-- -- База данных: `indnike_FS-RP` -- -- -------------------------------------------------------- -- -- Структура таблицы `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `pLevel` int(11) NOT NULL AUTO_INCREMENT, `pPhousekey` varchar(32) COLLATE cp1251_bin NOT NULL, `pPhousekey2` varchar(32) COLLATE cp1251_bin NOT NULL, `pPbiskey` int(11) NOT NULL, `pAdmin` int(11) NOT NULL, `pHelper` int(11) NOT NULL, `pForma` int(11) NOT NULL, `pJobHeal` int(11) NOT NULL, `pJobHealLeader` int(11) NOT NULL, `pFuelcar` float NOT NULL, `pText` int(11) NOT NULL, `pHP` varchar(127) COLLATE cp1251_bin NOT NULL, `pGod` varchar(128) COLLATE cp1251_bin NOT NULL, `pSatiety` varchar(128) COLLATE cp1251_bin NOT NULL, `pCheckip` int(11) NOT NULL, `pPhoneBook` int(11) NOT NULL, `pDirectory` int(11) NOT NULL, `pAlcoholPerk` int(11) NOT NULL, `pCar` int([...]
Ответ MySQL: Документация
#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 'pWheels` int(11) NOT NULL,
`pPaintJob` int(11) NOT NULL,
`pSpoiler` int(11' at line 132
SQL-запрос:
-- -- База данных: `indnike_FS-RP` -- -- -------------------------------------------------------- -- -- Структура таблицы `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `pLevel` int(11) NOT NULL AUTO_INCREMENT, `pPhousekey` varchar(32) COLLATE cp1251_bin NOT NULL, `pPhousekey2` varchar(32) COLLATE cp1251_bin NOT NULL, `pPbiskey` int(11) NOT NULL, `pAdmin` int(11) NOT NULL, `pHelper` int(11) NOT NULL, `pForma` int(11) NOT NULL, `pJobHeal` int(11) NOT NULL, `pJobHealLeader` int(11) NOT NULL, `pFuelcar` float NOT NULL, `pText` int(11) NOT NULL, `pHP` varchar(127) COLLATE cp1251_bin NOT NULL, `pGod` varchar(128) COLLATE cp1251_bin NOT NULL, `pSatiety` varchar(128) COLLATE cp1251_bin NOT NULL, `pCheckip` int(11) NOT NULL, `pPhoneBook` int(11) NOT NULL, `pDirectory` int(11) NOT NULL, `pAlcoholPerk` int(11) NOT NULL, `pCar` int([...]
Ответ MySQL: Документация
#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 'pWheels` int(11) NOT NULL,
`pPaintJob` int(11) NOT NULL,
`pSpoiler` int(11' at line 132
Связь со мной
VK:
Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!
Skype: gerain_17
