Please Help Can si Title Name in any Modified NPC: Freya H5 Server

[hernamewernau]

I have this small problem in my Modified NPC. I cannot see the title name above each NPC's which normally been seen. The one which had two small blues when you click  a certain NPC. All npc's are just fine except this two which I'm trying to modified. any help will do. tanx ^^, 

 

(9999,22755,'Ouch',1,'Buffer',1,'LineageMonster5.krakian','26','36',85,'male','L2NpcBuffer',40,'55817.8012671518','1846.8','187.410040552143','3',40,43,30,21,20,20,579304,58205,'12008.0135566142','578.861024','8707.81891430402','635.378064',253,4,333,0,0,0,42,180,0,1),

 

(10002,30417,'Mistah',1,'GM Shop',1,'LineageNPC.a_teleporter_FHuman','7','24',70,'male','L2Merchant',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,0,0,0,50,120,0,1);

[nekys]

Better also post the table stracture.

[hernamewernau]

Hi mate here is the table structure: correct me if im wrong, in regular basis the ipon installing the sql in the database if such sql has an error it will definitely give you a warming. In my case the installation just work so fine but it wonders me why is it the name didn't appear. Tanx for the time ^^,

 

DROP TABLE IF EXISTS `npc`;

CREATE TABLE `npc`(

  `id` smallint(5) unsigned NOT NULL,

  `idTemplate` smallint(5) unsigned NOT NULL,

  `name` varchar(200) NOT NULL DEFAULT '',

  `serverSideName` tinyint(1) NOT NULL DEFAULT '0',

  `title` varchar(45) NOT NULL DEFAULT '',

  `serverSideTitle` tinyint(1) NOT NULL DEFAULT '0',

  `class` varchar(200) DEFAULT NULL,

  `collision_radius` decimal(6,2) DEFAULT NULL,

  `collision_height` decimal(6,2) DEFAULT NULL,

  `level` tinyint(2) DEFAULT NULL,

  `sex` enum('etc','female','male') NOT NULL DEFAULT 'etc',

  `type` varchar(22) DEFAULT NULL,

  `attackrange` smallint(4) DEFAULT NULL,

  `hp` decimal(30,15) DEFAULT NULL,

  `mp` decimal(30,15) DEFAULT NULL,

  `hpreg` decimal(30,15) DEFAULT NULL,

  `mpreg` decimal(30,15) DEFAULT NULL,

  `str` tinyint(2) NOT NULL DEFAULT '40',

  `con` tinyint(2) NOT NULL DEFAULT '43',

  `dex` tinyint(2) NOT NULL DEFAULT '30',

  `int` tinyint(2) NOT NULL DEFAULT '21',

  `wit` tinyint(2) NOT NULL DEFAULT '20',

  `men` tinyint(2) NOT NULL DEFAULT '20',

  `exp` int(9) NOT NULL DEFAULT '0',

  `sp` int(9) NOT NULL DEFAULT '0',

  `patk` decimal(12,5) DEFAULT NULL,

  `pdef` decimal(12,5) DEFAULT NULL,

  `matk` decimal(12,5) DEFAULT NULL,

  `mdef` decimal(12,5) DEFAULT NULL,

  `atkspd` smallint(4) NOT NULL DEFAULT '230',

  `critical` tinyint(1) NOT NULL DEFAULT '1',

  `matkspd` smallint(4) NOT NULL DEFAULT '333',

  `rhand` smallint(5) unsigned NOT NULL DEFAULT '0',

  `lhand` smallint(5) unsigned NOT NULL DEFAULT '0',

  `enchant` tinyint(1) NOT NULL DEFAULT '0',

  `walkspd` decimal(10,5) NOT NULL DEFAULT '60',

  `runspd` decimal(10,5) NOT NULL DEFAULT '120',

  `dropHerbGroup` tinyint(1) NOT NULL DEFAULT '0',

  `basestats` tinyint(1) NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`,`idTemplate`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

[[AoH]Kratos]

In order to see the name / title you have to add a row in npc_elementals and npcaidata , like this :

INSERT INTO `npc` VALUES ('10002', '13100', 'GM Shop', '1', 'ServerName', '1', 'LineageMonster2.anakim_tr', '15.50', '29.00', '55', 'female', 'L2Merchant', '40', '1673.054730000000000', '889.800000000000000', '6.500000000000000', '2.400000000000000', '40', '43', '30', '21', '20', '25', '0', '0', '388.11142', '223.63620', '265.02979', '163.64727', '253', '4', '333', '0', '0', '0', '45.00000', '180.00000', '0', '1');
INSERT INTO `npc_elementals` VALUES ('10002', '0', '0', '20', '20', '20', '20', '20', '20');
INSERT INTO `npcaidata` VALUES ('10002', '7', '15', '0', '0', '1', '1', '1', '0', '0', '0', '0', '2', '2', '0', '0', '0', '0', null, '0', null, '0', '0', 'balanced');

It's been modified since High Five !

[hernamewernau]

ah ok...I see it now...superb.. ty mate ^^,

[[AoH]Kratos]

No problem :) !

Every time you add a custom NPC , you have to make this :)

[Fortuna]

Solved, locked.