[Release] Custom Vendors [Season 4 Vendor+Items]

[liesprivateserver]

ok i found the world database but what do i set it to? 127.0.0.1? cause when i do that then it says like cannot find path or whatever.

[pwner333]

so i downloaded it but....what folder do i extract the files into?

[lilbdiablo12]

Ok i got a question... what if i dont use navicat or blah blah blah? how do i do it then?

[Power of Illuminati]

Then you install navicat Lite Oo

[lilbdiablo12]

i dont use navicat though, i use mysql,ascent logon and ascent world... my DB is not in navicat... and not sql... i dont tihnk

[Power of Illuminati]

Navicat is a database editor, that is needed (or any other) for changing your DB

[lilbdiablo12]

ok, none of them are working for me, it says it cant find a colum or whatever....

[y2kss66]

you must use the right database structure yours is either too new or too old. and you will have to modify the columns. that is how I fixed it.

[lilbdiablo12]

hmmmm, ok, it says

[importing]starting importing venders
error1136 <21s01> : atline 202: Coloum count doesn't match value count at row 1.


how am i supposed to fix that?

[y2kss66]

you must add: ", '0', '0', '0', '0', '0', '0'" to creature_proto
edit: atleast that was for my server and they go at the end. but it depends on the database. I believe.

[lilbdiablo12]

0,0,0,0,0, on create_proto? so i have to edit to SQL file is what your saying?

[y2kss66]

0,0,0,0,0, on create_proto? so i have to edit to SQL file is what your saying?

yes that is right. atleast that is what I did.
or you can update your DB structure.

[lilbdiablo12]

ok im trying to do it manually and its says

[Err] 1054 - Unknown column 'max_amount' in 'field list'
[Err] Update `items` set `max_amount` = '0' where `entry` between '1' and '9999999';
[Msg] Finished - Unsuccessfully

[y2kss66]

alright then you have to delete the zero in the SQL that corresponds to that column.

[lilbdiablo12]

ok i deleted the 0 and its the same thing >.<