</form> </div> </div> <?php } else { ?> <div class="content"> <div class="content-header"> <h4><a href="?p=admin">Main Menu</a> / Vote Links</h4> </div> <!-- .content-header --> <div class="main-content"> <?php if (isset($_POST['action'])) { if ($_POST['action'] == 'addSite') { addSite(); } } ?> <form method="POST" action="?p=admin&sub=vote&addlink=true" class="form label-inline"> <input type="hidden" name="action" value="update"> <h5><center>List of Vote Sites</center></h5><br /> <table> <thead> <th><center><b><?php echo $lang['hostname']; ?> </center></b></th> <th><center><b><?php echo $lang['image']; ?>
} if (isset($_GET['comment'])) { $json = $_GET['comment']; addComment($json, $dbh); } if (isset($_GET['challange'])) { $json = $_GET['challange']; addChallange($json, $dbh); } if (isset($_GET['chComment'])) { $json = $_GET['chComment']; addChComment($json, $dbh); } if (isset($_GET['site'])) { $json = $_GET['site']; addSite($json, $dbh); } else { } function addKit($json, $db) { $array = split(',', $json); $ins = "insert into Kit (image, brand, model, item, date, userId) \n values ('{$array['0']}', '{$array['1']}', '{$array['2']}', '{$array['3']}', '{$array['4']}','{$array['5']}');" or die(print_r($dbh->errorInfo(), true)); $db->query($ins); } function addLog($json, $db) { $array = split(',', $json); $ins = "insert into Logs (diveNo, date, depth, timeIn, duration, visibility, PG, location, \n buddy, comments, diveProfile, userID) values ('{$array['0']}', '{$array['1']}', '{$array['2']}', '{$array['3']}',\n '{$array['4']}','{$array['5']}','{$array['6']}','{$array['7']}', '{$array['8']}','{$array['9']}','{$array['10']}',\n '{$array['11']}');" or die(print_r($dbh->errorInfo(), true)); $db->query($ins); } function addComment($json, $db)
addKit($values, $dbh); } if ($type == 'log') { addLog($values, $dbh); } if ($type == 'comment') { addComment($values, $dbh); } if ($type == 'challange') { addChallange($values, $dbh); } if ($type == 'chComment') { addChComment($values, $dbh); } if ($type == 'site') { addSite($values, $dbh); } if ($type == 'like') { like($values, $dbh); } function addKit($json, $db) { $ins = $db->prepare("insert into Kit (image, brand, model, item, date, userId) \n values (?, ?, ?, ?, ?, ?);") or die(print_r($dbh->errorInfo(), true)); $ins->bindParam(1, $json[0]); $ins->bindParam(2, $json[1]); $ins->bindParam(3, $json[2]); $ins->bindParam(4, $json[3]); $ins->bindParam(5, $json[4]); $ins->bindParam(6, $json[5]); $ins->execute(); }
} } } else { // We get A LOT of requests to add deep pages (eg, "http://www.youtube.com/blahblah"). // But we only allow one page per hostname if the URL is not in the list of top sites. // Here we check if this is a deep URL. $rooturl = substr($gRurl, 0, strpos($gRurl, "/", 10)); $rooturlObj = getUrl($rooturl, true); if ($rooturlObj) { echo "<p class=warning>{$gRurl} will not be added because <a href='{$rooturlObj['url']}'>{$rooturlObj['url']}</a> is already in the crawl. If a URL is not in the list of <a href='about.php#listofurls'>top URLs</a> it can only be added if there are no other URLs with the same hostname already in the crawl.</p>\n"; } else { $bAdd = true; } } if ($bAdd) { addSite($gRurl); // queue it for adding echo "<p class=warning>{$gRurl} will be added within five business days and will be included in the next crawl after that.</p>\n"; } } } ?> <h1><?php echo $gTitle; ?> </h1> <script type="text/javascript"> function confirmAdd() {