WebCP-Full-Database/finditem.php at main · Apollo-EE/WebCP-Full-Database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
<?php
ini_set('memory_limit', '1024M');
$pagetitle = 'Item Search';

if (isset($_GET['itemid']))
{
	$checkcsrf = true;
}

$_GET['itemid'] = preg_replace("/[^0-9]/", "", $_GET['itemid'] );

$NEEDPUB = true;
require 'common.php';

if (!$GM)
{
	$tpl->message = 'You must be a Game Master to view this page.';
	$tpl->Execute(null);
	exit;
}

if (isset($_GET['itemid']) && isset($_GET['imin']) && isset($_GET['imax']))
{
	$_GET['itemid'] = (int)$_GET['itemid'];

	$allcharacters = webcp_db_fetchall("SELECT name, account, goldbank, inventory, bank, paperdoll FROM characters");

	foreach ($allcharacters as &$character)
	{
		$character['inventory'] = unserialize_inventory($character['inventory']);
		$character['bank'] = unserialize_inventory($character['bank']);
		$character['paperdoll'] = unserialize_paperdoll($character['paperdoll']);
	}
	unset($character);

	$characters = array();

	foreach ($allcharacters as $character)
	{
		$items = $character['inventory'];
		$bank = $character['bank'];
		$paperdoll = $character['paperdoll'];

		foreach ($items as $item)
		{
			if ($item['id'] == $_GET['itemid'] && $item['amount'] >= $_GET['imin']
			 && ($item['amount'] <= $_GET['imax'] || $_GET['imax'] == 0))
			{
				$character['found_inventory'] = '<b>' . $item['amount'] . 'x</b>';
				$character['found'] = 1;
				break;
			}
		}

		if ($_GET['itemid'] == 1)
		{
			if ($character['goldbank'] >= $_GET['imin']
			 && ($character['goldbank'] || $_GET['imax'] == 0))
			{
				$character['found_bank'] = '<b>' . $character['goldbank'] . 'x</b>';
				$character['found'] = 1;
			}
		}
		else
		{
			foreach ($bank as $item)
			{
				if ($item['id'] == $_GET['itemid'] && $item['amount'] >= $_GET['imin']
				 && ($item['amount'] <= $_GET['imax'] || $_GET['imax'] == 0))
				{
					$character['found_bank'] = '<b>' . $item['amount'] . 'x</b>';
					$character['found'] = 1;
					break;
				}
			}
		}

		foreach ($paperdoll as $item)
		{
			if ($item['id'] == $_GET['itemid'] && 1 >= $_GET['imin']
			 && (1 <= $_GET['imax'] || $_GET['imax'] == 0))
			{
				$character['found_paperdoll'] = '<b>' . 1 . 'x</b>';
				$character['found'] = 1;
				break;
			}
		}

		$characters[] = $character;
	}

	$tpl->characters = $characters;

	$tpl->Execute('finditem_results');
}
else
{


	$i = 1;
	$item = $eoserv_items->Get($i);

	while ($item->id)
	{
		$items[] = array(
			'name' => $item->name,
			'id' => $item->id
		);

		$item = $eoserv_items->Get(++$i);
	}

	$tpl->items = $items;
	$tpl->Execute('finditem');
}