Changeset 5d9409d in confclerk_git for src/mvc

Timestamp:

03/03/10 16:47:00 (13 years ago)

Author:

timkoma <timkoma@…>

Branches:

master, qt5

Children:

5bd6aba

Parents:

7270ae0

Message:

UTC/LocalTime fix for import conference XML, DB queries for multiple conferences fixes

File:

• src/mvc/event.cpp (modified) (2 diffs)

src/mvc/event.cpp

@@ -144 +144 @@
     {
         QSqlQuery query;
-        query.prepare("SELECT xid_room FROM event_room WHERE xid_event = :id");
+        query.prepare("SELECT xid_room FROM event_room WHERE xid_event = :id AND xid_conference = :conf");
         query.bindValue(":id", id());
+        query.bindValue(":conf", conferenceId());
         if (!query.isActive())
             if (!query.exec())
@@ -165 +166 @@
         QSqlQuery query;
         // TODO: conference ID isn't used here
-        query.prepare("SELECT person.name FROM person INNER JOIN event_person ON person.id = event_person.xid_person AND event_person.xid_event = :id");
+        query.prepare("SELECT person.name FROM person INNER JOIN event_person ON person.id = event_person.xid_person AND event_person.xid_event = :id AND event_person.xid_conference = :conf");
         query.bindValue(":id", id());
+        query.bindValue(":conf", conferenceId());
         query.exec();
         // TODO: handle qeury error