API tools faq
paste
Guest User

Matt Lang

a guest
Oct 9th, 2009
252
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 43.47 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. $itemidMIN = 150000;
  3. $itemidMAX = 150500;
  4. $host = "localhost";
  5. $user = "root";
  6. $pass = "root";
  7. $worlddb = "arcemu-world";
  8.  
  9. mysql_connect($host,$user,$pass);
  10. @mysql_select_db($worlddb) or die( "Unable to select database");
  11.  
  12.  
  13. $result = mysql_query("SELECT * FROM items where entry >= $itemidMIN and entry <= $itemidMAX ORDER BY CLASS")
  14. or die(mysql_error());  
  15.  
  16. while($row = mysql_fetch_array( $result )) {
  17.     $class = $row['class'];
  18.     $subclass = $row['subclass'];
  19.     $name = $row['name1'];
  20.     $quality = $row['quality'];
  21.     $requiredlevel = $row['requiredlevel'];
  22.     $unique = $row['Unique'];
  23.     $armor = $row['armor'];
  24.     $statonetype = $row['stat_type1'];
  25.     $statoneval = $row['stat_value1'];
  26.     $stattwotype = $row['stat_type2'];
  27.     $stattwoval = $row['stat_value2'];
  28.     $statthreetype = $row['stat_type3'];
  29.     $statthreeval = $row['stat_value3'];
  30.     $statfourtype = $row['stat_type4'];
  31.     $statfourval = $row['stat_value4'];
  32.     $statfivetype = $row['stat_type5'];
  33.     $statfiveval = $row['stat_value5'];
  34.     $statsixtype = $row['stat_type6'];
  35.     $statsixval = $row['stat_value6'];
  36.     $statseventype = $row['stat_type7'];
  37.     $statsevenval = $row['stat_value7'];
  38.     $stateighttype = $row['stat_type8'];
  39.     $stateightval = $row['stat_value8'];
  40.     $statninetype = $row['stat_type9'];
  41.     $statnineval = $row['stat_value9'];
  42.     $stattentype = $row['stat_type10'];
  43.     $stattenval = $row['stat_value10'];
  44.     switch ($statonetype){
  45.         case 0:
  46.         $statonetype = (string)$statoneval." MANA<br>";
  47.         break;
  48.         case 1:
  49.         $statonetype = (string)$statoneval." HEALTH<br>";
  50.         break;
  51.         case 2:
  52.         $statonetype = (string)$statoneval." UNKNOWN<br>";
  53.         break;
  54.         case 3:
  55.         $statonetype = (string)$statoneval." AGILITY<br>";
  56.         break;
  57.         case 4:
  58.         $statonetype = (string)$statoneval." STRENGTH<br>";
  59.         break;
  60.         case 5:
  61.         $statonetype = (string)$statoneval." INTELLECT<br>";
  62.         break;
  63.         case 6:
  64.         $statonetype = (string)$statoneval." SPIRIT<br>";
  65.         break;
  66.         case 7:
  67.         $statonetype = (string)$statoneval." STAMINA<br>";
  68.         break;
  69.         case 11:
  70.         $statonetype = (string)$statoneval." WEAPON SKILL RATING<br>";
  71.         break;
  72.         case 12:
  73.         $statonetype = (string)$statoneval." DEFENSE RATING<br>";
  74.         break;
  75.         case 13:
  76.         $statonetype = (string)$statoneval." DODGE RATING<br>";
  77.         break;
  78.         case 14:
  79.         $statonetype = (string)$statoneval." PARRY RATING<br>";
  80.         break;
  81.         case 15:
  82.         $statonetype = (string)$statoneval." SHIELD BLOCK RATING<br>";
  83.         break;
  84.         case 16:
  85.         $statonetype = (string)$statoneval." MELEE HIT RATING<br>";
  86.         break;
  87.         case 17:
  88.         $statonetype = (string)$statoneval." RANGED HIT RATING<br>";
  89.         break;
  90.         case 18:
  91.         $statonetype = (string)$statoneval." SPELL HIT RATING<br>";
  92.         break;
  93.         case 19:
  94.         $statonetype = (string)$statoneval." MELEE CRIT RATING<br>";
  95.         break;
  96.         case 20:
  97.         $statonetype = (string)$statoneval." RANGED CRIT RATING<br>";
  98.         break;
  99.         case 21:
  100.         $statonetype = (string)$statoneval." SPELL CRIT RATING<br>";
  101.         break;
  102.         case 22:
  103.         $statonetype = (string)$statoneval." MELEE HIT AVOIDANCE<br>";
  104.         break;
  105.         case 23:
  106.         $statonetype = (string)$statoneval." RANGED HIT AVOIDANCE<br>";
  107.         break;
  108.         case 24:
  109.         $statonetype = (string)$statoneval." SPELL HIT AVOIDANCE<br>";
  110.         break;
  111.         case 25:
  112.         $statonetype = (string)$statoneval." MELEE CRIT AVOIDANCE<br>";
  113.         break;
  114.         case 26:
  115.         $statonetype = (string)$statoneval." RANGED CRIT AVOIDANCE<br>";
  116.         break;
  117.         case 27:
  118.         $statonetype = (string)$statoneval." SPELL CRIT AVOIDANCE<br>";
  119.         break;
  120.         case 28:
  121.         $statonetype = (string)$statoneval." MELEE HASTE RATING<br>";
  122.         break;
  123.         case 29:
  124.         $statonetype = (string)$statoneval." RANGED HASTE RATING<br>";
  125.         break;
  126.         case 30:
  127.         $statonetype = (string)$statoneval." SPELL HASTE<br>";
  128.         break;
  129.         case 31:
  130.         $statonetype = (string)$statoneval." HIT RATING<br>";
  131.         break;
  132.         case 32:
  133.         $statonetype = (string)$statoneval." CRIT RATING<br>";
  134.         break;
  135.         case 33:
  136.         $statonetype = (string)$statoneval." HIT AVOIDANCE<br>";
  137.         break;
  138.         case 34:
  139.         $statonetype = (string)$statoneval." CRIT AVOIDANCE<br>";
  140.         break;
  141.         case 35:
  142.         $statonetype = (string)$statoneval." RESILIENCE<br>";
  143.         break;
  144.         case 36:
  145.         $statonetype = (string)$statoneval." HASTE RATING<br>";
  146.         break;
  147.         case 37:
  148.         $statonetype = (string)$statoneval." EXPERTISE RATING<br>";
  149.         break;
  150.         case 38:
  151.         $statonetype = (string)$statoneval." ATTACK POWER<br>";
  152.         break;
  153.         case 39:
  154.         $statonetype = (string)$statoneval." RANGED ATTACK POWER<br>";
  155.         break;
  156.         case 40:
  157.         $statonetype = (string)$statoneval." FERAL ATTACK POWER<br>";
  158.         break;
  159.         case 41:
  160.         $statonetype = (string)$statoneval." SPELL HEALING<br>";
  161.         break;
  162.         case 42:
  163.         $statonetype = (string)$statoneval." SPELL DAMAGE<br>";
  164.         break;
  165.         case 43:
  166.         $statonetype = (string)$statoneval." MANA REGEN<br>";
  167.         break;
  168.         case 44:
  169.         $statonetype = (string)$statoneval." ARMOR PENETRATION<br>";
  170.         break;
  171.         case 45:
  172.         $statonetype = (string)$statoneval." SPELL POWER<br>";
  173.         break;
  174.         case 46:
  175.         $statonetype = (string)$statoneval." HEALTH REGEN<br>";
  176.         break;
  177.         case 47:
  178.         $statonetype = (string)$statoneval." SPELL PENETRATION<br>";
  179.         break;
  180.         case 48:
  181.         $statonetype = (string)$statoneval." BLOCK VALUE<br>";
  182.         break;
  183.     }
  184.     switch ($stattwotype){
  185.         case 0:
  186.         $stattwotype = (string)$stattwoval." MANA<br>";
  187.         break;
  188.         case 1:
  189.         $stattwotype = (string)$stattwoval." HEALTH<br>";
  190.         break;
  191.         case 2:
  192.         $stattwotype = (string)$stattwoval." UNKNOWN<br>";
  193.         break;
  194.         case 3:
  195.         $stattwotype = (string)$stattwoval." AGILITY<br>";
  196.         break;
  197.         case 4:
  198.         $stattwotype = (string)$stattwoval." STRENGTH<br>";
  199.         break;
  200.         case 5:
  201.         $stattwotype = (string)$stattwoval." INTELLECT<br>";
  202.         break;
  203.         case 6:
  204.         $stattwotype = (string)$stattwoval." SPIRIT<br>";
  205.         break;
  206.         case 7:
  207.         $stattwotype = (string)$stattwoval." STAMINA<br>";
  208.         break;
  209.         case 11:
  210.         $stattwotype = (string)$stattwoval." WEAPON SKILL RATING<br>";
  211.         break;
  212.         case 12:
  213.         $stattwotype = (string)$stattwoval." DEFENSE RATING<br>";
  214.         break;
  215.         case 13:
  216.         $stattwotype = (string)$stattwoval." DODGE RATING<br>";
  217.         break;
  218.         case 14:
  219.         $stattwotype = (string)$stattwoval." PARRY RATING<br>";
  220.         break;
  221.         case 15:
  222.         $stattwotype = (string)$stattwoval." SHIELD BLOCK RATING<br>";
  223.         break;
  224.         case 16:
  225.         $stattwotype = (string)$stattwoval." MELEE HIT RATING<br>";
  226.         break;
  227.         case 17:
  228.         $stattwotype = (string)$stattwoval." RANGED HIT RATING<br>";
  229.         break;
  230.         case 18:
  231.         $stattwotype = (string)$stattwoval." SPELL HIT RATING<br>";
  232.         break;
  233.         case 19:
  234.         $stattwotype = (string)$stattwoval." MELEE CRIT RATING<br>";
  235.         break;
  236.         case 20:
  237.         $stattwotype = (string)$stattwoval." RANGED CRIT RATING<br>";
  238.         break;
  239.         case 21:
  240.         $stattwotype = (string)$stattwoval." SPELL CRIT RATING<br>";
  241.         break;
  242.         case 22:
  243.         $stattwotype = (string)$stattwoval." MELEE HIT AVOIDANCE<br>";
  244.         break;
  245.         case 23:
  246.         $stattwotype = (string)$stattwoval." RANGED HIT AVOIDANCE<br>";
  247.         break;
  248.         case 24:
  249.         $stattwotype = (string)$stattwoval." SPELL HIT AVOIDANCE<br>";
  250.         break;
  251.         case 25:
  252.         $stattwotype = (string)$stattwoval." MELEE CRIT AVOIDANCE<br>";
  253.         break;
  254.         case 26:
  255.         $stattwotype = (string)$stattwoval." RANGED CRIT AVOIDANCE<br>";
  256.         break;
  257.         case 27:
  258.         $stattwotype = (string)$stattwoval." SPELL CRIT AVOIDANCE<br>";
  259.         break;
  260.         case 28:
  261.         $stattwotype = (string)$stattwoval." MELEE HASTE RATING<br>";
  262.         break;
  263.         case 29:
  264.         $stattwotype = (string)$stattwoval." RANGED HASTE RATING<br>";
  265.         break;
  266.         case 30:
  267.         $stattwotype = (string)$stattwoval." SPELL HASTE<br>";
  268.         break;
  269.         case 31:
  270.         $stattwotype = (string)$stattwoval." HIT RATING<br>";
  271.         break;
  272.         case 32:
  273.         $stattwotype = (string)$stattwoval." CRIT RATING<br>";
  274.         break;
  275.         case 33:
  276.         $stattwotype = (string)$stattwoval." HIT AVOIDANCE<br>";
  277.         break;
  278.         case 34:
  279.         $stattwotype = (string)$stattwoval." CRIT AVOIDANCE<br>";
  280.         break;
  281.         case 35:
  282.         $stattwotype = (string)$stattwoval." RESILIENCE<br>";
  283.         break;
  284.         case 36:
  285.         $stattwotype = (string)$stattwoval." HASTE RATING<br>";
  286.         break;
  287.         case 37:
  288.         $stattwotype = (string)$stattwoval." EXPERTISE RATING<br>";
  289.         break;
  290.         case 38:
  291.         $stattwotype = (string)$stattwoval." ATTACK POWER<br>";
  292.         break;
  293.         case 39:
  294.         $stattwotype = (string)$stattwoval." RANGED ATTACK POWER<br>";
  295.         break;
  296.         case 40:
  297.         $stattwotype = (string)$stattwoval." FERAL ATTACK POWER<br>";
  298.         break;
  299.         case 41:
  300.         $stattwotype = (string)$stattwoval." SPELL HEALING<br>";
  301.         break;
  302.         case 42:
  303.         $stattwotype = (string)$stattwoval." SPELL DAMAGE<br>";
  304.         break;
  305.         case 43:
  306.         $stattwotype = (string)$stattwoval." MANA REGEN<br>";
  307.         break;
  308.         case 44:
  309.         $stattwotype = (string)$stattwoval." ARMOR PENETRATION<br>";
  310.         break;
  311.         case 45:
  312.         $stattwotype = (string)$stattwoval." SPELL POWER<br>";
  313.         break;
  314.         case 46:
  315.         $stattwotype = (string)$stattwoval." HEALTH REGEN<br>";
  316.         break;
  317.         case 47:
  318.         $stattwotype = (string)$stattwoval." SPELL PENETRATION<br>";
  319.         break;
  320.         case 48:
  321.         $stattwotype = (string)$stattwoval." BLOCK VALUE<br>";
  322.         break;
  323.     }
  324.     switch ($statthreetype){
  325.         case 0:
  326.         $statthreetype = (string)$statthreeval." MANA<br>";
  327.         break;
  328.         case 1:
  329.         $statthreetype = (string)$statthreeval." HEALTH<br>";
  330.         break;
  331.         case 2:
  332.         $statthreetype = (string)$statthreeval." UNKNOWN<br>";
  333.         break;
  334.         case 3:
  335.         $statthreetype = (string)$statthreeval." AGILITY<br>";
  336.         break;
  337.         case 4:
  338.         $statthreetype = (string)$statthreeval." STRENGTH<br>";
  339.         break;
  340.         case 5:
  341.         $statthreetype = (string)$statthreeval." INTELLECT<br>";
  342.         break;
  343.         case 6:
  344.         $statthreetype = (string)$statthreeval." SPIRIT<br>";
  345.         break;
  346.         case 7:
  347.         $statthreetype = (string)$statthreeval." STAMINA<br>";
  348.         break;
  349.         case 11:
  350.         $statthreetype = (string)$statthreeval." WEAPON SKILL RATING<br>";
  351.         break;
  352.         case 12:
  353.         $statthreetype = (string)$statthreeval." DEFENSE RATING<br>";
  354.         break;
  355.         case 13:
  356.         $statthreetype = (string)$statthreeval." DODGE RATING<br>";
  357.         break;
  358.         case 14:
  359.         $statthreetype = (string)$statthreeval." PARRY RATING<br>";
  360.         break;
  361.         case 15:
  362.         $statthreetype = (string)$statthreeval." SHIELD BLOCK RATING<br>";
  363.         break;
  364.         case 16:
  365.         $statthreetype = (string)$statthreeval." MELEE HIT RATING<br>";
  366.         break;
  367.         case 17:
  368.         $statthreetype = (string)$statthreeval." RANGED HIT RATING<br>";
  369.         break;
  370.         case 18:
  371.         $statthreetype = (string)$statthreeval." SPELL HIT RATING<br>";
  372.         break;
  373.         case 19:
  374.         $statthreetype = (string)$statthreeval." MELEE CRIT RATING<br>";
  375.         break;
  376.         case 20:
  377.         $statthreetype = (string)$statthreeval." RANGED CRIT RATING<br>";
  378.         break;
  379.         case 21:
  380.         $statthreetype = (string)$statthreeval." SPELL CRIT RATING<br>";
  381.         break;
  382.         case 22:
  383.         $statthreetype = (string)$statthreeval." MELEE HIT AVOIDANCE<br>";
  384.         break;
  385.         case 23:
  386.         $statthreetype = (string)$statthreeval." RANGED HIT AVOIDANCE<br>";
  387.         break;
  388.         case 24:
  389.         $statthreetype = (string)$statthreeval." SPELL HIT AVOIDANCE<br>";
  390.         break;
  391.         case 25:
  392.         $statthreetype = (string)$statthreeval." MELEE CRIT AVOIDANCE<br>";
  393.         break;
  394.         case 26:
  395.         $statthreetype = (string)$statthreeval." RANGED CRIT AVOIDANCE<br>";
  396.         break;
  397.         case 27:
  398.         $statthreetype = (string)$statthreeval." SPELL CRIT AVOIDANCE<br>";
  399.         break;
  400.         case 28:
  401.         $statthreetype = (string)$statthreeval." MELEE HASTE RATING<br>";
  402.         break;
  403.         case 29:
  404.         $statthreetype = (string)$statthreeval." RANGED HASTE RATING<br>";
  405.         break;
  406.         case 30:
  407.         $statthreetype = (string)$statthreeval." SPELL HASTE<br>";
  408.         break;
  409.         case 31:
  410.         $statthreetype = (string)$statthreeval." HIT RATING<br>";
  411.         break;
  412.         case 32:
  413.         $statthreetype = (string)$statthreeval." CRIT RATING<br>";
  414.         break;
  415.         case 33:
  416.         $statthreetype = (string)$statthreeval." HIT AVOIDANCE<br>";
  417.         break;
  418.         case 34:
  419.         $statthreetype = (string)$statthreeval." CRIT AVOIDANCE<br>";
  420.         break;
  421.         case 35:
  422.         $statthreetype = (string)$statthreeval." RESILIENCE<br>";
  423.         break;
  424.         case 36:
  425.         $statthreetype = (string)$statthreeval." HASTE RATING<br>";
  426.         break;
  427.         case 37:
  428.         $statthreetype = (string)$statthreeval." EXPERTISE RATING<br>";
  429.         break;
  430.         case 38:
  431.         $statthreetype = (string)$statthreeval." ATTACK POWER<br>";
  432.         break;
  433.         case 39:
  434.         $statthreetype = (string)$statthreeval." RANGED ATTACK POWER<br>";
  435.         break;
  436.         case 40:
  437.         $statthreetype = (string)$statthreeval." FERAL ATTACK POWER<br>";
  438.         break;
  439.         case 41:
  440.         $statthreetype = (string)$statthreeval." SPELL HEALING<br>";
  441.         break;
  442.         case 42:
  443.         $statthreetype = (string)$statthreeval." SPELL DAMAGE<br>";
  444.         break;
  445.         case 43:
  446.         $statthreetype = (string)$statthreeval." MANA REGEN<br>";
  447.         break;
  448.         case 44:
  449.         $statthreetype = (string)$statthreeval." ARMOR PENETRATION<br>";
  450.         break;
  451.         case 45:
  452.         $statthreetype = (string)$statthreeval." SPELL POWER<br>";
  453.         break;
  454.         case 46:
  455.         $statthreetype = (string)$statthreeval." HEALTH REGEN<br>";
  456.         break;
  457.         case 47:
  458.         $statthreetype = (string)$statthreeval." SPELL PENETRATION<br>";
  459.         break;
  460.         case 48:
  461.         $statthreetype = (string)$statthreeval." BLOCK VALUE<br>";
  462.         break;
  463.     }
  464.     switch ($statfourtype){
  465.         case 0:
  466.         $statfourtype = (string)$statfourval." MANA<br>";
  467.         break;
  468.         case 1:
  469.         $statfourtype = (string)$statfourval." HEALTH<br>";
  470.         break;
  471.         case 2:
  472.         $statfourtype = (string)$statfourval." UNKNOWN<br>";
  473.         break;
  474.         case 3:
  475.         $statfourtype = (string)$statfourval." AGILITY<br>";
  476.         break;
  477.         case 4:
  478.         $statfourtype = (string)$statfourval." STRENGTH<br>";
  479.         break;
  480.         case 5:
  481.         $statfourtype = (string)$statfourval." INTELLECT<br>";
  482.         break;
  483.         case 6:
  484.         $statfourtype = (string)$statfourval." SPIRIT<br>";
  485.         break;
  486.         case 7:
  487.         $statfourtype = (string)$statfourval." STAMINA<br>";
  488.         break;
  489.         case 11:
  490.         $statfourtype = (string)$statfourval." WEAPON SKILL RATING<br>";
  491.         break;
  492.         case 12:
  493.         $statfourtype = (string)$statfourval." DEFENSE RATING<br>";
  494.         break;
  495.         case 13:
  496.         $statfourtype = (string)$statfourval." DODGE RATING<br>";
  497.         break;
  498.         case 14:
  499.         $statfourtype = (string)$statfourval." PARRY RATING<br>";
  500.         break;
  501.         case 15:
  502.         $statfourtype = (string)$statfourval." SHIELD BLOCK RATING<br>";
  503.         break;
  504.         case 16:
  505.         $statfourtype = (string)$statfourval." MELEE HIT RATING<br>";
  506.         break;
  507.         case 17:
  508.         $statfourtype = (string)$statfourval." RANGED HIT RATING<br>";
  509.         break;
  510.         case 18:
  511.         $statfourtype = (string)$statfourval." SPELL HIT RATING<br>";
  512.         break;
  513.         case 19:
  514.         $statfourtype = (string)$statfourval." MELEE CRIT RATING<br>";
  515.         break;
  516.         case 20:
  517.         $statfourtype = (string)$statfourval." RANGED CRIT RATING<br>";
  518.         break;
  519.         case 21:
  520.         $statfourtype = (string)$statfourval." SPELL CRIT RATING<br>";
  521.         break;
  522.         case 22:
  523.         $statfourtype = (string)$statfourval." MELEE HIT AVOIDANCE<br>";
  524.         break;
  525.         case 23:
  526.         $statfourtype = (string)$statfourval." RANGED HIT AVOIDANCE<br>";
  527.         break;
  528.         case 24:
  529.         $statfourtype = (string)$statfourval." SPELL HIT AVOIDANCE<br>";
  530.         break;
  531.         case 25:
  532.         $statfourtype = (string)$statfourval." MELEE CRIT AVOIDANCE<br>";
  533.         break;
  534.         case 26:
  535.         $statfourtype = (string)$statfourval." RANGED CRIT AVOIDANCE<br>";
  536.         break;
  537.         case 27:
  538.         $statfourtype = (string)$statfourval." SPELL CRIT AVOIDANCE<br>";
  539.         break;
  540.         case 28:
  541.         $statfourtype = (string)$statfourval." MELEE HASTE RATING<br>";
  542.         break;
  543.         case 29:
  544.         $statfourtype = (string)$statfourval." RANGED HASTE RATING<br>";
  545.         break;
  546.         case 30:
  547.         $statfourtype = (string)$statfourval." SPELL HASTE<br>";
  548.         break;
  549.         case 31:
  550.         $statfourtype = (string)$statfourval." HIT RATING<br>";
  551.         break;
  552.         case 32:
  553.         $statfourtype = (string)$statfourval." CRIT RATING<br>";
  554.         break;
  555.         case 33:
  556.         $statfourtype = (string)$statfourval." HIT AVOIDANCE<br>";
  557.         break;
  558.         case 34:
  559.         $statfourtype = (string)$statfourval." CRIT AVOIDANCE<br>";
  560.         break;
  561.         case 35:
  562.         $statfourtype = (string)$statfourval." RESILIENCE<br>";
  563.         break;
  564.         case 36:
  565.         $statfourtype = (string)$statfourval." HASTE RATING<br>";
  566.         break;
  567.         case 37:
  568.         $statfourtype = (string)$statfourval." EXPERTISE RATING<br>";
  569.         break;
  570.         case 38:
  571.         $statfourtype = (string)$statfourval." ATTACK POWER<br>";
  572.         break;
  573.         case 39:
  574.         $statfourtype = (string)$statfourval." RANGED ATTACK POWER<br>";
  575.         break;
  576.         case 40:
  577.         $statfourtype = (string)$statfourval." FERAL ATTACK POWER<br>";
  578.         break;
  579.         case 41:
  580.         $statfourtype = (string)$statfourval." SPELL HEALING<br>";
  581.         break;
  582.         case 42:
  583.         $statfourtype = (string)$statfourval." SPELL DAMAGE<br>";
  584.         break;
  585.         case 43:
  586.         $statfourtype = (string)$statfourval." MANA REGEN<br>";
  587.         break;
  588.         case 44:
  589.         $statfourtype = (string)$statfourval." ARMOR PENETRATION<br>";
  590.         break;
  591.         case 45:
  592.         $statfourtype = (string)$statfourval." SPELL POWER<br>";
  593.         break;
  594.         case 46:
  595.         $statfourtype = (string)$statfourval." HEALTH REGEN<br>";
  596.         break;
  597.         case 47:
  598.         $statfourtype = (string)$statfourval." SPELL PENETRATION<br>";
  599.         break;
  600.         case 48:
  601.         $statfourtype = (string)$statfourval." BLOCK VALUE<br>";
  602.         break;
  603.     }
  604.     switch ($statfivetype){
  605.         case 0:
  606.         $statfivetype = (string)$statfiveval." MANA<br>";
  607.         break;
  608.         case 1:
  609.         $statfivetype = (string)$statfiveval." HEALTH<br>";
  610.         break;
  611.         case 2:
  612.         $statfivetype = (string)$statfiveval." UNKNOWN<br>";
  613.         break;
  614.         case 3:
  615.         $statfivetype = (string)$statfiveval." AGILITY<br>";
  616.         break;
  617.         case 4:
  618.         $statfivetype = (string)$statfiveval." STRENGTH<br>";
  619.         break;
  620.         case 5:
  621.         $statfivetype = (string)$statfiveval." INTELLECT<br>";
  622.         break;
  623.         case 6:
  624.         $statfivetype = (string)$statfiveval." SPIRIT<br>";
  625.         break;
  626.         case 7:
  627.         $statfivetype = (string)$statfiveval." STAMINA<br>";
  628.         break;
  629.         case 11:
  630.         $statfivetype = (string)$statfiveval." WEAPON SKILL RATING<br>";
  631.         break;
  632.         case 12:
  633.         $statfivetype = (string)$statfiveval." DEFENSE RATING<br>";
  634.         break;
  635.         case 13:
  636.         $statfivetype = (string)$statfiveval." DODGE RATING<br>";
  637.         break;
  638.         case 14:
  639.         $statfivetype = (string)$statfiveval." PARRY RATING<br>";
  640.         break;
  641.         case 15:
  642.         $statfivetype = (string)$statfiveval." SHIELD BLOCK RATING<br>";
  643.         break;
  644.         case 16:
  645.         $statfivetype = (string)$statfiveval." MELEE HIT RATING<br>";
  646.         break;
  647.         case 17:
  648.         $statfivetype = (string)$statfiveval." RANGED HIT RATING<br>";
  649.         break;
  650.         case 18:
  651.         $statfivetype = (string)$statfiveval." SPELL HIT RATING<br>";
  652.         break;
  653.         case 19:
  654.         $statfivetype = (string)$statfiveval." MELEE CRIT RATING<br>";
  655.         break;
  656.         case 20:
  657.         $statfivetype = (string)$statfiveval." RANGED CRIT RATING<br>";
  658.         break;
  659.         case 21:
  660.         $statfivetype = (string)$statfiveval." SPELL CRIT RATING<br>";
  661.         break;
  662.         case 22:
  663.         $statfivetype = (string)$statfiveval." MELEE HIT AVOIDANCE<br>";
  664.         break;
  665.         case 23:
  666.         $statfivetype = (string)$statfiveval." RANGED HIT AVOIDANCE<br>";
  667.         break;
  668.         case 24:
  669.         $statfivetype = (string)$statfiveval." SPELL HIT AVOIDANCE<br>";
  670.         break;
  671.         case 25:
  672.         $statfivetype = (string)$statfiveval." MELEE CRIT AVOIDANCE<br>";
  673.         break;
  674.         case 26:
  675.         $statfivetype = (string)$statfiveval." RANGED CRIT AVOIDANCE<br>";
  676.         break;
  677.         case 27:
  678.         $statfivetype = (string)$statfiveval." SPELL CRIT AVOIDANCE<br>";
  679.         break;
  680.         case 28:
  681.         $statfivetype = (string)$statfiveval." MELEE HASTE RATING<br>";
  682.         break;
  683.         case 29:
  684.         $statfivetype = (string)$statfiveval." RANGED HASTE RATING<br>";
  685.         break;
  686.         case 30:
  687.         $statfivetype = (string)$statfiveval." SPELL HASTE<br>";
  688.         break;
  689.         case 31:
  690.         $statfivetype = (string)$statfiveval." HIT RATING<br>";
  691.         break;
  692.         case 32:
  693.         $statfivetype = (string)$statfiveval." CRIT RATING<br>";
  694.         break;
  695.         case 33:
  696.         $statfivetype = (string)$statfiveval." HIT AVOIDANCE<br>";
  697.         break;
  698.         case 34:
  699.         $statfivetype = (string)$statfiveval." CRIT AVOIDANCE<br>";
  700.         break;
  701.         case 35:
  702.         $statfivetype = (string)$statfiveval." RESILIENCE<br>";
  703.         break;
  704.         case 36:
  705.         $statfivetype = (string)$statfiveval." HASTE RATING<br>";
  706.         break;
  707.         case 37:
  708.         $statfivetype = (string)$statfiveval." EXPERTISE RATING<br>";
  709.         break;
  710.         case 38:
  711.         $statfivetype = (string)$statfiveval." ATTACK POWER<br>";
  712.         break;
  713.         case 39:
  714.         $statfivetype = (string)$statfiveval." RANGED ATTACK POWER<br>";
  715.         break;
  716.         case 40:
  717.         $statfivetype = (string)$statfiveval." FERAL ATTACK POWER<br>";
  718.         break;
  719.         case 41:
  720.         $statfivetype = (string)$statfiveval." SPELL HEALING<br>";
  721.         break;
  722.         case 42:
  723.         $statfivetype = (string)$statfiveval." SPELL DAMAGE<br>";
  724.         break;
  725.         case 43:
  726.         $statfivetype = (string)$statfiveval." MANA REGEN<br>";
  727.         break;
  728.         case 44:
  729.         $statfivetype = (string)$statfiveval." ARMOR PENETRATION<br>";
  730.         break;
  731.         case 45:
  732.         $statfivetype = (string)$statfiveval." SPELL POWER<br>";
  733.         break;
  734.         case 46:
  735.         $statfivetype = (string)$statfiveval." HEALTH REGEN<br>";
  736.         break;
  737.         case 47:
  738.         $statfivetype = (string)$statfiveval." SPELL PENETRATION<br>";
  739.         break;
  740.         case 48:
  741.         $statfivetype = (string)$statfiveval." BLOCK VALUE<br>";
  742.         break;
  743.     }
  744.     switch ($statsixtype){
  745.         case 0:
  746.         $statsixtype = (string)$statsixval." MANA<br>";
  747.         break;
  748.         case 1:
  749.         $statsixtype = (string)$statsixval." HEALTH<br>";
  750.         break;
  751.         case 2:
  752.         $statsixtype = (string)$statsixval." UNKNOWN<br>";
  753.         break;
  754.         case 3:
  755.         $statsixtype = (string)$statsixval." AGILITY<br>";
  756.         break;
  757.         case 4:
  758.         $statsixtype = (string)$statsixval." STRENGTH<br>";
  759.         break;
  760.         case 5:
  761.         $statsixtype = (string)$statsixval." INTELLECT<br>";
  762.         break;
  763.         case 6:
  764.         $statsixtype = (string)$statsixval." SPIRIT<br>";
  765.         break;
  766.         case 7:
  767.         $statsixtype = (string)$statsixval." STAMINA<br>";
  768.         break;
  769.         case 11:
  770.         $statsixtype = (string)$statsixval." WEAPON SKILL RATING<br>";
  771.         break;
  772.         case 12:
  773.         $statsixtype = (string)$statsixval." DEFENSE RATING<br>";
  774.         break;
  775.         case 13:
  776.         $statsixtype = (string)$statsixval." DODGE RATING<br>";
  777.         break;
  778.         case 14:
  779.         $statsixtype = (string)$statsixval." PARRY RATING<br>";
  780.         break;
  781.         case 15:
  782.         $statsixtype = (string)$statsixval." SHIELD BLOCK RATING<br>";
  783.         break;
  784.         case 16:
  785.         $statsixtype = (string)$statsixval." MELEE HIT RATING<br>";
  786.         break;
  787.         case 17:
  788.         $statsixtype = (string)$statsixval." RANGED HIT RATING<br>";
  789.         break;
  790.         case 18:
  791.         $statsixtype = (string)$statsixval." SPELL HIT RATING<br>";
  792.         break;
  793.         case 19:
  794.         $statsixtype = (string)$statsixval." MELEE CRIT RATING<br>";
  795.         break;
  796.         case 20:
  797.         $statsixtype = (string)$statsixval." RANGED CRIT RATING<br>";
  798.         break;
  799.         case 21:
  800.         $statsixtype = (string)$statsixval." SPELL CRIT RATING<br>";
  801.         break;
  802.         case 22:
  803.         $statsixtype = (string)$statsixval." MELEE HIT AVOIDANCE<br>";
  804.         break;
  805.         case 23:
  806.         $statsixtype = (string)$statsixval." RANGED HIT AVOIDANCE<br>";
  807.         break;
  808.         case 24:
  809.         $statsixtype = (string)$statsixval." SPELL HIT AVOIDANCE<br>";
  810.         break;
  811.         case 25:
  812.         $statsixtype = (string)$statsixval." MELEE CRIT AVOIDANCE<br>";
  813.         break;
  814.         case 26:
  815.         $statsixtype = (string)$statsixval." RANGED CRIT AVOIDANCE<br>";
  816.         break;
  817.         case 27:
  818.         $statsixtype = (string)$statsixval." SPELL CRIT AVOIDANCE<br>";
  819.         break;
  820.         case 28:
  821.         $statsixtype = (string)$statsixval." MELEE HASTE RATING<br>";
  822.         break;
  823.         case 29:
  824.         $statsixtype = (string)$statsixval." RANGED HASTE RATING<br>";
  825.         break;
  826.         case 30:
  827.         $statsixtype = (string)$statsixval." SPELL HASTE<br>";
  828.         break;
  829.         case 31:
  830.         $statsixtype = (string)$statsixval." HIT RATING<br>";
  831.         break;
  832.         case 32:
  833.         $statsixtype = (string)$statsixval." CRIT RATING<br>";
  834.         break;
  835.         case 33:
  836.         $statsixtype = (string)$statsixval." HIT AVOIDANCE<br>";
  837.         break;
  838.         case 34:
  839.         $statsixtype = (string)$statsixval." CRIT AVOIDANCE<br>";
  840.         break;
  841.         case 35:
  842.         $statsixtype = (string)$statsixval." RESILIENCE<br>";
  843.         break;
  844.         case 36:
  845.         $statsixtype = (string)$statsixval." HASTE RATING<br>";
  846.         break;
  847.         case 37:
  848.         $statsixtype = (string)$statsixval." EXPERTISE RATING<br>";
  849.         break;
  850.         case 38:
  851.         $statsixtype = (string)$statsixval." ATTACK POWER<br>";
  852.         break;
  853.         case 39:
  854.         $statsixtype = (string)$statsixval." RANGED ATTACK POWER<br>";
  855.         break;
  856.         case 40:
  857.         $statsixtype = (string)$statsixval." FERAL ATTACK POWER<br>";
  858.         break;
  859.         case 41:
  860.         $statsixtype = (string)$statsixval." SPELL HEALING<br>";
  861.         break;
  862.         case 42:
  863.         $statsixtype = (string)$statsixval." SPELL DAMAGE<br>";
  864.         break;
  865.         case 43:
  866.         $statsixtype = (string)$statsixval." MANA REGEN<br>";
  867.         break;
  868.         case 44:
  869.         $statsixtype = (string)$statsixval." ARMOR PENETRATION<br>";
  870.         break;
  871.         case 45:
  872.         $statsixtype = (string)$statsixval." SPELL POWER<br>";
  873.         break;
  874.         case 46:
  875.         $statsixtype = (string)$statsixval." HEALTH REGEN<br>";
  876.         break;
  877.         case 47:
  878.         $statsixtype = (string)$statsixval." SPELL PENETRATION<br>";
  879.         break;
  880.         case 48:
  881.         $statsixtype = (string)$statsixval." BLOCK VALUE<br>";
  882.         break;
  883.     }
  884.     switch ($statseventype){
  885.         case 0:
  886.         $statseventype = (string)$statsevenval." MANA<br>";
  887.         break;
  888.         case 1:
  889.         $statseventype = (string)$statsevenval." HEALTH<br>";
  890.         break;
  891.         case 2:
  892.         $statseventype = (string)$statsevenval." UNKNOWN<br>";
  893.         break;
  894.         case 3:
  895.         $statseventype = (string)$statsevenval." AGILITY<br>";
  896.         break;
  897.         case 4:
  898.         $statseventype = (string)$statsevenval." STRENGTH<br>";
  899.         break;
  900.         case 5:
  901.         $statseventype = (string)$statsevenval." INTELLECT<br>";
  902.         break;
  903.         case 6:
  904.         $statseventype = (string)$statsevenval." SPIRIT<br>";
  905.         break;
  906.         case 7:
  907.         $statseventype = (string)$statsevenval." STAMINA<br>";
  908.         break;
  909.         case 11:
  910.         $statseventype = (string)$statsevenval." WEAPON SKILL RATING<br>";
  911.         break;
  912.         case 12:
  913.         $statseventype = (string)$statsevenval." DEFENSE RATING<br>";
  914.         break;
  915.         case 13:
  916.         $statseventype = (string)$statsevenval." DODGE RATING<br>";
  917.         break;
  918.         case 14:
  919.         $statseventype = (string)$statsevenval." PARRY RATING<br>";
  920.         break;
  921.         case 15:
  922.         $statseventype = (string)$statsevenval." SHIELD BLOCK RATING<br>";
  923.         break;
  924.         case 16:
  925.         $statseventype = (string)$statsevenval." MELEE HIT RATING<br>";
  926.         break;
  927.         case 17:
  928.         $statseventype = (string)$statsevenval." RANGED HIT RATING<br>";
  929.         break;
  930.         case 18:
  931.         $statseventype = (string)$statsevenval." SPELL HIT RATING<br>";
  932.         break;
  933.         case 19:
  934.         $statseventype = (string)$statsevenval." MELEE CRIT RATING<br>";
  935.         break;
  936.         case 20:
  937.         $statseventype = (string)$statsevenval." RANGED CRIT RATING<br>";
  938.         break;
  939.         case 21:
  940.         $statseventype = (string)$statsevenval." SPELL CRIT RATING<br>";
  941.         break;
  942.         case 22:
  943.         $statseventype = (string)$statsevenval." MELEE HIT AVOIDANCE<br>";
  944.         break;
  945.         case 23:
  946.         $statseventype = (string)$statsevenval." RANGED HIT AVOIDANCE<br>";
  947.         break;
  948.         case 24:
  949.         $statseventype = (string)$statsevenval." SPELL HIT AVOIDANCE<br>";
  950.         break;
  951.         case 25:
  952.         $statseventype = (string)$statsevenval." MELEE CRIT AVOIDANCE<br>";
  953.         break;
  954.         case 26:
  955.         $statseventype = (string)$statsevenval." RANGED CRIT AVOIDANCE<br>";
  956.         break;
  957.         case 27:
  958.         $statseventype = (string)$statsevenval." SPELL CRIT AVOIDANCE<br>";
  959.         break;
  960.         case 28:
  961.         $statseventype = (string)$statsevenval." MELEE HASTE RATING<br>";
  962.         break;
  963.         case 29:
  964.         $statseventype = (string)$statsevenval." RANGED HASTE RATING<br>";
  965.         break;
  966.         case 30:
  967.         $statseventype = (string)$statsevenval." SPELL HASTE<br>";
  968.         break;
  969.         case 31:
  970.         $statseventype = (string)$statsevenval." HIT RATING<br>";
  971.         break;
  972.         case 32:
  973.         $statseventype = (string)$statsevenval." CRIT RATING<br>";
  974.         break;
  975.         case 33:
  976.         $statseventype = (string)$statsevenval." HIT AVOIDANCE<br>";
  977.         break;
  978.         case 34:
  979.         $statseventype = (string)$statsevenval." CRIT AVOIDANCE<br>";
  980.         break;
  981.         case 35:
  982.         $statseventype = (string)$statsevenval." RESILIENCE<br>";
  983.         break;
  984.         case 36:
  985.         $statseventype = (string)$statsevenval." HASTE RATING<br>";
  986.         break;
  987.         case 37:
  988.         $statseventype = (string)$statsevenval." EXPERTISE RATING<br>";
  989.         break;
  990.         case 38:
  991.         $statseventype = (string)$statsevenval." ATTACK POWER<br>";
  992.         break;
  993.         case 39:
  994.         $statseventype = (string)$statsevenval." RANGED ATTACK POWER<br>";
  995.         break;
  996.         case 40:
  997.         $statseventype = (string)$statsevenval." FERAL ATTACK POWER<br>";
  998.         break;
  999.         case 41:
  1000.         $statseventype = (string)$statsevenval." SPELL HEALING<br>";
  1001.         break;
  1002.         case 42:
  1003.         $statseventype = (string)$statsevenval." SPELL DAMAGE<br>";
  1004.         break;
  1005.         case 43:
  1006.         $statseventype = (string)$statsevenval." MANA REGEN<br>";
  1007.         break;
  1008.         case 44:
  1009.         $statseventype = (string)$statsevenval." ARMOR PENETRATION<br>";
  1010.         break;
  1011.         case 45:
  1012.         $statseventype = (string)$statsevenval." SPELL POWER<br>";
  1013.         break;
  1014.         case 46:
  1015.         $statseventype = (string)$statsevenval." HEALTH REGEN<br>";
  1016.         break;
  1017.         case 47:
  1018.         $statseventype = (string)$statsevenval." SPELL PENETRATION<br>";
  1019.         break;
  1020.         case 48:
  1021.         $statseventype = (string)$statsevenval." BLOCK VALUE<br>";
  1022.         break;
  1023.     }
  1024.     switch ($stateighttype){
  1025.         case 0:
  1026.         $stateighttype = (string)$stateightval." MANA<br>";
  1027.         break;
  1028.         case 1:
  1029.         $stateighttype = (string)$stateightval." HEALTH<br>";
  1030.         break;
  1031.         case 2:
  1032.         $stateighttype = (string)$stateightval." UNKNOWN<br>";
  1033.         break;
  1034.         case 3:
  1035.         $stateighttype = (string)$stateightval." AGILITY<br>";
  1036.         break;
  1037.         case 4:
  1038.         $stateighttype = (string)$stateightval." STRENGTH<br>";
  1039.         break;
  1040.         case 5:
  1041.         $stateighttype = (string)$stateightval." INTELLECT<br>";
  1042.         break;
  1043.         case 6:
  1044.         $stateighttype = (string)$stateightval." SPIRIT<br>";
  1045.         break;
  1046.         case 7:
  1047.         $stateighttype = (string)$stateightval." STAMINA<br>";
  1048.         break;
  1049.         case 11:
  1050.         $stateighttype = (string)$stateightval." WEAPON SKILL RATING<br>";
  1051.         break;
  1052.         case 12:
  1053.         $stateighttype = (string)$stateightval." DEFENSE RATING<br>";
  1054.         break;
  1055.         case 13:
  1056.         $stateighttype = (string)$stateightval." DODGE RATING<br>";
  1057.         break;
  1058.         case 14:
  1059.         $stateighttype = (string)$stateightval." PARRY RATING<br>";
  1060.         break;
  1061.         case 15:
  1062.         $stateighttype = (string)$stateightval." SHIELD BLOCK RATING<br>";
  1063.         break;
  1064.         case 16:
  1065.         $stateighttype = (string)$stateightval." MELEE HIT RATING<br>";
  1066.         break;
  1067.         case 17:
  1068.         $stateighttype = (string)$stateightval." RANGED HIT RATING<br>";
  1069.         break;
  1070.         case 18:
  1071.         $stateighttype = (string)$stateightval." SPELL HIT RATING<br>";
  1072.         break;
  1073.         case 19:
  1074.         $stateighttype = (string)$stateightval." MELEE CRIT RATING<br>";
  1075.         break;
  1076.         case 20:
  1077.         $stateighttype = (string)$stateightval." RANGED CRIT RATING<br>";
  1078.         break;
  1079.         case 21:
  1080.         $stateighttype = (string)$stateightval." SPELL CRIT RATING<br>";
  1081.         break;
  1082.         case 22:
  1083.         $stateighttype = (string)$stateightval." MELEE HIT AVOIDANCE<br>";
  1084.         break;
  1085.         case 23:
  1086.         $stateighttype = (string)$stateightval." RANGED HIT AVOIDANCE<br>";
  1087.         break;
  1088.         case 24:
  1089.         $stateighttype = (string)$stateightval." SPELL HIT AVOIDANCE<br>";
  1090.         break;
  1091.         case 25:
  1092.         $stateighttype = (string)$stateightval." MELEE CRIT AVOIDANCE<br>";
  1093.         break;
  1094.         case 26:
  1095.         $stateighttype = (string)$stateightval." RANGED CRIT AVOIDANCE<br>";
  1096.         break;
  1097.         case 27:
  1098.         $stateighttype = (string)$stateightval." SPELL CRIT AVOIDANCE<br>";
  1099.         break;
  1100.         case 28:
  1101.         $stateighttype = (string)$stateightval." MELEE HASTE RATING<br>";
  1102.         break;
  1103.         case 29:
  1104.         $stateighttype = (string)$stateightval." RANGED HASTE RATING<br>";
  1105.         break;
  1106.         case 30:
  1107.         $stateighttype = (string)$stateightval." SPELL HASTE<br>";
  1108.         break;
  1109.         case 31:
  1110.         $stateighttype = (string)$stateightval." HIT RATING<br>";
  1111.         break;
  1112.         case 32:
  1113.         $stateighttype = (string)$stateightval." CRIT RATING<br>";
  1114.         break;
  1115.         case 33:
  1116.         $stateighttype = (string)$stateightval." HIT AVOIDANCE<br>";
  1117.         break;
  1118.         case 34:
  1119.         $stateighttype = (string)$stateightval." CRIT AVOIDANCE<br>";
  1120.         break;
  1121.         case 35:
  1122.         $stateighttype = (string)$stateightval." RESILIENCE<br>";
  1123.         break;
  1124.         case 36:
  1125.         $stateighttype = (string)$stateightval." HASTE RATING<br>";
  1126.         break;
  1127.         case 37:
  1128.         $stateighttype = (string)$stateightval." EXPERTISE RATING<br>";
  1129.         break;
  1130.         case 38:
  1131.         $stateighttype = (string)$stateightval." ATTACK POWER<br>";
  1132.         break;
  1133.         case 39:
  1134.         $stateighttype = (string)$stateightval." RANGED ATTACK POWER<br>";
  1135.         break;
  1136.         case 40:
  1137.         $stateighttype = (string)$stateightval." FERAL ATTACK POWER<br>";
  1138.         break;
  1139.         case 41:
  1140.         $stateighttype = (string)$stateightval." SPELL HEALING<br>";
  1141.         break;
  1142.         case 42:
  1143.         $stateighttype = (string)$stateightval." SPELL DAMAGE<br>";
  1144.         break;
  1145.         case 43:
  1146.         $stateighttype = (string)$stateightval." MANA REGEN<br>";
  1147.         break;
  1148.         case 44:
  1149.         $stateighttype = (string)$stateightval." ARMOR PENETRATION<br>";
  1150.         break;
  1151.         case 45:
  1152.         $stateighttype = (string)$stateightval." SPELL POWER<br>";
  1153.         break;
  1154.         case 46:
  1155.         $stateighttype = (string)$stateightval." HEALTH REGEN<br>";
  1156.         break;
  1157.         case 47:
  1158.         $stateighttype = (string)$stateightval." SPELL PENETRATION<br>";
  1159.         break;
  1160.         case 48:
  1161.         $stateighttype = (string)$stateightval." BLOCK VALUE<br>";
  1162.         break;
  1163.     }
  1164.     switch ($statninetype){
  1165.         case 0:
  1166.         $statninetype = (string)$statnineval." MANA<br>";
  1167.         break;
  1168.         case 1:
  1169.         $statninetype = (string)$statnineval." HEALTH<br>";
  1170.         break;
  1171.         case 2:
  1172.         $statninetype = (string)$statnineval." UNKNOWN<br>";
  1173.         break;
  1174.         case 3:
  1175.         $statninetype = (string)$statnineval." AGILITY<br>";
  1176.         break;
  1177.         case 4:
  1178.         $statninetype = (string)$statnineval." STRENGTH<br>";
  1179.         break;
  1180.         case 5:
  1181.         $statninetype = (string)$statnineval." INTELLECT<br>";
  1182.         break;
  1183.         case 6:
  1184.         $statninetype = (string)$statnineval." SPIRIT<br>";
  1185.         break;
  1186.         case 7:
  1187.         $statninetype = (string)$statnineval." STAMINA<br>";
  1188.         break;
  1189.         case 11:
  1190.         $statninetype = (string)$statnineval." WEAPON SKILL RATING<br>";
  1191.         break;
  1192.         case 12:
  1193.         $statninetype = (string)$statnineval." DEFENSE RATING<br>";
  1194.         break;
  1195.         case 13:
  1196.         $statninetype = (string)$statnineval." DODGE RATING<br>";
  1197.         break;
  1198.         case 14:
  1199.         $statninetype = (string)$statnineval." PARRY RATING<br>";
  1200.         break;
  1201.         case 15:
  1202.         $statninetype = (string)$statnineval." SHIELD BLOCK RATING<br>";
  1203.         break;
  1204.         case 16:
  1205.         $statninetype = (string)$statnineval." MELEE HIT RATING<br>";
  1206.         break;
  1207.         case 17:
  1208.         $statninetype = (string)$statnineval." RANGED HIT RATING<br>";
  1209.         break;
  1210.         case 18:
  1211.         $statninetype = (string)$statnineval." SPELL HIT RATING<br>";
  1212.         break;
  1213.         case 19:
  1214.         $statninetype = (string)$statnineval." MELEE CRIT RATING<br>";
  1215.         break;
  1216.         case 20:
  1217.         $statninetype = (string)$statnineval." RANGED CRIT RATING<br>";
  1218.         break;
  1219.         case 21:
  1220.         $statninetype = (string)$statnineval." SPELL CRIT RATING<br>";
  1221.         break;
  1222.         case 22:
  1223.         $statninetype = (string)$statnineval." MELEE HIT AVOIDANCE<br>";
  1224.         break;
  1225.         case 23:
  1226.         $statninetype = (string)$statnineval." RANGED HIT AVOIDANCE<br>";
  1227.         break;
  1228.         case 24:
  1229.         $statninetype = (string)$statnineval." SPELL HIT AVOIDANCE<br>";
  1230.         break;
  1231.         case 25:
  1232.         $statninetype = (string)$statnineval." MELEE CRIT AVOIDANCE<br>";
  1233.         break;
  1234.         case 26:
  1235.         $statninetype = (string)$statnineval." RANGED CRIT AVOIDANCE<br>";
  1236.         break;
  1237.         case 27:
  1238.         $statninetype = (string)$statnineval." SPELL CRIT AVOIDANCE<br>";
  1239.         break;
  1240.         case 28:
  1241.         $statninetype = (string)$statnineval." MELEE HASTE RATING<br>";
  1242.         break;
  1243.         case 29:
  1244.         $statninetype = (string)$statnineval." RANGED HASTE RATING<br>";
  1245.         break;
  1246.         case 30:
  1247.         $statninetype = (string)$statnineval." SPELL HASTE<br>";
  1248.         break;
  1249.         case 31:
  1250.         $statninetype = (string)$statnineval." HIT RATING<br>";
  1251.         break;
  1252.         case 32:
  1253.         $statninetype = (string)$statnineval." CRIT RATING<br>";
  1254.         break;
  1255.         case 33:
  1256.         $statninetype = (string)$statnineval." HIT AVOIDANCE<br>";
  1257.         break;
  1258.         case 34:
  1259.         $statninetype = (string)$statnineval." CRIT AVOIDANCE<br>";
  1260.         break;
  1261.         case 35:
  1262.         $statninetype = (string)$statnineval." RESILIENCE<br>";
  1263.         break;
  1264.         case 36:
  1265.         $statninetype = (string)$statnineval." HASTE RATING<br>";
  1266.         break;
  1267.         case 37:
  1268.         $statninetype = (string)$statnineval." EXPERTISE RATING<br>";
  1269.         break;
  1270.         case 38:
  1271.         $statninetype = (string)$statnineval." ATTACK POWER<br>";
  1272.         break;
  1273.         case 39:
  1274.         $statninetype = (string)$statnineval." RANGED ATTACK POWER<br>";
  1275.         break;
  1276.         case 40:
  1277.         $statninetype = (string)$statnineval." FERAL ATTACK POWER<br>";
  1278.         break;
  1279.         case 41:
  1280.         $statninetype = (string)$statnineval." SPELL HEALING<br>";
  1281.         break;
  1282.         case 42:
  1283.         $statninetype = (string)$statnineval." SPELL DAMAGE<br>";
  1284.         break;
  1285.         case 43:
  1286.         $statninetype = (string)$statnineval." MANA REGEN<br>";
  1287.         break;
  1288.         case 44:
  1289.         $statninetype = (string)$statnineval." ARMOR PENETRATION<br>";
  1290.         break;
  1291.         case 45:
  1292.         $statninetype = (string)$statnineval." SPELL POWER<br>";
  1293.         break;
  1294.         case 46:
  1295.         $statninetype = (string)$statnineval." HEALTH REGEN<br>";
  1296.         break;
  1297.         case 47:
  1298.         $statninetype = (string)$statnineval." SPELL PENETRATION<br>";
  1299.         break;
  1300.         case 48:
  1301.         $statninetype = (string)$statnineval." BLOCK VALUE<br>";
  1302.         break;
  1303.     }
  1304.     switch ($stattentype){
  1305.         case 0:
  1306.         $stattentype = (string)$stattenval." MANA<br>";
  1307.         break;
  1308.         case 1:
  1309.         $stattentype = (string)$stattenval." HEALTH<br>";
  1310.         break;
  1311.         case 2:
  1312.         $stattentype = (string)$stattenval." UNKNOWN<br>";
  1313.         break;
  1314.         case 3:
  1315.         $stattentype = (string)$stattenval." AGILITY<br>";
  1316.         break;
  1317.         case 4:
  1318.         $stattentype = (string)$stattenval." STRENGTH<br>";
  1319.         break;
  1320.         case 5:
  1321.         $stattentype = (string)$stattenval." INTELLECT<br>";
  1322.         break;
  1323.         case 6:
  1324.         $stattentype = (string)$stattenval." SPIRIT<br>";
  1325.         break;
  1326.         case 7:
  1327.         $stattentype = (string)$stattenval." STAMINA<br>";
  1328.         break;
  1329.         case 11:
  1330.         $stattentype = (string)$stattenval." WEAPON SKILL RATING<br>";
  1331.         break;
  1332.         case 12:
  1333.         $stattentype = (string)$stattenval." DEFENSE RATING<br>";
  1334.         break;
  1335.         case 13:
  1336.         $stattentype = (string)$stattenval." DODGE RATING<br>";
  1337.         break;
  1338.         case 14:
  1339.         $stattentype = (string)$stattenval." PARRY RATING<br>";
  1340.         break;
  1341.         case 15:
  1342.         $stattentype = (string)$stattenval." SHIELD BLOCK RATING<br>";
  1343.         break;
  1344.         case 16:
  1345.         $stattentype = (string)$stattenval." MELEE HIT RATING<br>";
  1346.         break;
  1347.         case 17:
  1348.         $stattentype = (string)$stattenval." RANGED HIT RATING<br>";
  1349.         break;
  1350.         case 18:
  1351.         $stattentype = (string)$stattenval." SPELL HIT RATING<br>";
  1352.         break;
  1353.         case 19:
  1354.         $stattentype = (string)$stattenval." MELEE CRIT RATING<br>";
  1355.         break;
  1356.         case 20:
  1357.         $stattentype = (string)$stattenval." RANGED CRIT RATING<br>";
  1358.         break;
  1359.         case 21:
  1360.         $stattentype = (string)$stattenval." SPELL CRIT RATING<br>";
  1361.         break;
  1362.         case 22:
  1363.         $stattentype = (string)$stattenval." MELEE HIT AVOIDANCE<br>";
  1364.         break;
  1365.         case 23:
  1366.         $stattentype = (string)$stattenval." RANGED HIT AVOIDANCE<br>";
  1367.         break;
  1368.         case 24:
  1369.         $stattentype = (string)$stattenval." SPELL HIT AVOIDANCE<br>";
  1370.         break;
  1371.         case 25:
  1372.         $stattentype = (string)$stattenval." MELEE CRIT AVOIDANCE<br>";
  1373.         break;
  1374.         case 26:
  1375.         $stattentype = (string)$stattenval." RANGED CRIT AVOIDANCE<br>";
  1376.         break;
  1377.         case 27:
  1378.         $stattentype = (string)$stattenval." SPELL CRIT AVOIDANCE<br>";
  1379.         break;
  1380.         case 28:
  1381.         $stattentype = (string)$stattenval." MELEE HASTE RATING<br>";
  1382.         break;
  1383.         case 29:
  1384.         $stattentype = (string)$stattenval." RANGED HASTE RATING<br>";
  1385.         break;
  1386.         case 30:
  1387.         $stattentype = (string)$stattenval." SPELL HASTE<br>";
  1388.         break;
  1389.         case 31:
  1390.         $stattentype = (string)$stattenval." HIT RATING<br>";
  1391.         break;
  1392.         case 32:
  1393.         $stattentype = (string)$stattenval." CRIT RATING<br>";
  1394.         break;
  1395.         case 33:
  1396.         $stattentype = (string)$stattenval." HIT AVOIDANCE<br>";
  1397.         break;
  1398.         case 34:
  1399.         $stattentype = (string)$stattenval." CRIT AVOIDANCE<br>";
  1400.         break;
  1401.         case 35:
  1402.         $stattentype = (string)$stattenval." RESILIENCE<br>";
  1403.         break;
  1404.         case 36:
  1405.         $stattentype = (string)$stattenval." HASTE RATING<br>";
  1406.         break;
  1407.         case 37:
  1408.         $stattentype = (string)$stattenval." EXPERTISE RATING<br>";
  1409.         break;
  1410.         case 38:
  1411.         $stattentype = (string)$stattenval." ATTACK POWER<br>";
  1412.         break;
  1413.         case 39:
  1414.         $stattentype = (string)$stattenval." RANGED ATTACK POWER<br>";
  1415.         break;
  1416.         case 40:
  1417.         $stattentype = (string)$stattenval." FERAL ATTACK POWER<br>";
  1418.         break;
  1419.         case 41:
  1420.         $stattentype = (string)$stattenval." SPELL HEALING<br>";
  1421.         break;
  1422.         case 42:
  1423.         $stattentype = (string)$stattenval." SPELL DAMAGE<br>";
  1424.         break;
  1425.         case 43:
  1426.         $stattentype = (string)$stattenval." MANA REGEN<br>";
  1427.         break;
  1428.         case 44:
  1429.         $stattentype = (string)$stattenval." ARMOR PENETRATION<br>";
  1430.         break;
  1431.         case 45:
  1432.         $stattentype = (string)$stattenval." SPELL POWER<br>";
  1433.         break;
  1434.         case 46:
  1435.         $stattentype = (string)$stattenval." HEALTH REGEN<br>";
  1436.         break;
  1437.         case 47:
  1438.         $stattentype = (string)$stattenval." SPELL PENETRATION<br>";
  1439.         break;
  1440.         case 48:
  1441.         $stattentype = (string)$stattenval." BLOCK VALUE<br>";
  1442.         break;
  1443.     }
  1444.     switch($class){
  1445.         case 0:
  1446.         $class = "CONSUMABLE";
  1447.         break;
  1448.         case 1:
  1449.         $class = "CONTAINER";
  1450.         break;
  1451.         case 2:
  1452.         $class = "WEAPON";
  1453.        
  1454.             $mindmg = $row['dmg_min1'];
  1455.             $maxdmg = $row['dmg_max1'];
  1456.             $damage = "$mindmg - $maxdmg DAMAGE<br>";
  1457.             $speed = $row['delay'];
  1458.             $speed = "SPEED: ".(string)$speed."<br>";
  1459.             $dps = (((double)$row['dmg_min1'] + (double)$row['dmg_max1']) / 2) / ((double)$row['delay'] / 1000);
  1460.             $dps = (string)$dps." DPS<br>";
  1461.             switch($subclass){
  1462.             case 0:
  1463.             $subclass = "ONE-HANDED AXE";
  1464.             break;
  1465.             case 1:
  1466.             $subclass = "TWO-HANDED AXE";
  1467.             break;
  1468.             case 2:
  1469.             $subclass = "BOW";
  1470.             break;
  1471.             case 3:
  1472.             $subclass = "GUN";
  1473.             break;
  1474.             case 4:
  1475.             $subclass = "ONE-HANDED MACE";
  1476.             break;
  1477.             case 5:
  1478.             $subclass = "TWO-HANDED MACE";
  1479.             break;
  1480.             case 6:
  1481.             $subclass = "POLEARM";
  1482.             break;
  1483.             case 7:
  1484.             $subclass = "ONE-HANDED SWORD";
  1485.             break;
  1486.             case 8:
  1487.             $subclass = "TWO-HANDED SWORD";
  1488.             break;
  1489.             case 10:
  1490.             $subclass = "STAFF";
  1491.             break;
  1492.             case 13:
  1493.             $subclass = "FIST WEAPON";
  1494.             break;
  1495.             case 14:
  1496.             $subclass = "MISC WEAPON";
  1497.             break;
  1498.             case 15:
  1499.             $subclass = "DAGGER";
  1500.             break;
  1501.             case 16:
  1502.             $subclass = "THROWN<br>";
  1503.             break;
  1504.             case 18:
  1505.             $subclass = "CROSSBOW";
  1506.             break;
  1507.             case 19:
  1508.             $subclass = "WAND";
  1509.             break;
  1510.             case 20:
  1511.             $subclass = "FISHING POLE";
  1512.             break;
  1513.         }
  1514.         break;
  1515.         case 3:
  1516.         $class = "JEWLERY";
  1517.         $subclass = "JEWLERY";
  1518.         break;
  1519.         case 4:
  1520.         $class = "ARMOR";
  1521.             switch($subclass){
  1522.             case 0:
  1523.             $subclass = "JEWLERY";
  1524.             break;
  1525.             case 1:
  1526.             $subclass = "CLOTH";
  1527.             break;
  1528.             case 2:
  1529.             $subclass = "LEATHER";
  1530.             break;
  1531.             case 3:
  1532.             $subclass = "MAIL";
  1533.             break;
  1534.             case 4:
  1535.             $subclass = "PLATE";
  1536.             break;
  1537.             case 6:
  1538.             $subclass = "SHIELD";
  1539.             break;
  1540.             }
  1541.         break;
  1542.         case 5:
  1543.         $class = "REAGENT";
  1544.         break;
  1545.         case 6:
  1546.         $class = "PROJECTILE";
  1547.             switch($subclass){
  1548.             case 2:
  1549.             $subclass = "ARROW";
  1550.             break;
  1551.             case 3:
  1552.             $subclass = "BULLET";
  1553.             break;
  1554.             }
  1555.         break;
  1556.         case 7:
  1557.         $class = "TRADEGOODS";
  1558.         break;
  1559.         case 8:
  1560.         $class = "GENERIC";
  1561.         break;
  1562.         case 9:
  1563.         $class = "RECIPE";
  1564.         break;
  1565.         case 10:
  1566.         $class = "MONEY";
  1567.         break;
  1568.         case 11:
  1569.         $class = "QUIVER";
  1570.         break;
  1571.         case 12:
  1572.         $class = "QUEST";
  1573.         break;
  1574.         case 13:
  1575.         $class = "KEY";
  1576.         break;
  1577.         case 14:
  1578.         $class = "PERMANENT";
  1579.         break;
  1580.         case 15:
  1581.         $class = "MISCELLANEOUS";
  1582.         break;
  1583.         case 16:
  1584.         $class = "GLYPH";
  1585.         break;
  1586.     }
  1587.     switch($quality){
  1588.         case 0:
  1589.         $quality = "#696969";
  1590.         break;
  1591.         case 1:
  1592.         $quality = "#FFFFFF";
  1593.         break;
  1594.         case 2:
  1595.         $quality = "#00FF00";
  1596.         break;
  1597.         case 3:
  1598.         $quality = "#0000FF";
  1599.         break;
  1600.         case 4:
  1601.         $quality = "#7D26CD";
  1602.         break;
  1603.         case 5:
  1604.         $quality = "#DD7500";
  1605.         break;
  1606.         case 6:
  1607.         $quality = "#E3CF57";
  1608.         break;
  1609.         case 7:
  1610.         $quality = "#E3CF57";
  1611.         break;
  1612.     }
  1613.     if($statoneval == 0)
  1614.     {
  1615.         $statonetype = "";
  1616.     }
  1617.     if($stattwoval == 0)
  1618.     {
  1619.         $stattwotype = "";
  1620.     }
  1621.     if($statthreeval == 0)
  1622.     {
  1623.         $statthreetype = "";
  1624.     }
  1625.     if($statfourval == 0)
  1626.     {
  1627.         $statfourtype = "";
  1628.     }
  1629.     if($statfiveval == 0)
  1630.     {
  1631.         $statfivetype = "";
  1632.     }
  1633.     if($statsixval == 0)
  1634.     {
  1635.         $statsixtype = "";
  1636.     }
  1637.     if($statsevenval == 0)
  1638.     {
  1639.         $statseventype = "";
  1640.     }
  1641.     if($stateightval == 0)
  1642.     {
  1643.         $stateighttype = "";
  1644.     }
  1645.     if($statnineval == 0)
  1646.     {
  1647.         $statninetype = "";
  1648.     }
  1649.     if($stattenval == 0)
  1650.     {
  1651.         $stattentype = "";
  1652.     }
  1653.     if($armor == 0)
  1654.     {
  1655.         $armor = "";
  1656.     }
  1657.     else
  1658.     {
  1659.         $armor = (string)$armor . "  ARMOR";
  1660.     }
  1661.     echo "<div align= 'left'>";
  1662.     echo "<font color=\"$quality\"><b>$name</b></font><br>SUBCLASS - $subclass<br>Requires Level $requiredlevel<br><b>STATS</b><br>$statonetype $stattwotype $statthreetype $statfourtype $statfivetype $statsixtype $statseventype $stateighttype $statninetype $stattentype ";
  1663.     echo "$armor";
  1664.     echo "$damage";
  1665.     echo "$speed";
  1666.     echo "$dps";
  1667.     echo"<br><br><br>";
  1668.     echo "</div>";
  1669. }
  1670. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!