extDB2 stat system setup arma 3 !

[doomnet 23]

Hello everyone !

 

I'm looking for someone who can help me setup extDB2 for my arma 3 server

I cannot use any examples from other servers, because its my own mod !

Also there is no example mission with extDB2

 

I had in the past stats system with arma2NET system with sqlite database, was very simple to use and to setup

that's not the case with extDB2 which have also sqlite support !

Today i have a Linux server and cannot use arma2NET anymore because its for windows servers, and is also very old and buggy !

So i need someone who can help me setup extDB2 with the already sqlite database calls i have in the mission to adapt them !

I search for a solution since 2 weeks cannot find an answer, i have now a database of 5000 players with broken stats system !

 

Cheers

 

 

[Guest]

All is explained on the github wiki.

https://github.com/Torndeco/extDB2/wiki

Exemples.

https://github.com/Torndeco/extDB2/tree/master/examples/sqf

[doomnet 23]

All is explained on the github wiki.

https://github.com/Torndeco/extDB2/wiki

Exemples.

https://github.com/Torndeco/extDB2/tree/master/examples/sqf

 

Yes i already read those pages but that doesn't help me at all !

I don't understand nothing how to use !

And the explanation how to use extDB2 with sqlite database support is missing

Don't understand how to setup extDB2 with sqlite database!

Do i have to just launch @extDB2 and setup the sqlite database ? no answer on how to do it

Do i need an msql database even with sqlite database ? no answer

example mission does not exist for extDB2, exists for extDB but does not support sqlite

Thank you for giving me the links but as i said i try a lot to setup and understand something since two weeks

I think i've been thru all the related pages on the internet without success !

 

So any help is welcome !

 

Cheers

[doomnet 23]

i just need to save in the database

 

ID

UID

XP

KILLS

DEATHS

Kill/Death Ratio

 

that's all

could someone provide me with an example mission with extDB2 and sqlite support for the stats ?

Thanks

[Guest]

https://github.com/Torndeco/extDB2/blob/master/extdb-conf.ini

[SQLite_Example]
Type = SQLite
Name = sqlite.db

minSessions = 1
; minSession Default Value = 1

;maxSessions = 4
; maxSession Default Value = number of Main->Threads
; 	You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
; 	idleTime is the time before a database session is stopped if not used. 
;	If Database Sessions are greater than minSessions

So you configure it here. Then the usage is exactly the same as MySQL (Idk about queries in sqlite but wathever) with database name being "SQLite_Example".

Then init the database etc...

"extDB2" callExtension "9:DATABASE:SQLite_Example";
"extDB2" callExtension "9:ADD:DB_CUSTOM_v5:1:exemple"; // depending on the method you want to use

[doomnet 23]

thanks for the effort but doesn't help me at all

i know how to configure the .ini file in extdb2.

i need and example query for the mission

 

get stat

save stat

 

etc...

 

If someone has an example mission with stats running with extDB2 and sqlite support would be nice !

[Guest]

thanks for the effort but doesn't help me at all

i know how to configure the .ini file in extdb2.

i need and example query for the mission

 

get stat

save stat

 

etc...

 

If someone has an example mission with stats running with extDB2 and sqlite support would be nice !

 

You mean that you need the sql queries ?

[doomnet 23]

yes exactly should be nice if someone can show me an example

 

of queries with player kills, deaths etc....
;)

[hoverguy 177]

yes exactly should be nice if someone can show me an example

of queries with player kills, deaths etc.... ;)

Will you use raw SQL or pre-cached statements?

Raw SQL (using sql_raw protocol) ->

_query = format ["UPDATE Players SET DeathCount='%1' WHERE PlayerID ='%2'",_deathCount,_uid];

// Insert code here to send query to db function

Pre-cached statement (using sql_custom_v2 protocol) ->

[updateDeathCount]
SQL1_1 = UPDATE Players
SQL1_2 = SET DeathCount = ? WHERE PlayerID = ?;
SQL1_INPUTS = 1, 2-STRING
Number of Imputs = 2

The to call it:

_query = format["updateDeathCount:%1:%2",_deathCount,_uid];

// Insert code here to send query to db function

[Guest]

1. Use pre cached statements.

2. Do you already have a database design ?

2.1 Yes ? Give it to me.

2.2 No ? Give me all the data you need to save. When and what do you need to save. What and when do you need to retrieve.

3. I want you to consider using a "real" database like MySQL (It still sucks a lot in terms of performance and sql standards.) which may be better than a file only db.

4. I'm assuming you have the sqf level to sort things out and store the less data possible.

[doomnet 23]

1. Use pre cached statements.

2. Do you already have a database design ?

2.1 Yes ? Give it to me.

2.2 No ? Give me all the data you need to save. When and what do you need to save. What and when do you need to retrieve.

3. I want you to consider using a "real" database like MySQL (It still sucks a lot in terms of performance and sql standards.) which may be better than a file only db.

4. I'm assuming you have the sqf level to sort things out and store the less data possible.

 

Yes

I don't know what you mean with pre cached statements, but anyway

I will give you an example mission i have with @arma2NET sqlite database that works !

 

thank you very much ! ;)

[ozdeadmeat 12]

Anyone know where the extDB2 wiki went? all i get is 404 errors.

[doomnet 23]

Anyone know where the extDB2 wiki went? all i get is 404 errors.

yes same here

[Guest]

Tornedeco closed the extDB2 repo. Take a look at the official thread.

sad ;(

[Arkensor 96]

Download extdb from here: https://dropfile.to/vMC3JgT

 

 

Regards Arkensor