PageRenderTime 40ms CodeModel.GetById 10ms RepoModel.GetById 0ms app.codeStats 0ms

/wp-content/plugins/wp-e-commerce/wpsc-includes/display.functions.php

https://gitlab.com/endomorphosis/reservationtelco
PHP | 562 lines | 441 code | 74 blank | 47 comment | 134 complexity | a7d2d6cad544043be4ff49b3fcb7d53a MD5 | raw file
    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * WP eCommerce display functions

    4. 

  4.  *

    5. 

  5.  * These are functions for the wp-eCommerce theme engine, template tags and shortcodes

    6. 

  6.  *

    7. 

  7.  * @package wp-e-commerce

    8. 

  8.  * @since 3.7

    9. 

  9. */

    10. 

  10. 

    11. 

  11. 

    12. 

  12. 

    13. 

  13. 

    14. 

  14. /**

    15. 

  15. * wpsc buy now button code products function

    16. 

  16. * Sorry about the ugly code, this is just to get the functionality back, buy now will soon be overhauled, and this function will then be completely different

    17. 

  17. * @return string - html displaying one or more products

    18. 

  18. */

    19. 

  19. function wpsc_buy_now_button($product_id, $replaced_shortcode = false) {

    20. 

  20.   global $wpdb, $wpsc_query, $wpsc_cart;

    21. 

  21.   $temp_wpsc_query = new WPSC_query(array('product_id' =>$product_id));

    22. 

  22.   list($wpsc_query, $temp_wpsc_query) = array($temp_wpsc_query, $wpsc_query); // swap the wpsc_query objects

    23. 

  23. //  exit('<pre>'.print_r($temp_wpsc_query, true).'</pre>');

    24. 

  24.   $selected_gateways = get_option('custom_gateway_options');

    25. 

  25.   if (in_array('google', (array)$selected_gateways)) {

    26. 

  26. 		$output .= google_buynow($product['id']);

    27. 

  27. 	} else if (in_array('paypal_multiple', (array)$selected_gateways)) {

    28. 

  28. 		if ($product_id > 0){

    29. 

  29. 				//$output .= "<pre>".print_r($wpsc_query,true)."</pre>";

    30. 

  30. 			while (wpsc_have_products()) :

    31. 

  31. 				wpsc_the_product();

    32. 

  32. 				$price =  calculate_product_price($wpsc_query->product['id'], $wpsc_query->first_variations); 

    33. 

  33. 				$shipping = $wpsc_query->product['pnp'];

    34. 

  34. 				if(wpsc_uses_shipping()){$handling = get_option('base_local_shipping');}else{$handling = $shipping;}
    35. 

  35. 

    36. 

  36. 				$output .= "<form onsubmit='log_paypal_buynow(this)' target='paypal' action='".get_option('paypal_multiple_url')."' method='post' />

    37. 

  37. 					<input type='hidden' name='business' value='".get_option('paypal_multiple_business')."' />

    38. 

  38. 					<input type='hidden' name='cmd' value='_xclick' />

    39. 

  39. 					<input type='hidden' name='item_name' value='".wpsc_the_product_title()."' />

    40. 

  40. 					<input type='hidden' id='item_number' name='item_number' value='".wpsc_the_product_id()."' />

    41. 

  41. 					<input type='hidden' id='amount' name='amount' value='".($price+$pnp)."' />

    42. 

  42. 					<input type='hidden' id='unit' name='unit' value='".$price."' />

    43. 

  43. 					<input type='hidden' id='shipping' name='ship11' value='".$shipping."' />

    44. 

  44. 					<input type='hidden' name='handling' value='".$handling."' />

    45. 

  45. 					<input type='hidden' name='currency_code' value='".get_option('paypal_curcode')."' />";

    46. 

  46. 				if(get_option('multi_add') == 1){

    47. 

  47. 					$output .="<label for='quantity'>".__('Quantity','wpsc')."</label>";

    48. 

  48. 					$output .="<input type='text' size='4' id='quantity' name='quantity' value='' /><br />";

    49. 

  49. 				}else{

    50. 

  50. 					$output .="<input type='hidden' name='undefined_quantity' value='0' />";

    51. 

  51. 				}

    52. 

  52. 					$output .="<input type='image' name='submit' border='0' src='https://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif' alt='PayPal - The safer, easier way to pay online' />

    53. 

  53. 					<img alt='' border='0' width='1' height='1' src='https://www.paypal.com/en_US/i/scr/pixel.gif' />

    54. 

  54. 				</form>\n\r";

    55. 

  55. 			endwhile;

    56. 

  56. 		}

    57. 

  57. 	}

    58. 

  58. 	

    59. 

  59. 	list($temp_wpsc_query, $wpsc_query) = array($wpsc_query, $temp_wpsc_query); // swap the wpsc_query objects back

    60. 

  60. 	if($replaced_shortcode == true) {

    61. 

  61. 		return $output;

    62. 

  62. 	} else {

    63. 

  63. 		echo $output;

    64. 

  64.   }

    65. 

  65. }

    66. 

  66. 

    67. 

  67. 

    68. 

  68. 

    69. 

  69. function wpsc_also_bought($product_id) {

    70. 

  70.   /*

    71. 

  71.    * Displays products that were bought aling with the product defined by $product_id

    72. 

  72.    * most of it scarcely needs describing

    73. 

  73.    */

    74. 

  74.   global $wpdb;

    75. 

  75.   $siteurl = get_option('siteurl');

    76. 

  76.   

    77. 

  77.   if(get_option('wpsc_also_bought') == 0) {

    78. 

  78.     //returns nothing if this is off

    79. 

  79.     return '';

    80. 

  80. 	}

    81. 

  81.   

    82. 

  82.   // to be made customiseable in a future release

    83. 

  83.   $also_bought_limit = 3;

    84. 

  84.   $element_widths = 96; 

    85. 

  85.   $image_display_height = 96; 

    86. 

  86.   $image_display_width = 96; 

    87. 

  87.   

    88. 

  88.   $also_bought = $wpdb->get_results("SELECT `".WPSC_TABLE_PRODUCT_LIST."`.* FROM `".WPSC_TABLE_ALSO_BOUGHT."`, `".WPSC_TABLE_PRODUCT_LIST."` WHERE `selected_product`='".$product_id."' AND `".WPSC_TABLE_ALSO_BOUGHT."`.`associated_product` = `".WPSC_TABLE_PRODUCT_LIST."`.`id` AND `".WPSC_TABLE_PRODUCT_LIST."`.`active` IN('1') AND `".WPSC_TABLE_PRODUCT_LIST."`.`publish` IN ('1')ORDER BY `".WPSC_TABLE_ALSO_BOUGHT."`.`quantity` DESC LIMIT $also_bought_limit",ARRAY_A);

    89. 

  89.   if(count($also_bought) > 0) {

    90. 

  90.     $output = "<h2 class='prodtitles wpsc_also_bought' >".__('People who bought this item also bought', 'wpsc')."</h2>";

    91. 

  91.     $output .= "<div class='wpsc_also_bought'>";

    92. 

  92.     foreach((array)$also_bought as $also_bought_data) {

    93. 

  93.       $output .= "<div class='wpsc_also_bought_item' style='width: ".$element_widths."px;'>";

    94. 

  94.       

    95. 

  95.       if(get_option('show_thumbnails') == 1) {

    96. 

  96.         if($also_bought_data['image'] !=null) {

    97. 

  97. 

    98. 

  98.           $output .= "<a href='".wpsc_product_url($also_bought_data['id'])."' class='preview_link'  rel='".str_replace(" ", "_",$also_bought_data['name'])."'>";

    99. 

  99. 					$image_path = "index.php?productid=" . $also_bought_data['id'] . "&amp;width=" . $image_display_width."&amp;height=" . $image_display_height. "";

    100. 

  100.           

    101. 

  101.           $output .= "<img src='$image_path' id='product_image_".$also_bought_data['id']."' class='product_image' style='margin-top: ".$margin_top."px'/>";

    102. 

  102.           $output .= "</a>";

    103. 

  103. 				} else {

    104. 

  104.           if(get_option('product_image_width') != '') {

    105. 

  105.             $output .= "<img src='".WPSC_URL."/images/no-image-uploaded.gif' title='".$also_bought_data['name']."' alt='".$also_bought_data['name']."' width='$image_display_height' height='$image_display_height' id='product_image_".$also_bought_data['id']."' class='product_image' />";

    106. 

  106. 					} else {

    107. 

  107.             $output .= "<img src='".WPSC_URL."/images/no-image-uploaded.gif' title='".$also_bought_data['name']."' alt='".htmlentities(stripslashes($product['name']), ENT_QUOTES, 'UTF-8')."' id='product_image_".$also_bought_data['id']."' class='product_image' />";

    108. 

  108. 					}

    109. 

  109. 				}

    110. 

  110. 			}

    111. 

  111. 

    112. 

  112. 			$variations_processor = new nzshpcrt_variations;

    113. 

  113. 			$variations_output = $variations_processor->display_product_variations($also_bought_data['id'],true, false, true);

    114. 

  114. 			//$output .= $variations_output[0];

    115. 

  115. 			if($variations_output[1] !== null) {

    116. 

  116. 				$also_bought_data['price'] = $variations_output[1];

    117. 

  117. 				$also_bought_data['special_price'] = 0;

    118. 

  118. 			}

    119. 

  119. 		

    120. 

  120.       $output .= "<a class='wpsc_product_name' href='".wpsc_product_url($also_bought_data['id'])."'>".$also_bought_data['name']."</a>";

    121. 

  121. 			$output .= nzshpcrt_currency_display(($also_bought_data['price'] - $also_bought_data['special_price']), $also_bought_data['notax'],false,$also_bought_data['id']);

    122. 

  122.       //$output .= "<a href='".wpsc_product_url($also_bought_data['id'])."'>".$also_bought_data['name']."</a>";

    123. 

  123.       $output .= "</div>";

    124. 

  124. 		}

    125. 

  125.     $output .= "</div>";

    126. 

  126.     $output .= "<br clear='all' />";

    127. 

  127. 	}

    128. 

  128.   return $output;

    129. 

  129. }  

    130. 

  130. 

    131. 

  131. 

    132. 

  132. function fancy_notifications() {

    133. 

  133.   global $wpdb;

    134. 

  134.   if(get_option('fancy_notifications') == 1) {

    135. 

  135.     $output = "";

    136. 

  136.     $output .= "<div id='fancy_notification'>\n\r";

    137. 

  137.     $output .= "  <div id='loading_animation'>\n\r";

    138. 

  138.     $output .= '<img id="fancy_notificationimage" title="Loading" alt="Loading" src="'.WPSC_URL.'/images/indicator.gif" />'.__('Updating', 'wpsc')."...\n\r";

    139. 

  139.     $output .= "  </div>\n\r";

    140. 

  140.     $output .= "  <div id='fancy_notification_content'>\n\r";

    141. 

  141.     $output .= "  </div>\n\r";

    142. 

  142.     $output .= "</div>\n\r";

    143. 

  143. 	}

    144. 

  144.   return $output;

    145. 

  145. }

    146. 

  146. 

    147. 

  147. function fancy_notification_content($cart_messages) {

    148. 

  148.   global $wpdb;

    149. 

  149.   $siteurl = get_option('siteurl');

    150. 

  150. 	foreach((array)$cart_messages as $cart_message) {

    151. 

  151. 		$output .= "<span>".$cart_message."</span>";

    152. 

  152. 	}

    153. 

  153. 	$output .= "<a href='".get_option('shopping_cart_url')."' class='go_to_checkout'>".__('Go to Checkout', 'wpsc')."</a>";

    154. 

  154. 	$output .= "<a href='#' onclick='jQuery(\"#fancy_notification\").css(\"display\", \"none\"); return false;' class='continue_shopping'>".__('Continue Shopping', 'wpsc')."</a>";

    155. 

  155.   return $output;

    156. 

  156. }

    157. 

  157. 

    158. 

  158. 

    159. 

  159. function wpsc_product_url($product_id, $category_id = null, $escape = true) {

    160. 

  160.   global $wpdb, $wp_rewrite, $wp_query;

    161. 

  161.   

    162. 

  162.   if(!is_numeric($category_id) || ($category_id < 1)) {

    163. 

  163. 		if(is_numeric($wp_query->query_vars['product_category'])) {

    164. 

  164. 		  $category_id = $wp_query->query_vars['product_category'];

    165. 

  165. 		} else {

    166. 

  166. 			$category_list = $wpdb->get_row("SELECT `".WPSC_TABLE_PRODUCT_CATEGORIES."`.`id`, IF((`".WPSC_TABLE_PRODUCT_CATEGORIES."`.`id` = '".get_option('wpsc_default_category')."'), 0, 1) AS `order_state` FROM `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` , `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`product_id` IN ('".$product_id."') AND `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`.`category_id` = `".WPSC_TABLE_PRODUCT_CATEGORIES."`.`id` AND `".WPSC_TABLE_PRODUCT_CATEGORIES."`.`active` IN('1') LIMIT 1",ARRAY_A);

    167. 

  167. 			$category_id = $category_list['id'];		

    168. 

  168. 		}

    169. 

  169.   }

    170. 

  170.   

    171. 

  171. 

    172. 

  172. //  exit('<pre>'.print_r($wp_query, true).'</pre>');

    173. 

  173.   if((($wp_rewrite->rules != null) && ($wp_rewrite != null)) || (get_option('rewrite_rules') != null)) {

    174. 

  174.     $url_name = get_product_meta($product_id, 'url_name', true);

    175. 

  175.     $url_name = htmlentities(stripslashes($url_name), ENT_QUOTES, 'UTF-8');

    176. 

  176. 		$product_url =wpsc_category_url($category_id).$url_name."/";

    177. 

  177.   } else {    

    178. 

  178.     if(!stristr(get_option('product_list_url'), "?")) {

    179. 

  179.       $initial_seperator = "?";

    180. 

  180.     } else {

    181. 

  181.       $initial_seperator = ($escape) ? "&amp;" : "&";

    182. 

  182.     }

    183. 

  183.     if(is_numeric($category_id) && ($category_id > 0)) {

    184. 

  184.       $product_url = get_option('product_list_url').$initial_seperator."category=".$category_id.(($escape) ? "&amp;" : "&")."product_id=".$product_id;

    185. 

  185.     } else {

    186. 

  186.       $product_url = get_option('product_list_url').$initial_seperator."product_id=".$product_id;

    187. 

  187.     }

    188. 

  188.   }

    189. 

  189.   return $product_url;

    190. 

  190. }

    191. 

  191. 

    192. 

  192. 

    193. 

  193. function google_buynow($product_id) {

    194. 

  194. 	global $wpdb;

    195. 

  195. 	$output = "";

    196. 

  196. 	if ($product_id > 0){

    197. 

  197. 		$product_sql = "SELECT * FROM ".WPSC_TABLE_PRODUCT_LIST." WHERE id = ".$product_id." LIMIT 1";

    198. 

  198. 		$product_info = $wpdb->get_results($product_sql, ARRAY_A);

    199. 

  199. 		$variation_sql = "SELECT * FROM ".WPSC_TABLE_VARIATION_PROPERTIES." WHERE product_id = ".$product_id;

    200. 

  200. 		$variation_info = $wpdb->get_results($variation_sql, ARRAY_A);

    201. 

  201. 		if (count($variation_info) > 0) {

    202. 

  202. 			$variation = 1;

    203. 

  203. 			$price = $variation_info[0]['price'];

    204. 

  204. 		}

    205. 

  205. 		if (get_option('google_server_type')=='production') {

    206. 

  206. 			$action_target = "https://checkout.google.com/cws/v2/Merchant/".get_option('google_id')."/checkoutForm";

    207. 

  207. 		} else {

    208. 

  208. 			$action_target = "https://sandbox.google.com/checkout/cws/v2/Merchant/".get_option('google_id')."/checkoutForm";

    209. 

  209. 		}

    210. 

  210. 

    211. 

  211. 	

    212. 

  212. 		$product_info = $product_info[0];

    213. 

  213. 		$output .= "<form id='BB_BuyButtonForm".$product_id."' onsubmit='log_buynow(this);return true;' action= '".$action_target."' method='post' name='BB_BuyButtonForm".$product_id."'>";

    214. 

  214. 		$output .= "<input name='product_id' type='hidden' value='".$product_id."'>";

    215. 

  215. 		$output .= "<input name='item_name_1' type='hidden' value='".$product_info['name']."'>";

    216. 

  216. 		$output .= "<input name='item_description_1' type='hidden' value='".$product_info['description']."'>";

    217. 

  217. 		$output .= "<input name='item_quantity_1' type='hidden' value='1'>";

    218. 

  218. 		if ($variation == 1) {

    219. 

  219. 			$output .= "<input id='item_price' name='item_price_1' type='hidden' value='".$price."'>";

    220. 

  220. 		} else {

    221. 

  221. 			if ($product_info['special']=='0') {

    222. 

  222. 				$output .= "<input id='item_price' name='item_price_1' type='hidden' value='".$product_info['price']."'>";

    223. 

  223. 			} else {

    224. 

  224. 				$output .= "<input name='item_price_1' type='hidden' value='".$product_info['special_price']."'>";

    225. 

  225. 			}

    226. 

  226. 		}

    227. 

  227. 		$output .= "<input name='item_currency_1' type='hidden' value='".get_option('google_cur')."'>";

    228. 

  228. 		$output .= "<input type='hidden' name='checkout-flow-support.merchant-checkout-flow-support.continue-shopping-url' value='".get_option('product_list_url')."'>";

    229. 

  229. 		$output .= "<input type='hidden' name='checkout-flow-support.merchant-checkout-flow-support.edit-cart-url' value='".get_option('shopping_cart_url')."'>";

    230. 

  230. 		$output .= "<input alt='' src=' https://checkout.google.com/buttons/buy.gif?merchant_id=".get_option('google_id')."&w=117&h=48&style=trans&variant=text&loc=en_US' type='image'/>";

    231. 

  231. 		$output .="</form>";

    232. 

  232. 	}

    233. 

  233. 	return $output;

    234. 

  234. }

    235. 

  235. 

    236. 

  236. function external_link($product_id) { 

    237. 

  237. 	global $wpdb;

    238. 

  238. 	$link = get_product_meta($product_id,'external_link',true);

    239. 

  239. 	if (!stristr($link,'http://')) {

    240. 

  240. 		$link = 'http://'.$link;

    241. 

  241. 	}

    242. 

  242. 	$output .= "<input type='button' value='".__('Buy Now', 'wpsc')."' onclick='gotoexternallink(\"$link\")'>";

    243. 

  243. 	return $output;

    244. 

  244. }

    245. 

  245. 

    246. 

  246. 

    247. 

  247. // displays error messages if the category setup is odd in some way

    248. 

  248. // needs to be in a function because there are at least three places where this code must be used.

    249. 

  249. function wpsc_odd_category_setup() {

    250. 

  250. 	get_currentuserinfo();

    251. 

  251.   global $userdata;  

    252. 

  252.   $output = '';

    253. 

  253.   if(($userdata->wp_capabilities['administrator'] ==1) || ($userdata->user_level >=9)) {

    254. 

  254.     if(get_option('wpsc_default_category') == 1) {

    255. 

  255. 			$output = "<p>".__('You are using the example product group as your default group and it has no products in it, you should set the default group to something else, you can do so from your Shop Settings page.', 'wpsc')."</p>";

    256. 

  256. 		} else {

    257. 

  257. 		  $output = "<p>".__('This group is set as your default product group, you should either add some items to it or switch your default product group to one that does contain items.', 'wpsc')."</p>";

    258. 

  258. 		}

    259. 

  259.   }

    260. 

  260.   return $output;

    261. 

  261. }

    262. 

  262. 

    263. 

  263. 

    264. 

  264. function wpsc_product_image_html($image_name, $product_id) {

    265. 

  265.   global $wpdb, $wp_query;

    266. 

  266. 	if(is_numeric($wp_query->query_vars['product_category'])) {

    267. 

  267.     $category_id = (int)$wp_query->query_vars['product_category'];

    268. 

  268. 	} else if (is_numeric($_GET['category'])) {

    269. 

  269.     $category_id = (int)$_GET['category'];

    270. 

  270. 	} else {

    271. 

  271.     $category_id = (int)get_option('wpsc_default_category');

    272. 

  272. 	}

    273. 

  273. 	

    274. 

  274. 	$product['height'] = get_product_meta($id, 'thumbnail_height');	

    275. 

  275. 	$product['width']  = get_product_meta($id, 'thumbnail_width');

    276. 

  276. 	

    277. 

  277. 	

    278. 

  278. 	$use_thumbnail_image = 'false';

    279. 

  279. 	if(($product['height'] > $category['height']) || ($product['width'] > $category['width'])) {

    280. 

  280. 		$use_thumbnail_image = 'true';

    281. 

  281. 	}

    282. 

  282. 	

    283. 

  283. 	//list($category['height'], $category['width']) =

    284. 

  284. if($category_id > 0) {

    285. 

  285. 	$category = $wpdb->get_row("SELECT `image_height` AS `height`, `image_width` AS `width` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `id` IN ('{$category_id}') LIMIT 1", ARRAY_A);

    286. 

  286. 	}

    287. 

  287. 	// if there is a height, width, and imagePNG function

    288. 

  288. 	if(($category['height'] != null) && ($category['width'] != null) && (function_exists('ImagePNG'))) {

    289. 

  289. 		$image_path = "index.php?productid=".$product_id."&amp;thumbnail=".$use_thumbnail_image."&amp;width=".$category['width']."&amp;height=".$category['height']."";

    290. 

  290. 	} else {

    291. 

  291. 		$image_path = WPSC_THUMBNAIL_URL.$image_name;

    292. 

  292. 		if(is_ssl()) {

    293. 

  293. 			$image_path = str_replace("http://", "https://", $image_path);

    294. 

  294. 		}

    295. 

  295. 	}

    296. 

  296.   return $image_path;

    297. 

  297. }

    298. 

  298. 

    299. 

  299. 

    300. 

  300. /* 19-02-09

    301. 

  301.  * add cart button function used for php template tags and shortcodes

    302. 

  302. */

    303. 

  303. function wpsc_add_to_cart_button($product_id, $replaced_shortcode = false) {

    304. 

  304. 	global $wpdb;

    305. 

  305. 	if ($product_id > 0){

    306. 

  306. 		if(function_exists('wpsc_theme_html')) {

    307. 

  307. 			$product = $wpdb->get_row("SELECT * FROM ".WPSC_TABLE_PRODUCT_LIST." WHERE id = ".$product_id." LIMIT 1", ARRAY_A);

    308. 

  308. 			//this needs the results from the product_list table passed to it, does not take just an ID

    309. 

  309. 			$wpsc_theme = wpsc_theme_html($product);

    310. 

  310. 		}

    311. 

  311. 		

    312. 

  312. 		// grab the variation form fields here

    313. 

  313. 		$variations_processor = new nzshpcrt_variations;         

    314. 

  314. 		$variations_output = $variations_processor->display_product_variations($product_id,false, false, false);

    315. 

  315. 

    316. 

  316. 		$output .= "<form onsubmit='submitform(this);return false;'  action='' method='post'>";

    317. 

  317. 		if($variations_output != '') { //will always be set, may sometimes be an empty string 

    318. 

  318. 			$output .= "           <p>".$variations_output."</p>";

    319. 

  319. 		}	

    320. 

  320. 		$output .= "<input type='hidden' name='wpsc_ajax_action' value='add_to_cart' />";

    321. 

  321. 		$output .= "<input type='hidden' name='product_id' value='".$product_id."' />";

    322. 

  322. 		$output .= "<input type='hidden' name='item' value='".$product_id."' />";

    323. 

  323. 		if(isset($wpsc_theme) && is_array($wpsc_theme) && ($wpsc_theme['html'] !='')) {

    324. 

  324. 				$output .= $wpsc_theme['html'];

    325. 

  325. 		} else {

    326. 

  326. 			$output .= "<input type='submit' id='product_".$product['id']."_submit_button' class='wpsc_buy_button' name='Buy' value='".__('Add To Cart', 'wpsc')."'  />";

    327. 

  327. 		}

    328. 

  328. 		$output .= '</form>';

    329. 

  329. 		if($replaced_shortcode == true) {

    330. 

  330. 			return $output;

    331. 

  331. 		} else {

    332. 

  332. 			echo $output;

    333. 

  333. 	 	}

    334. 

  334. 	} 

    335. 

  335. }

    336. 

  336. 

    337. 

  337. 

    338. 

  338.   

    339. 

  339. function wpsc_refresh_page_urls($content) {

    340. 

  340.  global $wpdb;

    341. 

  341.  $wpsc_pageurl_option['product_list_url'] = '[productspage]';

    342. 

  342.  $wpsc_pageurl_option['shopping_cart_url'] = '[shoppingcart]';

    343. 

  343.  $check_chekout = $wpdb->get_var("SELECT `guid` FROM `{$wpdb->posts}` WHERE `post_content` LIKE '%[checkout]%' AND `post_type` NOT IN('revision') LIMIT 1");

    344. 

  344.  if($check_chekout != null) {

    345. 

  345.    $wpsc_pageurl_option['checkout_url'] = '[checkout]';

    346. 

  346.    } else {

    347. 

  347.    $wpsc_pageurl_option['checkout_url'] = '[checkout]';

    348. 

  348.    }

    349. 

  349.  $wpsc_pageurl_option['transact_url'] = '[transactionresults]';

    350. 

  350.  $wpsc_pageurl_option['user_account_url'] = '[userlog]';

    351. 

  351.  $changes_made = false;

    352. 

  352.  foreach($wpsc_pageurl_option as $option_key => $page_string) {

    353. 

  353.    $post_id = $wpdb->get_var("SELECT `ID` FROM `{$wpdb->posts}` WHERE `post_type` IN('page','post') AND `post_content` LIKE '%$page_string%' AND `post_type` NOT IN('revision') LIMIT 1");

    354. 

  354.    $the_new_link = get_permalink($post_id);

    355. 

  355.    if(stristr(get_option($option_key), "https://")) {

    356. 

  356.      $the_new_link = str_replace('http://', "https://",$the_new_link);

    357. 

  357.    }    

    358. 

  358.    update_option($option_key, $the_new_link);

    359. 

  359.   }

    360. 

  360.  return $content;

    361. 

  361. }

    362. 

  362.   

    363. 

  363. function wpsc_product_permalinks($rewrite_rules) {

    364. 

  364. 	global $wpdb, $wp_rewrite;

    365. 

  365. 

    366. 

  366. 	$page_details = $wpdb->get_row("SELECT * FROM `".$wpdb->posts."` WHERE `post_content` LIKE '%[productspage]%' AND `post_type` NOT IN('revision') LIMIT 1", ARRAY_A);

    367. 

  367. 	$is_index = false;

    368. 

  368. 	if((get_option('page_on_front') == $page_details['ID']) && (get_option('show_on_front') == 'page')) {

    369. 

  369. 		$is_index = true;

    370. 

  370. 	}

    371. 

  371. 

    372. 

  372. 	$first_post_name = $page_details['post_name'];

    373. 

  373. 	$page_name_array[] = $page_details['post_name'];

    374. 

  374. 	if($page_details['post_parent'] > 0) {

    375. 

  375. 		$count = 0;

    376. 

  376. 		while(($page_details['post_parent'] > 0) && ($count <= 20)) {

    377. 

  377. 			$page_details = $wpdb->get_row("SELECT * FROM `".$wpdb->posts."` WHERE `ID` IN('{$page_details['post_parent']}') AND `post_type` NOT IN('revision') LIMIT 1", ARRAY_A);

    378. 

  378. 			$page_name_array[] = $page_details['post_name'];

    379. 

  379. 			$count ++;

    380. 

  380. 		}

    381. 

  381. 	}

    382. 

  382. 

    383. 

  383. 	$page_name_array = array_reverse($page_name_array);

    384. 

  384. 	$page_name = implode("/",$page_name_array);

    385. 

  385. 		

    386. 

  386. 	if(!function_exists('wpsc_rewrite_categories')) {	 // to stop this function from being declared multiple times

    387. 

  387. 		  /*

    388. 

  388. 		   * This is the function for making the e-commerce rewrite rules, it is recursive

    389. 

  389. 		  */

    390. 

  390. 		function wpsc_rewrite_categories($page_name, $id = null, $level = 0, $parent_categories = array(), $is_index = false) {

    391. 

  391. 			global $wpdb,$category_data;

    392. 

  392. 			if($is_index == true) {

    393. 

  393. 				$rewrite_page_name = '';

    394. 

  394. 			} else {

    395. 

  395. 				$rewrite_page_name = $page_name.'/';

    396. 

  396. 			}

    397. 

  397. 

    398. 

  398. 			if(is_numeric($id)) {

    399. 

  399. 				$category_sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active`='1' AND `category_parent` = '".$id."' ORDER BY `id`";

    400. 

  400. 				$category_list = $wpdb->get_results($category_sql,ARRAY_A);

    401. 

  401. 			}	else {

    402. 

  402. 				$category_sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active`='1' AND `category_parent` = '0' ORDER BY `id`";

    403. 

  403. 				$category_list = $wpdb->get_results($category_sql,ARRAY_A);

    404. 

  404. 			}

    405. 

  405. 			if($category_list != null)	{

    406. 

  406. 				foreach($category_list as $category) {

    407. 

  407. 					if($level === 0) {

    408. 

  408. 						$parent_categories = array();

    409. 

  409. 					}

    410. 

  410. 					$parent_categories[] = $category['nice-name'];

    411. 

  411. 					$new_rules[($rewrite_page_name.implode($parent_categories,"/").'/?$')] = 'index.php?pagename='.$page_name.'&category_id='.$category['id'];

    412. 

  412. 					$new_rules[($rewrite_page_name.implode($parent_categories,"/").'/(.+?)/?$')] = 'index.php?pagename='.$page_name.'&category_id='.$category['id'].'&product_url_name=$matches[1]';

    413. 

  413. 					$new_rules[($rewrite_page_name.implode($parent_categories,"/").'/page/([0-9]+)/?$')] = 'index.php?pagename='.$page_name.'&category_id='.$category['id'].'&wpsc_page=$matches[1]';

    414. 

  414. 					// recurses here

    415. 

  415. 					$sub_rules = wpsc_rewrite_categories($page_name, $category['id'], ($level+1), $parent_categories, $is_index);

    416. 

  416. 					array_pop($parent_categories);

    417. 

  417. 					$new_rules = array_merge((array)$new_rules, (array)$sub_rules);

    418. 

  418. 				}

    419. 

  419. 			}

    420. 

  420. 			return $new_rules;

    421. 

  421. 		}

    422. 

  422. 	}

    423. 

  423. 	$new_rules = wpsc_rewrite_categories($page_name, null, 0, null, $is_index);

    424. 

  424. 	$new_rules = array_reverse((array)$new_rules);

    425. 

  425. 

    426. 

  426. 	$new_rules[($first_post_name.'/page/([0-9]+)/?$')] = 'index.php?pagename='.$page_name.'&wpsc_page=$matches[1]';

    427. 

  427. 	$new_rules[$page_name.'/tag/([A-Za-z0-9\-]+)?$'] = 'index.php?pagename='.$page_name.'&ptag=$matches[1]';

    428. 

  428. 	$new_rewrite_rules = array_merge((array)$new_rules,(array)$rewrite_rules);

    429. 

  429. 	return $new_rewrite_rules;

    430. 

  430. }

    431. 

  431. 

    432. 

  432. 

    433. 

  433. function wpsc_query_vars($vars) {

    434. 

  434. 	//   $vars[] = "product_category";

    435. 

  435. 	//   $vars[] = "product_name";

    436. 

  436.   $vars[] = "category_id";

    437. 

  437.   $vars[] = "product_url_name";

    438. 

  438.   $vars[] = "wpsc_page";

    439. 

  439.   return $vars;

    440. 

  440.   }

    441. 

  441. 

    442. 

  442. add_filter('query_vars', 'wpsc_query_vars');

    443. 

  443. 

    444. 

  444. // using page_rewrite_rules makes it so that odd permalink structures like /%category%/%postname%.htm do not override the plugin permalinks.

    445. 

  445. add_filter('page_rewrite_rules', 'wpsc_product_permalinks');

    446. 

  446. 

    447. 

  447. 

    448. 

  448. 

    449. 

  449. 

    450. 

  450. /**

    451. 

  451. * wpsc_obtain_the_title function, for replaacing the page title with the category or product

    452. 

  452. * @return string - the new page title

    453. 

  453. */

    454. 

  454. function wpsc_obtain_the_title() {

    455. 

  455.   global $wpdb, $wp_query, $wpsc_title_data;

    456. 

  456.   $output = null;

    457. 

  457. 

    458. 

  458. 	if(is_numeric($wp_query->query_vars['category_id'])) {

    459. 

  459. 	  $category_id = $wp_query->query_vars['category_id'];

    460. 

  460. 	} else if($_GET['category']) {

    461. 

  461. 		$category_id = absint($_GET['category']);

    462. 

  462. 	}

    463. 

  463. 	if($category_id > 0) {

    464. 

  464. 	  if(isset($wpsc_title_data['category'][$category_id])) {

    465. 

  465. 			$output = $wpsc_title_data['category'][$category_id];

    466. 

  466. 	  } else {

    467. 

  467. 			$output = $wpdb->get_var("SELECT `name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `id`='{$category_id}' LIMIT 1");

    468. 

  468. 			$wpsc_title_data['category'][$category_id] = $output;

    469. 

  469. 		}

    470. 

  470. 	}

    471. 

  471. 	if(isset($wp_query->query_vars['product_url_name']) || is_numeric($_GET['product_id'])) {

    472. 

  472. 	  $product_name = $wp_query->query_vars['product_url_name'];

    473. 

  473. 	  if(isset($wpsc_title_data['product'][$product_name])) {

    474. 

  474. 	    $product_list = array();

    475. 

  475. 	    $full_product_name = $wpsc_title_data['product'][$product_name];

    476. 

  476. 	  } else if($product_name != '') {

    477. 

  477. 			$product_id = $wpdb->get_var("SELECT `product_id` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `meta_key` IN ( 'url_name' ) AND `meta_value` IN ( '{$wp_query->query_vars['product_url_name']}' ) ORDER BY `id` DESC LIMIT 1");

    478. 

  478. 			$full_product_name = $wpdb->get_var("SELECT `name` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='{$product_id}' LIMIT 1");

    479. 

  479. 			$wpsc_title_data['product'][$product_name] = $full_product_name;

    480. 

  480. 		} else {

    481. 

  481. 		  $product_id = absint($_GET['product_id']);

    482. 

  482. 			$product_name = $wpdb->get_var("SELECT `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `meta_key` IN ( 'url_name' ) AND `product_id` IN ( '{$product_id}' ) LIMIT 1");

    483. 

  483. 			

    484. 

  484. 			$full_product_name = $wpdb->get_var("SELECT `name` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='{$product_id}' LIMIT 1");

    485. 

  485. 			$wpsc_title_data['product'][$product_name] = $full_product_name;

    486. 

  486. 		}

    487. 

  487.   }

    488. 

  488. 

    489. 

  489.   //exit("<pre>".print_r($wp_query,true)."</pre>");

    490. 

  490.   if(isset($full_product_name ) && ($full_product_name != null)) {

    491. 

  491.   	$output = htmlentities(stripslashes($full_product_name), ENT_QUOTES, 'UTF-8');

    492. 

  492.   }

    493. 

  493. 	return $output;

    494. 

  494. }

    495. 

  495.  

    496. 

  496. function wpsc_obtain_the_description() {

    497. 

  497.   global $wpdb, $wp_query, $wpsc_title_data;

    498. 

  498.   $output = null;

    499. 

  499.   //exit("<pre>".print_r($wp_query,true)."</pre>");

    500. 

  500.   

    501. 

  501. 	if(is_numeric($wp_query->query_vars['category_id'])) {

    502. 

  502. 	  $category_id = $wp_query->query_vars['category_id'];

    503. 

  503. 	} else if($_GET['category']) {

    504. 

  504. 		$category_id = absint($_GET['category']);

    505. 

  505. 	}

    506. 

  506. 	

    507. 

  507. 	if(is_numeric($category_id)) {

    508. 

  508. 		$output = $wpdb->get_var("SELECT `description` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `id`='{$category_id}' LIMIT 1");

    509. 

  509. 	}

    510. 

  510. 

    511. 

  511. 	

    512. 

  512. 	if(isset($wp_query->query_vars['product_url_name'])) {

    513. 

  513. 	  $product_name = $wp_query->query_vars['product_url_name'];

    514. 

  514. 		$product_id = $wpdb->get_var("SELECT `product_id` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `meta_key` IN ( 'url_name' ) AND `meta_value` IN ( '{$wp_query->query_vars['product_url_name']}' ) ORDER BY `id` DESC LIMIT 1");

    515. 

  515. 		$output = $wpdb->get_var("SELECT `description` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='{$product_id}' LIMIT 1");

    516. 

  516.   } else if(is_numeric($_GET['product_id']))  {

    517. 

  517. 		$product_id = absint($_GET['product_id']);

    518. 

  518. 		$output = $wpdb->get_var("SELECT `description` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='{$product_id}' LIMIT 1");

    519. 

  519. 	}

    520. 

  520. 	return $output;

    521. 

  521. }

    522. 

  522. 

    523. 

  523. 

    524. 

  524. function wpsc_replace_the_title($input) {

    525. 

  525.   global $wpdb, $wp_query;

    526. 

  526. 	$output = wpsc_obtain_the_title();

    527. 

  527. 	if($output != null) {

    528. 

  528. 		$backtrace = debug_backtrace();

    529. 

  529. 		if($backtrace[3]['function'] == 'get_the_title') {

    530. 

  530. 			return $output;

    531. 

  531. 		}

    532. 

  532. 	}

    533. 

  533. 	return $input;

    534. 

  534. }

    535. 

  535. 

    536. 

  536. function wpsc_replace_wp_title($input) {

    537. 

  537.   global $wpdb, $wp_query;

    538. 

  538. 	$output = wpsc_obtain_the_title();

    539. 

  539. 	if($output != null) {

    540. 

  540. 		return $output;

    541. 

  541. 	}

    542. 

  542. 	return $input;

    543. 

  543. }

    544. 

  544. 

    545. 

  545. function wpsc_replace_bloginfo_title($input, $show) {

    546. 

  546.   global $wpdb, $wp_query;

    547. 

  547.   if($show == 'description') {

    548. 

  548. 		$output = wpsc_obtain_the_title();

    549. 

  549. 		if($output != null) {

    550. 

  550. 			return $output;

    551. 

  551. 		}

    552. 

  552. 	}

    553. 

  553. 	return $input;

    554. 

  554. }

    555. 

  555.  

    556. 

  556. if(get_option('wpsc_replace_page_title') == 1) {

    557. 

  557.   add_filter('the_title', 'wpsc_replace_the_title', 10, 2);

    558. 

  558.   add_filter('wp_title', 'wpsc_replace_wp_title', 10, 2);

    559. 

  559. 	//add_filter('bloginfo', 'wpsc_replace_bloginfo_title', 10, 2);

    560. 

  560. }

    561. 

  561. 

    562. 

  562. ?>
    563.