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

[Steph]

Ah, excellent, thanks Ascended, I havent had time to look at these yet.

All the current Malls etc will need this new addition - thats a lot of items lol.

[L'Lawliet]

nope still doesnt work
[Err] INSERT INTO `vendors` VALUES ('1000044', '2519', '200', '0');
[Err] 1136 - Column count doesn't match value count at row 1

[~SaiLyn~]

nope still doesnt work
[Err] INSERT INTO `vendors` VALUES ('1000044', '2519', '200', '0');
[Err] 1136 - Column count doesn't match value count at row 1

For the looks of it , you have more tables.... which database are you using in the first place ?

NCDB latest database works with this , as i tested it yesturday and NO Errors what so ever.

[~SaiLyn~]

Halo , Try this

this is the error you got

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



Try changing it to this

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

[L'Lawliet]

i did and i get this
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[Err] INSERT INTO `vendors` VALUES ('1000044', '30319', '200', ;

i am using NCDB 710 maybe because you have NCDB 706

[~SaiLyn~]

Well look at this

this is ur error

[Err] INSERT INTO `vendors` VALUES ('1000044', '30319', '200', ;


listen every single vendor should have this

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

- whats in red is what each item should have at the end

[~SaiLyn~]

First post updated with new download links

[Arugos]

I successfully added it to my DB and im using 710 , im gonna post the way i did it if you guys can rep me for doing it , im trying to get 5 reput so i can reput other people

[Arugos]

nvm guys i saw it already been posted

[Performer]

I got an Error...

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
[Err] );
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '29736', '21000');

[Steph]

Its because you are using a newer database than the vendors were designed for.

If you want to use the old vendors, use the old database.

You cant put a square block, into a round hole.

If you want to fix the error, you need to manually add the new table differences between the old vendor code and the new table layouts.

[Performer]

Eeehh cant be arsed to do that

[Steph]

Eeehh cant be arsed to do that

Then just sit on your ass until you get something for free then instead of whining.

[Performer]

Im not whining ill just make my own..

[Gooday]

This is on a new NCDB server

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
[Err] );
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '29736', '21000');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '29735', '21000');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '29024', '100');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '26045', '100');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '26044', '100');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '24581', '21000');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '24579', '21000');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '20560', '100');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '20559', '100');
[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `vendors` VALUES ('1000049', '20558', '100');
[Msg] Finished - Unsuccessfully
--------------------------------------------------