Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

FunkyM

Archived
  • Posts

    25
  • Joined

  • Last visited

Everything posted by FunkyM

  1. Thanks for the help. I finally worked out that there must be a missing language file "stats_referral_sources.php" and it wasn't distributed with the original module. To fix the first problem I just opened" admin>stats_referral_sources.php" and added require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_STATS_REFERRAL_SOURCES); Directly AFTER the code below --------------------------------------------------------------------------- <?php /* $Id: stats_referral_sources.php,v 1.5 2006-05-11 rmh Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright ? 2004 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if ($action == 'display_other') { $referrals_query_raw = "select count(ci.customers_info_source_id) as no_referrals, so.customers_id, ci.customers_info_date_account_created, so.sources_other_name as sources_name from " . TABLE_CUSTOMERS_INFO . " ci, " . TABLE_SOURCES_OTHER . " so where ci.customers_info_source_id = '9999' and so.customers_id = ci.customers_info_id group by so.sources_other_name order by no_referrals DESC"; } else { $referrals_query_raw = "select count(ci.customers_info_source_id) as no_referrals, s.sources_name, s.sources_id from " . TABLE_CUSTOMERS_INFO . " ci LEFT JOIN " . TABLE_SOURCES . " s ON s.sources_id = ci.customers_info_source_id group by s.sources_id order by ci.customers_info_source_id DESC"; } ------------------------------------------------------------------ Next I duplicated admin>english>referrals.php and renamed it to "stats_referral_sources.php" then changed the DEFINE tags to match the missing DEFINE data. I then uploaded the file to admin>english directory. This has fixed that problem but I am still getting the database error when I click on the Other Referrals Link. Funkym
  2. Hi I recently just installed Version 1.5 of your module and it seems to work great. Thankyou very much for sharing this with the OSC community. However I am having a little problem. I was extremely carefull in installing the module and everything seemed to go OK except when I Visit the Reports > Referral Sources page it is acting like a language file is missing. The main page heading is "HEADING_TITLE" The table heading to the right hand side is "TABLE_HEADING_VIEWED" and the Other Referrals is "TEXT_OTHER" Also when I click on TEXT_OTHER I get this page error --------------------------------------------------------------------------------- HEADING_TITLE TABLE_HEADING_REFERRALS TABLE_HEADING_VIEWED 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 '-30, 30' at line 1 select count(ci.customers_info_source_id) as no_referrals, so.customers_id, ci.customers_info_date_account_created, so.sources_other_name as sources_name from customers_info ci, sources_other so where ci.customers_info_source_id = '9999' and so.customers_id = ci.customers_info_id group by so.sources_other_name order by no_referrals DESC limit -30, 30 [TEP STOP] --------------------------------------------------------------------------------- I was very carefull to upload all altered files and also the required new files. Any hlep would be great And once again thanks for the Fantastic MOD. Regards FunkyM
  3. Hi I recently just installed Version 1.5 of your module and it seems to work great. Thankyou very much for sharing this with the OSC community. However I am having a little problem. I was extremely carefull in installing the module and everything seemed to go OK except when I Visit the Reports > Referral Sources page it is acting like a language file is missing. The main page heading is "HEADING_TITLE" The table heading to the right hand side is "TABLE_HEADING_VIEWED" and the Other Referrals is "TEXT_OTHER" Also when I click on TEXT_OTHER I get this page error --------------------------------------------------------------------------------- HEADING_TITLE TABLE_HEADING_REFERRALS TABLE_HEADING_VIEWED 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 '-30, 30' at line 1 select count(ci.customers_info_source_id) as no_referrals, so.customers_id, ci.customers_info_date_account_created, so.sources_other_name as sources_name from customers_info ci, sources_other so where ci.customers_info_source_id = '9999' and so.customers_id = ci.customers_info_id group by so.sources_other_name order by no_referrals DESC limit -30, 30 [TEP STOP] --------------------------------------------------------------------------------- I was very carefull to upload all altered files and also the required new files. Any hlep would be great And once again thanks for the Fantastic MOD. Regards FunkyM
  4. Have you tried looking in includes\english.php to a search for "- Company" without the quotes of coarse. Sorry I can't help you with fixing the tags in new pages but I would say the STS is most likely stripping your new tags. Funkym
  5. I also alos not that great at STS V4 but I found that I couldn't get any meta-tags modules to work with it. The reason for this is that STS strips out any and all heder information before reconstructing the page with its own header content. So nothing that you add into the header of any pages will be displayed. After alot of work and pain I finally worked out a way to get custom header titles for each page. Now before you try this please note I am an amature at this to even though this worked it may not be the best option and someone else with more experience may be able to help you further. 1. Open catalog\includes\modules\sts_inc\general.php Scroll to the bottom of the page and find: $sts->template['headertags']= "<title>" . TITLE ."</title>"; Delete this whole line and replace it with: $sts->template['headertags']= "<title>" . TITLE . " (" . ADDITONAL_TITLE_INFORMATION . ")</title>"; Next open catalog\includes\languages\english\product_info.php and add this below the copyright info: $product_title_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_title = tep_db_fetch_array($product_title_query); define('ADDITONAL_TITLE_INFORMATION', $product_title['products_name']); Next open catalog\includes\languages\english\index.php and add this below the copyright info: $category_title_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "'"); $category_title = tep_db_fetch_array($category_title_query); define('ADDITONAL_TITLE_INFORMATION', $category_title['categories_name']); And thats it save and upload your files and your done. What this does is tacks the additional category name of product name in brackets after your default TITLE which is set in languages\english.php. If anyone know a better way to acheive this then please let me know. I would also like to be able to add a dynamic description tag that draws from the product description but was having problems so if anyone can find a way to do this please let me know. Regards Paul PS If this makes your OSC play up don't blame me!!!! :thumbsup:
  6. First of all I hope I am posting in the right area. Forgive me if I am not. This is probably a pretty simple question so I hope that someone knows that answer. How do I change the spelling of Catalog to Catalogue in the STS V4 Category Drop down list box??? I have looked in nealy every file and just can't find where to change it? It cannot be changed in languages/english.php either. All help appreciated Regards Funkym :huh:
  7. I have removed this post as it is not in the right spot
  8. Thanks for your help Bill But that was the first place that I looked. I did a word search for "Catalog" in english.php and I couldn't find it. Paul
  9. Hi this is probably a pretty simple question so I hope that someone knows that answer. How do I change the spelling of Catalog to Catalogue in the STS V4 Category Drop down list box??? I have looked in nealy every file and just can't find where to change it? All help appreciated Regards Funkym
  10. Now I can't seem to delete a coupon. I have created one for myself but I can't seem to delete it. I go to All Coupons and delete it. then go back to All coupons again and it's still there. Funkym
  11. Thanks for your help John I managed to track the problem down to me uploading the catalog/includes/application_top.php file to the admin directory. I just iploaded the correct file and everything seems to be in it's place now. Thanks for your help I really appreciate it. Kind Regards Funkym
  12. Thanks John I woked out it wasn't that it was database_tables.php didn't have the tables defined. Funny thing is the instructions didn't tell me to do this either
  13. I have a problem with the 5.10c installation please see the error below. When I try to add a coupon I get this. Fatal error: Call to undefined function: tep_draw_date_selector() in /home/httpd/vhosts/edimensional.tnmarketing.com.au/httpdocs/shop/catalog/admin/coupon_admin.php on line 709 Any help would be great Funkym
  14. I have just installed this module V5.10c and installed everything as per the instructions, uploaded all the files and changed the other files yet I am getting this error when I try to access the Vouchers / Coupons admin section. Yes I have ran the SQL and all the tables seem to exist. --------------------------------------------------------------------------------------- 1146 - Table 'ed_shop.TABLE_COUPONS' doesn't exist select count(*) as total from TABLE_COUPONS where coupon_active='Y' and coupon_type != 'G' [TEP STOP] --------------------------------------------------------------------------------------- I have been searching through the forum section but to no avail. Any help would be very much appreciated. Regards Funkym
×
×
  • Create New...