bxH9VGFs

1 
2SET NAMES utf8;
3SET time_zone = '+00:00';
4SET foreign_key_checks = 0;
5SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
6 
7DROP TABLE IF EXISTS `mordan_clans`;
8CREATE TABLE `mordan_clans` (
9  `clan_name` varchar(23) NOT NULL,
10  `color` varchar(23) DEFAULT NULL,
11  `members` text,
12  `gold` int(10) unsigned DEFAULT '0',
13  `kills` int(10) unsigned DEFAULT '0',
14  `deaths` int(10) unsigned DEFAULT '0',
15  `default_rank` varchar(23) DEFAULT NULL,
16  `default_perm` varchar(23) DEFAULT NULL,
17  `ally` text,
18  `enemy` text,
19  PRIMARY KEY (`clan_name`)
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;
21 
22 
23DROP TABLE IF EXISTS `mordan_head`;
24CREATE TABLE `mordan_head` (
25  `username` varchar(23) NOT NULL,
26  `gold` int(10) unsigned DEFAULT '0',
27  PRIMARY KEY (`username`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29 
30 
31DROP TABLE IF EXISTS `mordan_players_atribute`;
32CREATE TABLE `mordan_players_atribute` (
33  `username` varchar(23) NOT NULL,
34  `gold` int(10) unsigned DEFAULT '0',
35  `rank` float DEFAULT '0',
36  `pvp_win` smallint(5) unsigned DEFAULT '0',
37  `pvp_lose` smallint(5) unsigned DEFAULT '0',
38  `pk` smallint(5) unsigned DEFAULT '0',
39  `mission_complete` smallint(5) unsigned DEFAULT '0',
40  `monster_killed` int(10) unsigned DEFAULT '0',
41  PRIMARY KEY (`username`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43 
44INSERT INTO `mordan_players_atribute` (`username`, `gold`, `rank`, `pvp_win`, `pvp_lose`, `pk`, `mission_complete`, `monster_killed`) VALUES
45('Hades',   77, 14.4,   0,  0,  0,  5,  19),
46('MiolQ Krul',  3,  -1, 0,  0,  0,  0,  6);
47 
48DROP TABLE IF EXISTS `mordan_players_character`;
49CREATE TABLE `mordan_players_character` (
50  `username` varchar(23) NOT NULL,
51  `character_1` varchar(23) DEFAULT 'NONE',
52  `character_2` varchar(23) DEFAULT 'NONE',
53  `character_3` varchar(23) DEFAULT 'PREMIUM',
54  `character_4` varchar(23) DEFAULT 'PREMIUM',
55  `mordan_points` int(10) unsigned DEFAULT '0',
56  `loggedin` int(10) unsigned DEFAULT '0',
57  PRIMARY KEY (`username`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59 
60INSERT INTO `mordan_players_character` (`username`, `character_1`, `character_2`, `character_3`, `character_4`, `mordan_points`, `loggedin`) VALUES
61('Hades',   'MiolQ Krul,7,',    'Hades,10,',    'PREMIUM',  'PREMIUM',  0,  0);
62 
63DROP TABLE IF EXISTS `mordan_players_items`;
64CREATE TABLE `mordan_players_items` (
65  `username` varchar(23) NOT NULL,
66  `items` text,
67  PRIMARY KEY (`username`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69 
70INSERT INTO `mordan_players_items` (`username`, `items`) VALUES
71('Hades',   'ITMW_1H_VLK_DAGGER 1,ITFOMUTTONRAW 22,ITPL_WEED 3,ITAR_VLK_L 1,ITMW_1H_BAU_AXE 1,ITFO_WINE 4,ITPL_MUSHROOM_01 2,ITFO_BEER 6,'),
72('MiolQ Krul',  'ITMW_1H_VLK_DAGGER 1,ITFOMUTTONRAW 11,ITRW_ARROW 5,ITPO_HEALTH_01 1,');
73 
74DROP TABLE IF EXISTS `mordan_players_mission`;
75CREATE TABLE `mordan_players_mission` (
76  `username` varchar(23) NOT NULL,
77  `mission` text,
78  `mission_data` text,
79  PRIMARY KEY (`username`)
80) ENGINE=InnoDB DEFAULT CHARSET=latin1;
81 
82INSERT INTO `mordan_players_mission` (`username`, `mission`, `mission_data`) VALUES
83('Hades',   'KARCZMARZ_BEER 0,NAREK_WINE 0,MAZAR_FOOD_TO_CITY 0,',  ',,,'),
84('MiolQ Krul',  'INTRODUCTION 0,',  ',');
85 
86DROP TABLE IF EXISTS `mordan_players_npc_menu`;
87CREATE TABLE `mordan_players_npc_menu` (
88  `username` varchar(23) NOT NULL,
89  `menu` text,
90  PRIMARY KEY (`username`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92 
93INSERT INTO `mordan_players_npc_menu` (`username`, `menu`) VALUES
94('Hades',   'SEAL ,TRENING_STR ,TRENING_2H ,MISSION_WINE_WAIT ,MISSION_WHITE_RUM ,,MISSION_BEER ,MISSION_BEER ,MISSION_BEER ,MISSION_BEER ,MISSION_BEER ,MISSION_BEER ,MISSION_DEMON_SCAVENGER ,,,,,,,,,,,,,,,,,,WELCOME ,MISSION_WOLF_CANINES ,WELCOME ,,,,,MISSION_PLANTS SHOP ,,,HEAL ,MISSION_SEAL_LVL_5_START ,MISSION_SEAL_LVL_10_START ,LVL_15 ,LVL_20 ,LVL_25 ,,,ITEMSHOP ,,MISSION_BLACKWOLF ,WELCOME ,WELCOME ,WELCOME ,WELCOME ,,LVL_20 ,LVL_30 ,LVL_35 ,LVL_40 ,LVL_45 ,LVL_50 ,LVL_55 ,SHOP_SELL ,'),
95('MiolQ Krul',  ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,');
96 
97DROP TABLE IF EXISTS `mordan_players_skills`;
98CREATE TABLE `mordan_players_skills` (
99  `username` varchar(23) NOT NULL,
100  `hunter` text,
101  `armorer` text,
102  `alchemist` text,
103  `smith` text,
104  `mage` text,
105  `other` text,
106  PRIMARY KEY (`username`)
107) ENGINE=InnoDB DEFAULT CHARSET=latin1;
108 
109INSERT INTO `mordan_players_skills` (`username`, `hunter`, `armorer`, `alchemist`, `smith`, `mage`, `other`) VALUES
110('Hades',   '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 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',   '0 '),
111('MiolQ Krul',  '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 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',   '0 ');
112 
113DROP TABLE IF EXISTS `mordan_players_stats`;
114CREATE TABLE `mordan_players_stats` (
115  `username` varchar(23) NOT NULL,
116  `position` varchar(150) DEFAULT NULL,
117  `angle` smallint(5) unsigned DEFAULT NULL,
118  `world` varchar(40) DEFAULT NULL,
119  `acrobatic` tinyint(1) unsigned DEFAULT '0',
120  `visual` varchar(100) DEFAULT NULL,
121  `fatness` float DEFAULT NULL,
122  `dexterity` smallint(5) unsigned DEFAULT '10',
123  `strength` smallint(5) unsigned DEFAULT '10',
124  `experience` int(10) unsigned DEFAULT '0',
125  `next_experience` int(10) unsigned DEFAULT '200',
126  `level` tinyint(4) DEFAULT '0',
127  `learn_points` smallint(5) unsigned DEFAULT '0',
128  `health` smallint(5) unsigned DEFAULT '40',
129  `max_health` smallint(5) unsigned DEFAULT '40',
130  `mana` smallint(5) unsigned DEFAULT '0',
131  `max_mana` smallint(5) unsigned DEFAULT '0',
132  `magic_level` tinyint(4) DEFAULT '0',
133  `1h` tinyint(4) DEFAULT '0',
134  `2h` tinyint(4) DEFAULT '0',
135  `bow` tinyint(4) DEFAULT '0',
136  `crossbow` tinyint(4) DEFAULT '0',
137  `science` varchar(17) DEFAULT '0 0 0 0 0 0 0',
138  PRIMARY KEY (`username`)
139) ENGINE=InnoDB DEFAULT CHARSET=latin1;
140 
141INSERT INTO `mordan_players_stats` (`username`, `position`, `angle`, `world`, `acrobatic`, `visual`, `fatness`, `dexterity`, `strength`, `experience`, `next_experience`, `level`, `learn_points`, `health`, `max_health`, `mana`, `max_mana`, `magic_level`, `1h`, `2h`, `bow`, `crossbow`, `science`) VALUES
142('Hades',   '-897.341796875 98.185646057129 3484.5358886719',   354,    'MORDAN.ZEN',   0,  'Hum_Body_Naked0 9 Hum_Head_Pony 18',   0,  10, 10, 11421,  12529,  10, 100,    13, 178,    0,  0,  0,  0,  0,  0,  0,  '0 0 0 0 0 0 0'),
143('MiolQ Krul',  '-1490.1939697266 98.208122253418 2023.1591796875', 70, 'MORDAN.ZEN',   0,  'Hum_Body_Naked0 11 Hum_Head_Bald 18',  0.1,    10, 10, 3957,   5407,   7,  70, 30, 110,    10, 0,  0,  0,  0,  0,  0,  '0 0 0 0 0 0 0');
144 
145DROP TABLE IF EXISTS `mordan_players_update`;
146CREATE TABLE `mordan_players_update` (
147  `username` varchar(23) NOT NULL,
148  `finish` text,
149  PRIMARY KEY (`username`)
150) ENGINE=InnoDB DEFAULT CHARSET=latin1;
151 
152INSERT INTO `mordan_players_update` (`username`, `finish`) VALUES
153('Hades',   '0 1 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 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 '),
154('MiolQ Krul',  '');
155 
156DROP TABLE IF EXISTS `mordan_player_clans`;
157CREATE TABLE `mordan_player_clans` (
158  `username` varchar(23) NOT NULL,
159  `clan` varchar(23) DEFAULT NULL,
160  `rank` varchar(23) DEFAULT NULL,
161  `permission` varchar(23) DEFAULT NULL,
162  PRIMARY KEY (`username`)
163) ENGINE=InnoDB DEFAULT CHARSET=latin1;
164 
165INSERT INTO `mordan_player_clans` (`username`, `clan`, `rank`, `permission`) VALUES
166('Hades',   '', '', '0 0 0 0 0'),
167('MiolQ Krul',  '', '', '0 0 0 0 0');
168 
169DROP TABLE IF EXISTS `mordan_premium`;
170CREATE TABLE `mordan_premium` (
171  `username` varchar(23) NOT NULL,
172  `data` varchar(23) DEFAULT NULL,
173  PRIMARY KEY (`username`)
174) ENGINE=InnoDB DEFAULT CHARSET=latin1;
175 
176 
177DROP TABLE IF EXISTS `pb3_groups`;
178CREATE TABLE `pb3_groups` (
179  `group_name` varchar(30) NOT NULL,
180  `group_colour` char(30) NOT NULL,
181  `group_id` int(11) NOT NULL
182) ENGINE=InnoDB DEFAULT CHARSET=latin1;
183 
184 
185DROP TABLE IF EXISTS `pb3_users`;
186CREATE TABLE `pb3_users` (
187  `username` varchar(32) NOT NULL,
188  `user_password` varchar(32) NOT NULL,
189  `group_id` int(11) NOT NULL
190) ENGINE=InnoDB DEFAULT CHARSET=latin1;
191 
192INSERT INTO `pb3_users` (`username`, `user_password`, `group_id`) VALUES
193('Avaldsnes',   '202cb962ac59075b964b07152d234b70', 0);