Query to add users URGENT

Need some custom code changes to the phpBB core simple enough that you feel doesn't require an extension? Then post your request here so that community members can provide some assistance.

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: NO OFFICIAL SUPPORT IS PROVIDED IN THIS SUB-FORUM
Post Reply
Smithgb
Registered User
Posts: 144
Joined: Sat Jun 13, 2015 11:17 am

Query to add users URGENT

Post by Smithgb » Tue Feb 13, 2018 9:52 am

Hello team. I urgently need the following SQL query to add people to their corensponding group (RU), if needed to assign its group perms and to add them in phpbb_users table. I have a list of several thousands users and I urgently need to add them. Thanks

User avatar
AmigoJack
Registered User
Posts: 5177
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Query to add users URGENT

Post by AmigoJack » Wed Feb 14, 2018 9:08 am

That would need you to know how to use newly inserted IDs in consecutive queries at least. Not to speak about how easily one can mess up with all metadata by doing things outside of phpBB. Consider using function user_add() in /includes/functions_user.php instead - with your own script it'd be also very easy to adjust timeout thresholds and run loops over "several thousands". You can look up on how /includes/ucp/ucp_register.php deals with creating accounts.
The worst thing about censorship is ███████████

Post Reply

Return to “phpBB Custom Coding”

Who is online

Users browsing this forum: JimA and 5 guests