if (empty($invitedby)) {
$HTMLOUT .= "Currently no invited members.</td></tr>";
}
}
}
}
//==End
if ($user['paranoia'] < 2 || $user['hidecur'] == "yes" || $CURUSER['id'] == $id || $CURUSER['class'] >= UC_STAFF) {
if (isset($torrents)) {
$HTMLOUT .= "<tr valign=\"top\"><td class=\"rowhead\" width=\"10%\">{$lang['userdetails_uploaded_t']}</td><td align=\"left\" width=\"90%\"><a href=\"javascript: klappe_news('a')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pica\" alt=\"Show/Hide\" /></a><div id=\"ka\" style=\"display: none;\">{$torrents}</div></td></tr>\n";
}
if (isset($seeding)) {
$HTMLOUT .= "<tr valign=\"top\"><td class=\"rowhead\" width=\"10%\">{$lang['userdetails_cur_seed']}</td><td align=\"left\" width=\"90%\"><a href=\"javascript: klappe_news('a1')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pica1\" alt=\"Show/Hide\" /></a><div id=\"ka1\" style=\"display: none;\">" . maketable($seeding) . "</div></td></tr>\n";
}
if (isset($leeching)) {
$HTMLOUT .= "<tr valign=\"top\"><td class=\"rowhead\" width=\"10%\">{$lang['userdetails_cur_leech']}</td><td align=\"left\" width=\"90%\"><a href=\"javascript: klappe_news('a2')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pica2\" alt=\"Show/Hide\" /></a><div id=\"ka2\" style=\"display: none;\">" . maketable($leeching) . "</div></td></tr>\n";
}
//==Snatched
$user_snatches_data = $mc1->get_value('user_snatches_data_' . $id);
if ($user_snatches_data === false) {
$ressnatch = sql_query("SELECT s.*, t.name AS name, c.name AS catname, c.image AS catimg FROM snatched AS s INNER JOIN torrents AS t ON s.torrentid = t.id LEFT JOIN categories AS c ON t.category = c.id WHERE s.userid = {$user['id']}") or sqlerr(__FILE__, __LINE__);
$user_snatches_data = snatchtable($ressnatch);
$mc1->cache_value('user_snatches_data_' . $id, $user_snatches_data, $INSTALLER09['expires']['user_snatches_data']);
}
if (isset($user_snatches_data)) {
$HTMLOUT .= "<tr valign=\"top\"><td class=\"rowhead\" width=\"10%\">{$lang['userdetails_cur_snatched']}</td><td align=\"left\" width=\"90%\"><a href=\"javascript: klappe_news('a3')\"><img border=\"0\" src=\"pic/plus.gif\" id=\"pica3\" alt=\"Show/Hide\" /></a><div id=\"ka3\" style=\"display: none;\">{$user_snatches_data}</div></td></tr>\n";
}
//==End
}
//=== start snatched
$count_snatched = $count2 = '';
$torrentlist = maketable($res, 'leeching');
}
break;
// Completed torrents
// Completed torrents
case 'completed':
$res = sql_query("SELECT torrents.id AS torrent, torrents.name AS torrentname, small_descr, categories.name AS catname, categories.image, category, sp_state, size, snatched.uploaded, snatched.seedtime, snatched.leechtime, snatched.completedat FROM torrents LEFT JOIN snatched ON torrents.id = snatched.torrentid LEFT JOIN categories on torrents.category = categories.id WHERE snatched.finished='yes' AND torrents.owner != {$id} AND userid={$id} ORDER BY snatched.completedat DESC") or sqlerr();
$count = mysql_num_rows($res);
if ($count > 0) {
$torrentlist = maketable($res, 'completed');
}
break;
// Incomplete torrents
// Incomplete torrents
case 'incomplete':
$res = sql_query("SELECT torrents.id AS torrent, torrents.name AS torrentname, small_descr, categories.name AS catname, categories.image, category, sp_state, size, snatched.uploaded, snatched.downloaded, snatched.leechtime FROM torrents LEFT JOIN snatched ON torrents.id = snatched.torrentid LEFT JOIN categories on torrents.category = categories.id WHERE snatched.finished='no' AND userid={$id} AND torrents.owner != {$id} ORDER BY snatched.startdat DESC") or sqlerr();
$count = mysql_num_rows($res);
if ($count > 0) {
$torrentlist = maketable($res, 'incomplete');
}
break;
default:
$count = 0;
$torrentlist = "";
break;
}
if ($count) {
echo "<b>" . $count . "</b>" . $lang_getusertorrentlistajax['text_record'] . add_s($count) . "<br />" . $torrentlist;
} else {
echo $lang_getusertorrentlistajax['text_no_record'];
}
chmod("{$dirname}/{$name}", 0777);
}
}
if (!file_exists("{$dirname}/{$name}")) {
echo "<p>" . _UPLOADERROR . " {$dirname}/{$name}</p2>\n";
}
$picname = substr($name, 0, -4);
}
}
if ($act == 'delete') {
// do delete file
unlink($IMGFOLDER . '/' . $_POST['fname']);
}
if ($act == 'list') {
// generate table
maketable($dirname);
print '</body></html>';
exit;
}
// draw image manager window
print '<iframe id="frm1" name="frm1" width="480" height="220" src="./galery.php?act=list"></iframe>' . "\n";
print "<form name=\"imgupload\" method=\"post\" action=\"./galery.php?dirname={$dirname}\" enctype=\"multipart/form-data\">\n";
print "<center>\n";
print '<p id="imgalt"> </p>' . "\n";
print "<p>{$HELPSTR}</p>\n";
print "<button type=button onclick=viewimg();>{$LARGEIMG}</button> \n";
print "<button type=button onclick=insertimg();>{$INSERTIMG}</button> \n";
// print "<button type=button onclick=deleteimg();>$DELETEIMG</button><br/>\n";
// print "<input type=file size=40 name=upload> ";
// print "<input type=hidden name=act value=\"upload\"> ";
print "<input type=hidden name=fname value=\"\"> ";
}
?>
<div class="entries">
<div class="entries_inner">
<table>
<tr>
<td class="heading" style="min-width:400px"><a href="javascript:void(0)" onclick="tofront('addPoi');update_values('/get/getPoiEditData.php?Poi_id=0');$('#system_33').focus()" title="Add point of interest">Points of Interest</a></td>
<td class="heading" style="min-width:400px">Bookmarks</td>
</tr>
<tr>
<td style="vertical-align:top;padding:0">
<?php
// get poi in correct order
$poi_res = mysqli_query($GLOBALS["___mysqli_ston"], "\tSELECT SQL_CACHE user_poi.id, user_poi.poi_name AS item_name,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser_poi.system_name, user_poi.text,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIFNULL(user_poi.x, user_systems_own.x) AS item_coordx,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIFNULL(user_poi.y, user_systems_own.y) AS item_coordy,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIFNULL(user_poi.z, user_systems_own.z) AS item_coordz,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tedtb_systems.id AS system_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser_poi_categories.name AS catname\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM user_poi\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN edtb_systems ON user_poi.system_name = edtb_systems.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN user_poi_categories ON user_poi_categories.id = user_poi.category_id\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN user_systems_own ON user_poi.system_name = user_systems_own.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY -(sqrt(pow((item_coordx-(" . $usex . ")),2)+pow((item_coordy-(" . $usey . ")),2)+pow((item_coordz-(" . $usez . ")),2))) DESC, poi_name, system_name") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__);
echo maketable($poi_res, "Poi");
?>
</td>
<td style="vertical-align:top;padding:0">
<?php
// get bookmarks
$bm_res = mysqli_query($GLOBALS["___mysqli_ston"], "\tSELECT SQL_CACHE user_bookmarks.id, user_bookmarks.system_id, user_bookmarks.system_name,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser_bookmarks.comment as text, user_bookmarks.added_on,\n IFNULL(edtb_systems.x, user_systems_own.x) AS item_coordx,\n IFNULL(edtb_systems.y, user_systems_own.y) AS item_coordy,\n IFNULL(edtb_systems.z, user_systems_own.z) AS item_coordz,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser_bm_categories.name AS catname\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM user_bookmarks\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN edtb_systems ON user_bookmarks.system_name = edtb_systems.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN user_bm_categories ON user_bookmarks.category_id = user_bm_categories.id\n LEFT JOIN user_systems_own ON user_bookmarks.system_name = user_systems_own.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY -(sqrt(pow((item_coordx-(" . $usex . ")),2)+pow((item_coordy-(" . $usey . ")),2)+pow((item_coordz-(" . $usez . ")),2))) DESC, system_name") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__);
$i = 0;
echo maketable($bm_res, "Bm");
?>
</td>
</tr>
</table>
</div>
</div>
<?php
require_once "" . $_SERVER["DOCUMENT_ROOT"] . "/style/footer.php";
$HTMLOUT .= "<td align='left'>{$torrentcomments}</td></tr>\n";
}
$HTMLOUT .= "<tr><td class='rowhead'>{$lang['userdetails_posts']}</td>";
if ($forumposts && ($user["class"] >= UC_POWER_USER && $user["id"] == $CURUSER["id"] || $CURUSER['class'] >= UC_MODERATOR)) {
$HTMLOUT .= "<td align='left'><a href='userhistory.php?action=viewposts&id={$id}'>{$forumposts}</a></td></tr>\n";
} else {
$HTMLOUT .= "<td align='left'>{$forumposts}</td></tr>\n";
}
if (isset($torrents)) {
$HTMLOUT .= "<tr valign='top'><td class='rowhead'>{$lang['userdetails_uploaded_t']}</td><td align='left'>{$torrents}</td></tr>\n";
}
if (isset($seeding)) {
$HTMLOUT .= "<tr valign=top><td class=rowhead>{$lang['userdetails_cur_seed']}</td><td align=left>" . maketable($seeding) . "</td></tr>\n";
}
if (isset($leeching)) {
$HTMLOUT .= "<tr valign=top><td class=rowhead>{$lang['userdetails_cur_leech']}</td><td align=left>" . maketable($leeching) . "</td></tr>\n";
}
if ($user["info"]) {
$HTMLOUT .= "<tr valign='top'><td align='left' colspan='2' class='text' bgcolor='#F4F4F0'>" . format_comment($user["info"]) . "</td></tr>\n";
}
if ($CURUSER["id"] != $user["id"]) {
if ($CURUSER['class'] >= UC_MODERATOR) {
$showpmbutton = 1;
} elseif ($user["acceptpms"] == "yes") {
$r = mysql_query("SELECT id FROM blocks WHERE userid={$user['id']} AND blockid={$CURUSER['id']}") or sqlerr(__FILE__, __LINE__);
$showpmbutton = mysql_num_rows($r) == 1 ? 0 : 1;
} elseif ($user["acceptpms"] == "friends") {
$r = mysql_query("SELECT id FROM friends WHERE userid={$user['id']} AND friendid={$CURUSER['id']}") or sqlerr(__FILE__, __LINE__);
$showpmbutton = mysql_num_rows($r) == 1 ? 1 : 0;
}
}
if ($user["gender"] == "Male") {
$gender = "<td class=embedded><img src=" . $pic_base_url . "male.gif alt='Male' style='margin-left: 4pt'></td>";
}
if ($user["gender"] == "Female") {
$gender = "<td class=embedded><img src=" . $pic_base_url . "female.gif alt='Female' style='margin-left: 4pt'></td>";
}
if ($user["gender"] == "N/A") {
$gender = "<td class=embedded><img src=" . $pic_base_url . "na.gif alt='N/A' style='margin-left: 4pt'></td>";
}
$res = sql_query("SELECT torrent,added,uploaded,downloaded,torrents.name as torrentname,categories.name as catname,size,image,category,seeders,leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid=" . unsafeChar($id) . " AND seeder='no'") or sqlerr();
if (mysql_num_rows($res) > 0) {
$leeching = maketable($res);
}
$res = sql_query("SELECT torrent,added,uploaded,downloaded,torrents.name as torrentname,categories.name as catname,size,image,category,seeders,leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid=" . unsafeChar($id) . " AND seeder='yes'") or sqlerr();
if (mysql_num_rows($res) > 0) {
$seeding = maketable($res);
}
// /////////////// Birthday mod /////////////////////
if ($user['birthday'] != "0000-00-00") {
// $current = gmdate("Y-m-d", time());
$current = gmdate("Y-m-d", time() + $CURUSER['tzoffset'] * 60);
list($year2, $month2, $day2) = split('-', $current);
$birthday = $user["birthday"];
$birthday = date("Y-m-d", strtotime($birthday));
list($year1, $month1, $day1) = split('-', $birthday);
if ($month2 < $month1) {
$age = $year2 - $year1 - 1;
}
if ($month2 == $month1) {
if ($day2 < $day1) {
$age = $year2 - $year1 - 1;
<?php
if ($_SESSION["editor"]) {
echo "<p>Click <a href='editor.php'>here</a/> to access the editor page, you lucky duck!</p>";
}
?>
<?php
$userEmail = $_SESSION["userEmail"];
$sql = "SELECT * FROM papers WHERE \n\t\t\t\t\t\t\tauthor = '{$userEmail}'";
$result = mysqli_query($link, $sql);
if (!$result) {
error('A database error occurred in processing your ' . 'submission.\\nIf this error persists, please ' . 'contact spencer16a@ncssm.edu');
}
//var_dump($result);
maketable($result, ["filename", "subject", "timestamp"]);
$num_papers = mysqli_num_rows($result);
//var_dump($rows);
echo "<p> You've submitted {$num_papers} paper(s)";
?>
<p>Submit more <a href="upload.php">here</a></p>
<a href="logout.php">Logout?</a>
</div>
</div>
</section>
</main>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script src="../js/mobile-nav.js"></script>
