· 8 years ago · Jun 06, 2018, 03:22 PM
1;
2
3--
4-- Dumping data for table `roombots`
5--
6
7INSERT INTO `roombots` (`id`, `roomid`, `home`, `name`, `mission`, `badge`, `figure`, `x`, `y`, `z`, `freeroam`, `message_noshouting`, `pet`, `state`, `status`, `punching`) VALUES
8(2, 357, '321', 'Pierce', 'Civilian', 'BOT', 'hd-180-1.ch-917-110.lg-270-110.sh-735-110.hr-841-110.ha-508-110.', 10, 8, 0, '1', '', NULL, 1, 0, 0),
9(1, 338, '338', 'Jackson', 'Robocop 2.0', 'BOT', 'hd-180-1.ch-911-110.lg-270-110.sh-735-110.hr-841-100.ha-508-110.ea-1407-110', 9, 1, 0, '1', '', NULL, 2, 0, 1),
10(4, 367, '322', 'Kyle', 'Civilian', 'BOT', 'hd-180-1.ch-917-1252.lg-270-110.sh-735-110.hr-678-110.ha-508-110.he-1030-110', 8, 11, 0, '1', 'Shouting is not neccessary.', NULL, 1, 0, 0),
11(8, 362, '362', 'Dexter', 'UKRP Guide', 'BOT', 'hd-180-1.ch-917-110.lg-270-110.sh-735-110.hr-841-110.ha-508-110.', 8, 7, 18, '0', '', NULL, 1, 0, 0),
12(7, 320, '1', 'Dr. Boon', '[Working] Doctor', 'BOT', 'hd-180-1.hr-841-110.ch-913-92.lg-695-92.sh-735-110.ca-1819.fa-1208-1214', 10, 7, 0, '1', '', NULL, 1, 0, 0);
13
14-- --------------------------------------------------------
15
16--
17-- Table structure for table `roombots_coords`
18--
19
20CREATE TABLE IF NOT EXISTS `roombots_coords` (
21 `id` int(10) NOT NULL,
22 `x` int(5) NOT NULL,
23 `y` int(5) NOT NULL
24) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
25
26--
27-- Dumping data for table `roombots_coords`
28--
29
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `roombots_texts`
35--
36
37CREATE TABLE IF NOT EXISTS `roombots_texts` (
38 `id` int(10) NOT NULL,
39 `type` enum('shout','say') COLLATE latin1_general_ci NOT NULL,
40 `text` varchar(255) COLLATE latin1_general_ci NOT NULL
41) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
42
43--
44-- Dumping data for table `roombots_texts`
45--
46
47INSERT INTO `roombots_texts` (`id`, `type`, `text`) VALUES
48(1, 'say', 'Obide by the laws, and well get along just dandy!'),
49(3, 'say', 'I would prefer to not be bothered. '),
50(5, 'shout', 'Hey, are you a noob? Because I''m a bot! :)');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `roombots_texts_triggers`
56--
57
58CREATE TABLE IF NOT EXISTS `roombots_texts_triggers` (
59 `id` int(10) NOT NULL,
60 `words` text COLLATE latin1_general_ci NOT NULL,
61 `replies` text COLLATE latin1_general_ci NOT NULL,
62 `serve_replies` text COLLATE latin1_general_ci NOT NULL,
63 `serve_item` varchar(20) COLLATE latin1_general_ci NOT NULL
64) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
65
66--
67-- Dumping data for table `roombots_texts_triggers`
68--
69
70INSERT INTO `roombots_texts_triggers` (`id`, `words`, `replies`, `serve_replies`, `serve_item`) VALUES
71(1, 'punch', 'You shouldn''t punch anyone, ever!', '', ''),
72(2, 'pierce', 'Yes Sir? That is my name!', '', ''),
73(2, 'hey', 'Hey!', '', ''),
74(2, 'king', 'Woah! What!? Woah lad, you want to go face to face with king frost?', '', ''),
75(3, 'moustafa', 'Ack! What?', '', ''),
76(2, 'yes', 'You might better train more, then if you do, head north into the icy terrain.', '', ''),
77(4, 'kyle', 'Hello..', '', ''),
78(4, 'moustafa', 'Moustafa? Oh Mr. Moustafa? He is north of here.. Why do so many people want to see him..', '', ''),
79(4, 'punch', 'If you punch anyone, I''ll call the cops.', '', ''),
80(5, 'admin', 'No.', '', ''),
81(5, 'staff', 'No.', '', ''),
82(7, 'heal', 'Sorry, but I can''t heal you right now.', '', ''),
83(8, 'help', 'Your keywords are "gym, hospital, bank, punching, role-play".', '', ''),
84(8, 'gym', 'The gym is a place where you can increase your strength. Higher strength means more damage when you punch!', '', '');
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `rooms`
90--
91
92CREATE TABLE IF NOT EXISTS `rooms` (
93 `id` int(10) NOT NULL AUTO_INCREMENT,
94 `name` varchar(50) COLLATE latin1_general_ci NOT NULL,
95 `description` varchar(125) COLLATE latin1_general_ci DEFAULT NULL,
96 `owner` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
97 `category` int(3) NOT NULL DEFAULT '0',
98 `model` varchar(100) COLLATE latin1_general_ci NOT NULL,
99 `ccts` text COLLATE latin1_general_ci,
100 `floor` int(3) NOT NULL DEFAULT '0',
101 `wallpaper` int(3) NOT NULL DEFAULT '0',
102 `state` int(11) NOT NULL DEFAULT '0' COMMENT '0 = open, 1 = closed, 2 = password, 3 = hc only, 4 = staff',
103 `password` varchar(15) COLLATE latin1_general_ci DEFAULT NULL,
104 `showname` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
105 `superusers` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
106 `visitors_now` int(3) NOT NULL DEFAULT '0',
107 `visitors_max` int(3) NOT NULL DEFAULT '25',
108 `landscape` decimal(2,1) NOT NULL,
109 `price` int(11) NOT NULL,
110 `sale` int(1) NOT NULL,
111 `taxi` int(1) NOT NULL,
112 `violence` int(11) NOT NULL,
113 `fight` int(1) NOT NULL DEFAULT '1',
114 `poof` int(1) NOT NULL DEFAULT '1',
115 `eat` int(1) NOT NULL DEFAULT '1',
116 `gym` int(1) NOT NULL DEFAULT '0',
117 `freeze` int(1) NOT NULL DEFAULT '0',
118 PRIMARY KEY (`id`)
119) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=368 ;
120
121--
122--