diff options
| -rw-r--r-- | modules/database/db_sql_live.cpp | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/modules/database/db_sql_live.cpp b/modules/database/db_sql_live.cpp index 3a02bd0c5..e0f3adb08 100644 --- a/modules/database/db_sql_live.cpp +++ b/modules/database/db_sql_live.cpp @@ -173,7 +173,11 @@ public: if (!this->CheckInit() || obj->GetTimestamp() == Anope::CurTime) return; - Query query("SELECT * FROM `" + GetTableName(obj) + "` WHERE (`timestamp` >= " + this->SQL->FromUnixtime(obj->GetTimestamp()) + " OR `timestamp` IS NULL)"); + Anope::string sql = Anope::printf("SELECT * from `%s`", GetTableName(obj).c_str()); + if (obj->GetTimestamp()) + sql += Anope::printf(" WHERE (`timestamp` >= %s OR `timestamp` IS NULL)", this->SQL->FromUnixtime(obj->GetTimestamp()).c_str()); + + Query query(sql); obj->UpdateTimestamp(); |