toast_dk
13th of July 2002 (Sat), 03:41
I just found out how to alfabetize the "category drop-down" in the Exhibition Browser. If you cant wait for Pekka to implement it, this is what to do:
In list.php lines 391-402 change
// GET CATOGORIES
$fetchgenres = mysql_query(
"
SELECT
DISTINCT
$q22,$q23,$q24
FROM
ee_category,
ee_photo_to_category
WHERE
ee_category.ee_category_id = ee_photo_to_category.ee_category_id
"
into
// GET CATOGORIES
$fetchgenres = mysql_query(
"
SELECT
DISTINCT
$q22,$q23,$q24
FROM
ee_category,
ee_photo_to_category
WHERE
ee_category.ee_category_id = ee_photo_to_category.ee_category_id
ORDER BY
ee_category_name
"
If you want the dropdown in the Photo Editor to be alfabetized as well, you need to change the file photodata.php (in the directory you renamed), lines 1676-1687, like this:
[quote]
In list.php lines 391-402 change
// GET CATOGORIES
$fetchgenres = mysql_query(
"
SELECT
DISTINCT
$q22,$q23,$q24
FROM
ee_category,
ee_photo_to_category
WHERE
ee_category.ee_category_id = ee_photo_to_category.ee_category_id
"
into
// GET CATOGORIES
$fetchgenres = mysql_query(
"
SELECT
DISTINCT
$q22,$q23,$q24
FROM
ee_category,
ee_photo_to_category
WHERE
ee_category.ee_category_id = ee_photo_to_category.ee_category_id
ORDER BY
ee_category_name
"
If you want the dropdown in the Photo Editor to be alfabetized as well, you need to change the file photodata.php (in the directory you renamed), lines 1676-1687, like this:
[quote]