Server launcher showing age 0, player buildings are updated on every restart! HELP

Conan Exiles PC Discussion PC Bug Reports
, , , ,
45

Nice! Good job :slight_smile:

46

oh hey! Just to update everyone, day 11 (almost 12) since the fix with 0 as the entry. Everything is decaying as intended and stable. I really do think the db size is due to individual decay entries.

47

Hi, is the latest update fix this for everyone without applying the fix yourself?

48

possibly? I guess you can check. If you didn’t apply it and you have that database record, then that’s a yes


49

Unfortunately still zero.

50

then use the script from above, easy :smiley:

51

Xevyr thank you for all your help on this subject. I was able to get your .bat file to work on a test server for Conan Exiles map. How ever I noticed it will not work when changing maps to Isle of Siptah. It brought it back to 0. I then tired to rerun the .bat file and it won’t work. Any help would be greatly appreciated thanks.

52

That’s because Isle of Siptah uses a different database and we’re talking about a change in the database itself.
It’s also why the db in that script is already created as a variable so you can just change it there.

“set db_file=“game.db””

Basically change that line so you have the Siptah database file, “DLC_Siptah.db” instead of “game.db”

53

Your awesome Xevyr thank you for the quick reply. I changed the game.db to DLC_Siptah.db and all is working. I got the 1 day age on my test server. So when I get time I will do it to our active server. Just wanted to thank you again as this will help keep our server running better with a working decay system.

54

This script helped me too, thank you!

My host does not allow to upload bat files so i had to work around a bit.

Here how i did it - from noob for noobs :smiley:
Stopped my game server.
Downloaded my servers game.db and moved it into my single player ConanSandbox/Saved folder so it loads my servers save file on single player (make a backup from ur single player first if you play there lol). Then i added the TimeFix.bat file to that Saved folder. Run the TimedFix.bat, copied the game.db file again and moved it back into my servers Saved folder. Started the server.
And its on Day 1 :slight_smile:

Thank you Xevyr :smiley:

55

How do you do it on console?
Gportal doesn’t have a clue

56

You can’t on console since you dont have access to the database

57

We have that problem on our custom map Saphirre Exile. Can we use the script for that too? Change the *.db name?

58

Yes! That’s why it’s up there as a variable so it’s easy to change :slight_smile:

59

C’est une blague?
C’est aux dĂ©veloppeurs Funcom de corriger au plus vite ce problĂšme, pas aux joueurs de la communautĂ©. De plus, c’est sur PS4 et PS5 que je signale ce problĂšme, pas sur PC donc ça m’aide pas du tout votre bidouillage sur PC.

60

Thank you. Your script was working well for our random server map Sapphire Exile. Server has startet with 1 day. Decay works again.

61

Following this method fixes the server day for me, but the decay timers continue to reset after every server restart. Adding the value into the serverruntime row after adding it does not correct itself for me. Whatever number I put in there stays. 3677564.48736522 put it at 42 days. Taking the advice of someone else and using 86400 it puts the server day to 1, and it counts as per normal from there, but neither fixes the decay timer issue.

Edit: I’ve also tried switching the serverruntime to 0 as someone else suggested. Still, while this change reflects the server time, it does not stop the decay timers from resetting after every server reset.

Interestingly, after a server reset, the timer on any building doesn’t even begin counting down until loaded in by a player walking by it. It’s like wave-particle duality in quantum mechanics, the decay timer doesn’t exist until observed, and then it begins all over
 lol

Since none of the solutions work here I made the following temporary solution at least so I can pull the information of when players last logged in, their names, and clan names, out of the db file and put it in a readable format in lieu of Unix time codes. It prints it to a .xlsx file that can be put on Google Sheets. The idea is you can let the people on your server cross reference it and help you find buildings that need to be wiped, and then you can delete them with them present so they can get the loot.

import sqlite3
import pandas as pd
import paramiko
import time


sftp_host = 'host here'
sftp_port = port here 
sftp_user = 'user here'
sftp_pass = 'pass here'  
remote_path = 'path to game.db here'
local_path = r"local path here"


transport = paramiko.Transport((sftp_host, sftp_port))
transport.connect(username=sftp_user, password=sftp_pass)

sftp = paramiko.SFTPClient.from_transport(transport)
sftp.get(remote_path, local_path)
sftp.close()
transport.close()


time.sleep(6)


conn = sqlite3.connect(local_path)


df = pd.read_sql('''
    SELECT characters.playerId, characters.char_name, guilds.name,
    CASE 
        WHEN characters.lastTimeOnline > 10000000000 THEN datetime(characters.lastTimeOnline/1000, 'unixepoch') 
        ELSE datetime(characters.lastTimeOnline, 'unixepoch') 
    END AS last_online
    FROM characters
    LEFT JOIN guilds ON characters.guild = guilds.guildId
    ORDER BY characters.lastTimeOnline ASC
''', conn)


df.to_excel(r"path to output here", index=False, engine='openpyxl')

conn.close()
62

I did it and now there are loads of spawns broken, a lot of nps stopped spawning and I keep getting errors

63

Haven’t found a more convenient solution?

64

In regards to this old bug? It was fixed a long time ago, and as far as solutions go I suppose you could edit the wipe date to anything you wanted in the database now.