Use random product image for category image when not set

Code: Select all

if ($category_info['image']) {
				$image = $category_info['image'];
			} else {
				$image = '';
			}

Code: Select all

if ($category_info['image']) {
				$image = $category_info['image'];
			} else {
				$image = '';
				// Use random image from products in the category
				$rndImgQry = "SELECT p.image AS image FROM product AS p JOIN product_to_category AS c ON p.product_id = c.product_id "
						. "WHERE c.category_id = " . $category_info['category_id'] . " AND p.image NOT LIKE 'no_image.jpg'";
				$rndImgRslt = mysql_query($rndImgQry) or die (mysql_error());
				if (mysql_num_rows($rndImgRslt) > 0)
				{
					$imgRows = array();
					while($imgRow = mysql_fetch_array($rndImgRslt))
					{
						$imgRows[] = $imgRow['image'];
					}
					$image = $imgRows[array_rand($imgRows)];
				}
			}

Code: Select all

if ($result['image']) {
						$image = $result['image'];
					} else {
						$image = 'no_image.jpg';
					}

Code: Select all

if ($result['image']) {
						$image = $result['image'];
					} else {
						$image = 'no_image.jpg';
						// Use random image from products in the category
						$rndImgQry = "SELECT p.image AS image FROM product AS p JOIN product_to_category AS c ON p.product_id = c.product_id "
						       		. "WHERE c.category_id = " . $result['category_id'] . " AND p.image NOT LIKE 'no_image.jpg'";
						$rndImgRslt = mysql_query($rndImgQry) or die (mysql_error());
						if (mysql_num_rows($rndImgRslt) > 0)
						{
							$imgRows = array();
							while($imgRow = mysql_fetch_array($rndImgRslt))
							{
								$imgRows[] = $imgRow['image'];
							}
							$image = $imgRows[array_rand($imgRows)];
						}
					}

Code: Select all

if ($category_info['image']) {
				$data['thumb'] = $this->model_tool_image->resize($category_info['image'], $this->config->get($this->config->get('config_theme') . '_image_category_width'), $this->config->get($this->config->get('config_theme') . '_image_category_height'));
			} else {
				$data['thumb'] = '';
			}
			

Code: Select all

if ($category_info['image']) {
				$image = $category_info['image'];
			} else {
				$image = '';
				// Use random image from products in the category
				$rndImgQry = "SELECT p.image AS image FROM " . DB_PREFIX . "product AS p JOIN " . DB_PREFIX . "product_to_category AS c ON p.product_id = c.product_id "
						. "WHERE c.category_id = " . $category_info['category_id'] . " AND p.image NOT LIKE 'no_image.jpg'";
						
				$rndImgRslt = $this->db->query($rndImgQry);
				
				if ($rndImgRslt->num_rows)
				{
					$imgRows = array();
					
					foreach ($rndImgRslt->rows as $imgRow)
					{
						$imgRows[] = html_entity_decode($imgRow['image'], ENT_QUOTES, 'UTF-8');
					}
					
					$image = $imgRows[array_rand($imgRows)];
				}
			}

Code: Select all

if ($result['image']) {
					$image = $this->model_tool_image->resize($result['image'], $this->config->get($this->config->get('config_theme') . '_image_product_width'), $this->config->get($this->config->get('config_theme') . '_image_product_height'));
				} else {
					$image = $this->model_tool_image->resize('placeholder.png', $this->config->get($this->config->get('config_theme') . '_image_product_width'), $this->config->get($this->config->get('config_theme') . '_image_product_height'));
				}
					

Code: Select all

if ($result['image']) {
						$image = $result['image'];
					} else {
						$image = 'no_image.jpg';
						// Use random image from products in the category
						$rndImgQry = "SELECT p.image AS image FROM " . DB_PREFIX . "product AS p JOIN " . DB_PREFIX . "product_to_category AS c ON p.product_id = c.product_id "
						       		. "WHERE c.category_id = " . $result['category_id'] . " AND p.image NOT LIKE 'no_image.jpg'";
									
						$rndImgRslt = $this->db->query($rndImgQry);
						
						if ($rndImgRslt->num_rows)
						{
							$imgRows = array();
							
							foreach ($rndImgRslt->rows as $imgRow)
							{
								$imgRows[] = html_entity_decode($imgRow['image'], ENT_QUOTES, 'UTF-8');
							}
							
							$image = $imgRows[array_rand($imgRows)];
						}
					}