| 1 |
/*************************************************************************** |
/* SPDX-License-Identifier: GPL-3.0-or-later */ |
| 2 |
user_priv.c - description |
/* |
| 3 |
------------------- |
* user_priv |
| 4 |
Copyright : (C) 2004-2025 by Leaflet |
* - basic operations of user privilege |
| 5 |
Email : leaflet@leafok.com |
* |
| 6 |
***************************************************************************/ |
* Copyright (C) 2004-2026 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 |
|
|
|
#include "user_priv.h" |
|
| 13 |
#include "bbs.h" |
#include "bbs.h" |
| 14 |
#include "common.h" |
#include "common.h" |
| 15 |
#include "database.h" |
#include "database.h" |
| 16 |
#include "log.h" |
#include "log.h" |
| 17 |
|
#include "user_priv.h" |
| 18 |
#include <stdio.h> |
#include <stdio.h> |
| 19 |
#include <stdlib.h> |
#include <stdlib.h> |
| 20 |
#include <mysql/mysql.h> |
#include <mysql.h> |
| 21 |
|
|
| 22 |
BBS_user_priv BBS_priv; |
BBS_user_priv BBS_priv; |
| 23 |
|
|
| 31 |
{ |
{ |
| 32 |
mid = (left + right) / 2; |
mid = (left + right) / 2; |
| 33 |
|
|
| 34 |
if (sid <= p_priv->s_priv_list[mid].sid) |
if (sid < p_priv->s_priv_list[mid].sid) |
| 35 |
{ |
{ |
| 36 |
right = mid; |
right = mid - 1; |
| 37 |
} |
} |
| 38 |
else |
else if (sid > p_priv->s_priv_list[mid].sid) |
| 39 |
{ |
{ |
| 40 |
left = mid + 1; |
left = mid + 1; |
| 41 |
} |
} |
| 42 |
|
else // if (sid == p_priv->s_priv_list[mid].sid) |
| 43 |
|
{ |
| 44 |
|
left = mid; |
| 45 |
|
break; |
| 46 |
|
} |
| 47 |
} |
} |
| 48 |
|
|
| 49 |
*p_offset = left; |
*p_offset = left; |
| 50 |
|
|
| 51 |
return (left == right && sid == p_priv->s_priv_list[left].sid); |
return (sid == p_priv->s_priv_list[left].sid); |
| 52 |
} |
} |
| 53 |
|
|
| 54 |
int setpriv(BBS_user_priv *p_priv, int sid, int priv, int is_favor) |
int setpriv(BBS_user_priv *p_priv, int sid, int priv, int is_favor) |
| 62 |
return 0; |
return 0; |
| 63 |
} |
} |
| 64 |
|
|
| 65 |
if (search_priv(p_priv, sid, &offset)) //found |
if (search_priv(p_priv, sid, &offset)) // found |
| 66 |
{ |
{ |
| 67 |
p_priv->s_priv_list[offset].s_priv = priv; |
p_priv->s_priv_list[offset].s_priv = priv; |
| 68 |
p_priv->s_priv_list[offset].is_favor = is_favor; |
p_priv->s_priv_list[offset].is_favor = is_favor; |
| 94 |
{ |
{ |
| 95 |
int offset; |
int offset; |
| 96 |
|
|
| 97 |
if (search_priv(p_priv, sid, &offset)) //found |
if (search_priv(p_priv, sid, &offset)) // found |
| 98 |
{ |
{ |
| 99 |
*p_is_favor = p_priv->s_priv_list[offset].is_favor; |
*p_is_favor = p_priv->s_priv_list[offset].is_favor; |
| 100 |
return p_priv->s_priv_list[offset].s_priv; |
return p_priv->s_priv_list[offset].s_priv; |
| 126 |
uid); |
uid); |
| 127 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 128 |
{ |
{ |
| 129 |
log_error("Query user_list error: %s\n", mysql_error(db)); |
log_error("Query user_list error: %s", mysql_error(db)); |
| 130 |
return -1; |
return -1; |
| 131 |
} |
} |
| 132 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 133 |
{ |
{ |
| 134 |
log_error("Get user_list data failed\n"); |
log_error("Get user_list data failed"); |
| 135 |
return -1; |
return -1; |
| 136 |
} |
} |
| 137 |
if ((row = mysql_fetch_row(rs))) |
if ((row = mysql_fetch_row(rs))) |
| 148 |
uid); |
uid); |
| 149 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 150 |
{ |
{ |
| 151 |
log_error("Query admin_config error: %s\n", mysql_error(db)); |
log_error("Query admin_config error: %s", mysql_error(db)); |
| 152 |
return -1; |
return -1; |
| 153 |
} |
} |
| 154 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 155 |
{ |
{ |
| 156 |
log_error("Get admin_config data failed\n"); |
log_error("Get admin_config data failed"); |
| 157 |
return -1; |
return -1; |
| 158 |
} |
} |
| 159 |
if ((row = mysql_fetch_row(rs))) |
if ((row = mysql_fetch_row(rs))) |
| 172 |
uid); |
uid); |
| 173 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 174 |
{ |
{ |
| 175 |
log_error("Query section_master error: %s\n", mysql_error(db)); |
log_error("Query section_master error: %s", mysql_error(db)); |
| 176 |
return -1; |
return -1; |
| 177 |
} |
} |
| 178 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 179 |
{ |
{ |
| 180 |
log_error("Get section_master data failed\n"); |
log_error("Get section_master data failed"); |
| 181 |
return -1; |
return -1; |
| 182 |
} |
} |
| 183 |
while ((row = mysql_fetch_row(rs))) |
while ((row = mysql_fetch_row(rs))) |
| 196 |
"ORDER BY SID"); |
"ORDER BY SID"); |
| 197 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 198 |
{ |
{ |
| 199 |
log_error("Query section_config error: %s\n", mysql_error(db)); |
log_error("Query section_config error: %s", mysql_error(db)); |
| 200 |
return -1; |
return -1; |
| 201 |
} |
} |
| 202 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 203 |
{ |
{ |
| 204 |
log_error("Get section_config data failed\n"); |
log_error("Get section_config data failed"); |
| 205 |
return -1; |
return -1; |
| 206 |
} |
} |
| 207 |
while ((row = mysql_fetch_row(rs))) |
while ((row = mysql_fetch_row(rs))) |
| 230 |
uid); |
uid); |
| 231 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 232 |
{ |
{ |
| 233 |
log_error("Query ban_user_list error: %s\n", mysql_error(db)); |
log_error("Query ban_user_list error: %s", mysql_error(db)); |
| 234 |
return -1; |
return -1; |
| 235 |
} |
} |
| 236 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 237 |
{ |
{ |
| 238 |
log_error("Get ban_user_list data failed\n"); |
log_error("Get ban_user_list data failed"); |
| 239 |
return -1; |
return -1; |
| 240 |
} |
} |
| 241 |
while ((row = mysql_fetch_row(rs))) |
while ((row = mysql_fetch_row(rs))) |
| 251 |
uid); |
uid); |
| 252 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 253 |
{ |
{ |
| 254 |
log_error("Query section_favorite error: %s\n", mysql_error(db)); |
log_error("Query section_favorite error: %s", mysql_error(db)); |
| 255 |
return -1; |
return -1; |
| 256 |
} |
} |
| 257 |
if ((rs = mysql_store_result(db)) == NULL) |
if ((rs = mysql_store_result(db)) == NULL) |
| 258 |
{ |
{ |
| 259 |
log_error("Get section_favorite data failed\n"); |
log_error("Get section_favorite data failed"); |
| 260 |
return -1; |
return -1; |
| 261 |
} |
} |
| 262 |
while ((row = mysql_fetch_row(rs))) |
while ((row = mysql_fetch_row(rs))) |