1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

A simple mysql command

Discussion in 'XenForo Questions and Support' started by Mr.Smith, Nov 17, 2011.

  1. Mr.Smith

    Mr.Smith Member

    Can anyone help me with a simple mySQL command to grab 10 mod logs from the last 24 hrs from the xenforo DB?

    I just need to do a basic script so that the mods can see the logs themselves (only number of actions they have performed).

    thanks!
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This will return the number of mod log records from the last 24 hours:

    Code:
    SELECT COUNT(*)
    FROM xf_moderator_log
    WHERE log_date > UNIX_TIMESTAMP() - 24*60*60;
    
     
    EQnoble likes this.
  3. Mr.Smith

    Mr.Smith Member

    Thanks jake

    Could you make it a little more detailed with returning usernames and log numbers of individual mods?

    Thanks a lot :)
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This should do it:

    Code:
    SELECT user.username AS moderatorName, COUNT(*) AS count
    FROM xf_moderator_log AS modlog
    LEFT JOIN xf_user AS user ON (user.user_id = modlog.user_id)
    WHERE modlog.log_date > UNIX_TIMESTAMP() - 24*60*60
    GROUP BY modlog.user_id;
    
     
    EQnoble likes this.
  5. Mr.Smith

    Mr.Smith Member

    thanks Jake.

    any idea how do I add it on a xenforo page to show it to mods (only staff)?

    sorry I am a little new to this :)
     

Share This Page