Sort thread by results from Query

[DuNkLeArChOn]

Hey ,

I use vBulletin V 4.1.1 and have some problems with the sorting. I show in my threadbit the time&date of the modification of the first post of each thread.

here is the forumdisplay: https://vborg.vbsupport.ru/external/2011/03/19.jpg

"?nderung" = "modification" .. its german, i'am sorry

I have do this with the help of these plugin :

ob_start();
/*** CONTENT ************************************************** *************/
$firstthreadabfrage = $vbulletin->db->query("SELECT firstpostid FROM " . TABLE_PREFIX . "thread WHERE threadid = '" . intval($thread['threadid']) . "'"); // Query, firstpostid anfordern
$firstthreadabfragearray = array();
while($trow = $db->fetch_array($firstthreadabfrage))
{
$firstthreadabfragearray["$trow[id]"] = $trow[firstpostid];
}

for ($x = 0; $x < sizeof($firstthreadabfragearray); ++$x)
{
$fpid = current($firstthreadabfragearray);
// echo $fpid." / "; // Kontrollausgabe
}
//- - - - - - - - - - - - - - -
$editabfrage = $vbulletin->db->query("SELECT dateline FROM " . TABLE_PREFIX . "editlog WHERE postid='$fpid'"); // Query, edit-datum anfordern
$editabfragearray = array();
while($erow = $db->fetch_array($editabfrage))
{
$editabfragearray["$erow[id]"] = $erow[dateline];
}

for ($x = 0; $x < sizeof($editabfragearray); ++$x) // Ausgabe des Datums + Uhrzeit
{
$datum = date("d.m.Y",current($editabfragearray));
$uhrzeit = date("H:i",current($editabfragearray));
echo $datum," - ",$uhrzeit," Uhr";
}
/************************************************** *************************/
$includedphp = ob_get_contents();
ob_end_clean();

vB_Template::preRegister('threadbit',array('includ edphp' => $includedphp));




but my problem is to sort the Threads depending on this modification-date ... i don't know where i can find the sort-functions in the PHP-Files to edit them :erm:

[DuNkLeArChOn]

need help :-(