Exemplo n.º 1
0
        }
        $item = $mtg->format($db->fetch_single());
        return $link == true ? '<a href="items.php?action=info&amp;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();