Beispiel #1
0
 /**
  * 操作数据库
  * @param int $tid 帖子id
  * @param int $fid 版块id
  */
 function insertData($tid, $fid)
 {
     /*操作数据库*/
     global $action, $atc_title;
     $this->data['default'] = $this->data['act']['0'];
     $this->data['default']['tid'] = $tid;
     $this->data['default']['fid'] = $fid;
     $this->data['default']['actmid'] = $this->actmid;
     $this->data['user'] = array();
     !S::isArray($this->data['act']['1']) && ($this->data['act']['1'] = array());
     foreach ($this->data['act']['1'] as $key => $value) {
         if ($value) {
             $this->data['user'][$key] = $value;
         }
     }
     $this->data['user']['tid'] = $tid;
     $this->data['user']['fid'] = $fid;
     unset($this->data['act']);
     $defaultValueTableName = getActivityValueTableNameByActmid();
     $userDefinedValueTableName = getActivityValueTableNameByActmid($this->actmid, 1, 1);
     $this->db->pw_update("SELECT tid FROM {$defaultValueTableName} WHERE tid=" . S::sqlEscape($tid), "UPDATE {$defaultValueTableName} SET " . S::sqlSingle($this->data['default']) . "WHERE tid=" . S::sqlEscape($tid), "INSERT INTO {$defaultValueTableName} SET " . S::sqlSingle($this->data['default']));
     $this->db->pw_update("SELECT tid FROM {$userDefinedValueTableName} WHERE tid=" . S::sqlEscape($tid), "UPDATE {$userDefinedValueTableName} SET " . S::sqlSingle($this->data['user']) . "WHERE tid=" . S::sqlEscape($tid), "INSERT INTO {$userDefinedValueTableName} SET " . S::sqlSingle($this->data['user']));
     $subject = $this->db->get_value('SELECT subject FROM pw_threads WHERE tid=' . S::sqlEscape($tid));
     if ($subject) {
         $this->db->update('UPDATE pw_activitypaylog SET subject=' . S::sqlEscape($subject) . ' WHERE tid=' . S::sqlEscape($tid));
     }
     /*选择支付宝+没有绑定支付宝+没有通过支付宝实名认证 or 创建AA活动号*/
     if ($this->data['default']['paymethod'] == 1) {
         $tradeinfo = $this->db->get_one("SELECT tradeinfo FROM pw_memberinfo WHERE uid=" . S::sqlEscape($this->winduid));
         $tradeinfo = unserialize($tradeinfo['tradeinfo']);
         $alipay = $tradeinfo['alipay'];
         $isBinded = $tradeinfo['isbinded'];
         $isCertified = $tradeinfo['iscertified'];
         if (!$alipay || $isBinded != 'T' || $isCertified != 'T') {
             //选择支付宝+没有绑定支付宝+没有通过支付宝实名认证
             $this->db->update("UPDATE {$defaultValueTableName} SET iscertified=0 WHERE tid=" . S::sqlEscape($tid));
         } elseif ($alipay && $isBinded == 'T' && $isCertified == 'T') {
             //绑定支付宝+通过支付宝实名认证
             $this->db->update("UPDATE {$defaultValueTableName} SET iscertified=1 WHERE tid=" . S::sqlEscape($tid));
             require_once R_P . 'lib/activity/alipay_push.php';
             $alipayPush = new AlipayPush();
             if ($action == 'new') {
                 $alipayPush->create_aa_payment($tid, $this->winduid, $this->actmid, $atc_title);
                 //创建AA活动号
             } elseif ($action == 'modify') {
                 $alipayPush->modify_aa_payment($tid, $this->actmid, $atc_title);
                 //修改AA活动号
             }
         }
     }
     /*选择支付宝+没有绑定支付宝+没有通过支付宝实名认证 or 创建AA活动号*/
     /*附件上传*/
     L::loadClass('activityupload', 'upload', false);
     $img = new ActivityUpload($tid, $this->actmid);
     PwUpload::upload($img);
     require_once R_P . 'require/functions.php';
     pwFtpClose($GLOBALS['ftp']);
 }