1. Open Safari
2. Type Word in Google Search
3. Search For Word

Below is the blog I found this tip on, thanks!

http://iphoneindia.gyanin.com/2009/05/26/iphone-tricks-add-words-to-iphone-dictionary-disable-auto-correct-and-auto-capitalize/

AJAX Calls PHP Script On Your Domain -> PHP Script Fetches Content From Remote Domain -> PHP Script Returns The Remote Data Back To The AJAX Call

Below is a sample PHP script that I found and tweaked.

// Set your return content type
header('Content-type: text/html');

// Website url to open
$daurl = 'http://www.otherdomain.com/index.php?sku=' . $_GET["sku"];

// Get that website's content
$handle = fopen($daurl, "r");

// If there is something, read and return
if ($handle) {
    while (!feof($handle)) {
        $buffer = fgets($handle, 4096);
        echo $buffer;
    }
    fclose($handle);
}

Below is the AJAX call to load the content into a div using JQuery

$("#loadremotecontent").load('getprice.php?sku=322000');

The script could be further modified to pass in the entire URL as a parameter so it could be more generic. I would love to hear about other cross domain AJAX options if anyone has any other suggestions.

FlatPack is currently used in the Apache Camel project and Apache ActiveMQ just to name a couple.

For those not familiar with FlatPack, I have provided a couple quick examples below. Column names in the flat files can be bound via a header record in the file, or through an XML mapping.

Example of reading a delimited file

    	Parser parser = DefaultParserFactory.getInstance().newDelimitedParser(
                new FileReader("DataFile.txt"),  //txt file or String to parse. Can Take any Reader
                ',', //delimiter
                '"'); //text qualifier

        //obtain DataSet
        DataSet ds = parser.parse();

        while (ds.next()){ //loop through file
            ds.getString("mycolumnName");
        }

Example of reading a fixed width file

	    //Obtain the proper parser for your needs
        Parser parser = DefaultParserFactory.getInstance().newFixedLengthParser(
        		new FileReader("map.fpmap.xml"), //fixed with column map
                new FileReader("DataFile.txt"));  //txt file or String to parse.  Can take any Reader

        //obtain DataSet
        DataSet ds = parser.parse();

        while (ds.next()){ //loop through file
            ds.getString("mycolumnName");
        }

Please check out the FlatPack website for more examples and complete documentation, or download now from Sourceforge.

SELECT name, birth, CURDATE(),
(YEAR(CURDATE())-YEAR(birth))
- (RIGHT(CURDATE(),5)
AS age
FROM Bird;

I modified the query to get the average age.

SELECT avg((YEAR(CURDATE())-YEAR(birthday)) - (RIGHT(CURDATE(),5))) as averageAge
FROM user_info;

I also wanted to see the average age for each sex.

SELECT sex, avg((YEAR(CURDATE())-YEAR(birthday)) - (RIGHT(CURDATE(),5))) as averageAge
FROM user_info
group by sex

Then i wanted to see the percentage of male and female in the database.

SELECT sex, (100 * count(sex)/(
                    select count(sex) from user_info
           )) as percentSex
FROM user_info
group by sex

Also i wanted to see the percentages for a certain age group

// XX replace with age range you are looking for
SELECT (100 * count(birthday)/(
                   select count(birthday) from user_info
           )) as percentage
FROM user_info
where (YEAR(CURDATE())-YEAR(birthday)) - (RIGHT(CURDATE(),5))
between XX and XX

I wanted to see what percentages for male and female were for a certain age group.

// XX replace with age range you are looking for
SELECT sex, (100 * count(birthday)/(
           select count(birthday) from user_info where (YEAR(CURDATE())-YEAR(birthday)) - (RIGHT(CURDATE(),5))
between XX and XX
      )) as percentSex
FROM user_info
where (YEAR(CURDATE())-YEAR(birthday)) - (RIGHT(CURDATE(),5))
between XX and XX
group by sex

This data will be extremely helpful in my marketing and I was surprised by the results I found.

I decided to dive into the source code and tackle the problem on my own. Below are the details of how to implement this on your Virtuemart system should you have need.

The first thing I did was added a column to the shopper group table. This will flag the shopper group to have free shipping in the cart if you so desire.

/*You may have to alter the table name if your prefix does not start with jos_vm_ which is the default*/
ALTER TABLE `jos_vm_shopper_group` ADD COLUMN `shopper_group_freeshipping` TINYINT(1) UNSIGNED AFTER `default`;

There is on PHP file that must be edited. It is located in the following folder under your Joomla installation directory.
\administrator\components\com_virtuemart\classes\ps_checkout.php

At or around line 63 you will see the following if statement

if($vendor_freeshipping > 0 && $vars['order_subtotal_withtax'] >= $vendor_freeshipping) {

That line needs to be replaced with the following

		$db = new ps_DB();
		$q = 'SELECT shopper_group_freeshipping from #__{vm}_shopper_vendor_xref xref
			inner join #__{vm}_shopper_group shopper on xref.shopper_group_id = shopper.shopper_group_id
			where xref.user_id = ' . $_SESSION['auth']["user_id"];

		$db->query($q);
		$db->next_record();
		$free_shoppergroup_shipping = $db->f('shopper_group_freeshipping') == 1;
		//original line at 63
		if(($vendor_freeshipping > 0 && $vars['order_subtotal_withtax'] >= $vendor_freeshipping) || $free_shoppergroup_shipping) {

A little bit further down there is this if statement

if(empty($_REQUEST['ship_to_info_id']) && ps_checkout::noShipToNecessary()) {

$db = new ps_DB();

You can comment out or remove the $db = new ps_DB();. It is now already being instantiated due to our new code.

There is nothing else that needs to be changed. You will have to manually flag shopper groups in the db using the new shopper_group_freeshipping column that was added. This should have a value of 1 for any shopper groups that need to get free shipping. All other groups can have a value of NULL or 0 to get the standard shipping you have configured in your installation.

I will make another post if I tackle adding a checkbox on the shopper group to update this field. If anyone else does it please let me know and I will post your code or provide a link to your blog.

I was really bummed when I found out my version of ChrisControl did not work with Windows 7. I found out that have a new beta version that has worked great so far. If you do support, I strongly recommend this program. The beta version can be downloaded here.

	/*
		Provided by http://www.todayisearched.com
	*/
	class GeoIP {

		/*
			Returns all possible Geo Ip information in an associative array.  The following pieces of information
			are returned:
			IP - IP ADDRESS LOOKED UP
			CODE - COUNTRY CODE
			COUNTY - COUNTRY NAME
			FLAG - PATH TO IMAGE OF THE COUNTRY'S FLAG
			CITY - CITY NAME
			REGION - STATE NAME
			ISP - ISP NAME
			LAT - LATITUDE CORDINATE
			LNG - LONGITUDE CORDINATE

			USAGE:
			$ipinfo = GeoIP :: getGeoArray('xxx.xxx.xxx.xxx');
			echo $ipinfo['CITY'] . ', ' . $ipinfo['STATE'];
		*/
		public static function getGeoArray($ip) {
			$file = "http://www.ipgp.net/api/xml/". $ip;

			$xml_parser = xml_parser_create();
			$fp = fopen($file, "r");
			$data = fread($fp, 80000);
			xml_parse_into_struct($xml_parser, $data, $vals);
			$iplookup = array();
			foreach ($vals as $v) {
				if (isset($v['tag']) && isset($v['value'])) {
					$iplookup[$v['tag']] = $v['value'];
				}
			}
			xml_parser_free($xml_parser);
			fclose($fp);

			return $iplookup;
		}

		//shortcut to get the city name
		public static function getCity($ip) {
			$a =  self :: getGeoArray($ip);
			return $a['CITY'];
		}

		//shortcut to get the state name
		public static function getState($ip) {
			$a =  self :: getGeoArray($ip);
			return $a['REGION'];
		}

	}

Follow these steps to implement the above script:

1. Copy the script above and save it into a php file on your server
2. Add include_once(‘Path To The PHP File Saved On #1′);
3. Use the code snippet below in your php to obtain geoip information.

      include_once "geoip.php";
      $ipinfo = GeoIP :: getGeoArray($_SERVER['REMOTE_ADDR']);
      echo 'Hello, Your City And State Is ' . $ipinfo['CITY'] . ', ' . $ipinfo['REGION'];

Thanks http://www.ipgp.net for providing this invaluable service!

//before
$.getJSON(url, data, function(json){
                                //success code
                           });

//after
$.ajax({
  url: url,
  dataType: 'json',
  data: data,
  async: false,
  success: function(json){
                  //success code
               }
});

As you can see the shortcut code is well, shorter, but not as flexible as the basic ajax function. Shortcuts are nice but shouldn’t be leaned on for heavy lifting.

.ui-corner-all {
 -moz-border-radius: 4px/*{cornerRadius}*/;
 -webkit-border-radius: 4px/*{cornerRadius}*/;
}