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

Run SQL Query

Quiver

Active member
#1
Could someone please tell me how to do this:
http://xenforo.com/community/threads/query-help.31374/#post-358874

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
 

borbole

Well-known member
#2
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:
In that case, imho, it would be better if you posted a request at the request section for someone to code that for you.