[HELP] RevCMS news sorted by post date?

[Abidas]

Hello fellow Rev users, I would like to know if it's possible to make the RevCMS news page look like:

Instead of:

And if so, how is it done?

med venlig hilsen.

 

[JayC]

Yes? Just edit the box for it , figure out what page its on an just edit whats inside the box.

 

[Occult]

*BUMP*
Desperate to know how this can be done for RevCMS, as they have done it on Habboon.

No offence @JayCustom but that was the least helpful post I've ever seen on DevBest.

 

[Khalil]

I'm pretty sure you could just go to class.forms.php and edit where it says 'ORDER BY id' to 'ORDER BY date' or w/e the column is called in the 'cms_news' table.

You must be registered for see links

&

You must be registered for see links

 

[Abidas]

Hai, I haven't been on DevBest for a while, and just noticed this old thread. If anyone is interested in a fix, I found on - here you go:

1. Open news.php and replace {newslist} with;

Spoiler

<?php
for ($i = 0; $i < 7; $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() - (60 * 60 * 24 * 365);
break;
}

$q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax . " ORDER BY published DESC LIMIT 50";
$getArticles = mysql_query($q);

if (mysql_num_rows($getArticles) > 0)
{
echo '<h2>' . $sectionName . '</h2>
<ul>';

while ($a = mysql_fetch_assoc($getArticles))
{
?>

<li><?php if($news_id !== $a['id']){ echo"<a href=\"".$path."/index.php?url=news&id=".$a['id']."\">"; } ?>
<?php echo $a['title']; ?> &raquo;</a>
<?php if($news_id !== $a['id']){ echo"</a>"; } ?></li>
<?php }
echo '</ul>';
}
}
?>

 

[Wickd]

Hai, I haven't been on DevBest for a while, and just noticed this old thread. If anyone is interested in a fix, I found on - here you go:

1. Open news.php and replace {newslist} with;

Spoiler

<?php
for ($i = 0; $i < 7; $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() - (60 * 60 * 24 * 365);
break;
}

$q = "SELECT * FROM cms_news WHERE published >= " . $sectionCutoffMin . " AND published <= " . $sectionCutoffMax . " ORDER BY published DESC LIMIT 50";
$getArticles = mysql_query($q);

if (mysql_num_rows($getArticles) > 0)
{
echo '<h2>' . $sectionName . '</h2>
<ul>';

while ($a = mysql_fetch_assoc($getArticles))
{
?>

<li><?php if($news_id !== $a['id']){ echo"<a href=\"".$path."/index.php?url=news&id=".$a['id']."\">"; } ?>
<?php echo $a['title']; ?> &raquo;</a>
<?php if($news_id !== $a['id']){ echo"</a>"; } ?></li>
<?php }
echo '</ul>';
}
}
?>

Not sure that'll work.

 

[Wickd]

Yep i was right it'll just "break"

 

[Abidas]

Yep i was right it'll just "break"

What do you mean?

You must be registered for see links

 

[IWillSmackYou]

Yep i was right it'll just "break"

Obviously it is just a break the sql do all the work

 

[Wickd]

Obviously it is just a break the sql do all the work

No they don't.Well maybe 50/50?
You can use this one

You must be registered for see links