· 7 years ago · Jan 08, 2019, 12:32 AM
1DROP TABLE IF EXISTS `jobs_list`;
2CREATE TABLE IF NOT EXISTS `jobs_list` (
3 `sort_index` tinyint(3) NOT NULL,
4 `name` varchar(20) NOT NULL,
5 `title` varchar(40) NOT NULL,
6 `subtitle` varchar(40) NOT NULL,
7 `description` text NOT NULL,
8 `prereqs` text NOT NULL,
9 `require_alive` tinyint(1) NOT NULL DEFAULT '0',
10 `injury_chance` tinyint(3) NOT NULL DEFAULT '0',
11 `levels` text NOT NULL,
12 `pay` text NOT NULL,
13 `ranks` text NOT NULL,
14 `energy` smallint(5) NOT NULL,
15 `job_limit` tinyint(3) NOT NULL,
16 `time` smallint(5) NOT NULL,
17 `category` varchar(20) NOT NULL,
18 `avatar_job` tinyint(1) NOT NULL DEFAULT '0',
19 `drops` text NOT NULL,
20 `drop_rates` text NOT NULL,
21 `active` tinyint(1) NOT NULL DEFAULT '0',
22 PRIMARY KEY (`name`),
23 KEY `sort_index` (`sort_index`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26--
27-- Dumping data for table `jobs_list`
28--
29
30INSERT INTO `jobs_list` (`sort_index`, `name`, `title`, `subtitle`, `description`, `prereqs`, `require_alive`, `injury_chance`, `levels`, `pay`, `ranks`, `energy`, `job_limit`, `time`, `category`, `avatar_job`, `drops`, `drop_rates`, `active`) VALUES
31(5, 'astronomy', 'Observatory : Astronomy', 'Astronomy', 'Use the advanced technology at your disposal to map out the stars from the safety of the observatory.', '', 0, 0, '0#50#125#250#500#800#1300#1800#2000', '30#32#34#36#39#42#46#50#60', 'Astronomer#Map Designer#Telescope Operator#Telescope Designer#Meteorologist#Dimensional Research#Black Hole Research#Time Travel Research#Head of Astrology', 400, 4, 90, 'Basic Jobs', 1, '', '', 1),
32(6, 'cmining', 'Crystal Mining', 'Crystal Mining', 'A very energy demanding job found in privately owned mines. Working here is tedious, but it can be very rewarding in the long run. Just like with X-Corp though, you''re not insured.', 'xcorp:5', 1, 40, '0#20#75#125#200#275#325#400#500', '64#74#84#94#104#124#154#174#224', 'Laborer#Mucker#Diamond-Drill Operator#Core Driller#Rockbolter#Mine Planning Engineer#Environmental Officer#Chief Geologist#Metallurgist', 1000, 1, 70, 'Advanced Jobs', 0, 'Small Void Crystal#Small Green Crystal#Small Yellow Crystal#Hard Hat#Medium Green Crystal#Small Null Crystal#Small Air Crystal#Small Water Crystal#Small Fire Crystal#Small Orange Crystal#Small Pink Crystal#Small Golden Nugget#Small Golden Nugget#Hard Hat#Hard Hat', '', 1),
33(4, 'explore', 'Observatory : Exploration', 'Exploring', 'Explore the countless dimensions and locations in the universe with the help of the observatory and report your findings back to them for study.', '', 1, 20, '0#50#125#250#500#800#1300#1800#2000', '40#45#50#55#60#65#70#75#85', 'Away Team#Geographer#Navigator#Geologist#Pilot#Captain#Wormhole Explorer#Spaceship Designer#Quadrant Overseer', 500, 3, 60, 'Basic Jobs', 1, '', '', 1),
34(3, 'hacker', 'X-Corp : Network Hacking', 'X-Corp Hacking', 'X-Corp is the number one business in the Hive. This is because they destroy competition by hacking and stealing. Just try not to get on their bad side.', '', 0, 0, '0#50#125#250#500#800#1300#1800#2000', '10#12#15#20#22#24#26#28#30', 'AOL User#Coffee Boy#Receptionist#Trainee#Script Kiddie#Phreaker#Cracker#Hacker#Master Hacker', 300, 5, 90, 'Basic Jobs', 0, '', '', 1),
35(7, 'lab', 'X-Corp : Research Laboratory', 'Researching', 'X-Corp are always weary about those who work for them. Pay tends to be low until you gain their full trust in order to do their secret projects.', 'hacker:5', 0, 0, '0#50#125#250#500#800#1300#1800', '10#15#20#25#30#35#40#135', 'Laboratory Porter#Laboratory Technician Assistant#Laboratory Technician#Research Development#Weapon Tester#Energy Specialist#Advanced Technology Technician#Top Secret Development Researcher', 500, 6, 50, 'Advanced Jobs', 0, 'Large Power Cell#Power Cell#Power Cell#Power Cell#Generic Blueprint#Power Cell#Power Cell#Rare Blueprint#Power Cell#Bonding Paste#Wires#Spark Powder#Large Power Cell#Large Power Cell', '', 1),
36(2, 'post', 'Post Office : Mail Delivery', 'Post Office', 'Everyone uses the post office, and people are hired as temporary workers to deliver or sort mail when they can.', '', 1, 0, '0#50#125#250#500#800#1300#1800#2000', '8#10#12#15#16#18#20#22#23', 'Cleaner#Help Desk#Mail Sorter#Postman#Delivery Driver#Training Officer#Supervisor#Team Coordinator#Sector Manager', 200, 4, 60, 'Basic Jobs', 0, '', '', 1),
37(1, 'xcorp', 'X-Corp : Underground Mines', 'X-Corp Mining', 'Below the hive is a large mining organization owned by X-Corp. They employ anyone for temporary positions as miners, with a fair wage, but no insurance in the event of an injury.', '', 1, 10, '0#50#125#250#500#800#1300#1800#2000', '10#20#30#40#45#50#55#58#60', 'Slave#Labourer#Worker#Tunneler#Driller#Machine Worker#Machine Engineer#Explosive Expert#Foreman', 500, 5, 60, 'Basic Jobs', 0, 'Small Golden Nugget#Hard Hat#Hard Hat#Hard Hat', '', 1),
38(8, 'xmas', 'Santa''s Toy Factory', 'Toy Factory', 'Work in the happiest environment on Earth. Short shifts, easy work. Working in the Toy Factory over the festive period really does pay off. Santa also offers dividends via random items.', '', 0, 0, '0', '1500', 'Toy Maker', 5000, 1, 20, 'Event Jobs', 0, '', 'Gold Ticket:90#Silver Ticket:70#Bronze Ticket:0', 0);