Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
Prev Previous Post   Next Post Next
  #4  
Old 08-05-2010, 01:21 AM
ArchAngelz ArchAngelz is offline
 
Join Date: May 2010
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Oh, I always thought PHP is the same whether in a widget or forum block; but I'm not a programmer so I don't really know.

Would you be able to help me change the following from a php execution widget to a php forum block; this is my immediate need right now...

PHP Code:
$posts "Posts";
  
ob_start();
  require_once(
'./includes/functions_user.php');
  require_once(
'./includes/functions_bigthree.php');
  
// Current Week Top Posters
  
$starttime mktime(000date('n'), date('j'), date('Y')) - ((date('N')-1)*3600*24);
  
// Get Top Members for current week
  
$mostactiveweek_get vB::$db->query_read("
    SELECT "
.TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle,
     COUNT("
.TABLE_PREFIX."post.postid) AS postcount
    FROM "
.TABLE_PREFIX."user
     LEFT JOIN "
.TABLE_PREFIX."post
      ON "
.TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid
       AND dateline>'"
.$starttime."'
    WHERE usergroupid=2
   GROUP BY "
.TABLE_PREFIX."user.userid
   ORDER BY postcount DESC
   LIMIT 5"
);
  
$topposter true;
  
$output_bits '';
  while(
$user vB::$db->fetch_array($mostactiveweek_get))
  {
        
$percentage round(($user[postcount]/$totalposts[postcount]) * 100);
        if(
$topposter == true)
        {
           
$avatarurl fetch_avatar_url($user[userid]);
           if (!
$avatarurl) {
               
$useravatar 'images/misc/avatar.png';
           } else  {
              
$useravatar $avatarurl[0];
           }
           
$output_bits .='<div align="center">
                           <img border="0" src="'
.$useravatar.'"><br />
                           <a target="_blank" href="member.php?u='
.$user[userid].'">'.$user[username].'</a><br />
                           '
.$user[usertitle].'<br />
                           '
.$posts.':&nbsp;'.$user[postcount].'<br />
                           </div><hr />'
;
           
$topposter false;
        } else {
           
$output_bits .= '<a target="_blank" href="member.php?u='.$user[userid].'">'.$user[username].'</a><div style="float: right;">'.$user[postcount].'</div><br />';
        }
  } 
Quote:
Originally Posted by Videx View Post
This should be a simple matter programmatically, but the problem right now is a lack of documentation. And the fact that little bits of code change with every update. But I have no doubt someone will figure it out eventually.
Reply With Quote
 

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 05:11 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.05368 seconds
  • Memory Usage 2,450KB
  • Queries Executed 12 (?)
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)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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