Working Vendors in 2.3.0 menu

User Tag List

Results 1 to 4 of 4
  1. #1
    cylas's Avatar Member
    Reputation
    12
    Join Date
    Oct 2007
    Posts
    46
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Working Vendors in 2.3.0

    If your vendors aren't working in 2.3.0, simply save or execute this coding into your database. Its not a complex problem, but the npc flags were changed around and this fixes em. Hope this helps some of yall out there. Here are the stats of what our server is currently running:
    -=CoreWoW Server=-
    Core: Ascent 2.3 TRUNK r2340
    Database: NCDB 0.2.2 with the latest sql table and localization updates

    Code:
    UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
    UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
    UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
    UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
    UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
    UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
    UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
    UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
    UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
    UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
    UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
    UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
    UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
    UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
    UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
    UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
    UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
    UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
    UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
    UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
    UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
    UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
    UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
    UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
    UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
    UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
    UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
    UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
    UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
    UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
    UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
    UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
    UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
    UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
    UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
    UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
    UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;
    Last edited by cylas; 11-17-2007 at 01:44 AM. Reason: added core/db stats for viewers

    Working Vendors in 2.3.0
  2. #2
    Nilrac's Avatar Banned
    Reputation
    360
    Join Date
    Nov 2007
    Posts
    762
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Working Vendors in 2.3.0

    You make this?

  3. #3
    cylas's Avatar Member
    Reputation
    12
    Join Date
    Oct 2007
    Posts
    46
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Working Vendors in 2.3.0

    Yes and no. Found the new flags on another forum in a basic x = y setup.

    X = Old Flag
    Y = New Flag

    A friend from another server pointed me in the right direction and then it was just a matter of playing around with things. So did I figure out the new flags no. Did I have help, yes.

  4. #4
    diegooo1972's Avatar Member
    Reputation
    1
    Join Date
    Jan 2008
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    My vendor still won't work. possibly this are only few of the flags changed ?
    Last edited by diegooo1972; 01-14-2008 at 02:58 PM.

Similar Threads

  1. 2.4.3 WORKING vendors
    By Denelly in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 08-12-2008, 05:22 PM
  2. [Request] Working vendors for latest NCDB
    By vasko93 in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 12-31-2007, 01:24 PM
  3. [Release] 12/21/2007 Working Vendor's + Vendor's Items
    By ~SaiLyn~ in forum World of Warcraft Emulator Servers
    Replies: 31
    Last Post: 12-30-2007, 12:09 AM
  4. Working Vendors / Zul`Aman Items / Zul`Aman mounts!
    By Rouslan in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 11-27-2007, 01:14 AM
  5. Vendor wont work!
    By LJN in forum World of Warcraft Emulator Servers
    Replies: 7
    Last Post: 11-26-2007, 12:09 PM
All times are GMT -5. The time now is 10:30 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search