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. http://xenforo.com/community/threads/mysql-queries-how-to-use-db-in-xenforo-small-notes.5444/page-2