[QUICK] help please in mysql signature. - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [QUICK] help please in mysql signature. (/showthread.php?tid=470771)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [QUICK] help please in mysql signature. (/showthread.php?tid=470771)
[QUICK] help please in mysql signature. - Champ - 19.10.2013
I am getting this problem.
its a dynamic players stats generator.
Please help quick.
Thank You.
Re: [QUICK] help please in mysql signature. - Patrick - 19.10.2013
Show us your php code? Probaly something wrong in it.
Re: [QUICK] help please in mysql signature. - Champ - 19.10.2013
here's the code
PHP код:
// Creating of the .png image.
header('Content-Type: image/png;'); // Don't touch this. We use this to tell the script we're working with an image.
$im = @imagecreatefrompng('mypicture.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 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 = 'myfont.ttf'; //Upload your custom font to the directory where this file is placed. Then change the name here.
/* 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, 20, 36, $text_color, $font, $text_username); // Prints the username in the picture.
imagettftext($im, 16, 0, 72, 69, $text_color, $font, $text_score); // Prints the score in the picture.
imagettftext($im, 16, 0, 72, 99, $text_color, $font, $text_money); // Prints the money in the picture.
imagepng($im);
imagedestroy($im);
Re: [QUICK] help please in mysql signature. - Patrick - 19.10.2013
Are you sure that the picture is named mypicture.png?
Re: [QUICK] help please in mysql signature. - Champ - 19.10.2013
yes :/
Re: [QUICK] help please in mysql signature. - Champ - 19.10.2013
i used this tutorial
https://sampforum.blast.hk/showthread.php?tid=301435
please can anybody help?
Re: [QUICK] help please in mysql signature. - -Prodigy- - 19.10.2013
Remove the quotes in your variables.
Re: [QUICK] help please in mysql signature. - Champ - 19.10.2013
no change
Re: [QUICK] help please in mysql signature. - -Prodigy- - 19.10.2013
PHP код:
// Creating of the .png image.
header("content-Type: image/png"); // Don't touch this. We use this to tell the script we're working with an image.
$im = @imagecreatefrompng("mypicture.png"); // Don't forget to put your picture there. Eg: playersig.png
$text_color = imagecolorallocate($im, 197,197,199); // RED, GREEN, BLUE --> Go to 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 = "myfont.ttf"; //Upload your custom font to the directory where this file is placed. Then change the name here.
/* 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, 20, 36, $text_color, $font, $text_username); // Prints the username in the picture.
imagettftext($im, 16, 0, 72, 69, $text_color, $font, $text_score); // Prints the score in the picture.
imagettftext($im, 16, 0, 72, 99, $text_color, $font, $text_money); // Prints the money in the picture.
imagepng($im);
imagedestroy($im);
1. Are you sure you have the image in the same directory as this script?
2. How are you fetching the variables? (Playername, Score, Money)
3. Are you sure you have the font in the same directory as this script?
Re: [QUICK] help please in mysql signature. - Champ - 19.10.2013
check the script
PHP код:
$player_name=$_GET['player_name']; // This gets the player his name from the previous page.
/* 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."); //Selection of the database. If it can't read the database, it'll give an error.
/* To protect MySQL injection. */
$player_name = stripslashes($player_name);
$player_name = mysql_real_escape_string($player_name);
$query="SELECT * FROM accounts WHERE Name='$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 == 1) // If the user has been correct, then it'll give us 1 row. If its 1 row, then it'll proceed with the code.
{
$Name=mysql_result($result,0,"Name"); // Gets the username of the player and put it in the variable $Playername.
$Money=mysql_result($result,0,"Money"); // Gets the money of the player and put it in the variable $Money.
$Score=mysql_result($result,0,"Score"); // Gets the score of the player and put it in the variable $Score.