Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Haerith

Members
  • Content count

    2
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ana Chrys
  1. Haerith

    [Contribution] Auction Module

    Silly me.. Nevermind bout my 3rd observation... I remembered about the contribution "auctions_countdown_patch_1.tar" that I had used previously that had done the trick ;)
  2. Haerith

    [Contribution] Auction Module

    Hello all. I'm quite amazed with this module but I have some questions to make: 1st: When a costumer tries to make a bid here's what he gets: 1264 - Out of range value adjusted for column 'auctions_bids_id' at row 1 insert into auctions_bids (auctions_bids_id, auctions_id, customers_id, bid_price, bid_status, bid_date_added ) values ('', '1', '2', '17', '', now()) [TEP STOP] I've checked the data base and the field auctions_bids_id is set to Auto Increment so I really can't tell why this is happening. 2nd: About the time countdown issue. It should really be set using the server time. I've searched the net and found some scripts on how to get a server time. Thing is I'm no programmer and I can't mix things so it works how we want. Maybe this won't help a thing but here's a code I found at javascriptsource.com: <!-- THREE STEPS TO INSTALL SERVERDATE TO java script: 1. Save the code in a file called "servertime.php" 2. Copy the coding into the HEAD of your HTML document 3. Add the last code into the BODY of your HTML document --> <!-- STEP ONE: Paste this code in a file called "servertime.php" (without the quotes) and place it in the main directory of your site. Change mode to executable - chmod 755 --> <?php /* Copyright 2005 Emery Wooten - www.mresoftware.com This script is called from Javascript. It should be called before any JavaScripts that use the date. Place the statement below in the <head> section of your HTML page: <script type="text/javascript" src="servertime.php"></script> */ // Supress errors error_reporting(0); /* If your server is not in your time zone, adjust it here. Mine is 1 hour East of me. To use this variable, you will need to remove the "//". // $myServerOffset = (+1) * 3600; // Get server date $mydate = date("U"); // Get Timezone offset $myoffs = date("Z") - $myServerOffset; // Adjust offsets for local machine print "var tzoffset = $myoffs + (new Date().getTimezoneOffset()*60);"; // Set JavaScript variable to your server time as seen from client machine's location. print "var servertimeOBJ=new Date(($mydate+tzoffset)*1000);"; ?> <!-- STEP TWO: Paste this code into the HEAD of your HTML document --> <HEAD> <script language="JavaScript" src="servertime.php"></script> <script type="text/javascript"> <!-- Begin /* This script and many more are available free online at The JavaScript Source!! http://javascript.internet.com Created by: Emery Wooten :: www.mresoftware.com */ // First thing, reference the variable. var servertimeOBJ; // Now check that it is set if (servertimeOBJ != null){ var myscriptTime = servertimeOBJ; } // If server time not passed, use client's time else{ var myscriptTime = new Date(); } /* "myscriptTime" is a variable local to this script. Name it as you wish. After the above code is executed, this local variable is used for all date/time calculations performed by the script. If all works, this variable contains the server date as a proper JavaScript date object. */ // End --> </script> </HEAD> <!-- STEP THREE: Copy this code into the BODY of your HTML document --> <BODY> <script type="text/javascript"> <!-- Begin document.write(myscriptTime) // End --> </script> <p><center> <font face="arial, helvetica" size"-2">Free JavaScripts provided<br> by <a href="http://javascriptsource.com">The JavaScript Source</a></font> </center><p> It only uses JavaScript and PHP so I believe it's a good thing to be used, no? 3rd: When I first installed the mod (v. 1.42) I noticed the countdown time bug but after browsing this topic I somehow managed to fix it a bit (I had set the expire time to the next day and it was counting 11 days till end of bidding but after messing a bit I managed to put the number of days to 0, but then I don't know what I did it was all wrong again and I tried to do the same steps as before but this time I can't put it right) I'm so loving this module and I do wish you keep up the good work! I just wish I could be more of assistance!!
×