1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
|
#ifndef HYBBX_STORAGE_H
#define HYBBX_STORAGE_H
#include "hybbx/auth.h"
#include "hybbx/limits.h"
#include "hybbx/types.h"
#include <stddef.h>
#include <stdint.h>
#include <time.h>
#ifdef __cplusplus
extern "C" {
#endif
typedef enum hybbx_storage_backend_kind {
HYBBX_STORAGE_FLATFILE = 1,
HYBBX_STORAGE_SQLITE = 2,
HYBBX_STORAGE_MYSQL = 3,
HYBBX_STORAGE_MARIADB = 4
} hybbx_storage_backend_kind_t;
#define HYBBX_USER_NAME_MAX 64
#define HYBBX_USER_NICKNAME_MAX 64
#define HYBBX_USER_FULL_NAME_MAX 128
#define HYBBX_USER_COUNTRY_MAX 64
#define HYBBX_USER_LOCATION_MAX 128
#define HYBBX_USER_EMAIL_MAX 128
#define HYBBX_USER_PASSWORD_MAX HYBBX_PASSWORD_STORED_MAX
#define HYBBX_TRANSPORT_NAME_MAX 32
/** Peer address string (IPv4 or bracketed IPv6). */
#define HYBBX_REMOTE_ADDR_MAX 64
/** Maximum registered user records per INI user-file shard. */
#define HYBBX_USERS_PER_FILE 50u
/** INI section prefix for one user: [user.<id>]. */
#define HYBBX_USER_INI_SECTION_PREFIX "user."
typedef struct hybbx_user_registration {
char username[HYBBX_USER_NAME_MAX];
char nickname[HYBBX_USER_NICKNAME_MAX];
char full_name[HYBBX_USER_FULL_NAME_MAX];
char country[HYBBX_USER_COUNTRY_MAX];
char location[HYBBX_USER_LOCATION_MAX];
char email[HYBBX_USER_EMAIL_MAX];
char password[HYBBX_USER_PASSWORD_MAX];
} hybbx_user_registration_t;
/** Validate profile fields only (full name, country, location, email). */
int hybbx_user_profile_valid(const hybbx_user_registration_t *reg);
/** Validate registration profile fields (username + full name, country, location, email). */
int hybbx_registration_valid(const hybbx_user_registration_t *reg,
const char *guest_prefix);
typedef struct hybbx_user_record {
uint64_t id;
char username[HYBBX_USER_NAME_MAX];
char nickname[HYBBX_USER_NICKNAME_MAX];
hybbx_user_level_t level;
int active;
time_t created_at;
char full_name[HYBBX_USER_FULL_NAME_MAX];
char country[HYBBX_USER_COUNTRY_MAX];
char location[HYBBX_USER_LOCATION_MAX];
char email[HYBBX_USER_EMAIL_MAX];
char password[HYBBX_USER_PASSWORD_MAX];
time_t last_login_at;
} hybbx_user_record_t;
typedef struct hybbx_session_record {
uint64_t session_id;
uint64_t user_id;
char username[HYBBX_USER_NAME_MAX];
char transport[HYBBX_TRANSPORT_NAME_MAX];
char remote[HYBBX_REMOTE_ADDR_MAX];
time_t connected_at;
time_t disconnected_at;
int active;
} hybbx_session_record_t;
typedef struct hybbx_storage hybbx_storage_t;
/** Paths and backup settings for SQLite (`[storage]`). */
typedef struct hybbx_storage_sql_config {
char user_db[HYBBX_PATH_MAX];
char mail_db[HYBBX_PATH_MAX];
unsigned backup_interval_sec;
char backup_path[HYBBX_PATH_MAX];
} hybbx_storage_sql_config_t;
typedef struct hybbx_storage_options {
hybbx_storage_backend_kind_t backend;
const char *path;
const char *guest_prefix;
const hybbx_storage_sql_config_t *sql_cfg;
} hybbx_storage_options_t;
struct hybbx_config;
void hybbx_storage_sql_config_defaults(hybbx_storage_sql_config_t *cfg);
/** Resolve `user_db` / `mail_db` under @p storage_path from INI `[storage]`. */
void hybbx_storage_sql_config_apply(hybbx_storage_sql_config_t *cfg,
const struct hybbx_config *config,
const char *storage_path);
const hybbx_storage_sql_config_t *hybbx_storage_sql_config(
const hybbx_storage_t *storage);
/** Copy SQLite DB files to fallback paths (no-op when not SQLite). */
void hybbx_storage_backup_tick(hybbx_storage_t *storage);
hybbx_storage_t *hybbx_storage_open(const hybbx_storage_options_t *options);
void hybbx_storage_close(hybbx_storage_t *storage);
hybbx_storage_backend_kind_t hybbx_storage_backend(const hybbx_storage_t *storage);
/** Root data directory path, or NULL when unset. */
const char *hybbx_storage_root_path(const hybbx_storage_t *storage);
/**
* Register a new user account (level user, inactive until Sysop/Admin activates).
*/
hybbx_result_t hybbx_storage_register_user(hybbx_storage_t *storage,
const hybbx_user_registration_t *reg,
hybbx_user_record_t *out);
/** Look up a user by login name (case-insensitive; stored lowercase). */
hybbx_result_t hybbx_storage_find_user(hybbx_storage_t *storage,
const char *username,
hybbx_user_record_t *out);
/** Resolve by login name or nickname (case-insensitive). */
hybbx_result_t hybbx_storage_resolve_user(hybbx_storage_t *storage,
const char *name,
hybbx_user_record_t *out);
/** Count existing accounts at a given level (e.g. enforce one Sysop). */
hybbx_result_t hybbx_storage_count_level(hybbx_storage_t *storage,
hybbx_user_level_t level,
size_t *count);
/**
* Iterate all user records. @p fn returns HYBBX_OK to continue; any other
* result stops iteration and is returned from this function.
*/
typedef hybbx_result_t (*hybbx_storage_user_fn)(const hybbx_user_record_t *user,
void *ctx);
hybbx_result_t hybbx_storage_foreach_user(hybbx_storage_t *storage,
hybbx_storage_user_fn fn,
void *ctx);
hybbx_result_t hybbx_storage_session_begin(hybbx_storage_t *storage,
const hybbx_user_record_t *user,
const char *transport,
hybbx_session_record_t *out);
hybbx_result_t hybbx_storage_session_end(hybbx_storage_t *storage,
uint64_t session_id);
/**
* Replace an existing user record (matched by @p user->id).
*/
hybbx_result_t hybbx_storage_update_user(hybbx_storage_t *storage,
const hybbx_user_record_t *user);
/** Remove a user record from storage (matched by @p user_id). */
hybbx_result_t hybbx_storage_delete_user(hybbx_storage_t *storage,
uint64_t user_id);
#ifdef __cplusplus
}
#endif
#endif /* HYBBX_STORAGE_H */
|
