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

 

 
All times are GMT -5. The time now is 08:55 PM. Powered by vBulletin® Version 4.2.2
Copyright © 2016 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search