Help with Sql commands

[c0ncrete]

to get a list of fields in the items table, use:

DESCRIBE items;

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

	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

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.