Jump to content

Recommended Posts

Posted

Plz I need the IDs of Crystals D,C,B and A because players buy them with 15 adena and they sell them for 7500 adena.

 

If anyone knows how to delete them from the GMShop plzz tell me. Thanks

Posted

Here are the ID's for crystals:

 

Crystal: D Grade ID: 1458

 

Crystal: C Grade ID: 1459

 

Crystal: B Grade ID: 1460

 

Crystal: A Grade ID: 1461

 

Crystal: S Grade ID: 1462

  • 1 month later...
Posted

Here you got preaty script that check if shop buy for more adena then sell.

 

I dont take credits for this, It's not my work.

 

 

 

<body link="navy" vlink="blue" alink="#00CCFF" text="#003366" bgcolor="#f0f0ff">

 

<font face="Garamont" size="3">

 

<meta NAME="Author" CONTENT="Enforcer"><center><b>

 

<title>Check shops for items that allow adena exploits</title>

 

</body>

 

 

 

<?php

 

$db_user = "root"; //your sql username goes here

 

$db_pass = "root"; //your sql password goes here

 

$db_name = "l2jdb"; //your database name goes here

 

$db_serv = "127.0.0.1"; //the address of the database goes here

 

 

 

$res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");

 

mysql_select_db ( $db_name );

 

 

 

echo' <hr><form action="checkshops.php" method="post">

 

Items type:<select name="R1">

 

<option value="Weapons">Weapons</option>

 

<option value="Armors">Armors</option>

 

<option value="Others">Others</option>

 

<option selected value='.@$_POST['R1'].'>'.@$_POST['R1'].'</option></select>

 

<br>Shop IDs between<br><input type="text" name="shop1" size="6" value="'.@$_POST['shop1'].'"> and

 

<input type="text" name="shop2" size="6" value="'.@$_POST['shop2'].'"><br>

 

<input type="submit" name="submit" value="Go!"><hr>

 

</form>';

 

 

 

if(@$_POST['R1']=="Weapons")$table='weapon';

 

elseif(@$_POST['R1']=="Armors") $table='armor';

 

elseif(@$_POST['R1']=="Others") $table='etcitem';

 

if(empty($_POST['R1'])) {

 

echo"Please select search criteria";

 

exit();

 

}

 

 

 

if(empty($_POST['shop1']) or empty($_POST['shop1'])){

 

echo "Please fill both fields";

 

exit();

 

}

 

$shop1=@$_POST['shop1'];

 

$shop2=@$_POST['shop2'];

 

If($shop2<$shop1){

 

echo "Seoond shop ID cant be higher than first one!";

 

exit();

 

}

 

if(@$_POST['submit']=="Fix all"){

 

echo"All prices are now correct for selected range<br>";

 

}

 

 

 

$check_etcitem=(mysql_query("select $table.item_id,name,$table.price as sell_price,

 

merchant_buylists.price as buy_price,shop_id from $table,merchant_buylists

 

where $table.item_id=merchant_buylists.item_id and

 

shop_id between $shop1 and $shop2 and ($table.price/2)>merchant_buylists.price order by name"))or die(mysql_error());

 

if(mysql_num_rows($check_etcitem)==0){

 

$item_tbl='';

 

$rep_tbl='';

 

echo "You dont have items with bad prices on current selection";

 

}

 

else{

 

$rep_tbl='<table border=0 cellspacing=0 cellpadding=0 align=center valign=top width=90%>

 

<tr>

 

<form action="checkshops.php" method="post">

 

<input type="submit" name="submit" value="Fix all"></td>

 

<input type="hidden" name="R1" value="'.@$_POST['R1'].'">

 

<input type="hidden" name="shop1" value="'.@$_POST['shop1'].'">

 

<input type="hidden" name="shop2" value="'.@$_POST['shop2'].'">

 

</tr></table>';

 

$item_tbl='<table border=3 align=center width=90%>

 

<tr>Items list

 

<td style="border:0px solid silver" align=right width=10%><b>Item ID</td>

 

<td style="border:0px solid silver" align=center width=40%><b>Name</td>

 

<td style="border:0px solid silver" align=right width=15%><b>Sell price</td>

 

<td style="border:0px solid silver" align=right width=15%><b>Buy price</td>

 

<td style="border:0px solid silver" align=center width=10%><b>Earning</td>

 

<td style="border:0px solid silver" align=right width=10%><b>Shop id</td>

 

</tr></table>';

 

$i=1;

 

while ($check_etcitem_res=mysql_fetch_row($check_etcitem)){

 

$item_id=$check_etcitem_res[0];

 

$item_name=$check_etcitem_res['1'];

 

$base_price=$check_etcitem_res[2];

 

$sell_price=round($base_price/2,0);

 

$buy_price=$check_etcitem_res[3];

 

$shop_id=$check_etcitem_res[4];

 

$diff=round(($sell_price)-$buy_price,0);

 

$repair=("update merchant_buylists set price=$sell_price where item_id=$item_id and shop_id=$shop_id;");

 

 

 

//mysql_query($repair)or die(mysql_error());

 

 

 

$item_tbl.= '<table border=1 align=center width=90%>

 

<tr><form action="checkshops.php" method="post">

 

<td style="border:0px solid silver" align=center width=3%>'.$i.'.</td>

 

<td style="border:0px solid silver" align=center width=10%>'.$item_id.'</td>

 

<td style="border:0px solid silver" align=left width=30%>'.$item_name.'</td>

 

<td style="border:0px solid silver" align=right width=10%>'.$sell_price.'</td>

 

<td style="border:0px solid silver" align=right width=10%>'.$buy_price.'</td>

 

<td style="border:0px solid silver" align=right width=10%><font color=red>'.$diff.'</font></td>

 

<td style="border:0px solid silver" align=right width=10%>'.$shop_id.'</td>

 

</tr> <input type="hidden" name="R1" value="'.@$_POST['R1'].'">

 

<input type="hidden" name="shop1" value="'.@$_POST['shop1'].'">

 

<input type="hidden" name="shop2" value="'.@$_POST['shop2'].'">

 

</form></table>';

 

$i++;

 

if(@$_POST['submit']=="Fix all"){

 

mysql_query($repair);

 

}

 

}

 

}

 

if(@$_POST['submit']=="Go!"){

 

echo $rep_tbl,$item_tbl;}

 

?>

  • 1 year later...
Posted

WTF? WHY are you doing this?This is A VERY VERY old post..You have -2 karma already..You wish for 3rd?

Someone lock please, and soz for answering in such an old topic.

Guest
This topic is now closed to further replies.


  • Posts

    • what pack you use  send me on discord for it
    • 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
    • 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
    • Siege Reward Start PM Msg Rework Config root BossDieAnnounce and BossDieSound in the L24Team.properties and Config.java files for global raid boss death notifications and sounds. Adds a new reward_list table to the DB.sql file to track castle rewards. Improves character creation logic for thread safety and validation. Adds extensive state checks to the RequestEnchantItem method to prevent enchantments during inappropriate player states. Fixed auto-attack animation bug (there was no attack animation, only damage animation) Clean Code Other fixes I forgot to list! Java 14 Fixed issue where deleting a character would prevent it from leaving the screen or being removed, or even after a delete CD (it would only exit when re-logging in or creating a new character). Added Premium System from the other C2 project (Needs testing and improvement). Added the "Improved" Community Board (incomplete).
  • 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