RESISTS AND NEW KEYS

Here you can find plenty of help with your general coding needs and projects
If it is about a specific program, use the corresponding forum
DO NOT ask basic questions such as "How do I print a variable", use Google for that

RESISTS AND NEW KEYS

Postby purplegold » Sat Jul 22, 2006 11:18 pm

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.
Last edited by purplegold on Sat Jul 22, 2006 11:19 pm, edited 1 time in total.
purplegold
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:11 pm

Re: RESISTS AND NEW KEYS

Postby purplegold » Sat Jul 22, 2006 11:31 pm

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
purplegold
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:11 pm

RESISTS AND NEW KEYS

Postby purplegold » Sat Jul 22, 2006 11:48 pm

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');
?>
purplegold
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:11 pm

RESISTS AND NEW KEYS

Postby zanix » Sun Jul 23, 2006 12:25 am

This post does not belong in "WoWRoster.net"

Moving to appropriate forum "Roster > Code Help"
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: RESISTS AND NEW KEYS

Postby zanix » Sun Jul 23, 2006 12:26 am

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: RESISTS AND NEW KEYS

Postby purplegold » Mon Jul 24, 2006 7:02 am

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.
purplegold
WR.net Apprentice
WR.net Apprentice
 
Posts: 5
Joined: Sat Jul 22, 2006 11:11 pm


Return to General Code Help

Who is online

Users browsing this forum: No registered users and 0 guests

cron