Magictype.dat format?

06/10/2013 01:57 elvis1002#1
What would each number in this format represent?

Code:
6004@@6000@@1@@TwofoldBlades@@1@@0@@0@@0@@4@@0@@30130@@0@@100@@0@@3@@3@@-1@@0@@0@@0@@0@@2@@601@@0@@0@@0@@0@@0@@0@@30@@1@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@0@@
06/10/2013 03:27 pro4never#2
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.
06/15/2013 05:46 elvis1002#3
Quote:
Originally Posted by pro4never View Post
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
Example #1: Fast Blade
Code:
1045	Fast Blade	14	1	1	0	4	0	0	0	0	100	0	[SIZE="5"][B]4	10  [/B][/SIZE]	0	0	100000	40	2	410	0	0	0	0	5	0	20	1	0	0	[SIZE="5"][B]600[/B][/SIZE]	1
Example#2 Twofold Blades
Code:
428	6000	TwofoldBlades	1	1	0	0	0	3	0	30125	0	100	0	[SIZE="5"][B]3   3  [/B][/SIZE]  	0	0	20	120	2	601	0	0	0	0	0	0	30	1	0	0	[SIZE="5"][B]0[/B][/SIZE]	1

Of course these days, spaces aren't used, they're filled in with the "@" symbol.
06/15/2013 07:21 pro4never#4
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.
06/15/2013 17:46 elvis1002#5
Quote:
Originally Posted by pro4never View Post
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.....

:mad: 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;