<?php

 function getInfos2( $atts ){
 ob_start();

	$url = 'https://docs.google.com/spreadsheet/pub?output=csv&key=0AuTcdwPgARlZdEpxOVpSdHhXb3NMS2ttSV9fRlJfcXc';
	$fgc = file_get_contents($url);

	$return = array();
	$lines  = explode(chr(0x0A), $fgc);
	$header = explode(',', $lines[0]);

	for($i = 1; $i < sizeof($lines); $i++)
	{
		$power = explode(',',  $lines[$i]);
		$id    = $power[0];

		for($j = 1; $j < sizeof($power); $j++)
			$return[$id][$header[$j]] = $power[$j];
	}

	return $return;
}

function getInfos()
{
	if((filemtime('cache/powerid.txt')) < time())
	{
		$ret = serialize(getInfos2($atts));
		file_put_contents('cache/powerid.txt', $ret);
		return $ret;
	}

	$file = trim(file_get_contents('cache/powerid.txt'));

	return $file;
}

$powers = unserialize(getInfos());
echo '<table border="0" align="center" class="datatable table  table-bordered table-hover">';
	echo "<thead>";
		echo "<tr>";
			echo "<th><center>Power Type</center></th>";
			echo "<th><center>Powers</center></th>";
		echo "</tr>";
    echo "</thead>";
    echo "<tbody>";
	$groupTypes = array('Everypower', 'Allpowers', 'Limited', 'Unlimited', 'Game/Gameban', 'Group', 'Epic');
    foreach($powers as $i=>$v) {
		foreach($groupTypes as $val) {
			if($v[$val] == 1) {
				$powerTypes[$val]['count']++;
			}
		}
	}
	foreach($powerTypes as $k=>$v) {
		echo "<tr><td><center><b>".$k."</b></center></td>";
		echo "<td><center><b>".number_format($v['count'])."</b></center></td>";
		echo "</tr>";


	}
	echo "</tbody>";
echo "</table>";

echo '<table border="0" align="center" id="datatable" class="datatable table table-bordered table-hover">';
echo "<thead>";
echo "<tr>";
echo "<th><center>Power ID</center></th>";
echo "<th><center>Allpowers</center></th>";
echo "<th><center>Smilie</center></th>";
echo "<th><center>Name</center></th>";
echo "<th><center>Status</center></th>";
echo "<th><center>Category</center></th>";
echo "<th><center>Store value xats/days</center></th>";
echo "    </tr>";
echo "    </thead>";
echo "    <tbody> ";
foreach($powers as $i=>$v)
{

	$smilie = strtolower($powers[$i]['Power Name']);
	$img = ((strlen($smilie) > 0) == true) ? '<img title="'.$smilie.'" alt="'.$smilie.'" src="http://xat.com/images/smw/'.$smilie.'.png">' : '' ;
		if(strtolower(trim($powers[$i]['Status'])) == "limited") {
		echo "<tr style=\"background-color:#C8EDFF\">";

	}
	else {

		if(strtolower(trim($powers[$i]['Category/Type'])) == "group power") {
		echo "<tr style=\"background-color:#FAC0BF\">";

		}
	else {


		echo '<tr>';
	}}

	echo '<td><center><a href="/powers?id='.$i.'" target="_blank"><B>'.$i.'</b></center></td>';
	echo (empty($powers[$i]['Allpowers'])) ? "<td><center></center></td>" : "<td><center><img title='Allpowers' src='http://xat.com/images/apicon.png' /> <B>Allpowers</b></center></td>";
	$smilie = strtolower($powers[$i]['Power Name']);
	echo '<td><center><a href="http://util.xat.com/wiki/index.php?title='.$smilie.'" target="_blank">'.$img.'</center></td>';
	echo '<td><b><center>'.$powers[$i]['Power Name']."</center></b></td>";
	echo "<td><b><center>".$powers[$i]['Status']."</center></b></td>";
	echo "<td><b><center>".$powers[$i]['Type']."</center></b></td>";
	echo "<td><b><center>".$powers[$i]['Store value xats/days']."</center></b></td>";

	echo '</tr>';
 }
	echo '</table>';
	?>
    <link rel="stylesheet" type="text/css" href="js/datatables/jquery.dataTables.css">
	<script src="js/datatables/jquery-1.8.2.min.js"></script>
	<script src="js/datatables/jquery.dataTables.min.js"></script>
	<script>
	$(document).ready(function(){;
	$('#datatable').dataTable();
	});
	</script>