[timofsuburbia]

I want my users to see their saved stories in the sidebar... I think I've almost got it.

Here's the .php file so far, it will show all the recently saved stories for all users. I want to limit this to show only the saved stories for the user who is logged in.

Create a file called sidebar_saved.php in your root or where the other .php files are all stored.

PHP Code:

<?php
// The source code packaged with this file is Free Software, Copyright (C) 2005 by
// Ricardo Galli <gallir at uib dot es>.
// It's licensed under the AFFERO GENERAL PUBLIC LICENSE unless stated otherwise.
// You can get copies of the licenses here:
//         http://www.affero.org/oagpl.html
// AFFERO GENERAL PUBLIC LICENSE is also included in the file called "COPYING".
// -------------------------------------------------------------------------------------

include_once('Smarty.class.php');
$main_smarty = new Smarty;

include_once('config.php');
include_once(mnminclude.'html1.php');
include_once(mnminclude.'link.php');
include_once(mnminclude.'tags.php');
include_once(mnminclude.'search.php');
include_once(mnminclude.'smartyvariables.php');

// -------------------------------------------------------------------------------------

global $the_template, $main_smarty, $db;

echo "<div class=\"tlb\"><span><a onclick=\"new Effect.toggle('savedlinks','blind', {queue: 'end'}); \">  +/-</a></span></div>Recently Saved<div id=\"savedlinks\">";

$res = "select link_id,link_title,saved_id,saved_user_id,saved_link_id from ".table_links.",".table_saved_links." WHERE saved_link_id = link_id ORDER BY saved_id DESC limit 20";
$list_savedlinks = $db->get_results($res);
if($list_savedlinks)
{
    foreach($list_savedlinks as $row){            
        $story_url = getmyurl("story", $row->link_id);
        echo "<a class='switchurl' href='".$story_url."'>".$row->link_title."</a>";                
    }
}

echo "</div>";
    
    
?>

To add it to the sidebar create a file called sidebar_saved.tpl with these contents and place it in your sidebar modules folder.

PHP Code:

{* ----- show the sidebar stories box ----- *}
    {php}include('sidebar_saved.php');{/php}
{* ---------------------------------------- *} 


Finally, add this code to your sidebar.tpl

PHP Code:

{assign var=sidebar_module value="sidebar_saved"}{include file=$the_template_sidebar_modules."/wrapper.tpl"} 


This will put recently saved stories by all users in the sidebar, but I need help limiting the result to just the user's own saved stories.

[longcountdown]

I can't answer your question about limiting it to the current user, but thanks very much for this code. It's just what I was looking for.

[ddluk]

Ok. It works But I add some improvements to that:

1)I deleted that from sidebar_saved.php

echo "<div class=\"tlb\"><span><a onclick=\"new Effect.toggle('savedlinks','blind', {queue: 'end'}); \">  +/-</a></span></div>Recently Saved<div id=\"savedlinks\">"; 

echo "</div>";

2) I open sidebar_saved.tpl and on the beginning add:

<div class="tlb">
	<span><a onclick="new Effect.toggle('user_data','blind', {ldelim}queue: 'end'{rdelim});"> <img src="{$my_pligg_base}/templates/{$the_template}/images/expand.png" alt="expand" /></a></span>

	<a href="#">Recently saved news</a>
</div>

3)Finally i change the code in sidebar.tpl. Now users who are not registered see nothing because the don't need that panel

{if $user_authenticated eq true}
{assign var=sidebar_module value="sidebar_saved"}{include file=$the_template_sidebar_modules."/wrapper.tpl"}
{/if}

[facasplaca]

Excellent stuff!
Only issue I have is that I have some news twice...any idea why?