<?php
include '/xyz/xyz/xyz/config.inc.php';
//Datenbankverbindung
$portal_db = mysql_connect($dbHost, $dbUser, $dbPassword);
$blog_db = mysql_connect("localhost", "db_user", "db_pw");
header ("Content-type: image/png");
//Beginn: Signatur-Erstellung
$image = imagecreatetruecolor(440, 35);
$im = ImageCreateFromPNG("dynsig.png");
imagecopy($image, $im, 0, 0, 0, 0, 440, 35);
imagealphablending($image, false);
//Variabeln
$userID = "1"; //wird noch variabel
$bloguser = "2"; //wird noch variabel
$blogDBName = "blogs_";
//Fonteigenschaften
$white = imagecolorallocate($image, 255, 255, 255);
$green = imagecolorallocate($image, 102, 235, 87);
$schriftart = "/xyz/xyz/xyz//HARABARA.TTF";
$small = 2;
$large = 17*72/96;
// Datenbankabfrage: Username - funktioniert
mysql_select_db($dbName, $portal_db);
$username_query = mysql_query("SELECT username FROM wcf1_user WHERE userID = ".$userID."");
while($username_row = mysql_fetch_object($username_query))
{
$username = $username_row->username;
//Positionierung des Username's
$dimension = imagettfbbox ($large, 0, $schriftart, $username);
$x = ceil((440 - $dimension[4]) - 10);
$y = 15;
imagettftext($image, $large, 0, $x, $y, -1*$white, $schriftart, $username);
}
//Datenbankabfrage: Blog-Posts - funktioniert nicht
mysql_select_db($blogDBName, $blog_db);
$count_query = mysql_query("SELECT user_login FROM wp_users WHERE ID = ".$bloguser."");
while($count_row = mysql_fetch_object($count_query))
{
$count = $count_row->user_login;
imagestring($image, $small, 84, 17, $count, $green);
}
//Ende: Signatur
imagepng($image);
imagedestroy($image);
?>