All pastes #757109 Raw Edit

Mine

public php v1 · immutable
#757109 ·published 2007-10-31 23:56 UTC
rendered paste body
  public function delete($iId)  {    $this->_connect();    $oDb = $this->getSource();    $oDb->commit();        try    {      $oDb->setWhere('blog_owner = ' . (int)$iId);      $rData = $oDb->dbSelect('blogs', array('blog_id'));            if(!is_array($aData = $oDb->fetch(1, $rData))        return null;            $iBlog = $aData['blog_id'];      $oDb->clear();            $oDb->setWhere('user_id = ' . (int)$iId);      $oDb->dbDelete('users');      $oDb->clear();      $oDb->setWhere('settings_blog = ' . (int)$iBlog);      $oDb->dbDelete('blogs_settings');      $oDb->clear();      $oDb->setWhere('style_blog = ' . (int)$iBlog);      $oDb->dbDelete('blogs_styles');      $oDb->clear();      $oDb->setWhere('note_blog = ' . (int)$iBlog);      $oDb->dbDelete('notes');      $oDb->clear();      $oDb->setWhere('page_blog = ' . (int)$iBlog);      $oDb->dbDelete('pages');      $oDb->clear();      $oDb->setWhere('comment_blog = ' . (int)$iBlog);      $oDb->dbDelete('comments');      $oDb->clear();      $oDb->setWhere('link_blog = ' . (int)$iBlog);      $oDb->dbDelete('links');      $oDb->clear();      $oDb->setWhere('category_blog = ' . (int)$iBlog);      $oDb->dbDelete('categories');      $oDb->clear();      $oDb->setWhere('tag_blog = ' . (int)$iBlog);      $oDb->dbDelete('tags');      $oDb->clear();      $oDb->setWhere('priv_owner = ' . (int)$iBlog . ' OR priv_sender = ' . (int)$iBlog);      $oDb->dbDelete('priv');      $oDb->clear();    }    catch(Exception $oE)    {      $oDb->abort();      return false;    }        return true;  }