connect();
/**
Parse GET elements
**/
$REQUESTED_metal = preg_replace(array('/[^A-Za-z]/'), array(''), $_GET['metal']);
$REQUESTED_graph_width = preg_replace(array('/[^0-9]/'), array(''), $_GET['graph_width']);
$REQUESTED_graph_height = preg_replace(array('/[^0-9]/'), array(''), $_GET['graph_height']);
$REQUESTED_color_dark = preg_replace(array('/[^A-Za-z0-9]/'), array(''), $_GET['color_dark']);
$REQUESTED_color_light = preg_replace(array('/[^A-Za-z0-9]/'), array(''), $_GET['color_light']);
$REQUESTED_color_graph = preg_replace(array('/[^A-Za-z0-9]/'), array(''), $_GET['color_graph']);
/**
Graph settings init
**/
$source_url = 'http://goldiraguide.org/widget/';
$metal = ($REQUESTED_metal) ? $REQUESTED_metal:'gold';
$graph_width = ($REQUESTED_graph_width && $REQUESTED_graph_width <= 1000) ? $REQUESTED_graph_width : 250;
$graph_image_width = $graph_width - 10;
$graph_height = ($REQUESTED_graph_height) ? $REQUESTED_graph_height : 160;
$graph_size = "{$graph_image_width}x{$graph_height}";
$dark = ($REQUESTED_color_dark) ? '#' . $REQUESTED_color_dark : '#6B5E5E';
$light = ($REQUESTED_color_light) ? '#' . $REQUESTED_color_light : '#EDE7DA';
$graph_color = ($REQUESTED_color_graph) ? '#' . $REQUESTED_color_graph : '#EDE7DA';
$graph_color = substr($graph_color, 1);
/**
Time calculators (to know what to select)
**/
$from_now_month = time() - (60 * 60 * 24 * 31);
$from_now_quarter = time() - (60 * 60 * 24 * 121);
$from_now_halfyear = time() - (60 * 60 * 24 * 182);
$from_now_year = time() - (60 * 60 * 24 * 365);
$from_now_2year = time() - (60 * 60 * 24 * 2 * 365);
/**
###########################
ONE MONTH AGO
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' AND `scan_time` >= {$from_now_month} ORDER BY `scan_time` ASC";
$results = $db->fetch_array($sql);
$min = 99999999;
$max = 0;
$chart_data = array();
$chart_time = array();
$i = 0;
$allowed_dates = array(
count($results) - 1,
round(count($results) / 2),
0
);
if(count($results) == 0) {
die('');
}
foreach ($results as $prz)
{
$electronic_price = str_replace(",", "", $prz['electronic_price']);
if ($electronic_price < $min)
{
$min = $electronic_price;
}
if ($electronic_price > $max)
{
$max = $electronic_price;
}
$chart_data[] = $electronic_price;
if (in_array($i, $allowed_dates))
{
$chart_time[] = date('j M', $prz['scan_time']);
}
$i++;
}
$FNM_min = $min - 1;
$FNM_max = $max + 1;
$FNM_med = ($min + $max) / 2;
$FNM_chd = implode(",", $chart_data);
$FNM_chxt = implode("|", $chart_time);
/**
###########################
ONE QUARTER AGO
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' AND `scan_time` >= {$from_now_quarter} ORDER BY `scan_time` ASC";
$results = $db->fetch_array($sql);
$min = 99999999;
$max = 0;
$chart_data = array();
$chart_time = array();
$i = 0;
$allowed_dates = array(
count($results) - 1,
round(count($results) / 2),
0
);
if(count($results) > 50) {
$has_fnq = 1;
}
foreach ($results as $prz)
{
$electronic_price = str_replace(",", "", $prz['electronic_price']);
if ($electronic_price < $min)
{
$min = $electronic_price;
}
if ($electronic_price > $max)
{
$max = $electronic_price;
}
$chart_data[] = $electronic_price;
if (in_array($i, $allowed_dates))
{
$chart_time[] = date('j M', $prz['scan_time']);
}
$i++;
}
$FNQ_min = $min - 1;
$FNQ_max = $max + 1;
$FNQ_med = ($min + $max) / 2;
$FNQ_chd = implode(",", $chart_data);
$FNQ_chxt = implode("|", $chart_time);
/**
###########################
HALF YEAR AGO
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' AND `scan_time` >= {$from_now_halfyear} ORDER BY `scan_time` ASC";
$results = $db->fetch_array($sql);
$min = 99999999;
$max = 0;
$chart_data = array();
$chart_time = array();
$i = 0;
$allowed_dates = array(
count($results) - 1,
round(count($results) / 2),
0
);
if(count($results) > 100) {
$has_fnhy = 1;
}
foreach ($results as $prz)
{
$electronic_price = str_replace(",", "", $prz['electronic_price']);
if ($electronic_price < $min)
{
$min = $electronic_price;
}
if ($electronic_price > $max)
{
$max = $electronic_price;
}
$chart_data[] = $electronic_price;
if (in_array($i, $allowed_dates))
{
$chart_time[] = date('j M', $prz['scan_time']);
}
$i++;
}
$FNHY_min = $min - 1;
$FNHY_max = $max + 1;
$FNHY_med = ($min + $max) / 2;
$FNHY_chd = implode(",", $chart_data);
$FNHY_chxt = implode("|", $chart_time);
/**
###########################
ONE YEAR AGO
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' AND `scan_time` >= {$from_now_year} ORDER BY `scan_time` ASC";
$results = $db->fetch_array($sql);
$min = 99999999;
$max = 0;
$chart_data = array();
$chart_time = array();
$i = 0;
$allowed_dates = array(
count($results) - 1,
round(count($results) / 2),
0
);
if(count($results) > 200) {
$has_fny = 1;
}
foreach ($results as $id => $prz)
{
if ($id % 2 == 0 && !in_array($i, $allowed_dates))
{
$i++;
continue;
}
$electronic_price = str_replace(",", "", $prz['electronic_price']);
if ($electronic_price < $min)
{
$min = $electronic_price;
}
if ($electronic_price > $max)
{
$max = $electronic_price;
}
$chart_data[] = $electronic_price;
if (in_array($i, $allowed_dates))
{
$chart_time[] = date('j M Y', $prz['scan_time']);
}
$i++;
}
$FNY_min = $min - 1;
$FNY_max = $max + 1;
$FNY_med = ($min + $max) / 2;
$FNY_chd = implode(",", $chart_data);
$FNY_chxt = implode("|", $chart_time);
/**
###########################
TWO YEARS AGO
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' AND `scan_time` >= {$from_now_2year} ORDER BY `scan_time` ASC";
$results = $db->fetch_array($sql);
$min = 99999999;
$max = 0;
$chart_data = array();
$chart_time = array();
$i = 0;
$allowed_dates = array(
count($results) - 1,
round(count($results) / 2),
0
);
if(count($results) > 400) {
$has_fn2y = 1;
}
foreach ($results as $id => $prz)
{
if ($id % 2 == 0 && !in_array($i, $allowed_dates))
{
$i++;
continue;
}
$electronic_price = str_replace(",", "", $prz['electronic_price']);
if ($electronic_price < $min)
{
$min = $electronic_price;
}
if ($electronic_price > $max)
{
$max = $electronic_price;
}
$chart_data[] = $electronic_price;
if (in_array($i, $allowed_dates))
{
$chart_time[] = date('j M Y', $prz['scan_time']);
}
$i++;
}
$FN2Y_min = $min - 1;
$FN2Y_max = $max + 1;
$FN2Y_med = ($min + $max) / 2;
$FN2Y_chd = implode(",", $chart_data);
$FN2Y_chxt = implode("|", $chart_time);
/**
###########################
LATEST GOLD PRICE
###########################
**/
$sql = "SELECT * FROM `commodities_history` WHERE `metal_name` = '{$metal}' ORDER BY `scan_time` DESC";
$today_gold = $db->query_first($sql);
?>
px; padding: 5px 0px 0px 20px; font-size: 11px;">
Add widget to your site
*/
?>