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'); }