--- lbbs/src/database.c 2025/04/30 09:18:19 1.9 +++ lbbs/src/database.c 2025/05/04 14:54:55 1.11 @@ -16,15 +16,22 @@ ***************************************************************************/ #include "common.h" +#include "database.h" #include "log.h" #include #include -MYSQL * -db_open() +// Global declaration for database +char DB_host[256]; +char DB_username[50]; +char DB_password[50]; +char DB_database[50]; +char DB_timezone[50]; + +MYSQL *db_open() { MYSQL *db; - char sql[1024]; + char sql[SQL_BUFFER_LEN]; db = mysql_init(NULL); if (db == NULL) @@ -48,8 +55,8 @@ db_open() } sprintf(sql, - "SET time_zone = '%s'", - DB_timezone); + "SET time_zone = '%s'", + DB_timezone); if (mysql_query(db, sql) != 0) {