Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- -- Host: 127.0.0.1
- -- Server Version: 10.1.10-MariaDB - mariadb.org binary distribution
- -- Server Betriebssystem: Win32
- -- HeidiSQL Version: 9.3.0.4984
- -- --------------------------------------------------------
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET NAMES utf8mb4 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- -- Exportiere Struktur von Tabelle hatstats.heroes
- CREATE TABLE IF NOT EXISTS `heroes` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `api_id` int(11) DEFAULT NULL,
- `name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
- `api_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
- `itemized` int(11) DEFAULT '0',
- `image` varchar(100) COLLATE utf8_bin DEFAULT NULL,
- `link_text` varchar(100) COLLATE utf8_bin DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- Exportiere Daten aus Tabelle hatstats.heroes: ~111 rows (ungefähr)
- DELETE FROM `heroes`;
- /*!40000 ALTER TABLE `heroes` DISABLE KEYS */;
- INSERT INTO `heroes` (`id`, `api_id`, `name`, `api_name`, `itemized`, `image`, `link_text`) VALUES
- (1, 1, 'Anti-Mage', 'npc_dota_hero_antimage', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/antimage_full.png', 'anti-mage'),
- (2, 2, 'Axe', 'npc_dota_hero_axe', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/axe_full.png', 'axe'),
- (3, 3, 'Bane', 'npc_dota_hero_bane', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/bane_full.png', 'bane'),
- (4, 4, 'Bloodseeker', 'npc_dota_hero_bloodseeker', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/bloodseeker_full.png', 'bloodseeker'),
- (5, 5, 'Crystal Maiden', 'npc_dota_hero_crystal_maiden', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/crystal_maiden_full.png', 'crystal-maiden'),
- (6, 6, 'Drow Ranger', 'npc_dota_hero_drow_ranger', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/drow_ranger_full.png', 'drow-ranger'),
- (7, 7, 'Earthshaker', 'npc_dota_hero_earthshaker', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/earthshaker_full.png', 'earthshaker'),
- (8, 8, 'Juggernaut', 'npc_dota_hero_juggernaut', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/juggernaut_full.png', 'juggernaut'),
- (9, 9, 'Mirana', 'npc_dota_hero_mirana', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/mirana_full.png', 'mirana'),
- (10, 11, 'Shadow Fiend', 'npc_dota_hero_nevermore', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/nevermore_full.png', 'shadow-fiend'),
- (11, 10, 'Morphling', 'npc_dota_hero_morphling', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/morphling_full.png', 'morphling'),
- (12, 12, 'Phantom Lancer', 'npc_dota_hero_phantom_lancer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/phantom_lancer_full.png', 'phantom-lancer'),
- (13, 13, 'Puck', 'npc_dota_hero_puck', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/puck_full.png', 'puck'),
- (14, 14, 'Pudge', 'npc_dota_hero_pudge', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/pudge_full.png', 'pudge'),
- (15, 15, 'Razor', 'npc_dota_hero_razor', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/razor_full.png', 'razor'),
- (16, 16, 'Sand King', 'npc_dota_hero_sand_king', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/sand_king_full.png', 'sand-king'),
- (17, 17, 'Storm Spirit', 'npc_dota_hero_storm_spirit', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/storm_spirit_full.png', 'storm-spirit'),
- (18, 18, 'Sven', 'npc_dota_hero_sven', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/sven_full.png', 'sven'),
- (19, 19, 'Tiny', 'npc_dota_hero_tiny', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/tiny_full.png', 'tiny'),
- (20, 20, 'Vengeful Spirit', 'npc_dota_hero_vengefulspirit', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/vengefulspirit_full.png', 'vengeful-spirit'),
- (21, 21, 'Windranger', 'npc_dota_hero_windrunner', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/windrunner_full.png', 'windranger'),
- (22, 22, 'Zeus', 'npc_dota_hero_zuus', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/zuus_full.png', 'zeus'),
- (23, 23, 'Kunkka', 'npc_dota_hero_kunkka', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/kunkka_full.png', 'kunkka'),
- (24, 25, 'Lina', 'npc_dota_hero_lina', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/lina_full.png', 'lina'),
- (25, 31, 'Lich', 'npc_dota_hero_lich', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/lich_full.png', 'lich'),
- (26, 26, 'Lion', 'npc_dota_hero_lion', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/lion_full.png', 'lion'),
- (27, 27, 'Shadow Shaman', 'npc_dota_hero_shadow_shaman', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/shadow_shaman_full.png', 'shadow-shaman'),
- (28, 28, 'Slardar', 'npc_dota_hero_slardar', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/slardar_full.png', 'slardar'),
- (29, 29, 'Tidehunter', 'npc_dota_hero_tidehunter', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/tidehunter_full.png', 'tidehunter'),
- (30, 30, 'Witch Doctor', 'npc_dota_hero_witch_doctor', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/witch_doctor_full.png', 'witch-doctor'),
- (31, 32, 'Riki', 'npc_dota_hero_riki', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/riki_full.png', 'riki'),
- (32, 33, 'Enigma', 'npc_dota_hero_enigma', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/enigma_full.png', 'enigma'),
- (33, 34, 'Tinker', 'npc_dota_hero_tinker', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/tinker_full.png', 'tinker'),
- (34, 35, 'Sniper', 'npc_dota_hero_sniper', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/sniper_full.png', 'sniper'),
- (35, 36, 'Necrophos', 'npc_dota_hero_necrolyte', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/necrolyte_full.png', 'necrophos'),
- (36, 37, 'Warlock', 'npc_dota_hero_warlock', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/warlock_full.png', 'warlock'),
- (37, 38, 'Beastmaster', 'npc_dota_hero_beastmaster', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/beastmaster_full.png', 'beastmaster'),
- (38, 39, 'Queen of Pain', 'npc_dota_hero_queenofpain', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/queenofpain_full.png', 'queen-of-pain'),
- (39, 40, 'Venomancer', 'npc_dota_hero_venomancer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/venomancer_full.png', 'venomancer'),
- (40, 41, 'Faceless Void', 'npc_dota_hero_faceless_void', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/faceless_void_full.png', 'faceless-void'),
- (41, 42, 'Wraith King', 'npc_dota_hero_skeleton_king', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/skeleton_king_full.png', 'wraith-king'),
- (42, 43, 'Death Prophet', 'npc_dota_hero_death_prophet', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/death_prophet_full.png', 'death-prophet'),
- (43, 44, 'Phantom Assassin', 'npc_dota_hero_phantom_assassin', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/phantom_assassin_full.png', 'phantom-assassin'),
- (44, 45, 'Pugna', 'npc_dota_hero_pugna', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/pugna_full.png', 'pugna'),
- (45, 46, 'Templar Assassin', 'npc_dota_hero_templar_assassin', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/templar_assassin_full.png', 'templar-assassin'),
- (46, 47, 'Viper', 'npc_dota_hero_viper', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/viper_full.png', 'viper'),
- (47, 48, 'Luna', 'npc_dota_hero_luna', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/luna_full.png', 'luna'),
- (48, 49, 'Dragon Knight', 'npc_dota_hero_dragon_knight', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/dragon_knight_full.png', 'dragon-knight'),
- (49, 50, 'Dazzle', 'npc_dota_hero_dazzle', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/dazzle_full.png', 'dazzle'),
- (50, 51, 'Clockwerk', 'npc_dota_hero_rattletrap', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/rattletrap_full.png', 'clockwerk'),
- (51, 52, 'Leshrac', 'npc_dota_hero_leshrac', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/leshrac_full.png', 'leshrac'),
- (52, 53, 'Nature\'s Prophet', 'npc_dota_hero_furion', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/furion_full.png', 'natures-prophet'),
- (53, 54, 'Lifestealer', 'npc_dota_hero_life_stealer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/life_stealer_full.png', 'lifestealer'),
- (54, 55, 'Dark Seer', 'npc_dota_hero_dark_seer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/dark_seer_full.png', 'dark-seer'),
- (55, 56, 'Clinkz', 'npc_dota_hero_clinkz', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/clinkz_full.png', 'clinkz'),
- (56, 57, 'Omniknight', 'npc_dota_hero_omniknight', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/omniknight_full.png', 'omniknight'),
- (57, 58, 'Enchantress', 'npc_dota_hero_enchantress', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/enchantress_full.png', 'enchantress'),
- (58, 59, 'Huskar', 'npc_dota_hero_huskar', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/huskar_full.png', 'huskar'),
- (59, 60, 'Night Stalker', 'npc_dota_hero_night_stalker', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/night_stalker_full.png', 'night-stalker'),
- (60, 61, 'Broodmother', 'npc_dota_hero_broodmother', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/broodmother_full.png', 'broodmother'),
- (61, 62, 'Bounty Hunter', 'npc_dota_hero_bounty_hunter', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/bounty_hunter_full.png', 'bounty-hunter'),
- (62, 63, 'Weaver', 'npc_dota_hero_weaver', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/weaver_full.png', 'weaver'),
- (63, 64, 'Jakiro', 'npc_dota_hero_jakiro', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/jakiro_full.png', 'jakiro'),
- (64, 65, 'Batrider', 'npc_dota_hero_batrider', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/batrider_full.png', 'batrider'),
- (65, 66, 'Chen', 'npc_dota_hero_chen', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/chen_full.png', 'chen'),
- (66, 67, 'Spectre', 'npc_dota_hero_spectre', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/spectre_full.png', 'spectre'),
- (67, 69, 'Doom', 'npc_dota_hero_doom_bringer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/doom_bringer_full.png', 'doom'),
- (68, 68, 'Ancient Apparition', 'npc_dota_hero_ancient_apparition', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/ancient_apparition_full.png', 'ancient-apparition'),
- (69, 70, 'Ursa', 'npc_dota_hero_ursa', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/ursa_full.png', 'ursa'),
- (70, 71, 'Spirit Breaker', 'npc_dota_hero_spirit_breaker', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/spirit_breaker_full.png', 'spirit-breaker'),
- (71, 72, 'Gyrocopter', 'npc_dota_hero_gyrocopter', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/gyrocopter_full.png', 'gyrocopter'),
- (72, 73, 'Alchemist', 'npc_dota_hero_alchemist', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/alchemist_full.png', 'alchemist'),
- (73, 74, 'Invoker', 'npc_dota_hero_invoker', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/invoker_full.png', 'invoker'),
- (74, 75, 'Silencer', 'npc_dota_hero_silencer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/silencer_full.png', 'silencer'),
- (75, 76, 'Outworld Devourer', 'npc_dota_hero_obsidian_destroyer', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/obsidian_destroyer_full.png', 'outworld-devourer'),
- (76, 77, 'Lycan', 'npc_dota_hero_lycan', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/lycan_full.png', 'lycan'),
- (77, 78, 'Brewmaster', 'npc_dota_hero_brewmaster', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/brewmaster_full.png', 'brewmaster'),
- (78, 79, 'Shadow Demon', 'npc_dota_hero_shadow_demon', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/shadow_demon_full.png', 'shadow-demon'),
- (79, 80, 'Lone Druid', 'npc_dota_hero_lone_druid', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/lone_druid_full.png', 'lone-druid'),
- (80, 81, 'Chaos Knight', 'npc_dota_hero_chaos_knight', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/chaos_knight_full.png', 'chaos-knight'),
- (81, 82, 'Meepo', 'npc_dota_hero_meepo', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/meepo_full.png', 'meepo'),
- (82, 83, 'Treant Protector', 'npc_dota_hero_treant', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/treant_full.png', 'treant-protector'),
- (83, 84, 'Ogre Magi', 'npc_dota_hero_ogre_magi', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/ogre_magi_full.png', 'ogre-magi'),
- (84, 85, 'Undying', 'npc_dota_hero_undying', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/undying_full.png', 'undying'),
- (85, 86, 'Rubick', 'npc_dota_hero_rubick', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/rubick_full.png', 'rubick'),
- (86, 87, 'Disruptor', 'npc_dota_hero_disruptor', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/disruptor_full.png', 'disruptor'),
- (87, 88, 'Nyx Assassin', 'npc_dota_hero_nyx_assassin', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/nyx_assassin_full.png', 'nyx-assassin'),
- (88, 89, 'Naga Siren', 'npc_dota_hero_naga_siren', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/naga_siren_full.png', 'naga-siren'),
- (89, 90, 'Keeper of the Light', 'npc_dota_hero_keeper_of_the_light', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/keeper_of_the_light_full.png', 'keeper-of-the-light'),
- (90, 91, 'Io', 'npc_dota_hero_wisp', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/wisp_full.png', 'io'),
- (91, 92, 'Visage', 'npc_dota_hero_visage', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/visage_full.png', 'visage'),
- (92, 93, 'Slark', 'npc_dota_hero_slark', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/slark_full.png', 'slark'),
- (93, 94, 'Medusa', 'npc_dota_hero_medusa', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/medusa_full.png', 'medusa'),
- (94, 95, 'Troll Warlord', 'npc_dota_hero_troll_warlord', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/troll_warlord_full.png', 'troll-warlord'),
- (95, 96, 'Centaur Warrunner', 'npc_dota_hero_centaur', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/centaur_full.png', 'centaur-warrunner'),
- (96, 97, 'Magnus', 'npc_dota_hero_magnataur', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/magnataur_full.png', 'magnus'),
- (97, 98, 'Timbersaw', 'npc_dota_hero_shredder', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/shredder_full.png', 'timbersaw'),
- (98, 99, 'Bristleback', 'npc_dota_hero_bristleback', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/bristleback_full.png', 'bristleback'),
- (99, 100, 'Tusk', 'npc_dota_hero_tusk', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/tusk_full.png', 'tusk'),
- (100, 101, 'Skywrath Mage', 'npc_dota_hero_skywrath_mage', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/skywrath_mage_full.png', 'skywrath-mage'),
- (101, 102, 'Abaddon', 'npc_dota_hero_abaddon', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/abaddon_full.png', 'abaddon'),
- (102, 103, 'Elder Titan', 'npc_dota_hero_elder_titan', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/elder_titan_full.png', 'elder-titan'),
- (103, 104, 'Legion Commander', 'npc_dota_hero_legion_commander', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/legion_commander_full.png', 'legion-commander'),
- (104, 106, 'Ember Spirit', 'npc_dota_hero_ember_spirit', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/ember_spirit_full.png', 'ember-spirit'),
- (105, 107, 'Earth Spirit', 'npc_dota_hero_earth_spirit', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/earth_spirit_full.png', 'earth-spirit'),
- (106, 109, 'Terrorblade', 'npc_dota_hero_terrorblade', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/terrorblade_full.png', 'terrorblade'),
- (107, 110, 'Phoenix', 'npc_dota_hero_phoenix', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/phoenix_full.png', 'phoenix'),
- (108, 111, 'Oracle', 'npc_dota_hero_oracle', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/oracle_full.png', 'oracle'),
- (109, 105, 'Techies', 'npc_dota_hero_techies', 1, 'http://cdn.dota2.com/apps/dota2/images/heroes/techies_full.png', 'techies'),
- (110, 112, 'Winter Wyvern', 'npc_dota_hero_winter_wyvern', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/winter_wyvern_full.png', 'winter-wyvern'),
- (111, 113, 'Arc Warden', 'npc_dota_hero_arc_warden', 0, 'http://cdn.dota2.com/apps/dota2/images/heroes/arc_warden_full.png', 'arc-warden');
- /*!40000 ALTER TABLE `heroes` ENABLE KEYS */;
- /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
- /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement