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!!
New 
