user_delete()
function performs operations on the following tables:
Well, not only.
https://phpbbstudio.com/viewtopic.php?f=11&t=372Tony Berry wrote: ↑Wed Dec 01, 2021 11:27 pm ...
What would be a safe SQL statement to run to basically delete a user by user_id and all posts related to that user_id?
...
No probs. I was thinking about an array of example 5.000 IDs... perhaps you may want to chunk that array into arrays and send them to the loop so to avoid any kind of issues. See array_chunk in this case, any questions? Post at our site right in the devoted topic, I will be more than glad to assist you.Tony Berry wrote: ↑Thu Dec 02, 2021 5:17 pm Thanks 3Di... and I absolutely adore your avatar. Huge, old school, fan of the Commodore. I have amassed an extensive collection of old Commodore's, most still in OEM retail boxes. I also have a few C-65 components.
I think you mean c-64 isn't? I do still have vic-20 and spectrum and what not... LOL.
This is based on the configuration forTony Berry wrote: ↑Wed Dec 01, 2021 11:27 pm The MCP only allows 50 posts at a time to be selected for deletion. Users I can do 999 at a time.
Topics per page:
under post settings. You can either change it temporarily which will affect entire forum or can edit includes/mcp/mcp_forum.php
which will only affect the MCP. Around line 116 find:Code: Select all
$topics_per_page = ($forum_info['forum_topics_per_page']) ? $forum_info['forum_topics_per_page'] : $config['topics_per_page'];
Code: Select all
// Mod - Set Custom number of topics to display in MCP
$topics_per_page = 300;
Very strange, instructions are clear.Tony Berry wrote: ↑Tue Dec 07, 2021 10:08 pm Sorry 3Di, I could never get your code to function. I did some PHP self-educating, but couldn't make it function. Likely an authentication issue with the database. Wasn't prompting and I wasn't feeding it manually. I still appreciate your suggestions and assistance.
...