Vendors created using sql not showing all items. menu

User Tag List

Results 1 to 5 of 5
  1. #1
    harcourts's Avatar Member
    Reputation
    1
    Join Date
    Jul 2018
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Vendors created using sql not showing all items.

    I'm having an issue creating custom vendors through sql and I've spend some time trying to figure it out with no success, hoping someone can help:

    What I want:

    To be able to add items to custom vendors, like those provided by brotalnia in the elysium repack, through a db manager (I'm currently using dbeaver).

    What is wrong:

    I can add all my loot tables using INSERT INTO `npc_vendor`, however only 1 or 2 vendors display their items, then the rest of them only display 1 or 2 items or none at all. If I try and add items to the vendors in game after this issue, it says the item is already in the loot table (but it is not displayed in the in game loot menu).

    An example of what I'm trying:

    I copied my initial entry from creature_table from a random vendor, and changed some things like the entry, model id, ect. Generally the entries go 41000, 41001, 41002...
    INSERT INTO mangos.creature_template
    (entry, patch, KillCredit1, KillCredit2, modelid_1, modelid_2, modelid_3, modelid_4, name, subname, gossip_menu_id, minlevel, maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction_A, faction_H, npcflag, speed_walk, speed_run, `scale`, `rank`, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, `type`, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spells_template, PetSpellDataId, mingold, maxgold, AIName, MovementType, InhabitType, Civilian, RacialLeader, RegenHealth, equipment_id, trainer_id, vendor_id, MechanicImmuneMask, SchoolImmuneMask, flags_extra, ScriptName)
    VALUES (41001, 0, 0, 0, 3114, 0, 0, 0, 'Hunter', 'Set Vendor', 9360, 30, 30, 1605, 1605, 0, 0, 1200, 875, 875, 4, 1.24, 1.14286, 1.15, 0, 42, 53, 0, 122, 1, 2000, 2000, 1, 4608, 0, 0, 0, 0, 0, 0, 45.144, 62.073, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'EventAI', 0, 3, 0, 0, 1, 1887, 0, 0, 0, 0, 2, '');

    Then I'll input multiple item sets for each vendor like so(however in practice it generally has teir 1, 2 and 3 + pvp gear):

    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41000, 16820, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41000, 16821, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41001, 16822, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41001, 16823, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41002, 16824, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41002, 16825, 0, 0);
    INSERT INTO `npc_vendor`(`entry`, `item`, `maxcount`, `incrtime`) VALUES (41003, 16826, 0, 0);

    I've tried inserting less items into each vendor, but it doesnt change anything.

    Thanks for any help.

    Vendors created using sql not showing all items.
  2. #2
    brotalnia's Avatar Elite User
    Reputation
    497
    Join Date
    Apr 2009
    Posts
    473
    Thanks G/R
    26/300
    Trade Feedback
    0 (0%)
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)
    Select the npc in game and try adding items to it with the .npc additem command. Also check your Server.log for startup errors related to that. Maybe the npc you are adding items to doesn't have the vendor npc flag.

  3. #3
    harcourts's Avatar Member
    Reputation
    1
    Join Date
    Jul 2018
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for your reply, I had a look at what you were saying but still have no luck, I just deleted all my entries and decided to go with your vendors, and the same issue is happening.

    For example in this screenshot, I'm looking at your hunter set vendor, it only has 1 page of items, however I use a macro to add the other sets, and I'm told those items are already on the loot table. If I search for them on the loot table, they are there, but they still don't show in game.

    Imgur: The magic of the Internet <- as you can see there is only 1 page of items, however the db is showing 58 items. This is the same for all of your vendors and any vendors I create(well mine actually show less items).


    The part of the server log refering to vendors seems to have no errors:

    2018-07-22 15:29:44 Loading Vendors...
    2018-07-22 15:29:44
    2018-07-22 15:29:44 >> Loaded 339 vendor template items
    2018-07-22 15:29:44
    2018-07-22 15:29:44 >> Loaded 13805 vendor items

    If you have no ideas I might try deleting everything and re-downloading your pack.

  4. #4
    brotalnia's Avatar Elite User
    Reputation
    497
    Join Date
    Apr 2009
    Posts
    473
    Thanks G/R
    26/300
    Trade Feedback
    0 (0%)
    Mentioned
    14 Post(s)
    Tagged
    2 Thread(s)
    Items that have a reputation/class/race requirement that you don't fit are not shown by default. You need to turn on GM mode in order to see all items.

    .gm on

  5. #5
    harcourts's Avatar Member
    Reputation
    1
    Join Date
    Jul 2018
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Haha thanks, I can't believe it was that simple. Is there a way to change this setting? So that non-gms can see all available items?

Similar Threads

  1. [Question] Not showing all my pokemon?
    By 5o4KING in forum Pokemon GO Chat
    Replies: 0
    Last Post: 08-11-2016, 12:32 AM
  2. not showing all the menus in npc
    By edded in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 07-31-2009, 11:20 PM
  3. [Help!] SQL Error in all items from WoW Vendetta
    By webm0nst3r in forum World of Warcraft General
    Replies: 6
    Last Post: 01-03-2009, 07:35 PM
All times are GMT -5. The time now is 08:16 AM. 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