Vendor Fix!!!! verry easy! menu

These ads disappear when you log in.

Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    sadgonewild's Avatar Master Sergeant
    Reputation
    10
    Join Date
    Jun 2007
    Posts
    127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Vendor Fix!!!! verry easy!

    Go into sqljog\\\\Ascent db

    then exicute


    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 = 262145 WHERE npcflags = 1537;
    -- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
    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 = ??? WHERE npcflags = 64;
    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;


    problem solved.

    still looking for a guild master fix.

    but every thing else seems to work!

    These ads disappear when you log in.

  2. #2
    sadgonewild's Avatar Master Sergeant
    Reputation
    10
    Join Date
    Jun 2007
    Posts
    127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    srry for double post

    UPDATE creature_proto SET npcflags = 1048576 WHERE npcflags = 2048;


    that will fix your guild master problem

  3. #3
    Ebon's Avatar Contributor
    Reputation
    218
    Join Date
    Sep 2007
    Posts
    604
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Nice job dude, it worked, +Rep!

    Edit - Not sure if I gave you Repuation or not... it say's I can't give it to the same post twice... hmm... Sorry bud! !
    Last edited by Ebon; 11-18-2007 at 01:13 PM. Reason: Added some text...


  4. #4
    kristian92's Avatar Sergeant Major
    Reputation
    8
    Join Date
    Oct 2007
    Posts
    150
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    what does this update do?

  5. #5
    jkhmonkey's Avatar Private
    Reputation
    2
    Join Date
    Oct 2007
    Posts
    4
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    It lets you buy stuff from vendors using 2.3 repacks

  6. #6
    Herleybob's Avatar Contributor
    Reputation
    178
    Join Date
    Jul 2007
    Posts
    664
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    I have updated my repack to fix this stuff, just run the Program in the Databases folder and type "N" and it will fix the NPC's

    Nom Nom Nom :P

  7. #7
    sadgonewild's Avatar Master Sergeant
    Reputation
    10
    Join Date
    Jun 2007
    Posts
    127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Originally Posted by herleybob View Post
    I have updated my repack to fix this stuff, just run the Program in the Databases folder and type "N" and it will fix the NPC's
    good work mate,

    maybe that will stop me having to post this same thread every god dam page in ur guide

  8. #8
    matistic's Avatar Private
    Reputation
    1
    Join Date
    Nov 2007
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Well I've run the code and also tried the N option and while many vendors now work, not all do. I can't buy a horse mount, I can't get flight masters to let me go anywhere and I can't finish some quests because of the problems. Any ideas?

  9. #9
    Priscila's Avatar Private
    Reputation
    1
    Join Date
    Nov 2007
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Hello, I have MySQL instead of SQLyod, can you please tell me where I might excute these commands? thanks for thos rocking fix!

  10. #10
    Priscila's Avatar Private
    Reputation
    1
    Join Date
    Nov 2007
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    ANd also... once it's fixed...
    I am not really sure about how .npc vendoradditem works

    How do I designate the price for the item or maybe the requiement of pvp-points obained in order to get the item

    and under which catatory should I be modifying these things?

    Is it under "items" in the database?



    thanks!
    Last edited by Priscila; 11-24-2007 at 07:59 PM.

  11. #11
    sadgonewild's Avatar Master Sergeant
    Reputation
    10
    Join Date
    Jun 2007
    Posts
    127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Originally Posted by Priscila View Post
    Hello, I have MySQL instead of SQLyod, can you please tell me where I might excute these commands? thanks for thos rocking fix!

    open up SQLJog and log into it ect so u can see your databases. once you can see them you should be able to see the white box on the right hand side. copy and paste into that box and press control A then press F5 and its done.

  12. #12
    Durand44's Avatar Knight-Lieutenant
    Reputation
    31
    Join Date
    May 2007
    Posts
    226
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    thanks for that good jobe. i really needed

  13. #13
    Priscila's Avatar Private
    Reputation
    1
    Join Date
    Nov 2007
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    My T6 vendor still doesnt work, for the warriors T6 (Onslaughter's) works, but the rest of the gears for other classes don't.

    Thanks!

  14. #14
    sadgonewild's Avatar Master Sergeant
    Reputation
    10
    Join Date
    Jun 2007
    Posts
    127
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Originally Posted by Priscila View Post
    My T6 vendor still doesnt work, for the warriors T6 (Onslaughter's) works, but the rest of the gears for other classes don't.

    Thanks!

    how can you be able to buy one set from the vendor and not all?

    did u check u had tokens for all of them???

  15. #15
    Priscila's Avatar Private
    Reputation
    1
    Join Date
    Nov 2007
    Posts
    8
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    Re: Vendor Fix!!!! verry easy!

    Yes, I did check them all. It seems that all are working, but priest's set


    I have the token, but there is no image of token showing on the gears, meaning that I can't trade them ~
    Attached Thumbnails Attached Thumbnails Vendor Fix!!!! verry easy!-wowscrnshot_112707_173858-jpg  

Page 1 of 2 12 LastLast

Similar Threads

  1. [AC Web Repack 7.7] Token Vendor FIX
    By Tornad0z in forum WoW EMU Guides & Tutorials
    Replies: 12
    Last Post: 05-29-2008, 07:50 PM
  2. [fix] 2.4.1 trainer fix (made easy)
    By Krilio in forum World of Warcraft Emulator Servers
    Replies: 22
    Last Post: 04-22-2008, 02:55 AM
  3. No Mouse Icon over Custom Vendors? [Fix is here]
    By Illidan1 in forum World of Warcraft Emulator Servers
    Replies: 12
    Last Post: 03-30-2008, 07:02 AM
  4. Mount Vendor FIX -Advanced users
    By darkdanny in forum WoW EMU Guides & Tutorials
    Replies: 0
    Last Post: 12-13-2007, 02:05 PM
  5. Holloween Vendor (fix)
    By jokerjokes in forum World of Warcraft Emulator Servers
    Replies: 24
    Last Post: 10-31-2007, 10:32 PM
All times are GMT -5. The time now is 07:17 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2018 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search