how to make offline shop & ....

[QQ1]

my sever l2j interlude
1- how can i make offline shop ?
2- how can i change some items to be sold with coins not adena ?
thanks for your help

[Chuliganas]

offline shops option is in config files. l2jmods.properties file.
to sell items for some coins and not adena, you can use multisell. If you want to use coins in private shops - that's impossible. Especially to use together with adena as another payment option.

[QQ1]

i had found this link for offline shop
http://l2topzone.com/forum/l2-java-proj ... hop-craft/
but i dont know about "SQl part" what to do with that part ?
which file i need to change it ??

[Chuliganas]

wow, you know how to execute core changes, but don't know what to do with sql files? seriously?...

[QQ1]

wow, you know how to execute core changes, but don't know what to do with sql files? seriously?...

i dont know the SQL file that i need to change it , can u plz tell me , may be it is easy but i didnt do it before !!

[Chuliganas]

sql files updates or creates database tables.
execute it with navicat. it will update tables where needed.