/**
* Lezárja az adatbázis kapcsolatot (A PDO objektum-hoz a null értéket rendeli hozzá)
*/
public static function close_connect()
{
if (self::$connect != null) {
self::$connect = null;
}
return self::$connect;
}
public function GuardarAlbaranes()
{
$db = new db();
$db->connect();
$C = new ActiveRecord('albaranes');
$C->fields["fecha"] = $this->fecha;
$C->fields["operacion"] = $this->operacion;
$C->fields["guia"] = $this->guia;
$C->fields["remitente"] = $this->remitente;
$C->fields["beneficiario"] = $this->beneficiario;
$C->fields["documento"] = $this->documento;
$C->fields["pais"] = $this->pais;
$C->fields["direccion"] = $this->direccion;
$C->fields["ciudad"] = $this->ciudad;
$C->fields["telefono"] = $this->telefono;
$C->fields["descripcion"] = $this->descripcion;
$C->fields["peso"] = $this->peso;
$C->fields["comision"] = $this->comision;
$C->fields["seguro"] = $this->seguro;
$C->fields["iv"] = $this->iv;
$C->fields["total"] = $this->total;
$C->fields["direccion_agencia"] = $this->direccion_agencia;
$C->insert();
$db->close();
}
function authenticate($U, $P, $recordar = 0, $by = 'usuario')
{
$RESULT = false;
if (trim($U) != '' && trim($P) != '') {
$db = new db();
$db->connect();
$sql = ' SELECT * FROM usuarios
WHERE ( ' . $by . ' = "' . mysql_real_escape_string($U) . '" )
AND ( password = "******" )
';
$db->query($sql);
// no existe
$RESULT = false;
while ($record = $db->next()) {
// LOGEAR
$this->creaSession($record);
$RESULT = true;
if ($recordar) {
$two_months = time() + 30 * 24 * 3600;
setcookie('id_usuario', $U, $two_months);
setcookie('contrasena', $P, $two_months);
}
}
$db->close();
}
return $RESULT;
}
private function getDB($token)
{
if (!$token) {
return hg_ConnectDB();
}
$servindex = $this->get_serv_index($token);
$servindex = $servindex - 1;
if ($servindex == -1) {
$ServDB = hg_ConnectDB();
$this->iscp = true;
} else {
$this->iscp = false;
$servers = hg_load_login_serv();
if (!$servers) {
$ServDB = hg_ConnectDB();
} else {
$server = $servers[$servindex];
if ($server) {
include_once ROOT_PATH . 'lib/db/db_mysql.class.php';
$ServDB = new db();
$server['pass'] = hg_encript_str($server['pass'], false);
$ServDB->connect($server['host'], $server['user'], $server['pass'], $server['database'], $server['charset'], $server['pconnect']);
$this->dbname = $server['database'] . '.';
} else {
$ServDB = hg_ConnectDB();
}
}
}
return $ServDB;
}
public function getTableDS($table)
{
$sql = 'SELECT * FROM ' . $table . ' ORDER BY id';
db::connect();
$result = db::dataSource($sql);
return $result;
}
private function _prepare()
{
db::connect();
dibi::addSubst('table', 'students');
dibi::addSubst('courses_students', 'courses_students');
dibi::addSubst('courses', 'courses');
}
public function userInfo($id)
{
$bd = new db();
$bd->connect();
$this->query = mysql_query("SELECT * FROM users WHERE id = '{$id}'") or die(mysql_error());
$this->data = mysql_fetch_array($this->query);
return $this->data;
}
private function insertIntoPlaylistIndex($videoID, $playlist)
{
$db = new db();
$db->connect();
$videoID = mysql_real_escape_string($videoID);
$query = "INSERT INTO playlistindex ( id, video ) VALUES ( '{$playlist}' , '{$videoID}' );";
$result = mysql_query($query) or die('Could not add video.');
mysql_close();
}
public function getDate($id)
{
$db = new db();
$db->connect();
$query = "SELECT publishedOn FROM videos WHERE id = '{$id}' LIMIT 1;";
$result = mysql_query($query);
$data = mysql_fetch_assoc($result, MYSQL_ASSOC);
$date = $data['publishedOn'];
return strtotime($date) == strtotime("0") ? strtotime("06/01/2015") : strtotime($date);
}
function getPage()
{
$page = checkPage();
$db = new db();
$db->connect();
$pageData = getPageData($page);
if (count($pageData) <= 1) {
$pageData = getPageData("404");
header("HTTP/1.1 404 Not Found");
}
sendPage($pageData);
}
public function actionIndex()
{
$model = new Install();
$file = base_path() . 'config/database.php';
if (!is_writable($file)) {
$data['error'] = __('config/database.php is not writable');
}
$model->host = "localhost";
if ($model->load($_POST)) {
if (!$data['error']) {
$dsn = "mysql:host=" . trim($model->host) . ";dbname=" . trim($model->host_db);
$username = trim($model->host_user);
$model->host_pwd = $password = trim($_POST['Install']['host_pwd']);
$db = new \db();
$db->connect($dsn, $username, $password);
if (!$db->id) {
$data['error'] = __('connect host failed');
} else {
$content = \Yii::getAlias('@application/config/database.php');
$content = file_get_contents($content);
$content = str_replace('{dsn}', $dsn, $content);
$content = str_replace('{user}', $username, $content);
$content = str_replace('{pwd}', $password, $content);
file_put_contents($file, $content);
$rows = $db->query("SHOW TABLES")->all();
if ($rows) {
foreach ($rows as $r) {
foreach ($r as $v) {
$li[] = $v;
}
}
}
if (!$li || !in_array('auth_access', $li)) {
$row = $db->query("SHOW VARIABLES LIKE '%basedir%'")->one();
$this->bin = $row->Value;
$sql = $this->bin . "/bin/mysql -u" . $username . " -p" . $password . " " . trim($model->host_db) . " < " . \Yii::getAlias('@application/install.sql');
exec($sql);
}
$pwd = crypt(trim($model->password), $this->salt());
$u = $this->escap(trim($model->username));
$e = $this->escap(trim($model->email));
$sql = "INSERT INTO auth_users SET username='******',email='{$e}',password='******',active=1,created=" . time() . ",updated=" . time();
$db->query($sql);
flash('success', __('install success'));
$this->redirect(url('install/success'));
}
}
}
$data['url'] = $url;
$data['model'] = $model;
return $this->render('index', $data);
}
public static function verEstadosPais()
{
$db = new db();
$db->connect();
$query = 'SELECT * FROM lista_estados WHERE id_pais = ' . self::$id_pais;
$db->query($query);
$Arr = array();
while ($r = $db->next()) {
$Arr[] = $r;
}
$db->close();
return $Arr;
}
public function exists($email, $password)
{
$query = "SELECT name,email,password FROM users WHERE email= '" . $email . "'AND password='******'";
db::connect();
$result = db::selectquery($query);
if ($result) {
$this->name = $result[0]['name'];
}
if ($result) {
$data = $result ? $this : false;
}
return $data;
}
private function addVideoToDB($data, $playlist)
{
$db = new db();
$db->connect();
$id = $data['items'][0]['id'];
$title = mysql_real_escape_string($data['items'][0]['snippet']['title']);
$description = mysql_real_escape_string($data['items'][0]['snippet']['description']);
$thumbnail = mysql_real_escape_string($data['items'][0]['snippet']['thumbnails']['medium']['url']);
$query = "INSERT INTO videos ( id, title, description, thumbnail ) VALUES ( '{$id}' , '{$title}' , '{$description}' , '{$thumbnail}' );";
$result = mysql_query($query) or die('Could not add video.');
mysql_close();
$this::setVideoPlaylist($id, $playlist);
}
public function addPage($link, $title, $description, $feature, $content)
{
$db = new db();
$db->connect();
$link = mysql_real_escape_string($link);
$title = mysql_real_escape_string($title);
$description = mysql_real_escape_string($description);
$feature = mysql_real_escape_string($feature);
$content = mysql_real_escape_string($content);
$query = "\n\t\t\tINSERT INTO `pages`(`uid`, `link`, `title`, `description`, `feature`, `content`)\n\t\t\tVALUES (NULL, '{$link}', '{$title}', '{$description}', '{$feature}', '{$content}')";
$result = mysql_query($query) or die('Could not add page.');
mysql_close();
}
function verCiudadPais()
{
$db = new db();
$db->connect();
$query = 'SELECT * FROM lista_estados WHERE id_pais = ' . $this->id_pais;
$db->query($query);
$Arr = array();
while ($r = $db->next()) {
$Arr[] = $r;
}
return $Arr;
$db->close();
}
public function __construct()
{
$_db = new db();
$_db->connect(HOST, USER, PASSWORD, DB);
/*$ob_mysqli = new mysqli(HOST,USER,PASSWORD,DB);*/
if (!$ob_mysqli->connect_error) {
$this->_db = $_db;
$this->_db->query("SET NAMES 'utf8'");
return $this->_db;
} else {
exit("No connect to server");
}
}
function start()
{
db::connect();
if (!router::get(1)) {
return true;
}
self::$map = array('mode' => router::get(0), 'app' => router::get(1), 'module' => 'main', 'action' => router::get(2), 'id' => router::get(4));
s::set('SYS_PATH', 'http://' . SERVER . SYS_DIR);
define('APP', APPS . self::get('app') . '/');
s::set('APP', APP);
define('MODULE', APP . self::get('module') . '/');
s::set('MODULE', MODULE);
if (stristr(self::$map['mode'], 'admin')) {
self::$map['mode'] = 'admin';
} else {
self::$map['mode'] = 'web';
}
if (self::$map['mode'] == 'admin') {
if (defined('ADMIN_USER_SITE_ID')) {
admin::observer();
define('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
s::set('ADMIN_SITE_ID', ADMIN_USER_SITE_ID);
db::table('admin_sites');
db::where('site_id', ADMIN_USER_SITE_ID);
db::limit(1);
$row = db::select();
define('ADMIN_SITE', db::get('site_domain'));
s::set('ADMIN_SITE', ADMIN_SITE);
}
} else {
web::getSite();
$lang = lang::gets(LANG_INDEX, SITE_ID);
/*
Authentification webUser
*/
web::observer();
}
/*
Set params
*/
params::send();
if (router::get(0) == 'feed' || router::get(0) == 'rss') {
self::$map['module'] = 'feed';
}
if (self::$map['mode'] == 'admin') {
load::module(self::get('app'), self::get('module'), self::get('action'));
} else {
load::handler(self::get('app'), self::get('module'), self::get('action'));
}
}
public function verFuncionalidades()
{
$db = new db();
$db->connect();
$query = 'SELECT * FROM fk_privileges';
$db->query($query);
$Arr = array();
while ($r = $db->next()) {
$r['privilege_desc'] = utf8_encode($r['privilege_desc']);
$Arr[] = $r;
}
$db->close();
return $Arr;
}
function connect($basehost = DB_HOST, $baseuser = DB_USER, $basepass = DB_PASS, $dbname = DB_NAME)
{
if (self::$connect) {
return true;
}
$db = mysql_connect($basehost, $baseuser, $basepass);
if (!$db) {
exit("Datebase connection failed.");
} else {
self::$connect = true;
}
if (!mysql_select_db($dbname)) {
exit("Datebase select failed.");
}
self::charset();
}
/** Return true if email correct, false if isn't. In $this->errors will put the id error.
*
* @param string $email
* @return boolean
*/
private function check_email($email)
{
// Connecting to database
db::connect();
if (!empty($email) && preg_match("/^[-\\w.]+@([A-z0-9][-A-z0-9]+\\.)+([A-z]{2,4}\\.)?[A-z]{2,4}+\$/", $email)) {
return true;
}
if (empty($email)) {
$this->errors[] = 1;
// Empty email
} else {
$this->errors[] = 2;
// Email incorrect!
return false;
}
}
function syn_missed_calls()
{
require '/var/www/html/mysqldb.php';
require '/var/www/html/config.php';
$db = new db();
$db->connect($db_config);
$sql = "SELECT closecallid,lead_id,list_id,campaign_id,call_date,start_epoch,end_epoch, length_in_sec,status,phone_code,phone_number,user,comments,processed,queue_seconds,user_group,xfercallid, term_reason,uniqueid,agent_only,queue_position,ring_sec,drop_history FROM " . $db_config["database"] . ".vicidial_closer_log where drop_history ='0';";
$res = $db->row_query($sql);
//echo $row_q['drop_history'];
foreach ($res as $row_q) {
$history = $row_q['drop_history'];
if ($db->isNeedSyn($row_q)) {
$db->SynRecords($row_q, 2);
$db->row_query("UPDATE " . $db_config["database"] . ".vicidial_closer_log SET drop_history='1' where drop_history='0'");
}
}
}
public function logIn($login, $password)
{
$security = new Security();
$bd = new db();
$bd->connect();
$password = md5($password);
$query = "SELECT * FROM users WHERE login = '******' AND password = '******'";
$this->query = $security->secureQuery($query, $login, $password);
$this->total = mysql_num_rows($this->query);
if ($this->total == "") {
echo "User or password incorrect.";
} else {
$this->data = mysql_fetch_array($this->query);
// Criar sessao
$_SESSION['xo'] = $this->data['login'];
$_SESSION['xo_idGroup'] = $this->data['id_group'];
header("Location: manager.php");
}
}
protected function _db_disconnect()
{
if (!$this->lock_connect && $this->connected) {
switch ($this->connect_method) {
case 'connect':
$this->db->connect(DBUSER, DBPASS, DBNAME, DBHOST);
//$this->db->query("SET CHARACTER SET '" . COLLATE . "'");
break;
case 'use':
$this->db->query("USE `" . DBNAME . "`");
$this->db->query("SET NAMES '" . COLLATE . "'");
break;
default:
$this->db->query("SET NAMES '" . COLLATE . "'");
//$this->db->query("SET CHARACTER SET '" . COLLATE . "'");
break;
}
$this->connected = false;
}
}
private function getSQLQuery($isSearch, $pageArray, $userQuery, $playlist)
{
$db = new db();
$db->connect();
if ($playlist == 'playlistList') {
if ($isSearch) {
$searchTerm = '%' . mysql_real_escape_string($userQuery) . '%';
return 'SELECT * from playlists WHERE name LIkE \'' . $searchTerm . '\' LIMIT ' . $pageArray[0] . ', ' . $pageArray[1] . ';';
} else {
return 'SELECT * from playlists WHERE 1 LIMIT ' . $pageArray[0] . ', ' . $pageArray[1] . ';';
}
} else {
$playlistQuery = $this->queryPlaylist($playlist);
if ($isSearch) {
$searchTerm = '%' . mysql_real_escape_string($userQuery) . '%';
return 'SELECT * FROM videos WHERE `id` = "' . subStr($searchTerm, 1, 11) . '" OR title LIKE \'' . $searchTerm . '\' AND ' . $playlistQuery . ' OR keywords LIKE \'' . $searchTerm . '\' AND ' . $playlistQuery . ' ORDER BY publishedOrder DESC LIMIT ' . $pageArray[0] . ', ' . $pageArray[1] . ';';
} else {
return 'SELECT * FROM videos WHERE ' . $playlistQuery . ' ORDER BY publishedOrder DESC LIMIT ' . $pageArray[0] . ', ' . $pageArray[1] . ';';
}
}
}
public function comboGroups($id)
{
$bd = new db();
$bd->connect();
$this->query = mysql_query("SELECT * FROM groups ORDER by name ASC");
$this->total = mysql_num_rows($this->query);
if ($this->total != "") {
while ($this->data = mysql_fetch_array($this->query)) {
if ($id == "") {
echo '<option value="' . $this->data["id"] . '">' . $this->data["name"] . '</option>';
} else {
if ($id == $this->data["id"]) {
echo '<option value="' . $this->data["id"] . '" selected>' . $this->data["name"] . '</option>';
} else {
echo '<option value="' . $this->data["id"] . '">' . $this->data["name"] . '</option>';
}
}
}
} else {
echo "Doen't exist groups!";
}
}
public function addMessage($attachments)
{
try {
$con = db::connect();
$con->beginTransaction();
$query = "INSERT INTO messages\n (username, timestamp, thread_id, text)\n VALUES\n ('" . $this->user . "', '" . $this->timestamp . "', " . $this->thread_id . ", '" . $this->text . "')";
$con->exec($query);
$id = $con->lastInsertId();
$attch = null;
if (is_array($attachments)) {
$this->attachments = [];
foreach ($attachments as $attachment) {
$attch = new ModelAttachment($id, $attachment['link'], $attachment['title']);
array_push($this->attachments, $attch->addAttachments($con));
}
}
$con->commit();
} catch (PDOException $e) {
$con->{$rollback};
return false;
}
$res = array('id' => $id, 'username' => $this->user, 'timestamp' => $this->timestamp, 'thread_id' => $this->thread_id, 'text' => $this->text, 'likes' => 0, 'didlike' => false, 'attachments' => $this->attachments);
return $res;
}
static function init()
{
define("DP_VER", "1.0.1", false);
defined("CORE_PATH") or define("CORE_PATH", __DIR__);
defined("ROOT_PATH") or define("ROOT_PATH", dirname(CORE_PATH));
defined("PLUGIN_PATH") or define("PLUGIN_PATH", ROOT_PATH . "/plugins");
defined("APP_PATH") or define("APP_PATH", ROOT_PATH . "/app");
defined("LOG_PATH") or define("LOG_PATH", ROOT_PATH . "/logs");
function L($module = _MODULE_)
{
return app::in($module . "Logic", $module . "\\libs\\" . $module);
}
function P($lib, $module = _MODULE_)
{
return app::in($module . "_" . $lib, $module . "\\libs\\" . $lib);
}
function C($key, $item = "")
{
if (!isset(app::$config[$key])) {
$split = explode(".", $key);
$dest = count($split) > 1 ? $split[0] . "/config/" . $split[1] : "config/" . $split[0];
app::$config[$key] = (include APP_PATH . "/{$dest}.php");
}
return empty($item) ? app::$config[$key] : app::$config[$key][$item];
}
//autoload
spl_autoload_register(function ($className) {
$class = "/" . str_replace("\\", "/", $className) . ".php";
self::autoLoad($class, array(CORE_PATH, APP_PATH, ROOT_PATH));
});
plugin::init();
session::start();
self::$config = (include ROOT_PATH . "/config/app.php");
empty(self::$config['db']) || db::connect(self::$config['db']);
empty(self::$config['rule']) || router::set(self::$config['rule']);
}
function step3(&$install_error, &$install_recover)
{
global $html_title, $html_header, $html_footer;
if ($_POST['submitform'] != 'submit') {
return;
}
$db_host = $_POST['db_host'];
$db_port = $_POST['db_port'];
$db_user = $_POST['db_user'];
$db_pwd = $_POST['db_pwd'];
$db_name = $_POST['db_name'];
$db_prefix = $_POST['db_prefix'];
$admin = $_POST['admin'];
$password = $_POST['password'];
if (!$db_host || !$db_port || !$db_user || !$db_pwd || !$db_name || !$db_prefix || !$admin || !$password) {
$install_error = '输入不完整，请检查';
}
if (strpos($db_prefix, '.') !== false) {
$install_error .= '数据表前缀为空，或者格式错误，请检查';
}
if (strlen($admin) > 15 || preg_match("/^\$|^c:\\con\\con\$| |[,\"\\s\t\\<\\>&]|^游客|^Guest/is", $admin)) {
$install_error .= '非法用户名，用户名长度不应当超过 15 个英文字符，且不能包含特殊字符，一般是中文，字母或者数字';
}
if ($install_error != '') {
reutrn;
}
if (!@mysql_connect($db_host . ":" . $db_port, $db_user, $db_pwd)) {
$install_error = '数据库连接失败';
return;
}
if (mysql_get_server_info() > '5.0') {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$db_name}` DEFAULT CHARACTER SET " . DBCHARSET);
} else {
$install_error = '数据库必须为MySQL5.0版本以上';
return;
}
if (mysql_errno()) {
$install_error = mysql_error();
return;
}
if ($_POST['install_recover'] != 'yes' && ($query = mysql_query("SHOW TABLES FROM {$db_name}"))) {
while ($row = mysql_fetch_row($query)) {
if (preg_match("/^{$db_prefix}/", $row[0])) {
$install_error = '数据表已存在，继续安装将会覆盖已有数据';
$install_recover = 'yes';
return;
}
}
}
require 'step_4.php';
$sitepath = strtolower(substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/')));
$sitepath = str_replace('/install', "", $sitepath);
$auto_site_url = strtolower('http://' . $_SERVER['HTTP_HOST'] . $sitepath);
write_config($auto_site_url);
//execute sql
$db = new db();
$db->connect($db_host . ":" . $db_port, $db_user, $db_pwd, $db_name, DBCHARSET);
if (strtoupper(DBCHARSET) == 'GBK') {
$_charset = 'gbk';
} else {
$_charset = 'utf8';
}
$sql = file_get_contents("data/{$_charset}.sql");
$sql .= "\r\n" . file_get_contents("data/{$_charset}_cms.sql");
$sql .= "\r\n" . file_get_contents("data/{$_charset}_circle.sql");
$sql .= "\r\n" . file_get_contents("data/{$_charset}_microshop.sql");
if ($_POST['demo_data'] == '1') {
$sql .= file_get_contents("data/{$_charset}_add.sql");
}
$sql = str_replace("\r\n", "\n", $sql);
runquery($sql, $db_prefix, $db);
showjsmessage('初始化数据 ... 成功 ');
/**
* 转码
*/
if (strtoupper(DBCHARSET) == 'GBK') {
$sitename = iconv('UTF-8', 'GBK', $_POST['site_name']);
$username = iconv('UTF-8', 'GBK', $_POST['admin']);
$password = iconv('UTF-8', 'GBK', $_POST['password']);
$store_name = iconv('UTF-8', 'GBK', $_POST['store_name']);
$member_name = iconv('UTF-8', 'GBK', $_POST['member_name']);
$seller_name = iconv('UTF-8', 'GBK', $_POST['seller_name']);
$member_password = iconv('UTF-8', 'GBK', $_POST['member_password']);
} else {
$sitename = $_POST['site_name'];
$username = $_POST['admin'];
$password = $_POST['password'];
$store_name = $_POST['store_name'];
$member_name = $_POST['member_name'];
$seller_name = $_POST['seller_name'];
$member_password = $_POST['member_password'];
}
/**
* 产生随机的md5_key，来替换系统默认的md5_key值
*/
$md5_key = md5(random(4) . substr(md5($_SERVER['SERVER_ADDR'] . $_SERVER['HTTP_USER_AGENT'] . $db_host . $db_user . $db_pwd . $db_name . substr(time(), 0, 6)), 8, 6) . random(10));
$db->query("UPDATE {$db_prefix}setting SET value='" . $sitename . "' WHERE name='site_name'");
$db->query("UPDATE {$db_prefix}setting SET value='" . $md5_key . "' WHERE name='md5_key'");
//管理员帐号密码
$db->query("INSERT INTO {$db_prefix}admin (`admin_id`,`admin_name`,`admin_password`,`admin_login_time`,`admin_login_num`,`admin_is_super`) VALUES ('1','{$username}','" . md5($password) . "', '" . time() . "' ,'0',1);");
// 创建店铺
$db->query("INSERT INTO {$db_prefix}member (`member_id`,`member_name`,`member_passwd`,`member_email`,`member_time`,`member_login_time`,`member_old_login_time`) VALUES ('1', '{$member_name}','" . md5($member_password) . "', '', '" . time() . "', '" . time() . "', '" . time() . "')");
$db->query("INSERT INTO {$db_prefix}member_common (`member_id`) VALUES ('1')");
$db->query("INSERT INTO {$db_prefix}store (`store_id`,`store_name`,`grade_id`,`member_id`,`member_name`,`seller_name`,`store_state`,`store_time`) VALUES ('1','{$store_name}','1','1','{$member_name}','{$seller_name}','1', '" . time() . "')");
$db->query("INSERT INTO {$db_prefix}store_joinin (`member_id`,`member_name`,`seller_name`,`store_name`,`joinin_state`) VALUES ('1', '{$member_name}', '{$seller_name}', '{$store_name}', '40')");
$db->query("INSERT INTO {$db_prefix}seller (`seller_id`,`seller_name`,`member_id`,`seller_group_id`,`store_id`,`is_admin`) VALUES ('1', '{$seller_name}', '1', '0', '1', '1')");
$db->query("INSERT INTO {$db_prefix}store_bind_class (`bid`, `store_id`, `commis_rate`, `class_1`, `class_2`, `class_3`, `state`) VALUES ('1', '1', '0', '0', '0', '0', '1')");
$db->query("UPDATE `{$db_prefix}navigation` SET nav_url=CONCAT('{$auto_site_url}/',nav_url)");
$db->query("UPDATE `{$db_prefix}cms_navigation` SET navigation_link=CONCAT('{$auto_site_url}/',navigation_link)");
if ($_POST['demo_data'] == '1') {
$db->query("UPDATE {$db_prefix}store SET `live_store_name`='俏江南',`live_store_address`='天津市南开区南门外大街2号大悦城购物中心北区4L-27',`live_store_tel`='400-800800',`live_store_bus`='829路、832路、837路、855路、841路、860路 地铁2号线' WHERE `store_id`=1");
$db->query("UPDATE `{$db_prefix}goods` SET `store_name` = '{$store_name}'");
$db->query("UPDATE `{$db_prefix}goods_common` SET `store_name` = '{$store_name}'");
$db->query("UPDATE `{$db_prefix}groupbuy` SET `store_name` = '{$store_name}'");
$db->query("UPDATE `{$db_prefix}groupbuy_quota` SET `member_name` = '{$member_name}' ,`store_name` = '{$store_name}';");
$db->query("UPDATE `{$db_prefix}p_xianshi` SET `member_name` = '{$member_name}' ,`store_name` = '{$store_name}';");
$db->query("UPDATE `{$db_prefix}p_xianshi_quota` SET `member_name` = '{$member_name}' ,`store_name` = '{$store_name}';");
}
//新增一个标识文件，用来屏蔽重新安装
$fp = @fopen('lock', 'wb+');
@fclose($fp);
exit("<script type=\"text/javascript\">document.getElementById('install_process').innerHTML = '安装完成，下一步...';document.getElementById('install_process').href='index.php?step=5&sitename={$sitename}&username={$username}&password={$password}';</script>");
exit;
}
// WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A //
// PARTICULAR PURPOSE. See the GNU General Public License for more details: //
// //
// http://www.gnu.org/copyleft/gpl.html //
// //
////////////////////////////////////////////////////////////////////////////////////////
require "_language.php";
if (! isset ( $_CONF ['PATH'] )) {
require "../../config/default.php";
}
$validations = new validations ( );
$db = new db ( );
$db->connect ();
$cnpj = $validations->validStringForm ( $_POST ['cnpj'] );
$ie = $validations->validStringForm ( $_POST ['ie'] );
$endereco = $validations->validStringForm ( $_POST ['endereco'] );
$bairro = $validations->validStringForm ( $_POST ['bairro'] );
$cidade = $validations->validStringForm ( $_POST ['cidade'] );
$estado = $validations->validStringForm ( $_POST ['estado'] );
$cep = $validations->validStringForm ( $_POST ['cep'] );
$tel = $validations->validStringForm ( $_POST ['tel'] );
$fax = $validations->validStringForm ( $_POST ['fax'] );
$email = $validations->validStringForm ( $_POST ['email'] );
$site = $validations->validStringForm ( $_POST ['site'] );
$filiais = ($validations->validNumeric ( $_POST ['filiais'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['filiais'] );
$qtdturnos = ($validations->validNumeric ( $_POST ['qtdturnos'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['qtdturnos'] );
$qtdterminais = ($validations->validNumeric ( $_POST ['qtdterminais'] ) < 1) ? 1 : $validations->validNumeric ( $_POST ['qtdterminais'] );