Jump to content

Recommended Posts

Hello Metin2 dev, e need help.

 

View the query:

SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name,guild.id AS guild_id
  FROM player.player
  LEFT JOIN player.player_index
  ON player_index.id=player.account_id
  LEFT JOIN player.guild_member
  ON guild_member.pid=player.id
  LEFT JOIN player.guild
  ON guild.id=guild_member.guild_id
  INNER JOIN account.account
  ON account.id=player.account_id
  WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
  ORDER BY player.level DES

 

i need  order take 99 by time,   in db log.levellog  to configure my ranking in php how to?

levellog.jpg

Link to comment
https://metin2.dev/topic/17596-query-ranking-player/
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Don't use any images from : imgur, turkmmop, freakgamers, inforge, hizliresim... Or your content will be deleted without notice...
Use : https://metin2.download/media/add/

Please use https://metin2.download/ when uploading files smaller than 100MB, otherwise the approval will take longer due to manual upload.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.