Call SQLite Data on clientside?

[unknooooown]

Hi. The title of the topic pretty much expalins what my question is.

But what I want to know is, how can I call values from my SQLiteDatabase, in a clientside script?

I'm sure its possible to do somehow, but I would like to see an example or have someone explain to me how it works.

Thank you.

[Cyanide]

Since it's only a server-side function, you will need to use triggerServerEvent.

[unknooooown]

Could you show me an example of how you would do it? You dont need to show me a full working script, just enough to give me an idea of how you would do it.

[Cyanide]

Server:

  
function sql_query( ... )  
        executeSQLQuery( ... ) 
end 
addEvent( "sql_query", true ) 
addEventHandler( "sql_query", getRootElement(), sql_query ) 
  

Client:

  
function OnPlayerJoinServer( ) 
      triggerServerEvent( "sql_query", root, ... ) 
end 
  
addEventHandler("onClientPlayerJoin", getRootElement(), OnPlayerJoinServer ) 
  

The triple dots represent parameters. You can also check out the wiki's example.

[unknooooown]

The way you do it, its just gonna run all the values on the serverside isnt it?

What I want is some way to get the data from the database, and use it for something like eg. Gui on the clientside.

[eAi]

This is a REALLY bad thing to do. Giving clients direct access to run queries on your database leaves you incredibly vulnerable to anyone who manages to add their own script to their client. They can then delete everything in your database.

For the most part, if a function isn't available on the client, then there's a good reason - normally either security or performance.