| 3 |
* article_del |
* article_del |
| 4 |
* - user interactive feature to delete article |
* - user interactive feature to delete article |
| 5 |
* |
* |
| 6 |
* Copyright (C) 2004-2025 Leaflet <leaflet@leafok.com> |
* Copyright (C) 2004-2026 Leaflet <leaflet@leafok.com> |
| 7 |
*/ |
*/ |
| 8 |
|
|
| 9 |
|
#ifdef HAVE_CONFIG_H |
| 10 |
|
#include "config.h" |
| 11 |
|
#endif |
| 12 |
|
|
| 13 |
#include "article_del.h" |
#include "article_del.h" |
| 14 |
#include "database.h" |
#include "database.h" |
| 15 |
#include "io.h" |
#include "io.h" |
| 33 |
|
|
| 34 |
if (p_section == NULL || p_article == NULL) |
if (p_section == NULL || p_article == NULL) |
| 35 |
{ |
{ |
| 36 |
log_error("NULL pointer error\n"); |
log_error("NULL pointer error"); |
| 37 |
} |
} |
| 38 |
|
|
| 39 |
if (p_article->excerption) // Delete is not allowed |
if (p_article->excerption) // Delete is not allowed |
| 51 |
prints("真的要删除文章?(Y)是, (N)否 [N]: "); |
prints("真的要删除文章?(Y)是, (N)否 [N]: "); |
| 52 |
iflush(); |
iflush(); |
| 53 |
|
|
| 54 |
for (ch = 0; !SYS_server_exit; ch = igetch_t(MAX_DELAY_TIME)) |
for (ch = 0; !SYS_server_exit; ch = igetch_t(BBS_max_user_idle_time)) |
| 55 |
{ |
{ |
| 56 |
switch (toupper(ch)) |
switch (toupper(ch)) |
| 57 |
{ |
{ |
| 79 |
db = db_open(); |
db = db_open(); |
| 80 |
if (db == NULL) |
if (db == NULL) |
| 81 |
{ |
{ |
| 82 |
log_error("db_open() error: %s\n", mysql_error(db)); |
log_error("db_open() error: %s", mysql_error(db)); |
| 83 |
ret = -1; |
ret = -1; |
| 84 |
goto cleanup; |
goto cleanup; |
| 85 |
} |
} |
| 87 |
// Begin transaction |
// Begin transaction |
| 88 |
if (mysql_query(db, "SET autocommit=0") != 0) |
if (mysql_query(db, "SET autocommit=0") != 0) |
| 89 |
{ |
{ |
| 90 |
log_error("SET autocommit=0 error: %s\n", mysql_error(db)); |
log_error("SET autocommit=0 error: %s", mysql_error(db)); |
| 91 |
ret = -1; |
ret = -1; |
| 92 |
goto cleanup; |
goto cleanup; |
| 93 |
} |
} |
| 94 |
|
|
| 95 |
if (mysql_query(db, "BEGIN") != 0) |
if (mysql_query(db, "BEGIN") != 0) |
| 96 |
{ |
{ |
| 97 |
log_error("Begin transaction error: %s\n", mysql_error(db)); |
log_error("Begin transaction error: %s", mysql_error(db)); |
| 98 |
ret = -1; |
ret = -1; |
| 99 |
goto cleanup; |
goto cleanup; |
| 100 |
} |
} |
| 105 |
|
|
| 106 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 107 |
{ |
{ |
| 108 |
log_error("Query article status error: %s\n", mysql_error(db)); |
log_error("Query article status error: %s", mysql_error(db)); |
| 109 |
ret = -1; |
ret = -1; |
| 110 |
goto cleanup; |
goto cleanup; |
| 111 |
} |
} |
| 112 |
if ((rs = mysql_use_result(db)) == NULL) |
if ((rs = mysql_use_result(db)) == NULL) |
| 113 |
{ |
{ |
| 114 |
log_error("Get article status data failed\n"); |
log_error("Get article status data failed"); |
| 115 |
ret = -1; |
ret = -1; |
| 116 |
goto cleanup; |
goto cleanup; |
| 117 |
} |
} |
| 156 |
|
|
| 157 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 158 |
{ |
{ |
| 159 |
log_error("Update article status error: %s\n", mysql_error(db)); |
log_error("Update article status error: %s", mysql_error(db)); |
| 160 |
ret = -1; |
ret = -1; |
| 161 |
goto cleanup; |
goto cleanup; |
| 162 |
} |
} |
| 177 |
|
|
| 178 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 179 |
{ |
{ |
| 180 |
log_error("Update exp error: %s\n", mysql_error(db)); |
log_error("Update exp error: %s", mysql_error(db)); |
| 181 |
ret = -1; |
ret = -1; |
| 182 |
goto cleanup; |
goto cleanup; |
| 183 |
} |
} |
| 192 |
|
|
| 193 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 194 |
{ |
{ |
| 195 |
log_error("Add log error: %s\n", mysql_error(db)); |
log_error("Add log error: %s", mysql_error(db)); |
| 196 |
ret = -1; |
ret = -1; |
| 197 |
goto cleanup; |
goto cleanup; |
| 198 |
} |
} |
| 206 |
|
|
| 207 |
if (mysql_query(db, sql) != 0) |
if (mysql_query(db, sql) != 0) |
| 208 |
{ |
{ |
| 209 |
log_error("Update article error: %s\n", mysql_error(db)); |
log_error("Update article error: %s", mysql_error(db)); |
| 210 |
ret = -1; |
ret = -1; |
| 211 |
goto cleanup; |
goto cleanup; |
| 212 |
} |
} |
| 215 |
// Commit transaction |
// Commit transaction |
| 216 |
if (mysql_query(db, "COMMIT") != 0) |
if (mysql_query(db, "COMMIT") != 0) |
| 217 |
{ |
{ |
| 218 |
log_error("Commit transaction error: %s\n", mysql_error(db)); |
log_error("Commit transaction error: %s", mysql_error(db)); |
| 219 |
ret = -1; |
ret = -1; |
| 220 |
goto cleanup; |
goto cleanup; |
| 221 |
} |
} |