Add last 10 and scroll in the block

Worker Joined: Jul 20, 2004 Posts: 189 Location: Italy

Please help me to add last 10 and the scroll into the following block:

Code:

<?php


if ( !defined('BLOCK_FILE') ) {


   Header('Location: ../index.php');


   die();


}





global $prefix, $db;


$content = "";


$page_content = array();


$result = $db->sql_query("SELECT pid, cid, title FROM " . $prefix . "_pages WHERE active='1'");


while (list($pid, $cid, $title) = $db->sql_fetchrow($result)) {


   $page_content[$cid][] = array('pid'=>$pid, 'title'=>$title);


}





$result2 = $db->sql_query("SELECT cid, title FROM " . $prefix . "_pages_categories");


while (list($cid, $title) = $db->sql_fetchrow($result2)) {


  $content .= "<b>&nbsp;<strong><big>&middot;</big></strong>&nbsp;<a href=\"content-cat-.html$cid\">$title</a></b><br>";


   if(!empty($page_content[$cid])){


      foreach($page_content[$cid] as $value){


         $content .= "&nbsp;&nbsp;&middot;&nbsp;<a href=\"contentid-.html".$value['pid']."\">".$value['title']."</a><br>";


      }


   }


}





?>

Many thanks.

Posted: Wed Sep 09, 2009 2:55 pm

Wow how did this one escape us?

<bump> Sad

Posted: Wed Sep 09, 2009 4:25 pm

If you still need help with this please clarify exactly what you are trying to do.

Are you trying to list every category and then show the last 10 pages for each.

Worker Joined: Oct 26, 2004 Posts: 134 Location: Boston

jakec your getting old Welcome to the dark side Smile

Posted: Thu Sep 10, 2009 12:25 am

Thanks Unit1 Laughing

Posted: Thu Sep 10, 2009 1:20 am

Yes, so:
· Category 1

· Category 2

All scrolling.

Many thanks for your help.

Posted: Fri Sep 11, 2009 8:02 pm

What order should the categories and then pages appear?

Posted: Sat Sep 12, 2009 12:51 am

montego wrote:

What order should the categories and then pages appear?

Categories: Alphabetical

Pages: Chronological

Posted: Sat Nov 28, 2009 5:14 am

Please inform me if the modifications I ask is difficult to achieve.

Posted: Sat Nov 28, 2009 9:10 am

Eduardo, just thought of something, what about pages with no category?

Edited: Also, you say pages should be chronological, but what order? I.e., Most recent first or the opposite?

Posted: Sat Nov 28, 2009 11:10 am

Most recent first.

In the script I inserted the category is cronological. I need alphabetical.

Posted: Sun Nov 29, 2009 2:58 pm

Eduardo, ok, worked on this a little bit and here is what I came up with:

Code:




<?php


if (!defined('BLOCK_FILE')) {


   Header('Location: ../index.php');


   die();


}





$blkh = 10;        // Number of lines high


$blkw = 45;        // Number of characters wide 0 = unused


$scron = 1;        // Turn scrolling on by setting to 1


$scrdr = 'up';     // Scroll direction (up, down, left, or right)


$scrhg = 200;      // Scroller height in pixels


$scrwd = 145;      // Scroller width in pixels


$speed = 2;        // Speed Of Scroll


$scrolldelay = 75; // Scroll delay - small the number the smoother the scroll





global $prefix, $db;


$content = '';





$result = $db->sql_query('SELECT `cid`, `title` FROM `' . $prefix . '_pages_categories` ORDER BY `title`');


if ($db->sql_numrows($result) > 0) {


   if ($scron == 1) {


      $content .= '<marquee behavior="scroll" direction="'.$scrdr.'" height="'.$scrhg.'" width="'.$scrwd.'" scrollamount="'.$speed.'" scrolldelay="'.$scrolldelay.'" onmouseover="this.stop()" onmouseout="this.start()"><br />';


   }


   $content .= '<div id="ContentLast"><ul>'; // special 'id' is provided so can style the <ul> tags according to personal liking via ".ContentLast ul" and ".ContentLast ul ul"


   // Cycle through each category


   while (list($cid, $title) = $db->sql_fetchrow($result)) {


      $content .= '<li>' . $title;


      $result1 = $db->sql_query('SELECT `pid`, `title` FROM `' . $prefix . '_pages` WHERE `active` = \'1\' AND `cid` = \'' . $cid . '\' ORDER BY `pid` DESC LIMIT 10');


      if ($db->sql_numrows($result1) > 0) {


         $content .= '<ul>';


         while (list($pid, $ptitle) = $db->sql_fetchrow($result1)) {


            $content .= '<li><a href="contentid-' .$pid . '.html">' . $ptitle .'</a></li>';


         }


         $content .= '</ul>';


      }


      $content .= '</li>';


   }


   $content .= '</ul></div>';


   if ($scron == 1) {


      $content .= '</marquee>';


   }


}





?>

This is what you have asked for thus far plus a little bit more (with the marquee options). I added a special DIV wrapper to it so that you can use CSS to style the individual <ul> tags to your liking.

Hopefully you found this helpful and wouldn't mind donating to Raven's site here a little bit to help out with covering his expenses. Wink

Posted: Mon Nov 30, 2009 10:33 am

I made a donation.
Congratulations on your skill and sophistication.
I have some problems of style.
The margins are too far.
On the categories there are not the links and the bold in the text, even the text color is not correct.

Please go to [ Only registered users can see links on this board! Get registered or login! ]
and compare the last block (YOURS) with the penultimate (MINE).
The blocks are in the left side, the name is "Notizie da ..."

Posted: Wed Dec 02, 2009 6:26 am

Eduardo, I could not find any CSS statements in any of your .css files to style this. You need to add the proper CSS to this theme file:

themes/fiapple211/style/style.css

Here are just a couple of things to try to get you started (add to the above file):

Code:




.ContentLast ul {


  margin: 0;


  padding: 0;


  list-style-position: inside;


}





.ContentLast ul ul {


  margin: 0;


  padding: 0;


  list-style-position: inside;


}

That should give you some ideas on how to style it.

Posted: Wed Dec 02, 2009 8:56 am

Following style.css
At the end there is your code.
Imperfections have not changed.
I am not able to solve the problem.

Code:

FONT { 


font-family : Verdana, Helvetica; 


font-size : 10px; 


} 


TD { 


font-family : Verdana, Helvetica; 


font-size : 10px; 


} 


BODY { 


font-family : Verdana, Helvetica; 


font-size : 10px; 


} 


P { 


font-family : Verdana, Helvetica; 


font-size : 10px; 


} 


DIV { 


font-family : Verdana, Helvetica; 


font-size : 10px; 


} 


body { 


background : #f1f1f1 url(../forums/images/lines.gif); 


color : #000000; 


font : 12px Verdana, Arial, Helvetica, sans-serif; 


margin : 6px; 


padding : 0; 


} 


font, th, td, p { 


font : 10px Verdana, Arial, Helvetica, sans-serif; 


}


.gensmall { 


font-size : 10px; 


} 


td.genmed, .genmed { 


font-size : 11px; 


} 


.explaintitle { 


font-size : 11px; 


font-weight : bold; 


color : #5c81b1; 


} 


a:link, a:active, a:visited, a.postlink { 


color : #4682b4; 


text-decoration : none; 


} 


a:hover { 


color : #000000; 


text-decoration : underline; 


} 


.topictitle { 


font-size : 11px; 


font-weight : bold; 


} 


a.topictitle:visited { 


color : #5493b4; 


} 


a.topictitle:hover { 


color : #000000; 


} 


.name { 


font-size : 11px; 


font-weight : bold; 


} 


hr { 


border : 0 solid #757575; 


border-top-width : 1px; 


height : 0; 


} 


td.cat, td.rowpic { 


font-weight : bold; 


letter-spacing : 1px; 


background : #dedede url(../forums/images/catbkg.gif); 


height : 27px; 


text-indent : 4px; 


} 


td.cathead { 


font-weight : bold; 


letter-spacing : 1px; 


background : #f1f1f1 url(../forums/images/lines.gif); 


height : 29px; 


} 


.row1 { 


background : #f5f5f5; 


} 


.row2, .helpline { 


background : #ececec; 


} 


.row3 { 


background : #e3e3e3; 


} 


td.spacerow { 


background : #ffffff; 


} 


th { 


background : #f1f1f1 url(../forums/images/lines.gif); 


color : #333333; 


font-size : 11px; 


font-weight : bold; 


height : 27px; 


white-space : nowrap; 


text-align : center; 


padding-left : 8px; 


padding-right : 8px; 


} 


.bodyline { 


background : #fbfbfb; 


border : 1px solid #666666; 


} 


.forumline { 


background : #757575; 


border : 0; 


} 


.maintitle, h1 { 


font : bold 20px/120% "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; 


text-decoration : none; 


color : #939393; 


} 


.subtitle, h2 { 


font : bold 18px/180% "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; 


text-decoration : none; 


} 


.nav { 


font-size : 11px; 


font-weight : bold; 


} 


.postbody { 


font-size : 12px; 


line-height : 125%; 


} 


.postdetails { 


font-size : 10px; 


color : #353535; 


} 


.quote { 


background : #fafafa; 


border : 1px solid #d1d7dc; 


color : #444444; 


font-size : 11px; 


line-height : 125%; 


} 


.code { 


background : #fafafa; 


border : 1px solid #d1d7dc; 


color : #006600; 


font : 12px Courier, "Courier New", sans-serif; 


padding : 5px; 


} 


.errorline { 


background : #d3e4f3; 


border : 1px solid #666666; 


} 


input { 


border-color : #000000; 


color : #000000; 


background-color : #ffffff; 


font : normal 11px Verdana, Arial, Helvetica, sans-serif; 


border-width : 1px 1px 1px 1px; 


} 


textarea { 


border-color : #000000; 


color : #000000; 


background-color : #ffffff; 


font : normal 11px Verdana, Arial, Helvetica, sans-serif; 


border-width : 1px 1px 1px 1px; 


} 


select { 


border-color : #000000; 


color : #000000; 


font : normal 11px Verdana, Arial, Helvetica, sans-serif; 


} 


input.post, textarea.post { 


background : #ffffff; 


border : 1px solid #000000; 


font : 11px Verdana, Arial, Helvetica, sans-serif; 


padding-bottom : 2px; 


padding-left : 2px; 


} 


input.button, input.liteoption, .fakebut { 


border : 1px solid #000000; 


background : #d4d0c8; 


font-size : 11px; 


} 


input.catbutton { 


border : 1px solid #000000; 


background : #d4d0c8; 


font-size : 10px; 


} 


input.mainoption { 


border : 1px solid #000000; 


background : #d4d0c8; 


font-size : 11px; 


font-weight : bold; 


} 


a.but, a.but:hover, a.but:visited { 


color : #000000; 


text-decoration : none; 


} 


.helpline { 


border : 0 solid; 


font-size : 10px; 


} 


.admin, .mod { 


font-size : 11px; 


font-weight : bold; 


} 


.admin, a.admin, a.admin:visited { 


color : #ff0000; 


} 


.mod, a.mod, a.mod:visited { 


color : #006600; 


} 


a.admin:hover, a.mod:hover { 


color : #000000; 


} 


img { 


border : 0; 


} 


.tt12bkg { 


background : url(../forums/images/tt12_m.gif) repeat-x; 


height : 12px; 


width : 100%; 


} 


.tb12bkg { 


background : url(../forums/images/tb12_m.gif) repeat-x; 


height : 12px; 


width : 100%; 


} 


.ttb { 


width : 100%; 


} 


.scrntbkg { 


background : url(../forums/images/scrn_t.gif) repeat-x; 


height : 14px; 


width : 100%; 


} 


.scrnbbkg { 


background : url(../forums/images/scrn_b.gif) repeat-x; 


height : 14px; 


width : 100%; 


} 


.scrnlbkg { 


background : url(../forums/images/scrn_l.gif) repeat-y; 


width : 14px; 


} 


.scrnrbkg { 


background : url(../forums/images/scrn_r.gif) repeat-y; 


width : 14px; 


} 


.scrn { 


width : 100%; 


text-align : center; 


} 


td.scrnm { 


background : #ffffff; 


} 


.postbkg { 


background : url(images/tabblank.gif) repeat-y; 


height : 20px; 


} 


.title { 


background : none; 


color : #000000; 


font-size : 13px; 


font-weight : bold; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.content { 


background : none; 


color : #000000; 


font-size : 10px; 


font-family : Verdana, Helvetica; 


} 


.block-title { 


background : none; 


color : #000000; 


font-size : 11px; 


font-family : Verdana, Helvetica; 


} 


.storytitle { 


background : none; 


color : #000000; 


font-size : 11px; 


font-weight : bold; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.storycat { 


background : none; 


color : #000000; 


font-size : 11px; 


font-weight : bold; 


font-family : Verdana, Helvetica; 


text-decoration : underline; 


} 


.boxtitle { 


background : none; 


color : #000000; 


font-size : 10px; 


font-weight : bold; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.boxcontent { 


background : none; 


color : #000000; 


font-size : 10px; 


font-family : Verdana, Helvetica; 


} 


.option { 


background : none; 


color : #000000; 


font-size : 10px; 


font-weight : bold; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.tiny { 


background : none; 


color : #000000; 


font-size : 10px; 


font-weight : normal; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.small { 


background : none; 


color : #000000; 


font-size : 9px; 


font-weight : normal; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


} 


.footmsg { 


background : none; 


color : #000000; 


font-size : 9px; 


font-weight : normal; 


text-align : center; 


font-family : Verdana, Helvetica; 


text-decoration : none; 


}


.ContentLast ul {


  margin: 0;


  padding: 0;


  list-style-position: inside;


}


.ContentLast ul ul {


  margin: 0;


  padding: 0;


  list-style-position: inside;


}

Posted: Sat Dec 05, 2009 9:51 am

Dang it! My apologies! I used an "id" not "class". Change each of the ".ContentLast" to "#ContentLast". So sorry about that. Sad

Posted: Mon Dec 07, 2009 12:53 pm

Dear Montego many thanks.

I need the link and the bold style on the category.

Posted: Wed Dec 09, 2009 6:44 am

Eduardo, I have given you enough, I believe, to where you can now look up the other CSS that you need to do this quite easily. Yes, I could do this for you, but then you wouldn't learn anything from it. The following is an excellent site for learning CSS: [ Only registered users can see links on this board! Get registered or login! ]

Posted: Wed Dec 09, 2009 8:07 am

I think the solution is in the block code, not in the CSS file.

My first block make the bold text and the link to the category by the following script:

Quote:

$content .= " <big>·</big> <a href=\"content-cat-.html$cid\">$title</a> ";
if(!empty($page_content[$cid])){
foreach($page_content[$cid] as $value){
$content .= "  · <a href=\"contentid-.html".$value['pid']."\">".$value['title']."</a> ";

not by CSS file.

I can learn the CSS discipline, but surely it will not suffice.
I am sorry that you live in Arizona.
You'd certainly an excellent teacher for me.
Unfortunately I live in the most extreme points of Europe.
During this life I can only design systems. To make next life.

Posted: Wed Dec 09, 2009 9:06 am

Something like this should give you the main cat link. You could use bold or strong tags to make it bold.

find and replace

Code:

   $content .= '<li>' . $title;

with

Code:

   


      $content .= '<li><a href="content-cat-'.$cid.'.html">'.$title.'</a>';

Posted: Thu Dec 10, 2009 1:39 am

Thanks for your help but for me it is not enough.
Unfortunately I am not able to complete the good work done by Montego.
Please, try you to complete the block.

Posted: Thu Dec 10, 2009 3:28 am

Montego
I checked the block, also the link of the content pages are break.

Posted: Thu Dec 10, 2009 6:37 am

Eduardo, the original block code that you provided appeared to me to use ShortLinks or other form of GoogleTap, therefore, that is the style link that I provided and it works perfectly in my environment. In addition, there are NO code changes needed, only CSS, in order to get the category titles bolded and the links underlined.

Tell you what. I do not have time today to do this for you, but I will be off work tomorrow and will make these tweaks for you. HOWEVER, please let me know what type of nuke system you are running, plus version, and whether you are using ShortLinks, or GT-NExtGEn or any other type of link shortening system.

Posted: Thu Dec 10, 2009 8:58 am

RavenNuke v 2.30.02
Content Plus 2.2.1
Today I am not using ShortLinks/GT-NExtGEn.

Posted: Fri Dec 11, 2009 10:02 am

Ok, here is the completed block. Take a look at some of the configuration options that you have available:

Code:




<?php


/**


 * Content Plus: Last NN Content Pages Block


 *


 * This script may be used in either RavenNuke(tm) or PHP-Nuke along with


 * either the regular Content module or Content Plus module and is quite


 * configurable, including scrolling (not XHTML compliant).


 *


 * PHP versions 4 and 5


 *


 * LICENSE: GNU/GPL 2


 *


 * @package     RavenNuke(tm)


 * @subpackage  Content Plus


 * @category    Blocks


 * @author      Rob Herder (aka: montego) <montego@montegoscripts.com>


 * @copyright   2009 by RavenPHPScripts and Montego Scripts


 * @license     http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt GNU/GPL 2


 * @version     1.0


 * @link        http://www.ravenphpscripts.com and http://montegoscripts.com


 * @since       2.50.00


 * @uses        The configuration options below should be self-explanatory.


 */


if (!defined('BLOCK_FILE')) {


   Header('Location: ../index.php');


   die();


}


/**


 * Configuration Options


 */


$pages = 10;         // Number of pages (max) per category to show


$blkh = 10;          // Number of lines high


$blkw = 45;          // Number of characters wide 0 = unused


$scron = 0;          // Turn scrolling on by setting to 1


$scrdr = 'up';       // Scroll direction (up, down, left, or right)


$scrhg = 200;        // Scroller height in pixels


$scrwd = 145;        // Scroller width in pixels


$speed = 2;          // Speed of scroll


$scrolldelay = 75;   // Scroll delay - small the number the smoother the scroll


$showcatlink = true; // true = provide category link, false = no category link (default)





global $prefix, $db;


$content = '';


$result = $db->sql_query('SELECT `cid`, `title` FROM `' . $prefix . '_pages_categories` ORDER BY `title`');


if ($db->sql_numrows($result) > 0) {


   if ($scron == 1) {


      $content .= '<marquee behavior="scroll" direction="' . $scrdr . '" height="' . $scrhg . '" width="' . $scrwd . '" scrollamount="' . $speed . '" scrolldelay="' . $scrolldelay . '" onmouseover="this.stop()" onmouseout="this.start()"><br />';


   }


   $content .= '<div id="ContentLast"><ul>'; // special 'id' is provided so can style the <ul> tags according to personal liking via "#ContentLast ul" and "#ContentLast ul ul"


   // Cycle through each category


   while (list($cid, $title) = $db->sql_fetchrow($result)) {


      $content .= '<li>';


      if ($showcatlink) {


         $content .= '<a href="modules.php?name=Content&amp;pa=list_pages_categories&amp;cid=' . $cid . '">' . $title . '</a>';


      } else {


         $content .= $title;


      }


      $result1 = $db->sql_query('SELECT `pid`, `title` FROM `' . $prefix . '_pages` WHERE `active` = 1 AND `cid` = ' . (int)$cid . ' ORDER BY `pid` DESC LIMIT ' . $pages);


      if ($db->sql_numrows($result1) > 0) {


         $content .= '<ul>';


         // Cycle through each page within the given category


         while (list($pid, $ptitle) = $db->sql_fetchrow($result1)) {


            $content .= '<li><a href="modules.php?name=Content&amp;pa=showpage&amp;pid=' . $pid . '">' . $ptitle . '</a></li>';


         }


         $content .= '</ul>';


      }


      $content .= '</li>';


   }


   $content .= '</ul></div>';


   if ($scron == 1) {


      $content .= '</marquee>';


   }


}


?>

For your CSS, you can try the following:

Code:




#ContentLast ul {


   margin: 0;


   padding: 0;


   list-style-position: inside;


   font-weight: bold;


}





#ContentLast ul ul {


   padding-left: 1em;


   list-style-position: inside;


   font-weight: normal;


}

Style should NEVER be applied using the old HTML tags any longer.

ShortLinks/GT "taps" are not provided because you are not using them.

This should do it?

P.S. I am going to recommend this block for our 2.5.0 release and/or for Jonathan if he wishes to include with ContentPlus.