Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600

Hey yall, I have the vendors working on my server, and decieded to upload it because I saw all the posts about them being unusable because he did not update them... here you do, let me know if the link goes down or an error pops up with the sql's!

http://www.ackholegames.com/Download...%20Ackhole.zip

Version .2

Nice. So this will work with NCDB 600? Also, Thanks for remaking it. It will save some people time. And good luck.

-Kiteal

Quote:

---

Originally Posted by Kiteal

Nice. So this will work with NCDB 600? Also, Thanks for remaking it. It will save some people time. And good luck.

-Kiteal

---

Danke! Let me know if it works or not, or if I have to modify the sql files.

And yes, I am using .2.2 and they work fine.

Quote:

---

Originally Posted by Ackhole

Danke! Let me know if it works or not, or if I have to modify the sql files.

---

Quote:

---

Originally Posted by Ackhole

And yes, I am using .2.2 and they work fine.

---

Yup, they work for me. NCDB 606. Thanks.

-Kiteal

i use ascent rev 2173
and ncdb 606 and its no work :( its said error
u can fix it ?

Quote:

---

Originally Posted by edor5555

i use ascent rev 2173
and ncdb 606 and its no work :( its said error
u can fix it ?

---

What did you get error at?

-Kiteal.

sqlyog in date ncdb 606 and i do its talk error
want what is talk ?

Edor, no clue, but this may help...
Kiteal, sorry about that, just noticed that the items sql was for a custom T7 set I was working on at the same time... lol

Check top of page for new link!

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!

Yeah, dumb move for me.

this is no work the link from u give <>

Yep,Not working

Quote:

---

Originally Posted by Ackhole

Edor, no clue, but this may help...
Kiteal, sorry about that, just noticed that the items sql was for a custom T7 set I was working on at the same time... lol

http://files.filefront.com/Channel+49s+Custom+Vend

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!

Yeah, dumb move for me.

---

Ouch. Lol. Wekk the T7 one works, but I can not find the download for the Channel_49 thing.

Thanks.

-Kiteal

awsome thing..
it works..
but just one thing..
there's no single item on vendors.. even when you spawn them by yourself..

Quote:

---

Originally Posted by daverick

awsome thing..
it works..
but just one thing..
there's no single item on vendors.. even when you spawn them by yourself..

---

Channel_49s_Custom_Vendorp.zip - FileFront.com

As for your question, you have to actually restart ascent... since the vendors table in none-reloadable.

i did reload it.. serval times...
still no singel item..
AND i cant seem to find any other vendor and npc in the world..
only in GM Island...
and.. there's no mobs..

Quote:

---

Originally Posted by daverick

i did reload it.. serval times...
still no singel item..
AND i cant seem to find any other vendor and npc in the world..
only in GM Island...
and.. there's no mobs..

---

Mine should not have done that, which is why I said to backup your database first!

Im A Fricken idiot, redid the sql's again, because the create table clause was in there...

Check top of page for new link!

I updated all the other links on my posts too.

Where those vendors should spawn? I'm using ascent rev2181 and GM-island is at Tanaris, and there's nothing...

Quote:

---

Originally Posted by Etherstream

Where those vendors should spawn? I'm using ascent rev2181 and GM-island is at Tanaris, and there's nothing...

---

If you used my creature_spawns sql they should appear inside the building in GM Island, 1st, 2nd, and 3rd floor.

How can I teleport to "feralas" (?) GM-island? When I write .recall port gm I'll find myself at tanaris' GM-island.

Appreciate the hard work. Unfortunaly this did not function for the test server we deployed this on.

Jeremieg, any information on fuctioning would be nice...

Etherstream, .recall port gmisland

nice work.....

Incredible, thnx, I haven't seen one repack that doesn't use your vendors. Your a legend in the among the WoW Emulators.

wow, that would be crazy :-) And technically they are not my vendors, they were originally channel_49's. I just remade them to be usable in NCDB.

I just wanna say that I'm technically retired from wow until further notice. Way too much from university hitting me so...

And if anyone wanna link me to my original release thread, that'll be cool. Can't find it in many pages of spam.

How come when i open some vendors i get an error it has happened with 3 people so far i have someone recording which ones do it right now will post them in a minute

Quote:

---

Originally Posted by channel_49

I just wanna say that I'm technically retired from wow until further notice. Way too much from university hitting me so...

And if anyone wanna link me to my original release thread, that'll be cool. Can't find it in many pages of spam.

---

I actually do not have the link anymore :-(

Sorry, but thanks, hope I did a good job!

/legendalert.

Quote:

---

Originally Posted by popcapking

How come when i open some vendors i get an error it has happened with 3 people so far i have someone recording which ones do it right now will post them in a minute

---

I have no clue why that is happening, advice would be nice.

Hey! First off, a thanks to Channel 49 for all his original hardwork and to those who are keeping us all current while he battles books, bells and all the hot gurls in college. :)

I'm wondering if anyone else has run into problems importing the creature spawns aspect of this addon. I can import everything just fine until I try and import the spawns. Hopefully I'm not missing some obvious thing or this has been answered already in the thread.

I've tried on milestone 2.1, 2.2, as well as Rev606 & Rev 636. I get the same problem everytime.

Perhaps I'm missing a sql update? I've applied everything in the most current updates release.

My antrix version is 2278 and my current (preferred) db is 636.

Also, if anyone is using the GM Island addon for NCDB and has the quest giver that actually works I could go with that. I love the way it works but the guard are bloody annoying.

Thanks in advance, and again - Thank you guys for all the wonderfull work. Truely a good community.

Quote:

---

Originally Posted by evilgenx

Hey! First off, a thanks to Channel 49 for all his original hardwork and to those who are keeping us all current while he battles books, bells and all the hot gurls in college. :)

I'm wondering if anyone else has run into problems importing the creature spawns aspect of this addon. I can import everything just fine until I try and import the spawns. Hopefully I'm not missing some obvious thing or this has been answered already in the thread.

I've tried on milestone 2.1, 2.2, as well as Rev606 & Rev 636. I get the same problem everytime.

Perhaps I'm missing a sql update? I've applied everything in the most current updates release.

My antrix version is 2278 and my current (preferred) db is 636.

Also, if anyone is using the GM Island addon for NCDB and has the quest giver that actually works I could go with that. I love the way it works but the guard are bloody annoying.

Thanks in advance, and again - Thank you guys for all the wonderfull work. Truely a good community.

---

Hmm, I kind of doubt you missed a creature_Spawns update, ascent's last one was rev... none as far as I know :-)

Quote:

---

Originally Posted by Ackhole

Hmm, I kind of doubt you missed a creature_Spawns update, ascent's last one was rev... none as far as I know :-)

---

Thats what I thought. :) I'm gonna start from scratch with a clean 2.2 and see how it goes. So far tho, no such luck. cores about 6k in to the import for the spawns. When I do go in and check out whats made it i'm missing about half the the vendors. So I'll keep you in the loop as to what i find out. So far tho, no luck with a clean 600, 606 or 636. I'm updating my svn of ncdb just now but i'm not holding my breath.

I've looked thru your sql dump and it all looks good. Tho I can't see the exact error because SQLyog blows, i get a error when it parses the error log to actually show me wth is going on. It's like shooting in the dark. hehe.

Quote:

---

Originally Posted by evilgenx

Thats what I thought. :) I'm gonna start from scratch with a clean 2.2 and see how it goes. So far tho, no such luck. cores about 6k in to the import for the spawns. When I do go in and check out whats made it i'm missing about half the the vendors. So I'll keep you in the loop as to what i find out. So far tho, no luck with a clean 600, 606 or 636. I'm updating my svn of ncdb just now but i'm not holding my breath.

I've looked thru your sql dump and it all looks good. Tho I can't see the exact error because SQLyog blows, i get a error when it parses the error log to actually show me wth is going on. It's like shooting in the dark. hehe.

---

Yah. No matter what I do with a clean ncdb it bombs on query 20 of the import for Creature_spawns.Custom Vendors channel_49. Dunno what the issue is but I'll move forward with it perhaps a few updates from now.
Thanks for your hardwork, I look forward to revisiting this project in the future. Until then, keep up the good work.

PS - I'll be watching the thread so if anyone has any idea's for me I'm open to giving them a shot when I get some free time. So far I've tried .2.2, 2.1, 606, 636 and 639 revisions of NCDB. All fresh and with updates applied. Also tried several different orders of importing the data to no avail. Perhaps I'm too tired, perhaps I'm just not lucky. Either way, my weekly update is late and my players get pissy. :)

eg/Matt.

Ok, I just realized that any npc from 50050 - 50078 DOES NOT SPAWN through my querys... He did not originally have a spawn point I would assume, so, thus, you will have to make your own area for them.

New Link is also at the top of the thread, not just here:
http://www.ackholegames.com/Download...%20Ackhole.zip

version .2

I will be updating it from time to time when i find more errors. Make sure to read the Readme.txt, it may help some of the problems people are having.

Updated to be usable with 2.3.

Version .3

Let me know of any errors and such.

Same link as above.

Good job Ackhole. Malls for everyone!

Quote:

---

Originally Posted by Paco44

Good job Ackhole. Malls for everyone!

---

Thanks Paco :-) Just hope people find these helpful.

They are definitely useful. I also suggest you make a few more vendors, such as weapon vendors (separated, of course, between its respective weapon type).

Quote:

---

Originally Posted by Paco44

They are definitely useful. I also suggest you make a few more vendors, such as weapon vendors (separated, of course, between its respective weapon type).

---

There should be weapon's vendors in this repack, if you use the spawn script, they would be on the uppermost level inside the building in gm island. do you mean weapon vendors for differnet types, like axe, sword, 2hsword, and such?

Ackhole, I got an error while trying to import the creature_proto sql file. It appears that there is an extra space after the table name in the first line of the file:

'creature proto ' vs 'creature_proto'

I fixed it in my copy, and it ran just fine in SQLyog.

EDIT::: The creature_spawns sql file is outdated as of NCDB 659. After changing many of the field names, I still get the following error (which is different than the errors I was getting when the field names weren't matching):

Error occured at:2007-11-21 01:44:20
Line no.:1
Error Code: 1062 - Duplicate entry '85635' for key 1

In my creature_spawns table, the id field ranges from 1-50. I don't really understand how this table works.

Yes I do Ackhole.

Quote:

---

Originally Posted by Paco44

Yes I do Ackhole.

---

ok, another project for me :-)

I will work on updating the sql also, wont get to it until thanksgiving however :-(

Quote:

---

Originally Posted by kirbysayshi

Ackhole, I got an error while trying to import the creature_proto sql file. It appears that there is an extra space after the table name in the first line of the file:

'creature proto ' vs 'creature_proto'

I fixed it in my copy, and it ran just fine in SQLyog.

EDIT::: The creature_spawns sql file is outdated as of NCDB 659. After changing many of the field names, I still get the following error (which is different than the errors I was getting when the field names weren't matching):

Error occured at:2007-11-21 01:44:20
Line no.:1
Error Code: 1062 - Duplicate entry '85635' for key 1

In my creature_spawns table, the id field ranges from 1-50. I don't really understand how this table works.

---

I cannot find any of the errors you have in my sqls...

The field range for creature_Spawns is what spawns, only 50050 and under spawn in this spawn sql. the other 38 do not spawn, you must place them yourself.

Quote:

---

Originally Posted by kirbysayshi

Ackhole, I got an error while trying to import the creature_proto sql file. It appears that there is an extra space after the table name in the first line of the file:

'creature proto ' vs 'creature_proto'

I fixed it in my copy, and it ran just fine in SQLyog.

EDIT::: The creature_spawns sql file is outdated as of NCDB 659. After changing many of the field names, I still get the following error (which is different than the errors I was getting when the field names weren't matching):

Error occured at:2007-11-21 01:44:20
Line no.:1
Error Code: 1062 - Duplicate entry '85635' for key 1

In my creature_spawns table, the id field ranges from 1-50. I don't really understand how this table works.

---

Found an error in creature_proto, guess this is what you were talking about...
Fixed my Vendors.sql, seems that it had the wrong column names...

http://www.ackholegames.com/Download...%20Ackhole.zip

Version .4

Had an items.sql in there for a differnet project, and For all who are curious about what project, its called Rev2k7 Custom Godlike GM Armor.

<---- is stupid.

Added a query for someone which Will change the Dungeons Set 2 prices to 100g.

Let me know of any other mistakes and what not, and btw, I know the buyprices for some items will not come up, give me feedback so I may make an Items.sql which will add the correct prices!

Version .5, Same link as above.

Download Here

I am discontinueing work on this project, and the download has been removed.

why have you removed the download link? You could at least leave them up for other people to work on instead of being selfish.

If you want them, let me know.

I would like the very much indeed

http://www.ackholegames.com/Download...9;sVendors.zip

I just got sick of trying to do the fricken price updates. here are the creature_names
Creature_proto
Creature_spawns
vendors.