fix status double counting bug.

[rec10/rec10-git.git] / rec10 / trunk / src / dbMySQL.py

diff --git a/rec10/trunk/src/dbMySQL.py b/rec10/trunk/src/dbMySQL.py
index bf7fb5a..258dcf8 100644 (file)
--- a/rec10/trunk/src/dbMySQL.py
+++ b/rec10/trunk/src/dbMySQL.py
@@ -404,29 +404,30 @@ class DB_MySQL:
             stop  VARCHAR(30),\
             title VARCHAR(100),\
             exp VARCHAR(200),\
+            category VARCHAR(100),\
             UNIQUE unitv(bctype,channel,start,stop,title)\
             )")
         except:
             ""
         #db.commit()
         self.close_db(db)
-    def add_tv(self, bctype, channel, start, stop, title, desc):
+    def add_tv(self, bctype, channel, start, stop, title, desc, category):
         db = self.connect_db()
         db[1].execute('\
         INSERT IGNORE INTO tv \
-        VALUES (%s,%s,%s,%s,%s,%s)', \
-                      (bctype, channel, start, stop, title, desc))
+        VALUES (%s,%s,%s,%s,%s,%s,%s)', \
+                      (bctype, channel, start, stop, title, desc, category))
         #db.commit()
         self.close_db(db)
     def add_multi_tv(self, tvlists):
         """
-        tvlists is (bctype,channel,start,stop,title,desc) lists.
+        tvlists is (bctype,channel,start,stop,title,desc,category) lists.
         """
         db = self.connect_db()
         db[1].executemany('\
         INSERT IGNORE INTO tv \
-        (bctype,channel,start,stop,title,exp) \
-        values(%s,%s,%s,%s,%s,%s)', \
+        (bctype,channel,start,stop,title,exp,category) \
+        values(%s,%s,%s,%s,%s,%s,%s)', \
                           tvlists)
         #db.commit()
         self.close_db(db)