PHP PW_ActivityForBbs::activityDelSendmsg Examples

Example #1

File: superdel.php Project: sherlockhouse/aliyun

/**
 * 将活动帖子的数据删除
 * @param array $activityDb 帖子数据，形入array(tid, tid)
 */
function _delActivityTopic($activityDb)
{
    global $db;
    $defaultValueTableName = getActivityValueTableNameByActmid();
    $newActivityDb = array();
    $query = $db->query("SELECT actmid,tid FROM {$defaultValueTableName} WHERE tid IN(" . S::sqlImplode($activityDb) . ")");
    while ($rt = $db->fetch_array($query)) {
        $newActivityDb[$rt['actmid']][] = $rt['tid'];
    }
    /*帖子被删除费用日志更新*/
    L::loadClass('ActivityForBbs', 'activity', false);
    $postActForBbs = new PW_ActivityForBbs($data);
    $data = array();
    /*帖子被删除费用日志更新*/
    foreach ($newActivityDb as $key => $value) {
        $tids = S::sqlImplode($value);
        $userDefinedValueTableName = getActivityValueTableNameByActmid($key, 1, 1);
        $db->update("DELETE FROM {$defaultValueTableName} WHERE tid IN({$tids})");
        $db->update("DELETE FROM {$userDefinedValueTableName} WHERE tid IN({$tids})");
        $db->update("DELETE FROM pw_activitymembers WHERE tid IN({$tids})");
        /*帖子被删除费用日志更新*/
        $postActForBbs->UpdatePayLog($value, 0, 4);
        /*帖子被删除费用日志更新*/
        /*帖子被删除发送站内信*/
        $postActForBbs->activityDelSendmsg($value);
        /*帖子被删除发送站内信*/
    }
}