$stringfromfile = file('.git/HEAD', FILE_USE_INCLUDE_PATH);
$stringfromfile = $stringfromfile[0]; //get the string from the array
$explodedstring = explode("/", $stringfromfile); //separate out by the "/" in the string
$branchname = trim($explodedstring[2]); //get the one that is always the branch name
 
// ** MySQL settings - You can get this info from your web host ** //
if($branchname == "master")
{
	/** The name of the database for WordPress */
	define('DB_NAME', 'wordpress_local');
}
else
{
	define('DB_NAME', 'wordpress_new');
}

add_action('wp', 'ajax_autocomplete_search', 1000);
 
function ajax_autocomplete_search() {
	if(isset($_GET['q']) && isset($_GET['ajax']) && $_GET['ajax'] == "true" && !empty($_GET['q']))
	{
		$q = $_GET['q'];
		shopp('catalog','search-products',"load=true&search=$q");
 
		if(shopp('category','has-products'))
		{
			global $Shopp;
			$filter_cat = $_GET['category'];
 
			$results = array();
			$count = 0;
			$used_products = array();
 
			while(shopp('category','products'))
			{
				if($count == 3) continue;
 
				$product_id = shopp('product','id','return=true');
 
				shopp('catalog','product',"id=$product_id&load=true");
				require(TEMPLATEPATH.'/name-vars.php');
 
				if(!in_array($first_name, $used_products))
				{
					$used_products[] = $first_name;
 
					ob_start();
					shopp('product', 'coverimage', 'width=60&height=60');
					$image_tag = ob_get_clean();
 
					$summary = shopp('product','summary','return=true');
					$slug = shopp('product','slug','return=true');
 
					if(strlen($summary) > 90)
					{
						$summary = substr($summary,0,strpos($summary,' ',90))."…";
					}
					else
					{
						$summary = $summary;
					}
 
					if(shopp('product','in-category',"name=$filter_cat") || (!isset($filter_cat) || $filter_cat == "Everything"))
					{
						$results[] = array('name' => $first_name, 'summary' => $summary, 'image' => $image_tag, 'slug' => $slug);
					}
					$count++;
				}
			}
 
			if(count($Shopp->Category->products) > 3 && count($results) == 3)
			{
				$results[] = array('name' => 'footer', 'summary' => 'See All Search Results', 'search' => $_GET['s'], 'category' => $_GET['category']);
			}
 
			if(count($results) > 0)
			{
				echo json_encode($results);
			}
		}
		die;
	}
}

jQuery("#category-dropdown").change(function() {
				jQuery('input.search').marcoPolo({
				  url: '/?wp-minify-off=1&category=' + jQuery("#category-dropdown").val() + '&x=0&y=0&ajax=true',
				  param: 'q',
				  formatItem: function (data, $item) {
				  	if(data.name != "footer")
				  	{
				   		return '<h2>' + data.name + '</h2>' + data.image + '<p>' + data.summary + '</p>';
				   	}
				   	else
				   	{
				   		$item.addClass('footer');
				   		return data.summary;
				   	}
				  },
				  onSelect: function (data, $item) {
				  	if(data.name != "footer")
				  	{
				    	window.location = '/shop/' + data.slug;
				    }
				    else
				    {
				    	window.location = '/?s=' + data.search + '&category=' + data.category + '&catalog=true';
				    }
				  },
				  formatNoResults: function (q, $item) {
				  	$item.addClass("mp_selectable");
				  	$item.click(function() {
				  		window.location = '/?s=' + q + '&category=Everything&catalog=true';
				  	});
				  	return '<em>No results for <strong>' + q + '</strong> in ' + jQuery("#category-dropdown").val() + '.<br /><br /> Try your search again in Everything?</em>';
				  }
				});
			});
 
			jQuery("#category-dropdown").change();

if(isset($_GET['s']) && isset($_GET['catalog']))
{
	include_once('category-search.php');
}
else
{
	include_once('category-default.php');
}

<?php
if(isset($_GET['category']))
{
	$category = $_GET['category'];
}
?>
<?php if (shopp('category','has-products')): ?>
	<?php while(shopp('category','products')): ?>
	 	<?php if(shopp('product','in-category',"name=$category") || (!isset($category) || $category == "Everything")): ?>
		// your code to display in your own html using the product tags (model it after the default category template, for example)
 
		<?php endif; ?>
	<?php endwhile; ?>

			<form id="search" action="<?php bloginfo('url'); ?>" method="get" accept-charset="utf-8">
				<div class="search-perimeter">
					<input autocomplete="off" class="search" type="text" name="s" value="" id="find" />
					<select size=1 name="category" id="category-dropdown" title="Search in">
						<option value="Category 1 Name">Category 1 Name</option>
						<option value="Category 2 Name">Category 2 Name</option>
						<option value="Everything">Everything</option>
					</select>
					<input type="image" class="search-button" src="<?php bloginfo( 'template_url' ); ?>/images/search.png" />
				</div>
				<input type="hidden" name="catalog" value="true" id="catalog" />
			</form>

add_filter('wp_mail', 'html_email_prep');
 
function html_email_prep($email) {
	if(strpos($email['headers'], "html") != false )
	{
		$message = $email['message'];
 
		//Grab CSS block
		require_once TEMPLATEPATH.'/css_to_inline_styles.php';
 
		$cssConverter = new CSSToInlineStyles();
		$cssConverter->setCleanup(true);
		$cssConverter->setHTML($message);
		$cssConverter->setUseInlineStylesBlock(true);
 
		$new_html = $cssConverter->convert();
 
		$email['message'] = $new_html;
	}
 
	return $email;
}

<?php
//Adjust to point to root from where this script is located
require '../wp-load.php';
 
//Edit this path
$path = '/var/www/vhosts/domain/httpdocs/wp-content/uploads/shopp';
 
// END EDITS. You shouldn't have to edit below this line.
 
header("Content-Type: text/plain");
ini_set("auto_detect_line_endings", 1);
$dir_handle = opendir($path);
$row = 1;
$csv_data = array();
while (false !== ($file = readdir($dir_handle)))
{
	if ($file != "." && $file != "..")
	{
		$width_regex = '/((?<=width\";i:)[0-9]{1,4})|((?<=width=\")[0-9]{1,4})/';
		$height_regex = '/((?<=height\";i:)[0-9]{1,4})|((?<=height=\")[0-9]{1,4})/';
		$query = "select value from wp_shopp_meta where value LIKE '%"".$file.""%'";
		$info = getimagesize($path."/".$file);
 
		$existing_properties = $wpdb->get_var($query);
 
		if(strlen($existing_properties) > 10)
		{
			$new_width = $info[0];
			$new_height = $info[1];
 
			preg_match($width_regex, $existing_properties, $old_width);
			preg_match($height_regex, $existing_properties, $old_height);
 
 
			if(($new_width != $old_width[0] || $new_height != $old_height[0]) && !(empty($old_width[0]) || empty($old_height[0])))
			{
				echo "Updating $file. Old width/height: ".$old_width[0]."/".$old_height[0]." New width/height: $new_width/$new_height";
 
				$new_properties = preg_replace($width_regex, $new_width, $existing_properties);
				$new_properties = preg_replace($height_regex, $new_height, $new_properties);
 
				if(strlen($new_properties) > 10)
				{
					$query_update = "update wp_shopp_meta set value = '".mysql_real_escape_string($new_properties)."' where value LIKE '%"".$file.""%'";
 
					//echo "Query update: ".$query_update."n";
 
					$update = $wpdb->query($query_update);
 
					if($update == 0)
					{
						echo " --- FAILED. No rows changed. Didn't update.n";
					}
					else if($update > 1)
					{
						echo " --- POSSIBLE FAILURE. Updated too many rows.($update)n";
					}
					else
					{
						echo " --- SUCCESSn";
					}
				}
				else
				{
					echo "--- FAILED. New properties string suspiciously short.";
				}
			}
		}
	}
}
?>

<?php
// Copyright 2011, Clifton H. Griffin II
// This script is DESTRUCTIVE.  It will delete all images in your database!
// Run at your own risk. It is provided with NO WARRANTY WHATSOEVER.
// Please read carefully and do a full backup before using!
// Test with Shopp 1.0.14
 
//EDIT THIS LINE (this directory must be writeable)
$path = "/var/www/vhosts/domain.com/httpdocs/wp-content/uploads/shopp";
 
//Load WP data objects
require 'wp-load.php';
 
//Get list of rows from shopp
$sql    = "SELECT id FROM wp_shopp_asset";
$results = $wpdb->get_results($sql, "ARRAY_A");
 
//Loop through them, grabbing images
foreach ($results as $row)
{
	$id = $row['id'];
	$therow = $wpdb->get_row("SELECT name, data FROM wp_shopp_asset WHERE id = $id", "ARRAY_A");
	$image = $therow["data"];
	$name = $therow["name"];
 
	echo "File name: ".$path."$name <br />";
	$file = fopen($path."$name","w");
	fwrite($file, $image);
	fclose($file);
 
	//Clear image from DB
	$wpdb->query("UPDATE wp_shopp_asset SET data = null WHERE id = $id");
}
//Optimize the table to clear unused space
$wpdb->query("OPTIMIZE TABLE wp_shopp_asset");
?>