//商户订单号 $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; //——请根据您的业务逻辑来编写程序(以上代码仅作参考)—— ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } else { //验证失败 echo "fail"; //调试用,写文本函数记录程序运行情况是否正常
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); }
$todaydate = date('Y-m-d'); if ($h == 24) { $tommdate = date('Y-m-d', strtotime('+1 day')); } elseif ($h == 98) { $tommdate = date('Y-m-d', strtotime('+7 day')); } $todayunix = strtotime($todaydate); $tommunix = strtotime($tommdate); $whereStr = ' AND d_time>= ' . $todayunix . ' AND d_time<=' . $tommunix; $sql .= $whereStr; $sql1 .= $whereStr; } $nums = $db->getOne($sql1); $pagecount = ceil($nums / $MAC['api']['vod']['pagesize']); $sql = $sql . " limit " . $MAC['api']['vod']['pagesize'] * ($pg - 1) . "," . $MAC['api']['vod']['pagesize']; $rs = $db->query($sql); if (!$rs) { echo "err:" . "<br>" . $sql; exit; } else { $xml .= "<list page=\"" . $pg . "\" pagecount=\"" . $pagecount . "\" pagesize=\"" . $MAC['api']['vod']['pagesize'] . "\" recordcount=\"" . $nums . "\">"; while ($row = $db->fetch_array($rs)) { $tempurl = urlDeal($row["d_playurl"], $row["d_playfrom"]); if (strpos("," . $row["d_pic"], "http://") > 0) { $temppic = $row["d_pic"]; } else { $temppic = $MAC['api']['vod']['imgurl'] . $row["d_pic"]; } $typearr = $MAC_CACHE['vodtype'][$row["d_type"]]; $xml .= "<video>"; $xml .= "<last>" . date('Y-m-d H:i:s', $row["d_time"]) . "</last>";
redirect("/"); exit; } $userid = intval($tpl->P['uid']); if ($userid > 0) { $ip = ip2long(getIP()); $ly = getReferer(); StopAttack('referer', $ly, $getfilter); $ly = chkSql($ly); $todayunix = strtotime("today"); $tommunix = strtotime(date('Y-m-d', strtotime('+1 day'))); $sql = "select * from {pre}user_visit where uv_uid=" . $userid . " and uv_ip='" . $ip . "' and uv_time>=" . $todayunix . " and uv_time <=" . $tommunix; $row1 = $db->getRow($sql); if (!$row1) { $db->Add("{pre}user_visit", array("uv_uid", "uv_ip", "uv_ly", "uv_time"), array($userid, $ip, $ly, time())); $db->query("update {pre}user set u_extend=u_extend+1,u_points=u_points+" . $MAC['user']['popularize'] . " where u_id=" . $userid); $sql = "delete from {pre}user_visit where uv_time<" . $todayunix; $db->query($sql); } unset($row1); } redirect("/"); } elseif ($method == 'save') { chklogin(); $oldpass = be("post", "u_oldpass"); $password1 = be("post", "u_password1"); $password2 = be("post", "u_password2"); $u_qq = be("post", "u_qq"); $u_qq = chkSql($u_qq); $u_email = be("post", "u_email"); $u_email = chkSql($u_email);