News Script Change

[Sonic 296]

Over the past few days I've been testing out a better news posting script for the site, thats why you haven't seen any news updates for past few days. Its all up and running now. Our news script now features a working news comments system so please take advantage of it. It also has an RSS feed for those who want it. I'll still be making various tweaks and changes but news updates will resume.

 

Please test out the news comments system for any bugs and/or changes that should be made.

[Saracen 16]

Could comments posted be put in chronological order from the oldest at at top to the newest at the bottom, like the forums.

[Tree 0]

What news system is it, Sonic?

[Sonic 296]

Could comments posted be put in chronological order from the oldest at at top to the newest at the bottom, like the forums.

There is no option in the settings to make this type of change, it would require editing the of the script files which isn't really my thing. I don't know what to look for.

I will post a question about this at authors site and see what response I get.

 

What news system is it, Sonic?

Its called Kreative News, site is here http://www.kreative-studios.com. If you scroll to the bottom of the news page the name and link are there

[Tree 0]

Ahhh, K2. That's a good system. Unleashed uses it (or at least used to).

 

Much better than CuteNews in many areas, although it is significantly more complex.

[fire_fox_1990 0]

dang havent nodest it thats cool

[Sonic 296]

Ahhh, K2. That's a good system. Unleashed uses it (or at least used to).

 

Much better than CuteNews in many areas, although it is significantly more complex.

Yes it is more complex but that also means its more flexiable. I used K2News a couple of years ago when it was still an early beta release but it was quickly replaced since it way to unstable and full of bugs. It's much more improved now of course

 

CuteNews is still good but I would only use it for a small site that only gets a few updates rather than a site that gets updated almost daily. Plus since it uses flat files it can can cause problems. Lion had his share problems with CuteNews on CNC Den I think.

[Thierry 0]

Could comments posted be put in chronological order from the oldest at at top to the newest at the bottom, like the forums.

There is no option in the settings to make this type of change, it would require editing the of the script files which isn't really my thing. I don't know what to look for.

I will post a question about this at authors site and see what response I get.

 

What news system is it, Sonic?

Its called Kreative News, site is here http://www.kreative-studios.com. If you scroll to the bottom of the news page the name and link are there

 

I dont think changing that would be very difficult. Just find the query that gets the comments and then find the ORDER BY part. If it aint there (put it after the WHERE) then add it. If you want it ordered like C&C King said, you'll have to order it like this ORDER BY comment_table_id DESC.

Comment_table_id is ofcourse the name of the auto-numeric number of the comment table.

[Sonic 296]

I got a reply from someone on the www.kreative-studios.com forums about this. The comments are now in reverse order with the latest being at the bottom.

 

For those who understand, Thierry was on the right track....

$sqlbo = mysql_query("SELECT * FROM " . $tprefix . "comments WHERE newsid='" . $newsid . "' ORDER BY commentstamp ASC ");

 

I simply changed ORDER BY commentstamp DESC to ORDER BY commentstamp ASC. In the end its damn simple

[TheBlackOut 7]

I got a reply from someone on the www.kreative-studios.com forums about this. The comments are now in reverse order with the latest being at the bottom.

 

For those who understand, Thierry was on the right track....

$sqlbo = mysql_query("SELECT * FROM " . $tprefix . "comments WHERE newsid='" . $newsid . "' ORDER BY commentstamp ASC ");

 

I simply changed ORDER BY commentstamp DESC to ORDER BY commentstamp ASC. In the end its damn simple

 

Simple eh? :shot:

[Tree 0]

If you any PHP/MySQL, then yes.

 

If you took a look at the original code, and noticed that only one operateor was changed, then yes it is easy.

 

:roll: