Lenny

Thanks again Stefan! I have other questions, but they are for another thread .. I’m also very happy to donate ??

Stefan,

Thanks for the help! That worked perfectly!

A question Stefan .. Is is safe to have multiple tables on a single page sorted like above? Is there any server load risks or other type of concerns in your opinion?

example:

[wctable id=”4″ limit=”5″ filter=”name=’david’ AND week=’42′”]
[wctable id=”4″ limit=”5″ filter=”name=’andrew’ AND week=’42′”]
[wctable id=”4″ limit=”5″ filter=”name=’mary’ AND week=’42′”]
[wctable id=”4″ limit=”5″ filter=”name=’drew’ AND week=’42′”]
[wctable id=”4″ limit=”5″ filter=”name=’albert’ AND week=’42′”]
[wctable id=”4″ limit=”5″ filter=”name=’constance’ AND week=’42′”]

etc..

This list could become pretty long and could have more than 100 names on a single page which equals 100 queries?

Any concerns?

Thanks again Stefan..

In the latest version 1.4.0 this is now line 317

Change from

$album->sortorder = serialize( $wpdb->get_col(“SELECT gid FROM $wpdb->nggallery”) );

To

$album->sortorder = serialize( $wpdb->get_col(“SELECT gid FROM $wpdb->nggallery ORDER BY gid DESC”) );

All – My issue was resolved in NextGEN Gallery Version 1.4.0

Don’t know why ..

@alexrabe I disabled it when I noticed no one was looking at this thread.. It’s back up now, and working..

@vschafer That didn’t help – I had seen it before – but definitely appreciate the share. I’m sure it helped others ??

Bump anyone?

I’m sorry versions are..

WP 2.8.5
NextGen 1.3.6

@mfields This sounds like it would work – but what about pages where I list “Category = Events” .. They wont show up in correct order..

Bump?

@ipstenu Exactly..

I don’t use WP in the common way in the case of this particular site. I have a home page where there is a sidebar that shows upcoming Events (displayed by piping the events category into the query). When I dont schedule the posts (events) and post them immediately, they show up and the events never update in this sidebar. The scheduling allows me to schedule them and they update nicely in this sidebar.

This works just fine – no problems here – so the scheduler is fine.

The problem is that these events are on the calendar (posts are created when you create the event) and visible on the calender, but when clicked (to go to the post) – boom – error.. This is obviously because the posts are scheduled and not public yet – but when the scheduled date is met, of course the post is available.

So on this site in particular – posts are always hidden. They can see the posts by visiting the calendar and clicking on an event. Typically if you showed all your posts that are scheduled, they may show up on your homepage – but I’m not using it as a typical WP site. I’m using it more as a website.

So in short – I need to be able to show scheduled posts when accessed directly by the URL.

Hope this helps.

@mfields I’m using the Events Calendar Plugin. The problem is that when users click on one of the events from the calendar and it’s scheduled to be posted, they hit an error page because the page is scheduled to be published, not published currently.

@apljdi Might be contradictory, but you dont know ones intentions – so you cant say that ?? … With that said – what you mentioned is exactly what I want to do. But the post is not visible even if you know the link – see my comment to mfields.

Basically I’d just like that if the URL to the scheduled post is known, it could be accessed by clicking to it from something like Events Calendar or a URL posted elsewhere on the site.

BTW I have started using a plugin called “Upcoming Scheduled Posts” and this works, but not exactly as I prefer it. This plugin makes a page that shows all scheduled posts – none of which are clickable or viewable beyond the title.

NVM – Just found the answer here:
https://www.ads-software.com/support/topic/242457?replies=9

File: nextgen-gallery\lib\ngg-db.php
Line: 293
Replace With: $album->sortorder = serialize( $wpdb->get_col(“SELECT gid FROM $wpdb->nggallery ORDER BY gid DESC”) );

Done ??

I’ve tried making those changes bonitapang but didnt have any success..

How can it be that natively there isnt any option to sort albums?

I’m using the tag [ album id=x template=extend ]

Any ideas?

Ah – There ya go .. Thanks and sorry about that

Anyone Bump?