encyclopedia last entries?

rafamp · Regular Joined: Oct 15, 2005 Posts: 92 Location: Brazil

hi

do you guys have a block/module/rss feed to know the last encyclopedia entries?

thanks

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

I haven't seen this, but you could probably modify a similar last block to look at the encyclopedia table...

rafamp · Regular Joined: Oct 15, 2005 Posts: 92 Location: Brazil

trying this without success

source: block-Last_5_Articles.php

Code:

if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
die();
}

global $prefix, $db;

$sql = "SELECT tid, title FROM ".$prefix."_encyclopedia ORDER BY id DESC LIMIT 0,10";
$result = $db->sql_query($sql);
while (list($tid, $title) = $db->sql_fetchrow($result)) {
$id = intval($tid);
$title = stripslashes($title);
$content .= "<big>·</big> <a href=\"modules.php?name=Encyclopedia&rop=content&tid=$id\">$title</a> ";
}

?>

rafamp · Regular Joined: Oct 15, 2005 Posts: 92 Location: Brazil

Come on guys...

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

What happens? Do you get an error message?

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Did you post the entire code for the block? It's missing a <?PHP to start...

rafamp · Regular Joined: Oct 15, 2005 Posts: 92 Location: Brazil

yes there is the <?PHP i just removed it and the comments to get smaller here in the forum,

the problem is when i exchange it, nothing happens Sad

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

Try this (notice it's using a different table, the tid field is specified consistently in the SQL and the list result, the op code is correct in the URL):

Code:

<?php
if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
die();
}

global $prefix, $db;

$sql = "SELECT tid, title FROM ".$prefix."_encyclopedia_text ORDER BY tid DESC LIMIT 0,10";
$result = $db->sql_query($sql);

while (list($tid, $title) = $db->sql_fetchrow($result)) {
$id = intval($tid);
$title = stripslashes($title);
$content .= "<big>·</big> <a href=\"modules.php?name=Encyclopedia&op=content&tid=$id\">$title</a> ";
}

?>