to get a list of fields in the items table, use:
this link will give you a little more info as to what some of the fields are for. scroll down to where it says "struct Item_Struct".
so for example, if you wanted to multiply the following fields by 5
Code:
sint8 CR; // Save vs Cold
sint8 DR; // Save vs Disease
sint8 PR; // Save vs Poison
sint8 MR; // Save vs Magic
sint8 FR; // Save vs Fire
sint8 AStr; // Strength
sint8 ASta; // Stamina
sint8 AAgi; // Agility
sint8 ADex; // Dexterity
sint8 ACha; // Charisma
sint8 AInt; // Intelligence
sint8 AWis; // Wisdom
sint32 HP; // HP
sint32 Mana; // Mana
sint32 AC; // AC
the command would be
Code:
UPDATE items SET
CR=CR*5,
DR=DR*5,
PR=PR*5,
MR=MR*5,
FR=FR*5,
AStr=AStr*5,
ASta=AStr*5,
AAgi=AAgi*5,
ADex=ADex*5,
ACha=ACha*5,
AInt=AInt*5,
AWis=AWis*5,
HP=HP*5,
Mana=Mana*5,
AC=AC*5;
you will need to be aware that any stat with a negative value will also be multiplied, so it won't make everything better/stronger/more appealing.