Request for nuke

hi Carbonize
I would like to make you a very tempting application and of good taste
would you know how to create a block that lets the last 10 post flow or more than have they written on the guestbook for nuke?
It would be a very nice thing

I wait for one answer of yours...
hi Paolo

Hi. Please feel free to post iin your native tongue as I have friends who can translate for me. I'm guessing you wish to post the last 10 guestbook entries onto the index page or something similar?

grazie mille
quello che vorrei chiederti è se puoi creare un blocco per nuke che faccia scorrere gli ultimi 10 utenti che hanno firmato il guestbook

u are great

Ciao Paolo

Amperora gradireste uno scroller che visualizza le ultime 10 voci. Dovrò guardare come i blocchi su PHP Nuke sono fatti.

---------------------------------

Ah you would like a scroller that displays the last 10 entries. I will have to look at how blocks on PHP Nuke are made.

I tried this a while back with no luck. This block works for everything else except the Guestbook, including homemade modules. Wondering if it is because the IDs used in Guestbook show the whole page instead of just one entry?

Anyway, here is a block in case Carbonize or someone else wants to fix it. This is not a scrolling block but just a block to show the last 10. It does not produce any error message - Will show the block with the bullets, but will not show the content.

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2002 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("block-Last10Guestbook.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

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

$sql = "SELECT id, date, comment FROM book_data ORDER BY id DESC LIMIT 0,10";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
 $content .= "<big>&middot;</big>&nbsp;<a href=\"modules.php?name=guestbook&amp;rop=showcontent&amp;id=$row[id]\">$row[comment]</a> ";
}
$content .= " <center><a href=\"modules.php?name=guestbook\"> <img src='images/gbook.gif' border='0' alt=\"Guestbook\"></a>";
$content .= " <center><a href=\"modules.php?op=modload&name=guestbook&file=index&agbook=addentry\">Sign Our Guestbook</a> </center>";
?>

I already have the code for retrieving the last x number of entries I just don't know how PHP Nuke blocks work meaning how they integrate or get added to the admin.

I tried the block again just now and it works fine. Here it is below with the scrolling added.

I don't think blocks ever get coded to admin. Name the block file something like "block-Guestbook.php" and upload it to the blocks directory. Then in admin.php, select "blocks". Then scroll down past "Blocks Administration" to the "Add a New Block" section. In The "Title" section type the name you want for the block, "Guestbook." Then pick the filename from the dropdown box, "Guestbook.php". Indicate whether it should be on the left, right or in the middle and confirm that you want to add the block.

The following scrolling block works in PhpNuke 7.4 patched:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2002 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("block-GuestbookScroll.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}

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

$content = "<A name= \"scrollingCode\"></A>";

$content .="<MARQUEE behavior= \"scroll\" align= \"center\" direction= \"up\" height=\"220\" scrollamount= \"2\" scrolldelay= \"25\" onmouseover='this.stop()' onmouseout='this.start()'>";

$sql = "SELECT id, date, comment FROM book_data ORDER BY id DESC LIMIT 0,10";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
 $content .= "<big>&middot;</big>&nbsp;<a href=\"modules.php?name=guestbook&amp;rop=showcontent&amp;id=$row[id]\">$row[comment]</a> ";
}
$content .= " <center><a href=\"modules.php?name=guestbook\"> <img src='images/gbook.gif' border='0' alt=\"Guestbook\"></a>";
$content .= " <center><a href=\"modules.php?op=modload&name=guestbook&file=index&agbook=addentry\">Sign Guestbook</a> </center>";
?>

I known that this 3d is very visited
thanks for your help but I have problems with the block
for the one that to use the integrated AG PHPNUKE this line

it has to be

these small things me to know how to do,
but how you to be to see http://www.palermo1yahoochat.com
let's not give the results..
According to you to be able to depend on the fact that the AG to run on a different db from the PHPNUKE?
or from the fact that the $prefix to be different from the NUKE?
The $prefix to be standard to AG

Tnx All
(me to Hope that my English to go to improve

)

BYE Paolo

I do not understand your issue. FYI, this block was created for the regular Advanced Guestbook added to PhpNuke, not the PhpNuke Guestbook. The difference is, the first method just uploads the advanced guestbook in the modules directory and edits the code in admin/config.inc.php file to show true instead of false:
The Advanced Guestbook does not use prefixes. I don't use the PhpNuke Guestbook module that was created, so I don't know if it uses prefixes. You can tell by looking in the database.

Correction: The Advanced Guestbook prefix is "book". It is shown in the above block: "FROM book_data"

I looked at the .sql file for the nuke guestbook and see that in it the prefix was changed to "nuke".

I do not know the advantage of using the PhpNuke Guestbook module, since just adding the regular guestbook files to the modules directory works fine.

Correction: Remembering now that once installed in the modules directory, modifications to the regular Advanced Guestbook are not effective. Carbonize's new version with all of the modifications included should solve this issue.

it has to be
Code:
$content .= " <center><a href=\"modules.php?op=modload&name=guestbook&file=index&agbook=addentry\">Sign Guestbook</a> </center>";

I see now what you mean, and yes, you are correct. The above code is not calling up any scrolling text but is merely a link to the signin page. Thanks. I corrected it in the previous posts.