PHP PLG_itemDeleted函数代码示例

/**
* Automatic uninstall function for plugins
*
* @return   array
*
* This code is automatically uninstalling the plugin.
* It passes an array to the core code function that removes
* tables, groups, features and php blocks from the tables.
* Additionally, this code can perform special actions that cannot be
* foreseen by the core code (interactions with other plugins for example)
*
*/
function plugin_autouninstall_nexproject()
{
    global $_PRJCONF, $_TABLES;
    $out = array('tables' => array('prj_category', 'prj_department', 'prj_location', 'prj_objective', 'prj_permissions', 'prj_users', 'prj_projects', 'prj_sorting', 'prj_task_users', 'prj_tasks', 'prj_statuslog', 'prj_session', 'prj_filters', 'prj_lockcontrol', 'prj_projPerms', 'prj_taskSemaphore', 'prj_config'), 'groups' => array('nexProject Admin'), 'features' => array('nexproject.admin'), 'php_blocks' => array('phpblock_projectFilter'), 'vars' => array());
    if (prj_forumExists()) {
        //using this row's config value, we'll delete all forums with this ID as the parent and then chuck out the category itself...
        $sql = "SELECT * FROM {$_TABLES['gf_forums']} where forum_cat={$_PRJCONF['forum_parent']}";
        $forumres = DB_query($sql);
        while ($X = DB_fetchArray($forumres)) {
            forum_deleteForum($X['forum_id']);
        }
        DB_query("DELETE FROM {$_TABLES['gf_categories']} where id={$_PRJCONF['forum_parent']}");
    }
    if (prj_nexFileExists()) {
        PLG_itemDeleted($_PRJCONF['nexfile_parent'], 'nexproject_filefolder');
    }
    DB_query("DELETE FROM {$_TABLES['nexlistitems']} WHERE lid={$_PRJCONF['nexlist_locations']}");
    DB_query("DELETE FROM {$_TABLES['nexlistfields']} WHERE lid={$_PRJCONF['nexlist_locations']}");
    DB_query("DELETE FROM {$_TABLES['nexlist']} WHERE id={$_PRJCONF['nexlist_locations']}");
    DB_query("DELETE FROM {$_TABLES['nexlistitems']} WHERE lid={$_PRJCONF['nexlist_departments']}");
    DB_query("DELETE FROM {$_TABLES['nexlistfields']} WHERE lid={$_PRJCONF['nexlist_departments']}");
    DB_query("DELETE FROM {$_TABLES['nexlist']} WHERE id={$_PRJCONF['nexlist_departments']}");
    DB_query("DELETE FROM {$_TABLES['nexlistitems']} WHERE lid={$_PRJCONF['nexlist_category']}");
    DB_query("DELETE FROM {$_TABLES['nexlistfields']} WHERE lid={$_PRJCONF['nexlist_category']}");
    DB_query("DELETE FROM {$_TABLES['nexlist']} WHERE id={$_PRJCONF['nexlist_category']}");
    DB_query("DELETE FROM {$_TABLES['nexlistitems']} WHERE lid={$_PRJCONF['nexlist_objective']}");
    DB_query("DELETE FROM {$_TABLES['nexlistfields']} WHERE lid={$_PRJCONF['nexlist_objective']}");
    DB_query("DELETE FROM {$_TABLES['nexlist']} WHERE id={$_PRJCONF['nexlist_objective']}");
    return $out;
}

/**
* Delete a poll
*
* @param    string  $pid    ID of poll to delete
* @return   string          HTML redirect
*
*/
function deletePoll($pid)
{
    global $_CONF, $_TABLES, $_USER;
    $pid = addslashes($pid);
    $result = DB_query("SELECT owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$_TABLES['polltopics']} WHERE pid = '{$pid}'");
    $Q = DB_fetchArray($result);
    $access = SEC_hasAccess($Q['owner_id'], $Q['group_id'], $Q['perm_owner'], $Q['perm_group'], $Q['perm_members'], $Q['perm_anon']);
    if ($access < 3) {
        COM_accessLog("User {$_USER['username']} tried to illegally delete poll {$pid}.");
        return COM_refresh($_CONF['site_admin_url'] . '/plugins/polls/index.php');
    }
    DB_delete($_TABLES['polltopics'], 'pid', $pid);
    DB_delete($_TABLES['pollanswers'], 'pid', $pid);
    DB_delete($_TABLES['pollquestions'], 'pid', $pid);
    DB_delete($_TABLES['comments'], array('sid', 'type'), array($pid, 'polls'));
    PLG_itemDeleted($pid, 'polls');
    return COM_refresh($_CONF['site_admin_url'] . '/plugins/polls/index.php?msg=20');
}

/**
 * Delete a story and related data immediately.
 * Note: For internal use only! To delete a story, use STORY_deleteStory (see
 *       above), which will do permission checks and eventually end up here.
 *
 * @param    string $sid ID of the story to delete
 * @internal For internal use only!
 */
function STORY_doDeleteThisStoryNow($sid)
{
    global $_CONF, $_TABLES;
    require_once $_CONF['path_system'] . 'lib-comment.php';
    STORY_deleteImages($sid);
    DB_delete($_TABLES['comments'], array('sid', 'type'), array($sid, 'article'));
    DB_delete($_TABLES['trackback'], array('sid', 'type'), array($sid, 'article'));
    DB_delete($_TABLES['stories'], 'sid', $sid);
    TOPIC_deleteTopicAssignments('article', $sid);
    // notify plugins
    PLG_itemDeleted($sid, 'article');
    // update RSS feed
    COM_rdfUpToDateCheck('article');
    COM_rdfUpToDateCheck('comment');
    STORY_updateLastArticlePublished();
    CMT_updateCommentcodes();
}

function delCat()
{
    global $_CONF, $_TABLES, $eh, $mytree, $filemgmt_FileStore, $filemgmt_SnapCat, $filemgmt_SnapStore;
    $cid = $_POST['cid'];
    //get all subcategories under the specified category
    $arr = $mytree->getAllChildId($cid);
    for ($i = 0; $i < sizeof($arr); $i++) {
        //get all downloads in each subcategory
        $result = DB_query("SELECT lid,url,logourl FROM {$_TABLES['filemgmt_filedetail']} WHERE cid='{$arr[$i]}'");
        //now for each download, delete the text data and votes associated with the download
        while (list($lid, $url, $logourl) = DB_fetchArray($result)) {
            DB_query("DELETE FROM {$_TABLES['filemgmt_filedesc']} WHERE lid='{$lid}'");
            DB_query("DELETE FROM {$_TABLES['filemgmt_votedata']} WHERE lid='{$lid}'");
            DB_query("DELETE FROM {$_TABLES['filemgmt_filedetail']} WHERE lid='{$lid}'");
            DB_query("DELETE FROM {$_TABLES['filemgmt_brokenlinks']} WHERE lid='{$lid}'");
            $name = rawurldecode($url);
            $fullname = $filemgmt_FileStore . $name;
            if ($fullname != "" && file_exists($fullname) && !is_dir($fullname)) {
                $err = @unlink($fullname);
            }
            $name = rawurldecode($logourl);
            $fullname = $filemgmt_SnapStore . $name;
            if ($fullname != "" && file_exists($fullname) && !is_dir($fullname)) {
                $err = @unlink($fullname);
            }
        }
        //all downloads for each subcategory is deleted, now delete the subcategory data
        $catimage = DB_getItem($_TABLES['filemgmt_cat'], 'imgurl', "cid='{$arr[$i]}'");
        $catimage_filename = $filemgmt_SnapCat . $catimage;
        if ($catimage != '' && file_exists($catimage_filename) && !is_dir($catimage_filename)) {
            // Check that there is only one category using this image
            if (DB_count($_TABLES['filemgmt_cat'], 'imgurl', $catimage) == 1) {
                @unlink($catimage_filename);
            }
        }
        DB_query("DELETE FROM {$_TABLES['filemgmt_cat']} WHERE cid='{$arr[$i]}'");
    }
    //all subcategory and associated data are deleted, now delete category data and its associated data
    $result = DB_query("SELECT lid,url,logourl FROM {$_TABLES['filemgmt_filedetail']} WHERE cid='{$cid}'");
    while (list($lid, $url, $logourl) = DB_fetchArray($result)) {
        DB_query("DELETE FROM {$_TABLES['filemgmt_filedetail']} WHERE lid='{$lid}'");
        DB_query("DELETE FROM {$_TABLES['filemgmt_filedesc']} WHERE lid='{$lid}'");
        DB_query("DELETE FROM {$_TABLES['filemgmt_brokenlinks']} WHERE lid='{$lid}'");
        PLG_itemDeleted($lid, 'filemgmt');
        $name = rawurldecode($url);
        $fullname = $filemgmt_FileStore . $name;
        if ($fullname != "" && file_exists($fullname) && !is_dir($fullname)) {
            $err = @unlink($fullname);
        }
        $name = rawurldecode($logourl);
        $fullname = $filemgmt_SnapStore . $name;
        if ($fullname != '' && file_exists($fullname) && !is_dir($fullname)) {
            $err = @unlink($fullname);
        }
    }
    $catimage = DB_getItem($_TABLES['filemgmt_cat'], 'imgurl', "cid='{$cid}'");
    $catimage_filename = $filemgmt_SnapCat . $catimage;
    if ($catimage != '' && file_exists($catimage_filename) && !is_dir($catimage_filename)) {
        // Check that there is only one category using this image
        if (DB_count($_TABLES['filemgmt_cat'], 'imgurl', $catimage) == 1) {
            @unlink($catimage_filename);
        }
    }
    DB_query("DELETE FROM {$_TABLES['filemgmt_cat']} WHERE cid='{$cid}'");
    CACHE_remove_instance('whatsnew');
    redirect_header("{$_CONF['site_admin_url']}/plugins/filemgmt/index.php?op=categoryConfigAdmin", 2, _MD_CATDELETED);
    exit;
}

/**
* Delete a story and related data immediately.
*
* Note: For internal use only! To delete a story, use STORY_deleteStory (see
*       above), which will do permission checks and eventually end up here.
*
* @param    string  $sid    ID of the story to delete
* @internal For internal use only!
*
*/
function STORY_doDeleteThisStoryNow($sid)
{
    global $_CONF, $_TABLES;
    require_once $_CONF['path_system'] . 'lib-comment.php';
    STORY_deleteImages($sid);
    DB_delete($_TABLES['comments'], array('sid', 'type'), array($sid, 'article'));
    DB_delete($_TABLES['trackback'], array('sid', 'type'), array($sid, 'article'));
    DB_delete($_TABLES['stories'], 'sid', $sid);
    // notify plugins
    PLG_itemDeleted($sid, 'article');
    // update RSS feed and Older Stories block
    COM_rdfUpToDateCheck();
    COM_olderStuff();
    CMT_updateCommentcodes();
}

/**
 * Delete an existing static page
 *
 * @param   array   args    Contains all the data provided by the client
 * @param   string  &output OUTPUT parameter containing the returned text
 * @param   string  &svc_msg OUTPUT parameter containing any service messages
 * @return  int		    Response code as defined in lib-plugins.php
 */
function service_delete_staticpages($args, &$output, &$svc_msg)
{
    global $_CONF, $_TABLES, $_USER, $LANG_ACCESS, $LANG12, $LANG_STATIC, $LANG_LOGIN;
    if (empty($args['sp_id']) && !empty($args['id'])) {
        $args['sp_id'] = $args['id'];
    }
    // Apply filters to the parameters passed by the webservice
    if ($args['gl_svc']) {
        $args['sp_id'] = COM_applyBasicFilter($args['sp_id']);
        $args['mode'] = COM_applyBasicFilter($args['mode']);
    }
    $sp_id = $args['sp_id'];
    if (!SEC_hasRights('staticpages.delete')) {
        $output = COM_siteHeader('menu', $LANG_STATIC['access_denied']);
        $output .= COM_showMessageText($LANG_STATIC['access_denied_msg'], $LANG_STATIC['access_denied'], true);
        $output .= COM_siteFooter();
        if (!COM_isAnonUser()) {
            return PLG_RET_PERMISSION_DENIED;
        } else {
            return PLG_RET_AUTH_FAILED;
        }
    }
    DB_delete($_TABLES['staticpage'], 'sp_id', $sp_id);
    DB_delete($_TABLES['comments'], array('sid', 'type'), array($sp_id, 'staticpages'));
    PLG_itemDeleted($sp_id, 'staticpages');
    $output = COM_refresh($_CONF['site_admin_url'] . '/plugins/staticpages/index.php');
    return PLG_RET_OK;
}

/**
 * Delete an existing story
 *
 * @param   array   args    Contains all the data provided by the client
 * @param   string  &output OUTPUT parameter containing the returned text
 * @return  int		    Response code as defined in lib-plugins.php
 */
function service_delete_story($args, &$output, &$svc_msg)
{
    global $_CONF, $_TABLES, $_USER;
    if (empty($args['sid']) && !empty($args['id'])) {
        $args['sid'] = $args['id'];
    }
    if ($args['gl_svc']) {
        $args['sid'] = COM_applyBasicFilter($args['sid']);
    }
    $sid = $args['sid'];
    $result = DB_query("SELECT tid,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon FROM {$_TABLES['stories']} WHERE sid = '" . DB_escapeString($sid) . "'");
    $A = DB_fetchArray($result);
    $access = SEC_hasAccess($A['owner_id'], $A['group_id'], $A['perm_owner'], $A['perm_group'], $A['perm_members'], $A['perm_anon']);
    $access = min($access, SEC_hasTopicAccess($A['tid']));
    if ($access < 3) {
        COM_accessLog("User {$_USER['username']} tried to illegally delete story {$sid}.");
        $output = COM_refresh($_CONF['site_admin_url'] . '/story.php');
        if ($_USER['uid'] > 1) {
            return PLG_RET_PERMISSION_DENIED;
        } else {
            return PLG_RET_AUTH_FAILED;
        }
    }
    STORY_deleteImages($sid);
    DB_query("DELETE FROM {$_TABLES['comments']} WHERE sid = '" . DB_escapeString($sid) . "' AND type = 'article'");
    DB_delete($_TABLES['stories'], 'sid', DB_escapeString($sid));
    // delete Trackbacks
    DB_query("DELETE FROM {$_TABLES['trackback']} WHERE sid = '" . DB_escapeString($sid) . "' AND type = 'article';");
    PLG_itemDeleted($sid, 'article');
    // update RSS feed and Older Stories block
    COM_rdfUpToDateCheck();
    COM_olderStuff();
    COM_setMessage(10);
    $output = COM_refresh($_CONF['site_admin_url'] . '/story.php');
    return PLG_RET_OK;
}

}
foreach ($pluginLangLines as $line) {
    if (trim($line) == '' || substr($line, 0, 1) == '#') {
        continue;
    }
    $tokens = explode('=', $line);
    $key = 'LANG_' . trim($tokens[0]);
    array_shift($tokens);
    $val = implode('=', $tokens);
    $pluginLangLabels[$key] = trim($val);
}
/* Record Project ID (pid) in a project session record so we can navigate back from the other plugins */
prj_updateSession($pid);
switch ($mode) {
    case 'deletefile':
        PLG_itemDeleted($id, 'nexproject_fileitem');
        break;
    case 'edit':
        // Edit Task
        if ($pid == 0 and $id > 0) {
            // If pid not set but task id is - retrieve the pid (project id)
            $pid = DB_getItem($_TABLES['prj_tasks'], 'pid', "tid={$id}");
        }
        $uid = $_USER['uid'];
        $protoken = prj_getProjectPermissions($pid, $uid, $id);
        $ownertoken = getTaskToken($id, $uid, "{$_TABLES['prj_task_users']}", "{$_TABLES['prj_tasks']}");
        if ($protoken['full'] != 0 || $protoken['teammember'] != 0 || $ownertoken != 0) {
            $taskrec = DB_fetchArray(DB_query("SELECT * FROM {$_TABLES['prj_tasks']} WHERE tid={$id}"));
            $result = DB_query("SELECT pid, name FROM {$_TABLES['prj_projects']} WHERE pid={$pid}");
            list($pid, $name) = DB_fetchArray($result);
            $edit_icons = prj_edit_task_icons($pid, $id, 'edit');

/**
* Recursivly deletes all albums and child albums
*
* @param    int     album_id    album id to delete
* @return   int     true for success or false for failure
*
*/
function MG_deleteChildAlbums($album_id)
{
    global $MG_albums, $_CONF, $_MG_CONF, $_TABLES, $_USER;
    $sql = "SELECT * FROM {$_TABLES['mg_albums']} WHERE album_parent=" . $album_id;
    $aResult = DB_query($sql);
    $rowCount = DB_numRows($aResult);
    for ($z = 0; $z < $rowCount; $z++) {
        $row = DB_fetchArray($aResult);
        MG_deleteChildAlbums($row['album_id']);
    }
    $sql = "SELECT ma.media_id, m.media_filename, m.media_mime_ext\r\n            FROM " . $_TABLES['mg_media_albums'] . " as ma LEFT JOIN " . $_TABLES['mg_media'] . " as m ON ma.media_id=m.media_id\r\n            WHERE ma.album_id = " . $album_id;
    $result = DB_query($sql);
    $nRows = DB_numRows($result);
    $mediarow = array();
    for ($i = 0; $i < $nRows; $i++) {
        $row = DB_fetchArray($result);
        $mediarow[] = $row;
    }
    if (count($mediarow) != 0) {
        for ($i = 0; $i < count($mediarow); $i++) {
            $sql = "SELECT COUNT(media_id) AS count FROM " . $_TABLES['mg_media_albums'] . "  WHERE media_id = '" . $mediarow[$i]['media_id'] . "'";
            $result = DB_query($sql);
            $row = DB_fetchArray($result);
            if ($row['count'] <= 1) {
                foreach ($_MG_CONF['validExtensions'] as $ext) {
                    @unlink($_MG_CONF['path_mediaobjects'] . 'tn/' . $mediarow[$i]['media_filename'][0] . '/' . $mediarow[$i]['media_filename'] . $ext);
                    @unlink($_MG_CONF['path_mediaobjects'] . 'disp/' . $mediarow[$i]['media_filename'][0] . '/' . $mediarow[$i]['media_filename'] . $ext);
                }
                @unlink($_MG_CONF['path_mediaobjects'] . 'orig/' . $mediarow[$i]['media_filename'][0] . '/' . $mediarow[$i]['media_filename'] . '.' . $mediarow[$i]['media_mime_ext']);
                $sql = "DELETE FROM " . $_TABLES['mg_media'] . "  WHERE media_id = '" . $mediarow[$i]['media_id'] . "'";
                DB_query($sql);
                DB_delete($_TABLES['comments'], 'sid', $mediarow[$i]['media_id']);
                DB_delete($_TABLES['mg_playback_options'], 'media_id', $mediarow[$i]['media_id']);
                PLG_itemDeleted($mediarow[$i]['media_id'], 'mediagallery');
            }
        }
    }
    $sql = "DELETE FROM " . $_TABLES['mg_media_albums'] . " WHERE album_id = " . $album_id;
    DB_query($sql);
    $sql = "DELETE FROM " . $_TABLES['mg_albums'] . " WHERE album_id = " . $album_id;
    DB_query($sql);
    $feedname = sprintf($_MG_CONF['rss_feed_name'] . "%06d", $album_id);
    $feedpath = MG_getFeedPath();
    @unlink($feedpath . '/' . $feedname . '.rss');
}

/* Check to see if user has checked multiple records to delete */
if (strcasecmp($_SERVER['REQUEST_METHOD'], 'POST') === 0 and $op == 'delchecked' and SEC_checkToken()) {
    $chk_record_delete = array();
    if (isset($_POST['chk_record_delete'])) {
        $chk_record_delete = $_POST['chk_record_delete'];
    }
    foreach ($chk_record_delete as $id) {
        $id = COM_applyFilter($id, true);
        DB_query("DELETE FROM {$_TABLES['forum_topic']} WHERE id='{$id}'");
        PLG_itemDeleted($id, 'forum');
    }
    COM_rdfUpToDateCheck('forum');
    // forum rss feeds update
} elseif ($op == 'delrecord' and SEC_checkToken()) {
    DB_query("DELETE FROM {$_TABLES['forum_topic']} WHERE id='{$id}'");
    PLG_itemDeleted($id, 'forum');
    COM_rdfUpToDateCheck('forum');
    // forum rss feeds update
}
// Page Navigation Logic
if (empty($show)) {
    $show = $CONF_FORUM['show_messages_perpage'];
}
// Check if this is the first page.
if (empty($page)) {
    $page = 1;
}
$whereSQL = '';
$forumname = '';
if ($forum > 0) {
    $whereSQL = " WHERE forum='{$forum}'";

     PLG_itemDeleted($msgid, 'forum');
     DB_query("DELETE FROM {$_TABLES['forum_topic']} WHERE (pid='{$msgid}')");
     DB_query("DELETE FROM {$_TABLES['forum_watch']} WHERE (id='{$msgid}')");
     $postCount = DB_Count($_TABLES['forum_topic'], 'forum', $forum);
     DB_query("UPDATE {$_TABLES['forum_forums']} SET topic_count=topic_count-1,post_count={$postCount} WHERE forum_id={$forum}");
     $query = DB_query("SELECT MAX(id) FROM {$_TABLES['forum_topic']} WHERE forum={$forum}");
     list($last_topic) = DB_fetchArray($query);
     if ($last_topic > 0) {
         DB_query("UPDATE {$_TABLES['forum_forums']} SET last_post_rec={$last_topic} WHERE forum_id={$forum}");
     } else {
         DB_query("UPDATE {$_TABLES['forum_forums']} SET last_post_rec=0 WHERE forum_id={$forum}");
     }
 } else {
     DB_query("UPDATE {$_TABLES['forum_topic']} SET replies=replies-1 WHERE id={$topicparent}");
     DB_query("DELETE FROM {$_TABLES['forum_topic']} WHERE (id='{$msgid}')");
     PLG_itemDeleted($msgid, 'forum');
     DB_query("UPDATE {$_TABLES['forum_forums']} SET post_count=post_count-1 WHERE forum_id={$forum}");
     // Get the post id for the last post in this topic
     $query = DB_query("SELECT MAX(id) FROM {$_TABLES['forum_topic']} WHERE forum={$forum}");
     list($last_topic) = DB_fetchArray($query);
     if ($last_topic > 0) {
         DB_query("UPDATE {$_TABLES['forum_forums']} SET last_post_rec={$last_topic} WHERE forum_id={$forum}");
     }
 }
 if ($topicparent == 0) {
     $topicparent = $msgid;
 } else {
     $lsql = DB_query("SELECT MAX(id) FROM {$_TABLES['forum_topic']} WHERE pid={$topicparent}");
     list($lastrecid) = DB_fetchArray($lsql);
     if ($lastrecid == NULL) {
         $topicdatecreated = DB_getItem($_TABLES['forum_topic'], 'date', "id={$topicparent}");

/**
* Delete an event
*
* @param    string  $eid    id of event to delete
* @param    string  $type   'submission' when attempting to delete a submission
* @param    string          HTML redirect
*/
function CALENDAR_delete($eid, $type = '')
{
    global $_CONF, $_TABLES, $_USER;
    if (empty($type)) {
        // delete regular event
        $result = DB_query("SELECT * FROM {$_TABLES['events']} WHERE eid = '" . DB_escapeString($eid) . "'");
        $A = DB_fetchArray($result);
        $access = SEC_hasAccess($A['owner_id'], $A['group_id'], $A['perm_owner'], $A['perm_group'], $A['perm_members'], $A['perm_anon']);
        if ($access < 3) {
            COM_accessLog("User {$_USER['username']} tried to illegally delete event {$eid}.");
            return COM_refresh($_CONF['site_admin_url'] . '/plugins/calendar/index.php');
        }
        DB_delete($_TABLES['events'], 'eid', DB_escapeString($eid));
        DB_delete($_TABLES['personal_events'], 'eid', DB_escapeString($eid));
        PLG_itemDeleted($eid, 'calendar');
        COM_rdfUpToDateCheck('calendar', $A['event_type'], $A['eid']);
        return COM_refresh($_CONF['site_admin_url'] . '/plugins/calendar/index.php?msg=18');
    } elseif ($type == 'submission') {
        if (plugin_ismoderator_calendar()) {
            DB_delete($_TABLES['eventsubmission'], 'eid', DB_escapeString($eid));
            return COM_refresh($_CONF['site_admin_url'] . '/moderation.php');
        } else {
            COM_accessLog("User {$_USER['username']} tried to illegally delete event submission {$eid}.");
        }
    } else {
        COM_accessLog("User {$_USER['username']} tried to illegally delete event {$eid} of type {$type}.");
    }
    return COM_refresh($_CONF['site_admin_url'] . '/plugins/calendar/index.php');
}

/**
 * Delete forum post(s)
 *
 * This function will delete the requested forum post and update all the
 * topic / forum counters.
 *
 * @param  int     $topic_id        Topic ID to delete
 * @param  int     $topic_parent_id Parent ID of topic
 * @param  int     $forum_id        Forum ID where topic exists
 *
 * @return  string HTML to display confirmation
 */
function moderator_deletePost($topic_id, $topic_parent_id, $forum_id)
{
    global $_CONF, $_USER, $_TABLES, $_FF_CONF, $LANG_GF02;
    $retval = '';
    $topicparent = DB_getItem($_TABLES['ff_topic'], "pid", "id=" . (int) $topic_id);
    if ($topicparent == 0) {
        // Need to check for any attachments and delete if required
        $q1 = DB_query("SELECT id FROM {$_TABLES['ff_topic']} WHERE pid=" . (int) $topic_id . " OR id=" . (int) $topic_id);
        while ($A = DB_fetchArray($q1)) {
            $q2 = DB_query("SELECT id FROM {$_TABLES['ff_attachments']} WHERE topic_id=" . (int) $A['id']);
            while ($B = DB_fetchArray($q2)) {
                forum_delAttachment($B['id']);
            }
            PLG_itemDeleted($A['id'], 'forum');
        }
        DB_query("DELETE FROM {$_TABLES['ff_topic']} WHERE id=" . (int) $topic_id);
        DB_query("DELETE FROM {$_TABLES['ff_topic']} WHERE pid=" . (int) $topic_id);
        DB_query("DELETE FROM {$_TABLES['subscriptions']} WHERE (type='forum' AND id=" . (int) $topic_id . ")");
        $postCount = DB_Count($_TABLES['ff_topic'], 'forum', (int) $forum_id);
        $topicsQuery = DB_query("SELECT id FROM {$_TABLES['ff_topic']} WHERE forum=" . (int) $forum_id . " AND pid=0");
        $topicCount = DB_numRows($topicsQuery);
        DB_query("UPDATE {$_TABLES['ff_forums']} SET topic_count=" . (int) $topicCount . ",post_count=" . (int) $postCount . " WHERE forum_id=" . (int) $forum_id);
        // Remove any lastviewed records in the log so that the new updated topic indicator will appear
        DB_query("DELETE FROM {$_TABLES['ff_log']} WHERE topic=" . (int) $topicparent);
    } else {
        // Need to check for any attachments and delete if required
        $q1 = DB_query("SELECT id FROM {$_TABLES['ff_topic']} WHERE id=" . (int) $topic_id);
        while ($A = DB_fetchArray($q1)) {
            $q2 = DB_query("SELECT id FROM {$_TABLES['ff_attachments']} WHERE topic_id=" . (int) $A['id']);
            while ($B = DB_fetchArray($q2)) {
                forum_delAttachment($B['id']);
            }
        }
        DB_query("UPDATE {$_TABLES['ff_topic']} SET replies=replies-1 WHERE id=" . (int) $topicparent);
        DB_query("DELETE FROM {$_TABLES['ff_topic']} WHERE id=" . (int) $topic_id);
        $postCount = DB_Count($_TABLES['ff_topic'], 'forum', (int) $forum_id);
        DB_query("UPDATE {$_TABLES['ff_forums']} SET post_count=" . (int) $postCount . " WHERE forum_id=" . (int) $forum_id);
        $sql = "SELECT count(*) AS count FROM {$_TABLES['ff_topic']} topic left join {$_TABLES['ff_attachments']} att ON topic.id=att.topic_id WHERE (topic.id=" . (int) $topicparent . " OR topic.pid=" . (int) $topicparent . ") and att.filename <> ''";
        $result = DB_query($sql);
        if (DB_numRows($result) > 0) {
            list($attCount) = DB_fetchArray($result);
            DB_query("UPDATE {$_TABLES['ff_topic']} SET attachments=" . (int) $attCount . " WHERE id=" . (int) $topicparent);
        }
        PLG_itemDeleted($topic_id, 'forum');
    }
    if ($topicparent == 0) {
        $topicparent = $topic_id;
        gf_updateLastPost($forum_id);
    } else {
        gf_updateLastPost($forum_id, $topicparent);
    }
    CACHE_remove_instance('forumcb');
    if ($topicparent == $topic_id) {
        $link = $_CONF['site_url'] . '/forum/index.php?forum=' . $forum_id;
        $retval .= FF_statusMessage($LANG_GF02['msg55'], $link, $LANG_GF02['msg55'], true, $forum_id, true);
    } else {
        $link = $_CONF['site_url'] . '/forum/viewtopic.php?showtopic=' . $topicparent;
        $retval .= FF_statusMessage($LANG_GF02['msg55'], $link, $LANG_GF02['msg55'], true, $forum_id, true);
    }
    return $retval;
}

function MG_deleteMedia($media_id)
{
    global $_TABLES;
    $sql = "SELECT media_filename, media_mime_ext FROM {$_TABLES['mg_media']} " . "WHERE media_id='" . addslashes($media_id) . "'";
    $result = DB_query($sql);
    while (list($filename, $mime_ext) = DB_fetchArray($result)) {
        $orig = Media::getFilePath('orig', $filename, $mime_ext);
        @unlink($orig);
        $disp = Media::getFilePath('disp', $filename);
        @unlink($disp);
        $ext = pathinfo($disp, PATHINFO_EXTENSION);
        $tn = Media::getFilePath('tn', $filename, $ext);
        @unlink($tn);
        $types = array('0', '1', '2', '3', '10', '11', '12', '13');
        foreach ($types as $t) {
            $fpath = Media::getThumbPath($tn, $t);
            @unlink($fpath);
        }
        DB_delete($_TABLES['mg_media_albums'], 'media_id', addslashes($media_id));
        DB_delete($_TABLES['mg_media'], 'media_id', addslashes($media_id));
        DB_delete($_TABLES['comments'], 'sid', addslashes($media_id));
        DB_delete($_TABLES['mg_playback_options'], 'media_id', addslashes($media_id));
        PLG_itemDeleted($media_id, 'mediagallery');
    }
}

/**
 * Delete an existing static page
 *
 * @param   array   args    Contains all the data provided by the client
 * @param   string  &output OUTPUT parameter containing the returned text
 * @param   string  &svc_msg OUTPUT parameter containing any service messages
 * @return  int		    Response code as defined in lib-plugins.php
 */
function service_delete_staticpages($args, &$output, &$svc_msg)
{
    global $_CONF, $_TABLES, $_USER, $LANG_ACCESS, $LANG12, $LANG_STATIC;
    $output = COM_refresh($_CONF['site_admin_url'] . '/plugins/staticpages/index.php?msg=20');
    if (empty($args['sp_id']) && !empty($args['id'])) {
        $args['sp_id'] = $args['id'];
    }
    // Apply filters to the parameters passed by the webservice
    if ($args['gl_svc']) {
        $args['sp_id'] = COM_applyBasicFilter($args['sp_id']);
        $args['mode'] = COM_applyBasicFilter($args['mode']);
    }
    $sp_id = $args['sp_id'];
    if (!SEC_hasRights('staticpages.delete')) {
        $output = COM_siteHeader('menu', $LANG_STATIC['access_denied']);
        $output .= COM_startBlock($LANG_STATIC['access_denied'], '', COM_getBlockTemplate('_msg_block', 'header'));
        $output .= $LANG_STATIC['access_denied_msg'];
        $output .= COM_endBlock(COM_getBlockTemplate('_msg_block', 'footer'));
        $output .= COM_siteFooter();
        if ($_USER['uid'] > 1) {
            return PLG_RET_PERMISSION_DENIED;
        } else {
            return PLG_RET_AUTH_FAILED;
        }
    }
    // If a staticpage template, remove any use of the file
    if (DB_getItem($_TABLES['staticpage'], 'template_flag', "sp_id = '{$sp_id}'") == 1) {
        $sql = "UPDATE {$_TABLES['staticpage']} SET template_id = '' WHERE template_id = '{$sp_id}'";
        $result = DB_query($sql);
    }
    DB_delete($_TABLES['staticpage'], 'sp_id', $sp_id);
    DB_delete($_TABLES['comments'], array('sid', 'type'), array($sp_id, 'staticpages'));
    PLG_itemDeleted($sp_id, 'staticpages');
    return PLG_RET_OK;
}