[Mod] Photo Of The Day

[SLL]

I need to know how i can show the POTD in an external php page.

you can combine it with "radom image" mod for this
http://www.4homepages.de/forum/viewtopic.php?t=1020

[Amosnet]

and how can i combine it SLL?

[SLL]

Well.. just use database queries from POTD in Random Images MOD.... or wait untill V@no post this MOD here  

Usualy it takes him 15 minutes - from MOD's request to his post here  

[Amosnet]

V@no this is a MOD Request!

[V@no]

you can combine it with "radom image" mod for this
http://www.4homepages.de/forum/viewtopic.php?t=1020

exactly!

or wait untill V@no post this MOD here  

Usualy it takes him 15 minutes - from MOD's request to his post here  

o boy!

so, try this code:

Code: [Select]

<?php
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File&#58; potd.php                                           *
 *        Copyright&#58; &#40;C&#41; 2002 Jan Sorgalla                                *
 *            Email&#58; jan@4homepages.de                                    *
 *              Web&#58; http&#58;//www.4homepages.de                             *
 *    Scriptversion&#58; 1.0 for 4images 1.7                                *
 *                                                                        *
 *    Never released without support from&#58; Nicky &#40;http&#58;//www.nicky.net&#41; and SLL &#40;;   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen &#40;http&#58;//www.4homepages.de/4images/lizenz.php&#41; für       *
 *    weitere Informationen.                                              *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    &#40;http&#58;//www.4homepages.de/4images/lizenz_e.php&#41; for further         *
 *    information.                                                        *
 *                                                                        *
 *************************************************************************/

// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie
define&#40;'ROOT_PATH', './4images/'&#41;;
//include&#40;ROOT_PATH.'global.php'&#41;;
include&#40;ROOT_PATH.'config.php'&#41;;
include&#40;ROOT_PATH.'includes/db_mysql.php'&#41;;
include&#40;ROOT_PATH.'includes/constants.php'&#41;;

$site_db = new Db&#40;$db_host, $db_user, $db_password, $db_name&#41;;
function is_remote&#40;$file_name&#41; &#123;
  return &#40;preg_match&#40;'#^https?\\&#58;\\/\\/[a-z0-9\-&#93;+\.&#40;[a-z0-9\-&#93;+\.&#41;?[a-z&#93;+#i', $file_name&#41;&#41; ? 1 &#58; 0;
&#125;
switch &#40;POTD_SELECT_MODE&#41; &#123;
   case "by_rating"     &#58; $select_mode = "i.image_rating"; $select_mode2 = ", i.image_votes DESC"; break;
   case "by_votes"      &#58; $select_mode = "i.image_votes"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_comments"   &#58; $select_mode = "i.image_comments"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_downloads"  &#58; $select_mode = "i.image_downloads"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_hits" &#58; $select_mode = "i.image_hits"; $select_mode2 = ", i.image_name ASC"; break;
   default  &#58; $select_mode = "i.image_rating"; $select_mode2 = ", i.image_votes DESC"; break;
&#125;
$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, c.cat_name, u.user_name
        FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
        LEFT JOIN ".USERS_TABLE." u ON &#40;u.user_id = i.user_id&#41;
        WHERE i.image_active=1
    AND i.cat_id = c.cat_id
      AND c.auth_viewcat=".AUTH_ALL."
     AND c.auth_viewimage=".AUTH_ALL."
        ORDER BY $select_mode DESC $select_mode2
         LIMIT 1";
$row = $site_db->query_firstrow&#40;$sql&#41;;
$site_db->free_result&#40;&#41;;

$image_id = $row['image_id'&#93;;
$cat_id = $row['cat_id'&#93;;
$image_name = $row['image_name'&#93;;
$image_comments = $row['image_comments'&#93;;
$thumb_src = &#40;is_remote&#40;$row['image_thumb_file'&#93;&#41;&#41; ? $row['image_thumb_file'&#93; &#58; ROOT_PATH.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'&#93;;

echo "<a href=\"".ROOT_PATH."details.php?image_id=$image_id\"><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a><br>\n";
echo "<b>$image_name</b><br>\n";
echo "Comments&#58; $image_comments<br>\n";
?>

aslo, I'd suggest change from SLL original script switch (POTD_SELECT_MODE) { ... }to this:

Code: [Select]

switch (POTD_SELECT_MODE) {
   case "by_rating"     : $select_mode = "i.image_rating"; $select_mode2 = ", i.image_votes DESC"; break;
   case "by_votes"      : $select_mode = "i.image_votes"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_comments"   : $select_mode = "i.image_comments"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_downloads"  : $select_mode = "i.image_downloads"; $select_mode2 = ", i.image_name ASC"; break;
   case "by_hits" : $select_mode = "i.image_hits"; $select_mode2 = ", i.image_name ASC"; break;
   default : $select_mode = "i.image_rating"; $select_mode2 = ", i.image_votes DESC"; break;
}
and then,

Code: [Select]

       ORDER BY $select_mode DESC
to this:

Code: [Select]

       ORDER BY $select_mode DESC $select_mode2
this will solve little problem, when two images ( aaaa.jpg and bbbb.jpg ) have same rating (4.5), but bbbb.jpg has 10 votes, and aaaa.jpg has only 2 votes. so, with original script it will show aaaa.jpg instead of bbbb.jpg

[SLL]

aslo, I'd suggest change from SLL original script...

Fixed... Thanks!  

[hiuyu23]

Additional languages for above mode:

Code: [Select]

#
#-----[ OPEN ]----------------------------------------
#

/lang/deutsch/main.php

#
#-----[ ADD ]------------------------------------------
#

//-----------------------------------------------------
//--- Photo Of The Day --------------------------------
//-----------------------------------------------------

$lang['potd_title'] = "Foto des Tages";
$lang['potd_type_rating'] = "nach Bewertung";
$lang['potd_type_votes'] = "nach Stimmen";
$lang['potd_type_comments'] = "nach Kommentar";
$lang['potd_type_downloads'] = "nach Downloads";

#
#-----[ OPEN ]----------------------------------------
#

/lang/russian/main.php

#
#-----[ ADD ]------------------------------------------
#

//-----------------------------------------------------
//--- Photo Of The Day --------------------------------
//-----------------------------------------------------

$lang['potd_title'] = "Фотография дня";
$lang['potd_type_rating'] = "Выбрано по рейтингу";
$lang['potd_type_votes'] = "Выбрано по голосованиям";
$lang['potd_type_comments'] = "Выбрано по комментариям";
$lang['potd_type_downloads'] = "Выбрано по загрузкам";


Can you change to english?

[hiuyu23]

how to change the photo in the center?

i mean "phopt of the day".

http://utenti.lycos.it/kueou/4images/index.php

[lakeside]

Another Great Mod

Thanks, this is a great addition to 4images.  It worked without a hitch, other than I needed to fix the potd template so that the POTD name came below the image rather than start next to it.  But this is small and probably was only affected on my site.

Thanks much.

[Bomba]

how can i add additional field to image details page,
but this field wouldn't show on the user_uploadform. Only admin would be available to edit this field at the admin panel.

This way administrators can write a little description saying why was that pic choosen as "photo of the day", and that text would appear on the details.html of that image, in a way that "photo of the day" become a serious award to the best works and users.

This field when edited would be permanently showed, and not just as long as that pic is selected as "photo of the day". Remembering all "photo of the day" is my idea.


sorry if this is confuse to understand
thanks in advance

[SLL]

Can you change to english?

no, i can't...  i don't speak english  

[SLL]

Remembering all "photo of the day" is my idea.

well, well... even the name "photo of the day" shows you, that this is dynamic thing... from my point of view it doesn't make any sense to make it fixed. i'd suggest you to make separate category and move winners there manually.

[Bomba]

but is this additional field hard to make?

i don't want to change pic's category because that would kill the identity that user has chosen to that pic. if user chooses a category to his pic, that should be the category where the pic should stay.

having that little "photo of the day note" on the choosen pics would be discretly and eficient, from my point of view.

thanks
hope that this could be done

[SLL]

but is this additional field hard to make?

hard enough... this requires db modification, but i'd like to keep this mod simple

[batz]

Hi,

This is really a great MOD.

There is any chance of a POTD reset to make it a really POTD?
My settings are by_votes but if an image in 2 days had more votes than an one day photo the first image is the POTD. Can you fix this SSL?

This is very important for me. I have run through the forum but i don't figure how to do this.

Thanks
Paulo