function getBlockView($sUri) { $aEntry = $this->_oDb->getEntries(array('sample_type' => 'uri', 'uri' => $sUri)); $sModuleUri = $this->_oConfig->getUri(); $oView = new BxDolViews($this->_oConfig->getViewsSystemName(), $aEntry['id']); $oView->makeView(); $this->_oTemplate->setPageTitle($aEntry['caption']); $GLOBALS['oTopMenu']->setCustomSubHeader($aEntry['caption']); $GLOBALS['oTopMenu']->setCustomBreadcrumbs(array(_t('_' . $sModuleUri . '_top_menu_item') => BX_DOL_URL_ROOT . $this->_oConfig->getBaseUri() . 'index/', $aEntry['caption'] => '')); return $this->_oTemplate->displayList(array('sample_type' => 'view', 'viewer_type' => $this->_oTextData->getViewerType(), 'uri' => $aEntry['uri'])); }
function clean_database() { $db_clean_vkiss = (int) getParam("db_clean_vkiss"); $db_clean_profiles = (int) getParam("db_clean_profiles"); $db_clean_msg = (int) getParam("db_clean_msg"); $db_clean_visits = (int) getParam("db_clean_members_visits"); $db_clean_banners_info = (int) getParam("db_clean_banners_info"); //clear from `sys_banners_shows` if (db_res("DELETE FROM `sys_banners_shows` WHERE `Date` < UNIX_TIMESTAMP( NOW() - INTERVAL {$db_clean_banners_info} DAY )")) { db_res("OPTIMIZE TABLE `sys_banners_shows`"); } //clear from `sys_banners_clicks` if (db_res("DELETE FROM `sys_banners_clicks` WHERE `Date` < UNIX_TIMESTAMP( NOW() - INTERVAL {$db_clean_banners_info} DAY )")) { db_res("OPTIMIZE TABLE `sys_banners_clicks`"); } // clear from `sys_messages` if (db_res("DELETE FROM `sys_messages` WHERE FIND_IN_SET('sender', `Trash`) AND FIND_IN_SET('recipient', `Trash`)")) { db_res("OPTIMIZE TABLE `sys_messages`"); } //clear from `sys_ip_members_visits` if (db_res("DELETE FROM `sys_ip_members_visits` WHERE `DateTime` < NOW() - INTERVAL {$db_clean_visits} DAY")) { db_res("OPTIMIZE TABLE `sys_ip_members_visits`"); } // clear ban table if (db_res("DELETE FROM `sys_admin_ban_list` WHERE `DateTime` + INTERVAL `Time` SECOND < NOW()")) { db_res("OPTIMIZE TABLE `sys_admin_ban_list`"); } // profile_delete if ($db_clean_profiles > 0) { $res = db_res("SELECT `ID` FROM `Profiles` WHERE (`DateLastNav` < NOW() - INTERVAL {$db_clean_profiles} DAY) AND (`Couple` > `ID` OR `Couple` = 0)"); if ($res) { $db_clean_profiles_num = mysql_num_rows($res); while ($arr = mysql_fetch_array($res)) { profile_delete($arr['ID']); } db_res("OPTIMIZE TABLE `Profiles`"); } } if ($db_clean_vkiss > 0) { $res = db_res("DELETE FROM `sys_greetings` WHERE `When` < NOW() - INTERVAL {$db_clean_vkiss} DAY"); if ($res) { $db_clean_vkiss_num = db_affected_rows(); db_res("OPTIMIZE TABLE `sys_greetings`"); } } if ($db_clean_msg > 0) { $res = db_res("DELETE FROM `sys_messages` WHERE `Date` < NOW() - INTERVAL {$db_clean_msg} DAY"); if ($res) { $db_clean_msg_num = db_affected_rows(); db_res("OPTIMIZE TABLE `sys_messages`"); } } //--- Clean sessions ---// bx_import('BxDolSession'); $oSession = BxDolSession::getInstance(); $iSessions = $oSession->oDb->deleteExpired(); // clean expired ip bans bx_import('BxDolAdminIpBlockList'); $oBxDolAdminIpBlockList = new BxDolAdminIpBlockList(); $iIps = $oBxDolAdminIpBlockList->deleteExpired(); // clean old views bx_import('BxDolViews'); $oBxViews = new BxDolViews('', 0); $iDeletedViews = $oBxViews->maintenance(); // clean old votes bx_import('BxDolVoting'); $oBxVotes = new BxDolVoting('', 0); $iDeletedVotes = $oBxVotes->maintenance(); echo "\n- Database cleaning -\n"; echo "Deleted profiles: {$db_clean_profiles_num}\n"; echo "Deleted virtual kisses: {$db_clean_vkiss_num}\n"; echo "Deleted messages: {$db_clean_msg_num}\n"; echo "Deleted sessions: {$iSessions}\n"; echo "Deleted records from ip block list: {$iIps}\n"; echo "Deleted views: {$iDeletedViews}\n"; echo "Deleted votes: {$iDeletedVotes}\n"; }
/** * SQL: Delete post by POSTed data * * @return MsgBox of result */ function ActionDeletePost($iPostID = 0) { if (!$this->bAdminMode) { $this->CheckLogged(); } if ($iPostID == 0) { $iPostID = (int) bx_get('DeletePostID'); } $iPostOwnerID = $this->_oDb->getPostOwnerByID($iPostID); if (!$this->isAllowedPostDelete($iPostOwnerID)) { return $this->_oTemplate->displayAccessDenied(); } if ($iPostID > 0) { $oCmts = new BxDolCmts($this->_oConfig->getCommentSystemName(), (int) $iPostID); $oCmts->onObjectDelete(); // delete votings bx_import('BxTemplVotingView'); $oVoting = new BxTemplVotingView($this->_oConfig->getRateSystemName(), $iPostID); $oVoting->deleteVotings($iPostID); $sFileName = $this->_oDb->getPostPhotoByID($iPostID); $sFilePathPost = 'big_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $sFilePathPost = 'small_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $sFilePathPost = 'orig_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $vSqlRes = $this->_oDb->deletePost($iPostID); $sRet = db_affected_rows() > 0 ? _t('_post_successfully_deleted') : _t('_failed_to_delete_post'); $this->isAllowedPostDelete($iPostOwnerID, true); // perform action //reparse tags bx_import('BxDolTags'); $oTags = new BxDolTags(); $oTags->reparseObjTags('blog', $iPostID); //reparse categories $oCategories = new BxDolCategories(); $oCategories->reparseObjTags('bx_blogs', $iPostID); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews($this->_oConfig->getViewSystemName(), $iPostID, false); $oViews->onObjectDelete(); //delete all subscriptions $oSubscription = BxDolSubscription::getInstance(); $oSubscription->unsubscribe(array('type' => 'object_id', 'unit' => 'bx_blogs', 'object_id' => $iPostID)); bx_import('BxDolAlerts'); $oZ = new BxDolAlerts('bx_blogs', 'delete_post', $iPostID, $iPostOwnerID); $oZ->alert(); return MsgBox($sRet); } else { return MsgBox(_t('_Error Occured')); } }
/** * Deleting Advertisement from `bx_ads_main` * * @param $iID ID of deleting Advertisement * @return Text presentation of result */ function ActionDeleteAdvertisement($iID) { $iDeleteAdvertisementID = (int) $iID; $iAdvOwner = $this->_oDb->getOwnerOfAd($iDeleteAdvertisementID); if (!$this->isAllowedDelete($iAdvOwner)) { return $this->_oTemplate->displayAccessDenied(); } if ($iDeleteAdvertisementID > 0) { $sSuccDel = _t("_bx_ads_Ad_succ_deleted"); $sFailDel = _t("_bx_ads_Ad_fail_delete"); $sRetHtml = ''; $sMediaIDs = $this->_oDb->getMediaOfAd($iDeleteAdvertisementID); if ($sMediaIDs != '') { $aChunks = explode(',', $sMediaIDs); foreach ($aChunks as $sMedId) { $iMedId = (int) $sMedId; if ($iMedId) { $sMediaFileName = $this->_oDb->getMediaFile($iMedId); if ($sMediaFileName != '') { @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'img_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'thumb_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'big_thumb_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'icon_' . $sMediaFileName); } $this->_oDb->deleteMedia($iMedId); } } } if ($this->_oDb->deleteAd($iDeleteAdvertisementID)) { $this->isAllowedDelete($iAdvOwner, true); // perform action $oCmts = new BxDolCmts('ads', $iDeleteAdvertisementID); $oCmts->onObjectDelete(); //reparse tags bx_import('BxDolTags'); $oTags = new BxDolTags(); $oTags->reparseObjTags('ad', $iDeleteAdvertisementID); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews('ads', $iDeleteAdvertisementID, false); $oViews->onObjectDelete(); // delete associated locations if (BxDolModule::getInstance('BxWmapModule')) { BxDolService::call('wmap', 'response_entry_delete', array($this->_oConfig->getUri(), $iDeleteAdvertisementID)); } //delete all subscriptions $oSubscription = BxDolSubscription::getInstance(); $oSubscription->unsubscribe(array('type' => 'object_id', 'unit' => 'ads', 'object_id' => $iDeleteAdvertisementID)); bx_import('BxDolAlerts'); $oZ = new BxDolAlerts('ads', 'delete', $iDeleteAdvertisementID, $iDeleteAdvertisementID); $oZ->alert(); $sRetHtml .= MsgBox(_t($sSuccDel)); } else { $sRetHtml .= MsgBox(_t($sFailDel)); } return $sRetHtml; } else { return MsgBox(_t('_Error Occured')); } }
function onSiteDeleted($iSiteId) { // delete associated tags and categories $this->reparseTags($iSiteId); $this->reparseCategories($iSiteId); // delete sites votings bx_import('BxDolVoting'); $oVotingProfile = new BxDolVoting('bx_sites', 0, 0); $oVotingProfile->deleteVotings($iSiteId); // delete sites comments bx_import('BxDolCmts'); $oCmts = new BxDolCmts('bx_sites', $iSiteId); $oCmts->onObjectDelete(); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews('bx_sites', $iSiteId, false); $oViews->onObjectDelete($iSiteId); //delete all subscriptions $oSubscription = BxDolSubscription::getInstance(); $oSubscription->unsubscribe(array('type' => 'object_id', 'unit' => 'bx_sites', 'object_id' => $iSiteId)); // arise alert bx_import('BxDolAlerts'); $oAlert = new BxDolAlerts('bx_sites', 'delete', $iSiteId, $this->iOwnerId); $oAlert->alert(); }
function onEventDeleted($iEntryId, $aDataEntry = array()) { // delete associated tags and categories $this->reparseTags($iEntryId); $this->reparseCategories($iEntryId); // delete votings bx_import('Voting', $this->_aModule); $sClass = $this->_aModule['class_prefix'] . 'Voting'; $oVoting = new $sClass($this->_sPrefix, 0, 0); $oVoting->deleteVotings($iEntryId); // delete comments bx_import('Cmts', $this->_aModule); $sClass = $this->_aModule['class_prefix'] . 'Cmts'; $oCmts = new $sClass($this->_sPrefix, $iEntryId); $oCmts->onObjectDelete(); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews($this->_sPrefix, $iEntryId, false); $oViews->onObjectDelete(); // delete forum $this->_oDb->deleteForum($iEntryId); // delete associated locations if (BxDolModule::getInstance('BxWmapModule')) { BxDolService::call('wmap', 'response_entry_delete', array($this->_oConfig->getUri(), $iEntryId)); } // delete all subscriptions $oSubscription = new BxDolSubscription(); $oSubscription->unsubscribe(array('type' => 'object_id', 'unit' => $this->_sPrefix, 'object_id' => $iEntryId)); // arise alert $oAlert = new BxDolAlerts($this->_sPrefix, 'delete', $iEntryId, $this->_iProfileId); $oAlert->alert(); }
/** * Deleting Advertisement from `bx_ads_main` * * @param $iID ID of deleting Advertisement * @return Text presentation of result */ function ActionDeleteAdvertisement($iID) { $iDeleteAdvertisementID = (int) $iID; $iAdvOwner = $this->_oDb->getOwnerOfAd($iDeleteAdvertisementID); if (!$this->isAllowedDelete($iAdvOwner)) { return $this->_oTemplate->displayAccessDenied(); } if ($iDeleteAdvertisementID > 0) { $sSuccDel = _t("_bx_ads_Ad_succ_deleted"); $sFailDel = _t("_bx_ads_Ad_fail_delete"); $sRetHtml = ''; $sMediaIDs = $this->_oDb->getMediaOfAd($iDeleteAdvertisementID); if ($sMediaIDs != '') { $aChunks = explode(',', $sMediaIDs); foreach ($aChunks as $sMedId) { $iMedId = (int) $sMedId; if ($iMedId) { $sMediaFileName = $this->_oDb->getMediaFile($iMedId); if ($sMediaFileName != '') { @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'img_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'thumb_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'big_thumb_' . $sMediaFileName); @unlink(BX_DIRECTORY_PATH_ROOT . $this->sUploadDir . 'icon_' . $sMediaFileName); } $this->_oDb->deleteMedia($iMedId); } } } if ($this->_oDb->deleteAd($iDeleteAdvertisementID)) { $this->isAllowedDelete($iAdvOwner, true); // perform action $oCmts = new BxDolCmts('ads', $iDeleteAdvertisementID); $oCmts->onObjectDelete(); //reparse tags bx_import('BxDolTags'); $oTags = new BxDolTags(); $oTags->reparseObjTags('ad', $iDeleteAdvertisementID); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews('ads', $iDeleteAdvertisementID, false); $oViews->onObjectDelete(); bx_import('BxDolAlerts'); $oZ = new BxDolAlerts('ads', 'delete', $iDeleteAdvertisementID, $iDeleteAdvertisementID); $oZ->alert(); $sRetHtml .= MsgBox(_t($sSuccDel)); } else { $sRetHtml .= MsgBox(_t($sFailDel)); } return $sRetHtml; } else { return MsgBox(_t('_Error Occured')); } }
function onEventDeleted($iEntryId, $aDataEntry = array()) { // delete associated tags and categories $this->reparseTags($iEntryId); $this->reparseCategories($iEntryId); // delete votings bx_import('Voting', $this->_aModule); $sClass = $this->_aModule['class_prefix'] . 'Voting'; $oVoting = new $sClass($this->_sPrefix, 0, 0); $oVoting->deleteVotings($iEntryId); // delete comments bx_import('Cmts', $this->_aModule); $sClass = $this->_aModule['class_prefix'] . 'Cmts'; $oCmts = new $sClass($this->_sPrefix, $iEntryId); $oCmts->onObjectDelete(); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews($this->_sPrefix, $iEntryId, false); $oViews->onObjectDelete(); // delete forum $this->_oDb->deleteForum($iEntryId); // arise alert $oAlert = new BxDolAlerts($this->_sPrefix, 'delete', $iEntryId, $this->_iProfileId); $oAlert->alert(); }
function onSiteDeleted($iSiteId) { // delete associated tags and categories $this->reparseTags($iSiteId); $this->reparseCategories($iSiteId); // delete sites votings bx_import('BxDolVoting'); $oVotingProfile = new BxDolVoting('bx_sites', 0, 0); $oVotingProfile->deleteVotings($iSiteId); // delete sites comments bx_import('BxDolCmts'); $oCmts = new BxDolCmts('bx_sites', $iSiteId); $oCmts->onObjectDelete(); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews('bx_sites', $iSiteId, false); $oViews->onObjectDelete($iSiteId); // arise alert bx_import('BxDolAlerts'); $oAlert = new BxDolAlerts('bx_sites', 'delete', $iSiteId, $this->iOwnerId); $oAlert->alert(); }
/** * SQL: Delete post by POSTed data * * @return MsgBox of result */ function ActionDeletePost($iPostID = 0) { $this->CheckLogged(); if ($iPostID == 0) { $iPostID = (int) bx_get('DeletePostID'); } $iPostOwnerID = $this->_oDb->getPostOwnerByID($iPostID); if (!$this->isAllowedPostDelete($iPostOwnerID)) { return $this->_oTemplate->displayAccessDenied(); } if ($iPostID > 0) { $oCmts = new BxDolCmts('blogposts', (int) $iPostID); $oCmts->onObjectDelete(); $sFileName = $this->_oDb->getPostPhotoByID($iPostID); $sFilePathPost = 'big_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $sFilePathPost = 'small_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $sFilePathPost = 'orig_' . $sFileName; if ($sFilePathPost != '' && file_exists(BX_BLOGS_IMAGES_PATH . $sFilePathPost) && is_file(BX_BLOGS_IMAGES_PATH . $sFilePathPost)) { @unlink(BX_BLOGS_IMAGES_PATH . $sFilePathPost); } $vSqlRes = $this->_oDb->deletePost($iPostID); $sRet = db_affected_rows() > 0 ? _t('_post_successfully_deleted') : _t('_failed_to_delete_post'); $this->isAllowedPostDelete($iPostOwnerID, true); // perform action //reparse tags bx_import('BxDolTags'); $oTags = new BxDolTags(); $oTags->reparseObjTags('blog', $iPostID); //reparse categories $oCategories = new BxDolCategories(); $oCategories->reparseObjTags('bx_blogs', $iPostID); // delete views bx_import('BxDolViews'); $oViews = new BxDolViews('blogposts', $iPostID, false); $oViews->onObjectDelete(); bx_import('BxDolAlerts'); $oZ = new BxDolAlerts('bx_blogs', 'delete_post', $iPostID, $iPostOwnerID); $oZ->alert(); return MsgBox($sRet); } else { return MsgBox(_t('_Error Occured')); } }