Changeset 5c7119d
- Timestamp:
- 06/24/11 17:39:10 (12 years ago)
- Branches:
- master, qt5
- Children:
- 8bdf2d3
- Parents:
- 496685d
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
BUGS
r496685d r5c7119d 3 3 4 4 ------------------------------------------------------------------- 5 BugI d: 15 BugID: 1 6 6 Title: Persons are not deleted when deleting a conference. 7 7 Status: Fixed. 8 8 ------------------------------------------------------------------- 9 BugI d: 29 BugID: 2 10 10 Title: SQL injections possible. 11 11 Status: Fixed. … … 21 21 Status: 22 22 ------------------------------------------------------------------- 23 BugID 5 24 Title: Too many authors are shown (from other conferences). 25 Severity: major 26 Status: Fixed. 27 ------------------------------------------------------------------- -
src/mvc/event.cpp
r496685d r5c7119d 158 158 { 159 159 QSqlQuery query; 160 // TODO: conference ID isn't used here 161 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"); 160 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 = :conf1 AND person.xid_conference = :conf2"); 162 161 query.bindValue(":id", id()); 163 query.bindValue(":conf", conferenceId()); 164 query.exec(); 165 // TODO: handle qeury error 166 //qDebug() << query.lastError(); 162 query.bindValue(":conf1", conferenceId()); 163 query.bindValue(":conf2", conferenceId()); 164 if (!query.exec()) qDebug() << query.lastError(); 167 165 168 166 while(query.next()) … … 227 225 QString strQuery = QString("SELECT %1 FROM EVENT INNER JOIN SEARCH_EVENT USING (xid_conference, id) ").arg(columnsForSelect()); 228 226 strQuery += QString("WHERE xid_conference = :conf AND start >= :start AND start < :end ORDER BY %1").arg(orderBy); 229 //qDebug() << strQuery; 227 230 228 QList<Event> list; 231 229 QSqlQuery query;
Note: See TracChangeset
for help on using the changeset viewer.