[] How I can do, that the Username is show near Lastpost Date in the Active Topics table?
Like this:
Posted on
15/04/2005 18:59
Letzte Antwort: 19/04/2005 10:25 ( USERNAME ) [/]
I do it like this:
:::::::::::::::::::::::::
::- File dosearch.php -::
:::::::::::::::::::::::::
Zeile 703: $inlistuserid = "";
Zeile 736: $searchrow[$i]['UserLastPostID'] = $LastPosterId;
if ($i == 0) $inlistuserid .= "$LastPosterId";
else $inlistuserid .= ",$LastPosterId";
Zeile 838: // ---------------------
// Nickname des letzten Posters zuordnen
if (!$inlistuserid)
{
$i=0;
$query = "
SELECT U_Username, U_Number
FROM {$config['tbprefix']}Users
WHERE U_Number IN ($inlistuserid)
";
$sth = $dbh->do_query($query,__LINE__,__FILE__);
while(list ($UserNICK,$USERNumber) = $dbh -> fetch_array($sth))
{
$UserNickname[$USERNumber] = $UserNICK ;
$i++;
}
}
:::::::::::::::::::::::::
::- File dosearch.tmp -::
:::::::::::::::::::::::::
Zeile 72: for ($i=0;$i<$resultsize;$i++)
{
$UserLastPostID = $searchrow[$i]['UserLastPostID'] ;
//UBBTREMARK
Zeile 89: {$searchrow[$i]['gotolast']} von: {$UserNickname[$UserLastPostID] }
:::::::::::::::::::::::::
::- Looks like: -::::::::
:::::::::::::::::::::::::
: Active Topics screen:
Letzte Antwort: 20/04/2005 16:24 von: Stella
in english:
Last Post: 20/04/2005 16:24 by: Stella
Active Topics tiernetzwerk.de screen ------------------------------
UBBT Team... is it ok, or can there go something wrong.
--sorry for my english ....
Stan