NPC script to access Database

[rans]

Is it possible to access database from npc script? i know yes if you are going to access the localhost
but i'm talking about other server for example i have vote_points table on other host and i wanted it to be access by server2(this is from different host). what code should i use? or is it even possible?

 

[bWolfie]

yup. the answer is query_sql() script command. 

https://github.com/HerculesWS/Hercules/blob/master/doc/script_commands.txt#L8237

 

[rans]

yup. the answer is query_sql() script command. 

https://github.com/HerculesWS/Hercules/blob/master/doc/script_commands.txt#L8237

the query_sql script command is only referring to the main database. 
i wanted to use a query_sql that will refer to other host/server's database.

 

[bWolfie]

well sure but thats not RO related. you need to go to a linux forum and ask about remote ssh access, shell scripts and stuff. i doubt anyone here can answer your question about it. because what it seems you need is automated script performing SQL funcitons.

 

[rans]

no no no, 
what i aim here is RO related. 
see this is my situation. Server 1 (Login,char,map) and i have Server 2 (char, map) this setup is dual server using 1 login-server
so what i aim to do is make the vote_points table (from database of server 1) be accessible to Server 2 npc script (which is from different host)

I hope you get what i'm trying to do.

 

[benching]

You cant,

But you can implement that feature.