Hi,
I am attempting to replace all fabled weapon stats with regular weapon stats.
I have a list of fabled Items and a list of regular items, and I've matched up each of the IDs.
To replace all the stats on Fabled items with the stats on the regular items - what would that code look like?
I also want to randomize some stats on the (then normalized fabled items, in this case WEAPONS) , and to do that I could do this, right?
Code:
Update `items` set `damage` = `damage`*(RAND()+1), `astr`=`astr`+(15*RAND()), `asta`=`asta`+(15*RAND()),(ETC) WHERE (`itemtype` = 0 OR `itemtype` = 1 OR `itemtype` = 2 OR `itemtype` = 3 OR `itemtype` = 4 OR `itemtype` = 5
OR `itemtype` = 35 OR `itemtype` = 45) AND `name` like '%fabled%' AND `damage` > 1;
That would set the damage between 100-200% and add strength of 0-15, and add stamina between 0-15, right?
Do I need to make the randoms INTs or will the standard FLOATs be fine for this application?
Code:
CONVERT(INT, (10+3)RAND()) #example
Edit: I hope this is clear, My mind is a little fuzzy today.
In short:
1. Take Fabled Item, Replace stats with unfabled item (including req and rec level, etc)
2. Apply semi-random stats to fabled items.