Smoke Posted May 30, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 34 Reputation: 8 Joined: 01/06/12 Last Seen: April 16, 2019 Share Posted May 30, 2012 Hello, Is it possible to use a data from a mysql database hosted on another vps via an npc script? somewhat like the way its possible with php. I'd just like to know this and if possible, how to do it. Thanks Quote Link to comment Share on other sites More sharing options...
Nameless2you Posted May 30, 2012 Group: Members Topic Count: 14 Topics Per Day: 0.00 Content Count: 351 Reputation: 52 Joined: 11/15/11 Last Seen: June 15, 2015 Share Posted May 30, 2012 If that's not the default sql db that you're using, as in the one where your servers gets it's login, char and other table contents from, then I highly doubt it. Quote Link to comment Share on other sites More sharing options...
Brian Posted May 30, 2012 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted May 30, 2012 No it's not possible. Scripts can only do SQL queries on the ragnarok and log databases defined in /conf/inter_athena.conf You can use query_sql to access other databases on the same host, as long as the rAthena MySQL user has privileges on those databases and in the SQL query you use the full `database`.`table` name. Quote Link to comment Share on other sites More sharing options...
Question
Smoke
Hello,
Is it possible to use a data from a mysql database hosted on another vps via an npc script? somewhat like the way its possible with php.
I'd just like to know this and if possible, how to do it.
Thanks
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.