[RELEASE] PHP DropFinder V3

[Garrett_Thief]

Good work with php 5.2.xx but with php 5.3.xx error:

 Spoiler

Warning: odbc_execute(): SQL error: [Microsoft][SQL Server Native Client 10.0]Syntax error, permission violation, or other nonspecific error, SQL state 37000 in SQLDescribeParameter in C:\WebServer\hosts\Site\public\wp-content\plugins\Drop-finder\dropfinder.php on line 61

[Garrett_Thief]

And i'm has fixed query for better syntax and faster search because subquery in T-SQL really slow shit
Original query:

My query:

Query for line 55

 Spoiler

PHP Code:

SELECT M.MobID, M.MobName, M.HP, M.Level, M.Attrib, MI.DropRate, MI.ItemOrder, MN.MapName
            FROM PS_GameDefs.dbo.MobItems MI WITH (NOLOCK)
                  JOIN PS_GameDefs.dbo.Mobs M WITH (NOLOCK) ON M.MobID = MI.MobID 
                  JOIN PS_GameDefs.dbo.MapNames MN WITH (NOLOCK) ON M.MapID = MN.MapID
                  JOIN PS_GameDefs.dbo.Items I WITH (NOLOCK) ON MI.Grade = I.Grade
        WHERE I.ItemID = ? ORDER BY MI.DropRate DESC 


[Apero]

FIXE

[[ADM]Minxii]

i have installed all as per the instructions However I have no space to type an item name what do you think i have done wrong?

[Apero]

identifiant SQL

[Nathan.]

Everything worked pretty well, when I expand the list browser page started lagging as hell, lol.

Also:
Warning: odbc_execute(): SQL error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'PS_GameDefs'., SQL state 01000 in SQLExecute in C:\xampp\htdocs\dropsfind\dropfinder.php on line 61
The wished items: [1] SP can't be dropped for now! Contact our staff if you think that it an error!

[Trayne01]

Originally Posted by Nathan.

Everything worked pretty well, when I expand the list browser page started lagging as hell, lol.

Also:
Warning: odbc_execute(): SQL error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'PS_GameDefs'., SQL state 01000 in SQLExecute in C:\xampp\htdocs\dropsfind\dropfinder.php on line 61
The wished items: [1] SP can't be dropped for now! Contact our staff if you think that it an error!

I suggest you to use the updated PDO Version instead, released in the ShCMS v2 Package, .

[Eric-Dutra16]

Originally Posted by XareL

great works !!

thanks for share

There is a button you can use to thank, you have spammed a lot of old thread unnecessarily.