easy way to create 500 forum topics?

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

I am use ing ravens 7.9
I want to create about 500 forum topics is there an easy way to just change a mysql table or something? I can click through the forum and manualy create but....would liek a time saver

thank you

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4615

Strange - RavenNuke is based on PHP-Nuke 7.6, and it's version hasn't passed 2.20.1 - did I miss something? Smile

Are you trying to convert these from another forum, or simply inserting 500 new forum topics? If you are converting, there may be scripts to help with that (see phpbb.com). If not converting, you might wish to look at the convert code to see how to generate the SQL to create the topic, first post, and associated tables. Unfortunately, it isn't just one table.

thundarfoot · Regular Joined: Jan 16, 2008 Posts: 75

Lol
Just inserting new topics...

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4615

Look at includes/functions_post.php, specifically at function submit_post (after it calls prepare_post).

It inserts records into these tables:
nuke_bbtopics
nuke_bbposts
nuke_bbposts_text

It's called from modules/Forums/posting.php, so you can see which parameters are used and how. Also, after submit_post, it executes additional functions:
update_post_stats
user_notification

As you can see, it isn't trivial. If you want to use the function to generate the records from a script, remember that determining the correct files to include can be quite a challenge. It might be easier to figure out what the SQL is doing and go from there.

Gremmie · Posted: Tue Feb 26, 2008 8:52 am

Here is an easy way to create 500+ forum topics. Change the permissions on your forums so that anyone can post. Come back in about a week.

Gremmie · Posted: Tue Feb 26, 2008 8:54 am

But seriously, if you are using RavenNuke, turn on that awesome new logging feature. Then create a post manually. Then go check the log and you'll see all the SQL that happened. Put that in a script and loop over it 500 times. Smile

kguske · Site Admin Joined: Jun 04, 2004 Posts: 4615

Nice...