Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rabbitseffort

Archived
  • Posts

    1,339
  • Joined

  • Last visited

Everything posted by rabbitseffort

  1. I think I gave you the right answer here It has nothing to do with the arrogant response initially given to you by Jan, what is osC forums coming to, my goodness, a representative of this site should not act like that Good luck, HTH
  2. I just installed this on a test site, but during checkout payment when I add a valid code that is set for no minimum amount, no start or expiry date, etc...I keep getting the error that it is not valid--any ideas why? I can checkout fine without the code entered, so seems there may be some code missing possibly from somewhere, I went back thru and all was done properly so far as I can see, and I have installed hundreds of contributions so I know what I am doing in that respect---I appreciate any ideas!! Thanks for the help!
  3. I also get an error when using the $today = now(); Fatal error: Call to undefined function: now() in /home/.......... with $today = date("d/m/Y"); a date will show up but about 3 days late so I fixed it like so: Find line 21: $today = date("d/m/Y"); and change it to this: //$today = date("d/m/Y"); Then find this: <td class="pageHeading" width="50%"><?php /// BEGIN CRAZY!!! LOGIC FOR 3 TITLES if ($orderlist_days > 0 && $orderlist_days != NULL && !isset($_GET['month']) ) { and change it to this: <td class="pageHeading" width="50%"><?php echo strftime(DATE_FORMAT_LONG); ?><br><?php /// BEGIN CRAZY!!! LOGIC FOR 3 TITLES if ($orderlist_days > 0 && $orderlist_days != NULL && !isset($_GET['month']) ) { If I make any other pertinent observations I will post back here--thanks Insomniac
  4. works like it should for me, good contribution-- I agree figuring a way for the sql table to not get overloaded will be good--hmmm thanks!
  5. so about the above error, seems that this line of code is causing the error, can you help me write it in a way that isn't screwy for the sql syntax? $next_product_query = "select products.products_id from " . TABLE_PRODUCTS . " , " . TABLE_PRODUCTS_TO_CATEGORIES . " where products.products_status = '1' and products.products_id > '" . (int)$HTTP_GET_VARS['products_id'] . "' and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = $next_product_category "; $next_product_result = tep_db_query($next_product_query); $next_product_array = tep_db_fetch_array($next_product_result); if($next_product_array['products_id'] > 0){ $next_product_id = $next_product_array['products_id']; $next_button = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $next_product_id) . '">' . tep_image(DIR_WS_IMAGES . 'nextprod.gif') . '</a>'; }else{ $next_button = ''; also, about using the customers firstname instead of id, can somehow this code from product_info be used the way it calls for the first name? // send email notify about higher bid than the other customer's bid who won $sql_customer = 'select customers_lastname, customers_firstname, customers_email_address from '. TABLE_CUSTOMERS." c,". TABLE_AUCTIONS_BIDS." ab where c.customers_id=ab.customers_id and ab.auctions_id= '$auction_id' and ab.bid_price<".(int)$bid_price."";$acustomer_query = tep_db_query($sql_customer); while ($acustomer = tep_db_fetch_array($acustomer_query)) { $acustomer_firstname = $acustomer['customer_firstname']; $acustomer_lastname = $acustomer['customers_lastname']; thanks much, I appreciate the time!!
  6. Thanks again Jan--=both of your ideas here worked for me--but I don't want to display the customers whole name, just first name--I will see if I can do that somehow any idea on this error I get after hitting place bid? 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select products.products_id from products , products_to_categories where products.products_status = '1' and products.products_id > '0' and products.products_id = products_to_categories.products_id and products_to_categories.categories_id =
  7. Getting this error now when trying to bid: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select products.products_id from products , products_to_categories where products.products_status = '1' and products.products_id > '0' and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = any ideas why? thanks
  8. You can possibly use the contribution "manual order entry" for adding a won item to the customers basket-- I agree the admin area needs much in the way of management but I still love this script, I have wanted something like this for more than 2 years now--are the original authors still helping?
  9. Thanks Jan--I will know shortly if the email fix works, but the countdown is still screwy, I set my current test auction to end on Jan 31, but the counter reads : Auction Ends On: 2007-01-31 00:00:00 (43 days + 1h : 24m : 23s left) Obviously not right???? I have my date confirgured in auction_bids as follows, I am GMT-8 in California, is this set right? var month = '*'; // '*' for next month, '0' for this month or 1 through 12 for the month var day = '<?php echo '+'.$datetime_count_down['2']; ?>'; // Offset for day of month day or + day var hour = '<?php echo $datetime_count_down['3']; ?>'; // 0 through 23 for the hours of the day var tz = -8; // Offset for your timezone in hours from UTC var lab = 'countdown_date'; // The id of the page entry where the timezone countdown is to show thanks again! I am still trying to get the bid confirm button to go to a bid confirmation page rather than the products info page, or at least have it simply refresh the exisiting page and it mighte be good to have the customers first name instead of the customer ID number so they understand where they are in the bidding process, how might I accomplish this?
  10. Also, no emails are being sent-- is there supposed to be an admin page that gives me a list of bidders? thanks
  11. I made the suggested changes to product_info but no help, the date still doesn't show?? I will try the rest now--thanks! ok--the agree to terms works now, thanks! still want the timer to be right, it is way off, and "date bid added" to work--- also would be a treat to have an admin page with all bidder info there, nad maybe an option to email them straigt from the admin
  12. I have just installed this on a very modified shop, and so far it seems good, my kudos to those involved. There are some missing install instructions, but so far I have worked it out in only a few hours. Now for my errors/concerns so far-- 1.The terms and conditions box does not have to be checked for a bid to be placed. 2.The "date bid added" column does not have any info except all zeros 3.I would prefer the place bid button take you to a bid confirmation page rather than the products info page, I tried and failed at modding the code for that one. So maybe that is all for now--someone please advise me here--thank you much! Oh, and also not getting email notifications of bids being placed, like ebay's bid confirmed system?? Is this supposed to happen ps--I installed the last version 1.4_1
  13. you are the only one to report this hasnt worked right for them--not sure what to tell you the 3 is the orders status id--if you want it to be 2 or 1 you can depending on the orders status number in you sql
  14. yes--to see the orders that are anything but pending go to your orders2.php page
  15. If you search the forums for the very popular 1064 error you should find the answer pretty easily---or PM Daemonj since he helps loads with this idea becoming a reality
  16. you will admin it thru the specials admin part, quoting roy above: "The install file tells you that you can change "Selection of Products on Special".--" and if you want your entire catalog to loop then follow his other instruction here: But if you want, you can modify the sql line: $random_products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' order by rand() limit " . MAX_RANDOM_SELECT_SPECIALS); if you lop off everything after rand() so that it looks like rand()" );, that will select everything." If the info box is empty be sure you uploaded the javascript files in the package--that is most likely the cause
  17. looks like the sql wasnt ran or ran improperly, it is stating you dont have that table--the cron job isnt necessary so that isnt it--it is your database
  18. ellen, be sure you have the file it is telling you it cant find: includes/functions/links.php
  19. I saw the error message, but when I waited a few minutes and refreshed it was gone--maybe your database was slow to update?
  20. I know this thread is dead and there seems to be no help here anymore, but I only have one more issue I would like resolved how can I have the prefix for + or - automatically filled in on the grid in the new listing page? It is automatically a + on the attributes page, so I know it is an easy one to do, thanks in advance
  21. if you mean the links for sortings etc, then it is .productListing-heading { or if you mean the bacground color under those links it is .linkListing-heading {
  22. I dont use the call for those images--so I delete the call line in the html on the page--I dont like the look of the upper right images and I always modify the text for the title next to that image also
  23. I dont use column_right so I dont think that is the issue--it says in the error that is sint finding this: includes/boxes/card.php, so you must have column right being called and in column_right the card.php must not be commented out--the easy way to handle it is to remove the call for column_right.php from the files in question--my files call column_right.php but I have everything in the column_right file commented out so I get no errors anyway
  24. Thanks then--I suppose I will just try your above suggestion then--I appreciate all your time and help
×
×
  • Create New...