You are OK up to the part where you want to create the new forum data – i.e, the post record. There is a little more to it than just writing to the one table.

i would suggest you take a look at the code file /simple-press/forum/library/sp-post.php. This sets everything up to create a new topic and/or post record. It goes through the major steps for you. If you check the data requirements you will be able to trace through the new post action.

This code obviously uses POST variables but it should be pretty straightforward to adapt it for, say, using an AJAX call for each record. That gets you over the timeout issue as well of course. The main thing is to fill the required values and then pass control over to the post class.

Could we do it? I have to say straight off that certainly not very quickly or soon…

Thank you… are there any freelancers that know SP well enough to do this that you would recommend?

I’m sorry – but to be perfectly honest I do not know anyone. We always hoped that one or two people might materialise and we do know that some people do perform some customisation work on their own site, but we have never been asked to keep anyones name for such queries.

I’m looking through simple-press/forum/library/sp-post.php but don’t see what data I need to put into what tables. I see the validation checks, and then the part where it says it is saving to the database, but not what data is being added to what tables….

Still studying it – 

You would need to look at the sp-api-class-post.php file (in sp-api folder) – at the top are the variable declarations that make up the ‘newpost’ array.

Actually forget that – I am being dumb.

Open up the file /librtary/sp-linking-comments.php.

Find the function sp_create_post_from_comment().

That function does what you want to do – saves a comment as a forum post. You wont be able to call it as is but you should be able to rewrite for your requirements.

That function almost looks like if I made an edit in a comment it should add that comment as a post to the forum if it’s linked. 

I edited a comment (from the wp admin) and it didn’t do anything though…. 

On a larger scale, I was wondering if I could ‘trick’ the script into thinking a number of comments were edited so I could enter a bunch at a time…. just brainstorming since I don’t quite understand the code enough to really know what it’s doing. I’m picking through it though and may be able to figure it out – 

Opps, I was looking at the function that followed the one you mentioned when I wrote that – sorry, don’t think that applies.

you dont think the function Andy provided will work??

It very well might…. it’s more that I’m not sure how to use it –

do you have a specific question?  or section that is not understood?

No, I don’t really have a starting point on how to use it.

If I would put it in a new script? and how to get the data to it….? 

As I said in post #2 – you were pretty much there up until the post save. The code I have pointed you to ensures that part of it is performs properly. Although I would add that one thing you did not say in post #1 was to ensure you tackle the comments in ID order as  the order they are saved in will be reflected in the forum topic sequence.

Ok, so I’m thinking I need to get the data from the comments table, then the sflinks table, and if there is a link, then I would use the function by feeding it the data? 

So, right now, I’m working on getting the comments data (that works). Then the information from sflinks…. but for some reason I’m not getting that information. 

Do you see what I am doing wrong here?  Thanks for your help ahead of time!

<?php 

//load wp

require_once(“wp-load.php”);

//get comments

$comments = $wpdb->get_results( $wpdb->prepare(“SELECT * FROM $wpdb->comments LIMIT 7”) );

foreach ($comments as $comment) {

$comment_post_ID = $comment->comment_post_ID;

//do I have the comments info?

echo $comment_post_ID.”<br />”; //YES!

 //find and get data from sflinks

$links = $wpdb->get_row( $wpdb->prepare( “SELECT * FROM $wpdb->sflinks WHERE post_id = $comment_post_ID” ) );

$link_info = $links->topic_id.”<br />”;

 //do I have the info from sflinks?

echo $link_info.”<br /><br />”; //NO

}

?>