Senaste inlägg (Last post)

Inlägg av **Kjell** » 2007-10-05 13:37

Har arbetat med Last Post nu på morgonen

ver 0.0.3
Slängde ihop den här för jag saknade en sådan funktion

Koden är inte städad men fungerar, den visar senaste inlägg och av vem, 15 stycken visas.
Liknande vad Ez_Portal hadde förut i PHPBB2.
Är det någon som vill städa upp koden så är det fritt fram om ni delar med er.
Demo: http://www.svagan.se

Open includes/functions.php

Find

Kod: Markera allt

?>

Add Before

Kod: Markera allt

// Start last post
function get_last_posts($limit, $extra_id = false, $type = false)
{
    global $db, $phpbb_root_path, $phpEx, $template;
	global $cache, $user, $auth, $config, $user_cache;

	$extra = false;
	if ($extra_id)
	{
		switch($type)
		{
			case 'post':
				$extra = "AND p.post_id IN ($extra_id)";
			break;
		}
	}
		
	//find out which forums we have permission to view
	$auth_ary = $auth->acl_get_list($user->data['user_id'], 'f_read');
	
	$forum_ary = array();
	foreach ($auth_ary as $key => $var)
	{
		$forum_ary[] = $key;
	}
	$forums = implode(', ', $forum_ary);

	// Grab ranks
	$ranks = $cache->obtain_ranks();
   	// Grab icons
	$icons = $cache->obtain_icons();

    $sql = 'SELECT p.*, u.*
    FROM ' . POSTS_TABLE . ' p
    LEFT JOIN ' . USERS_TABLE . " u ON (u.user_id = p.poster_id)
    ORDER BY post_time DESC LIMIT $limit";
    $result = $db->sql_query($sql);
        
    while ($row = $db->sql_fetchrow($result))
    {
        $flags = (($row['enable_bbcode']) ? 1 : 0) + (($row['enable_smilies']) ? 2 : 0) + (($row['enable_magic_url']) ? 4 : 0);
        $row['post_text'] = generate_text_for_display($row['post_text'], $row['bbcode_uid'], $row['bbcode_bitfield'], $flags);
        
        $template->assign_block_vars('posts', array(
            'POST_AUTHOR'        => get_username_string('username', $row['poster_id'], $row['username'], $row['user_colour'], $row['post_username']),
			'POST_SUBJECT'    => substr($row['post_subject'], 0, 17),
            'U_MINI_POST'        => append_sid("{$phpbb_root_path}viewtopic.$phpEx", "p={$row['post_id']}&f={$row['forum_id']}#p{$row['post_id']}"),
        ));
    }
    $db->sql_freeresult($result);
    return;
}
// end Last Post

Open language/sv/common.php
Find

Kod: Markera allt

 	'VIEWED_COUNT_NONE'		=> 'Inte visad Ã¤n',

Add after

Kod: Markera allt

 	'LPOST'					=> 'Senaste inlÃ¤gg',

Open index.php or portal.php etc...
Find

Kod: Markera allt

// Output page

Add before

Kod: Markera allt

// Start last post
get_last_posts(15);
// End last post

Open styles/subsilver2/template/index_body.html or portal_body.htm etc.
Put in the html text where you feel.

Kod: Markera allt

<table class="tablebg" cellspacing="1" width="100%" id="table1">
<tr>
	<td class="cat">
	<p align="center"><b>{L_LPOST}</b></td>
</tr>
<tr>
	<td class="row1" align="left" style="line-height:150%;">
	<!-- BEGIN posts -->
    * <font color="#008080"><a href="{posts.U_MINI_POST}"><font color="#008080">{posts.POST_SUBJECT}</font></a></font><a style="color: #00FFFF" href="{posts.U_MINI_POST}">
    </a>of <a href={posts.U_POST_AUTHOR}>{posts.POST_AUTHOR}</a><br>
<!-- END posts -->
</tr>
</table>

Save all files

Ändra antal inägg i index.php (15)

Kod: Markera allt

get_last_posts(15);

Ändra längden på inlägg i funktions.php (17)

Kod: Markera allt

'POST_SUBJECT'    => substr($row['post_subject'], 0, 17),

sanda · Inlägg av **sanda** » 2007-11-15 15:45

kan man göra så dessa visas på en annan sida typ "huvudsida" och inte i forumindex?

Vill gärna ha detta på min startsida som ligger utanför forumet.

Mvh Tobias

Inlägg av **Kjell** » 2007-11-15 18:18

Du måste ha någon form av stöd för pgpBB3, se hur man kan göra egna sidor http://www.phpbb-se.com/forum/viewtopic.php?t=4664

Sedan kan du lägga till den här informationen på din sida.

Da^MsT · Inlägg av **Da^MsT** » 2008-04-01 06:43

Detta skulle kunna vara intressant för mig om än med lite modifikation. Någon som har en idé hur jag skulle kunna få detta att lira på en wordpress sida?

Da^MsT · Inlägg av **Da^MsT** » 2008-04-05 07:56

Skulle det funka att skapa en sån här sida och sedan inkludera (php include) den utanför phpBB?

Inlägg av **Kjell** » 2008-04-05 08:08

Inget är omöjligt, men eftersom du bygger unika sidor så har jag svårt att tala om hur det ska se ut, men du kan labba lite och se själv.

Da^MsT · Inlägg av **Da^MsT** » 2008-04-11 13:21

Har hittat en variant för att få det att funka för WordPress nu, men har lite problem jag skulle behöva hjälp med.

Min kod

Kod: Markera allt

 <?php
    // How Many Topics you want to display?
    $topicnumber = 10;
    // Scrolling towards up or down?
    $scroll = "up";
    // Change this to your phpBB path
    $urlPath = "forum";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'forum/config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die("Query failed");									
 
    print "<div class=\"wps-topic-recentpost\">";
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 
    echo  "<div class=\"thread\"><a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id]'."\"><strong>" .
utf8_encode($row["topic_title"]) .
"</strong></a><br /><small>startad av <a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['topic_first_post_id']."\">" .
$row["topic_first_poster_name"] ."</a> i <img src=\"http://wp-support.se/styles/prosilver/imageset/icon_post_target.gif\" alt=\"icon2\" width=\"11\" height=\"9\" /><a href=\"".$urlPath."/viewforum.php?f=".$row['forum_id']."\">".$row["forum_name"]."</a></small></div><span class=\"answers\">".$row["topic_replies"]."</span>
  <div class=\"recent\"><a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['user_id']."\">" .
$row["username"] .
"<a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\"><img src=\"http://wp-support.se/styles/prosilver/imageset/icon_topic_latest.gif\" alt=\"icon\" width=\"11\" height=\"9\" /></a><br />". date('j F, Y, h:i', $row["post_time"]) ."</div><div class=\"clearline-forum\"></div></div>";
    }
    print "</div>";
    mysql_free_result($result);
    mysql_close($link);
    ?>

Med denna kod får jag nu felet

Parse error: syntax error, unexpected ';', expecting ']' in /home/web00000/domains/mindomän.se/public_html/portal/wp-content/themes/wps/portal.php on line 73

Rad 73 är

Kod: Markera allt

"<a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\"><img src=\"http://wp-support.se/styles/prosilver/imageset/icon_topic_latest.gif\" alt=\"icon\" width=\"11\" height=\"9\" /></a><br />". date('j F, Y, h:i', $row["post_time"]) ."</div><div class=\"clearline-forum\"></div></div>";

Kan inte se vad som är fel där

Inlägg av **Kjell** » 2008-04-11 19:52

Den säger att det är fel på slutet </div></div>"; och förväntar sig </div></div>"] ...

Da^MsT · Inlägg av **Da^MsT** » 2008-04-11 22:08

Det var inte rätt nej. Var fel längre upp som jag till slut fick ordning på, jag har dock fortfarande problem.

Kod: Markera allt

 <?php
    // How Many Topics you want to display?
    $topicnumber = 10;
    // Scrolling towards up or down?
    $scroll = "up";
    // Change this to your phpBB path
    $urlPath = "forum";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'forum/config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die(mysql_error());
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_replies, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u2.user_id AS starter_id, u2.username AS starter_name, f.forum_name
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id AND
    t.topic_first_poster_id = starter_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";									
 
    print "<div class=\"wps-topic-recentpost\">";
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 
    echo  "<div class=\"thread\"><a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\">
	<strong>". utf8_encode($row["topic_title"]) ."</strong></a><br /><small>startad av <a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['starter_id']."\">". $row["starter_name"] ."</a> i <img src=\"forum/styles/prosilver/imageset/icon_post_target.gif\" alt=\"icon2\" width=\"11\" height=\"9\" /><a href=\"".$urlPath."/viewforum.php?f=".$row['forum_id']."\">". utf8_encode($row["forum_name"]) ."</a></small></div><span class=\"answers\">". $row["topic_replies"] ."</span><div class=\"recent\"><a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['user_id']."\">" .$row["username"]."</a><a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\"><img src=\"forum/styles/prosilver/imageset/icon_topic_latest.gif\" alt=\"icon\" width=\"11\" height=\"9\" /></a><br />". date('j F, h:i', $row["post_time"]) ."</div><div class=\"clearline-forum\"></div></div>";
    }
    print "</div>";
    mysql_free_result($result);
    mysql_close($link);
    ?>

Och denna kod ger

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource

Inlägg av **tumba25** » 2008-04-11 22:13

Du behöver ett

Kod: Markera allt

$result = mysql_query($query);

före "while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {". Annars finns ju inte något i $result.

Da^MsT · Inlägg av **Da^MsT** » 2008-04-11 22:27

Doh!

Kod: Markera allt

<?php
    // How Many Topics you want to display?
    $topicnumber = 10;
    // Scrolling towards up or down?
    $scroll = "up";
    // Change this to your phpBB path
    $urlPath = "forum";
 
    // Database Configuration (Where your phpBB config.php file is located)
    include 'forum/config.php';
 
    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die(mysql_error());
 
    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_replies, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, u2.user_id AS starter_id, u2.username AS starter_name, f.forum_name, t.topic_poster
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u, $table_users u2
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id AND
    t.topic_poster = u2.user_id
    ORDER BY p.post_id DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die(mysql_error());									
 
    print "<div class=\"wps-topic-recentpost\">";
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 
    echo  "<div class=\"thread\"><a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\">
	<strong>". utf8_encode($row["topic_title"]) ."</strong></a><br /><small>startad av <a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['starter_id']."\">". $row["starter_name"] ."</a> i <img src=\"http://wp-support.se/styles/prosilver/imageset/icon_post_target.gif\" alt=\"icon2\" width=\"11\" height=\"9\" /><a href=\"".$urlPath."/viewforum.php?f=".$row['forum_id']."\">". utf8_encode($row["forum_name"]) ."</a></small></div><span class=\"answers\">". $row["topic_replies"] ."</span><div class=\"recent\"><a href=\"".$urlPath."/memberlist.php?mode=viewprofile&u=".$row['user_id']."\">" .$row["username"]."</a><a href=\"".$urlPath."/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."&p=".$row['post_id']."#p".$row['post_id']."\"><img src=\"http://wp-support.se/styles/prosilver/imageset/icon_topic_latest.gif\" alt=\"icon\" width=\"11\" height=\"9\" /></a><br />". date('j F, h:i', $row["post_time"]) ."</div><div class=\"clearline-forum\"></div></div>";
    }
    print "</div>";
    mysql_free_result($result);
    mysql_close($link);
    ?>

Slutliga koden om någon vill använda

Tack för hjälpen!

Senaste inlägg (Last post)

Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Re: Senaste inlägg (Last post)

Vilka är online

Om phpBB Sverige