Hello there. I was hoping someone might have some info or links to
A: a way of showing resists unbuffed (e.g. fire and nature)
B: We're keeping track of new keys now aq etc... is there a mod'd key page that can help capture that?

Thanks, been a long time supporter.

well I knew i did this once before resists, wise
in the DB roster_players table are these fields. Not sure why there are 3 for each resist.

res_frost res_frost_c res_frost_b res_frost_d res_arcane res_arcane_c res_arcane_b res_arcane_d res_fire res_fire_c res_fire_b res_fire_d res_shadow res_shadow_c res_shadow_b res_shadow_d res_nature res_nature_c res_nature_b res_nature_d

I copied the indexalt.php and created a indexresists.php. I don't get what the number represents. it seems awfully low. Anyone know? Perhaps this is why we don't show resists in Roster?

Code: Select all

<?php
/******************************
 * WoWRoster.net  Roster
 * Copyright 2002-2006
 * Licensed under the Creative Commons
 * "Attribution-NonCommercial-ShareAlike 2.5" license
 *
 * Short summary
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/
 *
 * Full license information
 *  http://creativecommons.org/licenses/by-nc-sa/2.5/legalcode
 * -----------------------------
 *
 * $Id: indexresists.php 62 2006-06-14 22:26:47Z mathos $
 *
 ******************************/

require_once( 'settings.php' );

$header_title = $wordings[$roster_conf['roster_lang']]['alternate'];
include_once (ROSTER_BASE.'roster_header.tpl');


// Additional querries needed for this page
// Make sure the last item in this array DOES NOT have a (,) at the end
$additional_sql = array(
   '`players`.`health`, ',
   "IF( `players`.`health` IS NULL OR `players`.`health` = '', 1, 0 ) AS 'hisnull', ",
   '`players`.`mana`, ',
   "IF( `players`.`mana` IS NULL OR `players`.`mana` = '', 1, 0 ) AS 'misnull', ",
   '`players`.`money_g`, ',
   '`players`.`money_s`, ',
   '`players`.`money_c`, ',
   '`players`.`stat_armor`, ',
   '`players`.`stat_armor_c`, ',
   '`players`.`stat_armor_b`, ',
   '`players`.`stat_armor_d`, ',
   '`players`.`res_frost`, ',
   '`players`.`res_frost_c`, ',
   '`players`.`res_frost_b`, ',
   '`players`.`res_arcane`, ',
   '`players`.`res_arcane_c`, ',
   '`players`.`res_arcane_b`, ',
   '`players`.`res_arcane_d`, ',
   '`players`.`res_fire`, ',
   '`players`.`res_fire_c`, ',
   '`players`.`res_fire_b`, ',
   '`players`.`res_fire_d`, ',
   '`players`.`res_shadow`, ',
   '`players`.`res_shadow_c`, ',
   '`players`.`res_shadow_b`, ',
   '`players`.`res_shadow_d`, ',
   '`players`.`res_nature`, ',
   '`players`.`res_nature_c`, ',
   '`players`.`res_nature_b`, ',
   '`players`.`res_nature_d`, ',
   "IF( `players`.`stat_armor_c` IS NULL OR `players`.`stat_armor_c` = '', 1, 0 ) AS 'aisnull', ",
   '`players`.`mitigation` ',
);

$FIELD[] = array (
   'name' => array(
      'lang_field' => 'name',
      'order'    => array( '`members`.`name` ASC' ),
      'order_d'    => array( '`members`.`name` DESC' ),
      'required' => true,
      'default'  => true,
      'value' => 'name_value',
   ),
);

$FIELD[] = array (
   'class' => array(
      'lang_field' => 'class',
      'divider' => true,
      'divider_value' => 'class_divider',
      'order'    => array( '`members`.`class` ASC' ),
      'order_d'    => array( '`members`.`class` DESC' ),
      'default'  => true,
      'value' => 'class_value',
   ),
);

$FIELD[] = array (
   'level' => array(
      'lang_field' => 'level',
      'divider' => true,
      'divider_prefix' => 'Level ',
      'order_d'    => array( '`members`.`level` ASC' ),
      'default'  => true,
      'value' => 'level_value',
   ),
);

$FIELD[] = array (
   'health' => array (
      'lang_field' => 'health',
      'order' => array( 'hisnull','`players`.`health` DESC' ),
      'order_d' => array( 'hisnull','`players`.`health` ASC' ),
   ),
);

$FIELD[] = array (
   'mana' => array(
      'lang_field' => 'mana',
      'order' => array( 'misnull','`players`.`mana` DESC' ),
      'order_d' => array( 'misnull','`players`.`mana` ASC' ),
   ),
);

if( $roster_conf['show_money'] )
{
   $FIELD[] = array (
      'money_g' => array(
         'lang_field' => 'gold',
         'order' => array( '`players`.`money_g` DESC','`players`.`money_s` DESC','`players`.`money_c` DESC' ),
         'order_d' => array( '`players`.`money_g` ASC','`players`.`money_s` ASC','`players`.`money_c` ASC' ),
         'value' => 'money_value',
      ),
   );
}

$FIELD[] = array (
   'stat_armor_c' => array(
      'lang_field' => 'armor',
      'order' => array( 'aisnull','`players`.`stat_armor_c` DESC' ),
      'order_d' => array( 'aisnull','`players`.`stat_armor_c` ASC' ),
      'value' => 'armor_value',
   ),
);


$FIELD[] = array (
   'res_arcane_c' => array(
      'lang_field' => 'Arcane Res',
      'order' => array( 'misnull','`players`.`res_arcane_c` DESC' ),
      'order_d' => array( 'misnull','`players`.`res_arcane_c` ASC' ),
   ),
);

$FIELD[] = array (
   'res_fire_c' => array(
      'lang_field' => 'Fire Res',
      'order' => array( 'misnull','`players`.`res_fire_c` DESC' ),
      'order_d' => array( 'misnull','`players`.`res_fire_c` ASC' ),
   ),
);

$FIELD[] = array (
   'res_nature_c' => array(
      'lang_field' => 'Nature Res',
      'order' => array( 'misnull','`players`.`res_nature_c` DESC' ),
      'order_d' => array( 'misnull','`players`.`res_nature_c` ASC' ),
   ),
);

$FIELD[] = array (
   'res_shadow_c' => array(
      'lang_field' => 'Shadow Res',
      'order' => array( 'misnull','`players`.`res_shadow_c` DESC' ),
      'order_d' => array( 'misnull','`players`.`res_shadow_c` ASC' ),
   ),
);



include_once (ROSTER_BASE.'memberslist.php');

include_once (ROSTER_BASE.'roster_footer.tpl');
?>

This post does not belong in "WoWRoster.net"

Moving to appropriate forum "Roster > Code Help"

purplegold wrote:well I knew i did this once before resists, wise
in the DB roster_players table are these fields. Not sure why there are 3 for each resist.

res_frost res_frost_c res_frost_b res_frost_d res_arcane res_arcane_c res_arcane_b res_arcane_d res_fire res_fire_c res_fire_b res_fire_d res_shadow res_shadow_c res_shadow_b res_shadow_d res_nature res_nature_c res_nature_b res_nature_d

Ok, these are simple

Code: Select all

res_frost      base stat
res_frost_c    current
res_frost_b    buff amount
res_frost_d    debuff amount

Yes, I used the C because armor_C was used in the example I took from.

If i wanted their base values, or unbuffed, that includes armor, so I would want the frost_C ? Perhaps the numbers are so low because they are not taking into account their armor, or is it when character profiler gathers info they are not wearing their high resist armor?

This is a fairly coimmon thing that guilds do, look at resists and such, is there any plan to simply add this somewhere? I appreciate any enlightenment.