in the page index.php?action=moderate;area=modlog we can see all moderation actions, and i think they're all stored in smf_log_actions table in database.
it's all there? if i run a script every x hours pruning that table in db, it will work, or there are some dependencies?
i've got an auto publishing script for rss news and i have thousands of topic approval and deleting that i don't want to see in moderation log. is that possible or it needs to be deleted only by checking and deleting them from modlog page?
Thanks, anybody.
It's really complicated because multiple logs are stored in the same place as the moderation log.
Quote from: Arantor on September 13, 2017, 07:25:25 AM
It's really complicated because multiple logs are stored in the same place as the moderation log.
not so much, indeed, in my case. i need to delete only voices related to a single board, and only for deleting and approving posts
Yeah it is because admin and profile edit logs are literally in the same table. And I don't remember if you can easily filter to board level with straight SQL.
in smf_log_actions there are following keys:
id_action
id_log
log_time
id_member
ip
action
id_board
id_topic
id_msg
extra
so sure i can filter by member, board and action.
i don't know what does id_log mean, it's an integer between 1 and 3.
and that's been my entire point. It stores three different logs here!
You want where id_log is 1.
yes 1 is for moderation action, then i think 2 is for profile editing and 3 is for administrators actions.
could i simply delete filtered rows with a sql query?
Yes, that would work.
Though from your described use case I wonder if a forum is the right fit for you.
Quote from: Arantor on September 13, 2017, 10:53:18 AM
Yes, that would work.
Though from your described use case I wonder if a forum is the right fit for you.
yes, my site is basically a forum. those things are services we provide. maybe they would be ported to a CMS system, but I worked a lot in customizing simpleportal for it, and i cannot find a real user integration between SMF and a CMS like joomla or drupal or even wordpress.