Results 1 to 1 of 1
  1. #1
    Contributor

    Reputation
    164
    Join Date
    Aug 2007
    Posts
    275
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    NCDB alchemy learning bug



    Donate to Remove Ads, Get ShoutBawx - Elite Forum Access
    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

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 12:40 PM. Powered by vBulletin® Version 4.2.0
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved. Resources saved on this page: MySQL 5.88%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search