CREATE TABLE cl_commodities_text (
	id integer,
	name string,
	description string,
	image string
);
INSERT INTO cl_commodities_text ROWS (
	1,	'Staple Foods',	'Any non-luxury food falls in this tax group.',	'ui/commodity/co',
	2,	'Copper',	'A common metal, highly valued for its electrical properties.',	'ui/commodity/cu',
	3,	'Iron ore',	'A useful ore, though not often in demand.',	'ui/commodity/fe',
	4,	'Mfgd Goods',	'The Ministry of Accounts puts almost any cheap, mass-produced consumer product in this tax group',	'ui/commodity/mg',
	5,	'Shara Pods',	'This bioengineered mushroom is a mildly addictive performance enhancer. Illegal, yet still easy to get.',	'ui/commodity/sh',
	6,	'Bananabis',	'Genetically modified psychotropic fruit , rich in vitamins and nutrients.',	'ui/commodity/md',
	7,	'Antibiotics',	'Uncontrolled antibiotics, highly valued by all practitioners of unlicenced medicine.',	'ui/commodity/ab',
	8,	'Cotton',	'Due to lobbying by the clothing industry, this natural fiber has its own tax group.',	'ui/commodity/cn',
	9,	'Ivory Tusks',	'Horns and tusks collected from several endangered species.',	'ui/commodity/it',
	10,	'Silver',	'A semiprecious metal used in jewelery and several electro-chemical processes.',	'ui/commodity/ag',
	11,	'Gold',	'A precious metal used in jewelry and non-optical circuitry.',	'ui/commodity/au',
	12,	'Platinum',	'An extremely precious metal, used mainly in electro-chemical processes.',	'ui/commodity/pt',
	13,	'Oil',	'Synthetic hydrocarbon compounds and lubricants used in industrial plants.',	'ui/commodity/ol',
	14,	'Organs',	'Unlicenced bioenhancement clinics will pay a fortune for these.',	'ui/commodity/on',
	15,	'Weapons',	'Guns, ammo, grenades, and any other weapon you care to name.',	'ui/commodity/wn',
	16,	'Morphine',	'No longer used in medical facilities, this drug has become popular among the wealthy elite.',	'ui/commodity/mo',
	17,	'Q-N Components',	'Quantum/nuclear components, beloved by underground arms-producers.',	'ui/commodity/nc',
	18,	'ZX Dust',	'An effective poison valued by assasins across the galaxy.',	'ui/commodity/sm',
	19,	'Energy Cells',	'High capacity light-weight energy cells, used mainly in robotics.',	'ui/commodity/ec',
	20,	'Electronics',	'Consumer electronics ranging from low end com systems to household robots.',	'ui/commodity/ht',
	21,	'Gems',	'Gems, while also sold legally, are worth a fortune if smuggled past the tax men.',	'ui/commodity/gm',
	22,	'Ketralite',	'These leaves emit a chemical that limits numeric thinking. Greedy shopkeepers hide them near expensive goods.',	'ui/commodity/kt',
	23,	'Stem Cells',	'Widely used by unlicenced bioenhancement clinics.',	'ui/commodity/sc',
	24,	'Cargo Hold',	'Upgrade your ship to hold more cargo.',	'ui/commodity/ch',
	25,	'Purified Water',	'Water is heavily taxed and regulated due to its scarcity after most natural sources were radiologically contaminated.',	'ui/commodity/wa',
	28,	'Arpulators',	'Arpulators are special engineering devices that are mainly used in the creation and destruction of Quarks and Leptons.',	'',
	29,	'Earth Postcards',	'Postcards from Earth. The picture is of a sunset with the caption ''Greetings from Earth!''.',	'ui/commodity/ep',
	30,	'Venus Postcards',	'Postcards from Venus. They contain a picture of sulfuric acid raining down onto a sea of fire, with several people in hazard suits playing volleyball nearby.',	'ui/commodity/ep',
	31,	'Mars Postcards',	'Postcards from Mars. A scenic view of the famous ''Face of Mars'' is featured in the picture, along with the caption ''Lookin Good!''.',	'ui/commodity/ep',
	32,	'Convoy Postcards',	'Postcards from the traveling ship convoy. A picture of one of the ships as viewed from space is displayed, along with the caption ''WANDERING how you are!''.',	'',
	33,	'Delicious Spices',	'Rare and unique spices, each one more delicious than the last.',	'',
	34,	'Wigs',	'Wigs are pretty. Pretty fun to wear!',	'ui/commodity/wg',
	35,	'Furs',	'Furs poached from various endagered species.',	'',
	36,	'DNA Parasites',	'DNA Parasites that are difficult to trace by medical examiners make excellent assassination agents. Rare and highly illegal, only the most wealthy criminals can use them',	'',
	37,	'Probability Gen.',	'Probability Generators can drastically alter the probability of something happening. The layman term for them is ''Luck Generators''.',	'',
	38,	'Tritium',	'Tritium is a vital material in the creation of Fusion reactors. It is difficult to produce artificially, and it is extremely rare to find it in a natural state.',	'',
	39,	'Coffee',	'After massive blights many years ago, coffee beans are extremely rare. Coffee is now affordable only by the most wealthy of consumers.',	'',
	40,	'Artificial Skin',	'Artificial Skin is a medical breakthrough that gives burn victims a new lease on life. Difficult to produce and maintain, it is still only available to wealthy patients.',	''
);
CREATE TABLE cl_dialogs_answers (
	id integer,
	line integer,
	text string
);
INSERT INTO cl_dialogs_answers ROWS (
	25,	1,	'Yes, let''s go.',
	26,	1,	'Of course, let''s go!',
	27,	1,	'Let''s do it.',
	29,	1,	'I''m ready!',
	30,	1,	'I''m ready for combat.',
	31,	1,	'Alright, I''m ready.',
	32,	1,	'Okay, take me there.',
	33,	1,	'Yes,  I''ll do it.',
	34,	1,	'Yeah, let''s go.',
	35,	1,	'Know about any jobs?',
	38,	1,	'Let''s go!',
	39,	1,	'Yeah, tell me!',
	40,	1,	'I''ll do it.',
	41,	1,	'I''ll go after him.',
	42,	1,	'I''ll take him out.',
	43,	1,	'Yes, I''ll do it.',
	44,	1,	'I''ll do it.',
	45,	1,	'I''ll get the job done.',
	46,	1,	'Alright...',
	47,	1,	'Thanks for the tip!',
	77,	1,	'Moving along.',
	78,	1,	'I''ll keep that in mind.',
	79,	1,	'I will!',
	80,	1,	'Understood!',
	82,	1,	'I''ll try to remember that.',
	83,	1,	'I''ll be sure to pay on time.',
	84,	1,	'No, not hiding anything.',
	85,	1,	'I''ll consider it.',
	86,	1,	'Ketralite, you say?',
	87,	1,	'But traveling is so fun!',
	88,	1,	'No, I''ll be fine. You''re excused.',
	89,	1,	'Fine!',
	90,	1,	'I didn''t realize you were so busy.',
	91,	1,	'Alright, Alright...',
	92,	1,	'I''ll look for one.',
	93,	1,	'I''ll keep quiet!',
	94,	1,	'I''ll check it out.',
	95,	1,	'I''ll look!',
	96,	1,	'Okay.',
	97,	1,	'Stash, you say...',
	98,	1,	'We''ll see.',
	99,	1,	'Sure, sure I do!',
	100,	1,	'Sure I will...',
	101,	1,	'Alright, fine.',
	102,	1,	'Hey, not bad.',
	103,	1,	'That''s interesting!',
	104,	1,	'I won''t, I swear!',
	105,	1,	'I''d like to know more about ^2Trading^-.',
	106,	1,	'Tell me about ^2Buying^- commodities.',
	107,	1,	'Interesting!',
	108,	1,	'I''ll keep that in mind.',
	109,	1,	'Thanks!',
	110,	1,	'I see.',
	111,	1,	'I''ll be careful.',
	112,	1,	'Fine!',
	113,	1,	'Wait, why are you out of stock?',
	114,	1,	'Fine.',
	115,	1,	'Why don''t you have anything to sell?',
	116,	1,	'Bah.',
	117,	1,	'Fine!',
	118,	1,	'Oh well.',
	119,	1,	'Uh oh...',
	120,	1,	'Interesting.',
	121,	1,	'Okay.',
	122,	1,	'That sucks.',
	123,	1,	'Sssssee you later, then.',
	124,	1,	'Bye, then.',
	125,	1,	'Well sorry!',
	126,	1,	'Fine!',
	127,	1,	'Whatever.',
	128,	1,	'Bah!',
	129,	1,	'Addict!?',
	130,	1,	'Alright...',
	131,	1,	'Hey, I''m not trying anything!',
	132,	1,	'I will!',
	133,	1,	'Not right now.',
	134,	1,	'I''ll consider it.',
	135,	1,	'Dan Howle is offering me Bananabis in exchange for Shara Pods!',
	136,	1,	'Thanks!',
	137,	1,	'Hey, crime doesn''t pay!',
	138,	1,	'Yeah, let''s do it.',
	139,	1,	'Thanks!',
	140,	1,	'I don''t know anything!',
	141,	1,	'Nope, not right now.',
	142,	1,	'Maybe I will!',
	143,	1,	'Can I think about it first?',
	144,	1,	'I''m down for it.',
	145,	1,	'Sounds good.',
	146,	1,	'Roger Leiss is illegally offering cash in exchange for Silver.',
	147,	1,	'Thanks a ton.',
	148,	1,	'Sure thing.',
	149,	1,	'I can''t hear it when losers talk.',
	150,	1,	'Sure thing.',
	151,	1,	'Bye.',
	152,	1,	'Alright, I''m interested.',
	153,	1,	'Okay, I''ll give it a shot.',
	154,	1,	'I guess crime DOES pay... me!',
	155,	1,	'Maybe!',
	156,	1,	'Nope.',
	157,	1,	'Jan Seffron is involved in Gem smuggling!',
	158,	1,	'Thanks!',
	25,	2,	'No, not right now.',
	26,	2,	'I don''t want to right now.',
	27,	2,	'No thanks.',
	29,	2,	'I''m not interested.',
	30,	2,	'I don''t think so.',
	31,	2,	'Not right now, thanks.',
	32,	2,	'No thanks!',
	33,	2,	'Not right now, thanks.',
	34,	2,	'Not today.',
	35,	2,	'See you later.',
	38,	2,	'No, I don''t want to.',
	39,	2,	'No, I''m not interested.',
	40,	2,	'Not interested.',
	41,	2,	'No, I''m not ready.',
	42,	2,	'I''m not interested.',
	43,	2,	'No, I don''t want to.',
	44,	2,	'Not interested.',
	45,	2,	'Sorry, not right now.',
	105,	2,	'Tell me about ^2Bounties^-.',
	106,	2,	'I''d like to know about ^2Selling^- commodities.',
	107,	2,	'I have another question...',
	108,	2,	'I have another question...',
	109,	2,	'I have another question...',
	110,	2,	'I have another question...',
	111,	2,	'I have another question...',
	113,	2,	'I''ll leave.',
	115,	2,	'Fine, bye.',
	135,	2,	'Nothing for now!',
	138,	2,	'I''ll get back to you.',
	144,	2,	'I need more time.',
	146,	2,	'Nevermind, it''s nothing.',
	152,	2,	'Not now, sorry.',
	157,	2,	'Nope, nothing to report.',
	105,	3,	'How does ^2Traveling^- work?',
	106,	3,	'How can I meet new ^2Merchants^-?',
	105,	4,	'I''m fine, thanks.',
	106,	4,	'Tell me about ^2Banking^-.',
	160,	1,	'Let''s trade!',
	159,	1,	'No problem!',
	161,	1,	'Mirela Faz over on Venus is looking for a supplier.',
	162,	1,	'Fine, take $500',
	168,	1,	'Sure thing!',
	166,	1,	'Okay.',
	167,	1,	'I''ll think about it!',
	169,	1,	'Thanks for the cargo space!',
	170,	1,	'No problem!',
	164,	1,	'Okay.',
	172,	1,	'Sure, what is it?',
	172,	2,	'Not interested, sorry.',
	173,	1,	'Yeah. Let''s go right now.',
	173,	2,	'Let me think about it.',
	174,	1,	'I''ll try and speak with him.',
	175,	1,	'Alright. I''ll do it.',
	176,	1,	'Okay.',
	177,	1,	'Let''s see you give it a shot!',
	178,	1,	'Merien Sayeed is offering an illegal bounty on James Croft.',
	178,	2,	'No, nothing.',
	179,	1,	'Thanks.',
	180,	1,	'I bet!',
	181,	1,	'I''m interested. What do I need to do?',
	181,	2,	'Not now, sorry.',
	182,	1,	'Alright, let''s do it.',
	183,	1,	'Alright.',
	182,	2,	'Another time.',
	184,	1,	'Alright',
	185,	1,	'Bah',
	186,	1,	'I''ll look into it.',
	187,	1,	'Alright.',
	188,	1,	'I''m here to deliver ^215 Spices^-.',
	188,	2,	'Nevermind for now.',
	189,	1,	'I have a delivery for you.',
	189,	2,	'Nothing for now.',
	190,	1,	'Nice doing business with you.',
	191,	1,	'Let''s go right now.',
	191,	2,	'Let consider it first.',
	193,	1,	'You as well.',
	192,	1,	'Damn.',
	194,	1,	'Fine.',
	196,	1,	'Alright',
	195,	1,	'Sure. What is it?',
	195,	2,	'Not interested.',
	197,	1,	'Let''s go right now!',
	197,	2,	'Lemme think about it.',
	198,	1,	'Sorry.',
	200,	1,	'I''d like to know more about ^2Trading^-.',
	201,	1,	'I''d like to know more about ^2Trading^-.',
	202,	1,	'I''d like to know more about ^2Trading^-.',
	200,	2,	'Tell me about ^2Bounties^-.',
	200,	3,	'How does ^2Traveling^- work?',
	200,	4,	'Got any ^2Souvenirs^- I could have?',
	201,	2,	'Tell me about ^2Bounties^-.',
	201,	3,	'How does ^2Traveling^- work?',
	201,	4,	'Got any ^2Postcards^- to hand out?',
	202,	2,	'Tell me about ^2Bounties^-.',
	202,	3,	'How does ^2Traveling^- work?',
	202,	4,	'Got anything to give away for free?',
	203,	1,	'Alright.',
	204,	1,	'Fine, I have other questions.',
	205,	1,	'Thanks!',
	207,	1,	'Uh, I have different questions.',
	207,	2,	'I have to go. Right now.',
	208,	1,	'Thank you.',
	209,	1,	'Alright.',
	210,	1,	'Nevermind! I have another question.',
	210,	2,	'Alright, I''m going!',
	211,	1,	'Sure thing.',
	213,	1,	'^2Faye Carrol^- asked me to collect an illegal bounty for her.',
	213,	2,	'Nevermind.',
	214,	1,	'Gladly!',
	171,	1,	'Hey, I don''t need your attitude!',
	215,	1,	'Yeah, let''s go.',
	215,	2,	'What did I have to do, again?',
	204,	2,	'You can simulate getting bent!',
	212,	1,	'Alright whatever.',
	199,	1,	'Okay.',
	216,	1,	'I''ll think about it while you put in some ^2Cargo Slots^-.',
	217,	1,	'Fascinating. How much are ^2Cargo Slots^- going for?',
	216,	2,	'I wanted to ask you about ^2Traveling^-.',
	217,	2,	'That''s... uh... actually I wanted to ask about ^2Traveling^-.',
	216,	3,	'Nevermind.',
	218,	1,	'No, no I just want to get ^2Cargo Slots^-.',
	217,	3,	'I''ll be going now.',
	218,	2,	'I''d like to hear your thoughts on ^2Traveling^-.',
	218,	3,	'I have to go.',
	219,	1,	'Uh. I want to upgrade my ^2Cargo Slots^-.',
	219,	2,	'Let''s talk about ^2Traveling.^-',
	219,	3,	'I need to go. And check my bank balance.',
	220,	1,	'Thanks for the information.',
	220,	2,	'I have another question.',
	221,	1,	'I see, thanks.',
	222,	1,	'Dale March has offered me money in exchange for an illegal bounty.',
	222,	2,	'It was nothing, nevermind.',
	223,	1,	'Wow, thanks! A tin!',
	224,	1,	'All I hear is the sound of money in my pocket!',
	225,	1,	'Sure.',
	226,	1,	'Aun Argent is fat.',
	226,	2,	'The Space Cat flies at midnight.',
	226,	3,	'Nikstlitselpmur!',
	226,	4,	'Uh, I don''t remember being told a password?',
	227,	1,	'Wait, let me try again. I think I remember...',
	228,	1,	'Sorry. Let''s try again.',
	229,	1,	'Yes, here they are.',
	229,	2,	'Let me come back...',
	230,	1,	'Yeah, let''s do it!',
	230,	2,	'Let me think about it first.',
	231,	1,	'Sure, I''ll check it out.',
	232,	1,	'Mabye I''ll check it out!',
	233,	1,	'He looks so harmless!',
	234,	1,	'Yeah, garbage continent is pretty gross.',
	235,	1,	'Man, I''m glad a flat taxation rate was never agreed upon.',
	236,	1,	'Congratulations, you''re the creepiest maid I''ve ever seen. Goodbye.',
	237,	1,	'You should see some of the potholes on Earth.',
	238,	1,	'Maybe it''s just you.',
	239,	1,	'Better not say that too loudly...',
	240,	1,	'I''m really more of a Hockey fan.',
	241,	1,	'Don''t bother, you look pretty fragile.',
	242,	1,	'Yeah, but they should have fired the garbage into the sun.',
	243,	1,	'But with risk comes reward...',
	244,	1,	'Maybe they were bored acrobats, and not Traders?',
	245,	1,	'Sounds like more Traders are needed to bring the criminals down.',
	247,	1,	'Yes, let''s go.',
	247,	2,	'No, not yet.',
	248,	1,	'Well, sorry!',
	249,	1,	'Don Braggio is offering an illegal bounty on Rick Thorn.',
	250,	1,	'Wow, thanks.',
	249,	2,	'I don''t know anything!',
	251,	1,	'I can''t hear you over the sound of my money!',
	252,	1,	'Alright.',
	246,	1,	'What a shame. Does he have a business card?',
	206,	1,	'Will do!',
	0,	1,	'Got any jobs for me?',
	0,	2,	'See you later.',
	1,	1,	'Alright.'
);
CREATE TABLE cl_dialogs_text (
	id integer,
	text string
);
INSERT INTO cl_dialogs_text ROWS (
	25,	'There''s a rumor going around that Crusher Carl is using an abandoned train station as a base of operations. I have discovered his location, and I can tell you where it is in exchange for some bounty money.',
	26,	'Sandra Bays and her boys are smuggling all sorts of lovely contraband out of an abandoned underpass nearby. Let me in on some of that bounty money and I''ll tell you exactly where. Are you interested in going?',
	27,	'Dirk Braddock and his men are sitting on a ship in orbit right now, according to my sources. Braddock is a pretty infamous criminal. He''s on the Ministry of Accounts ''Most Wanted'' list. I can help you get onboard, if you''re willing.',
	29,	'The other day I saw Donna Faz, and I followed her to an abandoned underpass that she''s taken over with her men. I can lead you there if you share some bounty money with me.',
	30,	'Fradd is going to inject ^2ZX Dust^- into water supply unless the government pays up. I don''t want to risk my drinking water getting spiked, so I''m hoping you can take him out for me.',
	31,	'My associates on the other side of the law have told me that the famous ''El Gato'' that the Ministry of Accounts has been looking for is hiding out on a rickety old ship in orbit somewhere. I''d be more than willing to show you where, exactly.',
	32,	'Adrian Heross is a nefarious supplier of illegal contraband all over the system. He is currently hiding out in a shut down Water Treatment Facility. I can help you find him and let you take him out if you share some of the bounty money with me.',
	33,	'Jane Heross has been raiding cargo ships leaving the planet for the last few months.  The Ministry of Accounts can''t seem to track her down, but I know exactly where she''s hiding her ship. Give me part of the bounty and I''ll tell you how to get there.',
	34,	'The infamous Ghost Jones is hiding out in a collapsed underpass where the Ministry of Accounts never sends patrols. I can show you the entrance if you promise to let me in on some of that bounty money.',
	35,	'Hey there, Trader. What can I do for you?',
	38,	'Somo Fradd is camped out in an Underpass. I know where he is, and I can tell you how to get at him if you promise me part of the bounty on his head.',
	39,	'Adrian Heross is apparently hiding out on his contraband supply ship in orbit somewhere... I''m one of the few people that know where he is. If you split some bounty money with me, I''ll tell you how to get there.',
	40,	'Brad Krugger is sitting in a nearby warehouse waiting to meet with some of his associates. I''m letting you know so you can go take him down and share some of that sweet, sweet bounty with me.',
	41,	'Word is out that Dirk Braddock and his men are going to hold a Water Treatment Facility for ransom. I know when it''s going to happen, and if you share the bounty with me you can stop him.',
	42,	'The famous criminal ''El Gato'' is planning on striking a nearby Water Treatment Facility soon, he''s planning to hold it hostage unless he gets money. However, an associate of mine tipped me off to the details of their plan, and I could point you in the right direction. Funny, I thought cats hated water...',
	43,	'Ghost Jones, whose real name is still a mystery, is going to destroy a nearby Water Treatment Facility to shake up the Ministry of Accounts. This is also going to interfere with business, so there are several groups interested in having him stopped. I know where and when it''s going to happen - do you want the job?',
	44,	'Faz is running a smuggling operation somewhere in orbit. I know the whereabouts of her ship, and I want you to take her down for the bounty and let me have share in the proceeds.',
	45,	'Heross has a bounty on her head, and she''s hiding out in an abandoned freeway tunnel. Would you be interested in taking care of her if we split part of the bounty?',
	46,	'Sorry, nothing right now.',
	47,	'An excellent way to make some extra cash is to explore around trading areas to see if ^2Merchants^- have left any ^2Stash^- sitting around... they''re boxes of commodities that Merchants have hidden to avoid taxation, but it''s finders keepers!',
	77,	'Are you looking for a little action, something useful to do? There are several ^2bounties^- out on wanted criminals - to try your hand at hunting them down, find some of the more unsavory members of the population. You know where to find them, every planet has a bunch of them.',
	78,	'As a citizen, it is your duty to report any and all ^2Contraband Traders^- that you see. Just because you think you can make some money smuggling ^2Shara Pods^- or ^2Ivory Tusks^- doesn''t mean we won''t find and punish you.',
	79,	'Random inspections by the ^2Ministry of Accounts^- are a necessary and important part of disrupting the flow of contraband. Any resistance will be viewed as sedition, so you''d better stay in line the next time you''re inspected.',
	80,	'If I see you hanging around with any ^2Contraband Traders^- around here, you''ll be meeting the business end of my assault weapon and wishing we''d never met. Understand me?',
	82,	'The ^2Ministry of Accounts^- regularly contracts ^2Bounty^- hunters to go after illegal aliens and other undesirables. If you''re handy with a gun, and have decent detective skills, you should give it a shot. Ask around for more information.',
	83,	'You may not be aware of this, but the ^2Ministry of Accounts^- offers a wide variety of services, at competitive pricing. Our team of auditors will guide you through our taxation system, and help you achieve our financial goals. If you wish to avoid this convenience, be sure to file your taxes on time.',
	84,	'We have detected a substantially large amount of ^2Platinum^- in your cargo hold - as you may or may not know, ^2Platinum^- is used in conjunction with Selenium to mask the signature of illegal commodities... you''re not trying to pull something, Trader?',
	85,	'Keep your nose clean, Trader. Stay away from ^2Contraband^- - stick with ^2Iron Ore^-, it''s a solid investment in todays volatile markets.',
	86,	'Among Traders, ^2Ketralite^- is the latest contraband item of choice. It causes your mind to lose track of things, like numbers and dates, and it can leave you vulnerable to a bad trade. Anyone posessing these items will be dealt with in the SEVEREST manner possible.',
	87,	'You seem to have a knack for trading. Have you considered setting up shop? Merchants that make more than $500,000,000 per month need protection - that''s where I come in.',
	88,	'Do you have any questions of comments? I had no idea such successful Traders visited places such as this.',
	89,	'Get lost, Trader. I''m wasting my time talking to small time scumbags like you.',
	90,	'Beat it, go flip some ^2Copper^- or ^2Staple Foods^-, you''re testing my patience!',
	91,	'The ^2Ministry Of Accounts^- doesn''t take kindly to your loitering. Either start ^2Trading^- or get out.',
	92,	'Spare me your sob story - if you have questions, go talk to a ^2Greeter Bot^-. I''m not interested in hearing you whine.',
	93,	'We don''t like hearing complaints about the ^2Ministry of Accounts^- boarding your ship for inspections and treating you unfairly. Any more and bad things will start happening.',
	94,	'I don''t have time to speak with you, Trader. If you have a question you can speak to a ^2Greeter Bot^-.',
	95,	'Some say that ^2Gold^- is almost always a good investment... but it''s not my job to give out tips. Go do research on your own!',
	96,	'Just because you''ve gotten lucky in a few trades doesn''t mean you can get away with things. The penalties for smuggling shipments of ^2Contraband^- become more expensive to correct the more wealthy you become. Remember who your friends are!',
	97,	'When ^2Contraband Traders^- see us coming, they hide the ^2Stash^- whereever they can. Usually we get all of it, but sometimes Traders discover a few left over boxes. If you find any, you should hand it over immediately or face charges',
	98,	'You seem to be doing well for yourself, Trader. You''re not above the law when it comes to smuggling ^2Contraband^- - you can be inspected at any time!',
	99,	'^2Bounties^- are an excellent way to make extra money and help the government stop criminals at the same time. And you WANT to help your government, right?',
	100,	'When ^2ZX Dust^- touches your skin, it immediately boils and peels off, slowly poisoning you to death. If you see a ^2Contraband Trader^- selling it, report them!',
	101,	'As much as I''d like to help you, your questions would be better answered by a ^2Greeter Bot^-. Go see one of them.',
	102,	'Any ^2Stash^- you find, as long as it''s not ^2Contraband^-, is legally yours to keep. Merchants attempting to avoid taxation on their commodities will hide them all over, hoping to reclaim them after we''re finished our inspections.',
	103,	'That ^2Oil^- that you''re buying and selling so freely wasn''t always synthetic - once, long ago, it was pumped from the Earth in its natural form from fossilized vehicles that had tanks full of petroleum, and was then refined into oil. Now, enough history - go away.',
	104,	'If I spot you smuggling any ^2Ivory Tusks^- I''ll punch your teeth in, Trader. The thought of someone poaching a mighty rhinobird or an innocent elephoat for its tusks or horns just fills me with rage.',
	105,	'Hello, Trader! I''m a ^2Greeter Bot^-, and it''s my job to help you out with any questions you might have. What would you like to know?',
	106,	'What would you like to know about ^2Trading^-? I can tell you about buying, selling, meeting new merchants, and banking.',
	107,	'The ^2Ministry of Accounts^- maintains a ^2Bounty^- on every major criminal. If you can track them down and take them out, you''ll be given the reward. But many informants that tell you the location of these criminals will want a cut of the bounty for their help.',
	108,	'^2Traveling^- takes time! It can take over a month to go between two planets sometimes. If you''re on a tight schedule you should plan your route beforehand.. Sometimes when you travel the ^2Ministry of Accounts^- will inspect and tax your ship. It''s wise to not resist.',
	109,	'Buying ^2Commodities^- is done by speaking to a ^2Merchant^- with commodities in your price range.. It''s usually a good idea to buy something if it''s currently low priced, because it usually goes up after you travel.',
	110,	'Selling  ^2Commodities^- is accomplished by finding the appropriate ^2Merchant^-. Always try to sell your commodities for a profit, otherwise you''re losing money! Sometimes you can find ^2Stash^- lying around, and you can take that Merchants to sell.',
	111,	'Exploriing hubs is essential to meeting ^2Merchants^- that deal with different types of commodities. Be wary of stumbling upon ^2Contraband Traders^-, as they deal in restricted commodities that the ^2Ministry of Accounts^- could fine you for possessing.',
	112,	'Go away, Trader. Come back when you''ve got a little more money in your pocket.',
	113,	'I''m out of stock, Trader, and you couldn''t afford my services even if I were selling. Come back when you can afford my style of living and I might decide to do business with you.',
	114,	'Normally I welcome any and all customers, but I think I''ll pass on you. Come back when you aren''t such a small timer.',
	115,	'Get out of here. I don''t have the patience to deal with someone like you. Besides, I have nothing to sell you anyway.',
	116,	'I don''t know who you THINK you are, but you have no business with someone such as myself. Go trade some ^2Copper^- or something else that fits your skill level.',
	117,	'Go away. I shouldn''t have to keep telling you low level Traders this. Just go away.',
	118,	'Sorry Trader, my main supplier ^2Somo Fradd^- got pinched. I can''t seem to find a new supplier, so I''m out of the business... for now.',
	119,	'^2Somo Fradd^- kidnapped a supplier of mine, and before his family could pay the ransom some gung-ho Trader came in and took him out. Nobody has seen the supplier since... so for the time being, I have nothing to sell.',
	120,	'I doubt you could make a difference, but ^2Adrian Heross^- is making my life a living hell at the moment. He''s gone and raided almost every ship from my suppliers in the last month, leaving me with no stock - and I''m not the only one that''s being affected right now.',
	121,	'Someone as small time as yourself wouldn''t be able to do anything about that insidious ^2Adrian Heross^- raiding my supply ships and leaving me without any stock to sell. Once he''s been apprehended I should be back in business, now leave me be!',
	122,	'Argh, that ^2Brad Krugger^- has taken one of my cargo ships hostage - leaving me without any stock to sell. This is a new low for me.',
	123,	'I''m sssorry Trader, it looksss like I"m out of sssstock for the time being. A ssssupplier of mine is running into trouble with ^2Brad Krugger^- that continuesss to raid cargo shipsss.',
	124,	'I can smell those ^2Shara Pods^- you''ve got from a mile away. Don''t need no trouble from you or the ^2Ministry of Accounts^-, so you''d best take your business elsewhere.',
	125,	'I can''t believe someone like yourself would even consider being involved with the trade of ^2Ivory Tusks^-! You disgust me, go Trade with someone else!',
	126,	'Sorry Trader, I see that ^2Bananabis^- in your inventory. I don''t make deals with bananaheads like yourself!',
	127,	'Don''t think I can''t see those ^2Antibiotics^- in your inventory, Trader. Smuggling contraband like that can net you a hefty fine, and I don''t associate myself with those who take such foolish risks.',
	128,	'Get lost, Trader. I don''t deal with people who think it''s okay to smuggle ^2Weapons^- around the system. Come back when you''ve got some dignity.',
	129,	'I''ve got enough problems in life and don''t need to add onto them by associating with a ^2Morphine^- trading addict like yourself.',
	130,	'I see those ^2Organs^- in your inventory, and I think you''re sick to even consider smuggling those. Get a life and go elsewhere, Trader.',
	131,	'Wait... I smell that! ^2Ketralite^-! You''re trying to drug me into giving you a better deal, aren''t you? Get out of here before I call the ^2Ministry of Accounts^- on you, you waste of air!',
	132,	'I detect that you''re transporting illegal acquired ^2Gems^-, Trader... so you think you can do better in the underworld than with honest Merchants such as myself? Fine, go buy from them then!',
	133,	'Do you have anything to report, Trader?',
	134,	'I''ve got a proposition for you - get me ^215 Shara Pods^-, and I''ll give you some ^2Bananabis^-. What do you say?',
	135,	'What have you got for me, Trader?',
	136,	'I''m not surprised - that rat has been making deals behind our backs for awhile now. I think it''s time the ^2Ministry of Accounts^- hits him where it hurts - his wallet! As for you Trader, here''s a cash reward of ^2$1000^- for your help in this matter.',
	137,	'I hope you get shot and left for dead, Trader! The ^2Ministry of Accounts^- froze my bank account, and now I''m penniless! You''d better watch your back!',
	138,	'So what do you say - you give me ^215 Shara Pods^- and I swap it out with some ^2Bananabis^-? Do we have a deal?',
	139,	'Looks like we both came out ahead on this deal... tell you what, I''ve got a buddy on Mars named ^2Roger Leiss^- who might have some business for you. I''ll tell him I''m sending you.',
	140,	'If you''ve got any info on criminal activities, you''re required to let me know.',
	141,	'Are you here to report an infraction?',
	142,	'Beat it, go make some connections before you talk to me.',
	143,	'You must be the Trader that helped out Dan over on Venus. He seems to think you''re on the level, so I''ve got a proposal for you - I''m on a bit of a ^2trading probation^- right now, so get me ^25 Silver^-, and I''ll slide you ^2$17,000^-. What do you say?',
	144,	'You know the deal - give me ^25 Silver^- and I give you ^2$17,000^-. Yes or no?',
	145,	'Nicely done. Both Dan and I are impressed with your business skills... you should consider speaking with an associate of mine over on Earth named ^2Jan Seffron^-. I''ll let her know who you are.',
	146,	'What information do you have for me?',
	147,	'Sounds like Roger is back to his old tricks. We''ll be sure to fine him accordingly. But for your help in this matter, I''m authorized to reward you ^2$1500^-. Now I don''t believe we have anymore business, so... leave.',
	148,	'Go speak with ^2Jan Seffron^- over on Earth, I''m sure she''s got some work for you.',
	149,	'You''ll regret that stunt you pulled on me. I have connections, Trader! Big connections! Get out of my face!',
	150,	'Like I said, Trader - go talk to ^2Roger Leiss^- on Mars, he''s probably got some business he can do with you.',
	151,	'I''m not interested in whatever you have to say, Trader. Go earn my attention.',
	152,	'Leiss let me know you would be showing up around here. I''ve got a job for you - and it''s an easy one. My boss ^2Don Braggio^- needs someone to smuggle ^210 Gems^- to ^2Mars^- for him. He''ll pay you a generous price for them, and you''ll earn his favor.',
	153,	'I don''t have ^2Gems^- on me, so you''ll have to figure that one out on your own. But once you get ^210^-, ^2Don Braggio^- will be waiting for you on the ^2Mars^-. Now hurry up and get this done!',
	154,	'You messed up, Trader. Don Braggio could have hooked up with some really high-class work - but you threw it all away. And don''t think you won''t be punished for this.',
	155,	'Don Braggio has informed me that you did well. This could open up some big doors for you.',
	156,	'Grab ^210 Gems^-, travel to ^2Mars^-, and deliver them to ^2Don Braggio^-. That''s not TOO taxing, is it?',
	157,	'Are you here to report an infraction?',
	158,	'We''ll begin investigating his trafficking activities immediately. Thanks for the information, Trader! As a reward for helping us curb these nefarious criminals, here''s ^2$3,500^-!',
	159,	'I see you found me a new supplier, Trader. I''m in your debt. Here, I''ll expand your cargo capacy by ^25^-, how does that sound?',
	160,	'I''m back in business full swing now - thanks again! Shall we trade?',
	161,	'Hey, buzz off. I don''t deal with Traders. I''m more of a behind the scenes type guy.',
	162,	'Hmm, ^2Mirela Faz^-? I know her, she stiffed me on a bar tab a few years ago. I suppose I COULD supply her, but I''m an awfully lazy man... ^2$500^- might get me motivated. What do you say?',
	163,	'Alright, we''ve got a deal then. I''ll start sending some items her way right away.',
	164,	'Get lost. I''m busy counting money in my head.',
	165,	'I''m already supplying Mirela Faz, what else do you want!?',
	166,	'Howdy there! Would you mind doing me a tiny favor? I like to collect ^2Postcards^- from spots all over the solar system, but I haven''t been able to travel very much lately! Greeter Bots all over the solar system hand them out for free!',
	167,	'Well, if you wouldn''t mind picking me up a postcard from Earth, Mars, and Venus while you''re out and about I''d be mighty appreciative! I''ll throw in a bonus for you, too!',
	168,	'Wow! You got all the ^2Postcards^-! You''re the best! Here, in exchange for these awesome postcards, I''ll upgrade your Cargo space by ^215 Units^-! What do you say?',
	169,	'Great! Thanks again Trader, I really appreciate you finding these for me!',
	170,	'Thanks again for those ^2Postcards^-!',
	171,	'I apologize, but I simply can''t be seen dealing with someone as... financially challenged as yourself. Move along.',
	172,	'You can handle a gun, right? Want a job?',
	173,	'It''s a bounty I want you to collect. It''s a slightly less than legal, so keep it on the down low. I need you to take out a competitor of mine... ^2James Croft^-. You''ll get ^2$2500^- and you can keep whatever stash you find on him. Deal?',
	174,	'Good, ^2James Croft^- has been taken out and I got the items I wanted from him. You have a good head on your shoulders, you should talk to ^2Tyr Durant^-, he''s been looking for someone to do a job for him. Look for him here on ^2Earth^-.',
	175,	'I need you to take ^215 Delicious Spices^- to my associate ^2Dale March^- on Mars. But before you accept, know that the Ministry of Accounts will be out in force - they can detect ships carrying ^2Delicious Spices^- and might hassle you.',
	176,	'Sorry, I''ll need you to clear some space in your Cargo Hold first. Come back when you''re ready.',
	177,	'^2James Croft^- escaped, you fool! I don''t even know why I even bothered with you.',
	178,	'Do you have anything to report?',
	179,	'I thought she was involved in something criminal. As a reward, we''ve given you ^2$4500^- to spend as you please. I recommend investing in the local economy. Now get moving.',
	179,	'I thought she was involved in something criminal. As a reward, we''ve given you ^2$4500^- to spend as you please. I recommend investing in the local economy. Now get moving.',
	180,	'You ratted me out, and now the Ministry of Accounts has frozen my accounts. I''d watch my back if I were you, Trader... the streets won''t be safe for you much longer.',
	181,	'Listen, I need someone to transport some... less than legal goods for me. If you''re up for the job, I can arrange to have you rewarded handsomely.',
	182,	'I''ve loaded you up with ^215 Spices^-, and I need you to take them to ^2Dale March^- on ^2Mars^-. The Ministry of Accounts will be sticking their noses in every ship that leaves here if they hear I''ve found a carrier, so you''ll have to be careful.',
	183,	'Nevermind, you don''t have enough Cargo Space. Go make some room and come back.',
	184,	'You''ve got the stuff now, so get to it.',
	185,	'I had a smuggling job, but someone already took it. Too bad!',
	186,	'Sorry I sent you to the wrong spot, but I guess you managed decent enough. If you haven''t done so already, you may want to speak with ^2Merien Sayeed^- here on ^2Earth^-. I heard her talking about needing someone to do a job.',
	187,	'What? ^2Spices^-? You''re all mixed up, Trader. These are supposed to go to ^2Faye Carrol^- on ^-Venus^2. Get over there!',
	188,	'What can I do for you, Trader?',
	189,	'What do you want?',
	190,	'Excellent, these are the ^2Spices^- I was promised. You do good work, Trader. And I''m sure the Ministry of Accounts hounded you the entire time you were smuggling these for me. As a reward, I''ve given you ^2$15,000^-.',
	191,	'Since you did such excellent work with that smuggling operation, I have a bounty that you may be interested in. It''s off the books, so the Ministry of Accounts won''t approve... but if you want him, ^2Hastur Sayeed^- is yours for the taking. Well?',
	192,	'Bad news, ^2Hastur Sayeed^- got away. You should have tried a little harder, Trader. I have no leads on where he went.',
	193,	'Great work, Trader. Sayeed is gone and you''ve earned a name for yourself. Good doing business with you.',
	194,	'I have neither the time nor the inclination to speak with you.',
	195,	'Are you looking for some extra work?',
	196,	'We don''t have any business, Trader.',
	197,	'I''ve got someone I need you to take out. It''s not a legal bounty, but I think you''ll find that the price is right. ^2Chris Brass^- needs to be dealt with as soon as possible - what do you say?',
	198,	'You failed me, Trader! You let Brass get away. I don''t have a clue where he''s gone to!',
	199,	'Great work with Chris Brass, Trader. I may have more work for you in the future.',
	200,	'Hello, Trader! I''m a ^2Greeter Bot^-, and it''s my job to help you out with any questions you might have. What would you like to know?',
	201,	'Hello, Trader! I''m a ^2Greeter Bot^-, and it''s my job to help you out with any questions you might have. What would you like to know?',
	202,	'Hello, Trader! I''m a ^2Greeter Bot^-, and it''s my job to help you out with any questions you might have. What would you like to know?',
	203,	'I''m sorry, but you''ll need to clear some space in your inventory before I can give you a free ^2Postcard^-.',
	204,	'I''ve already given you a ^2Postcard^-, Trader. I have a positronic brain so advanced that I can simulate entire star systems in real time, and you think you can trick me into giving you another!?',
	205,	'Why yes, in fact. Take this free ^2Postcard^- from the Mars Tourism Authority. It features some wonderful artwork!',
	206,	'Go clear some space in your inventory! I have a ^2Postcard^- I can give away, but you don''t have a place to put it!',
	207,	'Error: ^2Postcard^- already given to Trader! Attempted robbery suspected. Response not found. Execute Emergency  ''Kill All Humans'' protocol.',
	208,	'Have a free ^2Postcard^-! They make great gifts, and in fact some people collect them! Enjoy!',
	209,	'Normally I would give you a ^2Postcard^-, but you don''t have any room for it in your inventory. Go make some room and I can give it to you.',
	210,	'Another ^2Postcard^-? I''ve already given you one, Trader. Are you running some sort of scheme that I should alert the authorities about? That''s right, I''ve revealed your conspiracy to the world! Get out of here before you''re arrested! Flee!',
	211,	'Have a ^2Postcard^- on the house! The Venus Triumvirate of Touristic Endeavors hopes that you''ll tell your friends about our wonderfully yellow skies!',
	212,	'I have nothing to say to a rat like you.',
	213,	'Do you have something to report?',
	214,	'You''ve done the community a service by reporting her to us. We''ll be freezing her assets immediately. As a reward, please accept ^2$8000^- on our behalf.',
	215,	'Have you decided about that ^2James Croft^- job yet?',
	216,	'Before I put in some more ^2Cargo Slots^-, I wanted to ask... is there any chance we could make a stop at the Interstellar Mechanic Convention? It''s always been my life long dream to go!',
	217,	'Boss! Here for some more ^2Cargo Slots^-? Or do you want to hear another one of my stories? Sure you do! Have I told you about the time I strapped a Probability Generator to a Whale? It just up and turned into a flower! Weird!',
	218,	'Want me to install some more ^2Cargo Slots^-, boss? Oh, and have you heard the new ring tone on my space phone? It''s this hit new song, Cat Jamboree!',
	219,	'I once tried out for the ^2Ministry of Accounts^-, but on the application when they asked if I could be trusted with money I accidentally wrote "Maybe". Now all I can do is install ^2Cargo Slots^-!',
	220,	'^2Banking^- is very simple to take advantage of. You can borrow money from the bank, use it to buy more ^2Commodities^- than you normally could, and then pay the bank back later on. You can also deposit money to gain interest on it! But always remember to keep an eye on your debt to the bank, it can stack up quickly.',
	221,	'^2Traveling^-, huh? Well, a good rule of thumb is to always travel to a planet that''s coming in your direction. Shorter travel times mean more trading opportunities.',
	222,	'What information can you give me, Trader?',
	223,	'Excellent work, Trader. Your informing ways will get you far with the Ministry of Accounts, if you keep it up. We''ll lock his bank accounts and start surveilling him immediately. As a reward for information leading to the disruption of criminal activity, here''s ^2$10,000^-. Additionally a decorative tin will be mailed to you in six to eighty weeks.',
	224,	'I can''t believe your... your audacity! You''ll never be safe again, Trader! Not while I have my contacts gunning for you! Do you hear me?',
	225,	'Unless you have something for me, get out of my sight.',
	226,	'Hrmm, you may be the person I''m waiting for. What is the password?',
	227,	'No, no that''s not it. Maybe I was wrong about you.',
	228,	'What do you think this is, some sort of... of... Adventure game?',
	229,	'Excellent, you passed the test. I believe you have some ^2Gems^- for me? Once they''re mine I''ll be more than happy to transfer no less than ^2$400,000^- into your account.',
	230,	'Since you have proven yourself trustworthy, I have a job for you to do. ^2Rick Thorn^- has been a... well, a THORN in my side for quite some time. I want you to take him out. Are you interested?',
	231,	'If you want to see some great graffiti before it gets washed out, check out the alley off of the main courtyard here on Venus. It''s a pretty seedy place, so keep an eye out.',
	232,	'A lot of the successful Traders eventually head out to Jupiter when they''ve made enough money over here. Jupiter is the latest hotspot for Trading, and colonization efforts are rapidly increasing the demand for materials.',
	233,	'This guy named ^2Harry Growzack^- is really starting to creep me out. Always asks for a post card when I walk past him. He tried to grab me once!',
	234,	'Have you been to Earth? I love it there - ever since they enacted that Cleanup Act a few decades ago, it''s been so clean and fresh. Except for the garbage continent.',
	235,	'If only people would listen to the Ministry of Accounts! My brother decided he would try to skip out on paying docking fees, and some troopers tracked him down the next day. They taxed the hell out of his shins.',
	236,	'Grit^5tings Tra^-der ^8How^-kanIhal^1puuuuu uuuu uu^-? Wo^3uld you ^-liiiii2know aboot ^2CLEANING^- or perhaps I can ^1wwwwwwash^- ^1yo^-ur^2- ^4f^-^5a^-^6c^-^7e^-?? error',
	237,	'The Maglev trains here on Mars are awful - there''s always some sort of obstruction on the track, meaning we have to wait for hours and hours to move. For all the money the Ministry of Accounts collects, they sure don''t seem to spend much on infrastructure.',
	238,	'Decades ago an artificial atmosphere was erected on Mars, and they used to say that the rust smell would go away eventually. Well, it''s still here! Every time I go outside it smells like I''m visiting a junkyard! Lousy red planet!',
	239,	'My grandfather was a Trader before the Ministry of Accounts started taking an active role in policing the space lanes... he said back then you could run into pirates and have everything valuable stolen from you. Nowadays the pirates are gone, but the Ministry of Accounts is doing a fine job replacing them.',
	240,	'Are you a fan of the Venusian Vertices? I saw them play last year in San Frangeles on Earth, against the Earthquakes. When they scored that first duck toss with 5 Leptons to spare in the third Quatloo, I knew they were the best team ever.',
	241,	'Nothing to do but kill time at the bar until the Maglev Train is ready to leave... Maybe I should try taking on a bounty?',
	242,	'The air is so fresh and clean here. Earth is such a paradise! Well, except for the garbage continent. We have to stick our refuse somewhere, I suppose.',
	243,	'There''s a dude around here trying to get people to smuggle some commodity for him... I hope nobody takes him up on his offer, otherwise they''ll get in trouble with the Ministry of Accounts.',
	244,	'Some Traders are real jerks. My cousin on Mars is pretty short, and while he was just standing around minding his own business a group of Traders took turns jumping on top of him! He was so scared that they were going to beat him up, he just stood there while they laughed and tried to build a human pyramid!',
	245,	'What confuses me is that the Ministry of Accounts becoming more and more strict, yet banks are constantly being robbed, ships are being raided, facilities are being taken over, and everything is going down the tubes! What''s the point?',
	246,	'My nephew was a real math whiz in school... but he was a little too smart for his own good. The Ministry of Accounts got ahold of his test scores and whisked him away to some sort of ''Accountant Training Camp'' for a few years. Now he sits in his room all day doing tax returns!',
	247,	'Have you decided to take down that annoying ^2Rick Thorn^- for me yet? I promise the reward will be worth it!',
	248,	'Get out of my sight! Begone! Do you hear me? Out! You failed in your attack on ^2Rick Thorn^-, and now he knows I''m after him! You''ll never work in this town again, Trader.',
	249,	'Hello, Trader. What kind of dirt do you have for me today?',
	250,	'Braggio, eh? We always knew he was involved with something big... I''m no fan of Rick Thorn, but the law is the law. As thanks, please enjoy a $250,000 reward from the Ministry of Accounts. Now beat it, I have a bank account to freeze.',
	251,	'Some day soon you will suffer ^benormously^- for the troubles you have caused me, Trader.',
	252,	'You''ve done it, Trader! The bounty is yours to keep, and you''ve made quite a name for yourself. I may contact you someday in the future, Trader... perhaps we can do further business.',
	0,	'Hello there trader, what can I do for you?',
	1,	'No, nothing today.  Try checking back later.'
);
CREATE TABLE cl_events_text (
	id integer,
	name string,
	description string,
	icon string
);
INSERT INTO cl_events_text ROWS (
	2,	'Famine!',	'Food shortages have struck Earth, causing a sharp rise in the cost of Staple Foods. Millions are without enough to eat and emergency government rations are expected to arrive in',	'foodshortage',
	3,	'Drug Bust!',	'Several Shara Pods shipments destined for Venus have been intercepted by the MOA, prices have skyrocketed. Rumors abound that another large shipment is on its way, and will arrive in',	'drugbust',
	4,	'Plague!',	'Disease overruns Mars! "It''s like that time when a bunch of people died!", says Doctor. Government shipments of medical supplies are expected in',	'plague',
	5,	'Gold Rush!',	'A new gold vein has been discovered on Mars and Manufactured Good prices are raising rapidly. Experts predict this rush will last for',	'goldrush',
	6,	'Crime Wave!',	'A crime wave has struck Venus, and citizens are buying weapons in large numbers. Authorities are planning on launching an anti-crime campaign in',	'crimewave',
	7,	'Smuggler Bust!',	'The MOA has broken up an Organ smuggling ring that was operating on Earth. A shortage of organs has left illegal bio-enhancement clinics paying top dollar for new ones. Criminal groups are taking over, and are estimated to resume smuggling within',	'organarrests',
	8,	'Technology Breakthrough!',	'A new technique for producing Manufactured Goods has been introduced on Earth,  causing a dramatic fall in pricing and a corresponding rise in demand for Copper and Iron Ore. Economists predict this will even out in',	'manufacturingimprovements',
	9,	'Elections!',	'Election season has arrived on Mars, and has been accompanied by the usual rise in assassinations and captures.  Prices for ZX Dust on the black market have shot up. Typically this lasts for',	'electiontime',
	10,	'Metal Shortage!',	'The new Foundry on Venus has caused a sharp rise in the price of Copper, Iron Ore, Platinum, and especially Tritium. Analysts expect this to continue for',	'newfoundry',
	11,	'Lice Outbreak!',	'A plague of lice reduced everyone to buzz cuts! Wigs are in super high demand now, and things are expected get less hairy in',	'liceoutbreak'
);
CREATE TABLE cl_missions_text (
	key string,
	value string
);
INSERT INTO cl_missions_text ROWS (
	'description',	'The inner solar system is yours to explore! Bounties are bountiful and the Ministry of Accounts will start hounding you for taxes!  Will you pay or fight?',
	'title',	'Free Trade',
	'time_units',	'days',
	'win_msg',	'Challenge Completed!',
	'db_version',	'2'
);
CREATE TABLE cl_news_text (
	id integer,
	title string,
	text string,
	sprite integer
);
INSERT INTO cl_news_text ROWS (
	1,	'{events_text.id[ planets.id[ 1 ].event_id ]^name}',	'{events_text.id[ planets.id[ 1 ].event_id ]^description} ^2{planets.id[ 1 ].event_end-GS_TIME:plain}^- {missions_text.key[''time_units'']^value}',	3,
	2,	'{events_text.id[ planets.id[ 2 ].event_id ]^name}',	'{events_text.id[ planets.id[ 2 ].event_id ]^description} ^2{planets.id[ 2 ].event_end-GS_TIME:plain}^- {missions_text.key[''time_units'']^value}',	3,
	3,	'{events_text.id[ planets.id[ 3 ].event_id ]^name}',	'{events_text.id[ planets.id[ 3 ].event_id ]^description} ^2{planets.id[ 3 ].event_end-GS_TIME:plain}^- {missions_text.key[''time_units'']^value}',	3,
	4,	'Vigilantes Wanted',	'^5Security News^- Small time hood ^2Crusher Carl^- was neutralized by one or more anonymous Traders recently. Authorities stated that "More people should take the law into their own hands.".',	1,
	5,	'Bays Behind Bars',	'^5Security News^- The well known ^2Sandra Bays^- has been "Taken care of", according the Ministry of Accounts. Rumors abound that bounty hunters took her down in a recent fire fight, but nothing has been confirmed yet.',	1,
	6,	'Urban Warzone',	'^5Security News^- ^2Dirk Braddock^- has been apprehended by authorities after a violent fire fight. The Ministry of Accounts gave partial credit to a group of vigilante Traders that decided to help them out.',	1,
	7,	'Heavy Cost of Crime Paid',	'^5Security News^- A great cheer rose up from a local ''All-U-Can-Eat'' buffet after the capture of criminal ^2Brad Krugger^- was announced. According to employees, "He ate an awful lot.".',	1,
	8,	'Faz Ousted',	'^5Security News^- ^2Donna Faz^- has been stopped by a group of anonymous Traders after a blazing showdown. A reward was handed out, but authorities refuse to reveal the identities of the bounty hunters.',	1,
	9,	'Pervert Pinched',	'^5Security News^- Social malcontent and goverment branded deviant ^2Somo Fradd^- was finally captured recently. The reward was claimed by one or more persons that wished to remain anonymous.',	1,
	10,	'Less than 9 Lives Now',	'^5Security News^- The mysterious and dangerous ^2El Gato^- is no longer on the prowl after a group of Traders tracked him down and put his fabled ''Nine Lives'' to the test.',	1,
	11,	'Citizens Sleep Securely',	'^5Security News^- Civilians are sleeping easier tonight after the nefarious ^2Adrian Heross^- was brought down in a firefight recently. A reward was claimed, but the details regarding the claimant are unknown at this point.',	1,
	12,	'Big Capture',	'^5Security News^- Ministry of Accounts troopers captured ^2Jane Heross^- and her entire criminal network in a battle that was "Aided by elements of the trading community.", sources say.',	1,
	13,	'Ghost Busted',	'^5Security News^- After years of searching, ^2Ghost Jones^- has been defeated and neutralized at the hands of one or more anonymous bounty hunters. "His reign of terror is over for good. We made sure of that.", Ministry of Accounts officials stated.',	1,
	14,	'^2James Croft^- bounty collected!',	'^1Crime Watch^- Suspected crime boss ^2James Croft^- was brought to justice recently. Details are sketchy, but rumors of a rogue group of Traders performing the act are being investigated by the Ministry of Accounts.',	1,
	15,	'Brass Ejected',	'^1Crime Watch^- Industrialist and entirely legal Arms merchant ^2Chris Brass^-, along with his bodyguardsm, were ''Paid a visit'' recently. Although never convicted of a major crime, the Ministry of Accounts suspect he was involved in a major criminal enterprise.',	1,
	16,	'Kam Krushed',	'^1Crime Watch^- Convicted criminal ^2Kam Gorum^- was attacked and neutralized by a group of criminal Traders recently. He had recently made bail on the charge of smuggling contraband commodities, and authorities are reportedly "Taking their time" investigating his death.',	1,
	17,	'NGL Outraged',	'^1Crime Watch^- A major upset in the world of sports occurred recently  with the death of ^2Hastur Sayeed^-, a famous Elephoat Jockey manager. Authorities claim that the attack was "Motivated by elements of the gambling underworld.".',	1,
	18,	'Suspected Thorn Removal',	'^1Crime Watch^- Suspected crime boss ^2Rick Thorn^- has been reported missing after a recent showdown. Ministry of Accounts officials have initiated a search, but have been quoted as saying "We only have time to look at night, and it''s awfully dark then.".',	1,
	19,	'Fools Gold',	'Gold has risen dramatically in price after it was revealed that a possible new gold vein was merely full of Iron Pyrite.',	4,
	20,	'Caution: Carl Crossing',	'The infamous ^2Crusher Carl^- has been sighted by authorities on ^2{planets_text.id[bosses.id[ npcs.name["Crusher Carl"].id].planet_id]^name}^-. Citizens are being told to keep their small pets indoors at all times, to prevent another incident.',	2,
	21,	'Snitch Spots Sandra',	'^2Sandra Bays^-, wanted on multiple counts of gangsterism, was recently sighted on ^2{planets_text.id[bosses.id[ npcs.name["Sandra Bays"].id].planet_id]^name}^-. ''She is a lot uglier in person.'', says snitch.',	2,
	22,	'Spotted Dirk',	'Authorities are stocking up on animal tranquilizer and searching for clues as to the whereabouts of ^2Dirk Braddock^-, whom was recently spotted on ^2{planets_text.id[bosses.id[ npcs.name["Dirk Braddock"].id].planet_id]^name}^-',	2,
	23,	'Krugger Terrorizes',	'^2Brad Krugger^- has been sighted on ^2{planets_text.id[bosses.id[ npcs.name["Brad Krugger"].id].planet_id]^name}^-. The terrorism color code of ^2Muave^- has been put into effect.',	2,
	24,	'Sunscreen and Criminal Warnings in Effect',	'While vacationing on ^2{planets_text.id[bosses.id[ npcs.name["Donna Faz"].id].planet_id]^name}^-, citizens are encouraged to keep an eye out for wanted criminal ^2Donna Faz^-.',	2,
	25,	'Vanilla Violence',	'^2Somo Fradd^-, wanted by the Ministry of Accounts, has recently been spotted on ^2{planets_text.id[bosses.id[ npcs.name["Somo Fradd"].id].planet_id]^name}^- buying suspicious amounts of iced cream.',	2,
	26,	'The Bad Kitty',	'The kitty themed ^2El Gato^- was sighted on ^2{planets_text.id[bosses.id[ npcs.name["El Gato"].id].planet_id]^name}^- by authorities. He has been implicated in several cat burglaries and bombings in the past year.',	2,
	27,	'Gang Tells All',	'Former members of a gang headed by criminal ^2Adrian Heross^- have indicated that he is currently hiding out on ^2{planets_text.id[bosses.id[ npcs.name["Adrian Heross"].id].planet_id]^name}^-',	2,
	28,	'Parrot Pilfering?',	'^2Jane Heross^- is carrying out unnamed criminal activities on ^2{planets_text.id[bosses.id[ npcs.name["Jane Heross"].id].planet_id]^name}^-, authorities have stated.',	2,
	29,	'Who Are We Gonna Call',	'The mysterious ^2Ghost Jones^- has been spotted by security cameras on ^2{planets_text.id[bosses.id[ npcs.name["Ghost Jones"].id].planet_id]^name}^-. Any and all bounty hunters attempting to bring him down are being warned to use extreme caution.',	2,
	30,	'Delicious Spices',	'You have been asked by ^2Tyr Durant^- to deliver ^2Delicious Spices^- to ^2Dale March^- on ^2Mars^-.',	1,
	0,	'^2Free Trade',	'The inner solar system is yours to explore! Bounties are bountiful and the Ministry of Accounts will start hounding you for taxes!  Scrape together ^2$5,000,000^- to conquer this challenge.',	1
);
CREATE TABLE cl_npcs_text (
	id integer,
	name string
);
INSERT INTO cl_npcs_text ROWS (
	12,	'Jenn Falkos',
	13,	'Gil Tartui',
	17,	'Hala Couzens',
	20,	'Graham Stowgrat',
	23,	'Aun Argent',
	25,	'Bartender',
	27,	'Mai Gorum',
	30,	'Michael Scort',
	55,	'Bartender',
	56,	'Crusher Carl',
	57,	'Sandra Bays',
	58,	'Dirk Braddock',
	59,	'Brad Krugger',
	60,	'Donna Faz',
	61,	'Somo Fradd',
	62,	'El Gato',
	63,	'Adrian Heross',
	64,	'Jane Heross',
	65,	'Ghost Jones',
	67,	'Bartender',
	68,	'Ricky Bates',
	70,	'Teig Phen',
	71,	'Thom Lark',
	73,	'Mirela Faz',
	74,	'Dorai Belouise',
	89,	'Iradine Essons',
	90,	'Carston Sr.',
	93,	'L.S. Bryant',
	94,	'Adrian Oram',
	96,	'Grom Magda',
	97,	'Leesha Harfill',
	98,	'Greeter Bot',
	99,	'Greeter Bot',
	100,	'Greeter Bot',
	101,	'Contraband Officer',
	102,	'Dan Howle',
	103,	'Contraband Officer',
	104,	'Contraband Officer',
	105,	'Roger Leiss',
	106,	'Jan Seffron',
	107,	'Ship Mechanic',
	108,	'Ship Mechanic',
	109,	'Ship Mechanic',
	117,	'Harry Growzack',
	120,	'Tyr Durant',
	125,	'Civilian',
	128,	'Civilian',
	130,	'Civilian',
	131,	'Merien Sayeed',
	132,	'James Croft',
	133,	'Dale March',
	134,	'Faye Carrol',
	135,	'Hastur Sayeed',
	136,	'Chris Brass',
	137,	'Kam Gorum',
	138,	'Rick Thorn',
	139,	'Don Braggio',
	140,	'Civilian',
	141,	'Civilian',
	142,	'Civilian',
	143,	'Civilian',
	144,	'Cleaner Bot',
	145,	'Civilian',
	146,	'Civilian',
	147,	'Civilian',
	148,	'Civilian',
	149,	'Civilian',
	150,	'Civilian'
);
CREATE TABLE cl_planets_text (
	id integer,
	name string,
	description string,
	icon integer,
	model_name string,
	shader_name string,
	icon_name string
);
INSERT INTO cl_planets_text ROWS (
	1,	'Earth',	'Earth is home to the Promenade Trading Station, one of the highest class trading areas in the entire system. It is an open air facility that looks out onto a mountain range, and Merchants pay heavily to have positions there.',	0,	'models/planet',	'ui/starmap/Earth',	'ui/planets/Earth',
	2,	'Mars',	'Martian Trading Zone B2 is the most common destination for Traders and Smugglers going to Mars, and as such it is where most business takes place.',	0,	'models/planet',	'ui/starmap/Mars',	'ui/planets/Mars',
	3,	'Venus',	'The Venusian trading district is one of the oldest in the system, and is tucked deep within one of the industrial cities. Its major non-trading attraction is a popular night club.',	0,	'models/planet',	'ui/starmap/Venus',	'ui/planets/Venus',
	4,	'Sun',	'',	0,	'models/planet',	'ui/starmap/Sun',	'ui/planets/Sun',
	5,	'Convoy',	'A wealthy convoy of star-faring habitats that make random, unscheduled stops at different planets. Typically they stay for only a few weeks or months before moving on to another location.',	0,	'models/planet',	'ui/starmap/???',	'ui/planets/???',
	6,	'Mercury',	'Energy Cells and Helium used for Fusion are the principal exports of Mercury. The Trading Annex is inside of the smaller transport hubs of the planet, and is very spartan in appearance.',	0,	'models/planet',	'ui/starmap/???',	'ui/planets/???'
);
