Looks like you've got JavaScript disabled in your browser - you'll get a better site experience if you enable JavaScript

Tool For Cleaning up site?

The Jamroom Network » Forum » Suggestions » Page » Tool For Cleaning up site?

Zachary Moonshine
@zachary-moonshine
2 weeks ago
829 posts

My server is nearly maxed out again, and every day, I see hundreds of new signups—though many of them are spammers. I know there are tools to make signups more difficult to help reduce spam, but at this point, I really need to reverse some of the damage and clear out what's bloating my system.

The ideal tool for me would be one that allows me to delete all user accounts that have never opened a newsletter. I’ve noticed that the system can already identify these accounts when sending newsletters, as it gives me the option to target them. Since the system can recognize them, it seems logical to have a tool that could delete them based on that—or even other criteria.

Is this something that would be possible?

@michael
one week ago
7,792 posts

There's a delete button in the DATA BROWSER.

See if searching for

user_last_login:%

gets you the list of users you want.

Zachary Moonshine
@zachary-moonshine
one week ago
829 posts

What about this: "Users who have never viewed a Newsletter" ?

@michael
one week ago
7,792 posts

Yeah that would need to be a tool or a custom query. You'd need to get all the user ids from that recipient search into a csv structure 1,23,45,489,1248,..... then pass that to the user databrowser to deleted it there or run the same system from a custom module.

certainly possible. possibly there exists a way to do it already but more likely is coding is needed.

--edit--

The function to get all the ids from users who have not viewed is:
jrMailer_get_no_view_users()

That would give you all the user_id's. Need to look into the user browser to see if its possible to pass them in
updated by @michael: 02/23/25 11:03:56AM

Zachary Moonshine
@zachary-moonshine
6 days ago
829 posts

Thanks for looking into it. Its now at 99% capacity and I don't see an option to upgrade to a larger server so not sure what else to do at this point. Is that whats using up all the space or is it something else?

@michael
8 hours ago
7,792 posts

Here's a hack for you. You need a custom module or tweak an existing one. If you have the jrAudio module you can drop this into the index.php file if you dont have your own custom module. If you have a custom module use its name.
[code]
function view_jrAudio_junk($_post, $_user, $_conf)
{
$_uid = jrMailer_get_no_view_users();
$uid = implode(',', $_uid);
return '_item_id in ' . $uid . ':';
}

That will give you all the id's of users who have never viewed the mail.

Copy those id's into the data browser then you can use the bulk delete.