Soo jetzt hab ich erst zeit gefunden sorry..
Also eigentlich hättest du ja das Profilmod Whazza und mir anschauen koennen und das einfach uebertragen
<?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);
$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'])){
$icq = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$row['icq']."\" target=\"_blank\"><img src=\"include/images/profilmod/icq.png?icq=".$row['icq']."&img=5\" border=\"0\"></a>";
}else{
$icq = "<img src=\"include/images/profilmod/kein_icq.png\" border=\"0\"/>";
}
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 = "<img src=\"include/images/profilmod/kein_facebook.png\" border=\"0\" />";
}
if(!empty($row['youtube'])){
$youtube = "<a href=\"".$row['youtube']."\" target=\"_blank\"><img src=\"include/images/profilmod/youtube.png\" border=\"0\" /></a>";
} else {
$youtube = "<img src=\"include/images/profilmod/kein_youtube.png\" border=\"0\" />";
}
if(!empty($row['cd'])){
$cd = "<a href=\"".$row['cd']."\" target=\"_blank\"><img src=\"include/images/profilmod/cd.png\" border=\"0\" /></a>";
} else {
$cd = "<img src=\"include/images/profilmod/kein_cd.png\" border=\"0\" />";
}
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 = '<span style="color:#0030ff">männlich</span>';
}elseif($row['geschlecht'] == 2){
$geschlecht = '<span style="color:#ff00c0">weiblich</span>';
}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 = "<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>";
}
if(!empty($row['statustext'])){
$statustext = $row['statustext'];
} else {
$statustext = "Kein Status Eingetragen";
}
if(!empty($row['cseite'])){
$cseite = "<a href=\"".$row['cseite']."\" target=\"_blank\">hier entlang</a>";
} else {
$cseite = "<span style=\"font-size:9px\"><i>keine Clanseite</i></span>";
}
if(!empty($row['cname'])){
$cname = $row['cname'];
} else {
$cname = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['ctag'])){
$ctag = $row['ctag'];
} else {
$ctag = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['clanlogo'])){
$clanlogo = "<img src=\"include/images/profilmod/clanlogos/".$row['clanlogo']."\" border=\"0\" />";
} else {
$clanlogo = "<img src=\"include/images/profilmod/clanlogos//na.png\" border=\"0\" />";
}
if(!empty($row['cpubild'])){
$cpubild = "<img src=\"include/images/profilmod/cpubild/".$row['cpubild']."\" border=\"0\" />";
} else {
$cpubild = "<img src=\"include/images/profilmod/cpubild/na.png\" border=\"0\" />";
}
if(!empty($row['gpubild'])){
$gpubild = "<img src=\"include/images/profilmod/grafikbild/".$row['gpubild']."\" border=\"0\" />";
} else {
$gpubild = "<img src=\"include/images/profilmod/grafikbild/na.png\" border=\"0\" />";
}
if(!empty($row['shootergame'])){
$shootergame = "<img src=\"include/images/profilmod/skillbilder/shootergame/".$row['shootergame']."\" border=\"0\" />";
} else {
$shootergame = "<img src=\"include/images/profilmod/skillbilder/shootergame/na.png\" border=\"0\" />";
}
if(!empty($row['racegame'])){
$racegame = "<img src=\"include/images/profilmod/skillbilder/racegame/".$row['racegame']."\" border=\"0\" />";
} else {
$racegame = "<img src=\"include/images/profilmod/skillbilder/racegame/na.png\" border=\"0\" />";
}
if(!empty($row['sportgame'])){
$sportgame = "<img src=\"include/images/profilmod/skillbilder/sportgame/".$row['sportgame']."\" border=\"0\" />";
} else {
$sportgame = "<img src=\"include/images/profilmod/skillbilder/sportgame/na.png\" border=\"0\" />";
}
######## Profil erweit. #######
if(!empty($row['board'])){
$board = $row['board'];
} else {
$board = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['prozesor'])){
$prozesor = $row['prozesor'];
} else {
$prozesor = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['ram'])){
$ram = $row['ram'];
} else {
$ram = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['grafik'])){
$grafik = $row['grafik'];
} else {
$grafik = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['tasta'])){
$tasta = $row['tasta'];
} else {
$tasta = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['maus'])){
$maus = $row['maus'];
} else {
$maus = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['system'])){
$system = $row['system'];
} else {
$system = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['sound'])){
$sound = $row['sound'];
} else {
$sound = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['hdd'])){
$hdd = $row['hdd'];
} else {
$hdd = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['monitor'])){
$monitor = $row['monitor'];
} else {
$monitor = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['inet'])){
$inet = $row['inet'];
} else {
$inet = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['headset'])){
$headset = $row['headset'];
} else {
$headset = "<span style=\"font-size:9px\"><i>Keine Angabe</i></span>";
}
if(!empty($row['mich'])){
$mich = $row['mich'];
} else {
$mich = "Sorry - Hier wurden leider keine Angaben gemacht";
}
if(!empty($row['sniperskill'])){
$sniperskill = $row['sniperskill'];
} else {
$sniperskill = "0";
}
if(!empty($row['medicskill'])){
$medicskill = $row['medicskill'];
} else {
$medicskill = "0";
}
if(!empty($row['engineerskill'])){
$engineerskill = $row['engineerskill'];
} else {
$engineerskill = "0";
}
if(!empty($row['reconskill'])){
$reconskill = $row['reconskill'];
} else {
$reconskill = "0";
}
if(!empty($row['teamplayskill'])){
$teamplayskill = $row['teamplayskill'];
} else {
$teamplayskill = "0";
}
if(!empty($row['taktikskill'])){
$taktikskill = $row['taktikskill'];
} else {
$taktikskill = "0";
}
if(!empty($row['komandoskill'])){
$komandoskill = $row['komandoskill'];
} else {
$komandoskill = "0";
}
if(!empty($row['shooter'])){
$shooter = $row['shooter'];
} else {
$shooter = "0";
}
if(!empty($row['race'])){
$race = $row['race'];
} else {
$race = "0";
}
if(!empty($row['sport'])){
$sport = $row['sport'];
} else {
$sport = "0";
}
if(!empty($row['fussball'])){
$fussball = $row['fussball'];
} else {
$fussball = "0";
}
if(!empty($row['poker'])){
$poker = $row['poker'];
} else {
$poker = "0";
}
if(!empty($row['round'])){
$round = $row['round'];
} else {
$round = "0";
}
if(!empty($row['sprint'])){
$sprint = $row['sprint'];
} else {
$sprint = "0";
}
if(!empty($row['zeitrennen'])){
$zeitrennen = $row['zeitrennen'];
} else {
$zeitrennen = "0";
}
if(!empty($row['cops'])){
$cops = $row['cops'];
} else {
$cops = "0";
}
if(!empty($row['crash'])){
$crash = $row['crash'];
} else {
$crash = "0";
}
if(!empty($row['drift'])){
$drift = $row['drift'];
} else {
$drift = "0";
}
if(!empty($row['id_steampro'])){
$id_steampro = $row['id_steampro'];
} else {
$id_steampro = "";
}
if(!empty($row['drag'])){
$drag = $row['drag'];
} else {
$drag = "0";
}
######### ENDE ########
#
##
###
####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,900);
$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
###
##
#
?>
<?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; //Bei höhere Anzahl muss ggf. in der Datenbank die Größe der Felder bzw der Typ geändert werden
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'],
'STEAM' => $steam,
'ID_STEAMPRO' => $id_steampro,
'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);
if(empty($row['steampro']))
{
$steampro = ''; }else{
$steampro = '<img src="include/steamprofile/spimage.php?id='.$row['steampro'].'" />';
}
/*Freunde*/
$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);
/*Freunde Ende*/
$design->footer();
?>
<?php
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Users :: Profil';
$hmenu = $extented_forum_menu.'<a class="smalfont" href="?user">Users</a><b> » </b> Profil'.$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1);
if ( $_SESSION['authright'] <= -1 ) {
if ( empty ($_POST['submit']) ) {
$design->header();
$abf = 'SELECT email,wohnort,homepage,aim,msn,icq,yahoo,avatar,id_steampro,status,staat,gebdatum,sig,opt_pm_popup,opt_pm,opt_mail,geschlecht,spezrank,steampro FROM `prefix_user` WHERE id = "'.$_SESSION['authid'].'"';
$erg = db_query($abf);
if ( db_num_rows($erg) > 0 ) {
$row = db_fetch_assoc($erg);
$tpl = new tpl ('user/profil_edit');
$row['staat'] = '<option></option>'.arliste ( $row['staat'] , get_nationality_array() , $tpl , 'staat' );
$row['geschlecht0'] = ( $row['geschlecht'] < 1 ? 'checked' : '' );
$row['geschlecht1'] = ( $row['geschlecht'] == 1 ? 'checked' : '' );
$row['geschlecht2'] = ( $row['geschlecht'] == 2 ? 'checked' : '' );
if ( $row['status'] == 1 ) { $row['status1'] = 'checked'; $row['status0'] = ''; } else { $row['status1'] = ''; $row['status0'] = 'checked'; }
if ( $row['opt_mail'] == 1 ) { $row['opt_mail1'] = 'checked'; $row['opt_mail0'] = ''; } else { $row['opt_mail1'] = ''; $row['opt_mail0'] = 'checked'; }
if ( $row['opt_pm'] == 1 ) { $row['opt_pm1'] = 'checked'; $row['opt_pm0'] = ''; } else { $row['opt_pm1'] = ''; $row['opt_pm0'] = 'checked'; }
if ( $row['opt_pm_popup'] == 1 ) { $row['opt_pm_popup1'] = 'checked'; $row['opt_pm_popup0'] = ''; } else { $row['opt_pm_popup1'] = ''; $row['opt_pm_popup0'] = 'checked'; }
$row['avatarbild'] = ( file_exists ( $row['avatar'] ) ? '<img src="'.$row['avatar'].'" alt=""><br />' : '' );
$row['Fabreite'] = $allgAr['Fabreite'];
$row['Fahohe'] = $allgAr['Fahohe'];
$row['Fasize'] = $allgAr['Fasize'];
$row['forum_max_sig'] = $allgAr['forum_max_sig'];
$row['uid'] = $_SESSION['authid'];
$row['forum_usergallery'] = $allgAr['forum_usergallery'];
$tpl->set_ar_out($row,0);
if ($allgAr['forum_avatar_upload']) $tpl->out(1);
$tpl->set_ar_out($row,2);
profilefields_change ( $_SESSION['authid'] );
$tpl->out(3);
} else {
$tpl = new tpl ( 'user/login.htm' );
$tpl->set_out('WDLINK','index.php',0);
}
} else { # submit
if ($row['id_steam'] != "") {
$row['readonly'] = "readonly='readonly'";
} else {
$row['readonly'] = "";
}
# change poassword
if ( !empty($_POST['np1']) AND !empty($_POST['np2']) AND !empty($_POST['op'])) {
if ($_POST['np1'] == $_POST['np2']) {
$akpw = db_result(db_query("SELECT pass FROM prefix_user WHERE id = ".$_SESSION['authid']),0);
if ($akpw == md5($_POST['op'])) {
$newpw = md5($_POST['np1']);
db_query("UPDATE prefix_user SET pass = '".$newpw."' WHERE id = ".$_SESSION['authid']);
setcookie(session_und_cookie_name(), $_SESSION['authid'].'='.$newpw, time() + 31104000, "/" );
$fmsg = $lang['passwortchanged'];
} else {
$fmsg = $lang['passwortwrong'];
}
} else {
$fmsg = $lang['passwortnotequal'];
}
}
# avatar speichern START
$avatar_sql_update = '';
if ( !empty ( $_FILES['avatarfile']['name'] ) AND $allgAr['forum_avatar_upload'] ) {
$file_tmpe = $_FILES['avatarfile']['tmp_name'];
$rile_type = ic_mime_type ($_FILES['avatarfile']['tmp_name']);
$file_type = $_FILES['avatarfile']['type'];
$file_size = $_FILES['avatarfile']['size'];
$fmsg = $lang['avatarisnopicture'];
$size = @getimagesize ($file_tmpe);
$endar = array (1 => 'gif', 2 => 'jpg', 3 => 'png');
if ( ($size[2] == 1 OR $size[2] == 2 OR $size[2] == 3) AND $size[0] > 10 AND $size[1] > 10 AND substr ( $file_type , 0 , 6 ) == 'image/' AND substr ( $rile_type , 0 , 6 ) == 'image/' ) {
$endung = $endar[$size[2]];
$breite = $size[0];
$hoehe = $size[1];
$fmsg = $lang['avatarcannotupload'];
if ( $file_size <= $allgAr['Fasize'] AND $breite <= $allgAr['Fabreite'] AND $hoehe <= $allgAr['Fahohe'] ) {
$neuer_name = 'include/images/avatars/'.$_SESSION['authid'].'.'.$endung;
@unlink (db_result(db_query("SELECT avatar FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
move_uploaded_file ( $file_tmpe , $neuer_name );
@chmod($neuer_name, 0777);
$avatar_sql_update = "avatar = '".$neuer_name."',";
$fmsg = $lang['pictureuploaded'];
}
}
} elseif ( isset($_POST['avatarloeschen']) ) {
$fmsg = $lang['picturedelete'];
@unlink (db_result(db_query("SELECT avatar FROM prefix_user WHERE id = ".$_SESSION['authid']),0));
$avatar_sql_update = "avatar = '',";
}
# avatar speichern ENDE
# email aendern
if ($_POST['email'] != $_POST['aemail']) {
$id = $_SESSION['authid'].'||'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),3)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['changedthemail'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], $lang['mail'].' '.$lang['changed'], $text );
$fmsg = $lang['pleaseconfirmmail'];
}
#
#remove account
if (isset($_POST['removeaccount'])) {
$id = $_SESSION['authid'].'-remove-'.md5 (uniqid (rand()));
db_query("INSERT INTO prefix_usercheck (`check`,email,datime,ak)
VALUES ('".$id."','".escape($_POST['email'],'string')."',NOW(),5)");
$page = $_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"];
$text = $lang['removeconfirm'] . sprintf ($lang['registconfirmlink'], $page, $id );
icmail ($_POST['email'], html_entity_decode($lang['removeaccount']), $text );
$fmsg = $lang['pleaseconfirmremove'];
}
#remove account
# statische felder speichern
db_query("UPDATE prefix_user
SET
homepage = '".get_homepage(escape($_POST['homepage'], 'string'))."',
wohnort = '".escape($_POST['wohnort'], 'string')."',
icq = '".escape($_POST['icq'], 'string')."',
msn = '".escape($_POST['msn'], 'string')."',
yahoo = '".escape($_POST['yahoo'], 'string')."',
".$avatar_sql_update."
aim = '".escape($_POST['aim'], 'string')."',
steampro = '".escape($_POST['steampro'], 'string')."',
id_steampro = '".escape($_POST['id_steampro'], 'string')."',
staat = '".escape($_POST['staat'], 'string')."',
geschlecht = '".escape($_POST['geschlecht'], 'string')."',
status = '".escape($_POST['status'], 'string')."',
opt_mail = '".escape($_POST['opt_mail'], 'string')."',
opt_pm = '".escape($_POST['opt_pm'], 'string')."',
opt_pm_popup = '".escape($_POST['opt_pm_popup'], 'string')."',
gebdatum = '".get_datum(escape($_POST['gebdatum'], 'string'))."',
sig = '".substr(escape($_POST['sig'], 'string'),0,$allgAr['forum_max_sig'])."'
WHERE id = ".$_SESSION['authid']
);
# change other profil fields
profilefields_change_save ( $_SESSION['authid'] );
$design->header();
# definie and print msg
$fmsg = ( isset($fmsg) ? $fmsg : $lang['changesuccessful'] );
wd('?user-8' , $fmsg , 3 );
}
} else {
$tpl = new tpl ( 'user/login' );
$tpl->set_out('WDLINK', '?user-8', 0);
}
$design->footer();
?>
Ich muss dazu sagen ich habs nicht getestet. Obs so funkt musst voher halt nen backup machen.
Und wenn nicht klappen sollte kannst du mich ja bei Steam adden bin wahrscheinlich heut abend dann on wenn nicht morgen aufjedenfall
Steam:
player_von_47
Zuletzt modifiziert von Sunshine Live am 07.10.2012 - 01:21:30
Zitat geschrieben von BigEasy
