Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
JustinWh Posted June 21, 2015 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
3DKiwi Posted June 21, 2015 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.
GrooveOnBeat Posted June 21, 2015 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?
Marcher Technologies Posted June 21, 2015 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.
GrooveOnBeat Posted June 21, 2015 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!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.