Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

[HELP]MySql code

killer666

Asked by killer666,

 Share

Question

killer666 Rookie

killer666

Posted
Posted

Hello dudes. I need some help here.

 

Here is a code to add baium ring to baiums droplist 

INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');

 

if i want to add to drop etc:  

+ 10 baium ring

or 

+ 22 Draconic Bow

what i have to do??? or how can i do this?

 

I really need the help here. :/

 

Thanks!

6 answers to this question

Recommended Posts

  • 0
xAddytzu Newbie

xAddytzu

Posted
Posted

Declare the next code in overrided doDie method from L2RaidbossInstance

 

 

 

 

if(killer instanceof L2PlayableInstance)

{

L2PcInstance player = ((L2PcInstance)killer);

   

int templateId = RB ID;

L2NpcTemplate template = NpcTable.getInstance().getTemplate(templateId);

 

if (template != null)

{

int itemId = ITEM ID;

L2ItemInstance item = player.getInventory().addItem("xAddytzu", itemId, 1, player, null);

item.setEnchantLevel(25);

}

}

 

  • 0
killer666 Rookie

killer666

Posted
  • Author
Posted

-- Table structure for table `weapon`

--

 

DROP TABLE IF EXISTS `weapon`;

CREATE TABLE `weapon` (

  `item_id` decimal(11,0) NOT NULL default '0',

  `name` varchar(70) default NULL,

  `bodypart` varchar(15) default NULL,

  `crystallizable` varchar(5) default NULL,

  `weight` decimal(4,0) default NULL,

  `soulshots` decimal(2,0) default NULL,

  `spiritshots` decimal(1,0) default NULL,

  `material` varchar(11) default NULL,

  `crystal_type` varchar(4) default NULL,

  `p_dam` decimal(5,0) default NULL,

  `rnd_dam` decimal(2,0) default NULL,

  `weaponType` varchar(8) default NULL,

  `critical` decimal(2,0) default NULL,

  `hit_modify` decimal(6,5) default NULL,

  `avoid_modify` decimal(2,0) default NULL,

  `shield_def` decimal(3,0) default NULL,

  `shield_def_rate` decimal(2,0) default NULL,

  `atk_speed` decimal(3,0) default NULL,

  `mp_consume` decimal(2,0) default NULL,

  `m_dam` decimal(3,0) default NULL,

  `duration` decimal(3,0) default NULL,

  `price` decimal(11,0) default NULL,

  `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',

  `enchant4_skill_id` decimal(11,0) NOT NULL default '0',

  `enchant4_skill_lvl` decimal(11,0) NOT NULL default '0',

  `onCast_skill_id` decimal(11,0) NOT NULL default '0',

  `onCast_skill_lvl` decimal(11,0) NOT NULL default '0',

  `onCast_skill_chance` decimal(11,0) NOT NULL default '0',

  `onCrit_skill_id` decimal(11,0) NOT NULL default '0',

  `onCrit_skill_lvl` decimal(11,0) NOT NULL default '0',

  `onCrit_skill_chance` decimal(11,0) NOT NULL default '0',

  PRIMARY KEY  (`item_id`)

) TYPE=MyISAM;

 

--

-- Dumping data for table `weapon`

--

 

INSERT INTO `weapon` VALUES

('1','Short Sword','rhand','false','1600','1','1','steel','none','8','10','sword','8','0.00000','0','0','0','379','0','6','-1','768','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('2','Long Sword','rhand','false','1560','2','2','fine_steel','none','24','10','sword','8','0.00000','0','0','0','379','0','17','-1','136000','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('3','Broadsword','rhand','false','1590','1','1','steel','none','11','10','sword','8','0.00000','0','0','0','379','0','9','-1','12500','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('4','Club','rhand','false','1870','1','1','wood','none','8','20','blunt','4','4.00000','0','0','0','379','0','6','-1','768','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('5','Mace','rhand','false','1880','1','1','steel','none','11','20','blunt','4','4.00000','0','0','0','379','0','9','-1','12500','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('6','Apprentice\'s Wand','rhand','false','1350','1','1','steel','none','5','20','blunt','4','4.00000','0','0','0','379','0','7','-1','138','0','false','false','true','false','0','0','0','0','0','0','0','0','0','0'),

('7','Apprentice\'s Rod','rhand','false','1330','1','1','wood','none','6','20','blunt','4','4.00000','0','0','0','379','0','8','-1','768','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('8','Willow Staff','lrhand','false','1080','1','1','wood','none','11','20','bigblunt','4','4.00000','0','0','0','325','0','12','-1','12500','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('9','Cedar Staff','lrhand','false','1090','2','2','wood','none','16','20','bigblunt','4','4.00000','0','0','0','325','0','16','-1','54100','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('10','Dagger','rhand','false','1160','1','1','steel','none','5','5','dagger','12','-3.00000','0','0','0','433','0','5','-1','138','0','false','false','true','false','0','0','0','0','0','0','0','0','0','0'),

('11','Bone Dagger','rhand','false','1150','1','1','bone','none','7','5','dagger','12','-3.00000','0','0','0','433','0','6','-1','768','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('12','Knife','rhand','false','1140','1','1','bronze','none','10','5','dagger','12','-3.00000','0','0','0','433','0','9','-1','12500','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('13','Short Bow','lrhand','false','1950','1','1','wood','none','16','5','bow','12','-3.00000','0','0','0','293','1','6','-1','768','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('14','Bow','lrhand','false','1930','1','1','wood','none','23','5','bow','12','-3.00000','0','0','0','293','1','9','-1','12500','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('15','Short Spear','lrhand','false','2140','2','2','steel','none','24','10','pole','8','-3.00000','0','0','0','325','0','17','-1','136000','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('16','Long Spear','lrhand','false','2120','2','2','bronze','none','31','10','pole','8','-3.00000','0','0','0','325','0','21','-1','244000','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('18','Leather Shield','lhand','false','1430','0','0','leather','none','0','0','none','0','0.00000','-8','47','20','0','0','0','-1','39','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('19','Small Shield','lhand','false','1420','0','0','steel','none','0','0','none','0','0.00000','-8','56','20','0','0','0','-1','638','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('20','Buckler','lhand','false','1410','0','0','wood','none','0','0','none','0','0.00000','-8','67','20','0','0','0','-1','2780','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('66','Gladius','rhand','false','1570','2','2','steel','none','17','10','sword','8','0.00000','0','0','0','379','0','12','-1','54100','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('67','Orcish Sword','rhand','false','1570','2','2','steel','none','17','10','sword','8','0.00000','0','0','0','379','0','12','-1','54100','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('68','Falchion','rhand','false','1530','2','2','bronze','none','31','10','sword','8','0.00000','0','0','0','379','0','21','-1','244000','0','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('69','Bastard Sword','rhand','true','1510','2','2','fine_steel','d','51','10','sword','8','0.00000','0','0','0','379','0','32','-1','644000','1170','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('70','Claymore','lrhand','true','2090','3','3','fine_steel','d','112','10','bigsword','8','0.00000','0','0','0','325','0','54','-1','1800000','3272','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('71','Flamberge','lrhand','true','2010','2','2','bronze','c','130','10','bigsword','8','0.00000','0','0','0','325','0','61','-1','2290000','916','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('72','Stormbringer','rhand','true','1430','2','2','fine_steel','c','107','10','sword','8','0.00000','0','0','0','379','0','61','-1','2290000','916','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('73','Shamshir','rhand','true','1420','2','2','fine_steel','c','122','10','sword','8','0.00000','0','0','0','379','0','68','-1','2870000','1148','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('74','Katana','rhand','true','1420','2','2','fine_steel','c','122','10','sword','8','0.00000','0','0','0','379','0','68','-1','2870000','1148','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('75','Caliburs','rhand','true','1400','3','3','oriharukon','c','139','10','sword','8','0.00000','0','0','0','379','0','76','-1','4300000','1720','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('76','Sword of Delusion','rhand','true','1400','3','3','mithril','c','139','10','sword','8','0.00000','0','0','0','379','0','76','-1','4300000','1720','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('77','Tsurugi','rhand','true','1400','3','3','fine_steel','c','139','10','sword','8','0.00000','0','0','0','379','0','76','-1','4300000','1720','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('78','Great Sword','lrhand','true','1930','1','1','steel','b','213','10','bigsword','8','0.00000','0','0','0','325','0','91','-1','8680000','1157','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('79','Sword of Damascus','rhand','true','1350','1','1','damascus','b','194','10','sword','8','0.00000','0','0','0','379','0','99','-1','13100000','1746','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('80','Tallum Blade','rhand','true','1330','1','1','adamantaite','a','213','10','sword','8','0.00000','0','0','0','379','0','107','-1','18300000','1464','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('81','Dragon Slayer','lrhand','true','1840','1','1','bone','a','282','10','bigsword','8','0.00000','0','0','0','325','0','114','-1','27000000','2160','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('82','God\'s Blade','rhand','true','1300','1','1','adamantaite','s','257','10','sword','8','0.00000','0','0','0','379','0','124','-1','38000000','1900','false','false','true','false','0','0','0','0','0','0','0','0','0','0'),

('83','Sword of Magic','rhand','true','970','2','2','bronze','d','43','10','sword','8','0.00000','0','0','0','379','0','45','-1','716000','1301','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('84','Homunkulus\'s Sword','rhand','true','950','3','3','blood_steel','c','111','10','sword','8','0.00000','0','0','0','379','0','101','-1','4300000','1720','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('85','Phantom Sword','rhand','true','860','1','1','oriharukon','a','170','10','sword','8','0.00000','0','0','0','379','0','143','-1','18300000','1464','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

('86','Tomahawk','rhand','true','1780','2','2','bronze','d','51','20','blunt','4','4.00000','0','0','0','379','0','32','-1','644000','1170','true','true','true','true','0','0','0','0','0','0','0','0','0','0'),

 

can someone explain me what is the use of the 2 lines that are red?

  • 0
xAddytzu Newbie

xAddytzu

Posted
Posted

You can put a skill on weapon, when is equiped you get the skill

 

 

    private L2Skill _enchant4Skill = null; // skill that activates when item is enchanted +4 (for duals)

sId = set.getInteger("enchant4_skill_id");

sLv = set.getInteger("enchant4_skill_lvl");

if(sId > 0 && sLv > 0)

_enchant4Skill = SkillTable.getInstance().getInfo(sId, sLv);

  • 0
killer666 Rookie

killer666

Posted
  • Author
Posted

You can put a skill on weapon, when is equiped you get the skill

 

 

    private L2Skill _enchant4Skill = null; // skill that activates when item is enchanted +4 (for duals)

sId = set.getInteger("enchant4_skill_id");

sLv = set.getInteger("enchant4_skill_lvl");

if(sId > 0 && sLv > 0)

_enchant4Skill = SkillTable.getInstance().getInfo(sId, sLv);

 

thats good... thanks! :p :p

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing


  • Posts

    • rufi
      InertiaX AutoFarm

      By rufi · Posted

      Faltan demasiados archivos,  y lógicas en clases claves como L2pcInstance, entre otras. si bien muchas cosas están y el flujo es valorable.  Gracias por tu esfuerzo es bastante... pero realmente no esta completo el código, falta que subas todas las modificaciones en clases colaterales... podrías intentar subir un diff de todo el mod  completo de tu pack y bueno ahí si que cada uno adapte... pero faltan muchas cosas, dudo que haya gente que lo haya echo funcionar con esto... 
    • Celestine
      [Active Anticheat] When Promises Fall Short

      By Celestine · Posted

      I know people who have fully bypassed and reversed AAC. One day, they might even release the full source code, but for now, they’re still making money off it. I won’t name anyone, but it’s clear that there aren’t any truly solid anticheats for Lineage2. As I’ve said before, kernel level anticheats are the only real solution. Anything that runs as Internal and injects gets flagged, and your account ends up getting kicked or banned. That’s just how most games handle it nowadays. To TL;DR the whole thing cheating will always exist because there are people out there smart enough to bypass any protection and run private cheats. Public cheats are always detected eventually, so I don’t see any point in buying AAC, especially when they claim it blocks adr, which simply isn’t true.
    • nicu30
      [L2J] L2 Adonis

      By nicu30 · Posted

      🌐 Website: https://l2adonis.com 📅 GRAND OPENING: July 18, 2025 – 20:00 (UTC+2) 💬 Discord: https://discord.com/invite/tZBj8JxAwx 🚫 No auto-farm • No auto-macro • No pay-to-win • No custom   Some Basic Info's (More detalied info's on website)  EXP/SP: x25  Adena: x15  Drop: x15  Spoil: x15  Seal Stones: x15  Raid Boss Drop: x10  Epic Boss Drop: x1  Manor: x10  Safe Enchant: +4  Max Enchant: +16  Normal Scroll Chance: 50%  Blessed Scroll Chance: 66% (If enchant fail item remain +4)  Buff Slots (30+4 extra with Divine Inspiration)  Dances/Songs Slots 14  Auto-learn skills  ⚔️ Real PvP • Real Progression • Retail-like experience JOIN NOW and relive the real L2 experience!
    • Utchiha-Market
      Full Verified 2015 - 2022 Discord Token's For Just $0.69

      By Utchiha-Market · Posted

      Discord         :  utchiha_market Telegram        : https://t.me/utchiha_market Auto Buy Store  : https://utchihamkt.mysellauth.com/ Not sure if we’re legit? Check Our server — real reviews, real buyers https://discord.gg/uthciha-servicess  | https://campsite.bio/utchihaamkt
    • MrVercetti
      LF DEVELOPER

      By MrVercetti · Posted

      Looking for a Developer – Lineage II Interlude (Vanganth Files)   I’m seeking a developer to collaborate on a project based on Vanganth Interlude files.   Important: Applicants with a bad attitude, lack of respect, or unwillingness to work will be immediately rejected. Payment: Hourly rate, not per task. Contact: Please reach out to me via PM.

  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock