SA-MP Forums Archive
[FilterScript] Attachements System [MySQL Version] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] Attachements System [MySQL Version] (/showthread.php?tid=614852)

Pages: 1 2


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