Simpnews > Hotnews6.php

Questions? Need Help? Want to share? » PHP Forum
Script Name:
Simpnews

Download:
simpnews.zip

Category:
News Publishing

Archive Content:

Content:

Admin

Admin > Css

Admin

Admin > Gfx

Admin

Admin > Help > De

Admin > Help > En

Admin

Admin > Includes

Admin > Includes > Js

Admin > Includes

Admin > Includes > Layoutpages

Admin > Includes

Admin

Admin > Js

Admin > Js > Tabbed

Admin > Language

Admin

Applet

Doc > De

Doc > En

Doc

Gfx

Gfx > Bbcodes > Highlight

Gfx > Bbcodes > Normal

Gfx

Gfx > Emoticons

Gfx

Gfx > Icons

Gfx

Help > De

Help > En

Includes

Includes > Js

Includes

Js

Language

Sfx

Content:

Hotnews6.php:


<?php
/***************************************************************************
 * (c)2002-2005 Boesch IT-Consulting (info <at> boesch-it <dot> de)
 ***************************************************************************/
$path_simpnews=dirname(__FILE__);
require_once(
$path_simpnews.'/config.php');
require_once(
$path_simpnews.'/functions.php');
if(!isset(
$sortorder))
    
$sortorder=0;
if(!isset($
$langvar) || !$$langvar)
    
$act_lang=$default_lang;
else
    
$act_lang=$$langvar;
include(
$path_simpnews.'/language/lang_'.$act_lang.'.php');
include(
$path_simpnews.'/includes/get_settings.inc');
include(
$path_simpnews.'/includes/styles2.inc');
setlocale(LC_TIME,  $def_locales[$act_lang]);
$announceavail=false;
if(!isset(
$maxannounce))
    
$maxannounce=0;
if(
$hn_linklayout)
    
$layout=$hn_linklayout;
$actdate date("Y-m-d 23:59:59");
?>
<!-- code generated by SimpNews begin -->
<table width="<?php echo $TableWidth2?>" border="0" CELLPADDING="1" CELLSPACING="0" ALIGN="<?php echo $tblalign?>" class="sntable">
<tr><TD BGCOLOR="<?php echo $bordercolor?>">
<TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
<?php
if((strlen($heading)>0) && ($hotscriptsnoheading==0))
{
?>
<TR BGCOLOR="<?php echo $headingbgcolor?>" ALIGN="CENTER">
<TD ALIGN="CENTER" VALIGN="MIDDLE" colspan="2"><font face="<?php echo $headingfont?>" size="<?php echo $headingfontsize?>" color="<?php echo $headingfontcolor?>"><b><?php echo $heading?></b></font></td></tr>
<?php
}
$sql "select * from ".$tableprefix."_misc";
if(!
$result mysql_query($sql,  $db)) {
    die(
"<tr class=\"errorrow\"><td>Could not connect to the database.");
}
if (
$myrow mysql_fetch_array($result))
{
    if(
$myrow["shutdown"]==1)
    {
?>
</tr></table></td></tr>
<tr><TD BGCOLOR="<?php echo $bordercolor?>">
<TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
<tr BGCOLOR="<?php echo $contentbgcolor?>" ALIGN="CENTER">
<TD ALIGN="CENTER" VALIGN="MIDDLE" colspan="2"><font face="<?php echo $contentfont?>" size="<?php echo $contentfontsize?>" color="<?php echo $contentfontcolor?>">
<?php
        $shutdowntext
=stripslashes($myrow["shutdowntext"]);
        
$shutdowntext undo_htmlspecialchars($shutdowntext);
        echo 
$shutdowntext;
        echo 
"</font></td></tr></table></td></tr></table>";
?>
</td></tr></table>
<?php
        
include($path_simpnews.'/includes/footer2.inc');
        echo 
"</body></html>";
        exit;
    }
}
if(
bittst($announceoptions, BIT_14) && !bittst($announceoptions, BIT_15))
{
    
$acttime=transposetime(time(), $servertimezone, $displaytimezone);
    
$tmpsql "select an.* from ".$tableprefix."_announce an,  ".$tableprefix."_hn6cats hn6 where (an.expiredate>=$acttime or an.expiredate=0)  and (an.firstdate<=$acttime or an.firstdate=0) and (an.category=hn6.catnr or an.category=0) and hn6.catnr!=0 ";
    if(
$separatebylang==1)
        
$tmpsql.="and an.lang='$act_lang' ";
    switch(
$sortorder)
    {
        case 
0:
            
$tmpsql.=" order by an.date desc";
            break;
        case 
1:
            
$tmpsql.=" order by an.date asc";
            break;
        case 
2:
            
$tmpsql.=" order by an.heading asc";
            break;
        case 
3:
            
$tmpsql.=" order by an.heading desc";
            break;
    }
    if(
$maxannounce>0)
        
$tmpsql.=" limit $maxannounce";
    else
        
$tmpsql.=" limit $anhn6numentries";
    if(!
$tmpresult mysql_query($tmpsql,  $db))
        die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
    if(
mysql_num_rows($tmpresult)>0)
    {
        echo 
"<tr bgcolor=\"$categorybgcolor\"><td align=\"left\" colspan=\"2\">";
        echo 
"<font face=\"$categoryfont\" size=\"$categoryfontsize\" color=\"$categoryfontcolor\">";
        if(!
bittst($hn_catlinking, BIT_1))
        {
            
$linkdest=$url_simpnews."/announce.php?$langvar=$act_lang&amp;layout=$layout&amp;category=-1";
            echo 
"<a title=\"$l_showcategory\" class=\"catlink\" href=\"$linkdest\" target=\"$hotnews6target\">";
        }
        echo 
get_start_tag($categorystyle);
        echo 
$l_announcements;
        echo 
get_end_tag($categorystyle);
        if(!
bittst($hn_catlinking, BIT_1))
            echo 
"</a>";
        echo 
"</font>";
        echo 
"</td></tr>";
        while(
$tmprow=mysql_fetch_array($tmpresult))
        {
            echo 
"<tr>";
            list(
$mydate, $mytime)=explode(" ", $tmprow["date"]);
            list(
$year,  $month,  $day) = explode("-",  $mydate);
            list(
$hour,  $min,  $sec) = explode(":", $mytime);
            if(
$month>0)
            {
                
$displaytime=mktime($hour, $min, $sec, $month, $day, $year);
                
$displaytime=transposetime($displaytime, $servertimezone, $displaytimezone);
                
$displaydate=strftime($news5dateformat, $displaytime);
            }
            else
                
$displaydate="";
            if(
$hotnewsicons==1)
            {
                echo 
"<td width=\"2%\" height=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\">";
                if(
$tmprow["headingicon"])
                    echo 
"<img src=\"$url_icons/".$tmprow["headingicon"]."\" border=\"0\" align=\"middle\"> ";
                echo 
"</td>";
            }
            echo 
"<td align=\"center\"><table class=\"newsbox\" width=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\" cellspacing=\"0\" cellpadding=\"0\">";
            echo 
"<tr><td align=\"left\" bgcolor=\"$timestampbgcolor\">";
            echo 
"<font face=\"$timestampfont\" size=\"$timestampfontsize\" color=\"$timestampfontcolor\">";
            if(
$tmprow["category"]==0)
                echo 
"<img style=\"margin: 1px\" src=\"$url_gfx/$gannouncepic\" border=\"0\" align=\"absmiddle\" alt=\"$l_global_announcement\" title=\"$l_global_announcement\"> ";
            else
                echo 
"<img style=\"margin: 1px\" src=\"$url_gfx/$announcepic\" border=\"0\" align=\"absmiddle\" alt=\"$l_announcement\" title=\"$l_announcement\"> ";
            echo 
get_start_tag($timestampstyle);
            echo 
$displaydate;
            echo 
get_end_tag($timestampstyle);
            echo 
"</font></td></tr>";
            if(
strlen($tmprow["heading"])>0)
            {
                echo 
"<tr bgcolor=\"$newsheadingbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$newsheadingfont\" size=\"$hn_newsheadingfontsize\" color=\"$newsheadingfontcolor\">";
                if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                {
                    if(
$usehnlinkdest==1)
                        
$linkdest="$hnlinkdestan?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                    else
                        
$linkdest=$url_simpnews."/announce.php?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                    echo 
" <a href=\"$linkdest\"";
                    if(
$hotnews6target)
                        echo 
" target=\"$hotnews6target\"";
                    echo 
">";
                }
                
$displayheading=$tmprow["heading"];
                if(
$hotnewsnohtmlformatting==1)
                    
$displayheading=strip_tags($displayheading);
                
$displayheading=do_htmlentities($displayheading);
                
$displayheading=undo_htmlspecialchars($displayheading);
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_start_tag($newsheadingstyle);
                echo 
$displayheading;
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_end_tag($newsheadingstyle);
                if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                    echo 
"</a>";
                echo 
"</font></td></tr>";
            }
            if(
$hotnewsmaxchars!=0)
            {
                echo 
"<tr bgcolor=\"$contentbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$contentfont\" size=\"$contentfontsize\" color=\"$contentfontcolor\">";
                
$displaytext=stripslashes($tmprow["text"]);
                
$displaytext undo_htmlspecialchars($displaytext);
                if((
$hotnewsmaxchars>0) && strlen($displaytext)>$hotnewsmaxchars)
                {
                    
$displaytext=str_replace("<BR>", " ", $displaytext);
                    
$displaytext=undo_htmlentities($displaytext);
                    
$displaytext=strip_tags($displaytext);
                    
$displaytext=substr($displaytext, 0, $hotnewsmaxchars);
                    
$displaytext=do_htmlentities($displaytext);
                    if(
$usehnlinkdest==1)
                        
$linkdest="$hnlinkdestan?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                    else
                        
$linkdest=$url_simpnews."/announce.php?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                    
$displaytext.=" <a href=\"$linkdest\"";
                    if(
$hotnews6target)
                        
$displaytext.=" target=\"$hotnews6target\"";
                    
$displaytext.=">[...]</a>";
                } else if(
$hotnewsnohtmlformatting==1)
                    
strip_tags($displaytext);
                echo 
$displaytext."</font></td></tr>";
            }
            if(
$hotnewsdisplayposter && (strlen($tmprow["poster"])>0))
            {
                echo 
"<tr bgcolor=\"$posterbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$posterfont\" size=\"$posterfontsize\" color=\"$posterfontcolor\">";
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_start_tag($posterstyle);
                echo 
"$l_poster: ".do_htmlentities($tmprow["poster"]);
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_end_tag($posterstyle);
                echo 
"</font></td></tr>";
            }
            echo 
"</table></td></tr>";
        }
    }
}
$catsql="select * from ".$tableprefix."_hn6cats hn6 order by catnr asc";
if(!
$catresult mysql_query($catsql,  $db))
    die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
while(
$catrow=mysql_fetch_array($catresult))
{
    if(
$catrow["catnr"]!=0)
    {
        
$tmpsql="select * from ".$tableprefix."_categories where catnr=".$catrow["catnr"];
        if(!
$tmpresult mysql_query($tmpsql,  $db))
            die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
        if(
$tmprow=mysql_fetch_array($tmpresult))
        {
            
$catname=display_encoded(stripslashes($tmprow["catname"]));
            
$tmpsql2="select * from ".$tableprefix."_catnames where catnr=".$tmprow["catnr"]." and lang='".$act_lang."'";
            if(!
$tmpresult2=mysql_query($tmpsql2, $db))
                die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
            if(
$tmprow2=mysql_fetch_array($tmpresult2))
            {
                if(
strlen($tmprow2["catname"])>0)
                    
$catname=display_encoded(stripslashes($tmprow2["catname"]));
            }
        }
        else
            
$catname=$l_unknown;
    }
    else
        
$catname=$l_general;
    echo 
"<tr bgcolor=\"$categorybgcolor\"><td align=\"left\" colspan=\"2\">";
    echo 
"<font face=\"$categoryfont\" size=\"$categoryfontsize\" color=\"$categoryfontcolor\">";
    if(!
bittst($hn_catlinking, BIT_1))
        echo 
"<a title=\"$l_showcategory\" class=\"catlink\" href=\"".$url_simpnews."/news.php?$langvar=$act_lang&amp;layout=$layout&amp;category=".$catrow["catnr"]."\" target=\"$hotnews6target\">";
    echo 
get_start_tag($categorystyle);
    echo 
$catname;
    echo 
get_end_tag($categorystyle);
    if(!
bittst($hn_catlinking, BIT_1))
        echo 
"</a>";
    echo 
"</font></td></tr>";
    if(
bittst($announceoptions, BIT_14) && bittst($announceoptions, BIT_15))
    {
        
$announceavail=false;
        
$acttime=transposetime(time(), $servertimezone, $displaytimezone);
        
$tmpsql "select * from ".$tableprefix."_announce where (expiredate>=$acttime or expiredate=0)  and (firstdate<=$acttime or firstdate=0) and category=".$catrow["catnr"];
        if(
$separatebylang==1)
            
$tmpsql.=" and lang='$act_lang'";
        switch(
$sortorder)
        {
            case 
0:
                
$tmpsql.=" order by date desc";
                break;
            case 
1:
                
$tmpsql.=" order by date asc";
                break;
            case 
2:
                
$tmpsql.=" order by heading asc";
                break;
            case 
3:
                
$tmpsql.=" order by heading desc";
                break;
        }
        if(
$maxannounce>0)
            
$tmpsql.=" limit $maxannounce";
        else
            
$tmpsql.=" limit $anhn6numentries";
        if(!
$tmpresult mysql_query($tmpsql,  $db))
            die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
        if(
mysql_num_rows($tmpresult)>0)
        {
            
$announceavail=true;
            while(
$tmprow=mysql_fetch_array($tmpresult))
            {
                echo 
"<tr>";
                list(
$mydate, $mytime)=explode(" ", $tmprow["date"]);
                list(
$year,  $month,  $day) = explode("-",  $mydate);
                list(
$hour,  $min,  $sec) = explode(":", $mytime);
                if(
$month>0)
                {
                    
$displaytime=mktime($hour, $min, $sec, $month, $day, $year);
                    
$displaytime=transposetime($displaytime, $servertimezone, $displaytimezone);
                    
$displaydate=strftime($news5dateformat, $displaytime);
                }
                else
                    
$displaydate="";
                if(
$hotnewsicons==1)
                {
                    echo 
"<td width=\"2%\" height=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\">";
                    if(
$tmprow["headingicon"])
                        echo 
"<img src=\"$url_icons/".$tmprow["headingicon"]."\" border=\"0\" align=\"middle\"> ";
                    echo 
"</td>";
                }
                echo 
"<td align=\"center\"><table class=\"newsbox\" width=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\" cellspacing=\"0\" cellpadding=\"0\">";
                echo 
"<tr><td align=\"left\" bgcolor=\"$timestampbgcolor\">";
                echo 
"<font face=\"$timestampfont\" size=\"$timestampfontsize\" color=\"$timestampfontcolor\">";
                if(
$tmprow["category"]==0)
                    echo 
"<img style=\"margin: 1px\" src=\"$url_gfx/$gannouncepic\" border=\"0\" align=\"absmiddle\" alt=\"$l_global_announcement\" title=\"$l_global_announcement\"> ";
                else
                    echo 
"<img style=\"margin: 1px\" src=\"$url_gfx/$announcepic\" border=\"0\" align=\"absmiddle\" alt=\"$l_announcement\" title=\"$l_announcement\"> ";
                echo 
get_start_tag($timestampstyle);
                echo 
$displaydate;
                echo 
get_end_tag($timestampstyle);
                echo 
"</font></td></tr>";
                if(
strlen($tmprow["heading"])>0)
                {
                    echo 
"<tr bgcolor=\"$newsheadingbgcolor\"><td align=\"left\">";
                    echo 
"<font face=\"$newsheadingfont\" size=\"$hn_newsheadingfontsize\" color=\"$newsheadingfontcolor\">";
                    if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                    {
                        if(
$usehnlinkdest==1)
                            
$linkdest="$hnlinkdestan?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                        else
                            
$linkdest=$url_simpnews."/announce.php?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                        echo 
" <a href=\"$linkdest\"";
                        if(
$hotnews6target)
                            echo 
" target=\"$hotnews6target\"";
                        echo 
">";
                    }
                    
$displayheading=$tmprow["heading"];
                    if(
$hotnewsnohtmlformatting==1)
                        
$displayheading=strip_tags($displayheading);
                    
$displayheading=do_htmlentities($displayheading);
                    
$displayheading=undo_htmlspecialchars($displayheading);
                    if(
$hotnewsnohtmlformatting==0)
                        echo 
get_start_tag($newsheadingstyle);
                    echo 
$displayheading;
                    if(
$hotnewsnohtmlformatting==0)
                        echo 
get_end_tag($newsheadingstyle);
                    if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                        echo 
"</a>";
                    echo 
"</font></td></tr>";
                }
                if(
$hotnewsmaxchars!=0)
                {
                    echo 
"<tr bgcolor=\"$contentbgcolor\"><td align=\"left\">";
                    echo 
"<font face=\"$contentfont\" size=\"$contentfontsize\" color=\"$contentfontcolor\">";
                    
$displaytext=stripslashes($tmprow["text"]);
                    
$displaytext undo_htmlspecialchars($displaytext);
                    if((
$hotnewsmaxchars>0) && strlen($displaytext)>$hotnewsmaxchars)
                    {
                        
$displaytext=str_replace("<BR>", " ", $displaytext);
                        
$displaytext=undo_htmlentities($displaytext);
                        
$displaytext=strip_tags($displaytext);
                        
$displaytext=substr($displaytext, 0, $hotnewsmaxchars);
                        
$displaytext=do_htmlentities($displaytext);
                        if(
$usehnlinkdest==1)
                            
$linkdest="$hnlinkdestan?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                        else
                            
$linkdest=$url_simpnews."/announce.php?$langvar=$act_lang&layout=$layout&category=".$tmprow["category"]."&announcenr=".$tmprow["entrynr"];
                        
$displaytext.=" <a href=\"$linkdest\"";
                        if(
$hotnews6target)
                            
$displaytext.=" target=\"$hotnews6target\"";
                        
$displaytext.=">[...]</a>";
                    } else if(
$hotnewsnohtmlformatting==1)
                        
strip_tags($displaytext);
                    echo 
$displaytext."</font></td></tr>";
                }
                if(
$hotnewsdisplayposter && (strlen($tmprow["poster"])>0))
                {
                    echo 
"<tr bgcolor=\"$posterbgcolor\"><td align=\"left\">";
                    echo 
"<font face=\"$posterfont\" size=\"$posterfontsize\" color=\"$posterfontcolor\">";
                    if(
$hotnewsnohtmlformatting==0)
                        echo 
get_start_tag($posterstyle);
                    echo 
"$l_poster: ".do_htmlentities($tmprow["poster"]);
                    if(
$hotnewsnohtmlformatting==0)
                        echo 
get_end_tag($posterstyle);
                    echo 
"</font></td></tr>";
                }
                echo 
"</table></td></tr>";
            }
        }
    }
    
$sql "select * from ".$tableprefix."_data dat where category=".$catrow["catnr"];
    if(
$separatebylang==1)
        
$sql.=" and lang='$act_lang'";
    
$sql.=" and date<='$actdate'";
    switch(
$sortorder)
    {
        case 
0:
            
$sql.=" order by date desc";
            break;
        case 
1:
            
$sql.=" order by date asc";
            break;
        case 
2:
            
$sql.=" order by heading asc";
            break;
        case 
3:
            
$sql.=" order by heading desc";
            break;
    }
    
$sql.=" limit $hn6_numentries";
    if(!
$result mysql_query($sql,  $db))
        die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
    if(!
$myrow=mysql_fetch_array($result))
    {
        if(!
$announceavail)
        {
            echo 
"<tr>";
            echo 
"<td align=\"center\" bgcolor=\"$contentbgcolor\">";
            echo 
$l_nonewnews;
            echo 
"<font face=\"$contentfont\" size=\"$contentfontsize\" color=\"$contentfontcolor\">";
            echo 
"</font></td></tr>";
        }
    }
    else
    {
        do
        {
            if(
$myrow["linknewsnr"]==0)
                
$entrydata=$myrow;
            else
            {
                
$tmpsql="select * from ".$tableprefix."_data where newsnr=".$myrow["linknewsnr"];
                if(!
$tmpresult mysql_query($tmpsql,  $db))
                    die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
                if(!
$tmprow=mysql_fetch_array($tmpresult))
                    die(
"<tr class=\"errorrow\"><td>Unable to get data");
                
$entrydata=$tmprow;
            }
            list(
$mydate, $mytime)=explode(" ", $myrow["date"]);
            list(
$year,  $month,  $day) = explode("-",  $mydate);
            list(
$hour,  $min,  $sec) = explode(":", $mytime);
            if(
$month>0)
            {
                
$displaytime=mktime($hour, $min, $sec, $month, $day, $year);
                
$displaytime=transposetime($displaytime, $servertimezone, $displaytimezone);
                
$displaydate=strftime($news5dateformat, $displaytime);
            }
            else
                
$displaydate="";
            echo 
"<tr>";
            if(
$hotnewsicons==1)
            {
                echo 
"<td width=\"2%\" height=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\">";
                if(
$entrydata["headingicon"])
                    echo 
"<img src=\"$url_icons/".$entrydata["headingicon"]."\" border=\"0\" align=\"middle\"> ";
                echo 
"</td>";
            }
            echo 
"<td align=\"center\"><table class=\"newsbox\" width=\"100%\" align=\"center\" bgcolor=\"$contentbgcolor\" cellspacing=\"0\" cellpadding=\"0\">";
            echo 
"<tr><td align=\"left\" bgcolor=\"$timestampbgcolor\">";
            echo 
"<font face=\"$timestampfont\" size=\"$timestampfontsize\" color=\"$timestampfontcolor\">";
            echo 
get_start_tag($timestampstyle);
            echo 
$displaydate;
            echo 
get_end_tag($timestampstyle);
            if(isset(
$lastvisitdate))
            {
                list(
$mydate, $mytime)=explode(" ", $myrow["date"]);
                list(
$year,  $month,  $day) = explode("-",  $mydate);
                list(
$hour,  $min,  $sec) = explode(":", $mytime);
                
$thisentrydate=mktime($hour, $min, $sec, $month, $day, $year);
                if(
$thisentrydate>=$lastvisitdate)
                    echo 
"&nbsp;&nbsp;<img src=\"$url_gfx/$newentrypic\" border=\"0\" align=\"absmiddle\">";
            }
            echo 
"</font></td>";
            
$srcscript=$url_simpnews."/news.php";
            if((
$allowcomments==1) && ($entrydata["allowcomments"]==1) && ($hotnewscommentslink==1))
            {
                
$tempsql="select * from ".$tableprefix."_comments where entryref=".$entrydata["newsnr"];
                if(!
$tempresult mysql_query($tempsql,  $db))
                    die(
"<tr class=\"errorrow\"><td>Unable to connect to database.".mysql_error());
                
$numcomments=mysql_num_rows($tempresult);
                if(
$numcomments>0)
                {
                    echo 
"<td align=\"right\" bgcolor=\"$timestampbgcolor\" width=\"10%\" valign=\"top\">";
                    echo 
"<font face=\"$timestampfont\" size=\"$timestampfontsize\" color=\"$timestampfontcolor\">";
                    if(
$commentsinline==0)
                        
$commentlink=$url_simpnews."/comment.php?mode=display&amp;$langvar=$act_lang&amp;entryref=".$entrydata["newsnr"];
                    else
                    {
                        if(
$usehnlinkdest)
                            
$commentlink=$hnlinkdest;
                        else
                            
$commentlink=$url_simpnews."/singlenews.php";
                        
$commentlink.="?$langvar=$act_lang&layout=$layout&category=".$entrydata["category"]."&newsnr=".$entrydata["newsnr"]."&srcscript=$srcscript";
                    }
                    echo 
"<a class=\"commentlink\" href=\"$commentlink\">";
                    if(
$commentspic)
                        echo 
"<img style=\"margin: 1px\" src=\"".$url_gfx."/$commentspic\" border=\"0\" alt=\"$l_comments$numcomments\" title=\"$l_comments$numcomments\">";
                    else
                        echo 
"$l_comments:&nbsp;$numcomments";
                    echo 
"</a>&nbsp;</font></td>";
                }
            }
            echo 
"</tr>";
            if(
strlen($entrydata["heading"])>0)
            {
                echo 
"<tr bgcolor=\"$newsheadingbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$newsheadingfont\" size=\"$hn_newsheadingfontsize\" color=\"$newsheadingfontcolor\">";
                if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                {
                    if(
$usehnlinkdest==1)
                        
$linkdest="$hnlinkdest?$langvar=$act_lang&layout=$layout&category=".$entrydata["category"]."&newsnr=".$entrydata["newsnr"]."&srcscript=$srcscript";
                    else
                        
$linkdest=$url_simpnews."/singlenews.php?$langvar=$act_lang&layout=$layout&category=".$entrydata["category"]."&newsnr=".$entrydata["newsnr"]."&srcscript=$srcscript";
                    echo 
" <a href=\"$linkdest\"";
                    if(
$hotnews6target)
                        echo 
" target=\"$hotnews6target\"";
                    echo 
">";
                }
                
$displayheading=$entrydata["heading"];
                if(
$hotnewsnohtmlformatting==1)
                    
$displayheading=strip_tags($displayheading);
                
$displayheading=do_htmlentities($displayheading);
                
$displayheading=undo_htmlspecialchars($displayheading);
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_start_tag($newsheadingstyle);
                echo 
$displayheading;
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_end_tag($newsheadingstyle);
                if((
$hotnewsmaxchars<1) && ($hnnolinking==0))
                    echo 
"</a>";
                echo 
"</font></td></tr>";
            }
            if(
$hotnewsmaxchars!=0)
            {
                echo 
"<tr bgcolor=\"$contentbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$contentfont\" size=\"$contentfontsize\" color=\"$contentfontcolor\">";
                
$displaytext=stripslashes($entrydata["text"]);
                
$displaytext undo_htmlspecialchars($displaytext);
                if((
$hotnewsmaxchars>0) && strlen($displaytext)>$hotnewsmaxchars)
                {
                    
$displaytext=str_replace("<BR>", " ", $displaytext);
                    
$displaytext=undo_htmlentities($displaytext);
                    
$displaytext=strip_tags($displaytext);
                    
$displaytext=substr($displaytext, 0, $hotnewsmaxchars);
                    
$displaytext=display_encoded($displaytext);
                    
$srcscript=$url_simpnews."/news.php";
                    if(
$usehnlinkdest==1)
                        
$linkdest="$hnlinkdest?$langvar=$act_lang&layout=$layout&category=".$entrydata["category"]."&newsnr=".$entrydata["newsnr"]."&srcscript=$srcscript";
                    else
                        
$linkdest=$url_simpnews."/singlenews.php?$langvar=$act_lang&layout=$layout&category=".$entrydata["category"]."&newsnr=".$entrydata["newsnr"]."&srcscript=$srcscript";
                    
$displaytext.=" <a href=\"$linkdest\"";
                    if(
$hotnews6target)
                        
$displaytext.=" target=\"$hotnews6target\"";
                    
$displaytext.=">[...]</a>";
                } else if(
$hotnewsnohtmlformatting==1)
                    
strip_tags($displaytext);
                echo 
$displaytext."</font></td></tr>";
            }
            if(
$hotnewsdisplayposter && (strlen($entrydata["poster"])>0))
            {
                echo 
"<tr bgcolor=\"$posterbgcolor\"><td align=\"left\">";
                echo 
"<font face=\"$posterfont\" size=\"$posterfontsize\" color=\"$posterfontcolor\">";
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_start_tag($posterstyle);
                echo 
"$l_poster: ".do_htmlentities($entrydata["poster"]);
                if(
$hotnewsnohtmlformatting==0)
                    echo 
get_end_tag($posterstyle);
                echo 
"</font></td></tr>";
            }
            echo 
"</table></td></tr>";
        }while(
$myrow=mysql_fetch_array($result));
    }
}
echo 
"</table></td></tr></table>";
include(
$path_simpnews.'/includes/footer2.inc');
?>


Other News Publishing Scripts:

WebMaster Resources Home

©RingsWorld.com