Vendor BuG menu

Shout-Out

User Tag List

Thread: Vendor BuG

Results 1 to 15 of 15
  1. #1
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Vendor BuG

    Hy dear mmowners!

    I have a bug with my vendors!

    If i buy something after that i returnto fierst page...so i need go back to buy any item then back to fierst......whats wrong?

    Any idea how to fiX it? :wave:

    OFC +Rep

    Vendor BuG
  2. #2
    Vision1000's Avatar Member
    Reputation
    104
    Join Date
    Jun 2008
    Posts
    122
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your using Arcemu?

    Happens on my server too, not anything gamebreaking though. You could fix it yourself or you can just wait until arcemu fixes it. To fix it yourself you'd need to know C++

  3. #3
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nop.. i remember one mmowner give me a sql code where fix that buG!

  4. #4
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Put amount as 1, max amount as -1 and inctime as 0. Should work now after reloading vendors and respawning the npc, or restart the server.

  5. #5
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by stoneharry View Post
    Put amount as 1, max amount as -1 and inctime as 0. Should work now after reloading vendors and respawning the npc, or restart the server.
    stoneharry - can u give me please a correct sql code for that?

    Tnx a lot :wave:

  6. #6
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`, `extended_cost`) values('npc id','item id','1','-1','0','0');

    Change bits in red and then execute, in code box:

    Code:
    insert into `vendors` (`entry`, `item`, `amount`, `max_amount`, `inctime`, `extended_cost`) values('npc id','item id','1','-1','0','0');

  7. #7
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmmm 1 row affected 2 warnings...Damnnn something wrong in this code man...

  8. #8
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ouu damn u think i need manually put all bugeg vendors ID and they items ID?

  9. #9
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    npc id','item id

    Did you change these in the code?
    If so what is the error?
    Duplicate entry = Already in there, change from insert into to replace into.
    Incorect syntax means your not using ArcEmu.
    Good luck!

  10. #10
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I Have latest Arcemu Core....be shure!

    Whai i need change there npc id and item id? what i need put there? Vendor ID and item ID?

    Mybe someone know where is the problem and can give to me a corect sql code who fiX all vendors if they be buged.. ! I remember - that code are! They look like this but they work perfect for me!

  11. #11
    Reflection's Avatar Legendary
    Reputation
    783
    Join Date
    Mar 2008
    Posts
    3,377
    Thanks G/R
    1/2
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Stoneharry, that query would just fix the vendors he adds after. He can use this syntax instead: (might get syntax errors because I can't remember it from the top of my head.)

    Code:
    UPDATE `vendors` SET `amount` ='1';
    UPDATE `vendors` SET `max_amount` ='-1';
    UPDATE `vendors` SET `inctime` ='0';

    Freelance Digital Artist
    https://reflectionartwork.deviantart.com
    You did not desert me
    My brothers in arms


  12. #12
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Aye that would work, I thought he ment to insert new items.

  13. #13
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ohh guy's sorry for my english i am from Baltic states......


    Tnx to all who help and enjoY!

    Get +rep from me!

  14. #14
    Baxterzz's Avatar Member
    Reputation
    4
    Join Date
    Oct 2008
    Posts
    25
    Thanks G/R
    0/0
    Trade Feedback
    1 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is it the right one for the revision

  15. #15
    Royalaty's Avatar Member
    Reputation
    2
    Join Date
    Feb 2008
    Posts
    298
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hmm not work for me on NCDB 100 Rev 2713

Similar Threads

  1. WoWbeez vendor bug! earn gold!
    By coth in forum WoW EMU Exploits & Bugs
    Replies: 7
    Last Post: 05-01-2010, 02:45 AM
  2. Vendor bug
    By Royalaty in forum WoW EMU Questions & Requests
    Replies: 1
    Last Post: 07-01-2009, 06:02 PM
  3. vendor bug?
    By xSUPERSTEVEx in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 08-05-2008, 06:20 AM
All times are GMT -5. The time now is 09:15 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search