array("DeathKnight","Druid","Hunter","Mage","Paladin","Priest","Rogue","Shaman","Warlock","Warrior"), "de" => array("DeathKnight","Druide","Jäger","Magier","Paladin","Priester","Schurke","Schamane","Hexenmeister","Krieger"), "fr" => array("DeathKnight","Druide","Chasseur","Mage","Paladin","Prêtre","Voleur","Chaman","Démonistes","Guerrier") ); // produce class names $tpl->assign_vars(array( 'Caption_DeathKnight' => $wow_classes[LB_LANGUAGE][0], 'Caption_Druid' => $wow_classes[LB_LANGUAGE][1], 'Caption_Hunter' => $wow_classes[LB_LANGUAGE][2], 'Caption_Mage' => $wow_classes[LB_LANGUAGE][3], 'Caption_Paladin' => $wow_classes[LB_LANGUAGE][4], 'Caption_Priest' => $wow_classes[LB_LANGUAGE][5], 'Caption_Rogue' => $wow_classes[LB_LANGUAGE][6], 'Caption_Shaman' => $wow_classes[LB_LANGUAGE][7], 'Caption_Warlock' => $wow_classes[LB_LANGUAGE][8], 'Caption_Warrior' => $wow_classes[LB_LANGUAGE][9]) ); // build up member data and produce it for($e=0;$e<2;$e++){ for($i=0;$iconfig['hide_inactive'] == '1' ) $sql .= " AND member_status <> '0'"; $sql .= " ORDER BY member_current desc"; // add limit if set $sql .= " LIMIT 0,1"; if ( !($class_result = $db->query($sql)) ) { message_die('Could not obtain member information', '', __FILE__, __LINE__, $sql); } // produce output while ( $row = $db->fetch_record($class_result) ) { $tpl->assign_block_vars('classlist_row_'.strtolower($wow_classes['en'][$i]), array( 'NAME' => $row['rank_prefix'] . (( $row['member_status'] == '0' ) ? '' . $row['member_name'] . '' : '' . $row['member_name']) . '' . $row['rank_suffix'], 'CURRENT' => '' . $row['member_current'] . '', 'C_CURRENT' => color_item($row['member_current']), 'U_VIEW_MEMBER' => 'viewmember.php' . $SID . '&' . URI_NAME . '='.$row['member_name']) ); } }else{ $sql = "SELECT m.*, (m.member_earned-m.member_spent+m.member_adjustment) AS member_current, member_status, r.rank_name, r.rank_hide, r.rank_prefix, r.rank_suffix, c.class_name AS member_class, c.class_armor_type AS armor_type, c.class_min_level AS min_level, c.class_max_level AS max_level FROM " . MEMBERS_TABLE . " m, " . MEMBER_RANKS_TABLE . " r, " . CLASS_TABLE . " c WHERE c.class_id = m.member_class_id AND (m.member_rank_id = r.rank_id) AND c.class_name = '".$wow_classes[LB_LANGUAGE][$i]."' AND rank_hide = '0'"; // Are we hiding inactive members? if ( $eqdkp->config['hide_inactive'] == '1' ) $sql .= " AND member_status <> '0'"; $sql .= " ORDER BY member_current desc"; // add limit if set if (MAXLIST > 0) $sql .= " LIMIT 1,".MAXLIST; if ( !($class_result = $db->query($sql)) ) { message_die('Could not obtain member information', '', __FILE__, __LINE__, $sql); } // produce output while ( $row = $db->fetch_record($class_result) ) { $tpl->assign_block_vars('classlist_row_'.strtolower($wow_classes['en'][$i]), array( 'NAME' => $row['rank_prefix'] . (( $row['member_status'] == '0' ) ? '' . $row['member_name'] . '' : $row['member_name']) . $row['rank_suffix'], 'CURRENT' => $row['member_current'], 'C_CURRENT' => color_item($row['member_current']), 'U_VIEW_MEMBER' => 'viewmember.php' . $SID . '&' . URI_NAME . '='.$row['member_name']) ); } $db->free_result($class_result); }}} // produce faction //Jody: Was previously done by counting paladin/shaman, which doesnt work anymore. //So I removed the useless code and just set it hardcoded $tpl->assign_vars(array( 'S_ISALLIANCE' => true, 'S_ISHORDE' => false) ); } ?>