Jump to content
MaxCheaters Official Group on Discord
-> Place your ad text here <-
LINEAGE2.GOLD INTERLUDE SERVER ON ESSENCE CLIENT

Need ID of Crystals D,C,B and A

pidixtoylis
 Share

Recommended Posts

pidixtoylis Newbie

pidixtoylis

Posted
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

Akagi Newbie

Akagi

Posted
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...
ACiD_I3URN Newbie

ACiD_I3URN

Posted
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...
spawn123 Newbie

spawn123

Posted
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.
 Share
Go to topic listing


  • Posts

    • kreis
      L2DragonLnads Custom High Five

      By kreis · Posted

      L2Virus the one who buyed those files from me.
    • ALISMS
      SMS.PRO - platform for selling your numbers

      By ALISMS · Posted

      Hi ️ Are you a supplier or do you have your own modem and are looking for a place to sell numbers?  SMS.PRO - The best option for selling your numbers  You choose the selling price yourself  Sale option: public (to everyone) or private (you choose who you want to sell to)  Everything works automatically  The simplest possible connection  Visit the website SMS.PRO and start selling your numbers.  Support @alismsorg_bot
    • L2Virus
      L2DragonLnads Custom High Five

      By L2Virus · Posted

      Good luck to anyone playing on this server . Kamael items are bugged ( stats are insane ) Commands not working properly ( .getreward for example  ... gives u free reward without voting ). When i had those files , i fixed most of the stuff .   Every 2-3 years , he closes the server because players report bugs to him about items , he dont know how to fix then he repeating the process again https://ibb.co/Fkv7y9hJ https://ibb.co/fdYP2bVQ https://ibb.co/sp1f8C61 https://ibb.co/CKZnCgL7 https://ibb.co/Z6GktJgP  
    • kreis
      L2DragonLnads Custom High Five

      By kreis · Posted

      Hello and welcome Server started 2026-01-05 Web site: https://l2dragonlands.eu Discrod: https://discord.gg/ngQUY8FB8G Rates >Xp x500 >Sp x500 >Drop x25 >Spoil x25 Enchant rates: Safe/max enchant +500  Blessed and simple scrolls max enchant (+200)  Enchant maneger to make +500.  In server items are progresed in tiers. Weapons: Starter > Vesper > Vorpal > Elegia > Ferrum. Armors: Starter > Moirai > Vesper > Vesper Noble > Vorpal > Elegia > Scarlet. Jewels: Starter > Vesper > Vorpal > Elegia > Ferrum. Cloaks: Pearl White > Pitch Black > Frintezza > Class Cloka > Hero > Scarlet. Acessories: Goblin Circlet 1/2lvl > Half Mask Mage 1/2lvl > Half Mask Fighter 1/2lvl > Flame of valakas > Gem Mask > Ferrum Helmet. Belt: Mithril Belt > Vitality Belt. Badges: For fighter and mage from 1lvl to 6lvl upgraded in order. Bracelets: Mithril > Shiny Fighter/Mage > 1/2lvl custom talismans in bracelest. Agathion: 7 tiers upgrade in order eatch one. Clan item shop/ New weapon Spadona upgradeble from 1lvl till 85lvl. Farm zones in order: >Giran Harbor > WasteLand > Gateway > Valley of Saints > Chromatic > Ruins of Despair > Soul Harbor > Dragon Valley. >LvL up zone >PvP zone Custom instance zone. Custom buff maneger it will grand big boost in stats. Lotery maneger to gamble. Extra features ALT+B: >Events  >Rankings  >Clan  >RB Status  >Updates and other Auto Event system: >Team VS Team event - Auto event  >Capture The Flag - Auto event Olympiad: >Retail olympiad game  >Competition period [2] week  >Olympiad start time [18:00] end [00:00]  >Maximum enchant in the Olympiad is +10, not custom items in olympiada only normal ones from shop.
    • protoftw
      Graphic/Html Designs - Protojah

      By protoftw · Posted

      L2 VOID - ADVERTISING BANNER   L2 FURY - ANIMATED BANNER   L2 HEROIC - ANIMATED BANNER   L2 WEED - ANIMATED BANNER   L2 REFORGE - ANIMATED LOGO   L2 WARZONE - ANIMATED LOGO   L2 ACME - SPLASH SCREEN   L2 DRUGS - ANIMATED BANNER   L2 GOLD - ADVERTISING BANNER   L2 AARON - ADVERTISING BANNER  

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

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