United States of America
Windows Version: Windows XP SP2
CPU Type: AMD 64 3200+ [Socket 939]
Memory: 1GB
Motherboard: ASUS A8N-VM CSM
Motherboard Chipset: NVIDIA nForce 430
Motherboard Bios: ASUS 0702
Video Card: NVIDIA 6600GT
Video Card Driver: 84.21
Sound Card: AuzenTech X-Plosion
Sound Card AC3: Optical Out
Sound Card Driver: 5.12
1. TV Card: Avermedia A180
1. TV Card Type: ATSC
1. TV Card Driver: 1.2.2.23
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
Video Codec: NVIDIA PureVideo 4020.203
Audio Codec: AC3Filter 1.0.1.0
Satelite/CableTV Provider:
HTPC Case: Origen AE X15
Power Supply: Seasonic 430W
Remote: MCE 2005
TV: BENQ Projector
TV - HTPC Connection: VGA (800x453)
In TVDatabase.cs, method UpdateProgram(TVProgram prog) is meant to either insert a new TV program or update existing program in the database.
The current code has been modified to remove the update functionality (it has been commented out) and so it now just returns if the program already exists instead of removing and replacing (so I guess it should really be called AddProgram, not UpdateProgram... heh)
Anyone know why it was done? Was/is there a bug/issue that needs to be resolved?
Right now, this means importing new TVGUIDE.XML files that may have updated programs details won't update the EPG database.
if (results2.Rows.Count > 0)
{
long idProgram = DatabaseUtility.GetAsInt64(results2, 0, "idProgram");
return (int)idProgram;//program already exists
/*
//and delete them
for (int i = 0; i < results2.Rows.Count; ++i)
{
idProgram = DatabaseUtility.GetAsInt64(results2, i, "idProgram");
//Log.WriteFile(Log.LogType.EPG, "sql: del {0} id:{1} {2}-{3}", i, idProgram,DatabaseUtility.Get(results2, i, "iStartTime"), DatabaseUtility.Get(results2, i, "iEndTime"));
strSQL = String.Format("DELETE FROM tblPrograms WHERE idProgram={0}", idProgram);
m_db.Execute(strSQL);
}*/
}
CPU Type: AMD 64 3200+ [Socket 939]
Memory: 1GB
Motherboard: ASUS A8N-VM CSM
Motherboard Chipset: NVIDIA nForce 430
Motherboard Bios: ASUS 0702
Video Card: NVIDIA 6600GT
Video Card Driver: 84.21
Sound Card: AuzenTech X-Plosion
Sound Card AC3: Optical Out
Sound Card Driver: 5.12
1. TV Card: Avermedia A180
1. TV Card Type: ATSC
1. TV Card Driver: 1.2.2.23
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
Video Codec: NVIDIA PureVideo 4020.203
Audio Codec: AC3Filter 1.0.1.0
Satelite/CableTV Provider:
HTPC Case: Origen AE X15
Power Supply: Seasonic 430W
Remote: MCE 2005
TV: BENQ Projector
TV - HTPC Connection: VGA (800x453)
In TVDatabase.cs, method UpdateProgram(TVProgram prog) is meant to either insert a new TV program or update existing program in the database.
The current code has been modified to remove the update functionality (it has been commented out) and so it now just returns if the program already exists instead of removing and replacing (so I guess it should really be called AddProgram, not UpdateProgram... heh)
Anyone know why it was done? Was/is there a bug/issue that needs to be resolved?
Right now, this means importing new TVGUIDE.XML files that may have updated programs details won't update the EPG database.
if (results2.Rows.Count > 0)
{
long idProgram = DatabaseUtility.GetAsInt64(results2, 0, "idProgram");
return (int)idProgram;//program already exists
/*
//and delete them
for (int i = 0; i < results2.Rows.Count; ++i)
{
idProgram = DatabaseUtility.GetAsInt64(results2, i, "idProgram");
//Log.WriteFile(Log.LogType.EPG, "sql: del {0} id:{1} {2}-{3}", i, idProgram,DatabaseUtility.Get(results2, i, "iStartTime"), DatabaseUtility.Get(results2, i, "iEndTime"));
strSQL = String.Format("DELETE FROM tblPrograms WHERE idProgram={0}", idProgram);
m_db.Execute(strSQL);
}*/
}
