14.09.2014, 11:55
Hello I was trying to make dynamic player signatures using this tutorial: https://sampforum.blast.hk/showthread.php?tid=301435
I have a bug that the image is not showing. I am using the script here: link removed don't think it is necessary.
Here are the scripts:
signature2.php
signature.php
Please tell me whats wrong?
EDIT: I got something like `Username` , `pKills`,etc in the script.
What is (`) here? I tried it but it doesn't works either.
I have a bug that the image is not showing. I am using the script here: link removed don't think it is necessary.
Here are the scripts:
signature2.php
pawn Код:
<html>
<head>
<title>My title here</title>
</head>
<h1>Signature configuration.</h1>
<p>Hello, welcome to the image configuration page.<br />
Before you can make your signature, we need your in-game name, exact as it is.</p>
<form action="signature.php" method="get"> <!-- When you click the "send" button, this information will be send to the "signature.php" page. If you're using another php page, you need to change "signature.php" to the file you called it. -->
Playername: <input type="text" name="player_name"><br> <!-- This is a little text box which will ask for you playername. -->
<input type="Submit"> <!-- A "send" button. -->
</form>
</body>
</html>
pawn Код:
<?
$player_name=$_GET['player_name']; // This gets the player his name from the previous page.
/* Let's start by configuring your mysql details. */
$username="******"; //Your MySQL Username.
$password="******"; // Your MySQL Pass.
$database="******"; // Your MySQL database.
$host="******"; // Your MySQL host. This is "localhost" or the IP specified by your hosting company.
/* Next, we will make a connection to the mysql.
If it can't connect, it'll print on the screen: Unable to select database. Be sure the databasename exists and online is. */
mysql_connect($host,$username,$password); // Connection to the database.
@mysql_select_db($database) or die( "Unable to select database. Be sure the databasename exists and online is.");
/* To protect MySQL injection. */
$player_name = stripslashes($player_name);
$player_name = mysql_real_escape_string($player_name);
$query="SELECT * FROM users WHERE Username ='$player_name'"; // Gets all the information about the player.
$result=mysql_query($query);
$i=mysql_num_rows($result); // Here we are counting how many rows this result gives us.
/* We will now put the player's information into variables so we can use them more easily. */
/* DON'T FORGET: The names should be exact the same as in your mysql db.*/
if ($i != 0) // If the user has been correct, then it'll give us 1 row. If its 1 row, then it'll proceed with the code.
{
$Playername=mysql_result($result,0,"Username"); // Gets the username of the player and put it in the variable $Playername.
$Money=mysql_result($result,0,"pMoney"); // Gets the money of the player and put it in the variable $Money.
$Score=mysql_result($result,0,"pKills"); // Gets the score of the player and put it in the variable $Score.
header('Content-Type: png;'); // Don't touch this. We use this to tell the script we're working with an image.
$im = @imagecreatefrompng('playersign.png') or die("Cannot select the correct image. Please contact the webmaster."); // Don't forget to put your picture there. Eg: playersig.png
$text_color = imagecolorallocate($im, 197,197,199); // RED, GREEN, BLUE --> Go to http://www.colorpicker.com, select a nice color, copy the R/G/B letters provided by colorpicker and put them here.
$text_username = "$Playername"; // This gets the information: player name to be showed in the picture.
$text_score = "$Score"; // Same as above but with score.
$text_money = "$Money"; // Same as above but with money.
$font = "Action.ttf" /* USAGE OF THE imagettftext: First ($im) shouldn't be changed. (16) is the text-size. (0) is the angle of your text. Change it, and you'll see what's going on. (20) is de X-coordinate of the text.
(36) is the Y-coordinate of the text. */
imagettftext($im, 16, 0, 0, 0, $text_color, $font, $text_username); // Prints the username in the picture.
imagettftext($im, 16, 0, 1, 1, $text_color, $font, $text_score); // Prints the score in the picture.
imagettftext($im, 16, 0, 2, 2, $text_color, $font, $text_money); // Prints the money in the picture.
imagepng($im);
imagedestroy($im);
} else echo('Username is not in our database. Please try again.'); // If the username doesn't exist (so the row is 0) then it'll give en error.
mysql_close();
?>
EDIT: I got something like `Username` , `pKills`,etc in the script.
pawn Код:
format(Query, sizeof(Query), "SELECT * FROM `users` WHERE `Username` = '%s'", escpname);
