[neverstop]

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);