chrometweaks.org

"REALLY FREE" java iPage web hosting?

Click Here To View All Answers...


First off, "REALLY FREE" java iPage web hosting? Many thanks for any comment. Second question.. I screwed up. Never made abackup of the database in admin pannel and screwed up the files..

I have th ebackup of my html folder from ftp in my hard drive. can I replace the database from that folder to the site. where is it located. any idea. plz help... I m up all night. urgent urgent..

Comments (6)

That's a good question. I'm not sure what is the right answer. I'll do some Googling and get back to you if I find an useful answer. You should email the people at iPage as they probably could answer your iPage question..

Comment #1

I just got a reply. they dont. do you know if I have the databse stored in the ftp folder?..

Comment #2

The database doesnt get stored in the ftp folder, only in the admin/backups or your local system if you have backed it up there..

Comment #3

Your error lies here in product_info.php.

And () and.

You cannot have it this way. remove and() from your statement.

Just dont go jumping the gun on restoring a database when it isnt a database problem. just a simple code statement error.

This post has been edited by.

Mibble.

: 25 October 2004, 05:14..

Comment #4

As you asked. the file..

<?php.

/*.

 $Id: family_products.php,v 3.30 2003/09/04 18:04:58 blueline Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2003 osCommerce.

 Released under the GNU General Public License.

*/.

?>.

<! family_products //>.

<?php.

//This is where the code for the infoBox starts:.

If ((FAMILY_DISPLAY_TYPE == 'Box') && (FAMILY_DISPLAY_FORMAT == 'Seperate')){.

$family_name_query = tep_db_query("select pf.family_id, f.family_name from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_FAMILIES" f where pf.family_id = f.family_id and pf.products_id = '"$products_id"'");.

While ($family_results = tep_db_fetch_array($family_name_query)) {.

 $info_box_contents = array();.

 .

 if (FAMILY_HEADER_FORMAT == 'Family Name') {.

 $info_box_contents[] = array('text' => $family_results['family_name']);.

 } else {.

 if (FAMILY_HEADER_TEXT == '') {.

 $info_box_contents[] = array('text' => TABLE_HEADING_FAMILY_PRODUCTS);.

 } else {.

 $info_box_contents[] = array('text' => FAMILY_HEADER_TEXT);.

 }.

 }.

$family_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and pf.family_id = '"(int)$family_results['family_id']"' and p.products_id = pf.products_id and p.products_id != '"$products_id"'"$where_clause2" order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

 if (tep_db_num_rows($family_query) > 0) {.

 new contentBoxHeading($info_box_contents);.

 $row = 0;.

 $col = 0;.

 $info_box_contents = array();.

 $where_clause2 = '';.

 while ($family = tep_db_fetch_array($family_query)) {.

$where_clause2 .= " and p.products_id != '"$family['products_id']"'";.

   $family['products_name'] = tep_get_products_name($family['products_id']);.

$info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$family['products_id'])'">'tep_image(DIR_WS_IMAGES$family['products_image'], $family['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$family['products_id'])'">'$family['products_name']'</a><br>'$currencies->display_price($family['products_price'], tep_get_tax_rate($family['products_tax_class_id'])));.

   $col ++;.

   if ($col > 2) {.

     $col = 0;.

     $row ++;.

   }.

 }.

 new contentBox($info_box_contents);.

Echo '<p>';.

}.

}.

}.

If ((FAMILY_DISPLAY_TYPE == 'Box') && (FAMILY_DISPLAY_FORMAT == 'Random')){.

$family_name_query = tep_db_query("select family_id from "TABLE_PRODUCTS_FAMILIES" where products_id = '"$products_id"'");.

 $info_box_contents = array();.

 if (FAMILY_HEADER_TEXT == '') {.

 $info_box_contents[] = array('text' => TABLE_HEADING_FAMILY_PRODUCTS);.

 } else {.

 $info_box_contents[] = array('text' => FAMILY_HEADER_TEXT);.

 }.

$family_name_num_rows = tep_db_num_rows($family_name_query);.

$num_of_rows_less_one = $family_name_num_rows - '1';.

If (tep_db_num_rows($family_name_query) == '1') {.

$family_results = tep_db_fetch_array($family_name_query);.

$family_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and pf.family_id = '"(int)$family_results['family_id']"' and p.products_id = pf.products_id and p.products_id != '"$products_id"' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

} else {.

$where_clause = '';.

For ($i=0; $i < tep_db_num_rows($family_name_query); $i++) {.

$family_results = tep_db_fetch_array($family_name_query);.

If ($i < $num_of_rows_less_one) {.

$where_clause .= "(pf.family_id = '"$family_results['family_id']"') OR ";.

} else {.

$where_clause .= "(pf.family_id = '"$family_results['family_id']"')";.

}.

}.

$family_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and ("$where_clause") and p.products_id = pf.products_id and p.products_id != '"$products_id"' limit "MAX_DISPLAY_NEW_PRODUCTS);.

}.

 if (tep_db_num_rows($family_query) > 0) {.

 new contentBoxHeading($info_box_contents);.

 $row = 0;.

 $col = 0;.

 $info_box_contents = array();.

$where_clause2 = '';    .

   for ($i=0, $j=1; ($i < MAX_DISPLAY_NEW_PRODUCTS) && ($i < tep_db_num_rows($family_query)); $i++, $j++) {.

 if (tep_db_num_rows($family_name_query) == '1') {.

   $family = tep_random_select("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = pf.products_id and p.products_id != '"$products_id"'"$where_clause2);.

 } else {.

   $family = tep_random_select("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and ("$where_clause") and p.products_id = pf.products_id and p.products_id != '"$products_id"'"$where_clause2);.

 }.

 $where_clause2 .= " and p.products_id != '"$family['products_id']"'";.

   $family['products_name'] = tep_get_products_name($family['products_id']);.

$info_box_contents[$row][$col] = array('align' => 'center',.

                                          'params' => 'class="smallText" width="33%" valign="top"',.

                                          'text' => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$family['products_id'])'">'tep_image(DIR_WS_IMAGES$family['products_image'], $family['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a><br><a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$family['products_id'])'">'$family['products_name']'</a><br>'$currencies->display_price($family['products_price'], tep_get_tax_rate($family['products_tax_class_id'])));.

   $col ++;.

   if ($col > 2) {.

     $col = 0;.

     $row ++;.

   }.

 }.

 new contentBox($info_box_contents);.

Echo '<p>';.

}.

}.

?>.

<?php.

//This is where the code for the list starts:.

If ((FAMILY_DISPLAY_TYPE == 'List') && (FAMILY_DISPLAY_FORMAT == 'Seperate')){.

$family_name_query = tep_db_query("select pf.family_id, f.family_name from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_FAMILIES" f where pf.family_id = f.family_id and pf.products_id = '"$products_id"'");.

While ($family_results = tep_db_fetch_array($family_name_query)) {.

$family_query = tep_db_query("select distinct p.manufacturers_id, p.products_id, p.products_image, p.products_tax_class_id, p.products_price, s.specials_new_products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and pf.family_id = '"(int)$family_results['family_id']"' and p.products_id = pf.products_id and p.products_id != '"$products_id"'"$where_clause2" order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

   .

   $define_list = array('PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,.

                        'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,.

                        'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,.

                        'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);.

   asort($define_list);.

   $column_list = array();.

   reset($define_list);.

   while (list($key, $value) = each($define_list)) {.

     if ($value > 0) $column_list[] = $key;.

   }.

$list_box_contents = array();.

 if (tep_db_num_rows($family_query) > 0) {.

 if (FAMILY_HEADER_FORMAT == 'Family Name') {.

   $list_box_contents[0][0] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;'$family_results['family_name']'&nbsp;');.

 } else {.

 if (FAMILY_HEADER_TEXT == '') {.

   $list_box_contents[0][0] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;'TABLE_HEADING_FAMILY_PRODUCTS'&nbsp;');.

 } else {.

     $list_box_contents[0][0] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;'FAMILY_HEADER_TEXT'&nbsp;');.

 }.

 }.

 .

For($i=1; $i<4; $i++) {.

   $list_box_contents[0][$i] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;');.

}.

 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {.

   switch ($column_list[$col]) {.

     case 'PRODUCT_LIST_NAME':.

       $lc_text = TABLE_HEADING_PRODUCTS;.

       $lc_align = '';.

       break;.

     case 'PRODUCT_LIST_PRICE':.

       $lc_text = TABLE_HEADING_PRICE;.

       $lc_align = 'right';.

       break;.

     case 'PRODUCT_LIST_IMAGE':.

       $lc_text = TABLE_HEADING_IMAGE;.

       $lc_align = 'center';.

       break;.

     case 'PRODUCT_LIST_BUY_NOW':.

       $lc_text = TABLE_HEADING_BUY_NOW;.

       $lc_align = 'center';.

       break;.

   }.

   if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {.

     $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);.

   }.

   $list_box_contents[1][] = array('align' => $lc_align,.

                                   'params' => 'class="productListing-heading"',.

                                   'text' => '&nbsp;'$lc_text'&nbsp;');.

 }.

   $rows = 0;.

 $where_clause2 = '';.

   while ($listing = tep_db_fetch_array($family_query)) {.

$where_clause2 .= " and p.products_id != '"$listing['products_id']"'";.

   $listing['products_name'] = tep_get_products_name($listing['products_id']);.

     $rows++;.

     if (($rows/2) == floor($rows/2)) {.

       $list_box_contents[] = array('params' => 'class="productListing-even"');.

     } else {.

       $list_box_contents[] = array('params' => 'class="productListing-odd"');.

     }.

     $cur_row = sizeof($list_box_contents) - 1;.

     for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {.

       $lc_align = '';.

       switch ($column_list[$col]) {.

         case 'PRODUCT_LIST_NAME':.

           $lc_align = '';.

           if (isset($HTTP_GET_VARS['manufacturers_id'])) {.

             $lc_text = '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id='$HTTP_GET_VARS['manufacturers_id']'&products_id='$listing['products_id'])'">'$listing['products_name']'</a>';.

           } else {.

             $lc_text = '&nbsp;<a href="'tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath='$cPath'&' : '')'products_id='$listing['products_id'])'">'$listing['products_name']'</a>&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_PRICE':.

           $lc_align = 'right';.

           if (tep_not_null($listing['specials_new_products_price'])) {.

             $lc_text = '&nbsp;<s>' $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'</s>&nbsp;&nbsp;<span class="productSpecialPrice">'$currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'</span>&nbsp;';.

           } else {.

             $lc_text = '&nbsp;'$currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_IMAGE':.

           $lc_align = 'center';.

           if (isset($HTTP_GET_VARS['manufacturers_id'])) {.

             $lc_text = '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id='$HTTP_GET_VARS['manufacturers_id']'&products_id='$listing['products_id'])'">'tep_image(DIR_WS_IMAGES$listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a>';.

           } else {.

             $lc_text = '&nbsp;<a href="'tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath='$cPath'&' : '')'products_id='$listing['products_id'])'">'tep_image(DIR_WS_IMAGES$listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a>&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_BUY_NOW':.

           $lc_align = 'center';.

           $lc_text = '<a href="'tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action'))'action=buy_now&products_id='$listing['products_id'])'">'tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW)'</a>&nbsp;';.

           break;.

       }.

       $list_box_contents[$cur_row][] = array('align' => $lc_align,.

                                              'params' => 'class="productListing-data"',.

                                              'text'  => $lc_text);.

     }.

   }.

   new productListingBox($list_box_contents);.

}.

Echo '<p>';.

}.

}.

If ((FAMILY_DISPLAY_TYPE == 'List') && (FAMILY_DISPLAY_FORMAT == 'Random')) {.

$family_name_query = tep_db_query("select family_id from "TABLE_PRODUCTS_FAMILIES" where products_id = '"$products_id"'");.

$family_name_num_rows = tep_db_num_rows($family_name_query);.

$num_of_rows_less_one = $family_name_num_rows - '1';.

If (tep_db_num_rows($family_name_query) == '1') {.

$family_results = tep_db_fetch_array($family_name_query);.

$family_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and pf.family_id = '"(int)$family_results['family_id']"' and p.products_id = pf.products_id and p.products_id != '"$products_id"' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

} else {.

$where_clause = '';.

$where_clause2 = '';.

For ($i=0; $i < tep_db_num_rows($family_name_query); $i++) {.

$family_results = tep_db_fetch_array($family_name_query);.

If ($i < $num_of_rows_less_one) {.

$where_clause .= "(pf.family_id = '"$family_results['family_id']"') OR ";.

} else {.

$where_clause .= "(pf.family_id = '"$family_results['family_id']"')";.

}.

}.

$family_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS_FAMILIES" pf, "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where p.products_status = '1' and ("$where_clause") and p.products_id = pf.products_id and p.products_id != '"$products_id"' limit "MAX_DISPLAY_NEW_PRODUCTS);.

}.

   $define_list = array('PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,.

                        'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,.

                        'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,.

                        'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);.

   asort($define_list);.

   $column_list = array();.

   reset($define_list);.

   while (list($key, $value) = each($define_list)) {.

     if ($value > 0) $column_list[] = $key;.

   }.

$list_box_contents = array();.

 if (tep_db_num_rows($family_query) > 0) {.

 if (FAMILY_HEADER_TEXT == '') {.

   $list_box_contents[0][0] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;'TABLE_HEADING_FAMILY_PRODUCTS'&nbsp;');.

 } else {.

     $list_box_contents[0][0] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;'FAMILY_HEADER_TEXT'&nbsp;');.

 }.

 .

For($i=1; $i<4; $i++) {.

   $list_box_contents[0][$i] = array('align' => 'left',.

                                  'params' => 'class="productListing-heading"',.

                                  'text' => '&nbsp;');.

}.

 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {.

   switch ($column_list[$col]) {.

     case 'PRODUCT_LIST_NAME':.

       $lc_text = TABLE_HEADING_PRODUCTS;.

       $lc_align = '';.

       break;.

     case 'PRODUCT_LIST_PRICE':.

       $lc_text = TABLE_HEADING_PRICE;.

       $lc_align = 'right';.

       break;.

     case 'PRODUCT_LIST_IMAGE':.

       $lc_text = TABLE_HEADING_IMAGE;.

       $lc_align = 'center';.

       break;.

     case 'PRODUCT_LIST_BUY_NOW':.

       $lc_text = TABLE_HEADING_BUY_NOW;.

       $lc_align = 'center';.

       break;.

   }.

   if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {.

     $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);.

   }.

   $list_box_contents[1][] = array('align' => $lc_align,.

                                   'params' => 'class="productListing-heading"',.

                                   'text' => '&nbsp;'$lc_text'&nbsp;');.

 }.

   $rows = 0;.

   while ($listing = tep_db_fetch_array($family_query)) {.

   $listing['products_name'] = tep_get_products_name($listing['products_id']);.

     $rows++;.

     if (($rows/2) == floor($rows/2)) {.

       $list_box_contents[] = array('params' => 'class="productListing-even"');.

     } else {.

       $list_box_contents[] = array('params' => 'class="productListing-odd"');.

     }.

     $cur_row = sizeof($list_box_contents) - 1;.

     for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {.

       $lc_align = '';.

       switch ($column_list[$col]) {.

         case 'PRODUCT_LIST_NAME':.

           $lc_align = '';.

           if (isset($HTTP_GET_VARS['manufacturers_id'])) {.

             $lc_text = '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id='$HTTP_GET_VARS['manufacturers_id']'&products_id='$listing['products_id'])'">'$listing['products_name']'</a>';.

           } else {.

             $lc_text = '&nbsp;<a href="'tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath='$cPath'&' : '')'products_id='$listing['products_id'])'">'$listing['products_name']'</a>&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_PRICE':.

           $lc_align = 'right';.

           if (tep_not_null($listing['specials_new_products_price'])) {.

             $lc_text = '&nbsp;<s>' $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'</s>&nbsp;&nbsp;<span class="productSpecialPrice">'$currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'</span>&nbsp;';.

           } else {.

             $lc_text = '&nbsp;'$currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id']))'&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_IMAGE':.

           $lc_align = 'center';.

           if (isset($HTTP_GET_VARS['manufacturers_id'])) {.

             $lc_text = '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id='$HTTP_GET_VARS['manufacturers_id']'&products_id='$listing['products_id'])'">'tep_image(DIR_WS_IMAGES$listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a>';.

           } else {.

             $lc_text = '&nbsp;<a href="'tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath='$cPath'&' : '')'products_id='$listing['products_id'])'">'tep_image(DIR_WS_IMAGES$listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'</a>&nbsp;';.

           }.

           break;.

         case 'PRODUCT_LIST_BUY_NOW':.

           $lc_align = 'center';.

           $lc_text = '<a href="'tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action'))'action=buy_now&products_id='$listing['products_id'])'">'tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW)'</a>&nbsp;';.

           break;.

       }.

       $list_box_contents[$cur_row][] = array('align' => $lc_align,.

                                              'params' => 'class="productListing-data"',.

                                              'text'  => $lc_text);.

     }.

   }.

   new productListingBox($list_box_contents);.

}.

}.

?>.

<! family_products_eof //>.

Now the link of the contribution I am using..

Http://www.oscommerce.com/community/contri...l/search,family.

Thanks alot..

I have done everysingle step in the readme installation file and created the tables in the database. I really appreciate your concern. as you know the iPage site is down because of that so I really appreciate your quick fix reply..

The problem file is above, it has != a lot of time and I dunno what else is wrong. thanks..

Thanks.

Dan..

Comment #5

This isnt the file to look at, it is products_info.php..

Comment #6

<?php.

/*.

 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2003 osCommerce.

 Released under the GNU General Public License.

*/.

 require('includes/application_top.php');.

 require(DIR_WS_LANGUAGES$language'/'FILENAME_PRODUCT_INFO);.

 $product_check_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

 $product_check = tep_db_fetch_array($product_check_query);.

?>.

<! begin dynamic meta tags query >.

<?php.

$the_product_info_query = tep_db_query("select pd.language_id, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = '"(int)$HTTP_GET_VARS['products_id']"'"" and pd.language_id ='" (int)$languages_id"'");.

  $the_product_info = tep_db_fetch_array($the_product_info_query);.

$the_product_name = strip_tags ($the_product_info['products_name'], "");.

$the_product_description = strip_tags ($the_product_info['products_description'], "");.

$the_product_model = strip_tags ($the_product_info['products_model'], "");.

?>.

<?php.

$the_manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from "TABLE_MANUFACTURERS" m left join "TABLE_MANUFACTURERS_INFO" mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '"(int)$languages_id"'), "TABLE_PRODUCTS" p  where p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and p.manufacturers_id = m.manufacturers_id");.

  $the_manufacturers = tep_db_fetch_array($the_manufacturer_query);.

?>.

<! end dynamic meta tags query >.

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">.

<html <?php echo HTML_PARAMS; ?>>.

<head>.

<! begin dynamic meta tags >.

<title><?php echo TITLE ?>: <?php echo $the_product_name; ?></title>.

<meta name="keywords" content="<?php echo TITLE ?>, <?php echo $the_product_name; ?>, <?php echo $the_product_model; ?>, <?php echo $the_manufacturers['manufacturers_name']; ?>">.

<meta name="description" content="<?php echo $the_product_description","$the_product_name","$the_manufacturers['manufacturers_name']; ?>">.

<! end dynamic meta tags >.

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">.

<title><?php echo TITLE; ?></title>.

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER)DIR_WS_CATALOG; ?>">.

<link rel="stylesheet" type="text/css" href="stylesheet.css">.

<script language="javascript"><!.

Function popupWindow(url) {.

 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res.

Izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le.

Ft=150').

}.

//></script>.

</head>.

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">.

<! header //>.

<?php require(DIR_WS_INCLUDES'header.php'); ?>.

<! header_eof //>.

<! body //>.

<table border="0" width="100%" cellspacing="3" cellpadding="3">.

 <tr>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! left_navigation //>.

<?php require(DIR_WS_INCLUDES'column_left.php'); ?>.

<! left_navigation_eof //>.

   </table></td>.

<! body_text //>.

   <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action'))'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">.

<?php.

 if ($product_check['total'] < 1) {.

?>.

     <tr>.

       <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               <td align="right"><?php echo '<a href="'tep_href_link(FILENAME_DEFAULT)'">'tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE)'</a>'; ?></td>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

<?php.

 } else {.

   $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_info, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

   $product_info = tep_db_fetch_array($product_info_query);.

   tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

   if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

     $products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

   } else {.

     $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

   }.

   if (tep_not_null($product_info['products_model'])) {.

     $products_name = $product_info['products_name']'<br><span class="smallText">['$product_info['products_model']']</span>';.

   } else {.

     $products_name = $product_info['products_name'];.

   }.

?>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">.

         <tr>.

           <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>.

           <td class="pageHeading1" align="right" valign="top"><?php echo (($product_info['products_price'] > 0) ? $products_price : '<img src="../images/call4price.gif" alt="" >'); ?></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td class="main">.

<?php.

   if (tep_not_null($product_info['products_image'])) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2" align="right">.

           <tr>.

             <td align="center" class="smallText">.

<script language="javascript"><!.

Document.write('<?php echo '<a href="javascript:popupWindow(\\\''tep_href_link(FILENAME_POPUP_IMAGE, 'pID='$product_info['products_id'])'\\\')">'tep_image(DIR_WS_IMAGES$product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>');.

//></script>.

<noscript>.

<?php echo '<a href="'tep_href_link(DIR_WS_IMAGES$product_info['products_image'])'" target="_blank">'tep_image(DIR_WS_IMAGES$product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"')'<br>'TEXT_CLICK_TO_ENLARGE'</a>'; ?>.

</noscript>.

             </td>.

           </tr>.

         </table>.

<?php.

   }.

?>.

<!  <p><b><?php // echo stripslashes($product_info['products_info']); ?></b></p> >.

         <p><?php echo stripslashes($product_info['products_description']); ?></p>.

<?php.

   $products_attributes_query = tep_db_query("select count(*) as total from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"'");.

   $products_attributes = tep_db_fetch_array($products_attributes_query);.

   if ($products_attributes['total'] > 0) {.

?>.

         <table border="0" cellspacing="0" cellpadding="2">.

           <tr>.

             <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>.

           </tr>.

<?php.

     $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from "TABLE_PRODUCTS_OPTIONS" popt, "TABLE_PRODUCTS_ATTRIBUTES" patrib where patrib.products_id='"(int)$HTTP_GET_VARS['products_id']"' and patrib.options_id = popt.products_options_id and popt.language_id = '"(int)$languages_id"' order by popt.products_options_name");.

     while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {.

       $products_options_array = array();.

       $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from "TABLE_PRODUCTS_ATTRIBUTES" pa, "TABLE_PRODUCTS_OPTIONS_VALUES" pov where pa.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pa.options_id = '"(int)$products_options_name['products_options_id']"' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '"(int)$languages_id"'");.

       while ($products_options = tep_db_fetch_array($products_options_query)) {.

         $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);.

         if ($products_options['options_values_price'] != '0') {.

           $products_options_array[sizeof($products_options_array)-1]['text'] .= ' ('$products_options['price_prefix']$currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';.

         }.

       }.

       if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {.

         $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];.

       } else {.

         $selected_attribute = false;.

       }.

?>.

           <tr>.

             <td class="main"><?php echo $products_options_name['products_options_name']':'; ?></td>.

             <td class="main"><?php echo tep_draw_pull_down_menu('id['$products_options_name['products_options_id']']', $products_options_array, $selected_attribute); ?></td>.

           </tr>.

<?php.

     }.

?>.

         </table>.

<?php.

   }.

?>.

       </td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   $reviews_query = tep_db_query("select count(*) as count from "TABLE_REVIEWS" where products_id = '"(int)$HTTP_GET_VARS['products_id']"'");.

   $reviews = tep_db_fetch_array($reviews_query);.

   if ($reviews['count'] > 0) {.

?>.

     <tr>.

       <td class="main"><?php echo TEXT_CURRENT_REVIEWS' '$reviews['count']; ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if (tep_not_null($product_info['products_url'])) {.

?>.

     <tr>.

       <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto='urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

<?php.

   }.

   if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>.

     </tr>.

<?php.

   } else {.

?>.

     <tr>.

       <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>.

     </tr>.

<?php.

   }.

?>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">.

         <tr class="infoBoxContents">.

           <td><table border="0" width="100%" cellspacing="0" cellpadding="2">.

             <tr>.

               <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

               <td class="main"><?php echo '<a href="'tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params())'">'tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS)'</a>'; ?></td>.

               <td class="main" align="right">.

       <?php // echo (($product_info['products_price'] > 0) ? tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART) : ''); ?>.

   <?php echo tep_draw_hidden_field('products_id', $product_info['products_id'])(($product_info['products_price'] > 0) ? tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART) : ''); ?></td>.

 .

   .

      <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>.

             </tr>.

           </table></td>.

         </tr>.

       </table></td>.

     </tr>.

     <tr>.

       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

     </tr>.

     <tr>.

       <td>.

<?php.

/* This has been commented out for use with Family Products v3.0.

   if ((USE_CACHE == 'true') && empty($SID)) {.

     echo tep_cache_also_purchased(3600);.

   } else {.

     include(DIR_WS_MODULESFILENAME_ALSO_PURCHASED_PRODUCTS);.

   } */.

 }.

?>.

       </td>.

     </tr>.

         <tr>.

           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>.

         </tr>.

         <tr>.

           <td><?php include(DIR_WS_MODULESFILENAME_FAMILY_PRODUCTS); ?></td>.

         </tr>.

       </td>.

     </tr>.

   </table></form></td>.

<! body_text_eof //>.

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">.

<! right_navigation //>.

<?php require(DIR_WS_INCLUDES'column_right.php'); ?>.

<! right_navigation_eof //>.

   </table></td>.

 </tr>.

</table>.

<! body_eof //>.

<! footer //>.

<?php require(DIR_WS_INCLUDES'footer.php'); ?>.

<! footer_eof //>.

<br>.

</body>.

</html>.

<?php require(DIR_WS_INCLUDES'application_bottom.php'); ?>..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.