Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 03-15-2011, 12:29 PM
DuNkLeArChOn DuNkLeArChOn is offline
 
Join Date: Jan 2011
Location: Germany
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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:

"?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:
Reply With Quote
  #2  
Old 03-16-2011, 08:06 PM
DuNkLeArChOn DuNkLeArChOn is offline
 
Join Date: Jan 2011
Location: Germany
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

need help :-(
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:27 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03398 seconds
  • Memory Usage 2,159KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete