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

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-11-2009, 02:07 AM
neverstop neverstop is offline
 
Join Date: Jan 2007
Posts: 170
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Revisting an old thread here, and I will try and reword it better as my needs have changed slightly.

Basically I have some code outputs a list of users based on the column 'credits' in the 'user' table, ie:
PHP Code:
    ORDER BY credits DESC
    LIMIT 5 
I want to add numbers to the list of usernames:

1. exampleuserA
2. exampleuserB
3. exampleuserC


So I can add some sort of variable to my template like $user[count]. I want to be able to user conditionals like <if condition="$user[count] == 1 <span class="bigusername">exampleuserA</span></if>

I hope it makes more sense now.

PHP Code:
<?php
/* --------------------------------------------------
  [vB 3.7.3] Module CMPS Add Top Posters   1.3
  DarkFaCe- http://www.vbadvanced-turkiye.com

   Tested on:
   - vBulletin 3.7.x
   - vBadvanced CMPS v3.0.1
-------------------------------------------------- */

$count $mod_options['portal_topposter_count'];
$exclude_gid $mod_options['portal_topposter_exgid'];
$exclude_uid $mod_options['portal_topposter_exuid'];

// ### TOP STATS ############## TOP POSTERS ##########################
$top_stats = array();
$top_posters $db->query("
    SELECT user.userid, user.usergroupid,  usergroup.opentag, user.username, usergroup.closetag, user.lastpostid, user.credits
    FROM " 
TABLE_PREFIX "user, usergroup 
    WHERE user.usergroupid=usergroup.usergroupid 
    " 
iif(!empty($exclude_gid), "AND usergroupid NOT IN ($exclude_gid)") . "
iif(!empty($exclude_uid), "AND userid NOT IN ($exclude_uid)") . "
    ORDER BY credits DESC
    LIMIT 5
    "
);

while(
$top_poster $db->fetch_array($top_posters)){
      eval(
'$top_stats[\'adv_portal_topcredits_bit\'] .= "' fetch_template('adv_portal_topcredits_bit') . '";');
    }

$db->free_result($top_posters);

eval(
'$home[$mods[\'modid\']][\'content\'] = "' fetch_template('adv_portal_topcredits') . '";');

unset(
$top_poster,$top_posters,$top_stats,$count,$exclude_gid$exclude_uid$mod_options);
Reply With Quote
 


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 08:40 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.07912 seconds
  • Memory Usage 2,708KB
  • 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
  • (4)bbcode_code
  • (1)bbcode_html
  • (5)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (15)post_thanks_box
  • (15)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (15)post_thanks_postbit_info
  • (15)postbit
  • (15)postbit_onlinestatus
  • (15)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