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

Run SQL Query

Discussion in 'XenForo Development Discussions' started by Quiver, May 12, 2013.

  1. Quiver

    Quiver Active Member

    Could someone please tell me how to do this:

    But from a XenForo addon (obviously we're talking PHP files here).
    The above code works fine in phpMyAdmin. But I'm looking, ideally, to create a cron job that runs once an hour and finds the top poster in that last hour using UNIX_TIMESTAMP or whatever it is that you use to limit searches based on time. Yes, I have no clue how to do what I'm trying to do, but I have a very good idea what I want the end result to be. ;)

    Please could someone help me do this in stages.
    STAGE ONE. Make a PHP file to display the top poster based on a preset time (forget the hourly function for now...say...midnight on whatever day, just make up a date I don't care what it is. LOL!)

    A heads up, I've read this file (both the 1st and the 2nd page).
    The code give there is partial code. I have no idea what to do with it.
    I'm a Windows developer and I'm familiar with C++ and C# but when it comes to working with PHP I am totally confused. It's like a completely different language to me. :confused: http://xenforo.com/community/threads/mysql-queries-how-to-use-db-in-xenforo-small-notes.5444/page-2
  2. borbole

    borbole Well-Known Member

    In that case, imho, it would be better if you posted a request at the request section for someone to code that for you.

Share This Page