- 0
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..
Question
DreamStage
Im tired of figuring it out, dont know the problem =S
I have all server data ok, just somethings wrong and i cant find it.
My sql files are:
-- ---------------------------- -- Table structure for `dm` -- ---------------------------- DROP TABLE IF EXISTS `dm`; CREATE TABLE `dm` ( `eventName` varchar(255) NOT NULL DEFAULT '', `eventDesc` varchar(255) NOT NULL DEFAULT '', `joiningLocation` varchar(255) NOT NULL DEFAULT '', `minlvl` int(4) NOT NULL DEFAULT '0', `maxlvl` int(4) NOT NULL DEFAULT '0', `npcId` int(8) NOT NULL DEFAULT '0', `npcX` int(11) NOT NULL DEFAULT '0', `npcY` int(11) NOT NULL DEFAULT '0', `npcZ` int(11) NOT NULL DEFAULT '0', `rewardId` int(11) NOT NULL DEFAULT '0', `rewardAmount` int(11) NOT NULL DEFAULT '0', `color` int(11) NOT NULL DEFAULT '0', `playerX` int(11) NOT NULL DEFAULT '0', `playerY` int(11) NOT NULL DEFAULT '0', `playerZ` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of dm -- ---------------------------- INSERT INTO `dm` VALUES ('Deathmatch', 'Deathmatch', 'Giran', '76', '86', '70005', '83425', '148585', '-3406', '57', '2000000', '255', '113502', '-155251', '-1533');-- ---------------------------- -- Table structure for `custom_npc` -- ---------------------------- DROP TABLE IF EXISTS `custom_npc`; CREATE TABLE `custom_npc` ( `id` mediumint(7) unsigned NOT NULL DEFAULT '0', `idTemplate` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(200) NOT NULL DEFAULT '', `serverSideName` tinyint(1) NOT NULL DEFAULT '1', `title` varchar(45) NOT NULL DEFAULT '', `serverSideTitle` tinyint(1) NOT NULL DEFAULT '1', `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', `aggro` smallint(4) NOT NULL DEFAULT '0', `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.00000', `runspd` decimal(10,5) NOT NULL DEFAULT '120.00000', `targetable` tinyint(1) NOT NULL DEFAULT '1', `show_name` tinyint(1) NOT NULL DEFAULT '1', `dropHerbGroup` tinyint(1) NOT NULL DEFAULT '0', `basestats` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of custom_npc -- ---------------------------- INSERT INTO `custom_npc` VALUES ('70005', '32215', 'DeathMatch', '1', 'DM Event Manager', '1', 'LineageNPC2.K_M1_master', '15.00', '25.00', '70', 'male', 'L2Npc', '40', '2444.000000000000000', '2444.000000000000000', '0.000000000000000', '0.000000000000000', '10', '10', '10', '10', '10', '10', '0', '0', '500.00000', '500.00000', '500.00000', '500.00000', '278', '0', '333', '9376', '0', '0', '0', '30.00000', '120.00000', '0', '0', '0', '0');Does anyone knows whats wrong? =S Please help
PS: This hapens after i press LOAD and JOIN! at Join command, he spawns and doesnt show html code.
3 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now