Jump to content

simaster99

Members
  • Content count

    127
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by simaster99

  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. Integrated into osCommerce 2.2 All credit to Lokesh Dhakar http://www.huddletogether.com/projects/lightbox2/ Files and installation for use in osCommerce sites can be found at Please feel free to ask post install questions or any ideas for updates Kind regards simaster99
  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
  15. simaster99

    Now Available: Extra Product Fields 2.3

    Hi All, I woner if you guys could help with install, how do i merge the In the install doc, 15i catalog/admin/categories.php // description copy modified to work with Extra Product Fields $description_query = tep_db_query("select * from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { $description['products_id'] = $dup_products_id; $description['products_viewed'] = 0; tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $description); } // end Extra Product Fields With ..... My catalog/admin/categories.php looks like $description_query = tep_db_query ("select language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6 from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products_id . "' "); while ($description = tep_db_fetch_array ($description_query) ) { // Products Specifications tep_db_query ("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6, products_viewed) values ('" . (int) $dup_products_id . "', '" . (int) $description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input ($description['products_description']) . "', '" . tep_db_input ($description['products_url']) . "', '" . tep_db_input ($description['products_tab_1']) . "', '" . tep_db_input ($description['products_tab_2']) . "', '" . tep_db_input ($description['products_tab_3']) . "', '" . tep_db_input ($description['products_tab_4']) . "', '" . tep_db_input ($description['products_tab_5']) . "', '" . tep_db_input ($description['products_tab_6']) . "', '0')"); } tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')"); // Start Products Specifications $specifications_query = tep_db_query ("select specifications_id, language_id, specification from " . TABLE_PRODUCTS_SPECIFICATIONS . " where products_id = '" . (int)$products_id . "' "); while ($specifications = tep_db_fetch_array ($specifications_query) ) { tep_db_query ("insert into " . TABLE_PRODUCTS_SPECIFICATIONS . " ( products_id, specifications_id, language_id, specification) values ( '" . (int) $dup_products_id . "', '" . (int) $specifications['specification_description_id'] . "', '" . (int)$specifications['language_id'] . "', '" . tep_db_input ($specifications['specification']) . "') "); } // while ($specifications // End Products Specifications This is a merge of the extra fields contrib and the product spec contrib. Any help welcome!!!! Simon
  16. simaster99

    [Contribution] Products Specifications

    Hi All, I woner if you guys could help with install, how do i merge the In the install doc, 15i catalog/admin/categories.php // description copy modified to work with Extra Product Fields $description_query = tep_db_query("select * from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { $description['products_id'] = $dup_products_id; $description['products_viewed'] = 0; tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $description); } // end Extra Product Fields With ..... My catalog/admin/categories.php looks like $description_query = tep_db_query ("select language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6 from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products_id . "' "); while ($description = tep_db_fetch_array ($description_query) ) { // Products Specifications tep_db_query ("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6, products_viewed) values ('" . (int) $dup_products_id . "', '" . (int) $description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input ($description['products_description']) . "', '" . tep_db_input ($description['products_url']) . "', '" . tep_db_input ($description['products_tab_1']) . "', '" . tep_db_input ($description['products_tab_2']) . "', '" . tep_db_input ($description['products_tab_3']) . "', '" . tep_db_input ($description['products_tab_4']) . "', '" . tep_db_input ($description['products_tab_5']) . "', '" . tep_db_input ($description['products_tab_6']) . "', '0')"); } tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')"); // Start Products Specifications $specifications_query = tep_db_query ("select specifications_id, language_id, specification from " . TABLE_PRODUCTS_SPECIFICATIONS . " where products_id = '" . (int)$products_id . "' "); while ($specifications = tep_db_fetch_array ($specifications_query) ) { tep_db_query ("insert into " . TABLE_PRODUCTS_SPECIFICATIONS . " ( products_id, specifications_id, language_id, specification) values ( '" . (int) $dup_products_id . "', '" . (int) $specifications['specification_description_id'] . "', '" . (int)$specifications['language_id'] . "', '" . tep_db_input ($specifications['specification']) . "') "); } // while ($specifications // End Products Specifications This is a merge of the extra fields contrib and the product spec contrib. Any help welcome!!!! Simon
  17. Hi All, I woner if you guys could help with install, how do i merge the In the install doc, 15i catalog/admin/categories.php // description copy modified to work with Extra Product Fields $description_query = tep_db_query("select * from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { $description['products_id'] = $dup_products_id; $description['products_viewed'] = 0; tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $description); } // end Extra Product Fields With ..... My catalog/admin/categories.php looks like $description_query = tep_db_query ("select language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6 from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $products_id . "' "); while ($description = tep_db_fetch_array ($description_query) ) { // Products Specifications tep_db_query ("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_tab_1, products_tab_2, products_tab_3, products_tab_4, products_tab_5, products_tab_6, products_viewed) values ('" . (int) $dup_products_id . "', '" . (int) $description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input ($description['products_description']) . "', '" . tep_db_input ($description['products_url']) . "', '" . tep_db_input ($description['products_tab_1']) . "', '" . tep_db_input ($description['products_tab_2']) . "', '" . tep_db_input ($description['products_tab_3']) . "', '" . tep_db_input ($description['products_tab_4']) . "', '" . tep_db_input ($description['products_tab_5']) . "', '" . tep_db_input ($description['products_tab_6']) . "', '0')"); } tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$dup_products_id . "', '" . (int)$categories_id . "')"); // Start Products Specifications $specifications_query = tep_db_query ("select specifications_id, language_id, specification from " . TABLE_PRODUCTS_SPECIFICATIONS . " where products_id = '" . (int)$products_id . "' "); while ($specifications = tep_db_fetch_array ($specifications_query) ) { tep_db_query ("insert into " . TABLE_PRODUCTS_SPECIFICATIONS . " ( products_id, specifications_id, language_id, specification) values ( '" . (int) $dup_products_id . "', '" . (int) $specifications['specification_description_id'] . "', '" . (int)$specifications['language_id'] . "', '" . tep_db_input ($specifications['specification']) . "') "); } // while ($specifications // End Products Specifications This is a merge of the extra fields contrib and the product spec contrib. Any help welcome!!!! Simon
  18. simaster99

    Optional Related Products, Version 4.0

    And check database_table.php
  19. simaster99

    Optional Related Products, Version 4.0

    Personaly I would restore the backup of your database and then run the SQL querry again, from Mysql. Kind regards Simon
  20. simaster99

    Filters

    Hi All, I wonder if anyone could help in recommending a contrib that will filter the results. The only thing is that my category.php file is heavily changed, so a contrib that does not effect this file much would be great. Many thanks Si
  21. simaster99

    Optional Related Products, Version 4.0

    Hi, The conrib is installed and works very well, however I would like to change the layout of the related products, so they display one product to a line.... image - name - price - buy now I have the products short description contrib installed and would like to know if i could display a shortend product description on the optional prelated products page. image - name - short description - price - buy now Kind regards
  22. simaster99

    Seperate Pricing Per Customer v3.5

    Hi Jan, Your contrib is awesome, many thanks, But the ask a question tab is not needed, how do i remove it? Kind regards Simon
  23. Found it, its in the admin/easypoplulate.php file Could the next update put this in bold and caps!!!!
  24. simaster99

    Header Tags SEO

    HTC EP and Extra fields Hi, I have been attempting to install the contribs, but they all need edits on the admin/catagories file Does anyone have a working file that I can drop in? Kind regards
×