Starim

Thanks, that fixes it. I appears both of our queries to modify the npc_vendor table are doing the same thing, but I wasn't setting the vendor IDs in the creature_template table to zero. So out of curiosity, what exactly does the vendor ID control?

I ran into this problem myself and tried to fix it by modifying the vendors table. I noticed there weren't any entries for the demon trainers in the npc_vendors table, though they did have entries in the npc_vendors_template table. So I created entries in the npc_vendor table for the demon trainers and their grimoires using this query: INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) SELECT C.`entry`, I.`entry`, 0, 0, 0 FROM `creature_template` C, `item_template` I WHERE C.`subname`='Demon Trainer' AND I.`name` LIKE 'Grimoire%' -- exclude the grimoires that train player spells AND I.`name` NOT LIKE '%Doom%' AND I.`name` NOT LIKE '%Inferno%' AND I.`name` NOT LIKE '%Shadow Bolt%' AND I.`name` NOT LIKE '%Immolate%' AND I.`name` NOT LIKE '%Corruption%'; Unfortunately, now whenever anyone goes to buy from a demon trainer, when the store opens most visible NPCs immediately change appearance to wisps and when attempting to buy a book the "you are too far away" message appears. I reverted my changes, but I could use some guidance on how I can modify the database to fix these vendors. Or will it require a change in the server code to fix?

I'm attempting to build Mangos on Fedora and getting stuck. The cmake arguments I used were: -DPREFIX=/opt/mangos -DPCH=0 -DACE_USE_EXTERNAL=0 -DTBB_USE_EXTERNAL=0 -DDEBUG=0 Then I ran make, but compilation halted with this error: [ 1%] Performing configure step for 'ACE_Project' checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking target system type... x86_64-unknown-linux-gnu checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... configure: error: unsafe srcdir value: `/home/Starim/mangos/dep/ACE_wrappers' make[2]: *** [dep/ACE_wrappers/ACE_Project-prefix/src/ACE_Project-stamp/ACE_Project-configure] Error 1 make[1]: *** [dep/ACE_wrappers/CMakeFiles/ACE_Project.dir/all] Error 2 make: *** [all] Error 2