<?php
$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);
if(file_exists("include/contents/user/user_gb.php")){
$abf8 = "SELECT COUNT(*) AS gb_eintraege FROM prefix_usergb WHERE uid = ".$uid."";
$erg8 = db_query($abf8);
$row8 = db_fetch_assoc($erg8);
if($row8['gb_eintraege'] == 0 ){
$gb_eintraege = "keine Einträge (<a href=\"index.php?user-usergb-view-".$uid."\">eintragen</a>)";
}elseif($row8['gb_eintraege'] == 1 ){
$gb_eintraege = "1 Eintrag (<a href=\"index.php?user-usergb-view-".$uid."\">eintragen</a>)";
}else{
$gb_eintraege = $row8['gb_eintraege']." Einträge";
}
} else {
$gb_eintraege = "Kein Gästebuch vorhanden";
}
$abf9 = "SELECT COUNT(*) AS gallery_eintraege FROM prefix_usergallery WHERE uid = ".$uid."";
$erg9 = db_query($abf9);
$row9 = db_fetch_assoc($erg9);
if(!empty($row['icq'])){
}else{
$icq = "keine Angabe";
}
if($row9['gallery_eintraege'] == 0){
$gallery_eintraege = "keine Bilder";
}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/icons/email_icon.png\" border=\"0\" /></a>";
}elseif(!empty($row['email']) && $row['opt_mail'] == 0){
$email = "<img src=\"include/images/icons/email_icon.png\" border=\"0\" /></a>";
} else {
$email = "<img src=\"include/images/icons/no_email_icon.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\" />";
}
if(!empty($row['jappy'])){
$jappy = "<a href=\"".$row['jappy']."\" target=\"_blank\"><img src=\"include/images/userdetails/jappy.png\" border=\"0\" /></a>";
} else {
$jappy = "<img src=\"include/images/userdetails/no_jappy.png\" border=\"0\" />";
}
if(!empty($row['facebook'])){
$facebook = "<a href=\"".$row['facebook']."\" target=\"_blank\"><img src=\"include/images/userdetails/facebook.png\" border=\"0\" /></a>";
} else {
$facebook = "<img src=\"include/images/userdetails/no_facebook.png\" border=\"0\" />";
}
if(!empty($row['wkw'])){
$wkw = "<a href=\"".$row['wkw']."\" target=\"_blank\"><img src=\"include/images/userdetails/wkw.png\" border=\"0\" /></a>";
} else {
$wkw = "<img src=\"include/images/userdetails/no_wkw.png\" border=\"0\" />";
}
if(!empty($row['wkw'])){
$skype = "<a href=\"".$row['wkw']."\" target=\"_blank\"><img src=\"include/images/userdetails/skype.png\" border=\"0\" /></a>";
} else {
$skype = "<img src=\"include/images/userdetails/no_skype.png\" border=\"0\" />";
}
if(!empty($row['studivz'])){
$steam = "<a href=\"".$row['studivz']."\" target=\"_blank\"><img src=\"include/images/userdetails/steam.png\" border=\"0\" /></a>";
} else {
$steam = "<img src=\"include/images/userdetails/no_steam.png\" border=\"0\" />";
}
if(!empty($row['studivz'])){
$studivz = "<a href=\"".$row['studivz']."\" target=\"_blank\"><img src=\"include/images/userdetails/studivz.png\" border=\"0\" /></a>";
} else {
$studivz = "<img src=\"include/images/userdetails/no_studivz.png\" border=\"0\" />";
}
if(!empty($row['myspace'])){
$myspace = "<a href=\"".$row['myspace']."\" target=\"_blank\"><img src=\"include/images/userdetails/myspace.png\" border=\"0\" /></a>";
} else {
$myspace = "<img src=\"include/images/userdetails/no_myspace.png\" border=\"0\" />";
}
if(!empty($row['youtube'])){
$youtube = "<a href=\"".$row['youtube']."\" target=\"_blank\"><img src=\"include/images/userdetails/youtube.png\" border=\"0\" /></a>";
} else {
$youtube = "<img src=\"include/images/userdetails/no_youtube.png\" border=\"0\" />";
}
if(!empty($row['staat'])){
$staat = "<img src=\"include/images/flags/".$row['staat']."\" border=\"0\" />";
} else {
$staat = "";
}
if(!empty($row['game1'])){
$game1 = "<img src=\"include/images/game_icon/".$row['game1']."\" border=\"0\" />";
} else {
$game1 = "";
}
if(!empty($row['game2'])){
$game2 = "<img src=\"include/images/game_icon/".$row['game2']."\" border=\"0\" />";
} else {
$game2 = "";
}
if(!empty($row['game3'])){
$game3 = "<img src=\"include/images/game_icon/".$row['game3']."\" border=\"0\" />";
} else {
$game3 = "";
}
if(!empty($row['game4'])){
$game4 = "<img src=\"include/images/game_icon/".$row['game4']."\" border=\"0\" />";
} else {
$game4 = "";
}
if(!empty($row['game5'])){
$game5 = "<img src=\"include/images/game_icon/".$row['game5']."\" border=\"0\" />";
} else {
$game5 = "";
}
$avatar = '';
if (file_exists($row['avatar'])) {
$avatar = '<img src="'.$row['avatar'].'" align="center" border="0">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "1") {
$avatar = '<img src="include/images/avatars/male.png" align="center" border="0">';
} elseif ($row['avatar'] == "" && $row['geschlecht'] == "2") {
$avatar = '<img src="include/images/avatars/female.png" align="center" border="0">';
} else {
$avatar = '<img src="include/images/avatars/wurstegal.png" align="center" border="0">';
}
$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>online</b>";
}else{
$online = "<b>offline</b>";
}
if($row['geschlecht'] == 1){
$geschlecht = "männlich";
}elseif($row['geschlecht'] == 2){
$geschlecht = "weiblich";
}else{
$geschlecht = "unentschlossen";
}
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 = "Kein Datum angegeben";
$alter = "";
}
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 = "Zwillige";
}
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 = "Unbekannt";
}
if(!empty($row['wohnort'])){
$wohnort = $row['wohnort'];
} else {
$wohnort = "Keine Angabe";
}
if(!empty($row['game'])){
$game = $row['game'];
} else {
$game= "";
}
if(!empty($row['spielerfahrungen'])){
$spielerfahrungen = $row['spielerfahrungen'];
} else {
$spielerfahrungen= "";
}
if(!empty($row['clan'])){
$clan = $row['clan'];
} else {
$clan= "";
}
if(!empty($row['map'])){
$map = $row['map'];
} else {
$map= "";
}
if(!empty($row['waffe'])){
$waffe = $row['waffe'];
} else {
$waffe= "";
}
if(!empty($row['essen'])){
$essen = $row['essen'];
} else {
$essen= "";
}
if(!empty($row['trinken'])){
$trinken = $row['trinken'];
} else {
$trinken= "";
}
if(!empty($row['film'])){
$film = $row['film'];
} else {
$film= "";
}
if(!empty($row['musik'])){
$musik = $row['musik'];
} else {
$musik= "";
}
if(!empty($row['sport'])){
$sport = $row['sport'];
} else {
$sport= "";
}
if(!empty($row['cpu'])){
$cpu = $row['cpu'];
} else {
$cpu= "";
}
if(!empty($row['mainboard'])){
$mainboard = $row['mainboard'];
} else {
$mainboard= "";
}
if(!empty($row['ram'])){
$ram = $row['ram'];
} else {
$ram= "";
}
if(!empty($row['monitor'])){
$monitor = $row['monitor'];
} else {
$monitor= "";
}
if(!empty($row['grafikkarte'])){
$grafikkarte = $row['grafikkarte'];
} else {
$grafikkarte= "";
}
if(!empty($row['soundkarte'])){
$soundkarte = $row['soundkarte'];
} else {
$soundkarte= "";
}
if(!empty($row['festplatte'])){
$festplatte = $row['festplatte'];
} else {
$festplatte= "";
}
if(!empty($row['i_net_verbindung'])){
$i_net_verbindung = $row['i_net_verbindung'];
} else {
$i_net_verbindung= "";
}
if(!empty($row['tastatur'])){
$tastatur = $row['tastatur'];
} else {
$tastatur= "";
}
if(!empty($row['maus'])){
$maus = $row['maus'];
} else {
$maus= "";
}
?>
Zitat geschrieben von Balthazar3k
