- 0
MySql script (cant explain here what i need) take a look :)
-
Similar Content
-
- 0 answers
- 1001 views
-
***PLEASE HELP*** 2017-12-13 16:25:01 HiveExt: [Information] HiveExt 2017-12-13 16:25:01 HiveExt: [Critical] Cannot create database: Error loading database module: DatabaseMySql
By anster3333,
- cannot connect
- mysql
- (and 4 more)
- 11 answers
- 2329 views
-
- 7 answers
- 3708 views
-
- 1 answer
- 925 views
-
- 2 answers
- 1735 views
-
- Advertisement
Question
StiflersM0M
Hey :)
ok, at first i want to do a Mysql cleanup which delete old objects in the object_data table.
i use this script now on my server
that tie the playeruid on buildables instead of the characterID.
now i want to cleanup objects where the lastLogin is older than 7 days in the character_data table.
so the script should look in the character_data table , find the Characters who are older than 7 days, copy the PlayerUID from theese characters go into the object_data table and search for the PlayerUID in the characterID column and delete the complete row.
i hope you could understand what i want to do :)
would be awesome if someone could help me out :D
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now