Jump to content

simaster99

Members
  • Content count

    127
  • Joined

  • Last visited

  • Days Won

    1

simaster99 last won the day on February 11 2010

simaster99 had the most liked content!

2 Followers

Profile Information

  • Real Name
    Simon Whitehead
  1. simaster99

    [Contribution] Products Specifications

    hi guys, atm the contrib is in and working well, however on the specs tab all the specifications are listed, however the are not broken up by group. can anybody sugest how this can be done. if you would like a url to see what i am on about pm me. kind regards sim
  2. Hi,

    If you ccan send me a link to your site I can have a look and see if we can fix any problems.

    kind regards

    Simon

  3. Hello Simon

    I was having few issues installing the lightbox add on, was wondering if you could offer any help at your earliest convenience please.

  4. simaster99

    [Contribution] Products Specifications

    Hi Jim, thats for the heads up on the page error, ill look nto it, this site it fairly heavilty modified... as for the filter, this screen grab is not from my shop can any one help in cnfiguring the contrib so it displays like many thanks Simon
  5. simaster99

    [Contribution] Products Specifications

    Okay another day another update..... STS template is still broken, but the site without STS is okay, product spec in (as far as I can see) apart from .... I would still like the filtering to be shown as it is here and the compasison link gives this error, again any help would be welcome!!! www.top4copiers.co.uk Simon
  6. simaster99

    [Contribution] Products Specifications

    Hi All, My previous post is now pretty much resolved, apart from,the sts templae part but i think this is just bad editing of the index.php file. but more importently in the admin/catergoies.php when I am adding a product the specification tab is empty, any ideas on how to resolve this? Many thanks Simon
  7. simaster99

    [Contribution] Products Specifications

    Hi Jim, All installed okay, but can you help with this, on the admin side the tabs work well, but on the catalog side the tabs are giving the link to #DESC or #DOC or #TAB_1 what have I done wrong? Aslo could anyone help me to configure the contrib so it displays like image bellow? Also after installing it seems that the STS templates no longer displays properly, is this just me or has anyone else experienced this, and again any ideas on how to fix it? In the product_info page I get the following error 1054 - Unknown column 'approved' in 'where clause' select count(*) as count from reviews where products_id = '29' and approved = '1' [TEP STOP] Many kind regards Simon
  8. Sorry but the prolem is ..... how do I get this to work? // begin Extra Product Fields $query = "select pd.products_name,pd.products_description,pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image,p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id"; foreach ($xfields as $f) { $query .= ', pd.' . $f; } $query .= " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"; $product_query = tep_db_query($query); // end Extra Product Fields ATM i get the following error when i edit a product, 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' pd.products_url, p.products_id, p.products_quantity, p.products_model, p.produc' at line 1 select pd.products_name,pd.products_description,pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image,p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, pd.extra_value_id1, pd.extra_value_ms2 from products p, products_description pd where p.products_id = '33' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] Any help would be much apriciated
  9. Hi All, In the install on product_info.php 11b) Around line 72 find the line that reads as follows: $product_info_query = tep_db_query("select 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_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 . "'"); and REPLACE it with the following code: // begin Product Extra Fields $query = "select 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"; foreach ($epf as $e) { $query .= ", pd." . $e['field']; } $query .= " 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_query = tep_db_query($query); // end Product Extra Fields My code looks like // BOF MaxiDVD: Modified For Ultimate Images Pack! $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_tab_1, pd.products_tab_2, pd.products_tab_3, pd.products_tab_4, pd.products_tab_5, pd.products_tab_6 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 . "'"); // EOF MaxiDVD: Modified For Ultimate Images Pack! How I merge the two?
  10. simaster99

    Adding a distributor

    Have you tried the affiliate contrib.... http://addons.oscommerce.com/info/158
  11. Hi Guys how do I go about of substituting the text for an image or adding an image as a field // START: Extra Fields Contribution v2.0b - mintpeel display fix $extra_fields_query = tep_db_query(" SELECT pef.products_extra_fields_order, pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef LEFT JOIN ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=". (int)$HTTP_GET_VARS['products_id'] ." and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='".(int)$languages_id."') ORDER BY pef.products_extra_fields_order"); echo '<tr> <td> <table border="0" width="50%" cellspacing="0" cellpadding="2px">'; while ($extra_fields = tep_db_fetch_array($extra_fields_query)) { if (! $extra_fields['status']) // show only enabled extra field continue; echo'<tr><td class="main" align="left" valign="middle"><font size="1" color="#666666"><b>'.$extra_fields['name'].': </b>' . stripslashes($extra_fields['value']).'</font></td></tr>'; } echo' </table> </td> </tr>'; // END: Extra Fields Contribution - mintpeel display fix Many thnaks Simon
  12. I found both your code parts in my admin/catergories.php Have you installed any other contribs before you started this one? For example I have installed "product tabs" this means my code differs form the install. Hope you manage to sort it, once installed this contrib has a lot of possibilities, but how do you add data that you have stored on the product info page? many thanks Simon
  13. Hi Guys, I have looked but I can not find how to insert my extra filed on the product_info.php page, can nayone point me in the right direction? Many thanks Simon
  14. simaster99

    Contribution: Products tabs

    Hi Guys, This is a stlye issue, but how do i move the tabs down to meet the product info? Many kind regards Simon
×