Sign in to follow this  
Followers 0
FireStorm

How interact with exile DataBase

24 posts in this topic

5 hours ago, τĿ | Care Bear said:

Well with that exile.ini addition you'd be inserting data into account table :P

x)

Wow I must have been very tired !

No no, my "exile.ini" looks more like this:

[createAccountTests]
SQL1_1 = INSERT INTO tests SET account_uid = ?, name = ?
Number Of Inputs = 2
SQL1_INPUTS = 1,2

 

Share this post


Link to post
Share on other sites
Advertisement

Maybe you can post extdblogs too when your stuff ain't working.

 

Numer of Inputs = 2

[createAccountTests]
SQL1_1 = INSERT INTO tests SET account_uid = ?, name = ?
Number Of Inputs = 2
SQL1_INPUTS = 1,2

But only sending 1:

_playeruid = getPlayerUID player;
_playerID = format["createAccountTests:%1", _playeruid ] call ExileServer_system_database_query_insertSingle;

I'm pretty sure that's not working. Maybe go for:

_playerID = format["createAccountTests:%1:2%", getPlayerUID player, name player ] call ExileServer_system_database_query_insertSingle;
Edited by WURSTKETTE

Share this post


Link to post
Share on other sites

Hi! So I think I'm close. Here's what I put on:

sqf file executed by trigger in game:

_ProfileName = profileName;
_UidPlayer = getPlayerUID player;
_IdInfos = [_ProfileName, _UidPlayer];



_IdInfos call ExileServer_system_test_Init;

In the "ExileServer_system_test_Init.sqf":

private["_ProfileName", "_UidPlayer"];

_string = _this select 0;
_id = _this select 1;

format ["createAccountTests:%1:%2",_id, _string] call ExileServer_system_database_query_fireAndForget;

And at the bottom of "exile.ini" file:

[createAccountTests]
SQL1_1 = INSERT INTO tests SET account_uid = ?, name = ?
Number Of Inputs = 2
SQL1_INPUTS = 1,2

It's almost working. it's just that it doesn't get the variables "uid and playername" correctly because in the "test" table in the "account_uid" column it's an empty box and in the "name" column it's "Exile" which is inserted there.

I don't know why when i transfert "_ProfileName" and "_UidPlayer" it's replaced by: "Exile" and ""

Any leads ?

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.