Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

fatmcgav

Archived
  • Posts

    171
  • Joined

  • Last visited

Everything posted by fatmcgav

  1. I'm having some issues getting this installed. When i try to run additional_images_configure.php it just dumps me back to the login screen. I login and try and run it again, and it dumps me back to the login screen, and so on and so forth... I've managed to manually create the tables, but i cant get the config values sorted out. Could you let me know what could be causing it to cycle the login window, or alternatively just provide me with the sql for the configuration_group and configuration_key entries. Any info appreciated. Cheers Gavin
  2. I'd be very interested in this aswell. I've had a quick look at the code, but got that friday feeling so cant quite get my head round it. Any ideas on where to start to get lightbox working with this mod? Cheers Gavin
  3. hi there, I've just uploded v1.5 of cDynamic Meta-tags and installed v1.1 of osC Advanced Cache Class by Chemo, hoping to use it to cache the meta-tag results in the db. However, when i set $cache_type = 1, the site gives me teh following error: The area around line 57 is: # Create paths and cache names $meta_cache_file=$meta_cache_filename.'_'.$meta_cache_param.$cache_language.$cache_currency.".meta-cache"; $meta_cache_file_full = $meta_cache_files_path.$meta_cache_file; ################################################################################ ############# # Check to see what type of cache if any and run with it... $cache_type == 1 ? $meta_cache_code = $cache->get_cache($meta_cache_file) : NULL; if ($meta_cache_code){ echo $meta_cache_code; }else if ($cache_type == 2 && file_exists($meta_cache_file_full)) { echo base64_decode(gzinflate(file_get_contents($meta_cache_file_full))); }else{ ob_start(); # Page Parameters I've double checked, uninstalled and reinstalled the db, and re-uploaded the neccessary files twice, and i still cant get it to work. Any ideas on wat might be causing the problem? Cheers Fatmcgav
  4. Anybody got any ideas on how i'd go about doing this??? Cheers Fatmcgav
  5. hey there, i've had a quick look and i cant see a solution for wat i'm lookin for, so i thought i'd ask. I'm wanting to modify the page so that it displays the article sub-categories on the categories page. eg: http://www.imperialdomination.co.uk/tech-t-2.html I want it to show the two Sub-category names on the page... Any ideas how i'd go about it? Cheers Fatmcgav
  6. Anybody got a demo store with this installed that i can have a look at? Cheers Fatmcgav
  7. Hey Pop, Any chance u would be able to add to this wonderful contrib so that the HTML email templates are used for order update emails, registration emails and newsletters? It's just i feel it dosent look that professional or consistent having a HTML email for the order conf email, and not for the order updates... If not, any chance somebody else could do it, or point me in the right direction? Cheers Fatmcgav
  8. Somebody out there must know how to fix this problem, PLEASE. I'm completely at a wits end with this one. Somebody, PLEASE...
  9. K, i'm getting this SQL error now if i try to disable a product: And This one if i try to enable a product: The corresponding section in featured.php is: function tep_set_featured_index($featured_id, $index) { if ($index == '1') { return tep_db_query("update " . TABLE_FEATURED . " set index = '1', expires_date = NULL, date_status_change = NULL, where featured_id = '" . $featured_id . "'"); } elseif ($index == '0') { return tep_db_query("update " . TABLE_FEATURED . " set index = '0', date_status_change = now() where featured_id = '" . $featured_id . "'"); } else { return -1; } } Any ideas ppl? Cheers Fatmcgav
  10. Hey, If someone could have a look at my thread Here it would be greatly appreicated. Cheers Fatmcgav
  11. Somebody must know what the problem is.... Cheers Fatmcgav
  12. All sorted :D:D I noticed some sql queries on the main links.php page, so i just commented a line out, and reshuffled a couple of fields, and it now seems to work fine. Cheers Fatmcgav
  13. If only it was that simple. As far as i can tell, the columns are created from a sql query, and i cant remove the description field, as it removes both the column and the description itself... Code taken from modules/links_listing.php switch ($column_list[$col]) { case 'LINK_LIST_TITLE': $lc_align = ''; if (LINKS_TITLES_AS_LINKS == 'True') $lc_text = $listing['links_title']; else $lc_text = '<a href="' . tep_get_links_url($listing['links_id']) . '" target="_' . $openMode . '">' . $listing['links_title'] . '</a><br>' . $listing['links_description']; break; case 'LINK_LIST_URL': $lc_align = ''; $lc_text = '<a href="' . tep_get_links_url($listing['links_id']) . '" target="_' . $openMode . '">' . $listing['links_url'] . '</a>'; break; case 'LINK_LIST_IMAGE': $lc_align = 'center'; if (tep_not_null($listing['links_image_url'])) { $lc_text = '<a href="' . tep_get_links_url($listing['links_id']) . '" target="_' . $openMode . '">' . tep_links_image($listing['links_image_url'], $listing['links_title'], LINKS_IMAGE_WIDTH, LINKS_IMAGE_HEIGHT) . '</a>'; } else { $lc_text = '<a href="' . tep_get_links_url($listing['links_id']) . '" target="_' . $openMode . '">' . tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', $listing['links_title'], LINKS_IMAGE_WIDTH, LINKS_IMAGE_HEIGHT, 'style="border: 3px double black"') . '</a>'; } break; case 'LINK_LIST_COUNT': $lc_align = ''; $lc_text = $listing['links_clicked']; break; } The change i made is moving $listing['links_description'] from it's own case to the title case, but i still cant seem to remove the descritpion column... Any ideas ppl? Cheers Fatmcgav
  14. Hey there, I had a quick q about modifying the links listing page. What i'm trying to do, is have the link image in one column, with the title in another, and underneath that is the description. This is a very simple image of wat i mean: ANy ideas on if this is possible? I've tried a couple of changes, and i've been able to get the description under the title, but it repeats in what was the Title and the Description colums... here ANy ideas on what code changes i'd need to make to do this? Cheers Fatmcgav
  15. Hey there, I've been working on modifying Featured Products 1.5.4 so that the user can specify a single product to be featured in the Index page, as a Product of the Week sort of thing. I've managed to edit the sql query in the featured prods module to query for the index column, which i've added to the featured table in my db. I've also added another set of status buttons in featured.php so that it's possible to toggle which one is the POW from the featured products page in admin. However, i'm having some problems getting the sql query to edit the db correct. Basically, all i've done is coppied the status change stuff, and changed the relavent fields and links... The DB query function tep_set_featured_index($featured_id, $index) { if ($index == '1') { return tep_db_query("update " . TABLE_FEATURED . " set index = '1', expires_date = NULL, date_status_change = NULL, where featured_id = '" . $featured_id . "'"); } elseif ($index == '0') { return tep_db_query("update " . TABLE_FEATURED . " set index = '0', date_status_change = now() where featured_id = '" . $featured_id . "'"); } else { return -1; } } The setindex case case 'setindex': tep_set_featured_index($HTTP_GET_VARS['id'], $HTTP_GET_VARS['flag']); tep_redirect(tep_href_link(FILENAME_FEATURED, '', 'NONSSL')); break; The Index buttons <?php if ($featured['index'] == '1') { echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' <a href="' . tep_href_link(FILENAME_FEATURED, 'action=setindex&flag=0&id=' . $featured['featured_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>'; } else { echo '<a href="' . tep_href_link(FILENAME_FEATURED, 'action=setindex&flag=1&id=' . $featured['featured_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10); } ?> If i click on either the green of the red buttons to toggle the POW, it gives me a 1064 mysql error with my code - however i cant see where it is, as the code is identical to the status update query, apart from changin a different field. Any ideas on what might be causing this? Cheers Fatmcgav
  16. To solve this one, open catalog/admin/includes/languages/english.php, and search for this line: define('HEADING_TITLE','Newsletter'); and just delete it. That should solve that problem for u. hth fatmcgav
  17. Anychance u could point me in right direction??? Cheers Fatmcgav
  18. Hmm,i duno if this is something i've done, or a contrib bug, but when i generate a new sitemap, it appears to be duplicating all the categorie URL's - one in the re-written format and one in the cpath=? format. Like this Just wondering if anybody else was having this problem, or if it was just me :D Cheers Fatmcgav
  19. Hey Bobby, if ure still looking for someone to test ure new release, i'd be more than happy to do it for u - i've got a site in the works atm - www.surferswarehouse.co.uk - and one of the biggest bug-bairs is that the infopages arent covered by ure SEO urls - but yeh, if ure in need of someone to test, drop me a pm and i'd be more than happy to help. Cheers Fatmcgav
  20. Hey there, I've got All Products in Menu without Additional File installed on my site, and i've just been trying to install Enable & Disable Categories The install has worked fine on for my products categories, but when it comes to the All Prods cat, the sql isnt working. Code 1: The Original // We Show Them All listing query - $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; Code 2: The SQL code that works for All Prods - if ($cPath == 64) // all products cpath = 64 no categories apply {$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "'"; } else // select on categories {$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } As u can see, this now uses a If Else Statement to link between the all prods cat and the standard cat... Code 3: The Enable Disable Products SQL Query - $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where c.categories_status = '1' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; Now, i've managed to combine Code 3 with Code 2 for the categories that show specific products - I simply replaced the second query for specific cats with Code 3. However, i've been unable to work out what changes I need to make to the query in order to make Code 2 (all prods cat) work... Code 4: The current SQL Statement in INdex.php for // We show them all // We show them all if ($cPath == 21) // all products cpath = 64 no categories apply {$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id where c.categories_status = '1' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"; } else // select on categories {$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where c.categories_status = '1' and p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } Any ideas on how i need to re-write the All Products query to show only Enabled Cats prods, or rewrite the Enable/Disable query to show All Prods??? Cheers Fatmcgav - Appologies for the long-winded post, just thought i'd give as much info as i could to make everything easier in the long run...
  21. My question still stands... is it possible to use the HTML emails on Order Updates??? Cheers Fatmcgav
  22. WTF, where did that come from - that's on a totally unrelated line... I only quoted that code as a user asked for it, and yes, it's possible the config_id might be different, but the user in question replied and said that it worked fine... and if it didnt, i appologies, but i also included instructions on how to change it. Anyhow, i dont see the point in this slaggin match - the only reason i responded in the first place is that u were'nt aware that the redemptions.php file in ure uploaded zip was broken... which I now see u have noticed and corrected. I see no point in trying to 'score points' off each other, so lets just leave it at this... And YES, for ure information, I am happy with the changes I made to MY DB!!!
  23. And in reply to ure above post and pm: ----------------------------------------------------------------------------------------- Chill dude :D :D The uploaded file contains the same files as the original download, apart from the changed redemptions.php and install - the original dload didnt contain the screenshots either - not the contrib install one anyway - the full one off ure site did, but not the one on the OSCom Site - all that contained was the install instructions, the new files and the sql. Even the latest one u've uploaded doesnt contain the screenshots... So the file I uploaded WAS complete in as much as it contained the sames files as i dloaded - nuthin more, nuthin less. So i think U need to upload the complete file before U have a go at ME. Also, for ure information, the latest one u uploaded contains the version of redemption.php which is missing code - if u dont believe me, i just dloaded and tested it, and it caused exactly the same error as before - try it for ureself if u dont believe me. I'm glad u've taken account of the install file mods though ;) Cheers again dude, and I hope u see what i've been saying all along that the wrong file redemptions.php is in the zip u uploaded. Peace out dude. :thumbsup: Fatmcgav BTW: I'm not American either :) And i dont like being told i'm wrong when i'm not <_< >_<
  24. Thats cool dude :D The problems were caused by the redemptions.php file in the original zip file missing some code - this was fixed evetually by the last upload :D The parse error was due to a missed line in the installation file, but this was also corrected with the 1.2 upload. Just making sure it works for everybody out of the box. Still a great contrib though dude :D
×
×
  • Create New...