[RevCMS]News List - News Archiving (Today, Yesterday, Last Week)

[Wickd]

Hey DevBest, Wickd here.
I'll be releasing a small script that allows News Archiving on RevCMS!I hope you boys will enjoy this!

How to set up this script? (If running on r63b make sure you change from "cms_news" to "site_news")

• Locate "
  <div id="article-archive">
  <ul>"
• After that paste this code
  

  <?php
                                                                          {
                                                                                  for ($i = 0; $i < 6; $i++)
                                                                                  {
                                                                                          $sectionName = "";
                                                                                          $sectionCutoffMax = 0;
                                                                                          $sectionCutoffMin = 0;
                                                                                        
                                                                                          switch ($i)
                                                                                          {
                                                                                                  case 0:
                                                                                                
                                                                                                          $sectionName = 'Today';
                                                                                                          $sectionCutoffMax = time();
                                                                                                          $sectionCutoffMin = time() - 86400;
                                                                                                          break;
                                                                                                        
                                                                                                  case 1:
                                                                                                
                                                                                                          $sectionName = 'Yesterday';
                                                                                                          $sectionCutoffMax = time() - 86400;
                                                                                                          $sectionCutoffMin = time() - 172800;
                                                                                                          break;
                                                                                                        
                                                                                                  case 2:
                                                                                                
                                                                                                          $sectionName = 'This week';
                                                                                                          $sectionCutoffMax = time() - 172800;
                                                                                                          $sectionCutoffMin = time() - 604800;
                                                                                                          break;
                                                                                                        
                                                                                                  case 3:
                                                                                                
                                                                                                          $sectionName = 'Last week';
                                                                                                          $sectionCutoffMax = time() - 604800;
                                                                                                          $sectionCutoffMin = time() - 1209600;
                                                                                                          break;
                                                                                                        
                                                                                                  case 4:
                                                                                                
                                                                                                          $sectionName = 'This month';
                                                                                                          $sectionCutoffMax = time() - 1209600;
                                                                                                          $sectionCutoffMin = time() - 2592000;
                                                                                                          break;
                                                                                                        
                                                                                                  case 5:
                                                                                                
                                                                                                          $sectionName = 'Last month';
                                                                                                          $sectionCutoffMax = time() - 2592000;
                                                                                                          $sectionCutoffMin = time() - 5184000;
                                                                                                          break;
                                                                                          }
                                                                                        
                                                                                          $q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax .  " ORDER BY published DESC";
                                                                                          $getArticles = mysql_query($q);
                                                                                          if (mysql_num_rows($getArticles) > 0)
                                                                                          {
                                                                                                  echo '<h2>' . $sectionName . '</h2>
                                                                                                  <ul>';
                                                                                                
                                                                                                  while ($a = mysql_fetch_assoc($getArticles))
                                                                                                  {
                                                                                                          echo '<li>            
                                                                                                                  <a href="http://lwickedev.net/index.php?url=news&id=' . $a['id'] . '">' . $a['title'] . '&nbsp;&raquo;</a>
                                                                                                          </li>';
                                                                                                  }
                                                                                                
                                                                                                  echo '</ul>';
                                                                                          }
                                                                                  }
                                                                          }
                                                                          ?>

 

[twentyfour]

works beautifully! just needs some css touchup. another thing for r63b users:
change

$q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax .  " ORDER BY published DESC";

to

$q = "SELECT * FROM site_news WHERE timestamp >= " . $sectionCutoffMin . " AND timestamp <= " . $sectionCutoffMax .  " ORDER BY timestamp DESC";

well, mines is called timestamp, im not sure about everyone else

 

[Zephyrus]

Very good. <3

 

[Wickd]

Very good. <3

Thanks man.

 

[luisbestretros]

Nice!

 

[Wickd]

Nice!

Yes!

 

[Janzeer]

Where do you locate this? "
<div id="article-archive">
<ul>" " can't seem to find in my news.php.

 

[Wickd]

Try using CTRL-H.

 

[Balls]

Good code<3

 

[Janzeer]

Try using CTRL-H.

Tried lmao.

 

[Wickd]

Tried lmao.

Well it's there.lol
 

Good code<3

Thanks.

 

[JackH]

You didn't even make this, this is directly taken from Uber and you converted it. Takes like 5 minutes

 

[Sledmore]

It's nice, but the actual full archive would be nicer.

And I also believe JackH is correct.

 

[Proximity]

Nice WIckd!!!!

 

[TheRealMoonman]

nice

 

[Wickd]

You didn't even make this, this is directly taken from Uber and you converted it. Takes like 5 minutes

That's exactly what i did.

 

[Proximity]

HAHAH grats on that @Wickd

 

[JackH]

Here, I added this to my hotel and realised it wouldn't show you what article you had picked (Like it does on Uber). So I fixed it up for you

<?php
    {
    for ($i = 0; $i < 6; $i++)
        {
            $sectionName = "";
            $sectionCutoffMax = 0;
            $sectionCutoffMin = 0;
        
            switch ($i)
            {
                    case 0:
                
                            $sectionName = 'Today';
                            $sectionCutoffMax = time();
                            $sectionCutoffMin = time() - 86400;
                            break;
                        
                    case 1:
                
                            $sectionName = 'Yesterday';
                            $sectionCutoffMax = time() - 86400;
                            $sectionCutoffMin = time() - 172800;
                            break;
                        
                    case 2:
                
                            $sectionName = 'This week';
                            $sectionCutoffMax = time() - 172800;
                            $sectionCutoffMin = time() - 604800;
                            break;
                        
                    case 3:
                
                            $sectionName = 'Last week';
                            $sectionCutoffMax = time() - 604800;
                            $sectionCutoffMin = time() - 1209600;
                            break;
                        
                    case 4:
                
                            $sectionName = 'This month';
                            $sectionCutoffMax = time() - 1209600;
                            $sectionCutoffMin = time() - 2592000;
                            break;
                        
                    case 5:
                
                            $sectionName = 'Last month';
                            $sectionCutoffMax = time() - 2592000;
                            $sectionCutoffMin = time() - 5184000;
                            break;
            }
        
            $q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax .  " ORDER BY published DESC";
            $getArticles = mysql_query($q);
            if (mysql_num_rows($getArticles) > 0)
            {
                    echo '<h2>' . $sectionName . '</h2>';
                
                    while ($a = mysql_fetch_assoc($getArticles))
                    {
                        if($a['id'] == $_GET['id'])
                        {
                        echo '' . $a['title'] . '&nbsp;&raquo;';
                        }
                        else
                        {
                        echo '<li><a href="/index.php?url=news&id=' . $a['id'] . '">' . $a['title'] . '&nbsp;&raquo;</a></li>';
                        }
                    }
            }
        }
    }
?>

Here's some screenshots:

 

[Lotus]

A new function is better than staying the same.

 

[Proximity]

I like that Jack!