} return $string; } function random1($car) { $string = ""; $chaine = "123456789"; srand((double) microtime() * 1000000); for ($i = 0; $i < $car; $i++) { $string .= $chaine[rand() % strlen($chaine)]; } return $string; } // APPEL // Génère une chaine de longueur 20 $identifiant = random1(3) . "-" . random(5) . "/" . random1(3); $_SESSION['identifiant'] = $identifiant; mysql_query("INSERT INTO `immat_user_info_voiture` (`matricule`, `marque`, `modele`, `puissance`, `energie`, `cp`, `user`, `date_add`,ref_cmd,total,status) VALUES ('" . $num_immat . "', '" . $marque . "', '" . $modele . "', '" . $puissance . "', '" . $energie . "', '" . $cp . "', '" . $email_user . "', '" . $date_add . "','" . $identifiant . "','" . $reduction_prix . "',0);") or die(mysql_error()); $new_id = mysql_insert_id(); $_SESSION['id_cmd'] = $new_id; if ($prestation1 != "") { if ($prestation1 == "Changement du statut matrimonial") { $chaine_prestation1 = "Changement du statut matrimonial"; $prestation1 = $prestation1 . "/" . $frais_dossier_prestation1["nom"]; mysql_query("insert into immat_cmd_detail(idcmd,prestation,montant)values(" . $new_id . ",'" . $prestation1 . "','" . $total_prix_chevaux . "')"); } else { $chaine_prestation1 = $prestation1; mysql_query("insert into immat_cmd_detail(idcmd,prestation,montant)values(" . $new_id . ",'" . $prestation1 . "','" . $total_prix_chevaux . "')"); mysql_query("insert into immat_cmd_detail(idcmd,prestation,montant)values(" . $new_id . ",'Frais dossier','" . $frais1 . "')"); } }
public function install() { @set_time_limit(3600); if (function_exists('ini_set')) { ini_set('max_execution_time', 3600); } $from_items = C("FROM_ITEMS"); $submit = true; $error_msg = array(); foreach ($from_items as $key => $items) { if (isset($_REQUEST[$key]) && is_array($_REQUEST[$key])) { foreach ($items as $k => $v) { $from_items[$key][$k]['value'] = $_REQUEST[$key][$k]; if (empty($_REQUEST[$key][$k]) || !preg_match($v['reg'], $_REQUEST[$key][$k])) { if (empty($_REQUEST[$key][$k]) && !$v['required']) { continue; } else { $submit = false; $from_items[$key][$k]['error'] = 1; } } } } } if ($from_items['admin']['ADM_PWD']['error'] == 1) { $from_items['admin']['ADM_PWD2']['error'] = 0; } else { $from_items['admin']['ADM_PWD']['notice'] = ''; if ($_REQUEST['admin']['ADM_PWD'] != $_REQUEST['admin']['ADM_PWD2']) { $submit = false; $from_items['admin']['ADM_PWD2']['error'] = 1; } } $_SESSION['from_items'] = $from_items; if (!$submit) { $this->assign("froms", $from_items); $this->assign("DEMO_DATA", $demo_data); $this->display("database"); exit; } $db_config = $_REQUEST['dbinfo']; $user_config = $_REQUEST['admin']; $this->display(); $status = true; $connect = @mysql_connect($db_config['DB_HOST'] . ":" . $db_config['DB_PORT'], $db_config['DB_USER'], $db_config['DB_PWD']); if (mysql_error() == "") { $rs = mysql_select_db($db_config['DB_NAME'], $connect); if (!$rs) { $db_rs = mysql_query("CREATE DATABASE IF NOT EXISTS `" . $db_config['DB_NAME'] . "` DEFAULT CHARACTER SET utf8"); if (!$db_rs) { $status = false; showjsmessage('', -1); showjsmessage("创建数据库失败", 1); } } } else { $status = false; showjsmessage('', -1); showjsmessage("连接数据库失败", 1); } if (!$status) { exit; } $db = Db::getInstance(array('dbms' => 'mysql', 'hostname' => $db_config['DB_HOST'], 'username' => $db_config['DB_USER'], 'password' => $db_config['DB_PWD'], 'hostport' => $db_config['DB_PORT'], 'database' => $db_config['DB_NAME'])); $tables = $db->query("SHOW TABLES LIKE '" . $db_config['DB_PREFIX'] . "%'"); foreach ($tables as $table) { $db->query("DROP TABLE IF EXISTS " . current($table)); } flush(); ob_flush(); showjsmessage('', -1); showjsmessage("开始安装程序", 2); //开始将$db_config写入配置 $db_config_str = "<?php\r\n"; $db_config_str .= "return array(\r\n"; foreach ($db_config as $key => $v) { $db_config_str .= "'" . $key . "'=>'" . $v . "',\r\n"; } $db_config_str .= ");\r\n"; $db_config_str .= "?>"; @file_put_contents(FANWE_ROOT . "public/db.global.php", $db_config_str); //开始执行安装脚本 if ($demo_data == 1) { $status = $this->restore(FANWE_ROOT . "install/install_demo.sql", $db_config); if ($status) { xCopy(FANWE_ROOT . "install/demofile", FANWE_ROOT . "public/upload", 1); } } else { $status = $this->restore(FANWE_ROOT . "install/install.sql", $db_config); } if ($status) { if ($user_config['ADM_NAME'] != "fanwe" || $user_config['ADM_PWD'] != "fanwe") { $sql = "UPDATE " . $db_config['DB_PREFIX'] . "admin SET admin_name = '" . $user_config['ADM_NAME'] . "',admin_pwd = '" . md5($user_config['ADM_PWD']) . "' WHERE id = 1"; $db->query($sql); if ($admins['ADM_NAME'] != "fanwe") { $sql = "UPDATE " . $db_config['DB_PREFIX'] . "sys_conf SET val = '" . $user_config['ADM_NAME'] . "' WHERE name = 'SYS_ADMIN'"; $db->query($sql); } } $authkey = substr(md5($_SERVER['SERVER_ADDR'] . $_SERVER['HTTP_USER_AGENT'] . $db_config['DB_HOST'] . $db_config['DB_USER'] . $db_config['DB_PWD'] . $db_config['DB_NAME'] . $user_config['ADM_NAME'] . $user_config['ADM_PWD'] . '0' . substr(time(), 0, 6)), 8, 6) . random1(10); $cookiepre = random1(4) . '_'; $memory_prefix = random1(6) . '_'; $configfile = @file_get_contents(FANWE_ROOT . 'public/config.global.php'); $configfile = trim($configfile); $configfile = preg_replace("/[\$]config\\['memory'\\]\\['prefix'\\].*?=.*?'.*?'.*?;/is", "\$config['memory']['prefix'] = '" . $memory_prefix . "';", $configfile); $configfile = preg_replace("/[\$]config\\['cookie'\\]\\['cookie_pre'\\].*?=.*?'.*?'.*?;/is", "\$config['cookie']['cookie_pre'] = '" . $cookiepre . "';", $configfile); $configfile = preg_replace("/[\$]config\\['security'\\]\\['authkey'\\].*?=.*?'.*?'.*?;/is", "\$config['security']['authkey'] = '" . $authkey . "';", $configfile); @file_put_contents(FANWE_ROOT . 'public/config.global.php', $configfile); @file_put_contents($this->install_lock, ""); Vendor('common'); include_once fimport('class/cache'); Cache::getInstance()->updateCache(); showjsmessage("安装成功", 4); } }