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.

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.