function lhg_db_get_cheapest_price_by_region($postid, $search_region)
{
global $region;
#echo "RG: $region";
#print "PID: $postid<br>";
if ($search_region == "de" && $region != "de") {
$postid = lhg_get_postid_de_from_com($postid);
}
if ($search_region != "de" && $region == "de") {
$postid = lhg_get_postid_com_from_de($postid);
}
#print "PID2: $postid<br>";
$shopids = lhg_return_shop_ids($search_region);
#print "SIDS<br>";
#var_dump($shopids);
//which shop has this product?
$products = lhg_get_sorted_products($shopids, $postid, $search_region);
$price = $products[0]["price"] + $products[0]["shipping"];
//return first one = cheapest
return $price;
}
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";
echo "\n \t<td id=\"col5\">\n\t <span class='column-hwbutton'>" . $hwbutton . "</span>\n <div class='regusers'>(Reg. Linux users: " . $usernum . ")</div>\n \t </td>";
}
// --- User to rate HW
$postid = $a_identified_hw->postid;
if ($lang == "de") {
$postid = lhg_get_postid_de_from_com($postid);
}
#if ($myrating == "n.a.")
echo "\n <td id=\"col4\">\n <span class='subscribe-column-2'>" . $out1 . "</span>\n </td>";
#$registration_date=$a_subscription->dt;
#list ($registration_date, $registration_time) = explode(" ",$registration_date);
$categorypart2 = "";
if ($category_name2 != "") {
$categorypart2 = "<br>({$category_name2})";
}
echo "\n <td id=\"col2\">\n <span class='subscribe-column-1'><center>{$category_name} {$categorypart2} </center></span>\n </td>";
echo "</tr>\n";
}
$usercomment_multi = lhg_get_usercomment_multi($sid, $id);
$buttontype = "green";
$buttontext = $txt_submit;
function lhg_country_row($p_region, $URLC, $URLD, $posturlcom, $posturlde)
{
# store url to be available globally (e.g. by wp-one-post-widget)
global $posturlcom_glob;
global $posturlde_glob;
$posturlcom = $posturlcom_glob;
$posturlde = $posturlde_glob;
global $post;
global $txt_out_of_stock;
global $region;
$selected = "";
if ($region == $p_region) {
$selected = 'class="ct_pricetop" ';
}
#print "URLD: $URLD -- $posturlde<br>";
print "<tr {$selected}>";
#print "PID: $post->ID";
# get the correct postid for .com and .de server
$relevant_postid = $post->ID;
if ($lang == "de") {
$relevant_postid = lhg_get_postid_de_from_com($post->ID);
}
$price = lhg_db_get_cheapest_price_by_region($relevant_postid, $p_region);
$price = lhg_float_to_currency_string($price, $p_region);
if ($price == 0) {
$price = $txt_out_of_stock;
$txt_currency = "";
} else {
$txt_currency = lhg_get_currency_symbol($p_region);
$price = $price;
}
#if ($p_region == "de"){
#
# print "PRI: $price<br>";
# # ToDo: need access to .de database or Amazon prices to be stored on priceDB
# $price = "-";
# $txt_currency = "";
#}
echo '<td class="ct_country"> ';
if ($p_region == "de") {
$URL_add = '/';
$flag = "de";
$country = "Germany";
}
if ($p_region == "ca") {
$URL_add = '/ca/';
$flag = "ca";
$country = "Canada";
}
if ($p_region == "com") {
$URL_add = '/';
$flag = "us";
$country = "USA";
}
if ($p_region == "co.uk") {
$URL_add = '/uk/';
$flag = "uk";
$country = "United Kingdom";
}
if ($p_region == "fr") {
$URL_add = '/fr/';
$flag = "fr";
$country = "France";
}
if ($p_region == "es") {
$URL_add = '/es/';
$flag = "es";
$country = "Espana";
}
if ($p_region == "it") {
$URL_add = '/it/';
$flag = "it";
$country = "Italia";
}
if ($p_region == "nl") {
$URL_add = '/nl/';
$flag = "nl";
$country = "Netherlands";
}
if ($p_region == "in") {
$URL_add = '/in/';
$flag = "in";
$country = "India";
}
if ($p_region == "co.jp") {
$URL_add = '/ja/';
$flag = "jp";
$country = "Japan";
}
if ($p_region == "cn") {
$URL_add = '/zh/';
$flag = "cn";
$country = "China";
}
if ($p_region == "de") {
$URL = $URLD . $URL_add . $posturlde;
}
if ($p_region != "de") {
$URL = $URLC . $URL_add . $posturlcom;
}
echo '<a href="' . $URL . '"><img src="/wp-content/plugins/qtranslate/flags/' . $flag . '.png" alt="' . $country . '" /> ' . $country . '</a></td>';
echo '<td class="ct_price">' . $price . '</td>';
echo '<td class="ct_currency">' . $txt_currency . '</td>';
echo '<td class="ct_comment">';
# comment number
#not yet implemented for "de"
#if ($p_region == "de"){
# echo "-";
#}else{
lhg_comments_number_language($p_region, $p_region, 0, $post->ID, "shortversion");
#}
echo '</td></tr>';
}
