API tools faq
paste
Advertisement
Guest User

index.php

a guest
Nov 12th, 2014
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 13.16 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3.     <style>
  4.         body {
  5.             font-size:11px;
  6.             font-color:#000;
  7.             font-family:tahoma;
  8.             background-color:#eee;
  9.         }
  10.     </style>
  11. </head>
  12. </html>
  13. <?php
  14.  
  15. echo "
  16.     REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`)
  17.     VALUES
  18. ";
  19.  
  20. $i = -1; // shut up the error
  21. $count = 10; // tiers count
  22. while ($i++ < $count) {
  23.  
  24.  
  25. // configs
  26.  
  27. $multiplier = pow(1.3,$i); // multiplier old item stat * x %
  28. //$ilvlmultipler = pow(1.10,$i); // ilvl multiplier
  29.  
  30. $reqlvl = "255";
  31. $ilvl = "175"; // ilvl for first tier
  32.  
  33. /*
  34.  ID Name
  35.  0  =  Mana
  36.  1  =  HEALTH
  37.  2  =  UNKNOWN
  38.  3  =  AGILITY
  39.  4  =  STRENGTH
  40.  5  =  INTELLECT
  41.  6  =  SPIRIT
  42.  7  =  STAMINA
  43. 11  =  WEAPON_SKILL_RATING
  44. 12  =  DEFENSE_RATING
  45. 13  =  DODGE_RATING
  46. 14  =  PARRY_RATING
  47. 15  =  SHIELD_BLOCK_RATING
  48. 16  =  MELEE_HIT_RATING
  49. 17  =  RANGED_HIT_RATING
  50. 18  =  SPELL_HIT_RATING
  51. 19  =  MELEE_CRITICAL_STRIKE_RATING
  52. 20  =  RANGED_CRITICAL_STRIKE_RATING
  53. 21  =  SPELL_CRITICAL_STRIKE_RATING
  54. 22  =  MELEE_HIT_AVOIDANCE_RATING
  55. 23  =  RANGED_HIT_AVOIDANCE_RATING
  56. 24  =  SPELL_HIT_AVOIDANCE_RATING
  57. 25  =  MELEE_CRITICAL_AVOIDANCE_RATING
  58. 26  =  RANGED_CRITICAL_AVOIDANCE_RATING
  59. 27  =  SPELL_CRITICAL_AVOIDANCE_RATING
  60. 28  =  MELEE_HASTE_RATING
  61. 29  =  RANGED_HASTE_RATING
  62. 30  =  SPELL_HASTE_RATING
  63. 31  =  HIT_RATING
  64. 32  =  CRITICAL_STRIKE_RATING
  65. 33  =  HIT_AVOIDANCE_RATING
  66. 34  =  EXPERTISE_RATING
  67. 35  =  RESILIENCE_RATING
  68. 36  =  HASTE_RATING
  69. 37  =  EXPERTISE_RATING_2
  70. 38  =  ATTACK_POWER
  71. 39  =  RANGED_ATTACK_POWER
  72. 40  =  FERAL_ATTACK_POWER
  73. 41  =  SPELL_HEALING_DONE
  74. 42  =  SPELL_DAMAGE_DONE
  75. 43  =  MANA_REGENERATION
  76. 44  =  ARMOR_PENETRATION_RATING
  77. 45  =  SPELL_POWER
  78. 46  =  HEALTH_REGEN
  79. 47  =  SPELL_PENETRATION  
  80. 48  =  BLOCK_VALUE
  81. */
  82. $stat_type =
  83. array(
  84. '1' => '5',
  85. '2' => '7',
  86. '3' => '32',
  87. '4' => '45',
  88. '5' => '36',
  89. '6' => '0',
  90. '7' => '0',
  91. '8' => '0',
  92. '9' => '0',
  93. '10' => '0'
  94. );
  95. //
  96.  
  97. // edit stat value
  98. $stat_value =
  99. array(
  100. '1' => '1390',
  101. '2' => '1390',
  102. '3' => '114',
  103. '4' => '4860',
  104. '5' => '35',
  105. '6' => '0',
  106. '7' => '0',
  107. '8' => '0',
  108. '9' => '0',
  109. '10' => '0'
  110. );
  111.  
  112. // edit if stat will be affected or no by multiplier 0 affect 1 disable
  113. $effect =
  114. array(
  115. '1' => '0',
  116. '2' => '0',
  117. '3' => '1',
  118. '4' => '0',
  119. '5' => '1',
  120. '6' => '0',
  121. '7' => '0',
  122. '8' => '0',
  123. '9' => '0',
  124. '10' => '0'
  125. );
  126.  
  127.  
  128.  
  129. $quality = "5"; // 0 = Poor 1 = Common 2 = Uncommon 3 = Rare 4 = Epic 5 = Legendary 6 = Artifact 7 = Heirloom
  130. $armor = "1700"; // armor
  131. $armor *= $multiplier;
  132. $armor = round($armor);
  133. $start_entry = 92152; // start entry
  134. $aclass = "128"; // allowable class number
  135. $material = "1"; // item material, usually subclass // 4 plate // 3 mail // 2 leather // 1 cloth
  136. $name = "[D-$i] - Mage"; // item generated near item type.
  137. //
  138.  
  139. // displays
  140. $helmet_display = "36440"; // helmet displayid
  141. $shoulders_display = "35326"; // helmet displayid
  142. $chest_display = "35523"; // helmet displayid
  143. $waist_display = "35519"; // helmet displayid
  144. $legplates_display = "35522"; // helmet displayid
  145. $boots_display = "35525"; // helmet displayid
  146. $wrist_display = "35677"; // helmet displayid
  147. $gloves_display = "35521"; // helmet displayid
  148. //
  149.  
  150.  
  151. $a = 0;
  152. while ($a++ < 10) {
  153.    
  154.     if($stat_type[$a] == $effect[$a] || $effect[$a] != 0) {
  155.    
  156.         $stat_value[$a] = $stat_value[$a];
  157.    
  158.     } else {
  159.    
  160.         $stat_value[$a] = $stat_value[$a] * $multiplier;
  161.  
  162.     }
  163.    
  164. }
  165.  
  166. // do not touch this
  167.     if ($i == 0) {
  168.  
  169.             $entry = $start_entry + $i;
  170.            
  171.     }
  172. //
  173.  
  174.     echo "
  175.     <p>## Tier $i</p>
  176.     (".$entry++.", 4, $material, -1, '$name Gloves', $gloves_display, $quality, 0, 0, 1, 0, 0, 10, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  177.     10,
  178.     {$stat_type[1]}, ".round($stat_value[1]).",
  179.     {$stat_type[2]}, ".round($stat_value[2]).",
  180.     {$stat_type[3]}, ".round($stat_value[3]).",
  181.     {$stat_type[4]}, ".round($stat_value[4]).",
  182.     {$stat_type[5]}, ".round($stat_value[5]).",
  183.     {$stat_type[6]}, ".round($stat_value[6]).",
  184.     {$stat_type[7]}, ".round($stat_value[7]).",
  185.     {$stat_type[8]}, ".round($stat_value[8]).",
  186.     {$stat_type[9]}, ".round($stat_value[9]).",
  187.     {$stat_type[10]}, ".round($stat_value[10]).",
  188.     0, 0, 0, 0, 0, 0, 0, 0,
  189.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  190.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier $i', 0, 0, 0, 0, 0, -1, 0, 0, 0,
  191.     0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  192.     <br />
  193.     (".$entry++.", 4, $material, -1, '$name Wrist', $wrist_display, $quality, 0, 0, 1, 0, 0, 9, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  194.     10,
  195.     {$stat_type[1]}, ".round($stat_value[1]).",
  196.     {$stat_type[2]}, ".round($stat_value[2]).",
  197.     {$stat_type[3]}, ".round($stat_value[3]).",
  198.     {$stat_type[4]}, ".round($stat_value[4]).",
  199.     {$stat_type[5]}, ".round($stat_value[5]).",
  200.     {$stat_type[6]}, ".round($stat_value[6]).",
  201.     {$stat_type[7]}, ".round($stat_value[7]).",
  202.     {$stat_type[8]}, ".round($stat_value[8]).",
  203.     {$stat_type[9]}, ".round($stat_value[9]).",
  204.     {$stat_type[10]}, ".round($stat_value[10]).",
  205.     0, 0, 0, 0, 0, 0, 0, 0,
  206.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  207.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0, 0, 0,
  208.     0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  209.     <br />
  210.     (".$entry++.", 4, $material, -1, '$name Boots', $boots_display, $quality, 0, 0, 1, 0, 0, 8, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  211.     10,
  212.     {$stat_type[1]}, ".round($stat_value[1]).",
  213.     {$stat_type[2]}, ".round($stat_value[2]).",
  214.     {$stat_type[3]}, ".round($stat_value[3]).",
  215.     {$stat_type[4]}, ".round($stat_value[4]).",
  216.     {$stat_type[5]}, ".round($stat_value[5]).",
  217.     {$stat_type[6]}, ".round($stat_value[6]).",
  218.     {$stat_type[7]}, ".round($stat_value[7]).",
  219.     {$stat_type[8]}, ".round($stat_value[8]).",
  220.     {$stat_type[9]}, ".round($stat_value[9]).",
  221.     {$stat_type[10]}, ".round($stat_value[10]).",
  222.     0, 0, 0, 0, 0, 0, 0, 0,
  223.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  224.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  225.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  226.     <br />
  227.     (".$entry++.", 4, $material, -1, '$name Legplates', $legplates_display, $quality, 0, 0, 1, 0, 0, 7, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  228.     10,
  229.     {$stat_type[1]}, ".round($stat_value[1]).",
  230.     {$stat_type[2]}, ".round($stat_value[2]).",
  231.     {$stat_type[3]}, ".round($stat_value[3]).",
  232.     {$stat_type[4]}, ".round($stat_value[4]).",
  233.     {$stat_type[5]}, ".round($stat_value[5]).",
  234.     {$stat_type[6]}, ".round($stat_value[6]).",
  235.     {$stat_type[7]}, ".round($stat_value[7]).",
  236.     {$stat_type[8]}, ".round($stat_value[8]).",
  237.     {$stat_type[9]}, ".round($stat_value[9]).",
  238.     {$stat_type[10]}, ".round($stat_value[10]).",
  239.     0, 0, 0, 0, 0, 0, 0, 0,
  240.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  241.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  242.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  243.     <br />
  244.     (".$entry++.", 4, $material, -1, '$name Waist', $waist_display, $quality, 0, 0, 1, 0, 0, 6, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  245.     10,
  246.     {$stat_type[1]}, ".round($stat_value[1]).",
  247.     {$stat_type[2]}, ".round($stat_value[2]).",
  248.     {$stat_type[3]}, ".round($stat_value[3]).",
  249.     {$stat_type[4]}, ".round($stat_value[4]).",
  250.     {$stat_type[5]}, ".round($stat_value[5]).",
  251.     {$stat_type[6]}, ".round($stat_value[6]).",
  252.     {$stat_type[7]}, ".round($stat_value[7]).",
  253.     {$stat_type[8]}, ".round($stat_value[8]).",
  254.     {$stat_type[9]}, ".round($stat_value[9]).",
  255.     {$stat_type[10]}, ".round($stat_value[10]).",
  256.     0, 0, 0, 0, 0, 0, 0, 0,
  257.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  258.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  259.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  260.     <br />
  261.     (".$entry++.", 4, $material, -1, '$name Chest', $chest_display, $quality, 0, 0, 1, 0, 0, 5, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  262.     10,
  263.     {$stat_type[1]}, ".round($stat_value[1]).",
  264.     {$stat_type[2]}, ".round($stat_value[2]).",
  265.     {$stat_type[3]}, ".round($stat_value[3]).",
  266.     {$stat_type[4]}, ".round($stat_value[4]).",
  267.     {$stat_type[5]}, ".round($stat_value[5]).",
  268.     {$stat_type[6]}, ".round($stat_value[6]).",
  269.     {$stat_type[7]}, ".round($stat_value[7]).",
  270.     {$stat_type[8]}, ".round($stat_value[8]).",
  271.     {$stat_type[9]}, ".round($stat_value[9]).",
  272.     {$stat_type[10]}, ".round($stat_value[10]).",
  273.     0, 0, 0, 0, 0, 0, 0, 0,
  274.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  275.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  276.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  277.     <br />
  278.     (".$entry++.", 4, $material, -1, '$name Shoulders', $shoulders_display, $quality, 0, 0, 1, 0, 0, 3, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  279.     10,
  280.     {$stat_type[1]}, ".round($stat_value[1]).",
  281.     {$stat_type[2]}, ".round($stat_value[2]).",
  282.     {$stat_type[3]}, ".round($stat_value[3]).",
  283.     {$stat_type[4]}, ".round($stat_value[4]).",
  284.     {$stat_type[5]}, ".round($stat_value[5]).",
  285.     {$stat_type[6]}, ".round($stat_value[6]).",
  286.     {$stat_type[7]}, ".round($stat_value[7]).",
  287.     {$stat_type[8]}, ".round($stat_value[8]).",
  288.     {$stat_type[9]}, ".round($stat_value[9]).",
  289.     {$stat_type[10]}, ".round($stat_value[10]).",
  290.     0, 0, 0, 0, 0, 0, 0, 0,
  291.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  292.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  293.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340),
  294.     <br />
  295.     (".$entry++.", 4, $material, -1, '$name Helmet', $helmet_display, $quality, 0, 0, 1, 0, 0, 1, $aclass, -1, $ilvl, $reqlvl, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
  296.     10,
  297.     {$stat_type[1]}, ".round($stat_value[1]).",
  298.     {$stat_type[2]}, ".round($stat_value[2]).",
  299.     {$stat_type[3]}, ".round($stat_value[3]).",
  300.     {$stat_type[4]}, ".round($stat_value[4]).",
  301.     {$stat_type[5]}, ".round($stat_value[5]).",
  302.     {$stat_type[6]}, ".round($stat_value[6]).",
  303.     {$stat_type[7]}, ".round($stat_value[7]).",
  304.     {$stat_type[8]}, ".round($stat_value[8]).",
  305.     {$stat_type[9]}, ".round($stat_value[9]).",
  306.     {$stat_type[10]}, ".round($stat_value[10]).",
  307.     0, 0, 0, 0, 0, 0, 0, 0,
  308.     $armor, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  309.     0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, '$name Tier', 0, 0, 0, 0, 0, -1, 0,
  310.     0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0, 0, 12340) ";
  311.    
  312.         if($count == $i) {
  313.             echo ";";
  314.         } else {
  315.             echo ",";
  316.         }
  317.    
  318. }
  319. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!