Register for your free account! | Forgot your password?

You last visited: Today at 09:54

  • Please register to post and access all features, it's quick, easy and FREE!


[RELEASE] PHP DropFinder V3

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 916
[RELEASE] PHP DropFinder V3

Hello everyone,
I made a modernized version of my old php drop finder.

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:

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:
Attached Files
File Type: rar DropFinderV3.rar (358.0 KB, 416 views)



Trayne01 is offline  
Thanks
10 Users
Old 07/27/2016, 19:00   #2
 
elite*gold: 0
Join Date: Oct 2011
Posts: 21
Received Thanks: 4
Great work!

i have a problem!


THEXxmateo is offline  
Thanks
1 User
Old 07/27/2016, 19:14   #3
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 916
Hello THEXxmateo,
Did you edited the inc/odbcConnect.php file with your right sql server IDs ?
Trayne01 is offline  
Thanks
1 User
Old 07/27/2016, 19:17   #4
 
elite*gold: 0
Join Date: Oct 2011
Posts: 21
Received Thanks: 4
Quote:
Originally Posted by Trayne01 View Post
Hello THEXxmateo,
Did you edited the inc/odbcConnect.php file with your right sql server IDs ?
Hi!
Yes:


THEXxmateo is offline  
Thanks
1 User
Old 07/27/2016, 19:24   #5
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 916
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); 
Trayne01 is offline  
Thanks
1 User
Old 07/27/2016, 19:30   #6
 
elite*gold: 0
Join Date: Oct 2011
Posts: 21
Received Thanks: 4
Quote:
Originally Posted by Trayne01 View Post
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

http://i.imgur.com/ehw8G13.jpg

I think I'll upgrade to the latest SQL Server xD
THEXxmateo is offline  
Thanks
1 User
Old 07/27/2016, 21:05   #7
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 916
Try to run this:

Code:
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
Trayne01 is offline  
Old 07/27/2016, 22:29   #8
 
elite*gold: 0
Join Date: Oct 2011
Posts: 21
Received Thanks: 4
Quote:
Originally Posted by Trayne01 View Post
Try to run this:

Code:
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:
THEXxmateo is offline  
Old 07/28/2016, 00:23   #9
 
elite*gold: 0
Join Date: Jul 2010
Posts: 403
Received Thanks: 400
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.
sominus is offline  
Thanks
2 Users
Old 08/01/2016, 19:53   #10
 
elite*gold: 0
Join Date: Oct 2014
Posts: 79
Received Thanks: 48
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.
NoMercyless is offline  
Thanks
1 User
Old 08/01/2016, 20:22   #11
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 916
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
Trayne01 is offline  
Old 08/01/2016, 23:19   #12
 
elite*gold: 0
Join Date: Oct 2014
Posts: 79
Received Thanks: 48
Quote:
Originally Posted by Trayne01 View Post
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.
NoMercyless is offline  
Old 08/01/2016, 23:22   #13
 
elite*gold: 0
Join Date: Apr 2015
Posts: 45
Received Thanks: 19
Or Ctrl+F and then replace ) into ,0)
[ADM]_Dephisio is offline  
Thanks
1 User
Old 09/27/2016, 01:09   #14
 
elite*gold: 0
Join Date: Feb 2016
Posts: 44
Received Thanks: 13
excuse me someone could help me with this?
I am using sql 2014
Attached Images
File Type: jpg Untitled2.jpg (17.0 KB, 36 views)
ASTARHOT is offline  
Old 09/28/2016, 15:00   #15
 
elite*gold: 0
Join Date: Oct 2009
Posts: 56
Received Thanks: 478
line 55, change the query for SQL to this....


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


BodySalvage is offline  
Thanks
4 Users
Reply


Similar Threads
HELP Dropfinder
06/02/2016 - Shaiya PServer Development - 2 Replies
Hello ePvP. I downloaded this file : http://www.elitepvpers.com/forum/shaiya-pserver-guides-releases/3783514-release-php-drop-finder-who-diplay-map-name-ect.html I executed the DropFinder.sql, but when I'm using the the drop finder, its show...
[Release] Dropfinder in .NET
01/14/2016 - Shaiya PServer Guides & Releases - 0 Replies
Hello EPvP! Today i release my programm coded in .NET. It's based on Trayne01 php script, i offer this script on .NET aplication. http://img15.hostingpics.net/pics/225326Sanstitre.png Require : .NET Framework 4.0 VirusTotal Scan



All times are GMT +2. The time now is 09:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.