/** * Format the next departures list * @param array $departures * @return array */ public function formatDepartures($departures) { $return = array(); if (isset($departures['values'])) { foreach ($departures['values'] as $row) { if (!in_array(trim($row['platform']['direction']['line']['line_name']), $this->Provider->ignore_routes)) { $Date = new DateTime($row['time_timetable_utc']); $Date->setTimezone(new DateTimeZone($this->Place->Region->timezone)); $key = $Date->getTimestamp(); $Now = new DateTime(); $Now->setTimezone(new DateTimeZone($this->Place->Region->timezone)); $item = array("to" => array("stop_id" => $row['run']['destination_id'], "stop_name" => $row['run']['destination_name']), "leaving" => array("utc" => $row['time_timetable_utc'], "local" => $Date->format(DateTime::ISO8601), "local_nice" => $Date->format("F j, g:i a"), "relative" => time2str($Date->getTimestamp(), $Now->getTimestamp())), "route" => array("name" => $row['platform']['direction']['line']['line_name'], "id" => $row['platform']['direction']['line']['line_id'], "number" => $row['platform']['direction']['line']['line_number']), "direction" => array("id" => $row['platform']['direction']['direction_id'], "name" => $row['platform']['direction']['direction_name'])); $return[$key] = $item; } } } return $return; }
/** * Get feedback items assigned to this user * @since Version 3.9 * @return array */ public function getAssignedItems() { if (!$this->Staff instanceof User) { throw new Exception("You must assign a valid User object before fetching assigned feedback items"); } $query = "SELECT f.*, fs.name AS status_text, fa.feedback_title AS area_text\r\n FROM feedback AS f \r\n INNER JOIN feedback_status AS fs ON f.status = fs.id\r\n INNER JOIN feedback_area AS fa ON f.area = fa.feedback_id\r\n WHERE f.assigned_to = ?\r\n ORDER BY f.time DESC"; $return = array(); foreach ($this->db->fetchAll($query, $this->Staff->id) as $row) { $date = new DateTime(sprintf("@%s", $row['time'])); $data = array("id" => $row['id'], "message" => $row['message'], "date" => array("absolute" => $date->format("Y-m-d H:i:s"), "relative" => time2str($row['time'])), "area" => array("id" => $row['area'], "text" => $row['area_text']), "status" => array("id" => $row['status'], "text" => $row['status_text']), "author" => array("id" => false, "username" => false, "realname" => false, "email" => $row['email'])); if (filter_var($row['user_id'], FILTER_VALIDATE_INT) && $row['user_id'] > 0) { $Author = new User($row['user_id']); $data['author']['id'] = $Author->id; $data['author']['username'] = $Author->username; $data['author']['realname'] = $Author->real_name; $data['author']['url'] = $Author->url->url; $data['author']['avatar'] = array("large" => format_avatar($Author->avatar, 120), "small" => format_avatar($Author->avatar, 40)); } $return[] = $data; } return $return; }
"><?php echo time2str($t->dt); ?> </a> </td> <td> <?php echo twitterfy($t->body); ?> <br> <span style="font-size:80%;"> <?php if ($t->replied_to) { ?> Replied to <?php echo time2str($t->reply_date); ?> <?php } else { ?> <a href="tweets.php?id=<?php echo $app_id; ?> &reply=<?php echo $t->id; ?> ">Reply</a> <?php } ?> </span>
$ticketInformation = "Information: To use this card, please connect <br/>" . "your device to the nearest ssid. Open your web <br/>" . "browser and enter each needed field."; $ticketLogoFile = "/images/daloradius_small.png"; if (isset($_REQUEST['type']) && $_REQUEST['type'] == "batch") { $format = $_REQUEST['format']; $plan = $_REQUEST['plan']; // accounts is a string with the format of "username1,password1||username2,password2||..." $accounts_temp = $_REQUEST['accounts']; $accounts = explode("||", $accounts_temp); include_once '../../library/opendb.php'; include_once '../management/pages_common.php'; $sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planCost AS planCost, " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planTimeBank AS planTimeBank, " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planCurrency AS planCurrency " . " FROM " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . " WHERE " . $configValues['CONFIG_DB_TBL_DALOBILLINGPLANS'] . ".planName=" . " '{$plan}' "; $res = $dbSocket->query($sql); $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $ticketCurrency = $row['planCurrency']; $ticketCost = $row['planCost'] . " " . $ticketCurrency; $ticketTime = time2str($row['planTimeBank']); printTicketsHTMLTable($accounts, $ticketCost, $ticketTime); } function printTicketsHTMLTable($accounts, $ticketCost, $ticketTime) { $output = ""; global $ticketInformation; global $ticketLogoFile; // the $accounts array contain the username,password|| first element as it's originally // used to be a for CSV table header array_shift($accounts); // we align 3 tables for each row (each line) // for each 4th entry of a new ticket table we put it in a new row of it's own $trCounter = 0; foreach ($accounts as $userpass) { list($user, $pass) = split(",", $userpass);
</thead> <tbody> <?php $query = $dbConn->prepare("SELECT `id`, `name`, `hidden`, `rank`, `lastMatch`, `teamCount`, `team1`, `team2`, `team3`, `team4`, `team5`" . "FROM `player_information`" . $conditions . "ORDER BY {$orderByVal} {$orderByOrder} " . "LIMIT {$lowerLimit}, {$upperLimit}"); $query->execute(); $result = $query->get_result(); while ($row = $result->fetch_assoc()) { print "<tr class=\"tableRow\" id=\"tableRow{$row['id']}\">"; print '<td>' . "<a target=\"_blank\" href=\"http://lan.op.gg/summoner/userName={$row['name']}\">" . $row['name'] . '</td>'; print '<td>' . $row['rank'] . '</td>'; ?> <?php if ($row['lastMatch'] == "0000-00-00 00:00:00") { print '<td><a data-toggle="tooltip" data-placement="top" title="No games on record">Not available</a></td>'; } else { print '<td><a data-toggle="tooltip" data-placement="top" title="' . date("F j, Y, g:i a", strtotime($row['lastMatch'])) . '">' . time2str($row['lastMatch']) . '</a></td>'; } ?> <td> <?php if ($row['teamCount'] > 0) { ?> <ul> <?php for ($i = 1; $i <= $row['teamCount']; $i++) { print "<li>{$row["team{$i}"]}</li>"; } ?> </ul> <?php } else {
public function strLastReleaseDate() { $db = Database::getDatabase(); $dt = $db->getValue("SELECT dt FROM shine_versions WHERE app_id = '{$this->id}' ORDER BY dt DESC LIMIT 1"); return time2str($dt); }
$content .= '<tr align="left"><td>' . $rak[$row[type]][name] . '</td><td style="width:55px"><center>' . countdown($row[fertigstellung] - date(U)) . '</center></td></tr>'; $stop = $row[fertigstellung]; } } else { if ($row[type] >= 1 and $row[type] <= 15) { $content .= '<tr align="left"><td>' . $einh[$row[type]][name] . '</td><td style="width:55px"><center>' . time2str($row[fertigstellung] - date(U)) . '</center></td></tr>'; $stop = $row[fertigstellung]; } if ($row[type] >= 1001 and $row[type] <= 1011) { $row[type] -= 1000; $content .= '<tr align="left"><td>' . $def[$row[type]][name] . '</td><td style="width:55px"><center>' . time2str($row[fertigstellung] - date(U)) . '</center></td></tr>'; $stop = $row[fertigstellung]; } if ($row[type] >= 2001 and $row[type] <= 2006) { $row[type] -= 2000; $content .= '<tr align="left"><td>' . $rak[$row[type]][name] . '</td><td style="width:55px"><center>' . time2str($row[fertigstellung] - date(U)) . '</center></td></tr>'; $stop = $row[fertigstellung]; } } $row = mysql_fetch_array($result); } while ($row); $content .= '</table>'; } // forschungen for ($i = $forschung['feuerwaffen']; $i > 0; $i--) { $content = str_replace('Feuerwaffen ' . $forschung['feuerwaffen'] . '/' . $i . ' ', '<font color="green">Feuerwaffen ' . $forschung['feuerwaffen'] . '/' . $i . ' </font>', $content); } for ($i = $forschung['sprengstoff']; $i > 0; $i--) { $content = str_replace('Sprengstoff ' . $forschung['sprengstoff'] . '/' . $i . ' ', '<font color="green">Sprengstoff ' . $forschung['sprengstoff'] . '/' . $i . ' </font>', $content); } for ($i = $forschung['raketen']; $i > 0; $i--) {
$content .= '<br/><br/><b>' . $l['all']['NASMAC'] . ':</b> ' . $row['mac']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => '<b>' . $row['hotspotname'] . '</b>', 'divId' => '')); echo "\n\t\t\t<tr>\n\t\t\t\t<td>\n\t\t\t\t\t{$str}\n\t\t\t\t</td>\n\t\t\t\n\t\t\t\t<td>" . $row['firmware'] . "\n\t\t\t\t\t<br/>" . $row['firmware_revision'] . "\n\t\t\t\t</td>\n\t\t\t"; $content = '<b>' . $l['all']['WanIface'] . ":</b> " . $row['wan_iface'] . "<br/>" . '<b>' . $l['all']['WanMAC'] . ":</b> " . $row['wan_mac'] . "<br/>" . '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip'] . "<br/>" . '<b>' . $l['all']['WanGateway'] . ":</b> " . $row['wan_ip']; $value = '<b>' . $l['all']['WanIP'] . ":</b> " . $row['wan_ip']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; $content = $l['all']['LanIface'] . ":</b> " . $row['lan_iface'] . "<br/><b>" . $l['all']['LanMAC'] . ":</b> " . $row['lan_mac'] . "<br/><b>" . $l['all']['LanIP'] . ":</b> " . $row['lan_ip']; $value = '<b>' . $l['all']['LanIP'] . ":</b> " . $row['lan_ip']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; $content = $l['all']['WifiIface'] . ":</b> " . $row['wifi_iface'] . "<br/><b>" . $l['all']['WifiMAC'] . ":</b> " . $row['wifi_mac'] . "<br/><b>" . $l['all']['WifiIP'] . ":</b> " . $row['wifi_ip'] . "<br/><b>" . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key'] . "<br/><b>" . $l['all']['WifiChannel'] . ":</b> " . $row['wifi_channel']; $value = '<b>' . $l['all']['WifiSSID'] . ":</b> " . $row['wifi_ssid'] . "<br/><b>" . $l['all']['WifiKey'] . ":</b> " . $row['wifi_key']; $str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['time'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t"; /* printqn(" <td> <input type='checkbox' name='username[]' value='$row[0]'>$row[2]</td> <td> "); if ( ($row[1] == "Reject") && ($row[4] == "Auth-Type") ) echo "<img title='user is disabled' src='images/icons/userStatusDisabled.gif' alt='[disabled]'>"; else echo "<img title='user is enabled' src='images/icons/userStatusActive.gif' alt='[enabled]'>"; printqn(" <a class='tablenovisit' href='javascript:return;'
/** * Get photos as an associative array * @since Version 3.9.1 * @return array * @param boolean $force */ public function getPhotosAsArray($force = null) { $key = sprintf("railpage:comp=%d;images.array", $this->id); $this->Memcached = AppCore::getMemcached(); if ($force == null && ($photos = $this->Memcached->fetch($key))) { return $photos; } $photos = array(); foreach ($this->getPhotos() as $Submission) { $photos[] = array("id" => $Submission->id, "url" => $Submission->url->getURLs(), "image" => $Submission->Image->getArray(), "author" => array("id" => $Submission->Author->id, "username" => $Submission->Author->username, "url" => $Submission->Author->url instanceof Url ? $Submission->Author->url->getURLs() : array("url" => $Submission->Author->url)), "dateadded" => array("absolute" => $Submission->DateAdded->format("Y-m-d H:i:s"), "relative" => function_exists("time2str") ? time2str($Submission->DateAdded->getTimestamp()) : null)); } $this->Memcached->save($key, $photos); return $photos; }
} } echo "<thread> <tr>\n\t\t<th scope='col'>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=attribute&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Attribute'] . "</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=maxtimeexpiration&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['MaxTimeExpiration'] . "</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=usedtime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['UsedTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> " . $l['all']['Status'] . " </th>\n\t\t<th scope='col'> " . $l['all']['Usage'] . " </th>\n\t\t</tr> </thread>"; while ($row = $res->fetchRow()) { $status = "Active"; if ($row[1] == "Expiration") { if (datediff('d', $row[2], "{$currdate}", false) > 0) { $status = "Expired"; } } if ($row[1] == "Max-All-Session") { if ($row[3] >= $row[2]) { $status = "End"; } } printqn("<tr>\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['0']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-edit.php?username={$row['0']}\">\n {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['0']}</a>\n </td>\n\n <td> {$row['1']} </td>\n <td> {$row['2']} </td>\n <td>" . time2str($row[3]) . "</td>\n <td> {$status} </td>\n\t\t\t<td> "); if ($row[1] == "Expiration") { $difference = datediff('d', $row[2], "{$currdate}", false); if ($difference > 0) { echo "<h100> " . " {$difference} days since expired" . "</h100> "; } else { echo substr($difference, 1) . " days until expiration"; } } if ($row[1] == "Max-All-Session") { if ($status == "End") { echo "<h100> " . abs($row[2] - $row[3]) . " seconds overdue credit" . "</h100>"; } else { echo $row[2] - $row[3]; echo " left on credit"; }
$orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&ratename={$ratename}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&ratename={$ratename}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&ratename={$ratename}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['LastLoginTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&ratename={$ratename}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t " . $l['all']['Billed'] . "\n\t\t</th>\n </tr> </thread>"; $sumBilled = 0; $sumSession = 0; while ($row = $res->fetchRow()) { $sessionTime = $row[3]; $rateCost = $row[4]; $billed = $sessionTime / $rateDivisor * $rateCost; $sumBilled += $billed; $sumSession += $sessionTime; echo "<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t\t\t<td> {$row['1']} </td>\n\t\t\t\t<td> {$row['2']} </td>\n\t\t\t\t<td> " . time2str($row[3]) . " </td>\n\t\t\t\t<td> " . number_format($billed, 2) . " </td>\n\t\t</tr>"; } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&ratename={$ratename}&startdate={$startdate}&enddate={$enddate}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>
I\'m sorry, but my premium account isn\'t active anymore.<br /> Please try again later, maybe I have then premium again.'; } } echo ' <div class="ui-widget" style="width:500px;"> <div class="ui-state-error ui-corner-all" style="padding: 0 .7em;"> <p> <span class="ui-icon ui-icon-alert" style="float: left; margin-right: .3em;"></span> ' . $alertmsg . ' </p> </div> </div> '; } else { echo 'Traffic left: ' . round($info['traffic'] / 1024 / 1024 / 1024, 2) . ' GB • Premium expires on <span title="' . time2str($info['expire'] - time()) . ' left">' . date("d.m.Y H:i", $info['expire']) . '</span><br /><hr style="width:400px;">'; ?> <br /> <span id="message"> <?php if (count($dlFiles) > 0) { if (true) { echo '<font color="green">Great, your Batch download is Ready!<br />'; foreach ($dlFiles as $dlFile) { $link = $dlFile[0]; $name = $dlFile[1]; if (strpos($link, "#F#") === false) { echo '<a style="color: green" target="_blank" href="' . $link . '" onclick="started();">' . $name . '</a></font><br>' . "\n"; } else { echo '<a style="color: red">' . $name . ' failed!</a></font><br>' . "\n";
<table class="lines"> <thead> <tr> <td>Date</td> <td>Name</td> <td>Email</td> <td>App Name</td> </tr> </thead> <tbody> <?php foreach ($orders as $o) { ?> <tr> <td><?php echo time2str($o->dt); ?> </td> <td><a href="order.php?id=<?php echo $o->id; ?> "><?php echo utf8_encode($o->first_name); ?> <?php echo utf8_encode($o->last_name); ?> </a></td> <td><a href="mailto:<?php echo $o->payer_email; ?>
} if (!$clan1) { $clan1['tag'] = '<font class="red">aufgelöst</font>'; } if (!$clan2) { $clan2['tag'] = '<font class="red">aufgelöst</font>'; } if ($clan1['aufgeloest'] >= 1) { $clan1['tag'] = '<font class="red">' . $clan1['tag'] . '</font>'; } if ($clan2['aufgeloest'] >= 1) { $clan2['tag'] = '<font class="red">' . $clan2['tag'] . '</font>'; } $i++; $newpiece = tag2value('id', $row['id'], $piece); $newpiece = tag2value('start', time2str($row['ended'] - $row['started']), $newpiece); $newpiece = tag2value('clan1', '<a href="claninfo.php?' . SID . '&clan=' . $clan1['clanid'] . '">' . $clan1['tag'] . '</a>', $newpiece); $newpiece = tag2value('kp1', $row['kampfpunkte1'], $newpiece); $newpiece = tag2value('pluenderung1', $row['ressis1'], $newpiece); $newpiece = tag2value('clan2', '<a href="claninfo.php?' . SID . '&clan=' . $clan2['clanid'] . '">' . $clan2['tag'] . '</a>', $newpiece); $newpiece = tag2value('kp2', $row['kampfpunkte2'], $newpiece); $newpiece = tag2value('pluenderung2', $row['ressis2'], $newpiece); $ranking2 .= $newpiece; } } while ($row); } else { $ranking2 = '<tr><td colspan="8"><center><a href="clanwars.php?archiv=1&' . SID . '">Klicke hier um die beendeten Clanwars anzuzeigen.</a></center></td></tr>'; } // get page html $template .= template('clanwars'); $template = tag2value('ranking', $ranking, $template);
<tr align="center"><td style="width:150px">Geschwindigkeit</td><td style="width:150px"><select name="speed" size="1" style="border:0; width:150px; height:20px" onchange="berechne()"> <option value="100" ' . $speedstep100 . '>100%</option> <option value="90" ' . $speedstep90 . '>90%</option> <option value="80" ' . $speedstep80 . '>80%</option> <option value="70" ' . $speedstep70 . '>70%</option> <option value="60" ' . $speedstep60 . '>60%</option> <option value="50" ' . $speedstep50 . '>50%</option> <option value="40" ' . $speedstep40 . '>40%</option> <option value="30" ' . $speedstep30 . '>30%</option> <option value="20" ' . $speedstep20 . '>20%</option> <option value="10" ' . $speedstep10 . '>10%</option> </select></td></tr> <tr align="center"><td style="width:150px">Einheiten</td><td style="width:150px">' . $anzahl . '</td></tr> <tr align="center"><td style="width:150px">Entfernung</td><td style="width:150px"><a id="entfernung" name="entfernung">' . $entfernung * 2.5 . '</a> km</td></tr> <tr align="center"><td style="width:150px">Geschwindigkeit</td><td style="width:150px"><div id="s">' . $maxspeed . '.00 km/h</div></td></tr> <tr align="center"><td style="width:150px">Dauer</td><td style="width:150px"><div id="d">' . time2str(felder2time($entfernung * 10 / $maxspeed) - 3600) . '<br />+1:00:00<br />=' . time2str(felder2time($entfernung * 10 / $maxspeed)) . '</div></td></tr> <tr align="center"><td style="width:150px">Gesamtplatz</td><td style="width:150px">' . $platz . '</td></tr> <tr align="center"><td style="width:150px">Verbrauch in Liter</td><td style="width:150px"><div id="v1">' . $verbrauch . ' Liter</div></td></tr> <tr align="center"><td style="width:150px">Verbrauch in Einh.</td><td style="width:150px"><div id="v2">' . $verbrauch_einh . ' Einh.</div></td></tr> <tr align="center"><td style="width:150px">Eisen</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="eisen" value="' . $_POST['eisen'] . '" style="border:0; width:150px; height:14px;"></td></tr> <tr align="center"><td style="width:150px">Titan</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="titan" value="' . $_POST['titan'] . '" style="border:0; width:150px; height:14px"></td></tr> <tr align="center"><td style="width:150px">Oel</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="oel" value="' . $_POST['oel'] . '" style="border:0; width:150px; height:14px"></td></tr> <tr align="center"><td style="width:150px">Uran</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="uran" value="' . $_POST['uran'] . '" style="border:0; width:150px; height:14px"></td></tr> <tr align="center"><td style="width:150px">Gold</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="gold" value="' . $_POST['gold'] . '" style="border:0; width:150px; height:14px"></td></tr> <tr align="center"><td style="width:150px">Chanje</td><td class="input"><input onChange="berechne();" onkeyup="berechne();" type="text" name="chanje" value="' . $_POST['chanje'] . '" style="border:0; width:150px; height:14px"></td></tr> <tr align="center"><td style="width:150px">Restplatz</td><td style="width:150px;' . $red . '"><div id="w">' . round($restplatz, 0) . '</div></td></tr> </table> <br /> <input type="submit" name="starten" value="Mission starten"> <input type="hidden" name="action" value="mission" /> <input type="hidden" name="anz1" value="' . $_POST['anz1'] . '" />
/** * Get detailed information about this file * @since Version 3.9.1 * @return array */ public function getDetails() { $mckey = sprintf("%s;details", $this->mckey); if (!($data = $this->Memcached->fetch($mckey))) { if (empty($this->mime) && file_exists(RP_DOWNLOAD_DIR . $this->filepath)) { $finfo = finfo_open(FILEINFO_MIME_TYPE); $this->mime = finfo_file($finfo, RP_DOWNLOAD_DIR . $this->filepath); } $mime = explode("/", $this->mime); $data = array("type" => ucwords($mime[0]), "size" => $this->filesize, "downloads" => $this->hits, "added" => array("absolute" => $this->Date->format("Y-m-d g:i:s a"), "relative" => time2str($this->Date->getTimestamp())), "thumbnail" => $this->getThumbnail(), "video" => $this->getHTML5Video()); $this->Memcached->save($mckey, $data, strtotime("+12 hours")); } return $data; }
$words = explode(" ", $tweet->text); $totalWords = sizeof($words); //print_r($tweet); // SUPAR HACK to determine if it's a question foreach ($words as $word) { // Skip hashtags if (substr($word, 0, 1) == "#") { continue; } $isquestion = substr($word, -1) == "?"; } // Skip non-questions if (!$isquestion) { continue; } print "<tr><td style=\"width:5%\">" . $count . " <a href=\"?upvote&voteid=" . $tweet->id . (isset($_GET['q']) ? "&q=" . urlencode($_GET['q']) : "") . "\">+</a>/<a href=\"?downvote&voteid=" . $tweet->id . (isset($_GET['q']) ? "&q=" . urlencode($_GET['q']) : "") . "\">-</a></td><td style=\"width:50%\"><a href=\"?qid=" . $tweet->id . "&sname=" . $tweet->user->screen_name . "\">" . $tweet->text . "</a> (" . time2str($tweet->created_at) . ")<br />"; //$count++; //print("<form><input type=\"text\" name=\"answer_1\" size=\"50\" margin-bottom=\"5\"><br />"); //print("<button type=\"button\" class=\"btn btn-xs btn-info\" style=\"margin: 5px 1px\">Reply</button>"); //print("<button type=\"button\" class=\"btn btn-xs btn-default\" style=\"margin: 5px 1px\">Clear</button></td>"); print "<td style=\"width:10%\"><a href=\"http://twitter.com/" . $tweet->user->screen_name . "\">@" . $tweet->user->screen_name . "</a></td>"; // Populate Tags column print "<td style=\"word-wrap: break-word; width:30%\"><h4>"; $tagcount = 0; for ($j = 0; $j < $totalWords; $j++) { // Remove all special characters //$stripped = preg_replace('/[^a-z]/i', '', $words[$j]); //print($stripped . "<br />"); // Check if the words are hashtags if (substr($words[$j], 0, 1) == "#") { $tagcount++;
foreach ($pirates as $p) { ?> <tr> <td><a href="http://www.geobytes.com/IpLocator.htm?GetLocation&ipaddress=<?php echo $p['ip']; ?> "><?php echo $p['ip']; ?> </a></td> <td><?php echo $p['guid']; ?> </td> <td><?php echo time2str($p['dt']); ?> </td> </tr> <?php } ?> </tbody> </table> </div> </div> </div></div> </div> <div id="sidebar" class="yui-b"> <div class="block">
<mark> <?php echo T_($row['category']); ?> <!-- --></mark>, </span> <span class="lang"> <?php $str = sprintf(T_('<mark>%s</mark>에서 <mark>%s</mark>로,'), T_($row['lang_from']), T_($row['lang_to'])); echo $str; ?> </span> <span> <?php echo time2str($row['date']); ?> <?php $user = fetch_first_row('SELECT * FROM users WHERE ID = ?', 'i', $row['author']); echo "<a href='/profile.php?id=" . $user['ID'] . "'>" . $user['user_nickname'] . "</a>"; ?> </span> </div> </section> </article> <?php } ?> </div> <ul class="pagination"> <?php
/** * Get stories from topic * @version 3.0 * @since Version 3.0 * @return mixed * @param int $page * @param int $limit * @param boolean $total */ public function stories($page = 0, $limit = 25, $total = true) { $return = false; $mckey = "railpage:topic_id=" . $this->id . ".stories.page=" . $page . ".limit=" . $limit . ".total=" . (int) $total; $mcexp = strtotime("+1 hour"); if (!($return = getMemcacheObject($mckey))) { // Get it from Sphinx $Sphinx = $this->getSphinx(); $query = $Sphinx->select("*")->from("idx_news_article")->orderBy("story_time_unix", "DESC")->limit($page * $limit, $limit)->where("topic_id", "=", $this->id); $matches = $query->execute(); $meta = $Sphinx->query("SHOW META"); $meta = $meta->execute(); if (is_array($matches) && count($matches)) { $return = array("total" => $meta[1]['Value'], "children" => array(), "page" => $page, "perpage" => $limit, "topic_id" => $this->id); foreach ($matches as $id => $row) { $row['time_relative'] = time2str($row['story_time_unix']); $row['time'] = $row['story_time']; $row['title'] = format_topictitle($row['story_title']); // Match the first sentence $line = explode("\n", $row['story_blurb']); $row['firstline'] = preg_replace('/([^?!.]*.).*/', '\\1', strip_tags($line[0])); if (empty($row['story_slug'])) { $row['slug'] = $this->createSlug($row['story_id']); } $row['url'] = $this->makePermaLink($row['story_slug']); $row['hometext'] = $row['story_blurb']; $row['bodytext'] = $row['story_body']; $row['featured_image'] = $row['story_image']; $row['informant'] = $row['username']; $return['children'][$id] = $row; } } } if (!isset($return) || $return === false || !is_array($return)) { $query = "SELECT SQL_CALC_FOUND_ROWS s.*, t.topicname, t.topicimage, t.topictext, u.user_id AS informant_id FROM nuke_stories AS s LEFT JOIN nuke_topics AS t ON s.topic = t.topicid LEFT JOIN nuke_users AS u ON s.informant = u.username WHERE s.topic = ? AND s.approved = ? ORDER BY s.time DESC LIMIT ?, ?"; $return = array(); $return['total'] = 0; $return['children'] = array(); $return['page'] = $page; $return['perpage'] = $limit; $return['topic_id'] = $this->id; if ($result = $this->db_readonly->fetchAll($query, array($this->id, "1", $page * $limit, $limit))) { $return['total'] = $this->db_readonly->fetchOne("SELECT FOUND_ROWS() AS total"); foreach ($result as $row) { if (function_exists("relative_date")) { $row['time_relative'] = relative_date(strtotime($row['time'])); } else { $row['time_relative'] = $row['time']; } $row['title'] = format_topictitle($row['title']); // Match the first sentence $line = explode("\n", $row['hometext']); $row['firstline'] = preg_replace('/([^?!.]*.).*/', '\\1', strip_tags($line[0])); if (empty($row['slug'])) { $row['slug'] = $this->createSlug($row['sid']); } $row['url'] = $this->makePermaLink($row['slug']); $return['children'][] = $row; } } setMemcacheObject($mckey, $return, $mcexp); } return $return; }
$content = tag2value('titanmine_titan', $kosten[titanmine][titan] * ($row[titanmine] * $row[titanmine]), $content); $content = tag2value('titanmine_oel', $kosten[titanmine][oel] * ($row[titanmine] * $row[titanmine]), $content); $content = tag2value('titanmine_uran', $kosten[titanmine][uran] * ($row[titanmine] * $row[titanmine]), $content); $content = tag2value('titanmine_gold', $kosten[titanmine][gold] * ($row[titanmine] * $row[titanmine]), $content); $content = tag2value('titanmine_chanje', $kosten[titanmine][chanje] * ($row[titanmine] * $row[titanmine]), $content); $content = tag2value('titanmine_dauer', time2str($kosten[titanmine][zeit] * $row[titanmine]), $content); $content = tag2value('titanmine_bauen', $bauen[titanmine], $content); $content = tag2value('lvl_oelpumpe', $row[oelpumpe] - 1, $content); $content = tag2value('oelpumpe_eisen', $kosten[oelpumpe][eisen] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_titan', $kosten[oelpumpe][titan] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_oel', $kosten[oelpumpe][oel] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_uran', $kosten[oelpumpe][uran] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_gold', $kosten[oelpumpe][gold] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_chanje', $kosten[oelpumpe][chanje] * ($row[oelpumpe] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_dauer', time2str($kosten[oelpumpe][zeit] * $row[oelpumpe]), $content); $content = tag2value('oelpumpe_bauen', $bauen[oelpumpe], $content); $content = tag2value('lvl_uranmine', $row[uranmine] - 1, $content); $content = tag2value('uranmine_eisen', $kosten[uranmine][eisen] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_titan', $kosten[uranmine][titan] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_oel', $kosten[uranmine][oel] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_uran', $kosten[uranmine][uran] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_gold', $kosten[uranmine][gold] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_chanje', $kosten[uranmine][chanje] * ($row[uranmine] * $row[uranmine]), $content); $content = tag2value('uranmine_dauer', time2str($kosten[uranmine][zeit] * $row[uranmine]), $content); $content = tag2value('uranmine_bauen', $bauen[uranmine], $content); // generierte seite ausgeben if ($running) { $onload = 'startCountdown();'; } $content = tag2value("onload", $onload, $content); echo $content . template('footer');
function userConnectionStatus($username, $drawTable) { $userStatus = checkUserOnline($username); include_once 'include/management/pages_common.php'; include 'library/opendb.php'; $username = $dbSocket->escapeSimple($username); // sanitize variable for sql statement $sql = "SELECT AcctStartTime,AcctSessionTime,NASIPAddress,CalledStationId,FramedIPAddress,CallingStationId" . ",AcctInputOctets,AcctOutputOctets FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " WHERE Username='******' ORDER BY RadAcctId DESC LIMIT 1"; $res = $dbSocket->query($sql); $row = $res->fetchRow(DB_FETCHMODE_ASSOC); $userUpload = toxbyte($row['AcctInputOctets']); $userDownload = toxbyte($row['AcctOutputOctets']); $userLastConnected = $row['AcctStartTime']; $userOnlineTime = time2str($row['AcctSessionTime']); $nasIPAddress = $row['NASIPAddress']; $nasMacAddress = $row['CalledStationId']; $userIPAddress = $row['FramedIPAddress']; $userMacAddress = $row['CallingStationId']; include 'library/closedb.php'; if ($drawTable == 1) { echo "<table border='0' class='table1'>"; echo "\r\n \t\t<thead>\r\n \t\t\t<tr>\r\n \t <th colspan='10' align='left'> \r\n \t\t\t\t<a class=\"table\" href=\"javascript:toggleShowDiv('divConnectionStatus')\">Session Info</a>\r\n \t </th>\r\n \t </tr>\r\n \t\t</thead>\r\n \t\t</table>\r\n \t"; echo "\r\n <div id='divConnectionStatus' style='display:none;visibility:visible'>\r\n \t\t<table border='0' class='table1'>\r\n \t\t<thread>\r\n\r\n <tr> \r\n <th scope='col' align='right'>\r\n User Status\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userStatus}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Last Connection \r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userLastConnected}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Online Time\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userOnlineTime}\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n Server (NAS)\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$nasIPAddress} (MAC: {$nasMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Workstation\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userIPAddress} (MAC: {$userMacAddress})\r\n </th>\r\n </tr>\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Upload\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userUpload}\r\n </th>\r\n </tr>\r\n\r\n\r\n <tr>\r\n <th scope='col' align='right'>\r\n User Download\r\n </th> \r\n \r\n <th scope='col' align='left'>\r\n {$userDownload}\r\n </th>\r\n </tr>\r\n\r\n </table>\r\n\r\n \t\t</div>\r\n \t"; } }
?> <div class="profile-story"> <h2><?php echo anchor('stories/view/' . $story->id, $story->headline); ?> </h2> <h3> <div class="dashboard-actions right"> <a href="#" class="display-stats">Stats</a> <a href="">Edit Story</a> <?php echo anchor('stories/delete/' . $story->id, 'Delete Story', ['data-reveal-id' => 'confirm-modal', 'data-reveal-ajax' => 'true']); ?> </div> Authored <em><?php echo time2str($story->date_created); ?> </em>. Happening in <a href=""><?php echo $story->state; ?> </a> </h3> <div class="stats"> <?php $sum = $story->upvote + $story->downvote; ?> <?php $score = $sum == 0 ? 0 : $story->upvote / $sum * 100; ?> <h1>Score: <?php echo $score;
$str = addToolTipBalloon(array('content' => $content, 'onClick' => '', 'value' => $value, 'divId' => '')); echo "<td> {$str} </td>"; // calculate time delay $currTime = time(); $checkinTime = strtotime($row['time']); if ($currTime - $checkinTime >= 60 * $hardDelay) { // this is hard delay $delayColor = 'red'; } elseif ($currTime - $checkinTime >= 60 * $softDelay && $currTime - $checkinTime < 60 * $hardDelay) { // this is soft delay $delayColor = 'orange'; } else { // this is no delay at all, meaning not above 5 minutes delay $delayColor = 'green'; } echo "\n\t\t\t\t<td>" . time2str($row['uptime']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . $row['cpu'] . "\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t\t<td>" . $row['memfree'] . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bup']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td>" . toxbyte($row['wan_bdown']) . "\n\t\t\t\t</td>\n\n\t\t\t\t<td> <font color='{$delayColor}'> " . $row['time'] . "\n\t\t\t\t\t</font>\n\t\t\t\t</td>\n\t\t\t\t\n\t\t\t</tr>\n\t\t"; } echo "\n\t\t\t\t\t<tfoot>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th colspan='11' align='left'> \n\t"; setupLinks($pageNum, $maxPage, $orderBy, $curOrderType); echo "\t\t\t\t\t\t\t</th>\n\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t</tfoot>\n\t\t"; echo "</table>"; echo "</form>"; include 'library/closedb.php'; ?> <?php include 'include/config/logging.php'; ?>
echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); } echo " </th></tr>\n\t\t\t</thead>\n\t"; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderType}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderType}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderType}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderType}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderType}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderType}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderType}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderType}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderType}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\t\t <td> {$row['1']} </td>\n\t <td> {$row['2']} </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>
<td class="milestone"><a href="tickets-milestone.php?id=<?php echo $t->milestone_id; ?> "><?php echo $milestones[$t->milestone_id]->title; ?> </a></td> <td class="assigned-to"><a href="tickets-user.php?id=<?php echo $t->assigned_to; ?> "><?php echo $users[$t->assigned_to]->username; ?> </a></td> <td class="age"><?php echo time2str($t->dt_created); ?> </td> </tr> <?php } ?> </tbody> </table> </div> </div> </div></div> </div> <div id="sidebar" class="yui-b"> <div class="block">
$lastlog_output = bytes2str($lastlog_output); } else { $not_known = 1; } } else { echo "<b>Database query failed: " . da_sql_error($link, $config) . "</b><br>\n"; } } } else { echo "<b>Could not connect to SQL database</b><br>\n"; } $monthly_limit = is_numeric($monthly_limit) ? time2str($monthly_limit) : $monthly_limit; $weekly_limit = is_numeric($weekly_limit) ? time2str($weekly_limit) : $weekly_limit; $daily_limit = is_numeric($daily_limit) ? time2str($daily_limit) : $daily_limit; $session_limit = is_numeric($session_limit) ? time2str($session_limit) : $session_limit; $remaining = is_numeric($remaining) ? time2str($remaining) : $remaining; if ($item_vals['Dialup-Access'][0] == 'FALSE' || !isset($item_vals['Dialup-Access'][0]) && $attrmap['Dialup-Access'] != '' && $attrmap['Dialup-Access'] != 'none') { $msg = <<<EON <font color=red><b> The user account is locked </b></font> EON; } else { $msg = <<<EON user can login for <font color="{$log_color}"> <b>{$remaining} {$extra_msg}</font> EON; } $lock_msg = $item_vals['Dialup-Lock-Msg'][0]; if ($lock_msg != '') { $descr = <<<EON <font color=red><b>{$lock_msg} </b</font> EON; } else {
$sql = "SELECT " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name AS hotspot, count(distinct(UserName)) AS uniqueusers, count(radacctid) AS totalhits, " . " avg(AcctSessionTime) AS avgsessiontime, sum(AcctSessionTime) AS totaltime, " . " avg(AcctInputOctets) AS avgInputOctets, sum(AcctInputOctets) AS sumInputOctets, " . " avg(AcctOutputOctets) AS avgOutputOctets, sum(AcctOutputOctets) AS sumOutputOctets " . " FROM " . $configValues['CONFIG_DB_TBL_RADACCT'] . " JOIN " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . " on (" . $configValues['CONFIG_DB_TBL_RADACCT'] . ".calledstationid LIKE " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".mac) GROUP BY " . $configValues['CONFIG_DB_TBL_DALOHOTSPOTS'] . ".name ORDER BY {$orderBy} {$orderType};"; $res = $dbSocket->query($sql); $logDebugSQL = ""; $logDebugSQL .= $sql . "\n"; echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='10'>" . $l['all']['Records'] . "</th>\n </tr>\n </thead>\n "; if ($orderType == "asc") { $orderType = "desc"; } else { if ($orderType == "desc") { $orderType = "asc"; } } echo "<thread> <tr>\n <th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=hotspot&orderType={$orderType}\">\n\t\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=uniqueusers&orderType={$orderType}\">\n\t\t\t" . $l['all']['UniqueUsers'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totalhits&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalHits'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=avgsessiontime&orderType={$orderType}\">\n\t\t\t" . $l['all']['AverageTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=totaltime&orderType={$orderType}\">\n\t\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumInputOctets&orderType={$orderType}\">\n\t\t\tTotal Uploads</a>\n\t\t\t</th>\n\t\t\t<th scope='col'> \n\t\t\t<br/>\n\t\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?orderBy=sumOutputOctets&orderType={$orderType}\">\n\t\t\tTotal Downloads</a>\n\t\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { echo "<tr>\n <td> {$row['0']} </td>\n <td> {$row['1']} </td>\n <td> {$row['2']} </td>\n <td> " . time2str($row[3]) . " </td>\n <td> " . time2str($row[4]) . " </td>\n\t\t\t<td> " . toxbyte($row[6]) . "</td>\n\t\t\t<td> " . toxbyte($row[8]) . "</td>\n </tr>"; } echo "</table>"; include 'library/closedb.php'; ?> </div> <div class="tabbertab" title="Graph"> <?php echo "<br/><br/><br/><center>"; echo "<img src=\"library/graphs-hotspot-compare-unique-users.php\" /><br/><br/>"; echo "<img src=\"library/graphs-hotspot-compare-hits.php\" /><br/><br/>"; echo "<img src=\"library/graphs-hotspot-compare-time.php\" /><br/><br/>"; echo "</center>";
echo "<table border='0' class='table1'>\n"; echo "\n <thead>\n <tr>\n <th colspan='12' align='left'>\n\n <input class='button' type='button' value='CSV Export'\n onClick=\"javascript:window.location.href='include/management/fileExport.php?reportFormat=csv'\"\n />\n <br/>\n <br/>\n "; if ($configValues['CONFIG_IFACE_TABLES_LISTING_NUM'] == "yes") { setupNumbering($numrows, $rowsPerPage, $pageNum, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); } echo " </th></tr>\n\t\t\t</thead>\n\t"; if ($orderType == "asc") { $orderTypeNextPage = "desc"; } else { if ($orderType == "desc") { $orderTypeNextPage = "asc"; } } echo "<thread> <tr>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=radacctid&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['ID'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=hotspot&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['HotSpot'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=username&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Username'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=framedipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['IPAddress'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstarttime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StartTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctstoptime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['StopTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctsessiontime&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['TotalTime'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctinputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Upload'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctoutputoctets&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['Download'] . " (" . $l['all']['Bytes'] . ")</a>\n\t\t</th>\n\t\t<th scope='col'>\n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=acctterminatecause&orderType={$orderTypeNextPage}\">\n\t\t " . $l['all']['Termination'] . "</a>\n\t\t</th>\n\t\t<th scope='col'> \n\t\t<br/>\n\t\t<a class='novisit' href=\"" . $_SERVER['PHP_SELF'] . "?username={$username}&startdate={$startdate}&enddate={$enddate}&orderBy=nasipaddress&orderType={$orderTypeNextPage}\">\n\t\t" . $l['all']['NASIPAddress'] . "</a>\n\t\t</th>\n </tr> </thread>"; while ($row = $res->fetchRow()) { printqn("<tr>\n\t\t\t\t<td> {$row['0']} </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retHotspotInfo.php\",\"retHotspotGeneralStat\",\"divContainerHotspotInfo\",\"hotspot={$row['1']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-hs-edit.php?name={$row['1']}\">\n {$l['Tooltip']['HotspotEdit']}</a>\n \n <a class=\"toolTip\" href=\"acct-hotspot-compare.php?\">\n {$l['all']['Compare']}</a>\n <br/><br/>\n\n <div id=\"divContainerHotspotInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['1']}</a>\n </td>\n\n <td> <a class='tablenovisit' href='javascript:return;'\n onClick='javascript:ajaxGeneric(\"include/management/retUserInfo.php\",\"retBandwidthInfo\",\"divContainerUserInfo\",\"username={$row['2']}\");\n javascript:__displayTooltip();'\n tooltipText='\n <a class=\"toolTip\" href=\"mng-edit.php?username={$row['2']}\">\n\t {$l['Tooltip']['UserEdit']}</a>\n <br/><br/>\n\n <div id=\"divContainerUserInfo\">\n Loading...\n </div>\n <br/>'\n >{$row['2']}</a>\n </td>\n\t\t\t\t<td> {$row['3']} </td>\n\t\t\t\t<td> {$row['4']} </td>\n\t\t\t\t<td> {$row['5']} </td>\n\t\t\t\t<td> " . time2str($row[6]) . " </td>\n\t\t\t\t<td> " . toxbyte($row[7]) . "</td>\n\t\t\t\t<td> " . toxbyte($row[8]) . "</td>\n\t\t\t\t<td> {$row['9']} </td>\n\t\t\t\t<td> {$row['10']} </td>\n\t\t</tr>"); } echo "\n <tfoot>\n <tr>\n <th colspan='12' align='left'>\n "; setupLinks($pageNum, $maxPage, $orderBy, $orderType, "&username={$username}&startdate={$startdate}&enddate={$enddate}"); echo "\n </th>\n </tr>\n </tfoot>\n "; echo "</table>"; include 'library/closedb.php'; ?> </div> <?php include 'include/config/logging.php'; ?>
/** Actual Functionality - building of member rows! **/ function build_members($usergroup, $start) { global $templates, $mybb, $parser, $plugins, $user; $rowiterator = 0; eval("\$memberlist = \"\";"); foreach ($usergroup->get_members_offset($start, $mybb->settings['rpgsuite_groupranks_perpage']) as $member) { $rowstyle = $rowiterator % 2 ? "trow2" : "trow1"; $user = $member->get_info(); $plugins->run_hooks("groupranks_user"); $user['isleader'] = $member->is_leader(); $lastpost = $member->get_last_icpost(); $user['lasticpost'] = $lastpost ? time2str($lastpost['dateline']) : 'Never'; eval("\$memberlist .= \"" . $templates->get('rpggroupview_noranks_user') . "\";"); $rowiterator++; } return $memberlist; }