[RELEASE] PHP DropFinder V3

[Trayne01]

Hello everyone,
I made a modernized version of .

You will be able to list mobs who are dropping the wished item. The goal is to avoid to update your droplist webpage on your website at each time you change a single drop.
Now? All you have to do is make an iframe to this script.

So wich are the new features?

• 100% ODBC made, no need special php drivers
• New modern design
• Added automatic item selection (no need to type item name)
• Decent anti-injection security (using odbc_prepare, you can now use this script on your public website)
• Mob ele icons, mob map
• EP4, EP5 & EP6 map display

Here is a screenshoot:


Credits:

• GM.Triest who gave me the idea of mob ele
• Lube for replying my questions (the team is definitely a very great idea)
• 
• 

Online Demo:
Here:

How to setup:

Run the DropFinder.sql file (no needed if you were using my old release)
Put the php files on your webserver, and don't forget to edit odbcConnect.php with your db id & password


Changelog:
V3.0: initial v3 release



Download:

[THEXxmateo]

Great work!

i have a problem!

[Trayne01]

Hello THEXxmateo,
Did you edited the inc/odbcConnect.php file with your right sql server IDs ?

[THEXxmateo]

Originally Posted by Trayne01

Hello THEXxmateo,
Did you edited the inc/odbcConnect.php file with your right sql server IDs ?

Hi!
Yes:

 Spoiler

$sqlUser = "Shaiya";
$sqlPass = "Shaiya123";
$sqlHost = "127.0.0.1";

[Trayne01]

Which version of SQL Server are you using?

If you are using an old version, then please try to replace

odbcConnect.php on line 18

PHP Code:

$odb_conn = odbc_connect("Driver={SQL Server Native Client 11.0};Server=$sqlHost;Database=$databaseg;", $sqlUser, $sqlPass); 


to this:

PHP Code:

$odb_conn = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$sqlHost;Database=$databaseg;", $sqlUser, $sqlPass); 


[THEXxmateo]

Originally Posted by Trayne01

Which version of SQL Server are you using?

If you are using an old version, then please try to replace

odbcConnect.php on line 18

PHP Code:

$odb_conn = odbc_connect("Driver={SQL Server Native Client 11.0};Server=$sqlHost;Database=$databaseg;", $sqlUser, $sqlPass); 


to this:

PHP Code:

$odb_conn = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$sqlHost;Database=$databaseg;", $sqlUser, $sqlPass); 


Thanks, it worked me!

I get this error when testing



I think I'll upgrade to the latest SQL Server xD

[Trayne01]

Try to run this:

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 ItemID = 1001) ORDER BY dbo.MobItems.DropRate DESC

In SQL, then we'll see if your SQL version is a problem, or not

[THEXxmateo]

Originally Posted by Trayne01

Try to run this:

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 ItemID = 1001) ORDER BY dbo.MobItems.DropRate DESC

In SQL, then we'll see if your SQL version is a problem, or not

Result:

 Spoiler

MobID MobName HP Level Attrib DropRate ItemOrder MapName
100 野生山羊 114 1 0 10 2 Raigo
2008 小盗贼猴 114 1 0 10 2 Light map1
2009 盗贼猴 150 2 0 10 2 Light map1
2010 树影猴 150 2 0 10 2 Light map1
2011 狐狸 150 2 0 10 2 Light map1
2012 杂毛山羊 186 3 4 10 2 Light map1
2013 风之丛林山羊 186 3 2 10 2 Light map1
2014 钝牙豺狼 186 3 4 10 2 Light map1
2015 野猪 226 4 0 10 2 Light map1
2016 风之丛林野猪 226 4 4 10 2 Light map1

[sominus]

Small suggestions:

• Your select "Var1" field, fills up with almost all valid items in the DB, so you could end with hundreds of names there. May be it was better just to type the partial item name.
• You could add ' AND Grade > 0' to avoid items that doesn't have a drop.
• You could round the mob HP (remove the decimals) for a better look.

[NoMercyless]

I was testing it in my local machine, i ran your script, tried it on browser, works fine and its a great release, but once i edited my monster.sdata and ran it on SQL it pops up some errors saying the supplied files doesnt match tables definitions and deletes all mobs on database, any tip on what to use or something would be handy.

[Trayne01]

You have to drop & create the table without the MapID column, then you can run the monster.sql file that ShStudio will give you. Re-Run the dropfinder.sql to bring back map id column and their values

[NoMercyless]

Originally Posted by Trayne01

You have to drop & create the table without the MapID column, then you can run the monster.sql file that ShStudio will give you. Re-Run the dropfinder.sql to bring back map id column and their values

Would be a good idea to add it into your tread information to avoid future questions like this type ^^

Thanks for the answer.

[[ADM]_Dephisio]

Or Ctrl+F and then replace ) into ,0)

[ASTARHOT]

excuse me someone could help me with this?
I am using sql 2014

[BodySalvage]

line 55, change the query for SQL to this....

 Spoiler

SELECT m.MobID, m.MobName, m.HP, m.Level, m.Attrib, mi.DropRate, mi.ItemOrder,mn.MapName FROM PS_GameDefs.dbo.MobItems AS mi INNER JOIN PS_GameDefs.dbo.Mobs AS m ON m.MobID = mi.MobID JOIN PS_GameDefs.dbo.MapNames AS mn ON m.MapID = mn.MapID WHERE mi.Grade = (SELECT TOP 1 Grade FROM PS_GameDefs.dbo.Items WHERE ItemID = ?) ORDER BY mi.DropRate DESC

When using SQL in php its best to use the 3 part Database.schema.Table setup to avoid possible errors such as this.