next »

[Mark]

homepagedisplay by Mark Kaplan
Instructions: Please create a tv with a checkbox titled something like "Promote to home page". Then look up in the db which tmplvarid it is in the site_tmplvar_contentvalues table. If it is your first tv ever it will be 1. Enter this value for $tempid. Then add this snippet to your homepage and promote some documents. You are set. If you have any text in the summary field it will be displayed instead of the shortened content by default (very handy if you experience formatting issues)

Example of TV:

Note: I changed the english lang file to use options instead of template variables to make it easier for the end user.

If you need assistance post here in this thread, I will be glad to help.

Code:

Code:

//homepagedisplay by Mark Kaplan
//Please create a tv with a checkbox titled something like "Promote to home page". Then look up in the db which tmplvarid it is in the site_tmplvar_contentvalues table. If it is your first tv ever it will be 1. Enter this value for $tempid. Then add this snippet to your homepage and promote some documents. You are set. If you have any text in the summary field it will be displayed instead of the shortened content by default (very handy if you experience formatting issues)

//BEGIN CONFIG
$lentoshow = 425; // Number of characters to display of the document
$nr = 5; // Number of documents to show
$tempid = 1; // ID of checkbox tv
$showcategory = true; //Set to true to disply the parent document's title otherwise set to false
//END CONFIG

$tbl = "".$this->dbConfig['table_prefix']."site_tmplvar_contentvalues";
$tbl2 = "".$this->dbConfig['table_prefix']."site_content";

$ftbl = $this->dbConfig['dbase'].".".$this->dbConfig['table_prefix']."site_tmplvar_contentvalues";
$ftbl2 = $this->dbConfig['dbase'].".".$this->dbConfig['table_prefix']."site_content";

$sql = "SELECT $tbl2.id, pagetitle, description, content, introtext, createdon, parent FROM $ftbl,$ftbl2 WHERE published=1 AND deleted=0 AND tmplvarid=$tempid AND value='Yes' AND $tbl.contentid = $tbl2.id ORDER BY createdon DESC";

$rs = $modx->dbQuery($sql);
$limit = $modx->recordCount($rs);

if($limit<1) {
   $output = "No documents found.<br />";
}

$nrvalue = $nr<$limit ? $nr : $limit;
$extendvalue = isset($extend);
if ($extendvalue == TRUE){$nrvalue = $limit; $lentoshow = 0;}
for ($x = 0; $x < $nrvalue; $x++) {
$resource = $modx->fetchRow($rs);

// show summary
if(strlen($resource['introtext'])>0) {
           if ($extendvalue != TRUE){ $rest = $resource['introtext'];
if(strlen($resource['content'])>0) $rest .= "...<br /><br /><a href='[~".$resource['id']."~]'>More on this story ></a>"; }
} else if(strlen($resource['content'])>$lentoshow) {
// strip the content
if ($extendvalue != TRUE){
            $rest = substr($resource['content'], 0, $lentoshow);
            $rest .= "...<br /><br /><a href='[~".$resource['id']."~]'>More on this story ></a>"; }
        } else {
            if ($extendvalue != TRUE){ $rest = $resource['content']; }
        }
$pid = $resource['parent'];
$parent = $modx->getPageInfo($pid);



     

//FORMAT HERE     


if ($extendvalue == TRUE){

$output .= "<div class='contentbox'><div class='newsbg'><b><a href='[~".$resource['id']."~]'>".$resource['pagetitle']."</a></b> --- <i>".strftime("%A, %B %d, %Y", $resource['createdon'])."</i></div><br /></div><br />";
}

else {

$output .= "<div class='contentbox'><div class='newsbg'><b>";

if ($showcategory == true) {

$output .= "<a href='[~".$parent['id']."~]'>".$parent['pagetitle']."</a> &raquo;";
}

$output .= "".$resource['pagetitle']."</b> --- <i>".strftime("%A, %B %d, %Y", $resource['createdon'])."</i></div><br />".$rest."</div><br />";

}


//END FORMAT

}

if ($extendvalue != TRUE){
$output .= "<div style='text-align:center;'><a href='[~50~]'>Archive</a></div>";}
return $output;

[zi]

Thanks for nice Snippet !!

Regards,

zi

[Mark]

Thanks for nice Snippet !!

Regards,

zi

Your welcome

[Dimmy]

I am not realy sure what this does...
Is it like a news thing but than you can select by a TV what docs it wil show?

if this is the case its superb was looking for a snippet like that.
if not pleas explain and maybe you have a demo url?

[Mark]

Is it like a news thing but than you can select by a TV what docs it wil show?

Yes

if this is the case its superb was looking for a snippet like that.

Thanks

maybe you have a demo url?

I am unsure as how to create a demo since it could be a security risk, but I could post screenshots if people would like.

[Mark]

How did it work for you Dimmy?

[Mark]

I have updated the first post with a newer version with several fixes and improvements.

Could someone advise on how to allow a user to enter a tv name instead of its id for use with this snippet?

Thanks in advance!

[Dimmy]

How did it work for you Dimmy?

Worked great I use it on www.eljakim.nu for the news item in the lamplight

[Djamoer]

This is a cool snippet. Any thought in integrating this one with tv name, instead of tv id?

[banzai]

Great snippet, but i think now you can use newlisting tvars filter.

[Mark]

Yes, NewsListing in the snippet to use now... Thanks to multiple levels and tv filters this snippet is now obsolete (hey I'm deprecating one of my own snippets and sending users to another of my snippets!).

[sottwell]

But does it have a feature for displaying a random selection?

[Dimmy]

It still worked nice for me tho hehe
I edited the snippet to have classes and show not only the introtext but also the pagetitle and have a nother class for the read more part

[Djamoer]

I guess, I will put down the snippet for the sake of the author itself.