/** * @static * @todo document this */ function deleteOneMember($memberid) { global $manager; $memberid = intval($memberid); $mem = MEMBER::createFromID($memberid); if (!$mem->canBeDeleted()) { return _ERROR_DELETEMEMBER; } $manager->notify('PreDeleteMember', array('member' => &$mem)); /* unlink comments from memberid */ if ($memberid) { $query = 'UPDATE ' . sql_table('comment') . ' SET cmember="0", cuser="******" WHERE cmember=' . $memberid; sql_query($query); } $query = 'DELETE FROM ' . sql_table('member') . ' WHERE mnumber=' . $memberid; sql_query($query); $query = 'DELETE FROM ' . sql_table('team') . ' WHERE tmember=' . $memberid; sql_query($query); $query = 'DELETE FROM ' . sql_table('activation') . ' WHERE vmember=' . $memberid; sql_query($query); // delete all associated plugin options NucleusPlugin::_deleteOptionValues('member', $memberid); $manager->notify('PostDeleteMember', array('member' => &$mem)); return ''; }
/** * Deletes an item */ function delete($itemid) { global $manager, $member; $itemid = intval($itemid); // check to ensure only those allow to alter the item can // proceed if (!$member->canAlterItem($itemid)) { return 1; } $manager->notify('PreDeleteItem', array('itemid' => $itemid)); // delete item $query = 'DELETE FROM ' . sql_table('item') . ' WHERE inumber=' . $itemid; sql_query($query); // delete the comments associated with the item $query = 'DELETE FROM ' . sql_table('comment') . ' WHERE citem=' . $itemid; sql_query($query); // delete all associated plugin options NucleusPlugin::_deleteOptionValues('item', $itemid); $manager->notify('PostDeleteItem', array('itemid' => $itemid)); return 0; }