Ok so here is the deal, I stumbled across dura items in the database and was successful in the attempt to alter their stats (Using information provided by Silent Bill) the dura works in game and can have it's stats set to give the correct amount of stat and stat type for the wep. (Using Base_Var for P/M.atk)
I believe the correct stats can be implemented via the OPT_var records, the problem is the item either starts out at 0/170 dura (this is on R6 Fervent Cleaver [2h] axe) if you change the 'Endurance' record on the cleaver you actually get dura to reset in. My problem is that the table is originally int32 and I tried several values ranging from -2 through 170 to -1.000 to 170.000 After a certain point I began testing different data types for the endurance field (Decimal, Numerical) and the lowest I can get the weapons dura is 380/170.
The weapon works when equipped and gives all stats set in the record to be given, the issue I feel is when you log the items will break. (This most likely due to the game seeing 380/170 and saying the dura is not correct and then it breaks. (While changing the endurance value for the weapon I got a range of durability all the way up to 200k/170) So I guess what the discussion is, is as follows:
We need to find the correct data type for the 'Endurance' field and the proper value for the field so that we can back the durability into the safe range e.g 150/170 to test and see if thats why the item breaks on relog.
Secondly the correct Opt_Var type (e.g. 11 for p.atk) for the dura type in question and set the values accordingly.
If I am correct in my findings and assumptions we could have dura working within days to weeks, but this is only if someone wants to take the time to help me figure out the problem.
Pyrok has said previous 'The game doesn't understand dura' I can't accept that as the final answer for the simple fact that when I spawn in a dura wep with edited opt_var's it will even give whatever stats I set to be the dura stats and will work for the entire duration of my being logged in, the moment I log out and back in all dura weps will break due to them being spawned with 0/xxx dura (Unless edited and as before with my edits the lowest dura I have achieved is 380/170)
I will be speaking with 'Silent Bill' and a few other database and SQL savvy people I know, but my hopes are that dura is not a thing just for the emulator and is just waiting to be fixed.
-ismokedrow






