N00b problem with gallery menu sorting in php

[Tolya]

Hey there, first post on this forum, so hello everyone.

I have a bit of a problem with my wife's website. About two years ago it was coded based on wordpress by a webdeveloper. Right now, Im picking up the admin's mantle, retro-ing the code and trying to figure it out myself so I can do all the necessary modifications. I've ran into a bit of a problem which is way beyond my expertise (html and css coding is mostly my thing, only started learning php).

Here is the problem.

The website in question is http://www.olakalinowska.pl and it is built on wordpress, with the postloop and branding modified to produce the current result. There is a script on the main page which takes all the galleries from a specified album ID and produces a collapsible menu - if you hover on one of the title bars, it will produce a sub-menu with links to specific galleries.

The thing is, the ordering of the galleries seems random. At first I thought it goes by gallery ID, but it does not, if you look at it. I don't think it utilizes any sort of array result ordering.

What I would like it to do is to follow the ordering on the wordpress ngg gallery in the CMS. In the very least, I would like to be able to set the sorting manually. Any help would be greatly appreciated.

<div class="float-me">
<!-- start slub -->
<div id="main-page-slub">
<a class="div-href" href="/slub/">śluby i chrzty</a>
<div class="menu">
<ul>
<li>
<a href="/slub/">śluby i chrzty</a>
<ul id="album-list-slub">
<?php
$aid = 4;
$query = 'SELECT * FROM wp_ngg_album WHERE id = '.$aid.' LIMIT 1'; //album ludzie
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$sort = $row['sortorder'];
}

$gals_ids = implode(',', (unserialize($sort)));

$query = 'SELECT * FROM wp_ngg_gallery WHERE gid IN ('.$gals_ids.')'; //wszystkie galerie z albumu ludzie
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo ('<li><a href="/slub/?album='.$aid.'&gallery='.$row['gid'].'">'.$row['title'].'</a></li>');
}
?>
</ul>
</li>
</ul>
</div>
</div>
<!-- stop slub -->
<div class="shadow-right"></div>
<div style="clear: both;"></div>
<div class="shadow-bottom"></div>

<div style="clear: both;"></div>
</div>

[simplypixie]

Change this line to

Code: Select all

$query = 'SELECT * FROM wp_ngg_gallery WHERE gid IN ('.$gals_ids.') ORDER BY '.$sort.'';

[Tolya]

Thank you, unfortunately it does not work.

When I replace the code, the actual webpage gets parsed only up to the point it stumbles upon that ORDER BY bit. It only renders the first photo without a functional submenu. Inspection of the website source code revealed this:

Something is wrong in your syntax obok ':5:{i:0;s:2:"15";i:1;s:2:"24";i:2;s:2:"14";i:3;s:2:"25";i:4;s:2:"18";}) WHERE gi' w linii 1

[simplypixie]

As the ngg gallery is a plugin, have you looked at changing the settings there, not trying to re-write the code?

[Tolya]

Yes, and unfortunately the plugin ordering of galleries does not carry over in any form to the front page script.

[Tolya]

Okay, sorted it out. Created a new field in wp_ngg_gallery named odr, assigned ascending integers to the rows I needed and just ordered by odr.