diff options
| author | Sadie Powell <sadie@witchery.services> | 2025-02-20 13:05:22 +0000 |
|---|---|---|
| committer | Sadie Powell <sadie@witchery.services> | 2025-02-20 13:05:22 +0000 |
| commit | 227caba7838f680c24e730ad3a4f534b59763dbc (patch) | |
| tree | eac66b2c06e615332f6077587708eddf85cdc155 /modules/database/db_sql_live.cpp | |
| parent | b51dff0b1a35b0d8608c6ea79b966d742b361757 (diff) | |
Fix sql_live on recent MariaDB.
Diffstat (limited to 'modules/database/db_sql_live.cpp')
| -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 e8fa9fa2f..29f58e888 100644 --- a/modules/database/db_sql_live.cpp +++ b/modules/database/db_sql_live.cpp @@ -174,7 +174,11 @@ class DBMySQL : public Module, public Pipe if (!this->CheckInit() || obj->GetTimestamp() == Anope::CurTime) return; - Query query("SELECT * FROM `" + this->prefix + obj->GetName() + "` WHERE (`timestamp` >= " + this->SQL->FromUnixtime(obj->GetTimestamp()) + " OR `timestamp` IS NULL)"); + Anope::string sql = Anope::printf("SELECT * from `%s%s`", this->prefix.c_str(), obj->GetName().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(); |