SQL result

Generation Time: Jul 04, 2006 at 11:49 PM
Generated by: phpMyAdmin 2.8.0.3 / MySQL 5.0.18-standard-log
SQL query: SELECT `id` , `sRefName` , `rank_of_spell` , `desc_spell_window` , `desc_buff_window` , `iRefID_ChrClass_COL16` FROM `Spell` WHERE `iRefID_ChrClass_COL16` = 4 ORDER BY `id` ASC LIMIT 0, 50 ;
Rows: 50

id sRefName rank_of_spell desc_spell_window desc_buff_window iRefID_ChrClass_COL16
71 Defensive Stance   A defensive combat stance.  Decreases damage taken by $7376s1% and damage caused by $7376s2%.  Increases threat generated.   4
72 Shield Bash Rank 1 Bashes the target with your shield for $s2 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
78 Heroic Strike Rank 1 A strong attack that increases melee damage by $s1 and causes a high amount of threat.   4
100 Charge Rank 1 Charge an enemy, generate $/10;s2 rage, and stun it for $7922d.  Cannot be used in combat.   4
284 Heroic Strike Rank 2 A strong attack that increases melee damage by $s1 and causes a high amount of threat.   4
285 Heroic Strike Rank 3 A strong attack that increases melee damage by $s1 and causes a high amount of threat.   4
355 Taunt   Taunts the target to attack you, but has no effect if the target is already attacking you.   4
676 Disarm   Disarm the enemy's weapon for $d. Disarmed! 4
694 Mocking Blow Rank 1 A mocking attack that causes $s1 damage, a moderate amount of threat and forces the target to focus attacks on you for $d. Taunted. 4
772 Rend Rank 1 Wounds the target causing them to bleed for $o1 damage over $d. Bleeding for $s1 damage every $t1 seconds. 4
845 Cleave Rank 1 A sweeping attack that does your weapon damage plus $s1 to the target and his nearest ally.   4
871 Shield Wall   Reduces the damage taken from melee attacks, ranged attacks and spells by $s1% for $d. Damage reduced by $s1%. 4
1134 zzOLDInner Rage Rank 1 Warrior focuses on releasing $ghis:her; inner rage, gaining 30 rage.   4
1160 Demoralizing Shout Rank 1 Reduces the melee attack power of all enemies within $a1 yards by $s1 for $d. Reduces melee attack power by $s1. 4
1161 Challenging Shout   Forces all nearby enemies to focus attacks on you for $d. Taunted. 4
1464 Slam Rank 1 Slams the opponent, causing weapon damage plus $s1.   4
1608 Heroic Strike Rank 4 A strong attack that increases melee damage by $s1 and causes a high amount of threat.   4
1671 Shield Bash Rank 2 Bashes the target with your shield for $s2 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
1672 Shield Bash Rank 3 Bashes the target with your shield for $s2 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
1680 Whirlwind   In a whirlwind of steel you attack up to $i enemies within $a1 yards, causing weapon damage to each enemy.   4
1715 Hamstring Rank 1 Maims the enemy, causing $s1 damage and slowing the enemy's movement by $s2% for $d. Movement slowed by $s2%. 4
1719 Recklessness   The warrior will cause critical hits with most attacks and will be immune to Fear effects for the next $d, but all damage taken is increased by $s2%. Immune to Fear effects, most attacks do critical hits, but all damage taken is increased by $s2%. 4
2457 Battle Stance   A balanced combat stance.   4
2458 Berserker Stance   An aggressive stance.  Critical hit chance is increased by $7381s1% and all damage taken is increased by $7381s2%.   4
2565 Shield Block   Increases chance to block by $s1% for $d, but will only block $n $lattack:attacks;. Block increased by $s1% for next attack. 4
2687 Bloodrage   Generates $/10;s1 rage at the cost of health, and then generates an additional $/10;29131o1 rage over $29131d.  The warrior is considered in combat for the duration.   4
5242 Battle Shout Rank 2 The warrior shouts, increasing the melee attack power of all party members within $a1 yards by $s1.  Lasts $d. Increases your melee attack power by $s1. 4
5246 Intimidating Shout   The warrior shouts, causing the targeted enemy to cower in fear.  Up to $i total nearby enemies will flee in fear.  Lasts $d. Intimidated. 4
5308 Execute Rank 1 Attempt to finish off a wounded foe, causing $s1 damage and converting each extra point of rage into $*10;F1 additional damage.  Only usable on enemies that have 20% or less health.   4
6178 Charge Rank 2 Charge an enemy, generate $/10;s2 rage, and stun it for $7922d.  Cannot be used in combat.   4
6190 Demoralizing Shout Rank 2 Reduces the melee attack power of all enemies within $a1 yards by $s1 for $d. Reduces melee attack power by $s1. 4
6192 Battle Shout Rank 3 The warrior shouts, increasing the melee attack power of all party members within $a1 yards by $s1.  Lasts $d. Increases your melee attack power by $s1. 4
6343 Thunder Clap Rank 1 Blasts nearby enemies with thunder slowing their attack speed by $s2% for $d and doing $s1 damage to them.  Will affect up to $i targets. Attack speed reduced by $s2%. 4
6546 Rend Rank 2 Wounds the target causing them to bleed for $o1 damage over $d. Bleeding for $s1 damage every $t1 seconds. 4
6547 Rend Rank 3 Wounds the target causing them to bleed for $o1 damage over $d. Bleeding for $s1 damage every $t1 seconds. 4
6548 Rend Rank 4 Wounds the target causing them to bleed for $o1 damage over $d. Bleeding for $s1 damage every $t1 seconds. 4
6552 Pummel Rank 1 Pummel the target for $s1 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
6554 Pummel Rank 2 Pummel the target for $s1 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
6555 zzOLDPummel Rank 3 Pummel the target for $s1 damage.  It also interrupts spellcasting and prevents any spell in that school from being cast for $d.   4
6572 Revenge Rank 1 Instantly counterattack an enemy for $s1 damage and a high amount of threat.   Revenge must follow a block, dodge or parry.   4
6574 Revenge Rank 2 Instantly counterattack an enemy for $s1 damage and a high amount of threat.   Revenge must follow a block, dodge or parry.   4
6673 Battle Shout Rank 1 The warrior shouts, increasing the melee attack power of all party members within $a1 yards by $s1.  Lasts $d. Increases your melee attack power by $s1. 4
7369 Cleave Rank 2 A sweeping attack that does your weapon damage plus $s1 to the target and his nearest ally.   4
7372 Hamstring Rank 2 Maims the enemy, causing $s1 damage and slowing the enemy's movement by $s2% for $d. Movement slowed by $s2%. 4
7373 Hamstring Rank 3 Maims the enemy, causing $s1 damage and slowing the enemy's movement by $s2% for $d. Movement slowed by $s2%. 4
7379 Revenge Rank 3 Instantly counterattack an enemy for $s1 damage and a high amount of threat.   Revenge must follow a block, dodge or parry.   4
7384 Overpower Rank 1 Instantly overpower the enemy, causing weapon damage plus $s1.  Only useable after the target dodges.  The Overpower cannot be blocked, dodged or parried.   4
7386 Sunder Armor Rank 1 Sunders the target's armor, reducing it by $s1 per Sunder Armor and causes a high amount of threat.  Can be applied up to 5 times.  Lasts $d. Armor decreased by $s1. 4
7390 zzOLDTaunt Rank 2 Taunts the target to attack you, causing a medium amount of threat.  More effective than Taunt (Rank 1).   4
7391 zzOLDTaunt Rank 3 Taunts the target to attack you, causing a high amount of threat.  More effective than Taunt (Rank 2).   4