API tools faq
paste
Advertisement
blackwolfsden

Eluna GW sql table

blackwolfsden
Jan 5th, 2014
215
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 14.85 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:             7.0.0.4053
  6. -- Date/time:                    2014-01-25 01:13:15
  7. -- --------------------------------------------------------
  8.  
  9. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40014 SET FOREIGN_KEY_CHECKS=0 */;
  12.  
  13. -- Dumping database structure for guild_warz
  14. DROP DATABASE IF EXISTS `guild_warz`;
  15. CREATE DATABASE IF NOT EXISTS `guild_warz` /*!40100 DEFAULT CHARACTER SET latin1 */;
  16. USE `guild_warz`;
  17.  
  18.  
  19. -- Dumping structure for table guild_warz.commands
  20. DROP TABLE IF EXISTS `commands`;
  21. CREATE TABLE IF NOT EXISTS `commands` (
  22.   `guild` varchar(50) NOT NULL DEFAULT '' COMMENT 'Do Not Touch',
  23.   `commands` varchar(10) NOT NULL DEFAULT 'commands',
  24.   `info_loc` varchar(10) NOT NULL DEFAULT 'info',
  25.   `list_loc` varchar(10) NOT NULL DEFAULT 'list',
  26.   `tele` varchar(6) NOT NULL DEFAULT 'gtele',
  27.   `version` varchar(15) NOT NULL DEFAULT 'ver',
  28.   `loc` varchar(15) NOT NULL DEFAULT 'area',
  29.   `farm` varchar(15) NOT NULL DEFAULT 'farm',
  30.   `barrack` varchar(15) NOT NULL DEFAULT 'barrack',
  31.   `hall` varchar(15) NOT NULL DEFAULT 'hall',
  32.   `pig` varchar(15) NOT NULL DEFAULT 'pig',
  33.   `guard` varchar(15) NOT NULL DEFAULT 'guard',
  34.   `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.',
  35.   `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.',
  36.   `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',
  37.   `details_loc` varchar(50) NOT NULL DEFAULT 'loc' COMMENT 'GM command gives more info about location.',
  38.   `table` varchar(50) NOT NULL DEFAULT 'table' COMMENT 'GM command reloads GW table.',
  39.   `GM_admin` tinyint(3) unsigned NOT NULL DEFAULT '5' COMMENT 'GM rank of server admin',
  40.   `GM_minimum` tinyint(1) unsigned NOT NULL DEFAULT '4' COMMENT 'Minimum Required Gm security level to use GM level commands.',
  41.   `currency` bigint(20) unsigned NOT NULL DEFAULT '62006' COMMENT 'item id for currency used.',
  42.   `loc_cost` smallint(5) unsigned NOT NULL DEFAULT '10' COMMENT 'price for basic empty zone.',
  43.   `farm_cost` smallint(5) unsigned NOT NULL DEFAULT '5' COMMENT 'price for small cheezy government issued house.',
  44.   `barrack_cost` smallint(5) unsigned NOT NULL DEFAULT '10' COMMENT 'price for small cheezy government issued house.',
  45.   `hall_cost` smallint(5) unsigned NOT NULL DEFAULT '100' COMMENT 'price for small cheezy government issued house.',
  46.   `pig_cost` smallint(5) NOT NULL DEFAULT '1' COMMENT 'price for one of these porkerz',
  47.   `guard_cost` smallint(5) NOT NULL DEFAULT '1' COMMENT 'how much is your back worth guarding?',
  48.   `farm_L` smallint(5) NOT NULL DEFAULT '1' COMMENT 'how many houses per location.',
  49.   `barrack_L` smallint(5) NOT NULL DEFAULT '1' COMMENT 'how many houses per location.',
  50.   `hall_L` smallint(5) NOT NULL DEFAULT '1' COMMENT 'how many houses per location.',
  51.   `pig_L` smallint(5) NOT NULL DEFAULT '20' COMMENT 'how many pigs per location.',
  52.   `guard_L` smallint(5) NOT NULL DEFAULT '10' COMMENT 'how many guards per location.',
  53.   `pig_payz` bigint(20) NOT NULL DEFAULT '100000' COMMENT 'amount in copper that each pig payz. hence "pig payz". default 100000 = 10g ',
  54.   `gift_count` tinyint(3) NOT NULL DEFAULT '25' COMMENT 'how many of currency item to give to guildmaster of newly created guild.',
  55.   `flag_require` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'does capturing a flag require killing all guards? default  == 0 no ; 1 == yes',
  56.   `Server` varchar(6) NOT NULL DEFAULT 'SERVER' COMMENT 'Do Not Touch',
  57.   `flag_id` mediumint(8) NOT NULL DEFAULT '187432' COMMENT 'Do Not Touch',
  58.   `farm_id` mediumint(8) NOT NULL DEFAULT '500000' COMMENT 'Do Not Touch',
  59.   `barrack_id` mediumint(8) NOT NULL DEFAULT '500002' COMMENT 'Do Not Touch',
  60.   `hall_id` mediumint(8) NOT NULL DEFAULT '500004' COMMENT 'Do Not Touch',
  61.   `pig_id` mediumint(8) NOT NULL DEFAULT '49000' COMMENT 'Do Not Touch',
  62.   `guard_id` mediumint(8) NOT NULL DEFAULT '49001' COMMENT 'Do Not Touch',
  63.   `walla_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  64.   `wallb_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  65.   `wallc_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  66.   `trainer1_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  67.   `trainer2_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  68.   `vendor1_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  69.   `vendor2_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  70.   `peon_id` mediumint(8) NOT NULL DEFAULT '111111' COMMENT 'Do Not Touch',
  71.   `command_set` varchar(50) NOT NULL DEFAULT 'set' COMMENT 'Do Not Touch ',
  72.   PRIMARY KEY (`guild`),
  73.   UNIQUE KEY `guild` (`guild`)
  74. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  75.  
  76. -- Dumping data for table guild_warz.commands: ~1 rows (approximately)
  77. DELETE FROM `commands`;
  78. /*!40000 ALTER TABLE `commands` DISABLE KEYS */;
  79. INSERT INTO `commands` (`guild`, `commands`, `info_loc`, `list_loc`, `tele`, `version`, `loc`, `farm`, `barrack`, `hall`, `pig`, `guard`, `GLD_lvlb`, `GLD_lvls`, `respawn_flag`, `details_loc`, `table`, `GM_admin`, `GM_minimum`, `currency`, `loc_cost`, `farm_cost`, `barrack_cost`, `hall_cost`, `pig_cost`, `guard_cost`, `farm_L`, `barrack_L`, `hall_L`, `pig_L`, `guard_L`, `pig_payz`, `gift_count`, `flag_require`, `Server`, `flag_id`, `farm_id`, `barrack_id`, `hall_id`, `pig_id`, `guard_id`, `walla_id`, `wallb_id`, `wallc_id`, `trainer1_id`, `trainer2_id`, `vendor1_id`, `vendor2_id`, `peon_id`, `command_set`) VALUES
  80.     ('SERVER', 'commands', 'info', 'list', 'gtele', 'ver', 'area', 'farm', 'barrack', 'hall', 'pig', 'guard', 0, 0, 'flag', 'loc', 'table', 5, 4, 62006, 10, 5, 10, 100, 1, 1, 1, 1, 1, 20, 10, 100000, 25, 0, 'SERVER', 187432, 500000, 500002, 500005, 49000, 49001, 111111, 111111, 111111, 111111, 111111, 111111, 111111, 111111, 'set');
  81. /*!40000 ALTER TABLE `commands` ENABLE KEYS */;
  82.  
  83.  
  84. -- Dumping structure for table guild_warz.help
  85. DROP TABLE IF EXISTS `help`;
  86. CREATE TABLE IF NOT EXISTS `help` (
  87.   `entry` bigint(20) unsigned DEFAULT NULL,
  88.   `name` varchar(50) DEFAULT NULL,
  89.   `description` varchar(1028) DEFAULT NULL,
  90.   `example` varchar(1028) DEFAULT NULL,
  91.   `command_level` varchar(1028) DEFAULT NULL,
  92.   UNIQUE KEY `entry` (`entry`)
  93. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  94.  
  95. -- Dumping data for table guild_warz.help: ~59 rows (approximately)
  96. DELETE FROM `help`;
  97. /*!40000 ALTER TABLE `help` DISABLE KEYS */;
  98. INSERT INTO `help` (`entry`, `name`, `description`, `example`, `command_level`) VALUES
  99.     (1, 'guild', 'Guild name for command entry . non-modifyable >>>>>DO NOT CHANGE<<<<<<', 'LOCKED', '7'),
  100.     (2, 'commands', 'produces a list of accessible commands by level.', 'set comm', '1'),
  101.     (3, 'info_loc', 'produces a basic description of current location.', 'set info_loc look', '1'),
  102.     (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'),
  103.     (5, 'tele', 'allows guild members to teleport to guild location flags using location id\'s.', 'set tele goto', '1'),
  104.     (6, 'version', 'allows player to view the system versions.', 'set version intelect', '1'),
  105.     (7, 'loc', 'allows guild members to purchase locations based on its value.', 'LOCKED', '4'),
  106.     (8, 'farm', 'allows guild members to purchase houses for guild locations.', 'LOCKED', '4'),
  107.     (9, 'barracks', 'allows guild members to purchasebarracks to produce guards for guild locations.', 'LOCKED', '4'),
  108.     (10, 'hall', 'allows guild members to purchase a guild hall for guild locations.', 'LOCKED', '4'),
  109.     (11, 'pig', 'allows guild members to purchase guild pigs for guild locations.', 'LOCKED', '4'),
  110.     (12, 'guard', 'allows guildmembers to purchase guards for locations', 'LOCKED', '4'),
  111.     (13, 'buy', 'allows guild member to buy.', 'LOCKED', '4'),
  112.     (14, 'sell', 'allows guild member to sell.', 'LOCKED', '4'),
  113.     (15, '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'),
  114.     (16, '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'),
  115.     (17, 'reset_loc', 'allows GM of minimum rank to reset a location onwner to "SERVER" and able to be purchased.', 'LOCKED', '5'),
  116.     (18, 'reset_farm', 'allows GM of minimum rank to reset house count of a location to 0', 'LOCKED', '5'),
  117.     (19, 'reset_barrack', 'allows GM of minimum rank to reset barrack count of a location to 0', 'LOCKED', '5'),
  118.     (20, 'reset_hall', 'allows GM of minimum rank to reset hall count of a location to 0', 'LOCKED', '5'),
  119.     (21, 'reset_pig', 'allows GM of minimum rank to reset pig countof a location to 0', 'LOCKED', '5'),
  120.     (22, 'reset_guard', 'allows GM of minimum rank to reset guard count of a location to 0', 'LOCKED', '5'),
  121.     (23, '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'),
  122.     (24, 'details_loc', 'allows a GM of minimum rank to list detailed information about current location.', 'set details_loc sniff', '5'),
  123.     (25, 'load_table', 'allows a GM of minimum rank to re-load all the guild warrz tables', 'set load_table re_think', '5'),
  124.     (26, 'GM_admin', 'system setting for GM rank of ADMIN acct.', 'set GM_admin 5', '6'),
  125.     (27, 'GM_minimum', 'system setting for GM required minimum rank to access GM commands.', 'set GM_minimum 3', '6'),
  126.     (28, 'currency', 'system setting>>CANNOT BE CHANGED<<', 'LOCKED', '7'),
  127.     (29, 'loc_cost', 'system setting how much x of currency is required to purchase a basic empty location.', 'set loc_cost 10', '6'),
  128.     (30, 'farm_cost', 'system setting how much x of currency to buy 1 house', 'set house_cost 5', '6'),
  129.     (31, 'barrack_cost', 'system setting how much x of currency to buy 1 barrack', 'set barrack_cost 10', '6'),
  130.     (32, 'hall_cost', 'system setting how much x of currency to buy 1 hall', 'set hall_cost 100', '6'),
  131.     (33, 'pig_cost', 'system setting how much x of currency to buy 1 guild pig.', 'set pig_cost 1', '6'),
  132.     (34, 'guard_cost', 'system setting how much x of currency to buy 1 guard.', 'set guard_cost 1', '6'),
  133.     (35, 'farm_L', 'system setting limit how many farms per location', 'set farm_L 1', '6'),
  134.     (36, 'barrack_L', 'system setting limit how many barracks per location', 'set barrack_L 1', '6'),
  135.     (37, 'hall_L', 'system setting limit how many halls per location', 'set hall_L 1', '6'),
  136.     (38, 'pig_L', 'system setting limit how may pigs per location.', 'set pig_L 20', '6'),
  137.     (39, 'guard_L', 'system setting limit how many guards per location.', 'set guard_L 10', '6'),
  138.     (40, 'pig_payz', 'system setting how much each pig payz in copper per half hour. 10g == 100000', 'set pig_payz 100000', '6'),
  139.     (41, 'gift_count', 'system setting how much currency to gift to newly created guilds.', 'set gift_count 25', '6'),
  140.     (42, 'flag_require', 'system setting switch does system require all guards dead to capture flag? default == 0 no; 1 == yes', 'set flag_require 1', '6'),
  141.     (43, 'Server', 'game core ID for guild ID storage of game master level commands  >>>>> DO NOT CHANGE  <<<<<', 'LOCKED', '7'),
  142.     (44, 'flag_id', 'game core ID for ally flag id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  143.     (45, 'farm_id', 'game core ID for guild house id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  144.     (46, 'barrack_id', 'game core ID for guild barrack id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  145.     (47, 'hall_id', 'game core ID for guild hall id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  146.     (48, 'pig_id', 'game core ID for guild pig id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  147.     (49, 'guard_id', 'game core ID for guild guard id >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  148.     (50, 'walla_id', 'game core ID for wall #a >>>>>>DO NOT CHANGE<<<<<<<<', 'LOCKED', '7'),
  149.     (51, 'wallb_id', 'game core ID for wall #b >>>>>>DO NOT CHANGE<<<<<<<<', 'LOCKED', '7'),
  150.     (52, 'wallc_id', 'game core ID for wall #c >>>>>>DO NOT CHANGE<<<<<<<<', 'LOCKED', '7'),
  151.     (53, 'barrack_id', 'game core ID for barracks ID >>>>>>DO NOT CHANGE<<<<<<<<', 'LOCKED', '7'),
  152.     (54, 'trainer1_id', 'game core ID for trainer npc id ', 'LOCKED', '7'),
  153.     (55, 'trainer2_id', 'game core ID for trainer npc id ', 'LOCKED', '7'),
  154.     (56, 'vendor1_id', 'game core ID for vendor npc id', 'LOCKED', '7'),
  155.     (57, 'vendor2_id', 'game core ID for vendor npc id', 'LOCKED', '7'),
  156.     (58, 'peon_id', 'game core ID for ally peon npc', 'LOCKED', '7'),
  157.     (59, 'command_set', 'game core command for modifying custom commands   >>>>>DO NOT CHANGE<<<<<', 'LOCKED', '7'),
  158.     (60, 'lock', 'ADMIN command to lock an area from purchase.', 'LOCKED', '6');
  159. /*!40000 ALTER TABLE `help` ENABLE KEYS */;
  160.  
  161.  
  162. -- Dumping structure for table guild_warz.zones
  163. DROP TABLE IF EXISTS `zones`;
  164. CREATE TABLE IF NOT EXISTS `zones` (
  165.   `entry` bigint(10) unsigned NOT NULL DEFAULT '0',
  166.   `map_id` bigint(10) unsigned NOT NULL DEFAULT '0',
  167.   `area_id` bigint(10) unsigned NOT NULL DEFAULT '0',
  168.   `zone_id` bigint(10) unsigned NOT NULL DEFAULT '0',
  169.   `guild_name` varchar(50) NOT NULL DEFAULT 'SERVER',
  170.   `team` smallint(10) unsigned NOT NULL DEFAULT '2',
  171.   `x` float NOT NULL DEFAULT '0',
  172.   `y` float NOT NULL DEFAULT '0',
  173.   `z` float NOT NULL DEFAULT '0',
  174.   `farm_count` tinyint(10) NOT NULL DEFAULT '0',
  175.   `barrack_count` tinyint(10) NOT NULL DEFAULT '0',
  176.   `hall_count` tinyint(10) NOT NULL DEFAULT '0',
  177.   `pig_count` tinyint(10) NOT NULL DEFAULT '0',
  178.   `guard_count` tinyint(10) NOT NULL DEFAULT '0',
  179.   `wall_count` tinyint(10) NOT NULL DEFAULT '0',
  180.   `trainer_count` tinyint(10) NOT NULL DEFAULT '0',
  181.   `npc_count` tinyint(10) NOT NULL DEFAULT '0',
  182.   `peon_count` tinyint(10) NOT NULL DEFAULT '0',
  183.   `flag_id` bigint(20) NOT NULL DEFAULT '0',
  184.   PRIMARY KEY (`entry`),
  185.   UNIQUE KEY `entry` (`entry`)
  186. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  187.  
  188. -- Dumping data for table guild_warz.zones: ~1 rows (approximately)
  189. DELETE FROM `zones`;
  190. /*!40000 ALTER TABLE `zones` DISABLE KEYS */;
  191. INSERT 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`, `wall_count`, `trainer_count`, `npc_count`, `peon_count`, `flag_id`) VALUES
  192.     (1, 0, 0, 0, 'SERVER', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  193. /*!40000 ALTER TABLE `zones` ENABLE KEYS */;
  194. /*!40014 SET FOREIGN_KEY_CHECKS=1 */;
  195. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
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!