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', '未找到指定系统模块');
}
