|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
mediman
Support Team
YaBB God
Posts: 2858
|
 |
Re:Externe Anzeige der letzen Beiträge...?!?
« Reply #8 on: March 24, 2002, 09:16:53 PM » |
|
also falls du die ssi.php ned zum laufen kriegst, und da du ja nur die x recent posts von board y anzeigen lassen magst :
<head><style type="text/css">
A:link {text-decoration: none; color: #005177; background-color: transparent;}
A:visited {text-decoration: none; color: #005177; background-color: transparent; }
A:hover {color: #CC3333; text-decoration: none; background-color: transparent; }
</style></head>
<?php
$yabbse_path = "";
$board ="1";
$numero ="5";
$incl = @include_once ($yabbse_path."/Settings.php");
$db = @mysql_connect($db_server, $db_user, $db_passwd);
$res = mysql_db_query( $db_name, "select * from {$db_prefix}messages, {$db_prefix}topics where {$db_prefix}topics.ID_TOPIC = {$db_prefix}messages.ID_TOPIC AND {$db_prefix}topics.ID_BOARD = $board order by {$db_prefix}messages.posterTime desc");
$num = mysql_num_rows($res);
$abfrage = mysql_db_query( $db_name, "select name FROM {$db_prefix}boards where ID_BOARD = '$board'");
$boardname = mysql_fetch_row($abfrage);
if ($num < $numero) {$numero = $num;}
for ($i=0; $i<$numero; $i++)
{
$sub = mysql_result($res, $i, "subject");
$pona = mysql_result($res, $i, "posterName");
$msg = mysql_result($res, $i, "ID_TOPIC");
echo "<a href=\"$boardurl/index.php?board=$board\">[$boardname[0]]</a> <a href=\"$boardurl/index.php?board=$board;action=display;threadid=$msg\"><font color='blue'>$sub</a></font> von <font color='green'>$pona</font><br>";
}
mysql_close($db);
?>
medi
|
|
|
|
« Last Edit: March 24, 2002, 09:24:43 PM by mediman »
|
Logged
|
mainComm Dev Team
|
|
|
|
|
|
|
|
|
|
|
|
|
mediman
Support Team
YaBB God
Posts: 2858
|
|
Re:Externe Anzeige der letzen Beiträge...?!?
« Reply #14 on: March 25, 2002, 03:07:26 PM » |
|
@NKTmas
trag deinen absoluten pfad zu yabbse ein und bau es in deineseite ein wo du das ganze anzeigen willst!
<?php
$yabbse_path = "";
$incl = @include_once ($yabbse_path."/Settings.php");
$con = @mysql_connect($db_server, $db_user, $db_passwd);
$guests = 0;
$tmpusers = array();
$abfrage = mysql_db_query( $db_name, "select identity FROM {$db_prefix}log_online where 1 order by logTime desc");
while ($tmp = mysql_fetch_array($abfrage))
{
$identity = $tmp[0];
$abfrage2 = mysql_db_query( $db_name, "SELECT realName FROM {$db_prefix}members WHERE (memberName='$identity') LIMIT 1");
if (mysql_num_rows($abfrage2) > 0){
$tmp = mysql_fetch_row($abfrage2);
$tmpusers[] = "<a href=\"$boardurl/index.php?action=viewprofile;user=$identity\">$tmp[0]</a>";
}
else
$guests ++;
}
$users = implode(", ",$tmpusers);
$numusersonline = sizeof($tmpusers);
echo "Gäste: $guests , Mitglieder: $numusersonline <br>Mitglieder online: $users";
mysql_close($con);
?>
medi
p.s. wenn es probs gibt, sag was!
|
|
|
|
« Last Edit: March 25, 2002, 03:35:44 PM by mediman »
|
Logged
|
mainComm Dev Team
|
|
|
Author