hELP display of news

Captain Joined: Apr 30, 2004 Posts: 566

Try this... I know this works....

replace X with the aid of the author

Code:

<?php

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

global $prefix, $multilingual, $currentlang, $db;

if ($multilingual == 1) {
$querylang = "WHERE (alanguage='$currentlang' OR alanguage='')";
} else {
$querylang = "";
}
$content = "<table width=\"100%\" border=\"0\"><tr><td>";
$result = $db->sql_query("
SELECT sid, title
FROM {$prefix}_stories
WHERE aid='X'
ORDER BY sid
DESC LIMIT 5");
while ($row = $db->sql_fetchrow($result))
{
$row['sid']= intval($row['sid']);
$row['title']= check_words(check_html($row['title'], "nohtml"));
$content. ="<strong>·</strong> <a href=\"modules.php?name=News&file=article&sid=$row[sid]\">$row[title]</a><br />";
}
$content .= "</td></tr></table>";
$content .= "<br /><center>[ <a href=\"modules.php?name=News\">"._MORENEWS."</a> ]</center>";

?>

Corporal Joined: Dec 13, 2005 Posts: 72

i am sorry to let u know that the block still did not work. i copied the code exactly as you posted and changed the X with the id of the newsreporter
still it did not work.

i am using phpnuke 8. what could be wrong?

Captain Joined: Apr 30, 2004 Posts: 566

when you replaced X, did you leave in the single quote marks?

for example: 'X' and not X

If that does not work, then I am not sure what is wrong. I use a modified version of 7.6, but there should not be much difference.

Corporal Joined: Dec 13, 2005 Posts: 72

yes i use the single quote mark like this 'username'

when i activate the block index page cannot be displayed, only the left blocks are displayed

Captain Joined: Apr 30, 2004 Posts: 566

I have the following code in a block named "Author News" here:

http://www.smf-nuke.com

It is on the bottom left side.

As far as I know, the only difference to the current PHP Nuke 8.0 and my 7.6 version is that I have made the field "aid" an integer field, while I am sure 8.0 still uses a varchar field.

Replace the aid='1'

with:

aid='username'

...where username is the author username.

Code:

<?php

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

global $db, $prefix;
$content = "";
$content .= "<table width=\"100%\" border=\"0\"><tr><td class=\"content\">";
$result = $db->sql_query("
SELECT sid, title
FROM {$prefix}_stories
WHERE aid='1'
ORDER BY sid
DESC LIMIT 5");
while ($row = $db->sql_fetchrow($result))
{
$row['sid']= intval($row['sid']);
$row['title']= check_words(check_html($row['title'], "nohtml"));
$content .= "<strong>·</strong> <a href=\"modules.php?name=News&file=article&sid=$row[sid]\">$row[title]</a><br />";
}
$content .= "</td></tr></table>";
$content .= "<br /><center>[ <a href=\"modules.php?name=News\">"._MORENEWS."</a> ]</center>";

?>

If this still does not work, please copy/paste the error line here. You may need to enable errors in the config.php file.

Corporal Joined: Dec 13, 2005 Posts: 72

yes it works now. thanks a lot spottedhog Very Happy

actually i may need many more codings. so be there Smile