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; }
public static function deleteListingFieldBySID($listing_field_sid) { $listing_field_info = SJB_ListingFieldDBManager::getListingFieldInfoBySID($listing_field_sid); if (!strcasecmp('list', $listing_field_info['type'])) { SJB_DB::query('DELETE FROM listing_field_list WHERE field_sid = ?n' . $listing_field_sid); } elseif (!strcasecmp('tree', $listing_field_info['type'])) { SJB_DB::query('DELETE FROM listing_field_tree WHERE field_sid = ?n', $listing_field_sid); } elseif (!strcasecmp('location', $listing_field_info['type'])) { SJB_DB::query('DELETE FROM listing_fields WHERE parent_sid = ?n', $listing_field_sid); } elseif (!strcasecmp('monetary', $listing_field_info['type'])) { SJB_DB::query("ALTER TABLE `listings` DROP `?w`", $listing_field_info['id'] . "_parameter"); } if (parent::deleteObjectInfoFromDB('listing_fields', $listing_field_sid)) { if (!strcasecmp('location', $listing_field_info['type'])) { parent::deleteField('listings', $listing_field_info['id'] . "_Country"); parent::deleteField('listings', $listing_field_info['id'] . "_State"); parent::deleteField('listings', $listing_field_info['id'] . "_City"); parent::deleteField('listings', $listing_field_info['id'] . "_ZipCode"); } return parent::deleteField('listings', $listing_field_info['id']); } return false; }