-
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Nice. So this will work with NCDB 600? Also, Thanks for remaking it. It will save some people time. And good luck.
-Kiteal
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
i use ascent rev 2173
and ncdb 606 and its no work :( its said error
u can fix it ?
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
sqlyog in date ncdb 606 and i do its talk error
want what is talk ?
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
this is no work the link from u give <>
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
awsome thing..
it works..
but just one thing..
there's no single item on vendors.. even when you spawn them by yourself..
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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..
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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!
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Where those vendors should spawn? I'm using ascent rev2181 and GM-island is at Tanaris, and there's nothing...
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
How can I teleport to "feralas" (?) GM-island? When I write .recall port gm I'll find myself at tanaris' GM-island.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Appreciate the hard work. Unfortunaly this did not function for the test server we deployed this on.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Jeremieg, any information on fuctioning would be nice...
Etherstream, .recall port gmisland
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Incredible, thnx, I haven't seen one repack that doesn't use your vendors. Your a legend in the among the WoW Emulators.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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 :-)
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Updated to be usable with 2.3.
Version .3
Let me know of any errors and such.
Same link as above.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Good job Ackhole. Malls for everyone!
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
Quote:
Originally Posted by
Paco44
Good job Ackhole. Malls for everyone!
Thanks Paco :-) Just hope people find these helpful.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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).
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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?
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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 :-(
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
I am discontinueing work on this project, and the download has been removed.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
why have you removed the download link? You could at least leave them up for other people to work on instead of being selfish.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
If you want them, let me know.
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
I would like the very much indeed
-
Re: Channel_49's Custom Vendors Remade for Ascent 2.0 Release and NCDB ~600
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.