milestorme / cmangos_mall Goto Github PK

Some creatures in the mall have left-over linking from probably some now-deleted creatures, which means if you try to tame a pet, the vendors inside come running out to attack you etc.

Also GUIDs are allocated statically, if these GUIDs are already in use by other custom NPCs they can't be easily re-mapped.

I'm in favor of changing the static nature of the GUIDs here to a more dynamic one

SET @CGUID := 90000000;

INSERT INTO creature (guid, ...) VALUES 
(@CGUID+0, ...),
(@CGUID+1, ...),
.
.
.

for example

CREATE TABLE item_template_backup LIKE item_template;
/* SQL Error (1146): Table 'tbcrealmd.item_template' doesn't exist */