function GetByID($ID) { global $DB; $ID = IntVal($ID); if (CSaleLocation::isLocationProMigrated()) { $strSql = "SELECT V.ID, V.USER_PROPS_ID, V.ORDER_PROPS_ID, V.NAME, " . CSaleOrderPropsValue::getPropertyValueFieldSelectSql('V') . ", P.TYPE " . "FROM b_sale_user_props_value V " . "INNER JOIN b_sale_order_props P ON (V.ORDER_PROPS_ID = P.ID) " . CSaleOrderPropsValue::getLocationTableJoinSql('V') . "WHERE V.ID = " . $ID . ""; } else { $strSql = "SELECT * " . "FROM b_sale_user_props_value " . "WHERE ID = " . $ID . ""; } $db_res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); if ($res = $db_res->Fetch()) { return $res; } return False; }