which PHP file contains posting sql function?

[kh99]

In includes/class_dm_threadpost.php, around line 1515 is class vB_DataManager_ThreadFirstPost, if you scroll down you see a $validfields array which I believe are the columns from the thread table. If you scroll down further you see this:

PHP Code:

    function vB_DataManager_Thread_FirstPost(&$registry, $errtype = ERRTYPE_STANDARD)
    {
        parent::vB_DataManager($registry, $errtype);

        ($hook = vBulletinHook::fetch_hook('threadfpdata_start')) ? eval($hook) : false;
    } 


which is executed when one of those objects is created, so if you create a plugin using hook threadfpdata_start, you should be able to add your fields to the $validfields array. Then in build_new_post() in includes/functions_newpost.php, you can see the fields being set. So you should be able to create a plugin using hook newpost_process and something like:

PHP Code:

if ($type == 'thread')
{
    $dataman->setr('price', $post['price']);
    // etc.
} 


(BTW, I haven't actually tried this).