if (dbver == "1128")
2067 {
2068
2069 MSqlQuery query(MSqlQuery::InitCon());
2070 query.prepare("SELECT chanid, starttime, cutlist FROM recorded"
2071 " WHERE LENGTH(cutlist) > 1;");
2072 if (query.exec() && query.isActive() && query.size() > 0)
2073 {
2074 MSqlQuery insert(MSqlQuery::InitCon());
2075 while (query.next())
2076 {
2077 QString cutlist = query.value(2).toString();
2078
2079 QStringList strlist = QStringList::split("\n", cutlist);
2080 QStringList::Iterator i;
2081 for (i = strlist.begin(); i != strlist.end(); ++i)
2082 {
2083 long long start = 0, end = 0;
2084 if (sscanf((*i).ascii(), "%lld - %lld", &start, &end) == 2)
2085 {
2086 insert.prepare(
2087 "INSERT INTO recordedmarkup (chanid, starttime,"
2088 " type, mark) "
2089 "VALUES (:CHANID, :STARTTIME, :TYPE, :MARK);");
2090 insert.bindValue(":CHANID", query.value(0).toString());
2091 insert.bindValue(":STARTTIME",
2092 query.value(1).toDateTime());
2093
2094 insert.bindValue(":TYPE", 1);
2095 insert.bindValue(":MARK", start);
2096 insert.exec();
2097
2098 insert.bindValue(":TYPE", 0);
2099 insert.bindValue(":MARK", end);
2100 insert.exec();
2101 }
2102 }
2103 }
2104 }
2105
2106 const QString updates[] = {
2107 "INSERT INTO recordedmarkup (chanid, starttime, type, mark) SELECT"
2108 " chanid, starttime, '2', bookmark FROM recorded WHERE bookmark <> 0;",
2109 "ALTER TABLE recorded CHANGE cutlist cutlist TINYINT(1) NOT NULL DEFAULT 0",
2110 "ALTER TABLE recorded CHANGE bookmark bookmark TINYINT(1) NOT NULL DEFAULT 0",
2111 ""
2112 };
2113 if (!performActualUpdate(updates, "1129", dbver))
2114 return false;
2115 }