· 5 years ago · Apr 10, 2020, 06:24 PM
1-- Create Tables
2CREATE TABLE IF NOT EXISTS `announcements` (
3 `id` int(10) NOT NULL ,
4 `title` varchar(50) NOT NULL,
5 `text` varchar(255) NOT NULL,
6 `date` varchar(20) NOT NULL,
7 `author` varchar(50) NOT NULL
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS `newsticker` (
11 `id` int(10) UNSIGNED NOT NULL ,
12 `date` int(11) NOT NULL,
13 `text` varchar(255) NOT NULL,
14 `icon` varchar(50) NOT NULL
15) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16
17CREATE TABLE IF NOT EXISTS `pagseguro_transactions` (
18 `transaction_code` varchar(36) NOT NULL,
19 `name` varchar(200) DEFAULT NULL,
20 `payment_method` varchar(50) NOT NULL,
21 `status` varchar(50) NOT NULL,
22 `item_count` int(11) NOT NULL,
23 `data` datetime NOT NULL,
24 `payment_amount` float DEFAULT '0'
25) ENGINE=InnoDB DEFAULT CHARSET=utf8;
26
27CREATE TABLE IF NOT EXISTS `player_former_names` (
28 `id` int(11) NOT NULL ,
29 `player_id` int(11) NOT NULL,
30 `former_name` varchar(35) NOT NULL,
31 `date` int(11) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34CREATE TABLE IF NOT EXISTS `tickets` (
35 `ticket_id` int(11) NOT NULL ,
36 `ticket_subject` varchar(45) NOT NULL,
37 `ticket_author` varchar(255) NOT NULL,
38 `ticket_author_acc_id` int(11) NOT NULL,
39 `ticket_last_reply` varchar(45) NOT NULL,
40 `ticket_admin_reply` int(11) NOT NULL,
41 `ticket_date` datetime NOT NULL,
42 `ticket_ended` varchar(45) NOT NULL,
43 `ticket_status` varchar(45) NOT NULL,
44 `ticket_category` varchar(45) NOT NULL,
45 `ticket_description` text NOT NULL
46) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
47
48CREATE TABLE IF NOT EXISTS `tickets_reply` (
49 `ticket_replyid` int(11) NOT NULL ,
50 `ticket_id` int(11) NOT NULL,
51 `reply_author` varchar(255) DEFAULT NULL,
52 `reply_message` text,
53 `reply_date` datetime DEFAULT NULL
54) ENGINE=InnoDB DEFAULT CHARSET=utf8;
55
56CREATE TABLE IF NOT EXISTS `z_forum` (
57 `id` int(11) NOT NULL ,
58 `first_post` int(11) NOT NULL DEFAULT '0',
59 `last_post` int(11) NOT NULL DEFAULT '0',
60 `section` int(3) NOT NULL DEFAULT '0',
61 `replies` int(20) NOT NULL DEFAULT '0',
62 `views` int(20) NOT NULL DEFAULT '0',
63 `author_aid` int(20) NOT NULL DEFAULT '0',
64 `author_guid` int(20) NOT NULL DEFAULT '0',
65 `post_text` text NOT NULL,
66 `post_topic` varchar(255) NOT NULL,
67 `post_smile` tinyint(1) NOT NULL DEFAULT '0',
68 `post_date` int(20) NOT NULL DEFAULT '0',
69 `last_edit_aid` int(20) NOT NULL DEFAULT '0',
70 `edit_date` int(20) NOT NULL DEFAULT '0',
71 `post_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
72 `icon_id` int(11) NOT NULL,
73 `news_icon` varchar(50) NOT NULL
74) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75
76CREATE TABLE IF NOT EXISTS `z_ots_comunication` (
77 `id` int(11) NOT NULL ,
78 `name` varchar(255) NOT NULL,
79 `type` varchar(255) NOT NULL,
80 `action` varchar(255) NOT NULL,
81 `param1` varchar(255) NOT NULL,
82 `param2` varchar(255) NOT NULL,
83 `param3` varchar(255) NOT NULL,
84 `param4` varchar(255) NOT NULL,
85 `param5` varchar(255) NOT NULL,
86 `param6` varchar(255) NOT NULL,
87 `param7` varchar(255) NOT NULL,
88 `delete_it` int(2) NOT NULL DEFAULT '1'
89) ENGINE=InnoDB DEFAULT CHARSET=utf8;
90
91CREATE TABLE IF NOT EXISTS `z_ots_guildcomunication` (
92 `id` int(11) NOT NULL ,
93 `name` varchar(255) NOT NULL,
94 `type` varchar(255) NOT NULL,
95 `action` varchar(255) NOT NULL,
96 `param1` varchar(255) NOT NULL,
97 `param2` varchar(255) NOT NULL,
98 `param3` varchar(255) NOT NULL,
99 `param4` varchar(255) NOT NULL,
100 `param5` varchar(255) NOT NULL,
101 `param6` varchar(255) NOT NULL,
102 `param7` varchar(255) NOT NULL,
103 `delete_it` int(2) NOT NULL DEFAULT '1'
104) ENGINE=InnoDB DEFAULT CHARSET=utf8;
105
106CREATE TABLE IF NOT EXISTS `z_polls` (
107 `id` int(11) NOT NULL ,
108 `question` varchar(255) NOT NULL,
109 `end` int(11) NOT NULL,
110 `start` int(11) NOT NULL,
111 `answers` int(11) NOT NULL,
112 `votes_all` int(11) NOT NULL
113) ENGINE=InnoDB DEFAULT CHARSET=utf8;
114
115CREATE TABLE IF NOT EXISTS `z_polls_answers` (
116 `poll_id` int(11) NOT NULL ,
117 `answer_id` int(11) NOT NULL,
118 `answer` varchar(255) NOT NULL,
119 `votes` int(11) NOT NULL
120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121
122CREATE TABLE IF NOT EXISTS `z_shop_category` (
123 `id` int(11) NOT NULL ,
124 `name` varchar(50) NOT NULL,
125 `desc` varchar(255) NOT NULL,
126 `button` varchar(50) NOT NULL,
127 `hide` int(11) NOT NULL DEFAULT '0'
128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129
130CREATE TABLE IF NOT EXISTS `z_shop_donates` (
131 `id` int(11) NOT NULL ,
132 `date` int(11) NOT NULL,
133 `reference` varchar(50) NOT NULL,
134 `account_name` varchar(50) NOT NULL,
135 `method` varchar(50) NOT NULL,
136 `price` varchar(20) NOT NULL,
137 `coins` int(11) NOT NULL,
138 `status` varchar(20) NOT NULL
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140
141CREATE TABLE IF NOT EXISTS `z_shop_donate_confirm` (
142 `id` int(11) NOT NULL ,
143 `date` int(11) NOT NULL,
144 `account_name` varchar(50) NOT NULL,
145 `donate_id` int(11) NOT NULL,
146 `msg` text NOT NULL
147) ENGINE=InnoDB DEFAULT CHARSET=utf8;
148
149CREATE TABLE IF NOT EXISTS `z_shop_history_item` (
150 `id` int(11) NOT NULL ,
151 `to_name` varchar(255) NOT NULL DEFAULT '0',
152 `to_account` int(11) NOT NULL DEFAULT '0',
153 `from_nick` varchar(255) NOT NULL,
154 `from_account` int(11) NOT NULL DEFAULT '0',
155 `price` int(11) NOT NULL DEFAULT '0',
156 `offer_id` varchar(255) NOT NULL DEFAULT '',
157 `trans_state` varchar(255) NOT NULL,
158 `trans_start` int(11) NOT NULL DEFAULT '0',
159 `trans_real` int(11) NOT NULL DEFAULT '0'
160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
161
162CREATE TABLE IF NOT EXISTS `z_shop_offer` (
163 `id` int(11) NOT NULL ,
164 `category` int(11) NOT NULL,
165 `coins` int(11) NOT NULL DEFAULT '0',
166 `price` varchar(50) NOT NULL,
167 `itemid` int(11) NOT NULL DEFAULT '0',
168 `mount_id` varchar(100) NOT NULL,
169 `addon_name` varchar(100) NOT NULL,
170 `count` int(11) NOT NULL DEFAULT '0',
171 `offer_type` varchar(255) DEFAULT NULL,
172 `offer_description` text NOT NULL,
173 `offer_name` varchar(255) NOT NULL,
174 `offer_date` int(11) NOT NULL,
175 `default_image` varchar(50) NOT NULL,
176 `hide` int(11) NOT NULL DEFAULT '0'
177) ENGINE=InnoDB DEFAULT CHARSET=utf8;
178
179CREATE TABLE IF NOT EXISTS `z_shop_payment` (
180 `id` int(11) NOT NULL ,
181 `ref` varchar(10) NOT NULL,
182 `account_name` varchar(50) NOT NULL,
183 `service_id` int(11) NOT NULL,
184 `service_category_id` int(11) NOT NULL,
185 `payment_method_id` int(11) NOT NULL,
186 `price` varchar(50) NOT NULL,
187 `coins` int(11) UNSIGNED NOT NULL,
188 `status` varchar(50) NOT NULL DEFAULT 'waiting',
189 `date` int(11) NOT NULL,
190 `gift` int(11) NOT NULL DEFAULT '0'
191) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192
193-- Alter Tables
194ALTER TABLE `accounts`
195 ADD `coins` int(12) NOT NULL DEFAULT '0',
196 ADD `key` varchar(20) NOT NULL DEFAULT '0',
197 ADD `create_ip` int(11) NOT NULL DEFAULT '0',
198 ADD `page_access` int(11) NOT NULL DEFAULT '0',
199 ADD `location` varchar(255) NOT NULL DEFAULT '0',
200 ADD `rlname` varchar(255) NOT NULL DEFAULT '0',
201 ADD `vip_time` int(11) NOT NULL,
202 ADD `birth_date` varchar(50) NOT NULL DEFAULT '0',
203 ADD `gender` varchar(20) NOT NULL DEFAULT '0',
204 ADD `guild_points_stats` int(11) NOT NULL DEFAULT '0',
205 ADD `email_new` varchar(255) NOT NULL DEFAULT '0',
206 ADD `email_new_time` int(11) NOT NULL DEFAULT '0',
207 ADD `email_code` varchar(255) NOT NULL DEFAULT '0',
208 ADD `next_email` int(11) NOT NULL DEFAULT '0',
209 ADD `create_date` int(11) NOT NULL DEFAULT '0',
210 ADD `last_post` int(11) NOT NULL DEFAULT '0',
211 ADD `flag` varchar(80) NOT NULL DEFAULT '',
212 ADD `vote` int(11) NOT NULL DEFAULT '0',
213 ADD `loyalty_points` bigint(20) NOT NULL DEFAULT '0',
214 ADD `guild_points` int(11) NOT NULL DEFAULT '0',
215 ADD `authToken` varchar(100) NOT NULL;
216
217ALTER TABLE `guilds`
218 ADD `description` text NOT NULL,
219 ADD `create_ip` int(11) NOT NULL DEFAULT '0',
220 ADD `guild_logo` mediumblob;
221
222ALTER TABLE `guild_invites`
223 ADD `date` int(11) NOT NULL;
224
225ALTER TABLE `players`
226 ADD `signature` varchar(255) NOT NULL,
227 ADD `marriage_spouse` int(11) NOT NULL DEFAULT '-1',
228 ADD `marriage_status` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
229 ADD `deleted` tinyint(1) NOT NULL DEFAULT '0',
230 ADD `description` varchar(255) NOT NULL DEFAULT '',
231 ADD `comment` text NOT NULL,
232 ADD `create_ip` int(11) NOT NULL DEFAULT '0',
233 ADD `create_date` int(11) NOT NULL DEFAULT '0',
234 ADD `hide_char` int(11) NOT NULL DEFAULT '0',
235 ADD `cast` tinyint(1) NOT NULL DEFAULT '0',
236 ADD `hide_skills` int(11) DEFAULT NULL,
237 ADD `hide_set` int(11) DEFAULT NULL,
238 ADD `former` varchar(255) NOT NULL DEFAULT '-',
239 ADD `loyalty_ranking` tinyint(1) NOT NULL DEFAULT '0';
240
241-- Insert Tables
242INSERT INTO `z_shop_category` (`id`, `name`, `desc`, `button`, `hide`) VALUES
243(2, 'Extra Services', 'Buy an extra service to transfer a character to another game world, to change your character name or sex, to change your account name, or to get a new recovery key.', '_sbutton_getextraservice.gif', 0),
244(3, 'Mounts', 'Buy your characters one or more of the fabulous mounts offered here.', '_sbutton_getmount.gif', 1),
245(4, 'Outfits', 'Buy your characters one or more of the fancy outfits offered here.', '_sbutton_getoutfit.gif', 1),
246(5, 'Items', 'Buy items for your character be more stronger in the game.', '_sbutton_getextraservice.gif', 1);
247
248INSERT INTO `z_shop_offer` (`id`, `category`, `coins`, `price`, `itemid`, `mount_id`, `addon_name`, `count`, `offer_type`, `offer_description`, `offer_name`, `offer_date`, `default_image`, `hide`) VALUES
249(5, 2, 250, '', 0, '', '', 1, 'changename', 'Buy a character name change to rename one of your characters.', 'Character Change Name', 1416865577, 'changename.png', 0),
250(6, 2, 10, '', 0, '', '', 1, 'changesex', 'Buy a character sex change to turn your male character into a female one, or your female character into a male one.', 'Character Change Sex', 1416874417, 'changesex.png', 1),
251(7, 2, 250, '', 0, '', '', 1, 'changeaccountname', 'Buy an account name change to select a different name for your account.', 'Account Name Change', 1416874601, 'changeaccountname.png', 0),
252(8, 2, 300, '', 0, '', '', 1, 'newrk', 'If you need a new recovery key, you can order it here. Note that the letter for the new recovery key can only be sent to the address in the account registration.', 'Recovery Key', 1416874816, 'newrk.png', 0);
253
254INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `type`, `premdays`, `coins`, `lastday`, `email`, `creation`, `vote`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `create_date`, `create_ip`, `last_post`, `flag`, `vip_time`, `guild_points`, `guild_points_stats`, `passed`, `block`, `refresh`, `birth_date`, `gender`, `loyalty_points`, `authToken`) VALUES
255(1, '1', '356a192b7913b04c54574d18c28d46e6395428ab', NULL, 1, 0, 0, 0, '', 0, 0, '0', '', 0, '', '', 0, '', 0, 0, 0, 0, 'unknown', 0, 0, 0, 0, 0, 0, '', '', 0, '');
256
257INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `blessings1`, `blessings2`, `blessings3`, `blessings4`, `blessings5`, `blessings6`, `blessings7`, `blessings8`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries`, `skill_criticalhit_chance`, `skill_criticalhit_damage`, `skill_lifeleech_chance`, `skill_lifeleech_amount`, `skill_manaleech_chance`, `skill_manaleech_amount`, `prey_stamina_1`, `prey_stamina_2`, `prey_stamina_3`, `prey_column`, `bonus_rerolls`, `xpboost_stamina`, `xpboost_value`, `marriage_status`, `hide_skills`, `hide_set`, `former`, `signature`, `marriage_spouse`, `loyalty_ranking`) VALUES
258(1, 'Account Manager', 1, 1, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 6, 0, 0, 0, '', 400, 0, 1407021967, 1793873073, 1, 0, 0, 1407021968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
259(2, 'Rook Sample', 1, 1, 1, 0, 150, 150, 0, 106, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 6, 0, 0, 0, '', 400, 0, 1407021967, 1793873073, 1, 0, 0, 1407021968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
260(3, 'Sorcerer Sample', 1, 1, 8, 1, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158878, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
261(4, 'Druid Sample', 1, 1, 8, 2, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
262(5, 'Paladin Sample', 1, 1, 8, 3, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158919, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0),
263(6, 'Knight Sample', 1, 1, 8, 4, 185, 185, 4200, 106, 95, 78, 116, 128, 0, 0, 40, 40, 0, 0, 2, 0, 0, 0, '', 470, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 1507158938, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, 0, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0);