echo "<html>\n\t\t\t<head>\n \t\t\t<title>Chimi 1.0 - Print Schedule by Instructor</title>\n \t\t</head>\n \t<html>";
// get university name, semester details
$univ_result = mysql_query("SELECT * FROM University WHERE sessionID = '" . $sessionID . "'");
while ($university = mysql_fetch_assoc($univ_result)) {
echo "<br>";
echo "THE " . strtoupper($university['universityName']);
echo "<br>";
echo 'SEMESTER COURSE LISTING' . "<br><br>";
}
$building_result = mysql_query("SELECT * FROM Building WHERE sessionID='" . $sessionID . "'");
$buildings = mysql_fetch_all($building_result);
$dept_result = mysql_query("SELECT * FROM Department WHERE sessionID='" . $sessionID . "'");
$departments = mysql_fetch_all($dept_result);
for ($i = 0; $i < count($instructors); ++$i) {
$section_result = mysql_query("SELECT * FROM Section WHERE sessionID='" . $sessionID . "' AND instructorID='" . $instructors[$i]["instructorID"] . "'");
$sections = mysql_fetch_all($section_result);
echo $instructors[$i]["lastName"] . ", " . $instructors[$i]["firstName"];
echo "<br><br>";
start_schedule_table();
// only print the sections which belong to the containing department?
for ($j = 0; $j < count($sections); ++$j) {
$roomID = slotID_to_roomID($sections[$j]["slotID"], $num_of_slots_per_room);
$building = binary_search($buildings, "buildingID", $rooms[$roomID]["buildingID"]);
$course = binary_search($courses, "courseID", $sections[$j]["courseID"]);
$available = $sections[$j]["maxEnrollment"] - $sections[$j]["preliminaryEnrollment"];
$dayOfWeek = slotID_to_dayOfWeek($sections[$j]["slotID"], $num_of_slots_per_room, count($periods));
$period = get_period_from_slotID($sections[$j]["slotID"], $num_of_slots_per_room, $periods, count($periods));
$startTime = convert_int_to_standard_time($period["startTime"]);
$endTime = convert_int_to_standard_time($period["endTime"]);
echo "<tr>";
echo "<td>" . $building["buildingAbbr"] . "</td>";
function get_windows()
{
global $NICKNAME;
$o = array();
$r = mysql_fetch_all(mysql_query("SELECT * FROM windows WHERE\n\t\tnickname ='{$NICKNAME}'"));
foreach ($r as $row) {
$o[] = $row['title'];
}
return $o;
}
function csvData($table, $state_name, $col, $key)
{
$query = 'SELECT ' . $col . ' FROM ' . $table . ' WHERE ' . $key . '="' . $state_name . '" LIMIT 1';
$query_result = mysqli_query($query);
if (!$query_result) {
die('Invalid query: ' . mysql_error());
}
$query_result = mysql_fetch_all($query_result);
//$query_result = str_replace("’","'",$query_result); //clean dirty characters
return $query_result[0][$col];
}
function fetch_queue($NICKNAME, $window, $seen = FALSE, $limit = 200)
{
$r = mysql_fetch_all(mysql_query("SELECT * FROM queue WHERE nickname = '{$NICKNAME}' AND window = '{$window}' AND seen = " . ($seen ? 1 : 0) . " ORDER BY id DESC " . ($limit ? "LIMIT {$limit}" : "")));
$startid = $r[count($r) - 1]['id'];
$endid = $r[0]['id'];
if (!$seen) {
mysql_query("UPDATE queue SET seen = 1 WHERE nickname = '{$NICKNAME}' AND window = '{$window}' AND id >= '{$startid}' AND id <= '{$endid}'");
}
krsort($r);
return $r;
}
function mail_entry($to, $subject, $uri, $page)
{
$r = mysql_query("select * from debug where uri = '{$uri}'");
$r = mysql_fetch_all($r);
if (count($r) == 0) {
mail($to, $subject, $uri . "\n" . $page);
print "Mailing {$to} about it...\n";
mysql_query("insert into debug (uri) values('{$uri}')");
/*} else {
print("Already mailed $to\n");*/
}
}
function get_messages($quals = NULL, $table = '')
{
global $messageboard_db, $messageboard_table;
if (!$messageboard_table) {
$messageboard_table = 'messages';
}
if (!$table) {
$ids = $quals;
if (!is_array($ids) or count($ids) == 0) {
return array();
}
} else {
unset($ids);
}
$q = "SELECT {$messageboard_table}.poster AS poster, {$messageboard_table}.subject AS subject,\n\t\t\t{$messageboard_table}.date AS date, {$messageboard_table}.body AS body\n\t\t\tFROM messages " . ($table ? ", {$table}" : "") . ($ids || $quals ? " WHERE " : "") . (is_array($ids) ? "{$messageboard_table}.messageid IN ('" . join("','", $ids) . "')" : "") . (is_array($quals) ? join(' AND ', $quals) : "") . " ORDER BY date";
print "<!-- {$q} -->";
return mysql_fetch_all(mysql_query($q, $messageboard_db));
}
function get_cached_friends($username, $limit = 0)
{
if (!$limit) {
$limit = JOURNAL_FRIENDSENTRIES;
}
$r = mysql_fetch_all(mysql_query("SELECT * FROM cache \n\t\t\t\tINNER JOIN friends ON (friends.uri = cache.friend_uri)\n\t\t\t\tWHERE friends.username = '******' \n\t\t\t\tORDER BY cache.date DESC \n\t\t\t\tLIMIT {$limit}"));
foreach ($r as $key => $row) {
$r[$key]['data'] = $row['body'];
if (ereg('opendiary.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(OD)';
} elseif (ereg('diaryland.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(DL)';
} elseif (ereg('livejournal.com', $r[$key]['friend_uri'])) {
$r[$key]['friend'] .= '(LJ)';
}
unset($r[$key]['body']);
}
return $r;
}
function cart_customer_new($ci)
{
extract($ci);
$id = FALSE;
if (mysql_query("INSERT INTO customers (name) VALUES ('" . $shipping['name'] . "')")) {
if ($r = mysql_query("SELECT last_insert_id() AS id")) {
$r = mysql_fetch_all($r);
$id = $r[0]['id'];
extract($shipping);
if (!mysql_query("INSERT INTO addresses \n\t\t\t\t\t(type, customerid, name, address, phone) VALUES \n\t\t\t\t\t('shipping', '{$id}', '{$name}', '{$address}', '{$phone}')")) {
print mysql_error();
}
extract($billing);
if (!mysql_query("INSERT INTO addresses \n\t\t\t\t\t(type, customerid, name, address, phone) VALUES \n\t\t\t\t\t('billing', '{$id}', '{$name}', '{$address}', '{$phone}')")) {
print mysql_error();
}
} else {
print mysql_error();
}
} else {
print mysql_error();
}
return $id;
}
// connect to database
mysql_connect("localhost", "root", "thebigredmachine") or die(mysql_error());
mysql_select_db("chimi") or die(mysql_error());
// get the session ID
$sessionID = getSessionCookie();
// fetch rooms, periods, courses, and instructors from database
$room_result = mysql_query("SELECT roomNo FROM Room WHERE sessionID='" . $sessionID . "' ORDER BY roomNo");
$rooms = mysql_fetch_all($room_result);
$period_result = mysql_query("SELECT startTime, endTime FROM Period WHERE sessionID='" . $sessionID . "'");
$periods = mysql_fetch_all($period_result);
$course_result = mysql_query("SELECT courseID, courseNo, courseName FROM Course WHERE sessionID='" . $sessionID . "'");
$courses = mysql_fetch_all($course_result);
$instructor_result = mysql_query("SELECT instructorID, firstName, lastName FROM Instructor WHERE sessionID='" . $sessionID . "'");
$instructors = mysql_fetch_all($instructor_result);
$conflict_result = mysql_query("SELECT courseID, instructorID, slotID, sectionID FROM Section WHERE sessionID='" . $sessionID . "' AND slotID=-1");
$conflicts = mysql_fetch_all($conflict_result);
// disconnect from database
mysql_close();
// the number of days
$num_of_days = 5;
// calculate the number of slots per room
$num_of_slots_per_room = count($periods) * $num_of_days;
// setup days of the week
$daysOfWeek = array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday");
?>
<!DOCTYPE html>
<html>
<head>
<title>Chimi 1.0 - Schedule</title>
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_array($result);
if (!$result) {
//A location update for new device
$sql = "INSERT INTO {$table_device_location} VALUES\n\t\t\t\t\t\t\t\t\t(NULL,{$deviceID},'{$time}','{$lat}','{$lng}')";
$result = mysql_query($sql) or die(mysql_error() . $sql);
} else {
$sql = "SELECT id from {$table_device_location} where tid={$deviceID} order by id LIMIT 1";
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_assoc($result);
$LocationID = $result['id'];
$sql = "UPDATE {$table_device_location} SET \n\t\t\t\t\t\t\t\t\t\t\t\tlat='{$lat}',\n\t\t\t\t\t\t\t\t\t\t\t\tlng='{$lng}',\n\t\t\t\t\t\t\t\t\t\t\t\tutime='{$time}'\n\t\t\t\t\t\t\t\t\t\tWHERE id={$LocationID}";
$result = mysql_query($sql) or die(mysql_error() . $sql);
}
}
}
});
$sql = "SELECT cdt.uuid, dl.lat, dl.lng, dl.utime FROM {$table_device_location} dl, {$table_device_info} cdt where cdt.id=dl.tid";
if ($id != '*') {
$sql .= " and tid={$id}";
}
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$result = mysql_query($sql) or die(mysql_error() . $sql);
$result = mysql_fetch_all($result, MYSQL_ASSOC);
mysql_close();
echo json_encode($result);
}
<?php
require_once dirname(__FILE__) . "/../string.php";
require_once dirname(__FILE__) . "/irc.php";
print "<meta http-equiv='refresh' content='15; URL=\"" . purlencode($PHP_SELF) . "?NICKNAME={$NICKNAME}\"' />";
$r = mysql_fetch_all(mysql_query("SELECT * FROM windows WHERE nickname = '{$NICKNAME}'"));
$w = get_windows();
foreach ($w as $window) {
$o .= td("<a href='{$SCRIPT_NAME}/Windows/" . purlencode($window) . "?NICKNAME={$NICKNAME}' target='window'>{$window}</a>");
}
$o .= td("<a href='{$SCRIPT_NAME}/Logoff?NICKNAME={$NICKNAME}' target='_top'>Log Off</a>");
$o .= td("<a href='{$PHP_SELF}?NICKNAME={$NICKNAME}'>Refresh</a>");
print table(tr($o));
public function fetchAll($result)
{
try {
if ($this->config->connector == "mysql") {
return mysql_fetch_all($result, MYSQLI_ASSOC);
} elseif ($this->config->connector == "mysqli") {
return mysqli_fetch_all($result, MYSQLI_ASSOC);
}
} catch (exception $e) {
return $e;
}
}
}
if (count($result) == 0) {
return $default_value;
}
return $result;
}
function get_user_name($userid)
{
$res = sql_query("SELECT `username` , `id` , `class`, `chatpost`, `leechwarn`, `warned`, `pirate`, `king`, `donor`, `enabled` FROM `users` WHERE `id` = {$userid} LIMIT 1") or sqlerr(__FILE__, __LINE__);
$username = mysql_fetch_assoc($res);
return $username;
}
$count1 = get_row_count('events');
$perpage = 15;
$pager = pager($perpage, $count1, 'staffpanel.php?tool=events&action=events&');
$scheduled_events = mysql_fetch_all("SELECT * from `events` ORDER BY `startTime` DESC " . $pager['limit'] . ";", array());
if (is_array($scheduled_events)) {
foreach ($scheduled_events as $scheduled_event) {
if (is_array($scheduled_event) && array_key_exists('startTime', $scheduled_event) && array_key_exists('endTime', $scheduled_event)) {
$startTime = 0;
$endTime = 0;
$overlayText = "";
$displayDates = true;
$startTime = $scheduled_event['startTime'];
$endTime = $scheduled_event['endTime'];
if (time() < $endTime && time() > $startTime) {
if (array_key_exists('overlayText', $scheduled_event)) {
$overlayText = $scheduled_event['overlayText'];
}
if (!is_string($overlayText)) {
$overlayText = "";
print $query_movie . "\n";
}
$query_set = "select * from sets order by strSet";
$query_tag = "select * from tag order by strTag";
$query_taglink = "select idTag, idMedia, c00 as title, c07 as year ";
$query_taglink .= "from taglinks t, movie m where t.idMedia=m.idMovie ";
$query_taglink .= "and idTag={$s_idtag} order by idTag";
$res_movie = mysql_query($query_movie);
$res_set = mysql_query($query_set);
$res_tag = mysql_query($query_tag);
$res_taglink = mysql_query($query_taglink);
$movies = mysql_fetch_all($res_movie);
$sets = mysql_fetch_all($res_set);
$tags = mysql_fetch_all($res_tag);
if ($res_taglink) {
$taglinks = mysql_fetch_all($res_taglink);
}
#####################
# Close DB connections
#####################
mysql_close($link);
}
}
?>
<html>
<HEAD>
<TITLE>XBMC Sets</TITLE>
<LINK REL="stylesheet" HREF="../styles/buttons.css" TYPE="TEXT/CSS">
<LINK REL="stylesheet" HREF="../styles/fields.css" TYPE="TEXT/CSS">
<LINK REL="stylesheet" HREF="../styles/lists.css" TYPE="TEXT/CSS">
<?php
$r = mysql_fetch_all(mysql_query("SELECT * FROM friends WHERE username = '******'"));
print "<div class='controls'>";
if (is_array($r)) {
print "<ul class='friends'><h2>Friends:</h2>";
foreach ($r as $row) {
extract($row);
print "<li class='friend'><span class='name'>{$friend}</span>\n\t\t\t<span class='uri'><a href='{$uri}'>{$uri}</a></span></li>";
}
print '</ul>';
}
print "<div class='toolbar'>";
print "<a href='{$PHP_SELF}/Friends/Add'>Add Friend</a>";
print "</div>";
$r = mysql_fetch_all(mysql_query("SELECT * FROM sidebars WHERE username = '******' ORDER BY title"));
if (is_array($r)) {
print "<ul class='sidebars'><h2>Sidebars:</h2>";
foreach ($r as $row) {
extract($row);
print "<li class='sidebar'><span class='title'>{$title}</span><span class='controls'>" . hyperlink("{$SCRIPT_URI}/Manage/Sidebar/Edit/" . $title, 'Edit') . "</span></li>";
}
print '</ul>';
}
print "</div>";
print "<div class='toolbar'>";
print "<a href='{$PHP_SELF}/Sidebar/Add'>Add Sidebar</a>";
print "</div>";
ob_end_clean();
if (!$action) {
$action = 'latest';
}
//$XMLPREFIX = 'journal:';
if ($action == 'latest') {
//header("Content-type: application/x-php-serialized");
header("Content-type: text/plain");
if (!$limit) {
$limit = 6;
}
$q = "SELECT date, subject, data, contenttype FROM journal WHERE username = '******' ORDER BY date DESC LIMIT {$limit}";
$r = mysql_query($q);
if ($r) {
$r = mysql_fetch_all($r);
$o = array();
foreach ($r as $row) {
$o[] = xmlize_entry($row);
}
print "<{$XMLPREFIX}journal>\n" . join("\n", $o) . "</{$XMLPREFIX}journal>\n";
}
}
exit;
function xmlize_entry($e)
{
global $XMLPREFIX;
extract($e);
return "<{$XMLPREFIX}entry time='{$date}'>\n" . xml_subject($subject) . "\t<{$XMLPREFIX}content type='{$contenttype}'>" . base64_encode($data) . "</{$XMLPREFIX}content>\n" . "</{$XMLPREFIX}entry>\n";
}
function xml_subject($s)
<div id="text">
<h1>Welcome</h1>
<?php
require_once "conn.php";
$qry = "SELECT * FROM it_issue";
$res = mysql_query($qry);
function mysql_fetch_all($res)
{
while ($row = mysql_fetch_array($res)) {
$return[] = $row;
}
return $return;
}
$allmax = "40";
function create_table($dataArr)
{
echo "<div>";
for ($j = 0; $j < count($dataArr); $j++) {
echo "<div class=\"field\">" . $dataArr[$j] . "  </div>";
}
echo "</div><br>";
}
$all = mysql_fetch_all($res);
for ($i = 0; $i < count($all); $i++) {
create_table($all[$i]);
}
mysql_close($con);
?>
</div>
</div>
<?php
if ($REQUEST_METHOD == 'POST') {
if ($data) {
$q = "REPLACE INTO sidebars (title, data, username) \n\t\t\t\tVALUES ('{$sidebar}', '{$data}', '" . JOURNAL_USERNAME . "')";
if (mysql_query($q)) {
print "Updated.";
} else {
print mysql_error();
}
} else {
print "You have to enter /something/.";
}
} else {
$r = mysql_fetch_all(mysql_query("SELECT * FROM sidebars WHERE username = '******' \n\t\t\t\tAND title = '{$sidebar}'"));
extract($r[0]);
print "<form action='{$PHP_SELF}' method='POST'>";
print table(row1(heading(2, $sidebar)) . row1(textarea('data', $data)) . row1("<input type='submit' value='Add' />"));
print "</form>";
}
require_once '../app/functions.php';
while (true) {
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
if (!mysql_set_charset('utf8', $conn)) {
echo "Error: Unable to set the character set.\n";
exit;
}
$devicesInfoInDatabase = mysql_query("Select distinct(uuid) from {$table_device_info} WHERE LENGTH(uuid)<18");
if (!$devicesInfoInDatabase) {
die('Invalid query: ' . mysql_error());
}
$devicesInfoInDatabase = mysql_fetch_all($devicesInfoInDatabase, MYSQL_ASSOC);
// filter just to get db
$dbDevices = array();
foreach ($devicesInfoInDatabase as $dbDevice) {
array_push($dbDevices, $dbDevice['uuid']);
}
// die(var_dump($dbDevices));
$databaseMatchingDevices = array();
$lostDevices = array();
//registered devices that are not online anymore
$newDevices = array();
// new devices in the network
$result = $pubnub->hereNow(null, false, true);
$connectedDevices = $result['payload']['channels'];
// $onlineDevices = $connectedDevices['connect']['uuids'];
/*First iteration check if the online devices exists in the database*/
$e = microtime(true);
echo "<h3>" . ($e - $s) . "</h3>";
break;
case "random":
if (!$memcached->get("data_user_rand")) {
$db = array();
$conn = mysql_connect("localhost", "root", "");
mysql_set_charset('utf8', $conn);
mysql_select_db("test_case", $conn);
$sql = "select * from user order by rand() ";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 0) {
echo "Chua co du lieu";
die;
}
$query_rs = mysql_fetch_all($query);
$memcached->set("data_user_rand", $query_rs);
echo 'generate cache';
} else {
echo 'get cache';
}
$s = microtime(true);
$m = $memcached->get("data_user_rand");
$max = count($m);
foreach ($m as $key => $value) {
echo "<h3>" . $m[rand(1, $max)]["name"] . "</h3>";
if ($key > 10) {
break;
}
}
$e = microtime(true);
mysqli_free_result($dbcolcontent);
}
echo '\\t\\t<WADB_COLUMN name="' . urlencode($value) . '"><![CDATA[' . json_encode($dballcols) . "]]></WADB_COLUMN>\n";
}
echo "\t</WADB_DATA>\n";
}
mysqli_free_result($dbcontent);
} else {
while ($row_dbcontent = mysql_fetch_assoc($dbcontent)) {
echo "\t<WADB_DATA>\n";
foreach ($row_dbcontent as $key => $value) {
$dbcolcontent = mysql_query("SHOW COLUMNS FROM `" . $value . "`", $connection);
if ($connection->connect_errno) {
die("<WADB_RESPONSE><WADB_ERROR code=\"5\"><![CDATA[Failed to execute sql: (" . $connection->connect_errno . ") " . $db_query . " : " . $connection->connect_error . "]]></WADB_ERROR></WADB_RESPONSE>");
}
$dballcols = mysql_fetch_all($dbcolcontent);
mysql_free_result($dbcolcontent);
echo '\\t\\t<WADB_COLUMN name="' . urlencode($value) . '"><![CDATA[' . json_encode($dballcols) . "]]></WADB_COLUMN>\n";
}
echo "\t</WADB_DATA>\n";
}
mysql_free_result($dbcontent);
}
break;
case "insert":
if (extension_loaded('mysqli')) {
echo "\t<WADB_DATA><![CDATA[" . mysqli_insert_id($connection) . "]]></WADB_DATA>\n";
} else {
echo "\t<WADB_DATA><![CDATA[" . mysql_insert_id($connection) . "]]></WADB_DATA>\n";
}
break;
}
if (!$error) {
// only proceed if there is no error
$conn = mysql_connect($servername, $username, $password);
mysql_select_db($database_name, $conn);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$idPart = " ";
if ($id != "*") {
$idPart = "AND cdi.id = {$id}";
}
$sql = "SELECT cdi.uuid,UNIX_TIMESTAMP(cdt.last_seen)*1000 as last_seen, cdt.status\n\t\t\tFROM {$table_device_timing} cdt, {$table_device_info} cdi\n\t\t\tWHERE (last_seen BETWEEN '" . $from . "' AND '" . $to . "')\n\t\t\t{$idPart}\n\t\t\tAND cdi.id = cdt.tid \n\t\t\tAND char_length( cdi.uuid ) <= 17\n\t\t\tORDER BY cdt.tid,cdt.last_seen ASC";
// die($sql);
$query = mysql_query($sql) or die(mysql_error() . $sql);
$query = mysql_fetch_all($query, MYSQL_ASSOC);
if (count($query) <= 0 || !$query) {
// empty result
$error = true;
$result['error'] = 'No result found in database';
$result['solution'] = 'Try a different date';
} else {
$result['result'] = $query;
$result['sucess'] = true;
}
mysql_close();
echo json_encode($result);
} else {
echo json_encode($error_array);
}
} else {
<?php
require_once dirname(__FILE__) . "/../mysql.php";
$q = mysql_query("SELECT * FROM todo ORDER BY duedate, WHERE username = "******"<tr><td>{$duedate}</td><td>{$item}</td></tr>";
}
print '</table>';
}
if (!in_array($result_type, array(MYSQL_ASSOC, MYSQL_BOTH, MYSQL_NUM), true)) {
trigger_error(__FUNCTION__ . '(): result type should be MYSQL_NUM, MYSQL_ASSOC, or MYSQL_BOTH', E_USER_WARNING);
return false;
}
$rows = array();
while ($row = mysql_fetch_array($result, $result_type)) {
$rows[] = $row;
}
return $rows;
}
do {
mysql_select_db($database_homebank_conecta, $homebank_conecta);
$query_tipoacessomenu = "SELECT codmenu FROM acessomenutipo WHERE codtipo={$row_tipopermissao['id']}";
$tipoacessomenu = mysql_query($query_tipoacessomenu, $homebank_conecta) or die(mysql_error());
$row_tipoacessomenu = mysql_fetch_all($tipoacessomenu);
$array_column = array();
foreach ($row_tipoacessomenu as $key => $value) {
$array_column[] = $value['codmenu'];
}
$valores = implode(',', $array_column);
?>
<tr>
<td width="200" align="right" class="td3"><?php
echo $row_tipopermissao['descricao'];
?>
</td>
<td class="td4">
<input type="radio" name="tiposacessomenu" id="<?php
echo $valores;
?>
require_once dirname(__FILE__) . "/../mysql.php";
require_once dirname(__FILE__) . "/../http.php";
while (ob_get_level()) {
ob_end_clean();
}
$db = mysql_connect('localhost', 'nobody', '');
mysql_select_db('nbtsc', $db);
if ($USER_AGENT) {
$ua = addslashes($USER_AGENT);
$q = "SELECT * FROM robots WHERE useragent = '{$ua}' \n\t\t\tOR useragent = '*'";
} else {
$q = "SELECT * FROM robots ORDER BY useragent";
}
header('Content-type: text/plain; charset=UTF-8');
if ($r = mysql_query($q, $db)) {
if (count($r = mysql_fetch_all($r))) {
foreach ($r as $row) {
$ua = $row['useragent'] ? $row['useragent'] : '*';
if (is_array($robots[$ua])) {
$robots[$ua][] = array('path' => $row['path'], 'sense' => $row['sense']);
} else {
$robots[$ua] = array(array('path' => $row['path'], 'sense' => $row['sense']));
}
}
if ($USER_AGENT) {
print "User-Agent: *\n";
foreach ($robots as $ua => $robot) {
foreach ($robot as $rule) {
print ($rule['sense'] == 'allow' ? 'Allow: ' : 'Disallow: ') . $rule['path'] . "\n";
}
}
$char_pull = mysql_query("SELECT * FROM characters WHERE account = '" . $gaco['id'] . "'", $charcon);
if (!$char_pull) {
echo mysql_error();
return false;
} else {
return $char_pull;
}
}
function mysql_fetch_all($char_pull)
{
while ($rotw = mysql_fetch_array($char_pull)) {
$return[] = $rotw;
}
return $return;
}
$charlist = mysql_fetch_all($char_pull);
if (isset($_POST['register'])) {
$error = "";
$db_fields = "";
$db_values = "";
$character = stripinput(trim(preg_replace("/ +/i", " ", $_POST['character'])));
if ($character == "") {
$error .= $locale['pt003'] . "<br />\n";
}
if ($error == "") {
opentable($locale['pt001']);
echo "<div style='text-align:center'><br />\n" . $locale['pt004'] . "<br /><br />\n" . $locale['pt005'] . "<br /><br />\n</div>\n";
closetable();
} else {
opentable($locale['pt0002']);
echo "<div style='text-align:center'><br />\n" . $locale['pt006'] . "<br /><br />\n{$error}<br />\n<a href='" . FUSION_SELF . "'>" . $locale['pt007'] . "</a></div></br>\n";
require_once "include/bbcode_functions.php";
////////////////snuggles freedownload for staff.php by Bigjoos////////////////
dbconn();
maxcoder();
if (!logged_in()) {
header("HTTP/1.0 404 Not Found");
// moddifed logginorreturn by retro//Remember to change the following line to match your server
print "<html><h1>Not Found</h1><p>The requested URL /{$_SERVER['PHP_SELF']} was not found on this server.</p><hr /><address>Apache/1.1.11 " . $SITENAME . " Server at " . $_SERVER['SERVER_NAME'] . " Port 80</address></body></html>\n";
die;
}
parked();
stdhead("FreeLeech");
// eZER0's mod for bonus contribution
// Limited this to 3 because of performance reasons and i wanted to go through last 3 events anyway the most we can have
// is that invites are enabled, double upload is enabled as well as freeleech is enabled! x 3 eZER0
$scheduled_events = mysql_fetch_all("SELECT * from `events` ORDER BY `startTime` DESC LIMIT 2;", array());
if (is_array($scheduled_events)) {
foreach ($scheduled_events as $scheduled_event) {
if (is_array($scheduled_event) && array_key_exists('startTime', $scheduled_event) && array_key_exists('endTime', $scheduled_event)) {
$startTime = 0;
$endTime = 0;
$startTime = $scheduled_event['startTime'];
$endTime = $scheduled_event['endTime'];
if (time() < $endTime && time() > $startTime) {
if (array_key_exists('freeleechEnabled', $scheduled_event)) {
$freeleechEnabled = $scheduled_event['freeleechEnabled'];
if ($scheduled_event['freeleechEnabled']) {
$freeleech_start_time = $scheduled_event['startTime'];
$freeleech_end_time = $scheduled_event['endTime'];
$freeleech_enabled = true;
}
function infoPagoGrupo($id, $tipo, $conexion)
{
$query = "SELECT COUNT(*) FROM `inscripcion` WHERE `id_curso` = '" . $id . "' AND `estado`= '" . $tipo . "';";
$res = mysql_query($query, $conexion) or die("Error: " . mysql_error());
$result = mysql_fetch_all($res);
return json_encode($result);
}
return $err;
}
if (@mysqli_num_rows($r)) {
while ($row = mysqli_fetch_array($r)) {
$result[] = $row;
}
}
if (count($result) == 0) {
return $default_value;
}
return $result;
}
$count1 = get_row_count('events');
$perpage = 15;
$pager = pager($perpage, $count1, 'staffpanel.php?tool=events&action=events&');
$scheduled_events = mysql_fetch_all("SELECT e.id, e.userid, e.startTime, e.endTime, e.overlayText, e.displayDates, e.freeleechEnabled, e.duploadEnabled, e.hdownEnabled, u.id, u.username, u.class, u.chatpost, u.leechwarn, u.warned, u.pirate, u.king, u.donor, u.enabled FROM events AS e LEFT JOIN users AS u ON u.id=e.userid ORDER BY startTime DESC " . $pager['limit'] . ";", array());
if (is_array($scheduled_events)) {
foreach ($scheduled_events as $scheduled_event) {
if (is_array($scheduled_event) && array_key_exists('startTime', $scheduled_event) && array_key_exists('endTime', $scheduled_event)) {
$startTime = 0;
$endTime = 0;
$overlayText = "";
$displayDates = true;
$startTime = $scheduled_event['startTime'];
$endTime = $scheduled_event['endTime'];
if (time() < $endTime && time() > $startTime) {
if (array_key_exists('overlayText', $scheduled_event)) {
$overlayText = $scheduled_event['overlayText'];
}
if (!is_string($overlayText)) {
$overlayText = "";
function feed()
{
$many = 20;
$board = '';
//wait for more fix
$result = inget('`id`, `post_title`, `post_author`, `post_author_nicename`, `post_content`, `post_date`, `post_board`', 'posts', $board . 'ORDER BY `post_date` DESC LIMIT 0, ' . $many);
$board = board_info();
$who = member_who();
$prefix = isSSL() ? 'https:' : 'http:';
$row = mysql_fetch_all($result);
if ($row) {
foreach ($row as $id => $list) {
$row[$id]['post_board'] = $board[$list['post_board']]['name'];
$row[$id]['post_board_nicename'] = $board[$list['post_board']]['nicename'];
if ($list['post_author']) {
$row[$id]['post_author'] = $who[$list['post_author']]['nicename'];
} else {
$row[$id]['post_author'] = $list['post_author_nicename'];
}
$row[$id]['post_content'] = html_transfer(show_text($list['post_content']));
}
}
header('Content-type: application/xml; charset=utf-8');
echo '<?xml version="1.0" encoding="utf-8"?>' . "\n";
include load_template('feed');
}
