Information about White (100%) and common/special Blue states

[Witchy Moo]

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%, except 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]
GO
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]
GO
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 this thread.

cheers

[MentaL]

[pandahot]

thank you for info.

[Crue]

good job ;)

[Blacksheep25]

Good work witchy :)

Will come in handy for procedures anyone is creating to do with blues/whites