/** * 操作数据库 * @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']); }