<?
/*
    Credits
    - Nordoz - Original Script
    - pds2k12 - Editing & fixing the script.
*/

$username = "root"; //Your MySQL Username.
$password = ""; // Your MySQL Pass.
$database = "samp"; // Your MySQL database.
$host = "127.0.0.1"; // Your MySQL host.

$player_name = $_GET[ 'Ime' ];

mysql_connect($host, $username, $password); // Connection to the database. on this line

@mysql_select_db($database) or die("ERROR: Sorry, We can't connect on your database, please re check if you entered the right information."); 

/* To protect MySQL injection. */
$player_name = stripslashes($player_name);
$player_name = mysql_real_escape_string($player_name);



$query = "SELECT * FROM `samp` WHERE Ime = '$player_name'";  
$result = mysql_query( $query );
$i = mysql_num_rows( $result ); 

if ($i == 1) 
{

    // Creating of the .png image.
    header('Content-Type: image/png;');
    $im = @imagecreatefrompng('header.png') or die("ERROR: Cannot select the correct image. Please contact the webmaster."); 
   
   //Creating the colour.
    $text_color = imagecolorallocate($im, 0, 0, 0);//color black
    
    //Creating the font.
    $font = 'font.ttf'; 

    $GetPlayerName = mysql_result($result, 0, "Ime"); // Gets the username of the player and put it in the variable $Playername.
    $GetPlayerMoney = mysql_result($result, 0, "Novac"); // Gets the money of the player and put it in the variable $Money.
    $GetPlayerScore = mysql_result($result, 0, "Level"); // Gets the score of the player and put it in the variable $Score.

    $print_username = "Ime: $GetPlayerName"; 
    $print_score = "Novac: $GetPlayerMoney";
    $print_money = "Level: $GetPlayerScore";

    imagettftext($im, 9, 0, 20, 30, $text_color, $font, $print_username); //Prints the username of the specific player.
    imagettftext($im, 9, 0, 20, 40, $text_color, $font, $print_score);  //Prints the money of the specific player.
    imagettftext($im, 9, 0, 20, 50, $text_color, $font, $print_money); //Prints the score of the specific player.
    imagepng($im);
    imagedestroy($im);
} 
else echo('ERROR: Sorry, We can not find your account in our database.');

mysql_close();

?>