Platinumwealth.co.za

I appreciate the responses, my requirement has changed, I pruned the users, it kept their content as guest (>1000 of orphans) I need a way to delete ALL guest content in one shot.

So I am out luck? Just like that. 6 years down the drain? Because there is no way on earth to delete guest posts? Am I reading the reply correctly, that I am on my own here. Unsure how this can be out of scope when it is an Inivison induced issue. And the fix is actually very straight forward as most of the functionality is there to do it. All I am asking is for my query to be sent to an actual developer, I understand not all of you are devs, so talking about SQL seems frightening, it really isn't.

I understand that Matt, hopefully one of your experienced developers can run it for me if you do not want to expose raw SQL. Bottom line is, we need to figure out a way to delete all the guest posts.

Request Background: I pruned >1000s of users, their topics are now orphaned as guest posts. My Ask: May I please be given support or the SQL query needed to do the following: delete all the guest posts in one shot.

dude, I am 100% sure one of the devs have an SQL query locally for this as this is something that is extremely common by design. Instead of gaslighting your clients, can I ask you to please ask the developer team the following: Please provide a SQL query to delete all guest posts. It is already possible to delete guests posts WHERE the user is named, so all I am asking for is the SQL query without the WHERE clause for the name. Please. That is all I am asking, they will know what is needed and it will safe me literal months. Whatever Query is built here behind the scenes will help /** * Delete Guest Content * * @return void */ public function deleteGuestContent() { \IPS\Dispatcher::i()->checkAcpPermission( 'membertools_delete' ); $form = new \IPS\Helpers\Form; $form->add( new \IPS\Helpers\Form\Text( 'guest_name_to_delete', NULL, TRUE ) ); if ( $values = $form->values() ) { $classes = array(); foreach ( \IPS\Content::routedClasses( FALSE, TRUE ) as $class ) { if ( isset( $class::$databaseColumnMap['author'] ) and isset( $class::$databaseColumnMap['author_name'] ) ) { \IPS\Task::queue( 'core', 'MemberContent', array( 'member_id' => 0, 'name' => $values['guest_name_to_delete'], 'class' => $class, 'action' => 'delete' ) ); } } \IPS\Session::i()->log( 'acplog__deleted_guest_content', array( $values['guest_name_to_delete'] => FALSE ) ); \IPS\Output::i()->redirect( \IPS\Http\Url::internal( "app=core&module=moderation&controller=spam&searchResult=guest_captcha" ), 'deleted' ); } \IPS\Output::i()->output = $form; }

There is >1000 users who got pruned. This won't work. Please can they just connect in to my forum and run the required SQL query(s) to do this? As the GUI offers no functional features to fix it. There are over 1000 guests (pruned users) each with 1 to 5 posts and topics, >4000 orphaned posts. This will take months of manual work.

Thank you. Perfect (We do not allow guest posts, so this should be sufficient). Unsure what to fill in here, instinctively I want to enter "Guest", but knowing Invision I suspect the obvious instinct is the wrong one.

I appreciate it. This is now my only hope.

Client of >6 years and paid a lot of money to Invision over the years and this is how we part ways as I cannot fix this on my own.

Wow. I am so over this. Is there a way to delete all guest posts? Please god just give me the SQL queries then I can fix this headache of software. I don't know how on earth this is a function that passed QA. What even would be the purpose of this to deliberately introduce orphaned posts? Not a bug but a logical error on Invision's part, IMO. And the mess passed on to me is how it feels.

It's pruned the users, whatever that means, seems it did not delete the content associated with them like "flag as spammer" does. So now the spammer accounts are deleted but the content is still there.

Sweet, what does Prune do? Delete posts and the user? I suppose a "Flag as spammer" would be better otherwise they can just register again? EDIT: Now all of their posts show as "Guest" FML. What a useless function.

Can you share the SQL queries that are run when you press "Flag as Spammer" then I will create that function. The issue is >1000 spammers registered between January 2024 and March 2024 each only posting 1 to 10 replies. Manually flagging each one as spam will take months.

I don't see this option? Can you give the exact steps?

The above approach is not effective. I need a way to ban (apply the "flag as spammer") everyone in a specific date range