vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Populate a subforum with each username as a threadtitle (https://vborg.vbsupport.ru/showthread.php?t=201085)

mahz 01-08-2009 03:50 PM

Populate a subforum with each username as a threadtitle
 
I'm making a subforum where the only threads will be a thread for each user in the system (username as the threadtitle) and then other users can provide feedback for each user view thread replies.

What would be the best way to automatically populate a subforum with 3,000 threads (3,000 users) in this manner?

Dismounted 01-09-2009 04:02 AM

Quote:

Originally Posted by mahz (Post 1705261)
What would be the best way to automatically populate a subforum with 3,000 threads (3,000 users) in this manner?

Create a script to do it? :D I'm not sure what kind of answer you want here...

luki 01-09-2009 08:20 AM

I'd do this with SQL, I think it's the most efficient way.

Dismounted 01-09-2009 09:27 AM

You should use the data manager and do it in batches, otherwise you may get timeouts. You should not use pure SQL to do this, as there are more things to do when adding a thread than you think.

mahz 01-09-2009 05:10 PM

Quote:

Originally Posted by Dismounted (Post 1705901)
Create a script to do it? :D I'm not sure what kind of answer you want here...

I'm no scripter but where could I get started in learning how to write a script to do this? :o

Dismounted 01-11-2009 04:17 AM

Have a look in the Articles section and also at the Appendix in the vBulletin Manual.


All times are GMT. The time now is 02:36 PM.

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.01029 seconds
  • Memory Usage 1,717KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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