Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
We're Rebuilding – Join Our Staff Team
  • 0

[Help]need pr00 help gia navicat kai SQL arxeia

angelos95

Asked by angelos95,

 Share

Question

angelos95 Newbie

angelos95

Posted
Posted

hi se olus elpizw na me help. ftiaxnw enan l2jOfficia pack kai 8elw na valw mesa npc kai items ala dn borw gt mu vgazei error .... 

sigura ine kati me to syntax ala dn 3erw ti alo na kanw. plzz help me  kai e3igiste mu pws

 

 

 

 

 

 

INSERT INTO `weapon` (`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`) VALUES

('9700', 'Devil Spear', 'lrhand', 'true', '1300', '1', '1', 'adamantaite', 's', '366', '10', 'pole', '8', '0.00000', '0', '0', '0', '379', '0', '132', '-1', '48800000', 2440, 'false', 'false', 'true', 'true', '3037', '2', '0', '0', '0', '0', '0', '0', '0', '0');

 

 

this is the SQL for 1 of the epic weps plzzz fix and repost it plz

 

 

19 answers to this question

Recommended Posts

  • 0
Sillent Newbie

Sillent

Posted
Posted

Τώρα;

 

REPLACE INTO `weapon` VALUES
(9700,'Devil Spear','lrhand','true',1300,1,1,'adamantaite','s',366,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9701, 'Medusa Blade', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'sword', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9702, 'Hades Dagger', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'dagger', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9703, 'Thor Hammer', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'blunt', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9704, 'Odin Cleaver', 'rhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'bigsword', 12, -3.00000, 0, 0, 0, 293, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9705, 'Artemis Bow', 'lrhand', 'true', 1820, 1, 1, 'adamantaite', 's', 444, 20, 'bow', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9706, 'Zeus Mace', 'rhand', 'true', 1800, 1, 1, 'adamantaite', 's', 366, 5, 'blunt', 8, -3.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9707, 'Ares Fists', 'lrhand', 'true', 1350, 1, 1, 'adamantaite', 's', 444, 5, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9708, 'Aphrodite Staff', 'lrhand', 'true', 1380, 1, 1, 'adamantaite', 's', 444, 5, 'bigblunt', 8, 0.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9704, 'Odin Cleaver', 'rhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'bigsword', 12, -3.00000, 0, 0, 0, 293, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9705, 'Artemis Bow', 'lrhand', 'true', 1820, 1, 1, 'adamantaite', 's', 444, 20, 'bow', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9706, 'Zeus Mace', 'rhand', 'true', 1800, 1, 1, 'adamantaite', 's', 366, 5, 'blunt', 8, -3.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9707, 'Ares Fists', 'lrhand', 'true', 1350, 1, 1, 'adamantaite', 's', 444, 5, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9708, 'Aphrodite Staff', 'lrhand', 'true', 1380, 1, 1, 'adamantaite', 's', 444, 5, 'bigblunt', 8, 0.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9709, 'Dual Medusa Blade', 'lrhand', 'true', 1300, 1, 1, 'adamantaite', 's', 310, 20, 'dual', 4, 4.00000, 0, 0, 0, 379, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9710, 'Spartan Shield', 'lhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'none', 12, -3.00000, 0, 0, 0, 293, 11, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');

Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • Advertising
      Hello everyone, this is ADENA L2REBORN / LU4 / MASTERWORK

      By Advertising · Posted

    • Advertising
      WTS/WTB L2REBORN x1 ( NEW )

      By Advertising · Posted

      you idiots ?  
    • MarGaZeaS
      PvP Random Zone

      By MarGaZeaS · Posted

      what pack you use  send me on discord for it
    • cheto45
      PvP Random Zone

      By cheto45 · Posted

      package custom.events.RandomZoneEvent; import java.io.File; import java.util.ArrayList; import java.util.List; import java.util.Random; import java.util.concurrent.ScheduledFuture; import org.w3c.dom.Document; import org.w3c.dom.Node; import org.l2jmobius.commons.threads.ThreadPool; import org.l2jmobius.commons.time.SchedulingPattern; import org.l2jmobius.commons.time.TimeUtil; import org.l2jmobius.commons.util.IXmlReader; import org.l2jmobius.gameserver.managers.ZoneManager; import org.l2jmobius.gameserver.model.StatSet; import org.l2jmobius.gameserver.model.actor.Creature; import org.l2jmobius.gameserver.model.actor.Npc; import org.l2jmobius.gameserver.model.actor.Player; import org.l2jmobius.gameserver.model.quest.Event; import org.l2jmobius.gameserver.model.zone.ZoneId; import org.l2jmobius.gameserver.model.zone.ZoneType; import org.l2jmobius.gameserver.model.zone.type.RandomZone; import org.l2jmobius.gameserver.util.Broadcast; /** * Random Zone Event - Activates one random PvP zone temporarily. No modifica la clase de la zona: usa flags PvP en runtime. * @author Juan */ public class RandomZoneEvent extends Event { private static final String CONFIG_FILE = "data/scripts/custom/events/RandomZoneEvent/config.xml"; private static int EVENT_DURATION_MINUTES = 15; private static boolean _isActive = false; private ScheduledFuture<?> _eventTask = null; private final List<ZoneType> _availableZones = new ArrayList<>(); private ZoneType _activeZone = null; public RandomZoneEvent() { loadConfig(); loadZones(); registerZoneListeners(); } /** * Registra listeners a TODAS LAS ZONAS random */ private void registerZoneListeners() { for (ZoneType zone : _availableZones) { addEnterZoneId(zone.getId()); addExitZoneId(zone.getId()); LOGGER.info("[RandomZoneEvent] Registered listener for zone: " + zone.getName()); } } private void loadConfig() { new IXmlReader() { @Override public void load() { parseDatapackFile(CONFIG_FILE); } @Override public void parseDocument(Document doc, File file) { forEach(doc, "event", eventNode -> { final StatSet att = new StatSet(parseAttributes(eventNode)); final String name = att.getString("name"); for (Node node = eventNode.getFirstChild(); node != null; node = node.getNextSibling()) { if ("schedule".equals(node.getNodeName())) { final StatSet attributes = new StatSet(parseAttributes(node)); final String pattern = attributes.getString("pattern"); final SchedulingPattern schedulingPattern = new SchedulingPattern(pattern); final StatSet params = new StatSet(); params.set("Name", name); params.set("SchedulingPattern", pattern); final long delay = schedulingPattern.getDelayToNextFromNow(); getTimers().addTimer("Schedule_" + name, params, delay + 5000, null, null); LOGGER.info("[RandomZoneEvent] Event " + name + " scheduled at " + TimeUtil.getDateTimeString(System.currentTimeMillis() + delay)); } } }); } }.load(); } private void loadZones() { for (ZoneType zone : ZoneManager.getInstance().getAllZones(RandomZone.class)) { if ((zone.getName() != null) && zone.getName().toLowerCase().startsWith("random_zone")) { _availableZones.add(zone); LOGGER.info("[RandomZoneEvent] Loaded zone: " + zone.getName() + " (id=" + zone.getId() + ")"); } } LOGGER.info("[RandomZoneEvent] Total random zones loaded: " + _availableZones.size()); } @Override public void onTimerEvent(String event, StatSet params, Npc npc, Player player) { if (event.startsWith("Schedule_")) { eventStart(null); final SchedulingPattern schedulingPattern = new SchedulingPattern(params.getString("SchedulingPattern")); final long delay = schedulingPattern.getDelayToNextFromNow(); getTimers().addTimer(event, params, delay + 5000, null, null); LOGGER.info("[RandomZoneEvent] Rescheduled for " + TimeUtil.getDateTimeString(System.currentTimeMillis() + delay)); } } @Override public boolean eventStart(Player eventMaker) { if (_isActive) { if (eventMaker != null) { eventMaker.sendMessage("RandomZoneEvent already active."); } return false; } if (_availableZones.isEmpty()) { Broadcast.toAllOnlinePlayers("[RandomZoneEvent] No zones configured."); return false; } _isActive = true; Broadcast.toAllOnlinePlayers("⚔️ Random Zone Event has started!"); _eventTask = ThreadPool.schedule(this::activateRandomZone, 5_000); return true; } private void activateRandomZone() { _activeZone = _availableZones.get(new Random().nextInt(_availableZones.size())); _activeZone.setEnabled(true); Broadcast.toAllOnlinePlayers("🔥 Random Zone Event: " + _activeZone.getName() + " is now PvP for " + EVENT_DURATION_MINUTES + " minutes!"); _eventTask = ThreadPool.schedule(this::eventStop, EVENT_DURATION_MINUTES * 60 * 1000L); } @Override public boolean eventStop() { if (!_isActive) { return false; } _isActive = false; if (_eventTask != null) { _eventTask.cancel(true); _eventTask = null; } if (_activeZone != null) { _activeZone.setEnabled(false); Broadcast.toAllOnlinePlayers("🏁 Random Zone Event ended. " + _activeZone.getName() + " is back to normal."); _activeZone = null; } else { Broadcast.toAllOnlinePlayers("🏁 Random Zone Event ended."); } return true; } @Override public void onEnterZone(Creature creature, ZoneType zone) { if (!_isActive || (_activeZone == null)) { return; } if ((zone == _activeZone) && creature.isPlayable()) { creature.setInsideZone(ZoneId.PVP, true); if (creature.isPlayer()) { creature.sendMessage("Esta zona está en modo PvP temporalmente."); } } } @Override public void onExitZone(Creature creature, ZoneType zone) { if (!_isActive || (_activeZone == null)) { return; } if ((zone == _activeZone) && creature.isPlayable()) { creature.setInsideZone(ZoneId.PVP, false); if (creature.isPlayer()) { creature.sendMessage("Abandonaste la zona PvP temporal."); } } } @Override public boolean eventBypass(Player player, String bypass) { return true; } @Override public String onEvent(String event, Npc npc, Player player) { return super.onEvent(event, npc, player); } @Override public String onFirstTalk(Npc npc, Player player) { return null; } public static void main(String[] args) { new RandomZoneEvent(); } } i have this but its not working
    • paparas22
      🌟 [RELEASE] Full Lineage 2 C4 Accumulative

      By paparas22 · Posted

      ZonePvPSpawnBossRadio=0 ZonePvPSpawnBossBarakiel=0 at the Customs.ini in L2Server folder. Im prety sure this is it because i had the same problem with you in cruma 1 floor for example and i couldn't fix it but i fixed it finally by changing these 2 lines

  • 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