Log in

View Full Version : Populate a subforum with each username as a threadtitle


mahz
01-08-2009, 03:50 PM
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
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
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 (http://www.vbulletin.com/docs/html/data_managers).