Forenprofil in normales Profil einbauen...

vollkrassandi · 29 August 2003, 13:25:30

Liebe, liebe Community. Ich habe ein riesiges Problem und brauche dringend eure Hilfe. Ich habe ein PHPNuke-System und ein 4nForum (basierend auf XFORUM). Nun möchte ich in das Profil (Your_Account) das Profil aus dem Forum (file=member&action=viewpro) in einen OpenTable()-CloseTable()-Bereich einbauen.

Wie kann man das Anstellen

Hier der Profil-Code aus dem 4nForum:

-------schnipp-------------

if($action == "viewpro")
{

if(!$member) { echo _NOMEMBER; }
else
{
$query = mysql_query("SELECT * FROM $table_members WHERE username='$member'") or die(mysql_error());
$memberinfo = mysql_fetch_array($query);

$daysreg = (time() - $memberinfo[regdate]) / (24*60*60);
$ppd = $memberinfo[postnum] / $daysreg;
$ppd = round($ppd, 2);

$memberinfo[regdate] = gmdate("n/j/y",$memberinfo[regdate]);
$memberinfo[site] = str_replace("http://", "", $memberinfo[site]);
$memberinfo[site] = "http://$memberinfo[site]";
if($memberinfo[site] != "http://") { $site = "$memberinfo[site]"; }

if($memberinfo[email] != "" && $memberinfo[showemail] == "yes") { $email = $memberinfo[email]; }

if($whosonlinestatus == "on") // si le qui whosonline est activé
{
$query = mysql_query("SELECT * FROM $table_whosonline WHERE username='$member'");
$onlineinfo = mysql_fetch_array($query);
if ($onlineinfo[username] == $member) { $onlinestatus = _TEXTONLINE; }
else { $onlinestatus = _TEXTOFFLINE; }
}

$lastvisitdate = gmdate("$dateformat",$memberinfo[lastvisit] + ($timeoffset * 3600));
$lastvisittime = gmdate("$timecode",$memberinfo[lastvisit] + ($timeoffset * 3600));
$lastmembervisittext = "$lastvisitdate "._TEXTAT." $lastvisittime";

$query = mysql_query("SELECT COUNT(pid) as nbsites FROM $table_posts") or die(mysql_error());
$row = mysql_fetch_array($query);
$posts = $row[nbsites];
$query = mysql_query("SELECT COUNT(tid) as nbsites FROM $table_threads") or die(mysql_error());
$row = mysql_fetch_array($query);
$threads = $row[nbsites];
$posttot = $threads+$posts;
if($posttot == 0) { $percent = "0"; }
else
{
$percent = $memberinfo[postnum]*100/$posttot;
$percent = round($percent, 2);
}

$memberinfo[bio] = nl2br($memberinfo[bio]);
$encodeuser = rawurlencode($memberinfo[username]);

$query = mysql_query("SELECT dateline, tid FROM $table_posts WHERE author='$memberinfo[username]' ORDER BY dateline DESC LIMIT 0, 1") or die(mysql_error());
$lastrep = mysql_fetch_array($query);

$query = mysql_query("SELECT dateline, subject, tid FROM $table_threads WHERE author='$memberinfo[username]' ORDER BY dateline DESC LIMIT 0, 1") or die(mysql_error());
$lasttop = mysql_fetch_array($query);

if($lastrep[dateline] > $lasttop[dateline])
{
$ltoptime = $lastrep[dateline];
$query = mysql_query("SELECT subject FROM $table_threads WHERE tid='$lastrep[tid]'") or die(mysql_error());
$ltop = mysql_fetch_array($query);
$lasttopsub = $ltop[subject];
$lttid = $lastrep[tid];
}
else
{
$ltoptime = $lasttop[dateline];
$lasttopsub = $lasttop[subject];
$lttid = $lasttop[tid];
}

$lasttopdate = gmdate("$dateformat", $ltoptime + ($timeoffset * 3600));
$lasttoptime = gmdate("$timecode", $ltoptime + ($timeoffset * 3600));
$lasttopic = "<a href=\""._BASEMOD."viewthread&tid=$lttid\">$lasttopsub</a> "._LASTREPLY1." $lasttopdate "._TEXTAT." $lasttoptime";
$showtitle = $memberinfo[status];
$queryrank = mysql_query("SELECT * FROM $table_ranks") or die(mysql_error());
while($rank = mysql_fetch_array($queryrank))
{
if($memberinfo[postnum] >= $rank[posts])
{
$allowavatars = $rank[allowavatars];
$showtitle = $rank[title];
$stars = "";
for($i = 0; $i < $rank[stars]; $i++) { $stars .= "<img src=\""._BASEMODIMG."/star.gif\">"; }

if($rank[avatarrank] != "") { $avarank = $rank[avatarrank]; }
}
else
{
$showtitle = $showtitle;
$stars = $stars;
}
}

?>
<table cellspacing="0" cellpadding="0" border="0" width="<?=$tablewidth?>" align="center">
<tr>
<td bgcolor="<?=$bordercolor?>">

<table border="0" cellspacing="<?=$borderwidth?>" cellpadding="<?=$tablespace?>" width="100%">
<tr>
<td colspan="2" class="header"><?=_TEXTPROFOR?> <?=$member?></td>
</tr>
<tr>
<td bgcolor="<?=$altbg1?>" width="22%" class="tablerow"><?=_TEXTUSERNAME?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[username]?> </td>
</tr>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTREGISTERED?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[regdate]?> (<?=$ppd?> <?=_TEXTMESPERDAY?>)</td>
</tr>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTPOSTS?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[postnum]?> (<?=$percent?>% <?=_TEXTOFTOTPOSTS?>)</td>
</tr>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTSTATUS?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[status]?></td>
</tr>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTSTATUSXF?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$showtitle?> <?=$stars?></td>
</tr>
<?
if($whosonlinestatus == "on")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_ONSTATUS?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$onlinestatus?></td>
</tr>
<? }

if($memberinfo[lastvisit] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" valign="top" class="tablerow"><?=_LASTACTIVE?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$lastmembervisittext?></td>
</tr>
<? }

if($memberinfo[postnum] != "0")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" valign="top" class="tablerow"><?=_LASTPOSTIN?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$lasttopic?></td>
</tr>
<? }

if($memberinfo[email] != "" && $memberinfo[showemail] == "yes")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTEMAIL?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><a href="mailto:<?=$email?>"><?=$email?></a></td>
</tr>
<? }

if($memberinfo[site] != "http://")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTSITE?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><a href="<?=$site?>"><?=$site?></a></td>
</tr>
<? }

if($memberinfo[aim] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTAIM?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[aim]?></td>
</tr>
<? }

if($memberinfo[icq] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTICQ?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[icq]?></td>
</tr>
<? }

if($memberinfo[yahoo] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTYAHOO?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[yahoo]?></td>
</tr>
<? }

if($memberinfo[msn] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTMSN?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[msn]?></td>
</tr>
<? }

if($memberinfo[location] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTLOCATION?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[location]?></td>
</tr>
<? }

if($memberinfo[bday] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" class="tablerow"><?=_TEXTBDAY?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[bday]?></td>
</tr>
<? }

if($memberinfo[bio] != "")
{
?>
<tr>
<td bgcolor="<?=$altbg1?>" valign="top" class="tablerow"><?=_TEXTBIO?></td>
<td bgcolor="<?=$altbg2?>" class="tablerow"><?=$memberinfo[bio]?></td>
</tr>
<? }

?>
<tr>
<td bgcolor="<?=$altbg1?>" colspan="2" class="tablerow"><?=_SEARCHUSERMSG?></td>
</tr>
</table>
</td></tr></table>
<?
}
}

---schnapp---

und der soll in das Profil von PHPNuke eingebaut werden:

---schnipp---

OpenTable();
CloseTable();

----schnapp----

Wenn mir einer helfen kann würde ich vor Freude den Boden küssen ;)
Bitte um genaue erklräung. Was muss ich abändern, was muss ich übernehmen. Bitte sichere Möglichkeiten und keine zu groben Vermutungen ...

Ich danke euch !!!

[Editiert am 29/8/2003 von vollkrassandi]