[MOD REQ] Adding a portfolio/showcase section AKA "Featured Images"

[Uncle Holden]

I have been tinkering with this idea for a while. The problems is that I have 4000+ images on my site and everybody is so busy these days that they wouldn't have the patience to see more than a few categories. I want to show them my most impressive shots and hopefully give them enough incentive to dig deeper.

My idea is to add a separate "Portfolio" section where I will display my most impressive work. A few points in this direction:

• No point duplicating images from /data. Probably it would be best to use a new table to store the image_ids of the selected shots and keep a separate hit count/vote count/rating. Comments/descriptions can be taken from the current images table.
• Ideally add an option to "Add this image to portfolio" when logged in as an admin and looking at a picture
• For each picture in the portfolio, add a link to the originating category
• ...?

If people have further suggestions/ideas, please comment here. Also, if somebody with more PHP skillZ than me is interested in picking this up, it would be awesome. Otherwise I may be able to hack together something but it will be ugly.

[mawenzi]

there was a MOD ... Featured Images ... , but in the old forum and lost by the last great forum-hack ...

[MOD] Featured Images
Missing MODs/FIXes/FAQs

mawenzi

[Uncle Holden]

Everybody keeps referring to "before the hack". Is there any information about what happened/whodunit? I am very curious.

It is time to start chopping then. Will see what I can do 

[mawenzi]

in the meantime you can test this

[Uncle Holden]

Well, it wasn't that hard to do. featured.php is essentially categories.php, except that the SQL code is modified to make a join with one more table.

display.php needs to be modified to display the name and a link the category from which the image is coming. Also, I added a link next to [Edit] and [Delete]: [Add to Featured]. On featured images it is replaced by [Remove from Featured]. Only admin can see those.

functions.php needs a slight tweak to return the proper links for the next and the previous images.

The usual suspects, constants.php and /lang/main.php also needed to be changed.

The code that handles the database manipulation is in /admin/images.php, and is a modification of the code to edit or delete an image.

Here is the final result for me: http://www.dtabakov.com/featured.php

[dosensteck]

Nice Mod / can i have it?

[Uncle Holden]

I took a few shortcuts when implementing it so it might not be very extensible. If more people are interested I will write a step-by-step guide. Otherwise I can send you my "before" and "after" files and let you figure out what I have changed.

For the demo above, note that it also includes another MOD. Clicking on the rightmost third of the picture takes you to the next picture, the left third takes you to the previous, and the middle takes you to the page with the thumbs.

[webslingers]

Count me as interested! It would be 100% perfect if you could also have a table similar to the "new images" on the front page with selects from the featured section. Once it's all setup, that part should be pretty easy. Care to share?

Thanks

[dosensteck]

Ok, i found a simple way

open search.php
find

Code: [Select]

$search_id = array();

Code: [Select]

if (isset($HTTP_POST_VARS['best']) || isset($HTTP_GET_VARS['best'])) {
$best = (isset($HTTP_POST_VARS['best'])) ? intval($HTTP_POST_VARS['best']) : intval($HTTP_GET_VARS['best']);
if ($best) {
  $show_result = 1;
$sql = "SELECT image_id
  FROM ".IMAGES_TABLE."
 WHERE best = 1";
 $result = $site_db->query($sql);
 $ids = "";
 while ($row = $site_db->fetch_array($result)){
  $ids .= $row['image_id'].",";
  }
  $search_id['image_ids'] = trim($ids, ",");
}
}
Add to Images Table 1 field called "best" default 0

Add to some Images best = 1

use /search.php?best=1


very simple and not the best way, but it works.

[ManniC]

It would be great if anyone (Uncle Holden / mavenzi ???? ) would post his solution here with sourcecode.

Thanks in advance

[Matthias70]

I'm also interested in this mod 

[Uncle Holden]

My solution is essentially a hack, and its only redeeming feature is that it works. I made some ugly changes to /admin/images.php that are not extensible. I would rather wait until I have more time to polish it off and write down the steps, otherwise I will feel guilty for publishing something that may break or may be incompatible with other mods.

For those who want to see my solution, you can download the before and after files from here: http://dtabakov.com/dsplus/m.php?p=featured.zip.

Warning: this will not work "out of the box" because my code is talking to a database table that doesn't exist. In my version it is called 4images_featured and has three attributes: image_id (int 10), image_active (tynyint) and image_hits (int 10). Don't just copy these files over your existing files because you will break things. What I would suggest is running diff on the original files and the modified files and seeing where the changes were made. If you decide to play with this, do so on your own risk. If, on the other hand, something doesn't make sense, let me know and I will try to explain what I was trying to achieve.