[Release] 12/21/2007 Working Vendor's + Vendor's Items

[~SaiLyn~]

/*

Vendor's + Vendor's Items

#This release include's working vendors plus their item's over 50-70 of them.

#This vendor's works well with all latest current database out there.

#NCDB latest database will also work with this.

-I did this , to thoes out there that need them.

Download Now VENDOR's ( ITEMS ) 12/22/07 :

Vendors__ITEM.sql - FileFront.com

DOWNLOAD NOW VENDORS ( NPC ) 12/22/07 :

NPCVendor.sql - FileFront.com

*/

[Illidan1]

lol the fact that all of my Malls (2.3.0) Malls all have them

[MysterioussouL1]

Nice any screenshot ?

[~SaiLyn~]

lol the fact that all of my Malls (2.3.0) Malls all have them

I think all repacks with vendors have same vendors just sometimes different items.

[Illidan1]

i was on a Server with 7612 Vendors, every item in game and over 5000 custom Items, i nearly f**king killed my self

[~SaiLyn~]

i was on a Server with 7612 Vendors, every item in game and over 5000 custom Items, i nearly f**king killed my self

Thats called NO-LIFE

[Sporeles]

i call that dedication to the players for a person to do that

[L'Lawliet]

yea umm one problem just one, currency. that didnt work.

[Illidan1]

the vendor? it didn't have any tokens Etc in it?
or the Tier 4 - 6 is broken?

[Steph]

Unfortunately the vendor items cant be straight imported into the new databases:

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

NCDB 710.

[L'Lawliet]

no the vendor, when i was adding the sql it kept on saying cant add the currency and all that. so then i spawned it, clicked it, and game crashed.
EDIT yep what steph said.

[Steph]

Its because of the table changes in the new DB. Not sure how simple the new ones are, tbh I cant be arsed lol

[Illidan1]

Could some one link me 2 NCDB 710 please, so i can keep up to date

[Steph]

http://www.mmowned.com/forums/emulat...-compiles.html

Link in there matey.

[~SaiLyn~]

Steph this is easy fix, look what the error said is this

 INSERT INTO `vendors` VALUES ('1000044', '32883', '200');

Just change it to this

 INSERT INTO `vendors` VALUES ('1000044', '32883', '200', '0');

So just do the same thing to all the ones that are missing the '0' at the end , so it should be a total of 4 numbers instead of 3