| 1 |
/*************************************************************************** |
/* SPDX-License-Identifier: GPL-3.0-or-later */ |
| 2 |
section_list_loader.c - description |
/* |
| 3 |
------------------- |
* section_list_loader |
| 4 |
Copyright : (C) 2004-2025 by Leaflet |
* - load and query operations of section articles |
| 5 |
Email : leaflet@leafok.com |
* |
| 6 |
***************************************************************************/ |
* Copyright (C) 2004-2025 Leaflet <leaflet@leafok.com> |
| 7 |
|
*/ |
| 8 |
/*************************************************************************** |
|
| 9 |
* * |
#ifdef HAVE_CONFIG_H |
| 10 |
* This program is free software; you can redistribute it and/or modify * |
#include "config.h" |
| 11 |
* it under the terms of the GNU General Public License as published by * |
#endif |
|
* the Free Software Foundation; either version 3 of the License, or * |
|
|
* (at your option) any later version. * |
|
|
* * |
|
|
***************************************************************************/ |
|
| 12 |
|
|
| 13 |
#include "article_cache.h" |
#include "article_cache.h" |
| 14 |
#include "article_view_log.h" |
#include "article_view_log.h" |
| 30 |
int section_list_loader_pid; |
int section_list_loader_pid; |
| 31 |
int last_article_op_log_mid; |
int last_article_op_log_mid; |
| 32 |
|
|
| 33 |
|
static void loader_proc_sig_usr1_handler(int i) |
| 34 |
|
{ |
| 35 |
|
// Restart log |
| 36 |
|
if (log_restart() < 0) |
| 37 |
|
{ |
| 38 |
|
log_error("Restart logging failed\n"); |
| 39 |
|
} |
| 40 |
|
} |
| 41 |
|
|
| 42 |
int load_section_config_from_db(int update_gen_ex) |
int load_section_config_from_db(int update_gen_ex) |
| 43 |
{ |
{ |
| 44 |
MYSQL *db = NULL; |
MYSQL *db = NULL; |
| 49 |
char master_list[(BBS_username_max_len + 1) * 3 + 1]; |
char master_list[(BBS_username_max_len + 1) * 3 + 1]; |
| 50 |
SECTION_LIST *p_section; |
SECTION_LIST *p_section; |
| 51 |
char ex_menu_conf[FILE_PATH_LEN]; |
char ex_menu_conf[FILE_PATH_LEN]; |
|
MENU_SET ex_menu_set_new; |
|
| 52 |
int ret = 0; |
int ret = 0; |
| 53 |
|
|
| 54 |
db = db_open(); |
db = db_open(); |
| 160 |
{ |
{ |
| 161 |
snprintf(ex_menu_conf, sizeof(ex_menu_conf), "%s/%d", VAR_GEN_EX_MENU_DIR, p_section->sid); |
snprintf(ex_menu_conf, sizeof(ex_menu_conf), "%s/%d", VAR_GEN_EX_MENU_DIR, p_section->sid); |
| 162 |
|
|
| 163 |
ret = load_menu(&ex_menu_set_new, ex_menu_conf); |
if (detach_menu_shm(&(p_section->ex_menu_set)) < 0) |
| 164 |
if (ret < 0) |
{ |
| 165 |
|
log_error("detach_menu_shm(%s) error\n", ex_menu_conf); |
| 166 |
|
} |
| 167 |
|
if (load_menu(&(p_section->ex_menu_set), ex_menu_conf) < 0) |
| 168 |
{ |
{ |
| 169 |
unload_menu(&ex_menu_set_new); |
log_error("load_menu(%s) error\n", ex_menu_conf); |
| 170 |
log_error("load_menu(%s) error: %d\n", ex_menu_conf, ret); |
unload_menu(&(p_section->ex_menu_set)); |
| 171 |
} |
} |
| 172 |
else |
else |
| 173 |
{ |
{ |
| 174 |
if (p_section->ex_menu_tm > 0) |
p_section->ex_menu_set.allow_exit = 1; // Allow exit menu |
|
{ |
|
|
unload_menu(&(p_section->ex_menu_set)); |
|
|
} |
|
|
|
|
|
ex_menu_set_new.allow_exit = 1; // Allow exit menu |
|
|
memcpy(&(p_section->ex_menu_set), &ex_menu_set_new, sizeof(ex_menu_set_new)); |
|
|
|
|
| 175 |
p_section->ex_menu_tm = atol(row[7]); |
p_section->ex_menu_tm = atol(row[7]); |
| 176 |
#ifdef _DEBUG |
#ifdef _DEBUG |
| 177 |
log_common("Loaded gen_ex_menu of section %d [%s]\n", p_section->sid, p_section->sname); |
log_common("Loaded gen_ex_menu of section %d [%s]\n", p_section->sid, p_section->sname); |
| 723 |
detach_menu_shm(&top10_menu); |
detach_menu_shm(&top10_menu); |
| 724 |
|
|
| 725 |
// Set signal handler |
// Set signal handler |
| 726 |
act.sa_handler = SIG_DFL; |
act.sa_handler = SIG_IGN; |
| 727 |
if (sigaction(SIGHUP, &act, NULL) == -1) |
if (sigaction(SIGHUP, &act, NULL) == -1) |
| 728 |
{ |
{ |
| 729 |
log_error("set signal action of SIGHUP error: %d\n", errno); |
log_error("set signal action of SIGHUP error: %d\n", errno); |
| 733 |
{ |
{ |
| 734 |
log_error("set signal action of SIGCHLD error: %d\n", errno); |
log_error("set signal action of SIGCHLD error: %d\n", errno); |
| 735 |
} |
} |
| 736 |
|
act.sa_handler = loader_proc_sig_usr1_handler; |
| 737 |
|
if (sigaction(SIGUSR1, &act, NULL) == -1) |
| 738 |
|
{ |
| 739 |
|
log_error("set signal action of SIGUSR1 error: %d\n", errno); |
| 740 |
|
} |
| 741 |
|
|
| 742 |
// Do section data loader periodically |
// Do section data loader periodically |
| 743 |
while (!SYS_server_exit) |
while (!SYS_server_exit) |
| 866 |
return 0; |
return 0; |
| 867 |
} |
} |
| 868 |
|
|
| 869 |
int query_section_articles(SECTION_LIST *p_section, int page_id, ARTICLE *p_articles[], |
int query_section_articles(SECTION_LIST *p_section, int page_id, const ARTICLE *p_articles[], |
| 870 |
int *p_article_count, int *p_page_count, int *p_ontop_start_offset) |
int *p_article_count, int *p_page_count, int *p_ontop_start_offset) |
| 871 |
{ |
{ |
| 872 |
ARTICLE *p_article; |
ARTICLE *p_article; |
| 897 |
} |
} |
| 898 |
else if (page_id < 0 || page_id >= *p_page_count) |
else if (page_id < 0 || page_id >= *p_page_count) |
| 899 |
{ |
{ |
| 900 |
|
#ifdef _DEBUG |
| 901 |
log_error("Invalid page_id=%d, not in range [0, %d)\n", page_id, *p_page_count); |
log_error("Invalid page_id=%d, not in range [0, %d)\n", page_id, *p_page_count); |
| 902 |
|
#endif |
| 903 |
ret = -3; |
ret = -3; |
| 904 |
} |
} |
| 905 |
else |
else |
| 938 |
: (page_id - p_section->page_count + 1) * BBS_article_limit_per_page - p_section->last_page_visible_article_count); |
: (page_id - p_section->page_count + 1) * BBS_article_limit_per_page - p_section->last_page_visible_article_count); |
| 939 |
while (*p_article_count < BBS_article_limit_per_page && i < p_section->ontop_article_count) |
while (*p_article_count < BBS_article_limit_per_page && i < p_section->ontop_article_count) |
| 940 |
{ |
{ |
| 941 |
p_articles[(*p_article_count)++] = p_section->p_ontop_articles[i++]; |
p_articles[*p_article_count] = p_section->p_ontop_articles[i++]; |
| 942 |
|
(*p_article_count)++; |
| 943 |
} |
} |
| 944 |
} |
} |
| 945 |
} |
} |
| 1023 |
p_article = section_list_find_article_with_offset(p_section, aid, &page_id, &offset, &p_tmp); |
p_article = section_list_find_article_with_offset(p_section, aid, &page_id, &offset, &p_tmp); |
| 1024 |
if (p_article != NULL) |
if (p_article != NULL) |
| 1025 |
{ |
{ |
| 1026 |
*p_article_count = (page_id == p_section->page_count - 1 ? p_section->last_page_visible_article_count : BBS_article_limit_per_page); |
*p_article_count = (page_id >= p_section->page_count - 1 ? p_section->last_page_visible_article_count : BBS_article_limit_per_page); |
| 1027 |
|
|
| 1028 |
p_article = p_section->p_page_first_article[page_id]; |
p_article = p_section->p_page_first_article[page_id]; |
| 1029 |
for (i = 0; i < *p_article_count && p_article != NULL;) |
for (i = 0; i < *p_article_count && p_article != NULL;) |
| 1044 |
break; |
break; |
| 1045 |
} |
} |
| 1046 |
} |
} |
| 1047 |
|
|
| 1048 |
p_article = p_article->p_next; |
p_article = p_article->p_next; |
| 1049 |
|
if (p_article == p_section->p_page_first_article[page_id]) |
| 1050 |
|
{ |
| 1051 |
|
log_error("Dead loop detected at page=%d, article_count=%d\n", page_id, *p_article_count); |
| 1052 |
|
break; |
| 1053 |
|
} |
| 1054 |
} |
} |
| 1055 |
|
|
| 1056 |
// Include ontop articles |
// Include ontop articles |
| 1068 |
return (ret < 0 ? ret : (p_article == NULL ? 0 : 1)); |
return (ret < 0 ? ret : (p_article == NULL ? 0 : 1)); |
| 1069 |
} |
} |
| 1070 |
|
|
| 1071 |
|
int last_article_in_section(SECTION_LIST *p_section, const ARTICLE **pp_article) |
| 1072 |
|
{ |
| 1073 |
|
int ret = 0; |
| 1074 |
|
|
| 1075 |
|
const ARTICLE *p_article; |
| 1076 |
|
|
| 1077 |
|
if (p_section == NULL || pp_article == NULL) |
| 1078 |
|
{ |
| 1079 |
|
log_error("NULL pointer error\n"); |
| 1080 |
|
return -1; |
| 1081 |
|
} |
| 1082 |
|
|
| 1083 |
|
*pp_article = NULL; |
| 1084 |
|
|
| 1085 |
|
// acquire lock of section |
| 1086 |
|
if ((ret = section_list_rd_lock(p_section)) < 0) |
| 1087 |
|
{ |
| 1088 |
|
log_error("section_list_rd_lock(sid = %d) error\n", p_section->sid); |
| 1089 |
|
return -2; |
| 1090 |
|
} |
| 1091 |
|
|
| 1092 |
|
for (p_article = p_section->p_article_tail; |
| 1093 |
|
p_article && p_article != p_section->p_article_head && !p_article->visible; |
| 1094 |
|
p_article = p_article->p_prior) |
| 1095 |
|
; |
| 1096 |
|
|
| 1097 |
|
if (p_article && p_article->visible) |
| 1098 |
|
{ |
| 1099 |
|
*pp_article = p_article; |
| 1100 |
|
ret = 1; |
| 1101 |
|
} |
| 1102 |
|
|
| 1103 |
|
// release lock of section |
| 1104 |
|
if (section_list_rd_unlock(p_section) < 0) |
| 1105 |
|
{ |
| 1106 |
|
log_error("section_list_rd_unlock(sid = %d) error\n", p_section->sid); |
| 1107 |
|
ret = -2; |
| 1108 |
|
} |
| 1109 |
|
|
| 1110 |
|
return ret; |
| 1111 |
|
} |
| 1112 |
|
|
| 1113 |
int scan_unread_article_in_section(SECTION_LIST *p_section, const ARTICLE *p_article_cur, const ARTICLE **pp_article_unread) |
int scan_unread_article_in_section(SECTION_LIST *p_section, const ARTICLE *p_article_cur, const ARTICLE **pp_article_unread) |
| 1114 |
{ |
{ |
| 1115 |
ARTICLE *p_article; |
ARTICLE *p_article; |
| 1145 |
} |
} |
| 1146 |
} |
} |
| 1147 |
|
|
| 1148 |
|
// release lock of section |
| 1149 |
|
if (section_list_rd_unlock(p_section) < 0) |
| 1150 |
|
{ |
| 1151 |
|
log_error("section_list_rd_unlock(sid = %d) error\n", p_section->sid); |
| 1152 |
|
return -2; |
| 1153 |
|
} |
| 1154 |
|
|
| 1155 |
|
return (p_article != NULL && p_article != p_article_cur ? 1 : 0); |
| 1156 |
|
} |
| 1157 |
|
|
| 1158 |
|
int scan_article_in_section_by_uid(SECTION_LIST *p_section, const ARTICLE *p_article_cur, |
| 1159 |
|
int direction, int32_t uid, const ARTICLE **pp_article) |
| 1160 |
|
{ |
| 1161 |
|
ARTICLE *p_article; |
| 1162 |
|
int ret = 0; |
| 1163 |
|
|
| 1164 |
|
if (p_section == NULL || p_article_cur == NULL || pp_article == NULL) |
| 1165 |
|
{ |
| 1166 |
|
log_error("NULL pointer error\n"); |
| 1167 |
|
return -1; |
| 1168 |
|
} |
| 1169 |
|
|
| 1170 |
|
if (p_article_cur->sid != p_section->sid) |
| 1171 |
|
{ |
| 1172 |
|
log_error("Inconsistent SID\n"); |
| 1173 |
|
return -1; |
| 1174 |
|
} |
| 1175 |
|
|
| 1176 |
|
// acquire lock of section |
| 1177 |
|
if ((ret = section_list_rd_lock(p_section)) < 0) |
| 1178 |
|
{ |
| 1179 |
|
log_error("section_list_rd_lock(sid = %d) error\n", p_section->sid); |
| 1180 |
|
return -2; |
| 1181 |
|
} |
| 1182 |
|
|
| 1183 |
|
*pp_article = NULL; |
| 1184 |
|
|
| 1185 |
|
if (direction >= 0) |
| 1186 |
|
{ |
| 1187 |
|
for (p_article = p_article_cur->p_next; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_next) |
| 1188 |
|
{ |
| 1189 |
|
if (p_article->visible && p_article->uid == uid) |
| 1190 |
|
{ |
| 1191 |
|
*pp_article = p_article; |
| 1192 |
|
break; |
| 1193 |
|
} |
| 1194 |
|
} |
| 1195 |
|
} |
| 1196 |
|
else // direction < 0 |
| 1197 |
|
{ |
| 1198 |
|
for (p_article = p_article_cur->p_prior; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_prior) |
| 1199 |
|
{ |
| 1200 |
|
if (p_article->visible && p_article->uid == uid) |
| 1201 |
|
{ |
| 1202 |
|
*pp_article = p_article; |
| 1203 |
|
break; |
| 1204 |
|
} |
| 1205 |
|
} |
| 1206 |
|
} |
| 1207 |
|
|
| 1208 |
|
// release lock of section |
| 1209 |
|
if (section_list_rd_unlock(p_section) < 0) |
| 1210 |
|
{ |
| 1211 |
|
log_error("section_list_rd_unlock(sid = %d) error\n", p_section->sid); |
| 1212 |
|
return -2; |
| 1213 |
|
} |
| 1214 |
|
|
| 1215 |
|
return (p_article != NULL && p_article != p_article_cur ? 1 : 0); |
| 1216 |
|
} |
| 1217 |
|
|
| 1218 |
|
int scan_article_in_section_by_username(SECTION_LIST *p_section, const ARTICLE *p_article_cur, |
| 1219 |
|
int direction, const char *username, const ARTICLE **pp_article) |
| 1220 |
|
{ |
| 1221 |
|
ARTICLE *p_article; |
| 1222 |
|
int ret = 0; |
| 1223 |
|
|
| 1224 |
|
if (p_section == NULL || p_article_cur == NULL || username == NULL || pp_article == NULL) |
| 1225 |
|
{ |
| 1226 |
|
log_error("NULL pointer error\n"); |
| 1227 |
|
return -1; |
| 1228 |
|
} |
| 1229 |
|
|
| 1230 |
|
if (p_article_cur->sid != p_section->sid) |
| 1231 |
|
{ |
| 1232 |
|
log_error("Inconsistent SID\n"); |
| 1233 |
|
return -1; |
| 1234 |
|
} |
| 1235 |
|
|
| 1236 |
|
// acquire lock of section |
| 1237 |
|
if ((ret = section_list_rd_lock(p_section)) < 0) |
| 1238 |
|
{ |
| 1239 |
|
log_error("section_list_rd_lock(sid = %d) error\n", p_section->sid); |
| 1240 |
|
return -2; |
| 1241 |
|
} |
| 1242 |
|
|
| 1243 |
|
*pp_article = NULL; |
| 1244 |
|
|
| 1245 |
|
if (direction >= 0) |
| 1246 |
|
{ |
| 1247 |
|
for (p_article = p_article_cur->p_next; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_next) |
| 1248 |
|
{ |
| 1249 |
|
if (p_article->visible && strcasecmp(p_article->username, username) == 0) |
| 1250 |
|
{ |
| 1251 |
|
*pp_article = p_article; |
| 1252 |
|
break; |
| 1253 |
|
} |
| 1254 |
|
} |
| 1255 |
|
} |
| 1256 |
|
else // direction < 0 |
| 1257 |
|
{ |
| 1258 |
|
for (p_article = p_article_cur->p_prior; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_prior) |
| 1259 |
|
{ |
| 1260 |
|
if (p_article->visible && strcasecmp(p_article->username, username) == 0) |
| 1261 |
|
{ |
| 1262 |
|
*pp_article = p_article; |
| 1263 |
|
break; |
| 1264 |
|
} |
| 1265 |
|
} |
| 1266 |
|
} |
| 1267 |
|
|
| 1268 |
|
// release lock of section |
| 1269 |
|
if (section_list_rd_unlock(p_section) < 0) |
| 1270 |
|
{ |
| 1271 |
|
log_error("section_list_rd_unlock(sid = %d) error\n", p_section->sid); |
| 1272 |
|
return -2; |
| 1273 |
|
} |
| 1274 |
|
|
| 1275 |
|
return (p_article != NULL && p_article != p_article_cur ? 1 : 0); |
| 1276 |
|
} |
| 1277 |
|
|
| 1278 |
|
int scan_article_in_section_by_title(SECTION_LIST *p_section, const ARTICLE *p_article_cur, |
| 1279 |
|
int direction, const char *title, const ARTICLE **pp_article) |
| 1280 |
|
{ |
| 1281 |
|
ARTICLE *p_article; |
| 1282 |
|
int ret = 0; |
| 1283 |
|
|
| 1284 |
|
if (p_section == NULL || p_article_cur == NULL || title == NULL || pp_article == NULL) |
| 1285 |
|
{ |
| 1286 |
|
log_error("NULL pointer error\n"); |
| 1287 |
|
return -1; |
| 1288 |
|
} |
| 1289 |
|
|
| 1290 |
|
if (p_article_cur->sid != p_section->sid) |
| 1291 |
|
{ |
| 1292 |
|
log_error("Inconsistent SID\n"); |
| 1293 |
|
return -1; |
| 1294 |
|
} |
| 1295 |
|
|
| 1296 |
|
// acquire lock of section |
| 1297 |
|
if ((ret = section_list_rd_lock(p_section)) < 0) |
| 1298 |
|
{ |
| 1299 |
|
log_error("section_list_rd_lock(sid = %d) error\n", p_section->sid); |
| 1300 |
|
return -2; |
| 1301 |
|
} |
| 1302 |
|
|
| 1303 |
|
*pp_article = NULL; |
| 1304 |
|
|
| 1305 |
|
if (direction >= 0) |
| 1306 |
|
{ |
| 1307 |
|
for (p_article = p_article_cur->p_next; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_next) |
| 1308 |
|
{ |
| 1309 |
|
if (p_article->visible && strcasestr(p_article->title, title) != NULL) |
| 1310 |
|
{ |
| 1311 |
|
*pp_article = p_article; |
| 1312 |
|
break; |
| 1313 |
|
} |
| 1314 |
|
} |
| 1315 |
|
} |
| 1316 |
|
else // direction < 0 |
| 1317 |
|
{ |
| 1318 |
|
for (p_article = p_article_cur->p_prior; p_article != NULL && p_article != p_article_cur; p_article = p_article->p_prior) |
| 1319 |
|
{ |
| 1320 |
|
if (p_article->visible && strcasestr(p_article->title, title) != NULL) |
| 1321 |
|
{ |
| 1322 |
|
*pp_article = p_article; |
| 1323 |
|
break; |
| 1324 |
|
} |
| 1325 |
|
} |
| 1326 |
|
} |
| 1327 |
|
|
| 1328 |
// release lock of section |
// release lock of section |
| 1329 |
if (section_list_rd_unlock(p_section) < 0) |
if (section_list_rd_unlock(p_section) < 0) |
| 1330 |
{ |
{ |