[vQmod] - 1.4.x - 2.3.x Show Random products for modules

3antz wrote:Hi Q, thanks for the free mod. Is there a way to only show products which are available in stock?

3antz wrote:Hi Q, thanks for the free mod. Is there a way to only show products which are available in stock?

$results = $this->model_catalog_product->getProducts($data);
		// randomise latest - from
		// http://forum.opencart.com/viewtopic.php?f=131&t=32570&start=20
		srand((float)microtime() * 1000000);
		shuffle($results); 
		$results = array_slice($results, 0, $setting['limit']);
		//
		
		foreach ($results as $result) {
		  // here
		  if ($result['quantity'] > 0) {
		  // end here
			if ($result['image']) {
				$image = $this->model_tool_image->resize($result['image'], $setting['image_width'], $setting['image_height']);
			} else {
				$image = false;
			}
						
			// blaa blaa blaa code deleted
			
			$this->data['products'][] = array(
				'product_id' => $result['product_id'],
				// blaa blaa blaa code deleted
				'href'    	 => $this->url->link('product/product', 'product_id=' . $result['product_id']),
			);
		  // here
		 }
		  // end here
		}

		if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/latest.tpl')) {
		// blaa blaa blaa code deleted

Qphoria wrote:Created vqmods for random latest, featured, bestsellers, and specials using the new no-strain method

What does "no-strain" mean?
Normally items are randomized by using the "rand()" mysql command. The problem with this is that the more products you have, the more items that must be randomized on the database. If you have a lot of products, it puts a large strain on the database having to randomize them all first, then only grabbing 10 of them.

So this mod uses a better method. It will pull more than the limit set and randomize them with php which is much faster and less intensive. Then return only the limit requested. Removing strain from the database.

Qphoria wrote:Created vqmods for random latest, featured, bestsellers, and specials using the new no-strain method

What does "no-strain" mean?
Normally items are randomized by using the "rand()" mysql command. The problem with this is that the more products you have, the more items that must be randomized on the database. If you have a lot of products, it puts a large strain on the database having to randomize them all first, then only grabbing 10 of them.

So this mod uses a better method. It will pull more than the limit set and randomize them with php which is much faster and less intensive. Then return only the limit requested. Removing strain from the database.

Goncharenko wrote:Can anyone confirm this works with the latest version?