API tools faq
paste
Advertisement
Liqxiez

SQL commands guild wars

Liqxiez
Apr 17th, 2019
233
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 22.61 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server version:               5.5.9-log - MySQL Community Server (GPL)
  4. -- Server OS:                    Win32
  5. -- HeidiSQL Version:             9.1.0.4867
  6. -- Grumboz Guild Warz            3.3.5a WotlK Eluna Boost
  7. -- --------------------------------------------------------
  8. CREATE DATABASE IF NOT EXISTS `guild_warz_335` /*!40100 DEFAULT CHARACTER SET utf8 */;
  9. USE `guild_warz_335`;
  10.  
  11.  
  12. CREATE TABLE IF NOT EXISTS `commands` (
  13.   `guild` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Do Not Touch',
  14.   `guild_id` mediumint(8) UNSIGNED NULL DEFAULT NULL COMMENT 'guild id',
  15.   `team` tinyint(1) UNSIGNED NOT NULL COMMENT 'guild team id',
  16.   `commands` VARCHAR(10) NOT NULL DEFAULT 'commands',
  17.   `info_loc` VARCHAR(10) NOT NULL DEFAULT 'info',
  18.   `list_loc` VARCHAR(10) NOT NULL DEFAULT 'list',
  19.   `tele` VARCHAR(6) NOT NULL DEFAULT 'gtele',
  20.   `version` VARCHAR(15) NOT NULL DEFAULT 'ver',
  21.   `GLD_lvlb` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Minimum Required Guild member level to access Guild Master buy commands. Guild Master = 0 , anything over + is rank below Guild master.',
  22.   `GLD_lvls` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Minimum Required Guild member level to access Guild Master sell commands. Guild Master = 0 , anything over + is rank below Guild master.',
  23.   `respawn_flag` VARCHAR(50) NOT NULL DEFAULT 'flag' COMMENT 'GM command spawns and assigns a flag to a guild owned area. will return an error if location is owned by SERVER',
  24.   `details_loc` VARCHAR(50) NOT NULL DEFAULT 'loc' COMMENT 'GM command gives more info about location.',
  25.   `table` VARCHAR(50) NOT NULL DEFAULT 'table' COMMENT 'GM command reloads GW table.',
  26.   `GM_admin` tinyint(3) UNSIGNED NOT NULL DEFAULT '4' COMMENT 'GM rank of server admin',
  27.   `GM_minimum` tinyint(1) UNSIGNED NOT NULL DEFAULT '3' COMMENT 'Minimum Required Gm security level to use GM level commands.',
  28.   `currency` mediumint(8) UNSIGNED NOT NULL DEFAULT '62006' COMMENT 'item id for currency used.',
  29.   `pig_payz` BIGINT(20) UNSIGNED NOT NULL DEFAULT '100000' COMMENT 'amount in copper that each pig payz. hence "pig payz". default 100000 = 10g ',
  30.   `pig_payz_timer` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1800000' COMMENT 'timer for pig payz. default  1800000 = 30 minutes.',
  31.   `gift_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '25' COMMENT 'how many of currency item to give to guildmaster of newly created guild.',
  32.   `flag_require` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'does capturing a flag require killing all guards? default  == 0 no ; 1 == yes',
  33.   `Server` VARCHAR(6) NOT NULL DEFAULT 'SERVER' COMMENT 'Do Not Touch',
  34.   `command_set` VARCHAR(50) NOT NULL DEFAULT 'set' COMMENT 'Do Not Touch ',
  35.   `anarchy` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'pure GvG PvP no faction filter.',
  36.   `f_timer` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'applies a cooldown-timer when a flag spaws. 0=off::1=on',
  37.   `s_timer` BIGINT(20) UNSIGNED NOT NULL DEFAULT '600000' COMMENT 'no-tag-flag timer cooldown time in seconds. i.e. 5 minutes = 300 seconds.',
  38.   `guild_invite` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'guild invite system. 0 == off :: 1 == on',
  39.   `loc` VARCHAR(15) NOT NULL DEFAULT 'area',
  40.   `loc_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '10' COMMENT 'price for basic empty zone.',
  41.   `flag_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '187432' COMMENT 'Do Not Touch',
  42.   `farm` VARCHAR(15) NOT NULL DEFAULT 'farm',
  43.   `farm_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '5' COMMENT 'price for small cheezy government issued house.',
  44.   `farm_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'how many farms per location.',
  45.   `farm_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '500000' COMMENT 'Do Not Touch',
  46.   `barrack` VARCHAR(15) NOT NULL DEFAULT 'barrack',
  47.   `barrack_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '10' COMMENT 'price for small cheezy government issued house.',
  48.   `barrack_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'how many barracks per location.',
  49.   `barrack_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '500002' COMMENT 'Do Not Touch',
  50.   `hall` VARCHAR(15) NOT NULL DEFAULT 'hall',
  51.   `hall_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '100' COMMENT 'price for small cheezy government issued house.',
  52.   `hall_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'how many houses per location.',
  53.   `hall_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '500004' COMMENT 'Do Not Touch',
  54.   `pig` VARCHAR(15) NOT NULL DEFAULT 'pig',
  55.   `pig_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'price for one of these porkerz',
  56.   `pig_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '20' COMMENT 'how many pigs per farm.',
  57.   `pig_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49000' COMMENT 'Do Not Touch',
  58.   `guard` VARCHAR(15) NOT NULL DEFAULT 'guard',
  59.   `guard_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'how much is your back worth guarding?',
  60.   `guard_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '10' COMMENT 'how many guards per location.',
  61.   `guard_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49002' COMMENT 'Do Not Touch',
  62.   `vendor1` VARCHAR(15) NOT NULL DEFAULT 'vendor1',
  63.   `vendor1_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '25',
  64.   `vendor1_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  65.   `vendor1_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49004' COMMENT 'Do Not Touch',
  66.   `vendor2` VARCHAR(15) NOT NULL DEFAULT 'vendor2',
  67.   `vendor2_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '25',
  68.   `vendor2_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  69.   `vendor2_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49006' COMMENT 'Do Not Touch',
  70.   `vendor3` VARCHAR(15) NOT NULL DEFAULT 'vendor3',
  71.   `vendor3_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '25',
  72.   `vendor3_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  73.   `vendor3_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49008' COMMENT 'Do Not Touch',
  74.   `cannon` VARCHAR(15) NOT NULL DEFAULT 'cannon',
  75.   `cannon_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '100',
  76.   `cannon_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '3',
  77.   `cannon_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '49010' COMMENT 'Do Not Touch',
  78.   `vault` VARCHAR(15) NOT NULL DEFAULT 'vault',
  79.   `vault_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '100',
  80.   `vault_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  81.   `vault_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '500008' COMMENT 'Do Not Touch',
  82.   `mailbox` VARCHAR(15) NOT NULL DEFAULT 'mailbox',
  83.   `mailbox_cost` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '10',
  84.   `mailbox_L` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  85.   `mailbox_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '500010' COMMENT 'Do Not Touch',
  86.   `setup` VARCHAR(10) DEFAULT 'setup' COMMENT 'player command that gives info about how its setup.',
  87.   `color_1` VARCHAR(10) DEFAULT '|cff00cc00' COMMENT 'Command color GREEN',
  88.   `color_2` VARCHAR(10) NOT NULL DEFAULT '|cffFFFF00' COMMENT 'Value color YELLOW',
  89.   `color_3` VARCHAR(10) NOT NULL DEFAULT '|cffFFFFFF' COMMENT 'Info color WHITE',
  90.   `color_4` VARCHAR(10) NOT NULL DEFAULT '|cff3399FF' COMMENT 'Alliance color BLUE',
  91.   `color_5` VARCHAR(10) NOT NULL DEFAULT '|cffBA0000' COMMENT 'Horde color RED',
  92.   `color_6` VARCHAR(10) NOT NULL DEFAULT '|cffFFFF00' COMMENT 'For Sale color YELLOW',
  93.   `color_7` VARCHAR(10) NOT NULL DEFAULT '|cffFF0000' COMMENT 'LOCKED color RED',
  94.   `color_8` VARCHAR(10) NOT NULL DEFAULT '|cffC0C0C0' COMMENT 'Titles color GREY',
  95.   `color_9` VARCHAR(10) NOT NULL DEFAULT '|cff000000' COMMENT 'Separators color BLACK',
  96.   `color_10` VARCHAR(10) NOT NULL DEFAULT '|cff00cc00' COMMENT 'HELP Commands color GREEN',
  97.   `color_11` VARCHAR(10) NOT NULL DEFAULT '|cffFFFF00' COMMENT 'HELP Description color YELLOW',
  98.   `color_12` VARCHAR(10) NOT NULL DEFAULT '|cffFF0000' COMMENT 'SET Error color RED',
  99.   `color_13` VARCHAR(10) NOT NULL DEFAULT '|cffFFFFFF' COMMENT 'SET Values color WHITE',
  100.   `color_14` VARCHAR(10) NOT NULL DEFAULT '|cff00cc00' COMMENT 'Good Announcements color GREEN',
  101.   `color_15` VARCHAR(10) NOT NULL DEFAULT '|cffFF0000' COMMENT 'Bad Annoucements RED',
  102.   UNIQUE KEY `guild_id` (`guild_id`)
  103. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='version 1.77';
  104.  
  105. REPLACE INTO `commands` (`guild`, `guild_id`, `team`, `commands`, `info_loc`, `list_loc`, `tele`, `version`, `GLD_lvlb`, `GLD_lvls`, `respawn_flag`, `details_loc`, `table`, `GM_admin`, `GM_minimum`, `currency`, `pig_payz`, `pig_payz_timer`, `gift_count`, `flag_require`, `Server`, `command_set`, `anarchy`, `f_timer`, `s_timer`, `guild_invite`, `loc`, `loc_cost`, `flag_id`, `farm`, `farm_cost`, `farm_L`, `farm_id`, `barrack`, `barrack_cost`, `barrack_L`, `barrack_id`, `hall`, `hall_cost`, `hall_L`, `hall_id`, `pig`, `pig_cost`, `pig_L`, `pig_id`, `guard`, `guard_cost`, `guard_L`, `guard_id`, `vendor1`, `vendor1_cost`, `vendor1_L`, `vendor1_id`, `vendor2`, `vendor2_cost`, `vendor2_L`, `vendor2_id`, `vendor3`, `vendor3_cost`, `vendor3_L`, `vendor3_id`, `cannon`, `cannon_cost`, `cannon_L`, `cannon_id`, `vault`, `vault_cost`, `vault_L`, `vault_id`, `mailbox`, `mailbox_cost`, `mailbox_L`, `mailbox_id`, `setup`, `color_1`, `color_2`, `color_3`, `color_4`, `color_5`, `color_6`, `color_7`, `color_8`, `color_9`, `color_10`, `color_11`, `color_12`, `color_13`, `color_14`, `color_15`) VALUES
  106.     ('SERVER', 0, 0, 'commands', 'info', 'list', 'gtele', 'ver', 0, 0, 'flag', 'loc', 'table', 5, 4, 62006, 100000, 1800000, 25, 0, 'SERVER', 'set', 1, 1, 300, 0, 'area', 10, 187432, 'farm', 5, 3, 500000, 'barrack', 10, 1, 500002, 'hall', 100, 1, 500004, 'pig', 1, 5, 49000, 'guard', 1, 10, 49002, 'vendor1', 25, 1, 49004, 'vendor2', 25, 1, 49006, 'vendor3', 25, 1, 49008, 'cannon', 100, 3, 49010, 'vault', 100, 3, 500006, 'mailbox', 10, 3, 500008, 'setup', '|cff00cc00', '|cffFFFF00', '|cffFFFFFF', '|cff3399FF', '|cffFF0000', '|cffFFFF00', '|cffFF0000', '|cffC0C0C0', '|cff000000', '|cff00cc00', '|cffFFFF00', '|cffFF0000', '|cffFFFFFF', '|cff00cc00', '|cffFF0000');
  107.  
  108. CREATE TABLE IF NOT EXISTS `help` (
  109.   `entry` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  110.   `name` VARCHAR(50) DEFAULT NULL,
  111.   `description` VARCHAR(1028) NOT NULL,
  112.   `example` VARCHAR(1028) NOT NULL,
  113.   `command_level` VARCHAR(1028) NOT NULL,
  114.   PRIMARY KEY (`entry`),
  115.   UNIQUE KEY `entry` (`entry`)
  116. ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 MAX_ROWS=5000 COMMENT='version 1.77';
  117.  
  118. REPLACE INTO `help` (`entry`, `name`, `description`, `example`, `command_level`) VALUES
  119.     (1, 'guild', 'Guild name for command entry . non-modifyable >>>>>DO NOT CHANGE<<<<<<', 'LOCKED', '7'),
  120.     (2, 'commands', 'produces a list of accessible commands by level.', 'set commands comm', '1'),
  121.     (3, 'info_loc', 'produces a basic description of current location.', 'set info_loc look', '1'),
  122.     (4, 'list_loc', 'produces a list of all locations own by player guild sshowing the loocation id, houses, guards, pigs, and value then provides a tally at the end.', 'set list_loc lands', '1'),
  123.     (5, 'tele', 'allows guild members to teleport to guild location flags using location id\'s.', 'set tele goto', '1'),
  124.     (6, 'buy', 'allows guild member to buy.', 'LOCKED', '7'),
  125.     (7, 'sell', 'allows guild member to sell.', 'LOCKED', '7'),
  126.     (8, 'GLD_lvlb', 'allows rank x access to guild master buy commands. guildmaster==0 any number above 0 is a lower guild rank i.e. officer==1.', 'set GLD_lvlb 2', '4'),
  127.     (9, 'GLD_lvls', 'allows rank x access to guild master sell commands. same as LGD_lvlb guild master == 0 officer == 1 etc.. etc..etc...', 'set GLD_lvls 1', '4'),
  128.     (10, 'reset loc', 'allows GM of minimum rank to reset a location onwner to "SERVER" and able to be purchased.', 'LOCKED', '5'),
  129.     (11, 'reset farm', 'allows GM of minimum rank to reset house count of a location to 0', 'LOCKED', '5'),
  130.     (12, 'reset barrack', 'allows GM of minimum rank to reset barrack count of a location to 0', 'LOCKED', '5'),
  131.     (13, 'reset hall', 'allows GM of minimum rank to reset hall count of a location to 0', 'LOCKED', '5'),
  132.     (14, 'reset pig', 'allows GM of minimum rank to reset pig countof a location to 0', 'LOCKED', '5'),
  133.     (15, 'reset guard', 'allows GM of minimum rank to reset guard count of a location to 0', 'LOCKED', '5'),
  134.     (16, 'reset vendor3', 'allows GM of minimum rank to reset vendor_3 count of a location to 0', 'LOCKED', '5'),
  135.     (17, 'respawn flag', 'allows GM of minimum rank to spawn a missing flag and bind it to current location. if location owned by "SERVER" then an error WILL happen.', 'LOCKED', '5'),
  136.     (18, 'details_loc', 'allows a GM of minimum rank to list detailed information about current location.', 'set details_loc sniff', '5'),
  137.     (19, 'table', 'allows a GM of minimum rank to re-load all the guild warrz tables', 'set table brain', '5'),
  138.     (20, 'GM_admin', 'system setting for GM rank of ADMIN acct.', 'set GM_admin 5', '6'),
  139.     (21, 'GM_minimum', 'system setting for GM required minimum rank to access GM commands.', 'set GM_minimum 3', '6'),
  140.     (22, 'currency', 'system setting>>CANNOT BE CHANGED<<', 'LOCKED', '7'),
  141.     (23, 'pig_payz', 'system setting how much each pig payz in copper per half hour. 10g == 100000', 'set pig_payz 100000', '6'),
  142.     (24, 'pig_payz_timer', 'system setting timer for pig payz.', 'set pig_payz 1800000', '6'),
  143.     (25, 'gift_count', 'system setting how much currency to gift to newly created guilds.', 'set gift_count 25', '6'),
  144.     (26, 'flag_require', 'system setting switch does system require all guards dead to capture flag? default == 0 no; 1 == yes', 'set flag_require 1', '6'),
  145.     (27, 'Server', 'game core ID for guild ID storage of game master level commands  >>>>> DO NOT CHANGE  <<<<<', 'LOCKED', '7'),
  146.     (28, 'flag_id', 'game core ID for ally flag id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  147.     (29, 'farm_id', 'game core ID for guild house id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  148.     (30, 'barrack_id', 'game core ID for guild barrack id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  149.     (31, 'hall_id', 'game core ID for guild hall id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  150.     (32, 'pig_id', 'game core ID for guild pig id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  151.     (33, 'guard_id', 'game core ID for guild guard id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  152.     (34, 'vendor1_id', 'game core ID for vendor1 id', 'set vendor1_id 49004', '6'),
  153.     (35, 'vendor2_id', 'game core ID for vendor2 id', 'set vendor2_id 49006', '6'),
  154.     (36, 'vendor3_id', 'game core ID for vendor3 id', 'set vendor3_id 49008', '6'),
  155.     (37, 'cannon_id', 'game core ID for cannon id', 'ADMIN', '6'),
  156.     (38, 'command_set', 'game core command for modifying custom commands   >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  157.     (39, 'lock', 'ADMIN command to lock an area from purchase.   >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  158.     (40, 'anarchy', 'game core setting allows same team invasions . 0 = off :: 1 = on', 'set anarchy 1', '6'),
  159.     (41, 'f_timer', 'no-tag-flag system  0 = off :: 1 = on', 'set f_timer 1', '6'),
  160.     (42, 's_timer', 'no-tag-flag-timer time in ms.', 'set s_timer 180000', '6'),
  161.     (43, 'guild_id', 'guild id', 'LOCKED', '7'),
  162.     (44, 'guild_invite', 'Guild Level Setting. Guild invite system 0 == off :: 1 == on // default on.', 'set guild_invite 1', '4'),
  163.     (45, 'loc', 'Word used to identify a guild location to support buy/sell.', 'set loc area', '4'),
  164.     (46, 'loc_cost', 'system setting how much x of currency is required to purchase a basic empty location.', 'set loc_cost 10', '6'),
  165.     (47, 'farm', 'Word used to identify a guild farm to support buy/sell.', 'set farm mudhole', '4'),
  166.     (48, 'farm_cost', 'system setting how much x of currency to buy 1 house', 'set house_cost 5', '6'),
  167.     (49, 'farm_L', 'system setting limit how many farms per location', 'set farm_L 1', '6'),
  168.     (50, 'barrack', 'Word used to identify a guild barrack to support buy/sell.', 'set barrack home', '4'),
  169.     (51, 'barrack_cost', 'system setting how much x of currency to buy 1 barrack', 'set barrack_cost 10', '6'),
  170.     (52, 'barrack_L', 'system setting limit how many barracks per farm', 'set barrack_L 1', '6'),
  171.     (53, 'hall', 'Word used to identify a guild hall to support buy/sell.', 'set hall tower', '4'),
  172.     (54, 'hall_cost', 'system setting how much x of currency to buy 1 hall', 'set hall_cost 100', '6'),
  173.     (55, 'hall_L', 'system setting limit how many halls per location', 'set hall_L 1', '6'),
  174.     (56, 'pig', 'Word used to identify a guild pig to support buy/sell.', 'set pig piggy', '4'),
  175.     (57, 'pig_cost', 'system setting how much x of currency to buy 1 guild pig.', 'set pig_cost 1', '6'),
  176.     (58, 'pig_L', 'system setting limit how may pigs per farm.', 'set pig_L 20', '6'),
  177.     (59, 'guard', 'Word used to identify a guild guard to support buy/sell.', 'set guard guard', '4'),
  178.     (60, 'guard_cost', 'system setting how much x of currency to buy 1 guard.', 'set guard_cost 1', '6'),
  179.     (61, 'guard_L', 'system setting limit how many guards per barrack.', 'set guard_L 10', '6'),
  180.     (62, 'vendor1', 'Word used to identify a guild vendor1 to support buy/sell.', 'set vendor1 buffer', '4'),
  181.     (63, 'vendor1_cost', 'system setting how much x of currency to buy vendor 1.', 'set vendor1_cost 30', '6'),
  182.     (64, 'vendor1_L', 'system setting limit how many buff vendors per location.', 'set vendor1_L 2', '6'),
  183.     (65, 'vendor2', 'Word used to identify a guild vendor2 to support buy/sell.', 'set vendor2 gearer', '4'),
  184.     (66, 'vendor2_cost', 'system setting how much x of currency to buy vendor 2.', 'set vendor2_cost 30', '6'),
  185.     (67, 'vendor2_L', 'system setting limit how many buff vendors per location.', 'set vendor2_L 2', '6'),
  186.     (68, 'vendor3', 'Word used to identify a guild vendor3 to support buy/sell.', 'set vendor3 fun', '4'),
  187.     (69, 'vendor3_cost', 'system setting how much x of currency to buy vendor 3.', 'set vendor3_cost 30', '6'),
  188.     (70, 'vendor3_L', 'system setting limit how many buff vendors per location.', 'set vendor3_L 2', '6'),
  189.     (71, 'vault', 'Word used to identify a guild vault to support buy/sell.', 'set vault gbank', '4'),
  190.     (72, 'vault_cost', 'system setting how much x of currency to buy a vault.', 'set vault_cost 100', '6'),
  191.     (73, 'vault_L', 'system setting limit how many vaults per location.', 'set vault_L 1', '6'),
  192.     (74, 'mailbox', 'Word used to identify a guild mailbox to support buy/sell.', 'set mailbox box', '4'),
  193.     (75, 'mailbox_cost', 'system setting how much x of currency to buy a mailbox.', 'set mailbox_cost 10', '6'),
  194.     (76, 'mailbox_L', 'system setting limit how many mailboxs per location.', 'set mailbox_L 1', '6'),
  195.     (77, 'color_1', 'command color GuildMaster Level', 'set color_1 cff000000', '4'),
  196.     (78, 'color_2', 'Setting Value color  GuildMaster Level', 'set color_2 cff000000', '4'),
  197.     (79, 'color_3', 'Info color  GuildMaster Level HEX CODE', 'set color_3 cff000000', '4'),
  198.     (80, 'color_4', 'Alliance color  GuildMaster Level HEX CODE', 'set color_4 cff000000', '4'),
  199.     (81, 'color_5', 'Horde color  GuildMaster Level HEX CODE', 'set color_5 cff000000', '4'),
  200.     (82, 'color_6', 'For Sale color  GuildMaster Level HEX CODE', 'set color_6 cff000000', '4'),
  201.     (83, 'color_7', 'LOCKED color  GuildMaster Level HEX CODE', 'set color_7 cff000000', '4'),
  202.     (84, 'color_8', 'Titles color  GuildMaster Level HEX CODE', 'set color_8 cff000000', '4'),
  203.     (85, 'color_9', 'Separator color  GuildMaster Level HEX CODE', 'set color_9 cff000000', '4'),
  204.     (86, 'color_10', 'Help Commands color  GuildMaster Level HEX CODE', 'set color_10 cff000000', '4'),
  205.     (87, 'color_11', 'Help Description color  GuildMaster Level HEX CODE', 'set color_11 cff000000', '4'),
  206.     (88, 'color_12', 'Set Error color  GuildMaster Level HEX CODE', 'set color_12 cff000000', '4'),
  207.     (89, 'color_13', 'Set Values color  GuildMaster Level HEX CODE', 'set color_13 cff000000', '4'),
  208.     (90, 'color_14', 'Good Announcements  color  GuildMaster Level HEX CODE', 'set color_14 cff000000', '4'),
  209.     (91, 'color_15', 'Bad Announcements  color  GuildMaster Level HEX CODE', 'set color_15 cff000000', '4'),
  210.     (92, 'reset barrack', 'allows GM of minimum rank to reset barrack count of a location to 0', 'LOCKED', '7'),
  211.     (93, 'reset hall', 'allows GM of minimum rank to reset hall count of a location to 0', 'LOCKED', '7'),
  212.     (94, 'reset pig', 'allows GM of minimum rank to reset pig countof a location to 0', 'LOCKED', '7'),
  213.     (95, 'reset guard', 'allows GM of minimum rank to reset guard count of a location to 0', 'LOCKED', '7'),
  214.     (96, 'reset vendor1', 'allows GM of minimum rank to reset vendor_1 count of a location to 0', 'LOCKED', '7'),
  215.     (97, 'reset vendor2', 'allows GM of minimum rank to reset vendor_2 count of a location to 0', 'LOCKED', '7'),
  216.     (98, 'reset vendor3', 'allows GM of minimum rank to reset vendor_3 count of a location to 0', 'LOCKED', '7'),
  217.     (99, 'reset cannon', 'allows GM of minimum rank to reset cannon count of a location to 0', 'LOCKED', '7'),
  218.     (100, 'reset vault', 'allows GM of minimum rank to reset vault count of a location to 0', 'LOCKED', '7'),
  219.     (101, 'reset mailbox', 'allows GM of minimum rank to reset mailbox count of a location to 0', 'LOCKED', '7'),
  220.     (102, 'lock', 'ADMIN command to lock an area from purchase.   >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  221.     (103, 'setup', 'fixed player command .', 'LOCKED', '7');
  222. /*!40000 ALTER TABLE `help` ENABLE KEYS */;
  223.  
  224. CREATE TABLE IF NOT EXISTS `zones` (
  225.   `entry` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  226.   `map_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  227.   `area_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  228.   `zone_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  229.   `guild_name` VARCHAR(50) NOT NULL DEFAULT 'SERVER',
  230.   `team` tinyint(1) UNSIGNED NOT NULL DEFAULT '2',
  231.   `x` FLOAT NOT NULL DEFAULT '0',
  232.   `y` FLOAT NOT NULL DEFAULT '0',
  233.   `z` FLOAT NOT NULL DEFAULT '0',
  234.   `farm_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  235.   `barrack_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  236.   `hall_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  237.   `pig_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  238.   `guard_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  239.   `vendor1_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  240.   `vendor2_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  241.   `vendor3_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  242.   `cannon_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  243.   `vault_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  244.   `mailbox_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  245.   `flag_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  246.   `fs_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'game time (in seconds) when the flag was spawned.',
  247.   `guild_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'guild id',
  248.   PRIMARY KEY (`entry`)
  249. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='version 1.76';
  250.  
  251. REPLACE INTO `zones` (`entry`, `map_id`, `area_id`, `zone_id`, `guild_name`, `team`, `x`, `y`, `z`, `farm_count`, `barrack_count`, `hall_count`, `pig_count`, `guard_count`, `vendor1_count`, `vendor2_count`, `vendor3_count`, `cannon_count`, `vault_count`, `mailbox_count`, `flag_id`, `fs_time`, `guild_id`) VALUES
  252.     (1, 0, 0, 0, 'SERVER', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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!