[DayBay]

Hi guys,

Just made a list for components that fit on vehicles based on this list, and I thought I'd save someone else the trouble and share it with the rest here.

You will notice that wheels have a model of 0, this is because I believe that each model can use the wheels. If I'm incorrect please tell me through a reply, cheers. I also left transfered cars out, since I have no idea what ID to give them to fit all ingame vehicles.

Код:

CREATE TABLE IF NOT EXISTS `components` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `model` int(11) NOT NULL,
 `component_id` int(11) NOT NULL,
 `comment` varchar(64) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=180 ;

INSERT INTO `components` (`id`, `model`, `component_id`, `comment`) VALUES
(1, 560, 1026, 'Sultan Side Skirt Type 1 (L)'),
(2, 560, 1027, 'Sultan Side Skirt Type 1 ®'),
(3, 560, 1028, 'Sultan Exhaust Type 1'),
(4, 560, 1029, 'Sultan Exhaust Type 2'),
(5, 560, 1030, 'Sultan Side Skirt Type 2 ®'),
(6, 560, 1031, 'Sultan Side Skirt Type 1 (L)'),
(7, 560, 1032, 'Sultan Roof Scoop type 1'),
(8, 560, 1033, 'Sultan Roof Scoop type 2'),
(9, 560, 1138, 'Sultan Spoiler type 1'),
(10, 560, 1139, 'Sultan Spoiler type 2'),
(11, 560, 1140, 'Sultan Rear Bumper type 2'),
(12, 560, 1141, 'Sultan Rear Bumper type 1'),
(13, 560, 1169, 'Sultan Front Bumper type 1'),
(14, 560, 1170, 'Sultan Front Bumper type 2'),
(15, 562, 1034, 'Elegy Ehaust type 1'),
(16, 562, 1035, 'Elegy Roof Scoop Type 1'),
(17, 562, 1036, 'Elegy Side Skirt type 1 (L)'),
(18, 562, 1037, 'Elegy Exhaust Type 2'),
(19, 562, 1038, 'Elegy Roof Scoop type 2'),
(20, 562, 1039, 'Elegy Side Skirt type 2 (L)'),
(21, 562, 1040, 'Elegy Side Skirt type 1 ®'),
(22, 562, 1041, 'Elegy Side Skirt type 2 ®'),
(23, 562, 1146, 'Elegy Spoiler type 2'),
(24, 562, 1147, 'Elegy Spoiler type 1'),
(25, 562, 1148, 'Elegy Rear Bumper type 2'),
(26, 562, 1149, 'Elegy Rear Bumper type 1'),
(27, 562, 1171, 'Elegy Front Bumper type 1'),
(28, 562, 1172, 'Elegy Front Bumper type 2'),
(44, 535, 1109, 'Slamvan Rear Bullbars type 1'),
(45, 535, 1110, 'Slamvan Rear Bullbars type 2'),
(46, 535, 1113, 'Slamvan Exhaust type 1'),
(47, 535, 1114, 'Slamvan Exhaust type 2'),
(48, 535, 1115, 'Slamvan Front Bullbars type 1'),
(49, 535, 1116, 'Slamvan Front Bullbars type 2'),
(50, 535, 1117, 'Slamvan Front Bumper'),
(51, 535, 1118, 'Slamvan Side Skirt type 1 (L)'),
(52, 535, 1119, 'Slamvan Side Skirt type 2 (L)'),
(53, 535, 1120, 'Slamvan Side Skirt type 1 ®'),
(54, 535, 1121, 'Slamvan Side Skirt type 2 ®'),
(55, 535, 1018, 'Curved Twin Cylinder Generic Exhaust'),
(56, 535, 1019, 'Twin Cylinder Generic Exhaust'),
(57, 535, 1020, 'Large Generic Exhaust'),
(58, 535, 1021, 'Medium Generic Exhaust'),
(59, 575, 1042, 'Broadway Side Skirt (L)'),
(60, 575, 1099, 'Broadway Side Skirt ®'),
(61, 575, 1043, 'Broadway Exhaust type 2'),
(62, 575, 1044, 'Broadway Exhahst type 1'),
(63, 575, 1174, 'Broadway Front Bumper type 1'),
(64, 575, 1175, 'Broadway Front Bumper type 2'),
(65, 575, 1176, 'Broadway Rear Bumper type 1'),
(66, 575, 1177, 'Broadway Rear Bumper type 2'),
(67, 565, 1045, 'Flash Exhaust type 2'),
(68, 565, 1046, 'Flash Exhaust type 1'),
(69, 565, 1047, 'Flash Side Skirt type 1 (L)'),
(70, 565, 1048, 'Flash Side Skirt type 2 (L)'),
(71, 565, 1049, 'Flash Spoiler type 1'),
(72, 565, 1050, 'Flash Spoiler type 2'),
(73, 565, 1051, 'Flash Side Skirt type 1 ®'),
(74, 565, 1052, 'Flash Side Skirt type 2 ®'),
(75, 565, 1053, 'Flash Roof Scoop type 2'),
(76, 565, 1054, 'Flash Roof Scoop type 1'),
(77, 565, 1150, 'Flash Rear Bumper type 1'),
(78, 565, 1151, 'Flash Rear Bumper type 2'),
(79, 565, 1152, 'Flash Front Bumper type 2'),
(80, 565, 1153, 'Flash Front Bumper type 1'),
(81, 561, 1055, 'Stratum Roof Scoop type 1'),
(82, 561, 1056, 'Stratum Side Skirt type 1 (L)'),
(83, 561, 1057, 'Stratum Side Skirt type 2 (L)'),
(84, 561, 1058, 'Stratum Spoiler type 1'),
(85, 561, 1059, 'Stratum Exhaust type 2'),
(86, 561, 1060, 'Stratum Spoiler type 2'),
(87, 561, 1061, 'Stratum Roof Scoop type 2'),
(88, 561, 1062, 'Stratum Side Skirt type 1 ®'),
(89, 561, 1063, 'Stratum Side Skirt type 2 ®'),
(90, 561, 1064, 'Stratum Exhaust type 1'),
(91, 561, 1154, 'Stratum Rear Bumper type 1'),
(92, 561, 1155, 'Stratum Front Bumper type 1'),
(93, 561, 1156, 'Stratum Rear Bumper type 2'),
(94, 561, 1157, 'Stratum Front Bumper type 2'),
(95, 559, 1065, 'Jester Exhaust type 1'),
(96, 559, 1066, 'Jester Exhaust type 2'),
(97, 559, 1067, 'Jester Roof Scoop type 1'),
(98, 559, 1068, 'Jester Roof Scoop type 2'),
(99, 559, 1069, 'Jester Side Skirt type 1 (L)'),
(100, 559, 1070, 'Jester Side Skirt type 2 (L)'),
(101, 559, 1071, 'Jester Side Skirt type 1 ®'),
(102, 559, 1072, 'Jester Side Skirt type 2 ®'),
(103, 559, 1173, 'Jester Front Bumper type 2'),
(104, 559, 1160, 'Jester Front bumper type 1'),
(105, 559, 1159, 'Jester Rear Bumper type 1'),
(106, 559, 1161, 'Jester Rear bumper type 2'),
(107, 559, 1158, 'Jester Spoiler type 2'),
(108, 559, 1162, 'Jester Spoiler type 1'),
(109, 558, 1088, 'Uranus Roof Scoop 1'),
(110, 558, 1089, 'Uranus Exhaust Type 1'),
(111, 558, 1090, 'Uranus Side Skirt type 1 (L)'),
(112, 558, 1091, 'Uranus Roof Scoop 2'),
(113, 558, 1092, 'Uranus Exhaust Type 2'),
(114, 558, 1093, 'Uranus Side Skirt type 2 (L)'),
(115, 558, 1094, 'Uranus Side Skirt type 1 ®'),
(116, 558, 1095, 'Uranus Side Skirt type 2 ®'),
(117, 558, 1163, 'Uranus Spoiler type 2'),
(118, 558, 1164, 'Uranus Spoiler type 1'),
(119, 558, 1165, 'Uranus Front Bumper type 2'),
(120, 558, 1166, 'Uranus Rear Bumper type 2'),
(121, 558, 1167, 'Uranus Front Bumper type 1'),
(122, 558, 1168, 'Uranus Rear Bumper type 1'),
(123, 534, 1100, 'Remington Misc. Part 1'),
(124, 534, 1101, 'Remington Side Skirt type 1 ®'),
(125, 534, 1122, 'Remington Side Skirt type 1 (L)'),
(126, 534, 1124, 'Remington Side Skirt type 2 ®'),
(127, 534, 1106, 'Remington Side Skirt type 2 (L)'),
(128, 534, 1123, 'Remington Misc. Part 2'),
(129, 534, 1125, 'Remington Misc. Part 3'),
(130, 534, 1126, 'Remington Exhaust type 1'),
(131, 534, 1127, 'Remington Exhaust type 2'),
(132, 534, 1178, 'Remington Rear Bumper type 2'),
(133, 534, 1179, 'Remington Front Bumper type 1'),
(134, 534, 1180, 'Remington Rear Bumper type 2'),
(135, 534, 1185, 'Remington Front Bumper type 2'),
(136, 536, 1103, 'Blade Roof type 2'),
(137, 536, 1104, 'Blade Exhaust type 1'),
(138, 536, 1105, 'Blade Exhaust type 2'),
(139, 536, 1181, 'Blade Front Bumper type 2'),
(140, 536, 1182, 'Blade Front Bumper type 1'),
(141, 536, 1183, 'Blade Rear Bumper type 2'),
(142, 536, 1184, 'Blade Rear Bumper type 1'),
(143, 536, 1107, 'Blade Side Skirt ®'),
(144, 536, 1108, 'Blade Side Skirt (L)'),
(145, 536, 1128, 'Blade Roof Type 1'),
(146, 567, 1102, 'Savanna Side Skirt ®'),
(147, 567, 1133, 'Savanna Side Skirt (L)'),
(148, 567, 1132, 'Savanna Exhaust type 2'),
(149, 567, 1129, 'Savanna Exhaust type 1'),
(150, 567, 1130, 'Savanna Roof type 1'),
(151, 567, 1131, 'Savanna Roof type 2'),
(152, 567, 1186, 'Savanna Rear Bumper type 2'),
(153, 567, 1187, 'Savanna Rear Bumper type 1'),
(154, 567, 1188, 'Savanna Front Bumper type 2'),
(155, 567, 1189, 'Savanna Front Bumper type 1'),
(156, 576, 1134, 'Tornado Side Skirt (L)'),
(157, 576, 1135, 'Tornado Exhaust type 2'),
(158, 576, 1136, 'Tornado Exhaust type 1'),
(159, 576, 1137, 'Tornado Side Skirt ®'),
(160, 576, 1190, 'Tornado Rear Bumper type 1'),
(161, 576, 1191, 'Tornado Rear Bumper type 2'),
(162, 576, 1192, 'Tornado Front Bumper type 1'),
(163, 576, 1193, 'Tornado Front Bumper type 2'),
(164, 0, 1073, 'Wheel Arch Angels Wheel type 6'),
(165, 0, 1074, 'Wheel Arch Angels Wheel type 3'),
(166, 0, 1075, 'Wheel Arch Angels Wheel type 2'),
(167, 0, 1076, 'Loco'' Low Co. Wheel type 4'),
(168, 0, 1077, 'Loco'' Low Co. Wheel type 1'),
(169, 0, 1078, 'Loco'' Low Co. Wheel type 3'),
(170, 0, 1079, 'Wheel Arch Angels Wheel type 1'),
(171, 0, 1080, 'Wheel Arch Angels Wheel type 5'),
(172, 0, 1081, 'Wheel Arch Angels Wheel type 4'),
(173, 0, 1082, 'Transfender Wheel type 1'),
(174, 0, 1083, 'Loco'' Low Co. Wheel type 2'),
(175, 0, 1084, 'Loco'' Low Co. Wheel type 5'),
(176, 0, 1085, 'Transfender Wheel type 2'),
(177, 0, 1096, 'Transfender Wheel type 3'),
(178, 0, 1097, 'Transfender Wheel type 4'),
(179, 0, 1098, 'Transfender Wheel type 5');

[hanzen]

Thanks