How to create a forum and topic manually through mysql query

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Xetal
Registered User
Posts: 4
Joined: Tue Sep 10, 2019 2:45 am

How to create a forum and topic manually through mysql query

Post by Xetal » Tue Sep 10, 2019 2:55 am

Hello there guys, how are you?

Sorry to bother, I searched for over an hour and I didn't find it anywhere.

I have a private phpbb forum.

Is there a way to create a forum and or topic straight from a mysql query inside phpmyadmin?
I know, people will ask, isn't it easy enough to just go to control panel and create a new forum? ...

Well, I want to be able to manipulate the forum from my c# app. I have a separate customer database with schedules, invoices, etc, and I want to be able to for example, create a forum named September 2019, and a topic callled 09 10 2019 Tuesday inside of sad forum for example.

Once I enter the customer into the schedule in my c# app, I want to be able to automate the whole process, rather than doing it manually.

Thank's so much guys!

User avatar
david63
Registered User
Posts: 16417
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: How to create a forum and topic manually through mysql query

Post by david63 » Tue Sep 10, 2019 10:04 am

Xetal wrote:
Tue Sep 10, 2019 2:55 am
Is there a way to create a forum and or topic straight from a mysql query inside phpmyadmin?
All things are possible, but necessarily practical.

You can create a script/extension that will do what you want but not via phpMyAdmin. Because of the way many of the tables in phpBB are interlinked just adding a forum or topic into one table will not be the complete picture. There are functions within phpBB that will do all/most of what you want.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
warmweer
Registered User
Posts: 2688
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: How to create a forum and topic manually through mysql query

Post by warmweer » Tue Sep 10, 2019 10:26 am

Xetal wrote:
Tue Sep 10, 2019 2:55 am
... inside of sad forum for example.
in phpBB It's prohibited to use sad forums :P (yeah I know it's a typo :mrgreen: )

As per david63, creating a forum includes many things e.g. giving it a parent (none, Category, forum or even subforum), setting group/user forum permissions , creating the topic, etc...), all these things would have to be taken into account in your SQL(s) for phpMyAdmin. It will most probably require a lot more time to figure out the SQLs than to do it manually (basically once you've got one forum set up exactly as you want it, making a new forum with the same permission settings is quite easy).
My board's not broken, it just went peculiar

Xetal
Registered User
Posts: 4
Joined: Tue Sep 10, 2019 2:45 am

Re: How to create a forum and topic manually through mysql query

Post by Xetal » Tue Sep 10, 2019 4:32 pm

Thank you guys for the quick response.

Sorry for the typo :D... hahaha sad forum. lol.

Do you know which files contain the create forum / topic procedures script by any chance?

I will spend the whole weekend on this, and once I get it to work, I will be happy to share it with you guys

User avatar
david63
Registered User
Posts: 16417
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: How to create a forum and topic manually through mysql query

Post by david63 » Tue Sep 10, 2019 5:50 pm

Xetal wrote:
Tue Sep 10, 2019 4:32 pm
Do you know which files contain the create forum / topic procedures script by any chance?
Off the top of my head I would start with function_posting.php
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50682
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to create a forum and topic manually through mysql query

Post by stevemaury » Tue Sep 10, 2019 6:12 pm

posting.php, includes/acp/acp_forums.php, and probably others.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

Post Reply

Return to “[3.2.x] Support Forum”