· 8 years ago · Jul 25, 2018, 08:16 AM
1-- MySQL dump 10.13 Distrib 5.7.22, for Linux (x86_64)
2--
3-- Host: localhost Database: dum_devworld01
4-- ------------------------------------------------------
5-- Server version 5.7.22-0ubuntu18.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `tbl_NPC`
20--
21
22DROP TABLE IF EXISTS `tbl_NPC`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `tbl_NPC` (
26 `id` int(32) NOT NULL AUTO_INCREMENT,
27 `name` varchar(50) NOT NULL,
28 `room` varchar(50) NOT NULL,
29 `lvl` int(11) NOT NULL,
30 `exp` int(11) NOT NULL,
31 `str` int(11) NOT NULL,
32 `per` int(11) NOT NULL,
33 `endu` int(11) NOT NULL,
34 `cha` int(11) NOT NULL,
35 `inte` int(11) NOT NULL,
36 `agi` int(11) NOT NULL,
37 `luc` int(11) NOT NULL,
38 `cred` int(11) NOT NULL,
39 `inv` varchar(200) NOT NULL,
40 `isAttackable` tinyint(1) NOT NULL,
41 `isStealable` tinyint(1) NOT NULL,
42 `isKillable` tinyint(1) NOT NULL,
43 `isAggressive` tinyint(1) NOT NULL,
44 `vocabulary` text NOT NULL,
45 `delay` int(11) NOT NULL,
46 `lookDescription` text NOT NULL,
47 `clo_head` int(11) NOT NULL,
48 `clo_larm` int(11) NOT NULL,
49 `clo_rarm` int(11) NOT NULL,
50 `clo_lhand` int(11) NOT NULL,
51 `clo_rhand` int(11) NOT NULL,
52 `clo_chest` int(11) NOT NULL,
53 `clo_lleg` int(11) NOT NULL,
54 `clo_rleg` int(11) NOT NULL,
55 `clo_feet` int(11) NOT NULL,
56 `imp_head` int(11) NOT NULL,
57 `imp_larm` int(11) NOT NULL,
58 `imp_rarm` int(11) NOT NULL,
59 `imp_lhand` int(11) NOT NULL,
60 `imp_rhand` int(11) NOT NULL,
61 `imp_chest` int(11) NOT NULL,
62 `imp_lleg` int(11) NOT NULL,
63 `imp_rleg` int(11) NOT NULL,
64 `imp_feet` int(11) NOT NULL,
65 `hp` int(11) NOT NULL,
66 `charge` int(11) NOT NULL,
67 PRIMARY KEY (`id`)
68) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
69/*!40101 SET character_set_client = @saved_cs_client */;
70
71--
72-- Dumping data for table `tbl_NPC`
73--
74
75LOCK TABLES `tbl_NPC` WRITE;
76/*!40000 ALTER TABLE `tbl_NPC` DISABLE KEYS */;
77INSERT INTO `tbl_NPC` VALUES (1,'Cleaning Bot','$rid=0$',1,0,1,2,1,0,0,1,2,0,'inventory',1,1,1,0,'<&&_t>Cleaning Bot </&&_t><&&_t>says: </&&_t><&&_t>Beeeeeep!</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Cleaning Bot </&&_t><&&_t>says: </&&_t><&&_t>Eeeeeek!</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Cleaning Bot </&&_t><&&_t>says: </&&_t><&&_t>Buzz!</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>',50,'It\'s an automated, autonomous cleaning robot. It slowly drives around the room following mysterious paths known only to himself.',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100),(2,'Maintenance Droid','$rid=3$',1,0,8,2,7,4,3,7,5,0,'inventory',1,1,1,0,'<&&_t>Maintenance Droid </&&_t><&&_t>says: </&&_t><&&_t>Huh?</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Maintenance Droid </&&_t><&&_t>says: </&&_t><&&_t>Grunt!</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|',70,'Sturdy and durable, maintenance bots are designed to perform heavy duty tasks while supervised by a human operator.',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100),(3,'Security Guard','$rid=3$',1,0,5,8,4,4,3,7,5,110,'inventory',1,1,1,0,'<&&_t>Security Guard </&&_t><&&_t>says: </&&_t><&&_t><sigh></&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Security Guard </&&_t><&&_t>says: </&&_t><&&_t>Move along.. There\'s nothing to be seen here..</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Security Gruard </&&_t><&&_t>says: </&&_t><&&_t>How long have I been standing here?</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|<&&_t>Security Guard </&&_t><&&_t>says: </&&_t><&&_t>So bored...</&&_t><&&_c>LightGreen</&&_c><&&_c>White</&&_c><&&_c>LightBlue</&&_c>|',40,'Security guard looks like he\'s been standing here for a very long time.',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100);
78/*!40000 ALTER TABLE `tbl_NPC` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `tbl_Players`
83--
84
85DROP TABLE IF EXISTS `tbl_Players`;
86/*!40101 SET @saved_cs_client = @@character_set_client */;
87/*!40101 SET character_set_client = utf8 */;
88CREATE TABLE `tbl_Players` (
89 `name` varchar(50) NOT NULL,
90 `room` varchar(50) NOT NULL,
91 `lvl` int(11) NOT NULL,
92 `exp` int(11) NOT NULL,
93 `str` int(11) NOT NULL,
94 `per` int(11) NOT NULL,
95 `endu` int(11) NOT NULL,
96 `cha` int(11) NOT NULL,
97 `inte` int(11) NOT NULL,
98 `agi` int(11) NOT NULL,
99 `luc` int(11) NOT NULL,
100 `cred` int(11) NOT NULL,
101 `inv` varchar(200) NOT NULL,
102 `pwd` varchar(50) NOT NULL,
103 `clo_head` int(11) NOT NULL,
104 `clo_larm` int(11) NOT NULL,
105 `clo_rarm` int(11) NOT NULL,
106 `clo_lhand` int(11) NOT NULL,
107 `clo_rhand` int(11) NOT NULL,
108 `clo_chest` int(11) NOT NULL,
109 `clo_lleg` int(11) NOT NULL,
110 `clo_rleg` int(11) NOT NULL,
111 `clo_feet` int(11) NOT NULL,
112 `imp_head` int(11) NOT NULL,
113 `imp_larm` int(11) NOT NULL,
114 `imp_rarm` int(11) NOT NULL,
115 `imp_lhand` int(11) NOT NULL,
116 `imp_rhand` int(11) NOT NULL,
117 `imp_chest` int(11) NOT NULL,
118 `imp_lleg` int(11) NOT NULL,
119 `imp_rleg` int(11) NOT NULL,
120 `imp_feet` int(11) NOT NULL,
121 `hp` int(11) NOT NULL,
122 `charge` int(11) NOT NULL,
123 PRIMARY KEY (`name`)
124) ENGINE=InnoDB DEFAULT CHARSET=latin1;
125/*!40101 SET character_set_client = @saved_cs_client */;
126
127--
128-- Dumping data for table `tbl_Players`
129--
130
131LOCK TABLES `tbl_Players` WRITE;
132/*!40000 ALTER TABLE `tbl_Players` DISABLE KEYS */;
133INSERT INTO `tbl_Players` VALUES ('Bartek','$rid=0$',1,0,6,4,8,7,5,5,6,1332,'inventory','haslo',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100),('Buzia','$rid=3$',1,0,6,4,8,7,5,5,6,1332,'inventory','haslo',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100),('Slav','$rid=3$',1,0,6,4,8,7,5,5,6,1332,'inventory','haslo',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100,100);
134/*!40000 ALTER TABLE `tbl_Players` ENABLE KEYS */;
135UNLOCK TABLES;
136/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
137
138/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
139/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
140/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
141/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
142/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
143/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
144/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
145
146-- Dump completed on 2018-07-25 8:09:42