Collections

AK 47 Assault Rifle, Collections

AK 47 Assault Rifle

The AK 47 Assault Rifle has been produced in greater numbers than any other equivalent weapon in the world. The 3rd Battalion of The Royal Regiment of Fusiliers seized this one during the First Gulf War in 1990.

You may also be interested in

'0' OR p.stockaction = 'show') GROUP BY p.productid ORDER BY p.name LIMIT " . $related_products . ""; $result_related = $db->query($sql_related); $col = 1; while ($row_related = $result_related->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_related['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_related['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_related['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; echo '
' // echo ''."\n"; if($col == 3) $col = 1; else $col++; $related_prods .= '\'' . $row_related['productid'] . '\','; } if (strlen($related_prods) > 0) { $related_prods .= 'END'; $related_prods = str_replace(',END','',$related_prods); $related_sql = "AND p.productid NOT IN (" . $related_prods . ")"; } $leftover_related = $related_products - $result_related->size(); if ($leftover_related > 0) { $sql_leftover = "SELECT p.name,p.seoname, p.productid, p.description FROM products p JOIN stock s ON s.productid = p.productid WHERE p.productid != '" . mysql_real_escape_string($row_product['productid']) . "' " . mysql_real_escape_string($related_sql) . " AND p.status = 'live' AND s.status = 'live' AND (s.stock > '0' OR p.stockaction = 'show') AND s.price > 0 GROUP BY p.productid ORDER BY RAND() LIMIT 6"; $result_leftover = $db->query($sql_leftover); while ($row_leftover = $result_leftover->fetch()) { $sql_category = "SELECT c.parent AS parent1, c2.parent AS parent2 FROM productcategories pc JOIN categories c ON pc.categoryid = c.categoryid LEFT JOIN categories c2 ON c2.categoryid = c.parent WHERE pc.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "'"; $result_category = $db->query($sql_category); $row_category = $result_category->fetch(); if ($row_category['parent2'] == 0) { $parents = $row_category['parent1'] . '/'; } else { $parents = $row_category['parent1'] . '/' . $row_category['parent2'] . '/'; } $sql_image = "SELECT pi.filename FROM productimages pi WHERE pi.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' ORDER BY pi.order LIMIT 1"; $result_image = $db->query($sql_image); if ($result_image->size() == 0) { $filename = 'no_image.jpg'; } else { $row_image = $result_image->fetch(); $filename = $row_image['filename']; } $sql_prices = "SELECT *, r.fldPrice AS reducedTo FROM stock s LEFT JOIN ( SELECT * FROM reductions WHERE ( fldDateStart IS NULL OR fldDateStart <= NOW() ) AND ( fldDateEnd IS NULL OR fldDateEnd >= NOW() ) ) AS r ON r.fldProductID = s.productid WHERE s.productid = '" . mysql_real_escape_string($row_leftover['productid']) . "' AND s.status = 'live' ORDER BY s.price"; $result_prices = $db->query($sql_prices); $row_prices = $result_prices->fetch(); $price = $row_prices['price']; $reducedPrice = $row_prices['reducedTo']; // Figure out image size for markup $tmpImagePath = 'http://'.$serverName.'/product_images/image_resize.php?image='.urlencode($filename).'&max_width=85&max_height=125'; $tmpImageData = getimagesize($tmpImagePath); if(is_null($reducedPrice)) $priceDisplay = '£'.number_format(round($price,2),2); else $priceDisplay = 'was £'.number_format(round($price,2),2).'
now £'.number_format(round($reducedPrice,2),2).''; if(!empty($row_leftover['description'])){ $description = $row_leftover['description']; } else { $description = "No description set"; } echo '
' .'Image preview of '.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'' .'
' .'

'.htmlentities($row_leftover['name'], ENT_QUOTES, 'UTF-8').'

'."\n" .'

'.substr(strip_tags($description), 0, 40).'...

' .'
' .'
'."\n"; $col++; } } // Slightly messy markup but we need to pad the columns out for this design to work if($col > 1) { while($col < 4) { echo '
 
'; $col++; } } ?>

Secure online shopping

You can pay online with these credit and debit cards:

Visa, Mastercard, Switch, Solo, Maestro • Thawte SSL Security

Terms & Conditions | Contact | Site Map

The Fusilier Museum is a Registered Charity (Registered in England No. 206186), Tel: 01494 601 300

eCommerce development leeds by newmediaboutique

*/ ?>