Si tratta di un blog legato alle vicende della Ferrovia Sangritana che attraversa il mio paese di origine.
Per chi fosse interessato ad argomenti di tecnica ferroviaria, mobilità sostenibile, etc. mi può seguire qui:
Un saluto
Wsc
A blog over an IT Developer
<?php $arjunaOptions = arjuna_get_options(); ?><?php get_header(); ?><div class="contentArea"><?php// take search terms and escape them$s = $wpdb->escape(stripslashes($wp_query->query_vars['s']));$sql = "SELECT `".$wpdb->prefix."wpsc_product_list`.* , `".$wpdb->prefix."wpsc_product_images`.imageFROM `".$wpdb->prefix."wpsc_product_list`INNER JOIN wp_wpsc_product_images ON (".$wpdb->prefix."wpsc_product_images.product_id = ".$wpdb->prefix."wpsc_product_list.id AND ".$wpdb->prefix."wpsc_product_images.image_order = 0)WHERE (`".$wpdb->prefix."wpsc_product_list`.`name` LIKE '%".$s."%' OR `".$wpdb->prefix."wpsc_product_list`.`description` LIKE '%".$s."%')";// echo $sql;$product_list = $wpdb->get_results($sql,ARRAY_A);if (!$product_list) {$output = "<p>There are no products found with your search term <i>".$s."</i>.";}else {$output = "<div id='search_list_products'>\n\r";foreach((array)$product_list as $product) {$output .= "<div class='search_product'>\n\r";$output .= "<a href='".wpsc_product_url($product['id'])."'>";if($product['image'] != '') {$output .= "<img src='".WPSC_THUMBNAIL_URL.$product['image']."' title='".$product['name']."' alt='".$product['name']."' />\n\r";$output .= "<p>\n\r";$output .= stripslashes($product['name'])."<br />";$output .= "<span class='front_page_price'>\n\r";if($product['special']==1) {$output .= "<span class='oldprice'>".nzshpcrt_currency_display($product['price'], $product['notax'])."</span><br />\n\r";$output .= nzshpcrt_currency_display(($product['price'] - $product['special_price']), $product['notax'],false,$product['id']);} else {$output .= "".nzshpcrt_currency_display($product['price'], $product['notax']);}$output .= "</span>\n\r";$output .= "</p>\n\r";}$output .= "</a>";$output .= "</div>\n\r";}$output .= "</div>\n\r";$output .= "<br style='clear: left;'>\n\r";} // elseecho $output; ?></div><?php get_sidebar(); ?><?php get_footer(); ?>
CREATE DEFINER=`root`@`localhost` FUNCTION `RowIdGen`() RETURNS CHAR(30) CHARSET latin1DETERMINISTICBEGINRETURN CONCAT('PREF',DATE_FORMAT(SYSDATE(),'%Y%m%d%H%i%s'),LPAD(FLOOR(1 + RAND() * 999999),7,0),LPAD(@numero := IFNULL(@numero,0) + 1,5,0));END$$DELIMITER ;