yeh, get different vendors for the latest patch,
also, please use [code][*/code]
format, saves space and stuff
Printable View
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!Quote:
Originally Posted by KingXCrosses
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
its doesnt work by me follow Error by custom_shop_updated.sql
pls help me i have the NCDB1058 DatabaseCode:[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
--------------------------------------------------
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.