[powerful_rogue]

Hi Lynne,
This is what ive currently got at the moment. Ive been trying to work with the SQL queries in this thread, but no luck.

PHP Code:

<plugin active="1">
            <title>welcome thread upon registration</title>
            <hookname>register_activate_process</hookname>
            <phpcode><![CDATA[if ($vbulletin->options['wtur_active'] AND $vbulletin->options['wtur_activewhen'] == 0)
            {
    
    // Backend Files
    require_once('./global.php');
    require_once('./includes/class_dm.php');
    require_once('./includes/class_dm_threadpost.php');
    require_once('./includes/functions_databuild.php');

$threaddm =& datamanager_init('Thread_FirstPost', $vbulletin, ERRTYPE_ARRAY, 'threadpost');
$foruminfo = fetch_foruminfo($foruminfo['forumid']);
$threadinfo = array();
$vboptions =& $vbulletin->options;
$bbuserinfo    =& $vbulletin->userinfo; 
$username = htmlspecialchars_uni($vbulletin->userinfo['username']);  
$forumid = $vbulletin->options['wtur_fid'];
eval('$title1 = "' . addslashes($vbulletin->options['wtur_title1']) . '";');  
eval('$title2 = "' . addslashes($vbulletin->options['wtur_title2']) . '";');
eval('$title3 = "' . addslashes($vbulletin->options['wtur_title3']) . '";');
eval('$title4 = "' . addslashes($vbulletin->options['wtur_title4']) . '";');
$title = array("$title1", "$title2", "$title3", "$title4");
$rand_title = array_rand($title, 4);
$wtur_userids_get = explode(",", $vbulletin->options['wtur_postinguserid']);
$wtur_userids = $wtur_userids_get[array_rand($wtur_userids_get)];
$wtur_userid = fetch_userinfo($wtur_userids);
eval('$pagetext1 = "' . addslashes($vbulletin->options['wtur_content1']) . '";');
eval('$pagetext2 = "' . addslashes($vbulletin->options['wtur_content2']) . '";');
eval('$pagetext3 = "' . addslashes($vbulletin->options['wtur_content3']) . '";');
eval('$pagetext4 = "' . addslashes($vbulletin->options['wtur_content4']) . '";');
$pagetext = array("$pagetext1", "$pagetext2", "$pagetext3", "$pagetext4");
$rand_text = array_rand($pagetext, 4);
$wtur_posticons_get = explode(",", $vbulletin->options['wtur_posticon']);
$wtur_posticons = $wtur_posticons_get[array_rand($wtur_posticons_get)];
$allowsmilie = '1';
$visible = $vbulletin->options['wtur_moderate'];

$threaddm->set_info('forum', $foruminfo);
$threaddm->set_info('thread', $threadinfo);
$threaddm->setr('forumid', $forumid);
$threaddm->setr('userid', $wtur_userid['userid']);
$threaddm->setr('pagetext', $pagetext[$rand_text[0]]);
$threaddm->setr('title', $title[$rand_title[0]]);
$threaddm->set('iconid', $wtur_posticons['iconid']);
$threaddm->set('allowsmilie', $allowsmilie);
$threaddm->set('visible', $visible);


$threaddm->pre_save();
if(count($threaddm->errors) < 1)
{
    $threadid = $threaddm->save();
    unset($threaddm);
    build_thread_counters($threaddm);
}
 build_forum_counters($forumid);
 
 // update post count for user
    $posts = $vbulletin->db->query_first("
        SELECT posts
        FROM " . TABLE_PREFIX . "user
        WHERE userid = ".$wtur_userid['userid']."
    ");
    
    $newpostcount = $posts['posts'] + 1;
    
    $vbulletin->db->free_result($posts);
    
    $vbulletin->db->query_write("
        UPDATE " . TABLE_PREFIX . "user
        SET posts = ".$newpostcount."
        WHERE userid = ".$wtur_userid['userid']."
    ");  
 
 ]]>}</phpcode>
        </plugin>        
    </plugins>