<?php
# Copyright Original Dateien und Einträge by: Manuel Staechele
# Support: www.ilch.de
# Profilmod by: orsnipe
# Profilmod Code by: orsnipe, IRvD, www.ilch.de/forum
# Profilmod Copyright by: www.capdesigns.de
defined ('main') or die ( 'no direct access' );
$uid = $menu->get(2);
######### Zufalls Gallerybild
$randbild = '';
$res = db_query('SELECT id, endung FROM `prefix_usergallery` WHERE `uid` = "'.$uid.'" ORDER BY rand() LIMIT 5');
if (db_num_rows($res))
{
while ($row = db_fetch_assoc($res))
{
$randbild .= '<a target="_new" href="/include/images/usergallery/img_'.$row['id'].'.'.$row['endung'].'"><img class="bilderrahmen" src="include/images/usergallery/img_thumb_'.$row['id'].'.'.$row['endung'].'" border="2" width="80" height="60"></a> ';
}
}
else
{
$randbild = '<img src="include/images/profilmod/no_usergallery.jpg" border="0">';
}
########## Ende
#Hits hochzählen
if ($_SESSION['authid'] != $uid and !isset($_SESSION['visited_profils'][$uid])) {
$_SESSION['visited_profils'][$uid] = true;
db_query("UPDATE prefix_user SET hits = hits + 1 WHERE id = ".$uid);
}
#Ende
#Squadanzeige im Profil
function user_get_teams ($uid) {
$erg = db_query("SELECT b.name, c.name as posi
FROM `prefix_groupusers` a
LEFT JOIN `prefix_groups` b ON b.id = a.gid
LEFT JOIN `prefix_groupfuncs` c ON a.fid = c.id
WHERE a.uid = ".$uid);
if (db_num_rows($erg) > 0 ) {
while ($r = db_fetch_assoc($erg)) {
if ($class == '') { $class = ''; } else { $class = ''; }
$l .= '<table width="100%" border="0" cellpadding="2" cellspacing="1"><tr><td class="inhalthintergrund" width="70%">'.$r['name'].'</td><td class="inhalthintergrund" width="30%" height="25">'.$r['posi'].'</td></tr></table>';
}
} else {
$l .= '';
}
return ($l);
}
########## Ende
#letzte Besucher
$lastbes_anz = 3;
if ($_SESSION['authid'] != $uid AND $_SESSION['authid'] != 0) {
$lb = db_fetch_object(db_query('SELECT last_bes, last_user_time FROM prefix_user WHERE id = '.$uid));
$lba = explode('#',$lb->last_bes);
$lbt = explode('#',$lb->last_user_time);
$i = array_search($_SESSION['authid'],$lba);
if ($i !== false) {
unset($lba[$i]); unset($lbt[$i]);
} elseif (count($lba) >= $lastbes_anz) {
$lba = array_slice($lba,0,$lastbes_anz-1);
$lbt = array_slice($lbt,0,$lastbes_anz-1);
}
array_unshift($lba,$_SESSION['authid']);
array_unshift($lbt,time());
$i_lb = implode('#',$lba);
$i_lbt = implode('#',$lbt);
db_query("UPDATE prefix_user SET last_bes = '$i_lb', last_user_time = '$i_lbt' WHERE id = $uid");
}
#Ende
#### punkte
if ( $row['posts'] != 0 AND userbwpoints($row['erstid']) > 0 ) {
$row['USERPOINTS'] = 'Punkte: '.userbwpoints($row['erstid']).'<br />';
} else {
$row['USERPOINTS'] = '';
}
#### ENDE
############### Gameicons Ausgabe #######################
$ausgabe = '';
$str = @db_result ( db_query ("SELECT `games` FROM prefix_user WHERE id = ".$uid) , 0 );
$gamesarr = explode("#", $str);
$style = 'width:px;height:100px;border:1px;border-bottom-left-radius: 5px;
border-top-left-radius: 5px;
border-bottom-right-radius: 5px;
border-top-right-radius: 5px;padding: 1px;-moz-box-shadow: 0px 2px 3px #000;
-webkit-box-shadow: 0px 1px 3px #000;
box-shadow: 0px 1px 3px #000;margin:1px;padding:0';
foreach($gamesarr as $value)
{
if (file_exists('include/images/wargames/'.$value))
{
$ausgabe .= '<img style="'.$style.'" onmouseover="Tip(\'<div align="center"><img style="width:180px;height:254px;border:none" src="include/images/spiele/'.$value.'"><br>'.substr($value,0,-4).'</div>\')" onmouseout="UnTip()" src="include/images/spiele/'.$value.'" alt="'.substr($value,0,-4).'" /> ';
} else {
$ausgabe .= '';
}
}
##################################################
############### Auszeichnung Ausgabe #######################
$ausgaben = '';
$str = @db_result ( db_query ("SELECT `auszeichnung` FROM prefix_user WHERE id = ".$uid) , 0 );
$auszeichnungarr = explode("#", $str);
$style = 'width:px;height:100px;border:1px;border-bottom-left-radius: 5px;
border-top-left-radius: 5px;
border-bottom-right-radius: 5px;
border-top-right-radius: 5px;padding: 1px;-moz-box-shadow: 0px 2px 3px #000;
-webkit-box-shadow: 0px 1px 3px #000;
box-shadow: 0px 1px 3px #000;margin:1px;padding:0';
foreach($auszeichnungarr as $value)
{
if (file_exists('include/images/profilmod/auszeichnung/'.$value))
{
$ausgaben .= '<img style="'.$style.'" onmouseover="Tip(\'<div align="center"><img style="width:180px;height:px;border:none" src="include/images/profilmod/auszeichnung/'.$value.'"><br>'.substr($value,0,-4).'</div>\')" onmouseout="UnTip()" src="include/images/profilmod/auszeichnung/'.$value.'" alt="'.substr($value,0,-4).'" /> ';
} else {
$ausgaben .= '';
}
}
##################################################
include('user_infos.php');
$ar = array (
'NAME' => $row['name'],
'HITS' => $row['hits'],
'JOINED' => date('d.m.Y',$row['regist']),
'LASTAK' => date('d.m.Y - H:i',$row['llogin']),
'POSTS' => $row['posts'],
'postpday' => $postpday,
'AUSGABE' => $ausgabe,
'AUSGABEN' => $ausgaben,
'RANDBILD' => $randbild,
'STATUSTEXT' => $statustext,
'UID' => $uid,
'RANG' => userrang ($row['posts'],$uid),
'RANGGRAFIK' => $row['rang'],
'AVATA' => $avatar,
'ONLINE' => $online,
'USERTITEL' => $usertitel,
'EMAIL' => $email,
'HOMEPAGE' => $homepage,
'GESCHLECHT' => $geschlecht,
'GEBDATUM' => $gebdatum,
'ALTER' => $alter,
'WOHNORT' => $wohnort,
'LASTUSER' => last_user($uid),
'MICH' => bbcode($row['mich']),
'CLANLOGO' => $clanlogo,
'CNAME' => $cname,
'CTAG' => $ctag,
'CSEITE' => $cseite,
'SYSTEM' => $system,
'SOUND' => $sound,
'HDD' => $hdd,
'MONITOR' => $monitor,
'INET' => $inet,
'HEADSET' => $headset,
'BOARD' => $board,
'PROZESOR' => $prozesor,
'RAM' => $ram,
'GRAFIK' => $grafik,
'TASTA' => $tasta,
'MAUS' => $maus,
'CPUBILD' => $cpubild,
'GPUBILD' => $gpubild,
'POSTEN' => $posten,
'LOGINS' => $row['logins'],
### Skills ###
'SNIPERSKILL' => $sniperskill,
'MEDICSKILL' => $medicskill,
'ENGINEERSKILL' => $engineerskill,
'RECONSKILL' => $reconskill,
'TEAMPLAYSKILL' => $teamplayskill,
'TAKTIKSKILL' => $taktikskill,
'KOMANDOSKILL' => $komandoskill,
'SHOOTER' => $shooter,
'RACE' => $race,
'SPORT' => $sport,
'FUSSBALL' => $fussball,
'POKER' => $poker,
'ROUND' => $round,
'SPRINT' => $sprint,
'ZEITRENNEN' => $zeitrennen,
'COPS' => $cops,
'CRASH' => $crash,
'DRIFT' => $drift,
'DRAG' => $drag,
'SHOOTERGAME' => $shootergame,
'RACEGAME' => $racegame,
'SPORTGAME' => $sportgame,
'SKILLS' => @db_result(db_query("Select (SNIPERSKILL + MEDICSKILL + ENGINEERSKILL + RECONSKILL + TEAMPLAYSKILL + TAKTIKSKILL + KOMANDOSKILL) /7 as foo from prefix_user where id ='".$uid."'"),0),
'GESAMTRACE' => @db_result(db_query("Select (ROUND + SPRINT + ZEITRENNEN + COPS + CRASH + DRIFT + DRAG) /7 as foo from prefix_user where id ='".$uid."'"),0),
'GESAMTSPORT' => @db_result(db_query("Select (FUSSBALL + POKER) /2 as foo from prefix_user where id ='".$uid."'"),0),
'POSTS' => $row['posts'],
'NEWSPOSTS' => $row6['newsposts'],
'POSTPDAY' => $postpday,
'FORUMTOPICS' => $row4['forumtopics'],
'NEWSTOPICS' => $row5['newstopics'],
'FORUMPOSTS' => $row7['forumposts'],
'KOMS' =>$row['koms'],
'PMGESENDET' => @db_result(db_query("SELECT COUNT(id) FROM `prefix_pm` WHERE `sid` = '".$uid."'"),0),
'PMGE' => @db_result(db_query("SELECT COUNT(ID) FROM `prefix_pm`"),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),
'NEWS' => @db_result(db_query("SELECT COUNT(news_id) FROM `prefix_news` WHERE `user_id` = '".$uid."'"),0),
'NEWSGE' => db_result(db_query("SELECT COUNT(news_id) FROM `prefix_news`"),0),
'TOPICS' => @db_result(db_query("SELECT COUNT(id) FROM `prefix_topics` WHERE `erst` = '".$row['name']."'"),0),
'TOPICSGE' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_topics`"),0),
'KOMGE' => db_result(db_query("SELECT COUNT(ID) FROM `prefix_koms`"),0),
'KOMU' => db_result(db_query("SELECT COUNT(id) FROM prefix_koms WHERE name='".$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),
'PMGES' => @db_result($pmGes,0),
'ANZBAL' => '<img src="/include/images/vote/votebalkenbox.gif" height="5" width="'.@round($pmGes/$pmGes *267).'" align="left" alt="">',
##############################
'NEXT' => $next,
'NEXTRANK' => $nextrank,
'POINTSLEFT' => $pointsleft,
'ERFAHRUNG' => $erfahrung,
'SIGNATUR' => bbcode($row['sig']),
'STAAT' => $staat,
'STERNZEICHEN' => $sternzeichen,
'GB_EINTRAEGE' => $gb_eintraege,
'GALLERIE_EINTRAEGE' => $gallery_eintraege,
'ICQ' => $icq,
'FACEBOOK' => $facebook,
'YOUTUBE' => $youtube,
'CD' => $cd,
'TEAMS' => user_get_teams ($uid),
);
$title = $allgAr['title'].' :: Users :: Details von '.$row['name'];
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> <a href=index.php?user-details-'.$uid.'>Details von '.$row['name']."</a>".$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
$design->header();
$tpl = new tpl ( 'user/userdetails' );
$l = profilefields_show ( $uid );
$ar['rowspan'] = 4 + substr_count($l, '<tr><td class="');
$ar['profilefields'] = $l;
$tpl->set_ar_out($ar,0);
$ges_ar = array ('wurstegal', 'maennlich', 'weiblich');
$dif = date('Y-m-d H:i:s', time() - 60);
$sql = db_query("SELECT a.fid as aktfid, b.id, b.name, IF(c.uptime > '$dif','online','offline') as status, b.avatar, b.geschlecht
FROM `prefix_friends` a
LEFT JOIN `prefix_user` b ON a.fid = b.id
LEFT JOIN `prefix_online` c ON a.fid = c.uid
WHERE a.uid = {$uid} ORDER BY b.recht ASC, c.uptime DESC");
if (db_num_rows($sql) > 0 ) {
while ($r = db_fetch_assoc($sql)) {
if (!is_numeric($r['geschlecht'])) { $r['geschlecht'] = 0; }
if (file_exists($r['avatar'])) { $r['AVATAR'] = '<img src="'.$r['avatar'].'" alt="User Pic" border="0" />'; }
elseif ($allgAr['forum_default_avatar']) { $r['AVATAR'] = '<img src="include/images/avatars/'.$ges_ar[$r['geschlecht']].'.jpg" alt="User Pic" border="0" />'; }
else { $r['avatar'] = ''; }
$r['FREUNDNAME'] = $r['name'];
$r['FREUNDID'] = $r['id'];
$tpl->set_ar_out($r,1);
}
} else {
echo '<tr><td class="Cmite">keine Freunde</td></tr>';
}
$tpl->out(2);
$design->footer();
?>
