php signature

[MEGAMIND]

sup everyone how can we create a signature like thijns code
i have tried this but gives me errors when i solve thos errors then the image displays but with no text or kills etc..

Code Select Expand

<?php
$servername = "localhost";
$username = "root";
$password = "root1";
$db = "vcmpdb";

// Create connection
$conn = new mysqli($servername, $username, $password, $db);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
//echo "connection successfull";

//$acc = "SELECT Name, IP, Level, Kills, Deaths, Cash, Bank, Joins, nogoto, WonLms, RandSpawn FROM Account";




if ( isset( $_REQUEST['nick'] ) )
{
$im  = imagecreatefrompng("Signature_Background.png") or die("Cannot Create new GD image");
$stats  = imagecolorallocate($im, 255, 208, 240);
$nick  = imagecolorallocate($im, 255, 43, 178);
$font = imageloadfont( "Font.gdf" );
$sql  = 'SELECT * FROM Account WHERE Name = \''.addslashes( $_REQUEST['nick'] ).'\'';


header('Content-Type: image/png');
imagepng($im);
imagedestroy($im);

foreach ($db->query($sql) as $row)
{
imagestring($im, $font, 100, 37, $_REQUEST['nick'], $nick) or die("Cannot place Text");
imagestring($im, $font, 380, 10, $row['Kills'], $stats) or die("Cannot place Text");
imagestring($im, $font, 380, 35, $row['Deaths'], $stats) or die("Cannot place Text");
imagestring($im, $font, 380, 60, ( ( ( $row[ $row['Kills'] ] > 0 ) && ( $row[ $Fields['Deaths'] ] > 0 ) ) ? round($row[ $Fields['Kills'] ] / $row[ $Fields['Deaths'] ],2) : 0 ), $stats ) or die("Cannot place Text");
}

}
?> if someone wants to check the url so try here which is the output http://wno-host.ddns.net:90/sign/sign.php?nick=MEGAMIND  @EK.IceFlake   @Doom_Kill3R and heres the input query http://wno-host.ddns.net:90/sign/

[MEGAMIND]

*BUMP* pls

[MEGAMIND]

*bump* or atleast someone fix me up that php code

[MEGAMIND]

*bump*

[Namir]

Resolved someone can lock dis topic .

[!]

Is it necessary to lock this topic?

[MEGAMIND]

Is it necessary to lock this topic?

nope as it is solved so its solved maybe someone may need help from this topic so he can ask it right here

so no need to lock