public function can_access($token, $permission)
{
//$a->token $b->permission
$role_id = $this->get_role_user($this->get_user_id_from_token($token));
$c = get_conn();
$statement = $c->prepare("SELECT permision_id from permisions where permission= ?");
$statement->execute(array($permission));
$permission_id = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
if (isset($permission_id[0])) {
$p_id = $permission_id[0];
} else {
return 0;
}
$statement = $c->prepare("SELECT count(*) from role_permission where role_id= ? and permission_id=?");
$statement->execute(array($role_id, $p_id));
$count = $statement->fetchAll(PDO::FETCH_COLUMN, 0);
try {
if ($count[0] == 1) {
return 1;
} else {
return 0;
}
} catch (Exception $e) {
return 0;
}
}
function set_page_count($url, $count)
{
$conn = get_conn();
$res = $conn->query("UPDATE click SET count ='" . $count . "' WHERE url = '" . mysql_escape_string($url) . "'");
if ($res === false) {
trigger_error('Error running SQL' . $conn->error, E_USER_ERROR);
}
}
function main()
{
while (1) {
echo "#WAKEUP\n";
$conn = get_conn();
if (!$conn) {
log_and_die(mysqli_connect_error());
}
$sql = "select mview_id from flexviews.mview_compute_schedule where unix_timestamp(now()) - unix_timestamp(last_computed_at) > compute_interval_seconds";
$stmt = mysqli_query($conn, $sql);
if (!$stmt) {
log_and_die(mysqli_error($conn));
}
echo "#Delta computation phase starting\n";
while ($row = mysqli_fetch_assoc($stmt)) {
$pid = pcntl_fork();
echo "#Spawning a child for {$row['mview_id']}\n";
if ($pid == 0) {
refresh_mview($row['mview_id'], 'COMPUTE');
exit;
} else {
$childCount++;
}
}
mysqli_close($conn);
while ($childCount) {
pcntl_wait($status);
--$childCount;
echo "#{$childCount} children remain\n";
}
$conn = get_conn();
$sql = "select mview_id from flexviews.mview_apply_schedule where unix_timestamp(now()) - unix_timestamp(last_applied_at) > apply_interval_seconds";
$stmt = mysqli_query($conn, $sql);
if (!$stmt) {
log_and_die(mysqli_error($conn));
}
echo "#Delta application phase starting\n";
while ($row = mysqli_fetch_assoc($stmt)) {
$pid = pcntl_fork($status);
echo "#Spawning a child for {$row['mview_id']}\n";
if ($pid == 0) {
refresh_mview($row['mview_id'], 'APPLY');
exit;
} else {
$childCount++;
}
}
mysqli_close($conn);
while ($childCount) {
pcntl_wait($status);
--$childCount;
echo "#{$childCount} children remain\n";
}
sleep(60);
}
}
function getManagedEntity($ppcEntityId, $idField, $increaseStart, $decreaseStart, $end)
{
$query = "SELECT SUM(b1.cost) AS total_cost, SUM(b1.revenue)-SUM(b1.cost) AS total_profit, COALESCE(increase.profit,0) AS increase_profit, COALESCE(decrease.profit,0) AS decrease_profit\n FROM bid_management_data b1 LEFT JOIN\n (SELECT b2.{$idField}, SUM(b2.revenue)-SUM(b2.cost) AS profit\n FROM bid_management_data b2\n WHERE b2.{$idField} = {$ppcEntityId} AND b2.data_date BETWEEN '{$increaseStart}' AND '{$end}'\n GROUP BY b2.{$idField}) AS increase ON increase.{$idField} = b1.{$idField} LEFT JOIN\n (SELECT b3.{$idField}, SUM(b3.revenue)-SUM(b3.cost) AS profit\n FROM bid_management_data b3\n WHERE b3.{$idField} = {$ppcEntityId} AND b3.data_date BETWEEN '{$decreaseStart}' AND '{$end}'\n GROUP BY b3.{$idField}) AS decrease ON decrease.{$idField} = b1.{$idField} ";
$conn = get_conn();
$result = mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error());
$row = mysql_fetch_array($result);
$managedEntity = $this->instantiateManagedEntity($row);
close_conn($conn);
return $managedEntity;
}
function __construct()
{
global $dbhost, $sys_dbname, $dbname, $dbuser, $dbpsw, $charset;
$this->db = get_conn($dbhost, $dbname, $dbuser, $dbpsw, $charset);
if ($this->db->ErrorNo() > 0) {
echo $this->db->ErrorMsg();
exit;
}
if (EZBOSS_DB_DEBUG == true) {
$this->db->debug = true;
}
}
public function __construct($catID, $examName, $examID)
{
$this->_examID = (int) $examID;
$this->_examName = $examName;
$this->_catID = (int) $catID;
$this->_conn = get_conn();
$this->_userID = (int) $_SESSION['userID'];
$this->_get_from_db();
$this->_shuffle_questions();
$this->_set_questionID_order();
$this->_get_num_of_correct_answers();
$this->_create_form();
}
function save($rule)
{
$conn = get_conn();
$cost_threshold = mysql_real_escape_string($rule->cost_threshold);
$increase_percent = mysql_real_escape_string($rule->increase_percent);
$increase_days = mysql_real_escape_string($rule->increase_days);
$decrease_percent = mysql_real_escape_string($rule->decrease_percent);
$decrease_days = mysql_real_escape_string($rule->decrease_days);
$apply = $rule->apply ? 1 : 0;
$query = "\n INSERT INTO bid_rule (\n id,\n ppc_entity_id,\n ppc_entity_type,\n rule_type,\n cost_threshold,\n increase_percent,\n increase_days,\n decrease_percent,\n decrease_days,\n apply\n )\n VALUES (\n {$rule->id},\n {$rule->entityId},\n {$rule->entityType},\n {$rule->ruleType},\n {$cost_threshold},\n {$increase_percent},\n {$increase_days},\n {$decrease_percent},\n {$decrease_days},\n {$apply}\n )\n ON DUPLICATE KEY UPDATE\n id=LAST_INSERT_ID(id),\n ppc_entity_id = VALUES(ppc_entity_id),\n ppc_entity_type = VALUES(ppc_entity_type),\n rule_type = VALUES(rule_type),\n cost_threshold = VALUES(cost_threshold),\n increase_percent = VALUES(increase_percent),\n increase_days = VALUES(increase_days),\n decrease_percent = VALUES(decrease_percent),\n decrease_days = VALUES(decrease_days),\n apply = VALUES(apply)\n ";
mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error());
$rule->id = mysql_insert_id();
close_conn($conn);
return $rule;
}
function get_json_text($catID, $userID)
{
$conn = get_conn();
$cat_info_array = get_cat_info_array($conn, $catID, $userID);
$number_of_exams = $cat_info_array['number_of_exams'];
$cat_name = $cat_info_array['cat_name'];
$info_array = array("category_name" => $cat_name, "number_of_exams" => $number_of_exams, "exams" => array());
$query = "select * from exam where catID={$catID}";
$result = $conn->query($query);
for ($i = 0; $i < $number_of_exams; $i++) {
$result->data_seek($i);
$row = $result->fetch_array(MYSQLI_ASSOC);
$exam_name = $row['exam_name'];
$number_of_questions = $row['number_of_questions'];
$examID = $row['examID'];
$temp_exam_array = array("exam_name" => $exam_name, "number_of_questions" => $number_of_questions, "questions" => array());
load_question_data($conn, $examID, $temp_exam_array, $number_of_questions);
$info_array["exams"][] = $temp_exam_array;
}
return json_encode($info_array);
}
function delete_answers($questionID, $question_type)
{
$conn = get_conn();
$questionID = (int) $questionID;
$query = "DELETE FROM {$question_type} WHERE questionID={$questionID}";
if (!$conn->query($query)) {
die(__LINE__ . " " . $conn->error);
}
$conn->close();
}
function pointcrud($inp, $owner_uid, $admin)
{
$db = get_conn();
switch ($inp['action']) {
case 'list':
$where = array();
if (isset($inp['id']) && !empty($inp['id'])) {
$where[] = "id = " . $inp['id'];
}
if ($admin != 1) {
$where[] = sprintf(" owner = %d", $owner_uid);
}
// pending approval
if (isset($inp['contribute']) && $inp['contribute'] == 1) {
$where[] = "contribute=1";
}
$where_str = count($where) > 0 ? "WHERE " . implode(" AND ", $where) : "";
$sql = sprintf("SELECT id,name,alias,type,class,number,status,ele,mt100,checked,comment,ST_X(coord) AS y,ST_Y(coord) as x,owner,contribute FROM point2 %s ORDER BY %s OFFSET %d LIMIT %d", $where_str, $inp['jtSorting'], $inp['jtStartIndex'], $inp['jtPageSize']);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail sql: {$sql}";
}
break;
case 'create':
$sql = sprintf("SELECT count(*) as count FROM point2 WHERE owner=%d", $owner_uid);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail {$sql}" . $db->ErrorMsg();
}
// 限制最多點數
if ($rs[0]['count'] >= 100) {
$errmsg[] = "too many rows: limit 100";
break;
}
if (isset($inp['checked'])) {
$checked = 1;
} else {
$checked = 0;
}
if (isset($inp['contribute'])) {
$contribute = 1;
} else {
$contribute = 0;
}
$pp = sprintf("ST_GeomFromText('SRID=4326;POINT(%f %f)')", $inp['y'], $inp['x']);
$inp['number'] = empty($inp['number']) ? "NULL" : intval($inp['number']);
$inp['ele'] = empty($inp['ele']) ? "NULL" : intval($inp['ele']);
$sql = sprintf("insert into point2 (id, name,alias,type,class,number,status,ele,mt100,checked,comment,coord,owner,contribute) values ( DEFAULT, '%s','%s','%s','%s',%s\n\t\t\t\t,'%s', %s,'%s','%s','%s',%s, %d, %d) returning id", $inp['name'], $inp['alias'], $inp['type'], $inp['class'], $inp['number'], $inp['status'], $inp['ele'], $inp['mt100'], $checked, pg_escape_string($inp['comment']), $pp, $owner_uid, $contribute);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail {$sql}" . $db->ErrorMsg();
}
$newid = $rs[0]['id'];
$sql = sprintf("SELECT id,name,alias,type,class,number,status,ele,mt100,checked,comment,ST_X(coord) AS y,ST_Y(coord) AS x,contribute,owner FROM point2 WHERE id=%d AND owner=%d", $newid, $owner_uid);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail {$sql}" . $db->ErrorMsg();
}
break;
case 'update':
if (isset($inp['checked']) && $inp['checked'] == 1) {
$checked = 1;
} else {
$checked = 0;
}
if (isset($inp['contribute'])) {
$contribute = intval($inp['contribute']);
} else {
$contribute = 0;
}
$pp = sprintf("ST_GeomFromText('SRID=4326;POINT(%f %f)')", $inp['y'], $inp['x']);
$inp['number'] = empty($inp['number']) ? "NULL" : intval($inp['number']);
$inp['ele'] = empty($inp['ele']) ? "NULL" : intval($inp['ele']);
// 1. 檢查身份
$sql = sprintf("select owner from point2 where id=%d", $inp['id']);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail {$sql}" . $db->ErrorMsg();
}
$point_owner_id = $rs[0]['owner'];
if (!$admin) {
if ($owner_uid != $point_owner_id) {
$errmsg[] = "not owner";
break;
}
$sql = sprintf("update point2 set name='%s',alias='%s',type='%s',class='%s',number=%s,status='%s',ele=%s,mt100='%s',checked='%s',comment='%s',coord=%s,contribute='%s' WHERE id=%s and owner=%d", $inp['name'], $inp['alias'], $inp['type'], $inp['class'], $inp['number'], $inp['status'], $inp['ele'], $inp['mt100'], $checked, pg_escape_string($inp['comment']), $pp, $contribute, $inp['id'], $owner_uid);
} else {
$sql = sprintf("update point2 set name='%s',alias='%s',type='%s',class='%s',number=%s,status='%s',ele=%s,mt100='%s',checked='%s',comment='%s',coord=%s,contribute='%s',owner=%d WHERE id=%s", $inp['name'], $inp['alias'], $inp['type'], $inp['class'], $inp['number'], $inp['status'], $inp['ele'], $inp['mt100'], $checked, pg_escape_string($inp['comment']), $pp, $contribute, $inp['owner'], $inp['id']);
}
if (($rs = $db->Execute($sql)) === false) {
$errmsg[] = "fail sql: {$sql}";
}
$sql = sprintf("SELECT id,name,alias,type,class,number,status,ele,mt100,checked,comment,ST_X(coord) AS y,ST_Y(coord) as x,owner,contribute FROM point2 WHERE id=%d", $inp['id']);
if (($rs = $db->GetAll($sql)) === false) {
$errmsg[] = "fail {$sql}" . $db->ErrorMsg();
}
break;
case 'delete':
if (!$admin) {
$sql = sprintf("DELETE from point2 WHERE id=%d and owner=%d", $inp['id'], $owner_uid);
} else {
$sql = sprintf("DELETE from point2 WHERE id=%d", $inp['id']);
}
if (($rs = $db->Execute($sql)) === false) {
$errmsg[] = "fail sql: {$sql}";
}
break;
}
if (count($errmsg) > 0) {
$jTableResult = array();
$jTableResult['Result'] = "ERROR";
$jTableResult['Message'] = implode("|", $errmsg);
print json_encode($jTableResult);
return;
}
$jTableResult = array();
$jTableResult['Result'] = "OK";
if ($inp['action'] == 'create' || $inp['action'] == 'update') {
$jTableResult['Record'] = $rs[0];
} else {
$jTableResult['Records'] = $rs;
}
print json_encode($jTableResult);
}
session_start();
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/sql_functions.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/session_functions.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/exam-simulator/private/functions/input.php";
if (logged_in()) {
log_out();
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$username = fix_string($_POST['new_username']);
$password = fix_string($_POST['new_password']);
$msg = "";
if (!username_valid($username)) {
$msg .= "<li>The username provided is not valid</li>";
}
if (!password_valid($password)) {
$msg .= "<li>The password provided is not valid</li>";
}
$conn = get_conn();
$password = encrypt_password($password);
if (username_available($conn, $username) && $msg == "") {
new_user($conn, $username, $password);
log_in($username);
$msg = '<script>location.href = \'//localhost/exam-simulator/public/index.php\'</script>';
} else {
$msg .= "<li>The username already exists.</li>";
}
$conn->close();
echo $msg;
} else {
go_home();
}
public function logout($a)
{
$cursor = get_conn();
if ($cursor == False) {
$ret['message'] = "Error connecting to database";
$ret['status_code'] = 100;
$ret['success'] = False;
print json_encode($ret);
} else {
try {
$statement2 = $cursor->prepare("DELETE FROM tokens WHERE token=?");
$statement2->execute(array($a));
$ret['message'] = "Logged out Succesful";
$ret['status_code'] = 200;
$ret['success'] = True;
print json_encode($ret);
} catch (Exception $e) {
$ret['message'] = "Invalid token";
$ret['status_code'] = 100;
$ret['success'] = False;
print json_encode($ret);
}
}
}
function get_comments($question_id)
{
$conn = get_conn();
$query = "select comment, left_by from comments where question_id={$question_id}";
$result = $conn->query($query);
if (!$result) {
die(__LINE__ . " " . $conn->error);
}
$returned_array = array();
$rows = $result->num_rows;
for ($i = 0; $i < $rows; $i++) {
$result->data_seek($i);
$row = $result->fetch_array(MYSQLI_ASSOC);
$returned_array[$i] = array($row['comment'], $row['left_by']);
}
$conn->close();
return $returned_array;
}
<?php
require_once dirname(__FILE__) . '/database_connect.php';
$dbh = get_conn();
/* ---------------------------- bid_rules ------------------------------ */
$query = "DROP TABLE IF EXISTS bid_rule";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
$query = "CREATE TABLE bid_rule (\n id INT NOT NULL AUTO_INCREMENT,\n ppc_entity_id INT NOT NULL,\n ppc_entity_type SMALLINT NOT NULL DEFAULT 0,\n rule_type SMALLINT NOT NULL DEFAULT 0,\n cost_threshold FLOAT NOT NULL DEFAULT 0,\n increase_percent FLOAT NOT NULL DEFAULT 0,\n increase_days FLOAT NOT NULL DEFAULT 0,\n decrease_percent FLOAT NOT NULL DEFAULT 0,\n decrease_days FLOAT NOT NULL DEFAULT 0,\n apply TINYINT NOT NULL DEFAULT 0,\n PRIMARY KEY(id),\n UNIQUE KEY(ppc_entity_id, ppc_entity_type, rule_type)\n ) ENGINE = MyISAM ";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
/* ---------------------------- ppc_keywords ------------------------------ */
$query = "DROP TABLE IF EXISTS ppc_keywords";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
$query = "CREATE TABLE ppc_keywords (\n id INT NOT NULL AUTO_INCREMENT,\n adgroup_id INT NOT NULL DEFAULT 0,\n keyword_id VARCHAR(255) NOT NULL DEFAULT '',\n text VARCHAR(255),\n match_type VARCHAR(255),\n status VARCHAR(255),\n search_max_cpc FLOAT NOT NULL DEFAULT 0,\n new_status VARCHAR(255),\n new_search_max_cpc FLOAT NOT NULL DEFAULT 0,\n current_url TEXT,\n new_url TEXT,\n keyword_bid_rule_id INT NOT NULL DEFAULT 0,\n PRIMARY KEY(id),\n UNIQUE KEY(adgroup_id, keyword_id)\n ) ENGINE = MyISAM ";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
/* ---------------------------- ppc_ads ------------------------------ */
$query = "DROP TABLE IF EXISTS ppc_ads";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
$query = "CREATE TABLE ppc_ads (\n id INT NOT NULL AUTO_INCREMENT,\n adgroup_id INT NOT NULL DEFAULT 0,\n ad_id VARCHAR(255) NOT NULL DEFAULT '',\n ad_name VARCHAR(255),\n current_url TEXT,\n PRIMARY KEY(id),\n UNIQUE KEY(adgroup_id, ad_id)\n ) ENGINE = MyISAM ";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
/* ---------------------------- ppc_adgroups ------------------------------ */
$query = "DROP TABLE IF EXISTS ppc_adgroups";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
$query = "CREATE TABLE ppc_adgroups (\n id INT NOT NULL AUTO_INCREMENT,\n adgroup_id VARCHAR(255) NOT NULL DEFAULT '',\n campaign_id INT NOT NULL DEFAULT 0,\n adgroup_name VARCHAR(255),\n status VARCHAR(255),\n content_max_cpc FLOAT NOT NULL DEFAULT 0,\n search_max_cpc FLOAT NOT NULL DEFAULT 0,\n new_status VARCHAR(255),\n new_content_max_cpc FLOAT NOT NULL DEFAULT 0,\n default_url TEXT,\n adgroup_bid_rule_id INT NOT NULL DEFAULT 0,\n keyword_bid_rule_id INT NOT NULL DEFAULT 0,\n PRIMARY KEY(id),\n UNIQUE KEY(campaign_id, adgroup_id)\n ) ENGINE = MyISAM ";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
/* ---------------------------- ppc_campaigns ------------------------------ */
$query = "DROP TABLE IF EXISTS ppc_campaigns";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
$query = "CREATE TABLE ppc_campaigns (\n id INT NOT NULL AUTO_INCREMENT,\n campaign_id VARCHAR(255) NOT NULL DEFAULT '',\n campaign_name VARCHAR(255),\n master_account VARCHAR(255),\n account VARCHAR(255) NOT NULL DEFAULT '',\n engine VARCHAR(255) NOT NULL DEFAULT '',\n status VARCHAR(255),\n budget FLOAT NOT NULL DEFAULT 0,\n new_status VARCHAR(255),\n new_budget FLOAT NOT NULL DEFAULT 0,\n campaign_bid_rule_id INT NOT NULL DEFAULT 0,\n adgroup_bid_rule_id INT NOT NULL DEFAULT 0,\n keyword_bid_rule_id INT NOT NULL DEFAULT 0,\n PRIMARY KEY(id),\n UNIQUE KEY(engine, account, campaign_id)\n ) ENGINE = MyISAM ";
mysql_query($query, $dbh) or die('I cannot execute the query because: ' . mysql_error());
/* ---------------------------- bid_management_data ------------------------------ */
$query = "DROP TABLE IF EXISTS bid_management_data";
if (isset($_POST['question_keyword_answer_id']) && isset($_POST['keyword_answers'])) {
$question_keyword_answer_id = fix_input_array($_POST['question_keyword_answer_id']);
$keyword_answers = fix_input_array($_POST['keyword_answers']);
if (count($keyword_answers) > 0) {
for ($i = 0; $i < count($question_keyword_answer_id); $i++) {
$keyword_answers[$i] = preg_replace("/[^A-Za-z0-9 ]/", '', $keyword_answers[$i]);
// remove non alphanumeric characters
$keyword_answers[$i] = strtoupper($keyword_answers[$i]);
$kwID_answer[$question_keyword_answer_id[$i]] = array_unique(explode(' ', $keyword_answers[$i]));
$kwID_answer[$question_keyword_answer_id[$i]] = array_values($kwID_answer[$question_keyword_answer_id[$i]]);
}
}
}
if (isset($_POST['num_of_questions']) && isset($_POST['num_of_correct_answers']) && isset($_POST['questionID_order'])) {
$num_of_questions = fix_string($_POST['num_of_questions']);
$num_of_correct_answers = fix_string($_POST['num_of_correct_answers']);
$questionID_order = fix_string($_POST['questionID_order']);
$questionID_order = explode(',', $questionID_order);
}
$marked = new MarkedExam($saID_answer, $multID_answerID, $kwID_answer);
$marked->set_question_amount($num_of_questions);
$marked->set_correct_answer_amount($num_of_correct_answers);
$marked->set_questionID_order($questionID_order);
$marked->set_connection(get_conn());
$marked->generate_html();
$get_script = "\$.getScript('javascript/taken_exam.js');";
$content = $marked->get();
get_main_template($content, $get_script);
} else {
go_home();
}
function edit_task($task, $last_edit, $taskID, $userID)
{
$conn = get_conn();
$userID = (int) mysql_fix_string($conn, $userID);
$task = mysql_fix_string($conn, $task);
$last_edit = mysql_fix_string($conn, $last_edit);
$taskID = (int) mysql_fix_string($conn, $taskID);
$query = "UPDATE ajx_org_todo \n\t\t\t SET task='{$task}', last_edited='{$last_edit}'\n\t\t\t WHERE userID={$userID} AND taskID={$taskID}";
get_result($conn, $query);
$conn->close();
}
function saveAds($ads)
{
if (count($ads) > 0) {
$chunks = array_chunk($ads, MAX_INSERT_ROWS);
foreach ($chunks as $chunk) {
$query = "INSERT INTO ppc_ads (\n id,\n ad_id,\n adgroup_id,\n ad_name,\n current_url\n ) VALUES";
foreach ($chunk as $ad) {
$conn = get_conn();
$name = mysql_real_escape_string($ad->name, $conn);
$query .= "(\n {$ad->id},\n '{$ad->adId}',\n {$ad->adgroup->id},\n '{$name}',\n '{$ad->currentUrl}'\n ),";
}
$query = substr($query, 0, strlen($query) - 1);
$query .= " ON DUPLICATE KEY UPDATE\n id = VALUES(id),\n ad_id = VALUES(ad_id),\n adgroup_id = VALUES(adgroup_id),\n ad_name = VALUES(ad_name),\n current_url = VALUES(current_url)\n ";
mysql_query($query, $conn) or die(__CLASS__ . __FUNCTION__ . 'I cannot execute the query because: ' . mysql_error());
close_conn($conn);
}
}
}
function get_lastest_point($num = 5)
{
$db = get_conn();
$sql = sprintf("SELECT id,name,alias,type,class,number,status,ele,mt100,checked,comment,ST_X(coord) AS y,ST_Y(coord) AS x,owner FROM point2 WHERE owner=0 ORDER BY id DESC LIMIT %d", $num);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
return $db->getAll($sql);
}
$real_do = 0;
}
if (isset($opt['d'])) {
$cache_dir = $opt['d'];
} else {
$cache_dir = "/home/nas/twmapcache/twmap_gpx";
}
$start_mid = isset($opt['m']) ? intval($opt['m']) : 0;
$do_count = 0;
if (isset($opt['c'])) {
$do_count = intval($opt['c']);
}
if ($do_count < 1) {
$do_count = 0;
}
$db = get_conn();
$sql = sprintf("select max(mid) from gpx_wp");
$rs = $db->getAll($sql);
// 取出最大 map id
$maxid = intval($rs[0][0]) + 1;
if ($start_mid > $maxid) {
$maxid = $start_mid;
}
$keepon_only = isset($opt['k']) ? "AND keepon_id != 'NULL'" : "";
$sql = sprintf("select mid,title,filename,keepon_id FROM \"map\" WHERE gpx=1 AND flag <> 2 AND mid >= %d %s ORDER BY cdate", $maxid, $keepon_only);
$rs = $db->getAll($sql);
printf("Total %d, from mid %d\n", count($rs), $maxid);
$i = 1;
if (count($rs) > 0) {
foreach ($rs as $row) {
// debug== 三筆就好 if ($i++ > 3) break;
