Look at any magictype database and look at the column names.
Also compare it to known/visible effects for the skill such as stamina cost and approximate range. It's pretty easy to figure out.
I ended up using the Albetros database(Thank you pro4never), for the future reference of those who don't want to install MySQL to do a simple magictype edit, Refer to this.
Things that are bolded are deemed important for client sided edits.
Code:
ID TYPE NAME SORT CRIME GROUND MULTI TARGET LEVEL MANA POWER INTONE_SPEED PERCENT STEP_SECS [SIZE="4"][B]RANGE DISTANCE [/B][/SIZE] STATUS NEED_PROF NEED_EXP NEED_LEVEL USE_EXP WEAPON_SUBTYPE ACTIVE TIMES AUTO_ACTIVE FLOOR_ATTR AUTO_LEARN LEARN_LEVEL DROP_WEAPON USE_EP WEAPON_HIT USE_ITEM NEXT_MAGIC [SIZE="4"][B]DELAY_MS[/B][/SIZE] USE_ITEM_NUM
They wouldn't need to install mysql... just ctrl + f in the database backup would work as it can be opened in notepad or w/e. Can just look at column names there.
They wouldn't need to install mysql... just ctrl + f in the database backup would work as it can be opened in notepad or w/e. Can just look at column names there.
WHAT?! NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.....
I could do that?
nobody ever tells me these things until after.....
Edit: I guess whoever wants to do it the easy way can look at this:
Code:
-- Table structure for `spellinfo`
-- ----------------------------
DROP TABLE IF EXISTS `spellinfo`;
CREATE TABLE `spellinfo` (
`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
`type` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`Name` varchar(20) NOT NULL DEFAULT 'Unknown',
`sort` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`crime` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`ground` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`multi` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`target` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`level` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`use_mp` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`power` int(4) NOT NULL DEFAULT '0',
`intone_speed` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`percent` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`step_secs` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`range` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`distance` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`status` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`need_prof` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`need_exp` int(4) NOT NULL DEFAULT '0',
`need_level` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`use_xp` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`weapon_subtype` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`active_times` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`auto_active` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`floor_attr` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`auto_learn` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`learn_level` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`drop_weapon` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`use_ep` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`weapon_hit` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0',
`use_item` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`next_magic` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`delay_ms` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
`use_item_num` int(4) unsigned zerofill NOT NULL DEFAULT '0001',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11024 DEFAULT CHARSET=latin1;
magictype 02/25/2012 - CO2 Private Server - 2 Replies does anybody know how i can import my magictype into my database? everytime i try to it says the information is too long to fit or something and it just deletes everything i had in there.
MagicType 09/29/2011 - CO2 Programming - 8 Replies How can I get a MagicType??
I mean,I`m sick of getting the target is not in range message during FB/SS -.-
MagicType? 12/23/2009 - CO2 Private Server - 5 Replies Does anyone have MagicType.dat decrypted for patch 5017?
Magictype.dat format?
I could do that? 
