static function setNotification($bookingId, $oneWeek, $threeDays, $oneDay)
{
$mysql = new MySQL();
if (self::getNotification($bookingId) === null) {
$results = $mysql->query('INSERT INTO notification(booking_id, one_week, three_days, one_day) VALUES (:booking_id, :one_week, :three_days, :one_day)', [':booking_id' => $bookingId, ':one_week' => $oneWeek, ':three_days' => $threeDays, ':one_day' => $oneDay]);
} else {
$results = $mysql->query('UPDATE notification SET one_week = :one_week, three_days = :three_days, one_day = :one_day WHERE booking_id = :booking_id', [':booking_id' => $bookingId, ':one_week' => $oneWeek, ':three_days' => $threeDays, ':one_day' => $oneDay]);
}
return $results['success'];
}
/**
* Добавить ключ если он не сущетсует или изменить его значение
*
* @param mixed $key
* @param string $value
*/
public static function setKey($key, $value)
{
$value = serialize($value);
self::dbConnector();
try {
self::$_sql->query("INSERT INTO `REGISTRY` VALUES ('{$key}','{$value}')");
} catch (Exception $ex) {
self::$_sql->query("UPDATE `REGISTRY` SET `value_serealized`='{$value}' WHERE `key`='{$key}'");
}
}
/**
* Query database. Retrun all values from a table
*
* @param $table String Table name
*
* @returns Object Database records. MySQL object
*/
public function checkNeededDataGoogleSearchAnalytics($website)
{
$core = new Core();
//Load core
$mysql = new MySQL();
//Load MySQL
$now = $core->now();
/* Identify date range */
$dateStartOffset = self::GOOGLE_SEARCH_ANALYTICS_MAX_DATE_OFFSET + self::GOOGLE_SEARCH_ANALYTICS_MAX_DAYS;
$dateStart = date('Y-m-d', strtotime('-' . $dateStartOffset . ' days', $now));
$dateEnd = date('Y-m-d', strtotime('-' . self::GOOGLE_SEARCH_ANALYTICS_MAX_DATE_OFFSET . ' days', $now));
/* Query database for dates with data */
$query = "SELECT COUNT( DISTINCT date ) AS record, date FROM " . MySQL::DB_TABLE_SEARCH_ANALYTICS . " WHERE domain LIKE '" . $website . "' AND date >= '" . $dateStart . "' AND date <= '" . $dateEnd . "' GROUP BY date";
$result = $mysql->query($query);
/* Create array from database response */
$datesWithData = array();
foreach ($result as $row) {
array_push($datesWithData, $row['date']);
}
/* Get date rante */
$dates = $core->getDateRangeArray($dateStart, $dateEnd);
/* Loop through dates, removing those with data */
foreach ($dates as $index => $date) {
if (in_array($date, $datesWithData)) {
unset($dates[$index]);
}
}
/* Reindex dates array */
$dates = array_values($dates);
$returnArray = array('dateStart' => $dateStart, 'dateEnd' => $dateEnd, 'datesWithNoData' => $dates);
return $returnArray;
}
private static function testTemplateType()
{
if (self::$clanData['premiumBis'] < time()) {
if (!empty(self::$clanData['useStandartDesign'])) {
echo "Eigenes Standart Design ";
} else {
Template::init("templates/standart_stylecheet.css");
Template::replace("{header_height}", self::$clanData['designset_headerheight']);
Template::set("Content-Type: text/css");
echo Template::out();
}
} else {
MySQL::query("SELECT * FROM `inhalte` WHERE `template`='1' AND `templateType`='5'");
if (MySQL::count()) {
MySQL::query("SELECT * FROM `inhalte` WHERE `template`='1' AND `templateType`='6'");
if (MySQL::count()) {
$row = MySQL::fetchArray();
Template::init(NULL, true, $row['inhalt']);
Template::replace("{header_height}", self::$clanData['designset_headerheight']);
Template::set("Content-Type: text/css");
echo Template::out();
}
} else {
echo "Premium Standart";
}
}
}
private static function testTemplateType()
{
if (self::$clanData['data']['premiumBis'] < time()) {
if (!empty(self::$clanData['data']['useStandartDesign'])) {
echo "Eigenes Standart Design ";
} else {
Template::init("templates/standart.html");
Template::replace("</head>", "\n" . Template::leerzeichen("<title>") . '<link rel="stylesheet" type="text/css" href="http://myclankonto.net/' . self::$routerData['clanid'] . '/stylecheet.css" />' . "\n" . Template::leerzeichen("<head>") . '</head>');
Template::replaceContent("{seiteninhalt}", "pages/site/" . self::$routerData['site'] . ".php");
Template::replace("{title}", self::$clanData['data']['pageTitle']);
echo Template::out();
}
} else {
MySQL::query("SELECT * FROM `inhalte` WHERE `clanid`='" . self::$routerData['clanid'] . "' AND `template`='1' AND `templateType`='5'");
if (MySQL::count() == 1) {
$row = MySQL::fetchArray();
Template::init(NULL, true, $row['inhalt']);
MySQL::query("SELECT * FROM `inhalte` WHERE `template`='1' AND `templateType`='6'");
if (MySQL::count()) {
Template::replace("</head>", "\n" . Template::leerzeichen("<title>") . '<link rel="stylesheet" type="text/css" href="http://myclankonto.net/' . self::$routerData['clanid'] . '/stylecheet.css" />' . "\n" . Template::leerzeichen("<head>") . '</head>');
}
Template::replaceContent("{seiteninhalt}", "pages/site/" . self::$routerData['site'] . ".php");
Template::replace("{title}", self::$clanData['data']['pageTitle']);
echo Template::out();
} else {
echo "Premium Standart";
}
}
}
public static function createEntity($identifier, $friendlyname, $lat, $lon)
{
$db = new MySQL();
$sql = 'INSERT INTO entities ';
$sql .= '(`ID`, `IDENTIFIER`, `FRIENDLYNAME`, `LATITUDE`, `LONGITUDE`, `DATETIME`, `DETACHED`) ';
$sql .= 'VALUES (\'\', %s, %s, %s, %s, NOW(), 0);';
return $db->query($sql, $identifier, $friendlyname, $lat, $lon);
}
/**
* Get a specific rating
*
* @param $offerId
* @param $userId
* @return null
*/
static function getRating($offerId, $userId)
{
$mysql = new MySQL();
$results = $mysql->query('SELECT * FROM rating WHERE offer = :offer AND createdby = :createdby', [':offer' => $offerId, ':createdby' => $userId]);
if ($results['success'] == true && !empty($results['results']) && $results['results'] != null) {
return $results['results'];
}
return null;
}
/**
* Creates a non attendance record for a booking id
*
* @param $bookingId
* @param $workshopId
* @return bool
*/
public static function createNonAttendance($bookingId, $workshopId)
{
if (self::getAttendance($bookingId) != null) {
return false;
}
$mysql = new MySQL();
$results = $mysql->query('INSERT INTO attendance(booking_id, workshop_id, student_id, attendance, learnt, taught, datecompleted) VALUES (:booking_id, :workshop_id, :student_id, :attendance, :learnt, :taught, :datecompleted)', [':booking_id' => $bookingId, ':workshop_id' => $workshopId, ':student_id' => User::getId(), ':attendance' => 0, ':learnt' => 'DID NOT ATTEND', ':taught' => 'DID NOT ATTEND', ':datecompleted' => time()]);
if ($results['success']) {
return true;
}
return false;
}
public static function getSiteData($siteId = NULL)
{
if ($siteId == NULL) {
throw new Exeption("siteData::getSiteData() haven't become an Siteid.");
} else {
MySQL::query("SELECT * FROM `webseiten` WHERE `clanid`='" . $siteId . "'");
if (MySQL::count() != 1) {
return array("success" => false, "error" => "Die Webseite mit der ID " . $siteId . " existiert nicht.");
} else {
return array("success" => true, "data" => MySQL::fetchArray());
}
}
}
/**
* Получает список дочерних разделов с учётом поля show_sub таблицы URL
*
* @return Array
*/
public function getSubSection()
{
$r = $this->_sql->query("SELECT `link`,`title` FROM `URL` WHERE `pid`={$this->_currentID} AND `module`!=0");
$t = $this->_sql->GetRows($r);
$bitOfString = $this->url = substr($_SERVER['REQUEST_URI'], 1);
$resArr = NULL;
if ($t != NULL) {
foreach ($t as $value) {
$resArr[] = array("link" => $value["link"] = "/" . $bitOfString . $value["link"] . "/", "title" => $value["title"]);
}
}
return $resArr;
}
function del($src, $dst)
{
$mysql = new MySQL();
$mysql->opendb("dns_http_ref", "utf8");
#$sql = "update `http_ref` set `status` = 'false' where `dst`='$dst' and `src`='$src'";
$sql = "delete from `http_ref` where `dst`='{$dst}' and `src`='{$src}'";
$result = $mysql->query($sql);
if ($result) {
$ret = 0;
} else {
$ret = 1;
}
print_r(json_encode(result_init($ret, '', '')));
}
public function update($record_id)
{
if (empty($db)) {
$dbConnection = new dbConnection();
$db = new MySQL($dbConnection->host, $dbConnection->userdb, $dbConnection->pass, $dbConnection->dbname);
}
$column_value_array = array_combine($this->my_columns_array, $this->my_values_array);
$update_string = '';
foreach ($column_value_array as $column => $value) {
$value = strip_tags(mysqli_real_escape_string($db->dbConn, $value));
$update_string .= $column . "='" . $value . "',";
}
$update_string = trim($update_string, ",");
$sql = "UPDATE " . $this->my_table . " SET {$update_string} WHERE " . $this->my_table . "_id = {$record_id}";
$results = $db->query($sql);
return TRUE;
}
function t($str)
{
global $CONF;
//if in maintainance mode, record this string in the translation db
if ($CONF['maintainer_mode']) {
require_once 'pastebin/mysql.class.php';
$db = new MySQL();
$db->query("select * from original_phrase where original=?", $str);
if ($db->next_record()) {
//update timestamp
$original_phrase_id = $db->f('original_phrase_id');
$db->query("update original_phrase set used=now() where original_phrase_id={$original_phrase_id}");
} else {
//create new record
$db->query("insert into original_phrase(original,used) values (?, now())", $str);
}
}
//if using english ui, just return the string
//if a translation is available, use that
//otherwise, use english
return $str;
}
public static function initCheck($domain = "myclankonto.net", $did = 1)
{
$subdomain = $_SERVER['HTTP_HOST'];
$subdomain = preg_replace("/\\." . $domain . "/Usi", "", $subdomain);
$subdomain = preg_replace("/www\\./Usi", "", $subdomain);
$subdomain = strtolower($subdomain);
if ($subdomain != $domain) {
MySQL::query("SELECT * FROM `subdomains` WHERE `domainID`='" . $did . "' AND `host`='" . $subdomain . "'");
if (MySQL::count() == 0) {
echo "null mysql";
die;
} else {
$row = MySQL::fetchArray();
if ($row['status']) {
header("Location: http://myclankonto.net/" . $row['clanid'] . "/site/intro/");
die;
} else {
echo "pff";
die;
}
}
}
}
// Includo le classi principali
include_once "../core/class.Ocarina.php";
include_once "../core/class.MySQL.php";
include_once "../core/class.Functions.php";
include_once "../rendering/config.php";
// Istanzio le classi
$cms = new Ocarina();
$db = new MySQL();
$func = new Functions();
if (!isset($_GET['nickname']) and !isset($_POST['nickname'])) {
$text = '<form action="" method="post">
Utente:<br /><select name="nickname">';
// Mi connetto al database
$db->connettidb();
// Creo una select con tutte le categorie
$query = $db->query("SELECT nickname FROM utenti");
while ($riga = $db->estrai($query)) {
$text .= '<option value="' . $func->rescape($riga->nickname) . '">' . $func->rescape($riga->nickname) . '</option>';
}
// Mi disconnetto dal database
$db->disconnettidb();
$text .= '</select><input type="submit" name="submit" value="Accedi">
</form>';
$nickname = 'Profilo';
// Per il titolo della pagina
} elseif (isset($_GET['nickname']) or isset($_POST['nickname'])) {
// Prelevo il nickname
if ($_GET['nickname']) {
$nickname = $func->escape($_GET['nickname']);
} elseif ($_POST['nickname']) {
$nickname = $func->escape($_POST['nickname']);
include_once "core/class.Ocarina.php";
include_once "core/class.MySQL.php";
include_once "core/class.Functions.php";
include_once "rendering/config.php";
// Istanzio le classi
$cms = new Ocarina();
$db = new MySQL();
$func = new Functions();
// Se si richiede la ricerca esegue
if (isset($_POST['keyword']) && $_POST['keyword'] !== '') {
// Prelevo la keyword
$keyword = $func->escape($_POST['keyword']);
// Mi connetto al database
$db->connettidb();
// Effetto le query
$query = $db->query("SELECT DISTINCT titolo,minititolo FROM pagine WHERE titolo LIKE '%" . $keyword . "%' OR contenuto LIKE '%" . $keyword . "%';");
$query2 = $db->query("SELECT DISTINCT titolo,minititolo FROM news WHERE titolo LIKE '%" . $keyword . "%' OR news LIKE '%" . $keyword . "%';");
$conta = $db->conta($query);
$conta2 = $db->conta($query2);
// Se non ci sono risultati
if ($conta <= 0 and $conta2 <= 0) {
$errore = 'Nessun risultato per la keyword immessa.';
// Visualizzo la pagina di errore
$smarty->assign("titolo", "Nessun risultato per la keyword immessa » " . $cms->nomesito());
// Titolo della pagina
$smarty->assign("errore", $errore);
// Il contenuto della pagina
$smarty->assign("description", $cms->description());
// La descrizione
$smarty->assign("keywords", $cms->keywords());
// Le keywords
/**
* Decline an offer
*
* @param $id
* @return mixed
*/
static function declineOffer($id)
{
$mysql = new MySQL();
$results = $mysql->query('UPDATE offer SET status = 2 WHERE id = :id', [':id' => $id]);
return $results['success'];
}
<?php
if (!$_GET['ID']) {
error('导入配置编号不能为空!');
}
if (!is_numeric($_GET['ID'])) {
error('导入配置编号只能是数字!');
}
$sql = 'SELECT * ';
$sql .= 'FROM ' . TB_DB2DB . ' ';
$sql .= 'WHERE id = ' . $_GET['ID'];
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$rs = $db->query($sql);
$rs->next_record();
if (!$rs) {
error('没有找到需要的导入配置');
}
if (!$_GET['action']) {
$tp->set_templatefile('templates/db_cfg_copy.html');
$tp->assign('id', $rs->get('id'));
$tp->assign('cfgname', $rs->get('name'));
$moduleTemplate = $tp->result();
$moduleTitle = '复制导入配置';
$db->disconnect();
} else {
$configName = trim($_POST['configname']);
if (!$_POST['configname']) {
error('请输入配置名称');
}
$sourceArray = $rs->getarray();
foreach ($sourceArray as $key => $val) {
/**
* Open an advertisement
*
* @param $id
* @return mixed
*/
static function open($id)
{
$mysql = new MySQL();
$results = $mysql->query('UPDATE advertisement SET status = 1 WHERE id = :id', [':id' => $id]);
return $results['success'];
}
<?php
session_start();
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
require_once "../config/config.inc.php";
$challenge = new Challenge();
if (isset($_POST['m'])) {
$mail = util::getPost('m');
$db = new MySQL(HOST, DB_USER, DB_PASSWORD, DB_NAME);
$sql = "SELECT mfrom,mto,msubject,mbody,mdate FROM mailbox m,players u WHERE u.id=m.userid AND u.name='" . $challenge->getUser() . "' AND m.mailid={$mail}";
// echo $sql;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$text = <<<EOT
<div id="message">
<!-- mail starts here -->
<table id="mailheader" cellpadding="15" cellspacing="3">
<tr><td align="right">To:</td><td> </td><td>{$mto}</td></tr>
<tr><td align="right">From:</td><td> </td><td>{$mfrom}</td></tr>
<tr><td align="right">Date:</td><td> </td><td>{$mdate}</td></tr>
<tr><td align="right">Subject:</td><td> </td><td>{$msubject}</td></tr>
</table>
<hr/>
<div id="mailbody">{$mbody}</div>
<!-- mail ends here -->
</div>
EOT;
<?php
/**
Author: SpringHack - springhack@live.cn
Last modified: 2015-12-29 12:21:13
Filename: expert.common.php
Description: Created by SpringHack using vim automatically.
**/
require_once 'MySQL.class.php';
$db = new MySQL();
if ($db->query("SHOW TABLES LIKE 'Expert'")->num_rows() != 1) {
$db->struct(array('school' => 'text', 'user_id' => 'text', 'user_pw' => 'text', 'name' => 'text', 'birthday' => 'text', 'nation' => 'text', 'sex' => 'text', 'what' => 'text', 'job' => 'text', 'job_name' => 'text', 'job_level' => 'text', 'job_what' => 'text', 'tele' => 'text', 'cell' => 'text', 'last_a' => 'text', 'last_b' => 'text', 'last_c' => 'text', 'for' => 'text', 'addr' => 'text', 'code' => 'text', 'email' => 'text', 'sub' => 'text', 'work' => 'text', 'rise' => 'text', 'area' => 'text', 'service' => 'text', 'time' => 'text'))->create("Expert");
}
<?php
/**
Author: SpringHack - springhack@live.cn
Last modified: 2015-12-20 12:59:18
Filename: user.common.php
Description: Created by SpringHack using vim automatically.
**/
require_once 'MySQL.class.php';
$db = new MySQL();
if ($db->query("SHOW TABLES LIKE 'User'")->num_rows() != 1) {
$db->struct(array('id' => 'text', 'user' => 'text', 'pass' => 'text', 'nick' => 'text', 'power' => 'text', 'birthday' => 'text', 'school' => 'text', 'use' => 'text'))->create("User");
$db->value(array('id' => '0', 'user' => 'admin', 'pass' => 'admin', 'nick' => '管理员', 'power' => '0', 'birthday' => '0', 'school' => 'none', 'use' => 'yes'))->insert("User");
}
@session_start();
$page = isset($_GET["page"]) && preg_match("/^[0-9]+\$/", $_GET["page"]) ? $_GET["page"] : 0;
$user_file = "/etc/mysql-user/user5000.ini";
if ($fp_user = fopen($user_file, "r")) {
$userName = rtrim(fgets($fp_user));
$password = rtrim(fgets($fp_user));
$database = rtrim(fgets($fp_user));
} else {
die("接続設定の読み込みに失敗しました");
}
$mysql = new MySQL($userName, $password, $database);
if ($mysql->connect_error) {
die("データベースの接続に失敗しました");
}
// 掲示板情報を取得
$sql = "UPDATE `board` SET `access_cnt`=`access_cnt`+1 WHERE `name`='{$id}'";
$mysql->query($sql);
$sql = "SELECT * FROM `board` WHERE `name`='{$id}'";
$result = $mysql->query($sql);
if (!$result->num_rows) {
die("ERROR03:存在しないIDです");
}
$board = new Board($result->fetch_array());
$title = $board->title;
// スレッド数を取得
$sql = "SELECT COUNT(1) AS `count` FROM `thread` WHERE `bid`='{$board->bid}'";
$result = $mysql->query($sql);
if ($mysql->error) {
die("ERROR04:存在しないIDです");
}
$array = $result->fetch_array();
$rows = $array["count"];
<?php
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
if (!trim($_GET['action'])) {
$sql = 'SELECT id, name ';
$sql .= 'FROM ' . TB_RULES . ' ';
$sql .= 'ORDER BY id DESC';
$rs = $db->query($sql);
$i = 0;
while ($rs->next_record()) {
$list['option'][$i]['rulesID'] = $rs->get('id');
$list['option'][$i]['rulesName'] = $rs->get('name');
$rs->get('id') == $_GET['rules'] ? $list['option'][$i]['rulesSelected'] = ' selected' : ($list['option'][$i]['rulesSelected'] = '');
++$i;
}
$tp->set_templatefile('templates/body_img_collection_form.html');
$tp->assign($list);
$tp->assign('display_markall', 'none');
$tp->assign('display_mark_text', 'block');
$tp->assign('display_mark_image', 'none');
$tp->assign('rulesID', $_GET['rules']);
$moduleTemplate = $tp->result();
$moduleTitle = '文章图片采集';
} else {
if ($_GET['action'] == 'getReady') {
if (!$_POST['eachTimes']) {
error('请您输入每次采集的条数');
}
if (!is_numeric($_POST['eachTimes'])) {
error('每次采集条数只能是数字');
}
$smarty->assign("url_cms", $cms->url_cms());
$smarty->assign("url_smartytpl", $cms->url_smartytpl());
$smarty->assign("cmsversion", $cms->cmsversion());
$smarty->display("admin/index/index2.tpl");
exit;
}
/* START */
// Prelevo il nickname
$nickname = $db->nickname($_COOKIE[$func->cookie()]);
if (isset($_POST['modificaprofilo'])) {
$email = $func->escape($_POST['email']);
$avatar = $func->escape($_POST['avatar']);
// Modifico il profilo
$db->connettidb();
// Mi connetto al database
$query = $db->query("UPDATE utenti SET email='{$email}', avatar='{$avatar}' WHERE nickname='{$nickname}'");
$db->disconnettidb();
// Mi disconnetto dal database
// Visualizzo la pagina
$text = 'Il tuo profilo è stato modificato.';
$smarty->assign("titolo", "Modifica profilo");
$smarty->assign("contents", $text);
$smarty->assign("url_cms", $cms->url_cms());
$smarty->assign("url_smartytpl", $cms->url_smartytpl());
$smarty->assign("cmsversion", $cms->cmsversion());
$smarty->display("admin/index/index2.tpl");
exit;
}
// Stampo i dati attuali
if (!isset($_POST['modificaprofilo'])) {
$db->connettidb();
fclose($confFileHandler);
/* Include resources */
include_once 'inc/code/core.php';
//Core functions
include_once 'inc/code/mysql.php';
//Database Connection
$core = new Core();
//Load core
$mysql = new MySQL();
//Load MySQL
require_once $GLOBALS['basedir'] . 'config/config.php';
//Credentials & Configuration
$GLOBALS['db'] = $core->mysql_connect_db();
// Connect to DB
$query = "ALTER TABLE `search_analytics` CHANGE `ctr` `ctr` FLOAT NOT NULL";
$result = $mysql->query($query);
$alert = array("type" => "success", "message" => "Upgrade performed succesfully.");
break;
}
}
?>
<?php
include_once 'inc/html/_alert.php';
?>
<h1>Organic Search Analytics | Upgrade</h1>
<div>Certain versions require special consideration when upgrading. This page will take care of technical changes that need to be made.</div>
<ul>
<li>
<h2>Version 1.x to 2.0.0</h2>
<?php
// Подключение настроек;
include $_SERVER['DOCUMENT_ROOT'] . '/config.php';
// Подключение библиотеки MySQL;
include $_SERVER['DOCUMENT_ROOT'] . '/mysql.php';
// Создание объекта MySQL;
$db = new MySQL();
$db->connect($db_host, $db_name, $db_user, $db_password);
$db->query("SET NAMES `UTF8`");
// Подключение дополнительных функций;
include $_SERVER['DOCUMENT_ROOT'] . '/functions.php';
<?
/*
* Sintaxe: table nome da tabela onde procurar a imagem id id da imagem
* typeField nome do campo tipo da imagem imgField nome do campo onde está a
* imagem - blob
*/
error_reporting ( E_ALL );
include_once ("classes.inc.php");
$db = new MySQL ();
$db->open ();
$sql = "SELECT *
FROM " . $_REQUEST ['table'] . "
WHERE id_" . $_REQUEST ['table'] . "='" . $_REQUEST ['id'] . "'";
$db->query ( $sql );
$varTabela = $db->result ( 0, $_REQUEST ['typeField'] );
header ( "Content-type: $varTabela" );
echo $db->result ( 0, $_REQUEST ['imgField'] );
$db->close ();
?>
$XMLContent .= str_repeat(' ', $depth - 1) . '</' . $CNTag[$endMark] . '>
';
}
}
$CNTag = array('nc_dbexport_config' => '易采_采集器数据库配置', 'information' => '配置信息', 'version' => '软件版本', 'config_name' => '配置名称', 'author' => '作者名字', 'contact' => '联系方式', 'readme' => '导出说明', 'date' => '导出时间', 'access' => '数据库设置', 'access_type' => '数据库类型', 'access_host' => '数据库地址', 'access_user' => '数据库用户', 'access_pass' => '数据库密码', 'access_dbname' => '数据库名称', 'otherdb' => '导出数据库设置', 'otherdb_table' => '导出数据库对应表', 'otherdb_fields' => '导出数据库对应字段', 'otherdb_rules' => '导出数据库对应关系');
if (!$_GET['ID']) {
error('导出的配置编号不能为空!');
}
if (!is_numeric($_GET['ID'])) {
error('导出的配置编号只能是数字!');
}
$sql = 'SELECT * ';
$sql .= 'FROM ' . TB_DB2DB . ' ';
$sql .= 'WHERE id = ' . $_GET['ID'];
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$rs = $db->query($sql);
$rs->next_record();
if (!$rs) {
error('找不到编号为' . $_GET['ID'] . '的数据库导出配置');
}
if (!$_GET['action']) {
$tp->set_templatefile('templates/db_cfg_export.html');
$tp->assign('id', $rs->get('id'));
$tp->assign('config_name', $rs->get('name'));
$moduleTemplate = $tp->result();
$moduleTitle = '数据库导出配置';
$db->disconnect();
} else {
$configName = trim($_POST['configname']);
if (!$_POST['config_name']) {
error('请输入配置名称');
// Istanzio le classi
$cms = new Ocarina();
$db = new MySQL();
$func = new Functions();
// Prima di procedere controllo se l' utente è già loggato
if ($func->logged() == 0) {
$text = 'Non risulti loggato, non hai bisogno di effettuare il logout.';
// Visualizzo la pagina
$smarty->assign("titolo", "Logout");
$smarty->assign("cookie", $db->auth($_COOKIE[$func->cookie()]));
$smarty->assign("grado", $db->grado($_COOKIE[$func->cookie()]));
$smarty->assign("contents", $text);
$smarty->assign("url_cms", $cms->url_cms());
$smarty->assign("url_smartytpl", $cms->url_smartytpl());
$smarty->assign("cmsversion", $cms->cmsversion());
$smarty->display("admin/index/index2.tpl");
exit;
}
// Prelevo il codice dal cookie
$codice = $_COOKIE[$func->cookie()];
// Mi connetto al database
$db->connettidb();
// Elimino il codice dal database
$query = $db->query("UPDATE utenti SET codice='' WHERE codice='{$codice}'");
// Mi disconnetto dal database
$db->disconnettidb();
// Effettuo il logout distruggendo il cookie
setcookie($func->cookie(), '', time() - 1, "/");
// Dirigo l' utente verso la index
header("Location: index.php");
exit;