-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `reporpg`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `armour`
-- 

CREATE TABLE `armour` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `slot` int(11) NOT NULL default '0',
  `armour` int(11) NOT NULL default '0',
  `image` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `armour`
-- 

INSERT INTO `armour` (`id`, `name`, `slot`, `armour`, `image`) VALUES 
(1, 'Repoman''s Mask', 1, 10, 'repomask');

-- --------------------------------------------------------

-- 
-- Table structure for table `locations`
-- 

CREATE TABLE `locations` (
  `location` varchar(255) NOT NULL default '',
  `x_axis` int(11) NOT NULL default '0',
  `y_axis` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `locations`
-- 

INSERT INTO `locations` (`location`, `x_axis`, `y_axis`) VALUES 
('geneco', 4, 5);

-- --------------------------------------------------------

-- 
-- Table structure for table `mail`
-- 

CREATE TABLE `mail` (
  `mailid` int(11) NOT NULL auto_increment,
  `receiverid` int(11) NOT NULL default '0',
  `senderid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `timestamp` varchar(255) NOT NULL default '0',
  `archive` int(11) NOT NULL default '0',
  `isread` int(11) NOT NULL default '0',
  `deleted` int(11) NOT NULL default '0',
  PRIMARY KEY  (`mailid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- 
-- Dumping data for table `mail`
-- 

INSERT INTO `mail` (`mailid`, `receiverid`, `senderid`, `title`, `content`, `timestamp`, `archive`, `isread`, `deleted`) VALUES 
(1, 1, 1, 'What am I doing?', 'Hey, it&#039;s me!', '1267438716', 0, 1, 1),
(2, 1, 1, 'Testing again', 'whaetnldjfakjgfdg', '1267438884', 1, 1, 0),
(4, 1, 1, 'Another Test', 'dfgdgsg', '1267438884', 1, 1, 0),
(5, 2, 1, 'Hey', 'Mail is working =)', '1267438884', 0, 1, 0),
(6, 18, 1, 'Hey', '=D', '1267438884', 0, 1, 0),
(7, 1, 18, 'oink', 'mooo', '1267438884', 1, 1, 0),
(8, 1, 18, 'unread', 'you have 1 unread message', '1267438884', 1, 1, 0),
(9, 18, 1, 'Do you?', 'Mwhaha', '1267438884', 0, 1, 0),
(10, 1, 18, 'they', 'are watching o_o', '1267438884', 1, 1, 0),
(11, 18, 1, 'Oh?', 'Who are they???', '1267438884', 0, 1, 0),
(12, 18, 1, 'Test', ' Reply', '1267438884', 0, 1, 0),
(13, 1, 18, '-', 'reply imminent ', '1267438884', 1, 1, 0),
(14, 1, 1, 'Test', 'Time Test', '1267491476', 1, 1, 0),
(15, 1, 1, 'Another Test', 'TE', '1267607782', 1, 1, 0),
(16, 16, 1, 'Hi', 'How are you doing?', '1267698730', 0, 1, 0),
(17, 3, 4, 'Repossession', 'Repossess.. something...', '1267438716', 0, 1, 0),
(18, 1, 3, 'Shilo', 'Shilo...', '1267957904', 1, 1, 0),
(19, 3, 1, 'RE: Shilo', 'Yes, Dad?\r\n\r\n------------------------------\r\nNathan wrote : \r\nShilo...', '1267957927', 0, 1, 0),
(20, 1, 3, 'RE: RE: Shilo', 'Did you take your medicine?\r\n\r\n------------------------------\r\nShilo wrote : \r\nYes, Dad?\r\n\r\n------------------------------\r\nNathan wrote : \r\nShilo...', '1267957944', 1, 1, 0),
(21, 3, 1, 'RE: RE: RE: Shilo', 'Yes?\r\nWhat&#039;s that??\r\n\r\n------------------------------\r\nNathan wrote : \r\nDid you take your medicine?\r\n\r\n------------------------------\r\nShilo wrote : \r\nYes, Dad?\r\n\r\n------------------------------\r\nNathan wrote : \r\nShilo...', '1267957961', 0, 1, 0),
(22, 2, 1, 'Mail System', 'No idea if you are going to check here before I get online tomorrow but..<br> \r\n<br>\r\nI&#039;ve fixed up the mail system, should be completely good now, plus added a delete and an archive option. Archive means you keep in in the archive area, freeing up your inbox. Delete doesn&#039;t actually delete it, just hides it from all users. Admins will be able to view mails.\r\n<br><br>\r\nThat&#039;s it =P', '1267958430', 0, 1, 0),
(23, 1, 1, 'Line Test', 'Will this make more lines<br />\r\n<br />\r\n1<br />\r\n<br />\r\n2<br />\r\n<br />\r\n3<br />\r\n<br />\r\n4<br />\r\n<br />\r\n5', '1267958783', 0, 1, 1),
(24, 1, 16, 'RE: Hi', ' good. a bit confused about everything. just trying things out for now, when I can get on the good computer. <br />\r\n<br />\r\n------------------------------<br />\r\nShilo wrote : <br />\r\nHow are you doing?', '1268526310', 1, 1, 0),
(25, 16, 1, 'RE: RE: Hi', ' lol. Ya, I need to write out a FAQ at some point.. I&#039;m planning to once more of it is done lol.<br />\r\n<br />\r\n------------------------------<br />\r\nIckaChan wrote : <br />\r\n good. a bit confused about everything. just trying things out for now, when I can get on the good computer. <br /><br />\r\n<br /><br />\r\n------------------------------<br /><br />\r\nShilo wrote : <br /><br />\r\nHow are you doing?', '1268618834', 0, 0, 0),
(26, 16, 1, 'RE: RE: Hi', ' Oh, also, try going to "stat points" on the menu and give your agility or strength a boost, should help you win if you attack other players/npc&#039;s lol.<br />\r\n<br />\r\n------------------------------<br />\r\nIckaChan wrote : <br />\r\n good. a bit confused about everything. just trying things out for now, when I can get on the good computer. <br /><br />\r\n<br /><br />\r\n------------------------------<br /><br />\r\nShilo wrote : <br /><br />\r\nHow are you doing?', '1268618980', 0, 0, 0),
(27, 20, 1, 'Hi', 'Hi, how are you?', '1270447415', 0, 0, 0),
(28, 1, 1, 'Hi', 'Test', '1271989583', 0, 1, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `message`
-- 

CREATE TABLE `message` (
  `user_id` int(11) NOT NULL default '0',
  `content` text NOT NULL,
  `x_axis` int(11) NOT NULL default '0',
  `y_axis` int(11) NOT NULL default '0',
  `message_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=207 ;

-- 
-- Dumping data for table `message`
-- 

INSERT INTO `message` (`user_id`, `content`, `x_axis`, `y_axis`, `message_id`) VALUES 
(1, 'This is a test message. If you can see this, it is working!', 2, 3, 1),
(1, 'Hmm. Does this work now?', 2, 3, 2),
(3, 'Didn&#039;t I tell you not to go out, didn&#039;t I?', 2, 3, 3),
(0, 'Ooga booga booga.', 2, 3, 4),
(3, 'What?', 2, 3, 5),
(0, 'Oh, man, you have to refresh to see new messages?', 2, 3, 6),
(1, 'Ya.. for now. I&#039;m working on fixing that now', 2, 3, 7),
(0, 'Wow. It just went berserk with refresh.', 2, 3, 8),
(9, 'Is there really such a need for so many !!!!!!!!!s?', 2, 3, 9),
(1, 'Indeed =P there was! Took me forever to get it working so I was excited when it did!', 2, 3, 10),
(9, 'Oh, gotcha.', 2, 3, 11),
(9, 'I SEE NOW', 2, 3, 12),
(1, 'Testing yet again.', 2, 3, 13),
(9, 'BLAU UND WEIß!', 2, 3, 14),
(1, 'Yay it works!!!!!', 2, 3, 15),
(1, 'Hmmmmmmm', 2, 3, 16),
(9, 'Interesting.', 2, 3, 17),
(1, 'Well now only the last 6 show up, thats an improvement!', 2, 3, 18),
(9, 'Science rules.', 2, 3, 19),
(1, 'You guys are scary!', 4, 3, 20),
(1, 'Does it now?', 2, 3, 21),
(1, 'Why does it show only 5 now..', 2, 3, 22),
(1, 'Fixed back to 6.', 2, 3, 23),
(9, 'Cool. Ands yes, according to Bill Nye, who has yet to lead me wrong, Science does rule.', 2, 3, 24),
(1, 'Bill Nye is evil =P', 2, 3, 25),
(9, 'Bill Nye rules.', 2, 3, 26),
(1, 'Bill Nighy can beat Bill Nye any day!', 2, 3, 27),
(9, 'Well, that&#039;s not news.', 2, 3, 28),
(1, 'Leaving the message count at 5 for now then.', 2, 3, 29),
(3, 'Didn&#039;t I tell you not to go out, didn&#039;t I?', 3, 3, 30),
(1, 'You did, you did...', 3, 3, 31),
(1, 'Guess it&#039;s 6 again..', 2, 3, 32),
(1, 'You there?', 2, 3, 33),
(1, '=P', 2, 3, 34),
(1, 'Mwhahaha', 2, 3, 35),
(1, 'hey sketch!', 2, 3, 36),
(1, '=)', 2, 2, 37),
(1, 'hmm', 2, 2, 38),
(14, 'very nice profile', 2, 2, 39),
(1, '=)', 2, 2, 40),
(1, 'chat box got messed up it seems =P', 2, 2, 41),
(14, 'lol its a bit weird ', 2, 2, 42),
(1, 'I think it works fine in the next square up lol', 2, 2, 43),
(1, 'test', 2, 3, 44),
(1, 'Test', 1, 1, 45),
(1, 'Test', 3, 2, 46),
(1, 'Test', 1, 2, 47),
(0, 'Test', 2, 2, 48),
(0, 'darn', 2, 2, 49),
(14, 'works', 3, 2, 50),
(14, '.', 3, 1, 51),
(14, '..', 3, 1, 52),
(14, '.', 2, 1, 53),
(14, '.', 2, 1, 54),
(14, 'lol', 1, 1, 55),
(0, 'Test', 4, 5, 56),
(1, 'Test', 4, 5, 57),
(0, 'Test', 4, 5, 58),
(1, 'Test', 4, 4, 59),
(1, 'Test', 4, 5, 60),
(1, 'Test', 4, 5, 61),
(1, 'Let&#039;s see....', 2, 2, 62),
(1, 'Test again', 2, 3, 63),
(1, 'Test Again', 2, 2, 64),
(1, 'Test =P', 4, 5, 65),
(3, 'Hmm', 2, 2, 66),
(1, 'Test Again', 2, 2, 67),
(1, '5', 2, 2, 68),
(1, '4', 2, 2, 69),
(1, '3', 2, 2, 70),
(1, '2', 2, 2, 71),
(1, '1', 2, 2, 72),
(3, 'But Shilo…..', 2, 2, 73),
(1, 'Your patients need you. Dad, who’s that?', 2, 2, 74),
(3, 'Oh that, One of my patients, He’s..uh.. sick.', 2, 2, 75),
(1, 'Will he live?', 2, 2, 76),
(3, 'It’s looking grim.', 2, 2, 77),
(1, '=)', 2, 2, 78),
(1, 'Hey goddess!', 2, 2, 79),
(10, 'hello', 2, 2, 80),
(10, 'hiya', 2, 2, 81),
(1, 'Mwhaha it works!', 2, 2, 82),
(10, 'oh there we go', 2, 2, 83),
(10, 'oh there we go', 2, 2, 84),
(10, 'oh there we go', 2, 2, 85),
(1, '=P', 2, 2, 86),
(10, 'dont know why but it was pitch black on the chat box above had to reload it', 2, 2, 87),
(10, 'i have to keep reloading chat by looks of things else it stays pitch black? lol', 2, 2, 88),
(10, 'i have to keep reloading chat by looks of things else it stays pitch black? lol', 2, 2, 89),
(1, 'what browser are you using', 2, 2, 90),
(2, 'lol', 2, 2, 91),
(10, 'firefox', 2, 2, 92),
(10, 'oh there we go didnt have to reload that time', 2, 2, 93),
(10, 'darn it >.>', 2, 2, 94),
(10, 'darn it >.>', 2, 2, 95),
(1, 'that&#039;s odd that you do, ya you shouldnt have to because I put code in that doesnt make it', 2, 2, 96),
(10, 'maybe my net is just playing up tonight', 2, 2, 97),
(10, 'maybe my net is just playing up tonight', 2, 2, 98),
(1, 'maybe lol', 2, 2, 99),
(2, 'so far it looks good ', 2, 2, 100),
(10, 'i agree', 2, 2, 101),
(10, 'i agree', 2, 2, 102),
(10, 'why is it spamming my words twice lol', 2, 2, 103),
(2, 'same on my end ', 2, 2, 104),
(10, 'ok why does the chat change when u go like north, west etc lol?', 2, 2, 105),
(2, 'diffrent chat area&#039;s ', 2, 2, 106),
(10, 'ok so basically its for different chat locations i noticed', 2, 2, 107),
(10, 'yeah lol', 2, 2, 108),
(1, 'yep, each square has its own', 2, 2, 109),
(10, 'cool you can like avoid a person thats irritating you until he/she finds out where you are lol', 2, 2, 110),
(1, 'exactly lol', 2, 2, 111),
(10, 'thats funny lol', 2, 2, 112),
(1, '=)', 2, 2, 113),
(2, 'game should be good  ', 2, 2, 114),
(10, 'could play hide n seek on this lol', 2, 2, 115),
(10, 'could play hide n seek on this lol', 2, 2, 116),
(1, 'well I am planning a really big map, like 100X100.. so that is a possability lol', 2, 2, 117),
(10, 'lol cool, find what region the person is in til theyre spotted X-D', 2, 2, 118),
(2, 'shes planning to play 40k as well when we are together ', 2, 2, 119),
(1, 'that is a good idea, have an admin sponsored event with prizes lol', 2, 2, 120),
(2, 'lol ', 2, 2, 121),
(10, 'lol cool, find what region the person is in til theyre spotted X-D', 2, 2, 122),
(2, 'lol ', 2, 2, 123),
(10, 'ah bluddy thing spammed my message again lol', 2, 2, 124),
(10, 'ah bluddy thing spammed my message again lol', 2, 2, 125),
(1, 'lol', 2, 2, 126),
(3, 'test', 2, 2, 127),
(1, 'Hmmm', 2, 2, 128),
(3, 'Uh', 2, 2, 129),
(1, 'Well at least it works with firefox...', 2, 2, 130),
(3, 'I can&#039;t see!! Damned IE!', 2, 2, 131),
(3, 'I&#039;ll stain the streets, they&#039;ll run with blood!', 2, 2, 132),
(1, 'Wait a sec..', 2, 2, 133),
(3, 'Ya.. it&#039;s working now.. go figure..', 2, 2, 134),
(1, 'Huh', 2, 2, 135),
(1, '=)', 2, 2, 136),
(2, 'looks good ', 2, 2, 137),
(1, 'Attack Zydrate Addict lol', 2, 2, 138),
(2, 'lol  you really like how it came out huh ', 2, 2, 139),
(1, 'yep lol, lot of work but Im happy its mostly working now lol', 2, 2, 140),
(1, 'mwhaha you killed him', 2, 2, 141),
(2, 'lol ', 2, 2, 142),
(1, 'maybe i should have a record of wins and losses huh', 2, 2, 143),
(2, 'probly ', 2, 2, 144),
(1, 'added it to my list of things to do lol', 2, 2, 145),
(1, 'oh I linke the graverobber page to you now, wherever you move, it goes too lol', 2, 2, 146),
(2, 'lol what do you have to do ?', 2, 2, 147),
(1, 'quite a bit still lol', 2, 2, 148),
(2, 'really?', 2, 2, 149),
(1, '*falls over after all the work of writing what I still have yet to do!*', 2, 2, 150),
(1, 'if you are using IE, don&#039;t mind the layout break, I will be fixing it!', 2, 2, 151),
(1, 'The party is at coords 2 , 2!', 1, 1, 152),
(1, 'and health and energy regenerate one point every.. 20 min I think I set it to now..', 2, 2, 153),
(3, 'Hmmm', 2, 2, 154),
(18, 'Shilo Wallace, report to the zydrate factory', 1, 1, 155),
(1, 'Oh there you are', 2, 2, 156),
(1, 'hey Deon!', 2, 2, 157),
(18, 'whos deon im not this deon you speak of', 2, 2, 158),
(18, 'i am Neod', 2, 2, 159),
(1, 'lol', 2, 2, 160),
(1, 'Hey', 2, 2, 161),
(1, 'Tali?', 2, 2, 162),
(10, 'Hoy, hoy!', 2, 2, 163),
(1, 'lol', 2, 2, 164),
(1, 'so what do you think so far lol', 2, 2, 165),
(10, 'It&#039;s neat!', 2, 2, 166),
(1, '=)', 2, 2, 167),
(1, 'I have a lot more plans for it too lol', 2, 2, 168),
(10, 'Lol. It&#039;ll be awesome, I bet.', 2, 2, 169),
(1, 'I hope so lol', 2, 2, 170),
(1, 'http://www.raptorred.com/reporpg/forum/viewtopic.php?f=2&t=6', 2, 2, 171),
(1, 'check out that link', 2, 2, 172),
(10, 'Arg! I can&#039;t copy it...', 2, 2, 173),
(1, 'ill send it to you on myspace', 2, 2, 174),
(10, 'Okay! Thank you.', 2, 2, 175),
(10, 'Be right back.. Going to actually create a username.', 2, 2, 176),
(1, 'ok lol', 2, 2, 177),
(1, 'lol welcome back', 2, 2, 178),
(19, 'Lol. Thank you.', 2, 2, 179),
(1, 'Ah I gotta get going for now.. get myself some dinner, I&#039;ll be back a little later', 2, 2, 180),
(1, 'If you have any ideas, just throw them up on that forum or message them to me on myspace.. or the mail system in here lol', 2, 2, 181),
(1, 'see you around', 2, 2, 182),
(19, 'Okay. Later~!', 2, 2, 183),
(1, '=P', 2, 2, 184),
(1, 'No! I&#039;m GeneCo =P', 1, 1, 185),
(18, ':O', 2, 2, 186),
(1, '*blinks*', 2, 2, 187),
(18, '*winks*', 2, 2, 188),
(1, 'so what are you up to lol', 2, 2, 189),
(18, 'im in a chatbox with red', 2, 2, 190),
(1, '=P', 2, 2, 191),
(18, 'lol ;P', 2, 2, 192),
(18, 'hm whos tali', 2, 2, 193),
(1, 'friend of mine from crimson moon', 2, 2, 194),
(18, 'ah', 2, 2, 195),
(1, 'co-leader of geneco now lol', 2, 2, 196),
(18, ':O here or on crimson?', 2, 2, 197),
(1, 'crimson', 2, 2, 198),
(18, 'ah cool ', 2, 2, 199),
(18, 'well im pretty tired, going to hit the sack, good night :D', 2, 2, 200),
(1, 'gn', 2, 2, 201),
(1, 'Hi', 3, 3, 202),
(1, 'Hello! I&#039;m in php class right now.. and talking to myself!', 2, 2, 203),
(1, 'I am missing my dragon', 2, 2, 204),
(1, 'hey!', 2, 2, 205),
(1, '=)', 2, 2, 206);

-- --------------------------------------------------------

-- 
-- Table structure for table `motd`
-- 

CREATE TABLE `motd` (
  `motd` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `motd`
-- 

INSERT INTO `motd` (`motd`) VALUES 
('Check on the forums for info. Lots of stuff I have yet to do is listed there. If you find a bug, put it there!');

-- --------------------------------------------------------

-- 
-- Table structure for table `npc_list`
-- 

CREATE TABLE `npc_list` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `level` int(11) NOT NULL default '1',
  `faction` int(11) NOT NULL default '0',
  `rewards` varchar(255) NOT NULL default '',
  `money` int(11) NOT NULL default '0',
  `x_axis` int(11) NOT NULL default '1',
  `y_axis` int(11) NOT NULL default '1',
  `cur_health` int(11) NOT NULL default '10',
  `max_health` int(11) NOT NULL default '10',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `npc_list`
-- 

INSERT INTO `npc_list` (`id`, `name`, `level`, `faction`, `rewards`, `money`, `x_axis`, `y_axis`, `cur_health`, `max_health`) VALUES 
(1, 'Yuppie', 1, 0, '', 100, 1, 5, 10, 10),
(2, 'Zydrate Addict', 1, 2, '', 2, 4, 4, 10, 10),
(3, 'GeneCo Guard', 1, 1, '', 40, 1, 5, 10, 10);

-- --------------------------------------------------------

-- 
-- Table structure for table `reservednames`
-- 

CREATE TABLE `reservednames` (
  `name` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `reservednames`
-- 

INSERT INTO `reservednames` (`name`) VALUES 
('Shilo'),
('Shilo Wallace'),
('Shilo_Wallace'),
('Shilo-Wallace'),
('Nathan'),
('Nathan Wallace'),
('Nathan_Wallace'),
('Nathan'),
('Blind Mag'),
('Blind_Mag'),
('Blind-Mag'),
('Rotti'),
('Rotti Largo'),
('Rotti_Largo'),
('Rotti-Largo'),
('Luigi'),
('Luigi Largo'),
('Luigi_Largo'),
('Luigi-Largo'),
('Pavi'),
('Pavi Largo'),
('Pavi_Largo'),
('Pavi-Largo'),
('Amber'),
('Amber Sweet'),
('Amber_Sweet'),
('Amber-Sweet'),
('Graverobber'),
('Grave robber'),
('Grave_robber'),
('Grave-robber'),
('Marni'),
('Marni Wallace'),
('Marni_Wallace'),
('Marni-Wallace'),
('Repo Cadet'),
('RepoCadet'),
('Repo_Cadet'),
('Repo-Cadet');

-- --------------------------------------------------------

-- 
-- Table structure for table `scrolls`
-- 

CREATE TABLE `scrolls` (
  `id` int(11) NOT NULL auto_increment,
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `scrolls`
-- 

INSERT INTO `scrolls` (`id`, `content`) VALUES 
(1, 'Ask your gentern about Zydrate today!'),
(2, 'Financed organs are subject to all legal default remedies including repossessions.'),
(3, 'GeneCo presents the Genetic Opera. Tickets are available for immediate purchase!!!'),
(4, 'Tonight''s Genetic Opera is the place to be!!!');

-- --------------------------------------------------------

-- 
-- Table structure for table `searchitems`
-- 

CREATE TABLE `searchitems` (
  `item_id` int(11) NOT NULL default '0',
  `item_name` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `searchitems`
-- 

INSERT INTO `searchitems` (`item_id`, `item_name`) VALUES 
(0, 'money');

-- --------------------------------------------------------

-- 
-- Table structure for table `test3`
-- 

CREATE TABLE `test3` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(10) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `test3`
-- 

INSERT INTO `test3` (`id`, `name`) VALUES 
(1, 'test'),
(2, 'test2');

-- --------------------------------------------------------

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `displayname` varchar(255) NOT NULL default '',
  `admin` char(2) NOT NULL default '',
  `special` char(1) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `ban_until` int(11) NOT NULL default '0',
  `jailed` int(11) NOT NULL default '0',
  `bannedby` int(11) NOT NULL default '0',
  `email` varchar(60) NOT NULL default '',
  `online` int(11) NOT NULL default '0',
  `ipaddress` longtext NOT NULL,
  `x_axis` int(11) NOT NULL default '1',
  `y_axis` int(11) NOT NULL default '1',
  `level` int(11) NOT NULL default '1',
  `experience` int(11) NOT NULL default '0',
  `max_health` int(11) NOT NULL default '10',
  `cur_health` int(11) NOT NULL default '10',
  `max_energy` int(11) NOT NULL default '10',
  `cur_energy` int(11) NOT NULL default '10',
  `faction` int(11) NOT NULL default '0',
  `faction_rank` int(11) NOT NULL default '0',
  `weapon` int(11) NOT NULL default '0',
  `statpoints` int(11) NOT NULL default '5',
  `agility` int(11) NOT NULL default '0',
  `strength` int(11) NOT NULL default '0',
  `perception` int(11) NOT NULL default '0',
  `image` varchar(255) NOT NULL default '',
  `profile` text NOT NULL,
  `sig` varchar(255) NOT NULL default '',
  `fontcolour` varchar(6) NOT NULL default '999966',
  `timezone` int(11) NOT NULL default '0',
  `dst` int(11) NOT NULL default '0',
  `money` int(11) NOT NULL default '0',
  `timestamp` varchar(255) NOT NULL default '',
  `hit` int(11) NOT NULL default '0',
  `washit` int(11) NOT NULL default '0',
  `lastkilled` int(11) NOT NULL default '0',
  `lastkilledby` int(11) NOT NULL default '0',
  `zydrateorgans` int(11) NOT NULL default '0',
  `lungs` int(11) NOT NULL default '0',
  `liver` int(11) NOT NULL default '0',
  `bladder` int(11) NOT NULL default '0',
  `heart` int(11) NOT NULL default '0',
  `spleen` int(11) NOT NULL default '0',
  `intestines` int(11) NOT NULL default '0',
  `spine` int(11) NOT NULL default '0',
  `brain` int(11) NOT NULL default '0',
  `eyes` int(11) NOT NULL default '0',
  `pancreas` int(11) NOT NULL default '0',
  `stomach` int(11) NOT NULL default '0',
  `kidneys` int(11) NOT NULL default '0',
  `zydrate` int(11) NOT NULL default '0',
  `wins` int(11) NOT NULL default '0',
  `losses` int(11) NOT NULL default '0',
  `street_zydrate` int(11) NOT NULL default '0',
  `head_armour` int(11) NOT NULL default '0',
  `chest_armour` int(11) NOT NULL default '0',
  `leg_armour` int(11) NOT NULL default '0',
  `boot_armour` int(11) NOT NULL default '0',
  `glove_armour` int(11) NOT NULL default '0',
  `extra_armour` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `user`
-- 

INSERT INTO `user` (`id`, `name`, `displayname`, `admin`, `special`, `password`, `ban_until`, `jailed`, `bannedby`, `email`, `online`, `ipaddress`, `x_axis`, `y_axis`, `level`, `experience`, `max_health`, `cur_health`, `max_energy`, `cur_energy`, `faction`, `faction_rank`, `weapon`, `statpoints`, `agility`, `strength`, `perception`, `image`, `profile`, `sig`, `fontcolour`, `timezone`, `dst`, `money`, `timestamp`, `hit`, `washit`, `lastkilled`, `lastkilledby`, `zydrateorgans`, `lungs`, `liver`, `bladder`, `heart`, `spleen`, `intestines`, `spine`, `brain`, `eyes`, `pancreas`, `stomach`, `kidneys`, `zydrate`, `wins`, `losses`, `street_zydrate`, `head_armour`, `chest_armour`, `leg_armour`, `boot_armour`, `glove_armour`, `extra_armour`) VALUES 
(1, 'Shilo', 'Shilo Wallace', 'a', 'A', 'ratha', 0, 0, 0, 'raptorred@raptorred.com', 1, '72.138.39.131 174.112.180.69 174.112.180.224', 4, 5, 9, 840, 60, 60, 50, 37, 1, 0, 0, 5, 9, 8, 8, 'avs/Shilo_avatar.png', 'I&#039;m infected....<br />\r\n<br />\r\n[color=990000][u]"You have repossessed one set of Eyes from Blind Mag."[/u][/color]', 'http://www.raptorred.com/reporpg/image/shilo_l4dmods_sig_100.png', 'FF4000', -5, 0, 1824, '1416570772', 0, 0, 5, 8, 1, 3, 4, 11, 10, 10, 5, 7, 3, 4, 11, 6, 7, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 'GraveRobber', '', 'b', 'A', 'reaver53', 0, 0, 0, '', 0, '207.193.31.69', 2, 2, 1, 30, 10, 10, 10, 10, 2, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/graverobber.png', '', 'http://www.raptorred.com/reporpg/image/gb_tempsig.png', '3399CC', 0, 0, 63, '1273853568', 0, 0, 10, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 'Nathan', 'Nathan Wallace', '', '*', 'ratha', 0, 0, 0, '', 0, '', 2, 2, 1, 15, 10, 10, 10, 10, 1, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/nathan_80.png', 'Keen incisions, I deliver!', 'http://www.raptorred.com/reporpg/image/repo_clan.jpg', '990000', 0, 0, 203, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 'Rotti Largo', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 2, 2, 1, 30, 10, 10, 10, 10, 1, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/rotti.png', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 'Blind Mag', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 2, 2, 1, 0, 10, 0, 10, 10, 0, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/blindmag.png', '', '', '999966', 0, 0, 0, '0', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0),
(6, 'Pavi Largo', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 4, 3, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, 'Luigi Largo', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 4, 5, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0),
(8, 'Amber Sweet', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 2, 2, 1, 60, 10, 0, 10, 10, 0, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/amber.png', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0),
(9, 'RSwarthout', '', '', '', 'un4giv3nRTB89', 0, 0, 0, '', 0, '', 0, 0, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(10, 'Guest', '', '', '', 'guest', 0, 0, 0, '', 0, '67.163.243.75', 4, 4, 1, 30, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 28, '1268458543', 0, 0, 11, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(11, 'Zydrate Addict', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 2, 2, 1, 15, 10, 0, 10, 10, 2, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/z_addict.png', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 0, 0),
(12, 'Test', '', '', '', 'test', 0, 0, 0, '', 0, '', 0, 0, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(13, 'Zydrate Addict2', '', '', '*', 'ratha', 0, 0, 0, '', 0, '', 0, 0, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(14, 'SD', '', '', '', 'reaver53', 0, 0, 0, '', 0, '', 0, 0, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(15, 'Bad Test Person', '', '', '', 'ratha', 0, 0, 1, '', 0, '', 1, 1, 1, 0, 10, 10, 10, 10, 0, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(16, 'IckaChan', '', '', '', 'marble', 0, 0, 0, '', 0, '65.96.89.192', 2, 2, 1, 0, 10, 10, 10, 10, 2, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 0, '1268526357', 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0),
(17, 'Lalaek', '', '', '', 'coolcat', 0, 0, 0, '', 0, '', 2, 3, 1, 0, 10, 0, 10, 10, 2, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 12, '1267483387', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0),
(18, 'GhostDragon', '', '', '', '718424', 0, 0, 0, '', 0, '98.14.3.139', 2, 2, 1, 0, 10, 0, 10, 10, 0, 0, 0, 5, 0, 0, 0, 'http://www.raptorred.com/reporpg/image/repo1.png', '', '', '6666CC', 0, 0, 0, '1291003010', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0),
(19, 'Tali', '', '', '', 'fishies', 0, 0, 0, 'samilard@yahoo.com', 0, '', 2, 2, 1, 15, 20, 20, 20, 20, 0, 0, 0, 0, 1, 0, 0, '', '', '', '999966', 0, 0, 0, '1268006672', 0, 0, 11, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0),
(20, 'Lavender', '', '', '', 'password', 0, 0, 0, 'purlav@gmail.com', 0, '65.96.89.192', 3, 3, 1, 0, 10, 10, 10, 10, 2, 0, 0, 5, 0, 0, 0, '', '', '', '999966', 0, 0, 95, '1273671879', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
