function _getPasscode($refcode)
{
$initDB = new hnSQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$query = $initDB->query("SELECT * FROM ilink WHERE refcode='{$refcode}'");
$row = $initDB->fetch_array($query);
if ($row) {
return $row['passcode'];
} else {
return '';
}
$initDB->close();
}
<?php
require_once 'db_config.php';
require_once 'database.class.php';
$db = new hnSQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
if (isset($_GET['id'])) {
$sharerLinkID = $_GET['id'];
$db->query("SELECT * FROM ilink WHERE id='{$sharerLinkID}'");
if ($sls = $db->fetch_array()) {
$url = $sls['linkaddr'];
$removehttp = str_replace('http://', '', $url);
$removeslash = rtrim($removehttp, '/');
if (strpos($removeslash, ':') !== false) {
list($ip, $port) = explode(":", $removeslash);
} else {
$ip = $removeslash;
$port = 80;
}
}
if (fsockopen($ip, $port, $errno, $errstr, 5) !== false) {
echo '1';
} else {
echo '0';
}
}
$db->close();
$linkAddr = $row['linkaddr'];
$linkDesc = $row['linkdesc'];
$passcode = $row['passcode'];
$refcode = $row['refcode'];
echo '<tr>';
echo '<td>' . $refcode . '</td><td><a href="' . $linkAddr . '">' . $linkName . '</a><br/>';
echo stripslashes(rtrim($linkDesc)) . '</td><td id="indicator-' . $linkID . '"></td>';
echo '</tr>';
}
}
$db->close();
echo '</tbody>
</table>';
//echo '</div>
//</div>';
$db2 = new hnSQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$querydb2 = $db2->query("SELECT * FROM ilink ORDER BY id");
while ($row2 = $db2->fetch_assoc($querydb2)) {
$linkID2 = $row2['id'];
echo '
<script>
$(document).ready(function () {
checkStatus' . $linkID2 . '(' . $linkID2 . ');
setInterval(function(){checkStatus' . $linkID2 . '(' . $linkID2 . ');}, 900000);
});
function checkStatus' . $linkID2 . '(sharerID) {
$("#indicator-' . $linkID2 . '").html("<span class=\\"label label-warning\\">Checking</span>");
$.ajax({
