function ratings_shortcode($atts) { $attributes = shortcode_atts(array('id' => 0, 'results' => false), $atts); if (!is_feed()) { $id = intval($attributes['id']); if ($attributes['results']) { return the_ratings_results($id); } else { return the_ratings('span', $id, false); } } else { return __('Note: There is a rating embedded within this post, please visit this post to rate it.', 'wp-postratings'); } }
/** * Parses content tags * * @since 1.4.6 * @param string HTML string with content tags * @param array Post data * @param bool Used to display post rating (if functionality is available) * @return string */ private function __format_content($string, $data = array(), $rating) { if (empty($string) || (empty($data) || !is_array($data))) { return false; } $params = array(); $pattern = '/\\{(excerpt|summary|stats|title|image|thumb|thumb_img|rating|score|url|text_title|author|category|views|comments|date)\\}/i'; preg_match_all($pattern, $string, $matches); array_map('strtolower', $matches[0]); if (in_array("{title}", $matches[0])) { $string = str_replace("{title}", $data['title'], $string); } if (in_array("{stats}", $matches[0])) { $string = str_replace("{stats}", $data['stats'], $string); } if (in_array("{excerpt}", $matches[0]) || in_array("{summary}", $matches[0])) { $string = str_replace(array("{excerpt}", "{summary}"), $data['summary'], $string); } if (in_array("{image}", $matches[0]) || in_array("{thumb}", $matches[0])) { $string = str_replace(array("{image}", "{thumb}"), $data['img'], $string); } if (in_array("{thumb_img}", $matches[0])) { $string = str_replace("{thumb_img}", $data['img_no_link'], $string); } // WP-PostRatings check if ($rating) { if (function_exists('the_ratings_results') && in_array("{rating}", $matches[0])) { $string = str_replace("{rating}", the_ratings_results($data['id']), $string); } if (function_exists('expand_ratings_template') && in_array("{score}", $matches[0])) { $string = str_replace("{score}", expand_ratings_template('%RATINGS_SCORE%', $data['id']), $string); // removing the redundant plus sign $string = str_replace('+', '', $string); } } if (in_array("{url}", $matches[0])) { $string = str_replace("{url}", $data['url'], $string); } if (in_array("{text_title}", $matches[0])) { $string = str_replace("{text_title}", $data['text_title'], $string); } if (in_array("{author}", $matches[0])) { $string = str_replace("{author}", $data['author'], $string); } if (in_array("{category}", $matches[0])) { $string = str_replace("{category}", $data['category'], $string); } if (in_array("{views}", $matches[0])) { $string = str_replace("{views}", $data['views'], $string); } if (in_array("{comments}", $matches[0])) { $string = str_replace("{comments}", $data['comments'], $string); } if (in_array("{date}", $matches[0])) { $string = str_replace("{date}", $data['date'], $string); } return $string; }
function get_most_rated_events($mode = '', $min_votes = 0, $limit = 10, $chars = 0, $display = true) { global $wpdb; $ratings_max = intval(get_option('postratings_max')); $ratings_custom = intval(get_option('postratings_customrating')); $output = ''; if (!empty($mode) && $mode != 'both') { $where = "{$wpdb->posts}.post_type = '{$mode}'"; } else { $where = '1=1'; } if ($ratings_custom && $ratings_max == 2) { $order_by = 'ratings_score'; } else { $order_by = 'ratings_average'; } $temp2 = $temp3 = $temp4 = ''; $post_id = "%POST_URL%"; $temp = '<li>'; $temp3 .= '<div class="main_event_widget_container"> <a href="%POST_URL%" title="%POST_TITLE%">%POST_TITLE%</a>'; $temp2 .= '</div><div class="right_event_widget_container"> <a href="%POST_URL%" class="icon-play-1" title="%POST_TITLE%">'; $temp4 .= '</a> <a href="%POST_URL%' . '#tickets' . '" class="icon-ticket" title="%POST_TITLE%"></a></div> </li>'; $most_rated = $wpdb->get_results("SELECT DISTINCT {$wpdb->posts}.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users, (t3.meta_value+0.00) AS ratings_score FROM {$wpdb->posts} LEFT JOIN {$wpdb->postmeta} AS t1 ON t1.post_id = {$wpdb->posts}.ID LEFT JOIN {$wpdb->postmeta} As t2 ON t1.post_id = t2.post_id LEFT JOIN {$wpdb->postmeta} AS t3 ON t3.post_id = {$wpdb->posts}.ID WHERE t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' AND t3.meta_key = 'ratings_score' AND {$wpdb->posts}.post_password = '' AND {$wpdb->posts}.post_date < '" . current_time('mysql') . "' AND {$wpdb->posts}.post_status = 'publish' AND t2.meta_value >= {$min_votes} AND {$where} ORDER BY ratings_users DESC, {$order_by} DESC LIMIT {$limit}"); if ($most_rated) { $i = 1; foreach ($most_rated as $post) { $output .= expand_ratings_template($temp, $post, null, $chars, false); if ($i == 10) { $output .= '<span class="event_widget_number last">' . $i . '</span>'; } else { $output .= '<span class="event_widget_number">' . $i . '</span>'; } $post_id = url_to_postid(expand_ratings_template($post_id, $post, null, $chars, false)); $output .= expand_ratings_template($temp3, $post, null, $chars, false); if (function_exists('the_ratings')) { $rating_images = substr_replace(the_ratings_results($post->ID), '', strlen(the_ratings_results($post->ID)) - 5); $rating_value = number_format(floatval(substr(the_ratings_results(get_the_ID()), strlen(the_ratings_results(get_the_ID())) - 5)), 1); if ($rating_value < 10) { $rating_value = ' ' . $rating_value; } $output .= '<div class="event_list_rating">' . $rating_images . $rating_value . '</div>'; } $output .= expand_ratings_template($temp2, $post, null, $chars, false); $youtube = explode('=', get_post_meta($post->ID, 'event_trailer', true)); if ($youtube[0] != '') { $youtube_url = $youtube['1']; } else { $youtube_url = ''; } $output .= '<input type="hidden" value="' . $youtube_url . '"></input>'; $output .= expand_ratings_template($temp4, $post, null, $chars, false) . "\n"; $i++; } } else { $output = '<li>' . __('N/A', 'vh') . '</li>' . "\n"; } if ($display) { echo $output; } else { return $output; } }
} // ToDo: break, if rated comment } //echo "<br>-B-"; $deact = '<span class="active">' . $txt_subscr_active . '</span>'; if (strpos($a_subscription->status, "C") != false) { $deact = '<span class="warning">' . $txt_subscr_inactive . '</span>'; } //echo "<li><label for='post_{$a_subscription->post_id}'><input type='checkbox' name='post_list[]' value='{$a_subscription->post_id}' id='post_{$a_subscription->post_id}'/> <span class='subscribe-column-1'>$a_subscription->dt</span> <span class='subscribe-separator subscribe-separator-1'>—</span> <span class='subscribe-column-2'>{$a_subscription->status}</span> <span class='subscribe-separator subscribe-separator-2'>—</span> <a class='subscribe-column-3' href='$permalink'>$title</a></label></li>\n"; echo "<tr id=\"regcont\">\n\n\n <td id=\"col1\"> "; // <center><label id=\"registration\" for='post_{$a_subscription->post_id}'> // <input type='checkbox' name='post_list[]' value='{$a_subscription->post_id}' id='post_{$a_subscription->post_id}'/> // </center> echo "</td>"; // list HW entry $rating = the_ratings_results($a_subscription->post_id, 0, 0, 0, 10); $commenttext = ""; if ($comment_excerpt != "") { $commenttext = '<div class="hwprofile-cite"><i>"' . wp_strip_all_tags($comment_excerpt) . '"</i> (<a href="' . $permalink . '#comment-' . $CID . '">' . $txt_subscr_more . '</a>)</div>'; } echo "\n <td id=\"col-hw\"> <a class='subscribe-column-3' href='{$permalink}'>{$art_image}</a>\n\n " . '<div class="subscribe-hwtext"><div class="subscribe-hwtext-span"><a href=' . $permalink . '>' . $title . '</a><br>' . $rating . '<br>' . $commenttext . '</div></div></label> </td>'; /* echo " <td id=\"col-hw\"> <a class='subscribe-column-3' href='$permalink'>$art_image</a> ".'<div class="subscribe-hwtext"><span class="subscribe-hwtext-span"><a href='.$permalink.'>'.$title.'</a><br>'.$rating.'</span></div></label> </td>'; //<td id=\"col4\">
function process_ratings() { global $wpdb, $user_identity, $user_ID; if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'postratings') { $rate = intval($_REQUEST['rate']); $post_id = intval($_REQUEST['pid']); // Verify Referer if (!check_ajax_referer('postratings_' . $post_id . '-nonce', 'postratings_' . $post_id . '_nonce', false)) { _e('Failed To Verify Referrer', 'wp-postratings'); exit; } if ($rate > 0 && $post_id > 0 && check_allowtorate()) { // Check For Bot $bots_useragent = array('googlebot', 'google', 'msnbot', 'ia_archiver', 'lycos', 'jeeves', 'scooter', 'fast-webcrawler', 'slurp@inktomi', 'turnitinbot', 'technorati', 'yahoo', 'findexa', 'findlinks', 'gaisbo', 'zyborg', 'surveybot', 'bloglines', 'blogsearch', 'ubsub', 'syndic8', 'userland', 'gigabot', 'become.com'); $useragent = $_SERVER['HTTP_USER_AGENT']; foreach ($bots_useragent as $bot) { if (stristr($useragent, $bot) !== false) { return; } } header('Content-Type: text/html; charset=' . get_option('blog_charset') . ''); postratings_textdomain(); $rated = check_rated($post_id); // Check Whether Post Has Been Rated By User if (!$rated) { // Check Whether Is There A Valid Post $post = get_post($post_id); // If Valid Post Then We Rate It if ($post && !wp_is_post_revision($post)) { $ratings_max = intval(get_option('postratings_max')); $ratings_custom = intval(get_option('postratings_customrating')); $ratings_value = get_option('postratings_ratingsvalue'); $post_title = addslashes($post->post_title); $post_ratings = get_post_custom($post_id); $post_ratings_users = !empty($post_ratings['ratings_users']) ? intval($post_ratings['ratings_users'][0]) : 0; $post_ratings_score = !empty($post_ratings['ratings_score']) ? intval($post_ratings['ratings_score'][0]) : 0; // Check For Ratings Lesser Than 1 And Greater Than $ratings_max if ($rate < 1 || $rate > $ratings_max) { $rate = 0; } $post_ratings_users = $post_ratings_users + 1; $post_ratings_score = $post_ratings_score + intval($ratings_value[$rate - 1]); $post_ratings_average = round($post_ratings_score / $post_ratings_users, 2); update_post_meta($post_id, 'ratings_users', $post_ratings_users); update_post_meta($post_id, 'ratings_score', $post_ratings_score); update_post_meta($post_id, 'ratings_average', $post_ratings_average); // Add Log if (!empty($user_identity)) { $rate_user = addslashes($user_identity); } elseif (!empty($_COOKIE['comment_author_' . COOKIEHASH])) { $rate_user = addslashes($_COOKIE['comment_author_' . COOKIEHASH]); } else { $rate_user = __('Guest', 'wp-postratings'); } $rate_user = apply_filters('wp_postratings_process_ratings_user', $rate_user); $rate_userid = apply_filters('wp_postratings_process_ratings_userid', intval($user_ID)); // Only Create Cookie If User Choose Logging Method 1 Or 3 $postratings_logging_method = intval(get_option('postratings_logging_method')); if ($postratings_logging_method == 1 || $postratings_logging_method == 3) { $rate_cookie = setcookie("rated_" . $post_id, $ratings_value[$rate - 1], time() + 30000000, apply_filters('wp_postratings_cookiepath', SITECOOKIEPATH)); } // Log Ratings No Matter What $rate_log = $wpdb->query($wpdb->prepare("INSERT INTO {$wpdb->ratings} VALUES (%d, %d, %s, %d, %d, %s, %s, %s, %d )", 0, $post_id, $post_title, $ratings_value[$rate - 1], current_time('timestamp'), get_ipaddress(), @gethostbyaddr(get_ipaddress()), $rate_user, $rate_userid)); // Allow Other Plugins To Hook When A Post Is Rated do_action('rate_post', $rate_userid, $post_id, $ratings_value[$rate - 1]); // Output AJAX Result echo the_ratings_results($post_id, $post_ratings_users, $post_ratings_score, $post_ratings_average); exit; } else { printf(__('Invalid Post ID. Post ID #%s.', 'wp-postratings'), $post_id); exit; } // End if($post) } else { printf(__('You Had Already Rated This Post. Post ID #%s.', 'wp-postratings'), $post_id); exit; } // End if(!$rated) } // End if($rate && $post_id && check_allowtorate()) } // End if(isset($_REQUEST['action']) && $_REQUEST['action'] == 'postratings') }
} $comment = $a_identified_hw->usercomment; $url = $a_identified_hw->url; $id = $a_identified_hw->id; #$category_ids[1]->cat_name = ""; #overwrite old values $category_ids = get_the_category($postid); $category_name = $category_ids[0]->cat_name; #$category_name2 = ""; $category_name2 = $category_ids[1]->cat_name; # --- Registered users global $wpdb; $usernum = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->postmeta} WHERE meta_key LIKE '\\_stcr@\\_%' AND post_id = " . $postid); // list HW entry #$commenttext = ""; #if ($comment_excerpt != "") $commenttext='<div class="hwprofile-cite"><i>"'.wp_strip_all_tags($comment_excerpt).'"</i> <br>(<a href="'.$permalink.'#comment-'.$CID.'">'.$txt_subscr_more.'</a> - <a href="/wp-admin/comment.php?action=editcomment&c='.$CID.'">'.$txt_subscr_edit_comment.'</a>)</div>'; $rating = the_ratings_results($postid, 0, 0, 0, 10); if (count($postids) > $multilimit) { #small version, no image echo "\n \t <td id=\"col-hw\"> \n \t" . '<div class="subscribe-hwtext"><div class="subscribe-hwtext-span-scan-small"><a href=' . $permalink . ' target="_blank">' . $short_title . '</a></div></div>' . $title_part2 . '</label>' . "<span class='subscribe-column-23-small'>{$rating}</span>"; print " </td>"; } else { echo "\n <td id=\"col-hw\"> <a class='hwscan-found-image' href='{$permalink}' target='_blank' >{$art_image}</a>\n\n " . '<div class="subscribe-hwtext"><div class="subscribe-hwtext-span-scan"><a href=' . $permalink . ' target="_blank">' . $short_title . '</a></div></div>' . $title_part2 . '</label>' . "<span class='subscribe-column-23'>{$rating}</span>"; print " </td>"; } //<td id=\"col4\"> //<span class='subscribe-column-2'>$deact<br>({$a_subscription->status})</span> //</td> // --- Add to HW profile if ($userknown == 1) { $hwbutton = lhg_add_hwbutton($email, $a_identified_hw->postid); #$hwbutton = "Test";
function format_content($string, $data = array(), $rating) { if (empty($string) || (empty($data) || !is_array($data))) { return false; } $params = array(); $pattern = '/\\{(summary|stats|title|image|rating)\\}/i'; preg_match_all($pattern, $string, $matches); for ($i = 0; $i < count($matches[0]); $i++) { if (strtolower($matches[0][$i]) == "{title}") { $params[$matches[0][$i]] = $data['title']; continue; } if (strtolower($matches[0][$i]) == "{stats}") { $params[$matches[0][$i]] = $data['stats']; continue; } if (strtolower($matches[0][$i]) == "{summary}") { $params[$matches[0][$i]] = $data['summary']; continue; } if (strtolower($matches[0][$i]) == "{image}") { $params[$matches[0][$i]] = $data['img']; continue; } // WP-PostRatings check if ($rating) { if (strtolower($matches[0][$i]) == "{rating}") { $params[$matches[0][$i]] = the_ratings_results($data['id']); continue; } } } for ($i = 0; $i < count($params); $i++) { $string = str_replace($matches[0][$i], $params[$matches[0][$i]], $string); } return $string; }
function process_ratings() { global $wpdb, $user_identity, $user_ID; $rate = intval($_GET['rate']); $post_id = intval($_GET['pid']); if ($rate > 0 && $post_id > 0 && check_allowtorate()) { // Check For Bot $bots_useragent = array('googlebot', 'google', 'msnbot', 'ia_archiver', 'lycos', 'jeeves', 'scooter', 'fast-webcrawler', 'slurp@inktomi', 'turnitinbot', 'technorati', 'yahoo', 'findexa', 'findlinks', 'gaisbo', 'zyborg', 'surveybot', 'bloglines', 'blogsearch', 'ubsub', 'syndic8', 'userland', 'gigabot', 'become.com'); $useragent = $_SERVER['HTTP_USER_AGENT']; foreach ($bots_useragent as $bot) { if (stristr($useragent, $bot) !== false) { return; } } header('Content-Type: text/html; charset=' . get_option('blog_charset') . ''); postratings_textdomain(); $rated = check_rated($post_id); // Check Whether Post Has Been Rated By User if (!$rated) { // Check Whether Is There A Valid Post $post = get_post($post_id); // If Valid Post Then We Rate It if ($post && !wp_is_post_revision($post)) { $ratings_max = intval(get_option('postratings_max')); $ratings_custom = intval(get_option('postratings_customrating')); $ratings_value = get_option('postratings_ratingsvalue'); $post_title = addslashes($post->post_title); $post_ratings = get_post_custom($post_id); $post_ratings_users = intval($post_ratings['ratings_users'][0]); $post_ratings_score = intval($post_ratings['ratings_score'][0]); // Check For Ratings Lesser Than 1 And Greater Than $ratings_max if ($rate < 1 || $rate > $ratings_max) { $rate = 0; } $post_ratings_users = $post_ratings_users + 1; $post_ratings_score = $post_ratings_score + intval($ratings_value[$rate - 1]); $post_ratings_average = round($post_ratings_score / $post_ratings_users, 2); if (!update_post_meta($post_id, 'ratings_users', $post_ratings_users)) { add_post_meta($post_id, 'ratings_users', $post_ratings_users, true); } if (!update_post_meta($post_id, 'ratings_score', $post_ratings_score)) { add_post_meta($post_id, 'ratings_score', $post_ratings_score, true); } if (!update_post_meta($post_id, 'ratings_average', $post_ratings_average)) { add_post_meta($post_id, 'ratings_average', $post_ratings_average, true); } // Add Log if (!empty($user_identity)) { $rate_user = addslashes($user_identity); } elseif (!empty($_COOKIE['comment_author_' . COOKIEHASH])) { $rate_user = addslashes($_COOKIE['comment_author_' . COOKIEHASH]); } else { $rate_user = __('Guest', 'wp-postratings'); } $rate_userid = intval($user_ID); // Only Create Cookie If User Choose Logging Method 1 Or 3 $postratings_logging_method = intval(get_option('postratings_logging_method')); if ($postratings_logging_method == 1 || $postratings_logging_method == 3) { $rate_cookie = setcookie("rated_" . $post_id, $ratings_value[$rate - 1], time() + 30000000, COOKIEPATH); } // Log Ratings No Matter What $rate_log = $wpdb->query("INSERT INTO {$wpdb->ratings} VALUES (0, {$post_id}, '{$post_title}', " . $ratings_value[$rate - 1] . ",'" . current_time('timestamp') . "', '" . get_ipaddress() . "', '" . esc_attr(@gethostbyaddr(get_ipaddress())) . "' ,'{$rate_user}', {$rate_userid})"); # store into transver LHG database lhg_store_ratings($post_id, $post_ratings_users, $post_ratings_score, $ratings_value[$rate - 1]); // Output AJAX Result //echo the_ratings_results($post_id, $post_ratings_users, $post_ratings_score, $post_ratings_average); //show my rating, not the average echo the_ratings_results($post_id, $post_ratings_users, $post_ratings_score, $ratings_value[$rate - 1]); exit; } else { printf(__('Invalid Post ID. Post ID #%s.', 'wp-postratings'), $post_id); exit; } // End if($post) } else { printf(__('You Had Already Rated This Post. Post ID #%s.', 'wp-postratings'), $post_id); exit; } // End if(!$rated) } // End if($rate && $post_id && check_allowtorate()) }
$img = '<img src="' . get_stylesheet_directory_uri() . '/images/default.jpg" alt="' . get_the_title() . '" title="' . get_the_title() . '">'; } // create json map $address = get_field('address'); $dataLatLng = geocode($address); $news = ''; if (get_field('new')) { $news = '<div class="news-icon"><span>New</span></div>'; } else { if (get_field('page_hot')) { $news = '<div class="news-icon hot"><span>Hot</span></div>'; } } $url = $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $total_comment = getFacebookDetails($url); $ratings = the_ratings_results(get_the_ID()); $jsonData[] = array('title' => get_the_title(), 'lng' => $dataLatLng[0], 'lat' => $dataLatLng[1], 'address' => '', 'description' => '<p class="description">' . the_excerpt_max_charlength(18) . '</p>', 'vote' => '<div class="fs-comment"><span>Bình chọn:</span>' . $ratings . '</div>', 'img' => $img, 'baseurl' => get_the_permalink(), 'hot' => $news); ?> <?php } ?> </ul> <?php $defaultLng = 10.7596132; $defaultLat = 106.6644058; if ($jsonData) { foreach ($jsonData as $val) { if (!empty($val['lng']) || !empty($val['lat'])) { $defaultLng = $val['lng']; $defaultLat = $val['lat'];
function wp_one_post_widget($args, $vars = array()) { extract($args); $widget_number = (int) str_replace('wp-one-post-widget-', '', @$widget_id); $options = get_option('wp_one_post_widget'); if (!empty($options[$widget_number])) { $vars = $options[$widget_number]; } // ------ data used by several parts ---------- $title = translate_title(get_the_title()); $s = explode("(", $title); $short_title = trim($s[0]); global $post; global $wpdb; global $lhg_price_db; global $lang; global $txt_summary; global $txt_supplier; global $txt_cheapest_supplier; global $txt_rating; global $txt_select; global $txt_ratings; global $txt_sim_tags; global $txt_combine_tags; global $txt_wpop_register; global $txt_register_long; global $txt_send; global $txt_manage_subscr; global $txt_not_avail; global $txt_rate_yourself; global $txt_wpop_register; global $txt_button_string; //defined by amazon-product-in-a-post.php //echo "ID: $post->ID"; if (is_single($post->ID)) { $querystr = "\r\n SELECT {$wpdb->posts}.* \r\n FROM {$wpdb->posts}\r\n WHERE {$wpdb->posts}.post_title = '" . $vars['title'] . "'\r\n AND {$wpdb->posts}.post_status = 'publish' \r\n AND {$wpdb->posts}.post_type = 'post'\r\n "; $pageposts = $wpdb->get_results($querystr, OBJECT); foreach ($pageposts as $post) { setup_postdata($post); $title = $post->post_title; $excerpt = $post->post_excerpt; if (!$excerpt) { $excerpt = substr($post->post_content, 0, 100); } if (!$vars['thumbnail_position']) { $vars['thumbnail_position'] = 'left'; } $thumb = get_the_post_thumbnail($post->ID, 'thumbnail', array('class' => $vars['thumbnail_position'])); $link = get_permalink($post->ID); } echo "\n{$before_widget}"; echo ' <div class="topright" style="border: 1px solid #2b8fc3; padding-left: 3px; padding-right:3px; padding-top: 1px; margin-bottom: 10px; background-color: #fff; padding-bottom: 17px;">'; echo ' <div class="wp-one-summary">' . $txt_summary . "</div>"; // if(empty($vars['custom_title'])): echo $before_title . "A".$vars['title'] . $after_title; else: echo "<h2>".$vars['custom_title'] . "</h2>"; endif; if ($vars['use_thumbnail'] == 'yes') { $content_widget = $thumb . '<p>' . $excerpt . ' <a href="' . $link . '">' . $vars['readmore'] . '</a></p>'; } else { $content_widget = '<p>' . $excerpt . ' <a href="' . $link . '">' . $vars['readmore'] . '</a></p>'; } //$thumb = get_the_post_thumbnail($post->ID); //echo "$thumb"; //Rating Overview $post_id = $post->ID; // Check IP From IP Logging Database #$get_rates = $wpdb->get_results("SELECT rating_rating FROM $wpdb->ratings WHERE rating_postid = $post_id"); //echo "Nr: ".sizeof($get_rates); $rating1 = 0; $rating2 = 0; $rating3 = 0; $rating4 = 0; $rating5 = 0; $rating_total = 0; #foreach($get_rates as $get_rate){ # $rating_total++; # # if ($get_rate->rating_rating == 1 ) $rating1++; # if ($get_rate->rating_rating == 2 ) $rating2++; # if ($get_rate->rating_rating == 3 ) $rating3++; # if ($get_rate->rating_rating == 4 ) $rating4++; # if ($get_rate->rating_rating == 5 ) $rating5++; # #} if ($lang != "de") { $ratings = $lhg_price_db->get_results("SELECT * FROM `lhgtransverse_posts` WHERE postid_com = {$post_id}"); } if ($lang == "de") { $ratings = $lhg_price_db->get_results("SELECT * FROM `lhgtransverse_posts` WHERE postid_de = {$post_id}"); } #var_dump($ratings); $rating1 = $ratings[0]->post_ratings_1_com + $ratings[0]->post_ratings_1_de; $rating2 = $ratings[0]->post_ratings_2_com + $ratings[0]->post_ratings_2_de; $rating3 = $ratings[0]->post_ratings_3_com + $ratings[0]->post_ratings_3_de; $rating4 = $ratings[0]->post_ratings_4_com + $ratings[0]->post_ratings_4_de; $rating5 = $ratings[0]->post_ratings_5_com + $ratings[0]->post_ratings_5_de; $rating_total = $ratings[0]->post_ratings_users_com + $ratings[0]->post_ratings_users_de; #$rating1 + $rating2 + $rating3 + $rating4 + $rating5; //echo "<table cellspacing=0 cellpadding=0 border=1> // <tr> // <td width=90%>"; //echo "</td></tr></table> "; global $vspacer; $vspacer = '<div class="spacer" style="border-top: 1px solid #2b8fc3; height: 0px; margin-top: 9px; margin-bottom: 9px;"></div>'; // ---- Overview - cheapest supplier // get cheapest supplier $cheapest_supplier_id = lhg_db_get_cheapest_supplier_id($post->ID); #echo "CID: $cheapest_supplier_id <br>"; if ($cheapest_supplier_id != "") { lhg_show_supplier_square($cheapest_supplier_id, $post->ID); } if ($cheapest_supplier_id == "") { lhg_show_supplier_square_default($post->ID); } //get price & url from DB $region = get_region(); # $meta="price-amazon.".$region; # $aprice = get_post_meta($post->ID,$meta,true); # $meta="url-amazon.".$region; # $aurl=get_post_meta($post->ID,$meta,true); //amaz_url($post->ID); //still undefined? # if ($aurl == ""){ # $aid=get_id(); # $aurl = 'http://www.amazon.'.$region.'/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag='.$aid; # } /* if ( ($region == "de") or ($region == "fr") or ($region == "it") or ($region == "es")) { $aprice=str_replace(".","",$aprice); }else{ $aprice=str_replace(",","",$aprice); //$aprice=str_replace(",",".",$aprice); } */ //echo "AP0: $aprice"; # $aprice = lhg_amazon_price_to_float ( $aprice , $region ); //echo "AP1: $aprice"; // // affilinet prices // if ($lang == "de debug") { //echo "A"; $meta = "affilinet_PID"; $aff_PID = get_post_meta($post->ID, $meta, true); //amaz_url($post->ID); if ($aff_PID == "") { //check for wrong entered PID $meta = "PID_affilinet"; $aff_PID = get_post_meta($post->ID, $meta, true); //amaz_url($post->ID); //echo "affPID: $aff_PID"; } if ($aff_PID != "") { // check for multiple PIDs $PIDlist = str_getcsv($aff_PID, ";"); $num = count($PIDlist); //echo "Num: $num <br>PIDlist0: $PIDlist[0]<br>"; //echo "PIDlist1: $PIDlist[1]<br>"; if ($num == 1) { list($aff_date, $aff_shop_id, $aff_price, $aff_shipping, $aff_url) = get_price_aff($aff_PID); $cheapestURL = str_replace("+++++", ";", $aff_url); //echo "Cheap: $cheapestURL<br>"; $tprice = $aff_price + $aff_shipping; //echo "TP: $tprice <br>"; if ($aff_shop_id == 1739) { $pcount++; $pricetable[$pcount] = $tprice . '### EUR ' . str_replace(".", ",", number_format($tprice, 2)) . ' > <a href="' . $aff_url . '" rel="nofollow">Redcoon.de</a>'; $pricetable_data[$pcount] = $tprice . '###' . str_replace(".", ",", number_format($tprice, 2)) . '###' . $aff_url . '###Redcoon.de' . '###' . str_replace(".", ",", number_format($aff_shipping, 2)); } if ($aff_shop_id == 1752) { $pcount++; $pricetable[$pcount] = $tprice . '### EUR ' . str_replace(".", ",", number_format($tprice, 2)) . ' > <a href="' . $aff_url . '" rel="nofollow">Reichelt.de</a>'; $pricetable_data[$pcount] = $tprice . '###' . str_replace(".", ",", number_format($tprice, 2)) . '###' . $aff_url . '###Reichelt.de' . '###' . str_replace(".", ",", number_format($aff_shipping, 2)); } } if ($num > 1) { //cycle through IDs //$ProductIDList = str_getcsv($ProductID,";"); //echo "multiple ids<br>"; list($aff_date, $aff_shop_id, $aff_price, $aff_shipping, $aff_url) = get_price_aff($aff_PID, $num); //echo "ShopID: $aff_shop_id"; $ShopIDList = str_getcsv($aff_shop_id, ";"); $PriceList = str_getcsv($aff_price, ";"); $ShippingList = str_getcsv($aff_shipping, ";"); $URLList = str_getcsv($aff_url, ";"); $tpriceListCheapest = 9999999999; for ($i = 0; $i < $num; $i++) { $tpriceList[$i] = $PriceList[$i] + $ShippingList[$i]; //url of cheapest partner if ($tpriceList[$i] < $tpriceListCheapest) { $tpriceListCheapest = $tpriceList[$i]; $cheapestURL = str_replace("+++++", ";", $URLList[$i]); //echo "Cheap: $cheapestURL<br>"; } if ($ShopIDList[$i] == 1739) { $pcount++; $pricetable[$pcount] = $tpriceList[$i] . '### EUR ' . str_replace(".", ",", number_format($tpriceList[$i], 2)) . ' > <a href="' . $URLList[$i] . '" rel="nofollow">Redcoon.de</a>'; $pricetable_data[$pcount] = $tpriceList[$i] . '###' . str_replace(".", ",", number_format($tpriceList[$i], 2)) . '###' . $URLList[$i] . '###Redcoon.de' . '###' . str_replace(".", ",", number_format($ShippingList[$i], 2)); } if ($ShopIDList[$i] == 1752) { $pcount++; $pricetable[$pcount] = $tpriceList[$i] . '### EUR ' . str_replace(".", ",", number_format($tpriceList[$i], 2)) . ' > <a href="' . $URLList[$i] . '" rel="nofollow">Reichelt.de</a>'; $pricetable_data[$pcount] = $tpriceList[$i] . '###' . str_replace(".", ",", number_format($tpriceList[$i], 2)) . '###' . $URLList[$i] . '###Reichelt.de' . '###' . str_replace(".", ",", number_format($ShippingList[$i], 2)); } } } } //echo "ID: $aff_shop_id <br>Price: $aff_price + $aff_shipping"; } //$nbprice=str_replace(",",".",NB_price($post->ID)); //$nburl=NB_url($post->ID); //$region=get_region(); //$aid=get_id(); //print $aprice; //print "AURL: $aurl<br>"; //if ($aurl == "") $aurl="http://www.amazon.$region/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=$aid"; //default: Euro //print "2: ".number_format($aprice,2); //$pricestring = number_format( str_replace("EUR","",str_replace(",",".",$aprice)),2,',','.'); //pure price without currency //$pureprice = str_replace("EUR","",$aprice); //$pureprice = str_replace("CND","",$aprice); //$pureprice = str_replace("$","",$aprice); # $pricestring = $aprice; # # if ( ($region == "de") or # ($region == "es") or # ($region == "fr") or # ($region == "it") ){ # //$pricetable[0] = str_replace(",",".",$pricestring).'### EUR <span itemprop="price">'.$pricestring.'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; # //$pricetable[0] = str_replace(",",".",$pricestring).'### EUR <span itemprop="price">'.$pricestring.'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; # $pricetable_data[0] = $pricestring.'###'.$pricestring.'###'.$aurl.'###Amazon.'.$region; # } //float price to string # $aprice_str = lhg_float_to_currency_string( $aprice , $region ); # $cs = lhg_get_currency_symbol( $region ); //echo "REG: $region"; /* if ($region == "com") $pricetable[0] = ' $ <span itemprop="price">'.str_replace(".",".",number_format(str_replace("$","",$aprice),2)).'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; if ($region == "in") $pricetable[0] = ' '.str_replace("INR",'₹ <span itemprop="price">',$aprice).'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; if ($region == "ca") $pricetable[0] = ' CDN$ <span itemprop="price">'.str_replace(".",".",number_format(str_replace("CDN\$","",$aprice),2)).'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; if ($region == "co.uk") $pricetable[0] = ' '.$cs.' <span itemprop="price">'.$aprice_str.'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; if ($region == "co.jp") $pricetable[0] = ' ¥ <span itemprop="price">'.$aprice_str.'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; */ # $pricetable[0] = ' '.$cs.' <span itemprop="price">'.$aprice_str.'</span> > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; //echo "PT: $pricetable[0]"; //print "APrice: $aprice<br>"; # if ($aprice=='out of stock') # $pricetable[0] = ' '.$txt_not_avail.' > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; //print "AP: >$aprice< <br>"; # if ( (strpos($aprice,'nicht vorr') !== false) or (strpos($aprice,'nicht liefer') !== false) or ($aprice=="") ) # $pricetable[0] = ' '.$txt_not_avail.' > <a href="'.$aurl.'" rel="nofollow">Amazon.'.$region.'</a>'; # if ($lang == "de"){ # if ($nbprice != ""){ # $pcount++; # $pricetable[$pcount] = ' EUR <span itemprop="price">'.str_replace(".",",",number_format(str_replace("EUR","",$nbprice),2)).'</span> > <a href="'.$nburl.'" rel="nofollow">Notebooksbilliger.de</a>'; # } # //sort($pricetable); # array_multisort( $pricetable , SORT_NUMERIC, $pricetable_data ); # } //echo "PT0 ".$pricetable[0]; //echo "POS: ".strpos($pricetable[0],"###"); //get rid of sorting string, works only for "de" # if ( strpos($pricetable[0],"###") >0 ) # foreach ($pricetable as &$value) { # list( $null, $value) = explode("###",$value); # } //echo "PT0 ".$pricetable[0]; //echo "<br>PT1 ".$pricetable[1]; //echo "PR: $aprice"; // echo "\n".'<div itemscope itemtype="http://data-vocabulary.org/Product">'; // echo "\n".'<span itemprop="category" content="Hardware" ></span>'; // echo "\n".'<span itemprop="name" content="'.translate_title(get_the_title()).'" ></span>'; //echo "PC: $pcount"; # if ($pcount > 0) # echo "\n".'<div style="text-align: center;"><b>'.$txt_cheapest_supplier.':</b></div>'; //echo "aprice: $aprice<br>"; //echo "PC: ",$pcount; # if ($pcount == 0) # if ($aprice!='out of stock') # echo "\n".'<div style="text-align: center;"><b>'.$txt_supplier.'</b></div>'; # echo "\n".'<div class="rating" style="border: 0px solid #222; width: 70%; text-align: center; margin: 0 auto;">'; # echo $cheap_txt; /* single offer. to be changed for group of offers! */ //echo "\n".'<span itemprop="offerDetails" itemscope itemtype="http://data-vocabulary.org/Offer">'; # $price_meta = "USD"; # if ($region == "de") $price_meta = "EUR"; # if ($region == "it") $price_meta = "EUR"; # if ($region == "fr") $price_meta = "EUR"; # if ($region == "es") $price_meta = "EUR"; # if ($region == "com") $price_meta = "USD"; # if ($region == "co.uk") $price_meta = "GBP"; # if ($region == "co.jp") $price_meta = "JPY"; # if ($region == "cn") $price_meta = "CNY"; # if ($region == "ca") $price_meta = "CAD"; # if ($region == "in") $price_meta = "INR"; # # echo "\n".'<meta itemprop="currency" content="'.$price_meta.'" />'; //echo '<meta itemprop="price" content="'.str_replace(".",",",number_format(str_replace("EUR","",$nbprice),2)).'" />'; //echo "Amazon.$region"; //echo "PT: $pricetable[0]"; # if ( (strpos($pricetable[0],"Amazon.$region")) or ($pricetable[0] == "") ){ # //if ($aprice!='out of stock') # echo "\n".'<div class="amazonbutton"><a href="'.$aurl.'" rel="nofollow"><img src="/wp-uploads/2012/10/Amazon_Logo1.png" border=0 width=125 height=125 alt="'.$txt_button_string.': '.$short_title.'" title="'.$txt_button_string.': '.$short_title.'"></a></div>'; # }elseif (strpos($pricetable[0],"Notebooksbilliger.de")){ # echo "\n".'<div class="amazonbutton"><a href="'.$nburl.'" rel="nofollow"><img src="wp-uploads/2012/10/Logo_125-x-125_5_H.gif" border=0></a></div>'; # }elseif (strpos($pricetable[0],"Redcoon.de")){ # echo "\n".'<div class="amazonbutton" style="border: 1px solid #2B8FC3; width: 140px; margin: 0 auto;"><a href="'.$cheapestURL.'" rel="nofollow"><img src="/wp-uploads/2014/03/redcoon-logo-125x125.jpg" border=0 width=140 height=140></a></div>'; # }elseif (strpos($pricetable[0],"Reichelt.de")){ # echo "\n".'<div class="amazonbutton" style="border: 1px solid #2B8FC3; width: 140px; margin: 0 auto;"><a href="'.$cheapestURL.'" rel="nofollow"><img src="/wp-uploads/2014/03/reichelt_logo_125x125.gif" border=0 width=140 height=140></a></div>'; # } # # $pricetable[0] = str_replace("+++++",";",$pricetable[0]); # echo str_replace(" > ", "<br>",$pricetable[0]); # echo "\n"."</div>"; # if ($pcount == 0){ # //echo "<b>Preis:</b>"; # }else{ # //echo "<b>Amazon-Preis:</b><br>"; # //echo ' '.$aprice.' > <a href="'.$aurl.'">Amazon.de</a>'; # echo $vspacer; # echo "<b>Übersicht der Anbieter:</b>"; # # } //echo "<br>PT1 ".$pricetable[1]; # if ($pcount == 0){ # //echo $line; # }else{ # echo "<br> # <table>"; # //<tr><td><b>Preis</b></td><td><b>Anbieter</b></td><td></td></tr> # //"; # $i=0; # foreach($pricetable as $line){ # list ($price1, $price2, $url , $shop, $shipping) = explode("###",$pricetable_data[$i]); # # //echo "$price2 .. $url .. $shop"; # # if (strpos($pricetable[$i],"Redcoon.de")){ # echo '<tr><td>EUR '.$price2.'<br><div class="portoline">inkl. Porto: '.$shipping.' EUR</div></td><td valign="middle"><a href="'.$url.'" rel="nofollow"><img src="wp-uploads/2014/03/redcoon-logo-110x033.jpg" style="border: 1px solid #2B8FC3;"></a></td><td><a href="'.$url.'" rel="nofollow">Redcoon.de</a></td></tr>'; # # }elseif (strpos($pricetable[$i],"Amazon.de")){ # echo '<tr><td>EUR '.$price2.'<br><div class="portoline">exkl. Porto</div></td><td valign="middle"><a href="'.$url.'" rel="nofollow"><img src="wp-uploads/2014/03/amazon_de_logo_110_33.jpg" style="border: 1px solid #2B8FC3;"></a></td><td><a href="'.$url.'" rel="nofollow">Amazon.de</a></td></tr>'; # //echo '<img src="wp-uploads/2014/03/amazon_de_logo_110_33.jpg">'.$pricetable[$i]."<br>"; # }elseif (strpos($pricetable[$i],"Reichelt.de")){ # $url = str_replace("+++++",";",$url); # echo '<tr><td>EUR '.$price2.'<br><div class="portoline">inkl. Porto: '.$shipping.' EUR</div></td><td valign="middle"><a href="'.$cheapestURL.'" rel="nofollow"><img src="wp-uploads/2014/03/reichelt_logo_110x33.jpeg" style="border: 1px solid #2B8FC3;"></a></td><td><a href="'.$url.'" rel="nofollow">Reichelt.de</a></td></tr>'; # //echo '<img src="wp-uploads/2014/03/amazon_de_logo_110_33.jpg">'.$pricetable[$i]."<br>"; # } # else{ # echo $pricetable[$i]."<br>"; # } # # //if ($i == 0) echo '<div class="priceline" style="border: 0px solid #000; "><div class="pricetop" style="border: 1px solid #2b8fc3; background-color: #eee; margin: 3px 3px;">'.$line.'</div></div>'; # //if ($i > 0) echo '<div class="priceline" style="border: 0px solid #000; "><div class="price" style="border: 0px solid #333; background-color: #fff; margin: 3px 3px;">'.$line.'</div></div>'; # $i++; # } # echo"</table>"; # } // echo get_affiliate_prices($post->ID); // // ---- New Supplier Overview // #if ($lang == "de") lhg_supplier_comparison($post->ID); // // ---- Rating Overview ============================================================== // global $txt_opw_num_ratings; // = "Number of ratings"; global $txt_opw_average_rating; // = "Average ratings"; global $txt_opw_rating_overview; global $txt_out_of; global $txt_opw_hardware; global $txt_average; global $no_supplier_square; #$rating_avg = get_post_meta($post->ID,'ratings_average',true); $num_rates = $ratings[0]->post_ratings_users_com + $ratings[0]->post_ratings_users_de; if ($num_rates == 0) { $rating_avg = 0; } if ($num_rates != 0) { $rating_avg = ($ratings[0]->post_ratings_score_com + $ratings[0]->post_ratings_score_de) / $num_rates; } if ($no_supplier_square != 1) { echo $vspacer; } #echo '<div itemscope itemtype="http://schema.org/Product">'; #echo '<div itemscope itemtype="http://data-vocabulary.org/Review-aggregate">'; #echo '<div property="itemReviewed" typeof="Product">'; #echo ' <div itemprop="rating" itemscope itemtype="http://data-vocabulary.org/Rating">'; //echo '<div class="rating" style="border: 0px solid #222; width: 90%; margin: 0 auto;">'; echo ' <table class="ratingtable" border="0"> <tr> <td><b>' . $txt_opw_hardware . ':</b></td> <td><span itemprop="name">' . $short_title . '</span></td> </tr> <tr> <td> '; //if ($rating_total>1) echo "<b>$txt_wpone_num_ratings:</b></td><td> <b>".'<span itemprop="votes">'."$rating_total</span></b><br>"; //if ($rating_total<2) echo " <b>{$txt_opw_num_ratings}:</b>\n </td>\n\n\n\n <td>\n {$rating_total} <br />\n </td>\n </tr>\n\n\n <tr>\n <td><b>{$txt_opw_average_rating}: </b></td>\n\n <td>"; echo '<span itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">'; echo the_ratings_results($post->ID, 0, 0, 0, 10) . ' (<span itemprop="ratingValue">' . round($rating_avg, 1) . '</span> ' . $txt_out_of . ' <span itemprop="bestRating">5</span>) <span itemprop="ratingCount" content="' . $rating_total . '" /> <span itemprop="worstRating" content="0" /> </span> </td> </tr> '; echo ' <tr> <td class="td-ratingoverview">' . "<b>{$txt_opw_rating_overview}:</b></td>\n\n <td>"; if ($rating_total == 0) { $ra5 = 0; $ra4 = 0; $ra3 = 0; $ra2 = 0; $ra1 = 0; } else { $ra5 = 100 * $rating5 / $rating_total; $ra4 = 100 * $rating4 / $rating_total; $ra3 = 100 * $rating3 / $rating_total; $ra2 = 100 * $rating2 / $rating_total; $ra1 = 100 * $rating1 / $rating_total; } echo ' <div class="rateline" style="border: 0px solid #000;"> <div style="float: left;">5: </div> <div class="outerbox" style="background-color: #eee; width: 80px; float: left; margin: 4px 0px;"> <div class="box" style="border: 0px solid #088; background-color: #2b8fc3; height: 8px; width: ' . $ra5 . '%;" ></div> </div> (' . $rating5 . ') </div><br clear="all" />'; echo ' <div class="rateline" style="border: 0px solid #000; margin-top: -17px; "> <div style="float: left;">4: </div> <div class="outerbox" style="background-color: #eee; width: 80px; float: left; margin: 4px 0px;"> <div class="box" style="border: 0px solid #088; background-color: #2b8fc3; height: 8px; width: ' . $ra4 . '%;" ></div> </div> (' . $rating4 . ') </div><br clear="all" />'; echo ' <div class="rateline" style="border: 0px solid #000; margin-top: -17px; "> <div style="float: left;">3: </div> <div class="outerbox" style="background-color: #eee; width: 80px; float: left; margin: 4px 0px;"> <div class="box" style="border: 0px solid #088; background-color: #2b8fc3; height: 8px; width: ' . $ra3 . '%;" ></div> </div> (' . $rating3 . ') </div><br clear="all" />'; echo ' <div class="rateline" style="border: 0px solid #000; margin-top: -17px; "> <div style="float: left;">2: </div> <div class="outerbox" style="background-color: #eee; width: 80px; float: left; margin: 4px 0px;"> <div class="box" style="border: 0px solid #088; background-color: #2b8fc3; height: 8px; width: ' . $ra2 . '%;" ></div> </div> (' . $rating2 . ') </div><br clear="all" />'; echo ' <div class="rateline" style="border: 0px solid #000; margin-top: -17px; "> <div style="float: left;">1: </div> <div class="outerbox" style="background-color: #eee; width: 80px; float: left; margin: 4px 0px;"> <div class="box" style="border: 0px solid #2b8fc3; background-color: #2b8fc3; height: 8px; width: ' . $ra1 . '%;" ></div> </div> (' . $rating1 . ') </div>'; # echo ' # </div>'; echo ' <a href="#comments">' . $txt_rate_yourself . '</a>'; //echo "</td></tr><tr><td></td><td>"; echo "\n </td>\n </tr>\n\n </table>\n\n "; #echo '</div>'; // itemreviewed # echo " </div>"; //Rating #echo '</div>'; //Review-aggregate //echo $vspacer; // // -------- Subscriber ============================================================= // //if ($lang == "de"){ echo $vspacer; print "<b>" . '<i class="icon-user icon-add-hw-user"></i><i class="icon-plus icon-add-hw-plus"></i>' . "{$txt_wpop_register}</b><br />"; print "{$txt_register_long}"; if (is_user_logged_in()) { $current_user = wp_get_current_user(); print '<form action="/hardware-profile?srp=' . $post->ID . '&sra=s" method="post" onsubmit="if(this.sre.value==\'\' || this.sre.indexOf(\'@\')==0) return false"> <fieldset style="border:0"> <input type="hidden" class="subscribe-form-field" name="sre" value="' . $current_user->user_email . '" size="18"> <button type="submit" value="' . $txt_send . '" >' . $txt_send . ' <i class="icon-arrow-right icon-button"></i></button> </fieldset> </form>'; } else { print '<form action="/hardware-profile?srp=' . $post->ID . '&sra=s" method="post" onsubmit="if(this.sre.value==\'\' || this.sre.indexOf(\'@\')==0) return false"> <fieldset style="border:0"> <input type="text" class="subscribe-form-field" name="sre" value="email" size="18" onfocus="if(this.value==this.defaultValue)this.value=\'\'" onblur="if(this.value==\'\')this.value=this.defaultValue"/> <button type="submit" value="' . $txt_send . '" >' . $txt_send . ' <i class="icon-arrow-right icon-button"></i></button> </fieldset> </form>'; } $usernum = 0; //get number of registered users global $txt_opw_registered; global $wpdb; global $txt_not_avail; $usernum = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->postmeta} WHERE meta_key LIKE '\\_stcr@\\_%' AND post_id = " . $post->ID); if ($usernum > 0) { print "(" . $txt_opw_registered . ": " . $usernum . ")"; } //print do_shortcode('<a href="/manage-subscriptions">'.$txt_manage_subscr."</a>"); //} // // ----------- Language Selector ============================================ // #$selected ='<div class="pricetop" style="border: 1px solid #2b8fc3; background-color: #eee; margin: 3px 3px 3px 3px; padding-top: 3px;">'; #$selectedEnd ='</div>'; # Debug: #lhg_store_comment_numbers_by_post_id( $post_id ); echo $vspacer; echo "<b>{$txt_select}:</b><br />"; //echo "PL:".get_permalink(); //echo "<br>QPL:".qtrans_convertURL(get_permalink()); list($null1, $null2, $null3, $posturl) = explode("/", get_permalink()); list($null1, $null2, $null3, $null4, $posturl2) = explode("/", get_permalink()); //echo "pu:".$posturl ."<br>"; //echo "pu2".$posturl2."<br>"; if ($posturl2 != "") { $posturl = $posturl2; } //we are in a qtranslate subfolder! $posturlde = $posturl; $posturlcom = $posturl; if (!is_search() and !($postID == "1821") and !is_archive()) { $comURL = get_post_meta($post->ID, 'COM_URL', true); $deURL = get_post_meta($post->ID, 'DE_URL', true); if ($comURL != "") { $posturlcom = $comURL; } if ($deURL != "") { $posturlde = $deURL; } if (substr($comURL, 0, 1) == "/") { $comURL = substr($comURL, 1); } if (substr($deURL, 0, 1) == "/") { $deURL = substr($deURL, 1); } //echo "LANG: $lang, PID: $postID, "; //translation still missing -> redirect to main page if ($comURL == "" and $post->ID > 2599 and $lang == "de") { $posturlcom = ""; } if ($deURL == "" and $post->ID > 2599 and $lang == "en") { $posturlde = ""; } # on de server get com link from priceDB if ($lang == "de") { $com = lhg_get_com_post_URL($postID); $comURL == $com; } } //remove language selection for .de $posturlde = str_replace("?lang=jp", "", $posturlde); $posturlde = str_replace("?lang=it", "", $posturlde); $posturlde = str_replace("?lang=es", "", $posturlde); $posturlde = str_replace("?lang=uk", "", $posturlde); $posturlde = str_replace("?lang=ca", "", $posturlde); $posturlde = str_replace("?lang=in", "", $posturlde); $posturlde = str_replace("?lang=fr", "", $posturlde); $posturlde = str_replace("?lang=cn", "", $posturlde); $posturlde = str_replace("?lang=en", "", $posturlde); $posturlcom = str_replace("?lang=jp", "", $posturlcom); $posturlcom = str_replace("?lang=it", "", $posturlcom); $posturlcom = str_replace("?lang=es", "", $posturlcom); $posturlcom = str_replace("?lang=uk", "", $posturlcom); $posturlcom = str_replace("?lang=ca", "", $posturlcom); $posturlcom = str_replace("?lang=in", "", $posturlcom); $posturlcom = str_replace("?lang=fr", "", $posturlcom); $posturlcom = str_replace("?lang=cn", "", $posturlcom); $posturlcom = str_replace("?lang=en", "", $posturlcom); if ($lang == "de") { $URLC = "http://www.linux-hardware-guide.com"; $URLD = ""; } if ($lang != "de") { $URLC = ""; $URLD = "http://www.linux-hardware-guide.de"; } //$URLC="http://192.168.3.113"; //Debug if (1 == 1) { echo '<div class="countrytable"><table border="0"> <tr class="countrytable_header"> <td class="cth_country">Country</td> <td class="cth_price">Price</td> <td class="cth_currency"></td> <td class="cth_comment">Comments</td> </tr>'; print lhg_country_row("de", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("com", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("ca", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("co.uk", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("fr", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("es", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("it", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("nl", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("in", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("co.jp", $URLC, $URLD, $posturlcom, $posturlde); print lhg_country_row("cn", $URLC, $URLD, $posturlcom, $posturlde); echo "</table></div>"; } else { //if ($region == "de") print $selected; //echo ' <a href="'.$URLD.'/'.$posturlde.'"><img src="/wp-content/plugins/qtranslate/flags/de.png" alt="Germany" /> Germany (€)</a><br />'; //if ($region == "de") print $selectedEnd; if ($region == "de") { print $selected; } echo ' <a href="' . $URLC . '/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/us.png" alt="USA" /> USA (€)</a><br />'; if ($region == "de") { print $selectedEnd; } if ($region == "ca") { print $selected; } echo ' <a href="' . $URLC . '/ca/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/ca.png" alt="Canada" /> Canada (CDN $)</a><br />'; if ($region == "ca") { print $selectedEnd; } if ($region == "co.uk") { print $selected; } echo ' <a href="' . $URLC . '/uk/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/uk.png" alt="UK" /> United Kingdom (£)</a><br />'; if ($region == "co.uk") { print $selectedEnd; } if ($region == "fr") { print $selected; } echo ' <a href="' . $URLC . '/fr/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/fr.png" alt="France" /> France (€)</a><br />'; if ($region == "fr") { print $selectedEnd; } if ($region == "es") { print $selected; } echo ' <a href="' . $URLC . '/es/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/es.png" alt="Espana" /> Espana (€)</a><br />'; if ($region == "es") { print $selectedEnd; } if ($region == "it") { print $selected; } echo ' <a href="' . $URLC . '/it/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/it.png" alt="Italia" /> Italia (€)</a><br />'; if ($region == "it") { print $selectedEnd; } if ($region == "nl") { print $selected; } echo ' <a href="' . $URLC . '/nl/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/nl.png" alt="Netherlands" /> Netherlands (€)</a><br />'; if ($region == "nl") { print $selectedEnd; } if ($region == "in") { print $selected; } echo ' <a href="' . $URLC . '/in/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/in.png" alt="India" /> India (₹)</a><br />'; if ($region == "in") { print $selectedEnd; } if ($region == "co.jp") { print $selected; } echo ' <a href="' . $URLC . '/ja/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/jp.png" alt="Japan" /> Japan (¥)</a><br />'; if ($region == "co.jp") { print $selectedEnd; } if ($region == "cn") { print $selected; } echo ' <a href="' . $URLC . '/zh/' . $posturlcom . '"><img src="/wp-content/plugins/qtranslate/flags/cn.png" alt="China" /> China (RMB)</a><br />'; if ($region == "cn") { print $selectedEnd; } } // // Tag List Start // echo $vspacer; echo "\n\n" . " <b>{$txt_sim_tags}:</b>\n <br />"; echo "\n" . ' <div style="margin-left: 18px;">'; echo "\n\n" . ' <form method="get" action="/tagsearch/" class="combine_tags">' . "\n"; foreach (get_the_category() as $category) { $counter++; $CID = $category->cat_ID; break; //stop at main category! } $args = array('category' => $CID); $catposts = get_posts($args); foreach ($catposts as $post) { setup_postdata($post); $posttags = get_the_tags(get_the_ID()); if (is_array($posttags)) { foreach ($posttags as $tag) { if ($tag->count > 1) { // combination not useful in case of one result if ($tag->term_id != 981) { $count++; $tagstrings[$count] = $tag->term_id . '; <a href="' . get_tag_link($tag->term_id) . '">' . $tag->name . '</a> (' . $tag->count . ')<br /> '; if ($count > 15) { break; } } } } } } if (is_array($tagstrings)) { $unique_tagstrings = array_unique($tagstrings); } if (is_array($unique_tagstrings)) { sort($unique_tagstrings); } $countU = 0; if (is_array($unique_tagstrings)) { foreach ($unique_tagstrings as $tagstring) { $part = explode(";", $tagstring); $out .= "\n" . ' <input type="checkbox" name="tagid[' . $countU . ']" value="' . $part[0] . '" />' . $part[1]; $countU++; } } echo $out; // // Tag List End // echo $content_widget; echo "\n" . ' <div class="tagbutton"> <button type="submit" value="' . $txt_combine_tags . '" >' . $txt_combine_tags . ' <i class="icon-arrow-right icon-button"></i> </button> </div> </form>'; echo "\n" . "\n </div>\n "; echo "\n" . "</div>"; echo $after_widget; //close the blue widget } }
function getSingleAmazonProduct($asin = '', $extratext = '', $extrabutton = 0) { global $public_key, $private_key, $aws_partner_id, $aws_partner_locale, $amazonhiddenmsg, $amazonerrormsg, $apippopennewwindow, $apippnewwindowhtml; global $appip_text_lgimage; global $appip_text_listprice; global $appip_text_newfrom; global $appip_text_usedfrom; global $appip_text_instock; global $appip_text_outofstock; global $appip_text_author; global $appip_text_starring; global $appip_text_director; global $appip_text_reldate; global $appip_text_preorder; global $appip_text_releasedon; global $appip_text_notavalarea; global $buyamzonbutton; global $addestrabuybutton; global $encodemode; global $post; global $amazonRun; //text strings global $lang; global $txt_compat; global $txt_Compat; global $txt_with; global $txt_rating; global $txt_ratings; global $txt_price; global $txt_out_of_stock; global $txt_button; global $txt_button_width; global $siteurl; global $txt_pricetrend; global $txt_A_preis; global $txt_currency; global $txt_shipping; global $txt_on_stock; global $txt_updated; global $txt_buy_from; global $txt_search_at; global $txt_preorder; global $txt_not_avail_at; global $txt_never_avail; $region = get_region(); $aws_partner_id = get_id(); $aws_partner_locale = $region; //print "PL: $aws_partner_locale"; //$apippOpenNewWindow = get_post_meta($post->ID,'amazon-product-newwindow',true); //if($apippOpenNewWindow!='3'){$apippnewwindowhtml=' target="amazonwin" ';} #print "A0: $asin<br>"; $asinlist = get_post_meta($post->ID, 'amazon-product-asin-list', true); #print "CSV: ".str_getcsv($asin.",".$asinlist, ","); $data = str_getcsv($asin . "," . $asinlist, ","); #var_dump($data); # # check if DB entries for asins already exist -> create if necessary # $i = 0; while ($i < count($data)) { $asin_tmp = $data[$i]; #print " A: $asin"; if ($asin_tmp != "") { lhg_amazon_create_db_entry($region, $post->ID, $asin_tmp); } $i++; } //print "<br>Data0: $data[0] <br>"; //print "Data1: $data[1] <br>"; #print "Af: $asin<br>"; if ($asin != '') { #print "count: ".count($data); #$i=0; #while ( $i< count($data) ){ # one loop is enough. SQL request looks at all ASINs //print "I: $i <br>"; global $amazonRun; $amazonRun = 0; // reset loop counter for new asin list element $asin = $data[$i]; // $asin; //valid ASIN $ASIN = $asin; //valid ASIN //print "ASIN: $asin"; $errors = ''; #$appip_responsegroup = "ItemAttributes,Images,Offers,Reviews"; #$appip_operation = "ItemLookup"; #$appip_idtype = "ASIN"; #if ($region != "nl") #$pxml = aws_signed_request($aws_partner_locale, array("Operation"=>$appip_operation,"ItemId"=>$ASIN,"ResponseGroup" => $appip_responsegroup,"IdType"=>$appip_idtype,"AssociateTag"=>$aws_partner_id ), $public_key, $private_key); //print "<br>PXML: ";var_dump($pxml); #if(!is_array($pxml)){ # $pxml2=$pxml; # $pxml = array(); # $pxml["itemlookuperrorresponse"]["error"]["code"]["message"] = $pxml2; #} #if(isset($pxml["itemlookuperrorresponse"]["error"]["code"])){ # $errors = $pxml["itemlookuperrorresponse"]["error"]["code"]["message"]; #} //print "<br>Article found, checking"; //Call 1 $amazonRun += 1; //count loops to prevent multiple requests (will be reset for ASIN lists) //echo "<hr>Call 1<br>RUN: $amazonRun<br>"; //if ($run == 2) break; #$result = FormatASINResult($pxml,$post->ID); $newPrice = lhg_db_get_lowest_amazon_price($post->ID, $region); #print "<br>New Price: $newPrice - $asin, $region"; #if ($newPrice != "" and $newPrice != 0) break; #$i++; #} if ($lang != "de") { if ($newPrice == 0) { $newPrice = "out of stock"; } } if ($lang == "de") { if ($newPrice == 0) { $newPrice = "nicht lieferbar"; } } if ($errors == 'exceeded') { # $hiddenerrors = "<"."!-- HIDDEN AMAZON PRODUCT IN A POST ERROR: Requests Exceeded -->"; # $errors = 'Requests Exceeded'; # if($extratext!=''){return $hiddenerrors.$extratext;} # return $hiddenerrors; #}elseif($errors=='no signature match'){ # //echo "HERE A!"; # $hiddenerrors = "<"."!-- HIDDEN AMAZON PRODUCT IN A POST ERROR: Signature does not match AWS Signature. Check AWS Keys and Signature method. -->"; # $errors = 'Signature does not match'; # if($extratext!=''){return $hiddenerrors.$extratext;} # return $hiddenerrors; //}elseif($errors=='not valid'){ // //echo "HERE B!"; // $hiddenerrors = "<"."!-- HIDDEN AMAZON PRODUCT IN A POST ERROR: Item Not Valid. Possibly not available in your locale or you did not enter a correct ASIN. -->"; // $errors = 'Not a valid item'; // if($extratext!=''){return $hiddenerrors.$extratext;} // return $hiddenerrors; //}elseif($errors!=''){ // $hiddenerrors = "<"."!-- HIDDEN AMAZON PRODUCT IN A POST ERROR: ". $errors ."-->"; // if($extratext!=''){return $hiddenerrors.$extratext;} // return $hiddenerrors; } else { //global $run; //$run += 1; //Call 2 //echo "<hr>Call 2<br>"; //$result = FormatASINResult($pxml,$post->ID); //print_r ($result); //echo "<br>WHAT: ".$result['URL']; //$returnval = ' <br /><div class="amazon-box">'; //$returnval = ' '; //$returnval .= ' <div class="amazon-box">'; //<table cellpadding="0"class="amazon-product-table">'."\n"; //$returnval .= ' <tr>'."\n"; //$returnval .= ' <td valign="top">'."\n"; $returnval .= ' <div class="amazon-image-wrapper">' . "\n"; //$returnval .= ' <a href="' . $result["URL"] . '" '. $apippnewwindowhtml .'>' . awsImageGrabber($result['MediumImage'],'amazon-image') . '</a><br />'."\n"; global $txt_cpl_noimage; // = "Kein Bild verfügbar"; # # ToDo: URL should be stored in DB and not fetched each time # #$amazon_image = awsImageGrabber($result['MediumImage'],'amazon-image'); $attr = array('alt' => trim(strip_tags(translate_title(get_the_title($PID)))), 'title' => trim(strip_tags(translate_title(get_the_title($PID))))); $amazon_image = get_the_post_thumbnail($artid, array(130, 130), $attr); if (strpos($amazon_image, 'src=""')) { $amazon_image = '<img src="/wp-uploads/2013/03/noimage130.jpg" alt="' . $txt_cpl_noimage . '" title="' . $txt_cpl_noimage . '">'; } if ($amazon_image == "") { $amazon_image = '<img src="/wp-uploads/2013/03/noimage130.jpg" alt="' . $txt_cpl_noimage . '" title="' . $txt_cpl_noimage . '">'; } $returnval .= ' ' . $amazon_image . '' . "\n"; //$returnval .= ' '. awsImageGrabber($result['MediumImage'],'amazon-image') . ''."\n"; //if($result['LargeImage']!=''){ //$returnval .= ' <a target="amazon-image" href="javascript: void(0)" onclick="artwindow=window.open(\'' .$result['LargeImage'] .'\',\'art\',\'directories=no, location=no, menubar=no, resizable=no, scrollbars=no, status=no, toolbar=no, width=400,height=525\');artwindow.focus();return false;"><span class="amazon-tiny">'.$appip_text_lgimage.'</span></a>'."\n"; //$returnval .= ' <a rel="appiplightbox" href="'.$result['LargeImage'] .'"><span class="amazon-tiny">'.$appip_text_lgimage.'</span></a>'."\n"; //$returnval .= ' <span class="amazon-tiny">'.$appip_text_lgimage.'</span>'."\n"; //} $returnval .= ' </div>' . "\n"; $returnval .= ' <div class="amazon-buying">' . "\n"; //$returnval .= ' <h2 class="amazon-asin-title"><a href="' . $result["URL"] . '" '. $apippnewwindowhtml .'><span class="asin-title">'.$result["Title"].'</span></a></h2>'."\n"; //$returnval .= ' <h2 class="amazon-asin-title"><a href="' . $result["URL"] . '" '. $apippnewwindowhtml .'><span class="asin-title">'.$result["Title"].'</span></a></h2>'."\n"; #if(isset($result["Author"])){ #$returnval .= ' <span class="amazon-author">'.$appip_text_author.' '.$result["Author"].'</span><br />'."\n"; #} #if(isset($result["Director"])){ #$returnval .= ' <span class="amazon-director-label">'.$appip_text_director.': </span><span class="amazon-director">'.$result["Director"].'</span><br />'."\n"; #} #if(isset($result["Actors"])){ #$returnval .= ' <span class="amazon-starring-label">'.$appip_text_starring.': </span><span class="amazon-starring">'.$result["Actors"].'</span><br />'."\n"; #} //if(isset($result["Rating"])){ //$returnval .= ' <span class="amazon-rating-label">Rating: </span><span class="amazon-rating">'.$result["Rating"].'</span><br />'."\n"; //} ob_start(); if (function_exists('the_ratings')) { $returnval .= the_ratings(); } $out1 = ob_get_contents(); ob_end_clean(); //get the correct! rating $post_id = $post->ID; global $wpdb; global $lhg_price_db; if ($lang != "de") { $ratings = $lhg_price_db->get_results("SELECT * FROM `lhgtransverse_posts` WHERE postid_com = {$post_id}"); } if ($lang == "de") { $ratings = $lhg_price_db->get_results("SELECT * FROM `lhgtransverse_posts` WHERE postid_de = {$post_id}"); } #$get_rates = $wpdb->get_results("SELECT rating_rating FROM $wpdb->ratings WHERE rating_postid = $post_id"); $rating_total = 0; $rating_total = $ratings[0]->post_ratings_users_com + $ratings[0]->post_ratings_users_de; $rating = $ratings[0]->post_ratings_score_com + $ratings[0]->post_ratings_score_de; #foreach($get_rates as $get_rate){ # $rating += $get_rate->rating_rating; # //print_r($get_rate); # $rating_total++; #} //$returnval .= '<div class="hreview-aggregate">'; //$returnval .= '<span class="item">'; //$returnval .= '<span class="fn"><span class="value-title" title="'.get_the_title().'"/></span>'; //$returnval .= '<span class="photo"><span class="value-title" title="'.wp_get_attachment_url( get_post_thumbnail_id($post->ID) ).'"/></span>'; //$returnval .= '</span>'; //$returnval .= '<span class="rating"><span class="value-title" title="'.($rating/$rating_total).'"/></span>'; //$returnval .= '<span class="reviewer"><span class="value-title" title="linux-hardware-guide.de"/></span>'; //$returnval .= '<span class="dtreviewed"><span class="value-title" title="'.get_the_date().'"/></span>'; //$returnval .= '<span class="votes"><span class="value-title" title="'.$rating_total.'"/></span>'; //$returnval .= '<span class="count"><span class="value-title" title="'.get_comments_number().'"/></span>'; //$tooltip= 'Bewertet wird an dieser Stelle einzig die Linux-Kompatibilität und nicht die Qualität des Produktes.<div style="height: 3px;"></div>Sollten Sie dieses Produkt besitzen, dann helfen Sie bitte auch anderen Linux-Benutzern, indem Sie dessen // <a href="#comment-box">Linux-Kompatibilität bewerten</a>.'; //set tooltip depending on logged in or not (due to google rating) global $txt_tooltip; global $txt_amz_tooltip_loggedin; global $txt_amz_tooltip_not_loggedin; if (is_user_logged_in()) { $txt_tooltip = $txt_amz_tooltip_loggedin; } if (!is_user_logged_in()) { $txt_tooltip = $txt_amz_tooltip_not_loggedin; } $tooltip = $txt_tooltip; //'Bewertet wird an dieser Stelle einzig die Linux-Kompatibilität und nicht die Qualität des Produktes. Sollten Sie dieses Produkt besitzen, dann helfen Sie bitte auch anderen Linux-Benutzern, indem Sie dessen Linux-Kompatibilität im Kommentar-Bereich dieser Seite bewerten.'; $returnval .= "\n\t<b>{$txt_compat}:</b>"; $returnval .= ' <span class="tooltip"> ' . tooltip($tooltip, -118, 380, -178) . ' </span>'; $returnval .= ' <br /> <div style="border: 0px solid #eee;"> <div style="border: 0px solid #eee; width:80px; float: left;"> ' . the_ratings_results($post->ID, 0, 0, 0, 10) . ' </div> '; //Rich Snippet start //$returnval .= '<div itemscope itemtype="http://data-vocabulary.org/Review">'; if ($rating_total == 1) { $returnval .= ' <div style="border: 0px solid #eee; white-space: nowrap;"> (<span class="rating"> <span class="value-title" title="' . round($rating / $rating_total, 1) . '"> ' . round($rating / $rating_total, 1) . ' </span> </span> ' . $txt_with . ' <span class="votes"> <span class="value-title" title="' . $rating_total . '"> ' . $rating_total . ' </span> </span> ' . $txt_rating . ') </div> </div>' . "\n"; } if ($rating_total == 0) { $rate_average_value = 0; } else { $rate_average_value = round($rating / $rating_total, 1); } if ($rating_total != 1) { $returnval .= ' <div style="border: 0px solid #eee; white-space: nowrap;"> (<span class="rating"> <span class="value-title" title="' . $rate_average_value . '"> ' . $rate_average_value . ' </span> </span> ' . $txt_with . ' <span class="votes"> <span class="value-title" title="' . $rating_total . '"> ' . $rating_total . ' </span> </span> ' . $txt_ratings . ') </div> </div>' . "\n"; } //Rich Snippet end //$returnval .= '</div>'; $returnval .= ' <br /> '; //also store cheapest price - not used. Use central price DB instead #$cheapest_price = lhg_db_get_cheapest_price($post->ID); #print "<br>Cheapest: $cheapest_price"; #$meta="cheapest_price_".$region; #update_post_meta($post->ID,$meta,$cheapest_price); # $returnval .= '<div class="amaz-grey-box" style="border: 0px solid #eee; background-color: #eee;">'; //if ($rating_total != 1) $returnval .= ' ('.$rating_total.' Bewertungen)</div></div><br>'."\n"; //$returnval .= ' <hr noshade="noshade" size="1" />'."\n"; //$returnval .= ' <div align="left">'."\n"; //$returnval .= ' <table class="amazon-product-price" cellpadding="0">'."\n"; //if($extratext!=''){ //$returnval .= ' <tr>'."\n"; //$returnval .= ' <td class="amazon-post-text" colspan="2">'.$extratext.'</td>'."\n"; //$returnval .= ' </tr>'."\n"; //} //If($result["PriceHidden"]==1 ){ // $returnval .= ' <tr>'."\n"; // $returnval .= ' <td class="amazon-list-price-label">'.$appip_text_listprice.':</td>'."\n"; // $returnval .= ' <td class="amazon-list-price-label">'.$amazonhiddenmsg.'</td>'."\n"; // $returnval .= ' </tr>'."\n"; //}elseif($result["ListPrice"]!='0'){ // $returnval .= ' <tr>'."\n"; // $returnval .= ' <td class="amazon-list-price-label">Preis: '.$appip_text_listprice.':</td>'."\n"; //$returnval .= ' Preis: '.$appip_text_listprice.':'."\n"; //$returnval .= ' '. mb_convert_encoding($result["ListPrice"], $encodemode, mb_detect_encoding( $result["ListPrice"], "auto" )) .' '."\n"; // $returnval .= ' <td class="amazon-list-price">'. mb_convert_encoding($result["ListPrice"], $encodemode, mb_detect_encoding( $result["ListPrice"], "auto" )) .'</td>'."\n"; // $returnval .= ' </tr>'."\n"; //} if (isset($newPrice)) { #print "AAH!"; #$result["LowestNewPrice"])){ #if($result["LowestNewPrice"]=='Too low to display'){ # $newPrice = 'Check Amazon For Pricing'; #}else{ # #$newPrice = $result["LowestNewPrice"]; #} //$returnval .= ' <tr>'."\n"; //$returnval .= ' <td class="amazon-new-label">'.$appip_text_newfrom.':</td>'."\n"; # $returnval .= ' '.$txt_price.':'."\n"; #if ($result["TotalNew"] == '') $returnval.="Warn \n"; #if($result["TotalNew"]>0){ //$ship=scrape($asin); //print_r($ship); //$returnval .= "Total: ".$SalePrice['FormattedPrice']."-".$result["ListPrice"]."+".$ship[1]."<br>"; #not needed any longer. Stored in DB //$newPrice $myFile = "/home/wordpressftp/amazon-{$region}.txt"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $post->ID . ";" . $newPrice . "\n"; fwrite($fh, $stringData); fwrite($fh, $stringData); fclose($fh); # store price - currently disabled # //$newPrice with date $myFile = "/home/wordpressftp/amazon_date-{$region}.txt"; $timeInf = time(); $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $post->ID . ";" . $newPrice . ";" . $timeInf . ";" . $result["URL"] . "\n"; fwrite($fh, $stringData); fclose($fh); #lhg_amazon_price_to_db($region, $post->ID, $asin, $newPrice, $result["URL"], $timeInf); //remove Amazon string Symbol $newPrice = lhg_remove_amazon_currency_symbol($newPrice, $region); //add currency symbol # $returnval .= lhg_get_currency_symbol ( $region ); /* if ($region == "co.uk") $returnval .= "£"; if ($region == "co.jp") $returnval .= "¥"; if ($region == "cn") { $returnval .= "¥"; $newPrice = substr($newPrice,2); } if ($region == "co.jp") $newPrice = substr($newPrice,2); */ # $returnval .= ' '. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span itemprop="availability" content="in_stock" class="instock"> ('.$txt_on_stock.') </span>'."\n"; # $returnval .= '<br><div class="shipping"><font size="1">('.$txt_shipping.')'; global $txt_tooltip2; $tooltip = $txt_tooltip2; //"Die von Amazon zur Verfügung gestellten Preise sind exklusive möglicherweise zusätzlich anfallender Versandkosten (abhängig vom jeweiligen Anbieter des Amazon-Marketplace)."; # $returnval .= '<span class="tooltip">'.tooltip($tooltip).'<span>'; # $returnval .= '</font></div>'; # # }else{ #// $returnval .= ' '. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="outofstock">'.$appip_text_outofstock.'</span>'."\n"; # $returnval .= 'BB unbekannt '; //. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="outofstock">'.$appip_text_outofstock.'</span>'."\n"; #} //if($result["TotalNew"]>0){ // $returnval .= ' <td class="amazon-new">'. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="instock">'.$appip_text_instock.'</span></td>'."\n"; //}else{ // $returnval .= ' <td class="amazon-new">'. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="outofstock">'.$appip_text_outofstock.'</span></td>'."\n"; //} //$returnval .= ' </tr>'."\n"; // $returnval .= ' </div>'."\n"; //store in DB $meta = "price-amazon." . $region; update_post_meta($post->ID, $meta, $newPrice); //$meta="url-amazon.".$region; //update_post_meta($post->ID,$meta,$result["URL"]); } elseif ($region != "pl") { #Price tag $aid = get_id(); //if( ($errors!='') && ($region == "en")){ // $returnval .='Not available at <a target="_blank" href="http://www.amazon.'.$region.'/b/?_encoding=UTF8&camp=1789&creative=390957&linkCode=ur2&node=2956536011&tag=linuhardguid-20">Amazon.'.$region.'</a><img src="https://www.assoc-amazon.com/e/ir?t=linuhardguid-20&l=ur2&o=1" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />'; //}else{ //$returnval .= ' '.$txt_price.':'."\n"; $ProductIsUnavailable = 1; if ($result["URL"] == "") { $meta = "url-amazon." . $region; $result["URL"] = get_post_meta($post->ID, $meta, true); } //still undefined? if ($result["URL"] == "") { $region_tmp = $region; if ($region == "nl") { $region_tmp = "de"; } $result["URL"] = 'http://www.amazon.' . $region_tmp . '/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=' . $aid; $NoUrlAvailable = 1; } # $returnval .= ' '. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="outofstock">('.$txt_out_of_stock.')</span>'."\n"; # if ($region !== "de") if ($NoUrlAvailable != 1) $returnval .='<br><div class="amazon-cr"></div>'.$txt_not_avail_at.' <a target="_blank" href="http://www.amazon.'.$region.'/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag='.$aid.'" rel="nofollow">Amazon.'.$region.'</a><div class="amazon-cr"></div>'; # if ($region !== "de") if ($NoUrlAvailable == 1) $returnval .='<br><div class="amazon-cr"></div>'.$txt_never_avail.' <a target="_blank" href="http://www.amazon.'.$region.'/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag='.$aid.'" rel="nofollow">Amazon.'.$region.'</a><div class="amazon-cr"></div>'; # if ($region == "de") $returnval .='<br>Nicht lieferbar von <a target="_blank" href="http://www.amazon.'.$region.'/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag='.$aid.'" rel="nofollow">Amazon.'.$region.'</a>'; //<img src="https://www.assoc-amazon.com/e/ir?t=linuhardguid-20&l=ur2&o=1" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" />'; // $returnval .= ' '. mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' <span class="instock"> (auf Lager) </span>'."\n"; //} #Not needed any longer. Stored in DB $myFile = "/home/wordpressftp/amazon-{$region}.txt"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $post->ID . ";" . $txt_out_of_stock . "\n"; fwrite($fh, $stringData); fclose($fh); # store price to file currently disabled # # //print 'Res:'. $result["URL"]; # //$newPrice with date $myFile = "/home/wordpressftp/amazon_date-{$region}.txt"; $timeInf = time(); $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = $post->ID . ";" . $newPrice . ";" . $timeInf . ";" . $result["URL"] . "\n"; fwrite($fh, $stringData); fclose($fh); //store in DB $newPrice = "out of stock"; if ($region === "de") { $newPrice = "nicht lieferbar"; } $meta = "price-amazon." . $region; update_post_meta($post->ID, $meta, $newPrice); //$meta="url-amazon.".$region; //update_post_meta($post->ID,$meta,$result["URL"]); #print "BBB<br>"; #lhg_amazon_price_to_db($region, $post->ID, $asin, $newPrice, $result["URL"], $timeInf); // $returnval.="Warn \n"; } //if(isset($result["LowestUsedPrice"])){ // $returnval .= ' <tr>'."\n"; // $returnval .= ' <td class="amazon-used-label">'.$appip_text_usedfrom.':</td>'."\n"; // if($result["TotalUsed"]>0){ // // $returnval .= ' <td class="amazon-used">'. mb_convert_encoding($result["LowestUsedPrice"], $encodemode, mb_detect_encoding( $result["LowestUsedPrice"], "auto" )) .' <span class="instock">'.$appip_text_instock.'</span></td>'."\n"; // }else{ // $returnval .= ' <td class="amazon-new">'. mb_convert_encoding($result["LowestNewPrice"], $encodemode, mb_detect_encoding( $result["LowestUsedPrice"], "auto" )) . ' <span class="outofstock">'.$appip_text_outofstock.'</span></td>'."\n"; // } // $returnval .= ' </tr>'."\n"; //} //$returnval .= ' <tr>'."\n"; //$returnval .= ' <td valign="top" colspan="2">'."\n"; //$returnval .= ' <div class="amazon-dates">'."\n"; //if(isset($result["ReleaseDate"])){ // if(strtotime($result["ReleaseDate"]) > strtotime(date("Y-m-d",time()))){ //$returnval .= ' <span class="amazon-preorder"><br />'.$appip_text_releasedon.' '.date("F j, Y", strtotime($result["ReleaseDate"])).'.</span>'."\n"; // }else{ //$returnval .= ' <span class="amazon-release-date">'.$appip_text_reldate.' '.date("F j, Y", strtotime($result["ReleaseDate"])).'.</span>'."\n"; // } //} //update amazon price first (see above), now show the button with updated price $returnval .= lhg_get_shop_button($post->ID); if ($errors == '') { //product not available at amazon if ($result["URL"] == "") { $meta = "url-amazon." . $region; $result["URL"] = get_post_meta($post->ID, $meta, true); } //still undefined? if ($result["URL"] == "") { $result["URL"] = 'http://www.amazon.' . $region . '/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag=' . $aid; $NoUrlAvailable = 1; } // href="http://www.amazon.'.$region.'/?_encoding=UTF8&camp=15121&creative=390961&linkCode=ur2&tag='.$aid.'"> //gif for german page # if ($lang == "de") $returnval .= '<br><a href="' . $result["URL"] .'" rel="nofollow"><img src="'.$txt_button.'" border="0" '.$txt_button_width.'></a>'; # # //dynamic button for everyone else # if ($lang != "de") { # # global $txt_button_string; # # if ($ProductIsUnavailable == 1) if ($NoUrlAvailable == 1) { ## $txt_button_string = $txt_search_at.' Amazon.'.$region; # $returnval .= '<br><a href="'. $result["URL"] .'" class="css_btn_class" rel="nofollow"><i class="icon-search icon-large3"></i> '.$txt_button_string.'</a>'; # } # # if ($ProductIsUnavailable == 1) if ($NoUrlAvailable != 1) { # $txt_button_string = $txt_preorder.' Amazon.'.$region; # $returnval .= '<br><a href="'. $result["URL"] .'" class="css_btn_class" rel="nofollow"><i class="icon-shopping-cart icon-large3"></i> '.$txt_button_string.'</a>'; # } # # if ($ProductIsUnavailable != 1) { # $txt_button_string = $txt_buy_from.' Amazon.'.$region; # $returnval .= '<br><a href="'. $result["URL"] .'" class="css_btn_class" rel="nofollow"><i class="icon-shopping-cart icon-large3"></i> '.$txt_button_string.'</a>'; # } # } } if ($extrabutton == 1 && $aws_partner_locale != '.com') { //$returnval .= ' <br /><div><a style="display:block;margin-top:8px;margin-bottom:5px;width:165px;" '. $apippnewwindowhtml .' href="' . $result["URL"] .'"><img src="'.WP_PLUGIN_URL.'/amazon-product-in-a-post-plugin/images/buyamzon-button.png" border="0" style="border:0 none !important;margin:0px !important;background:transparent !important;"/></a></div>'."\n"; } //close amzbox $returnval .= '</div>'; # $returnval .= '</div></div>'."\n"; //$returnval .= ' </td>'."\n"; //$returnval .= ' </tr>'."\n"; //If(!isset($result["LowestUsedPrice"]) && !isset($result["LowestNewPrice"]) && !isset($result["ListPrice"])){ // $returnval .= ' <tr>'."\n"; // $returnval .= ' <td class="amazon-price-save-label" colspan="2">'.$appip_text_notavalarea.'</td>'."\n"; // $returnval .= ' </tr>'."\n"; //} //$returnval .= ' </table>'."\n"; // $returnval .= ' </div>'; // <br style="clear:left;">'."\n"; //$returnval .= ' </div>'."\n"; //$returnval .= ' </td>'."\n"; //$returnval .= ' </tr>'."\n"; //$returnval .= ' </table>'."\n"; //$siteurl="linux-hardware-guide.com"; $catlist = category_links(); global $lhg_is_mobile_mode; if ($lhg_is_mobile_mode != 1) { $returnval = $returnval . '<div class="amazon-cat-list">' . $catlist . "</div>"; } /*<table class=producttop border=0> #<tr class="producttop"> #<td class="producttop" width=50%>'. $returnval .'</td> <td class="producttop" width=50%>'. $catlist .' </td></tr></table>'; */ if ($lhg_is_mobile_mode == 1) { $returnval = '<div class="amazon_product_top">' . $returnval . '</div> <div class="amazon-cat-list">' . $catlist . ' </div> <br style="clear:left;" /> '; } if (is_category()) { // is category, not chart output // echo "<h2>Cat</h2>"; } else { if ($errors == '') { # creation of chart should be performed on separate machine # currently disabled # # //echo "Here"; start_pricechart($post->ID); //print "lang: $lang"; // Pricetrend image alt text: $currency = lhg_get_currency_symbol($region); $imgtext = $txt_pricetrend; if (file_exists("/var/www/charts/" . $post->ID . "-" . $region . ".dat")) { $myFile = "/var/www/charts/" . $post->ID . "-" . $region . ".dat"; $file = file($myFile); list($min, $max, $chartdate) = split(";", $file[0]); //echo "Min, Max: $min $max"; $title = get_the_title(); //echo "T: $title"; $sp = strpos($title, "("); //echo "Pos: $sp"; if ($sp != "") { $title = substr($title, 0, $sp); } //echo "T: $title"; $imgtext = $txt_pricetrend . "\n" . translate_title($title) . "\n-\nMinimum: {$currency} {$min} \nMaximum: {$currency} {$max} \n{$txt_updated}: {$chartdate}"; } if ($lang == "de") { // en has no support for multiple affiliates a.t.m. //if (file_exists("/var/www/charts/".$post->ID."m.png")){ if (false) { $returnval .= '<br style="clear:left;" /><img src="http://' . $siteurl . '/wp-uploads/charts/' . $post->ID . 'm.png" alt="' . $imgtext . '" title="' . $imgtext . '" />'; } else { if (file_exists("/var/www/charts/" . $post->ID . "-" . $region . ".png")) { if ($charterror == 0) { $returnval .= '<br style="clear:left;" /><img src="/wp-uploads/charts/' . $post->ID . '-' . $region . '.png" alt="' . $imgtext . '" title="' . $imgtext . '" />'; } } } } else { if ($charterror == 0) { if (file_exists("/var/www/charts/" . $post->ID . "-" . $region . ".png")) { $returnval .= '<br style="clear:left;" /><img src="/wp-uploads/charts/' . $post->ID . "-" . $region . '.png" alt="' . $imgtext . '" title="' . $imgtext . '" />'; } } } #list known prices #if (file_exists("/var/www/charts/list".$post->ID.".txt")){ #$PriceList = file("/var/www/charts/list".$post->ID.".txt"); # #$returnval .= '<ul>Preisvergleich # <li>Amazon.de: '.mb_convert_encoding($newPrice , $encodemode, mb_detect_encoding( $newPrice, "auto" )).' (<a href="' . $result["URL"] .'">bestellen</a>)'; # #$returnval .= $PriceList[0]; #$returnval .="</ul>"; #} } } //List related categories //$returnval .= category_links(); //show CPU table #if (in_category('CPU')) $returnval .= cpu_comparison(); $googlecom = '<script async src="http://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <ins class="adsbygoogle" style="display:inline-block;width:728px;height:90px" data-ad-client="ca-pub-5383503261197603" data-ad-slot="4611540473"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script>'; $googlede = '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- Linux-Hardware-Guide.de --> <ins class="adsbygoogle" style="display:inline-block;width:728px;height:90px" data-ad-client="ca-pub-5383503261197603" data-ad-slot="3000901678"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script>'; $google_small_mobile = ' <center> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <!-- Mobile Banner --> <ins class="adsbygoogle" style="display:inline-block;width:320px;height:50px" data-ad-client="ca-pub-5383503261197603" data-ad-slot="9621646075"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </center>'; global $lhg_is_mobile_mode; global $lhg_mobile_size; if ($lhg_is_mobile_mode != 1) { if ($lang == "en") { if (!is_user_logged_in()) { $returnval .= $googlecom; } } } // if ($rating_total == 0) { $rate_average_value = 0; } else { $rate_average_value = round($rating / $rating_total, 1); } //only show in case of low rating if ($lhg_is_mobile_mode != 1) { if ($lang == "de") { if ($rate_average_value < 5) { if (!is_user_logged_in()) { $returnval .= $googlede; } } } } if ($lhg_is_mobile_mode == 1) { if (!is_user_logged_in()) { if ($lhg_mobile_size == "small") { $returnval .= $google_small_mobile; } elseif ($lhg_mobile_size == "large") { $returnval .= $googlecom; } else { $returnval .= $google_small_mobile; } } } //show article header //itemprop description is closed in related-post-thumbnails $returnval .= '<br /><h2>' . $txt_Compat . '</h2><div itemprop="description"><div class="description">'; $returnval .= affilinet(); //article_list(); return $returnval; } } }
/** * Parses content tags * Since 1.4.6 */ function format_content($string, $data = array(), $rating) { if (empty($string) || (empty($data) || !is_array($data))) { return false; } $string = htmlentities($string); $params = array(); $pattern = '/\\{(excerpt|summary|stats|title|image|thumb|rating|score|url|text_title|author|category|views|comments)\\}/i'; preg_match_all($pattern, $string, $matches); array_map('strtolower', $matches[0]); if (in_array("{title}", $matches[0])) { $string = str_replace("{title}", $data['title'], $string); } if (in_array("{stats}", $matches[0])) { $string = str_replace("{stats}", $data['stats'], $string); } if (in_array("{excerpt}", $matches[0])) { $string = str_replace("{excerpt}", htmlentities($data['summary'], ENT_QUOTES), $string); } if (in_array("{summary}", $matches[0])) { $string = str_replace("{summary}", htmlentities($data['summary'], ENT_QUOTES), $string); } if (in_array("{image}", $matches[0])) { $string = str_replace("{image}", $data['img'], $string); } if (in_array("{thumb}", $matches[0])) { $string = str_replace("{thumb}", $data['img'], $string); } // WP-PostRatings check if ($rating && $this->postRating) { if (in_array("{rating}", $matches[0])) { $string = str_replace("{rating}", the_ratings_results($data['id']), $string); } if (in_array("{score}", $matches[0])) { $string = str_replace("{score}", expand_ratings_template('%RATINGS_SCORE%', $data['id']), $string); // removing the redundant plus sign $string = str_replace('+', '', $string); } } if (in_array("{url}", $matches[0])) { $string = str_replace("{url}", $data['url'], $string); } if (in_array("{text_title}", $matches[0])) { $string = str_replace("{text_title}", $data['text_title'], $string); } if (in_array("{author}", $matches[0])) { $string = str_replace("{author}", $data['author'], $string); } if (in_array("{category}", $matches[0])) { $string = str_replace("{category}", $data['category'], $string); } if (in_array("{views}", $matches[0])) { $string = str_replace("{views}", $data['views'], $string); } if (in_array("{comments}", $matches[0])) { $string = str_replace("{comments}", $data['comments'], $string); } return html_entity_decode($string); }
/** * * @global type $wp_locale * @global type $wp_query * @param int $source SEARCH_ constant * @param type $wpQueryResults * @param type $displayPostMeta * @param string $maxResults */ private function populate($source, $wpQueryResults, $displayPostMeta, $maxResults) { global $wp_locale; global $wp_query; $dateFormat = get_option('date_format'); // Some other plugin threw a fit once if I didn't instantiate // WP_Query once to initialize everything and then call it // for real. Might have been "Search Everything". I think there's // a comment about it in an old version of DWLS. $wp_query = $wpQueryResults = new WP_Query(); $wp_query = $wpQueryResults = new WP_Query(); if (function_exists('relevanssi_do_query')) { // Relevanssi isn't treating 0 as "unlimited" results // like WordPress's native search does. So we'll replace // $maxResults with a really big number, the biggest one // PHP knows how to represent, if $maxResults == -1 // (unlimited) if (-1 == $maxResults) { $maxResults = PHP_INT_MAX; } } $wpQueryParams = $_GET; $wpQueryParams['showposts'] = $maxResults; if (self::SEARCH_WPCOMMERCE === $source) { $wpQueryParams['post_type'] = 'wpsc-product'; } else { # LHG: was "any", but now limited to HW posts $wpQueryParams['post_type'] = 'post'; } $wpQueryParams['post_status'] = 'publish'; $queryString = http_build_query($wpQueryParams); $wpQueryResults->query($queryString); $this->searchTerms = $wpQueryResults->query_vars['s']; $wpQueryResults = apply_filters('dwls_alter_results', $wpQueryResults, $maxResults); foreach ($wpQueryResults->posts as $result) { // Add author names & permalinks if ($displayPostMeta) { $result->post_author_nicename = $this->authorName($result->post_author); } $result->permalink = lhg_translate_search_url(get_permalink($result->ID)); if (function_exists('get_post_thumbnail_id')) { // Support for WP 2.9 post thumbnails $postImageID = get_post_thumbnail_id($result->ID); $postImageData = wp_get_attachment_image_src($postImageID, apply_filters('post_image_size', 'thumbnail')); $hasThumbnailSet = $postImageData !== false; } else { // No support for post thumbnails $hasThumbnailSet = false; } if ($hasThumbnailSet) { $result->attachment_thumbnail = $postImageData[0]; } else { // If no post thumbnail, grab the first image from the post $applyContentFilter = get_option('daves-wordpress-live-search_apply_content_filter', false); $content = $result->post_content; if ($applyContentFilter) { $content = apply_filters('the_content', $content); } $content = str_replace(']]>', ']]>', $content); $result->attachment_thumbnail = $this->firstImg($content); } $result->attachment_thumbnail = apply_filters('dwls_attachment_thumbnail', $result->attachment_thumbnail); $result->post_excerpt = $this->excerpt($result); $result->post_date = date_i18n($dateFormat, strtotime($result->post_date)); $result->post_date = apply_filters('dwls_post_date', $result->post_date); // We don't want to send all this content to the browser unset($result->post_content); // xLocalization $result->post_title = apply_filters("localization", $result->post_title); $result->post_title = apply_filters('dwls_post_title', $result->post_title); global $lang; if ($lang != "de") { $pt = qtrans_useCurrentLanguageIfNotFoundUseDefaultLanguage($result->post_title); } if ($lang == "de") { $pt = $result->post_title; } $result->post_title = $pt . "<br>" . the_ratings_results($result->ID, 0, 0, 0, 10); #."<br>".$pt; $result->show_more = true; $this->results[] = $result; } }
public function widget($args, $lhg_instance) { //show only for english pages (missing translation of articles) // ToDo: Check if translation exists, otherwise hide global $region; if ($region == "fr" or $region == "es" or $region == "it" or $region == "nl" or $region == "co.jp" or $region == "cn") { return; } #echo "INS: ".$instance['title']; #var_dump($lhg_instance); $title = apply_filters('widget_title', $lhg_instance['title']); $artid = $lhg_instance['artid']; $default_image = ""; $text = get_post_field('post_content', $artid); $text = lhg_clean_extract($text, 600); $more = "(more)"; $posttitle = translate_title(get_the_title($artid)); $s = explode("(", $posttitle); $short_title = trim($s[0]); $sub_title = trim($s[1]); $sub_title = str_replace(")", "", $sub_title); //get the latest date global $wpdb; $sql = "\n SELECT post_modified\n FROM {$wpdb->posts}\n WHERE ID = " . $artid; $last_update = $wpdb->get_var($sql); $wpdf = get_option('date_format'); $lupdate = date($wpdf, strtotime($last_update)); // get comments $cn = lhg_get_comments_number($artid); if ($cn > 0) { //Comment tooltip $txt_comments = $txt_cpl_comments; //"Kommentare"; //if ($lang == "en") $txt_comments="comments"; if ($cn == 1) { $txt_comments = $txt_cpl_comment; //"Kommentar"; //if ($lang == "en") $txt_comments="comment"; } $coutInv = ''; //<span class="comment-count-out-invisible"></span>'; $cout = '<a href="' . $arturl . '#comments" alt="' . $cn . ' ' . $txt_comments . '" title="' . $cn . ' ' . $txt_comments . '"> <div class="comment-count-out"> <span class="comment-bubble"></span> <span class="comment-count">' . $cn . '</span> </div> </a>'; } else { $coutInv = ""; $cout = ""; } //ratings $ratings = the_ratings_results($artid, 0, 0, 0, 10); #var_dump($last_update); #var_dump($wpdf); #$sql = "SELECT post_modified # FROM $wpdb->posts # WHERE post_id ='".$artid."'"; #$last_update = $wdpb->get_var( $sql ); #echo( "Last updated $lupdate ." ); #$date = get_the_modified_date($artid) $permalink = get_permalink($artid); $image = get_the_post_thumbnail($artid, array(130, 130)); #echo "ARGS: $args"; #var_dump($args); extract($args); #var_dump($instance); #echo "TIT: ".$instance['title']; echo "{$before_widget}"; #$title = apply_filters ( 'widget_title', $instance['title'] ); #$artid = empty( $instance['artid'] ) ? ' ' : $instance['artid']; #if ( !empty( $title ) ) { echo $before_title . $title . $after_title; #}; echo '<div class="featured-hw">'; #echo '<div class="featured-title-date">'.$lupdate.':</div>'; echo '<div class="featured-title"><a href="' . $permalink . '">' . $short_title . '</a></div> <span class="featured-comments">' . $cout . '</span> <span class="featured-ratings">' . $ratings . '</span> <div class="featured-title-sub"><a href="' . $permalink . '">(' . $sub_title . ')</a></div> <div class="featured-image"><a href="' . $permalink . '">' . $image . '</a></div> ' . $text . '... <a href="' . $permalink . '">' . $more . '</a></p>'; echo "</div>"; echo $after_widget; }