[Mod] Let visitors to chose how to sort images(date,name,..)

[V@no]

Can it sort by username too?  Sometimes people may want to see what a user has posted.... Kindly let me know what to add thank you


GREAT MOD !!

doesnt make too much sence, because u always can do search by user...

[tradertt]

But can it be done with a extra code? Cause I do not know what code to put in for sort by username

[V@no]

But can it be done with a extra code? Cause I do not know what code to put in for sort by username

it was simpliest change I've ever done...

in /lang/<yourlanguage>/main.php replace the line u inserted:

Code: [Select]

 "image_hits"      => "Hits"
with this:

Code: [Select]

 "image_hits"      => "Hits",
  "image_comments"  => "Comments",
  "user_name"       => "User"


[V@no]

hmm...I guess it wasnt so simple...this method works untill u click on image details...
if no one figure it out, then I'll try fix it in 18 hours


[EDITED]
couldnt resist...
in details.php u'll need do following changes:

1.
find:

Code: [Select]

if ($mode == "lightbox") {
  if (!empty($user_info['lightbox_image_ids'])) {
    $image_id_sql = str_replace(" ", ", ", trim($user_info['lightbox_image_ids']));
    $sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
            FROM ".IMAGES_TABLE."
            WHERE image_active = 1 AND image_id IN ($image_id_sql) AND cat_id IN (".get_auth_cat_sql("auth_viewcat").")
            ORDER BY ".$config['image_order']." ".$config['image_sort'];
    $in_mode = 1;
  }
}
replace with:

Code: [Select]

if ($mode == "lightbox") {
  if (!empty($user_info['lightbox_image_ids'])) {
    $image_id_sql = str_replace(" ", ", ", trim($user_info['lightbox_image_ids']));
    $sql = "SELECT i.image_id, i.cat_id, i.image_name, i.image_media_file, i.image_thumb_file, i.user_id
            FROM ".IMAGES_TABLE." i
            LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
            WHERE i.image_active = 1 AND i.image_id IN ($image_id_sql) AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
            ORDER BY ".$config['image_order']." ".$config['image_sort'];
    $in_mode = 1;
  }
}


2.
Find:

Code: [Select]

 else {
    $cat_id_sql = get_auth_cat_sql("auth_viewcat");
  }

  if (!empty($sql_where_query)) {
    $sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
            FROM ".IMAGES_TABLE."
            WHERE image_active = 1
            $sql_where_query
            AND cat_id IN ($cat_id_sql)
            ORDER BY ".$config['image_order']." ".$config['image_sort'];
    $in_mode = 1;
  }
}
if (!$in_mode || empty($sql)) {
  $sql = "SELECT image_id, cat_id, image_name, image_media_file, image_thumb_file
          FROM ".IMAGES_TABLE."
          WHERE image_active = 1 AND cat_id = $cat_id
          ORDER BY ".$config['image_order']." ".$config['image_sort'];
}
$result = $site_db->query($sql);
Replace with:

Code: [Select]

 else {
    $cat_id_sql = get_auth_cat_sql("auth_viewcat");
  }

  if (!empty($sql_where_query)) {
    $sql = "SELECT i.image_id, i.cat_id, i.image_name, i.image_media_file, i.image_thumb_file, i.user_id
            FROM ".IMAGES_TABLE." i
            LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
            WHERE i.image_active = 1
            $sql_where_query
            AND i.cat_id IN ($cat_id_sql)
            ORDER BY ".$config['image_order']." ".$config['image_sort'];
    $in_mode = 1;
  }
}
if (!$in_mode || empty($sql)) {
  $sql = "SELECT i.image_id, i.cat_id, i.image_name, i.image_media_file, i.image_thumb_file, i.user_id
          FROM ".IMAGES_TABLE." i
          LEFT JOIN ".USERS_TABLE." u ON (".get_user_table_field("u.", "user_id")." = i.user_id)
          WHERE i.image_active = 1 AND i.cat_id = $cat_id
          ORDER BY ".$config['image_order']." ".$config['image_sort'];
}
$result = $site_db->query($sql);

[Ernesto Taseffa]

.

[V@no]

ops, sry, didnt check my post, and I had extra "feature" in my own main.php....
just edited my post, check it again. I also added this "new feature"

[Ernesto Taseffa]

.

[V@no]

opsy...my typo.
it's in details.php
*seems I'm the trouble here...   *

[Ernesto Taseffa]

.

[V@no]

geeee what's wrong with me today?  
sry, my bad again.
change "Hits," to this: "Hits",
I added comma in wront place...

[Ernesto Taseffa]

.

[PuCK]

I can't get the mod to work. I did everything like it said in the second post. I don't get anny errormessages, but when I change the options and click on go, it always shows the images by Date, Descending, like I set it up in the control panel. These options also stay selected when I click on GO.

Does anybody know why this is? It looks like it can't override the Date, Descending options wich I set up in the Control Panel.

[V@no]

ok, I just find out why this script didnt work for me, when I uncommented two lines:
find:

Code: [Select]

//  $imagesorder = intval($HTTP_POST_VARS['imagesorder']);
Replace with:

Code: [Select]

 $imagesorder = $HTTP_POST_VARS['imagesorder'];
and find:

Code: [Select]

// $imagessort = intval($HTTP_POST_VARS['imagessort']);
Replace with:

Code: [Select]

$imagessort = $HTTP_POST_VARS['imagessort'];

that how it suposed to be

P.S. I edited my original post, so, if u just installed this MOD, then dont worry about changes above.

[PuCK]

YES!

It works now for me to. How strange. I had those 2 lines commented, but when I changed them into the new lines you gave, uncommented it worked!  

[V@no]

YES!

It works now for me to. How strange. I had those 2 lines commented, but when I changed them into the new lines you gave, uncommented it worked!  

yes, it took me just 3 month to figure it out... hehe