Forums / Setup & design / Listing order of embedded articles?

Listing order of embedded articles?

Author Message

Knut Nes

Tuesday 04 October 2005 5:19:24 am

This is probably quite easy, but I can't figure it out. On the front page I have put a box listing the contents of the article page. The problem is that the oldest articles are on top, so the embedded list box is always displaying the same old articles. That is pretty meaningless.

How do I fix this? What template?

Thanks
Knut

Knut Nes

Thursday 13 October 2005 5:22:39 am

Didn't I manage to express myself? Still hoping for some help here.

Knut

Xavier Dutoit

Thursday 13 October 2005 6:08:16 am

I did a quick fix on the kernel to set the order.

--- kernel/classes/ezcontentobject.php  (revision 13696)
+++ kernel/classes/ezcontentobject.php  (working copy)
@@ -1968,7 +1968,9 @@
                                     ezcontentobject_link.from_contentobject_id='$fromObjectID' AND
                                     ezcontentobject_link.from_contentobject_version='$fromObjectVersion' AND
                                     contentclassattribute_id=$attributeID
-                                    $versionNameJoins" );
+                                    $versionNameJoins
+                                 ORDER BY
+                                    ezcontentobject.published DESC" );

http://www.sydesy.com

Knut Nes

Monday 17 October 2005 2:02:37 am

Thanks for your reply.

Unfortunately this doesn't seem to work out for me. I removed the one line and added the three other ones in the php file. I refreshed my page and found no changes. I cleared the "content view cache" (or what's it's name), refreshed and found no changes.

Have I missed something to get this to work?

I'm using the <embed href="ezobject://...">, just to be clear on what I'm talking about.

Thanks
Knut

eZ debug

Timing: Jan 31 2025 06:04:17
Script start
Timing: Jan 31 2025 06:04:17
Module start 'content'
Timing: Jan 31 2025 06:04:17
Module end 'content'
Timing: Jan 31 2025 06:04:18
Script end

Main resources:

Total runtime0.1874 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0062 587.9531180.8281
Module start 'content' 0.00620.0062 768.781394.0078
Module end 'content' 0.01230.1750 862.7891522.2031
Script end 0.1874  1,384.9922 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00351.8508200.0002
Check MTime0.00140.7494200.0001
Mysql Total
Database connection0.00100.510610.0010
Mysqli_queries0.139874.55941410.0010
Looping result0.00080.45031390.0000
Template Total0.174693.210.1746
Template load0.00090.472710.0009
Template processing0.173792.690510.1737
Override
Cache load0.00060.310510.0006
Sytem overhead
Fetch class attribute can translate value0.00050.261910.0005
XML
Image XML parsing0.00020.125910.0002
General
dbfile0.00934.9444200.0005
String conversion0.00000.009230.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0002 secs