return '';
}
if (substr($clan_url, 0, 7) != 'http://' and substr($clan_url, 0, 8) != 'https://') {
$clan_url = "http://" . $clan_url;
}
return '<a href="' . $clan_url . '" target="_blank">' . $clan_url . '</a>';
}
switch ($_GET['step']) {
default:
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('clanmgr');
$ms2->query['from'] = "%prefix%clan AS c\n LEFT JOIN %prefix%user AS u ON c.clanid = u.clanid";
$ms2->config['EntriesPerPage'] = 20;
#$ms2->AddBGColor('c.clanid', array($auth['clanid'] => 'ff0000'));
$ms2->AddTextSearchField(t('Clanname'), array('c.name' => '1337', 'c.url' => 'like'));
$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=install&action=translation', 'file');
$dsp->AddFieldSetEnd();
break;
case 2:
$dsp->NewContent(t('Übersetzen'), t('Es müssen nur Einträge eingetragen werden, die sich in der Zielsprache vom Orginal unterscheiden'));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('install');
$ms2->query['from'] = "%prefix%translation";
$ms2->config['EntriesPerPage'] = 50;
$selections = array('' => t('Alle'));
$res = $db->qry("SELECT file FROM %prefix%translation GROUP BY file");
while ($row = $db->fetch_array($res)) {
$selections[$row['file']] = $row['file'];
}
$db->free_result($res);
$ms2->AddTextSearchDropDown(t('Fundstelle'), 'file', $selections);
$ms2->AddTextSearchDropDown(t('Englisch'), 'en', array('' => t('Egal'), '>0' => t('Vorhanden')));
$ms2->AddTextSearchDropDown(t('Veraltet'), 'obsolete', array('' => t('Alle'), '0' => t('Nur neue'), '1' => t('Nur veraltete')));
$ms2->AddTextSearchField(t('Text'), array('org' => 'like'));
$ms2->AddResultField(t('Text'), 'org');
$ms2->AddResultField(t('Fundstelle'), 'file');
$ms2->AddResultField(t('De'), 'de', 'YesNo');
$ms2->AddResultField(t('En'), 'en', 'YesNo');
$ms2->AddResultField(t('Es'), 'es', 'YesNo');
$ms2->AddResultField(t('Nl'), 'nl', 'YesNo');
$ms2->AddResultField(t('Fr'), 'fr', 'YesNo');
$ms2->AddResultField(t('It'), 'it', 'YesNo');
$ms2->AddIconField('edit', 'index.php?mod=install&action=translation&step=3&tid=', t('Edit'));
$ms2->PrintSearch('index.php?mod=install&action=translation&step=2', 'tid');
break;
case 3:
if ($line['available'] == 1) {
return "<div class=\"tbl_green\">Online</div>";
} elseif ($line['available'] == 2) {
return "<div class=\"tbl_red\">Port Offline</div>";
} else {
return "<div class=\"tbl_red\">IP Offline</div>";
}
} else {
return "-";
}
}
$ms2->query['from'] = "%prefix%server AS s LEFT JOIN %prefix%user AS u ON s.owner = u.userid";
$ms2->config['EntriesPerPage'] = 30;
$ms2->AddTextSearchField(t('Name'), array('s.caption' => 'like', 's.ip' => 'like'));
$ms2->AddTextSearchField(t('Besitzer'), array('u.username' => '1337', 'u.name' => 'like', 'u.firstname' => 'like'));
$ms2->AddTextSearchDropDown(t('Servertyp'), 's.type', array('' => t('Alle'), 'gameserver' => 'Game', 'ftp' => 'FTP', 'irc' => 'IRC', 'web' => 'Web', 'proxy' => 'Proxy', 'misc' => 'Misc'));
$ms2->AddTextSearchDropDown('PW', 's.pw', array('' => t('Alle'), '0' => t('Nein'), '1' => t('Ja')));
$ms2->AddSelect('u.userid');
$ms2->AddResultField(t('Name'), 's.caption');
$ms2->AddResultField(t('Servertyp'), 's.type', 'ServerType');
$ms2->AddResultField(t('IP-Adresse / Domain'), 's.ip');
$ms2->AddResultField(t('Port'), 's.port');
$ms2->AddResultField(t('Besitzer'), 'u.username', 'UserNameAndIcon');
$ms2->AddResultField('PW', 's.pw', 'PWIcon');
$ms2->AddResultField(t('Status'), 's.available', 'ServerStatus');
$ms2->AddIconField('details', 'index.php?mod=server&action=show_details&serverid=', t('Details'));
if ($auth['type'] >= 2) {
$ms2->AddIconField('edit', 'index.php?mod=server&action=change&step=2&serverid=', t('Editieren'));
}
if ($auth['type'] >= 3) {
$ms2->AddIconField('delete', 'index.php?mod=server&action=delete&step=2&serverid=', t('Löschen'));
$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);
$ms2->AddTextSearchDropDown('Modul', 'module', $list);
$list = array('' => 'Alle');
$row = $db->qry('SELECT b.agent, u.username FROM %prefix%bugtracker AS b LEFT JOIN %prefix%user AS u ON b.agent = u.userid WHERE b.agent > 0 ORDER BY u.username');
while ($res = $db->fetch_array($row)) {
$list[$res['agent']] = $res['username'];
}
$db->free_result($row);
$ms2->AddTextSearchDropDown('Bearbeiter', 'b.agent', $list);
$list = array('' => 'Alle');
$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');
$ms2->AddSelect('t.sticky');
$ms2->AddResultField(t('Status'), 'UNIX_TIMESTAMP(r.date) AS date', 'NewPosts');
if ($_GET['fid'] != '') {
$ms2->AddResultField(t('Thread'), 't.caption', 'FormatTitle');
} else {
$ms2->AddResultField(t('Thread'), 'CONCAT(\'<b>\', f.name, \'</b><br />\', t.caption) AS ThreadName', 'FormatTitle');
}
$ms2->AddResultField(t('Aufrufe'), 't.views');
$ms2->AddResultField(t('Antworten'), '(COUNT(p.pid) - 1) AS posts');
//$ms2->AddResultField(t('Erster Beitrag'), 'UNIX_TIMESTAMP(MIN(p.date)) AS FirstPost', 'LastPostDetails');
$ms2->AddResultField(t('Letzter Beitrag'), 'UNIX_TIMESTAMP(MAX(p.date)) AS LastPost', 'LastPostDetails');
if ($_GET['action'] == 'bookmark') {
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%log AS l\n LEFT JOIN %prefix%user AS u ON u.userid = l.userid";
$ms2->query['default_order_by'] = 'l.date DESC';
$ms2->config['EntriesPerPage'] = 50;
$ms2->AddTextSearchField(t('Meldung'), array('l.description' => 'like'));
$ms2->AddTextSearchField(t('IP'), array('ip' => 'aton'));
$list = array('' => t('Alle'), '0' => t('System'));
$res = $db->qry("SELECT l.userid, u.username FROM %prefix%log AS l\n LEFT JOIN %prefix%user AS u ON u.userid = l.userid\n GROUP BY l.userid");
while ($row = $db->fetch_array($res)) {
if ($row['userid']) {
$list[$row['userid']] = $row['username'];
}
}
$db->free_result($res);
$ms2->AddTextSearchDropDown(t('Auslöser'), 'l.userid', $list);
$list = array('' => t('Alle'));
$row = $db->qry("SELECT sort_tag FROM %prefix%log GROUP BY sort_tag");
while ($res = $db->fetch_array($row)) {
if ($res['sort_tag']) {
$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');
return '';
}
}
$ms2->query['from'] = "%prefix%user AS u\n LEFT JOIN %prefix%clan AS c ON u.clanid = c.clanid\n LEFT JOIN %prefix%party_user AS p ON u.userid = p.user_id\n LEFT JOIN %prefix%party_prices AS i ON i.party_id = p.party_id AND i.price_id = p.price_id";
if ($party->party_id) {
$ms2->query['where'] = 'p.party_id = ' . (int) $party->party_id;
} else {
$ms2->query['where'] = '1 = 1';
}
$cfg['guestlist_showorga'] ? $ms2->query['where'] .= ' AND u.type >= 1' : ($ms2->query['where'] .= ' AND u.type = 1');
$ms2->config['EntriesPerPage'] = 20;
$ms2->AddTextSearchField(t('Benutzername'), array('u.username' => '1337'));
$ms2->AddTextSearchField(t('Userid'), array('u.userid' => 'exact'));
$ms2->AddTextSearchField(t('Name'), array('u.name' => 'like', 'u.firstname' => 'like'));
if ($party->party_id) {
$ms2->AddTextSearchDropDown(t('Bezahlt'), 'p.paid', array('' => 'Alle', '0' => 'Nicht bezahlt', '>1' => 'Bezahlt'));
if (!$cfg['sys_internet']) {
$ms2->AddTextSearchDropDown(t('Eingecheckt'), 'p.checkin', array('' => t('Alle'), '0' => t('Nicht Eingecheckt'), '>1' => t('Eingecheckt')));
$ms2->AddTextSearchDropDown(t('Ausgecheckt'), 'p.checkout', array('' => t('Alle'), '0' => t('Nicht Ausgecheckt'), '>1' => t('Ausgecheckt')));
}
}
$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) {
/*
* Created on 12.02.2009
*
* Gibt zufällig ausgewählte Benutzer aus. Nützlich für Gewinnspiele etc.
*
* @package lansuite_core
* @author Maztah
*
*/
$dsp->NewContent(t('Zufallsuser'));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('random_user');
//Anzeige User
$ms2->query['from'] = "%prefix%user AS u\n \t\tLEFT JOIN %prefix%clan AS c ON u.clanid = c.clanid\n \tLEFT JOIN %prefix%party_user AS p ON u.userid = p.user_id\n \t\tLEFT JOIN %prefix%party_prices AS i ON i.party_id = p.party_id AND i.price_id = p.price_id";
$ms2->query['default_order_by'] = "RAND()";
$ms2->config['EntriesPerPage'] = 20;
$party_list = array('' => 'Alle', 'NULL' => 'Zu keiner Party angemeldet');
$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(t('Party'), 'p.party_id', $party_list, $party->party_id);
$ms2->AddTextSearchDropDown(t('Eingecheckt'), 'p.checkin', array('' => t('Alle'), '0' => t('Nicht eingecheckt'), '>1' => t('Eingecheckt')));
$ms2->AddResultField(t('LS ID'), 'u.userid');
$ms2->AddResultField(t('Benutzername'), 'u.username');
$ms2->AddResultField(t('Vorname'), 'u.firstname');
$ms2->AddResultField(t('Nachname'), 'u.name');
$ms2->AddIconField('details', 'index.php?mod=usrmgr&action=details&userid=', t('Details'));
$ms2->PrintSearch('index.php?mod=guestlist&action=random_user', 'u.userid');
function get_modullink($modul)
{
return "<a href=\"index.php?mod=install&action=mod_cfg&step=10&module=" . $modul . "\">" . $modul . "</a>";
}
$dsp->NewContent('Suche Configschlüssel', 'Zum bearbeiten auf den Modullink klicken');
// Init Mastersearch
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%config l";
// Add Searchfields
$ms2->AddSelect('l.cfg_key');
$ms2->AddSelect('l.cfg_value');
$ms2->AddSelect('l.cfg_desc');
$ms2->AddTextSearchField(t('Alle Felder'), array('l.cfg_key' => 'like', 'l.cfg_value' => 'like', 'l.cfg_desc' => 'like', 'l.cfg_module' => 'like'));
$list = array('' => 'Alle');
$row = $db->qry('SELECT cfg_module FROM %prefix%config WHERE cfg_module != "" GROUP BY cfg_module ORDER BY cfg_module');
while ($res = $db->fetch_array($row)) {
$list[$res['cfg_module']] = $res['cfg_module'];
}
$db->free_result($row);
$ms2->AddTextSearchDropDown('Modul', 'l.cfg_module', $list);
// Which columns should be displayed?
$ms2->AddResultField(t('Key'), 'l.cfg_key');
$ms2->AddResultField(t('Modul'), 'l.cfg_module', 'get_modullink');
$ms2->AddResultField(t('Value'), 'l.cfg_value');
$ms2->AddResultField(t('Beschreibung'), 'l.cfg_desc');
// Functionbuttons
// Einzeledit muss noch integriert werden.
//if ($auth['type'] >= 2) $ms2->AddIconField('edit', 'index.php?mod=install&action=mod_cfg&step=10&cfg_key=', t('Editieren'));
// Final Output
$ms2->PrintSearch('index.php?mod=install&action=search_cfg', 'l.cfg_key');
$return = "";
$return .= "<a href='index.php?mod=foodcenter&headermenuitem=" . $data[cat_id] . "&info=" . $id . "'><b>" . $data[caption] . "</b>";
$return .= " <br />" . $data[p_desc] . "</a>";
return $return;
}
$product_list = new product_list();
$dsp->NewContent(t('Produktsuche'), t('Hier findest du alles was das Herz begehrt'));
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%food_product AS p\n\t\t\tLEFT JOIN %prefix%food_option AS o ON o.parentid = p.id";
$cat_list = array('' => 'Alle');
$row = $db->qry("SELECT * FROM %prefix%food_cat");
while ($res = $db->fetch_array($row)) {
$cat_list[$res['cat_id']] = $res['name'];
}
$db->free_result($row);
$ms2->AddTextSearchDropDown('Produktkategorie', 'p.cat_id', $cat_list);
$ms2->AddTextSearchField('Produktsuche', array('p.caption' => 'like', 'p.p_desc' => 'like'));
$ms2->AddSelect('p.cat_id');
$ms2->AddResultField('Titel', 'p.id', 'GetTitelName');
//$ms2->AddIconField('basket', 'index.php?mod=foodcenter&headermenuitem='=', t('Details'));
switch ($_POST['search_dd_input'][0]) {
case 1:
$ms2->NoItemsText = t('Keine aktuellen Bestellungen vorhanden.');
break;
case 2:
$ms2->NoItemsText = t('Es müssen keine Produkte bestellt werden.');
break;
case 3:
$ms2->NoItemsText = t('Es wird auf keine Lieferung gewartet.');
break;
case 4:
$mf->SendForm('index.php?mod=boxes&step=20', 'boxes', 'boxid', $_GET['boxid']);
break;
// Delete
// Delete
case 30:
include_once 'inc/classes/class_masterdelete.php';
$md = new masterdelete();
$md->Delete('boxes', 'boxid', $_GET['boxid']);
break;
}
$dsp->NewContent(t('Box-Manager'), t('Hier kannst du die Anzeige und Position der Boxen verwalten'));
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');
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%food_ordering AS a\n\t\t\tLEFT JOIN %prefix%food_status AS s ON a.status = s.id \n\t\t\tLEFT JOIN %prefix%food_product AS p ON a.productid = p.id \n\t\t\tLEFT JOIN %prefix%food_option AS o ON a.opts = o.id";
$ms2->query['where'] = 'userid=' . (int) $auth['userid'];
$status_list = array('' => 'Alle');
$row = $db->qry("SELECT * FROM %prefix%food_status");
while ($res = $db->fetch_array($row)) {
$status_list[$res['id']] = $res['statusname'];
}
$db->free_result($row);
$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('Status', 'a.status', $status_list);
$ms2->AddTextSearchDropDown('Party', 'a.partyid', $party_list, $party->party_id);
$ms2->AddResultField('Titel', 'p.caption');
$ms2->AddResultField('Einheit', 'o.unit');
$ms2->AddResultField('Anzahl', 'a.pice');
$ms2->AddResultField('Preis', 'o.price', 'GetPriceFormat');
$ms2->AddResultField('Bestellt', 'a.ordertime', 'MS2GetDate');
$ms2->AddResultField('Letzte änderung', 'a.lastchange', 'MS2GetDate');
$ms2->AddResultField('Geliefert', 'a.supplytime', 'MS2GetDate');
$ms2->AddResultField('Status', 's.statusname');
//$ms2->AddIconField('details', 'index.php?mod=foodcenter&action=ordered&step=2&id=', t('Details'));
switch ($_POST['search_dd_input'][0]) {
case 1:
$ms2->NoItemsText = t('Keine aktuellen Bestellungen vorhanden.');
break;
case 2:
break;
}
}
if (!$_GET['act'] or $_GET['act'] and $_GET['step'] == 2) {
if ($userid == null) {
$userid = $auth['userid'];
}
$dsp->NewContent(t('Buchhaltung'), t('Übersicht aller meiner Ein- und Ausgaben'));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('accounting');
$ms2->query['from'] = "%prefix%cashmgr_accounting AS a\r\n LEFT JOIN %prefix%user AS fu ON a.fromUserid = fu.userid\r\n LEFT JOIN %prefix%user AS tu ON a.toUserid = tu.userid";
$ms2->query['default_order_by'] = 'actiontime DESC';
$ms2->query['where'] = "a.toUserid = {$userid} OR a.fromUserid = {$userid}";
$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', 'a.partyid', $party_list, $party->party_id);
$ms2->AddTextSearchDropDown('Zahlungsart', 'a.cash', array('' => 'Alle', 0 => 'Nur Online', '1' => 'Nur Bar'));
$ms2->AddResultField(t('Datum'), 'a.actiontime', 'MS2GetDate');
$ms2->AddResultField(t('Modul'), 'a.modul');
$ms2->AddResultField(t('Kommentar'), 'a.comment');
$ms2->AddSelect('a.fromUserid');
$ms2->AddSelect("IF(a.fromUserid = {$userid},'1','0') AS my");
$ms2->AddResultField(t('Bearbeiter'), 'fu.username', 'UserNameAndIcon');
$ms2->AddResultField(t('Betrag'), 'a.movement', 'getColor');
$ms2->PrintSearch('index.php?mod=cashmgr&action=myaccounting', 'a.id');
}
switch ($_GET["step"]) {
default:
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2('install');
$ms2->query['from'] = "%prefix%stats_auth AS a\n LEFT JOIN %prefix%user AS u ON a.userid = u.userid";
$ms2->config['EntriesPerPage'] = 50;
$ms2->query['default_order_by'] = 'a.lasthit DESC';
$list = array('' => t('Alle'), '0' => t('System'));
$res = $db->qry("SELECT l.userid, u.username FROM %prefix%log AS l\n LEFT JOIN %prefix%user AS u ON u.userid = l.userid\n GROUP BY l.userid");
while ($row = $db->fetch_array($res)) {
if ($row['userid']) {
$list[$row['userid']] = $row['username'];
}
}
$db->free_result($res);
$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');
<?php
$dsp->NewContent(t('Suchmaschinen'), t('Hier siehst du, über welche Suchbegriffe Besucher über Suchmaschinenen auf deiner Seite gelandet sind'));
include_once 'modules/mastersearch2/class_mastersearch2.php';
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%stats_se";
$ms2->query['default_order_by'] = 'hits DESC';
$ms2->config['EntriesPerPage'] = 50;
$ms2->AddTextSearchField(t('Suchbegriff'), array('term' => 'like'));
$list = array('' => 'Alle');
$res = $db->qry('SELECT se FROM %prefix%stats_se GROUP BY se ORDER BY se');
while ($row = $db->fetch_array($res)) {
$list[$row['se']] = $row['se'];
}
$db->free_result($res);
$ms2->AddTextSearchDropDown('Suchmaschiene', 'se', $list);
$ms2->AddResultField(t('Suchbegriff'), 'term', '', 80);
$ms2->AddResultField(t('Anzahl'), 'hits');
$ms2->AddResultField(t('Erstmalig'), 'UNIX_TIMESTAMP(first) AS first', 'MS2GetDate');
$ms2->AddResultField(t('Zuletzt'), 'UNIX_TIMESTAMP(last) AS last', 'MS2GetDate');
#$ms2->AddIconField('details', 'index.php?mod=news&action=comment&newsid=', t('Details'));
#if ($auth['type'] >= 2) $ms2->AddIconField('edit', 'index.php?mod=news&action=change&step=2&newsid=', t('Editieren'));
#if ($auth['type'] >= 3) $ms2->AddIconField('delete', 'index.php?mod=news&action=delete&step=2&newsid=', t('Löschen'));
$ms2->PrintSearch('index.php?mod=stats&action=search_engines', '1');
$dsp->AddBackButton("index.php?mod=stats", "stats/se");
$dsp->AddContent();
$status_list[$res['id']] = $res['statusname'];
}
$db->free_result($row);
$supp_list = array('' => 'Alle');
$row = $db->qry("SELECT * FROM %prefix%food_supp");
while ($res = $db->fetch_array($row)) {
$supp_list[$res['supp_id']] = $res['name'];
}
$db->free_result($row);
$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('Status', 'a.status', $status_list, '1');
$ms2->AddTextSearchDropDown('Lieferant', 's.supp_id', $supp_list);
$ms2->AddTextSearchDropDown('Party', 'a.partyid', $party_list, $party->party_id);
/*
$userquery = $db->qry("SELECT * FROM %prefix%food_ordering AS a LEFT JOIN %prefix%user AS u ON a.userid=u.userid");
$user_array[''] = t('');
while ($userrows = $db->fetch_array($userquery)) {
$user_array[$userrows['userid']] = $userrows['username'];
}
$ms2->AddTextSearchDropDown('Besteller', 'a.userid', $user_array);
*/
$ms2->AddSelect('u.userid');
$ms2->AddResultField('Titel', 'p.caption');
//$ms2->AddResultField('Option', 'o.caption');
$ms2->AddResultField('Einheit', 'o.unit');
$ms2->AddResultField('Anzahl', 'a.pice');
$ms2 = new mastersearch2();
$ms2->query['from'] = "%prefix%comments AS c\n LEFT JOIN %prefix%user AS u ON u.userid = c.creatorid";
$ms2->query['default_order_by'] = 'c.date DESC';
$ms2->config['EntriesPerPage'] = 30;
$ms2->AddTextSearchField(t('Kommentar'), array('c.text' => 'like'));
$list = array('' => t('Alle'), '0' => t('System'));
$res = $db->qry('SELECT u.userid, u.username FROM %prefix%comments AS c
LEFT JOIN %prefix%user AS u ON u.userid = c.creatorid
GROUP BY c.creatorid');
while ($row = $db->fetch_array($res)) {
if ($row['userid']) {
$list[$row['userid']] = $row['username'];
}
}
$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'];
}
