UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Active Topics / Last Post

Hello UBBt ,

the new feature Active Topics is not bad, but who I can use boths?

One Table for Active Topics
and another for Last Post like UBBt 6.4

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 [:"blue"]( USERNAME ) [/]


Stan

[] 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

EDIT::::

Zeile 737:

if (($inlistuserid == "") && ($LastPosterId != "")) { $inlistuserid .= $LastPosterId ;}
elseif ($LastPosterId != "") { $inlistuserid .= ",$LastPosterId"; }

:: EDIT ::


Line 686: add --> ,t1.B_LastPosterId
Line 707: add --> ,$LastPosterId
Line 839:
// ---------------------
// Nickname des letzten Posters zuordnen

if (($inlistuserid != "") && ($topic == "1"))
{
$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++;
}
}

:: EDIT ::

dosearch.php:

Line 686: add --> ,t1.B_LastPosterId
Line 707: add --> ,$LastPosterId
Line 839:
// ---------------------
// Nickname des letzten Posters zuordnen

if (($inlistuserid != "") && ($topic == "1"))
{
$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 ;
}
}


dosearch.tmp::

deleted:
$UserLastPostID = $searchrow[$i]['UserLastPostID'] ;

changed:

{$searchrow[$i]['gotolast']} {$UserNickname[$searchrow[$i]['UserLastPostID']]}