Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

6 lines (3 sloc) 9.958 kB
use evemu;
INSERT INTO market_orders (typeID, charID, regionID, stationID, bid, price, volEntered, volRemaining, issued, orderState, minVolume, contraband, accountID, duration, isCorp, solarSystemID, escrow, jumps) SELECT typeID, 1 as charID, regionID, stationID, 0 as bid, basePrice as price, 100000000 as volEntered, 100000000 as volRemaining, 129581138737420715 as issued, 1 as orderState, 1 as minVolume,0 as contraband, 0 as accountID, 18250 as duration,0 as isCorp, solarSystemID, 0 as escrow, 1 as jumps FROM staStations, invTypes WHERE solarSystemID in ('30001356', '30001358', '30001360', '30001361', '30001363', '30001365', '30001367', '30001368', '30001370', '30001372', '30001373', '30001375', '30001377', '30001379', '30001380', '30001382', '30001384', '30001386', '30001387', '30001389', '30001391', '30001392', '30001394', '30001396', '30001398', '30001399', '30001401', '30001403', '30001404', '30001406', '30001408', '30001410', '30001411', '30001413', '30001415', '30001417', '30001418', '30001420', '30001422', '30001423', '30001425', '30001427', '30001429', '30001430', '30001432', '30001434', '30001436', '30001437', '30001439', '30001441', '30001442', '30001444', '30001446', '30001448', '30011392', '30021392', '30041407') AND published = 1 and raceID in ('4', '1', '8', '2', '32') and groupID in ('474', '376', '654', '372', '374', '377', '914', '913', '1041', '656', '726', '655', '722', '653', '725', '375', '373', '648', '657', '46', '126', '966', '518', '405', '410', '342', '98', '163', '328', '348', '326', '329', '349', '325', '350', '62', '142', '528', '772', '324', '397', '96', '162', '309', '339', '352', '367', '400', '1042', '419', '489', '27', '107', '712', '284', '898', '90', '172', '863', '864', '303', '718', '544', '61', '141', '76', '156', '87', '169', '768', '767', '43', '123', '915', '873', '883', '944', '29', '109', '47', '127', '547', '643', '225', '1019', '476', '878', '330', '401', '104', '815', '346', '100', '176', '906', '1027', '540', '526', '1010', '662', '484', '429', '317', '447', '334', '535', '365', '471', '266', '308', '905', '830', '285', '370', '378', '386', '26', '106', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '783', '300', '658', '838', '839', '60', '140', '716', '917', '538', '333', '728', '731', '730', '979', '729', '732', '734', '735', '733', '88', '170', '1004', '954', '420', '487', '304', '485', '537', '647', '407', '408', '645', '586', '644', '646', '357', '273', '20', '178', '313', '202', '131', '201', '130', '80', '160', '753', '514', '893', '955', '439', '639', '272', '381', '503', '409', '71', '151', '837', '67', '147', '68', '148', '660', '53', '133', '271', '958', '882', '543', '765', '1063', '1026', '505', '139', '1023', '549', '396', '395', '394', '445', '833', '881', '513', '525', '86', '168', '483', '25', '105', '281', '497', '316', '532', '737', '422', '280', '353', '255', '59', '205', '218', '358', '894', '385', '158', '63', '143', '85', '167', '965', '974', '977', '964', '74', '154', '890', '423', '521', '724', '28', '108', '941', '945', '268', '762', '1012', '831', '589', '541', '428', '902', '707', '590', '258', '652', '384', '283', '640', '832', '710', '302', '900', '530', '269', '976', '663', '475', '92', '174', '18', '463', '477', '482', '727', '101', '177', '901', '54', '134', '546', '314', '84', '166', '56', '511', '136', '862', '524', '506', '512', '510', '771', '256', '507', '508', '501', '509', '449', '413', '430', '417', '414', '426', '438', '418', '364', '361', '371', '498', '17', '427', '416', '916', '1046', '763', '275', '638', '499', '267', '972', '956', '425', '888', '889', '764', '493', '82', '161', '1033', '1044', '1035', '892', '1032', '1025', '1036', '1031', '766', '137', '1028', '289', '83', '165', '55', '135', '957', '1022', '97', '175', '282', '769', '355', '1034', '311', '78', '842', '585', '870', '290', '208', '299', '773', '782', '787', '778', '780', '786', '781', '775', '776', '779', '904', '777', '896', '774', '387', '886', '237', '754', '486', '481', '918', '709', '479', '270', '912', '203', '212', '223', '910', '911', '440', '295', '296', '338', '360', '40', '120', '321', '38', '118', '770', '77', '157', '444', '57', '39', '119', '41', '121', '369', '363', '48', '128', '31', '111', '515', '516', '210', '347', '341', '404', '661', '436', '879', '880', '993', '990', '992', '997', '991', '971', '72', '152', '406', '500', '278', '1005', '1045', '1030', '257', '1040', '65', '145', '441', '641', '536', '834', '480', '1029', '963', '996', '464', '490', '1048', '840', '841', '856', '860', '855', '853', '871', '891', '854', '859', '858', '857', '973', '989', '642', '588', '651', '659', '1013', '492', '49', '129', '472', '478', '379', '504', '877', '721', '1003', '884', '30', '110', '332', '356', '89', '473', '213', '224', '909', '291', '343', '211', '344', '209', '345', '907', '650', '723', '274', '380', '470', '315', '899', '548', '908', '52', '132', '443', '545', '967');
INSERT INTO market_orders (typeID, charID, regionID, stationID, bid, price, volEntered, volRemaining, issued, orderState, minVolume, contraband, accountID, duration, isCorp, solarSystemID, escrow, jumps) SELECT typeID, 1 as charID, regionID, stationID, 0 as bid, basePrice as price, 100000000 as volEntered, 100000000 as volRemaining, 129581140516610715 as issued, 1 as orderState, 1 as minVolume,0 as contraband, 0 as accountID, 18250 as duration,0 as isCorp, solarSystemID, 0 as escrow, 1 as jumps FROM staStations, invTypes WHERE solarSystemID in ('30001356', '30001358', '30001360', '30001361', '30001363', '30001365', '30001367', '30001368', '30001370', '30001372', '30001373', '30001375', '30001377', '30001379', '30001380', '30001382', '30001384', '30001386', '30001387', '30001389', '30001391', '30001392', '30001394', '30001396', '30001398', '30001399', '30001401', '30001403', '30001404', '30001406', '30001408', '30001410', '30001411', '30001413', '30001415', '30001417', '30001418', '30001420', '30001422', '30001423', '30001425', '30001427', '30001429', '30001430', '30001432', '30001434', '30001436', '30001437', '30001439', '30001441', '30001442', '30001444', '30001446', '30001448', '30011392', '30021392', '30041407') AND published = 1 and raceID in ('0') and groupID in ('474', '376', '654', '372', '374', '377', '914', '913', '1041', '656', '726', '655', '722', '653', '725', '375', '373', '648', '657', '46', '126', '966', '518', '405', '410', '342', '98', '163', '328', '348', '326', '329', '349', '325', '350', '62', '142', '528', '772', '324', '397', '96', '162', '309', '339', '352', '367', '400', '1042', '419', '489', '27', '107', '712', '284', '898', '90', '172', '863', '864', '303', '718', '544', '61', '141', '76', '156', '87', '169', '768', '767', '43', '123', '915', '873', '883', '944', '29', '109', '47', '127', '547', '643', '225', '1019', '476', '878', '330', '401', '104', '815', '346', '100', '176', '906', '1027', '540', '526', '1010', '662', '484', '429', '317', '447', '334', '535', '365', '471', '266', '308', '905', '830', '285', '370', '378', '386', '26', '106', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '783', '300', '658', '838', '839', '60', '140', '716', '917', '538', '333', '728', '731', '730', '979', '729', '732', '734', '735', '733', '88', '170', '1004', '954', '420', '487', '304', '485', '537', '647', '407', '408', '645', '586', '644', '646', '357', '273', '20', '178', '313', '202', '131', '201', '130', '80', '160', '753', '514', '893', '955', '439', '639', '272', '381', '503', '409', '71', '151', '837', '67', '147', '68', '148', '660', '53', '133', '271', '958', '882', '543', '765', '1063', '1026', '505', '139', '1023', '549', '396', '395', '394', '445', '833', '881', '513', '525', '86', '168', '483', '25', '105', '281', '497', '316', '532', '737', '422', '280', '353', '255', '59', '205', '218', '358', '894', '385', '158', '63', '143', '85', '167', '965', '974', '977', '964', '74', '154', '890', '423', '521', '724', '28', '108', '941', '945', '268', '762', '1012', '831', '589', '541', '428', '902', '707', '590', '258', '652', '384', '283', '640', '832', '710', '302', '900', '530', '269', '976', '663', '475', '92', '174', '18', '463', '477', '482', '727', '101', '177', '901', '54', '134', '546', '314', '84', '166', '56', '511', '136', '862', '524', '506', '512', '510', '771', '256', '507', '508', '501', '509', '449', '413', '430', '417', '414', '426', '438', '418', '364', '361', '371', '498', '17', '427', '416', '916', '1046', '763', '275', '638', '499', '267', '972', '956', '425', '888', '889', '764', '493', '82', '161', '1033', '1044', '1035', '892', '1032', '1025', '1036', '1031', '766', '137', '1028', '289', '83', '165', '55', '135', '957', '1022', '97', '175', '282', '769', '355', '1034', '311', '78', '842', '585', '870', '290', '208', '299', '773', '782', '787', '778', '780', '786', '781', '775', '776', '779', '904', '777', '896', '774', '387', '886', '237', '754', '486', '481', '918', '709', '479', '270', '912', '203', '212', '223', '910', '911', '440', '295', '296', '338', '360', '40', '120', '321', '38', '118', '770', '77', '157', '444', '57', '39', '119', '41', '121', '369', '363', '48', '128', '31', '111', '515', '516', '210', '347', '341', '404', '661', '436', '879', '880', '993', '990', '992', '997', '991', '971', '72', '152', '406', '500', '278', '1005', '1045', '1030', '257', '1040', '65', '145', '441', '641', '536', '834', '480', '1029', '963', '996', '464', '490', '1048', '840', '841', '856', '860', '855', '853', '871', '891', '854', '859', '858', '857', '973', '989', '642', '588', '651', '659', '1013', '492', '49', '129', '472', '478', '379', '504', '877', '721', '1003', '884', '30', '110', '332', '356', '89', '473', '213', '224', '909', '291', '343', '211', '344', '209', '345', '907', '650', '723', '274', '380', '470', '315', '899', '548', '908', '52', '132', '443', '545', '967');
Jump to Line
Something went wrong with that request. Please try again.