/**
* @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;
}
