· 7 years ago · Feb 22, 2019, 08:54 AM
1// Error while buying 2nd Vehicle solt. But it works for 1 vehicle slot
214:16:04 02/22/19] [ERROR] CMySQLQuery::Execute[LoadPlayerVehicle] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM vehicles WHERE Owner='Oblivion'' at line 1 (Query: "SELECT Model,Price,PaintJob,Color1,Color2,Plate,Locked,Mod1,Mod2,Mod3,Mod4,Mod5,Mod6,Mod7,Mod8,Mod9,Mod10,Mod11,Mod12,Mod13,Mod14,Mod15,Mod16,Mod17,Model_2,Price_2,PaintJob_2,Color1_2,Color2_2,Plate2,Locked2,Mod1S2,Mod2S2,Mod3S2,Mod4S2,Mod5S2,Mod6S2,Mod7S2,Mod8S2,Mod9S2,Mod10S2,Mod11S2,Mod12S2,Mod13S2,Mod14S2,Mod15S2,Mod16S2,Mod17S2,Model_3,Price_3,PaintJob_3,Color1_3,Color2_3,PlateS3,LockedS3,Mod1S3,Mod2S3,Mod3S3,Mod4S3,Mod5S3,Mod6S3,Mod7S3,Mod8S3,Mod9S3,Mod10S3,Mod11S3,Mod12S3,Mod13S3,Mod14S3,Mod15S3,Mod16S3,Mod17S3,FROM vehicles WHERE Owner='Oblivion'")
3
4
5// The table
6CREATE TABLE IF NOT EXISTS `vehicles` (
7 `ID` mediumint(6) NOT NULL AUTO_INCREMENT,
8 `Owner` varchar(24) NOT NULL,
9 `Model` mediumint(6) NOT NULL,
10 `Price` int(10) NOT NULL,
11 `Locked` tinyint(1) NOT NULL DEFAULT 1,
12 `PaintJob` smallint(3) NOT NULL DEFAULT -1,
13 `Color1` smallint(3) NOT NULL DEFAULT 0,
14 `Color2` smallint(3) NOT NULL DEFAULT 0,
15 `Plate` varchar(12) NOT NULL DEFAULT '*',
16 `Mod1` smallint(5) unsigned NOT NULL DEFAULT 0,
17 `Mod2` smallint(5) unsigned NOT NULL DEFAULT 0,
18 `Mod3` smallint(5) unsigned NOT NULL DEFAULT 0,
19 `Mod4` smallint(5) unsigned NOT NULL DEFAULT 0,
20 `Mod5` smallint(5) unsigned NOT NULL DEFAULT 0,
21 `Mod6` smallint(5) unsigned NOT NULL DEFAULT 0,
22 `Mod7` smallint(5) unsigned NOT NULL DEFAULT 0,
23 `Mod8` smallint(5) unsigned NOT NULL DEFAULT 0,
24 `Mod9` smallint(5) unsigned NOT NULL DEFAULT 0,
25 `Mod10` smallint(5) unsigned NOT NULL DEFAULT 0,
26 `Mod11` smallint(5) unsigned NOT NULL DEFAULT 0,
27 `Mod12` smallint(5) unsigned NOT NULL DEFAULT 0,
28 `Mod13` smallint(5) unsigned NOT NULL DEFAULT 0,
29 `Mod14` smallint(5) unsigned NOT NULL DEFAULT 0,
30 `Mod15` smallint(5) unsigned NOT NULL DEFAULT 0,
31 `Mod16` smallint(5) unsigned NOT NULL DEFAULT 0,
32 `Mod17` smallint(5) unsigned NOT NULL DEFAULT 0,
33 `Model_2` mediumint(6) NOT NULL DEFAULT 0,
34 `Price_2` int(10) NOT NULL DEFAULT 0,
35 `Paintjob_2` smallint(3) NOT NULL DEFAULT -1,
36 `Color1_2` smallint(3) NOT NULL DEFAULT 0,
37 `Color2_2` smallint(3) NOT NULL DEFAULT 0,
38 `Locked2` tinyint(1) NOT NULL DEFAULT 1,
39 `Plate2` varchar(12) NOT NULL DEFAULT '*',
40 `Mod1S2` smallint(5) unsigned NOT NULL DEFAULT 0,
41 `Mod2S2` smallint(5) unsigned NOT NULL DEFAULT 0,
42 `Mod3S2` smallint(5) unsigned NOT NULL DEFAULT 0,
43 `Mod4S2` smallint(5) unsigned NOT NULL DEFAULT 0,
44 `Mod5S2` smallint(5) unsigned NOT NULL DEFAULT 0,
45 `Mod6S2` smallint(5) unsigned NOT NULL DEFAULT 0,
46 `Mod7S2` smallint(5) unsigned NOT NULL DEFAULT 0,
47 `Mod8S2` smallint(5) unsigned NOT NULL DEFAULT 0,
48 `Mod9S2` smallint(5) unsigned NOT NULL DEFAULT 0,
49 `Mod10S2` smallint(5) unsigned NOT NULL DEFAULT 0,
50 `Mod11S2` smallint(5) unsigned NOT NULL DEFAULT 0,
51 `Mod12S2` smallint(5) unsigned NOT NULL DEFAULT 0,
52 `Mod13S2` smallint(5) unsigned NOT NULL DEFAULT 0,
53 `Mod14S2` smallint(5) unsigned NOT NULL DEFAULT 0,
54 `Mod15S2` smallint(5) unsigned NOT NULL DEFAULT 0,
55 `Mod16S2` smallint(5) unsigned NOT NULL DEFAULT 0,
56 `Mod17S2` smallint(5) unsigned NOT NULL DEFAULT 0,
57 `Model_3` mediumint(5) NOT NULL DEFAULT 0,
58 `Price_3` int(10) NOT NULL DEFAULT 0,
59 `Paintjob_3` smallint(3) NOT NULL DEFAULT -1,
60 `Color1_3` smallint(3) NOT NULL DEFAULT 0,
61 `Color2_3` smallint(3) NOT NULL DEFAULT 0,
62 `LockedS3` tinyint(1) NOT NULL DEFAULT 1,
63 `PlateS3` varchar(12) NOT NULL DEFAULT '*',
64 `Mod1S3` smallint(5) unsigned NOT NULL DEFAULT 0,
65 `Mod2S3` smallint(5) unsigned NOT NULL DEFAULT 0,
66 `Mod3S3` smallint(5) unsigned NOT NULL DEFAULT 0,
67 `Mod4S3` smallint(5) unsigned NOT NULL DEFAULT 0,
68 `Mod5S3` smallint(5) unsigned NOT NULL DEFAULT 0,
69 `Mod6S3` smallint(5) unsigned NOT NULL DEFAULT 0,
70 `Mod7S3` smallint(5) unsigned NOT NULL DEFAULT 0,
71 `Mod8S3` smallint(5) unsigned NOT NULL DEFAULT 0,
72 `Mod9S3` smallint(5) unsigned NOT NULL DEFAULT 0,
73 `Mod10S3` smallint(5) unsigned NOT NULL DEFAULT 0,
74 `Mod11S3` smallint(5) unsigned NOT NULL DEFAULT 0,
75 `Mod12S3` smallint(5) unsigned NOT NULL DEFAULT 0,
76 `Mod13S3` smallint(5) unsigned NOT NULL DEFAULT 0,
77 `Mod14S3` smallint(5) unsigned NOT NULL DEFAULT 0,
78 `Mod15S3` smallint(5) unsigned NOT NULL DEFAULT 0,
79 `Mod16S3` smallint(5) unsigned NOT NULL DEFAULT 0,
80 `Mod17S3` smallint(5) unsigned NOT NULL DEFAULT 0,
81 PRIMARY KEY (`ID`)
82) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;