$colums = array_filter(array_keys($a[0]), "remove"); $t = '<div overflow:auto;"><table style="width:100%;" border="0" cellspacing="0" cellpadding="2">'; $t .= '<tr><th class="mastersearch2_result_row_key" style="border-bottom: 1px solid #000000;">' . implode('</th><th class="mastersearch2_result_row_key" style="border-bottom: 1px solid #000000;">', $colums) . '</th></tr>'; foreach ($a as $row) { $cellstyle = $row['cellstyle']; unset($row['cellstyle']); $t .= '<tr><td style="border-bottom: 1px solid #000000;' . $cellstyle . '">' . implode('</td><td style="border-bottom: 1px solid #000000;' . $cellstyle . '">', $row) . '</td></tr>'; } $t .= '</table></div>'; } else { $t = ''; } return $t; } include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $tgames = $db->qry("SELECT games1.gameid AS gid1, games2.gameid AS gid2, teams1.name AS name1, \n teams2.name AS name2, teams1.leaderid AS leaderid1, teams2.leaderid AS leaderid2, t.name AS tuname, \n t.mode AS modus , t.tournamentid AS tid,\n IF (games1.lastchange>games2.lastchange,games1.lastchange,games2.lastchange) AS lastactivity,\n games1.round, t.game_duration, t.break_duration,\n IF (games1.round=0,(t.game_duration*60),((t.game_duration+t.break_duration)*60)) AS overtime, (UNIX_TIMESTAMP(CURRENT_TIMESTAMP())-UNIX_TIMESTAMP(IF(games1.lastchange>games2.lastchange,games1.lastchange,games2.lastchange))) AS overtime2\nFROM %prefix%t2_games AS games1 \nINNER JOIN %prefix%t2_games AS games2 ON (games1.tournamentid = games2.tournamentid) AND (games1.round = games2.round) \nLEFT JOIN %prefix%tournament_tournaments AS t ON (t.tournamentid = games1.tournamentid) \nLEFT JOIN %prefix%t2_teams AS teams1 ON (games1.leaderid = teams1.leaderid) AND (t.tournamentid = teams1.tournamentid) \nLEFT JOIN %prefix%t2_teams AS teams2 ON (games2.leaderid = teams2.leaderid) AND (t.tournamentid = teams2.tournamentid) \nLEFT JOIN %prefix%t2_teammembers AS memb1 ON (teams1.teamid = memb1.teamid) LEFT JOIN %prefix%t2_teammembers AS \nmemb2 ON (teams2.teamid = memb2.teamid) \nWHERE ((games1.position / 2) = FLOOR(games1.position / 2)) \n AND (games1.score = 0) \n AND (games1.leaderid != 0) \n AND ((games1.position + 1) = games2.position) \n AND (games2.score = 0) \n AND (games2.leaderid !=0) \n AND (teams1.disqualified = '0') \n AND (teams2.disqualified = '0') \n AND (t.party_id = %int%) \n AND (t.status = 'process') \n AND NOT (mode = 'all')\n GROUP BY games1.gameid, games2.gameid \n ORDER BY lastactivity ASC \n", $party->party_id); while ($tgamesrow = $db->fetch_array($tgames, 1, MYSQLI_ASSOC)) { //d($tgamesrow); //$outputrow['Begegnung'] = "<b>".$tgamesrow['name1']."</b> vs <b>".$tgamesrow['name2']."</b>"; if (!($tgamesrow['modus'] == "single" and $tgamesrow['round'] < 0) and !($tgamesrow['modus'] == "all")) { // Workaround wegen Looserbraketeinträgen bei SingleElimination $outall[] = $tgamesrow; //$outputrow['Spieler 1'] = $tgamesrow['name1']; $outputrow['Spieler/Team 1'] = $dsp->FetchUserIcon($tgamesrow['leaderid1'], "<b>" . $tgamesrow['name1'] . "</b>") . " </br>" . $seat2->SeatNameLink($tgamesrow['leaderid1'], '', '') . ""; //$outputrow['Spieler 2'] = $tgamesrow['name2']; $outputrow['Spieler/Team 2'] = $dsp->FetchUserIcon($tgamesrow['leaderid2'], "<b>" . $tgamesrow['name2'] . "</b>") . " </br>" . $seat2->SeatNameLink($tgamesrow['leaderid2'], '', '') . ""; $outputrow['Turnier'] = "<a href=\"?mod=tournament2&action=details&tournamentid=" . $tgamesrow['tid'] . "\"><b>" . $tgamesrow['tuname'] . "</b></a>"; //$outputrow['Startzeit'] = $tgamesrow['lastactivity']; $tage = array("So", "Mo", "Di", "Mi", "Do", "Fr", "Sa"); $outputrow['Startzeit'] = $tage[date('w', strtotime($tgamesrow['lastactivity']))] . " " . date('H:i', strtotime($tgamesrow['lastactivity']));
} $games = $db->qry_first("SELECT COUNT(*) AS anz FROM %prefix%t2_games WHERE (tournamentid = %int%) AND (round=0) GROUP BY round", $tournamentid); $team_anz = $games["anz"]; $team1 = $db->qry_first("SELECT games.group_nr, games.round, games.position, games.score, games.comment, games.server_id, teams.name, teams.teamid, teams.disqualified, user.userid, user.username\n FROM %prefix%t2_games AS games\n LEFT JOIN %prefix%t2_teams AS teams ON games.leaderid = teams.leaderid\n LEFT JOIN %prefix%user AS user ON user.userid = teams.leaderid\n WHERE (teams.tournamentid = %int%) AND (games.gameid = %int%)\n ", $tournamentid, $gameid1); $team2 = $db->qry_first("SELECT games.round, games.position, games.score, games.comment, games.server_id, teams.name, teams.teamid, teams.disqualified, user.userid, user.username\n FROM %prefix%t2_games AS games\n LEFT JOIN %prefix%t2_teams AS teams ON games.leaderid = teams.leaderid\n LEFT JOIN %prefix%user AS user ON user.userid = teams.leaderid\n WHERE (teams.tournamentid = %int%) AND (games.gameid = %int%)\n ", $tournamentid, $gameid2); ########## Einschränkungen prüfen if ($tournament["name"] == "") { $func->error(t('Du musst zuerst ein Turnier auswählen!'), "index.php?mod=tournament2&action=details&tournamentid={$tournamentid}"); } elseif (abs($team1['position'] - $team2['position']) != 1) { $func->error(t('Diese Spielkonstellation existiert nicht!' . $team1['position'] . $team2['position'])); ########## Keine Einschränkungen gefunden } else { switch ($_GET["step"]) { default: include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); unset($_SESSION['tournament_submit_result_blocker']); if ($func->isModActive('server')) { //Server auslesen $selections = array(); $selections['0'] = t('Kein Server zugewiesen'); $res = $db->qry("SELECT * FROM %prefix%server WHERE party_id = %int%", $party->party_id); while ($row = $db->fetch_array($res)) { $selections[$row['serverid']] = $row['caption']; } $db->free_result($res); } $dsp->NewContent(t('Details der Partie %1 vs %2', $team1['name'], $team2['name']), t('Hier siehst du Details zu dieser Partie und kannst das Ergebnis eintragen.')); // Write Start and Enddate for each round $round_start = $tfunc->GetGameStart($tournament, $team1['round'], $team1['group_nr']); $round_end = $tfunc->GetGameEnd($tournament, $team1['round'], $team1['group_nr']);
<?php include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); if ($_GET['action'] == 'add' and $_GET['step'] < 2) { $_GET['step'] = 2; } // Error-Switch $error = array(); switch ($_GET['step']) { case 3: // Error Columns if ($_POST['cols'] == "") { $error['cols'] = t('Bitte gib die horizontale Länge ein'); } elseif ($_POST['cols'] <= 0) { $error['cols'] = t('Bitte gib eine Zahl, die größer als 0 ist ein'); } elseif ($_POST['cols'] >= 60) { $error['cols'] = t('Bitte gib eine kleinere Zahl als 60 ein'); } else { $row = $db->qry_first("SELECT count(*) AS number FROM %prefix%seat_seats\n WHERE blockid = %int% AND status = 2 AND col >= %int%", $_GET['blockid'], $_POST['cols']); if ($row["number"] != 0) { $error['cols'] = t('Bitte gib eine größere Zahl ein, da sonst Sitzplätze gelöscht werden. Um Trotzdem einen kleineren Sitzblock zu erzeugen, entferne bitte die betroffenen Benutzer.'); } } // Error Rows if ($_POST['rows'] == "") { $error['rows'] = t('Bitte gib die vertikale Länge ein'); } elseif ($_POST['rows'] <= 0) { $error['rows'] = t('Bitte gib eine Zahl, die größer als 0 ist ein'); } elseif ($_POST['rows'] >= 100) { $error['rows'] = t('Bitte gib eine kleinere Zahl als 100 ein');
<?php include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); switch ($_GET['step']) { default: #include_once('modules/seating/search.inc.php'); $row = $db->qry_first('SELECT blockid FROM %prefix%seat_block WHERE party_id = %int%', $party->party_id); $_GET['blockid'] = $row['blockid']; // Show seatplan // Show seatplan case 2: $dsp->NewContent(t('Sitzplatz - Informationen'), t('Fahre mit der Maus über einen Sitzplatz, um weitere Informationen zu erhalten.')); $current_url = 'index.php?mod=seating'; include_once 'modules/seating/search_basic_blockselect.inc.php'; $dsp->AddSingleRow($seat2->DrawPlan($_GET['blockid'], 0)); $dsp->AddBackButton('index.php?mod=seating', 'seating/show'); $dsp->AddContent(); break; // Reserve free seat // Reserve free seat case 10: $user_data = $db->qry_first("SELECT paid FROM %prefix%party_user\n WHERE user_id = %int% AND party_id = %int%", $auth['userid'], $party->party_id); $seat_user = $db->qry_first("SELECT status FROM %prefix%seat_seats\n WHERE blockid = %int% AND row = %string% AND col = %string%", $_GET['blockid'], $_GET['row'], $_GET['col']); // Check paid if (!$user_data['paid'] and $cfg['seating_paid_only'] and !$cfg['seating_not_paid_mark']) { $func->information(t('Du musst zuerst für diese Party bezahlen, bevor du dir einen Sitzplatz reservieren darfst.'), "index.php?mod=seating&action=show&step=2&blockid={$_GET['blockid']}"); } elseif ($seat_user['status'] == 2) { $func->error(t('Dieser Sitzplatz ist bereits vergeben'), "index.php?mod=seating&action=show&step=2&blockid={$_GET['blockid']}"); } elseif ($seat_user['status'] == 0 or $seat_user['status'] > 9) {
} } } $dsp->SetForm("index.php?mod=foodcenter&action=print&design=base\" target=\"_blank\"", "print"); $dsp->AddDropDownFieldRow("file", t('Bitte Template auswählen:'), $file_array, ""); $MainContent .= "<input type=\"hidden\" name=\"search_input[0]\" value=\"{$_POST['search_input'][0]}\">\n"; $MainContent .= "<input type=\"hidden\" name=\"search_dd_input[0]\" value=\"{$_POST['search_dd_input'][0]}\">\n"; $MainContent .= "<input type=\"hidden\" name=\"search_dd_input[1]\" value=\"{$_POST['search_dd_input'][1]}\">\n"; $MainContent .= "<input type=\"hidden\" name=\"search_dd_input[2]\" value=\"{$_POST['search_dd_input'][2]}\">\n"; $dsp->AddFormSubmitRow(t('Drucken')); $dsp->AddContent(); break; case 2: if ($_POST['action']) { include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $time = time(); $totprice = 0; foreach ($_POST["action"] as $item => $val) { if ($_GET["status"] == 6 | $_GET["status"] == 7) { $db->qry("UPDATE %prefix%food_ordering SET status = %string%, lastchange = %string%, supplytime = %string% WHERE id = %string%", $_GET["status"], $time, $time, $item); //sitzplan popup einbinden //change by jan für sitzplatz popup $item = id in food_ordering table //unit food_option (größe) $abfrage = $db->qry_first("SELECT %prefix%food_ordering.userid AS userid,%prefix%food_ordering.pice AS pice,unit, %prefix%food_product.caption AS caption, username, name, firstname\n\t\t\t\tFROM %prefix%food_ordering,%prefix%food_option, %prefix%food_product, %prefix%user\n\t\t\t\tWHERE %prefix%food_ordering.id = " . $item . " \n\t\t\t\tAND lastchange=" . $time . " \n\t\t\t\tAND supplytime=" . $time . " \n\t\t\t\tAND %prefix%food_product.id = %prefix%food_option.parentid \n\t\t\t\tAND %prefix%food_ordering.productid = %prefix%food_product.id\n\t\t\t\tAND %prefix%user.userid = %prefix%food_ordering.userid"); //$dsp->AddDoubleRow('Ergebnis', $seat2->SeatOfUser($abfrage['userid'], 0, 2)); $dsp->AddDoubleRow('Was -> Wohin', $abfrage['pice'] . ' x ' . $abfrage['caption'] . ' (' . $abfrage['unit'] . ') -> ' . $abfrage['username'] . ' (' . $abfrage['firstname'] . ' ' . $abfrage['name'] . ') ' . $seat2->SeatOfUser($abfrage['userid'], 0, 2)); //change ende } elseif ($_GET["status"] == 8) { $totprice = 0; $prodrow = $db->qry_first("SELECT * FROM %prefix%food_ordering WHERE id = %string%", $item);
$link = 'index.php?mod=guestlist&step=21&userid=' . $_GET['userid']; } if ($user_party['checkout']) { $party_row .= ' ' . $dsp->AddIcon('out', $link, t('Ausgecheckt')) . '[' . $func->unixstamp2date($user_party['checkout'], 'datetime') . ']'; } else { $party_row .= ' ' . $dsp->AddIcon('not_out', $link, t('Nicht ausgecheckt')); } if (IsAuthorizedAdmin() and $user_party['checkin'] > 0 and $user_party['checkout'] > 0) { $party_row .= $dsp->AddIcon('delete', 'index.php?mod=guestlist&step=22&userid=' . $_GET['userid'], 'Reset Checkin'); } $dsp->AddDoubleRow("Party '<i>" . $_SESSION['party_info']['name'] . "</i>'", $party_row); } // Seating if ($func->isModActive('seating')) { include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $user_data_seating = $seat2->SeatOfUserArray($_GET['userid']); if ($user_data_seating['block'] == '') { $seat = t('Kein Sitzplatz ausgewählt / zugeteilt.'); } else { $seat = $seat2->SeatOfUser($_GET['userid'], 0, 2); if (IsAuthorizedAdmin()) { $seat .= ' ' . $dsp->AddIcon('delete', "index.php?mod=seating&action=seatadmin&step=20&blockid={$user_data_seating['block']}&row={$user_data_seating['row']}&col={$user_data_seating['col']}&userid={$user_data['userid']}", t('Löschen')); } } if (IsAuthorizedAdmin()) { $seat .= ' ' . $dsp->AddIcon('edit', 'index.php?mod=seating&action=seatadmin&step=2&userid=' . $_GET['userid'], t('Editieren')); } if ($cfg['sys_internet'] == 0 and $user_data_seating['ip']) { $seat .= ' IP:' . $user_data_seating['ip']; }
<?php include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $timestamp = time(); if (!$party->party_id) { $func->information(t('Es gibt keine aktive Party. Bitte setze im Partymanager eine Party aktiv')); } else { // Main-Switch switch ($_GET["step"]) { // Auswahl: Angemeldet? ja/Nein case '': case 1: unset($_SESSION['quick_signon']); $dsp->AddFieldsetStart('Direkt zu folgendem Benutzer springen'); if ($cfg['sys_barcode_on']) { $dsp->AddBarcodeForm("<strong>" . t('Strichcode') . "</strong>", "", "index.php?mod=usrmgr&action=entrance&step=3&userid="); } $dsp->SetForm('index.php?mod=usrmgr&action=entrance&step=3', 'CheckinAssistantUseridForm'); $dsp->AddTextFieldRow('userid', t('UserID'), '', ''); $dsp->AddFormSubmitRow(t('Weiter')); $dsp->AddFieldsetEnd(); $questionarr[1] = t('Bereits <b>angemeldeten Gast einchecken</b>'); $questionarr[2] = t('Bereits <b>zu einer vergangenen Party angemeldeten Gast einchecken</b>'); $questionarr[3] = t('Neuer Gast. Einen <b>Account erstellen</b><br /><i>Es wird nur eine E-Mail-Adresse angelegt und ein Passwort automatisch generiert. Alle weiteren Daten gibt der Benutzer beim ersten Einloggen selbst ein.</i>'); $questionarr[4] = t('Neuer Gast. Einen <b>erweiterten Account erstellen</b><br /><i>Hier liegst du direkt am Einlass alle Benutzerdaten fest.</i>'); $linkarr[1] = "index.php?mod=usrmgr&action=entrance&step=2&signon=1"; $linkarr[2] = "index.php?mod=usrmgr&action=entrance&step=2&signon=0"; $linkarr[3] = "index.php?mod=usrmgr&action=entrance&step=3&quick_signon=1"; $linkarr[4] = "index.php?mod=usrmgr&action=entrance&step=3&quick_signon=0"; $func->multiquestion($questionarr, $linkarr, "");
<?php include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); // Errors if ($_GET['step'] > 1 and !$_GET['userid']) { $func->error(t('Es wurde kein Benutzer ausgewählt'), "index.php?mod=seating&action=seatadmin"); } if ($_GET['step'] > 2 and !$_GET['blockid']) { $func->error(t('Es wurde kein Sitzblock ausgewählt'), "index.php?mod=seating&action=seatadmin&step=2&userid={$_GET['userid']}"); } // Exec step10-query if ($_GET['step'] == 10 and $_GET['quest']) { // Assign seat $seat2->AssignSeat($_GET['userid'], $_GET['blockid'], $_GET['row'], $_GET['col']); // If old owner should get a new seat, jump to step 2 an procede with this user if ($_GET['quest'] == 2) { $_GET['step'] = 2; $_GET['userid'] = $_GET['next_userid']; } $back_link = ''; if ($_GET['quest'] == 1) { $back_link = 'index.php?mod=seating&action=seatadmin'; } $func->confirmation(t('Der Sitzplatz wurde erfolgreich für %1 reserviert', $new_user['username']), $back_link); } // Select seat and user infos if ($_GET['blockid'] and isset($_GET['row']) and isset($_GET['col'])) { $seat = $db->qry_first("SELECT s.userid, s.status, u.username, u.firstname, u.name FROM %prefix%seat_seats AS s\n LEFT JOIN %prefix%user AS u ON s.userid = u.userid\n WHERE blockid = %int% AND row = %string% AND col = %string%", $_GET['blockid'], $_GET['row'], $_GET['col']); } if ($_GET['userid']) {
function ExportCSVCard($sep) { global $db, $config, $func, $party; include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $user_export = $config['lansuite']['version'] . " CSV Export\r\nParty: " . $config['lanparty']['name'] . "\r\nExportdate: " . $func->unixstamp2date(time(), 'daydatetime') . "\r\n\r\n"; $user_export .= "username;name;firstname;clan;seatblock;col;row;seat;ip\n"; $query = $db->qry("SELECT s.* FROM %prefix%seat_seats AS s\n LEFT JOIN %prefix%seat_block AS b ON s.blockid = b.blockid\n WHERE b.party_id = %int% AND s.status = 2\n ORDER BY s.blockid", $party->party_id); while ($row_seat = $db->fetch_array($query)) { $userid = $row_seat["userid"]; $row = $db->qry_first("SELECT u.*, c.name AS clan, c.url AS clanurl, p.paid, p.checkin, p.checkout, p.signondate, p.seatcontrol\n FROM %prefix%user AS u\n LEFT JOIN %prefix%party_user AS p ON p.user_id = u.userid\n \t\t\tLEFT JOIN %prefix%clan AS c ON u.clanid = c.clanid\n WHERE u.userid=%int%\n ", $userid); $username = str_replace(">", "", $row["username"]); $username = str_replace("<", "", $username); $username = str_replace(">", "", $username); $username = str_replace("<", "", $username); $username = trim($username); $user_export .= $username . $sep; $user_export .= $row["name"] . $sep; $user_export .= $row["firstname"] . $sep; $user_export .= $row["clan"] . $sep; $blockid = $row_seat["blockid"]; $row_block = $db->qry_first("SELECT orientation, name FROM %prefix%seat_block WHERE blockid=%int%", $blockid); $seatindex = $seat2->CoordinateToName($row_seat["col"] + 1, $row_seat["row"], $row_block["orientation"]); $user_export .= $row_block["name"] . $sep; $user_export .= $row_seat["col"] . $sep; $user_export .= $row_seat["row"] . $sep; $user_export .= $seatindex . $sep; $user_export .= $row_seat["ip"]; $user_export .= "\r\n"; } // end while return $user_export; }
<?php include_once "modules/seating/class_seat.php"; $seat2 = new seat2(); $id = $_GET['id']; $function = $_GET['function']; $userarray = $_GET['userarray']; $legend = $_GET['l']; $dsp->NewContent(""); $dsp->AddSingleRow($seat2->DrawPlan($id, 0, '', $userarray[0])); $dsp->AddContent();