admin stuff
tommy
Join date: Aug 25th 2010
Community posts: 38
View Profile
Send Message
+Follow
i need access to all members email addresses. i need to run this, as well as their IP address, through the "stop forum spam" database so i know my members are not spammers.

i also need the ability to edit / remove comments.

other than those two issues, i'm quite happy with jcow :)
Oct 10th 2010, 11:22 am
eeji
Join date: Aug 4th 2010
Community posts: 107
View Profile
Send Message
+Follow
its not possible from the admin panel sql query (note to devs: why does a query show no output???) but you can run this query directly in your database through phpmyadmin or similar:

SELECT username, email, ipaddress FROM `jcow_accounts`;


this will show you all your users, their email and the ip they registered from.
Oct 11th 2010, 3:33 am
tommy
Join date: Aug 25th 2010
Community posts: 38
View Profile
Send Message
+Follow
@eeji .. Thanks!

i didn't think to look into the db itself.. but yeah, everything i need is right there in plain sight under the _accounts table.

scrolling down a little further and i found the _comments table, solving my other issue as well.

-----------------------------------

Still, it would be nice to have these options built into the admin cp - mucking around in the db isn't a proper solution for todays "point and click" generation (no offense intended)
Oct 11th 2010, 8:49 am