Changeset 765 for pykota/trunk/pykota/storages/sql.py

Timestamp:

02/08/03 23:12:09 (21 years ago)

Author:

jalet

Message:

Life time counter for users and groups added.

Files:

• pykota/trunk/pykota/storages/sql.py (modified) (2 diffs)

pykota/trunk/pykota/storages/sql.py

@@ -15 +15 @@
 #
 # $Log$
+# Revision 1.15  2003/02/08 22:12:09  jalet
+# Life time counter for users and groups added.
+#
 # Revision 1.14  2003/02/07 22:13:13  jalet
 # Perhaps edpykota is now able to add printers !!! Oh, stupid me !
@@ -171 +174 @@
         (userid, printerid) = self.getUPIds(username, printername)
         if (userid is not None) and (printerid is not None) :
-            self.doQuery("UPDATE userpquota SET pagecounter=pagecounter+(%s) WHERE userid=%s AND printerid=%s;" % (self.doQuote(pagecount), self.doQuote(userid), self.doQuote(printerid)))
+            self.doQuery("UPDATE userpquota SET lifepagecounter=lifepagecounter+(%s), pagecounter=pagecounter+(%s) WHERE userid=%s AND printerid=%s;" % (self.doQuote(pagecount), self.doQuote(pagecount), self.doQuote(userid), self.doQuote(printerid)))
         
     def buyUserPQuota(self, username, printername, pagebought) :