Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2004, 01:48 PM
Guy G Guy G is offline
 
Join Date: Nov 2004
Posts: 250
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default what am i doing wrong with this code?

PHP Code:
<?php 

// ### COLLAPSABLE ENABLING ######################################## 
 
$collapseobj_toposters $vbcollapse['collapseobj_toprep'];
$collapseimg_toposters $vbcollapse['collapseimg_toprep'];


$top_stats = array(); 
// TOP REPUTATIONists 
$top_rep $DB_site->query("SELECT * FROM ".TABLE_PREFIX."user ORDER BY reputation DESC LIMIT 10"); 
while(
$top_rep $DB_site->fetch_array($top_rep)) 
unset(
$top_rep); 
$DB_site->free_result($top_rep);

eval(
'$top_stats[\'top_rep\'] .= "' fetch_template('toprep') . '";');

eval(
'$home[$mods[\'modid\']][\'content\'] = "' fetch_template('adv_portal_toprep') . '";'); 
?>
these are my templates:

toprep
PHP Code:
<li><span class="smallfont"><a href="member.php?u=$toprep[userid]">$toprep[username]</a> ($toprep[reputation])</span></li
adv_portal_toprep
PHP Code:
<table align="center" border="0" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]class="tborder"width="180px">
<
thead>
              <
tr
                      <
td class="tcat">
<
a style="float:$stylevar[right]href="#top" onclick="return toggle_collapse('toprep')"><img id="collapseimg_toprep" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_toprep.gif" alt="" border="0" /></a>

<
span class="smallfont"><b>$vboptions[blockbullet]<a href="$vboptions[bburl]/profile.php?$session[sessionurl]do=editlist"Top Reputations</a></b></span></td>
              </
tr>
              </
thead>
<
tbody id="collapseobj_toprep" style="$collapseobj_toprep">
              <
tr class="alt1"
                      <
td width="100%"><span class="smallfont">
$top_stats[top_rep]
                      </
td>
              </
tr>
</
tbody>
            </
table>
<
br /> 
suppose to show top 10 users with the most reputation... but doesnt for some reason..
Reply With Quote
  #2  
Old 12-17-2004, 05:31 PM
WetWired's Avatar
WetWired WetWired is offline
 
Join Date: Jun 2002
Location: Texas
Posts: 669
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, your first problem is that you destroy all the data before you try to display it.
Try replacing
Code:
$top_rep = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."user ORDER BY reputation DESC LIMIT 10"); 
while($top_rep = $DB_site->fetch_array($top_rep)) 
unset($top_rep); 
$DB_site->free_result($top_rep); 

eval('$top_stats[\'top_rep\'] .= "' . fetch_template('toprep') . '";');
with
Code:
$top_rep_res = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."user ORDER BY reputation DESC LIMIT 10"); 
while($top_rep = $DB_site->fetch_array($top_rep_res))
  eval('$top_stats[\'top_rep\'] .= "' . fetch_template('toprep') . '";'); 
$DB_site->free_result($top_rep_res);
Reply With Quote
Reply


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 04:02 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03489 seconds
  • Memory Usage 2,192KB
  • 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
  • (2)bbcode_code
  • (3)bbcode_php
  • (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