Re: Attachements System [MySQL Version] -
tboysamp - 02.09.2016
I don't get what I'm doing wrong here
Код:
02:36:53] [MYSQL ERROR]: ID: 1146
[02:36:53] [MYSQL ERROR]: Error: Table 'smallcountyrp.phonenumber' doesn't exist
[02:36:53] [MYSQL ERROR]: Query: SELECT `36` FROM `PhoneNumber` WHERE `characters` = 'BLS' LIMIT 1
Код:
#define MYSQL_USERS_TABLE "PhoneNumber"
#define MYSQL_ID_FIELDNAME "36"
#define MYSQL_NAME_FIELDNAME "characters"
#define MYSQL_ID_INDEX 0
Re: Attachements System [MySQL Version] -
Shinja - 02.09.2016
Show me your users/playerbase table
Re: Attachements System [MySQL Version] -
tboysamp - 02.09.2016
Код:
CREATE TABLE IF NOT EXISTS `characters` (
`ID` int(6) NOT NULL,
`A_ID` int(6) NOT NULL,
`Name` varchar(34) NOT NULL,
`RegisterIP` varchar(16) NOT NULL,
`RegisterDate` int(12) NOT NULL,
`LatestIP` varchar(16) NOT NULL,
`Tutorial` int(2) NOT NULL,
`Level` int(5) NOT NULL,
`XP` int(6) NOT NULL,
`Cash` int(11) NOT NULL,
`Skin` int(3) NOT NULL,
`PosX` float NOT NULL,
`PosY` float NOT NULL,
`PosZ` float NOT NULL,
`VWorld` int(4) NOT NULL,
`Interior` int(2) NOT NULL,
`Age` int(3) NOT NULL,
`Gender` int(2) NOT NULL,
`Kicks` int(5) NOT NULL,
`Muted` int(2) NOT NULL,
`Faction` int(2) NOT NULL,
`Rank` int(2) NOT NULL,
`Job` int(2) NOT NULL,
`Health` float NOT NULL,
`Armour` float NOT NULL,
`hEntered` int(5) NOT NULL,
`bEntered` int(5) NOT NULL,
`Vehicles` int(3) NOT NULL,
`Bank` int(12) NOT NULL,
`ExemptIP` int(11) NOT NULL,
`TotalTimePlayed` int(12) NOT NULL,
`OnlinePeriod` int(12) NOT NULL,
`Payday` int(12) NOT NULL,
`LastOnline` int(12) NOT NULL,
`PhoneStatus` int(2) NOT NULL,
`PhoneNumber` int(11) NOT NULL,
`TruckingCompleted` int(6) NOT NULL,
`TruckCoolDown` int(12) NOT NULL,
`GDL` int(2) NOT NULL,
`CDL` int(2) NOT NULL,
`MDL` int(2) NOT NULL,
`Fare` int(3) NOT NULL,
`VehicleRadio` int(2) NOT NULL,
`Cuffed` int(1) NOT NULL,
`Spawn` int(1) NOT NULL,
`Jail` int(4) NOT NULL,
`Radio` int(2) NOT NULL,
`RadioFreq` int(4) NOT NULL DEFAULT '27',
`Weapons` varchar(104) NOT NULL DEFAULT '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',
`Uniform` int(4) NOT NULL,
`Screwdriver` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;
Re: Attachements System [MySQL Version] -
Shinja - 02.09.2016
PHP код:
#define MYSQL_USERS_TABLE "characters"
#define MYSQL_ID_FIELDNAME "ID"
#define MYSQL_NAME_FIELDNAME "Name"
#define MYSQL_ID_INDEX 0Â
btw ID should better be auto_increment
Re: Attachements System [MySQL Version] -
AstroZ - 04.09.2016
great simple and useful , repped
Re: Attachements System [MySQL Version] -
fireranger11 - 19.05.2017
Someone tell me how to do i create mysql tables with fields?
Re: Attachements System [MySQL Version] - Astralis - 20.05.2017
Useful and fun.
Re: Attachements System [MySQL Version] -
Kimsa - 20.05.2017
Nice work!
Re: Attachements System [MySQL Version] -
Shinja - 30.07.2017
Updating to +40 MySQL version soon