Changeset 27743 for extensions/MyPiwiShop/include/public_events.inc.php
- Timestamp:
- Mar 12, 2014, 11:28:47 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/MyPiwiShop/include/public_events.inc.php
r27568 r27743 1 1 <?php 2 2 defined('MPS_PATH') or die('Hacking attempt!'); 3 4 5 6 3 7 4 /* … … 100 97 ORDER BY `order` 101 98 ;'; 102 103 99 $result = pwg_query($query); 104 100 $num_rows = pwg_db_num_rows($result); 105 106 107 if ($num_rows != 0) 108 { 101 if ($num_rows != 0){ 109 102 while($row = pwg_db_fetch_assoc($result)){ 110 103 $product[$row['product']] = $row['product'].' '. $row['price'].' '. $config['currency']; 111 112 104 $price[] = $row['price']; 113 } 114 105 } 115 106 116 107 117 108 $query='SELECT pi.product_id, po.product_id, p.price, p.product, o.name, o.type, o.requi, o.order, po.opt_id, ov.val 118 109 FROM '.MPS_PROD_IMG_TABLE.' AS pi 119 LEFT JOIN '.MPS_PRODUCT_TABLE.' A sp ON p.id = pi.product_id110 LEFT JOIN '.MPS_PRODUCT_TABLE.' AS p ON p.id = pi.product_id 120 111 LEFT JOIN '.MPS_PROD_OPT_TABLE.' AS po ON po.product_id = p.id 121 112 LEFT JOIN '.MPS_OPTION_TABLE.' AS o ON o.id = po.opt_id … … 123 114 WHERE image_id = '.$image_id .' 124 115 AND po.opt_id IS NOT NULL 125 ORDER BY o.order116 ;'; 126 117 127 ;'; 128 $result = pwg_query($query); 118 $result = pwg_query($query); 129 119 while($row = pwg_db_fetch_assoc($result)){ 130 120 {
Note: See TracChangeset
for help on using the changeset viewer.