| DuNkLeArChOn |
03-15-2011 12:29 PM |
Sort thread by results from Query
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 :
Code:
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('includedphp' => $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: |
More Information