userdetails.html:
<!--<a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a>
<br />
<br />
<table width="100%" cellpadding="3" cellspacing="1" class="border">
<tr class="Chead">
<th colspan="3"><b>{_lang_detailsfrom} {NAME}</b></th>
</tr><tr>
<td class="Cmite" width="30%">{_lang_nickname}</td>
<td class="Cnorm" width="40%">{NAME}</td>
<td class="Cnorm" width="30%" rowspan="{rowspan}" valign="top" align="center">
{AVATA}
<br /><br />
<font class="smalfont">{RANG}</font>
</td>
</tr><tr>
<td class="Cmite">{_lang_regsince}</td>
<td class="Cnorm">{JOINED}</td>
</tr><tr>
<td class="Cmite">{_lang_lastactivity}</td>
<td class="Cnorm">{LASTAK}</td>
</tr><tr>
<td class="Cmite">{_lang_posts2}</td>
<td class="Cnorm">{POSTS}, {_lang_perday}: {postpday}</td>
</tr>
{profilefields}
</table>
<br />
<a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a>-->
<br />
<script language="javascript" type="text/javascript">
function details()
{
if(document.getElementById('more_details').style.display=='block'){
document.getElementById('more_details').style.display='none';
}else{
document.getElementById('more_details').style.display='block';
}
}
</script>
<table border="0" width="100%">
<tr>
<td colspan="2" style="padding-left:8px;" width="300" height="25"><u><b>• Personal Info</b></u></td>
<td colspan="2" style="padding-left:8px;" width="270" height="25"><u><b>• Userpic</b></u></td>
</tr><tr>
<td width="15%" height="25">Nickname</td>
<td height="25">{NAME}</td>
<td colspan="2" valign="top" align="center" rowspan="13" style="vertical-align:middle">{AVATA}</td>
</tr><tr>
<td height="25">Status</td>
<td height="25">{ONLINE}</td>
</tr><tr>
<td height="25">Titel</td>
<td height="25">{USERTITEL}</td>
</tr><tr>
<td height="25">Kontakt</td>
<td height="25">{EMAIL}</td>
</tr><tr>
<td height="25">ICQ</td>
<td height="25">{ICQ}</td>
</tr><tr>
<td height="25">Homepage</td>
<td height="25">{HOMEPAGE}</td>
</tr><tr>
<td height="25">Geschlecht</td>
<td height="25">{GESCHLECHT}</td>
</tr><tr>
<td height="25">Geburtstag</td>
<td height="25">{GEBDATUM} {ALTER}</td>
</tr><tr>
<td height="25">Sternzeichen</td>
<td height="25">{STERNZEICHEN}</td>
</tr><tr>
<td height="25">Wohnort</td>
<td height="25">{WOHNORT} {STAAT}</td>
</tr><tr>
<td height="25">Registriert</td>
<td height="25">{JOINED}</td>
</tr><tr>
<td height="25">Last Login</td>
<td height="25">{LASTAK} Uhr</td>
</tr><tr><td colspan="4"> </td></tr><tr>
<td colspan="2" style="padding-left:8px;" width="320" height="25"><u><b>• More Infos</b></u></td>
<td colspan="2" style="padding-left:8px;" width="250" height="25"><u><b>• Statistic</b></u></td>
</tr><tr>
<td height="25">Usergallerie</td>
<td height="25">{GALLERIE_EINTRAEGE} (<a href="index.php?user-usergallery-{UID}">ansehen)</a></td>
<td height="25" width="20%">Forumtopics</td>
<td height="25">{FORUMTOPICS}</td>
</tr><tr>
<td height="25">Gästebuch</td>
<td height="25">{GB_EINTRAEGE}</td>
<td height="25">Newstopics</td>
<td height="25">{NEWSTOPICS}</td>
</tr><tr>
<td height="25">Private Mail</td>
<td height="25"><a href="index.php?forum-privmsg-new=0&empfid={UID}">schreiben</a></td>
<td height="25">Newsposts</td>
<td height="25">{NEWSPOSTS}</td>
</tr><tr>
<td height="25">More Details</td>
<td height="25"><div id="nav"><a href="javascript:onClick=details()">anzeigen</a></div></td>
<td height="25">Forumposts</td>
<td height="25">{POSTS}</td>
</tr><tr><td colspan="4"> </td></tr><tr>
<td colspan="4" style="padding-left:8px;" width="320" height="25"><u><b>• Signatur</b></u></td>
</tr><tr>
<td height="25" colspan="4" valign="top">{SIGNATUR}</td>
</tr><tr><td colspan="4"> </td></tr><tr>
<td colspan="4"><div id="more_details" style="display:none"><table>{profilefields}</table></div></td>
</tr>
</table>
<br />
<a href="javascript:history.back(1)"><b>«</b> {_lang_back}</a>
user_infos.php:
<?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'])){
$icq = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=".$row['icq']."\" target=\"_blank\"><img src=\"http://status.icq.com/online.gif?icq=".$row['icq']."&img=5\" border=\"0\"></a>";
}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['staat'])){
$staat = "<img src=\"include/images/flags/".$row['staat']."\" border=\"0\" />";
} else {
$staat = "";
}
$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/male.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";
}
?>
mfg slavka