WarpConduit Computing

Automatically Embedding Video Using Only the URL With the Help of oEmbed

by

One of my favorite functions of the WordPress editor is now the automatic embedding of video and other rich media by simply putting the URL on it’s own line. Really, it’s amazing!

Here is my rip of the WordPress code (found in the WP_Embed and WP_oEmbed classes) and assembled into a class named AutoEmbed. [Read more…]

Prevent Windows Update from Automatically Rebooting Your PC

by

In Windows Server 2008 and Windows 7 your computer may automatically install Window’s Updates and then restart.  Follow one of the methods below to disable this behavior.  These instructions are for computer experts only.

Method 1

  1. Run gpedit.msc
  2. Go to Local Computer Policy -> Computer Configuration -> Administrative Templates -> Windows Components -> Windows Update
  3. Double-click on “No auto-restart for scheduled Automatic Update installation”
  4. Enable it, click OK and close the Group Policy Editor
  5. Reboot

Method 2

If you don’t have gpedit.msc, use the following instructions.

  1. Run regedit.exe
  2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU
    Note: You will need to create the WindowsUpdate and AU keys if they are missing.
  3. Create a new 32-bit DWORD value inside of WindowsUpdate\AU and name it NoAutoRebootWithLoggedOnUsers
  4. Double-click on your newly created value and give it a value data of 1 (hexadecimal)
  5. Click OK and close Registry Editor

Automatic Category Images for OpenCart 1.4.9.3

by

The changes set forth below will cause OpenCart to assign a random product image from the category as the category image if one has not already been set. If the category contains no products, no_image.jpg will still display.

Make the following changes around line 112 of catalog/controller/product/category.php.

foreach ($results as $result) {
	if ($result['image']) {
		$image = $result['image'];
	} else {
/* START AUTOMATIC CATEGORY IMAGES */
      		$catimg = $this->model_catalog_product->getRandomProductImageByCategoryId($result['category_id']);
      		if($catimg){
      			$image = $catimg['image'];
      		}else{
      			$image = 'no_image.jpg';
      		}
/* END AUTOMATIC CATEGORY IMAGES */
	}
	
	$this->data['categories'][] = array(
		'name'  => $result['name'],
		'href'  => $this->model_tool_seo_url->rewrite(HTTP_SERVER . 'index.php?route=product/category&path=' . $this->request->get['path'] . '_' . $result['category_id'] . $url),
		'thumb' => $this->model_tool_image->resize($image, $this->config->get('config_image_category_width'), $this->config->get('config_image_category_height'))
	);
}

Add this function to catalog/model/catalog/product.php.

public function getRandomProductImageByCategoryId($category_id) {
	$sql = "SELECT p.image FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p.image != '' AND p.date_available <= NOW() AND p2c.category_id = '" . (int)$category_id . "' ORDER BY RAND() LIMIT 1";
			
	$query = $this->db->query($sql);
									  
	return $query->row;
}

That’s it, enjoy your automatically generated and random category images!