public static function addTreeItemAfterByParentSID($field_sid, $parent_sid, $tree_item_value, $after_tree_item_sid)
{
$parent_level = SJB_ListingFieldTreeManager::getTreeItemLevelBySID($parent_sid);
$level = $parent_level + 1;
$after_order = SJB_DB::queryValue("SELECT `order` FROM listing_field_tree WHERE field_sid = ?n AND parent_sid = ?n AND sid = ?n", $field_sid, $parent_sid, $after_tree_item_sid);
$after_order = empty($after_order) ? 0 : $after_order;
$new_order = $after_order + 1;
SJB_DB::query("UPDATE listing_field_tree SET `order` = `order` + 1 WHERE parent_sid = ?n AND `order` > ?n", $parent_sid, $after_order);
return SJB_DB::query("INSERT INTO listing_field_tree SET field_sid = ?n, parent_sid = ?n, level = ?n, caption = ?s, `order` = ?n", $field_sid, $parent_sid, $level, $tree_item_value, $new_order);
}
