public static function deletePollBySID($sid) { if (SJB_ObjectDBManager::deleteObjectInfoFromDB('polls', $sid)) { SJB_DB::query('DELETE FROM `polls_field_list` WHERE `field_sid` = ?n', $sid); SJB_DB::query('DELETE FROM `polls_results` WHERE `poll_sid` = ?n', $sid); } }
public static function deleteQuestionBySID($sid) { $info = self::getFieldInfoBySID($sid); if (!strcasecmp("list", $info['type']) || !strcasecmp("boolean", $info['type']) || !strcasecmp("multilist", $info['type'])) { SJB_DB::query("DELETE FROM questions_field_list WHERE field_sid = ?n" . $sid); } return parent::deleteObjectInfoFromDB("questions", $sid); }
public static function deleteUserById($id) { SJB_DB::query('UPDATE `users` SET `parent_sid` = 0 WHERE `parent_sid` = ?n', $id); SJB_DB::query('UPDATE `listings` SET `subuser_sid` = 0 WHERE `subuser_sid` = ?n', $id); $user = SJB_UserManager::getObjectBySID($id); SJB_Statistics::addStatistics('deleteUser', $user->getUserGroupSID(), $user->getSID()); return parent::deleteObjectInfoFromDB('users', $id); }
public static function deleteAlphabetBySID($ABSsid) { return SJB_ObjectDBManager::deleteObjectInfoFromDB("alphabet", $ABSsid); }
public static function deleteCurrencyBySID($currency_sid) { return parent::deleteObjectInfoFromDB('currency', $currency_sid); }
public static function deleteUserProfileFieldInfo($user_profile_field_sid) { $field_info = SJB_UserProfileFieldDBManager::getUserProfileFieldInfoBySID($user_profile_field_sid); if (!strcasecmp("list", $field_info['type'])) { SJB_DB::query("DELETE FROM user_profile_field_list WHERE field_sid = ?n" . $user_profile_field_sid); } elseif (!strcasecmp('location', $field_info['type'])) { SJB_DB::query('DELETE FROM user_profile_fields WHERE parent_sid = ?n', $user_profile_field_sid); } if (parent::deleteObjectInfoFromDB('user_profile_fields', $user_profile_field_sid)) { $result = SJB_DB::query("SELECT * FROM `user_profile_fields` WHERE `id` = ?s", $field_info['id']); if (count($result) == 0) { if (!strcasecmp('location', $field_info['type'])) { parent::deleteField('users', $field_info['id'] . "_Country"); parent::deleteField('users', $field_info['id'] . "_State"); parent::deleteField('users', $field_info['id'] . "_City"); parent::deleteField('users', $field_info['id'] . "_ZipCode"); } return parent::deleteField('users', $field_info['id']); } else { SJB_DB::query("UPDATE users SET `{$field_info['id']}` = null WHERE `user_group_sid` = ?n", $field_info['user_group_sid']); } } return false; }
/** * @static * @param int $templateSID * @return array|bool|int */ public static function deleteEmailTemplateBySID($templateSID) { $emailTemplate = SJB_EmailTemplateEditor::getEmailTemplateBySID($templateSID); if (!empty($emailTemplate)) { $userDefined = $emailTemplate->getPropertyValue('user_defined'); if ($userDefined) { // delete atachment $fileProp = $emailTemplate->getProperty('file'); if ($fileProp) { SJB_UploadFileManager::deleteUploadedFileByID($fileProp->value); } return SJB_ObjectDBManager::deleteObjectInfoFromDB('email_templates', $templateSID); } } return false; }
public static function deleteObject($db_table_name, $object_sid) { return SJB_ObjectDBManager::deleteObjectInfoFromDB($db_table_name, $object_sid); }
public static function deleteListingTypeBySID($listing_type_sid) { return parent::deleteObjectInfoFromDB("listing_types", $listing_type_sid); }
public static function deleteArticleBySID($articleSid) { parent::deleteObjectInfoFromDB('news', $articleSid); }
public static function deleteQuestionnaireBySID($sid) { SJB_ObjectDBManager::deleteObjectInfoFromDB('screening_questionnaires', $sid); SJB_ScreeningQuestionnairesFieldManager::deleteQuestionsByParentSID($sid); SJB_DB::query("UPDATE `listings` SET `screening_questionnaire`='' WHERE `screening_questionnaire`=?n", $sid); }
public static function deleteComplexListingFieldBySID($listing_field_info) { if (!strcasecmp('list', $listing_field_info->field_type)) { SJB_DB::query('DELETE FROM listing_field_list WHERE field_sid = ?n' . $listing_field_info->sid); } elseif (!strcasecmp('tree', $listing_field_info->field_type)) { SJB_DB::query('DELETE FROM listing_field_tree WHERE field_sid = ?n', $listing_field_info->sid); } return parent::deleteObjectInfoFromDB('listing_complex_fields', $listing_field_info->sid); }
public static function deleteProductBySID($productSID) { SJB_ShoppingCart::deleteItemsFromCartByProductSID($productSID); return SJB_ObjectDBManager::deleteObjectInfoFromDB('products', $productSID); }
public static function deleteSubAdminById($id) { return parent::deleteObjectInfoFromDB('subadmins', $id); }
public static function deleteUserGroupInfo($user_group_sid) { return parent::deleteObjectInfoFromDB('user_groups', $user_group_sid); }
public static function deleteListingBySID($listing_sid) { $listing = SJB_ListingManager::getObjectBySID($listing_sid); if (parent::deleteObjectInfoFromDB('listings', $listing_sid)) { SJB_Statistics::addStatistics('deleteListing', $listing->getListingTypeSID(), $listing->getSID()); } }