void ChannelGroupStorage::Load(void) { setting->setValue("0"); MSqlQuery query(MSqlQuery::InitCon()); QString qstr = "SELECT grpid FROM channelgroupnames WHERE name = :GRPNAME"; query.prepare(qstr); query.bindValue(":GRPNAME", grpname); if (!query.exec() || !query.isActive()) MythDB::DBError("ChannelGroupStorage::Load", query); else if (query.next()) { grpid = query.value(0).toUInt(); qstr = "SELECT * FROM channelgroup WHERE grpid = :GRPID AND " "chanid = :CHANID"; query.prepare(qstr); query.bindValue(":GRPID", grpid); query.bindValue(":CHANID", chanid); if (!query.exec() || !query.isActive()) MythDB::DBError("ChannelGroupStorage::Load", query); else if (query.size() > 0) setting->setValue("1"); } }