[Astpp-commit] SF.net SVN: astpp: [2170] trunk/astpp-common.pl

[<dar...@us...>]

Revision: 2170
          http://astpp.svn.sourceforge.net/astpp/?rev=2170&view=rev
Author:   darrenkw
Date:     2007-12-28 20:26:16 -0800 (Fri, 28 Dec 2007)

Log Message:
-----------
Resolved: [ 1847735 ] refill bugs

Modified Paths:
--------------
    trunk/astpp-common.pl

Modified: trunk/astpp-common.pl
===================================================================
--- trunk/astpp-common.pl	2007-11-19 10:12:08 UTC (rev 2169)
+++ trunk/astpp-common.pl	2007-12-29 04:26:16 UTC (rev 2170)
@@ -3549,17 +3549,17 @@
 	# Status 2 means the card has expired.
 	# Status 3 means the card is empty.
 	my ($astpp_db,$cardinfo) = @_;
-	my $now = $astpp_db->selectall_arrayref("SELECT NOW() + 0")->[0][0];
+	my $now = $astpp_db->selectall_arrayref("SELECT NOW()")->[0][0];
 	print STDERR "Present Time: $now\n";
 	print STDERR "Expiration Date: $cardinfo->{expiry}\n";
 	print STDERR "Valid for Days: $cardinfo->{validfordays}\n";
-	print STDERR "First Use: $cardinfo->{firstuse}\n";
+	print STDERR "First Use: $cardinfo->{firstused}\n";
 	if ( $cardinfo->{inuse} != 0 )
 	{                
 		return 1; #Status 1 means card is in use.
 	}
 	if ( $cardinfo->{validfordays} > 0 ) {
-		$now = $astpp_db->selectall_arrayref("SELECT NOW() + 0")->[0][0];
+		$now = $astpp_db->selectall_arrayref("SELECT NOW()")->[0][0];
 		if ( $now gt $cardinfo->{expiry} && $cardinfo->{expiry} ne "0000-00-00 00:00:00" ) {
 			my $sql =
 			  "UPDATE callingcards SET status = 2 WHERE cardnumber = "


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.