Results 1 to 1 of 1
  1. #1
    Contributor *TraPStaR*'s Avatar
    Reputation
    164
    Join Date
    Aug 2007
    Posts
    275
    Thanks (Given)
    0
    Thanks (Received)
    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

 

 

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 01:46 PM. Powered by vBulletin® Version 4.2.2
Copyright © 2016 vBulletin Solutions, Inc. All rights reserved. Feedback Buttons provided by Advanced Post Thanks / Like v3.3.2 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search