find items in db with uber atk and def

[olav1ar]

Do somone know of a methode to find all uber items wit loots of amout of atk and def?

like a sword with atk:1000000, def:10000000

 

[Diazapam]

Well the items are not saved in the db (just the item id's if players own an item).
I think for this you'll have to go through the items.xml and find it.

 

[Cykotitan]

Attributes in player_items are stored in BLOB (binary), you can't just read them like that.

 

[Azcarer]

If you want these "UBERWEAPONS" then search through items.xml and change the weapon you want to. Example:


<item id="2376" article="a" name="sword">
<attribute key="weight" value="3"/>
<attribute key="defense" value="100000000"/>
<attribute key="attack" value="100000000"/>
<attribute key="weaponType" value="sword"/>
<attribute key="extradef" value="100000000"/>
</item>

 

[olav1ar]

Thx Cykotitan
Its just what i was thinking.

Can u help me how to make the BLOB readable in mysql ?