From f690c7dde14a6f9c5fbf04ed94170c7648591cb6 Mon Sep 17 00:00:00 2001 From: "Javier S. Pedro" Date: Thu, 4 Apr 2013 20:58:57 +0200 Subject: store post position in database, create invisible items for unfetched --- fetchforumsaction.cpp | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'fetchforumsaction.cpp') diff --git a/fetchforumsaction.cpp b/fetchforumsaction.cpp index c3b77cd..8bbe23b 100644 --- a/fetchforumsaction.cpp +++ b/fetchforumsaction.cpp @@ -39,8 +39,8 @@ void FetchForumsAction::handleFinishedCall() handleDatabaseError("truncating forums table", db.lastError()); } QSqlQuery query(db); - query.prepare("INSERT INTO forums (forum_id, forum_name, description, parent_id, logo_url, new_post, is_protected, is_subscribed, can_subscribe, url, sub_only, sort_index)" - "VALUES (:forum_id, :forum_name, :description, :parent_id, :logo_url, :new_post, :is_protected, :is_subscribed, :can_subscribe, :url, :sub_only, :sort_index)"); + query.prepare("INSERT INTO forums (forum_id, forum_name, description, parent_id, logo_url, new_post, is_protected, is_subscribed, can_subscribe, url, sub_only, position)" + "VALUES (:forum_id, :forum_name, :description, :parent_id, :logo_url, :new_post, :is_protected, :is_subscribed, :can_subscribe, :url, :sub_only, :position)"); foreach (const QVariant& list_element, list) { QVariantMap map = list_element.toMap(); @@ -67,7 +67,7 @@ void FetchForumsAction::handleFinishedCall() query.bindValue(":can_subscribe", map["can_subscribed"].toBool() ? 1 : 0); query.bindValue(":url", map["url"].toString()); query.bindValue(":sub_only", map["sub_only"].toBool() ? 1 : 0); - query.bindValue(":sort_index", map["sort_index"]); + query.bindValue(":position", map["position"]); if (!query.exec()) { qWarning() << "Failed to store forum info for:" << forum_id; @@ -95,7 +95,7 @@ QList FetchForumsAction::flattenForumList(const QVariantList &list, QList flattened; foreach (const QVariant& list_element, list) { QVariantMap map = list_element.toMap(); - map["sort_index"] = (*order)++; + map["position"] = (*order)++; QVariantMap::iterator child_key = map.find("child"); if (child_key != map.end()) { // There are children, so flatten them too. -- cgit v1.2.3