Login     Sign up
admin stuff
tommy (@tommy)
Join date: Aug 24th 2010
Community posts: 38
View Profile
Send Message

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 :)

164 months ago
Ian (@eeji)
Join date: Aug 3rd 2010
Community posts: 107
View Profile
Send Message

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:

[code]SELECT username, email, ipaddress FROM jcow_accounts;[/code]

this will show you all your users, their email and the ip they registered from.

164 months ago
tommy (@tommy)
Join date: Aug 24th 2010
Community posts: 38
View Profile
Send Message

@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)

164 months ago