} $item = $mtg->format($db->fetch_single()); return $link == true ? '<a href="items.php?action=info&ID=' . $id . '">' . $item . '</a>' : $item; } public function listAll($ddname = 'item', $selected = null, $notIn = [], $pure = '') { global $db, $mtg; $first = $selected == null ? 0 : 1; $ret = '<select name="' . $ddname . '"' . ($pure ? ' class="' . $pure . '"' : '') . '><option value="0"' . ($selected == null ? ' selected="selected"' : '') . '>--- Select ---</option>'; $first = 1; $extra = ''; if (count($notIn)) { $extra .= ' WHERE `id` NOT IN(' . implode(',', $notIn) . ') '; } $db->query('SELECT `id`, `name` FROM `items` ' . $extra . ' ORDER BY `name` ASC'); $db->execute(); $rows = $db->fetch_row(); foreach ($rows as $row) { $ret .= "\n" . '<option value="' . $row['id'] . '"'; if ($selected == $row['id'] || !$first || isset($_POST[$ddname]) && $_POST[$ddname] == $row['id']) { $ret .= ' selected="selected"'; $first = 1; } $ret .= '>' . $mtg->format($row['name']) . ' [' . $mtg->format($row['id']) . ']</option>'; } $ret .= "\n" . '</select>'; return $ret; } } $items = items::getInstance();