[ASCENT][CUSTOM] GM Vendors

Hi,I have one problem with arena season 2 items. When i put them i can't see his model and I'm naked :S How I can resolve that? I try to change the display ID for the t5 ID but doesn't work. Screen:
http://img211.imageshack.us/img211/4...naitemsnf3.jpg
Thanks in advance. Greetings.

It's because you assigned them no DisplayID. They have stats, sockets, and everything else, but the item is pre-determined by their DisplayID (This gives it the Model for your character to be seen with, and for the item model when you click it in your inventory).

Buy they have a displayID number and I'm not seen them.
http://img165.imageshack.us/img165/4...playidsfv8.jpg
:punch::punch: T_T. What I can do?

How positive are you that that is the right displayID?

Is the default displayid. I don't change nothing. :juggle:

What database do you use ?

I'm using AscentRev1141 with WR ASCENT DB V10 UPDATED.

You may want to use a different DB.

What DB you recommend?

I use "Chrispeee" database, located here:

Code:

---

http://www.mmowned.com/forums/ascent-guides/45158-chrispeee-ascent-db-realese-new.html

---

All credits go to Chrispeee.

I try your Db but still the same problem, I can't see the models of arena items season 2 :S :S

Strange, it works fine for me. :\

Could be your client

Oh yes... are you using TBC 2.1.3?

Ok, I was using TBC 2.1.1 xD so now I update for 2.1.3. I need to change the server to other recently version. I try to the last version Ascent 1518?
Thank a lot for helping me. Greetings.

EDIT: Now, I can't connect to the server; says unable to validate game version. I'm using now TBC 2.1.3.6898 and AscentRev1518. :S

In your loginserver.conf change the maxbuild to 9999.

I have many problems now trying to start server. How Server Files and Database are the much stable? Thx.

What problems?

Some problems I have:
Error when start server: http://img522.imageshack.us/img522/1498/errorbm1.jpg
Skills like Stealth, Demon Skin, Seal of Righteousness doesn't work.
Some trainers don't work.
I'm using the Chrispeee DB and AscentRev1518.

I get the same errors, it's not crashing my servers in any way though.

I decided go back to TBC 2.1.1. What I can do to do that? Repair utility doesn't work.

I get item not found on certain vendors.. like all armor and weapon vendors when I try and buy things from them. What's up? Also when I tried to run the custom_shop_display sql file, I got an error. My creature_proto doesnt have a display ID column.. What do I have to do?

Edit: Nevermind I'm just retarded... my character didn't have enough gold...

okay....
one question
is channel_49 not been that active??
actually i lied, i have another statement
Deboun, there's a way, but i forgot how to find it, some other forums may have a repair thing that works.

Quote:

---

Originally Posted by KingXCrosses

okay....

is channel_49 not been that active??

---

If you havent of noticed on other websites..... but terranet is not made for public anymore, so thats probably why channel is inactive

Hello. I can't Install custom shops on the NCDB . What to do? Always get errors!!!

If you get errors it's probably because the NPC is already created with that entry ID.

Quote:

---

Originally Posted by lordik333

Hello. I can't Install custom shops on the NCDB . What to do? Always get errors!!!

---

the vendors creature proto is terranets, NCDB uses a whole different creature proto, nothing to do with it already getting taken,
channel has a command in the sql file to delete what eva was in the positions of the vendors

cant thank you enough!

could somebody adjust this shops for NCDB?

Quote:

---

Originally Posted by Lordik333

could somebody adjust this shops for NCDB?

---

Please? Strange, I used to use with NCDB, but no longer works.

Some core/NCDB sql changes must have rendered them incompat.

Well, i did some testing and after about 30 mins i got the SQL files working.

Have phun :)

How do I install the vendors?? Do i just unzip to my Sql folder?

traxxas
trust me when i say this give up with your antrix server and go for ascent i tried mangos and antrix setup they are the servers that have the most setup troubles if your looking for easy setup go for ascent , as im testing my ascent server I have had truobles with Npcs and weapons and GM commands (but i think that might just cuase i dont know what they are and how to install them) anyways I hope you find this helpfull

When I try to execute the batch file Custom_shop.sql into my antrix db in SQLYog I get this error
Error Code: 1136 - Column count doesn't match value count at row 1

please help

prolly a dumb question, but how do i update my tables? says i have to in post 1 of this thread


~~Ignore this, i decided to quit hosting and playing WoW~~

Quote:

---

Originally Posted by Ap0ll013

Well, i did some testing and after about 30 mins i got the SQL files working.

Have phun :)

---

thx a lot mate!!!!
i was going crazy with the vendords xD

omg its a WoW quitter!!!!!
good job about the vendors still :) they all work...great!!!

I dont get mine to work:S

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO creature_proto VALUES (50000, 100, 1741, 1000000, 1000000, 2, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0);
[Msg] Finished - Unsuccessfully


and yes i've executed the stuff at the first post

umm did you execute the vendors yet?

Hello,
I have just made an update of the sql of custom_shop_3.0a makes by channel_49 and of the version custom_shop_3.0b which I had to modify with additions according to.

Inside there is also the pnj which Cat121 had made to sell the 4 totem air/fire/water/ground + totem spirit of water in love.

And the pnj makes by eldianel for the farts (pets)

And the pnj makes by Lucky to sell the various compos class and poison for Rogue

And the pnj makes by creatif63 and me even for the validation of quest class.
example: defensive posture of the warrior or form of transformation druid and well of others for the 2 factions A and H.

Version: custom_shop_3.0c
Compatible: ncdb 485 and undoubtedly of other bdd recent
Compatible core ascent: 1714 and undoubtedly of other core ranging between the 1500 and 1714
Compatible wow: 2.1.3 and 2.2.0

Download custom_shop_3.0c

I ask politely, but if you could make an update to your shops channel_49 to meet NCDB 2 requirements, that would be fantastic.

I got a prblem When i try To Execute the custom_shop_display.Sql in my navicat
It says this :
[Err] 1054 - Unknown column 'displayid' in 'field list'
[Err] UPDATE creature_proto SET displayid = '18106' WHERE entry between '50000' and '50080';

Plz help me fix this!
U will get a candy :P

Okay i dont know if anyone have posted this yet but if anyone wants these shops to work with femaleid maleid walkspeed rnspeed flyspeed and all that stuff, i made this little update and added the values. i made this for myselff cuz i like the shops very much just wanted to share with others since its kinda boring to fill in the values :) also made them to humanoid's insted of elemental's. and fixed npc_respawn_link insted of respawnNpcLink

tested on:
Ascent1709
Next-Chapter Database Milestone 0.2.0

Filebeam!

Channel, great job. I have some questions though.
1. Is there a query to make all of the Misc. Currency items have a buyprice?
2. Some of the items do not have buy prices, although almost all of them do. Is that a fault of the query I ran?
3. Can i hug you?

Welcome to Ackhole Games!

Edit* Im using rev 1700 of Ascent and NCDB .2, I used version 3.0b
EDIT* Also, some of my tier 4-6 do not require the Forgotten stuff to buy it. Or is that just T6? If so, then my tier 4 and 5 do not require anything to purchase.

when using the supplied patches to the vendors for the new ncdb .2 vendors dont have prices anymore, it removes the prices for T5 and T6 and some pvp vendors as well, and a few other regular vendors, anyway to fix this ?

I have tried the ones that give price updates but they dont work at all any solution ?

i will post the fix for the tier 4,5,6 :D
Filebeam - Free Fast File Hosting

Buyprices...

WTF! I cant execute any sql ive tryed with query and normal just execute batchfile and still it says:

Code:

---

[Err] 1136 - Column count doesn't match value count at row 1
[Msg] Finished - Unsuccessfully

---

If i add the NPC spawns, when i restart the server, will they still be there?

You should add this question with an answer to first post if it is a no. If its a yes, i want you to have my babies. :)

I get this error all the timewhen i try to execute "custom_shop_display":

Quote:

---

[Err] 1054 - Unknown column 'displayid' in 'field list'
[Err] UPDATE creature_proto SET displayid = '18106' WHERE entry between '50000' and '50080';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

---

All the other files worked to execute.

hi
i have TNDB8.sql and i tery updata custom.shop.3.0 not Working

help me

well, i want a npc creator someone help me plz

Thank you so much for this custom vendors sql files. My friend was looking for one while I did work on the server and he couldn't find any (most likely was lazy). I was about to create them on wow-v until google reminded me we are best friends ;)

hey, pilame, wow-v.com or .org or .net or w/e has an npc creator, along with armors and weapons, etc.'
(i think its wow-v.com)

channel_49 ... i spawn the vendors somewhere in darkshore - H and ally in WETLANDS ...How i can put portals at start Taurens,undeads,Humans...etc?

Thanks.

Quote:

---

Originally Posted by Divishona

I get this error all the timewhen i try to execute "custom_shop_display":



All the other files worked to execute.

---

same here

Quote:

---

Originally Posted by fira

same here

---

That is the look of it i believe

And...
Npc creator


That is julianx's npc creator, never tried it.
Describes how it works and all that jazz(mmowned Forums)

Any new content/update coming out any time soon?

I don't know if this works in terranet or not, but it works for ncdb, for the most part. Some of the prices were not added or do not upload correctly.

Portals: you need to make your own custom portals to get to that area, check these forums or ascent forums to find out how to create them.

displayid: the displayid and been changed to male_displayid and female_displayid.

As for NCDB... I have the custom vendors working, i could make a sql backup of them for you, also, i will add the pricing for you to make most if not all of the prices work. (What I mean is everything will have a price, not neccisarly the right one :-) Post on here if you are interested.

i can't install all the sql files in 3.0a

i can install the buyprice ones, but not the other.

when i try custom shop i get: Column count doesn't match value count at row 1

display: Unknown column 'displayid' in 'field list'

spawn: Unknown column 'respawnNpcLink' in 'field list'

Channel_49 I have conf your Vendors for the newest DB Milestone 0.2.1 so i could share if you want?

lol555 check out my newest post that you can import i guess. : /

Those don't work, says:
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
[Msg] Finished - Unsuccessfully

:S

well thanks for the npc creator, if someone help me now with an item creator plz.

How come I get an error when I try to execute the SQL-Files?

Quote:

---

Originally Posted by Ap0ll013

Well, i did some testing and after about 30 mins i got the SQL files working.

Have phun :)

---

that works for me ;) thanks

I Get this error:
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0);
[Msg] Finished - Unsuccessfully
Can someone help me pls???

A really noobish question....
Where can I find the vendors?

Regards,
Sjors

these vendors are not compatible with ncdb

They are compatible, here is a dump of my own!
Channel_49s_Custom_Vendorp.zip - FileFront.com
Let me know how it works!

Edit* I put the wrong items files in, so here are the buyprice updates.
WARNING, Backup your db first, to make sure if something happens, you can fix it.
Attention: The one buyprice query will put everything without a sellprice to a 50g buyprice, be careful with this!

I'm retired for the time being, too much... real work, and this charity work won't pay for my expenses. I'll prolly invest a little time in the near future, as well as pick up on speciosus.

hey, i'm very curious, and i'm not tryin to be rude, but what do you do for a living?

When it says "The item was not found" is for the most, cause you have too much gold on you. (You cant have over 200k gold).. If im right?

I updated the custom shop for NCDB rev652. Here is your download link:
custom_shop_ncdb.rar

When I try to execute the batch files with my SQLyog, I get an error.
The first part;
There was an error while executing a query.
The query and the error message has been logged at:
C:\Documents and Settings\Jay\Application Data\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file.
- Then i open the error file, and this here comes;

[i]Query:
Rar!


Error occured at:2007-11-10 19:11:22
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-10 19:11:51
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-11 17:40:34
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-11 18:20:24
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-11 18:20:32
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-11 18:20:34
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
Rar!


Error occured at:2007-11-11 18:21:19
Line no.:2
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rar!' at line 1

Query:
d8:announce44:http://vip.tracker.thepiratebay.org/...comment18:This is a comment!13:creation datei1185052043e4:infod5:filesld6:lengthi2205e4:pathl10:GM weapons35:Axe_of_the_Game_Master-29925552.sqleed6:lengthi2200e4:pathl10:GM weapons29:Axe_of_the_Monkey_Dance-9.sqleed6:lengthi2151e4:pathl10:GM weapons18:BOOM_Hammer!-4.sqleed6:lengthi2173e4:pathl10:GM weapons30:Blade_of_Swordman-19931993.sqleed6:lengthi2135e4:pathl10:GM weapons15:Boomling-10.sqleed6:lengthi2122e4:pathl10:GM weapons22:Da_Thing!-20979773.sqleed6:lengthi2246e4:pathl10:GM weapons26:Helm_of_Jamaz-22002200.sqleed6:lengthi2149e4:pathl10:GM weapons22:Holiday_Blade-1993.sqleed6:lengthi2298e4:pathl10:GM weapons19:Killer-88888888.sqleed6:lengthi2101e4:pathl10:GM weapons16:Newbie_Axe-1.sqleed6:lengthi2112e4:pathl10:GM weapons19:Newbie_Dagger-6.sqleed6:lengthi2118e4:pathl10:GM weapons17:Newbie_Mace-2.sqleed6:lengthi2106e4:pathl10:GM weapons18:Newbie_Sword-5.sqleed6:lengthi2182e4:pathl10:GM weapons36:Overpowered_Ashbringer-123456789.sqleed6:lengthi2126e4:pathl10:GM weapons17:Slam_Hammer-8.sqleed6:lengthi2228e4:pathl10:GM weapons30:Staff_of_the_Game_Master-7.sqleed6:lengthi2215e4:pathl10:GM weapons37:Sword_of_The_Game_Master-35377273.sqleed6:lengthi2167e4:pathl10:GM weapons28:The_Skrewdriver-22747273.sqleed6:lengthi2316e4:pathl10:GM weapons38:Thunderbolt,_hand_of_Zeus-11223344.sqleed6:lengthi27471e4:pathl7:GMAddon11:BanForm.xmleed6:lengthi3203e4:pathl7:GMAddon13:Changelog.txteed6:lengthi36910e4:pathl7:GMAddon12:CommForm.xmleed6:lengthi22684e4:pathl7:GMAddon20:EditAnnounceForm.xmleed6:lengthi8122e4:pathl7:GMAddon11:GMAddon.luaeed6:lengthi31637e4:pathl7:GMAddon15:GMAddonForm.xmleed6:lengthi25489e4:pathl7:GMAddon12:ItemForm.xmleed6:lengthi28940e4:pathl7:GMAddon12:MiniForm.xmleed6:lengthi8982e4:pathl7:GMAddon14:MiniTicket.xmleed6:lengthi17647e4:pathl7:GMAddon12:MiscForm.xmleed6:lengthi22294e4:pathl7:GMAddon11:NPCForm.xmleed6:lengthi16333e4:pathl7:GMAddon14:ObjectForm.xmleed6:lengthi37295e4:pathl7:GMAddon19:ProfessionsForm.xmleed6:lengthi29495e4:pathl7:GMAddon14:RidingForm.xmleed6:lengthi25562e4:pathl7:GMAddon13:SkillForm.xmleed6:lengthi18941e4:pathl7:GMAddon13:SpellForm.xmleed6:lengthi22149e4:pathl7:GMAddon12:TeleForm.xmleed6:lengthi23076e4:pathl7:GMAddon8:Textures13:Highlight.blpeed6:lengthi12196e4:pathl7:GMAddon8:Textures14:Highlight2.blpeed6:lengthi12196e4:pathl7:GMAddon8:Textures14:Highlight3.blpeed6:lengthi6660e4:pathl7:GMAddon8:Textures10:TBlogo.blpeed6:lengthi6660e4:pathl7:GMAddon8:Textures11:TBlogob.blpeed6:lengthi18975e4:pathl7:GMAddon14:TicketForm.xmleed6:lengthi48443e4:pathl7:GMAddon18:TicketShowForm.xmleed6:lengthi52930e4:pathl7:GMAddon14:WeaponForm.xmleed6:lengthi549e4:pathl7:GMAddon11:gmaddon.toceed6:lengthi171232e4:pathl11:Objects.txteed6:lengthi534379e4:pathl10:Spells.txteed6:lengthi514948e4:pathl9:items.csveed6:lengthi374405e4:pathl8:npcs.csveee4:name19:Antrix GM help pack12:piece lengthi262144e6:pieces180:

Just find or create new vendors, this one obviously has bugs due to recent database changes.

yeh, get different vendors for the latest patch,
also, please use [code][*/code]
format, saves space and stuff

Quote:

---

Originally Posted by KingXCrosses

yeh, get different vendors for the latest patch,
also, please use [code][*/code]
format, saves space and stuff

---

Oh yea, sorry about that :) Didnet know that it was possible..But ill do that next time!

I revised the Channel_49 GM Shops to work with 2.3.0 and the Newest Ascent Core 2343 and Newest NCDB 652

link to get it is at Filebeam - Free Fast File Hosting

What do I do? Graphic design.

Too much work at college, we have like 5 projects a week, so I don't have much extra time for wow anymore lol. Maybe it'll calm down a bit soon, and I'll have some time after final exams and critiques.

Been doing a lot graffiti lately for some reason...
Heres a handstyle tag: YouTube - Re: Nick's Legal Graffiti Tagging Style.
I have beef with this random toy who can't write for shit lol.

And heres what I'm working on right this very moment: http://img102.imageshack.us/img102/2121/img0012ws5.jpg

can u make the vendors work for 2.3? cuzz i get errors with column 1 etc error when i try to execute em.

zebra download CrimsonRO's fix thats 2 replys above yours.
it works fine.

thnx a lot!

Nice Graffiti Dude, and thanks for releasing new vendors

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO vendors VALUES ('50000', '16677', '1');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I am formally known as CrimsonRO, I am working with Ackhole to fix some issue in the Mall and GM vendors, I had fixed it to work with newest ncdb and Ascent, but experiancing issue with mouse pointer dispearing when its over the npc, but still could right click and access to npc, yet mouse pointer is missing around it.

Soon will release the update, with that fixed

The current vendors table will not allow these to be executed. You'll have to find workarounds.

I just revised the Custom Shop to work with 2.3.3 (NCDB rev 1000+)
It took a while but it was worth it in the end: Filebeam or Qsave, your choice!

Filebeam - Free Fast File Hosting

Channel_49 Custom Shop for 2.3.3.zip - 51.1 Kb

Quote:

---

Originally Posted by humera5

I just revised the Custom Shop to work with 2.3.3 (NCDB rev 1000+)
It took a while but it was worth it in the end: Filebeam or Qsave, your choice!

Filebeam - Free Fast File Hosting

Channel_49 Custom Shop for 2.3.3.zip - 51.1 Kb

---

its doesnt work by me follow Error by custom_shop_updated.sql

Code:

---

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

---

pls help me i have the NCDB1058 Database
another from this pack works fine

Greetz
DaNeo

Lol I can't get the vendors to work for myself either.

Wow, people still want these... anyway, ill sql dump the ones in my db for you, updated to 1021. That should work. And BTW, i never did get all the prices right if anyone has them :-)

http://www.ackholegames.com/Download...GM_Vendors.zip

Two important things:
Channel 49 never made spawns for 50-78, so they are not here.
Also, I dont have prices for you. If someone has for all prices, however, i would love them myself.

HAVE FUN.

POST IF you have issues!

I love channel_49. He got me into scripting in the first place.
Welcome to Ackhole Games!

buy viagra professional online buy viagra canada buy discount viagra uk buy discount viagra viagra professional buy female viagra buy viagra in australia buy viagra prescriptions buy viagra online buy viagra tramadol cod delivery tramadol overnight cod no prescription tramadol free shipping tramadol cash delivery cod tramadol cod next day cash on delivery tramadol tramadol overnight shipping buy cheap tramadol online buy tramadol saturday delivery buy tramadol buy discount cialis online buy cialis soft tabs buy cialis professional online buy cheap cialis jelly buy cheap cialis online buy cheap generic cialis buy discount cialis soft tabs buy discount cialis online prescription viagra buy discount viagra UK forum.ragezone.com 7

LOL! A bot.

Talking about viagra and linking to ipodhacks.com, that's not fair. >:

I am very 'good' at puting the vendors at 'cool' places on gm island =] I used to mod allot (ingame) And I've made my own map + objects & houses remade from gm island.. and build gm island to a fighting instance and home for if your really into the game :) --- And I can script well.. It was a while ago since I had my private server But i'm making one tonight so if i have the spawns I will post them if w/e anybody needs them =] (don't expect me to post them that soon)..
anyway Friendly greetings Bodekai. (I'm not a pro at all or anything, just a bored antousiast server Leader^^)

i get all the stuf

Query:
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2008-03-12 19:59:48
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2008-03-12 20:00:05
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2008-03-12 20:00:07
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50000, 1, 16256.1, 16298.3, 13.1752, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0)

Error occured at:2008-03-12 20:01:59
Line no.:3
Error Code: 1054 - Unknown column 'x' in 'field list'

Query:
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2008-03-12 20:02:50
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO creature_names VALUES (50000, "Armor", "Dungeon I", 0, 4, 0, 3, 0, 0, 18106, 1, 1, 1, 0)

Error occured at:2008-03-13 18:40:40
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
UPDATE items SET buyprice = (sellprice*5) WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid BETWEEN '50000' AND '50080')

Error occured at:2008-03-13 18:49:38
Line no.:1
Error Code: 1054 - Unknown column 'itemguid' in 'field list'

Version 3.1
Hello, I am back and slowly coming out of retirement, getting back into WoW development as I go. The latest release is to make sure the vendors are compatible with the new database structure, and new content will be added in the new releases to update to the new wow standards.

Testers are welcome since I havn't tested these ingame yet (havn't got time to setup server yet). I'm also looking for helpers whoever is willing to create new content/spawns/other stuff for my vendors.

In other new: Since this is my "first" development release, so I updated this first, but do expect me to release other 100% tables again, such as loot tables/vendors/etc.

I like...
Nice work Channel49...
Keep it up xD

Does this new update work properly, has anyone tested it.

I ran the update, everything went ok. Only problem I am having is that I spawned one of the vendors, but cant interact with it. Is there something I am missing?

Try this attached version, see if it fixes it.