Quote:
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.....
: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;