<?php
class Rarufu_Example_donation
{
	public static function getHtml()
	{

/*the function that converts the Steam Id*/
    function convert_id($id,$s){
        return (string)bcadd((string)(intval($id)*2+intval($s)),"76561197960265728");
    }
/* © Rarufu */
/*Database connection login*/
$servername = "server.sc3network.com";
$username = "donationwidget";
$password = "YH6arXNezMzcq3Jw";
$dbname = "donations";


/*Connection to database
This allows the script to connect to the database */
$conn = new mysqli($servername, $username, $password, $dbname);
/* Checks if the connection is working, if not closes it down */
if ($conn->connect_error) {
	die("Connection failed" . $conn->connect_error);
}
/*Gets last 5 donations for the database */
$sql = "SELECT * FROM gmd_donations ORDER BY ID DESC LIMIT 5";
$result  = $conn->query($sql);
/*Check if data was actually pulled from database */
if (!$result) {
	echo "Failed to get data from database";
}
 /* Creating HTML table */
 echo "<table><tr><th></th><th align='center'></th><th align='center' width='60px'></th></tr>";
 /* Putting data in table */
 while($row = $result->fetch_assoc())
 {
/* Getting Date */
	/*$d=strtotime("now");
              $date = $row['Date'];
              if($d - $date < 7)
              {
                  $dateEcho = date('D',$date);
              }
              else{
                  $dateEcho = date('m-d',$date);
              }
              */
	/* Getting SteamID */
	$array=preg_split('#:#',$row['SteamID']);
	$id = convert_id($array[2],$array[1]);
	$link = file_get_contents("http://api.steampowered.com/ISteamUser/GetPlayerSummaries/v0002/?key=key&steamids='$id'%20&format=json");
	$myarray = json_decode($link, true);
	$steamName = $myarray['response']['players'][0]['personaname'];
	$steamLink = $myarray['response']['players'][0]['profileurl'];
	$steamPicture = $myarray['response']['players'][0]['avatar'];
	/*Put it all in the table */
	echo "<tr><td><a href=".$steamLink."><img src='".$steamPicture." width='32px' height = '32px'></a></td> <td align='center'><a href=".$steamLink.">".$steamName."</a></td><td align='left' width='60px'><b>&pound;".$row["Amount"]."</b></td></tr>";
 }
  echo "</table>";
 $conn->close();
	}
}
?>