Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

TB

Archived
  • Posts

    585
  • Joined

  • Last visited

Everything posted by TB

  1. I've just updated the download on the contribution page so this should solve any further problems. :) If you're looking for the contribution, it can be found here: http://www.oscommerce.com/community/contributions,236 Cheers, Tony
  2. NZ Bank Transfer module for those New Zealand osCommerce users who want to offer bank transfer as a payment method. This module displays: Account Name, Account Number and Bank Name. http://www.oscommerce.com/community/contributions,1441 Thanks to: Phil Townsend for the original UK Bank Transfer module. Steve Kemp for modifying the UK module to suit the Australian osCommerce sites, as well as adding administration functionality. This NZ version is based on the Australian version by Steve Kemp.
  3. Do you have access to phpMyAdmin? If yes... read on. Select your database from the drop down box in the left of your screen. Then, select 'SQL' from the top menu on the right of your screen. Copy the following code and paste it to the text box on your phpMyAdmin screen. ALTER TABLE `customers` ADD `customers_group_name` CHAR( 27 ) DEFAULT 'Retail' NOT NULL , ADD `customers_group_id` INT( 11 ) DEFAULT '0' NOT NULL; CREATE TABLE `products_groups` ( `customers_group_id` INT( 11 ) NOT NULL , `customers_group_price` DECIMAL( 15, 4 ) NOT NULL , `products_id` INT( 11 ) NOT NULL , `products_price` DECIMAL( 15, 4 ) NOT NULL ); Press 'Go' Some should appear saying 'Successful', and vaugly resemble what you pasted previously. That should be it... Let me know if you have any more troubles, Tony
  4. Ralf... YOU'RE DA MAN! I don't know what code magic you're working there, but it's all going great! Well... nearly... :) The only part that isn't working is the redirect is still showing my '?ref=' could this be because it's using ? instead of &... does it matter which one I use? Could it also be because I'm hard coding it into the URL on the linked site? Ohh.. and if someone types any form of '&blah=blah' using the & symbol... the javascript code gets stuck in a continual loop. Thanks again for all what you've done so far... it's MAGIC! Tony
  5. Ralf, Although you don't think you're a JavaScript guru, you know mroe about it than I do! One thing, and this may seem pedantic for those who run their sites in the root directory, though it may be a real issue for those who run theirs under 'domainname.com/catalog/'. But is there any way to remove the second '/' that gets added by the redirect statement? tep_redirect(tep_href_link($PHP_SELF, tep_get_all_get_params($parameters))); Also, as you will notice if you look at the URL of my WWW, I'm running the Ad Tracker contribution on my site. Is there some way for your code to remove the '?ref=sitename' from the URI? This would be a fantastic option for the Ad Tracker contribution if possible, IMHO. Thanks again for any help... Tony
  6. Adam, Insert the following using phpMyAdmin and you should be right. ALTER TABLE `customers` ADD `customers_group_name` CHAR( 27 ) DEFAULT 'Retail' NOT NULL , ADD `customers_group_id` INT( 11 ) DEFAULT '0' NOT NULL; CREATE TABLE `products_groups` ( `customers_group_id` INT( 11 ) NOT NULL , `customers_group_price` DECIMAL( 15, 4 ) NOT NULL , `products_id` INT( 11 ) NOT NULL , `products_price` DECIMAL( 15, 4 ) NOT NULL ); HTH, Tony
  7. Ralf, THANKS SO MUCH for the code! I've got it working, you can see it here: www.turningbase.com I know this is a long shot and you probably would have done it if possible, but is there any chance of getting rid of the 'javascript=on' form the URI? I know I can rename it to DHTMLMENU=on or something like that, but I'd rather nothing in the URI if possible. Once again, THANK YOU for the code... :D Tony
  8. Does anyone know how to detect if JavaScript is enable with php? What I'm trying to do is load the DHTML menu when JavaScript is enabled, and default back to the original menu when it's not. I've tried the following to test, though it's not working as I thought it would. <SCRIPT LANGUAGE="JavaScript"> <?php define (JAVAON,'Yes'); define (JAVAOFF,'No'); ?> </script> <noscript> <?php define (JAVAON,'No'); define (JAVAOFF,'Yes'); ?> </noscript> <?php echo '<b>Java On?</B> '. JAVAON .'<BR>'. '<b>Java Off? </b>'. JAVAOFF; ?> Can anyone shed some light on this for me? Thanks, Tony
  9. Can someone please let me know how I can make each page title (in top of browser, not breadcrumb.) dyamically show my store name, and the name of the current product. If no product is selected, then the title will just show my store name. This would make a good contribution which will assist in search engine placements too... Thanks for any assistance offered... Tony
  10. David, As per the above post, make sure you and your friend know that the 'Disable Right Click' isn't foolproof. Nothing to do with the way this module is created, but ANYWHERE that uses 'Disable Right Click' isn't foolproof. If someone wants your images, they will get them...
  11. I understand that people want it, and thanks for creating and contributing it for those people. I do agree with Peter though, that it's a PITA for just about everyone... These people who want this feature should really be told how much of a PITA it is... but they wanted it, you created it, thanks for your efforts... though I personally don't use the feature. My $0.02 worth... Tony
  12. Normally this only happens when your server can't connect to the Austpost server. You will see the same screen if you're testing on a local server that isn't connected to the internet. Does it consitantly give you this error, or just some of the time?
  13. What tha?? Which contribution? My crystal ball is out of service... If you're talking about the contribution which automatically creates thumbnails from the larger images, you'll have to wait until PHP is updated. The patent on the GIF format has only just expired (20-06-2003) so we'll probably see a mixed reaction to it's uptake. NOTE: Patents are still in force until 2004 in Canada, France, Italy, Germany, United Kingdom and Japan. Some people will be 'anti' GIF because UNISYS (patent owners) wanted users to pay a licensing fee to use the LZW (Lempel Ziv Welch) compression in their software, which is the compression technique in standard GIF files. PNG is being supported by more and more browsers... (post 1997, only about 1% of internet users left that don't support PNG) so both PNG and JPG look like being the way ahead. The PNG format offers transparency and in most cases a reduction in file size compaired to GIF. If you're still not convinced about dropping the GIF format, read this UNISYS page: http://www.unisys.com/about__unisys/lzw/lz...se__english.htm According to this site, if you use licenced software to create your GIF's than you're also licenced to use those images on your website, though you could be up for a big surprise if the software you used isn't licenced to use LZW compression. A BS money making game from UNISYS in my opinion! HTH, Tony
  14. I've made a test account for my store, which you're welcome to use in testing the wishlist (and other mods). My other posts should detail the problems I came across, so please look there before PMing me with 1000 messages... my inbox is constantly overflowing. This thread here is a good start: http://www.oscommerce.com/forums/viewtopic.php?t=50005 Username: tester@localhost Password: tester Please respect that other people will want to test this out also... and will probably be 'playing' with the wishlist at the same time, so if products appear, it's probably because someone else has added them. Clean up after you're finished... and we'll all be happy. :) Cheers, Tony
  15. Read back through this thread... you will see that the problem will be with your <form> tag.
  16. Try the Cross Sell contribution out: http://www.oscommerce.com/community/contributions,1005
  17. I have it set-up. You can view it here if you like: www.turningbase.com
  18. Does anyone know of a way to make this menu default back to the original when a browser with Java disabled is used? I was thinking something along the lines of this sort of code: <script> <?php include 'dhtml_menu.php'; ?> </script> <noscript> <?php include 'stnd_menu.php'; ?> </noscript> Though it didn't work... I think due to the include not working properly inside the <noscript> tags... Any help is appreciated... would also be a good addition to the contribution. Thanks, Tony
  19. Good point which I forgot also... I copy the zip files to an 'add-ons' folder so I know at a glance what contributions I have installed. I also keep at least five COMPLETE site backups... not all of the one version, but rather than copying over the last backup, I just rename them in sequential order... so, should anything from my last few changes stuff things up, I just upload a working backup and all is fine... hopefully! :) I also keep an exact repositry of my website on my local drive, so I can do testing offline and know the results I will get... when I'm happy with the changes I just upload the modified files and violla... all is good.
  20. What I normally do when installing a contribution is extract the files to a new folder. Noting the ?NEW? folder? so at to DEFINATLY not just paste over my old files. Instead, I use ExamDiff (similar to BeyondCompare) to find the required differences and install them manually. Once I have finished the installation for each file, I delete it from the NEW folder so I know all changes from it have been completed. This is the way I do it? others may have different ideas/methods? I?d like to hear them if they do... it'll help me, you and hopefully a lot of others. Cheers, Tony
  21. I don't get what you're after? If you want to add a cost for the purchase of the CD box for shipping, just change your handling cost in the "Admin >> Modules >> Shipping >> Australia Post" screen.
  22. You still need the original wishlist file. The MS1 update from Johnson is just that... an update to make the wishlist work under MS1. This missing SQL portion from the original which you require is this: (Run it in phpMyAdmin) # # Database table for customers_wishlist` # CREATE TABLE customers_wishlist ( products_id int(13) NOT NULL default '0', customers_id int(13) NOT NULL default '0', products_model varchar(13) default NULL, products_name varchar(64) NOT NULL default '', products_price decimal(8,2) NOT NULL default '0.00', final_price decimal(8,2) NOT NULL default '0.00', products_quantity int(2) NOT NULL default '0', wishlist_name varchar(64) default NULL ) TYPE=MyISAM; HTH, Tony
  23. Does anyone have a problem with the module timing the server out? I can get the results perfectly from my test server (56k dial-up in AU), though my server in the US doesn't like it at all... takes forever to load... and times out after showing no information. Is there a server setting I need to change? I have tried the time-out in PHP though it had no effect. Thanks, Tony
  24. The * query problem * didn't end up being a query problem at all. With MS2CVS, I had to change the splitPageResults function. Change this: $wishlist_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_WISHLIST_PRODUCTS, $wishlist_query_raw, $wishlist_numrows); To this: $wishlist_split = new splitPageResults($wishlist_query_raw, MAX_DISPLAY_WISHLIST_PRODUCTS); Change this: if ($wishlist_numrows > 0 && (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3')) { To this: if (($wishlist_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { Change this: <td class="smallText"><?php echo $wishlist_split->display_count($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_WISHLIST); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE; ?> <?php echo $wishlist_split->display_links($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> To this: <td class="smallText"><?php echo $wishlist_split->display_count(TEXT_DISPLAY_NUMBER_OF_WISHLIST); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $wishlist_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> Change this: if (tep_db_num_rows($wishlist_query)) { To this: if ($wishlist_split->number_of_rows > 0) { Change this: if ($wishlist_numrows > 0 && (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3')) { To this: if (($wishlist_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { Change this: <td class="smallText"><?php echo $wishlist_split->display_count($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_WISHLIST); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE; ?> <?php echo $wishlist_split->display_links($wishlist_numrows, MAX_DISPLAY_WISHLIST_PRODUCTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> To this: <td class="smallText"><?php echo $wishlist_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $wishlist_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> Try that out... I don't know if it'll work on MS1. I've got the module 75% working (problem is incorrect number of product on page)... if the changes work for you, all the better. If not, than sorry... it may be MS2 or my site only.
  25. Yes, I do have one modification of my own, the 'CTBN_BREADCRUMB_SHOW_BROWSER_TITLE' though it won't make a difference on anyone elses setup since it will equal 'false' and revert to the original method of showing the browser title. I think the errors are due to the difference between the number of arguements required for the 'splitpageresults' function in MS1 and MS2CVS. On this note, can someone test this under a stock standard MS2CVS and return your results. Thanks, Tony
×
×
  • Create New...