<?php
# Copyright Original Dateien und Einträge by: Manuel Staechele
# Support: www.ilch.de
# Profil Mod by: orsnipe
# Profil Mod Code by: orsnipe, IRvD, Lord|Schirmer & www.ilch.de/forum
# Profil Mod Copyright by: www.capfx.de
$abf = 'SELECT * FROM prefix_user WHERE id = "'.$uid.'"';
$erg = db_query($abf);
$row = db_fetch_assoc($erg);
$user_name = $row['name'];
$abf2 = "SELECT * FROM prefix_online";
$erg2 = db_query($abf2);
$row2 = db_fetch_assoc($erg2);
$recht = $row['recht'];
$abf3 = "SELECT * FROM prefix_grundrechte WHERE id = ".$recht."";
$erg3 = db_query($abf3);
$row3 = db_fetch_assoc($erg3);
$abf4 = "SELECT COUNT(*) AS forumtopics FROM prefix_topics WHERE erst = '$user_name'";
$erg4 = db_query($abf4);
$row4 = db_fetch_assoc($erg4);
$abf5 = "SELECT COUNT(*) AS newstopics FROM prefix_news WHERE user_id = ".$uid."";
$erg5 = db_query($abf5);
$row5 = db_fetch_assoc($erg5);
$abf6 = "SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'";
$erg6 = db_query($abf6);
$row6 = db_fetch_assoc($erg6);
$abf7 = "SELECT COUNT(*) AS newsposts FROM prefix_koms WHERE name = '$user_name'";
$erg7 = db_query($abf7);
$row7 = db_fetch_assoc($erg7);
$abf8 = "SELECT * FROM prefix_warstats";
$erg8 = db_query($abf8);
$row8 = db_fetch_assoc($erg8);
$abf9 = "SELECT COUNT(*) AS gallery_eintraege FROM prefix_usergallery WHERE uid = ".$uid."";
$erg9 = db_query($abf9);
$row9 = db_fetch_assoc($erg9);
$erg = db_query('SELECT COUNT(*) FROM `prefix_warmember` a INNER JOIN `prefix_wars` b ON a.wid = b.id AND a.aktion = 1 AND b.status = 3 WHERE a.uid = ' . $uid);
$awp = db_result($erg);
if(!empty($row['awp'])){
$awp = $row['awp'];
} else {
$awp = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if($row9['gallery_eintraege'] == 0){
$gallery_eintraege = "<span style=\"font-size:9px\"><i>keine Bilder</i></span>";
}elseif($row9['gallery_eintraege'] == 1){
$gallery_eintraege = "1 Bild vorhanden";
} else {
$gallery_eintraege = $row9['gallery_eintraege']." Bilder";}
if(!empty($row['email']) && $row['opt_mail'] == 1){
$email = "<a href=\"mailto:".$row['email']."\"><img src=\"include/images/profilmod/email.png\" border=\"0\" /></a>";
}elseif(!empty($row['email']) && $row['opt_mail'] == 0){
$email = "<img src=\"include/images/profilmod/email.png\" border=\"0\" /></a>";
} else {
$email = "<img src=\"include/images/profilmod/keine_email.png\" border=\"0\" />";}
if(!empty($row['homepage'])){
$homepage = "<a href=\"".$row['homepage']."\" target=\"_blank\"><img src=\"include/images/icons/website_icon.png\" border=\"0\" /></a>";
} else {
$homepage = "<img src=\"include/images/icons/no_website_icon.png\" border=\"0\" /> <span style=\"font-size:9px\"><i>Keine Angabe</i></span>";}
if(!empty($row['facebook'])){
$facebook = "<a href=\"".$row['facebook']."\" target=\"_blank\"><img src=\"include/images/profilmod/facebook.png\" border=\"0\" /></a>";
} else {
$facebook = "";}
if(!empty($row['staat'])){
$staat = "<img src=\"include/images/flags/".$row['staat']."\" border=\"0\" />";
} else {
$staat = "<img src=\"include/images/flags/na.gif\" border=\"0\" />";}
$row['koms'] = db_count_query('SELECT COUNT(id) FROM `prefix_koms` WHERE name="'.$row['name'].'"');
$pmge = db_result(db_query("SELECT COUNT(ID) FROM `prefix_pm`"),0);
$pmu = db_result(db_query("SELECT COUNT(ID) FROM prefix_pm WHERE sid = '".$uid."'"),0);
$postsge = db_result(db_query("SELECT COUNT(ID) FROM `prefix_posts`"),0);
$postsu = db_result(db_query("SELECT COUNT(id) FROM `prefix_posts` WHERE `erst` = '".$row['name']."'"),0);
####################################################
$pollge = db_result(db_query("SELECT COUNT(poll_id) FROM prefix_poll WHERE recht = '2' "),0);
$pollu = db_result(db_query("SELECT COUNT(*) FROM prefix_poll WHERE recht = '2' AND text REGEXP '#".$uid."(#|$)'"),0);
$shoutge = db_result(db_query("SELECT COUNT(id) FROM prefix_shoutbox"),0);
$shoutu = db_result(db_query("SELECT COUNT(id) FROM prefix_shoutbox WHERE nickname = '".$row['name']."'"),0);
####################################################
if(!empty($row['posten'])){
$posten = "<img src=\"include/images/profilmod/posten/".$row['posten']."\" border=\"0\" />";
} else {
$posten = "<img src=\"include/images/profilmod/posten/na.png\" border=\"0\" />";
}
$avatar = '';
if (file_exists($row['avatar'])) {
$avatar = '<img src="'.$row['avatar'].'" align="center" border="0" width="120">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "1") {
$avatar = '<img src="include/images/avatars/gast.png" align="center" border="0" width="120">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "2") {
$avatar = '<img src="include/images/avatars/gast.png" align="center" border="0" width="120">';
} else {
$avatar = '<img src="include/images/avatars/gast.png" align="center" border="0" width="120">';
}
$regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row['regist'];
$regday = round($regsek / 86400);
$postpday = ( $regday == 0 ? 0 : round($row['posts'] / $regday, 2 ) );
$usertitel = $row3['name'];
if($row2['uid'] == $uid){
$online = '<b><span style="color:#009900;">online</span></b>';
}else{
$online = "<b>offline</b>";}
if($row['geschlecht'] == 1){
$geschlecht = '<img src="include/images/profilmod/male.png" height="12" border="0" />';
}elseif($row['geschlecht'] == 2){
$geschlecht = '<img src="include/images/profilmod/female.png" height="12" border="0" />';
}else{
$geschlecht = "";}
if($row['gebdatum'] !== "0000-00-00"){
$gebdatum = date('d.m.Y',strtotime($row['gebdatum']));
$tag = date('d',strtotime($row['gebdatum']));
$monat = date('m',strtotime($row['gebdatum']));
$jahr = date('Y',strtotime($row['gebdatum']));
$jetzt = mktime(0,0,0,date("m"),date("d"),date("Y"));
$geburtstag = mktime(0,0,0,$monat,$tag,$jahr);
$alter = "(".intval(($jetzt - $geburtstag) / (3600 * 24 * 365)).")";
} else {
$gebdatum = "<span style=\"font-size:9px\"><i>Kein Datum angegeben</i></span>";
$alter = "<span style=\"font-size:9px\"><i>Kein Alter angegeben</i></span>";}
function Sternzeichen($t,$m,$j) {
$tag = date("d",mktime(0,0,0,$m,$t,$j));
$monat = date("n",mktime(0,0,0,$m,$t,$j));
if ($tag > 20 && $monat == 3 || $tag < 21 && $monat == 4) {
$zeichen = "Widder";}
if ($tag > 20 && $monat == 4 || $tag < 21 && $monat == 5) {
$zeichen = "Stier";}
if ($tag > 20 && $monat == 5 || $tag < 22 && $monat == 6) {
$zeichen = "Zwillinge";}
if ($tag > 21 && $monat == 6 || $tag < 23 && $monat == 7) {
$zeichen = "Krebs";}
if ($tag > 22 && $monat == 7 || $tag < 24 && $monat == 8) {
$zeichen = "Löwe";}
if ($tag > 23 && $monat == 8 || $tag < 24 && $monat == 9) {
$zeichen = "Jungfrau";}
if ($tag > 23 && $monat == 9 || $tag < 24 && $monat == 10) {
$zeichen = "Waage";}
if ($tag > 23 && $monat == 10 || $tag < 23 && $monat == 11) {
$zeichen = "Skorpion";}
if ($tag > 22 && $monat == 11 || $tag < 22 && $monat == 12) {
$zeichen = "Schütze";}
if ($tag > 21 && $monat == 12 || $tag < 21 && $monat == 1) {
$zeichen = "Steinbock";}
if ($tag > 20 && $monat == 1 || $tag < 20 && $monat == 2) {
$zeichen = "Wassermann";}
if ($tag > 19 && $monat == 2 || $tag < 21 && $monat == 3) {
$zeichen = "Fische";}
return "$zeichen";}
if($row['gebdatum'] !== "0000-00-00"){
$sternzeichen = Sternzeichen($tag,$monat,$jahr);
} else {
$sternzeichen = "<span style=\"font-size:9px\"><i>Unbekannt</i></span>";
}
if(!empty($row['wohnort'])){
$wohnort = $row['wohnort'];
} else {
$wohnort = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
$string = $row['char1'];
$search = array("Ae", "Oe", "Ue", "ae", "oe", "ue", "ss", ".png");
$replace = array("Ä", "Ö", "Ü", "ä", "ö", "ü", "ss", "");
if(!empty($row['char1'])){
$char1 = "<img src=\"include/images/profilmod/char/".$row['char1']."\" height=\"20\" border=\"0\" align=\"absmiddle\" /> ".str_replace($search, $replace, $string);
} else {
$char1 = "<span style=\"font-size:9px\"><i>Keine Klasse angegeben</i></span>";
}
#
##
###
####Charakter Charnamen
if(!empty($row['charname1'])){
$charname1 = $row['charname1'];
} else {
$charname1 = "<span style=\"font-size:8px\"><i>Keine Namensangabe</i></span>";
}
#
##
###
####Charakter Level
if(!empty($row['level1'])){
$level1 = $row['level1'];
} else {
$level1 = "1";
}
#
##
###
####Erfahrung/NächsterRang
if($row['posts'] != 0)
{
$postar = array(1,5,25,50,75,100,125,150,175,200,225,250,275,300,325,350,375,400,425,450,475,500,525,550,575,600,625,650,675,700,725,750,775,800,2500);
$postarnames = array(Level_1,Level_2,Level_3,Level_4,Level_5,Level_6,Level_7,Level_8,Level_9,Level_10,Level_11,Level_12,Level_13,Level_14,Level_15,Level_16,Level_17,Level_18,Level_19,Level_20,Level_21,Level_22,Level_23,Level_24,Level_25,Level_26,Level_27,Level_28,Level_29,Level_30,Level_31,Level_32,Level_33,Level_34,Level_35);
$i=0;
while($postar[$i] < $row['posts'])
{
$next = round(100/($postar[$i+1]-$postar[$i])*($row['posts']-$postar[$i]),2);
if($postar[$i+1] != $row['posts']) { $pointsleft = $postar[$i+1] - $row['posts']; $nextrank = $postarnames[$i+1]; } else { $pointsleft = $postar[$i+2] - $row['posts']; $nextrank = $postarnames[$i+2]; }
$i++;
}
}
else
{
$next = "0%";
}
$erfahrung = round (100/350*$row['posts'],2);
#### ende
###
##
#
?>
Regt mich das grad auf...
Zitat
