[cevou]

Until it's implemented I wrote a code snippet, that copies threads into project tools.

PHP Code:

<?php

    //MySQL Server-Data
    $server = "localhost";
    $db        = "db";
    $user    = "user";
    $pass    = "pass";
    
    $fromforum = 19;
    $saveastype = "bug";
    $projectid = 1;
    
    //Create connection and connect
    $conn = mysql_connect($server,$user,$pass);
    
    //Select database
    mysql_select_db($db,$conn);
    
    $res = mysql_query("SELECT * FROM thread WHERE forumid=".$fromforum);
    
    while ($r = mysql_fetch_array($res)) {
        mysql_query("INSERT INTO pt_issue (projectid,issuetypeid,title,submituserid,submitusername,submitdate) 
        VALUES (".$projectid.",'".$saveastype."','".$r['title']."','".$r['postuserid']."','".$r['postusername']."','".$r['dateline']."')");
        $res2 = mysql_query("SELECT * FROM post WHERE threadid=".$r['threadid']." ORDER BY dateline");
        $issueid = mysql_insert_id();
        while ($r2 = mysql_fetch_array($res2)) {
            mysql_query("INSERT INTO pt_issuenote (issueid,dateline,pagetext,userid,username)
            VALUES ('".$issueid."','".$r2['dateline']."','".$r2['pagetext']."','".$r2['userid']."','".$r2['username']."')");
        }
        mysql_query("UPDATE pt_issue SET lastpost='".$r2['dateline']."', lastactivity='".$r2['dateline']."', lastpostuserid='".$r2['userid']."', lastpostusername='".$r2['username']."' WHERE issueid=".$issueid);
    }

?>