Hey guys, hi zanix & Co!

Just having an idea

I would love to also show the CRIT, DODGE, PARRY and BLOCK data on the indexalt.php.

Could anyone post the codechanges for that?

Thanks a lot!

Greetinx

Noone?

Zanix, Anthony? Someone?
Would be nice if someone could help me.
Can´t be a big thing cause all data is available in the DB.
(See char.php). Just wanna include that data (crit, dodge, parry and block) also on the indexalt.php

Help, Thank you!

You waited only 8 hours for an answer?
You are kinda impatient...

With that aside, it would not be hard at all to add these columns
Give me some time on this

I would love to see Spell crit chance in there along with +spell damage and healing as well

@Zanix:

Sorry for beeing impatient :smurfin:
Just thought you already had seen this and given no answer

Great, thx for helping and take your time. Waiting for the sourcechanges and send ya some :flower:

Greetinx

Chile wrote:I would love to see Spell crit chance in there along with +spell damage and healing as well

Good idea, but think this will be hard to realize.
I asked for Crit, dodge, parry and block because THIS DATA is already available in the database and used in char.php.

So its easy to also include it on the indexalt.php

yamyam wrote:

Chile wrote:I would love to see Spell crit chance in there along with +spell damage and healing as well

Good idea, but think this will be hard to realize.
I asked for Crit, dodge, parry and block because THIS DATA is already available in the database and used in char.php.

So its easy to also include it on the indexalt.php

Exactly

I know you gotta have a lot to do and many questions and support to do, but is there anything new for me Mr. Roster Zanix?

Open indexalt.php
Find

Code: Select all

$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`, ',
    "IF( `players`.`stat_armor_c` IS NULL OR `players`.`stat_armor_c` = '', 1, 0 ) AS 'aisnull', ",
    '`players`.`mitigation` ',
); 

Replace with

Code: Select all

$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`, ',
    "IF( `players`.`stat_armor_c` IS NULL OR `players`.`stat_armor_c` = '', 1, 0 ) AS 'aisnull', ",
    '`players`.`mitigation`, ',
    '`players`.`dodge`, ',
    "IF( `players`.`dodge` IS NULL OR `players`.`dodge` = '', 1, 0 ) AS 'disnull', ",
    '`players`.`parry`, ',
    "IF( `players`.`parry` IS NULL OR `players`.`parry` = '', 1, 0 ) AS 'pisnull', ",
    '`players`.`block`, ',
    "IF( `players`.`block` IS NULL OR `players`.`block` = '', 1, 0 ) AS 'bisnull', ",
    '`players`.`crit`, ',
    "IF( `players`.`crit` IS NULL OR `players`.`crit` = '', 1, 0 ) AS 'cisnull' ",
); 

---

Find

Code: Select all

$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',
    ),
); 

After Add

Code: Select all

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

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

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

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

This is even nice enough to be in 1.7.1

And so it shall be!

Zanix, your my hero!

And thx for taking my idea into 1.7.1.
Works fine and looks much better then before.

But i would like to add "%" after crit, dodge parry and block.
So it would be "24,67%" instead of "24,67". Whre do i have to do this?

Well, you would have to make a display function for them

Wouldn't be too hard I don't think, I'll try to whip something up

anyway we can get spell crit chance in there?

and maybe if you can be nice in the character profile too, i think its the char.php

you know where it says:

Crit:
Dodge:
Unused Talent Points:

so with it modded it will look like

Crit:
Dodge:
Parry:
Block:
Spell Crit:
Unused Talent Points:

that would rock just like you!

If it's in CP.lua, then it can go in
But if it's not, I don't have a clue how to do the calculation for it

ya i guess that wouldnt work if its not there...why doesnt blizzard tell us spell crit chance..seems lik it would be as easy as doing melee crit chance.

well...

Block and Parry should be in CP.lua

I remember on my warrior it would show me in the spell book. IT migh only be for warriors though...hmmm maybe only orc warriors too...it is there though