Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions
Server setupMuEmu / LouisSeason 6 (Louis)

How do I make a working online time ranking per character?

✓ Confirmed by the topic starter
  1. Add an int column OnlineTime to the Character table (back up first).
  2. Create a SQL Agent job every minute: UPDATE Character SET OnlineTime=OnlineTime+1 joined to MEMB_STAT (ConnectStat=1) and AccountCharacter (Name = GameIDC).
  3. Read it with SELECT Name, OnlineTime FROM Character ORDER BY OnlineTime DESC. The value is in minutes.

The topic starter confirmed that this worked.

Original words (Spanish)

“@Louis , funcionou perfeitamente , só que está marcando minutos”

The topic starter, 2021-03-09 (original words)
CreandoMU · 2021-03-09
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.