Jump to content

jchasick

Members
  • Content count

    1,473
  • Joined

  • Last visited

Everything posted by jchasick

  1. jchasick

    Live Support Fix

    unless you are really comfortable with php, mysql and html, you really should be using either the MS1 release or the Loaded5 version from Ian - the CVS versions change daily, and if you are not adding the new daily commits, then you are asking for trouble.....
  2. jchasick

    Style Selection

    you may want to look at a couple of downloads/contributions in the themes area to get an idea what they are doing and see if that helps - the contributions only allow the admin to change the theme from the admin panel but there is no user control for doing it - that might be a nice new contribution :wink:
  3. jchasick

    Header Tags

    yes it does
  4. when all else fails.... stab in the dark and pray :lol: :lol:
  5. jchasick

    Subcatagory Product Description For (MS1)

    nice design (the catagories menu takes a long time to load tho...) where do you want the description to appear?
  6. i borrowed Linda's IV :lol: :lol:
  7. # # Table structure for table `faqdesk` # CREATE TABLE faqdesk ( faqdesk_id int(11) NOT NULL auto_increment, faqdesk_image varchar(64) default NULL, faqdesk_image_two varchar(64) default NULL, faqdesk_image_three varchar(64) default NULL, faqdesk_date_added datetime NOT NULL default '0000-00-00 00:00:00', faqdesk_last_modified datetime default NULL, faqdesk_date_available datetime default NULL, faqdesk_status tinyint(1) NOT NULL default '0', faqdesk_sticky tinyint(1) NOT NULL default '1', PRIMARY KEY (faqdesk_id), KEY idx_faqdesk_date_added (faqdesk_date_added) ) TYPE=MyISAM; # # Table structure for table `faqdesk_categories` # CREATE TABLE faqdesk_categories ( categories_id int(11) NOT NULL auto_increment, categories_image varchar(64) default NULL, parent_id int(11) NOT NULL default '0', sort_order int(3) default NULL, date_added datetime default NULL, last_modified datetime default NULL, catagory_status tinyint(1) NOT NULL default '1', PRIMARY KEY (categories_id), KEY idx_categories_parent_id (parent_id) ) TYPE=MyISAM; # # Table structure for table `faqdesk_categories_description` # CREATE TABLE faqdesk_categories_description ( categories_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '1', categories_name varchar(32) NOT NULL default '', categories_heading_title varchar(64) default NULL, categories_description text, PRIMARY KEY (categories_id,language_id), KEY idx_categories_name (categories_name) ) TYPE=MyISAM; # # Table structure for table `faqdesk_configuration` # CREATE TABLE faqdesk_configuration ( configuration_id int(11) NOT NULL auto_increment, configuration_title varchar(64) NOT NULL default '', configuration_key varchar(64) NOT NULL default '', configuration_value varchar(255) NOT NULL default '', configuration_description varchar(255) NOT NULL default '', configuration_group_id int(11) NOT NULL default '0', sort_order int(5) default NULL, last_modified datetime default NULL, date_added datetime NOT NULL default '0000-00-00 00:00:00', use_function varchar(255) default NULL, set_function varchar(255) default NULL, PRIMARY KEY (configuration_id) ) TYPE=MyISAM; # INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (1, 'Search Results', 'MAX_DISPLAY_FAQDESK_SEARCH_RESULTS', '20', 'How many FAQS do you want to list?', 1, 1, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (2, 'Page Links', 'MAX_DISPLAY_FAQDESK_PAGE_LINKS', '5', 'Number of links to use for page-sets', 1, 2, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (3, 'Display Question', 'FAQDESK_QUESTION', '1', 'Do you want to display the question? (0=disable; 1-4 sort order)', 1, 3, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (4, 'Display Short Answer', 'FAQDESK_SHORT_ANSWER', '2', 'Do you want to display the short answer? (0=disable; 1-4 sort order)', 1, 4, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (5, 'Display Long Answer', 'FAQDESK_LONG_ANSWER', '3', 'Do you want to display the long Answer? (0=disable; 1-4 sort order)', 1, 5, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (6, 'Display Date', 'FAQDESK_DATE_AVAILABLE', '4', 'Do you want to display the date? (0=disable; 1-4 sort order)', 1, 6, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (7, 'Location of Prev/Next Navigation Bar', 'FAQDESK_PREV_NEXT_BAR_LOCATION', '3', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 1, 12, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (8, 'Display Main FAQS Items', 'MAX_DISPLAY_FAQDESK_FAQS', '3', 'How many FAQS do you want to display on the top page?', 2, 1, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (9, 'Latest FAQS Box Counts', 'LATEST_DISPLAY_FAQDESK_FAQS', '5', 'How many FAQS do you want to display in the Latest News Box?', 2, 2, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (10, 'Display Latest FAQS Box', 'DISPLAY_LATEST_FAQS_BOX', '1', 'Do you want to display the Latest FAQS Box? (0=disable; 1=enable)', 2, 3, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (11, 'Display FAQS Catagory Box', 'DISPLAY_FAQS_CATAGORY_BOX', '1', 'Do you want to display the FAQS Catagory Box? (0=disable; 1=enable)', 2, 4, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (12, 'Display View Counts', 'DISPLAY_FAQDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; 1=enable)', 2, 5, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (13, 'Display Read More', 'DISPLAY_FAQDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; 1=enable)', 2, 6, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (14, 'Display Short Answwer', 'DISPLAY_FAQDESK_SHORT_ANSWER', '1', 'Do you want to display the Short Answer? (0=disable; 1=enable)', 2, 7, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (15, 'Display Question', 'DISPLAY_FAQDESK_QUESTION', '1', 'Do you want to display the Question? (0=disable; 1=enable)', 2, 8, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (16, 'Display Date', 'DISPLAY_FAQDESK_DATE', '1', 'Do you want to display the FAQS Date? (0=disable; 1=enable)', 2, 9, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (17, 'Display Image 1', 'DISPLAY_FAQDESK_IMAGE', '1', 'Do you want to display image "1" for the FAQ? (0=disable; 1=enable)', 2, 10, NULL, '2003-03-03 11:59:47', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (18, 'Display Image 2', 'DISPLAY_FAQDESK_IMAGE_TWO', '1', 'Do you want to display image "2" for the FAQ? (0=disable; 1=enable)', 2, 11, '2003-03-03 12:08:55', '2003-03-03 11:59:47', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (19, 'Display Image 3', 'DISPLAY_FAQDESK_IMAGE_THREE', '1', 'Do you want to display image "3" for the FAQ? (0=disable; 1=enable)', 2, 12, '2003-03-03 12:09:16', '2003-03-03 11:59:47', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (20, 'Display Reviews', 'DISPLAY_FAQDESK_REVIEWS', '1', 'Do you want to display FAQS Reviews? (0=disable; 1=enable)', 3, 1, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (21, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '10', 'Maximum number of new reviews to display', 3, 2, NULL, '2003-02-16 02:08:36', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (22, 'Display Question', 'STICKY_QUESTION', '1', 'Do you want to display the question? (0=disable; 1=enable)', 4, 1, NULL, '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (23, 'Display Short Answer', 'STICKY_SHORT_ANSWER', '1', 'Do you want to display the short answer? (0=disable; 1=enable)', 4, 2, NULL, '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (24, 'Display Long Answer', 'STICKY_LONG_ANSWER', '1', 'Do you want to display the long answer? (0=disable; 1=enable)', 4, 3, '2003-03-02 00:49:34', '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (25, 'Display View Counts', 'STICKY_FAQDESK_VIEWCOUNT', '1', 'Do you want to display View Counts? (0=disable; 1=enable)', 4, 4, NULL, '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (26, 'Display Read More', 'STICKY_FAQDESK_READMORE', '1', 'Do you want to display Read More? (0=disable; 1=enable)', 4, 5, NULL, '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (27, 'Display Date', 'STICKY_DATE_ADDED', '1', 'Do you want to display the date? (0=disable; 1=enable)', 4, 6, '2003-03-02 00:49:54', '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (28, 'Display URL', 'STICKY_EXTRA_URL', '1', 'Do you want to display the extra URL? (0=disable; 1=enable)', 4, 7, '2003-03-02 00:50:28', '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (29, 'Display Image', 'STICKY_IMAGE', '1', 'Do you want to display image "1" for the FAQ? (0=disable; 1=enable)', 4, 8, '2003-03-02 00:50:14', '2003-03-02 00:47:21', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (30, 'Display Image 2', 'STICKY_IMAGE_TWO', '1', 'Do you want to display image "2"for the FAQ? (0=disable; 1=enable)', 4, 9, NULL, '2003-03-03 23:10:34', NULL, NULL); INSERT INTO faqdesk_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (31, 'Display Image 3', 'STICKY_IMAGE_THREE', '1', 'Do you want to display image "3" for the FAQ? (0=disable; 1=enable)', 4, 10, NULL, '2003-03-03 23:10:34', NULL, NULL); # # Table structure for table `faqdesk_configuration_group` # CREATE TABLE faqdesk_configuration_group ( configuration_group_id int(11) NOT NULL auto_increment, configuration_group_title varchar(64) NOT NULL default '', configuration_group_description varchar(255) NOT NULL default '', sort_order int(5) default NULL, visible int(1) default '1', PRIMARY KEY (configuration_group_id) ) TYPE=MyISAM; # INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (1, 'Listing Settings', 'Listing Page configuration options', 1, 1); INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (2, 'Frontpage Settings', 'Front Page configuration options', 1, 1); INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (3, 'Reviews Settings', 'Reviews configuration options', 1, 1); INSERT INTO faqdesk_configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (4, 'Sticky Settings', 'Reviews configuration options', 1, 1); # # Table structure for table `faqdesk_description` # CREATE TABLE faqdesk_description ( faqdesk_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', faqdesk_question varchar(64) NOT NULL default '', faqdesk_answer_long text, faqdesk_answer_short text, faqdesk_extra_url varchar(255) default NULL, faqdesk_extra_viewed int(5) default '0', faqdesk_image_text text, faqdesk_image_text_two text, faqdesk_image_text_three text, PRIMARY KEY (faqdesk_id,language_id), KEY faqdesk_question (faqdesk_question) ) TYPE=MyISAM; # # Table structure for table `faqdesk_reviews` # CREATE TABLE faqdesk_reviews ( reviews_id int(11) NOT NULL auto_increment, faqdesk_id int(11) NOT NULL default '0', customers_id int(11) default NULL, customers_name varchar(64) NOT NULL default '', reviews_rating int(1) default NULL, date_added datetime default NULL, last_modified datetime default NULL, reviews_read int(5) NOT NULL default '0', approved tinyint(3) unsigned default '0', PRIMARY KEY (reviews_id) ) TYPE=MyISAM; # # Table structure for table `faqdesk_reviews_description` # CREATE TABLE faqdesk_reviews_description ( reviews_id int(11) NOT NULL default '0', languages_id int(11) NOT NULL default '0', reviews_text text NOT NULL, PRIMARY KEY (reviews_id,languages_id) ) TYPE=MyISAM; # # Table structure for table `faqdesk_to_categories` # CREATE TABLE faqdesk_to_categories ( faqdesk_id int(11) NOT NULL default '0', categories_id int(11) NOT NULL default '0', PRIMARY KEY (faqdesk_id,categories_id) ) TYPE=MyISAM;
  8. jchasick

    Airborne Express Module Available

    we use LIBRA also but no notification.... please dont tell me we are going to have to start using UPS again - despite what their commercials say there is only one thing brown I can think of and it describes their service and rates........ :shock:
  9. see http://forums.oscommerce.com/viewtopic.php...=35513&start=40
  10. make certain you install all the tables in the faqdesk.sql file that is part of the install
  11. jchasick

    Airborne Express Module Available

    this is interesting news :shock: we have been using Airborne for the last 2 years and we haven't received any notice from them that any of this is going on.... :shock: :shock: i wonder if this will impact their rate structures :?
  12. please dont cross post message or ask them more than once - please :D
  13. same problem - you are missing that field in the database
  14. we can always count on Greg to find those small, obscure, drive you crazy types of things with nice simple solutions :D way to go 8)
  15. jchasick

    Contribution Request: Manual Order Entry

    boy am I glad I came back to take a look - I dl'd the file and then read the read me and it said to go to their site to dl something, but your cant access their site, and then i see the two comments above..... :shock: :shock: :shock: glad I didnt waste me time installing this 8)
  16. it sounds like you did not add the sql tables to your database when you did the install
  17. :lol: :lol: :lol: looks like me after a day of coding :lol: :lol: :lol:
  18. it may be a local issue - when i first installed the version with flags and tested it on my local machine the flags were not showing - when it uploaded it to my production server the flags showed up....?
  19. and is that one of you? :? as for Ians Spider Killer, there is a problem with it under SSL - there is a thread called New Spider (search for those 2 words) and you will find a version of the Spider Killer that goes into output_html.php that works really well.
  20. you are correct Linda, it should be 1 or 0 here is the code I am working on and I am getting an SQL error, but don't know what the error is since it gives no error number: I am using this in login.php: $date_now = date('Ymd'); tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . $customer_id . "'"); //my mod $xcomp=tep_db_query("select entry_company from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $check_customer['customers_id']. "'"); $xxcomp = tep_db_fetch_array($xcomp); if (substr($xxcomp['entry_company'],'thecomanyname')) { $check_customer['customers_approved']='1'; tep_db_query("update " . TABLE_CUSTOMERS . " set customers_approved? = 1 where customers_id = '" . $check_customer['customers_id'] . "'"); //echo $check_customer['customers_approved']. ' '; //echo 'here i am' . $xxcomp['entry_company']; //exit; } the error seems be the tep_db_query call... any ideas??
  21. well there are only 2 other things that i can possibly think of that could cause the error: 1) permission on the file not set correctly 2) the file is corrupt (GeoIP)
  22. and you also have geoip.inc in the same folder admin/includes/ as the GeoIP.dat file correct?
  23. ok, did you change the path in the statement below to match your path: Add to admin/includes/footer.php (at the bottom): <?php require('../../catalog/' . DIR_WS_FUNCTIONS . 'user_tracking.php'); if ( ADMIN_CONFIG_USER_TRACKING == 'true') { tep_update_user_tracking(); } ?> NOTE: replace /catalog/ with your named directory
  24. did you download the GeoIP.dat file as specificed in the installation directions and place it in the correct folder? it is complaining that it cannot open the file
  25. did you download the GeoIP.dat file as per the install/readme file?
×