OMG - you are a lifesaver.
I wanted to add something, if you all don't mind. As it stands, this mod lists the manufacturers in alphabetical order. My client wanted 1) images to show (which, thank you for commenting this out *very nicely* - it was easy to do that), and 2) he wanted images to show in a particular order, and have it be easy to change.
I managed to accomplish this *very* easily, and I thought I'd tell you all how I did it - in case anyone else wanted to do the same.
Line 32 is currently:
Code:
if (PRODUCTS_MANUFACTURERS_STATUS == '1') {
$manufacturer_sidebox_query = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image
I changed it to include the other tables - the one in question is getting the "last modified" date:
Code:
if (PRODUCTS_MANUFACTURERS_STATUS == '1') {
$manufacturer_sidebox_query = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified
NOTE: I also put in the "date added" - in case you wanted the most recent manufacturer to show up.
then I simply changed two more lines....37 & 41, which were originally:
Code:
order by manufacturers_name";
and now they are:
Code:
order by last_modified DESC";
Now, all we have to do is just go into the "Catalog>Manufacturers" area, and when we want someone to show up at the top of the list, we just resave the info. (Adding a new one will also change the list, since it was the most recent one modified.)
Now...if only I can figure out how to use the *mini* icons we have for them rather than the HUGE icons we have, I'll be set ;) (But I can always resize them via CSS...so I'm fine either way)
Just thought I'd share! And thanks so much for the mod!
Bookmarks