Sign in to follow this  
razoreqx

Achievements Hotfix with Clusters

Recommended Posts

Special thanks to Bdew for working out a quick band-aid for bug with malformed Achievement entries from cluster to login servers;

 

1. Backup Wurmplayers.db

2. Open in SQLite browser

3. open Execute SQL tab

4. Paste UPDATE ACHIEVEMENTS SET ADATE=datetime(ADATE/1000, 'unixepoch') WHERE ADATE NOT LIKE '%-%'

5. Hit the run button on same tab

6. Save changes

 

Note:  This will not prevent further corruption from new achievements being earned but it will fix the thousands of errors already created and prevents dropping or deleting the entries or other methods of DB cleanup.

 

 

  • Like 1

Share this post


Link to post
Share on other sites

Awsome, now i can fix my personal cluster, good work Razor

  • Like 1

Share this post


Link to post
Share on other sites

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