Mass edit reports

[Tom_]

I have 300 open reports waiting to change status to resolved. Is there any way to change all open reports status to resolved at once (phpmyadmin/mysql)?

 

[djbaxter]

@AndyB Approval Queue Tools

Approval queue tools

Premium upgrade: This XF2 add-on along with the entire collection can be purchased for $35.00 USD. Your Premium upgrade will allow you to download as many XF2 add-ons as you like for one year. Please see the entire collection located in the...

xenforo.com

 

[Tom_]

@AndyB Approval Queue Tools

Approval queue tools

Premium upgrade: This XF2 add-on along with the entire collection can be purchased for $35.00 USD. Your Premium upgrade will allow you to download as many XF2 add-ons as you like for one year. Please see the entire collection located in the...

xenforo.com

35, no thanks.

Hope that there is SQL-spell that do the magic.

 

[Mr Lucky]

35, no thanks.

That’s a good price for over 200 addons

 

[webbouk]

That works out at 11cents per open report resolved. Compare it to the time taken to resolve each report individually and it's a no-brainer

 

[djbaxter]

That’s a good price for over 200 addons

It's over 300 now and I think approaching 400 addons, all for that one price of $35USD.

That works out at 11cents per open report resolved. Compare it to the time taken to resolve each report individually and it's a no-brainer

No you're wrong. It doesn't. I can almost guarantee that there will be a few more you'll want to add once you have a subscription. Depending on the site, I think most of those forums I manage have probably 8-10 or more of @AndyB's addons installed (not necessarily the same ones — not necessarily the same 8-10 plus but that's what customization is all about.

 

[Tom_]

I dont care about Andyb's addons, is these some kind of advertisements?

SQL help is what i need.

 

[djbaxter]

No. Just trying to help you out. And operating directly on the database is a last resort -- too easy to accidentally trash your database.

But you do whatever you want to do. Juts try to do it politely. Nobody here is out to get you -- just to give you the best advice for your problem.

 

[nocte]

You can try at your own risk:

UPDATE xf_report SET report_state = 'resolved' WHERE report_state = 'open';

This will change the report state for all open reports to "resolved". You could also use "rejected".

After this you will need a new report and resolve it (you can create a dummy report), so the counters get updated.

I guess the database should be o.k. afterward, but again: try at your own risk!