Conan Exiles in SQL database

[fjamieson]

I ran the following query:

SELECT a.ip_address, a.game_port, b.*

FROM tc_game_services a, tc_game_service_live_stats b

WHERE a.service_id = b.service_id;

 

All the Conan Exiles servers we have running (23 of them) are showing ONLINE as "0", also the game_type is blank

 

Additionally: I have the query_protocol set to Half Life 2 new for Conan, the database shows "hl2s" but on another game like Arma3 I have the same query_protocol set but the database is showing "a2s"... confused.

 

(Side note: cannot get Conan to query, using the the "Game Query Tool" )

 

Thanks in advance for any assistance

[numpty]

I have Conan working fine. Share your config I'll look at it for you

[tmyrdal]

How did you resolve this m8 ?

Will have been cool if you share the sulusion I will have benn verry happy as I also have the same problem.

[numpty]

5 minutes ago, tmyrdal said:

How did you resolve this m8 ?

Will have been cool if you share the sulusion I will have benn verry happy as I also have the same problem.

that's all i have in the Query and RCon stuff and i queries perfectly fine

 

and a custom script to run before shutdown 

Script.WriteToConsole("^C");

 

that has not failed for me with over 200 conan servers

 

[tmyrdal]

numpty, how do you enter that script Im new to this script stuff, where can I enter inn that script ?

[numpty]

26 minutes ago, tmyrdal said:

numpty, how do you enter that script Im new to this script stuff, where can I enter inn that script ?

When you're editing the config on ledmft. If using mvc theme  you will see custom scriprs.. press that and create new... done 

[tmyrdal]

Dont work, the Conan server do not shutdown in a normal way.

Can see in the logg that noting is happend wbfore the server goes offline and I see that some things on the server will not be saved.

Lets say if you write something on a "sign" then that txt is not saved when we stop the server on normal tcadmin way. But if I write /shutdown inside the game the server will shutdown on the normal way.

But I cant manage to have tcadmin to do the same.

I can provide a logg of normal good way when the server shutdown and the log from the normal tcadmin way, I can give you that so you can see.

I can also give you access to my tcadmin if you can help out np

[numpty]

30 minutes ago, tmyrdal said:

Dont work, the Conan server do not shutdown in a normal way.

Can see in the logg that noting is happend wbfore the server goes offline and I see that some things on the server will not be saved.

Lets say if you write something on a "sign" then that txt is not saved when we stop the server on normal tcadmin way. But if I write /shutdown inside the game the server will shutdown on the normal way.

But I cant manage to have tcadmin to do the same.

I can provide a logg of normal good way when the server shutdown and the log from the normal tcadmin way, I can give you that so you can see.

I can also give you access to my tcadmin if you can help out np

In that script i gave with ctrl +c i think.. replace that with /shutdown see if that helps n fixes it as it will basically do exactly what u do ingame

On 4/1/2020 at 6:01 PM, tmyrdal said:

numpty, how do you enter that script Im new to this script stuff, where can I enter inn that script ?

When you're editing the config on ledmft. If using mvc theme  you will see custom scriprs.. press that and create new... done 

[tmyrdal]

I have tryed but dont work, Im not sure whats wrong with it hmm...

[tmyrdal]

Thanks for no respond for over haf a year lol, not hard to see people are only helping itself and do not share it all.

[numpty]

What do you mean I have given everything that is used in my config and it works perfectly shits down server perfectly and everything 

[tmyrdal]

lol sorry, it was on another topic lol, it was wrong place and I dident find athe delete post lol, it was nothing ment to you m8, Im verry thanksfull to you m8 lol

[tmyrdal]

I think your sulution works now I think its realy cool. But do you know how you get the game using mysql insted of the defualt one ? Do you know how I can get that working ? Is it any command line thing to get this working?

[numpty]

I think your sulution works now I think its realy cool. But do you know how you get the game using mysql insted of the defualt one ? Do you know how I can get that working ? Is it any command line thing to get this working?

I don't know if its possible I will look into it but I think the game is vocoder for redisdb...so you would need to re code the game but will look for you

Sent from my SM-G975F using Tapatalk

[tmyrdal]

On 7/18/2020 at 3:42 PM, numpty said:

I don't know if its possible I will look into it but I think the game is vocoder for redisdb...so you would need to re code the game but will look for you

Sent from my SM-G975F using Tapatalk
 

Verry cool of you can check it out, I will be verry thanksfull to you if you find anything.