Liebe Community,
wir verwenden dieses wirklich tolle Script seit 2006.
Um die bisherigen Erfolge im Profil zu zeigen, habe ich dieses etwas modifiziert.
Vielleicht interessiert das ja auch den einen oder anderen?
um das zu erreichen habe ich die finalen Ergebnistabellen der jeweiligen Tippspiele in das neue Tippspiel aufgenommen. Eine solche Tabelle heisst z.B. rangliste_2006.
der inhalt meiner img/php/profil.php datei ist wie folgt
PHP
- <?php
- ###################################################################################################
- # Dateiname: profil.php
- #
- # Last Change of File
- # -------------------
- # Revision: $Rev: 3 $
- # Date: $Date: 2011-12-18 19:33:31 +0100 (So, 18 Dez 2011) $
- # Author: $Author: soeren $
- #--------------------------------------------------------------------------------------------------
- # Copyright (C) 2002 - 2014 Soeren Wiechert
- # Many thanks to Sebastian Mueller for his great work on the base code!
- #
- # License: GPL V3 - http://www.gnu.org/licenses/gpl-3.0.txt
- #
- # Please read the terms of license found in the license files which should be part of the
- # package of this script. If not, please contact us at http://www.xcript.de.
- #
- # Bitte lese die Lizenz-Informationen, die als Beilage zu diesem Script-Paket enthalten sind.
- # Falls diese nicht enthalten sind, dann kontaktiere uns bitte unter http://www.xcript.de.
- ###################################################################################################
- ob_start();
- if (@file_exists('../../include/config_emtipp.php')) {
- require_once ("../../include/config_emtipp.php");
- } else {
- require_once "../../include/inc.config.php";
- }
- require_once "../../include/inc.functions.php";
- require_once "../../include/inc.content.php";
- createMysqlConnect($CONFIG['MYSQL']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."users WHERE id = '".(int)$_GET['user']."'");
- $user = $sql->fetch_array();
- # -- MOD-Userpic/MOD-Profildatei -> Höhe $h von 181 auf 198px geändert
- $h = 230; //181
- $w = 700;
- header ("Content-type: image/png");
- $im = imagecreatetruecolor ($w, $h);
- $color = imagecolorallocatealpha($im, 248, 249, 250, 127); // Transparente Farbe setzen
- imagefill($im, 0, 0, $color); // Bild mit transparenter Farbe füllen
- $bgLight = imagecolorallocate($im, 248, 249, 250);
- $bgDark = imagecolorallocate($im,232,233,234);
- $border_color = imagecolorallocate($im,176,176,176);
- $headerText = imagecolorallocate($im,96,96,96);
- $teamName1 = imagecolorallocate($im,80,80,80);
- $teamName2 = imagecolorallocate($im,150,150,150);
- $col_black = imagecolorallocate($im,150,150,150);
- $verdana = $CONFIG['FOLDER'].'img/php/verdana.ttf';
- imagefilledrectangle($im,0,0,$w,30,$bgDark);
- imageline($im,0,30,$w,30,$border_color);
- imageline($im,0,0,0,$h,$border_color);
- imageline($im,0,0,$w,0,$border_color);
- imageline($im,$w-1,0,$w-1,$h-1,$border_color);
- imageline($im,0,$h-1,$w-1,$h-1,$border_color);
- $h = $h - 8;
- $src = imagecreatefrompng($CONFIG['FOLDER']."./img/flags/".strtolower(getTeamName($user['fav'],"short")).".png");
- #imagerectangle ($im, 4,3, 27,20,$teamName2);
- imagecopyresampled ($im, $src, 7, 5, 0, 0, 30, 20, 34, 25);
- imagettftext ($im, 8, 0, 44, 20, $headerText, $verdana, $user['usr']." - Letzte Aktivität am ".date("d.m.y \u\m H:i \U\h\\r",$user['lastLogin'])." @ ".$user['currentPage']);
- ### MOD-Userpic -- das Preview des Design auskommentiert und dafür das Profilbild anzeigen lassen
- #$src = imagecreatefromjpeg($CONFIG['FOLDER']."./img/previews/".($user['color'] == 0 ? getDefaultDesignIndex() : $user['color']).".jpg");
- $src = imagecreatefromstring(file_get_contents($CONFIG['FOLDER']."./img/userpic/".($user['userpic'])));
- ###
- imagerectangle ($im, 8,35, 10+imagesx($src)+5,37+imagesy($src)+5,$teamName2);
- imagecopyresampled ($im, $src, 12, 39, 0, 0, imagesx($src), imagesy($src), imagesx($src), imagesy($src));
- #imagettftext ($im, 9, 0, 250, 50, $teamName1,$verdana,"Farbschema:");
- #imagettftext ($im, 9, 0, 450, 50, $teamName1,$verdana,$CONFIG['COLORS'][($user['color'] == 0 ? getDefaultDesignIndex() : $user['color'])].($user['color'] == 0 ? " (default)" : ""));
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."forum_threads WHERE autor = '".$user['id']."'");
- $sql1 = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."forum_posts WHERE autor = '".$user['id']."'");
- imagettftext ($im, 9, 0, 250, 50,$teamName1,$verdana,"Forum Beiträge / Themen");
- imagettftext ($im, 9, 0, 450, 50,$teamName1,$verdana,$sql1->num_rows." Posts in ".$sql->num_rows." Threats");
- #imagettftext ($im, 9, 0, 250, 100,$teamName1,$verdana,"Forum Beiträge:");
- #imagettftext ($im, 9, 0, 450, 100,$teamName1,$verdana,$sql->num_rows." Posts");
- imagettftext ($im, 9, 0, 250, 70,$teamName1,$verdana,"Tipps");
- imagettftext ($im, 9, 0, 450, 70,$teamName1,$verdana,loadDoneTipps($user['id'])." bisher gewertet");
- $fuenfer = loadFuenfer($user['id']);
- $ergpkt = loadFuenferPkt($user['id']);
- imagettftext ($im, 9, 0, 260, 85,$teamName1,$verdana,"davon richtige Ergebnisse");
- imagettftext ($im, 9, 0, 450, 85,$teamName1,$verdana, $fuenfer." (".$ergpkt." Punkte)");
- $diff = loadDiff($user['id']);
- $ergpkt = loadDiffPkt($user['id']);
- imagettftext ($im, 9, 0, 260, 100,$teamName1,$verdana,"davon richtige Differenzen");
- imagettftext ($im, 9, 0, 450, 100,$teamName1,$verdana, $diff." (".$ergpkt." Punkte)");
- $tend = loadTend($user['id']);
- $ergpkt = loadTendPkt($user['id']);
- imagettftext ($im, 9, 0, 260, 115,$teamName1,$verdana,"davon richtige Tendenzen");
- imagettftext ($im, 9, 0, 450, 115,$teamName1,$verdana, $tend." (".$ergpkt." Punkte)");
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM ". $CONFIG['MYSQL']['PREFIX'] ."rangliste_boni WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['b'] = empty($row['b']) ? 0 : $row['b'];
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? 0 : $row['rang'];
- $content = "".$row['rang'].". Platz (".$row['pkt']." Punkte)";
- $contentBonus = ($row['b'] == 1) ? $row['b']. " Punkt" : $row['b']. " Punkte";
- imagettftext ($im, 9, 0, 260, 130,$teamName1,$verdana,"Bonuspunkte");
- imagettftext ($im, 9, 0, 450, 130,$teamName1,$verdana, $contentBonus);
- imagettftext ($im, 9, 0, 250, 150,$teamName1,$verdana,"Platz EM 2020");
- imagettftext ($im, 9, 0, 450, 150,$teamName1,$verdana, $content);
- imagefilledrectangle($im,245,155,560,175,$bgDark);
- imageline($im,245,155,245,215,$border_color);
- imageline($im,245,155,560,155,$border_color);
- imageline($im,245,175,560,175,$border_color);
- imageline($im,560,155,560,215,$border_color);
- imageline($im,245,215,560,215,$border_color);
- imageline($im,290,175,290,215,$border_color);
- imageline($im,335,175,335,215,$border_color);
- imageline($im,380,175,380,215,$border_color);
- imageline($im,425,175,425,215,$border_color);
- imageline($im,470,175,470,215,$border_color);
- imageline($im,515,175,515,215,$border_color);
- imageline($im,245,195,560,195,$border_color);
- imagettftext ($im, 9, 0, 250, 170,$teamName1,$verdana,"Abschneiden bei den bisherigen Tippspielen");
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2006 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content06 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 250, 190,$teamName1,$verdana,"2006");
- imagettftext ($im, 9, 0, 260, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2008 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content08 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 295, 190,$teamName1,$verdana,"2008");
- imagettftext ($im, 9, 0, 305, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2010 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content10 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 340, 190,$teamName1,$verdana,"2010");
- imagettftext ($im, 9, 0, 350, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2012 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content12 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 385, 190,$teamName1,$verdana,"2012");
- imagettftext ($im, 9, 0, 395, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2014 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content14 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 430, 190,$teamName1,$verdana,"2014");
- imagettftext ($im, 9, 0, 440, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2016 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content16 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 475, 190,$teamName1,$verdana,"2016");
- imagettftext ($im, 9, 0, 485, 210,$teamName1,$verdana, $row['rang']);
- $sql = $CONFIG['MYSQL']['CONNECT']->query("SELECT * FROM rangliste_2018 WHERE uid = '".$user['id']."'");
- $row = $sql->fetch_array();
- $row['pkt'] = empty($row['pkt']) ? 0 : $row['pkt'];
- $row['rang'] = empty($row['rang']) ? "-" : "".$row['rang'].".";
- $content18 = "".$row['rang'].".";
- imagettftext ($im, 9, 0, 520, 190,$teamName1,$verdana,"2018");
- imagettftext ($im, 9, 0, 530, 210,$teamName1,$verdana, $row['rang']);
- $textwidth = imagettfbbox(8, 0, $verdana, $CONFIG['PAGE']['NAME']); // Breite des Textes ermitteln
- imagettftext ($im, 8, 0, $w - $textwidth[2] - 7, 20, $teamName2, $verdana, $CONFIG['PAGE']['NAME']);
- imagesavealpha($im, true); // Alpha-Transparenz speichern (wichtig!)
- ImagePNG ($im);
- imagedestroy ($im);
- ?>