1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91
92. 92

<?php
/*
  $Id: specials.php,v 1.1.1.1 2004/03/04 23:42:27 ccwjr Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  CRE Loaded , Open Source E-Commerce Solutions
  http://www.creloaded.com
 
  Chain Reaction Works, Inc
  Portions: Copyright © 2005 - 2006 Chain Reaction Works, Inc.
  
  Last Modified by $Author$
  Last Modifed on : $Date$
  Latest Revision : $Revision:$


  Released under the GNU General Public License
*/

  if(!tep_session_is_registered('sppc_customer_group_id')) {
  $customer_group_id = 'G';
  } else {
   $customer_group_id = $sppc_customer_group_id;
  }

   $random_product25 = tep_db_query("select distinct
   p.products_id, 
   pd.products_name, 
   IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price,
   p.products_tax_class_id, 
   p.products_image, 
   s.specials_new_products_price 
   from " . TABLE_PRODUCTS . " p 
    left join " . TABLE_PRODUCTS_GROUPS . " pg on p.products_id = pg.products_id and pg.customers_group_id like '%" . $customer_group_id . "%',
    " . TABLE_PRODUCTS_DESCRIPTION . " pd,
    " . TABLE_SPECIALS . " s 
   where 
   p.products_status = '1' 
   and p.products_id = s.products_id 
   and pd.products_id = s.products_id 
   and pd.language_id = '" . (int)$languages_id . "' 
   and s.status = '1' 
   and p.products_group_access like '%". $customer_group_id."%'
   order by rand(), s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
 
  
  $random_product24_side_row = tep_db_num_rows($random_product25);
     if ($random_product24_side_row > 0){

// EOF Separate Price per Customer
//Eversun mod end for sppc and qty price breaks
?>
<!-- d specials //-->
          <tr>
            <td>
<?php

while ($product_specials22 = tep_db_fetch_array($random_product25)){
  $product_specials22_id = $product_specials22['products_id'];
  $product_specials22_image = tep_get_products_image($product_specials22['products_id']);
  $product_specials22_name = tep_get_products_name($product_specials22['products_id']);

  $pf->loadProduct($product_specials22['products_id'],$languages_id);
        $special_random_price = $pf->getPriceStringShort();
}
    $info_box_contents = array();
    $info_box_contents[] = array('text'  => '<font color="' . $font_color . '">' . BOX_HEADING_SPECIALS . '</font>');
    new infoBoxHeading($info_box_contents, tep_href_link(FILENAME_SPECIALS));

    $info_box_contents = array();
    $info_box_contents[] = array('align' => 'center',
                                 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials22_id) . '">' . tep_image(DIR_WS_IMAGES . $product_specials22_image, $product_specials22_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials22_id) . '">' . $product_specials22_name . '</a><br>' . $special_random_price);

    new infoBox($info_box_contents);
     if (TEMPLATE_INCLUDE_FOOTER =='true'){
         $info_box_contents = array();
          $info_box_contents[] = array('align' => 'left',
                                        'text'  => tep_draw_separator('pixel_trans.gif', '100%', '1')
                                      );
     new infoboxFooter($info_box_contents);
 }
?>
            </td>
          </tr>
<!-- d specials_eof //-->
<?php
  }
?>