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;
}
