X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/a481c1e57ecc91e87e24f8074602f5ed3de77a07..8c6fa3fbaccc22127280bf77a48fab5a3ee0716e:/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp diff --git a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp index cef5b203..6f8177ca 100644 --- a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp +++ b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp @@ -165,6 +165,7 @@ try query += " where pk_tariff = ?"; + unsigned num = 5; st->Prepare(query); st->Set(1, td.tariffConf.fee); st->Set(2, td.tariffConf.free); @@ -172,16 +173,21 @@ try st->Set(4, td.tariffConf.traffType); if (schemaVersion > 0) + { st->Set(5, TARIFF::PeriodToString(td.tariffConf.period)); + ++num; + } + if (schemaVersion > 1) { st->Set(6, TARIFF::ChangePolicyToString(td.tariffConf.changePolicy)); IBPP::Timestamp policyTimeout; time_t2ts(td.tariffConf.changePolicyTimeout, &policyTimeout); st->Set(7, policyTimeout); + num += 2; } - st->Set(8, id); + st->Set(num, id); st->Execute(); st->Close(); @@ -284,7 +290,6 @@ try st->Get(3, td->tariffConf.fee); st->Get(4, td->tariffConf.free); st->Get(5, td->tariffConf.passiveCost); - //st->Get(6, td->tariffConf.traffType); td->tariffConf.traffType = TARIFF::IntToTraffType(Get(st, 6)); if (schemaVersion > 0) td->tariffConf.period = TARIFF::StringToPeriod(Get(st, 7));