vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Forum Statistics in FORUMDISPLAY (https://vborg.vbsupport.ru/showthread.php?t=60075)

Boofo 02-16-2004 01:40 PM

Well, I hate to differ with you but all the information from the queries in my hack is 100% correct. It has been tested thoroughly. Yes, I am using the same cache type that I used for the forumhome stats cache hack. And my hack was completely rewritten for version 2 with the cache. It only uses 1 query when reading from the cache and 6 when writing to it at the preset time. So, if queries is a big issue for anyone (and on bigger boards it usually is), then my hack will save them that. ;)

SpeedStreet 03-11-2004 12:49 AM

Can you install this hack on a per forum basis?

Gio Takahashi 03-21-2004 09:46 AM

Quote:

Originally Posted by SpeedStreet
Can you install this hack on a per forum basis?

Seems that this one may not be compatible with Gold. Had problem installiong this. Get a blank white page when I Try to do this:

Code:

Then find :


*********************************************************************
$show['forumdescription'] = iif ($foruminfo['description'] != '', true, false);
$show['forumsearch'] = iif ($forumperms & CANSEARCH, true, false);
$show['forumslist'] = iif ($forumshown, true, false);
$show['stickies'] = iif ($threadbits_sticky != '', true, false);

eval('print_output("' . fetch_template('FORUMDISPLAY') . '");');
*********************************************************************


and add above :


*********************************************************************
// STATS DU FORUM par Grog6 pour VBulletinDev
$sujets=$DB_site->query_first("$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues
FROM " . TABLE_PREFIX . "thread
WHERE forumid = $forumid
GROUP BY forumid
ORDER BY dateline DESC");
$nb_vues = vb_number_format($sujets['vues']);");
$nb_vues = vb_number_format($sujets['vues']);

$moyenne = $DB_site->query_first("SELECT AVG(votetotal/votenum) AS votes FROM " . TABLE_PREFIX . "thread where forumid=$forumid AND votenum<>0");
$moyenne['votes'] = vb_number_format($moyenne['votes']);
$moyenne['votes'] = "<img src=\"images/rating/rating_$moyenne[votes].gif\" alt=\"Vote : $moyenne[votes]\">";

$meilleur = $DB_site->query_first("SELECT " . TABLE_PREFIX . "user.userid, " . TABLE_PREFIX . "user.username, COUNT(" . TABLE_PREFIX . "post.postid) AS postcount FROM " . TABLE_PREFIX . "post LEFT JOIN " . TABLE_PREFIX . "thread ON (" . TABLE_PREFIX . "post.threadid=" . TABLE_PREFIX . "thread.threadid) LEFT JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "post.userid=" . TABLE_PREFIX . "user.userid) WHERE " . TABLE_PREFIX . "thread.forumid=$forumid GROUP BY " . TABLE_PREFIX . "post.userid ORDER BY POSTCOUNT DESC LIMIT 1");
$meilleur['postcount'] = vb_number_format($meilleur['postcount']);

$sujet = $DB_site->query_first("SELECT COUNT(open) AS ferme FROM " . TABLE_PREFIX . "thread WHERE forumid=$forumid AND open=0");

$forum = $DB_site->query_first("SELECT lastthread, lastposter, replycount, threadcount FROM " . TABLE_PREFIX . "forum WHERE forumid=$forumid");
  $forum['posts'] = ($forum['replycount'] - $forum['threadcount']);

  eval('$stats .= "' . fetch_template('forumdisplay_stats') . '";');
// STATS par Grog6
*********************************************************************


VBDev 03-21-2004 09:57 AM

@Gio : it should work but I haven't tested it on vb3 Gold, I'll have to modify all my hacks for Vb3 Gold ;)

It should be posted during the week

VBDev 03-24-2004 08:40 PM

Our team has opened its support forum.

Now we will make support on our forum

So if you want better support on our hacks go on our forum: http://www.vbulletindev.net/

There are not a lot of hacks for the moment but it will come.

Cya soon on our forum :)

OCH-Stan 06-15-2004 01:09 PM

I get this message: Parse error: parse error, unexpected T_STRING in /home/ochost/public_html/forum/forumdisplay.php on line 825. What's wrong??

EscortCossie 02-02-2005 03:01 PM

I'm sorry to bump this thread, but I still get a parse error when installing exactly as stated in this thread. (also the fix..)

vakvak 03-25-2005 02:57 AM

Quote:

Parse error: parse error, unexpected T_STRING in /home/pcteknik/public_html/fr2/forumdisplay.php on line 816
forumdisplay error help pls

vakvak 03-25-2005 05:46 PM

My FILES MODIFICATIONS
PHP Code:

// pre-cache templates used by specific actions
$actiontemplates = array(
    
'none' => array(
        
'FORUMDISPLAY',
        
'threadbit',
        
'threadbit_deleted',
        
'forumdisplay_announcement',
        
'forumhome_lastpostby',
        
'forumhome_forumbit_level1_post',
        
'forumhome_forumbit_level2_post',
        
'forumhome_forumbit_level1_nopost',
        
'forumhome_forumbit_level2_nopost',
        
'forumhome_subforumbit_nopost',
        
'forumhome_subforumseparator_nopost',
        
'forumdisplay_loggedinuser',
        
'forumhome_moderator',
        
'forumdisplay_moderator',
        
'forumdisplay_sortarrow',
        
'forumhome_subforumbit_post',
        
'forumhome_subforumseparator_post',
        
'forumrules'
        
,
                
'forumdisplay_stats'
    
)
); 







PHP Code:

    // mark a single forum as read as it appears all threads are read
    
set_bbarray_cookie('forum_view'$foruminfo['forumid'], TIMENOW);
}
construct_forum_rules($foruminfo$forumperms);

//remove html to stop the breaking of the meta description
$foruminfo['description'] = strip_tags($foruminfo['description']);

// STATS DU FORUM par Grog6 pour VBulletinDev
$sujets=$DB_site->query_first("$sujets=$DB_site->query_first("SELECT postusernameSUMviews )  AS vues
FROM 
" . TABLE_PREFIX . "thread
WHERE forumid 
$forumid
GROUP BY forumid
ORDER BY dateline DESC
");
$nb_vues = vb_number_format($sujets['vues']);");
$nb_vues vb_number_format($sujets['vues']);

$moyenne $DB_site->query_first("SELECT AVG(votetotal/votenum) AS votes FROM " TABLE_PREFIX "thread where forumid=$forumid AND votenum<>0");
$moyenne['votes'] = vb_number_format($moyenne['votes']);
$moyenne['votes'] = "<img src=\"images/rating/rating_$moyenne[votes].gif\" alt=\"Vote : $moyenne[votes]\">";

$meilleur $DB_site->query_first("SELECT " TABLE_PREFIX "user.userid, " TABLE_PREFIX "user.username, COUNT(" TABLE_PREFIX "post.postid) AS postcount FROM " TABLE_PREFIX "post LEFT JOIN " TABLE_PREFIX "thread ON (" TABLE_PREFIX "post.threadid=" TABLE_PREFIX "thread.threadid) LEFT JOIN " TABLE_PREFIX "user ON (" TABLE_PREFIX "post.userid=" TABLE_PREFIX "user.userid) WHERE " TABLE_PREFIX "thread.forumid=$forumid GROUP BY " TABLE_PREFIX "post.userid ORDER BY POSTCOUNT DESC LIMIT 1");
$meilleur['postcount'] = vb_number_format($meilleur['postcount']);

$sujet $DB_site->query_first("SELECT COUNT(open) AS ferme FROM " TABLE_PREFIX "thread WHERE forumid=$forumid AND open=0");

$forum $DB_site->query_first("SELECT lastthread, lastposter, replycount, threadcount FROM " TABLE_PREFIX "forum WHERE forumid=$forumid");
  
$forum['posts'] = ($forum['replycount'] - $forum['threadcount']);

   eval(
'$stats .= "' fetch_template('forumdisplay_stats') . '";');
// STATS par Grog6

$show['forumdescription'] = iif ($foruminfo['description'] != ''truefalse);
$show['forumsearch'] = iif ($forumperms CANSEARCH AND $vboptions['enablesearches'], truefalse);
$show['forumslist'] = iif ($forumshowntruefalse);
$show['stickies'] = iif ($threadbits_sticky != ''truefalse);

eval(
'print_output("' fetch_template('FORUMDISPLAY') . '");'); 


but
Parse error: parse error, unexpected T_STRING in /home/pcteknik/public_html/fr2/forumdisplay.php on line 816
help.. :ninja:

Elfo King 06-05-2005 12:41 PM

I have this error....

Quote:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in D:\Inetpub\wwwroot\forum\forumdisplay.php on line 822
This is line 822......

Quote:

$nb_vues = vb_number_format($sujets['vues']);


All times are GMT. The time now is 09:07 AM.

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.01229 seconds
  • Memory Usage 1,786KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete