June 21, 2015 in Technical Problems
I had this setup with 3.4.7 in the SQL section of AdminCP but 4.0 doesn't have an SQL section.
I'm doing a weekly draw on my forum giving away $50 every week. To enter, members have to contribute 50 posts in the forum over the course of that week.
I need an SQL query that will generate a list of every member who posts 50 times or more in the forums from [starting date/time] to [ending date/time].
I've tried to figure it out but I'm not an SQL pro by any stretch.
If anyone could throw me in the right direction, I would be super grateful. Thanks!
Sure it does. It's just less obvious where it is. See the attached image. Click where I have highlighted. You then get the same SQL query box that we had before. Hope this helps.
Why in the world such a tiny link way over there lol? Unless it's to prevent people from accidently doing damage, wouldn't it have been better placed under the "Support" heading?
You just answered your own question. That's exactly why it is a tiny link way over there. Far more common than you can imagine, unfortunately.
Haha, I guess I did!
This topic is now archived and is closed to further replies.
Started July 29
Started 13 hours ago
Started 4 hours ago