Drop Items Problems Solved!!!

Results 1 to 2 of 2
  1. #1
    Apprentice francosa is offline
    MemberRank
    Nov 2007 Join Date
    23Posts

    Drop Items Problems Solved!!!

    The problem is not the DB. The problem is the Ascent.
    If you get to run the NCDB 662 with ascent rev 2355 this problem is solved.

    The bad is that you all work to fix the NPC and trainers.

    To keep functioning properly to the NPC and Trainers, you must do the following:

    Update in you World DB

    1649world_banned_phrases
    2074world_creature_names_localized
    2074world_gameobject_names_localized
    2074world_itempages_localized
    2074world_items_localized
    2074world_npc_text_localized
    2074world_quests_localized
    2325_world_creature_names
    2368_world_worldmap_info

    and run this query in World DB:

    #<Weapon Master> should be a trainer
    UPDATE `creature_proto` SET `npcflags`='16' WHERE `entry`='11867';
    UPDATE `creature_spawns` SET `flags`='16' WHERE `entry`='11867';

    #Set UNIT_NPC_FLAG_TRAINER flag for ALL weapon masters
    UPDATE `creature_proto` SET `npcflags` = '16' WHERE `entry` in (select `entry` from `creature_names` where `subname` like '%weapon master%');


    And ready to engage other BUGS!!!

    Saludos - Greetings


  2. #2
    Valued Member tuntara is offline
    MemberRank
    Mar 2004 Join Date
    TimBukTuLocation
    148Posts

    Re: Drop Items Problems Solved!!!

    could u help me out with this one?

    im gettin
    Code:
    Sql query failed due to [Sort aborted], Query: [SELECT * FROM creatureloot ORDER BY entryid ASC]
    Sql query failed due to [Sort aborted], Query: [SELECT * FROM pickpocketingloot ORDER BY entryid ASC]
    if it cant be helped could u give me a name of some DB that works alright just for a temp? thx.



Advertisement