This is the entire function:
function stamp_purchases($user)
{
//$userid=$user;
echo $user."=Userid<br>";
$result=dbquery("SELECT purit.purchaseid AS purchaseid, purit.pkgid, pkgit.playid, pk.gamestart, UNIX_TIMESTAMP(gamestart) AS killdate, pl.playid, pkg.* FROM purchase_items AS purit, pkg_items AS pkgit, purchase AS pur, plays as pl, picks AS pk, packages AS pkg WHERE purit.purchaseid=pur.purchaseid and purit.pkgid=pkgit.pkgid and pkgit.pkgid=pkg.pkgid and pkgit.playid=pl.playid and pk.playid=pl.playid and userid='$user' and pur.pending='0' AND pur.start='0000-00-00 00:00:00'");
while($row=mysql_fetch_array($result))
{
echo $row['gamestart']."=Gamestart. ".$row['duration']."=Duration. ".$row['pkgid']."=PKGID.<br>";
$currentdt=time();
$startdt=mktime(0, 0, 0, date("n", $currentdt), date("j", $currentdt), date("Y", $currentdt));
$duration=$row['duration'];
echo $startdt."=StDt.<br>";
echo $currentdt."=CurrDt.<br>";
echo $duration."=duration.<br>";
//echo $startdt."=StDt.<br>";
$purchaseid=$row['purchaseid'];
if (($currentdt > $startdt && $currentdt < $row['killdate']) && $row['killdate'] < ($startdt + ($duration * 86400)))
{
$duration=$row['duration'];
echo $duration."=Duration.<br>";
$killdt=$startdt+($duration * 86400);
echo $killdt."=Killdate new.<BR>";
$killdt=mktime(0, 0, 0, date("n", $killdt), date("j", $killdt), date("Y", $killdt));
echo $killdt."=Killdate mktime.<BR>";
$resultinsert=dbquery("UPDATE purchase SET start='$currentdt', killdt='$killdt' WHERE userid=purchaseid='$purchaseid'") or die("Record not updated");
}// End If currdt
else
{
if ($currentdt > $row['killdate'])
{
$startdt=$startdt + 86400;
$killdt=$startdt + ($duration * 86400);
$resultinsert=dbquery("UPDATE purchase SET start='$stardt', killdt='$killdt'") or die("Record not updated");
}
} // END Else
} // end While
}// End Function
Output is below:
11=Userid
2003-06-23 19:00:00=Gamestart. 1=Duration. 3=PKGID.
1056340800=StDt.
1056390091=CurrDt.
1=duration.
1=Duration.
1056427200=Killdate new.
1056427200=Killdate mktime.
2003-06-23 21:15:00=Gamestart. 1=Duration. 3=PKGID.
1056340800=StDt.
1056390091=CurrDt.
1=duration.
1=Duration.
1056427200=Killdate new.
1056427200=Killdate mktime.
Yet when I check the records in the table (purchase) the time stamp update does not work.
This is bugging me now🙁
