Delivery cost depending on categories

foreach($dbrates as $k => $rate) {
			if($rate->shipping_type == $this->name && empty($rate->shipping_published)) {
				$rate->shipping_price=500;
				$rates[] = $rate;
			}

$shipping_key = sha1(serialize($order_clone).serialize($rates));
	if($app->getUserState(HIKASHOP_COMPONENT.'.shipping.'.$shipping_key.'.key',false)){

$use_cache = $config->get('use_shipping_cache', true);

$use_cache = $config->get('use_shipping_cache', true);
$use_cache = false;

/* START Harry Delivery*/
	$session =& JFactory::getSession(); $session_id=$session->getID();
    $link = mysql_connect("localhost", "bduser", "bdpass") or die("Could not connect : " . mysql_error());
	mysql_query ("SET CHARACTER SET 'utf8'", $link);
	mysql_select_db("dbname") or die("Could not select database");
    $query = 'SELECT DISTINCT tyr72_hikashop_category.category_name, tyr72_hikashop_category.min_sum, tyr72_hikashop_category.price_delivery FROM tyr72_hikashop_product, ((tyr72_hikashop_cart INNER JOIN tyr72_hikashop_cart_product ON tyr72_hikashop_cart.cart_id = tyr72_hikashop_cart_product.cart_id) INNER JOIN tyr72_hikashop_product_category ON tyr72_hikashop_cart_product.product_id = tyr72_hikashop_product_category.product_id) INNER JOIN tyr72_hikashop_category ON tyr72_hikashop_product_category.category_id = tyr72_hikashop_category.category_id WHERE (((tyr72_hikashop_cart.session_id)="'.$session_id.'"));';
    $result = mysql_query($query) or die("Query failed : " . mysql_error());
	
	$query2 = 'SELECT Sum(tyr72_hikashop_cart_product.cart_product_quantity*tyr72_hikashop_price.price_value) AS PRZ, tyr72_hikashop_category.min_sum, tyr72_hikashop_category.category_name, tyr72_hikashop_category.free_delivery, tyr72_hikashop_category.price_delivery
	FROM tyr72_hikashop_cart INNER JOIN (((tyr72_hikashop_cart_product INNER JOIN tyr72_hikashop_price ON tyr72_hikashop_cart_product.product_id = tyr72_hikashop_price.price_product_id) INNER JOIN tyr72_hikashop_product_category ON tyr72_hikashop_cart_product.product_id = tyr72_hikashop_product_category.product_id) INNER JOIN tyr72_hikashop_category ON tyr72_hikashop_product_category.category_id = tyr72_hikashop_category.category_id) ON tyr72_hikashop_cart.cart_id = tyr72_hikashop_cart_product.cart_id
	WHERE (((tyr72_hikashop_cart.session_id)="'.$session_id.'"))
	GROUP BY tyr72_hikashop_category.min_sum, tyr72_hikashop_category.category_id, tyr72_hikashop_category.category_name;';
	$result2 = mysql_query($query2) or die("Query failed : " . mysql_error());

	$col2_sum = 0;

	while ($row = mysql_fetch_array($result2, MYSQL_ASSOC))	{
		if (($row['free_delivery'] <= $row['PRZ']) AND ($row['free_delivery'] <> 0))
			{$col2_sum-= $row['price_delivery'];}
		}
		
		while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {$col2_sum += $line['price_delivery'];}
		mysql_free_result($result);
		mysql_free_result($result2);
		mysql_close($link);
/* END Harry Delivery*/

$rates = array();
		foreach($dbrates as $k => $rate) {
			if($rate->shipping_type == $this->name && !empty($rate->shipping_published)) {
				$rate->shipping_price+=$col2_sum; //harry edit
				$rates[] = $rate;
			}
		}