public function __construct() { if (self::$pdo) { return; } $config = (require CONFIG_FILE); $dbConfig = $config['database']; $host = isset($dbConfig['host']) ? $dbConfig['host'] : 'localhost'; $dsn = "mysql:host={$host};dbname=" . $dbConfig['database']; $attr = array(\PDO::ATTR_TIMEOUT => 10); self::$pdo = new \PDO($dsn, $dbConfig['user'], $dbConfig['password'], $attr); self::$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); $this->setFetchMode(\PDO::FETCH_OBJ); }
/** * Создание объекта подключения к БД */ public function __construct() { $config = App\Config::instance(); $param1 = 'mysql:host=' . $config->data['db']['host'] . ';dbname=' . $config->data['db']['dbname']; self::$DbName = $config->data['db']['dbname']; $param2 = $config->data['db']['login']; $param3 = $config->data['db']['pass']; try { $this->dbh = new \PDO($param1, $param2, $param3); //Добавлены атрибуты подключения (режимы выброса исключений) $this->dbh->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); } catch (\PDOException $e) { $mailer = new \App\SwMailer(); $res = $mailer->sendMail('Проблемы БД', 'Потеря соединения с БД', 1); $msg = !$res ? 'Неудачная попытка оповещения администратора' : 'Администратор оповещен'; throw new \App\Exceptions\DB('Некорректные параметры подключения к БД. ' . $msg . ' '); } }
//收货人地址 $receive_address = $_POST['WIDreceive_address']; //如:XX省XXX市XXX区XXX路XXX小区XXX栋XXX单元XXX号 //收货人邮编 $receive_zip = $_POST['WIDreceive_zip']; //如:123456 //收货人电话号码 $receive_phone = $_POST['WIDreceive_phone']; //如:0571-88158090 //收货人手机号码 $receive_mobile = $_POST['WIDreceive_mobile']; //如:13312341234 /************************************************************/ //构造要请求的参数数组,无需改动 $parameter = array("service" => "trade_create_by_buyer", "partner" => trim($alipay_config['partner']), "payment_type" => $payment_type, "notify_url" => $notify_url, "return_url" => $return_url, "seller_email" => $alipay_config['no'], "out_trade_no" => $out_trade_no, "subject" => $subject, "price" => $price, "quantity" => $quantity, "logistics_fee" => $logistics_fee, "logistics_type" => $logistics_type, "logistics_payment" => $logistics_payment, "body" => $body, "show_url" => $show_url, "receive_name" => $receive_name, "receive_address" => $receive_address, "receive_zip" => $receive_zip, "receive_phone" => $receive_phone, "receive_mobile" => $receive_mobile, "_input_charset" => trim(strtolower($alipay_config['input_charset']))); $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $sql = 'select count(*) from {pre}user_pay where p_order=' . $out_trade_no; $num = $db->getOne($sql); if ($num > 0) { showErr('System', "订单号错误无法提交数据"); } else { $db->Add('{pre}user_pay', array('p_uid', 'p_order', 'p_price', 'p_point', 'p_time'), array($_SESSION["userid"], $out_trade_no, $price, $price * $MAC['pay']['app']['exc'], time())); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>支付宝标准双接口接口</title> </head> <?php
} elseif ($verify_result_2) { ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //请在这里加上商户的业务逻辑程序代码 //——请根据您的业务逻辑来编写程序(以下代码仅作参考)—— //获取支付宝的通知返回参数,可参考技术文档中页面跳转同步通知参数列表 //商户订单号 $out_trade_no = intval($_GET['out_trade_no']); //支付宝交易号 $trade_no = $_GET['trade_no']; //交易状态 $trade_status = $_GET['trade_status']; if ($_GET['trade_status'] == 'WAIT_SELLER_SEND_GOODS' || $_GET['trade_status'] == 'TRADE_FINISHED') { //判断该笔订单是否在商户网站中已经做过处理 //如果没有做过处理,根据订单号(out_trade_no)在商户网站的订单系统中查到该笔订单的详细,并执行商户的业务程序 //如果有做过处理,不执行商户的业务程序 $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $sql = 'select * from {pre}user_pay where p_status=0 and p_order=' . $out_trade_no; $row = $db->getRow($sql); if ($row) { $point = $row['p_point']; $db->query("update {pre}user set u_points=u_points+" . $point . " where u_id = " . $row["p_uid"]); $db->query("update {pre}user set p_status=1 where p_order=" . $out_trade_no); } unset($row); alertUrl("充值成功", "../../../index.php?m=user-index"); } else { echo "trade_status=" . $_GET['trade_status']; } // echo "验证成功<br />"; // echo "trade_no=".$trade_no; //——请根据您的业务逻辑来编写程序(以上代码仅作参考)——
} $pattern = '/[^\\x00-\\x80]/'; if (!preg_match($pattern, $g_content)) { alert('内容必须包含中文,请重新输入!'); exit; } $g_name = badFilter($g_name); $g_name = strip_tags($g_name); $g_content = badFilter($g_content); $g_content = strip_tags($g_content); $g_ip = ip2long(getIP()); $g_time = time(); if ($MAC['other']['gbookaudit'] == 1) { $g_hide = 1; } else { $g_hide = 0; } if (strlen($g_name) > 64) { $g_name = substring($g_name, 64); } if (strlen($g_content) > 255) { $g_content = substring($g_content, 255); } $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $db->Add("{pre}gbook", array("g_vid", "g_hide", "g_name", "g_ip", "g_time", "g_content"), array($g_vid, $g_hide, $g_name, $g_ip, $g_time, $g_content)); $_SESSION["last_gbooktime"] = time(); $_SESSION["code_gbook"] = ""; alert('留言成功'); } else { showErr('System', '未找到指定系统模块'); }
unset($row); $tpl->loadvod('play'); $tpl->replaceVod(); $tpl->playdownlist('play'); $tpl->H = str_replace('[vod:playnum]', $tpl->P['num'], $tpl->H); $tpl->H = str_replace('[vod:playsrc]', $tpl->P['src'], $tpl->H); $tpl->getUrlName('play'); $tpl->H = str_replace('[vod:playerinfo]', '<script>' . $tpl->getUrlInfo('play') . ' </script>' . "\n", $tpl->H); $tpl->H = str_replace('[vod:player]', '<script src="' . $MAC['site']['installdir'] . 'js/playerconfig.js"></script><script src="' . $MAC['site']['installdir'] . 'js/player.js"></script>' . "\n", $tpl->H); $tpl->playdownlist("down"); } elseif ($method == 'down') { $tpl->C["siteaid"] = 18; $tpl->P['cp'] = 'voddown'; $tpl->P['cn'] = $tpl->P['id'] . '-' . $tpl->P['src'] . '-' . $tpl->P['num']; echoPageCache($tpl->P['cp'], $tpl->P['cn']); $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $sql = "SELECT * FROM {pre}vod WHERE d_hide=0 AND d_id=" . $tpl->P['id']; $row = $db->getRow($sql); if (!$row) { showMsg("获取数据失败,请勿非法传递参数", MAC_PATH); } if (!getUserPopedom($row["d_type"], "down")) { showMsg("您没有权限浏览播放页", MAC_PATH . "index.php?m=user-index.html"); } if ($MAC['user']['status'] == 1) { $uid = intval($_SESSION['userid']); if ($row["d_stint"] > 0 && $uid == 0) { showMsg("此为收费数据请先登录再观看", MAC_PATH . "index.php?m=user-index.html"); } $rowu = $db->getRow("SELECT * FROM {pre}user where u_id=" . $uid); if ($rowu) {
<?php if (!defined('MAC_ROOT')) { exit('Access Denied'); } if ($method == 'vod') { $tpl->P['cp'] = 'map'; $tpl->P['cn'] = $method . $tpl->P['id']; echoPageCache($tpl->P['cp'], $tpl->P['cn']); $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $sql = "SELECT * FROM {pre}vod WHERE d_hide=0 AND d_id=" . $tpl->P['id']; $row = $db->getRow($sql); if (!row) { showErr('System', '未找到指定数据'); } $tpl->T = $MAC_CACHE['vodtype'][$row['d_type']]; $tpl->D = $row; unset($row); $tpl->loadvod("rss"); $tpl->replaceVod(); $tpl->playdownlist("play"); $tpl->playdownlist("down"); } elseif ($method == 'rss' || $method == 'baidu' || $method == 'google' || $method == '360') { $tpl->P['cp'] = 'map'; $tpl->P['cn'] = $method . '-' . $tpl->P['pg']; echoPageCache($tpl->P['cp'], $tpl->P['cn']); $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $tpl->H = loadFile(MAC_ROOT . '/inc/map/' . $method . '.html'); $tpl->mark(); } else { showErr('System', '未找到指定系统模块');
exit; } if (getTimeSpan("last_gbooktime") < $MAC['other']['gbooktime']) { alert('请不要频繁操作'); exit; } $pattern = '/[^\\x00-\\x80]/'; if (!preg_match($pattern, $g_content)) { alert('内容必须包含中文,请重新输入!'); exit; } $g_name = badFilter($g_name); $g_content = badFilter($g_content); $g_ip = ip2long(getIP()); $g_time = time(); $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $db->Add("{pre}gbook", array("g_vid", "g_hide", "g_name", "g_ip", "g_time", "g_content"), array($g_vid, $g_hide, $g_name, $g_ip, $g_time, $g_content)); $_SESSION["last_gbook"] = time(); $_SESSION["code_gbook"] = ""; echo "<script>alert('报错成功,多谢支持!');window.close();</script>"; } elseif ($ac == 'suggest') { $q = be("get", "q"); $q = chkSql($q); $t = be("get", "t"); $t = chkSql($t); $res = '{"status":0,"info":"err","data":[{}]}'; if (!empty($q)) { $q = mysql_real_escape_string($q); $sql = "SELECT d_name from {pre}vod WHERE d_name like '" . $q . "%' or d_enname like '" . $q . "%' "; if ($t == 'art') { "SELECT a_name from {pre}art WHERE a_name like '" . $q . "%' or a_enname like '" . $q . "%' ";
<?php session_start(); $RootDir = $_SERVER['DOCUMENT_ROOT']; require_once $RootDir . '/conf/config.php'; require_once $RootDir . '/model/app.db.php'; $appdb = new AppDb(); //没有参数 //if(empty($_POST)) //{ // backMsg('param is empty.','-1'); // exit; //} //用户是否登录 //if(empty($_SESSION['uname'])) //{ // backMsg('user is not login.','-3'); // exit; //} $searchType = $_POST['type']; //type 没有 if (empty($searchType)) { backMsg('type is empty.', '-2'); exit; } switch ($searchType) { case 'history': $startTime = $_POST['startTime']; $endTime = $_POST['endTime']; //开始、结束时间 if (empty($startTime)) {
<?php require "conn.php"; require MAC_ROOT . '/inc/common/360_safe3.php'; if ($MAC['api']['vod']['status'] == 0) { echo "closed"; exit; } $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $ac = be("get", "ac"); $t = intval(be("get", "t")); $pg = intval(be("get", "pg")); $h = intval(be("get", "h")); $wd = be("get", "wd"); $wd = chkSql($wd); $ids = be("all", "ids"); $ids = chkSql($ids); if ($pg < 1) { $pg = 1; } if ($ac == 'videolist') { $cp = 'api'; $cn = 'videolist' . $t . "-" . $pg . "-" . $wd . "-" . $h . "-" . str_replace(",", "", $ids); echoPageCache($cp, $cn); $xmla = "<?xml version=\"1.0\" encoding=\"utf-8\"?>"; $xmla .= "<rss version=\"5.1\">"; $sql = "select * from {pre}vod where 1=1 "; $sql1 = "select count(*) from {pre}vod where 1=1 "; if (!empty($ids)) { $arr = explode(',', $ids); for ($i = 0; $i < count($arr); $i++) {
function stepC() { global $db; $site_url = be("post", "site_url"); $site_name = be("post", "site_name"); $site_installdir = be("post", "site_installdir"); $site_keywords = be("post", "site_keywords"); $site_description = be("post", "site_description"); $db_type = be("post", "db_type"); $db_path = "inc/" & be("post", "db_path"); $db_server = be("post", "db_server"); $db_name = be("post", "db_name"); $db_user = be("post", "db_user"); $db_pass = be("post", "db_pass"); $db_tablepre = be("post", "db_tablepre"); $m_name = be("post", "m_name"); $m_password1 = be("post", "m_password1"); $m_password2 = be("post", "m_password2"); $app_safecode = be("post", "app_safecode"); show_step(3, "安装数据库", "正在执行数据库安装写入配置文件"); echo <<<EOT \t<div class="main"> \t<div class="btnbox"><div id="notice"></div></div> \t<div class="btnbox margintop marginbot"><form method="get" autocomplete="off" action="install.php"> \t<table class="tb2"><tr><th class="tbopt" align="left"> </th><td> <input type="hidden" name="action" value="d" /><div class="btnbox marginbot"><input type="button" onclick="history.back();" value="上一步"><input type="submit" value="下一步"></td><td></td></tr></table></form></div> EOT; $config = $GLOBALS['MAC']; $config['db']['server'] = $db_server; $config['db']['name'] = $db_name; $config['db']['user'] = $db_user; $config['db']['pass'] = $db_pass; $config['db']['tablepre'] = $db_tablepre; $GLOBALS['MAC']['db']['tablepre'] = $db_tablepre; $config['app']['safecode'] = $app_safecode; $config['site']['url'] = $site_url; $config['site']['name'] = $site_name; $config['site']['installdir'] = $site_installdir; $config['site']['keywords'] = $site_keywords; $config['site']['description'] = $site_description; $configstr = '<?php' . chr(10) . '$MAC = ' . var_export($config, true) . ';' . chr(10) . '?>'; fwrite(fopen("inc/config/config.php", "wb"), $configstr); echo '<script type="text/javascript">showmessage(\'写入网站配置文件... 成功 \');</script>'; error_reporting(E_NOTICE); $dbck = false; $lnk = @mysql_connect($db_server, $db_user, $db_pass); if (!$lnk) { echo '<script type="text/javascript">showmessage(\'数据库设置出错:mysql请检查数据库连接信息... \');</script>'; } else { if (!@mysql_select_db($db_name, $lnk)) { echo '<script type="text/javascript">showmessage(\'数据库服务器连接成功,没有找到【 ' . $db_name . ' 】数据... \');</script>'; } else { $dbck = true; } } error_reporting(7); if ($dbck) { $db = new AppDb($db_server, $db_user, $db_pass, $db_name); echo '<script type="text/javascript">showmessage(\'开始创建数据库结构... \');</script>'; if (!isExistTable("" . $db_tablepre . "art", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "art` (\n `a_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `a_name` varchar(255) NOT NULL,\n `a_subname` varchar(255) NOT NULL,\n `a_enname` varchar(255) NOT NULL,\n `a_letter` char(1) NOT NULL,\n `a_color` char(6) NOT NULL,\n `a_from` varchar(32) NOT NULL,\n `a_author` varchar(32) NOT NULL,\n `a_tag` varchar(64) NOT NULL,\n `a_pic` varchar(255) NOT NULL,\n `a_type` smallint(6) NOT NULL DEFAULT '0',\n `a_topic` varchar(255) NOT NULL,\n `a_level` tinyint(1) NOT NULL DEFAULT '0',\n `a_hide` tinyint(1) NOT NULL DEFAULT '0',\n `a_lock` tinyint(1) NOT NULL DEFAULT '0',\n `a_up` mediumint(8) NOT NULL DEFAULT '0',\n `a_down` mediumint(8) NOT NULL DEFAULT '0',\n `a_hits` mediumint(8) NOT NULL DEFAULT '0',\n `a_dayhits` mediumint(8) NOT NULL DEFAULT '0',\n `a_weekhits` mediumint(8) NOT NULL DEFAULT '0',\n `a_monthhits` mediumint(8) NOT NULL DEFAULT '0',\n `a_addtime` int(10) NOT NULL,\n `a_time` int(10) NOT NULL,\n `a_hitstime` int(10) NOT NULL,\n `a_maketime` int(10) NOT NULL,\n `a_remarks` varchar(255) NOT NULL,\n `a_content` mediumtext NOT NULL,\n PRIMARY KEY (`a_id`),\n KEY `a_type` (`a_type`),\n KEY `a_level` (`a_level`),\n KEY `a_hits` (`a_hits`),\n KEY `a_dayhits` (`a_dayhits`),\n KEY `a_weekhits` (`a_weekhits`),\n KEY `a_monthhits` (`a_monthhits`),\n KEY `a_addtime` (`a_addtime`),\n KEY `a_time` (`a_time`),\n KEY `a_maketime` (`a_maketime`),\n KEY `a_hide` (`a_hide`),\n KEY `a_letter` (`a_letter`),\n KEY `a_down` (`a_down`),\n KEY `a_up` (`a_up`),\n KEY `a_tag` (`a_tag`),\n KEY `a_name` (`a_name`),\n KEY `a_enname` (`a_enname`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'art... \');</script>'; } if (!isExistTable("" . $db_tablepre . "art_relation", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "art_relation` (\n `r_id` mediumint(8) NOT NULL AUTO_INCREMENT,\n `r_type` tinyint(1) NOT NULL DEFAULT '0',\n `r_a` mediumint(8) NOT NULL DEFAULT '0',\n `r_b` mediumint(8) NOT NULL DEFAULT '0',\n PRIMARY KEY (`r_id`),\n KEY `r_type` (`r_type`),\n KEY `r_a` (`r_a`),\n KEY `r_b` (`r_b`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'art_relation... \');</script>'; } if (!isExistTable("" . $db_tablepre . "art_topic", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "art_topic` (\n `t_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `t_name` varchar(64) NOT NULL,\n `t_enname` varchar(128) NOT NULL,\n `t_sort` smallint(6) NOT NULL DEFAULT '0',\n `t_tpl` varchar(128) NOT NULL,\n `t_pic` varchar(255) NOT NULL,\n `t_content` varchar(255) NOT NULL,\n `t_key` varchar(255) NOT NULL,\n `t_des` varchar(255) NOT NULL,\n `t_title` varchar(255) NOT NULL,\n `t_hide` tinyint(1) NOT NULL DEFAULT '0',\n `t_level` tinyint(1) NOT NULL DEFAULT '0',\n `t_up` mediumint(8) NOT NULL DEFAULT '0',\n `t_down` mediumint(8) NOT NULL DEFAULT '0',\n `t_score` decimal(3,1) NOT NULL,\n `t_scoreall` mediumint(8) NOT NULL,\n `t_scorenum` smallint(6) NOT NULL,\n `t_hits` mediumint(8) NOT NULL DEFAULT '0',\n `t_dayhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_weekhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_monthhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_addtime` int(10) NOT NULL,\n `t_time` int(10) NOT NULL,\n `t_hitstime` int(10) NOT NULL,\n PRIMARY KEY (`t_id`),\n KEY `t_sort` (`t_sort`),\n KEY `t_hide` (`t_hide`),\n KEY `t_level` (`t_level`),\n KEY `t_up` (`t_up`),\n KEY `t_down` (`t_down`),\n KEY `t_score` (`t_score`),\n KEY `t_scoreall` (`t_scoreall`),\n KEY `t_scorenum` (`t_scorenum`),\n KEY `t_hits` (`t_hits`),\n KEY `t_dayhits` (`t_dayhits`),\n KEY `t_weekhits` (`t_weekhits`),\n KEY `t_monthhits` (`t_monthhits`),\n KEY `t_addtime` (`t_addtime`),\n KEY `t_time` (`t_time`),\n KEY `t_hitstime` (`t_hitstime`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'art_topic... \');</script>'; } if (!isExistTable("" . $db_tablepre . "art_type", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "art_type` (\n `t_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `t_name` varchar(64) NOT NULL,\n `t_enname` varchar(128) NOT NULL,\n `t_pid` smallint(6) NOT NULL DEFAULT '0',\n `t_sort` smallint(6) NOT NULL DEFAULT '0',\n `t_hide` tinyint(1) NOT NULL DEFAULT '0',\n `t_tpl` varchar(64) NOT NULL,\n `t_tpl_list` varchar(64) NOT NULL,\n `t_tpl_art` varchar(64) NOT NULL,\n `t_key` varchar(255) NOT NULL,\n `t_des` varchar(255) NOT NULL,\n `t_title` varchar(255) NOT NULL,\n `t_union` varchar(255) NOT NULL,\n PRIMARY KEY (`t_id`),\n KEY `t_pid` (`t_pid`),\n KEY `t_sort` (`t_sort`),\n KEY `t_hide` (`t_hide`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'art_type... \');</script>'; } if (!isExistTable("" . $db_tablepre . "comment", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "comment` (\n `c_id` int(11) NOT NULL AUTO_INCREMENT,\n `c_type` int(11) DEFAULT '0',\n `c_vid` int(11) DEFAULT '0',\n `c_rid` int(11) DEFAULT '0',\n `c_hide` tinyint(1) DEFAULT '0',\n `c_name` varchar(64) NOT NULL,\n `c_ip` varchar(32) NOT NULL,\n `c_content` varchar(128) NOT NULL,\n `c_time` int(10) NOT NULL,\n PRIMARY KEY (`c_id`),\n KEY `c_vid` (`c_vid`),\n KEY `c_type` (`c_type`),\n KEY `c_rid` (`c_rid`),\n KEY `c_time` (`c_time`),\n KEY `c_hide` (`c_hide`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'comment... \');</script>'; } if (!isExistTable("" . $db_tablepre . "gbook", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "gbook` (\n `g_id` int(11) NOT NULL AUTO_INCREMENT,\n `g_vid` int(11) DEFAULT '0',\n `g_hide` tinyint(1) DEFAULT '0',\n `g_sort` smallint(6) NOT NULL DEFAULT '0',\n `g_name` varchar(64) NOT NULL,\n `g_content` varchar(255) NOT NULL,\n `g_reply` varchar(255) NOT NULL,\n `g_ip` int(11) NOT NULL,\n `g_time` int(10) NOT NULL,\n `g_replytime` int(10) NOT NULL,\n PRIMARY KEY (`g_id`),\n KEY `g_vid` (`g_vid`),\n KEY `g_time` (`g_time`),\n KEY `g_hide` (`g_hide`),\n KEY `g_sort` (`g_sort`),\n KEY `g_replytime` (`g_replytime`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'gbook... \');</script>'; } if (!isExistTable("" . $db_tablepre . "link", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "link` (\n `l_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `l_name` varchar(64) NOT NULL,\n `l_url` varchar(255) NOT NULL,\n `l_logo` varchar(255) NOT NULL,\n `l_type` tinyint(1) NOT NULL DEFAULT '0',\n `l_sort` smallint(6) NOT NULL DEFAULT '0',\n PRIMARY KEY (`l_id`),\n KEY `l_sort` (`l_sort`),\n KEY `l_type` (`l_type`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'link... \');</script>'; } if (!isExistTable("" . $db_tablepre . "manager", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "manager` (\n `m_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `m_name` varchar(32) NOT NULL,\n `m_password` varchar(32) NOT NULL,\n `m_levels` varchar(32) NOT NULL,\n `m_random` varchar(32) NOT NULL,\n `m_status` tinyint(1) NOT NULL DEFAULT '0',\n `m_logintime` int(10) NOT NULL,\n `m_loginip` int(10) NOT NULL,\n `m_loginnum` smallint(6) NOT NULL,\n PRIMARY KEY (`m_id`),\n KEY `m_status` (`m_status`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'manager... \');</script>'; } if (!isExistTable("" . $db_tablepre . "user", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "user` (\n `u_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\n `u_qid` varchar(32) NOT NULL,\n `u_name` varchar(32) NOT NULL,\n `u_password` varchar(32) NOT NULL,\n `u_qq` varchar(16) NOT NULL,\n `u_email` varchar(32) NOT NULL,\n `u_phone` varchar(16) NOT NULL,\n `u_status` tinyint(1) NOT NULL DEFAULT '0',\n `u_flag` tinyint(1) NOT NULL DEFAULT '0',\n `u_question` varchar(255) NOT NULL,\n `u_answer` varchar(255) NOT NULL,\n `u_group` smallint(6) NOT NULL DEFAULT '0',\n `u_points` smallint(6) NOT NULL DEFAULT '0',\n `u_regtime` int(11) NOT NULL,\n `u_logintime` int(11) NOT NULL,\n `u_loginnum` smallint(6) NOT NULL DEFAULT '0',\n `u_extend` smallint(6) NOT NULL DEFAULT '0',\n `u_loginip` int(11) NOT NULL,\n `u_random` varchar(32) NOT NULL,\n `u_fav` text NOT NULL,\n `u_plays` text NOT NULL,\n `u_downs` text NOT NULL,\n `u_start` int(11) NOT NULL,\n `u_end` int(11) NOT NULL,\n PRIMARY KEY (`u_id`),\n KEY `u_group` (`u_group`),\n KEY `u_status` (`u_status`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'user... \');</script>'; } if (!isExistTable("" . $db_tablepre . "user_card", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "user_card` (\n `c_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `c_number` varchar(16) NOT NULL,\n `c_pass` varchar(8) NOT NULL,\n `c_money` smallint(11) NOT NULL DEFAULT '0',\n `c_point` smallint(11) NOT NULL DEFAULT '0',\n `c_used` tinyint(1) NOT NULL DEFAULT '0',\n `c_sale` tinyint(1) NOT NULL DEFAULT '0',\n `c_user` smallint(6) NOT NULL DEFAULT '0',\n `c_addtime` int(11) NOT NULL,\n `c_usetime` int(11) NOT NULL,\n PRIMARY KEY (`c_id`),\n KEY `c_used` (`c_used`),\n KEY `c_sale` (`c_sale`),\n KEY `c_user` (`c_user`),\n KEY `c_addtime` (`c_addtime`),\n KEY `c_usetime` (`c_usetime`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'user_card... \');</script>'; } if (!isExistTable("" . $db_tablepre . "user_group", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "user_group` (\n `ug_id` smallint(6) NOT NULL AUTO_INCREMENT,\n `ug_name` varchar(32) NOT NULL,\n `ug_type` varchar(255) NOT NULL,\n `ug_popedom` varchar(32) NOT NULL,\n `ug_upgrade` smallint(6) NOT NULL DEFAULT '0',\n `ug_popvalue` smallint(6) NOT NULL DEFAULT '0',\n PRIMARY KEY (`ug_id`),\n KEY `ug_upgrade` (`ug_upgrade`),\n KEY `ug_popvalue` (`ug_popvalue`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'user_group... \');</script>'; } if (!isExistTable("" . $db_tablepre . "user_pay", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "user_pay` (\n `p_id` int(11) NOT NULL AUTO_INCREMENT,\n `p_order` int(11) NOT NULL DEFAULT '0',\n `p_uid` mediumint(8) NOT NULL DEFAULT '0',\n `p_price` smallint(6) NOT NULL DEFAULT '0',\n `p_time` int(11) NOT NULL DEFAULT '0',\n `p_point` smallint(6) NOT NULL DEFAULT '0',\n `p_status` tinyint(1) NOT NULL DEFAULT '0',\n PRIMARY KEY (`p_id`),\n KEY `p_order` (`p_order`),\n KEY `p_uid` (`p_uid`),\n KEY `p_status` (`p_status`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'user_pay... \');</script>'; } if (!isExistTable("" . $db_tablepre . "user_visit", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "user_visit` (\n `uv_id` int(11) NOT NULL AUTO_INCREMENT,\n `uv_uid` int(11) DEFAULT '0',\n `uv_ip` int(11) NOT NULL,\n `uv_ly` varchar(128) NOT NULL,\n `uv_time` int(10) NOT NULL,\n PRIMARY KEY (`uv_id`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'user_visit... \');</script>'; } if (!isExistTable("" . $db_tablepre . "vod", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "vod` (\n `d_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `d_name` varchar(255) NOT NULL,\n `d_subname` varchar(255) NOT NULL,\n `d_enname` varchar(255) NOT NULL,\n `d_letter` char(1) NOT NULL,\n `d_color` char(6) NOT NULL,\n `d_pic` varchar(255) NOT NULL,\n `d_picthumb` varchar(255) NOT NULL,\n `d_picslide` varchar(255) NOT NULL,\n `d_starring` varchar(255) NOT NULL,\n `d_directed` varchar(255) NOT NULL,\n `d_tag` varchar(64) NOT NULL,\n `d_remarks` varchar(64) NOT NULL,\n `d_area` varchar(16) NOT NULL,\n `d_lang` varchar(16) NOT NULL,\n `d_year` smallint(4) NOT NULL,\n `d_type` smallint(6) NOT NULL DEFAULT '0',\n `d_type_expand` varchar(255) NOT NULL,\n `d_class` varchar(255) NOT NULL,\n `d_topic` varchar(255) NOT NULL DEFAULT '0',\n `d_hide` tinyint(1) NOT NULL DEFAULT '0',\n `d_lock` tinyint(1) NOT NULL,\n `d_state` int(8) NOT NULL DEFAULT '0',\n `d_level` tinyint(1) NOT NULL DEFAULT '0',\n `d_usergroup` smallint(6) NOT NULL DEFAULT '0',\n `d_stint` smallint(6) NOT NULL DEFAULT '0',\n `d_stintdown` smallint(6) NOT NULL DEFAULT '0',\n `d_hits` mediumint(8) NOT NULL DEFAULT '0',\n `d_dayhits` mediumint(8) NOT NULL DEFAULT '0',\n `d_weekhits` mediumint(8) NOT NULL DEFAULT '0',\n `d_monthhits` mediumint(8) NOT NULL DEFAULT '0',\n `d_duration` smallint(6) NOT NULL DEFAULT '0',\n `d_up` mediumint(8) NOT NULL DEFAULT '0',\n `d_down` mediumint(8) NOT NULL DEFAULT '0',\n `d_score` decimal(3,1) NOT NULL DEFAULT '0.0',\n `d_scoreall` mediumint(8) NOT NULL,\n `d_scorenum` smallint(6) NOT NULL DEFAULT '0',\n `d_addtime` int(10) NOT NULL,\n `d_time` int(10) NOT NULL,\n `d_hitstime` int(10) NOT NULL,\n `d_maketime` int(10) NOT NULL,\n `d_content` text NOT NULL,\n `d_playfrom` varchar(255) NOT NULL,\n `d_playserver` varchar(255) NOT NULL,\n `d_playnote` varchar(255) NOT NULL,\n `d_playurl` mediumtext NOT NULL,\n `d_downfrom` varchar(255) NOT NULL,\n `d_downserver` varchar(255) NOT NULL,\n `d_downnote` varchar(255) NOT NULL,\n `d_downurl` mediumtext NOT NULL,\n PRIMARY KEY (`d_id`),\n KEY `d_type` (`d_type`),\n KEY `d_state` (`d_state`),\n KEY `d_level` (`d_level`),\n KEY `d_hits` (`d_hits`),\n KEY `d_dayhits` (`d_dayhits`),\n KEY `d_weekhits` (`d_weekhits`),\n KEY `d_monthhits` (`d_monthhits`),\n KEY `d_stint` (`d_stint`),\n KEY `d_stintdown` (`d_stintdown`),\n KEY `d_hide` (`d_hide`),\n KEY `d_usergroup` (`d_usergroup`),\n KEY `d_score` (`d_score`),\n KEY `d_addtime` (`d_addtime`),\n KEY `d_time` (`d_time`),\n KEY `d_maketime` (`d_maketime`),\n KEY `d_topic` (`d_topic`),\n KEY `d_letter` (`d_letter`),\n KEY `d_name` (`d_name`),\n KEY `d_enname` (`d_enname`),\n KEY `d_year` (`d_year`),\n KEY `d_area` (`d_area`),\n KEY `d_language` (`d_lang`),\n KEY `d_starring` (`d_starring`),\n KEY `d_directed` (`d_directed`),\n KEY `d_tag` (`d_tag`),\n KEY `d_type_expand` (`d_type_expand`),\n KEY `d_class` (`d_class`),\n KEY `d_lock` (`d_lock`),\n KEY `d_up` (`d_up`),\n KEY `d_down` (`d_down`),\n KEY `d_scoreall` (`d_scoreall`),\n KEY `d_scorenum` (`d_scorenum`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'vod... \');</script>'; } if (!isExistTable("" . $db_tablepre . "vod_class", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "vod_class` (\n `c_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `c_name` varchar(64) NOT NULL,\n `c_pid` smallint(6) NOT NULL DEFAULT '0',\n `c_sort` smallint(6) NOT NULL DEFAULT '0',\n `c_hide` tinyint(1) NOT NULL DEFAULT '0',\n PRIMARY KEY (`c_id`),\n KEY `c_sort` (`c_sort`),\n KEY `c_pid` (`c_pid`),\n KEY `c_hide` (`c_hide`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'vod_class... \');</script>'; } if (!isExistTable("" . $db_tablepre . "vod_relation", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "vod_relation` (\n `r_id` mediumint(8) NOT NULL AUTO_INCREMENT,\n `r_type` tinyint(1) NOT NULL DEFAULT '0',\n `r_a` mediumint(8) NOT NULL DEFAULT '0',\n `r_b` mediumint(8) NOT NULL DEFAULT '0',\n PRIMARY KEY (`r_id`),\n KEY `r_type` (`r_type`),\n KEY `r_a` (`r_a`),\n KEY `r_b` (`r_b`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'vod_relation... \');</script>'; } if (!isExistTable("" . $db_tablepre . "vod_topic", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "vod_topic` (\n `t_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `t_name` varchar(64) NOT NULL,\n `t_enname` varchar(128) NOT NULL,\n `t_sort` smallint(6) NOT NULL DEFAULT '0',\n `t_tpl` varchar(128) NOT NULL,\n `t_pic` varchar(255) NOT NULL,\n `t_content` varchar(255) NOT NULL,\n `t_key` varchar(255) NOT NULL,\n `t_des` varchar(255) NOT NULL,\n `t_title` varchar(255) NOT NULL,\n `t_hide` tinyint(1) NOT NULL DEFAULT '0',\n `t_level` tinyint(1) NOT NULL DEFAULT '0',\n `t_up` mediumint(8) NOT NULL DEFAULT '0',\n `t_down` mediumint(8) NOT NULL DEFAULT '0',\n `t_score` decimal(3,1) NOT NULL,\n `t_scoreall` mediumint(8) NOT NULL,\n `t_scorenum` smallint(6) NOT NULL,\n `t_hits` mediumint(8) NOT NULL DEFAULT '0',\n `t_dayhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_weekhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_monthhits` mediumint(8) NOT NULL DEFAULT '0',\n `t_addtime` int(10) NOT NULL,\n `t_time` int(10) NOT NULL,\n `t_hitstime` int(10) NOT NULL,\n PRIMARY KEY (`t_id`),\n KEY `t_sort` (`t_sort`),\n KEY `t_hide` (`t_hide`),\n KEY `t_level` (`t_level`),\n KEY `t_up` (`t_up`),\n KEY `t_down` (`t_down`),\n KEY `t_score` (`t_score`),\n KEY `t_scoreall` (`t_scoreall`),\n KEY `t_scorenum` (`t_scorenum`),\n KEY `t_hits` (`t_hits`),\n KEY `t_dayhits` (`t_dayhits`),\n KEY `t_weekhits` (`t_weekhits`),\n KEY `t_monthhits` (`t_monthhits`),\n KEY `t_addtime` (`t_addtime`),\n KEY `t_time` (`t_time`),\n KEY `t_hitstime` (`t_hitstime`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'vod_topic... \');</script>'; } if (!isExistTable("" . $db_tablepre . "vod_type", $db_name)) { $db->query("CREATE TABLE `" . $db_tablepre . "vod_type` (\n `t_id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,\n `t_name` varchar(64) NOT NULL,\n `t_enname` varchar(128) NOT NULL,\n `t_pid` smallint(6) NOT NULL DEFAULT '0',\n `t_sort` smallint(6) NOT NULL DEFAULT '0',\n `t_hide` tinyint(1) NOT NULL DEFAULT '0',\n `t_tpl` varchar(64) NOT NULL,\n `t_tpl_list` varchar(64) NOT NULL,\n `t_tpl_vod` varchar(64) NOT NULL,\n `t_tpl_play` varchar(64) NOT NULL,\n `t_tpl_down` varchar(64) NOT NULL,\n `t_key` varchar(255) NOT NULL,\n `t_des` varchar(255) NOT NULL,\n `t_title` varchar(255) NOT NULL,\n `t_union` varchar(255) NOT NULL,\n PRIMARY KEY (`t_id`),\n KEY `t_sort` (`t_sort`),\n KEY `t_pid` (`t_pid`),\n KEY `t_hide` (`t_hide`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $db_tablepre . 'vod_type... \');</script>'; } if (!isExistTable("tmptable", $db_name)) { $db->query("CREATE TABLE `tmptable` (\n `d_name1` varchar(255) CHARACTER SET utf8 NOT NULL\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n"); echo '<script type="text/javascript">showmessage(\'创建数据表 tmptable... \');</script>'; } echo '<script type="text/javascript">showmessage(\'数据库结构创建完成... \');</script>'; $db->query("insert into " . $db_tablepre . "manager(m_id,m_name,m_password,m_status,m_levels) values('1','" . $m_name . "','" . md5($m_password1) . "',1,'b,c,d,e,f,g,h,i,j')"); echo '<script type="text/javascript">showmessage(\'管理员帐号' . $m_name . '初始化成功... \');</script>'; $db->query("INSERT into " . $db_tablepre . "user_group (ug_id,ug_name,ug_type,ug_popedom,ug_upgrade,ug_popvalue) values ('1','普通会员','','',0,1)"); echo '<script type="text/javascript">showmessage(\'默认会员组初始化完毕... \');</script>'; $db->query("INSERT INTO `" . $db_tablepre . "vod_type` (`t_id`, `t_name`, `t_enname`, `t_pid`, `t_sort`, `t_hide`, `t_tpl`, `t_tpl_list`, `t_tpl_vod`, `t_tpl_play`, `t_tpl_down`, `t_key`, `t_des`, `t_title`, `t_union`) VALUES\n(1, '电影', 'dianying', 0, 1, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(2, '连续剧', 'lianxuju', 0, 2, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(3, '综艺', 'zongyi', 0, 3, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(4, '动漫', 'dongman', 0, 4, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(5, '动作片', 'dongzuopian', 1, 11, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(6, '喜剧片', 'xijupian', 1, 12, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(7, '爱情片', 'aiqingpian', 1, 13, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(8, '科幻片', 'kehuanpian', 1, 14, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(9, '恐怖片', 'kongbupian', 1, 14, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(10, '剧情片', 'juqingpian', 1, 16, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(11, '战争片', 'zhanzhengpian', 1, 17, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(12, '国产剧', 'guochanju', 2, 21, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(13, '港台剧', 'gangtaiju', 2, 22, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(14, '日韩剧', 'rihanju', 2, 23, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', ''),\n(15, '欧美剧', 'oumeiju', 2, 24, 0, 'vod_type.html', 'vod_list.html', 'vod_detail.html', 'vod_play.html', 'vod_down.html', '', '', '', '');\n"); $db->query("INSERT INTO `" . $db_tablepre . "art_type` (`t_id`, `t_name`, `t_enname`, `t_pid`, `t_sort`, `t_hide`, `t_tpl`, `t_tpl_list`, `t_tpl_art`, `t_key`, `t_des`, `t_title`, `t_union`) VALUES\n(1, '站内新闻', 'zhanneixinwen', 0, 1, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', ''),\n(2, '娱乐动态', 'yuledongtai', 0, 2, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', ''),\n(3, '八卦爆料', 'baguabaoliao', 0, 3, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', ''),\n(4, '影片资讯', 'yingpianzixun', 0, 4, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', ''),\n(5, '明星资讯', 'mingxingzixun', 0, 5, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', ''),\n(6, '电视资讯', 'dianshizixun', 0, 6, 0, 'art_type.html', 'art_list.html', 'art_detail.html', '', '', '', '');\n"); $db->query("INSERT INTO `" . $db_tablepre . "vod_class` ( `c_name`, `c_pid`, `c_sort`, `c_hide`) VALUES\n( '惊悚', 1, 1, 0),( '悬疑', 1, 2, 0),( '魔幻', 1, 3, 0),( '罪案', 1, 4, 0),( '灾难', 1, 5, 0),( '动画', 1, 6, 0),( '古装', 1, 7, 0),( '青春', 1, 8, 0),( '歌舞', 1, 9, 0),( '文艺', 1, 10, 0),( '生活', 1, 10, 0),( '历史', 1, 10, 0),( '励志', 1, 10, 0),( '预告片', 1, 10, 0),\n\t\t\n( '言情', 2, 1, 0),( '都市', 2, 2, 0),( '家庭', 2, 3, 0),( '生活', 2, 4, 0),( '偶像', 2, 5, 0),( '喜剧', 2, 6, 0),( '历史', 2, 7, 0),( '古装', 2, 8, 0),\n( '武侠', 2, 9, 0),( '刑侦', 2, 10, 0),( '战争', 2, 11, 0),( '神话', 2, 12, 0),( '军旅', 2, 13, 0),( '谍战', 2, 14, 0),( '商战', 2, 15, 0),( '校园', 2, 16, 0),( '穿越', 2, 17, 0),( '悬疑', 2, 18, 0),( '犯罪', 2, 19, 0),( '科幻', 2, 20, 0),( '预告片', 2, 21, 0),\n\n( '脱口秀', 3, 1, 0),( '真人秀', 3, 2, 0),( '选秀', 3, 3, 0),( '情感', 3, 4, 0),( '访谈', 3, 5, 0),( '时尚', 3, 6, 0),( '晚会', 3, 7, 0),( '财经', 3, 8, 0),( '益智', 3, 9, 0),( '音乐', 3, 10, 0),( '游戏', 3, 11, 0),( '职场', 3, 12, 0),( '美食', 3, 13, 0),( '旅游', 3, 14, 0),\n\t\n( '冒险', 4, 1, 0),( '热血', 4, 2, 0),( '搞笑', 4, 3, 0),( '少女', 4, 4, 0),( '推理', 4, 5, 0),( '竞技', 4, 6, 0),( '益智', 4, 7, 0),( '童话', 4, 8, 0),( '经典', 4, 9, 0);\n"); echo '<script type="text/javascript">showmessage(\'数据分类初始化成功... \');</script>'; updateCacheFile(); echo '<script type="text/javascript">showmessage(\'数据缓存初始化成功... \');</script>'; } unset($db); }
<?php if (!defined('MAC_ROOT')) { exit('Access Denied'); } include MAC_ROOT . '/inc/common/phplib.php'; include MAC_ROOT . '/inc/user/qqconnect.php'; @(include MAC_ROOT . '/inc/user/ucenter/config.inc.php'); @(include MAC_ROOT . '/inc/user/ucenter/uc_client/client.php'); if ($MAC['user']['status'] == 0) { echo '会员系统关闭中'; exit; } $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $tpl->C["siteaid"] = 40; function chklogin() { global $user; if (intval($_SESSION["userid"]) > 0) { $sql = "SELECT * FROM {pre}user where u_id=" . $_SESSION["userid"]; $user = $GLOBALS['db']->getRow($sql); $user['u_regtime'] = date('Y-m-d H:i:s', $user['u_regtime']); $user['u_logintime'] = date('Y-m-d H:i:s', $user['u_logintime']); $user['u_loginip'] = long2ip($user['u_loginip']); if (!empty($user['u_start'])) { $user['u_start'] = date('Y-m-d', $user['u_start']); } if (!empty($user['u_end'])) { $user['u_end'] = date('Y-m-d', $user['u_end']); } $loginValidate = md5($user["u_random"] . $user["u_id"]);
public static function getInstance() { // проверяем актуальность экземпляра if (null === self::$_instance) { // создаем новый экземпляр self::$_instance = new self(); } // возвращаем созданный или существующий экземпляр return self::$_instance; }
} $pattern = '/[^\\x00-\\x80]/'; if (!preg_match($pattern, $c_content)) { echo '内容必须包含中文,请重新输入!'; exit; } $c_name = badFilter($c_name); $c_name = strip_tags($c_name); $c_content = badFilter($c_content); $c_content = strip_tags($c_content); $c_ip = ip2long(getIP()); $c_time = time(); if ($MAC['other']['commentaudit'] == 1) { $c_hide = 1; } else { $c_hide = 0; } if (strlen($c_name) > 64) { $c_name = substring($c_name, 64); } if (strlen($c_content) > 255) { $c_content = substring($c_content, 255); } $db = new AppDb($MAC['db']['server'], $MAC['db']['user'], $MAC['db']['pass'], $MAC['db']['name']); $db->Add("{pre}comment", array("c_vid", "c_hide", "c_type", "c_name", "c_ip", "c_time", "c_content"), array($c_vid, $c_hide, $c_type, $c_name, $c_ip, $c_time, $c_content)); $_SESSION["last_commenttime"] = time(); $_SESSION["code_comment"] = ""; echo "ok"; } else { showErr('System', '未找到指定系统模块'); }