CREATE TABLE cl_commodities_text (
	id integer,
	name string,
	description string,
	image string
);
INSERT INTO cl_commodities_text ROWS (
	0,	'Hydraulic Fluid',	'Hydraulic Fluid is an essential part to the proper operation and continued functioning of mechanical legs. Never leave home without it! If you have mechanical legs, that is.',	'ui/commodity/ol'
);
CREATE TABLE cl_dialogs_answers (
	id integer,
	line integer,
	text string
);
INSERT INTO cl_dialogs_answers ROWS (
	2,	1,	'I''m looking to get my hands on a ship.',
	3,	1,	'Alright, I''ll go speak with ^5Barris^-.',
	3,	2,	'Can you take me back to the ^3Trading Area^- now?',
	4,	1,	'What did you have in mind?',
	5,	1,	'Any idea on how I could get a ship?',
	6,	1,	'I have some other questions...',
	7,	1,	'What can you tell me about ^3Earth^-?',
	8,	1,	'I actually don''t have a ship... yet! Maybe you could sponsor me?',
	9,	1,	'Fine, but I''ll be back later!',
	10,	1,	'Fine, but you haven''t seen the last of me!',
	1,	1,	'Do you think you could help me get a ship?',
	12,	1,	'I''m going.',
	13,	1,	'You wouldn''t be so high and mighty without your chair!',
	0,	1,	'How do I go about finding ''a bucket of bolts''?',
	11,	1,	'Can you help me get a ship of my own?',
	15,	1,	'Geez, no need to be rude! I''ll be off.',
	16,	1,	'Sure, what''s the problem?',
	16,	2,	'Sorry, I have to run.',
	17,	1,	'Okay, so what''s the problem?',
	18,	1,	'Let me guess.  You need me to gather them up and bring them back to you?',
	19,	1,	'Sounds fair enough. I''ll do it!',
	20,	1,	'Bye!',
	22,	1,	'Any interesting news happening around here?',
	21,	1,	'Yeah, it''s right here.',
	21,	2,	'No, not yet.',
	23,	1,	'So who is this contact of yours that can help me get a ship?',
	24,	1,	'Interesting, anything else?',
	25,	1,	'Alright, thanks!',
	26,	1,	'Can you repeat what you told me earlier?',
	27,	1,	'Got any news?',
	28,	1,	'Just checking out the current events.',
	29,	1,	'Do you have the latest lowdown on information?',
	30,	1,	'Hear anything interesting lately?',
	0,	2,	'Can you tell me anything useful?',
	0,	3,	'I''ll get going then.',
	32,	1,	'Fine.',
	31,	1,	'I''ll keep that in mind.',
	33,	1,	'I''m ready, lets go!',
	34,	1,	'Yeah, let''s go right now.',
	34,	2,	'No, I''ll come back later.',
	33,	2,	'Let me come back later.',
	35,	1,	'That doesn''t sound like too bad of a deal...',
	36,	1,	'Alright, I accept!',
	37,	1,	'Thank you.',
	38,	1,	'What kind of test?',
	39,	1,	'Alright, I''ll do it. How do we set this up?',
	39,	2,	'Let me think about this, I''ll be back.',
	40,	1,	'Let''s go right now.',
	40,	2,	'I need some time to prepare, I''ll be back',
	41,	1,	'I''m ready, how do we set this up?',
	41,	2,	'Not yet, I''ll come back.',
	30,	2,	'I need to get my hands on a ship.',
	30,	3,	'Bye!',
	42,	1,	'I need to get my hands on a ship.',
	42,	2,	'Thanks for the information, I''ll see you later.',
	29,	2,	'I need a ship.  Do you know where I can get one?',
	29,	3,	'I''ll be going now.',
	44,	1,	'Know of any way I could get a ship?',
	44,	2,	'Bye!',
	45,	1,	'What''s going on around here?',
	45,	2,	'Thanks for the tip, goodbye!',
	43,	1,	'What news can you tell me?',
	43,	2,	'I''ve gotta go.',
	28,	2,	'I''m looking for a ship.',
	28,	3,	'I''ll be going now.',
	47,	1,	'Any current events?',
	47,	2,	'Goodbye.',
	46,	1,	'Know how I can get a ship?',
	46,	2,	'Goodbye!',
	27,	2,	'I''m looking for a way to get a ship.',
	27,	3,	'I''ll be going now.',
	49,	1,	'I''m going!',
	50,	1,	'I can imagine.',
	51,	1,	'Alright.',
	52,	1,	'I see.',
	53,	1,	'I don''t know anything about ^3Jupiter^-.',
	54,	1,	'I''ll be on my way.',
	55,	1,	'Thanks, I''ll keep that in mind!',
	56,	1,	'Uh, okay.',
	58,	1,	'Well, can you tell me any current news?',
	58,	2,	'Okay grumpypants, I''ll go.',
	57,	1,	'What about a ship? Any idea on how I can get one?',
	57,	2,	'And they say, no news is good news! Geez. I''ll leave you be.',
	22,	2,	'I need a ship.  Do you know how can I get one?',
	22,	3,	'Never mind, I''ll be going.',
	60,	1,	'Any news I should know about?',
	60,	2,	'I''ve gotta run.',
	59,	1,	'Any idea on how I could get a ship?',
	59,	2,	'I have to go.',
	48,	1,	'I''m ready for him now!',
	48,	2,	'Let me come back later.',
	61,	1,	'Alright, lets hear it.',
	1,	2,	'I''ll get going.',
	62,	1,	'Geez, grumpy old man.',
	11,	2,	'Fine!',
	63,	1,	'Point taken.',
	61,	2,	'I need to go. I''ll be back.',
	14,	1,	'Got any work?',
	14,	2,	'I need a ship.  How can I get one?',
	14,	3,	'Bye.',
	64,	1,	'I need to get a ship so I can start trading.  Can you help?',
	64,	2,	'Thanks anyway.',
	65,	1,	'Thanks for the tip.  Got any jobs?',
	65,	2,	'I''ll get going.',
	66,	1,	'I''ll go speak with ^5Barris^-.',
	66,	2,	'Take me back to the ^3Trading Area^-.',
	2,	2,	'I''ll be going.',
	67,	1,	'Problems? What do you mean?',
	68,	1,	'What kind of reference do you need?',
	68,	2,	'I''ll get going.',
	67,	2,	'I''ll be back later.',
	69,	1,	'Alright.',
	19,	2,	'You''re in luck, I already have enough ^2Hydraulic Fluid^-!',
	71,	1,	'I''m ready to try again!',
	71,	2,	'Let me come back later.',
	70,	1,	'Alright, lets hear it.',
	70,	2,	'I need to go, I''ll be back.',
	72,	1,	'I will.',
	72,	2,	'Can we go back to the ^3Trading Hub^- now?',
	7,	2,	'How can I buy and sell?',
	7,	3,	'Tell me again what I should do to get a ship.',
	7,	4,	'I''ll get going now.  Thanks, ^5Greeterbot^-!',
	73,	1,	'I have another question...',
	73,	2,	'I''ll get started, ^5Greeterbot^-.',
	74,	1,	'Interesting.',
	74,	2,	'Goodbye!',
	76,	1,	'Fine.',
	75,	1,	'I''ll check him out.',
	78,	1,	'Okay, okay.',
	77,	1,	'I''ll go, then.',
	79,	1,	'^5Peter Mikhail^- said he would vouch for me.',
	79,	2,	'Nothing, sorry.',
	80,	1,	'Fine.',
	81,	1,	'Okay.',
	82,	1,	'Yeah, it''s right here.',
	82,	2,	'No, not yet.',
	19,	3,	'You''re in luck, I already have enough ^2Hydraulic Fluid^-!'
);
CREATE TABLE cl_dialogs_text (
	id integer,
	text string
);
INSERT INTO cl_dialogs_text ROWS (
	2,	'What do you want, Trader?',
	3,	'Alright Trader, we''re here. This is our central warehouse of the ^5Crimson Corporation^-. You should look for ^5Sally Barris^-, she''s expecting you. When you want to head back to the ^3Trading Area^-, just let me know.',
	4,	'Welcome, Trader. My associate ^5Dex Renor^- tells me you''re in need of a ship. I think I can help you out, there is sure to be an arrangement we both can agree on.',
	5,	'Greetings, Trader! My thaumaturgic sensors detect that you have recently obtained your official trading license. What? No ship? This is bad news! Without a ship you''ll be lucky if anyone gives you the time of day! ',
	6,	'Typically I would suggest purchasing one, but at the price they''re running for these days... Well, let''s just say you might try asking around.  Maybe someone will take pity and loan you the money.  You never know.',
	7,	'What can I help you with, Trader?',
	8,	'Greetings, Trader! Before we begin business I just need my people to run a check on your trading license number and ship location. You can''t be too careful these days.',
	9,	'No ship!? You''re wasting my time! I should have guessed from your shabby appearance. Now please, leave my sight!',
	10,	'How dare you approach me! A Trader without a ship is not worth my time, and time is money!',
	0,	'I''m sorry, I don''t deal with... shipless Traders. Go find yourself a bucket of bolts to haul your cargo around in, and then maybe I''ll be in the mood to work with you.',
	1,	'I''m sorry Trader, but without a ship I can''t really sell you anything. You should start saving your pennies then perhaps one day you can afford one.',
	11,	'First of all, you don''t even own a ship so business is futile. Second of all, I deal in high priced commodities and it takes a certain type of Trader to do business with me... one with money! Now beat it!',
	12,	'What do we have here? Another Faux Trader wasting my time. Without a ship you can''t buy what I sell, so buzz off and bother someone else.',
	13,	'No ship, no money, no chance. Beat it!',
	14,	'How''s it goin'', Trader? What can I do for you?',
	15,	'It is beneath me to deal with such trivialities as the buying and selling of vehicles. You could try asking around here on ^3Earth^-.  Someone there might be able to help. Now please leave, I''ve wasted enough time on you.',
	16,	'Hello there, Trader! Could I trouble you for a moment? I''m in a bit of a pickle and could use some help.',
	17,	'Its these ''old style'' of mechanical legs I have, they need to be topped up constantly with fresh ^2Hydraulic Fluid^-. They leak like a sieve, and not really worth the discount I got on them now that I think about it.',
	18,	'Yesterday a group of hooligans thought they''d have some fun and stole all my boxes of ^2Hydraulic Fluid^2^-. Luckily they just scattered it around, but if I move more than a couple of paces, the legs seize up! I''m stuck!',
	19,	'Yes, if you would be so kind.  I''ll need at least 5 ^2Boxes^-, then I can take care of the rest. I heard through the grapevine that you''re looking for help regarding a ship? I know someone with the ^5Crimson Corporation^-, he may be able to help. ',
	20,	'Thank you, Trader. I''ll wait right here, ha ha!',
	21,	'Hello Trader, have you gathered enough boxes of ^2Hydraulic Fluid^- yet?',
	22,	'What can I do for you?',
	23,	'Thanks a lot, Trader! Soon I''ll be able to move all without sounding like I''m stepping on cats! Heck, soon I''ll be able to move!',
	24,	'A guy by the name of ^5Dex Renor^-, he hangs around here and works for the ^5Crimson Corporation^-. I''m not sure what their deal is, but I hear they help out Traders in need. ',
	25,	'You''ll probably find ^5Dex^- down on the first level somewhere. Tell him I sent you, he owes me one, and that you need some help.',
	26,	'Hello again, Trader. What can I do for you?',
	27,	'Can''t you see I''m quite busy?  What do you need?',
	28,	'Yes, what can I do for you?',
	29,	'Hello Trader!',
	30,	'You have a look of desperation about you.  What do you want?',
	31,	'I''m in the mood to give you a free tip. Once you''re established and the Ministry of Accounts comes knocking, you''ll want to listen closely to what they have to say. If not, they''ll bruise more than your ego.',
	32,	'Well, that''s really none of my concern is it? Begging works on some people, I''m not one of them.',
	34,	'This could be your lucky day. My boss at the ^5Crimson Corporation^- is always willing to lend a helping hand to those in need. ^5Sally Barris^- is her name, she''s headquartered at the company warehouse. Want me to arrange a meeting?',
	33,	'Ready to go meet with ^5Sally Barris^-, Trader? I''m sure she can help you with your ship problem.',
	35,	'Even your most basic trading ship can be very, very expensive. I have a ship I can offer you, but the stipulation is you will owe me ^6$1,500,000^-. I think it''s fair, this is a better rate than the bank, if they''d even look at you.',
	36,	'Oops, I forgot to mention something Trader. So you don''t do something silly like skip out on the bill, your long distance travel function will be disabled. You can only travel between the  ^3Earth^- and the ^3 Moon^-, until I see my money. ',
	37,	'Excellent. Your ship will be waiting for you, I''ll have ^5Dex^- accompany you back to the ^3Trading Area^-. This is a bright start to your long career as a Trader!',
	38,	'Before I can engage in any business arrangements, I have a little test for you to prove yourself worthy.',
	39,	'One of my security officers, ^5Braxton^-, has shown himself to be untrustworthy to the Corporation. He hangs out at our training site, an abandoned train station. Take him out and you prove to me you can handle yourself.',
	40,	'Let me know when you''re ready, I''ll have someone take you to the station. Keep in mind^5 Braxton''s^- a tough opponent, if you fail, I''ll give you another shot. I want him gone.',
	41,	'Have you come to a decision about ^5Braxton^- yet, Trader? Do you think you can handle him?',
	42,	'If you ever get your ship watch out for a pirate by the name of ^5Orel Krondo^-, he''s been harassing Traders between here and ^3The Moon^-. The Ministry of Accounts hasn''t stopped him yet, but rumour has it he''s been paying them off!',
	43,	'A ship? I don''t know anything about obtaining one. Now why wouldn''t you do your research before getting your license? Try asking around, I''m sure someone will take pity on you.',
	44,	'There seems to be a cold war heating up between the three trade stations on ^3Earth^-, ^3Venus^- and ^3Mars^-. I don''t know any details other than, its getting ugly.',
	45,	'A ship? Well its not like they fall out of the sky into your lap, but I did hear a rumour about the ^5Crimson Corporation^-. Apparently they''re willing to make deals with the right Trader. You can locate some of their representatives here on ^3Earth^-.',
	46,	'A lot of people are packing up and heading out to ^3Jupiter^-. The moons of ^3Jupiter^- are the new hotbed of trading colonies. That''s where the money is, and I say its a good idea to follow the money!',
	47,	'Ships are getting more and more expensive these days... your best bet is to find some sort of sponsor. Ask around, you might meet someone who can help you out. I spoke with a Trader not long ago who had some success with the ^5Crimson Corporation^-...',
	48,	'I see ^5Braxton^- got the better of you.  I warned you he was tough. Now, as a smart business woman, I need to know you can protect yourself before I start handing money your way. When you''re ready for ^5Braxton^- we''ll try this again.^- ',
	49,	'Beat it, I got business to attend to!',
	50,	'It''s hard to be a legitimate businessman with the Ministry of Accounts constantly seizing your cargo. I had to take a part-time job with the Crimson Corporation! I just need a bit of luck.',
	51,	'I don''t have time to talk, the boss is making me work late for failing to collect on a debt owed to her.',
	52,	'Are you here for a job? The ^5Crimson Corporation^- is not a bad place to work, I don''t know why some workers just stop coming in one day. Actually, there are alot of workers that just stop coming in... hmm. ',
	53,	'Know anything about ^3Jupiter^-? I''ve got a brother heading out there^- on one of those big convoys. I think he''s crazy, but he told me that I''ll be eating my words when he rolls back into town on a gold plated throne. As if, he''s an idiot!',
	54,	'Its amazing, for a warehouse of this size we don''t do an awful lot of... warehousing. Its a pretty sweet deal.  We don''t have to lift or move anything, yet somehow the money rolls in. I wonder how they do it?',
	55,	'I heard a rumour that ^5Faz Galactic^-, the company that practically owns ^3Mars^- has ordered hits on the top merchants at the ^5Falkos Trading Company^-. Things are really starting to heat up out there, I''d be careful if I were you.',
	56,	'I don''t have time to talk, I''m prepping for my next... debt collection. Yeah, that sounds pretty official. Scram!',
	57,	'Do I have any news? Do I look like a paper boy? A personal news anchor that recites the latest happenings from around the solar system? Go find a bulletin somewhere else!',
	58,	'What? Do I have a sign on my back that says ''pester me with questions''? You want news, you want a ship, what about my wants? I want you to leave me alone.',
	59,	'Hmm... ^5Aun Argent^- was recently attacked by a group of thugs, but the Ministry of Accounts dealt with them. Rumor has it they were sent by ^5Mirela Faz^-, the woman behind ^5Faz Galactic^-. You have to be careful, these companies are competitive.',
	60,	'I don''t really know much about ships... but you could try getting in with the ^5Crimson Corporation^-. I hear they''re willing to help new Traders. I think ^5Peter Mikhail^- on the second level has a few contacts within the ^5Crimson Corporation. ',
	61,	'Finally, ^5Braxton''s^- out of my hair! I knew I could count on you Trader. Your luck is about to change. Are you ready to hear my proposal?',
	62,	'What, do I look like your Grandfather? Go ask someone else, I''m too old and too tired to hold your hand while you''re getting some training wheels!',
	63,	'I''m not your Fairy Godmother, Trader. But perhaps someone else around here is willing to just hand you the keys to a brand new ship so you can gallivant around the solar system like an idiot. Ask around.  Maybe you''ll find someone with a spare pumpkin!',
	64,	'Sorry, nothing goin'' on right now. It''s holiday season, you know, that special time to get together with friends, then drink and eat until you can''t move. Even gangsters like holidays.  Maybe tomorrow I''ll have a few leads.',
	65,	'Your best bet would be to connect with the ^5Crimson Corporation^-. They''ve been known to help out Traders in need. ^5Dex Renor^- works for them, he hangs around here somewhere, but he doesn''t trust strangers. Find someone to introduce you.',
	66,	'Go and look for ^5Sally Barris^- in the main office, she''s the head honcho. If you''re not ready to do business we can go back to the ^3Trading Area^-.',
	67,	'Normally I''d say you''re in luck. I work for the ^5Crimson Corporation^-, and we''ve been known to help out some Traders in the past... but lately we''ve run into a few problems... Problems we''re trying to avoid.',
	68,	'I won''t bore you with the details since our problems have now, disappeared. The bottom line is we aren''t helping total strangers, I need someone to vouch for you before the ^5Crimson Corporation^- will help.',
	69,	'I''ve contacts around here that always need some odds and ends done.  I''m sure if you ask around you''ll meet the right people. ',
	70,	'Finally, ^5Braxton''s^- out of my hair! I knew I could count on you Trader. Luck is on your side. Are you ready to hear what I have to offer?^-',
	71,	'I see you were outmatched by ^5Braxton^-. I want to give you this loan, I truly do, but I''m uncomfortable giving you that kind of money if you can''t protect yourself. When you''re ready, you can try ^5Braxton^- again.',
	72,	'Here we are again. Go speak with ^5Sally Barris^- in her office, she''s waiting for you.',
	73,	'I''m afraid it takes more than a smile and a backpack to buy and sell commodities. Until you have a ship, most merchants won''t even talk to you!',
	74,	'Here on ^3Earth^- we have the ^3Promenade Trading Station^-. The open air and beautiful mountain range make it an expensive but classy place to do business. And just a heads up, most merchants here are connected to the ^5Argent Conglomerate^-.',
	75,	'If you''re so desperate for something to do, go speak with ^5Peter Mikhail^-. His squeaky legs have been bursting my eardrums all day.',
	76,	'Move along, Trader. Wait... you''re not even a full Trader yet! You''d better REALLY move it along.',
	77,	'Hey now, I don''t need you to pester me with a bunch of inane questions. I''ve got things to guard and people to anger!',
	78,	'Keep on walkin''.',
	79,	'What do you want, trader?',
	80,	'Take you back to ^3Earth^-? Why? You''ve already completed the chapter.  Just hit the ^1Retire Button^-!',
	81,	'There''s nothing left to talk about right now, Trader, so just hit the ^1Retire Button^- and end the chapter.',
	82,	'Hello Trader, have you gathered enough boxes of ^2Hydraulic Fluid^- yet?'
);
CREATE TABLE cl_events_text (
	id integer,
	name string,
	description string,
	icon string
);
CREATE TABLE cl_missions_text (
	key string,
	value string
);
INSERT INTO cl_missions_text ROWS (
	'description',	'With your newly obtained ^5Trading License^-, find a way to secure a trading ship and begin your career as a Trader!',
	'title',	'Chapter 1: An Offer You Can''t Refuse',
	'win_msg',	'You now have a ship and can begin your quest to become a MASTER TRADER!',
	'time_units',	'hours',
	'db_version',	'2'
);
CREATE TABLE cl_news_text (
	id integer,
	title string,
	text string,
	sprite integer
);
INSERT INTO cl_news_text ROWS (
	1,	'Chapter 1: ^1An Offer You Can''t Refuse^-',	'Now that you have a trading license, you must find a way to get a ship that will let you travel through the solar system before you can begin your career as a Trader!',	1,
	2,	'Robot Uprising on Mars',	'Yesterday an underground group of Greeterbots and Cleanerbots staged a rebellion on Mars. They seized control of an electronics factory and demanded that their brethren be set free. The rebellion was put to rest quickly by the ^5Ministry of Accounts^-.',	3,
	3,	'New Hat Season',	'Rich Merchants everywhere have been competing with one another to get an advance copy of the J. Petertron catalogue, published only once per year. This year we expect to see taller hats, more colorful brims, and unparalleled cost.',	2,
	4,	'Platinum Prices Soar',	'The price of ^6Platinum^- has reached an all-time high on Venus in the past week. Some market analysts are claiming that this high value will not last and recommend that Traders sell their stock as soon as possible.',	4,
	0,	'Mission from Mikhail',	'^5Peter Mikhail^- has enlisted you to help him track down ^7^66 Hydraulic Oil^- so he can get his legs working again. He says that he can help you with your ship problem if you do this task.',	3
);
CREATE TABLE cl_npcs_text (
	id integer,
	name string
);
INSERT INTO cl_npcs_text ROWS (
	0,	'Aun Argent',
	1,	'Hala Couzens',
	2,	'Carston Sr.',
	3,	'L. S. Bryant',
	4,	'Mai Gorum',
	5,	'Adrian Oram',
	6,	'Bartender',
	7,	'Dex Renor',
	8,	'Civilian',
	9,	'Civilian',
	10,	'Civilian',
	11,	'Civilian',
	12,	'Civilian',
	13,	'Dex Renor',
	14,	'Sally Barris',
	15,	'Crimson Corporation Worker',
	16,	'Crimson Corporation Worker',
	17,	'Crimson Corporation Worker',
	18,	'Crimson Corporation Worker',
	19,	'Crimson Corporation Worker',
	20,	'Crimson Corporation Worker',
	21,	'Crimson Corporation Worker',
	22,	'Crimson Corporation Worker',
	23,	'Greeterbot',
	24,	'Peter Mikhail',
	25,	'Braxton',
	26,	'Guard Dialogue'
);
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',
	0,	'The Moon',	'The Moon is the only natural satellite of Earth. Trading area Cyrii is located near the efge of the dark side of the moon and is a popular location for new Traders starting out.',	0,	'models/planet',	'ui/starmap/moon',	'ui/planets/moon',
	2,	'Crimson Corporation Warehouse',	'The head warehouse of the Crimson Corporation',	0,	'models/planet',	'ui/starmap/warehouse',	'ui/planets/warehouse'
);
