Jump to content

saho

Members
  • Content count

    45
  • Joined

  • Last visited

About saho

  • Birthday 09/10/1971

Profile Information

  • Real Name
    Scott
  • Location
    Burlington, VT
  • Website

Recent Profile Visitors

7,124 profile views
  1. Just call it up as a module <tr> <td class="add your class here"><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td> </tr>
  2. Has anyone successfully added a category and manufacturers filter to featured_products.php site like this http://www.vagant.de/exclusive.php If so, and they would like to share the code I would be forever grateful.
  3. saho

    [Contribution] SEO-G

    All SELECT count(*) as total FROM configuration WHERE configuration_group_id=24 does is return the number of configuration_group_id entries. Looking back at that posting enigma was wondering if that person had made the proper entries into the admin/includes/database_tables.php //-MS- SEO-G Added define('TABLE_SEO_URL', 'seo_url'); define('TABLE_SEO_REDIRECT', 'seo_redirect'); define('TABLE_SEO_EXCLUDE', 'seo_exclude'); define('TABLE_SEO_FREQUENCY', 'seo_frequency'); define('TABLE_SEO_TYPES', 'seo_types'); define('TABLE_SEO_TO_CATEGORIES','seo_to_categories'); define('TABLE_SEO_TO_PRODUCTS','seo_to_products'); define('TABLE_SEO_TO_MANUFACTURERS','seo_to_manufacturers'); //-MS- SEO-G Added EOM //-MS- SEO-G Support for Articles Manager define('TABLE_SEO_TO_TOPICS','seo_to_topics'); define('TABLE_SEO_TO_ARTICLES','seo_to_articles'); define('TABLE_SEO_TO_AUTHORS','seo_to_authors'); //-MS- SEO-G Support for Articles Manager EOM //-MS- SEO-G Support for Information Pages Unlimited define('TABLE_SEO_TO_INFORMATION','seo_to_information'); //-MS- SEO-G Support for Information Pages Unlimited EOM //-MS- SEO-G Support for Links Manager define('TABLE_SEO_TO_LINKS','seo_to_links'); //-MS- SEO-G Support for Links Manager EOM
  4. saho

    [Contribution] SEO-G

    I am having a bit of trouble. I tested this mod extensively on a test server at the same host I use for my production server. Test Server works perfectly: I have .htaccess file set up correctly where the store is in a folder called live. All admin root ssl pages and admin ssl pages work correctly. #-MS- SEO-G Added Options +FollowSymLinks RewriteEngine On # Next line must be changed to match your osCommerce folder RewriteBase /live/ RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING} #-MS- SEO-G Added EOM Production Server: All ssl pages at the site root are working fine but all admin ssl pages resolve at cookies_usage.php #-MS- SEO-G Added Options +FollowSymLinks RewriteEngine On # Next line must be changed to match your folder RewriteBase / RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING} #-MS- SEO-G Added EOM As I said all the code is the same, all the settings are the same. There are only two differences. The test site is in a folder/ and it is on a different server but at the same host. Does anyone have any idea what may be going on? I would appreciate any leads.
  5. I am having a bit of trouble. I tested this mod extensively on a test server at the same host I use for my production server. Test Server works perfectly: I have .htaccess file set up correctly where the store is in a folder called live. All admin root ssl pages and admin ssl pages work correctly. #-MS- SEO-G Added Options +FollowSymLinks RewriteEngine On # Next line must be changed to match your osCommerce folder RewriteBase /live/ RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING} #-MS- SEO-G Added EOM Production Server: All ssl pages at the site root are working fine but all admin ssl pages resolve at cookies_usage.php #-MS- SEO-G Added Options +FollowSymLinks RewriteEngine On # Next line must be changed to match your folder RewriteBase / RewriteRule ^(.*).html$ root.php?$1.html&%{QUERY_STRING} #-MS- SEO-G Added EOM As I said all the code is the same, all the settings are the same. There are only two differences. The test site is in a folder/ and it is on a different server but at the same host. Does anyone have any idea what may be going on? I would appreciate any leads.
  6. If anyone uses posim point of sale software, I have created a script that downloads order information in POSIM's format. If anyone is interested I can supply it to them. Scott
  7. saho

    Mailchimp Integration

    php code is here: http://www.mailchimp.com/api/#optins
  8. Has anyone written or seen an integration of mailchimp into oscommerce. Mailchimp is an email newsletter site (one of the best) they have an API that would allow people to sign up. Could be written into an infobox as well as the create an account page which would allow automated addition to your list through mailchimps API.
  9. saho

    Ajax State Selector problem

    I have the same issue, wondering if it is server environment, I am using xampp
  10. saho

    Featured Products problem

    I found the answer here: http://forums.oscommerce.com/index.php?showtopic=199498&hl= replace the $featured_products_query in catalog/includes/modules/featured.php to make it work with mysql 5 $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS);
  11. saho

    Featured Products problem

    I am having the exact same problem it has to do with mysql 5.0 MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode. Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen. The error is in catalog/includes/modules/featured.php somewhere in this string: $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, products_retail_price, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (" . $featured_products_category_id_list . ") and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); If anyone can help rewrite this I am sure we would all appreciate it. If you need a guide there are similar strings that had to be rewritten, check here. http://www.oscommerce.com/ext/update-20051...l#_Toc119473689
  12. For quite sometime I have been using xml tracking 2.0 and I loved it. One day it stopped working. My question is can I reprogram it to point to the UPS.com tracking page Example: Rather than http://mystore.com/catalog/tracking.php?tracknum=etc. to my customers when I update to shipped could I send them to: http://wwwapps.ups.com/etracking/tracking....A650R6034156???? Below I have the original code in the package and below that is my best guess at sending them to the new url. Could someone take a look at it and suggest if it would work. Thank you in advance for looking at this, I really appreciate it, at the moment tracking is not working. I am using a June 2002 snapshot with ups xml tracking version2 -------------------------------------------------------------------- $customer_notified = '0'; if ($HTTP_POST_VARS['notify'] == 'on' & $ups_track_num == '' ) { $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $customer_notified = '1'; }elseif ($HTTP_POST_VARS['notify'] == 'on' & tep_not_null($ups_track_num) ) { $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . EMAIL_TEXT_TRACKING_NUMBER . ' ' . tep_catalog_href_link(FILENAME_CATALOG_TRACKING_NUMBER, 'action=track&tracknum=' . $ups_track_num, 'NONSSL') . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $customer_notified = '1'; } ---------------------------------------------------------------------- Changed code ---------------------------------------------------------------------- Can I replace with this: $customer_notified = '0'; if ($HTTP_POST_VARS['notify'] == 'on' & $ups_track_num == '' ) { $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $customer_notified = '1'; }elseif ($HTTP_POST_VARS['notify'] == 'on' & tep_not_null($ups_track_num) ) { $email = STORE_NAME . "n" . EMAIL_SEPARATOR . "n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "nn" . EMAIL_TEXT_TRACKING_NUMBER . ' ' . 'http://wwwapps.ups.com/etracking/tracking.cgi?tracknum=' . $ups_track_num, 'NONSSL') . "nn" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, ''); $customer_notified = '1'; } ------------------------------------------------------------------------ Thank you
×