function wppa_filter_exif($desc, $photo)
{
    global $wpdb;
    if (strpos($desc, 'E#') === false) {
        return $desc;
    }
    // No tags in desc: Nothing to do
    $exiflabels = $wpdb->get_results("SELECT * FROM `" . WPPA_EXIF . "` WHERE `photo` = '0' ORDER BY `id`", ARRAY_A);
    $exifdata = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_EXIF . "` WHERE `photo`=%s ORDER BY `id`", $photo), ARRAY_A);
    wppa_dbg_q('Q61v');
    // Init
    $temp = $desc;
    $prevtag = '';
    $combined = '';
    // Process all exiflines of this photo
    if ($exifdata) {
        foreach ($exifdata as $exifline) {
            $tag = $exifline['tag'];
            if ($prevtag == $tag) {
                // add a next item for this tag
                $combined .= ', ' . htmlspecialchars(strip_tags($exifline['description']));
            } else {
                // first item of this tag
                if ($combined) {
                    // Process if required
                    $temp = str_replace($prevtag, $combined, $temp);
                }
                $combined = htmlspecialchars(strip_tags($exifline['description']));
                $prevtag = $tag;
            }
        }
        // Process last
        $temp = str_replace($tag, $combined, $temp);
    }
    // Process all labels
    if ($exiflabels) {
        foreach ($exiflabels as $exiflabel) {
            $tag = $exiflabel['tag'];
            // convert E#XXX to E#LXXX to indicate the label
            $t = substr($tag, 0, 2) . 'L' . substr($tag, 2);
            $tag = $t;
            $temp = str_replace($tag, __a($exiflabel['description']), $temp);
        }
    }
    // Remove untranslated
    $pos = strpos($temp, 'E#');
    while ($pos !== false) {
        $tmp = substr($temp, 0, $pos) . __a('n.a.') . substr($temp, $pos + 6);
        $temp = $tmp;
        $pos = strpos($temp, 'E#');
    }
    // Return result
    return $temp;
}
function wppa_load_footer()
{
    global $wppa;
    global $wpdb;
    global $wppa_session;
    if (wppa_opt('wppa_lightbox_name') == 'wppa') {
        $fontsize_lightbox = wppa_opt('wppa_fontsize_lightbox') ? wppa_opt('wppa_fontsize_lightbox') : '10';
        $d = wppa_switch('wppa_ovl_show_counter') ? 1 : 0;
        $ovlh = wppa_opt('wppa_ovl_txt_lines') == 'auto' ? 'auto' : (wppa_opt('wppa_ovl_txt_lines') + $d) * ($fontsize_lightbox + 2);
        $txtcol = wppa_opt('wppa_ovl_theme') == 'black' ? '#a7a7a7' : '#272727';
        echo '
<!-- start WPPA+ Footer data -->
	<div id="wppa-overlay-bg" style="text-align:center; display:none; position:fixed; top:0; left:0; z-index:100090; width:100%; height:2048px; background-color:' . wppa_opt('wppa_ovl_bgcolor') . ';" onclick="wppaOvlOnclick(event)" >';
        if (wppa_switch('ovl_show_legenda') && !wppa('is_mobile')) {
            echo '
		<div id="wppa-ovl-legenda-1" onmouseover="jQuery(this).css(\'visibility\',\'visible\');" onmouseout="jQuery(this).css(\'visibility\',\'hidden\');" style="position:absolute; left:0; top:0; background-color:' . wppa_opt('wppa_ovl_theme') . ';color:' . $txtcol . '; visibility:visible;" >
			' . __a('Press f for fullscreen.') . '
		</div>';
        }
        echo '
	</div>
	<div id="wppa-overlay-ic" style="position:fixed; top:0; padding-top:10px; z-index:100095; opacity:1; box-shadow:none;" >
	</div>
	<img id="wppa-overlay-sp" alt="spinner" style="position:fixed; top:200px; left:200px; z-index:100100; opacity:1; visibility:hidden; box-shadow:none;" src="' . wppa_get_imgdir() . 'loading.gif" />
	<script type="text/javascript">jQuery("#wppa-overlay-bg").css({height:window.innerHeight});
		wppaOvlTxtHeight = "' . $ovlh . '";
		wppaOvlCloseTxt = "' . __(wppa_opt('wppa_ovl_close_txt')) . '";
		wppaOvlOpacity = ' . wppa_opt('wppa_ovl_opacity') / 100 . ';
		wppaOvlOnclickType = "' . wppa_opt('wppa_ovl_onclick') . '";
		wppaOvlTheme = "' . wppa_opt('wppa_ovl_theme') . '";
		wppaOvlAnimSpeed = ' . wppa_opt('wppa_ovl_anim') . ';
		wppaOvlSlideSpeed = ' . wppa_opt('wppa_ovl_slide') . ';
		wppaVer4WindowWidth = 800;
		wppaVer4WindowHeight = 600;
		wppaOvlShowCounter = ' . (wppa_switch('wppa_ovl_show_counter') ? 'true' : 'false') . ';
		' . (wppa_opt('wppa_fontfamily_lightbox') ? 'wppaOvlFontFamily = "' . wppa_opt('wppa_fontfamily_lightbox') . '"' : '') . '
		wppaOvlFontSize = "' . $fontsize_lightbox . '";
		' . (wppa_opt('wppa_fontcolor_lightbox') ? 'wppaOvlFontColor = "' . wppa_opt('wppa_fontcolor_lightbox') . '"' : '') . '
		' . (wppa_opt('wppa_fontweight_lightbox') ? 'wppaOvlFontWeight = "' . wppa_opt('wppa_fontweight_lightbox') . '"' : '') . '
		' . (wppa_opt('wppa_fontsize_lightbox') ? 'wppaOvlLineHeight = "' . (wppa_opt('wppa_fontsize_lightbox') + '2') . '"' : '') . '
		wppaOvlFullLegenda = "' . __a('Keys: f = next mode; escape = exit; p = previous, n = next, s = start/stop, d = dismiss this notice.') . '";
		wppaOvlFullLegendaSingle = "' . __a('Keys: f = next mode; escape = exit; d = dismiss this notice.') . '";
		wppaOvlVideoStart = ' . (wppa_switch('ovl_video_start') ? 'true' : 'false') . ';
		wppaOvlAudioStart = ' . (wppa_switch('ovl_audio_start') ? 'true' : 'false') . ';
		wppaOvlShowLegenda = ' . (wppa_switch('ovl_show_legenda') && !wppa('is_mobile') ? 'true' : 'false') . ';
		wppaOvlShowStartStop = ' . (wppa_switch('ovl_show_startstop') ? 'true' : 'false') . ';
	</script>
	';
        wp_nonce_field('wppa-check', 'wppa-nonce', false, true);
        // Nonce field for Ajax bump view counter from lightbox
        echo '
	<script type="text/javascript">';
        if (isset($wppa_session['photo'])) {
            foreach (array_keys($wppa_session['photo']) as $p) {
                echo '
				wppaPhotoView[' . $p . '] = true;';
            }
        }
        echo '
	</script>
<!-- end WPPA+ Footer data -->
';
    }
    wppa_dbg_q('print');
    if ($wppa['debug']) {
        $plugins = get_option('active_plugins');
        wppa_dbg_msg('Active Plugins');
        foreach ($plugins as $plugin) {
            wppa_dbg_msg($plugin);
        }
        wppa_dbg_msg('End Active Plugins');
    }
    echo '
<!-- Do user upload -->';
    wppa_user_upload();
    // Do the upload if required and not yet done
    echo '
<!-- Done user upload -->';
}
function wppa_cache_thumb($id, $data = '')
{
    global $wpdb;
    global $thumb;
    static $thumb_cache_2;
    // Action?
    if ($id == 'invalidate') {
        if (isset($thumb_cache_2[$data])) {
            unset($thumb_cache_2[$data]);
        }
        $thumb = false;
        return false;
    }
    if ($id == 'add') {
        if (!$data) {
            // Nothing to add
            return false;
        } elseif (isset($data['id'])) {
            // Add a single thumb to 2nd level cache
            $thumb_cache_2[$data['id']] = $data;
            // Looks valid
        } elseif (count($data) > 10000) {
            return false;
            // Too many, may cause out of memory error
        } else {
            foreach ($data as $thumb) {
                // Add multiple
                if (isset($thumb['id'])) {
                    // Looks valid
                    $thumb_cache_2[$thumb['id']] = $thumb;
                }
            }
        }
        return false;
    }
    if ($id == 'count') {
        if (is_array($thumb_cache_2)) {
            return count($thumb_cache_2);
        } else {
            return false;
        }
    }
    if (!wppa_is_int($id) || $id < '1') {
        wppa_dbg_msg('Invalid arg wppa_cache_thumb(' . $id . ')', 'red');
        $thumb = false;
        return false;
    }
    // In first level cache?
    if (isset($thumb['id']) && $thumb['id'] == $id) {
        wppa_dbg_q('G-T1');
        return $thumb;
    }
    // In  second level cache?
    if (!empty($thumb_cache_2)) {
        if (in_array($id, array_keys($thumb_cache_2))) {
            $thumb = $thumb_cache_2[$id];
            wppa_dbg_q('G-T2');
            return $thumb;
        }
    }
    // Not in cache, do query
    $thumb = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $id), ARRAY_A);
    wppa_dbg_q('Q-P');
    // Found one?
    if ($thumb) {
        // Store in second level cache
        $thumb_cache_2[$id] = $thumb;
        return $thumb;
    } else {
        wppa_dbg_msg('Photo ' . $id . ' does not exist', 'red');
        return false;
    }
}
function wppa_get_potd()
{
    global $wpdb;
    $image = '';
    switch (wppa_opt('widget_method')) {
        case '1':
            // Fixed photo
            $id = wppa_opt('widget_photo');
            if ($id != '') {
                $image = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s LIMIT 0,1", $id), ARRAY_A);
                wppa_dbg_q('Q-Potd');
                wppa_cache_photo('add', $image);
            }
            break;
        case '2':
            // Random
            $album = wppa_opt('widget_album');
            if ($album == 'topten') {
                $images = wppa_get_widgetphotos($album);
                if (count($images) > 1) {
                    // Select a random first from the current selection
                    $idx = rand(0, count($images) - 1);
                    $image = $images[$idx];
                }
            } elseif ($album != '') {
                $images = wppa_get_widgetphotos($album, "ORDER BY RAND() LIMIT 0,1");
                $image = $images[0];
            }
            break;
        case '3':
            // Last upload
            $album = wppa_opt('widget_album');
            if ($album == 'topten') {
                $images = wppa_get_widgetphotos($album);
                if ($images) {
                    // fid last uploaded image in the $images pool
                    $temp = 0;
                    foreach ($images as $img) {
                        if ($img['timestamp'] > $temp) {
                            $temp = $img['timestamp'];
                            $image = $img;
                        }
                    }
                }
            } elseif ($album != '') {
                $images = wppa_get_widgetphotos($album, "ORDER BY timestamp DESC LIMIT 0,1");
                $image = $images[0];
            }
            break;
        case '4':
            // Change every
            $album = wppa_opt('widget_album');
            if ($album != '') {
                $per = wppa_opt('widget_period');
                $photos = wppa_get_widgetphotos($album);
                if ($per == '0') {
                    if ($photos) {
                        $image = $photos[rand(0, count($photos) - 1)];
                    } else {
                        $image = '';
                    }
                } elseif ($per == 'day-of-week') {
                    $image = '';
                    if ($photos) {
                        $d = date_i18n("w");
                        $d -= get_option('wppa_potd_offset', '0');
                        while ($d < '1') {
                            $d += '7';
                        }
                        foreach ($photos as $img) {
                            if ($img['p_order'] == $d) {
                                $image = $img;
                            }
                        }
                    }
                } elseif ($per == 'day-of-month') {
                    $image = '';
                    if ($photos) {
                        $d = strval(intval(date_i18n("d")));
                        $d -= get_option('wppa_potd_offset', '0');
                        while ($d < '1') {
                            $d += '31';
                        }
                        foreach ($photos as $img) {
                            if ($img['p_order'] == $d) {
                                $image = $img;
                            }
                        }
                    }
                } elseif ($per == 'day-of-year') {
                    $image = '';
                    if ($photos) {
                        $d = strval(intval(date_i18n("z")));
                        $d -= get_option('wppa_potd_offset', '0');
                        while ($d < '0') {
                            $d += '366';
                        }
                        foreach ($photos as $img) {
                            if ($img['p_order'] == $d) {
                                $image = $img;
                            }
                        }
                    }
                } else {
                    $u = date_i18n("U");
                    // Seconds since 1-1-1970, local
                    $u /= 3600;
                    //  hours since
                    $u = floor($u);
                    $u /= $per;
                    $u = floor($u);
                    // Find the right photo out of the photos found by wppa_get_widgetphotos(),
                    // based on the Change every { any timeperiod } algorithm.
                    if ($photos) {
                        $p = count($photos);
                        $idn = fmod($u, $p);
                        // If from topten,...
                        if ($album == 'topten') {
                            // Do a re-read of the same to order by rand, reproduceable
                            // This can not be done by wppa_get_widgetphotos(),
                            // it does already ORDER BY for the top selection criterium.
                            // So we save the ids, and do a SELECT WHERE id IN ( array of found ids ) ORDER BY RAND( seed )
                            $ids = array();
                            foreach ($photos as $photo) {
                                $ids[] = $photo['id'];
                            }
                            $photos = $wpdb->get_results("SELECT `id`, `p_order` " . "FROM `" . WPPA_PHOTOS . "` " . "WHERE `id` IN (" . implode(',', $ids) . ") " . "ORDER BY RAND(" . $idn . ")", ARRAY_A);
                        } else {
                            $photos = wppa_get_widgetphotos($album, " ORDER BY RAND(" . $idn . ")");
                        }
                        // Image found
                        $image = $photos[$idn];
                    } else {
                        $image = '';
                    }
                }
            } else {
                $image = '';
            }
            break;
        default:
            $image = '';
    }
    if ($image) {
        $image = wppa_cache_photo($image['id']);
    }
    return $image;
}
Exemple #5
0
function wppa_get_album_title_linktype($alb)
{
    global $wpdb;
    if (is_numeric($alb)) {
        $result = $wpdb->get_var($wpdb->prepare("SELECT cover_linktype FROM " . WPPA_ALBUMS . " WHERE id = %s LIMIT 1", $alb));
    } else {
        $result = '';
    }
    wppa_dbg_q('Q59');
    return $result;
}
function wppa_load_footer()
{
    global $wpdb;
    global $wppa_session;
    echo '
		<!-- start WPPA+ Footer data -->
		';
    // Do they use our lightbox?
    if (wppa_opt('lightbox_name') == 'wppa') {
        $fontsize_lightbox = wppa_opt('fontsize_lightbox') ? wppa_opt('fontsize_lightbox') : '10';
        $d = wppa_switch('wppa_ovl_show_counter') ? 1 : 0;
        $ovlh = wppa_opt('ovl_txt_lines') == 'auto' ? 'auto' : (wppa_opt('ovl_txt_lines') + $d) * ($fontsize_lightbox + 2);
        $txtcol = wppa_opt('ovl_theme') == 'black' ? '#a7a7a7' : '#272727';
        // The lightbox overlay background
        echo '<div' . ' id="wppa-overlay-bg"' . ' style="' . 'text-align:center;' . 'display:none;' . 'position:fixed;' . 'top:0;' . 'left:0;' . 'z-index:100090;' . 'width:100%;' . 'height:2048px;' . 'background-color:' . wppa_opt('ovl_bgcolor') . ';' . '"' . ' onclick="wppaOvlOnclick(event)"' . ' >';
        // Display legenda
        if (wppa_switch('ovl_show_legenda') && !wppa('is_mobile')) {
            echo '<div' . ' id="wppa-ovl-legenda-1"' . ' onmouseover="jQuery(this).css(\'visibility\',\'visible\');"' . ' onmouseout="jQuery(this).css(\'visibility\',\'hidden\');"' . ' style="' . 'position:absolute;' . 'left:0;' . 'top:0;' . 'background-color:' . wppa_opt('ovl_theme') . ';' . 'color:' . $txtcol . ';' . 'visibility:visible;' . '"' . ' >
					' . __('Press f for fullscreen.', 'wp-photo-album-plus') . '
				</div>';
        }
        // The fullscreen button
        echo '<img' . ' id="wppa-fulls-btn"' . ' src="' . wppa_get_imgdir('fulls.png') . '"' . ' style="height:32px;z-index:100091;position:fixed;top:0;right:0;"' . ' onclick="wppaOvlFull()"' . ' ontouchstart="wppaOvlFull()"' . ' onmouseover="jQuery(this).fadeTo(600,1);"' . ' onmouseout="jQuery(this).fadeTo(600,0);"' . ' />';
        // Close lightbox overlay background
        echo '</div>';
        // The Lightbox Image container
        echo '<div' . ' id="wppa-overlay-ic"' . ' style="' . 'position:fixed;' . 'top:50%;' . 'left:50%;' . 'z-index:100095;' . 'opacity:1;' . 'box-shadow:none;' . 'box-sizing:content-box;' . '"' . ' >' . '</div>';
        // The Spinner image
        echo '
			<img' . ' id="wppa-overlay-sp"' . ' alt="spinner"' . ' style="' . 'position:fixed;' . 'top:50%;' . 'margin-top:-16px;' . 'left:50%;' . 'margin-left:-16px;' . 'z-index:100100;' . 'opacity:1;' . 'visibility:hidden;' . 'box-shadow:none;' . '"' . ' src="' . wppa_get_imgdir() . 'loading.gif"' . ' />';
        // The init vars
        echo '
		<script type="text/javascript">
			jQuery("#wppa-overlay-bg").css({height:window.innerHeight});
			wppaOvlTxtHeight = "' . $ovlh . '";
			wppaOvlOpacity = ' . wppa_opt('ovl_opacity') / 100 . ';
			wppaOvlOnclickType = "' . wppa_opt('ovl_onclick') . '";
			wppaOvlTheme = "' . wppa_opt('ovl_theme') . '";
			wppaOvlAnimSpeed = ' . wppa_opt('ovl_anim') . ';
			wppaOvlSlideSpeed = ' . wppa_opt('ovl_slide') . ';
			wppaVer4WindowWidth = 800;
			wppaVer4WindowHeight = 600;
			wppaOvlShowCounter = ' . (wppa_switch('wppa_ovl_show_counter') ? 'true' : 'false') . ';
			' . (wppa_opt('fontfamily_lightbox') ? 'wppaOvlFontFamily = "' . wppa_opt('fontfamily_lightbox') . '"' : '') . '
			wppaOvlFontSize = "' . $fontsize_lightbox . '";
			' . (wppa_opt('fontcolor_lightbox') ? 'wppaOvlFontColor = "' . wppa_opt('fontcolor_lightbox') . '"' : '') . '
			' . (wppa_opt('fontweight_lightbox') ? 'wppaOvlFontWeight = "' . wppa_opt('fontweight_lightbox') . '"' : '') . '
			' . (wppa_opt('fontsize_lightbox') ? 'wppaOvlLineHeight = "' . (wppa_opt('fontsize_lightbox') + '2') . '"' : '') . '
			wppaOvlFullLegenda = "' . __('Keys: f = next mode; q,x = exit; p = previous, n = next, s = start/stop, d = dismiss this notice.', 'wp-photo-album-plus') . '";
			wppaOvlFullLegendaSingle = "' . __('Keys: f = next mode; q,x = exit; d = dismiss this notice.', 'wp-photo-album-plus') . '";
			wppaOvlVideoStart = ' . (wppa_switch('ovl_video_start') ? 'true' : 'false') . ';
			wppaOvlAudioStart = ' . (wppa_switch('ovl_audio_start') ? 'true' : 'false') . ';
			wppaOvlShowLegenda = ' . (wppa_switch('ovl_show_legenda') && !wppa('is_mobile') ? 'true' : 'false') . ';
			wppaOvlShowStartStop = ' . (wppa_switch('ovl_show_startstop') ? 'true' : 'false') . ';
		</script>
		';
    }
    // The photo views cache
    echo '
	<script type="text/javascript">';
    if (isset($wppa_session['photo'])) {
        foreach (array_keys($wppa_session['photo']) as $p) {
            echo '
				wppaPhotoView[' . $p . '] = true;';
        }
    }
    echo '
	</script>
<!-- end WPPA+ Footer data -->
';
    // Debugging, show queries
    wppa_dbg_q('print');
    // Debugging, show active plugins
    if (wppa('debug')) {
        $plugins = get_option('active_plugins');
        wppa_dbg_msg('Active Plugins');
        foreach ($plugins as $plugin) {
            wppa_dbg_msg($plugin);
        }
        wppa_dbg_msg('End Active Plugins');
    }
    echo '
<!-- Nonce for various wppa actions -->';
    // Nonce field for Ajax bump view counter from lightbox, and rating
    wp_nonce_field('wppa-check', 'wppa-nonce', false, true);
    echo '
<!-- Do user upload -->';
    // Do the upload if required and not yet done
    wppa_user_upload();
    // Done
    echo '
<!-- Done user upload -->';
}
function wppa_allow_user_uploads()
{
    global $wpdb;
    // Get the limits
    $limits = wppa_get_user_upload_limits();
    $temp = explode('/', $limits);
    $limit_max = isset($temp[0]) ? $temp[0] : '0';
    $limit_time = isset($temp[1]) ? $temp[1] : '0';
    if (!$limit_max) {
        return '-1';
    }
    // Unlimited max
    $user = wppa_get_user('login');
    if (!$limit_time) {
        // For ever
        $curcount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `owner` = %s", $user));
        wppa_dbg_q('Q326');
    } else {
        // Time criterium in place
        $timnow = time();
        $timthen = $timnow - $limit_time;
        $curcount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `owner` = %s AND `timestamp` > %s", $user, $timthen));
        wppa_dbg_q('Q327');
    }
    if ($curcount >= $limit_max) {
        $result = '0';
    } else {
        $result = $limit_max - $curcount;
    }
    return $result;
}
function wppa_time_to_wait_html($album, $user = false)
{
    global $wpdb;
    if (!$album && !$user) {
        return '0';
    }
    if ($user) {
        $limits = wppa_get_user_upload_limits();
    } else {
        $limits = $wpdb->get_var($wpdb->prepare("SELECT `upload_limit` FROM `" . WPPA_ALBUMS . "` WHERE `id` = %s", $album));
    }
    wppa_dbg_q('Q62');
    $temp = explode('/', $limits);
    $limit_max = isset($temp[0]) ? $temp[0] : '0';
    $limit_time = isset($temp[1]) ? $temp[1] : '0';
    $result = '';
    if (!$limit_max || !$limit_time) {
        return $result;
    }
    if ($user) {
        $owner = wppa_get_user('login');
        $last_upload_time = $wpdb->get_var($wpdb->prepare("SELECT `timestamp` FROM `" . WPPA_PHOTOS . "` WHERE `owner` = %s ORDER BY `timestamp` DESC LIMIT 1", $owner));
    } else {
        $last_upload_time = $wpdb->get_var($wpdb->prepare("SELECT `timestamp` FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s ORDER BY `timestamp` DESC LIMIT 1", $album));
    }
    wppa_dbg_q('Q63');
    $timnow = time();
    // For simplicity: a year is 364 days = 52 weeks, we skip the months
    $seconds = array('min' => '60', 'hour' => '3600', 'day' => '86400', 'week' => '604800', 'month' => '2592000', 'year' => '31449600');
    $deltatim = $last_upload_time + $limit_time - $timnow;
    $temp = $deltatim;
    //	$months  = floor( $temp / $seconds['month'] );
    //	$temp    = $temp % $seconds['month'];
    $weeks = floor($temp / $seconds['week']);
    $temp = $temp % $seconds['week'];
    $days = floor($temp / $seconds['day']);
    $temp = $temp % $seconds['day'];
    $hours = floor($temp / $seconds['hour']);
    $temp = $temp % $seconds['hour'];
    $mins = floor($temp / $seconds['min']);
    $secs = $temp % $seconds['min'];
    $switch = false;
    $string = __('You can upload after', 'wp-photo-album-plus') . ' ';
    //	if ( $months           ) { $string .= $months.' '.'months'.', '; $switch = true; }
    if ($weeks || $switch) {
        $string .= $weeks . ' ' . __('weeks', 'wp-photo-album-plus') . ', ';
        $switch = true;
    }
    if ($days || $switch) {
        $string .= $days . ' ' . __('days', 'wp-photo-album-plus') . ', ';
        $switch = true;
    }
    if ($hours || $switch) {
        $string .= $hours . ' ' . __('hours', 'wp-photo-album-plus') . ', ';
        $switch = true;
    }
    if ($mins || $switch) {
        $string .= $mins . ' ' . __('minutes', 'wp-photo-album-plus') . ' ' . __('and', 'wp-photo-album-plus') . ' ';
        $switch = true;
    }
    if ($switch) {
        $string .= $secs . ' ' . __('seconds', 'wp-photo-album-plus');
    }
    $string .= '.';
    $result = '<span style="font-size:9px;"> ' . $string . '</span>';
    return $result;
}
function wppa_get_potd()
{
    global $wpdb;
    global $thumb;
    $image = '';
    switch (wppa_opt('wppa_widget_method')) {
        case '1':
            // Fixed photo
            $id = wppa_opt('wppa_widget_photo');
            if ($id != '') {
                $image = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s LIMIT 0,1", $id), ARRAY_A);
                wppa_dbg_q('Q-Potd');
                wppa_cache_photo('add', $image);
            }
            break;
        case '2':
            // Random
            $album = wppa_opt('wppa_widget_album');
            if ($album == 'topten') {
                $images = wppa_get_widgetphotos($album);
                if (count($images) > 1) {
                    // Select a random first from the current selection
                    $idx = rand(0, count($images) - 1);
                    $image = $images[$idx];
                }
            } elseif ($album != '') {
                $images = wppa_get_widgetphotos($album, "ORDER BY RAND() LIMIT 0,1");
                $image = $images[0];
            }
            break;
        case '3':
            // Last upload
            $album = wppa_opt('wppa_widget_album');
            if ($album == 'topten') {
                $images = wppa_get_widgetphotos($album);
                if ($images) {
                    // fid last uploaded image in the $images pool
                    $temp = 0;
                    foreach ($images as $img) {
                        if ($img['timestamp'] > $temp) {
                            $temp = $img['timestamp'];
                            $image = $img;
                        }
                    }
                }
            } elseif ($album != '') {
                $images = wppa_get_widgetphotos($album, "ORDER BY timestamp DESC LIMIT 0,1");
                $image = $images[0];
            }
            break;
        case '4':
            // Change every
            $album = wppa_opt('wppa_widget_album');
            if ($album != '') {
                $per = wppa_opt('wppa_widget_period');
                $photos = wppa_get_widgetphotos($album);
                if ($per == '0') {
                    if ($photos) {
                        $image = $photos[rand(0, count($photos) - 1)];
                    } else {
                        $image = '';
                    }
                } elseif ($per == 'day-of-week') {
                    $image = '';
                    if ($photos) {
                        $d = wppa_local_date('w');
                        if (!$d) {
                            $d = '7';
                        }
                        foreach ($photos as $img) {
                            if ($img['p_order'] == $d) {
                                $image = $img;
                            }
                        }
                    }
                } elseif ($per == 'day-of-month') {
                    $image = '';
                    if ($photos) {
                        $d = wppa_local_date('d');
                        if (substr($d, '0', '1') == '0') {
                            $d = substr($d, '1');
                        }
                        foreach ($photos as $img) {
                            if ($img['p_order'] == $d) {
                                $image = $img;
                            }
                        }
                    }
                } else {
                    $u = date("U");
                    // Seconds since 1-1-1970
                    $u /= 3600;
                    //  hours since
                    $u = floor($u);
                    $u /= $per;
                    $u = floor($u);
                    if ($photos) {
                        $p = count($photos);
                        $idn = fmod($u, $p);
                        $image = $photos[$idn];
                    } else {
                        $image = '';
                    }
                }
            } else {
                $image = '';
            }
            break;
        default:
            $image = '';
    }
    $thumb = $image;
    return $image;
}
Exemple #10
0
function wppa_crumb_page_ancestors($page = '0')
{
    global $wpdb;
    $query = "SELECT post_parent FROM " . $wpdb->posts . " WHERE post_type = 'page' AND post_status = 'publish' AND id = %s LIMIT 0,1";
    $parent = $wpdb->get_var($wpdb->prepare($query, $page));
    wppa_dbg_q('Q-bc4');
    if (!is_numeric($parent) || $parent == '0') {
        return;
    }
    wppa_crumb_page_ancestors($parent);
    $query = "SELECT post_title FROM " . $wpdb->posts . " WHERE post_type = 'page' AND post_status = 'publish' AND id = %s LIMIT 0,1";
    $title = $wpdb->get_var($wpdb->prepare($query, $parent));
    wppa_dbg_q('Q-bc5');
    $title = __(stripslashes($title));
    if (!$title) {
        $title = '****';
        // Page exists but is not publish
        wppa_bcitem($title, '#', __('Unpublished', 'wp-photo-album-plus'), $class = 'b2');
    } else {
        wppa_bcitem($title, get_page_link($parent), __('Page:', 'wp-photo-album-plus') . ' ' . $title, 'b2');
    }
}
function wppa_get_youngest_album_name()
{
    global $wpdb;
    $result = $wpdb->get_var("SELECT `name` FROM `" . WPPA_ALBUMS . "` ORDER BY `id` DESC LIMIT 1");
    wppa_dbg_q('Q17');
    return stripslashes($result);
}
function wppa_is_user_blacklisted($user = -1)
{
    global $wpdb;
    static $result = -1;
    $cur = -1 == $user;
    if ($cur && -1 != $result) {
        // Already found out for current user
        return $result;
    }
    if ($cur && !is_user_logged_in()) {
        // An logged out user can not be on the blacklist
        $result = false;
        return false;
    }
    $blacklist = get_option('wppa_black_listed_users', array());
    if (empty($blacklist)) {
        // Anybody on the blacklist?
        $result = false;
        return false;
    }
    if ($cur) {
        $user = get_current_user_id();
    }
    if (is_numeric($user)) {
        $user = $wpdb->get_var($wpdb->prepare("SELECT `user_login` FROM `" . $wpdb->users . "` WHERE `ID` = %d", $user));
        wppa_dbg_q('Q-iub');
    } else {
        return false;
    }
    if ($cur) {
        $result = in_array($user, $blacklist);
        // Save current users result.
    }
    return in_array($user, $blacklist);
}
Exemple #13
0
function wppa_auto_page_links($where)
{
    global $wpdb;
    $m = $where == 'bottom' ? 'margin-top:8px;' : '';
    $mustwhere = wppa_opt('auto_page_links');
    if (($mustwhere == 'top' || $mustwhere == 'both') && $where == 'top' || ($mustwhere == 'bottom' || $mustwhere == 'both') && $where == 'bottom') {
        wppa_out('
			<div' . ' id="prevnext1-' . wppa('mocc') . '"' . ' class="wppa-box wppa-nav wppa-nav-text"' . ' style="text-align: center; ' . __wcs('wppa-box') . __wcs('wppa-nav') . __wcs('wppa-nav-text') . $m . '"' . ' >');
        $photo = wppa('single_photo');
        $thumb = wppa_cache_thumb($photo);
        $album = $thumb['album'];
        $photos = $wpdb->get_results($wpdb->prepare("SELECT `id`, `page_id` FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s " . wppa_get_photo_order($album), $album), ARRAY_A);
        wppa_dbg_q('Q-Ppag');
        $prevpag = '0';
        $nextpag = '0';
        $curpag = get_the_ID();
        $count = count($photos);
        $count_ = $count - 1;
        $current = '0';
        if ($photos) {
            foreach (array_keys($photos) as $idx) {
                if ($photos[$idx]['page_id'] == $curpag) {
                    if ($idx != '0') {
                        $prevpag = wppa_get_the_auto_page($photos[$idx - 1]['id']);
                    }
                    // ['page_id'];
                    if ($idx != $count_) {
                        $nextpag = wppa_get_the_auto_page($photos[$idx + 1]['id']);
                    }
                    // ['page_id'];
                    $current = $idx;
                }
            }
        }
        if ($prevpag) {
            wppa_out('<a href="' . get_permalink($prevpag) . '" style="float:left" >' . __('< Previous', 'wp-photo-album-plus') . '</a>');
        } else {
            wppa_out('<span style="visibility:hidden" >' . __('< Previous', 'wp-photo-album-plus') . '</span>');
        }
        wppa_out(++$current . '/' . $count);
        if ($nextpag) {
            wppa_out('<a href="' . get_permalink($nextpag) . '" style="float:right" >' . __('Next >', 'wp-photo-album-plus') . '</a>');
        } else {
            wppa_out('<span style="visibility:hidden" >' . __('Next >', 'wp-photo-album-plus') . '</span>');
        }
        wppa_out('</div><div style="clear:both"></div>');
    }
}
    function do_album_navigator($parent, $page, $skip, $propclass)
    {
        global $wpdb;
        static $level;
        static $ca;
        if (!$level) {
            $level = '1';
            if (isset($_REQUEST['wppa-album'])) {
                $ca = $_REQUEST['wppa-album'];
            } elseif (isset($_REQUEST['album'])) {
                $ca = $_REQUEST['album'];
            } else {
                $ca = '0';
            }
            $ca = wppa_force_numeric_else($ca, '0');
            if ($ca && !wppa_album_exists($ca)) {
                //				wppa_log('dbg', 'Non-existent album '.$ca.' in url. Referrer= '.$_ENV["HTTP_REFERER"].', Request uri= '.$_ENV["REQUEST_URI"]);
                $ca = '0';
            }
        } else {
            $level++;
        }
        $slide = wppa_opt('album_navigator_widget_linktype') == 'slide' ? '&amp;wppa-slide=1' : '';
        $w = $this->get_widget_id();
        $p = $parent;
        $result = '';
        $albums = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_ALBUMS . "` WHERE `a_parent` = %s " . wppa_get_album_order(max('0', $parent)), $parent), ARRAY_A);
        wppa_dbg_q('Q-WidANav');
        if (!empty($albums)) {
            wppa_cache_album('add', $albums);
            $result .= '<ul>';
            foreach ($albums as $album) {
                $a = $album['id'];
                $treecount = wppa_treecount_a($a);
                if ($treecount['albums'] || $treecount['photos'] > wppa_opt('min_thumbs') || $skip == 'no') {
                    $result .= '
						<li class="anw-' . $w . '-' . $p . $propclass . '" style="list-style:none; display:' . ($level == '1' ? '' : 'none') . ';">';
                    if (wppa_has_children($a)) {
                        $result .= '
							<div style="cursor:default;width:12px;float:left;text-align:center;font-weight:bold;" class="anw-' . $w . '-' . $a . '-" onclick="jQuery(\'.anw-' . $w . '-' . $a . '\').css(\'display\',\'\'); jQuery(\'.anw-' . $w . '-' . $a . '-\').css(\'display\',\'none\');" >' . ($a == $ca ? '&raquo;' : '+') . '</div>
							<div style="cursor:default;width:12px;float:left;text-align:center;font-weight:bold;display:none;" class="anw-' . $w . '-' . $a . '" onclick="jQuery(\'.anw-' . $w . '-' . $a . '-\').css(\'display\',\'\'); jQuery(\'.anw-' . $w . '-' . $a . '\').css(\'display\',\'none\'); jQuery(\'.p-' . $w . '-' . $a . '\').css(\'display\',\'none\');" >' . ($a == $ca ? '&raquo;' : '-') . '</div>';
                    } else {
                        $result .= '
							<div style="width:12px;float:left;" >&nbsp;' . ($a == $ca ? '&raquo;' : '') . '</div>';
                    }
                    $result .= '
							<a href="' . wppa_get_permalink($page) . '&amp;wppa-album=' . $a . '&amp;wppa-cover=0&amp;wppa-occur=1' . $slide . '">' . wppa_get_album_name($a) . '</a>
						</li>';
                    $newpropclass = $propclass . ' p-' . $w . '-' . $p;
                    $result .= '<li class="anw-' . $w . '-' . $p . $propclass . '" style="list-style:none;" >' . $this->do_album_navigator($a, $page, $skip, $newpropclass) . '</li>';
                }
            }
            $result .= '</ul>';
            if ($level == '1' && $ca) {
                // && $parent != '-1' ) {
                $result .= '<script type="text/javascript" >';
                while ($ca != '0' && $ca != '-1') {
                    $result .= '
								jQuery(\'.anw-' . $w . '-' . $ca . '\').css(\'display\',\'\'); jQuery(\'.anw-' . $w . '-' . $ca . '-\').css(\'display\',\'none\');';
                    $ca = wppa_get_parentalbumid($ca);
                }
                $result .= '</script>';
            }
        }
        $level--;
        return str_replace('<ul></ul>', '', $result);
    }
function wppa_get_coverphoto_ids($alb, $count)
{
    global $wpdb;
    if (!$alb) {
        return false;
    }
    // no album, no coverphoto
    // Find cover photo id
    $id = wppa_get_album_item($alb, 'main_photo');
    // main_photo is a positive integer ( photo id )?
    if ($id > '0') {
        // 1 coverphoto explicitly given
        $photo = wppa_cache_photo($id);
        if (!$photo) {
            // Photo gone, set id to 0
            $id = '0';
        } elseif ($photo['album'] != $alb) {
            // Photo moved to other album, set id to 0
            $id = '0';
        } else {
            $temp['0'] = $photo;
            // Found!
        }
    }
    // main_photo is 0? Random
    if ('0' == $id) {
        if (current_user_can('wppa_moderate')) {
            $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s ORDER BY RAND( " . wppa_get_randseed('page') . " ) LIMIT %d", $alb, $count), ARRAY_A);
        } else {
            $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s AND ( ( `status` <> 'pending' AND `status` <> 'scheduled' ) OR `owner` = %s ) ORDER BY RAND( " . wppa_get_randseed('page') . " ) LIMIT %d", $alb, wppa_get_user(), $count), ARRAY_A);
        }
    }
    // main_photo is -2? Last upload
    if ('-2' == $id) {
        if (current_user_can('wppa_moderate')) {
            $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s ORDER BY `timestamp` DESC LIMIT %d", $alb, $count), ARRAY_A);
        } else {
            $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s AND ( ( `status` <> 'pending' AND `status` <> 'scheduled' ) OR `owner` = %s ) ORDER BY `timestamp` DESC LIMIT %d", $alb, wppa_get_user(), $count), ARRAY_A);
        }
    }
    // main_phtot is -1? Random featured
    if ('-1' == $id) {
        $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s AND `status` = 'featured' ORDER BY RAND( " . wppa_get_randseed('page') . " ) LIMIT %d", $alb, $count), ARRAY_A);
    }
    // Random from children
    if ('-3' == $id) {
        $allalb = wppa_expand_enum(wppa_alb_to_enum_children($alb));
        $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` " . "WHERE `album` IN ( " . str_replace('.', ',', $allalb) . " ) " . "AND ( ( `status` <> 'pending' AND `status` <> 'scheduled' ) OR `owner` = %s ) " . "ORDER BY RAND( " . wppa_get_randseed('page') . " ) LIMIT %d", wppa_get_user(), $count), ARRAY_A);
    }
    // Most recent from children
    if ('-4' == $id) {
        $allalb = wppa_expand_enum(wppa_alb_to_enum_children($alb));
        $temp = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` " . "WHERE `album` IN ( " . str_replace('.', ',', $allalb) . " ) " . "AND ( ( `status` <> 'pending' AND `status` <> 'scheduled' ) OR `owner` = %s ) " . "ORDER BY `timestamp` DESC LIMIT %d", wppa_get_user(), $count), ARRAY_A);
    }
    // Report query
    wppa_dbg_q('Q-gcovp');
    // Add to 2nd level cache
    wppa_cache_photo('add', $temp);
    // Extract the ids only
    $ids = array();
    if (is_array($temp)) {
        foreach ($temp as $item) {
            $ids[] = $item['id'];
        }
    }
    return $ids;
}
function wppa_is_id_free($type, $id)
{
    global $wpdb;
    if (!is_numeric($id)) {
        return false;
    }
    if ($id == '0') {
        return false;
    }
    $table = '';
    if ($type == 'album') {
        $table = WPPA_ALBUMS;
    } elseif ($type == 'photo') {
        $table = WPPA_PHOTOS;
    } else {
        $table = $type;
    }
    // $type may be the tablename itsself
    if ($table == '') {
        echo 'Unexpected error in wppa_is_id_free()';
        return false;
    }
    $exists = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . $table . "` WHERE `id` = %s", $id), ARRAY_A);
    wppa_dbg_q('Q208');
    if ($exists) {
        return false;
    }
    return true;
}