API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 10th, 2020
464
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 15.02 KB | None | 0 0
raw download clone embed print report
  1. -- Create Tables
  2. CREATE 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.  
  10. CREATE 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.  
  17. CREATE 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.  
  27. CREATE 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.  
  34. CREATE 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.  
  48. CREATE 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.  
  56. CREATE 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.  
  76. CREATE 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.  
  91. CREATE 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.  
  106. CREATE 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.  
  115. CREATE 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.  
  122. CREATE 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.  
  130. CREATE 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.  
  141. CREATE 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.  
  149. CREATE 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.  
  162. CREATE 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.  
  179. CREATE 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
  194. ALTER 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.  
  217. ALTER TABLE `guilds`
  218.     ADD `description` text NOT NULL,
  219.     ADD `create_ip` int(11) NOT NULL DEFAULT '0',
  220.     ADD `guild_logo` mediumblob;
  221.  
  222. ALTER TABLE `guild_invites`
  223.     ADD `date` int(11) NOT NULL;
  224.  
  225. ALTER 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
  242. INSERT 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.  
  248. INSERT 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.  
  254. INSERT 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.  
  257. INSERT 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!