Google Docs into Wordpress - Midacad

Page Code

[one_third][crews_points] First third of content - Pull Crew Points from Google Doc [/one_third]

PHP Code from Shortcode UI

$gsRSSArray = array(SimplePieWP('https://spreadsheets.google.com/feeds/list/0AjmAOGsTcBETdDlGUEVqbzVndGtUTzlVMDhDQnUzM3c/od6/public/basic?min-row=2&min-col=9&max-row=6&max-col=10', array('enable_order_by_date' => false)));
unset ($RSSParseString);
foreach ($gsRSSArray as $key=>$value) { $RSSParseString = $value; }
$RSSParseArray = explode('<br />', $RSSParseString);
foreach ($RSSParseArray as $key=>$value)
{
switch($key) {
case 1:
$tmp = trim(substr($value,strlen("$"),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewHuron'] = $tmp;
unset($tmp);
break;
case 2:
$tmp = trim(substr($value,strlen("$"),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewOntario'] = $tmp;
unset($tmp);
break;
case 3:
$tmp = trim(substr($value,strlen("$"),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewSuperior'] = $tmp;
unset($tmp);
break;
case 4:
$tmp = trim(substr($value,strlen("$"),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewMichigan'] = $tmp;
unset($tmp);
break;
case 5:
$tmp = trim(substr($value,strlen("$"),strlen($value)));
$tmp = number_format((float)$tmp);
$_SESSION['crewErie'] = $tmp;
unset($tmp);
break;
}
}
echo "{$_SESSION['crewHuron']} <br />";
echo "{$_SESSION['crewOntario']} <br />";
echo "{$_SESSION['crewSuperior']} <br />";
echo "{$_SESSION['crewMichigan']} <br />";
echo "{$_SESSION['crewErie']} <br />";