foreach ($_POST['action'] as $key => $val) {
$tx_status = $db->qry_first("SELECT fromUserID, tx_deleted FROM %prefix%mail_messages WHERE mailID = %int%", $key);
// Ist eMail vom Sender gelöscht? JA: Lösche aus DB, NEIN: Setze rx flag
if ($tx_status['tx_deleted'] == 1 or $tx_status['fromUserID'] == 0) {
$db->qry("DELETE FROM %prefix%mail_messages WHERE mailID = %int%", $key);
} else {
$db->qry("UPDATE %prefix%mail_messages SET rx_deleted = 1 WHERE mailID = %int%", $key);
}
}
break;
}
}
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%mail_messages AS m LEFT JOIN %prefix%user AS u ON m.FromUserID = u.userid";
$ms2->query['where'] = "m.toUserID = '{$auth['userid']}' AND m.mail_status = 'delete' AND rx_deleted = 0";
$ms2->query['default_order_by'] = 'm.tx_date';
$ms2->query['default_order_dir'] = 'DESC';
$ms2->config['EntriesPerPage'] = 30;
$ms2->AddTextSearchField('Mail', array('m.subject' => 'fulltext', 'm.msgbody' => 'fulltext'));
$ms2->AddTextSearchField(t('Nachricht von'), array('u.userid' => 'exact', 'u.username' => '1337', 'u.name' => 'like', 'u.firstname' => 'like'));
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Betreff'), 'm.subject', '', 160);
$ms2->AddResultField(t('Nachricht von'), 'u.username', 'UserNameAndIcon', '', 100);
$ms2->AddResultField('Status', 'm.des_status', 'MailStatus', '', 80);
$ms2->AddResultField(t('Gesendet'), 'UNIX_TIMESTAMP(m.tx_date) AS tx_date', 'MS2GetDate', '', 70);
$ms2->AddResultField(t('Gelesen'), 'UNIX_TIMESTAMP(m.rx_date) AS rx_date', 'MS2GetDate', '', 60);
$ms2->AddIconField('details', 'index.php?mod=mail&action=showmail&ref=trash&mailID=', t('Details'));
$ms2->AddIconField('delete', 'index.php?mod=mail&action=trashcan&step=20&mailid=', t('Entgültig löschen'), '', 10);
$ms2->AddMultiSelectAction(t('Entgültig löschen'), 'index.php?mod=mail&action=trashcan&step=20', 1, 'delete');
$ms2->PrintSearch('index.php?mod=mail&action=trash', 'm.mailid');
$ms2->AddTextSearchDropDown(t('Benutzer'), 'a.userid', $list);
$list = array('' => t('Alle'));
$res = $db->qry('SELECT ip FROM %prefix%stats_auth GROUP BY ip ORDER BY ip');
while ($row = $db->fetch_array($res)) {
if ($row['ip']) {
$list[$row['ip']] = $row['ip'];
}
}
$db->free_result($res);
$ms2->AddTextSearchDropDown(t('IP'), 'a.ip', $list);
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Session-ID'), 'a.sessid');
$ms2->AddResultField(t('Benutzername'), 'u.username', 'UserNameAndIcon');
$ms2->AddResultField(t('IP'), 'a.ip');
#$ms2->AddResultField(t('Login?'), 'a.login');
$ms2->AddResultField(t('Hits'), 'a.hits');
$ms2->AddResultField(t('Visits'), 'a.visits');
#$ms2->AddResultField(t('Letzter Aufruf'), 'a.logtime', 'MS2GetDate');
$ms2->AddResultField(t('Eingeloggt'), 'a.logintime', 'MS2GetDate');
$ms2->AddResultField(t('Letzter Aufruf'), 'a.lasthit', 'MS2GetDate');
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Session beenden'), "index.php?mod=install&action=sessions&step=10", 1);
}
$ms2->PrintSearch('index.php?mod=install&action=sessions', 'a.sessid');
break;
case 10:
include_once 'inc/classes/class_masterdelete.php';
$md = new masterdelete();
$md->MultiDelete('stats_auth', 'sessid');
break;
}
$ms2->AddResultField('Titel', 'p.caption');
//$ms2->AddResultField('Option', 'o.caption');
$ms2->AddResultField('Einheit', 'o.unit');
$ms2->AddResultField('Anzahl', 'a.pice');
$ms2->AddResultField('Lieferant', 's.name');
$ms2->AddResultField('Besteller', 'u.username', 'UserNameAndIcon');
$ms2->AddResultField('Bestellt', 'a.ordertime', 'MS2GetDate');
$ms2->AddResultField('Geliefert', 'a.supplytime', 'MS2GetDate');
$ms2->AddIconField('details', 'index.php?mod=foodcenter&action=statchange&step=2&id=', t('Details'));
$fc_ordered_status_quest[0] = t('Status ändern: Abgeholt');
$fc_ordered_status_quest[1] = t('Status ändern: Abholbereit');
$fc_ordered_status_quest[2] = t('Status ändern: Lieferung erwartet');
$fc_ordered_status_quest[3] = t('Status ändern: An Platz geliefert');
$fc_ordered_status_quest[4] = t('Produkt abbestellen und Geld zurücküberweisen.');
$fc_ordered_status_quest[5] = t('Zurück');
$ms2->AddMultiSelectAction($fc_ordered_status_quest[0], 'index.php?mod=foodcenter&action=statchange&step=2&status=6', 1);
$ms2->AddMultiSelectAction($fc_ordered_status_quest[1], 'index.php?mod=foodcenter&action=statchange&step=2&status=5', 1);
$ms2->AddMultiSelectAction($fc_ordered_status_quest[2], 'index.php?mod=foodcenter&action=statchange&step=2&status=3', 1);
$ms2->AddMultiSelectAction($fc_ordered_status_quest[3], 'index.php?mod=foodcenter&action=statchange&step=2&status=7', 1);
$ms2->AddMultiSelectAction($fc_ordered_status_quest[4], 'index.php?mod=foodcenter&action=statchange&step=2&status=8', 1);
switch ($_POST['search_dd_input'][0]) {
case 1:
$dsp->NewContent(t('Bestellte Produkte'), '');
$ms2->NoItemsText = t('Keine aktuellen Bestellungen vorhanden.');
break;
case 2:
$dsp->NewContent(t('Produkte die bestellt werden'), '');
$ms2->NoItemsText = t('Es müssen keine Produkte bestellt werden.');
break;
case 3:
$dsp->NewContent(t('Diese Produkte wurden bestellt. Auf die Lieferung wird gewartet.'), '');
$ms2->AddResultField(t('Reporter'), 'r.username AS reporter', 'UserNameAndIcon');
$ms2->AddResultField(t('Bearbeiter'), 'a.username AS agent');
$ms2->AddResultField(t('Antw.'), 'COUNT(c.relatedto_id) AS comments');
$ms2->AddResultField(t('Datum'), 'UNIX_TIMESTAMP(b.date) AS date', 'MS2GetDate');
$ms2->AddResultField(t('Letzte Änderung'), 'UNIX_TIMESTAMP(b.changedate) AS changedate', 'MS2GetDate');
$ms2->SetTargetPage('comments', 20);
$ms2->AddIconField('details', 'index.php?mod=bugtracker&bugid=%id%&ms_page=%page%', t('Details'));
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=bugtracker&action=add&bugid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=bugtracker&action=delete&bugid=', t('Löschen'));
}
if ($auth['type'] >= 2) {
foreach ($bugtracker->stati as $key => $val) {
$ms2->AddMultiSelectAction(t('Status') . ' -> ' . $val, 'index.php?mod=bugtracker&state=' . $key);
}
$ms2->AddMultiSelectAction(t('Bearbeiter löschen'), 'index.php?mod=bugtracker&userid=0');
$res = $db->qry("SELECT userid, username FROM %prefix%user WHERE type >= 2");
while ($row = $db->fetch_array($res)) {
$ms2->AddMultiSelectAction(t('Bearbeiter') . ' -> ' . $row['username'], 'index.php?mod=bugtracker&userid=' . $row['userid']);
}
$db->free_result($res);
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=bugtracker&action=delete');
} elseif ($auth['login']) {
$ms2->AddMultiSelectAction(t('Status') . ' -> ' . $bugtracker->stati[1], 'index.php?mod=bugtracker&state=1');
$ms2->AddMultiSelectAction(t('Status') . ' -> ' . $bugtracker->stati[2], 'index.php?mod=bugtracker&state=2');
$ms2->AddMultiSelectAction(t('Status') . ' -> ' . $bugtracker->stati[7], 'index.php?mod=bugtracker&state=7');
}
$ms2->PrintSearch('index.php?mod=bugtracker', 'b.bugid');
// Details page
$ms2->AddTextSearchDropDown(t('Mitglieder'), 'COUNT(u.clanid)', array('' => t('Alle'), '0' => t('Ohne Mitglieder'), '>1' => t('Mit Mitglieder')));
$ms2->AddResultField(t('Clanname'), 'c.name');
$ms2->AddResultField(t('Webseite'), 'c.url', 'link_to_clan');
$ms2->AddResultField(t('Mitglieder'), 'COUNT(u.clanid) AS members');
$ms2->AddIconField('details', 'index.php?mod=clanmgr&step=2&clanid=', t('Clan-Details'));
if ($auth['type'] >= 2) {
$ms2->AddIconField('change_pw', 'index.php?mod=clanmgr&step=10&clanid=', t('Passwort ändern'));
}
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=clanmgr&step=30&clanid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=clanmgr&step=20&clanid=', t('Löschen'));
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=clanmgr&step=20', 1);
}
$ms2->PrintSearch('index.php?mod=clanmgr', 'c.clanid');
if ($auth['type'] >= 1) {
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=clanmgr&step=30'));
}
break;
// Details
// Details
case 2:
$row = $db->qry_first('SELECT name, url, clanlogo_path FROM %prefix%clan WHERE clanid = %int%', $_GET['clanid']);
if (func::chk_img_path($row['clanlogo_path'])) {
$dsp->AddDoubleRow(t(''), '<img src="' . $row['clanlogo_path'] . '" alt="' . $row['name'] . '">');
}
$dsp->AddDoubleRow(t('Clan'), $row['name']);
if (stristr($row['url'], 'http://') === FALSE) {
}
$mail_new_total = $db->qry_first("SELECT count(*) as n FROM %prefix%mail_messages WHERE ToUserID = %int% AND mail_status = 'active' AND des_status = 'new'", $auth['userid']);
$mail_total = $db->qry_first("SELECT count(*) as n FROM %prefix%mail_messages WHERE ToUserID = %int% AND mail_status = 'active'", $auth['userid']);
$dsp->NewContent(t('Posteingang'), t('Du hast <b>%1</b> Mail(s) empfangen. Davon sind <b>%2</b> ungelesen.', array($mail_total['n'], $mail_new_total['n'])));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%mail_messages AS m LEFT JOIN %prefix%user AS u ON m.FromUserID = u.userid";
$ms2->query['where'] = "m.toUserID = '{$auth['userid']}' AND m.mail_status = 'active'";
$ms2->query['default_order_by'] = 'm.tx_date';
$ms2->query['default_order_dir'] = 'DESC';
$ms2->AddBGColor('label', $colors);
$ms2->config['EntriesPerPage'] = 20;
$ms2->AddTextSearchField('Mail', array('m.subject' => 'fulltext', 'm.msgbody' => 'fulltext'));
$ms2->AddTextSearchField(t('Nachricht von'), array('u.userid' => 'exact', 'u.username' => '1337', 'u.name' => 'like', 'u.firstname' => 'like'));
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Betreff'), 'm.subject', '', 160);
$ms2->AddResultField(t('Nachricht von'), 'u.username', 'UserNameAndIcon', '', 100);
$ms2->AddResultField('Status', 'm.des_status', 'MailStatus', '', 80);
$ms2->AddResultField(t('Gesendet'), 'UNIX_TIMESTAMP(m.tx_date) AS tx_date', 'MS2GetDate', '', 70);
$ms2->AddResultField(t('Gelesen'), 'UNIX_TIMESTAMP(m.rx_date) AS rx_date', 'MS2GetDate', '', 20);
$ms2->AddIconField('details', 'index.php?mod=mail&action=showmail&ref=in&mailID=', t('Details'), '', 10);
$ms2->AddIconField('delete', 'index.php?mod=mail&action=inbox&step=20&mailid=', t('Löschen'), '', 10);
$ms2->AddMultiSelectAction(t('Markierung entfernen'), 'index.php?mod=mail&step=10', 0);
$ms2->AddMultiSelectAction(t('Markieren: Rot'), 'index.php?mod=mail&step=11', 0);
$ms2->AddMultiSelectAction(t('Markieren: Blau'), 'index.php?mod=mail&step=12', 0);
$ms2->AddMultiSelectAction(t('Markieren: Grün'), 'index.php?mod=mail&step=13', 0);
$ms2->AddMultiSelectAction(t('Markieren: Gelb'), 'index.php?mod=mail&step=14', 0);
$ms2->AddMultiSelectAction(t('Markieren: Lila'), 'index.php?mod=mail&step=15', 0);
$ms2->AddMultiSelectAction(t('In den Papierkorb'), 'index.php?mod=mail&step=20', 1, 'delete');
$ms2->PrintSearch('index.php?mod=mail', 'm.mailid');
}
<?php
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=guestbook&action=add') . HTML_NEWLINE);
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%guestbook AS g";
$ms2->query['default_order_by'] = 'g.date';
$ms2->query['default_order_dir'] = 'DESC';
$ms2->config['EntriesPerPage'] = 50;
$ms2->AddSelect('g.userid');
$ms2->AddResultField(t('Autor'), 'g.poster', 'UserNameAndIcon');
$ms2->AddResultField(t('Eintrag'), 'g.text', 'Text2LSCode');
$ms2->AddResultField(t('Datum'), 'g.date', 'MS2GetDate');
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=guestbook&action=add&guestbookid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=guestbook&action=delete&guestbookid=', 1);
}
$ms2->PrintSearch('index.php?mod=guestbook', 'g.guestbookid');
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=guestbook&action=add'));
$dsp->AddContent();
if ($_GET['action'] == 'bookmark') {
$ms2->AddResultField(t('E-Mail'), 'b.email', 'TrueFalse');
$ms2->AddResultField(t('System-Mail'), 'b.sysemail', 'TrueFalse');
}
$ms2->AddIconField('details', 'index.php?mod=board&action=thread&tid=', t('Details'));
if ($_GET['action'] != 'bookmark') {
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=board&action=forum&step=10&fid=' . $_GET['fid'] . '&tid=', t('Überschrift editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=board&action=delete&step=11&tid=', t('Löschen'));
}
if ($auth['type'] >= 2) {
$res = $db->qry("SELECT fid, name FROM %prefix%board_forums");
while ($row = $db->fetch_array($res)) {
$ms2->AddMultiSelectAction(t('Verschieben nach ') . $row['name'], 'index.php?mod=board&action=forum&step=20&to_fid=' . $row['fid'] . '&fid=' . $_GET['fid'], 1, 'in');
}
$db->free_result($res);
$ms2->AddMultiSelectAction(t('Markierung entfernen'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=40', 0, 'selection_none');
$ms2->AddMultiSelectAction(t('Markieren: Rot'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=41', 0, 'selection_all');
$ms2->AddMultiSelectAction(t('Markieren: Blau'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=42', 0, 'selection_all');
$ms2->AddMultiSelectAction(t('Markieren: Grün'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=43', 0, 'selection_all');
$ms2->AddMultiSelectAction(t('Markieren: Gelb'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=44', 0, 'selection_all');
$ms2->AddMultiSelectAction(t('Markieren: Lila'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=45', 0, 'selection_all');
$ms2->AddMultiSelectAction(t('Als Top Thread setzen'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=50', 0, 'important');
$ms2->AddMultiSelectAction(t('Top Thread Marker entfernen'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=51', 0, 'del_important');
$ms2->AddMultiSelectAction(t('Schliessen'), 'index.php?mod=board&action=forum&fid=' . $_GET['fid'] . '&step=52', 1);
}
} else {
$ms2->AddIconField('delete', 'index.php?mod=board&action=bookmark&step=30&tid=', t('Löschen'));
}
$list[$res['sort_tag']] = $res['sort_tag'];
}
}
$db->free_result($row);
$ms2->AddTextSearchDropDown(t('Gruppe'), 'l.sort_tag', $list);
$ms2->AddTextSearchDropDown(t('Prioritat'), 'l.type', array('' => 'Alle', '1' => 'Niedrig', '2' => 'Normal', '3' => 'Hoch'));
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Meldung'), 'l.description', '', 140);
$ms2->AddResultField(t('IP'), 'INET_NTOA(l.ip) AS ip');
$ms2->AddResultField(t('Gruppe'), 'l.sort_tag');
$ms2->AddResultField(t('Datum'), 'UNIX_TIMESTAMP(l.date) AS date', 'MS2GetDate');
$ms2->AddResultField(t('Auslöser'), 'u.username', 'UserNameAndIcon');
$ms2->AddResultField(t('Prio.'), 'l.type');
$ms2->AddIconField('details', 'index.php?mod=install&action=log&step=2&logid=', t('Details'));
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), "index.php?mod=install&action=log&step=10", 1);
}
$ms2->PrintSearch('index.php?mod=install&action=log', 'l.logid');
break;
case 2:
$log = $db->qry_first("SELECT l.type, l.sort_tag, l.description, l.script, l.referer, l.userid, UNIX_TIMESTAMP(l.date) AS date,\n INET_NTOA(l.ip) AS ip, u.username\n FROM %prefix%log AS l\n LEFT JOIN %prefix%user AS u ON l.userid = u.userid\n WHERE l.logid = %int%\n ", $_GET['logid']);
$dsp->NewContent($log['sort_tag']);
$dsp->AddDoubleRow(t('Meldung'), $log['description']);
$dsp->AddDoubleRow(t('Zeitpunkt'), $func->unixstamp2date($log['date'], 'datetime'));
$dsp->AddDoubleRow(t('Priorität'), $log['type']);
$dsp->AddDoubleRow(t('IP'), $log['ip']);
$dsp->AddDoubleRow(t('Referer'), $log['referer']);
$dsp->AddDoubleRow(t('Script'), '<a href="' . $log['script'] . '">' . $log['script'] . '</a>');
$dsp->AddDoubleRow(t('Auslöser'), $dsp->FetchUserIcon($log['userid'], $log['username']));
$dsp->AddBackButton("index.php?mod=install&action=log", '');
$dsp->AddContent();
$ms2->AddTextSearchField(t('Clan'), array('c.name' => 'like'));
$ms2->AddResultField(t('Benutzername'), 'u.username');
if ($auth['type'] >= 2 or !$cfg['sys_internet'] or $cfg['guestlist_shownames']) {
$ms2->AddResultField(t('Vorname'), 'u.firstname');
$ms2->AddResultField(t('Nachname'), 'u.name');
}
$ms2->AddSelect('c.url AS clanurl');
$ms2->AddSelect('c.clanid AS clanid');
$ms2->AddResultField('Clan', 'c.name AS clan', 'ClanURLLink');
if ($party->party_id) {
$ms2->AddResultField(t('Bez.'), 'p.paid', 'PaidIconLink');
$ms2->AddSelect('i.price');
$ms2->AddResultField(t('Preis'), 'i.price_text', 'p_price');
if ($func->isModActive('seating')) {
$ms2->AddResultField(t('Sitz'), 'u.userid', 'SeatNameLink');
}
if (!$cfg['sys_internet']) {
$ms2->AddResultField(t('In'), 'UNIX_TIMESTAMP(p.checkin) AS checkin', 'MS2GetDate');
$ms2->AddResultField(t('Out'), 'UNIX_TIMESTAMP(p.checkout) AS checkout', 'MS2GetDate');
}
}
$ms2->AddIconField('details', 'index.php?mod=guestlist&action=details&userid=', t('Details'));
$ms2->AddIconField('send_mail', 'index.php?mod=mail&action=newmail&step=2&userID=', t('Mail senden'));
if ($auth['type'] >= 2) {
$ms2->AddMultiSelectAction(t('Auf "Bezahlt" setzen'), "index.php?mod=guestlist&step=10", 1, 'paid');
$ms2->AddMultiSelectAction(t('Auf "Nicht Bezahlt" setzen'), "index.php?mod=guestlist&step=11", 1, 'not_paid');
$ms2->AddMultiSelectAction(t('Einchecken'), "index.php?mod=guestlist&step=20", 1, 'in');
$ms2->AddMultiSelectAction(t('Auschecken'), "index.php?mod=guestlist&step=21", 1, 'out');
$ms2->AddMultiSelectAction(t('Ein- und Auschecken rückgängig'), "index.php?mod=guestlist&step=22", 1, 'not_out');
}
$ms2->PrintSearch('index.php?mod=guestlist', 'u.userid');
$md = new masterdelete();
$md->MultiDelete('comments_bookmark', 'bid');
break;
}
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%comments_bookmark AS b";
$ms2->query['where'] = 'b.userid = ' . (int) $_GET['userid'];
$ms2->query['default_order_by'] = 'b.relatedto_item';
$ms2->config['EntriesPerPage'] = 20;
$ms2->AddResultField(t('Modul'), 'b.relatedto_item');
$ms2->AddResultField(t('Beitrags ID'), 'b.relatedto_id');
$ms2->AddResultField(t('Internet-Mail'), 'b.email');
$ms2->AddResultField(t('System-Mail'), 'b.sysemail');
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=usrmgr&action=details&userid=' . $_GET['userid'] . '&step=10&tab=1', 1);
}
$ms2->PrintSearch('index.php?mod=usrmgr&action=details&userid=' . $_GET['userid'] . '&tab=1', 'b.bid');
$dsp->AddFieldsetEnd();
$dsp->EndTab();
$dsp->StartTab(t('Sonstiges'));
// logins, last login
if ($auth['type'] >= 2) {
$lastLoginTS = $db->qry_first("SELECT max(logintime) FROM %prefix%stats_auth WHERE userid = %int% AND login = '******'", $_GET['userid']);
$dsp->AddDoubleRow(t('Logins'), $user_data['logins']);
if ($user_data['lastlogin']) {
$loginTime = t('am/um: ') . $func->unixstamp2date($user_data['lastlogin'], 'daydatetime');
} else {
$loginTime = t('noch nicht eingeloggt');
}
$dsp->AddDoubleRow(t('Letzter Login'), $loginTime);
$ms2->AddSelect('t.lgz_gamename');
$ms2->AddSelect('COUNT(teams.tournamentid) AS teamanz');
$ms2->AddResultField(t('Turniername'), 't.name', 'GetTournamentName');
$ms2->AddResultField(t('Admin'), 'tournamentadmin', 'GetTournamentUserIcon');
$ms2->AddResultField(t('Tech'), 'techadmin', 'GetTournamentUserIcon');
$ms2->AddResultField(t('Startzeit'), 'UNIX_TIMESTAMP(t.starttime) AS starttime', 'MS2GetDate');
$ms2->AddResultField(t('Team'), 't.maxteams', 'GetTournamentTeamAnz');
$ms2->AddResultField(t('Status'), 't.status', 'GetTournamentStatus');
$ms2->AddIconField('details', 'index.php?mod=tournament2&action=details&tournamentid=', t('Details'));
$ms2->AddIconField('tree', 'index.php?mod=tournament2&action=tree&step=2&tournamentid=', t('Spielbaum'), 'IfGenerated');
$ms2->AddIconField('play', 'index.php?mod=tournament2&action=games&step=2&tournamentid=', t('Paarungen'), 'IfGenerated');
$ms2->AddIconField('ranking', 'index.php?mod=tournament2&action=rangliste&step=2&tournamentid=', t('Rangliste'), 'IfFinished');
if ($auth['type'] >= 2) {
$ms2->AddIconField('generate', 'index.php?mod=tournament2&action=generate_pairs&step=2&tournamentid=', t('Generieren'), 'IfNotGenerated');
}
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=tournament2&action=change&step=1&tournamentid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=tournament2&action=delete&step=2&tournamentid=', t('Löschen'));
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction('Anmeldung öffnen', 'index.php?mod=tournament2&action=changestat&step=open', 1);
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction('Anmeldung sperren', 'index.php?mod=tournament2&action=changestat&step=lock', 1);
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction('Löschen', 'index.php?mod=tournament2&action=delete&step=10', 1);
}
$ms2->PrintSearch('index.php?mod=tournament2', 't.tournamentid');
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('');
$ms2->query['from'] = "%prefix%boxes AS b";
$ms2->query['default_order_by'] = 'place ASC, pos ASC, name ASC';
$ms2->AddTextSearchDropDown(t('Internet-Modus'), 'b.internet', array('' => t('Egal'), '1' => t('Nur im Intranet-Modus'), '2' => t('Nur im Internet-Modus')));
$ms2->AddTextSearchDropDown(t('Login'), 'b.login', array('' => t('Egal'), '1' => t('Nur für ausgeloggte'), '2' => t('Nur für eingeloggte'), '3' => t('Nur für Admins + Superadminen'), '4' => t('Nur für Superadminen')));
function PlaceName($place)
{
if ($place == 0) {
return t('Linke Seite');
} elseif ($place == 1) {
return t('Rechte Seite');
}
}
$ms2->AddResultField(t('Titel'), 'b.name');
$ms2->AddResultField(t('Boxid'), 'boxid');
$ms2->AddResultField(t('Seite'), 'b.place', 'PlaceName');
$ms2->AddResultField(t('Position'), 'b.pos');
$ms2->AddResultField(t('Aktiv'), 'b.active', 'TrueFalse');
$ms2->AddResultField(t('Quelldatei'), 'b.source');
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=boxes&step=20&boxid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=boxes&step=30&boxid=', t('Löschen'));
}
$ms2->AddMultiSelectAction(t('Aktivieren'), 'index.php?mod=boxes&step=10');
$ms2->AddMultiSelectAction(t('Deaktivieren'), 'index.php?mod=boxes&step=11');
$ms2->PrintSearch('index.php?mod=boxes', 'b.boxid');
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=boxes&step=20'));
$dsp->AddContent();
}
$db->free_result($res);
$ms2->AddTextSearchDropDown(t('Auslöser'), 'c.creatorid', $list);
$list = array('' => t('Alle'));
$row = $db->qry('SELECT relatedto_item FROM %prefix%comments GROUP BY relatedto_item');
while ($res = $db->fetch_array($row)) {
if ($res['relatedto_item']) {
$list[$res['relatedto_item']] = $res['relatedto_item'];
}
}
$db->free_result($row);
$ms2->AddTextSearchDropDown(t('Modul'), 'c.relatedto_item', $list);
$list = array('' => t('Alle'));
$row = $db->qry('SELECT relatedto_id FROM %prefix%comments GROUP BY relatedto_id');
while ($res = $db->fetch_array($row)) {
if ($res['relatedto_id']) {
$list[$res['relatedto_id']] = $res['relatedto_id'];
}
}
$db->free_result($row);
$ms2->AddTextSearchDropDown(t('Beitrags ID'), 'c.relatedto_id', $list);
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Meldung'), 'c.text', '', 220);
$ms2->AddResultField(t('Modul'), 'c.relatedto_item');
$ms2->AddResultField(t('Beitrags ID'), 'c.relatedto_id');
$ms2->AddResultField(t('Datum'), 'UNIX_TIMESTAMP(c.date) AS date', 'MS2GetDate');
$ms2->AddResultField(t('Auslöser'), 'u.username', 'UserNameAndIcon');
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=install&action=mc_search&step=10', 1);
}
$ms2->PrintSearch('index.php?mod=install&action=mc_search', 'c.commentid');
switch ($_GET['step']) {
// Delete
case 10:
include_once 'inc/classes/class_masterdelete.php';
$md = new masterdelete();
$md->MultiDelete('cron', 'jobid');
break;
// Run now
// Run now
case 20:
include_once "modules/cron2/class_cron2.php";
$cron2 = new cron2();
$dsp->AddDoubleRow(t('Folgender SQL-Befehl wurde ausgeführt'), $cron2->Run($_GET['jobid']));
$dsp->AddBackButton('index.php?mod=cron2');
break;
default:
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('cron2');
$ms2->query['from'] = "%prefix%cron AS c";
$ms2->AddResultField(t('Name'), 'c.name');
$ms2->AddResultField(t('Geplant um'), 'runat');
$ms2->AddResultField(t('Aktiv'), 'active', 'TrueFalse');
$ms2->AddResultField(t('Letzte Ausführung'), 'UNIX_TIMESTAMP(c.lastrun) AS lastrun', 'MS2GetDate');
$ms2->AddIconField('edit', 'index.php?mod=cron2&action=add&jobid=', t('Editieren'));
$ms2->AddIconField('generate', 'index.php?mod=cron2&step=20&jobid=', t('Jetzt ausführen'));
$ms2->AddMultiSelectAction('Löschen', 'index.php?mod=cron2&step=10&jobid=', 1);
$ms2->PrintSearch('index.php?mod=cron2', 'c.jobid');
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=cron2&action=add'));
break;
}
$dsp->AddContent();
return '<a href="index.php?mod=clanmgr&action=clanmgr&step=2&clanid=' . $line['clanid'] . '">' . $clan_name . '</a>';
} elseif ($clan_name != '' and $line['clanurl'] != '' and $line['clanurl'] != 'http://') {
if (substr($line['clanurl'], 0, 7) != 'http://') {
$line['clanurl'] = 'http://' . $line['clanurl'];
}
return '<a href="' . $line['clanurl'] . '" target="_blank">' . $clan_name . '</a>';
} else {
return $clan_name;
}
}
if (!$party->party_id) {
$func->information(t('Bitte setzte zuerst eine aktive Party.'));
} else {
$ms2->query['from'] = "%prefix%party_user pu\n\tINNER JOIN %prefix%user u ON u.userid = pu.user_id\n\tLEFT JOIN %prefix%clan c ON c.clanid = u.clanid";
$ms2->query['where'] = 'pu.party_id = ' . (int) $party->party_id . ' AND (exported IS NULL OR exported = 0)';
$ms2->config['EntriesPerPage'] = 100;
$ms2->AddResultField(t('Benutzername'), 'u.username');
if ($auth['type'] >= 2 or !$cfg['sys_internet'] or $cfg['guestlist_shownames']) {
$ms2->AddResultField(t('Vorname'), 'u.firstname');
$ms2->AddResultField(t('Nachname'), 'u.name');
}
$ms2->AddSelect('c.url AS clanurl');
$ms2->AddSelect('c.clanid AS clanid');
$ms2->AddResultField('Clan', 'c.name AS clan', 'ClanURLLink');
$ms2->AddIconField('details', 'index.php?mod=guestlist&action=details&userid=', t('Details'));
if ($auth['type'] >= 2) {
$ms2->AddMultiSelectAction(t('Exportieren'), "index.php?mod=guestlist&action=export&step=10", 1, 'export');
$ms2->AddMultiSelectAction(t('Als exportiert markieren'), "index.php?mod=guestlist&action=export&step=11", 1, 'setexported');
}
$ms2->PrintSearch('index.php?mod=guestlist', 'u.userid');
}
break;
case 'ban':
echo $item . "b" . HTML_NEWLINE;
break;
}
}
} else {
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%board_posts AS p\n LEFT JOIN %prefix%user AS u ON p.userid = u.userid\n LEFT JOIN %prefix%board_threads AS t ON p.tid = t.tid\n LEFT JOIN %prefix%board_forums AS f ON t.fid = f.fid\n ";
$ms2->query['where'] = 'f.need_type <= ' . (int) ($auth['type'] + 1);
$ms2->query['default_order_by'] = 'LastPost DESC';
$ms2->AddTextSearchField(t('Forum'), array('f.name' => 'like'));
$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'));
$ms2->AddSelect('p.userid');
$ms2->AddSelect('f.fid');
$ms2->AddSelect('MAX(p.date) AS LastPost');
$ms2->AddResultField(t('Text'), 'CONCAT(\'<b>\', f.name, \'</b> (\', t.caption, \')<br />\', p.comment) AS ThreadName', '', 140);
$ms2->AddResultField(t('Autor'), 'u.username', 'UserNameAndIcon');
$ms2->AddResultField(t('IP'), 'INET_NTOA(p.ip) AS ip');
$ms2->AddResultField(t('Datum'), 'p.date', 'MS2GetDate');
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=board&action=delete&step=10&pid=', t('Delete'));
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Delete'), 'index.php?mod=board&action=admin_search&mode=del', 1);
}
$ms2->PrintSearch('index.php?mod=board&action=admin_search', 'p.pid');
}
} else {
return $dsp->FetchIcon('index.php?mod=party&action=price&step=11&party_id=' . $_GET['party_id'] . '&evening_price_id=' . $line['price_id'], 'no', t('Nein'));
}
}
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('party');
$ms2->query['from'] = "%prefix%partys AS party LEFT JOIN %prefix%party_prices AS p ON p.party_id = party.party_id";
$ms2->query['default_order_by'] = 'p.price_text DESC';
$ms2->query['where'] = "party.party_id = " . (int) $_GET['party_id'];
$ms2->config['EntriesPerPage'] = 20;
/*
$party_list = array('' => 'Alle');
$row = $db->qry("SELECT party_id, name FROM %prefix%partys");
while($res = $db->fetch_array($row)) $party_list[$res['party_id']] = $res['name'];
$db->free_result($row);
$ms2->AddTextSearchDropDown('Party', 'p.party_id', $party_list, $party->party_id);
*/
$ms2->AddResultField(t('Text für Eintrittspreis'), 'p.price_text');
$ms2->AddResultField(t('Preis'), 'p.price');
$ms2->AddResultField(t('Abendkasse-Preis?'), 'party.evening_price_id', 'eveningPriceIdLink');
$ms2->AddResultField('Party', 'party.name');
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=party&action=price_edit&party_id=' . $_GET['party_id'] . '&price_id=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddMultiSelectAction(t('Löschen'), 'index.php?mod=party&action=price_del&party_id=' . $_GET['party_id'], 1);
}
$ms2->PrintSearch('index.php?mod=party&action=price&party_id=' . $_GET['party_id'], 'p.price_id');
$dsp->AddSingleRow($dsp->FetchSpanButton(t('Hinzufügen'), 'index.php?mod=party&action=price_edit'));
$dsp->AddBackButton('index.php?mod=party');
$dsp->AddContent();
