Zaldron

nikos_span@hotmail.com trusted guy

Φυσικά και θα σας βγάλει τέτειο error άμα έχετε βάλει κωδικό στο navicat και δεν τον έχετε βάλει στα Login server / Game server bat

The problem is here it's not typed well . I dont know a lot for sql so wait for another person to reply u .

[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 'TYPE=MyISAM' at line 24 [Err] -- -- Table structure for table `armor` -- DROP TABLE IF EXISTS `armor`; CREATE TABLE `armor` ( `item_id` int(11) NOT NULL default '0', `name` varchar(70) default NULL, `bodypart` varchar(15) NOT NULL default '', `crystallizable` varchar(5) NOT NULL default '', `armor_type` varchar(5) NOT NULL default '', `weight` int(5) NOT NULL default '0', `material` varchar(15) NOT NULL default '', `crystal_type` varchar(4) NOT NULL default '', `avoid_modify` int(1) NOT NULL default '0', `duration` int(3) NOT NULL default '0', `p_def` int(3) NOT NULL default '0', `m_def` int(2) NOT NULL default '0', `mp_bonus` int(3) NOT NULL default '0', `price` int(11) NOT NULL default '0', `crystal_count` int(4) default NULL, `sellable` varchar(5) default NULL, `dropable` varchar(5) default NULL, `destroyable` varchar(5) default NULL, `tradeable` varchar(5) default NULL, `item_skill_id` decimal(11,0) NOT NULL default '0', `item_skill_lvl` decimal(11,0) NOT NULL default '0', PRIMARY KEY (`item_id`) TYPE=MyISAM; [Err] 1146 - Table 'l2jdb.armor' doesn't exist [Err] -- -- Dumping data for table `armor` INSERT INTO `armor` VALUES ('21','Shirt','chest','false','light','4830','cloth','none','0','-1','36','0','0','147','0','true','true','true','true','0','0'), ('22','Leather Shirt','chest','false','light','4830','leather','none','0','-1','43','0','0','2430','0','true','true','true','true','0','0'), ('23','Wooden Breastplate','chest','false','light','4820','wood','none','0','-1','47','0','0','7960','0','true','true','true','true','0','0'), ('24','Bone Breastplate','chest','false','light','4770','bone','none','0','-1','50','0','0','20300','0','true','true','true','true','0','0'), ('25','Piece Bone Breastplate','chest','false','heavy','8970','bone','none','0','-1','62','0','0','31800','0','true','true','true','true','0','0'), ('26','Bronze Breastplate','chest','false','heavy','8920','bronze','none','0','-1','68','0','0','49200','0','true','true','true','true','0','0'), ('27','Hard Leather Shirt','chest','false','light','4720','leather','none','0','-1','53','0','0','36900','0','true','true','true','true','0','0'), ('28','Pants','legs','false','light','1740','cloth','none','0','-1','22','0','0','92','0','true','true','true','true','0','0'), ('29','Leather Pants','legs','false','light','1730','leather','none','0','-1','27','0','0','1520','0','true','true','true','true','0','0'), ('30','Hard Leather Pants','legs','false','light','1700','leather','none','0','-1','29','0','0','4970','0','true','true','true','true','0','0'), ('31','Bone Gaiters','legs','false','light','1680','bone','none','0','-1','32','0','0','12700','0','true','true','true','true','0','0'), ('32','Piece Bone Gaiters','legs','false','heavy','4020','bone','none','0','-1','39','0','0','19900','0','true','true','true','true','0','0'), ('33','Hard Leather Gaiters','legs','false','light','1610','leather','none','0','-1','33','0','0','23000','0','true','true','true','true','0','0'), ('34','Bronze Gaiters','legs','false','heavy','3960','bronze','none','0','-1','43','0','0','30700','0','true','true','true','true','0','0'), ('35','Cloth Shoes','feet','false','none','1320','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'), ('36','Leather Sandals','feet','false','none','1320','leather','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'), ('37','Leather Shoes','feet','false','none','1320','leather','none','0','-1','13','0','0','2650','0','true','true','true','true','0','0'), ('38','Low Boots','feet','false','none','1320','leather','none','0','-1','15','0','0','6770','0','true','true','true','true','0','0'), ('39','Boots','feet','false','none','1310','cloth','none','0','-1','17','0','0','12300','0','true','true','true','true','0','0'), ('40','Leather Boots','feet','true','none','1300','leather','d','0','-1','19','0','0','20900','38','true','true','true','true','0','0'), ('41','Cloth Cap','head','false','none','660','cloth','none','0','-1','13','0','0','55','0','true','true','true','true','0','0'), ('42','Leather Cap','head','false','none','660','leather','none','0','-1','16','0','0','911','0','true','true','true','true','0','0'), ('43','Wooden Helmet','head','false','none','660','wood','none','0','-1','19','0','0','3980','0','true','true','true','true','0','0'), ('44','Leather Helmet','head','false','none','650','leather','none','0','-1','23','0','0','10200','0','true','true','true','true','0','0'), ('45','Bone Helmet','head','true','none','640','bone','d','0','-1','29','0','0','31300','56','true','true','true','true','0','0'), ('46','Bronze Helmet','head','true','none','630','bronze','d','0','-1','33','0','0','50000','90','true','true','true','true','0','0'), ('47','Helmet','head','true','none','640','fine_steel','d','0','-1','37','0','0','76200','138','true','true','true','true','0','0'), ('48','Short Gloves','gloves','false','none','660','cloth','none','0','-1','9','0','0','37','0','true','true','true','true','0','0'), ('49','Gloves','gloves','false','none','660','cloth','none','0','-1','13','0','0','2650','0','true' [Msg] Finished - Unsuccessfully -------------------------------------------------- Try to do it like this one

What's this? If u add this then nothing is wrong . Just execute the sql it's so simple .

press "C" and when u finish the installation add the armor.sql to navicat alone.

What's the points ? It's useless since it's already on l2jfrozen. Someone lock it ...

Just relax guys he's trying to help that section with shares . I dont say that he is correct at all but one warn it's ok !

Come on speak english it's not greek forum

It's called "Epic Armor" , just download it from where u find that pic and try to adapt it for h5 that's all .

Why u post it since it's already added on frozen ?

Thanks for your feedback & test .

Where is your problem ? I Havent got Lineage on my computer !

And wtf are u ? You thing that you are smart and posting ? L2J Website Developer ( o really ? )

No psd and no php scripts = useless

I cant see any insult . I cant say that's called spam.

No friends to celebrate with ?

Hello , it's my first share at this forum and i hope u will like it . It's not tested yet (if u test it please leave a reply) . With this code when someone is teleporting at pvp zone then he's autoflagged . L2Characters.java /** Zone system */ +public static final byte ZONE_FLAG_PVP = 0; public static final byte ZONE_PVP = 0; find public final boolean isInsideZone(final byte zone) { return zone == ZONE_PVP ? _zones[ZONE_PVP] > 0 && _zones[ZONE_PEACE] == 0 : _zones[zone] > 0; } make it public final boolean isInsideZone(final byte zone) { return zone == ZONE_PVP ? _zones[ZONE_PVP] > 0 && ZONE_FLAG_PVP ? _zones[ZONE_FLAG_PVP] > 0 && _zones[ZONE_PEACE] == 0 : _zones[zone] > 0; } L2PvPAreaZone.java package com.l2jserver.gameserver.model.zone.type; import com.l2jserver.gameserver.datatables.MapRegionTable; import com.l2jserver.gameserver.model.actor.L2Character; import com.l2jserver.model.actor.instance.L2PcInstance; import com.l2jserver.model.zone.L2SpawnZone; import com.l2jserver.gameserver.network.SystemMessageId; import com.l2jserver.gameserver.network.serverpackets.SystemMessage; /** * @author Zaldron */ public class L2PvpAreaZone extends L2SpawnZone { private L2PcInstance activeChar; public PvpArea(int id) { super(11037); } protected void onEnter(L2Character character) { if (character instanceof L2PcInstance) { if (!character.isInsideZone(L2Character.ZONE_FLAG_PVP)) ((L2PcInstance) character).sendPacket(new SystemMessage(SystemMessageId.ENTERED_COMBAT_ZONE)); } character.setInsideZone(L2Character.ZONE_FLAG_PVP, true); character.setInsideZone(L2Character.ZONE_NOSUMMONFRIEND, true); activeChar.decayMe(); activeChar.spawnMe(); activeChar.isNoblesseBlessed(); activeChar.setPvpFlag(1); activeChar.setTitle("Lets Fight"); activeChar.broadcastUserInfo(); } protected void onExit(L2Character character) { character.setInsideZone(L2Character.ZONE_FLAG_PVP, false); character.setInsideZone(L2Character.ZONE_NOSUMMONFRIEND, false); activeChar.decayMe(); activeChar.spawnMe(); activeChar.stopNoblesseBlessing(null); activeChar.setPvpFlag(0); activeChar.setTitle(""); activeChar.broadcastUserInfo(); if (character instanceof L2PcInstance) { if (!character.isInsideZone(L2Character.ZONE_FLAG_PVP)) ((L2PcInstance) character).sendPacket(new SystemMessage(SystemMessageId.LEFT_COMBAT_ZONE)); } } public void onDieInside(L2Character character) {MapRegionTable.getInstance().getTeleToLocation(activeChar, MapRegionTable.TeleportWhereType.Town);} public void onReviveInside(L2Character character) {} } </zone> <zone id="11037" type="ZONE_FLAG_PVP" shape="NPoly" minZ="-3600" maxZ="-3400"> <stat name="isPeaceZone" val="false" /> <spawn X="x" Y="y5" Z="z" /> </zone> /** * On "x" "y" "z" you can put your pvp zone. */ L2Zonetype.java + else if(zoneType.equals("PvpFlagZone")) + { + temp = new PvpAreaZone(11037); + } SQL All kind of comments are accepted . Also thanks for your time by watching the topic !

Then you are a fail troller . And what's your problem exactly ? You are the owner of l2six ? He did one mistake that's all !

Oh yea !

I know trance and he told me what happend.. And what are u exactly ? His babysiter ?

Show me the html code maybe i can help u ...

No it's not possible but maybe it's saved to another place - table .

Dont try to untangle the things , i know very well what happend to l2finest and who decide to close it.