include/spell_data.php

   1 <?php
   2 include_once("functions.php");
   3
   4 $gSpellEffect = array(
   5 '1'=>'Instakill',
   6 '2'=>'School damage',
   7 '3'=>'Dummy',
   8 '4'=>'Portal teleport',
   9 '5'=>'Teleport units',
  10 '6'=>'Apply aura',
  11 '7'=>'Environmental damage',
  12 '8'=>'Power drain',
  13 '9'=>'Health leech',
  14 '10'=>'Heal',
  15 '11'=>'Bind',
  16 '12'=>'Portal',
  17 '13'=>'Ritual base',
  18 '14'=>'Ritual specialize',
  19 '15'=>'Ritual activate portal',
  20 '16'=>'Quest complete',
  21 '17'=>'Weapon damage noschool',
  22 '18'=>'Resurrect',
  23 '19'=>'Add extra attacks',
  24 '20'=>'Dodge',
  25 '21'=>'Evade',
  26 '22'=>'Parry',
  27 '23'=>'Block',
  28 '24'=>'Create item',
  29 '25'=>'Weapon',
  30 '26'=>'Defense',
  31 '27'=>'Persistent area aura',
  32 '28'=>'Summon',
  33 '29'=>'Leap',
  34 '30'=>'Energize',
  35 '31'=>'Weapon percent damage',
  36 '32'=>'Trigger missile',
  37 '33'=>'Open lock',
  38 '34'=>'Summon change item',
  39 '35'=>'Apply area aura party',
  40 '36'=>'Learn spell',
  41 '37'=>'Spell defense',
  42 '38'=>'Dispel',
  43 '39'=>'Language',
  44 '40'=>'Dual wield',
  45 '41'=>'Jump',
  46 '42'=>'Jump2',
  47 '43'=>'Teleport units face caster',
  48 '44'=>'Skill step',
  49 '45'=>'Add honor',
  50 '46'=>'Spawn',
  51 '47'=>'Trade skill',
  52 '48'=>'Stealth',
  53 '49'=>'Detect',
  54 '50'=>'Trans door',
  55 '51'=>'Force critical hit',
  56 '52'=>'Guarantee hit',
  57 '53'=>'Enchant item',
  58 '54'=>'Enchant item temporary',
  59 '55'=>'Tamecreature',
  60 '56'=>'Summon pet',
  61 '57'=>'Learn pet spell',
  62 '58'=>'Weapon damage',
  63 '59'=>'Open lock item',
  64 '60'=>'Proficiency',
  65 '61'=>'Send event',
  66 '62'=>'Power burn',
  67 '63'=>'Threat',
  68 '64'=>'Trigger spell',
  69 '65'=>'Apply area aura raid',
  70 '66'=>'Create mana gem',
  71 '67'=>'Heal max health',
  72 '68'=>'Interrupt cast',
  73 '69'=>'Distract',
  74 '70'=>'Pull',
  75 '71'=>'Pickpocket',
  76 '72'=>'Add farsight',
  77 '73'=>'Untrain talents',
  78 '74'=>'Apply glyph',
  79 '75'=>'Heal mechanical',
  80 '76'=>'Summon object wild',
  81 '77'=>'Script effect',
  82 '78'=>'Attack',
  83 '79'=>'Sanctuary',
  84 '80'=>'Add combo points',
  85 '81'=>'Create house',
  86 '82'=>'Bind sight',
  87 '83'=>'Duel',
  88 '84'=>'Stuck',
  89 '85'=>'Summon player',
  90 '86'=>'Activate object',
  91 '87'=>'Wmo damage',
  92 '88'=>'Wmo repair',
  93 '89'=>'Wmo change',
  94 '90'=>'Kill credit',
  95 '91'=>'Threat all',
  96 '92'=>'Enchant held item',
  97 '93'=>'Summon phantasm',
  98 '94'=>'Self resurrect',
  99 '95'=>'Skinning',
 100 '96'=>'Charge',
 101 '97'=>'Summon all totems',
 102 '98'=>'Knock back',
 103 '99'=>'Disenchant',
 104 '100'=>'Inebriate',
 105 '101'=>'Feed pet',
 106 '102'=>'Dismiss pet',
 107 '103'=>'Reputation',
 108 '104'=>'Summon object slot1',
 109 '105'=>'Summon object slot2',
 110 '106'=>'Summon object slot3',
 111 '107'=>'Summon object slot4',
 112 '108'=>'Dispel mechanic',
 113 '109'=>'Summon dead pet',
 114 '110'=>'Destroy all totems',
 115 '111'=>'Durability damage',
 116 '112'=>'SPELL_EFFECT_112',
 117 '113'=>'Resurrect new',
 118 '114'=>'Attack me',
 119 '115'=>'Durability damage pct',
 120 '116'=>'Skin player corpse',
 121 '117'=>'Spirit heal',
 122 '118'=>'Skill',
 123 '119'=>'Apply area aura pet',
 124 '120'=>'Teleport graveyard',
 125 '121'=>'Normalized weapon dmg',
 126 '122'=>'SPELL_EFFECT_122',
 127 '123'=>'Send taxi',
 128 '124'=>'Player pull',
 129 '125'=>'Modify threat percent',
 130 '126'=>'Steal beneficial buff',
 131 '127'=>'Prospecting',
 132 '128'=>'Apply area aura friend',
 133 '129'=>'Apply area aura enemy',
 134 '130'=>'Redirect threat',
 135 '131'=>'SPELL_EFFECT_131',
 136 '132'=>'Play music',
 137 '133'=>'Unlearn specialization',
 138 '134'=>'Kill credit',
 139 '135'=>'Call pet',
 140 '136'=>'Heal pct',
 141 '137'=>'Energize pct',
 142 '138'=>'Leap back',
 143 '139'=>'Clear quest',
 144 '140'=>'Force cast',
 145 '141'=>'SPELL_EFFECT_141',
 146 '142'=>'Trigger spell with value',
 147 '143'=>'Apply area aura owner',
 148 '144'=>'SPELL_EFFECT_144',
 149 '145'=>'SPELL_EFFECT_145',
 150 '146'=>'Activate rune',
 151 '147'=>'Quest fail',
 152 '148'=>'SPELL_EFFECT_148',
 153 '149'=>'Charge 2',
 154 '150'=>'SPELL_EFFECT_150',
 155 '151'=>'Trigger spell 2',
 156 '152'=>'SPELL_EFFECT_152',
 157 '153'=>'Create pet',
 158 '154'=>'Unused',
 159 '155'=>'Titan grip',
 160 '156'=>'Enchant item prismatic',
 161 '157'=>'Create item 2',
 162 '158'=>'Milling',
 163 '159'=>'Allow rename pet',
 164 '160'=>'SPELL_EFFECT_160',
 165 '161'=>'Learn a Talent Specialization',
 166 '162'=>'Activate Spec',
 167 '163'=>'SPELL_EFFECT_163',
 168 );
 169
 170 $gSpellAuraName = array(
 171 '0'=>"NONE",
 172 '1'=>"Bind Sight",
 173 '2'=>"Mod Possess",
 174 '3'=>"Periodic Damage",
 175 '4'=>"Dummy",
 176 '5'=>"Confuse",
 177 '6'=>"Charm",
 178 '7'=>"Fear",
 179 '8'=>"Periodic Heal",
 180 '9'=>"Mod Attack Speed",
 181 '10'=>"Mod Threat",
 182 '11'=>"Taunt",
 183 '12'=>"Stun",
 184 '13'=>"Mod Damage Done",
 185 '14'=>"Mod Damage Taken",
 186 '15'=>"DAMAGE_SHIELD",
 187 '16'=>"Stealth",
 188 '17'=>"Stealth Detection",
 189 '18'=>"Invisibilily",
 190 '19'=>"Invisibilily Detection",
 191 '20'=>"Periodic Regenerate % of Total Health",
 192 '21'=>"Periodic Regenerate % of Total Mana",
 193 '22'=>"Mod Resistance",
 194 '23'=>"Periodic Trigger Spell",
 195 '24'=>"Perioic Energize",
 196 '25'=>"Pacify",
 197 '26'=>"Root",
 198 '27'=>"Silence",
 199 '28'=>"Chance to Reflect harmful Spells",
 200 '29'=>"Mod Stat",
 201 '30'=>"Mod Skill",
 202 '31'=>"Increase Speed",
 203 '32'=>"Increase Mounted Speed",
 204 '33'=>"Decrease Speed",
 205 '34'=>"Mod Maximum Health",
 206 '35'=>"Mod Maximum Power",
 207 '36'=>"Snapeshift",
 208 '37'=>"Immune Effect ",
 209 '38'=>"Immune State",
 210 '39'=>"Immune School",
 211 '40'=>"Immune Damage",
 212 '41'=>"Immune Dispel",
 213 '42'=>"Proc Trigger Spell",
 214 '43'=>"Proc Trigger Damage",
 215 '44'=>"Track Creatures",
 216 '45'=>"Track Resources",
 217 '46'=>"Mod Parry Skill",
 218 '47'=>"Mod Parry %",
 219 '48'=>"Mod Dodge Skill",
 220 '49'=>"Mod Dodge %",
 221 '50'=>"Mod Block Skill",
 222 '51'=>"Mod Block %",
 223 '52'=>"Mod Crit %",
 224 '53'=>"Periodic Leech",
 225 '54'=>"Mod Melee/Ranged Hit Chance",
 226 '55'=>"Mod Spell Hit Chance",
 227 '56'=>"Transform",
 228 '57'=>"Mod Spell Crit Chance",
 229 '58'=>"Increase Swim Speed",
 230 '59'=>"Mod Melee/Spell Damage Versus",
 231 '60'=>"Pacify and Silence",
 232 '61'=>"Scale",
 233 '62'=>"Periodic Health Funnel",
 234 '63'=>"Periodic Power Funnel",
 235 '64'=>"Periodic Power Leech",
 236 '65'=>"Haste - Spells",
 237 '66'=>"Feign Death",
 238 '67'=>"Disarm",
 239 '68'=>"Stalked",
 240 '69'=>"Absorbs Damage for School",
 241 '70'=>"EXTRA_ATTACKS",
 242 '71'=>"Mod Spell Crit",
 243 '72'=>"Mod Power Cost %",
 244 '73'=>"Mod Power Cost",
 245 '74'=>"Reflect Spells",
 246 '75'=>"Laungage",
 247 '76'=>"Far Sight",
 248 '77'=>"Mechanic Immunity",
 249 '78'=>"MOUNTED",
 250 '79'=>"Mod Damage Done %",
 251 '80'=>"MOD_PERCENT_STAT",
 252 '81'=>"SPLIT_DAMAGE_PCT",
 253 '82'=>"WATER_BREATHING",
 254 '83'=>"MOD_BASE_RESISTANCE",
 255 '84'=>"MOD_REGEN",
 256 '85'=>"MOD_POWER_REGEN",
 257 '86'=>"Create Item on Victim Death",
 258 '87'=>"Mod Damage Taken %",
 259 '88'=>"MOD_HEALTH_REGEN_PERCENT",
 260 '89'=>"Periodic Damage % Total Health",
 261 '90'=>"Mod Resist Chance",
 262 '91'=>"Mod Detect Range",
 263 '92'=>"PREVENTS_FLEEING",
 264 '93'=>"MOD_UNATTACKABLE",
 265 '94'=>"INTERRUPT_REGEN",
 266 '95'=>"Ghost",
 267 '96'=>"SPELL_MAGNET",
 268 '97'=>"Mana Shield",
 269 '98'=>"MOD_SKILL_TALENT",
 270 '99'=>"Mod Melee Attack Power",
 271 '100'=>"AURAS_VISIBLE",
 272 '101'=>"MOD_RESISTANCE_PCT",
 273 '102'=>"Mod Melee Attack Power Versus",
 274 '103'=>"MOD_TOTAL_THREAT",
 275 '104'=>"Water Walk",
 276 '105'=>"FEATHER_FALL",
 277 '106'=>"Hower",
 278 '107'=>"Add Flat Modifier",
 279 '108'=>"Add % Modifier",
 280 '109'=>"Add Cast on Target Trigger",
 281 '110'=>"Mod Power Regeneration %",
 282 '111'=>"Redirect % Damage to Caster",
 283 '112'=>"Override Class Scripts",
 284 '113'=>"Mod Ranged Damage Taken",
 285 '114'=>"Mod Ranged Damage Taken %",
 286 '115'=>"Mod Healing Taken",                       //  ???
 287 '116'=>"MOD_REGEN_DURING_COMBAT",
 288 '117'=>"MOD_MECHANIC_RESISTANCE",
 289 '118'=>"Mod Healing Taken %",
 290 '119'=>"SHARE_PET_TRACKING",
 291 '120'=>"UNTRACKABLE",
 292 '121'=>"EMPATHY",
 293 '122'=>"Mod Offhand Damage %",
 294 '123'=>"Mod Target Resistance",
 295 '124'=>"Mod Ranged Attack Power",
 296 '125'=>"Mod Melee Damage Taken",
 297 '126'=>"Mod Melee Damage Taken %",
 298 '127'=>"RANGED_ATTACK_POWER_ATTACKER_BONUS",
 299 '128'=>"MOD_POSSESS_PET",
 300 '129'=>"MOD_SPEED_ALWAYS",
 301 '130'=>"MOD_MOUNTED_SPEED_ALWAYS",
 302 '131'=>"Mod Ranged Attack Power Versus",
 303 '132'=>"Mod Maximum Energy %",
 304 '133'=>"Mod Maximum Health %",
 305 '134'=>"MOD_MANA_REGEN_INTERRUPT",
 306 '135'=>"Mod Healing Done",
 307 '136'=>"Mod Healing Done %",
 308 '137'=>"Mod Total Stat %",
 309 '138'=>"Haste Melee/Ranged",
 310 '139'=>"Force Reaction",
 311 '140'=>"Haste Ranged",
 312 '141'=>"Haste Ranged (Ammo)",
 313 '142'=>"MOD_BASE_RESISTANCE_PCT",
 314 '143'=>"MOD_RESISTANCE_EXCLUSIVE",
 315 '144'=>"Safe Fall",
 316 '145'=>"Charisma",
 317 '146'=>"Persuaded",
 318 '147'=>"ADD_CREATURE_IMMUNITY",
 319 '148'=>"Retain Combo Points",
 320 '149'=>"RESIST_PUSHBACK",
 321 '150'=>"MOD_SHIELD_BLOCKVALUE_PCT",
 322 '151'=>"TRACK_STEALTHED",
 323 '152'=>"MOD_DETECTED_RANGE",
 324 '153'=>"SPLIT_DAMAGE_FLAT",
 325 '154'=>"MOD_STEALTH_LEVEL",
 326 '155'=>"MOD_WATER_BREATHING",
 327 '156'=>"Mod Reputation Gained %",
 328 '157'=>"PET_DAMAGE_MULTI",
 329 '158'=>"MOD_SHIELD_BLOCKVALUE",
 330 '159'=>"NO_PVP_CREDIT",
 331 '160'=>"MOD_AOE_AVOIDANCE",
 332 '161'=>"MOD_HEALTH_REGEN_IN_COMBAT",
 333 '162'=>"POWER_BURN_MANA",
 334 '163'=>"MOD_CRIT_DAMAGE_BONUS_MELEE",
 335 '164'=>"164",
 336 '165'=>"MELEE_ATTACK_POWER_ATTACKER_BONUS",
 337 '166'=>"MOD_ATTACK_POWER_PCT",
 338 '167'=>"MOD_RANGED_ATTACK_POWER_PCT",
 339 '168'=>"Mod Damage Done Versus %",
 340 '169'=>"Mod Crit Damage Versus %",
 341 '170'=>"DETECT_AMORE",
 342 '171'=>"MOD_SPEED_NOT_STACK",
 343 '172'=>"MOD_MOUNTED_SPEED_NOT_STACK",
 344 '173'=>"ALLOW_CHAMPION_SPELLS",
 345 '174'=>"MOD_SPELL_DAMAGE_OF_STAT_PERCENT",
 346 '175'=>"MOD_SPELL_HEALING_OF_STAT_PERCENT",
 347 '176'=>"SPIRIT_OF_REDEMPTION",
 348 '177'=>"AOE_CHARM",
 349 '178'=>"Mod Debuff Resistance %",
 350 '179'=>"MOD_ATTACKER_SPELL_CRIT_CHANCE",
 351 '180'=>"Mod Spell Damage Versus",
 352 '181'=>"Mod Spell Crit Damage Versus",
 353 '182'=>"MOD_RESISTANCE_OF_INTELLECT_PERCENT",
 354 '183'=>"MOD_CRITICAL_THREAT",
 355 '184'=>"MOD_ATTACKER_MELEE_HIT_CHANCE",
 356 '185'=>"MOD_ATTACKER_RANGED_HIT_CHANCE",
 357 '186'=>"MOD_ATTACKER_SPELL_HIT_CHANCE",
 358 '187'=>"MOD_ATTACKER_MELEE_CRIT_CHANCE",
 359 '188'=>"MOD_ATTACKER_RANGED_CRIT_CHANCE",
 360 '189'=>"Mod Rating",
 361 '190'=>"Mod Faction Reputation Gain",
 362 '191'=>"Limit Movement Speed",
 363 '192'=>"Melee Haste",
 364 '193'=>"Melee Slow",
 365 '194'=>"MOD_DEPRICATED_1",
 366 '195'=>"MOD_DEPRICATED_2",
 367 '196'=>"Mod Cooldown",
 368 '197'=>"MOD_ATTACKER_SPELL_AND_WEAPON_CRIT_CHANCE",
 369 '198'=>"MOD_ALL_WEAPON_SKILLS",
 370 '199'=>"MOD_INCREASES_SPELL_PCT_TO_HIT",
 371 '200'=>"Mod Experience Earned %",
 372 '201'=>"Fly",
 373 '202'=>"IGNORE_COMBAT_RESULT",
 374 '203'=>"Mod Melee Critical Damage Taken",
 375 '204'=>"Mod Ranged Critical Damage Teken",
 376 '205'=>"205",
 377 '206'=>"MOD_SPEED_MOUNTED",
 378 '207'=>"MOD_INCREASE_FLIGHT_SPEED",
 379 '208'=>"MOD_SPEED_FLIGHT",
 380 '209'=>"MOD_FLIGHT_SPEED_ALWAYS",
 381 '210'=>"210",
 382 '211'=>"MOD_FLIGHT_SPEED_NOT_STACK",
 383 '212'=>"MOD_RANGED_ATTACK_POWER_OF_STAT_PERCENT",
 384 '213'=>"Mod Rage from Damage Dealt %",
 385 '214'=>"214",
 386 '215'=>"ARENA_PREPARATION",
 387 '216'=>"Haste Spells",
 388 '217'=>"Slow Spells ???",
 389 '218'=>"Haste Ranged",
 390 '219'=>"MOD_MANA_REGEN_FROM_STAT",
 391 '220'=>"MOD_RATING_FROM_STAT",
 392 '221'=>"221",
 393 '222'=>"222",
 394 '223'=>"223",
 395 '224'=>"224",
 396 '225'=>"DUMMY_3",
 397 '226'=>"Peridic Dummy",
 398 '227'=>"227",
 399 '228'=>"DETECT_STEALTH",
 400 '229'=>"Mod AOE Damage Taken",
 401 '230'=>"230",
 402 '231'=>"231",
 403 '232'=>"Mod Mechanic Duration",
 404 '233'=>"233",
 405 '234'=>"Mod Mechanic Duration not stack",
 406 '235'=>"Mod Mechanic Dispel Resist",
 407 '236'=>"236",
 408 '237'=>"MOD_SPELL_DAMAGE_OF_ATTACK_POWER",
 409 '238'=>"MOD_SPELL_HEALING_OF_ATTACK_POWER",
 410 '239'=>"MOD_SCALE_2",
 411 '240'=>"Mod Expertise",
 412 '241'=>"FORCE_MOVE_FORWARD",
 413 '242'=>"MOD_SPELL_DAMAGE_FROM_HEALING",
 414 '243'=>"243",
 415 '244'=>"COMPREHEND_LANGUAGE = 244",
 416 '245'=>"MOD_DURATION_OF_MAGIC_EFFECTS",
 417 '246'=>"MOD_DURATION_OF_EFFECTS_BY_DISPEL",
 418 '247'=>"247",
 419 '248'=>"MOD_COMBAT_RESULT_CHANCE",
 420 '249'=>"Convert Rune",
 421 '250'=>"MOD_INCREASE_HEALTH_2",
 422 '251'=>"MOD_ENEMY_DODGE",
 423 '252'=>"252",
 424 '253'=>"MOD_BLOCK_CRIT_CHANCE",
 425 '254'=>"MOD_DISARM_SHIELD",
 426 '255'=>"MOD_MECHANIC_DAMAGE_TAKEN_PERCENT",
 427 '256'=>"NO_REAGENT_USE",
 428 '257'=>"MOD_TARGET_RESIST_BY_SPELL_CLASS",
 429 '258'=>"258",
 430 '259'=>"259",
 431 '260'=>"260",
 432 '261'=>"261",
 433 '262'=>"262",
 434 '263'=>"ALLOW_ONLY_ABILITY",
 435 '264'=>"264",
 436 '265'=>"265",
 437 '266'=>"266",
 438 '267'=>"267",
 439 '268'=>"MOD_ATTACK_POWER_OF_STAT_PERCENT",
 440 '269'=>"269",
 441 '270'=>"270",
 442 '271'=>"271",
 443 '272'=>"272",
 444 '273'=>"273",
 445 '274'=>"274",
 446 '275'=>"275",
 447 '276'=>"276",
 448 '277'=>"277",
 449 '278'=>"MOD_DISARM_RANGED",
 450 '279'=>"279",
 451 '280'=>"MOD_TARGET_ARMOR_PCT",
 452 '281'=>"MOD_HONOR_GAIN",
 453 '282'=>"MOD_BASE_HEALTH_PCT",
 454 '283'=>"MOD_HEALING_RECEIVED"
 455 );
 456
 457 function getSpellFamilyNames()
 458 {
 459   global $wDB;
 460   return $wDB->selectCol('-- CACHE: 1h
 461   SELECT `spell_family` AS ARRAY_KEY, `name` FROM `wowd_chr_classes`');
 462 }
 463
 464 function getSpellFamilyName($i)
 465 {
 466   $l = getSpellFamilyNames();
 467   return isset($l[$i]) ? $l[$i] : 'Family_'.$i;
 468 }
 469
 470 function getRatingList($mask)
 471 {
 472   global $gRatingNames;
 473   return getListFromArray_1($gRatingNames, $mask);
 474 }
 475
 476 function getSpellRange($id)
 477 {
 478   global $wDB;
 479   return $wDB->selectRow("-- CACHE: 1h
 480   SELECT * FROM `wowd_spell_range` WHERE `id` = ?d", $id);
 481 }
 482
 483 function getRange($index)
 484 {
 485   $range = getSpellRange($index);
 486   if ($range == 0)
 487     return "Err index $index";
 488
 489   if ($range['minRange']==0 OR $range['minRange']==$range['maxRange'])
 490     return $range['maxRange'];
 491   return $range['minRange'].' - '.$range['maxRange'];
 492 }
 493
 494 function getRangeText($index)
 495 {
 496   $range =  getSpellRange($index);
 497   if ($range == 0)
 498     return "Err index $index";
 499
 500   if ($range['minRange']==0 OR $range['minRange']==$range['maxRange'])
 501     return $range['maxRange'].' yds ('.$range['name'].')';
 502   return $range['minRange'].' - '.$range['maxRange'].' yds ('.$range['name'].')';
 503 }
 504
 505 //*****************************************
 506 // Totem Category
 507 //*****************************************
 508 function getTotemCategory($i, $as_ref=1)
 509 {
 510   global $wDB;
 511   $gTotemCategory = $wDB->selectCol('-- CACHE: 1h
 512   SELECT `id` AS ARRAY_KEY, `name` FROM `wowd_totem_category`');
 513
 514   $name = @$gTotemCategory[$i];
 515   if ($name == "")
 516       $name = "Category_$i";
 517   if ($as_ref)
 518       return "<a href=\"?s=i&totem=$i\">".$name."</a>";
 519   return $name;
 520 }
 521
 522 function getRuneName($i)
 523 {
 524   global $gRuneName;
 525   if (empty($gRuneName[$i]))
 526     return "Rune_".$i;
 527   return $gRuneName[$i];
 528 }
 529
 530 function getTargetsList($mask)
 531 {
 532   global $gTargetsList;
 533   return getListFromArray_1($gTargetsList, $mask);
 534 }
 535
 536 //***************************************
 537 // Form functions
 538 //***************************************
 539 function getFormNames()
 540 {
 541     global $wDB;
 542         return $wDB->selectCol('-- CACHE: 1h
 543         SELECT `id` AS ARRAY_KEY, `name` FROM `wowd_spell_shapeshift`');
 544 }
 545
 546 function getForm($i, $as_ref=1)
 547 {
 548   $gSpellSnapeshiftForm = getFormNames();
 549   $name = @$gSpellSnapeshiftForm[$i];
 550   if ($name == "") $name = "Form_$i";
 551   if ($as_ref)
 552       return "<a href=\"?s=s&form=$i\">".$name."</a>";
 553   return $name;
 554 }
 555
 556 function getAllowableForm($mask, $as_ref=1)
 557 {
 558   $gSpellSnapeshiftForm = getFormNames();
 559   if ($as_ref)
 560       return getListFromArray_1($gSpellSnapeshiftForm, $mask, "?s=s&form=%d");
 561   return getListFromArray_1($gSpellSnapeshiftForm, $mask);
 562 }
 563
 564 function getCategoryName($i, $as_ref=1)
 565 {
 566   if ($as_ref)
 567     return "<a href=\"?s=s&cat=$i\">".$i."</a>";
 568   return "$i";
 569 }
 570
 571 function getPowerTypeName($index)
 572 {
 573   global $gSpellPowerType;
 574   if ($index >= 0 && $index < 5)
 575     return $gSpellPowerType[$index];
 576   return $gSpellPowerType[-1];
 577 }
 578
 579 function getSpellEffectName($i)
 580 {
 581   global $gSpellEffect;
 582   return $gSpellEffect[$i];
 583 }
 584
 585 function getSpellAuraName($i)
 586 {
 587   global $gSpellAuraName;
 588   return $gSpellAuraName[$i];
 589 }
 590
 591 function getSpellModName($i)
 592 {
 593   global $gSpellModsType;
 594   return $gSpellModsType[$i];
 595 }
 596
 597 function getDispelName($i, $as_ref=1)
 598 {
 599   global $wDB;
 600   $d = $wDB->selectCol('-- CACHE: 1h
 601   SELECT `id` AS ARRAY_KEY, `name` FROM `wowd_spell_dispel_type`');
 602   $name = isset($d[$i]) ? $d[$i] : 'Dispell_'.$i;
 603   if ($as_ref && $i)
 604       return "<a href=\"?s=s&dispel=$i\">$name</a>";
 605   return $name;
 606 }
 607
 608 function getMechanicName($i, $as_ref=1)
 609 {
 610   global $gSpellMechanic;
 611   $name = @$gSpellMechanic[$i];
 612   if (!$name) $name = "Mechanic_$i";
 613   if ($as_ref && $i)
 614       return "<a href=\"?s=s&mech=$i\">$name</a>";
 615   return $name;
 616 }
 617
 618 function getLaungageName($i)
 619 {
 620   global $wDB;
 621   $l = $wDB->selectCol('-- CACHE: 1h
 622   SELECT `id` AS ARRAY_KEY, `name` FROM `wowd_languages`');
 623   return isset($l[$i]) ? $l[$i] : 'Laungage_'.$i;
 624 }
 625
 626 function getSchool($i)
 627 {
 628   global $gSpellSchool;
 629   $name = @$gSpellSchool[$i];
 630   if ($name == "") $name = "School_$i";
 631   return $name;
 632
 633 }
 634
 635 function getSpellSchool($mask)
 636 {
 637   global $gSpellSchool;
 638   return getListFromArray_0($gSpellSchool, $mask);
 639 }
 640
 641 function getSpellDamageClass($i)
 642 {
 643   global $gDmgClass;
 644   return $gDmgClass[$i];
 645 }
 646
 647 function getSpell($spell_id, $fields="*")
 648 {
 649   global $wDB;
 650   return $wDB->selectRow("SELECT ".$fields." FROM `wowd_spell` WHERE `id` = ?d", $spell_id);
 651 }
 652
 653 function getSpellName($spell, $as_ref=1)
 654 {
 655   if ($spell)
 656   {
 657     $name = $spell['SpellName'];
 658     if ($as_ref)
 659         $name = "<a href=\"?spell=$spell[id]\">".$name."</a>";
 660     if ($spell['Rank']!="")
 661         $name.="<br><div class=srank>".$spell['Rank']."</div>";
 662     return $name;
 663   }
 664   return "No spell";
 665 }
 666
 667 function getSpellNameFromId($spellId, $as_ref=1)
 668 {
 669   if ($spell = getSpell($spellId))
 670     return getSpellName($spell, $as_ref);
 671   return "Err spell $spellId";
 672 }
 673
 674 function getSpellDurationData($durationIndex)
 675 {
 676   global $wDB;
 677   return $wDB->selectRow("-- CACHE: 1h
 678   SELECT * FROM `wowd_spell_duration` WHERE `id` = ?d", $durationIndex);
 679 }
 680
 681 function getSpellDuration($spell)
 682 {
 683   if ($spell['DurationIndex'])
 684    if ($spell_duration = getSpellDurationData($spell['DurationIndex']))
 685      return  $spell_duration['duration_1']/1000;
 686   return '';
 687 }
 688
 689 function getSpellDurationText($spell)
 690 {
 691   if ($spell['DurationIndex'])
 692   {
 693    if ($spell_duration = getSpellDurationData($spell['DurationIndex']))
 694    {
 695      if ($spell_duration['duration_1'] == -1)
 696          return "Unlimited";
 697 //     if ($spell_duration['duration_1'] == ($spell_duration['duration_3'])
 698 //         return getTimeText($spell_duration['duration_1']/1000);
 699      // TODO fix it
 700      return  getTimeText($spell_duration['duration_1']/1000);
 701    }
 702    else
 703      return "Err index ".$spell['DurationIndex'];
 704   }
 705   return "";
 706 }
 707
 708 function getSpellRadius($id)
 709 {
 710   global $wDB;
 711   return $wDB->selectRow("-- CACHE: 1h
 712   SELECT * FROM `wowd_spell_radius` WHERE `id` = ?d", $id);
 713 }
 714
 715 function getRadius($index)
 716 {
 717   if ($index==0) return '0';
 718
 719   $radius = getSpellRadius($index);
 720   if (!$radius)
 721         return "Err index $index";
 722
 723   if ($radius['radius_1']==0 OR $radius['radius_1']==$radius['radius_3'])
 724     return $radius['radius_3'];
 725   return $radius['radius_1']." - ".$radius['radius_3'];
 726 }
 727
 728 function getRadiusText($index)
 729 {
 730   return getRadius($index).' yds';
 731 }
 732
 733 function getSpellCooldown($spell)
 734 {
 735   if ($spell['RecoveryTime'] > $spell['CategoryRecoveryTime'])
 736     return $spell['RecoveryTime'];
 737   else
 738     return $spell['CategoryRecoveryTime'];
 739 }
 740
 741 function getSpellCastTime($id)
 742 {
 743   global $wDB;
 744   return $wDB->selectRow("-- CACHE: 1h
 745   SELECT * FROM `wowd_spell_cast_time` WHERE `id` = ?d", $id);
 746 }
 747
 748 function getCastTimeText($spell)
 749 {
 750   $cast_time = getSpellCastTime($spell['CastingTimeIndex']);
 751   $time = @$cast_time['time_1']/1000;
 752   if ($time)
 753     return $time." sec cast";
 754   else
 755     return "Instant Cast";
 756 }
 757
 758 function getBasePointDesc($spell, $index)
 759 {
 760   if (empty($spell))
 761       return;
 762   $s = $spell['EffectBasePoints_'.$index]+1;
 763   if ($spell['EffectDieSides_'.$index] > 1)
 764     $s.=" - ".abs($spell['EffectBasePoints_'.$index]+$spell['EffectDieSides_'.$index]);
 765
 766   if ($spell['EffectRealPointsPerLevel_'.$index])
 767     $s.=" + lvl*".$spell['EffectRealPointsPerLevel_'.$index];
 768 // Óâåëè÷èâàåò òîëüêî ìàêñ ðàíäîìíîå çíà÷åíèå
 769 // if ($spell['EffectDicePerLevel_'.$index])
 770 //   $s.=" + lvl*".$spell['EffectDicePerLevel_'.$index];
 771   if ($spell['EffectPointsPerComboPoint_'.$index])
 772     $s." + combo*".$spell['EffectPointsPerComboPoint_'.$index];
 773   return $s;
 774 }
 775
 776 function getSpellData($spell)
 777 {
 778   // Basepoints
 779   $s1 = abs($spell['EffectBasePoints_1']+1);
 780   $s2 = abs($spell['EffectBasePoints_2']+1);
 781   $s3 = abs($spell['EffectBasePoints_3']+1);
 782   if ($spell['EffectDieSides_1']>1) $s1.=" - ".abs($spell['EffectBasePoints_1']+$spell['EffectDieSides_1']);
 783   if ($spell['EffectDieSides_2']>1) $s2.=" - ".abs($spell['EffectBasePoints_2']+$spell['EffectDieSides_2']);
 784   if ($spell['EffectDieSides_3']>1) $s3.=" - ".abs($spell['EffectBasePoints_3']+$spell['EffectDieSides_3']);
 785
 786   $d  = 0;
 787   if ($spell['DurationIndex'])
 788    if ($spell_duration = getSpellDurationData($spell['DurationIndex']))
 789      $d = $spell_duration['duration_1']/1000;
 790
 791   // Tick duration
 792   $t1 = $spell['EffectAmplitude_1'] ? $spell['EffectAmplitude_1']/1000 : 5;
 793   $t2 = $spell['EffectAmplitude_1'] ? $spell['EffectAmplitude_2']/1000 : 5;
 794   $t3 = $spell['EffectAmplitude_1'] ? $spell['EffectAmplitude_3']/1000 : 5;
 795
 796   // Points per tick
 797   $o1 = @intval($s1*$d/$t1);
 798   $o2 = @intval($s2*$d/$t2);
 799   $o3 = @intval($s3*$d/$t3);
 800
 801   $spellData['t1']=$t1;
 802   $spellData['t2']=$t2;
 803   $spellData['t3']=$t3;
 804   $spellData['o1']=$o1;
 805   $spellData['o2']=$o2;
 806   $spellData['o3']=$o3;
 807   $spellData['s1']=$s1;
 808   $spellData['s2']=$s2;
 809   $spellData['s3']=$s3;
 810   $spellData['m1']=$s1;
 811   $spellData['m2']=$s2;
 812   $spellData['m3']=$s3;
 813   $spellData['x1']= $spell['EffectChainTarget_1'];
 814   $spellData['x2']= $spell['EffectChainTarget_2'];
 815   $spellData['x3']= $spell['EffectChainTarget_3'];
 816 //  $spellData['i'] = $spell['MaxAffectedTargets'];
 817   $spellData['d'] = getTimeText($d);
 818   $spellData['d1']= getTimeText($d);
 819   $spellData['d2']= getTimeText($d);
 820   $spellData['d3']= getTimeText($d);
 821   $spellData['v'] = $spell['AffectedTargetLevel'];
 822   $spellData['u'] = $spell['StackAmount'];
 823   $spellData['a1']= getRadius($spell['EffectRadiusIndex_1']);
 824   $spellData['a2']= getRadius($spell['EffectRadiusIndex_2']);
 825   $spellData['a3']= getRadius($spell['EffectRadiusIndex_3']);
 826   $spellData['b1']= $spell['EffectPointsPerComboPoint_1'];
 827   $spellData['b2']= $spell['EffectPointsPerComboPoint_2'];
 828   $spellData['b3']= $spell['EffectPointsPerComboPoint_3'];
 829   $spellData['e'] = $spell['EffectMultipleValue_1'];
 830   $spellData['e1']= $spell['EffectMultipleValue_1'];
 831   $spellData['e2']= $spell['EffectMultipleValue_2'];
 832   $spellData['e3']= $spell['EffectMultipleValue_3'];
 833   $spellData['f1']= $spell['DmgMultiplier_1'];
 834   $spellData['f2']= $spell['DmgMultiplier_2'];
 835   $spellData['f3']= $spell['DmgMultiplier_3'];
 836   $spellData['q1']= $spell['EffectMiscValue_1'];
 837   $spellData['q2']= $spell['EffectMiscValue_2'];
 838   $spellData['q3']= $spell['EffectMiscValue_3'];
 839   $spellData['h'] = $spell['procChance'];
 840   $spellData['n'] = $spell['procCharges'];
 841   $spellData['z'] = "<home>";
 842   return $spellData;
 843 }
 844
 845 function spellReplace($spell, $text)
 846 {
 847     $letter = array('${','}');
 848     $values = array( '[',']');
 849     $text = str_replace($letter, $values, $text);
 850
 851         $signs = array('+', '-', '/', '*', '%', '^');
 852     $data = $text;
 853         $pos = 0;
 854     $npos = 0;
 855         $str = '';
 856     $cacheSpellData=array(); // Spell data for spell
 857     $lastCount = 1;
 858         while (false!==($npos=strpos($data, '$', $pos)))
 859         {
 860                 if ($npos!=$pos)
 861                         $str .= substr($data, $pos, $npos-$pos);
 862                 $pos = $npos+1;
 863                 if ('$' == substr($data, $pos, 1))
 864                 {
 865                         $str .= '$';
 866                         $pos++;
 867                         continue;
 868                 }
 869
 870                 if (!preg_match('/^((([+\-\/*])(\d+);)?(\d*)(?:([lg].*?:.*?);|(\w\d*)))/', substr($data, $pos), $result))
 871                         continue;
 872                 $pos += strlen($result[0]);
 873                 $op = $result[3];
 874                 $oparg = $result[4];
 875                 $lookup = $result[5]? $result[5]:$spell['id'];
 876                 $var = $result[6] ? $result[6]:$result[7];
 877                 if (!$var)
 878                         continue;
 879         // l - ðàçìåð ïîñëåäíåé âåëè÷èíû == 1 ? 0 : 1
 880         if ($var[0]=='l')
 881         {
 882             $select = explode(':', substr($var, 1));
 883             $str.=@$select[$lastCount==1 ? 0:1];
 884         }
 885         // g - ïîë ïåðñîíæà
 886         else if ($var[0]=='g')
 887         {
 888             $select = explode(':', substr($var, 1));
 889             $str.=$select[0];
 890         }
 891         else
 892         {
 893             $spellData = @$cacheSpellData[$lookup];
 894             if ($spellData == 0)
 895             {
 896                 if ($lookup == $spell['id']) $cacheSpellData[$lookup] = getSpellData($spell);
 897                 else                         $cacheSpellData[$lookup] = getSpellData(getSpell($lookup));
 898                 $spellData = @$cacheSpellData[$lookup];
 899             }
 900             if ($spellData && $base = @$spellData[strtolower($var)])
 901             {
 902                 if ($op && is_numeric($oparg) && is_numeric($base))
 903                 {
 904                      $equation = $base.$op.$oparg;
 905                      eval("\$base = $equation;");
 906                         }
 907                 if (is_numeric($base)) $lastCount = $base;
 908             }
 909             else
 910                 $base = $var;
 911             $str.=$base;
 912         }
 913         }
 914         $str.= substr($data, $pos);
 915         $str = @preg_replace_callback("/\[.+[+\-\/*\d]\]/", 'my_relpace', $str);
 916 //    $letter = array('*','/','+','-');
 917 //    $values = array(' * ', ' / ',' + ',' - ');
 918 //    $str = str_replace($letter, $values, $str);
 919
 920         return($str);//."<br /><br />".$text;
 921 }
 922
 923 function my_relpace($matches)
 924 {
 925     $text = str_replace( array('[',']'), array('', ''), $matches[0]);
 926     eval("\$text = abs(".$text.");");
 927     return intval($text);
 928 }
 929
 930 function getSpellDesc($spell)
 931 {
 932   if ($spell['Description']=="") return $spell['SpellName'];
 933   return spellReplace($spell, $spell['Description']);
 934 }
 935
 936 function getSpellBuff($spell)
 937 {
 938   if ($spell['ToolTip']=="") return "";
 939   return spellReplace($spell, $spell['ToolTip']);
 940 }
 941
 942 function get_spell_details($spell_id)
 943 {
 944   $spell=getSpell($spell_id);
 945   if ($spell)
 946     return getSpellDesc($spell);
 947   return "Spell id - $spell_id";
 948 }
 949
 950 function getSpellCostText($spell)
 951 {
 952   // Çàïîëíÿåì ñòîèìîñòü çàêëèíàíèÿ
 953   $powerType = getPowerTypeName($spell['powerType']);
 954   $powerCost = "";
 955   if ($spell['AttributesEx'] & 2)
 956     $powerCost = "Uses 100% ".$powerType;
 957   else
 958   {
 959     if ($spell['ManaCostPercentage'])
 960       $powerCost = $spell['ManaCostPercentage']."% of base";
 961     else if ($spell['manaCost'])
 962       $powerCost = $spell['manaCost'];
 963     if ($powerCost)
 964     {
 965       $powerCost.= " ".$powerType;
 966       if ($spell['manaPerSecond'])
 967         $powerCost.= " plus ".$spell['manaPerSecond']." per sec";
 968     }
 969   }
 970   return $powerCost;
 971 }
 972 ?>