Example #1
0
     $msgtitle = "你没有权限浏览文档:{$arctitle} !";
     $moremsg = "这篇文档需要 <font color='red'>" . $memberTypes[$needRank] . "</font> 才能访问,你目前是:<font color='red'>" . $memberTypes[$cfg_ml->M_Rank] . "</font> !";
     include_once DEDETEMPLATE . '/plus/view_msg.htm';
     exit;
 }
 //需要金币的情况
 if ($needMoney > 0 && $arc->Fields['mid'] != $cfg_ml->M_ID) {
     $sql = "SELECT aid,money FROM `#@__member_operation` WHERE buyid='ARCHIVE" . $aid . "' AND mid='" . $cfg_ml->M_ID . "'";
     $row = $dsql->GetOne($sql);
     //未购买过此文章
     if (!is_array($row)) {
         if ($cfg_ml->M_Money == '' || $needMoney > $cfg_ml->M_Money) {
             $msgtitle = "你没有权限浏览文档:{$arctitle} !";
             $moremsg = "这篇文档需要 <font color='red'>" . $needMoney . " 金币</font> 才能访问,你目前拥有金币:<font color='red'>" . $cfg_ml->M_Money . " 个</font> !";
             include_once DEDETEMPLATE . '/plus/view_msg.htm';
             $arc->Close();
             exit;
         } else {
             if ($dopost == 'buy') {
                 $inquery = "INSERT INTO `#@__member_operation`(mid,oldinfo,money,mtime,buyid,product,pname)\r\n                              VALUES ('" . $cfg_ml->M_ID . "','{$arctitle}','{$needMoney}','" . time() . "', 'ARCHIVE" . $aid . "', 'archive',''); ";
                 if ($dsql->ExecuteNoneQuery($inquery)) {
                     $inquery = "UPDATE `#@__member` SET money=money-{$needMoney} WHERE mid='" . $cfg_ml->M_ID . "'";
                     if (!$dsql->ExecuteNoneQuery($inquery)) {
                         showmsg('购买失败, 请返回', -1);
                         exit;
                     }
                     #api{{
                     if (defined('UC_APPID')) {
                         include_once DEDEROOT . '/api/uc.func.php';
                         $row = $dsql->GetOne("SELECT `scores`,`userid` FROM `#@__member` WHERE `mid`='" . $cfg_ml->M_ID . "'");
                         uc_credit_note($row['userid'], -$needMoney, 'money');
 $AddSql = ereg_replace('@([a-z0-9]{1,})@', '', $AddSql);
 if (!$dsql->ExecuteNoneQuery($MaiSql)) {
     $dsql->ExecuteNoneQuery("Delete From `#@__arctiny` where id='{$aid}' ");
 } else {
     if (!$dsql->ExecuteNoneQuery($AddSql)) {
         $dsql->ExecuteNoneQuery("Delete From `#@__arctiny` where id='{$aid}' ");
         $dsql->ExecuteNoneQuery("Delete From `{$Maitable}` where id='{$aid}' ");
     } else {
         if ($make) {
             require_once DEDEINC . "/arc.archives.class.php";
             $ac = new Archives($aid);
             $rurl = $ac->MakeHtml();
             $ac->Close();
             $ac = new Archives($aid - 1);
             $rurl = $ac->MakeHtml();
             $ac->Close();
             $dsql->ExecuteNoneQuery("Update `#@__co_note` set cotime='" . time() . "' where nid='{$nid}'; ");
         }
         //更新数据
         $row = $dsql->GetOne("SELECT a.id,a.title,a.click,a.typeid,b.body,c.typename,c.zuozhe,c.bookclick,c.bookclickm,c.bookclickw,c.tuijian,c.tuijianm,c.tuijianw,c.booksize,c.lastclick,c.lasttuijian,c.startdate,c.reid,d.typename as retypename FROM `{$Maitable}` a left join `{$Addtable}` b on(a.id=b.aid) left join `#@__arctype` c on(a.typeid=c.id) left join `#@__arctype` d on(c.reid=d.id) WHERE a.id='{$aid}'");
         if ($row) {
             $txt_filename = $row['zuozhe'] . "-" . $row['typename'];
             $typename = $row['typename'];
             $txt_comtens = "";
             $startdatesql = "";
             $txt_title = $row['title'];
             $treid = $row['reid'];
             $tretypename = $row['retypename'];
             $updatetime = time();
             $lastclick = $row['lastclick'];
             $lasttuijian = $row['lasttuijian'];