$res .= "</tr>"; } $res .= "</tbody></table></center>"; print $res; exit; } } if ($action == "showenqueued") { $mg = mg_connect($config, "", "", ""); if ($mg) { $stmt = new mg_stmt_select($mg, "sources"); //$stmt->setWhereClause("enabled = 1 and deleted = 0 and (crawl_process_status='' or crawl_process_status='0') and id_account = " . $id_account_current); $query = array('$and' => array(array(enabled => "1"), array(deleted => "0"), array(id_account => intval($id_account_current)), array('$or' => array(array(crawl_process_status => null), array(crawl_process_status => "0"))))); //$query = array('$and' => array(array(enabled => "1"), array(deleted => "0"))); $stmt->setQuery($query); $stmt->setSort(array("crawl_priority" => -1, "crawl_nexttime" => 1)); //$stmt->setSort(array( "crawl_nexttime" => 1 )); if ($limit != "0") { $stmt->setLimit($limit); } $count = $stmt->execute(); if ($count == 0) { print ""; exit; } $cursor = $stmt->getCursor(); $res .= "<center><table>"; $res .= "<tr><th>Title</th><th>Starting URL</th><th>Next crawl date</th><th class='priority'>Priority</th></tr><tbody>"; while ($cursor->hasNext()) { $rs = $cursor->getNext(); $query = array('$and' => array(array("type" => "cnx"), array("id" => intval($rs["type"]))));
<?php require_once "../init_gpc.inc.php"; require_once "../init.inc.php"; $id = $_GET['id']; $row = $_GET['row']; if ($id == '') { exit; } //TODO: V4 - Tester $mg = mg_connect($config, "", "", ""); if ($mg) { $stmt = new mg_stmt_select($mg, "sources_log"); $query = array("id_source" => intval($id)); $stmt->setQuery($query); $stmt->setSort(array("createtime" => -1)); $count = $stmt->execute(); header('Content-type: text/html; charset=UTF-8'); if ($count == 0) { print "No log available !"; exit; } $cursor = $stmt->getCursor(); if ($row == "") { $row = 0; while ($cursor->hasNext()) { $rs = $cursor->getNext(); $t = $rs["createtime"] / 1000; $created = date('Y-m-d H:i:s', $t); //1.37271406957E+12 print "<a href='log.php?id=" . $id . "&row=" . $row . "'>" . $created . "</a><br>";
//============================================================================ // (c) 2009-2010, Eolya - All Rights Reserved. // This source code is the property of Eolya. // The license applying to this source code is available at : // http://www.crawl-anywhere.com/licenses/ //============================================================================ require_once "../../init_gpc.inc.php"; require_once "../../init.inc.php"; $action = POSTGET("action"); if ($action == "showaccountlist") { $mg = mg_connect($config, "", "", ""); if ($mg) { $res = "<h2>Accounts</h2>"; $stmt = new mg_stmt_select($mg, "accounts"); $stmt->setFields(array("id" => "true", "name" => "true")); $stmt->setSort(array("name" => 1)); $count = $stmt->execute(); if ($count > 0) { $cursor = $stmt->getCursor(); while ($cursor->hasNext()) { $rs = $cursor->getNext(); $account = $rs["name"]; $res .= $account; $res .= " <a href='#' onClick='editAccount(" . $rs["id"] . ");return false;' title='Edit'><img src='images/button_edit.png'></a>"; $res .= "<br />"; } } } $res .= "<br /><br /><br /><br /><br /><br />Add new account<a href='#' onClick='displayAddAccount(); return false;'><img src='images/edit_add_32.png'></a> "; print $res; exit;
function getAvailableEngines($config) { $aEnginesFinal = null; $mg = mg_connect($config, "", "", ""); if ($mg) { $stmt = new mg_stmt_select($mg, "accounts"); $stmt->setFields(array("id" => "true", "name" => "true")); $stmt->setSort(array("name" => 1)); $count = $stmt->execute(); if ($count > 0) { $aAccountsFinal = array(); $cursor = $stmt->getCursor(); while ($cursor->hasNext()) { $rs = $cursor->getNext(); $id = strtolower(trim($rs['id'])); $name = trim($rs['name']); $aEnginesFinal[$id] = $name; } } } return $aEnginesFinal; }
//============================================================================ // (c) 2009-2010, Eolya - All Rights Reserved. // This source code is the property of Eolya. // The license applying to this source code is available at : // http://www.crawl-anywhere.com/licenses/ //============================================================================ require_once "../../init_gpc.inc.php"; require_once "../../init.inc.php"; $action = POSTGET("action"); if ($action == "showuserlist") { $mg = mg_connect($config, "", "", ""); if ($mg) { $res = "<h2>Users</h2>"; $stmt = new mg_stmt_select($mg, "users"); $stmt->setFields(array("id" => "true", "user_name" => "true")); $stmt->setSort(array("user_name" => 1)); $count = $stmt->execute(); if ($count > 0) { $cursor = $stmt->getCursor(); while ($cursor->hasNext()) { $rs = $cursor->getNext(); $user = $rs["user_name"]; $res .= $user; $res .= " <a href='#' onClick='editUser(" . $rs["id"] . ");return false;' title='Edit'><img src='images/button_edit.png'></a>"; $res .= "<br />"; } } } $res .= "<br /><br /><br /><br /><br /><br />Add new user<a href='#' onClick='displayAddUser(); return false;'><img src='images/edit_add_32.png'></a> "; print $res; exit;