Magictype.dat format?

[elvis1002]

What would each number in this format represent?

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@@

[pro4never]

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.

[elvis1002]

Originally Posted by pro4never

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.

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

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

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.

[pro4never]

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.

[elvis1002]

Originally Posted by pro4never

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:

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