Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

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

    • PiratD
      Development of add-ons for the client

      By PiratD · Posted

      Good day! Due to the increasing number of questions, "Do you provide services for the client?" - I decided to answer with a separate topic. I provide services for editing/modifying the client and individual files, namely: 1. Transfer/Creation/Editing locations, geodata.   2. All kinds of work with NPCs, including transfer, animation, adding effects to them and logos.   3. Actually, Transfer/Creation/Edit any EFFECTS, including Abnormal Effects.   4. Any work with weapons, armor, accessories and everything related to it.   5. Create or edit textures, including dynamic textures.   6. Creating a Lobby Screen, Lobby Char Selection (character selection window) and Lobby Char Creation (character creation window). What I don't do: 1. Coding in any form (except for CB).   I started publishing my work recently, here - YouTube And here - RuTube If required, I respect confidentiality. Any other questions? Welcome to Telegram or PM.
    • FaTal1Ty
      [L2Off] L2 Forever

      By FaTal1Ty · Posted

      🎮https://discord.gg/yyVRtna9RB 🌎https://l2-forever.com L2 Forever was the best mid rates PvP server back in C4 and C5 and we want to give players the same experience with Interlude!   # L2-Forever * EXP: 50x * Adena: 200x * Spoil: 5x * Drops: 5x   # ENCHANTS *Safe Enchant : 3 *Max. Enchant : 20 *Normal Scroll chance : 65% *Blessed Scroll chance : 70%   # NEW PLAYERS * Start with Coupons allowing you to get free top D-grade * Start at level 20 * Main Town Giran Harbor   # BOOSTED AREA'S * Execution Grounds [ 20 - 40] * Cruma Tower [40-52] * Antharas Lair [52-61] * Antharas Heart [61-80] * Giran Harbor - Shopping Area   # END GAME FARMING AREAS * Monastery of Silence and Primeval Island customized for group farm # PLATINUM ARMORS * Platinum Armors get dropped by raids, allowing everyone to obtain a set and not only donators * Many Raids all over the L2 world drop parts of the Platinum Armors   # BUFFS * Buff duration is set at 1 hour for normal buffs (Buffs and Songs / Dances) * Town Buffers in all main towns with all available buffs Giran Harbor (GH) is the place to be for all your trades and item needs! Platinum Armors   # FOREVER ITEMS * Unique Forever weapons & armors # UNIQUE L2 FOREVER AUGMENTATION SYSTEM * We don't use retail augmentations, we use our own unique system and glows!   # OTHER CUSTOM FEATURES * Global Gatekeeper * NPC Class Changer * Auction House * Unique Augmenter * Subclass with Adena or from Cabrio * Nobless - Barakiel * Useless S weapon Special abilities like (Cheap shot) are changed
    • FaTal1Ty
      L2Forever

      By FaTal1Ty · Posted

      🎮https://discord.gg/yyVRtna9RB 🌎https://l2-forever.com L2 Forever was the best mid rates PvP server back in C4 and C5 and we want to give players the same experience with Interlude!   # L2-Forever * EXP: 50x * Adena: 200x * Spoil: 5x * Drops: 5x   # ENCHANTS *Safe Enchant : 3 *Max. Enchant : 20 *Normal Scroll chance : 65% *Blessed Scroll chance : 70%   # NEW PLAYERS * Start with Coupons allowing you to get free top D-grade * Start at level 20 * Main Town Giran Harbor   # BOOSTED AREA'S * Execution Grounds [ 20 - 40] * Cruma Tower [40-52] * Antharas Lair [52-61] * Antharas Heart [61-80] * Giran Harbor - Shopping Area   # END GAME FARMING AREAS * Monastery of Silence and Primeval Island customized for group farm # PLATINUM ARMORS * Platinum Armors get dropped by raids, allowing everyone to obtain a set and not only donators * Many Raids all over the L2 world drop parts of the Platinum Armors   # BUFFS * Buff duration is set at 1 hour for normal buffs (Buffs and Songs / Dances) * Town Buffers in all main towns with all available buffs Giran Harbor (GH) is the place to be for all your trades and item needs! Platinum Armors   # FOREVER ITEMS * Unique Forever weapons & armors # UNIQUE L2 FOREVER AUGMENTATION SYSTEM * We don't use retail augmentations, we use our own unique system and glows!   # OTHER CUSTOM FEATURES * Global Gatekeeper * NPC Class Changer * Auction House * Unique Augmenter * Subclass with Adena or from Cabrio * Nobless - Barakiel * Useless S weapon Special abilities like (Cheap shot) are changed
    • UTCHIHAmkt
      DISCORD TOKEN 1.99$ 7 YEARS AGED | FULL VERIFIED

      By UTCHIHAmkt · Posted

      DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/uthciha-services https://campsite.bio/utchihaamkt
    • 911reg
      L2 Control Hub: Revolutionizing Lineage 2 Server Management

      By 911reg · Posted

      Reminds me a lot to Warcraft III's triggers

  • Topics

×
×
  • Create New...