* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
*/
/** @require functions */
require_once $_SERVER["DOCUMENT_ROOT"] . "/source/functions.php";
/** @require MySQL */
require_once $_SERVER["DOCUMENT_ROOT"] . "/source/MySQL.php";
use EDTB\source\System;
$system = isset($_GET["system"]) ? $_GET["system"] : "";
if (empty($system)) {
exit;
}
$esc_system = $mysqli->real_escape_string($system);
/**
* check if system has screenshots
*/
$screenshots = System::has_screenshots($system) ? '<a href="/Gallery?spgmGal=' . urlencode(strip_invalid_dos_chars($system)) . '" title="View image gallery"><img src="/style/img/image.png" alt="Gallery" class="icon" style="margin-left:5px;vertical-align:top" /></a>' : "";
/**
* check if system is in the bookmarks
*/
$query = " SELECT user_bookmarks.comment, user_bookmarks.added_on\n FROM user_bookmarks\n WHERE user_bookmarks.system_name = '{$esc_system}'\n LIMIT 1";
$result = $mysqli->query($query) or write_log($mysqli->error, __FILE__, __LINE__);
$count2 = $result->num_rows;
if ($count2 > 0) {
$obj = $result->fetch_object();
$comment = $obj->comment;
$added_on = $obj->added_on;
if ($comment != "") {
echo 'Bookmark comment: ' . $comment . ' - ';
}
echo 'Bookmark added: ' . get_timeago($added_on, false);
echo '<br />';
