Page 1 of 1

Need Tutorial

Posted: Wed Aug 10, 2011 12:11 pm
by n1k3
Hey Guys.

I need tutorial to this mod :
viewtopic.php?f=73&t=12664

I read but still don't know how to install that.
I try google but there also no tutorials.

Re: Need Tutorial

Posted: Wed Aug 10, 2011 12:24 pm
by Michalis
Well that is a already tutorial what you not understund? :)

also learn how to apply a pach i am sure you will made it!!
take a look here how to do it that How To Apply a Pach

Re: Need Tutorial

Posted: Wed Aug 10, 2011 1:09 pm
by n1k3
Michalis wrote:Well that is a already tutorial what you not understund? :)

also learn how to apply a pach i am sure you will made it!!
take a look here how to do it that How To Apply a Pach
I'm still don't understand :|

Re: Need Tutorial

Posted: Wed Aug 10, 2011 1:22 pm
by SolidSnake
L2j Server has its own wiki, you should take it a look. Anyway did you follow this guide (viewtopic.php?f=2&t=10719) to get your server? Or did you download the nightly builds?

Re: Need Tutorial

Posted: Wed Aug 10, 2011 1:34 pm
by n1k3
SolidSnake wrote:L2j Server has its own wiki, you should take it a look. Anyway did you follow this guide (viewtopic.php?f=2&t=10719) to get your server? Or did you download the nightly builds?
Yes i download the nightly builds. I read in wiki about Eclipse but still don't know :x

Re: Need Tutorial

Posted: Wed Aug 10, 2011 4:21 pm
by SolidSnake
You must use eclipse and have a basic knowledge of java to apply that patch.

Re: Need Tutorial

Posted: Thu Aug 11, 2011 8:33 am
by n1k3
Oh I think I understand :)
I will test it right now :)

Re: Need Tutorial

Posted: Fri Aug 12, 2011 6:53 am
by n1k3
I added all files but i can't add SQL file :|

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 65
[Err] CREATE TABLE `fake_pcs` (
`npc_id` int(11) NOT NULL,
`race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`sex` tinyint(3) unsigned NOT NULL DEFAULT '0',
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`title` varchar(16) NOT NULL DEFAULT '',
`title_color` char(6) NOT NULL DEFAULT 'FFFFFF',
`name` varchar(35) NOT NULL,
`name_color` char(6) NOT NULL DEFAULT 'FFFFFF',
`hair_style` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hair_color` tinyint(3) unsigned NOT NULL DEFAULT '0',
`face` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mount` tinyint(3) unsigned NOT NULL DEFAULT '0',
`team` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hero` tinyint(3) unsigned NOT NULL DEFAULT '0',
`pd_under` int(11) NOT NULL DEFAULT '0',
`pd_under_aug` int(11) NOT NULL DEFAULT '0',
`pd_head` int(11) NOT NULL DEFAULT '0',
`pd_head_aug` int(11) NOT NULL DEFAULT '0',
`pd_rhand` int(11) NOT NULL DEFAULT '0',
`pd_rhand_aug` int(11) NOT NULL DEFAULT '0',
`pd_lhand` int(11) NOT NULL DEFAULT '0',
`pd_lhand_aug` int(11) NOT NULL DEFAULT '0',
`pd_lrhand` int(11) NOT NULL DEFAULT '0',
`pd_lrhand_aug` int(11) NOT NULL DEFAULT '0',
`pd_gloves` int(11) NOT NULL DEFAULT '0',
`pd_gloves_aug` int(11) NOT NULL DEFAULT '0',
`pd_chest` int(11) NOT NULL DEFAULT '0',
`pd_chest_aug` int(11) NOT NULL DEFAULT '0',
`pd_legs` int(11) NOT NULL DEFAULT '0',
`pd_legs_aug` int(11) NOT NULL DEFAULT '0',
`pd_feet` int(11) NOT NULL DEFAULT '0',
`pd_feet_aug` int(11) NOT NULL DEFAULT '0',
`pd_back` int(11) NOT NULL DEFAULT '0',
`pd_back_aug` int(11) NOT NULL DEFAULT '0',
`pd_hair` int(11) NOT NULL DEFAULT '0',
`pd_hair_aug` int(11) NOT NULL DEFAULT '0',
`pd_hair2` int(11) NOT NULL DEFAULT '0',
`pd_hair2_aug` int(11) NOT NULL DEFAULT '0',
`pd_rbracelet` int(11) NOT NULL DEFAULT '0',
`pd_rbracelet_aug` int(11) NOT NULL DEFAULT '0',
`pd_lbracelet` int(11) NOT NULL DEFAULT '0',
`pd_lbracelet_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco1` int(11) NOT NULL DEFAULT '0',
`pd_deco1_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco2` int(11) NOT NULL DEFAULT '0',
`pd_deco2_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco3` int(11) NOT NULL DEFAULT '0',
`pd_deco3_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco4` int(11) NOT NULL DEFAULT '0',
`pd_deco4_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco5` int(11) NOT NULL DEFAULT '0',
`pd_deco5_aug` int(11) NOT NULL DEFAULT '0',
`pd_deco6` int(11) NOT NULL DEFAULT '0',
`pd_deco6_aug` int(11) NOT NULL DEFAULT '0',
`enchant_effect` int(11) NOT NULL DEFAULT '0',
`pvp_flag` tinyint(3) unsigned NOT NULL DEFAULT '0',
`karma` int(10) unsigned NOT NULL DEFAULT '0',
`fishing` tinyint(3) unsigned NOT NULL DEFAULT '0',
`fishing_x` mediumint(9) NOT NULL DEFAULT '0',
`fishing_y` mediumint(9) NOT NULL DEFAULT '0',
`fishing_z` mediumint(9) NOT NULL DEFAULT '0',
`invisible` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`npc_id`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Re: Need Tutorial

Posted: Sat Aug 13, 2011 9:40 am
by n1k3
Please help :?:

Re: Need Tutorial

Posted: Sat Aug 13, 2011 10:06 am
by Legend1
here is an sql file that i use for H5 should work for you

Code: Select all

SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `fake_pcs`-- ----------------------------DROP TABLE IF EXISTS `fake_pcs`;CREATE TABLE `fake_pcs` (  `npc_id` int(11) NOT NULL,  `race` int(11) NOT NULL DEFAULT '0',  `sex` int(11) NOT NULL DEFAULT '0',  `class` int(11) NOT NULL DEFAULT '0',  `title` varchar(255) NOT NULL,  `title_color` int(11) NOT NULL DEFAULT '0',  `name` varchar(255) NOT NULL,  `name_color` int(11) NOT NULL DEFAULT '0',  `hair_style` int(11) NOT NULL DEFAULT '0',  `hair_color` int(11) NOT NULL DEFAULT '0',  `face` int(11) NOT NULL DEFAULT '0',  `mount` tinyint(4) NOT NULL DEFAULT '0',  `team` tinyint(4) NOT NULL DEFAULT '0',  `hero` tinyint(4) NOT NULL DEFAULT '0',  `pd_under` int(11) NOT NULL DEFAULT '0',  `pd_under_aug` int(11) NOT NULL DEFAULT '0',  `pd_head` int(11) NOT NULL DEFAULT '0',  `pd_head_aug` int(11) NOT NULL DEFAULT '0',  `pd_rhand` int(11) NOT NULL DEFAULT '0',  `pd_rhand_aug` int(11) NOT NULL DEFAULT '0',  `pd_lhand` int(11) NOT NULL DEFAULT '0',  `pd_lhand_aug` int(11) NOT NULL DEFAULT '0',  `pd_gloves` int(11) NOT NULL DEFAULT '0',  `pd_gloves_aug` int(11) NOT NULL DEFAULT '0',  `pd_chest` int(11) NOT NULL DEFAULT '0',  `pd_chest_aug` int(11) NOT NULL DEFAULT '0',  `pd_legs` int(11) NOT NULL DEFAULT '0',  `pd_legs_aug` int(11) NOT NULL DEFAULT '0',  `pd_feet` int(11) NOT NULL DEFAULT '0',  `pd_feet_aug` int(11) NOT NULL DEFAULT '0',  `pd_back` int(11) NOT NULL DEFAULT '0',  `pd_back_aug` int(11) NOT NULL DEFAULT '0',  `pd_lrhand` int(11) NOT NULL DEFAULT '0',  `pd_lrhand_aug` int(11) NOT NULL DEFAULT '0',  `pd_hair` int(11) NOT NULL DEFAULT '0',  `pd_hair_aug` int(11) NOT NULL DEFAULT '0',  `pd_hair2` int(11) NOT NULL DEFAULT '0',  `pd_hair2_aug` int(11) NOT NULL DEFAULT '0',  `pd_rbracelet` int(11) NOT NULL DEFAULT '0',  `pd_rbracelet_aug` int(11) NOT NULL DEFAULT '0',  `pd_lbracelet` int(11) NOT NULL DEFAULT '0',  `pd_lbracelet_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco1` int(11) NOT NULL DEFAULT '0',  `pd_deco1_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco2` int(11) NOT NULL DEFAULT '0',  `pd_deco2_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco3` int(11) NOT NULL DEFAULT '0',  `pd_deco3_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco4` int(11) NOT NULL DEFAULT '0',  `pd_deco4_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco5` int(11) NOT NULL DEFAULT '0',  `pd_deco5_aug` int(11) NOT NULL DEFAULT '0',  `pd_deco6` int(11) NOT NULL DEFAULT '0',  `pd_deco6_aug` int(11) NOT NULL DEFAULT '0',  `enchant_effect` tinyint(4) NOT NULL DEFAULT '0',  `pvp_flag` int(11) NOT NULL DEFAULT '0',  `karma` int(11) NOT NULL DEFAULT '0',  `fishing` tinyint(4) NOT NULL DEFAULT '0',  `fishing_x` int(11) NOT NULL DEFAULT '0',  `fishing_y` int(11) NOT NULL DEFAULT '0',  `fishing_z` int(11) NOT NULL DEFAULT '0',  `invisible` tinyint(4) NOT NULL DEFAULT '1',  PRIMARY KEY (`npc_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;  

Re: Need Tutorial

Posted: Sat Aug 13, 2011 11:03 am
by n1k3
Thank you it helped , but there still a problem NPC remained as he had been. :?

Re: Need Tutorial

Posted: Sat Aug 13, 2011 3:27 pm
by Legend1
what problem u have maybe i can help tell me what client you ate using if you are using H5 i can give you my patch

Re: Need Tutorial

Posted: Sat Aug 13, 2011 4:57 pm
by n1k3
I using freya.
I may be wrong java files processed