Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Vince76

Archived
  • Posts

    69
  • Joined

  • Last visited

Everything posted by Vince76

  1. nice but you can also just make a copy of the user_tracking table and name it user_tracking_searchengines to keep the data seperate ;) and ofcourse copy admin/usertracking.php to user_tracking_searchengines.php and change all table and filename data in it. i changed in admin/user_tracking.php if (($whos_online['full_name'] == "Guest") && ($whos_online['session_id'] == "")) { ? ? ? $user_tracking[$whos_online['session_id']]['full_name'] = '<font color="ff0000"><b>Spider</b></font>'; ? ?tep_db_query("INSERT INTO " . TABLE_USER_TRACKING_SEARCHENGINES . " SELECT * FROM " . TABLE_USER_TRACKING . " WHERE session_id = '" . $whos_online['session_id'] . "'"); ? ?tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE session_id = '" . $whos_online['session_id'] . "'"); } just to give you an idea <{POST_SNAPBACK}> I'd like to know more about this, not quite sure what to do there. I copied and renamed the dbase and file but not sure what to do next with the above code? Cheers
  2. First of all if I were you guys I'd remove the JS redirect and the onmouseovers and make it a real sitemap.. Now my question, does anyone know how to get the sitemap products page to span pages? I use this contrib because saves me adding new products to the sitemap page but it will just timeout with too many products and needs the ability to span pages. Anyone got any ideas?
  3. This contrib is excellent thanks. I only have one problem the dhtml menu is appearing behind the form feilds. Anyway to have it always ontop?
  4. Hmm ok thanks for the reply. I won't be turning that off in a hurry so I guess I will have to live with out this contrib. Thanks again..
  5. OK! I figured it out... You don't need fancy mods like PWA and other purchase without account contribs and have to edit 20 files.. 2 Simple changes in two files will create this checkout process Checkout -----> Create Account -----> Checkout Shipping -----> Checkout Payment Open checkout_shipping.php Change this code: // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); To this: // if the customer is not logged on, redirect them to the create account page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL')); Open create_account.php Find this: tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL')); Replace with this: tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); Good luck with it...
  6. I looked at contribs and searched but couldn't find anything like this... PWA contrib will checkout without an account but I think new customers should be able to click checkout then add their shipping and billing details, account information ie user/pass then continue straight to the credit card payment section which will create their account aswell as allow them to continue the checkout process without bouncing back to login forms, create account forms, or account pages... Does anyone know if there is anything like this? Cheers..
  7. ANyone using this contrib successfully? All I get is the line No products viewed...or cookies not enabled. Yes cookies are enabled... Thanks..
  8. I can't get this to work, after installed it shows nothing... in catalog/product_info.php ---------------------------- insert this code ... if (!tep_session_is_registered('recently_viewed')) ?{ ?tep_session_register('recently_viewed'); ?$recently_viewed = $HTTP_GET_VARS['products_id'] . ';'; ?//$recently_viewed = ""; ?} $check_not_duplicate = $HTTP_GET_VARS['products_id']; $temp_recent = $recently_viewed; if (!ereg($check_not_duplicate, $temp_recent ) ) $recently_viewed = $HTTP_GET_VARS['products_id'] . ';' . $recently_viewed; I put it just before $product_info_query = tep_db_query("select or $product_info = tep_db_query("select ?on some versions but it isn't that important. "but it isn't that important" Does that mean that peice of code doesn't need to be added? Cheers..
  9. I can't get this contrib to work and I followed the readme to the letter 3 times.. I just keep getting the error can't find TABLE_VISUAL_VERIFY_CODE, but it's in the database I can see it.. Anyone know of another contrib that can do something similar? Cheer...
  10. Right... there is always something left to check... It was the '$content' what wasn't in the correct place... now it's all working fine! Thanks for your help Vince. Glad it was something simple ;-)
  11. Is this the name of your file in the sts_templates folder "sts_product_info.php.html" ? If it is change it to "product_info.php.html"
  12. Did you apply the 25 Aug 2004 - STS 2.01 Bug fixes? If so I found that using that killed my product_info.html pages. This fix with in the sts_display_output.php worked for me http://www.oscommerce.com/forums/index.php?sho...ndpost&p=441854 I did that after I applied the 25 Aug 2004 - STS 2.01 Bug fix Good luck with it!
  13. I think there is something on it about 50 pages back lol This thread is getting waaaay to big.. Just make up a html page and call it index.php_"catnumber".html then place it inside you includes/sts_templates/ folder and that's about it.
  14. Thanks for the replies Iggy and Kevin, my current problems exist specifically with contribs which involve the product_info.php. I would like to take advantage of using the sts templates for making new product info pages but I really can't use the sts product info pages unless the contribs are working on them. After exhausting most of the reading material on the subject at these forums I tried adding the extra contrib code which I hacked into the product_info.php to originally get the contribs to work, and copying that code into the sts version of the product_info. I used the attributes code in the sts product_info as a guide for the format, removing all the <?php ?> tags etc. For example with Master Products I used the below code from the product_info.php //START MASTER PRODUCTS //a check to see if there are slave products and if so check if they are active(product_status) if not don't activate the slave section $master_product_query=tep_db_query("select p.products_status, p2m.master_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_MASTER . " p2m where master_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.products_id=p2m.slave_id and p.products_status = '1'"); if (tep_db_num_rows($master_product_query) > 0) { ?> <tr> <td><?php echo TEXT_OPTIONS?></td> </tr> <?php // create column list $define_list = array('PRODUCT_LIST_MODEL' => SLAVE_LIST_MODEL, 'PRODUCT_LIST_NAME' => SLAVE_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => SLAVE_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => SLAVE_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => SLAVE_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => SLAVE_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => SLAVE_LIST_IMAGE, 'PRODUCT_SLAVE_BUY_NOW' => SLAVE_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } $listing_sql = "select " . $select_column_list . " p.products_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, pm.master_id, pm.slave_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_MASTER . " pm, " . 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.products_id=pm.slave_id and pm.master_id='" . (int)$HTTP_GET_VARS['products_id'] . "'"; if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $uni .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> <?php } //END MASTER PRODUCTS Then added this code to sts_product_info.php //START MASTER PRODUCTS //a check to see if there are slave products and if so check if they are active(product_status) if not don't activate the slave section $master_product_query=tep_db_query("select p.products_status, p2m.master_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_MASTER . " p2m where master_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.products_id=p2m.slave_id and p.products_status = '1'"); if (tep_db_num_rows($master_product_query) > 0) { $template['textoptions'] = TEXT_OPTIONS; // create column list $define_list = array('PRODUCT_LIST_MODEL' => SLAVE_LIST_MODEL, 'PRODUCT_LIST_NAME' => SLAVE_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => SLAVE_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => SLAVE_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => SLAVE_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => SLAVE_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => SLAVE_LIST_IMAGE, 'PRODUCT_SLAVE_BUY_NOW' => SLAVE_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } $listing_sql = "select " . $select_column_list . " p.products_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, pm.master_id, pm.slave_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_MASTER . " pm, " . 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.products_id=pm.slave_id and pm.master_id='" . (int)$HTTP_GET_VARS['products_id'] . "'"; if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $uni .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } $template['filenameproductlisting'] = FILENAME_PRODUCT_LISTING; //END MASTER PRODUCTS All I got inplace of where the $variable call in the product_info.php.html template was, was the words "product_info.php" instead of the master products contrib. Hopefully this explains the problem a little more. Cheers..
  15. Can anyone give some ideas on how to add contributions to sts. I been going all day without success. I have been through 80 pages of this thread but no answers. I have tried searching the forums and google, and even experimenting myself with poor results. I am trying to use, EZfeilds, master products, and text feild option attributes with sts but can't seem to get anything working. Is there a special way we are supposed to go about adding contribs to sts? Could someone write up maybe some short docs as to what kind of things we need to think about when trying to use contribs with sts? Sts is a great idea but it's not much good if us php noobs can't use it with other contribs. I'd prefer to lose cosmetics over functionality anyday but would be nice to have both ;-) cheers..
  16. Ok Fixed it! All I did was revert back to the original code for override popup window section. Replaced /* ///////////////////////////////////// ERROR FIXED by Walo ///////////// ///////////////////////////////////////// ERROR FIXED by Walo ///////////// ///////////////////////////////////////// ERROR FIXED by Walo ///////////// // Override if we need to show a pop-up window $scriptname = $_SERVER['PHP_SELF']; $scriptname = getenv('SCRIPT_NAME'); $scriptbasename = substr($scriptname, strrpos($scriptname, '/') + 1); // If script name contains "popup" then turn off templates and display the normal output // This is required to prevent display of standard page elements (header, footer, etc) from the template and allow javascript code to run properly if (strpos($scriptname, "popup") !== false || strpos($scriptname, "info_shopping_cart") !== false) { $display_normal_output = 1; $display_template_output = 0; } ///////////////////////////////////////// ERROR FIXED by Walo /////EOF///// */ // Override if we need to show a pop-up window $scriptname = $_SERVER['PHP_SELF']; // Returns file name without path nor parameters $scriptbasename = substr($scriptname, strrpos($scriptname, '/') + 1); $scriptname1 = strstr($scriptname, "popup"); $scriptname2 = strstr($scriptname, "info_shopping_cart"); // If script name contains "popup" then turn off templates and display the normal output // This is required to prevent display of standard page elements (header, footer, etc) from the template and allow javascript code to run properly if ($scriptname1 != false || $scriptname2 != false) { $display_normal_output = 1; $display_template_output = 0; } With original version // Override if we need to show a pop-up window $scriptname = $_SERVER['PHP_SELF']; $scriptname = getenv('SCRIPT_NAME'); $scriptbasename = substr($scriptname, strrpos($scriptname, '/') + 1); // If script name contains "popup" then turn off templates and display the normal output // This is required to prevent display of standard page elements (header, footer, etc) from the template and allow javascript code to run properly if (strpos($scriptname, "popup") !== false || strpos($scriptname, "info_shopping_cart") !== false) { $display_normal_output = 1; $display_template_output = 0; } Seems to work fine for me now. Cheers..
  17. I should have been a little more specific, when I say page specific templates not working I mean product_info.php.html specifically. I can delete that file and there is no change even though I have applied the latest fix..
  18. Sounds like your having the same problem I am, the product info template doesn't seem to be kicking in and its reverting to the default sts index template. Try deleting the product_info.php.html and if there is no change your having the same prob as me..
  19. Just tried the 25 Aug 2004 - STS 2.01 Bug fixes but page-specific templates still not working. If I revert back to the sts 2.00 sts_display_output.php they work but then I lose the meta tags and header tag options. Any ideas? Cheers..
  20. Well got it sorted, cost me $150 to get someone to sort it for me though ;)
  21. Farnastic: Yes, I am looking for a text box just like this!! Can you tell me if this is a contribution ? I would appreciate any help. I have the attribute type contribution installed and can't get a textarea to work. Thanks! I just found this http://www.thewebmakerscorner.com/freecall...products_id=130 I think that's what they are using there, although I don't really want to start from scratch just for one mod.
  22. Does anyone know of another contribution that does something similar? I have installed literally dozens of contributions recently and I haven't even got a clue how people are even getting passed hacking tthe code and uploading their files for this one. My products_info.php is nothing like the one supplied, guess It's been hacked up to0 much. Anyone know of another similar contrib for text feild attributes which actually has a readme with the code changes in it? I desperately need the text input because the current way the attributes are setup in oscommerce fill up the dbase way to easily. I've added only 150 products and there were already 500+ pages of attributes and over 7500+ entries in the dbase lol Makes easypopulate stop working :( Any ideas would be very helpful.
×
×
  • Create New...