SQL database

[pidow 0]

Hello,

I need some information: is possible to a script to read a different SQL database than ragnarok.
I think like IPB database.
Do you think is possible ? how ?
Thx a lot !!

[Habilis 119]

Depends what this is needed for...

 

You can do it Habilis' way (not as efficient, but somewhat easier)

 

Habilis' way :

1. Well you can read a custom table (or  MySQL View) from your Ragnarok database
2. Create a mysql view in your Ragnarok database
3. reference the other database in this mysql view
4. Database user your Emulator uses should have access to SELECT (or whatever else you want to do) on that OTHER database...

 

Food for Thought (To inspire you):

 

http://stackoverflow.com/questions/674115/select-columns-across-different-databases

 

http://stackoverflow.com/questions/5698378/mysql-join-between-tables-in-2-different-databases

Edited April 17, 2017 by Habilis