phpBB.nl

Op m'n website zitten een aantal leden die erg actief zijn in de shoutbox, daarom wil ik daarin de 10 recente topics horizontaal laten scrollen.
Het moet op deze plek komen. Bij voorkeur dat het af en toe vernieuwd wordt, net zoals de shoutbox zelf.

Via phpbb.com heb ik dit script gekregen, echter zonder info over de stylesheet. Hoe kan ik dit toevoegen?

Code: Selecteer alles

<B>Recent topics:</b> 
<br /> 
<marquee> 
<?php 
$url = "/phpbb2";   // If url is - http://www.yourforums.com/forums , then enter in "/forums" 
$ppath = "/home/www/phpbb2/config.php";    // Physical path to the config.php file, edit this for your own site. 
if(empty($count)) 
   $count = "10";    // How many topics to link to 

include_once("$ppath"); 
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection"); 
@mysql_select_db("$dbname",$db) or die("here we die"); 

$prefix = "phpbb"; 

$query="SELECT * FROM " . $prefix . "_topics ORDER BY `topic_id` DESC LIMIT 0, $count"; 
      $result = mysql_query($query); 
      while($row = mysql_fetch_array($result)) { 
      $topicid = "$row[topic_id]"; 
      $title = "$row[topic_title]"; 
      $forumid = "$row[forum_id]"; 

echo "<a title=\"$title\" href=\"$url/viewtopic.php?t=$topicid&sid=$forumid\" class=\"forumlink\">$title</a> "; 

} 
?>

is gewoon de css van subsilver, of een andere style

paulus schreef:is gewoon de css van subsilver, of een andere style

Kwam ik ook net achter ja

Is het mogelijk om dit op deze manier weer te geven:

moppen
by wvniersen on Wo 13 Apr 2005 19:50

Ik heb dit uit mijn portal:

Code: Selecteer alles

			<marquee id="recent_topics" behavior="scroll" direction="up" height="200" scrolldelay="100" scrollamount="2">
			<!-- BEGIN recent_topic_row -->
			&raquo; <a href="{recent_topic_row.U_TITLE}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{recent_topic_row.L_TITLE}</a><br />
			by <a href="{recent_topic_row.U_POSTER}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{recent_topic_row.S_POSTER}</a> on {recent_topic_row.S_POSTTIME}<br /><br />
			<!-- END recent_topic_row -->
			</marquee>

Kan ik hier een gedeelte van overnemen of moet ik dan ook nog wat wijzigen in andere bestanden?

dan moet je ook nog de mysql query aanpassen, die moet dan ook wat aan de users tabel halen.

Ik krijg het niet voor elkaar.

$title "; } ?>

scrollt alleen voorbij

Code: Selecteer alles

	<marquee> 
<?php 
$url = "/forum";   // If url is - http://www.yourforums.com/forums , then enter in "/forums" 
$ppath = "/var/www/html/forum/config.php";    // Physical path to the config.php file, edit this for your own site. 
if(empty($count)) 
   $count = "10";    // How many topics to link to 

include_once("$ppath"); 
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection"); 
@mysql_select_db("$dbname",$db) or die("here we die"); 

$prefix = "phpbb"; 

$query="SELECT * FROM " . $prefix . "_topics ORDER BY `topic_id` DESC LIMIT 0, $count"; 
      $result = mysql_query($query); 
      while($row = mysql_fetch_array($result)) { 
      $topicid = "$row[topic_id]"; 
      $title = "$row[topic_title]"; 
      $forumid = "$row[forum_id]"; 

echo "<a title=\"$title\" href=\"$url/viewtopic.php?t=$topicid&sid=$forumid\" class=\"forumlink\">$title</a> "; 

} 
?> 
</marquee>

paulus schreef:dan moet je ook nog de mysql query aanpassen, die moet dan ook wat aan de users tabel halen.

'A bridge too far'

Probeer eens:

Code: Selecteer alles

  <marquee>
<?php
$url = "/forum";   // If url is - http://www.yourforums.com/forums , then enter in "/forums"
$ppath = "/var/www/html/forum/config.php";    // Physical path to the config.php file, edit this for your own site.
if(empty($count))
   $count = "10";    // How many topics to link to

include_once("$ppath");
$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("here we die at connection");
@mysql_select_db("$dbname",$db) or die("here we die");

$prefix = "phpbb"; 

$query="SELECT t.*, p.*, u.* FROM " . $prefix . "_topics t, " . $prefix . "_posts p, " . $prefix . " u
        WHERE t.topic_first_post_id = p.post_id
		AND p.poster_id = u.user_id ORDER BY `topic_id` DESC LIMIT 0, $count";
      $result = mysql_query($query);
      while($row = mysql_fetch_array($result)) {
      $topicid = "$row[topic_id]";
      $title = "$row[topic_title]";
      $forumid = "$row[forum_id]";
	  $user = "$row[username]";
	  $user_id = "$row[user_id]";
	  $time = date("D d M Y G:i","$row[post_time]);

echo "<span class=\"forumlink\"><a title=\"$title\" href=\"$url/viewtopic.php?t=$topicid&sid=$forumid\" class=\"forumlink\">$title</a><br />By <a href=\"$url/profile.php?mode=viewprofile&u=$user_id\" class=\"forumlink\">$user</a> on $time</span>";

}
?>
</marquee>

Luuk schreef:Probeer eens:

Ik krijg nu meer variabelen, maar helaas nog steeds op deze manier:

$title
By $user on $time"; } ?>

Ligt dat aan

Code: Selecteer alles

$ppath = "/var/www/html/forum/config.php";    // Physical path to the config.php file, edit this for your own site.

Het probleem is hier te zien.

Maak van $ppath = "/var/www/html/forum/config.php";
eens $ppath = "config.php";

Luuk schreef:Maak van $ppath = "/var/www/html/forum/config.php";
eens $ppath = "config.php";

Helaas, weer geen succes

Code: Selecteer alles

$ppath = "/var/www/html/forum/config.php";

Heb ik overgenomen van mijn FTP, moet dan kloppen, toch?

Ik heb het probleem ook op twekaers.net neergelegd. Klopt het wat er daar wordt gesuggereerd?

Ik had maar overgenomen wat er al stond, is ook niet mijn normale manier

Probeer dan eens zo:

Code: Selecteer alles

<marquee>
<?php
$url = "/forum";   // If url is - http://www.yourforums.com/forums , then enter in "/forums"
$ppath = "/var/www/html/forum/config.php";    // Physical path to the config.php file, edit this for your own site.
if(empty($count))
{
   $count = "10";    // How many topics to link to
}

include_once("$ppath");
$db = @mysql_connect($dbhost, $dbuser, $dbpasswd) or die("here we die at connection");
@mysql_select_db($dbname,$db) or die("here we die");

$query="SELECT t.*, p.*, u.*
	FROM " . $table_prefix . "topics t, " . $table_prefix . "posts p, " . $table_prefix . "users u
    WHERE t.topic_first_post_id = p.post_id
      AND p.poster_id = u.user_id ORDER BY `topic_id` DESC LIMIT 0," . $count;
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
    $topicid = $row['topic_id'];
	$title = $row['topic_title'];
    $forumid = $row['forum_id'];
    $user = $row['username'];
    $user_id = $row['user_id'];
    $time = date("D d M Y G:i",$row['post_time']);
	
	echo("<span class=\"" . forumlink . "\"><a title=\"" . $title . "\" href=\"" . $url . "/viewtopic.php?t=" . $topicid . "\" class=\"forumlink\">" . $title . "</a><br />By <a href=\"" . $url . "/profile.php?mode=viewprofile&u=" . $user_id . "\" class=\"forumlink\">" . $user . "</a> on " . $time . "</span>");
}
?>
</marquee>

Ik heb het nu werkend door de recent topics mod te gebruiken van mijn portal, echter de lijst scrolt nu niet meer, waar zit de fout?

Code: Selecteer alles

			<marquee id="recent_topics" behavior="scroll" direction="left" height="200" scrolldelay="100" scrollamount="2">
			<!-- BEGIN recent_topic_row -->
			<td class="row1" align="left"><span class="mainmenu">
			&raquo; <a href="{recent_topic_row.U_TITLE}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{recent_topic_row.L_TITLE}</a><br />
			by <a href="{recent_topic_row.U_POSTER}" onMouseOver="document.all.recent_topics.stop()" onMouseOut="document.all.recent_topics.start()">{recent_topic_row.S_POSTER}</a><br />
			on {recent_topic_row.S_POSTTIME}</span></td>
			<!-- END recent_topic_row -->
			</marquee>

(verplaatsen naar Mod Support?)

phpBB.nl

Recent topics, horizontaal als het kan, stap 3

Recent topics, horizontaal als het kan, stap 3