Changeset 5d9409d for src/mvc/event.cpp


Ignore:
Timestamp:
03/03/10 16:47:00 (12 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:
1 edited

Legend:

Unmodified
Added
Removed
  • src/mvc/event.cpp

    r7270ae0 r5d9409d  
    144144    {
    145145        QSqlQuery query;
    146         query.prepare("SELECT xid_room FROM event_room WHERE xid_event = :id");
     146        query.prepare("SELECT xid_room FROM event_room WHERE xid_event = :id AND xid_conference = :conf");
    147147        query.bindValue(":id", id());
     148        query.bindValue(":conf", conferenceId());
    148149        if (!query.isActive())
    149150            if (!query.exec())
     
    165166        QSqlQuery query;
    166167        // TODO: conference ID isn't used here
    167         query.prepare("SELECT person.name FROM person INNER JOIN event_person ON person.id = event_person.xid_person AND event_person.xid_event = :id");
     168        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");
    168169        query.bindValue(":id", id());
     170        query.bindValue(":conf", conferenceId());
    169171        query.exec();
    170172        // TODO: handle qeury error
Note: See TracChangeset for help on using the changeset viewer.