Need ID of Crystals D,C,B and A

pidixtoylis · April 20, 2006

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 · April 21, 2006

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

panadolextra1 · April 21, 2006

noob Gm:)

ACiD_I3URN · June 5, 2006

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;}

?>

masterking · June 22, 2007

jajajaja

spawn123 · June 22, 2007

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.

eKoIce · June 22, 2007

jajajaja

Are you an IDIOT ?

*TOPIC LOCKED*

Member reported

Need ID of Crystals D,C,B and A

Recommended Posts

pidixtoylis

Akagi

panadolextra1

ACiD_I3URN

masterking

spawn123

eKoIce

Posts

Topics

Browse

Activity

Store