Closed calyxes closed 1 year ago
[SQL] Query world start [ERR] 1061 - Duplicate key name 'idx_gameobject_loot_template_item' [ERR] -- delete original GOSSIP_MENU_BOT delete FROM gossip_menu_option where option_id = 99;
DROP TABLE IF EXISTS ai_playerbot_rpg_races;
ai_playerbot_rpg_races
CREATE TABLE ai_playerbot_rpg_races ( id bigint(20) NOT NULL AUTO_INCREMENT, entry bigint(20), race bigint(20), minl bigint(20), maxl bigint(20), PRIMARY KEY (id), KEY entry (entry) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
id
entry
race
minl
maxl
DELETE FROM ai_playerbot_rpg_races;
-- say
-- Innkeeper Thulfram, Hinterlands, Dwarven Outpost (NULL, 7744, 3, 40, 50), -- dwarves (NULL, 7744 [SQL] Finished with error
[SQL] Query world start [ERR] 1061 - Duplicate key name 'idx_gameobject_loot_template_item' [ERR] -- delete original GOSSIP_MENU_BOT delete FROM gossip_menu_option where option_id = 99;
DROP TABLE IF EXISTS
ai_playerbot_rpg_races
;CREATE TABLE
ai_playerbot_rpg_races
(id
bigint(20) NOT NULL AUTO_INCREMENT,entry
bigint(20),race
bigint(20),minl
bigint(20),maxl
bigint(20), PRIMARY KEY (id
), KEYentry
(entry
) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;DELETE FROM
ai_playerbot_rpg_races
;-- say
INSERT INTO
ai_playerbot_rpg_races
VALUES-- DRAENEI
-- Draenei Azumeryst Isle (NULL, 16553, 11, 1, 10), -- Draenei Bloodmyst Isle (NULL, 17553, 11, 10, 20),
-- HUMANS
-- Innkeeper Farley, Goldshire (NULL, 295, 1, 1, 10), -- Innkeeper Heather, Westfall (NULL, 8931, 1, 10, 20),
-- DWARVES & GNOMES
-- Innkeeper Belm, Kharanos (NULL, 1247, 3, 1, 10), (NULL, 1247, 7, 1, 10), -- Innkeeper Hearthstove, Loch Modan (NULL, 6734, 3, 10, 20), (NULL, 6734, 7, 10, 20),
-- NIGHT ELVES
-- Innkeeper Keldamyr, Dolanaar (NULL, 6736, 4, 1, 10), -- Innkeeper Shaussiy, Auberdine (NULL, 6737, 4, 10, 20),
-- ALLIANCE CITIES
-- Innkeeper Saelienne, Darnassus (NULL, 6735, 4, 10, 80), -- elves
-- Innkeeper Firebrew, Ironforge (NULL, 5111, 3, 10, 80), -- dwarves (NULL, 5111, 7, 10, 80), -- gnomes (NULL, 5111, 4, 10, 80), -- elves (NULL, 5111, 1, 10, 80), -- human (NULL, 5111, 11, 20, 80), -- draenei
-- Innkeeper Allison, Stormwind (NULL, 6740, 1, 10, 80), -- human (NULL, 6740, 3, 10, 80), -- dwarves (NULL, 6740, 4, 10, 80), -- elves (NULL, 6740, 7, 10, 80), -- gnomes (NULL, 6740, 11, 20, 80), -- draenei
-- Caregiver Breel Exodar (NULL, 16739, 11, 10, 80), -- draenei (NULL, 16739, 1, 60, 80), -- human (NULL, 16739, 3, 60, 80), -- dwarves (NULL, 16739, 4, 60, 80), -- elves (NULL, 16739, 7, 60, 80), -- gnomes
-- ALLIANCE CONTESTED LOCATIONS
-- Innkeeper Kimlya, Astranaar
(NULL, 6738, 4, 15, 30), -- elves (NULL, 6738, 11, 20, 30), -- draenei
-- Innkeeper Faralia, Stonetalon Peak
(NULL, 16458, 4, 15, 27), -- elves
-- Innkeeper Lyshaerya, Desolase
(NULL, 11103, 4, 30, 40), -- elves
-- Innkeeper Shyria, Feathermoon, Feralas (NULL, 7736, 4, 40, 50), -- elves
-- Falfindel Waywarder, Feralas elf camp (NULL, 4048, 4, 40, 50), -- elves
-- Innkeeper Helbrek, Wetlands
(NULL, 1464, 3, 20, 30), -- dwarves (NULL, 1464, 7, 20, 30), -- gnomes
-- Innkeeper Trelayne, Duskwood
(NULL, 6790, 1, 18, 30), -- human (NULL, 6790, 3, 18, 30), -- dwarves (NULL, 6790, 7, 18, 30), -- gnomes (NULL, 6790, 11, 20, 30), -- draenei
-- Innkeeper Brianna, Redridge Mountains
(NULL, 6727, 1, 15, 25), -- human
-- Innkeeper Anderson, Southshore, Hillsbrad (NULL, 2352, 1, 20, 30), -- human (NULL, 2352, 3, 20, 30), -- dwarves (NULL, 2352, 7, 20, 30), -- gnomes (NULL, 2352, 11, 20, 30), -- draenei
-- Captain Nials, Refuge Pointe, Arathi (NULL, 2700, 1, 30, 40), -- human (NULL, 2700, 3, 30, 40), -- dwarves (NULL, 2700, 7, 30, 40), -- gnomes (NULL, 2700, 4, 30, 40), -- elves (NULL, 2700, 11, 30, 40), -- draenei
-- Lt. Doren, Stranglethorn Vale (NULL, 469, 1, 30, 45), -- human (NULL, 469, 3, 30, 45), -- dwarves (NULL, 469, 4, 30, 45), -- elves (NULL, 469, 7, 30, 45), -- gnomes (NULL, 469, 11, 30, 45), -- draenei
-- Innkeeper Janene, Theramore (NULL, 6272, 1, 35, 45), -- human (NULL, 6272, 3, 35, 45), -- dwarves (NULL, 6272, 7, 35, 45), -- gnomes (NULL, 6272, 11, 35, 45), -- draenei
-- Innkeeper Prospector Ryedol, Badlands Q-giver (NULL, 2910, 3, 35, 45), -- dwarves (NULL, 2910, 7, 35, 45), -- gnomes
-- Innkeeper Thulfram, Hinterlands, Dwarven Outpost (NULL, 7744, 3, 40, 50), -- dwarves (NULL, 7744 [SQL] Finished with error