Differences From Artifact [8bc923eb4c]:
- File src/moderate.c — part of check-in [b14cf3bc68] at 2019-05-17 07:27:00 on branch moderate-disapprove-on-user-delete — When deleting a user via /setup_uedit, also disapprove any pending-moderation entries for users which are no longer in the user table. This is programmatically simpler than only removing entries for the removed user but (potential corner case) would also disapprove pending modreq entries if a user account is renamed while moderation of their content is pending. (user: stephan size: 6428) [more...]
To Artifact [dc44a6cacb]:
- File src/moderate.c — part of check-in [b39d8d69dd] at 2019-05-20 22:47:27 on branch selected-branch-on-left — For timelines of a particular branch, try to put the target branch on the left side of the graph, before "trunk". Trunk comes second. (user: drh size: 6431) [more...]
| ︙ | |||
182 183 184 185 186 187 188 | 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 | - + |
if( moderation_table_exists() ){
blob_init(&sql, timeline_query_for_www(), -1);
blob_append_sql(&sql,
" AND event.objid IN (SELECT objid FROM modreq)"
" ORDER BY event.mtime DESC"
);
db_prepare(&q, "%s", blob_sql_text(&sql));
|
| ︙ |