View Single Post
  #3  
Old 11-23-2012, 06:46 PM
c0ncrete's Avatar
c0ncrete
Dragon
 
Join Date: Dec 2009
Posts: 719
Default

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

Code:
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

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.
Reply With Quote