[PHP] Search for items

[V3ct0r 2,117]

 

With this PHP script you can search for different items in characters bag, temporary bag and bank.

 

Requirements:

1. PHP 7.0+;
2. PDO support;
3. sqlsrv driver for PDO.

 

How to install and use:

1) Put the script to your web server working folder, usually it named htdocs.

2) Open index.php and configure it;

 

First of all, fill the data to connect to the MSSQL server:

// MSSQL Settings
$db_host = '';
$db_user = '';
$db_pass = '';
$db_name = 'GameDB';

Then enter the access key. It is needed to access the script from the web browser.

// Secret key
$access_key = 'E10ADC3949BA59ABBE56E057F20F883E';

Fill the list of items you need to search for:

// List of items to search for
// ID, Name, Icon
$items = array(
	// new Item(Item_ID, 'Item_Name', 'Item_Icon'),
	new Item(1,    'Short sword',    'w0001'),
	new Item(2,    'Long sword',     'w0002'),
	new Item(863,  'Gem of Rage',    'n1182'),
	new Item(855,  'Fairy Coin',     'n1482'),
	new Item(1847, 'Apple',          'n0275')
);

That's all!

 

3) Run the script in the your web browser and you will see the results of the search.

http://localhost/search_items/index.php

 

The script is based on the PHP class for working with inventory from user Matt from forum serverdev.net. Icons of items are included. Do not use on a production server for security reasons.

 

Download

 

On 6/8/2018 at 11:26 PM, SoundX said:

to avoid `count()` compatibility issue if someone uses PHP 7.2:

 

In `class.inventory.php`, line 21:

$itemAttrCount = count((array)$item);

 

[SoundX 14]

Thank you, very useful.

 

Also to avoid `count()` compatibility issue if someone uses PHP 7.2:

 

In `class.inventory.php`, line 21:

$itemAttrCount = count((array)$item);

 

[Masuka00 54]

Link Down  please fix

[V3ct0r 2,117]

Hello @Masuka00,

 

Link has been fixed.

[Masuka00 54]

2 minutes ago, V3ct0r said:

Hello @Masuka00,

 

Link has been fixed.

Thanks!!