JustinWh Posted June 21, 2015 Share Posted June 21, 2015 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!-Andrew Link to comment Share on other sites More sharing options...
3DKiwi Posted June 21, 2015 Share Posted June 21, 2015 I had this setup with 3.4.7 in the SQL section of AdminCP but 4.0 doesn't have an SQL section. 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. Link to comment Share on other sites More sharing options...
GrooveOnBeat Posted June 21, 2015 Share Posted June 21, 2015 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? Link to comment Share on other sites More sharing options...
Marcher Technologies Posted June 21, 2015 Share Posted June 21, 2015 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. Link to comment Share on other sites More sharing options...
GrooveOnBeat Posted June 21, 2015 Share Posted June 21, 2015 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! Link to comment Share on other sites More sharing options...
JustinWh Posted June 21, 2015 Author Share Posted June 21, 2015 Thanks brother! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.