chrometweaks.org

Where I get a best web iPage hosting services in Singapore for the following Requirement?

Click Here To View All Answers...


My question is Where I get a best web iPage hosting services in Singapore for the following Requirement? Many thanks for any answer. Another question I got... When I am looking at product(s) on /admin/categories.php - is there a way to add an extra colum for products_model ? .

I really need this to happen, so if anyone can help at all that would be AWESOME. I've asked in other sections and no one will even reply. at least tell me if it's not possible...

Comments (68)

I'm stumped. I'm not so sure what is the answer to your question. I'll do some poking around and get back to you if I find an anything. You should email the people at iPage as they probably can help you..

Comment #1

Great, I would really appreciate it. Theres no way to manage this iPage site without seeing the product model # listed. thanks again!..

Comment #2

OK, here is solution:.

In admin/categories.php search following lines(about 800-820):.

$products_count = 0;.

If (isset($HTTP_GET_VARS['search'])) {.

  $products_query = tep_db_query("select p.products_id, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and pd.products_name like '%"tep_db_input($search)"%' order by pd.products_name");.

} else {.

  $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = '"(int)$current_category_id"' order by pd.products_name");.

}.

Add ".

P.products_model,.

" after ".

Select p.products_id,.

" to both queries..

Then scroll down and search lines (about 820-230):.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$products['products_id']'&action=new_product_preview&read=only')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$products['products_name']; ?></td>.

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

<?php.

Add ".

' '$products['products_model'].

" between ".

$products['products_name'].

" and ".

;.

"..

That's it..

-Pasi-..

Comment #3

Thanks ppajukos, Quan and I work together and I'd been monitoring this post.

Appreciate it..

PPAJUKOS:.

Hey, Quan and I work together and I just so happened to notice the reply. Appreciate the assistance. Not to bother you with more, but is it possible to put it in a column by itself just like the name and status's are? That away it is aligned and easier to read. Currently it is just resting next to the title of the item and is not easy to distinguish between title/item #..

Thanks,.

Justin.

This post has been edited by.

PristineWEB.

: 13 July 2004, 18:25..

Comment #4

Of course, try this (for example) to lines where you output product row:.

<td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$products['products_id']'&action=new_product_preview&read=only')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$products['products_name']; ?></td>.

               <td class="dataTableContent" align="center"><? php echo $products['products_model']; ?></td>.

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

You must of course add column to header too and maybe.

Modify td col spans and alignments if there is any. Shouldn't be a bad job..

-Pasi-..

Comment #5

You rock dude.. thanks a ton for all the help...

Comment #6

When I am looking at product(s) on /admin/categories.php - is there a way to add an extra colum for products_model ? .

I really need this to happen, so if anyone can help at all that would be AWESOME. I've asked in other sections and no one will even reply. at least tell me if it's not possible...

Comment #7

It should be possible, I need a little time to check out how you get it.

-Pasi-..

Comment #8


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