Discussion on [RELEASE]PHP Drop Finder, who diplay Map Name ect within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.
Hello E*PvP,
I finished my PHP Script, this script allow your players to find every mobs who drop the item that they are looking for. I think some screenshoots are better than a long text, so:
In first you have to enter the item name:
And, the script will display the mobs list, and the maps where the monsters are:
You can test this script here:
But pls note that our database is still in french, we will make an english one soon, so u have to enter french item name (exemple: "Poudre Alchimique Mgique" or "Epée d'argent"), it will too display french mobs
So, how to install?
First, you have to run the SQL server script in the archive (download bellow)
If you use french Sdata, and so a french databse (french or other languages that often use ''s), i recommand u to uncoment this part:
PHP Code:
--'Uncomment this bellow if you get problems with '' 's UPDATE PS_GameDefs.dbo.Items SET ItemName = REPLACE(ItemName, '''', '_')
UPDATE PS_GameDefs.dbo.Skills SET SkillName = REPLACE(SkillName, '''', '_')
UPDATE PS_GameDefs.dbo.Mobs SET MobName = REPLACE(MobName, '''', '_')
UPDATE PS_GameDefs.dbo.ProductList SET ProductName = REPLACE(ProductName, '''', '_')
These quotes can cause some problems on ur logs
The episo 6 map ids are 102 103 104, you can change it if you want, it's at the end of the sql file, but don't forget to edit the dbo.MapNames table too
So, next, simply put both php file in your web server
don't dorget to edit the db file:
PHP Code:
$host='151.80.XXX.XXX'; // <-- IP Adresse of the server where your DB is hosted $user='Shaiya'; // <-- Your DB UserName $pass='Shaiya123'; // <-- Your DB Password
Credits/thanks to:
Changelog:
-- v1
* Initial Release
-- v2
* Adding Armor and Wepeon support
* Now displaying Map Name
-- v3 (work under progress, thanks to )
* Fixed security issues
* Better search engine
I'm open for any suggestions
Thank you for this release!
I edited the code a little bit so that it shows the HP, Mob Level, Mob Ele and it shows the drops in order by drop rate.
Code:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Drop Finder</title>
</head>
<body>
<center>
<?
function str_replace_assoc(array $replace, $subject) {
return str_replace(array_keys($replace), array_values($replace), $subject);
}
header('Content-Type: text/html; charset=UTF-8');
include ('db.php');
//include ('query.php');
Echo ('Return to <a href="form.php">form</a><br/><br/>');
//Par Marc Faussurier, Copie interdite
if (isset($_POST['Var1']))://Champs obligatoires
{
$DisplayItemName=$_POST['Var1'];
$replace = array(
"'" => "_",
"é" => "e",
"è" => "e",
"ê" => "e",
"î" => "i",
//"ï" => "i",
"à" => "a",
"û" => "u",
"ô" => "o"
);
//$newstr = utf8_encode(str_replace_assoc($replace,$_POST['Var1']));
$newstr = str_replace_assoc($replace,$_POST['Var1']);
$ItemName=$newstr; //On déclare les variables et on double les appostrophe pour éviter les confilts SQL Srv
$CheckItemNumber="SELECT Grade from dbo.Items WHERE ItemName like '$ItemName'";
$retour=odbc_exec($conn,$CheckItemNumber);
if (odbc_num_rows($retour)==0)
{
echo ("The desired item ($newstr or $ItemName) is not present in our databases, please check the spelling and try again");
}
else
{
$MobID="USE PS_GameDefs
SELECT dbo.Mobs.MobID, dbo.Mobs.MobName, dbo.Mobs.HP, dbo.Mobs.Level, dbo.Mobs.Attrib, dbo.MobItems.DropRate, dbo.MobItems.ItemOrder, dbo.MapNames.MapName
FROM dbo.MobItems
INNER JOIN Mobs ON dbo.Mobs.MobID = dbo.MobItems.MobID
JOIN MapNames ON dbo.Mobs.MapID = dbo.MapNames.MapID
WHERE Grade = (SELECT TOP 1 Grade FROM PS_GameDefs.dbo.Items WHERE ItemName like '$ItemName') ORDER BY dbo.MobItems.DropRate DESC";
$ele = array(0 => 'None', 1 => 'Fire', 2=> 'Water', 3=> 'Earth', 4=> 'Wind');
//La requête SQL qui va trouver les drop et assosier les ID des monstres à leurs noms
$res12=odbc_exec($conn,$MobID);//On lance la requête
//while( $row = odbc_fetch_array($res12) ) {
// print_r($row);
//print_r('<br/>');
if (odbc_num_rows($res12)!=0)
{
echo "<center>List of Monster: $DisplayItemName
<table cellspacing=1 cellpadding=2 border=1 style=\"border-style:hidden;\">
<tr>
<th>Name Monster</th>
<th>Mob HP</th>
<th>Mob Level</th>
<th>Mob Ele</th>
<th>Drop Percentage Rate</th>
<th>Map Name</th>
</tr>";
if (odbc_num_rows($res12)>0)
{
odbc_fetch_array($res12);
echo "<tr>";
echo "<td>";
echo utf8_encode($row['MobName']);//On encode en utf-8 le résultat au format donné par SQL Server
echo "</td>";
echo "<td>";
echo $nombre_format_francais = number_format($row['HP'], 2, '.', ',');
echo "</td>";
echo "<td>";
echo ($row['Level']);
echo "</td>";
echo "<td>";
echo ($ele[$row['Attrib']]);
echo "</td>";
echo "<td>";
$DropRate=$row['DropRate'];
if ($row['ItemOrder'] > 4)//On vérifie si l'ItemOrder est plus grand que 4
{
$DropRate=($DropRate/100000);//Car si il est plus, grand, c'est plus en pourcentage mais en millions qu'on exprime le resultat, on le converti donc.
}
if ($DropRate > 100)
{
$DropRate=100;
}
echo (($DropRate)." %");
echo "</td>";
echo "<td>";
echo ($row['MapName']);
echo "</td>";
echo "</tr>";
echo "</table></center>";
}
else {
while($row = odbc_fetch_array($res12))
{
echo "<tr>";
echo "<td><center>";
echo utf8_encode($row['MobName']);//On encode en utf-8 le résultat au format donné par SQL Server
echo "</center></td>";
echo "<td><center>";
echo $nombre_format_francais = number_format($row['HP'], 2, '.', ',');
echo "</center></td>";
echo "<td><center>";
echo ($row['Level']);
echo "</center></td>";
echo "<td>";
echo ($ele[$row['Attrib']]);
echo "</td>";
echo "<td><center>";
$DropRate=$row['DropRate'];
if ($row['ItemOrder'] > 4)//On vérifie si l'ItemOrder est plus grand que 4
{
$DropRate=($DropRate/100000);//Car si il est plus, grand, c'est plus en pourcentage mais en millions qu'on exprime le resultat, on le converti donc.
}
if ($DropRate > 100)
{
$DropRate=100;
}
echo (($DropRate)." %");
echo "</center></td>";
echo "<td><center>";
echo ($row['MapName']);
echo "</center></td>";
echo "</tr>";
}
echo "</table></center>";
}
}
else
{
$var1=$_POST['Var1'];
echo("There's currently no mobs/bosses droping '$var1'.");
}
//}
}
}
Elseif($_POST['Var1']==0): //Champs obligatoires non remplis
{
echo("Thank you for filling in the required fields.");
}
endif;
?>
<center>
</body>
</html>
i can use this to find item drop rate for europe server?i think no but anyone can extract from client item list drop from official shaiya europe ep 7?because i need to see the drop rate of items... i don't know if its possible....
i can use this to find item drop rate for europe server?i think no but anyone can extract from client item list drop from official shaiya europe ep 7?because i need to see the drop rate of items... i don't know if its possible....
This displays what is on database, unless you setup a local server with the same files of it.
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\dropfinderUS\proc.php:9) in C:\xampp\htdocs\dropfinderUS\proc.php on line 13
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\dropfinderUS\proc.php:9) in C:\xampp\htdocs\dropfinderUS\db.php on line 9
Return to form
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Items'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\dropfinderUS\proc.php on line 40
Warning: odbc_num_rows(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\dropfinderUS\proc.php on line 41
The desired object (Apple ou Apple) is not present in our databases, thank you to check the spelling and try again
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\dropfinderUS\proc.php:9) in C:\xampp\htdocs\dropfinderUS\proc.php on line 13
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\dropfinderUS\proc.php:9) in C:\xampp\htdocs\dropfinderUS\db.php on line 9
Return to form
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.Items'., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\dropfinderUS\proc.php on line 40
Warning: odbc_num_rows(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\dropfinderUS\proc.php on line 41
The desired object (Apple ou Apple) is not present in our databases, thank you to check the spelling and try again
Put '@' before session_start or idk on line 13. Try to replace dbo.Items by PS_GameDefs.dbo.Items
If you still have issues , you should take the updated DrpFinder from here :
[Release]Address Finder {low ===> Pro} 02/10/2015 - S4 League Hacks, Bots, Cheats & Exploits - 34 Replies http://i.epvpimg.com/WnxKd.png
Program ss(3):
http://i.epvpimg.com/YuhNc.jpg
http://i.epvpimg.com/hZRug.png
http://i.epvpimg.com/jhsic.png
How to?
1*Run "Address Finder.exe".
2* Wait....
Release Drop personnaliser / Drop Release customize 03/30/2012 - Rappelz Private Server - 5 Replies Bonjour, avec ces scripts vous pourrez modifier vos objet, que vous voulez: droper, sur presque tout les types de monstres.
Hello, with these scripts you can modify your object, you want: droper, on almost all types of monsters
Realase Drop personalize.rar
Crédit Ncarbon / egurgle
[Release] S4 League Dmg Finder 11/25/2009 - S4 League Hacks, Bots, Cheats & Exploits - 22 Replies http://www.badassbadges.co.uk/images/i-love/cock-3 8mm.jpg
![[RELEASE]PHP Drop Finder, who diplay Map Name ect](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-guides-releases/release-php-drop-finder-who-diplay-map-name-ect_ltr.gif){kind=small}
![[GM]Zeroo's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar6850362_1.gif){kind=avatar}
