Results 1 to 1 of 1
  1. #1
    Contributor *TraPStaR*'s Avatar
    Reputation
    164
    Join Date
    Aug 2007
    Posts
    275
    Thanks G/R
    0/0
    CoreCoins
    0
    Trade Feedback
    0 (0%)

    NCDB alchemy learning bug

    my newest fix for the NCDB not deleting the old professions when you learn a new rank
    this one if for the Alchemy profession

    Code:
    update trainer_spells set deletespell = '2259' where cast_spell = '2280'; 
    update trainer_spells set deletespell = '3101' where cast_spell = '3465'; 
    update trainer_spells set deletespell = '3464' where cast_spell = '11612'; 
    update trainer_spells set deletespell = '11611' where cast_spell = '28597'

    medenus helped me link them so they can be ran as one .sql file or query and gave me the original file i modded to fix other professions

 

 

Similar Threads

  1. [Fix] Ncdb fast moving npc bug
    By 2dgreengiant in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 01-20-2008, 01:12 PM
  2. [bug] Skill trainers wont learn out skills
    By cutelyn in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 11-02-2007, 01:18 PM
  3. Wrath 5-piece set bug
    By Matt in forum World of Warcraft Exploits
    Replies: 1
    Last Post: 12-09-2006, 04:50 PM
  4. Broken Heart Bug
    By Matt in forum World of Warcraft Exploits
    Replies: 0
    Last Post: 02-18-2006, 01:11 AM
All times are GMT -5. The time now is 10:59 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2017 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search