Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

Need ID of Crystals D,C,B and A

pidixtoylis
 Share

Recommended Posts

pidixtoylis Iron Initiate

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 Iron Initiate

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 Iron Initiate

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 Iron Initiate

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

    • klouditem
      12-18 Months Gemini Pro Google AI One on Your Personal Gmail

      By klouditem · Posted

      ⚡ Weekend special! Upgrade your personal Google account with 5TB storage and Gemini Pro in under 60 seconds.
    • AlisaCodeDragon
      How do you sell your products? Don't sell. LUL

      By AlisaCodeDragon · Posted

      Don't cry, it's a game. If it makes you cum on your monitor, of course, enjoy it. My business has been running for years and will continue to do so. No matter what happens here, the dogs bark, the caravan moves on. Start developing game engines - post them too - after all, I create them too) Salvation:Arena (MOBA) Unreal Engine RED-TEAM REVERSECODE Аліса займається розробкою ще з часів створення денді та сеги-діти які створюють шум для мене просто діти) За ці роки роботи я бачила багато різних людей у цій сфері все що я думаю про це не плачте та насолоджуйтесь життям слава ураїне - котись на свій бразильський форум)   If you'd simply asked me in a private message on the forum to be reinstated, you'd have been unblocked without a problem. I have no enemies—it's just business. I can make any product on the market, models and effects, copyrights—complex tools—at my age, people run large companies. I'm pleased that our beloved MXC* forum will now have a lot of free products. I earn a maximum of $200-$300 a year from this industry. If that excites you, well, have fun with us.       I moderate many gaming communities, here's one of them  if I hated you, you'd be out of here in a minute, brother  so don't get carried away with your wet dreams. On the topic of free work, start doing it yourself—the forum needs good free stuff. Someone will definitely like you here and throw a flower on your grave. Besides, you're forgetting that half the forum is involved in this interface development business and for many developers, it's a good income. So, you want to make life sweeter for them all, not just for me it's actually nice that you're such a noble young man.   Besides, I usually work from behind the scenes and don't move anywhere in the market but nothing stops me from doing what others do - working from the shadows  you won't even see that I'm doing it, it's so funny.   Start doing free work. You promised to do it well and post it to communities on time. Good luck! We'll have fun, that's great!🥰   завжди приємно поспілкуватися з веселими людьми              
    • rocoder
      Lineage 2 Interface Source Code (All Chronicles & Protocols)

      By rocoder · Posted

      Complete development packages for Lineage 2 UI development, across all chronicles and an automated tool to update and patch Interface.u & Interface.xdat What I Offer Clean Sources: 100% clean, retail-based interface source code with zero unwanted custom modifications. Interface.u Update Tool: A standalone tool designed to patch, rebuild, and update Interface.u efficiently. Custom Modifications: Custom UI features and tailoring can be implemented upon request. Turnaround Time: Most major versions and protocols are ready for immediate delivery; other versions take up to 1 week. How It Works Let me know the specific chronicle or protocol version you are targeting. I will provide the tool, which is HWID-bound to your machine, for your setup. Once satisfied with the results, we finalize the deal. Pricing & Notes Both products are priced separately based on the target protocol and requirements. Package deals are negotiable if purchasing both. DM for inquiries, demos, and pricing quotes.    
    • Jericos*
      L2Gold.co - Legacy x45

      By Jericos* · Posted

      Well u need to change when sm1 press exit it keeps it in game..  
    • Litch
      How do you sell your products? Don't sell. LUL

      By Litch · Posted

      That’s just part of buying and selling; if your service didn't appeal to me at the time, there's no reason for me to force myself to buy it. After all, I regularly buy other interfaces and clients from other users mostly Russians using USDT. But *I'm* the child here, even though *you're* the incredibly arrogant one.   The payment method or the amounts were never the problem you were. But life goes on; you’d rather stay caught up in your delusions, thinking you’re the protagonist of some anime. Princess Alice 😂   I have all the interfaces for the 474/506/509/520/542/563/557. and olds too.  Some were created by me, including the ARENA P140 interface, which will soon be released for free. This includes everything you make available. It will no longer be a monopoly held by just a few people.   Including your clients with system. like  

  • 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..