vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Manually Adding Forums (https://vborg.vbsupport.ru/showthread.php?t=136957)

nathanmickler 01-19-2007 07:00 PM
Manually Adding Forums
 
For the website I'm developing, I need to manually add forums by directly modifying the MySQL database. Can anybody tell me which tables this will involve?

I know that it involves the forum table, but after adding an entry to this table, several things happen.

1. The new forum doesn't show up anywhere
2. When I directly access it by forumid my superadmin account is informed that it doesn't have the privildge to view the forum

Thanks in advance.

- Nathan

More development on this...

I've found out that the forum table is the only table I need to change, but manually adding to the forum table in the database doesn't update the webpages for some reason. However, if I manually add a forum by inserting into the forum table and then create a forum usign the admincp, it will then pick up and display the forum i added manually.

Does anybody know what function I need to call or how I can get the database change to be "picked up"?

JMH11788 01-20-2007 02:27 AM
Quote:
Originally Posted by nathanmickler (Post 1162951)
For the website I'm developing, I need to manually add forums by directly modifying the MySQL database. Can anybody tell me which tables this will involve?

I know that it involves the forum table, but after adding an entry to this table, several things happen.

1. The new forum doesn't show up anywhere
2. When I directly access it by forumid my superadmin account is informed that it doesn't have the privildge to view the forum

Thanks in advance.


- Nathan

More development on this...

I've found out that the forum table is the only table I need to change, but manually adding to the forum table in the database doesn't update the webpages for some reason. However, if I manually add a forum by inserting into the forum table and then create a forum usign the admincp, it will then pick up and display the forum i added manually.

Does anybody know what function I need to call or how I can get the database change to be "picked up"?
Sounds like the data is cached and won't update the display. IIRC the cached data is in the "datastore" table. You should be able to delete the correct row and it will work. BE VERY CAREFUL WITH THAT TABLE. YOU CAN AND WILL FUBAR YOUR FORUM IF YOU ARE NOT EXTREMELY CAREFUL. MY RECOMMENDATION IS TO SETUP A DUMMY FORUM IN ANOTHER DIRECTORY ON ANOTHER DATABASE AND PLAY WITH IT THERE.

JMH11788 01-22-2007 01:27 AM
Oh and just so you know the biggest danger with datastore is deleting a row. You can truncate the data column usually without any problems though, I do it all the time on the options row :p


All times are GMT. The time now is 11:42 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01580 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete