$dsp->NewContent(t('Bugtracker'), t('Hier kannst du Fehler melden, die bei der Verwendung dieses Systems auftreten, sowie Feature Wünsche äußern. Können die Admins dieser Webseite sie nicht selbst beheben, haben diese die Möglichkeit sie an das Lansuite-Team weiterzureichen.'));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('bugtracker');
$quicklink = array();
$quicklink['name'] = 'Fehler (offen)';
$quicklink['link'] = 'index.php?mod=bugtracker&order_by=&order_dir=&EntsPerPage=&search_input%5B0%5D=&search_input%5B1%5D=&search_dd_input%5B0%5D=&search_dd_input%5B1%5D=&search_dd_input%5B2%5D=&search_dd_input%5B3%5D=&search_dd_input%5B4%5D%5B%5D=0&search_dd_input%5B4%5D%5B%5D=1&search_dd_input%5B4%5D%5B%5D=2&search_dd_input%5B4%5D%5B%5D=3&search_dd_input%5B4%5D%5B%5D=5&search_dd_input%5B4%5D%5B%5D=7&search_dd_input%5B5%5D%5B%5D=2&search_dd_input%5B5%5D%5B%5D=3&search_dd_input%5B5%5D%5B%5D=4&search_dd_input%5B5%5D%5B%5D=5&suchen=Suchen';
$ms2->quicklinks[] = $quicklink;
$quicklink['name'] = 'Wünsche (offen)';
$quicklink['link'] = 'index.php?mod=bugtracker&order_by=&order_dir=&EntsPerPage=&search_input%5B0%5D=&search_input%5B1%5D=&search_dd_input%5B0%5D=&search_dd_input%5B1%5D=&search_dd_input%5B2%5D=&search_dd_input%5B3%5D=&search_dd_input%5B4%5D%5B%5D=0&search_dd_input%5B4%5D%5B%5D=1&search_dd_input%5B4%5D%5B%5D=2&search_dd_input%5B4%5D%5B%5D=3&search_dd_input%5B4%5D%5B%5D=5&search_dd_input%5B4%5D%5B%5D=7&search_dd_input%5B5%5D%5B%5D=1&suchen=Suchen';
$ms2->quicklinks[] = $quicklink;
$ms2->query['from'] = "%prefix%bugtracker AS b\n LEFT JOIN %prefix%user AS r ON b.reporter = r.userid\n LEFT JOIN %prefix%user AS a ON b.agent = a.userid\n LEFT JOIN %prefix%comments AS c ON (c.relatedto_id = b.bugid AND c.relatedto_item = 'BugEintrag')\n ";
$ms2->query['where'] = '(!private OR ' . (int) $auth['type'] . ' >= 2)';
# $ms2->query['default_order_by'] = 'FIND_IN_SET(state, \'0,7,1,2,3,4,5,6\'), date DESC';
$ms2->query['default_order_by'] = 'changedate DESC, FIND_IN_SET(state, \'0,7,1,2,3,4,5,6\'), date DESC';
$ms2->config['EntriesPerPage'] = 50;
$ms2->AddBGColor('state', $colors);
$ms2->AddTextSearchField(t('Überschrift'), array('b.caption' => 'like'));
$ms2->AddTextSearchField(t('Text'), array('b.text' => 'fulltext', 'c.text' => 'fulltext'));
$list = array('' => 'Alle');
$row = $db->qry('SELECT b.reporter, u.username FROM %prefix%bugtracker AS b LEFT JOIN %prefix%user AS u ON b.reporter = u.userid WHERE b.reporter > 0 ORDER BY u.username');
while ($res = $db->fetch_array($row)) {
$list[$res['reporter']] = $res['username'];
}
$db->free_result($row);
$ms2->AddTextSearchDropDown('Reporter', 'b.reporter', $list);
$list = array('' => 'Alle');
$row = $db->qry('SELECT module FROM %prefix%bugtracker WHERE module != "" GROUP BY module ORDER BY module');
while ($res = $db->fetch_array($row)) {
$list[$res['module']] = $res['module'];
}
$db->free_result($row);
$colors[5] = 'purple';
if ($_POST['search_input'][1] != '' or $_POST['search_input'][2] != '' or $_GET['search_input'][1] != '' or $_GET['search_input'][2] != '') {
$dsp->AddSingleRow('<b>' . t('Achtung: du hast als Suche einen Autor, bzw. Text angegeben. Die Ergebnis-Felder Antworten, sowie erster und letzter Beitrag beziehen sich daher nur noch auf Posts, in denen diese Eingaben gefunden wurden, nicht mehr auf den ganzen Thread!') . '</b>');
}
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%board_threads AS t\n LEFT JOIN %prefix%board_forums AS f ON t.fid = f.fid\n LEFT JOIN %prefix%board_posts AS p ON t.tid = p.tid\n LEFT JOIN %prefix%lastread AS r ON t.tid = r.entryid AND r.tab = 'board' AND r.userid = " . (int) $auth['userid'] . "\n LEFT JOIN %prefix%user AS u ON p.userid = u.userid\n LEFT JOIN %prefix%board_bookmark AS b ON (b.fid = t.fid OR b.tid = t.tid) AND b.userid = " . (int) $auth['userid'] . "\n ";
$ms2->query['where'] = 'f.need_type <= ' . (int) ($auth['type'] + 1 . " AND (!need_group OR need_group = {$auth['group_id']})");
if ($_GET['fid'] != '') {
$ms2->query['where'] .= ' AND t.fid = ' . (int) $_GET['fid'];
}
if ($_GET['action'] == 'bookmark') {
$ms2->query['where'] .= ' AND b.bid IS NOT NULL';
}
$ms2->query['default_order_by'] = 't.sticky DESC, LastPost DESC';
$ms2->AddBGColor('label', $colors);
#$ms2->AddBGColor('sticky', array('', 'red'));
if ($_GET['fid'] == '') {
$ms2->AddTextSearchField(t('Titel'), array('t.caption' => 'like'));
$ms2->AddTextSearchField(t('Text'), array('p.comment' => 'fulltext'));
$ms2->AddTextSearchField(t('Autor'), array('u.username' => '1337', 'u.name' => 'like', 'u.firstname' => 'like'));
$list = array();
$list[''] = t('Alle');
$res = $db->qry("SELECT fid, name FROM %prefix%board_forums");
while ($row = $db->fetch_array($res)) {
$list[$row['fid']] = $row['name'];
}
$ms2->AddTextSearchDropDown(t('Forum'), 'f.fid', $list);
$db->free_result($res);
}
$ms2->AddSelect('t.closed');
