chrometweaks.org

My ftp login is acting up (filezilla and iPage)?

Click Here To View All Answers...


My question is My ftp login is acting up (filezilla and iPage)? Thanks in advance for any comment. Another question on my mind: Hi all,.

Trying something different (and if anyone knows if what I am about to ask has been done before please let me know..

I wish to have best_sellers.php appear on the column_right.php in all pages..

What I have done is:.

* Changed the maximum value in Admin Panel for best sellers to be 10.

What I want to do is have.

The best sellers box have.

1) Image.

2) Product Name.

3) Product Price.

Is this possible??????.

I would be happy with just Image and Product Name.

Let me know if possible and how it can be done!..

Comments (78)

Hmm... I need to find out myself. I don't know what is the answer to your question. I'll do some research and get back to you if I got an good answer. You should email the people at iPage as they probably know..

Comment #1

Now - me being the silly PHP boy I am - which files are your referring to..

Also to modify $info_box_contents - where do I do that. I understand in principal what I must do, but step instructions or a module similar may be a help. Then once I finalise it - it's off to contributions we go!..

Comment #2

DOH.. sorry I forgot to reference them.. Specials.php under /include/boxes folder.. :oops:..

Comment #3

Is it Specials or Best Sellers are you talking about? I only want to edit the Best Sellers list - with Product Image/Product Name.

Is it includes/boxes - best_sellers.php or specials I should be referencing??/.

Thanks for your help in advance!..

Comment #4

Hello.

I have the same problem.i cannot add prices to best_sellers.php in /boxes/. I cannot print them after I select the price and the tax from the database.any help would be apriciated..

Zam..

Comment #5

Has anyone got this to work? I can only get the [file name] listing / scrolling - but not displaying as the image?.

Cheers..

Comment #6

This should work.

<?php.

/*.

 $Id: best_sellers.php,v 1.19 2002/06/05 20:59:08 dgw_ Exp $.

 osCommerce, Open Source E-Commerce Solutions.

 http://www.oscommerce.com.

 Copyright (c) 2001 osCommerce.

 Released under the GNU General Public License.

*/.

?>.

<! best_sellers //>.

<?php.

 if ($cPath) {.

   $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_image, p.products_price, p.products_ordered from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '"$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (c.categories_id = '"$current_category_id"' OR c.parent_id = '"$current_category_id"') order by p.products_ordered DESC, pd.products_name limit "MAX_DISPLAY_BESTSELLERS);.

 } else {.

   $best_sellers_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_ordered from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '"$languages_id"' order by p.products_ordered DESC, pd.products_name limit "MAX_DISPLAY_BESTSELLERS);.

 }.

 if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {.

?>.

         <tr>.

           <td>.

<?php.

   $info_box_contents = array();.

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

                                'text'  => BOX_HEADING_BESTSELLERS.

                               );.

   new infoBoxHeading($info_box_contents, false, false);.

   $rows = 0;.

   $info_box_contents = array();.

   while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {.

     $rows++;.

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

                                  'text'  => '<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$best_sellers['products_id'], 'NONSSL')'">'tep_image(DIR_WS_IMAGES$best_sellers['products_image'])'</a><br><font color="red">'tep_row_number_format($rows)'</font>&nbsp;<a href="'tep_href_link(FILENAME_PRODUCT_INFO, 'products_id='$best_sellers['products_id'], 'NONSSL')'">'$best_sellers['products_name']'</a><br><font color=red><b>'$currencies->display_price($best_sellers['products_price'], tep_get_tax_rate($best_sellers['products_tax_class_id']))'</b></font>' );.

   }.

   new infoBox5($info_box_contents);.

?>.

           </td>.

         </tr>.

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

<?php.

 }.

?>.

<! best_sellers_eof //>..

Comment #7

Hi all,.

Trying something different (and if anyone knows if what I am about to ask has been done before please let me know..

I wish to have best_sellers.php appear on the column_right.php in all pages..

What I have done is:.

* Changed the maximum value in Admin Panel for best sellers to be 10.

What I want to do is have.

The best sellers box have.

1) Image.

2) Product Name.

3) Product Price.

Is this possible??????.

I would be happy with just Image and Product Name.

Let me know if possible and how it can be done!..

Comment #8

It should be relatively easy to do....

What I would suggest is maybe add something like this.. First find the following code...

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_ordered from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES...............................

Add something like p.prorducts_image and p.products_price so it queries the products image as well...

So the above code would look something like.

$best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name, p.products_image, p.products_price p.products_ordered from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES...............................

Do the same thing for the one below that.. (add the query for images and price...

Then, just modify $info_box_contents[] to what you want to display...

I have not tested this.. but give it a shot....

Hope this helps..

Comment #9


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