[RELEASE] Full GMI Vendor Mall v4.0

[zeal_aiz]

HOT RELEASE!!!
Do you want make funserver but doesn't have mall vendor? Now no need to worry life more easier with latest and up-to-date mall vendor available here!

Full GMI Mall Vendor v4.0 (Release 23 Dec 2008)
- Compatibility with ArcEmu rev 1913 or latest. Now also support AspireCore HS branch rev 670 or latest:D!!
- Easy to install include Readme
- Add install and remove feature
- Can be execute many time
- Thousand of cleanup
- Thousand of addition
- Thousand of fix and editing
- Clean sql base make it easier for editing and adding item in future
- WotLK items thx to PaikProductions
- Contain 94 mall vendor which sell 8000+ TBC & WOTLK items
- Mall Vendor List:
ID NPC Vendor
50000 Armor:Dungeon I -TBC-
50001 Armor:Dungeon II -TBC-
50002 Armor:Dungeon III -TBC-
50003 Armor:Raid Tier I -TBC-
50004 Armor:Raid Tier II -TBC-
50005 Armor:Raid Tier III -TBC-
50006 Armor:Raid Tier IV -TBC-
50007 Armor:Raid Tier V -TBC-
50008 Armor:Raid Tier VI -TBC-
50009 Armor:Raid Tier VII -WOTLK-
50010 Armor:Raid Tier VII -WOTLK-
50011 Armor:Wrist -TBC- -WOTLK-
50012 Armor:Necklace -TBC- -WOTLK-
50013 Armor:Rings -TBC- -WOTLK-
50014 Armor:Trinket -TBC- -WOTLK-
50015 Armor:Cloak -TBC- -WOTLK-
50016 Armor:Shirt -TBC- -WOTLK-
50017 Armor:Tabard -TBC- -WOTLK-
50018 Armor:Miscellaneous -TBC- -WOTLK-
50019 Armor:Off-Hands/Relic -TBC- -WOTLK-
50020 Armor:Libram/Idol/Totem -TBC-
50021 Armor:Waist -TBC- -WOTLK-
50022 Armor:Feet -TBC- -WOTLK-
50023 Armor:Shield -TBC- -WOTLK-
50024 Weapon:Level 50+ -TBC-
50025 Weapon:Level 60+ -TBC-
50026 Weapon:Level 65+ -TBC-
50027 Weapon:Level 75+ -TBC-
50028 Weapon:Level 100+ -TBC-
50029 Weapon:Level 200+ -WOTLK-
50030 Arena:Season I -TBC-
50031 Arena:Season I -TBC-
50032 Arena:Season I -TBC-
50033 Arena:Season II -TBC-
50034 Arena:Season II -TBC-
50035 Arena:Season II -TBC-
50036 Arena:Season III -TBC-
50037 Arena:Season III -TBC-
50038 Arena:Season III -TBC-
50039 Arena:Season IV -TBC-
50040 Arena:Season IV -TBC-
50041 Arena:Season V -WOTLK-
50042 Gem:Red Gemstone -TBC-
50043 Gem:Blue Gemstone -TBC-
50044 Gem:Yellow Gemstone -TBC-
50045 Gem:Purple Gemstone -TBC-
50046 Gem:Green Gemstone -TBC-
50047 Gem:Orange Gemstone -TBC-
50048 Gem:Meta/Prismatic Gemstone -TBC-
50049 Gem:Simple Gemstone -TBC-
50050 Recipe:Book A-Z -TBC- -WOTLK-
50051 Recipe:Leather A-F -TBC- -WOTLK-
50052 Recipe:Leather G-R -TBC- -WOTLK-
50053 Recipe:Leather S-Z -TBC- -WOTLK-
50054 Recipe:Tailor A-G -TBC- -WOTLK-
50055 Recipe:Tailor H-Z -TBC- -WOTLK-
50056 Recipe:Engineer A-Z -TBC- -WOTLK-
50057 Recipe:Blacksmith A-F -TBC- -WOTLK-
50058 Recipe:Blacksmith G-R -TBC- -WOTLK-
50059 Recipe:Blacksmith S-Z -TBC- -WOTLK-
50060 Recipe:Cooking A-Z -TBC- -WOTLK-
50061 Recipe:Alchemy A-Z -TBC- -WOTLK-
50062 Recipe:Enchant A-G -TBC- -WOTLK-
50063 Recipe:Enchant H-Z -TBC- -WOTLK-
50064 Recipe:Jeweler A-K -TBC- -WOTLK-
50065 Recipe:Jeweler L-Z -TBC- -WOTLK-
50066 Reagent:Leather I -TBC- -WOTLK-
50067 Reagent:Leather II -TBC- -WOTLK-
50068 Reagent:Tailor I -TBC- -WOTLK-
50069 Reagent:Tailor II -TBC- -WOTLK-
50070 Reagent:Engineer I -TBC- -WOTLK-
50071 Reagent:Engineer II -TBC- -WOTLK-
50072 Reagent:Blacksmith I -TBC- -WOTLK-
50073 Reagent:Blacksmith II -TBC- -WOTLK-
50074 Reagent:Cooking -TBC- -WOTLK-
50075 Reagent:Alchemy -TBC- -WOTLK-
50076 Reagent:Enchant -TBC- -WOTLK-
50077 Reagent:Jeweler -TBC- -WOTLK-
50078 Reagent:Inscription/Miscellaneous -TBC- -WOTLK-
50079 Misc:Potion/Flask/Elixir -TBC-
50080 Misc:Scrolls -TBC-
50081 Misc:Books/Tomes/Codex -TBC-
50082 Misc:Projectile/Quiver -TBC- -WOTLK-
50083 Misc:Container -TBC- -WOTLK-
50084 Misc:Enchantment -TBC- -WOTLK-
50085 Misc:Key -TBC-
50086 Misc:Currency -TBC-
50087 Misc:Mount I -TBC-
50088 Misc:Mount II -TBC-
50089 Misc:Mount III -TBC-
50090 Misc:Glyph I -WOTLK-
50091 Misc:Glyph II -WOTLK-
50092 Misc:Heirloom -WOTLK-
50093 Misc:General Goods -WOTLK-
50094 Misc:Custom -TBC- -WOTLK-


Here Download Link
Full GMI Mall Vendor v4.0 ArcEmu - HERE (http://filebeam.com/34f4b213dfb888e798a7144599c2235d)
Full GMI Mall Vendor v4.0 AspireCore - HERE (http://filebeam.com/0f06443ea8fabb49d5f92c6ec21afaea)
PASSWORD:zeal

I'll update this vendor time to time!! Hope u all like it:D
I already test it with NCDB rev46. It should work flawless. If any prob occure let me know.
Repack maker feel free to use this mall vendor but don't forget mention credit:P
Please keep reply on this post, keep this post bump for easier for me to update in future;) U can post suggestion, adding item, missing item, bug etc

More to come!!
GMI Mall Vendor Spawn v4.0
- Support ArcEmu and AspireCore latest revision
- I'll make sql query for spawning Full GMI Mall Vendor v4.0 and Full Global Trainer v4.0 at location you want!
- Atm i will spawn this at GM Island. Suggestion here in this thread for another location.
- Make this mall vendor and trainer fully spawn neatly.
- Add enable and disable spawn feature
- Progress: Not started yet gonna rest a while;)

Full Global Trainer v4.0
- DONE!! Full Global Trainer v4.0 (http://www.ac-web.org/forum/releases/42265-release-full-global-trainer-v4-0-a.html)


CREDIT
- Hercules, soul02 for helping me 3 month ago to create Full GMI Mall Vendor v1.0-v3.0:)
GMI Mall Vendor v1.0-v3.0 (http://www.ac-web.org/forum/releases/33298-release-gm-island-full-spawn-vendor-trainer-etc.html)
- PaikProductions for provide WotLK ites which i put into my vendor;)
- Me, zeal_aiz for creating, fixing, cleaning, adding, merging and most importantly make your life easier:p I hope

[Gnome]

Looks good. +Rep

Hmm... i have the latest ArcEmu Database but still i get Errors... with the First INSERT INTO Query

nvm got it, you forgot ; in

DELETE FROM creature_names WHERE entry BETWEEN 50000 AND 50094;
DELETE FROM creature_proto WHERE entry BETWEEN 50000 AND 50094;
DELETE FROM vendors WHERE entry BETWEEN 50000 AND 50094

[zeal_aiz]

Looks good. +Rep

Hmm... i have the latest ArcEmu Database but still i get Errors... with the First INSERT INTO Query

nvm got it, you forgot ; in

DELETE FROM creature_names WHERE entry BETWEEN 50000 AND 50094;
DELETE FROM creature_proto WHERE entry BETWEEN 50000 AND 50094;
DELETE FROM vendors WHERE entry BETWEEN 50000 AND 50094

Thx really glad u like it:D Already double check this. My sql seem fine and i can execute it as many as i want. Perhaps i need to upload it again or maybe u accidentially delete it:p

BTW I already add AspireCore support and already test it with NCDB rev46 for AspireCore feel free to try it;) Gonna upload ArcEmu support 1 more time.

EDIT: Done!! Now it support both ArcEmu and AspireCore. Perhaps later gonna make it support MANGoS. Also please suggest good place to spawn all this vendor.

[cruiser101]

Awesome. +rep

[PaikProductions]

great work mate, good job!

[nickp2011]

hey let me know when u get them vendors.

[tekkeryole]

O.o now this I think I might like :P mind if I use in world x v 1.6 maybe?

[zeal_aiz]

Awesome. +rep

Thx dude;)

great work mate, good job!

Thx to u too!

hey let me know when u get them vendors.

This already ready to be vendor all u need to do is spawn it. I'll pm u later after i spawn it at GM Island.

My gosh... There lot to do but right now busy make X-mas prep...
Happy X-Mas!!!! to all AC Web community.

O.o now this I think I might like :P mind if I use in world x v 1.6 maybe?

As I said earlier, Repack Maker feel free to use this;) Yeah sure use this since this the only one vendor support AspireCore!! Already test it with NCDB rev46 AspireCore then it should work on your repack too:D

[nickp2011]

HAPPY XMAS TO U TO i accualy meant them trainers.. and yea the gm island would also be cool :) I need a good trainer list.. or even the global melee and caster trainer~ btw excellent job.

[DeViLzzz2008]

omg this is awesome ... look forward to using this but still need to sort out getting trainers into the game for class and for profs

[Raistlin77]

Cool stuff. I'm sure I'll find it all very useful indeed.

[PaikProductions]

Zeal_aiz, if you need some help with anything just send me a PM :)!

[zeal_aiz]

HAPPY XMAS TO U TO i accualy meant them trainers.. and yea the gm island would also be cool :) I need a good trainer list.. or even the global melee and caster trainer~ btw excellent job.

Thx glad u like it.:D I'm working on Global Trainer right now

omg this is awesome ... look forward to using this but still need to sort out getting trainers into the game for class and for profs

Working on it:P

Cool stuff. I'm sure I'll find it all very useful indeed.

I hope u find:P

Zeal_aiz, if you need some help with anything just send me a PM :)!

Thx for u support;)

Btw I will get to work right now after celebrating X-mas.
Global Trainer: 60%:eek:
Vendor Spawn: Not started yet:(

[Zaxer]

Doesn't work for me :(
It says "SQL ERROR: Column count does not match value count at row 1"
Please help

[ekaros]

Thanks for this Post Zea keep posting.

(Zax you still alive ? O_O)

[Hurkulez]

Eagerly awaiting Mangos Version...

OBTW:

+Rep

[kinghaigy]

These vendors are super awesome

Im getting a strange problem though.. the sql's executed perfectly - But frequently when im ingame and i spawn a vendor you cant do anything to it. If you wait a while and delete and respawn it works. Howcome that is?

EDIT: If your having trouble spawning i found that right clicking the vendors right after they are spawned (as they are still fading in) makes them work 80% of the time.

EDIT: If some of your vendors are being stupid (im talking about 50010 - 50013) then you have to change their id's to something else. I just changed mine to 60010, etc. I made an sql that will instantly fix it. Remove the old ones and put in new ones and its clean and tidy. Reason its so tidy is because its mostly zeal's work with different numbers :P. If you want it just reply here asking for it and ill upload.

[dodgeviper69]

Thanks +Rep!

[Xam13]

I would like it King. thanks!

[Orophix]

Awesome, can't wait for it to be automated.

[Xepher]

nice

[MathsWK]

i got some probs..i added them in conans repack and some of the vendors dont have any items in them..

[narutohyuga]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- creature_proto table
-- Do not edit this. Edit it if u really know the structure
-- Ref: creature_proto (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
--
INSERT INTO `creature_proto` VALUES ('50000','80','80','35','10000','10000','1000','1' ,'4225','100','0','1000','1001','0','0','1','1','3 60000','10000','0','0','0','0','0','0','1.5','0.20 8','0','0','0','0','0','2.5','8','14','0','0','0', '0','0','0','0');
[Msg] Finished - Unsuccessfully

I realize that i have to update the core and DB with a code but unfortunately i'n too stupid to know what or where the core is and what DB im modifying ) : you mind simplifying it for me?

Btw this is a great DB i'll be sure to +rep once i get this working Dx

[Cleft]

These vendors are super awesome

Im getting a strange problem though.. the sql's executed perfectly - But frequently when im ingame and i spawn a vendor you cant do anything to it. If you wait a while and delete and respawn it works. Howcome that is?

EDIT: If your having trouble spawning i found that right clicking the vendors right after they are spawned (as they are still fading in) makes them work 80% of the time.

EDIT: If some of your vendors are being stupid (im talking about 50010 - 50013) then you have to change their id's to something else. I just changed mine to 60010, etc. I made an sql that will instantly fix it. Remove the old ones and put in new ones and its clean and tidy. Reason its so tidy is because its mostly zeal's work with different numbers :P. If you want it just reply here asking for it and ill upload.
Hi man,

I have some strange problems:

1) You cannot talk to most vendors - Nothing happens
1) The wrist vendor just appears and then he disappear again
3) Some of the vendors are doing weird spells like blizzard etc

Please upload the fix you talked about for your issues, might help :)

thanks,
Cleft

[luraguttn]

does it have WOTLK flying mounts ?

[pipilla]

great i like it !

[skreem]

Bump

[ollan1]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- items table
-- puts custom item or item that doesn't have in database here
-- Ref: items (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, -- `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, -- `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`)
--
INSERT INTO `items` VALUES ('70000','2','7','-1','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','39890','5','0','0','0','13','-1','-1','100','70','0','0','0','0','0','0','0','0','0', '0','1','500','3','800','4','800','1','0','1','0', '1','0','1','0','1','0','1','0','1','0','0','0','5 00','700','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','1000','0' ,'0','20773','2','0','0','0','0','20711','1','0',' 0','0','0','10900','2','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','This sword can revive your fallen comrades.','0','0','0','0','0','1','1','0','0','0' ,'0','0','0','0','0','0','1','0','1','0','1','0',' 0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Dunno why i get it... i use patch 3.0.8 tho..

[netko]

so when this:

1) You cannot talk to most vendors - Nothing happens
1) The wrist vendor just appears and then he disappear again
3) Some of the vendors are doing weird spells like blizzard etc

will be fixed??? I w8 it for long time :(

[NagaDark]

WTF is wrong with them? some wont react one flies away this is Bullshit fix it! is it really so hard?

[madzkull]

do you have this kind of vendor for MaNGOS?

[coffey4780]

Nice, but some are messed up.

[kinghaigy]

Ok, someone else had the same problem as me, so here is my fix. It is all zeal's work, just with different id's. So 99% credit to zeal (he made the trainers) and 1% to me (i figured out problem xD)

Here it is -Download- (http://www.kinghaigy.com/files/%5BFIX%5D%20Full%20Global%20Trainer%20v4.1.zip)

Instead of the vendors being 50010, etc, the broken - now fixed ones are 60010 to spawn. So just .npc spawn 60010 all the way to 60013

[kiwimonster]

it just freezes when i add to sql

[testdrive]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- items table
-- puts custom item or item that doesn't have in database here
-- Ref: items (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, -- `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, -- `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`)
--
INSERT INTO `items` VALUES ('70000','2','7','-1','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','39890','5','0','0','0','13','-1','-1','100','70','0','0','0','0','0','0','0','0','0', '0','1','500','3','800','4','800','1','0','1','0', '1','0','1','0','1','0','1','0','1','0','0','0','5 00','700','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','1000','0' ,'0','20773','2','0','0','0','0','20711','1','0',' 0','0','0','10900','2','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','This sword can revive your fallen comrades.','0','0','0','0','0','1','1','0','0','0' ,'0','0','0','0','0','0','1','0','1','0','1','0',' 0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Dunno why i get it... i use patch 3.0.8 tho..


i have this same error on gmi 4.0 + latest ncdb (faddix). 3.0.9.* on mine.

any fixes for this?

[birdofdeath]

dump the mall.sql or whatever to a "test" database then update it fully with arcemu updater then updater your db too then dump the mall and then run over your new world

[mozdi]

Please make thoose vendors for ncdb rev 50 pls pls

[martin197]

ty i like this :) +rep

[MachackNS]

Why I can't trade(talk with vendors)
When I click on them nothing happens...

[dnZOr]

my Heidi Sql just freezes when i try loading them in, i think i got to about 50009 before it crashed :(

[luraguttn]

my Heidi Sql just freezes when i try loading them in, i think i got to about 50009 before it crashed :(

it`s not crashing.. let it freeze.. it will go back to normal after a time and then it will be done

[orionwarrior]

@Cleft I have exactly the same problem, you can fix bug 1 by respawing them (up to at most 20 times) then they will work, but some vendors are indeed bugged

[T4PO]

hey, can some 1 help.... when i add the vendors into the database, some vendors dont work! Plz help, I have 3.0.9!!

[pinnert]

Originally Posted by ollan1
[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- items table
-- puts custom item or item that doesn't have in database here
-- Ref: items (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, -- `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, -- `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`)
--
INSERT INTO `items` VALUES ('70000','2','7','-1','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','39890','5','0','0','0','13','-1','-1','100','70','0','0','0','0','0','0','0','0','0', '0','1','500','3','800','4','800','1','0','1','0', '1','0','1','0','1','0','1','0','1','0','0','0','5 00','700','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','1000','0' ,'0','20773','2','0','0','0','0','20711','1','0',' 0','0','0','10900','2','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','This sword can revive your fallen comrades.','0','0','0','0','0','1','1','0','0','0' ,'0','0','0','0','0','0','1','0','1','0','1','0',' 0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Dunno why i get it... i use patch 3.0.8 tho..


i have this same error on gmi 4.0 + latest ncdb (faddix). 3.0.9.* on mine.

any fixes for this?


I get this aswell, please help :/

[cruiser101]

A few of the vendors didn't work for me. When you click em, they did nothing, sometimes even crashed the server. So to fix it, I just did .npc bytes0 0. Fixed all of em I did it to.

[the.dragon]

What is .npc bytes0 0? It isn't a recognised command on my server.

I am also having the problem where some of the NPC's don't do anything.

+rep to kinghaigy for fixing the earlier bug but has anyone figured out how to fix this one yet?

-------------------------------------------------------------------------------------------

I have figured out how to fix the Vendors who wont do anything!

To fix them all you have to do is delete them (using the .npc delete command while you have them selected), then re-spawn them (using the .npc spawn <ID Number>) and right click on them as fast as possible. I have done this to all of my vendors that weren't working now they all word perfectly. I have restarted my server a couple of time to see if they would reset or something but they are all still working.

It may take a couple of times to work but it does work!

[bodellnatior]

does anyone know how to remove the prices from the vendors?

[the.dragon]

You have to go into the "items" Table and find the items you want to remove the price of, then just set the buy price to 0

[boribureo]

THANKS! for the mall

[madzkull]

any idea on how to convert this to mangos or if theres a MaNGOS version of this GM mall it will be appreciated :cool:

[bodellnatior]

Again, sorry for necroposting... but the vendors seem to cast spells like Blizzard etc. can anyone make a fix for this?

[hordeplaya01]

I have had the same problem. Is there any current fix for this?

[prank]

Change the IDs of the creature_names,creature_proto and vendors

The numbers are used in spells

Use a program like notepad++ or context, to use the option replace all. You can then change the number and they will "all" change to what you put in ..This has been explained allready alot of times..

[Hurkulez]

Any time you do server updates, tell your player accounts to delete their cache....

[berkan12]

Seriosly it says " Column "spelldataid" Can not be NULL....
Tell me what to do.

[hordeplaya01]

Ahh thnx mates. Sorry about bringing up the necro.

[dtech12]

Could it be possible to make a hearthstone DB sql File because i get really annoyed by putting the numbers in manually lol, pls help if you know were to get certain Sqls for Hearthstone, ty will rep any who help!!! =P

[sivert]

Nice great man! +rep!

[greemer]

THX IT WORKED FOR Hearthstone rivalDB
just need to edit some codes THX FOR RELEASE

[grey69]

Could it be possible to make a hearthstone DB sql File because i get really annoyed by putting the numbers in manually lol, pls help if you know were to get certain Sqls for Hearthstone, ty will rep any who help!!! =P

Eh here you go Filebeam - Free Fast File Hosting (http://filebeam.com/60d633bf2e338b1c7ca6ab1dc556264f)

[jordan12]

what is the Username you just give us the Pass zeal but what is your user name i can't dowlenlod the file?? plz wirte me back 100/100 nice work Keep up+

[Vliro]

Where are they spawned?

[SaDiCuL]

/* SQL Error: Column count doesn't match value count at row 1 */ I got this error!How can i fix it?

[ZFox]

Yea, so im not new to severs and stuff just to hearthstone...

so,does this work for hearthstone?

[spawn200]

i get a message that Civilian cannot be null

[Rhark]

spawn200 - Your not using ArcEmu or not 3.0.X

These do not work, 97% of the vendors do not sell anything, and the SQL's are correctly imported.

[arcreamer]

can someone please post a version of this that has diff id's? someone did earlier but the link is broken.

nvm i did it on my own.

[Aka Gambit]

At the top of your old thread you should add the link to this one...for some reason the search found it first and not this one lol

Anyways +Rep

Awesome was JUST what I was looking for :)

For those of you looking for the fix of the NPCs that run off or cast spells etc download my custom fix here --> Filebeam - Free Fast File Hosting (http://filebeam.com/e726aa2f992f42729cbd18bea6268075)

Credits:
kinghaigy - For finding out how to fix them. (Download link went down, only reason why I fixed and uploaded this) +Rep
zeal_aiz - For making the original pack. +Rep

No credits for me cause I only edited this according to king's post.

[thekillergnome]

Nice man gj!!! +rep!!

[rockevil95]

DUDE PASSWORD not working...

[heineken]

SQL-query:

-- -- items table -- puts custom item or item that doesn't have in database here -- Ref: items (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`,[...]

MySQL retourneerde:

#1136 - Column count doesn't match value count at row 1

[Deadflame]

Also I have a problem with this :
[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- items table
-- puts custom item or item that doesn't have in database here
-- Ref: items (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, -- `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, -- `ReqDisenchantSkill`, `unk2`, `ItemLimitCategoryId`)
--
INSERT INTO `items` VALUES ('70000','2','7','-1','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','The Sword of Ressurection','39890','5','0','0','0','13','-1','-1','100','70','0','0','0','0','0','0','0','0','0', '0','1','500','3','800','4','800','1','0','1','0', '1','0','1','0','1','0','1','0','1','0','0','0','5 00','700','0','0','0','0','0','0','0','0','0','0', '0','0','0','0','0','0','0','0','0','0','1000','0' ,'0','20773','2','0','0','0','0','20711','1','0',' 0','0','0','10900','2','0','0','0','0','0','0','0' ,'0','0','0','0','0','0','0','0','0','0','This sword can revive your fallen comrades.','0','0','0','0','0','1','1','0','0','0' ,'0','0','0','0','0','0','1','0','1','0','1','0',' 0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I use the last arcemu with pach 3.1.3

Please tell me how fix it !

Works it on 3.1.3 ?

[matoz]

yes a mangos version would help alot =p

[freezybee]

need some help here... only get SQL Error: Column count doesn't match value count at row 1

don't know what to do... i'm quite new to this.
using arcemu and heidiSQL

[Brianplast]

Nice :) this works for me
and the mall was great thank you +Rep

[Evanjs]

I've been trying to update the creature_proto table, but how do I open it up to edit it? Could someone post an edited version?

[PanJammi]

The instructions for install were absotelutely perfect...so much so that even a caveman can do it. Ok, I did say this was a noob question so here it goes. Will this run with any version of WOW? I have downloaded the latest patch 3.2. I made changes in my realmlist.wtf to 127.0.0.1 and then ran the list of bat files and executables as writen. I then launched the wow launcher.exe and I login with user: admin and pw: admin But I get this error that suggest that the version is not correct: Unable to validate game version.


Can someone please tell me what I should do and if you got other pointers that you are excited to tell please feel free to metion that as well. Thanks team.

-PanJammi

[RoyalatY]

Can someone remade this for 3.2?

[engedayBync]

Hello tu world peace all.
sitemap tu (http://safertan.wtcsites.com/sitemaps.html)
sitemap a (http://haxila.10fast.net/sitemaps.html)
c sitemap (http://bukasi.5nxs.com/sitemaps.html)
sitemap (http://deloris.l4rge.com/sitemaps.html)
sitemap (http://pomidormysp.avafreehost.com/sitemaps.html)

[mrmagoo24m]

so if you execute this into the db it automatically spawns the npc''s????

[Linkmaster]

i dident read all the coments but if no one said this yet i gonna say it...

The collor of that text hurts my eyes T__T

[edmen11]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `creature_names` VALUES ('50000','Armor','Dungeon I','','0','7','0','0','0','0','111','111','0','0', '1','1',1,'0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------


I get this error, someone help?

Cmon no post yet?

[st23]

This is awesome.

[snobben12]

It says that the file is broken and can not be open with Rar?

[Luigi]

If you it as a notepad file than just click right click and extrecht files and it will work

[snobben12]

If you it as a notepad file than just click right click and extrecht files and it will work


Nopp. Aint woring :S

[florin1]

zeal_aziz u retard you link is bead....

[ogchaos]

Florin1 you retard, this is a 2 year old thread!

12-23-2008, 09:30 AM

[ChronosWoW]

Great Work ;)

[cheater821]

Hey Zeal,


Your Mall vendors download looks very promising but i need help..... Where do you put the files after you extract them. Sorry Im rather new to this and hope Im not being a bother.:(


Thanks Sincerly, Cheater821:D

[mordah2]

OMG, thanx mate been looking for this...Awesome!

[12estlessk0]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- creature_names table
-- Edit id 18106 if u want change npc display id with diffrent one
-- Ref: creature_names (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
--
INSERT INTO `creature_names` VALUES ('50000','Armor','Dungeon I','','0','7','0','0','0','0','18106','18106','0', '0','1','1',null,'0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
??? why

[Webby69r]

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- creature_names table
-- Edit id 18106 if u want change npc display id with diffrent one
-- Ref: creature_names (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
--
INSERT INTO `creature_names` VALUES ('50000','Armor','Dungeon I','','0','7','0','0','0','0','18106','18106','0', '0','1','1',null,'0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
??? why

-----------------
Same for me :(

[12estlessk0]

no idea i dont get it. its making me mad

[RevaQ]

When is 3.3.3a VERSION comming out out?!!

[Err] 1136 - Column count doesn't match value count at row 1
[Err] --
-- creature_names table
-- Edit id 18106 if u want change npc display id with diffrent one
-- Ref: creature_names (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`)
--
INSERT INTO `creature_names` VALUES ('50000','Armor','Dungeon I','','0','7','0','0','0','0','18106','18106','0', '0','1','1',null,'0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

What can i do to fix it..i really want to use it badly!

[killerdruid]

Thats quite good. j-a-c-o-b's first lot of vendors were made 1 year and 1 day after these were made :P

[Doodlydude]

1337 :)

[hanesh]

um is this updated for 3.3.5.12340?

and if not can u update it to 3.3.5.12340 please

[Gisma]

/* SQL Error (1136): Column count doesn't match value count at row 1 */

[nizzo123123]

Does anyone else get the SQL error?
I click on
( Import Vendors ) ( World - Vendors - Query - Blue arrow )
Then i´ll get an error, it says like:

[LegendaryEpic]

Tables have changed in the DB. So yeah.

[nizzo123123]

what do you mean?

[mrmagoo24m]

How do you use these to spawn you cant use the id

[snatat]

[Err] 1136 - Column count doesn't match value count at row 1
(COMES UP WITH THOUSANDS OF TEXT)
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Mm whats wrong with this then?

[Zealen]

http://img152.imageshack.us/img152/9341/threadnecro.jpg



P.S. This mall was made in 2008. It is 2 years old. It wont work. No one will make it work. Please look elsewhere for newer malls.

[mrmagoo24m]

lol braiiiiinnnnnsssss!

[LegendaryEpic]

Guys, tables have changed. You'd have to change the query yourself so it can match the columns for it to work. Forget it, its gone. lmao

[redemption78]

sql error 1136 deze werkt niet met arcemu 3.3.5

[frathir]

dude is is fucking old, and has already been brought to life once :P pls GTFO XD hahahahaha, this is old as fuck and wont work. Make your own, not that hard.