Sooo
/templates/user/profil_edit.htm
<form action="index.php?user-profil" method="POST" enctype="multipart/form-data">
<fieldset>
<legend>Persönliche Daten ändern</legend>
<br />
<label style="float:left; width:35%;">{_lang_mail}</label><input style="margin-bottom:2px;" name="email" value="{email}" /><input type="hidden" name="aemail" value="{email}" /><font class="smalfont">{_lang_mustbeentered}</font><br />
<label style="float:left; width:35%;">{_lang_homepage}</label><input style="margin-bottom:2px;" name="homepage" value="{homepage}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_hometown}</label><input style="margin-bottom:2px;" name="wohnort" value="{wohnort}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_icq}</label><input style="margin-bottom:2px;" name="icq" value="{icq}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_msn}</label><input style="margin-bottom:2px;" name="msn" value="{msn}" /><br style="clear:both;" />
<label style="float:left; width:35%;">X-Fire Name</label><input style="margin-bottom:2px;" name="xfire" value="{xfire}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_yahoo}</label><input style="margin-bottom:2px;" name="yahoo" value="{yahoo}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_aim}</label><input style="margin-bottom:2px;" name="aim" value="{aim}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_birthday}</label><input style="margin-bottom:2px;" name="gebdatum" value="{gebdatum}" /><font class="smalfont">{_lang_dateformat}</font><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_state}</label><select style="margin-bottom:2px;" name="staat">{_list_staat@<option%1 value="%2">%3</option>}</select><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_sex}</label><input style="margin-bottom:2px;" type="radio" value="1" id="geschlecht1" name="geschlecht" {geschlecht1} /><label for="geschlecht1"> {_lang_male}</label>, <input id="geschlecht2" type="radio" value="2" name="geschlecht" {geschlecht2} /><label for="geschlecht2"> {_lang_female}</label>, <input id="geschlecht0" type="radio" value="0" name="geschlecht" {geschlecht0} /><label for="geschlecht0"> {_lang_itdoesntmatter}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_status}</label><input id="status_aktiv" type="radio" value="1" name="status" {status1} /><label for="status_aktiv"> {_lang_active}</label>, <input id="status_inaktiv" type="radio" value="0" name="status" {status0} /><label for="status_inaktiv"> {_lang_inactive}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_mails}<span class="smalfont"> {_lang_fromotherusers}?</span></label><input id="opt_mail1" type="radio" value="1" name="opt_mail" {opt_mail1} /><label for="opt_mail1"> {_lang_yes}</label>, <input id="opt_mail0" type="radio" value="0" name="opt_mail" {opt_mail0} /><label for="opt_mail0"> {_lang_no}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_privatemessages}<span class="smalfont"> {_lang_fromotherusers}?</span></label><input id="opt_pm1" type="radio" value="1" name="opt_pm" {opt_pm1} /><label for="opt_pm1"> {_lang_yes}</label>, <input id="opt_pm0" type="radio" value="0" name="opt_pm" {opt_pm0} /><label for="opt_pm0"> {_lang_no}</label><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_privatemessages}<span class="smalfont"> {_lang_popupbynewmsg}?</span></label><input id="opt_pm_popup1" type="radio" value="1" name="opt_pm_popup" {opt_pm_popup1} /><label for="opt_pm_popup1"> {_lang_yes}</label>, <input id="opt_pm_popup0" type="radio" value="0" name="opt_pm_popup" {opt_pm_popup0} /><label for="opt_pm_popup0"> {_lang_no}</label><br style="fclear:both;" /><br />
<label style="float:left; width:35%;">{_lang_game}</label><input style="margin-bottom:2px;" name="game" value="{game}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_spielerfahrungen}</label><input style="margin-bottom:2px;" name="spielerfahrungen" value="{spielerfahrungen}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_clan}</label><input style="margin-bottom:2px;" name="clan" value="{clan}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_map}</label><input style="margin-bottom:2px;" name="map" value="{map}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_waffe}</label><input style="margin-bottom:2px;" name="waffe" value="{waffe}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_essen}</label><input style="margin-bottom:2px;" name="essen" value="{essen}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_trinken}</label><input style="margin-bottom:2px;" name="trinken" value="{trinken}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_film}</label><input style="margin-bottom:2px;" name="film" value="{film}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_musik}</label><input style="margin-bottom:2px;" name="musik" value="{musik}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_sport}</label><input style="margin-bottom:2px;" name="sport" value="{sport}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_cpu}</label><input style="margin-bottom:2px;" name="cpu" value="{cpu}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_mainboard}</label><input style="margin-bottom:2px;" name="mainboard" value="{mainboard}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_ram}</label><input style="margin-bottom:2px;" name="ram" value="{ram}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_monitor}</label><input style="margin-bottom:2px;" name="monitor" value="{monitor}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_grafikkarte}</label><input style="margin-bottom:2px;" name="grafikkarte" value="{grafikkarte}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_soundkarte}</label><input style="margin-bottom:2px;" name="soundkarte" value="{soundkarte}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_festplatte}</label><input style="margin-bottom:2px;" name="festplatte" value="{festplatte}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_i_net_verbindung}</label><input style="margin-bottom:2px;" name="i_net_verbindung" value="{i_net_verbindung}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_tastatur}</label><input style="margin-bottom:2px;" name="tastatur" value="{tastatur}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_maus}</label><input style="margin-bottom:2px;" name="maus" value="{maus}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_jappy}</label><input style="margin-bottom:2px;" name="jappy" value="{jappy}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_facebook}</label><input style="margin-bottom:2px;" name="facebook" value="{facebook}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_wkw}</label><input style="margin-bottom:2px;" name="wkw" value="{wkw}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_studivz}</label><input style="margin-bottom:2px;" name="studivz" value="{studivz}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_myspace}</label><input style="margin-bottom:2px;" name="myspace" value="{myspace}" /><br style="clear:both;" />
<label style="float:left; width:35%;">{_lang_youtube}</label><input style="margin-bottom:2px;" name="youtube" value="{youtube}" /><br style="clear:both;" />
{_if_{forum_usergallery}=='1'}<div align="center">
<a href="index.php?user-usergallery-{uid}">Usergallery</a> <a href="index.php?user-remove"/></a>
</div>{/_endif}<br />
{EXPLODE}
<fieldset>
<legend>{_lang_removeaccount}</legend>
<label style="float:left; width:35%;"> </label><input type="checkbox" value="yes" name="removeaccount" /> {_lang_delete}? <font class="smalfont">{_lang_mustbeentered}</font>
</fieldset>
<fieldset>
<legend>{_lang_avatar}</legend>
<label style="float:left; width:35%;"> </label>{avatarbild}<input type="checkbox" value="yes" name="avatarloeschen" /> {_lang_delete}?<br /><br />
<label style="float:left; width:35%;"> </label><input style="margin-bottom:2px;" type="file" name="avatarfile" /><br /><font class="smalfont"><br />{_lang_criterions}: {_lang_maxwidth} {Fabreite}px, {_lang_maxheight} {Fahohe}px {_lang_and} max size {Fasize} bytes. {_lang_otherwisenoaction}.</font><br />
</fieldset>
<br />
{EXPLODE}
<fieldset>
<legend>{_lang_signature}</legend>
<label style="float:left; width:35%;"><font class="smalfont">{_lang_max} {forum_max_sig} {_lang_signs}.</font></label><textarea style="margin-bottom:2px;" cols="60" rows="2" name="sig">{sig}</textarea><br />
</fieldset>
<br />
<fieldset>
<legend>{_lang_editpassword}</legend>
<br />
<label style="float:left; width:35%;">{_lang_current}</label><input style="margin-bottom:2px;" type="password" name="op" maxlength="20"><br />
<label style="float:left; width:35%;">{_lang_new}</label><input style="margin-bottom:2px;" type="password" name="np1" maxlength="20"><br />
<label style="float:left; width:35%;">{_lang_repeat}</label><input style="margin-bottom:2px;" type="password" name="np2" maxlength="20"><br />
</fieldset>
<br />
<fieldset>
<br />
{EXPLODE}
</fieldset>
<br />
<div align="center">
<input style="margin-bottom:2px;" type="submit" value="{_lang_send2}" name="submit">
</div>
</fieldset>
</form>
/templates/user/userdetails.htm
<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td valign="top" width="60%"><table border="0" cellpadding="2" cellspacing="0" width="80%">
<tbody>
<tr>
<td colspan="2"><b> • <u>Persönliche Informationen</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="35%"><img src="include/images/userdetails/user.png" class="gradualfader" border="0" height="16" width="16" /> Nickname:</td>
<td width="65%"><strong>{NAME}</strong></td>
</tr>
<tr>
<td><img src="include/images/userdetails/status.png" class="gradualfader" border="0" height="16" width="16"> Status:</td>
<td>{STATUS2}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/titel.png" class="gradualfader" border="0" height="16" width="16"> Benutzertitel:</td>
<td>{USERTITEL}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/email.png" class="gradualfader" border="0" height="16" width="16"> Kontakt:</td>
<td>{EMAIL}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/homepage.png" class="gradualfader" border="0" height="16" width="16"> Homepage:</td>
<td>{HOMEPAGE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/icq.png" class="gradualfader" border="0" height="16" width="16"> ICQ:</td>
<td>{ICQ}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/xfire.png" class="gradualfader" border="0" height="16" width="16"> {XFIREt}</td>
<td>{XFIRE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/sex.png" class="gradualfader" border="0" height="16" width="16"> Geschlecht:</td>
<td>{GESCHLECHT}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/gebdatum.png" class="gradualfader" border="0" height="16" width="16" />Geburstag:</td>
<td>{GEBDATUM} {ALTER}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/sternzeichen.png" class="gradualfader" border="0" height="16" width="16" />Sternzeichen</td>
<td>{STERNZEICHEN}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/land.png" class="gradualfader" border="0" height="16" width="16"> Land:</td>
<td>{WOHNORT} {STAAT}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/reg.png" class="gradualfader" border="0" height="16" width="16"> Dabei seit:</td>
<td>{JOINED}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/letzteakt.png" class="gradualfader" border="0" height="16" width="16"> Letzte Aktivität:</td>
<td>{LASTAK} Uhr</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td><b><img src="include/images/userdetails/signatur.png" class="gradualfader" border="0" height="16" width="16"><u>Signatur</u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td class="gradualfader">{SIGNATUR}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="80%">
<tbody>
<tr>
<td colspan="2"><b> • <u>Game / Sonstiges</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="23%">• Favorit</td>
</tr>
<tr>
<td><img src="include/images/userdetails/games.png" class="gradualfader" border="0" height="16" width="16"> Game:</td>
<td width="77%">{GAME}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/fadenkreuz.gif" class="gradualfader" border="0" height="16" width="16"> Skill:</td>
<td>{SPIELERFAHRUNG}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/clan.png" class="gradualfader" border="0" height="16" width="16"> Clan:</td>
<td>{CLAN}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/map.gif" class="gradualfader" border="0" height="16" width="16"> Map:</td>
<td>{MAP}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/waffe.png" class="gradualfader" border="0" height="16" width="16"> Waffe:</td>
<td>{WAFFE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/essen.png" class="gradualfader" border="0" height="16" width="16"> Essen:</td>
<td>{ESSEN}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/trinken.png" class="gradualfader" border="0" height="16" width="16"> Trinken:</td>
<td>{TRINKEN}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/film.png" class="gradualfader" border="0" height="16" width="16"> Film:</td>
<td>{FILM}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/musik.png" class="gradualfader" border="0" height="16" width="16"> Musik:</td>
<td>{MUSIK}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/sport.png" class="gradualfader" border="0" height="16" width="16"> Sport:</td>
<td>{SPORT}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="30%">
<tbody>
<tr>
<td align="left" valign="middle" colspan="2"><b> • <u>Community</u></b></td>
</tr>
<tr>
<td><img src="include/images/userdetails/jappy.png" class="gradualfader" border="0" height="16" width="16"> Jappy:</td>
<td>{JAPPY}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/facebook.png" class="gradualfader" border="0" height="16" width="16"> Facebook:</td>
<td>{FACEBOOK}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/wkw.png" class="gradualfader" border="0" height="16" width="16"> WkW:</td>
<td>{WKW}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/studivz.png" class="gradualfader" border="0" height="16" width="16"> Studivz:</td>
<td>{STUDIVZ}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/myspace.png" class="gradualfader" border="0" height="16" width="16"> MySpace:</td>
<td>{MYSPACE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/youtube.png" class="gradualfader" border="0" height="16" width="16"> YouTube:</td>
<td>{YOUTUBE}</td>
</tr>
</tbody>
</table></td>
<td width="0%"> </td>
<td valign="top" width="40%"><table cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td><b> • <u>Benutzerbild:</u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td align="center" class="gradualfader" height="215">{AVATA}</td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td colspan="2"><b> • <u>Specials</u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td width="37%">IM Messanger:</td>
<td width="63%"><a href="javascript:void(0)" onclick="javascript:chatWith({UID},'{NAME}')">IM Fenster öffnen</a></td>
</tr>
<tr>
<td width="37%">Usergallerie:</td>
<td width="63%">{GALLERIE_EINTRAEGE} (<a href="index.php?user-usergallery-{UID}">ansehen)</a></td>
</tr>
<tr>
<td width="37%">Gästebuch:</td>
<td width="63%"><a href="index.php?user-usergb-view-{UID}">Klicke hier!</a></td>
</tr>
<tr>
<td width="37%">Private Mail:</td>
<td width="63%"><a href="index.php?forum-privmsg-new=0&empfid={UID}">schreiben</a></td>
</tr>
</tbody>
</table>
<br>
<table width="100%">
<tbody>
<tr>
<td><b> • <u>Letzte Besucher </u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr bgcolor="">
<td><table cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td>{LASTUSER}</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table width="100%">
<tbody>
<tr>
<td><b> • <u>Letzte Besucher </u></b></td>
</tr>
<tr>
<td></td>
</tr>
<tr bgcolor="">
<td><table cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td height="25" width="27%">Forumtopics:</td>
<td width="73%" height="25">{FORUMTOPICS}</td>
</tr>
<tr>
<td height="25" width="27%">Newstopics:</td>
<td width="73%" height="25">{NEWSTOPICS}</td>
</tr>
<tr>
<td height="25" width="27%">Newsposts:</td>
<td width="73%" height="25">{NEWSPOSTS}</td>
</tr>
<tr>
<td height="25" width="27%">Forumposts:</td>
<td width="73%" height="25">{POSTS}</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br>
<table cellpadding="2" cellspacing="0" width="50%">
<tbody>
<tr>
<td align="left" valign="middle" colspan="2"><b> • <u>Computer Technik </u></b></td>
</tr>
<tr>
<td colspan="2"></td>
</tr>
<tr>
<td><img src="include/images/userdetails/cpu.png" class="gradualfader" border="0" height="16" width="16"> Cpu:</td>
<td>{CPU}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/mainboard.png" class="gradualfader" border="0" height="16" width="16"> Mainboard:</td>
<td>{MAINBOARD}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/arbeitsspeicher.png" class="gradualfader" border="0" height="16" width="16"> Ram:</td>
<td>{RAM}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/monitor.png" class="gradualfader" border="0" height="16" width="16"> Monitor:</td>
<td>{MONITOR}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/grafik.png" class="gradualfader" border="0" height="16" width="16"> Grafikkarte:</td>
<td>{GRAFIKKARTE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/soundkarte.png" class="gradualfader" border="0" height="16" width="16"> Soundkarte:</td>
<td>{SOUNDKARTE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/festplatte.png" class="gradualfader" border="0" height="16" width="16"> Festplatte:</td>
<td>{FESTPLATTE}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/modem.png" class="gradualfader" border="0" height="16" width="16">Verbindung:</td>
<td>{I_NET_VERBINDUNG}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/tastatur.png" class="gradualfader" border="0" height="16" width="16"> Tastatur:</td>
<td>{TASTATUR}</td>
</tr>
<tr>
<td><img src="include/images/userdetails/maus.png" class="gradualfader" border="0" height="16" width="16"> Maus:</td>
<td>{MAUS}</td>
</tr>
</tbody>
</table></td>
</tr>
</tbody>
</table>
<br />
<table width="100%" cellpadding="3" cellspacing="1" class="border">
<tr class="Chead">
<center> <th colspan="2"><center>Auszeichnungen von {NAME}</center></b></th></tr><tr>
</tr></table>
<table width="100%" cellpadding="3" cellspacing="1">
<th colspan="2" class="gradualfader" bgcolor="#F2F2F2">{AWARDS}</b></th>
</table>
<br />
/contents/user.php
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
# menu
require_once('include/contents/forum/menu.php');
switch($menu->get(1)) {
default : $userDatei = 'memb_list'; break;
case 'regist' : case 1 : $userDatei = 'regist'; break;
case 'usergb' : case 5 : $userDatei = 'user_gb'; break;
case 'confirm' : $userDatei = 'confirm'; break;
case 'login' : case 2 : $userDatei = 'login'; break;
case 'logout' : case 3 : $userDatei = 'logout'; break;
case 'mail' : case 4 : $userDatei = 'mail'; break;
case 'usergallery' : $userDatei = 'usergallery'; break;
case 'details' : case 6 : $userDatei = 'user_details'; break;
case 'profil' : case 8 : $userDatei = 'profil_edit'; break;
case 'remind' : case 13 : $userDatei = 'password_reminder'; break;
case 'xfire' : case 14 : $userDatei = 'xfire'; break;
}
require_once('include/contents/user/'.$userDatei.'.php');
?>
contents/user/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['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['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 = "";
}
$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 ) );
if(empty($row['xfire']))
{$xfire_online = ''; $xfire_onlinet = '';}else{
if($allgAr['xfire_online'] == '1'){ $xfire_online = '<img src="http://de.miniprofile.xfire.com/bg/sh/type/4/'.$row['xfire'].'.png" />'; }else{ $xfire_online = ''; }
if($allgAr['xfire_online'] == '1'){ $xfire_onlinet = 'X-Fire'; }else{ $xfire_onlinet = ''; }
}
$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= "";
}
?>
contents/user/user_details.php
<?php
# Copyright by: Manuel Staechele
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
$uid = $menu->get(2);
#Award Ausgabe
$awards = ''; $ax = 0;
$sqlA = db_query("SELECT a.platz, a.text, a.wofur, a.team, a.bild, DATE_FORMAT(a.`time`, '%d.%m.%Y') AS time FROM `prefix_awards` a INNER JOIN prefix_user b ON a.team = b.name WHERE b.id = ".$uid." ORDER BY `time` ASC");
while($rowA = db_fetch_assoc($sqlA))
{
$ax++; if ($ax == 8) {$awards .= "<br>"; $ax = 0;}
$awards .= (!empty($rowA['bild']) ? '<img style="padding:1px;border:0px;" src="'.$rowA['bild'].'" alt="'.$rowA['wofur'].'" title="'.$rowA['wofur'].'"/>' : $rowA['wofur']);
}
$awards = '<b><b><br><div style="text-align:center;">'.$awards.'</div>';
$lastbes_anz = 5; //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");
}
include('user_infos.php');
$ar = array (
'UID' => $uid,
'NAME' => $row['name'],
'JOINED' => date('d.m.Y',$row['regist']),
'LASTAK' => date('d.m.Y - H:i',$row['llogin']),
'POSTS' => $row['posts'],
'postpday' => $postpday,
'RANG' => userrang ($row['posts'],$uid),
'AVATA' => $avatar,
'LASTUSER' => last_user($uid),
'STATUS2' => $online,
'USERTITEL' => $usertitel,
'EMAIL' => $email,
'HOMEPAGE' => $homepage,
'GESCHLECHT' => $geschlecht,
'GEBDATUM' => $gebdatum,
'ALTER' => $alter,
'WOHNORT' => $wohnort,
'FORUMTOPICS' => $row4['forumtopics'],
'NEWSTOPICS' => $row5['newstopics'],
'NEWSPOSTS' => $row6['newsposts'],
'FORUMPOSTS' => $row7['forumposts'],
'SIGNATUR' => bbcode($row['sig']),
'STAAT' => $staat,
'UID' => $uid,
'STERNZEICHEN' => $sternzeichen,
'GB_EINTRAEGE' => $gb_eintraege,
'GALLERIE_EINTRAEGE' => $gallery_eintraege,
'ICQ' => $icq,
'GAME' => $game,
'SPIELERFAHRUNG' => $spielerfahrungen,
'CLAN' => $clan,
'MAP' => $map,
'WAFFE' => $waffe,
'ESSEN' => $essen,
'TRINKEN' => $trinken,
'FILM' => $film,
'MUSIK' => $musik,
'SPORT' => $sport,
'CPU' => $cpu,
'MAINBOARD' => $mainboard,
'RAM' => $ram,
'MONITOR' => $monitor,
'GRAFIKKARTE' => $grafikkarte,
'SOUNDKARTE' => $soundkarte,
'FESTPLATTE' => $festplatte,
'I_NET_VERBINDUNG' => $i_net_verbindung,
'TASTATUR' => $tastatur,
'MAUS' => $maus,
'JAPPY' => $jappy,
'FACEBOOK' => $facebook,
'WKW' => $wkw,
'XFIRE' => $xfire_online,
'XFIREt' => $xfire_onlinet,
'STUDIVZ' => $studivz,
'MYSPACE' => $myspace,
'YOUTUBE' => $youtube,
'AWARDS' => $awards,
);
$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);
$design->footer();
?>
sollte so gehn
Zuletzt modifiziert von Sunshine Live am 13.11.2010 - 18:25:24