Jump to content

jackanderson

Members
  • Content count

    90
  • Joined

  • Last visited

About jackanderson

  • Birthday 05/23/1983

Profile Information

  • Real Name
    Jack Anderson
  • Gender
    Male
  • Interests
    osCommerce Design/Customization/Troubleshooting Services available. Contact me via PM.
  • Website
  1. Loving the new forum look..

  2. jackanderson

    Getting sent back to checkout_confirmation.php with Flo2Cash

    Do you have register_globals enabled? This gateway needs it to be enabled.
  3. jackanderson

    display quantity of product?

    If you mean on the Product Info page.. here you go.. http://addons.oscommerce.com/info/4362
  4. Try changing your DB encoding to utf8 to support other languages..
  5. Do you have FILENAME_FEATURED defined in /catalog/includes/filenames.php ?? define('FILENAME_FEATURED', 'featured_products.php'); Like this? If not, add it, and it should work properly... Cheers..
  6. I don't think the functionality exists for a customer to choose group.. This has to be done via backend (that's my interpretation after reading about SPPC).. You'd have to do some pretty large modifications to let customer choose his/her group..
  7. jackanderson

    Slowly drowning on Ultimate SEO

    Ultimate SEO 2-2.2d-4 has no such folder structure.. Which version are you using??
  8. jackanderson

    Customers extra fields

    Nevermind.. I figured out my solution.. To all of those who're facing problems with create_account not saving the data.. Download the bugfix.. http://addons.oscommerce.com/info/3737 basically change $sql_data_array = array('customers_id' => (int)$customers_id, 'fields_id' => $extra_fields['fields_id'], 'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]); } else { $sql_data_array = array('customers_id' => (int)$customers_id, into $sql_data_array = array('customers_id' => (int)$customer_id, 'fields_id' => $extra_fields['fields_id'], 'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]); } else { $sql_data_array = array('customers_id' => (int)$customer_id, That's it.. $customers_id was preventing it from storing in the database.. Now it works like a charm.. Cheers..
  9. jackanderson

    Customers extra fields

    Has anybody else had problems with sppc and this contrib?? It doesn't store the info when entered via create_account.php but if i manually add it via admin.. it goes in.. same for account edit after loggin ing.. it stores it even then... I saw that the code after $customer_id = tep_db_insert_id(); is the problem.. original was // BOF Customers extra fields $extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 "); while($extra_fields = tep_db_fetch_array($extra_fields_query)){ $sql_data_array = array('customers_id' => $customer_id, 'fields_id' => $extra_fields['fields_id'], 'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]); tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array); } // EOF Customers extra fields and the one in the latest version is // BOF Customers extra fields $extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 "); while($extra_fields = tep_db_fetch_array($extra_fields_query)) { if(isset($HTTP_POST_VARS['fields_' . $extra_fields['fields_id']])){ $sql_data_array = array('customers_id' => (int)$customers_id, 'fields_id' => $extra_fields['fields_id'], 'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]); } else { $sql_data_array = array('customers_id' => (int)$customers_id, 'fields_id' => $extra_fields['fields_id'], 'value' => ''); $is_add = false; for($i = 1; $i <= $HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_total']; $i++) { if(isset($HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_' . $i])) { if($is_add) { $sql_data_array['value'] .= "\n"; } else { $is_add = true; } $sql_data_array['value'] .= $HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_' . $i]; } } } tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array); } // EOF Customers extra fields Any ideas why it isn't storing in DB when using the new code? The old code works, but only for input fields.. It doesn't store radio button values.. Someone help please...
  10. jackanderson

    Master Products - MS2

    Has anybody ever managed to get the Master Product and one or multiple slave products into the shopping cart. I need to be able to do this. Any ideas would really be appreciated. Thanks..
  11. jackanderson

    Yahoo Tree Menu With AJAX

    Some how i cant edit my post... Just to note, there's no space between "#" and the "yahootreemenu" code.. so it should read.. 1. #yahootreemenu a { font-weight: 700; /* font is bold now */ } 3. #yahootreemenu a:hover { background: #408BCA; /* What's your Flavor subcategory background */ color: #fff; /*What's your Flavor mouseover text color*/ } Cheers..
  12. jackanderson

    Yahoo Tree Menu With AJAX

    1. Try this. In /includes/boxes/yahootreemenu.php, line 23, remove "</div>" and put it on line 87 (after </noscript>). This will make sure that the menu has the class "yahootreemenu". Now got your css file (stylesheet.css or tree.css) and at the end of the file add this. # yahootreemenu a { font-weight: 700; /* font is bold now */ } 3. Following the steps of answer 1, add this.. # yahootreemenu a:hover { background: #408BCA; /* What's your Flavor subcategory background */ color: #fff; /*What's your Flavor mouseover text color*/ } Maybe not the nicest way to do it.. but does work... :) Cheers..
  13. jackanderson

    [Contribution] SEO-G

    Carol, Here you go... -- ---------------------------------------------------------------------------- -- Copyright © 2006-2007 Asymmetric Software - Innovation & Excellence -- [url="http://www.asymmetrics.com"]http://www.asymmetrics.com[/url] -- SEO-G mySQL Database Tables for osCommerce -- ---------------------------------------------------------------------------- -- Script is intended to be used with: -- osCommerce, Open Source E-Commerce Solutions -- [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] -- Copyright © 2003 osCommerce -- ------------------------------------------------------------------------- -- Released under the GNU General Public License -- ------------------------------------------------------------------------- DROP TABLE IF EXISTS seo_url; CREATE TABLE seo_url ( seo_url_key VARCHAR(32) NOT NULL, seo_url_get TEXT NOT NULL, seo_url_org TEXT NOT NULL, seo_url_hits int(11) NOT NULL default '0', seo_url_priority decimal(2,1) NOT NULL default '0.5', seo_frequency_id int(11) NOT NULL default '1', date_added date NOT NULL, PRIMARY KEY (seo_url_key) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_redirect; CREATE TABLE seo_redirect ( seo_url_key VARCHAR(32) NOT NULL, seo_url_get TEXT NOT NULL, seo_url_org TEXT NOT NULL, seo_redirect int(3) NOT NULL default '301', seo_url_hits int(11) NOT NULL default '0', last_modified date NOT NULL, PRIMARY KEY (seo_url_key) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_types; CREATE TABLE seo_types ( seo_types_id int(11) NOT NULL auto_increment, seo_types_name VARCHAR(32) NOT NULL, seo_types_handler VARCHAR(255) default NULL, seo_types_class VARCHAR(64) NOT NULL, seo_types_prefix VARCHAR(64) NOT NULL, seo_types_linkage int(3) NOT NULL default '1', sort_order int(3) NOT NULL default '1', seo_types_status tinyint(1) NOT NULL default '1', PRIMARY KEY (seo_types_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_exclude; CREATE TABLE seo_exclude ( seo_exclude_key VARCHAR(32) NOT NULL, seo_exclude_script VARCHAR(64) NOT NULL, seo_exclude_params VARCHAR(255)default NULL, PRIMARY KEY (seo_exclude_key) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_frequency; CREATE TABLE seo_frequency ( seo_frequency_id int(11) NOT NULL auto_increment, seo_frequency_name VARCHAR(32) NOT NULL, PRIMARY KEY (seo_frequency_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_products; CREATE TABLE seo_to_products ( seo_types_id int(11) NOT NULL, products_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, products_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_categories; CREATE TABLE seo_to_categories ( seo_types_id int(11) NOT NULL, categories_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, categories_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_manufacturers; CREATE TABLE seo_to_manufacturers ( seo_types_id int(11) NOT NULL, manufacturers_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, manufacturers_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_articles; CREATE TABLE seo_to_articles ( seo_types_id int(11) NOT NULL, articles_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, articles_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_topics; CREATE TABLE seo_to_topics ( seo_types_id int(11) NOT NULL, topics_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, topics_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_authors; CREATE TABLE seo_to_authors ( seo_types_id int(11) NOT NULL, authors_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, authors_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_information; CREATE TABLE seo_to_information ( seo_types_id int(11) NOT NULL, information_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, information_id) ) TYPE=MyISAM; DROP TABLE IF EXISTS seo_to_links; CREATE TABLE seo_to_links ( seo_types_id int(11) NOT NULL, link_categories_id int(11) default NULL, seo_name VARCHAR(255) NOT NULL, PRIMARY KEY (seo_types_id, link_categories_id) ) TYPE=MyISAM; INSERT INTO seo_types (seo_types_name, seo_types_handler, seo_types_class, seo_types_prefix, seo_types_status, sort_order, seo_types_linkage) VALUES ('Products', 'product_reviews.php, product_reviews_write.php, product_reviews_info.php, popup_image.php', 'seo_products', '', 1, 19, 1), ('Categories', '', 'seo_categories', '', 1, 18, 2), ('Manufacturers', '', 'seo_manufacturers', '', 1, 17, 3), ('Articles', 'article_reviews.php, article_reviews_write.php, article_reviews_info.php', 'seo_articles', '', 0, 9, 5), ('Topics', '', 'seo_topics', '', 0, 8, 6), ('Authors', '', 'seo_authors', '', 0, 7, 7), ('Link Categories', '', 'seo_links', '', 0, 12, 11), ('Information', '', 'seo_information', '', 0, 11, 15); INSERT INTO seo_frequency (seo_frequency_name) VALUES ('always'), ('hourly'), ('daily'), ('weekly'), ('monthly'), ('yearly'), ('never'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Master Switch', 'SEO_DEFAULT_ENABLE', 'false', 'This switch controls the SEO-G urls. When false the SEO-G is disabled and SEO-G URLs are not generated. However incoming hits of SEO-G URLs will still be converted to osC original ones to keep your store functional.', '99', '1', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Extension', 'SEO_DEFAULT_EXTENSION', '.html', 'Default Extension to be appended with the SEO-G urls. Note your <b>.htaccess</b> file should be modified to match this setting.', '99', '2', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Error Header', 'SEO_DEFAULT_ERROR_HEADER', '301', 'Default Header to be set by SEO-G when a page is not found. Used for inactive urls that match the SEO-G extension.', '99', '3', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Redirect', 'SEO_DEFAULT_ERROR_REDIRECT', 'cookie_usage.php', 'Default Redirect Page to be loaded when the header is set to a temp or permanent redirect (Like 301).', '99', '4', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Strict Validation', 'SEO_STRICT_VALIDATION', 'false', 'When true all parameters passed must contain 2 arguments (eg:products_id=1) and invalid parameters will not propagate.', '99', '5', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Auto Names Builder', 'SEO_AUTO_BUILDER', 'true', 'When true, seo names for handled parameters, are generated automatically on the catalog end. When false the system relies exclusively on user-input via the G-Controller to generate names.', '99', '6', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Continuous Check', 'SEO_CONTINUOUS_CHECK', 'false', 'When <b>false</b>, SEO-G checks a passed osC URL against the stored ones, leading to a faster response. When <b>true</b> SEO-G will process every osC URL request and response will be slower but SEO-G name updates will be instant.', '99', '7', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Process Secure Pages', 'SEO_PROCESS_SSL', 'false', 'When <b>false</b>, SEO-G does not process secure pages. When <b>true</b> SEO-G will generate links for secure pages.', '99', '8', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Redirection Table', 'SEO_REDIRECT_TABLE', 'true', 'When <b>true</b> SEO-G uses the redirection table first, before decoding incoming URLs. If a match is found, a redirect is issued according to the redirection type. <b>false</b> Redirections are disabled.', '99', '9', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Safe Mode', 'SEO_DEFAULT_SAFE_MODE', 'true', 'Controls if SEO-G urls are generated on non-handled parameters. When false SEO-G generates friendly urls regardless of parameters passed with the links. When true generates links for the handled parameters only. (ex: products_id, cpath etc).', '99', '5', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Parts Separator', 'SEO_DEFAULT_PARTS_SEPARATOR', '_', 'Default Separator used to join SEO-G url sections. Invalid characters/sequences can cause problems with URLs. Use <b>-</b> or <b>_</b> for best results.', '99', '10', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Words Separator', 'SEO_DEFAULT_WORDS_SEPARATOR', '-', 'Default Separator used to join words and replace invalid characters with processed strings. Invalid characters/sequences can cause problems with URLs. Use <b>-</b> or <b>_</b> for best results.', '99', '11', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Inner Separator', 'SEO_DEFAULT_INNER_SEPARATOR', '_', 'Default Separator used to join paths (Like Categories and Sub-Categories). Invalid characters/sequences can cause problems with URLs. Use <b>-</b> or <b>_</b> for best results.', '99', '12', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Minimum Words Length', 'SEO_DEFAULT_WORD_LENGTH', '1', 'Minimum length of each word to be filtered by SEO-G when names are generated. Words with less characters that the defined value are ignored', '99', '13', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Listings Split', 'SEO_PAGE_SPLIT', '100', 'Default Page Split for SEO-G Lists in osC Admin.', '99', '20', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G Sitemap Filename', 'SEO_SITEMAP_FILENAME', 'google_sitemap.xml', 'Default Filename for the Google Sitemap in XML format. This is generated from the reports page. Do not include the .gz extension (appended automatically).', '99', '24', now(), NULL, NULL); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('SEO-G XML Compress', 'SEO_DEFAULT_COMPRESS', 'true', 'Default compress behavior of the XML maps generated by SEO-G. When true XML map files are compressed.', '99', '29', now(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),'); This is the sql.. In catalog\admin\seo_zones_config.php set $gID to 99.. Cheers...
  14. jackanderson

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    Sent you a PM.. Cheers..
  15. jackanderson

    [CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo

    PM sent... Cheers.. Jack
×