All pastes #918174 Raw Edit

Untitled

public php v1 · immutable
#918174 ·published 2008-02-25 23:20 UTC
rendered paste body
<p>Products</p><p>&nbsp;</p><?php virtual('/alpweb-new/Connections/rsZenCart.php'); ?><table border="1">  <tr>    <td>products_id</td>    <td>products_type</td>    <td>products_quantity</td>    <td>products_model</td>    <td>products_image</td>    <td>products_price</td>    <td>products_virtual</td>    <td>products_date_added</td>    <td>products_last_modified</td>    <td>products_date_available</td>    <td>products_weight</td>    <td>products_status</td>    <td>products_tax_class_id</td>    <td>manufacturers_id</td>    <td>products_ordered</td>    <td>products_quantity_order_min</td>    <td>products_quantity_order_units</td>    <td>products_priced_by_attribute</td>    <td>product_is_free</td>    <td>product_is_call</td>    <td>products_quantity_mixed</td>    <td>product_is_always_free_shipping</td>    <td>products_qty_box_status</td>    <td>products_quantity_order_max</td>    <td>products_sort_order</td>    <td>products_discount_type</td>    <td>products_discount_type_from</td>    <td>products_price_sorter</td>    <td>master_categories_id</td>    <td>products_mixed_discount_quantity</td>    <td>metatags_title_status</td>    <td>metatags_products_name_status</td>    <td>metatags_model_status</td>    <td>metatags_price_status</td>    <td>metatags_title_tagline_status</td>    <td>products_id</td>    <td>language_id</td>    <td>products_name</td>    <td>products_description</td>    <td>products_url</td>    <td>products_viewed</td>  </tr>  <?php do { ?>    <tr>      <td><?php echo $row_products['products_id']; ?></td>      <td><?php echo $row_products['products_type']; ?></td>      <td><?php echo $row_products['products_quantity']; ?></td>      <td><?php echo $row_products['products_model']; ?></td>      <td><?php echo $row_products['products_image']; ?></td>      <td><?php echo $row_products['products_price']; ?></td>      <td><?php echo $row_products['products_virtual']; ?></td>      <td><?php echo $row_products['products_date_added']; ?></td>      <td><?php echo $row_products['products_last_modified']; ?></td>      <td><?php echo $row_products['products_date_available']; ?></td>      <td><?php echo $row_products['products_weight']; ?></td>      <td><?php echo $row_products['products_status']; ?></td>      <td><?php echo $row_products['products_tax_class_id']; ?></td>      <td><?php echo $row_products['manufacturers_id']; ?></td>      <td><?php echo $row_products['products_ordered']; ?></td>      <td><?php echo $row_products['products_quantity_order_min']; ?></td>      <td><?php echo $row_products['products_quantity_order_units']; ?></td>      <td><?php echo $row_products['products_priced_by_attribute']; ?></td>      <td><?php echo $row_products['product_is_free']; ?></td>      <td><?php echo $row_products['product_is_call']; ?></td>      <td><?php echo $row_products['products_quantity_mixed']; ?></td>      <td><?php echo $row_products['product_is_always_free_shipping']; ?></td>      <td><?php echo $row_products['products_qty_box_status']; ?></td>      <td><?php echo $row_products['products_quantity_order_max']; ?></td>      <td><?php echo $row_products['products_sort_order']; ?></td>      <td><?php echo $row_products['products_discount_type']; ?></td>      <td><?php echo $row_products['products_discount_type_from']; ?></td>      <td><?php echo $row_products['products_price_sorter']; ?></td>      <td><?php echo $row_products['master_categories_id']; ?></td>      <td><?php echo $row_products['products_mixed_discount_quantity']; ?></td>      <td><?php echo $row_products['metatags_title_status']; ?></td>      <td><?php echo $row_products['metatags_products_name_status']; ?></td>      <td><?php echo $row_products['metatags_model_status']; ?></td>      <td><?php echo $row_products['metatags_price_status']; ?></td>      <td><?php echo $row_products['metatags_title_tagline_status']; ?></td>      <td><?php echo $row_products['products_id']; ?></td>      <td><?php echo $row_products['language_id']; ?></td>      <td><?php echo $row_products['products_name']; ?></td>      <td><?php echo $row_products['products_description']; ?></td>      <td><?php echo $row_products['products_url']; ?></td>      <td><?php echo $row_products['products_viewed']; ?></td>    </tr>    <?php } while ($row_products = mysql_fetch_assoc($products)); ?></table><?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") {  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);  switch ($theType) {    case "text":      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";      break;        case "long":    case "int":      $theValue = ($theValue != "") ? intval($theValue) : "NULL";      break;    case "double":      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";      break;    case "date":      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";      break;    case "defined":      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;      break;  }  return $theValue;}}$maxRows_products = 10;$pageNum_products = 0;if (isset($_GET['pageNum_products'])) {  $pageNum_products = $_GET['pageNum_products'];}$startRow_products = $pageNum_products * $maxRows_products;mysql_select_db($database_rsZenCart, $rsZenCart);$query_products = "SELECT * FROM products, products_description";$query_limit_products = sprintf("%s LIMIT %d, %d", $query_products, $startRow_products, $maxRows_products);$products = mysql_query($query_limit_products, $rsZenCart) or die(mysql_error());$row_products = mysql_fetch_assoc($products);if (isset($_GET['totalRows_products'])) {  $totalRows_products = $_GET['totalRows_products'];} else {  $all_products = mysql_query($query_products);  $totalRows_products = mysql_num_rows($all_products);}$totalPages_products = ceil($totalRows_products/$maxRows_products)-1;mysql_free_result($products);?>