Jump to content
  • 0

PolyMorph Config SQL


Question

Posted
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for npc_to_pc_polymorph

-- ----------------------------

DROP TABLE IF EXISTS `npc_to_pc_polymorph`;

CREATE TABLE `npc_to_pc_polymorph` (

 `spawn` int(9) NOT NULL default '0',

 `template` int(9) NOT NULL default '0',

 `name` varchar(35) default NULL,

 `title` varchar(35) default NULL,

 `class_id` int(3) NOT NULL default '0',

 `female` int(1) NOT NULL default '0',

 `hair_style` int(1) NOT NULL default '0',

 `hair_color` int(1) NOT NULL default '0',

 `face` int(1) NOT NULL default '0',

 `name_color` int(7) NOT NULL default '0',

 `title_color` int(7) NOT NULL default '0',

 `noble` int(1) NOT NULL default '0',

 `hero` int(1) NOT NULL default '0',

 `pvp` int(1) NOT NULL default '0',

 `karma` int(7) NOT NULL default '0',

 `wpn_enchant` int(7) NOT NULL default '0',

 `right_hand` int(7) NOT NULL default '0',

 `left_hand` int(7) NOT NULL default '0',

 `gloves` int(7) NOT NULL default '0',

 `chest` int(7) NOT NULL default '0',

 `legs` int(7) NOT NULL default '0',

 `feet` int(7) NOT NULL default '0',

 `hair` int(7) NOT NULL default '0',

 `hair2` int(7) NOT NULL default '0',

 `pledge` int(2) NOT NULL default '0',

 `cw_level` int(3) NOT NULL default '0',

 `clan_id` int(9) NOT NULL default '0',

 `ally_id` int(9) NOT NULL default '0',

 `clan_crest` int(9) NOT NULL default '0',

 `ally_crest` int(9) NOT NULL default '0',

 `rnd_class` int(1) NOT NULL default '0',

 `rnd_appearance` int(1) NOT NULL default '0',

 `rnd_weapon` int(1) NOT NULL default '0',

 `rnd_armor` int(1) NOT NULL default '0',

 `max_rnd_enchant` int(7) NOT NULL default '0',

 KEY `spawn` (`spawn`),

 KEY `template` (`template`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

-- ----------------------------

-- Records

-- ----------------------------

INSERT INTO `npc_to_pc_polymorph` VALUES ('0', '31227', 'plm', 'pzm', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

 

 

Client Interlude

the server is l2jfrozen

i tried 1 to spawn and nothing...doesnt appear

 

Someone to help with this....

4 answers to this question

Recommended Posts

Guest
This topic is now closed to further replies.


×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..