• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Doubt Phpmyadmin Command

V

Vrotz

Member
Joined
Apr 7, 2011
Messages
1,071
Reaction score
7
Location
Brazil
Hi!

I have a doubt about phpmyadmin. Its possible use any command to reset the level of inactive players a few days?

I've many players inactives at level 80 and need reset to level 50! but just level.
 
Sort by date Sort by votes
It's hard to convert to a simple SQL query since the lastlogout row is stored as microtime. You could try this either through PHP as a cronjob launched according to a given time period, through the source or simply through LUA. What you need to do is to loop all the players, extract their individual lastlogout row and convert it from microtime to a date, compare it to the current date and then set their level (inject into the database).

Good luck

Ignazio
 
Upvote 0 Downvote
Back
Top