[Share/Guide] Information about White (100%) and common/special Blue states

[witchymoo]

Hello,

I'd like to share something about BLUE and WHITE attributes (I think there's yet complete explanation around).

Variance (white state)

 Spoiler

• 34359738336 = Gear, Weapons, Shields all attributes 100%, expect durability
• 1073741823 = Accessories all attributes 100%

MagParam (common blue state)

 Spoiler

I found these values by trying each corresponding stones on the item. But since we can do it from SQL-Query, we can actually skip some rules and put all blue to all equip haha :P

• All Items:
  • 30064771144 = Str 7
  • 30064771150 = Int 7
  • 34359738441 = Str 8
  • 34359738447 = Int 8
• Gear set, Weapon, Shield:
  • 858993459290 = Durability 200%
• Weapon:
  • 429496729714 = Blocking Rate 100
  • 257698037862 = Attack Rate 60%
• Shield:
  • 429496729726 = Critical Block 100
  • 257698037898 = Parry Rate 60%
• All Accessories:
  • 85899346100 = Freeze 20%
  • 85899346094 = Electric Shock 20%
  • 85899346088 = Burn 20%
  • 85899346106 = Poison 20%
  • 85899346112 = Zombie 20%

MagParam (special blue state)

 Spoiler

These are made from special MAGICSTONES, as follows:

• ABYSS - Earring - CombustionProbability 50%
• STUPOR - Earring - SleepProbability 50%
• DEVIL - Chest - HP recovery/MP recovery 210%
• GUARD - Necklace - StunProbability 11%
• HEAT - Ring - DiseaseProbability 25%
• SHARP - Weapon - Critical 3
• STRONGMIND - Ring - FearProbability 25%

And the blue attributes are:

• Chest gear:
  • 901943132463 = HP recovery/MP recovery 210%
• Earring:
  • 214748365115 = CombustionProbability 50% Reduce
  • 214748365139 = SleepProbability 50% Reduce
• Necklace:
  • 47244640547 = StunProbability 50% Reduce
• All Rings:
  • 107374182751 = DiseaseProbability 25% Reduce
  • 107374182727 = FearProbability 25% Reduce

Usage example:
Making earring full white 100% and 9 blue attributes including the special ones:

USE [SRO_VT_SHARD]
DECLARE @EarringItemID64 INT = <your_earring_ID_here>	-- change this to your earring ID
DECLARE @EQPlus TINYINT = 12	-- da PLUS
UPDATE _Items SET OptLevel = @EQPlus, Variance = 1073741823, MagParamNum = 9, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 85899346100, MagParam4 = 85899346094, MagParam5 = 85899346088, MagParam6 = 85899346106, MagParam7 = 85899346112, MagParam8 = 214748365115, MagParam9 = 214748365139, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @EarringItemID64

Result is:

 Spoiler

Making chest full white 100% (except dura) and full blue attributes including special ones:

USE [SRO_VT_SHARD]
DECLARE @MailItemID64 INT = <your_chest_ID_here>	-- change this to your chest ID
DECLARE @EQPlus TINYINT = 12	-- da PLUS
UPDATE _Items SET OptLevel = @EQPlus, Variance = 34359738336, MagParamNum = 5, MagParam1 = 30064771144, MagParam2 = 30064771150, MagParam3 = 858993459290, MagParam4 = 257698037898, MagParam5 = 901943132463, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 = @MailItemID64

Result is:

 Spoiler

And so on...

Hope this could help a little bit

PS: You can also merge this with SP i made to add automatic gear for GMs in .

cheers

[PortalDark]

#Approved

[Alexiuns]

don't give me fish but learn me how to get it

i mean (Instead of creating the tutorial with totally bullshit no-exiplanation not well-guided, create something useful or at least EXPLAIN the calculation of this equiation to get the value done instead of going to smc and run it.)

[witchymoo]

Originally Posted by Alexiuns

don't give me fish but learn me how to get it

i mean (Instead of creating the tutorial with totally bullshit no-exiplanation not well-guided, create something useful or at least EXPLAIN the calculation of this equiation to get the value done instead of going to smc and run it.)

You know what, Mr Pro, I bet you never even tried to get that info yourself, and if even if you did, did you share? I don't think so Now someone had it done and you throw negativity at the effort, and yet, you saw the info, that's just pathetic. You shouldn't even looking at threads started by newbies like me, and rather than throwing bullsh*t all around, I think you better make some effort by doing it and finding whatever info you need and share with us.

I couldn't find anything about calculation around the net and I don't know anyone who really knows about the formula, neither do you, right? Instead waiting and throwing sh*t around I took simpler step and found some useful information to share, what did you found about it? care to share?

Originally Posted by PortalDark

#Approved

Thank you

[Justin1337*]

Thanks dude =)

[@$$]

Nice keep shareing :-)

[Alexiuns]

Originally Posted by witchymoo

You know what, Mr Pro, I bet you never even tried to get that info yourself, and if even if you did, did you share? I don't think so Now someone had it done and you throw negativity at the effort, and yet, you saw the info, that's just pathetic. You shouldn't even looking at threads started by newbies like me, and rather than throwing bullsh*t all around, I think you better make some effort by doing it and finding whatever info you need and share with us.

I couldn't find anything about calculation around the net and I don't know anyone who really knows about the formula, neither do you, right? Instead waiting and throwing sh*t around I took simpler step and found some useful information to share, what did you found about it? care to share?



Thank you

as you said you are newbie.. so you have to search about me first, then write this answer
you are useless; sharing smth not useful and any beginner can do it
so don't bother yourself and make this useless release
go better learn what is the meaning of "database" or "SQL"

[magicanoo]

I also prefer a method on how to calculate these parameters.Would be better than giving STR7/INT7 FB 100% stats,since not everyone is using D11 gear.

[HellMezo*]

i want

Stat 80% please

Originally Posted by @$$

Nice keep shareing :-)

[Hedgehock]

Nice ! Just wanted to remind I've wrote a little sample for decoding joymax way of storing that kind of data in php. In this case - variance.

[item_stats.class.php]

<?php

class CItemInfo
{
 private $m_ItemType = 0;
 private $m_nCurParam = 0;
 private $m_CurStatParams = array();
 
 public static $s_WeaponStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'HitRatio', 'PhyAttack', 'MagAttack', 'CriticalRatio');
 
 public static $s_EquipmentStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'PhyDefense', 'MagDefense', 'ParryRatio');
 
 public static $s_ShieldStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'BlockRatio', 'PhyDefense', 'MagDefense');
 
 public static $s_AccessoryStatNames =
  array('PhyAbsorb', 'MagAbsorb');
  

 
 public function __construct($item_type)
 {
  if($item_type > 3 || $item_type < 0) die("Item with type > 4 or < 0 !!1 (CItemInfo)!!");
  $this -> m_ItemType = $item_type;
 }
 
 public function AddParam($param_value)
 {
  $this -> m_CurStatParams[$this -> m_nCurParam++] = $param_value;
 }
 
 public function GetParamCountForItem()
 {
  switch($this -> m_ItemType)
  {
   case 0:
   {
    return count(self::$s_WeaponStatNames);
   }
   break;
   case 1:
   {
    return count(self::$s_EquipmentStatNames);
   }
   break;
   case 2:
   {
    return count(self::$s_ShieldStatNames);
   }
   break;
   case 3:
   {
    return count(self::$s_AccessoryStatNames);
   }
   break;
  }
 }
 
 public function GetParams()
 {
  $result = array(array());
  

  
  switch($this -> m_ItemType)
  {
   case 0:
   {
    for($i = 0; $i < count (self::$s_WeaponStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_WeaponStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 1:
   {
    for($i = 0; $i < count (self::$s_EquipmentStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_EquipmentStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 2:
   {
    for($i = 0; $i < count (self::$s_ShieldStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_ShieldStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 3:
   {
    for($i = 0; $i < count (self::$s_AccessoryStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_AccessoryStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
  }
  return $result;
 }
}

class CItemClass
{
 
 static $s_Instance;
 
 private function __construct()
 {
 
 }
 
 protected function __clone()
 {
 
 }
 
 static public function Instance()
 {
  if(is_null(self::$s_Instance))
  {
   self::$s_Instance = new self();
  }
  return self::$s_Instance;
 }
 
 public function PercentageFromBitvalue($bitvalue)
 {
  return round(($bitvalue * 100 / 31) - 0.5 , 0);
 }
 
 
 public function GetVarianceDump($variance, $item_type_id)
 {
  $result = null;
  $g_Item = new CItemInfo($item_type_id);
  
  $n = 0;
  $nParams = $g_Item -> GetParamCountForItem();
  while($n < $nParams)
  {
    $cur_stat = $variance & 0x1F;
    $g_Item -> AddParam($this -> PercentageFromBitvalue($cur_stat));
    $variance >>= 5;
    $n++;
   
  }

  //print_r($g_Item -> GetParams());
  return $g_Item -> GetParams();
 }
}
?>

Usage example:


[get_whitestats.php]

<html>
<head>
 <title>ohai squirl</title>
</head>

<body>
 <center>
 <table border = '1' cellspacing = '2' cellpadding = '2'>
 <form method='post'>
 <td>Variance</td><td><input type='text' name='variance'></td><tr/>
 <td>ItemType</td>
 <td>
  <select name = 'item_type'>
  <option value='0'>Weapon</option>
  <option value='1'>Armor</option>
  <option value='2'>Shield</option>
  <option value='3'>Accessory</option>
  </select>
 </td>
 <td><input type='submit' value='Gib meh'></td>
 </form>
 </table>
 </center>
</body>

</html>

<?php
if(!empty($_POST['variance']))
{
 include('item_stats.class.php');

 $instance = CItemClass::Instance();
 
 //$a = (long) ($_POST['variance']);
 print_r(
  $instance -> GetVarianceDump((float)($_POST['variance']), $_POST['item_type'])
 );
}
?>

I remember it had some kind of bug, but that's not the point. What I wanna show is how to do bit operations.

[hoangvispkt]

Originally Posted by Hedgehock

Nice ! Just wanted to remind I've wrote a little sample for decoding joymax way of storing that kind of data in php. In this case - variance.

[item_stats.class.php]

<?php

class CItemInfo
{
 private $m_ItemType = 0;
 private $m_nCurParam = 0;
 private $m_CurStatParams = array();
 
 public static $s_WeaponStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'HitRatio', 'PhyAttack', 'MagAttack', 'CriticalRatio');
 
 public static $s_EquipmentStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'PhyDefense', 'MagDefense', 'ParryRatio');
 
 public static $s_ShieldStatNames =
  array('Durability', 'PhyReinforce', 'MagReinforce', 'BlockRatio', 'PhyDefense', 'MagDefense');
 
 public static $s_AccessoryStatNames =
  array('PhyAbsorb', 'MagAbsorb');
  

 
 public function __construct($item_type)
 {
  if($item_type > 3 || $item_type < 0) die("Item with type > 4 or < 0 !!1 (CItemInfo)!!");
  $this -> m_ItemType = $item_type;
 }
 
 public function AddParam($param_value)
 {
  $this -> m_CurStatParams[$this -> m_nCurParam++] = $param_value;
 }
 
 public function GetParamCountForItem()
 {
  switch($this -> m_ItemType)
  {
   case 0:
   {
    return count(self::$s_WeaponStatNames);
   }
   break;
   case 1:
   {
    return count(self::$s_EquipmentStatNames);
   }
   break;
   case 2:
   {
    return count(self::$s_ShieldStatNames);
   }
   break;
   case 3:
   {
    return count(self::$s_AccessoryStatNames);
   }
   break;
  }
 }
 
 public function GetParams()
 {
  $result = array(array());
  

  
  switch($this -> m_ItemType)
  {
   case 0:
   {
    for($i = 0; $i < count (self::$s_WeaponStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_WeaponStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 1:
   {
    for($i = 0; $i < count (self::$s_EquipmentStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_EquipmentStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 2:
   {
    for($i = 0; $i < count (self::$s_ShieldStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_ShieldStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
   case 3:
   {
    for($i = 0; $i < count (self::$s_AccessoryStatNames); $i++)
    {
     $result[$i] =
      array(self::$s_AccessoryStatNames[$i] => $this -> m_CurStatParams[$i]);
    }
   }
   break;
  }
  return $result;
 }
}

class CItemClass
{
 
 static $s_Instance;
 
 private function __construct()
 {
 
 }
 
 protected function __clone()
 {
 
 }
 
 static public function Instance()
 {
  if(is_null(self::$s_Instance))
  {
   self::$s_Instance = new self();
  }
  return self::$s_Instance;
 }
 
 public function PercentageFromBitvalue($bitvalue)
 {
  return round(($bitvalue * 100 / 31) - 0.5 , 0);
 }
 
 
 public function GetVarianceDump($variance, $item_type_id)
 {
  $result = null;
  $g_Item = new CItemInfo($item_type_id);
  
  $n = 0;
  $nParams = $g_Item -> GetParamCountForItem();
  while($n < $nParams)
  {
    $cur_stat = $variance & 0x1F;
    $g_Item -> AddParam($this -> PercentageFromBitvalue($cur_stat));
    $variance >>= 5;
    $n++;
   
  }

  //print_r($g_Item -> GetParams());
  return $g_Item -> GetParams();
 }
}
?>

Usage example:


[get_whitestats.php]

<html>
<head>
 <title>ohai squirl</title>
</head>

<body>
 <center>
 <table border = '1' cellspacing = '2' cellpadding = '2'>
 <form method='post'>
 <td>Variance</td><td><input type='text' name='variance'></td><tr/>
 <td>ItemType</td>
 <td>
  <select name = 'item_type'>
  <option value='0'>Weapon</option>
  <option value='1'>Armor</option>
  <option value='2'>Shield</option>
  <option value='3'>Accessory</option>
  </select>
 </td>
 <td><input type='submit' value='Gib meh'></td>
 </form>
 </table>
 </center>
</body>

</html>

<?php
if(!empty($_POST['variance']))
{
 include('item_stats.class.php');

 $instance = CItemClass::Instance();
 
 //$a = (long) ($_POST['variance']);
 print_r(
  $instance -> GetVarianceDump((float)($_POST['variance']), $_POST['item_type'])
 );
}
?>

I remember it had some kind of bug, but that's not the point. What I wanna show is how to do bit operations.

It's very helpful to me