Want to get involved in developing SMF, then why not lend a hand on our github!
Started by digit, December 21, 2007, 06:48:43 AM
$days_ago = 365;$not_visited = strtotime("-$days_ago days");... connect to the database ...$mysqli -> query("DELETE t1 FROM <tables> AS t1 INNER JOIN smf_members AS t2 ON t1.id_member = t2.id_member WHERE t2.last_login < $not_visited");
Quote from: FishingManMatt on November 24, 2019, 08:25:02 PMHm... This time:smf_log_boards # of records decreased (the size remained the same) from 39000 (820 kB) to 29000 (820 kB)smf_log_mark_read # of records and the size increased from 8000 (200 kB) to 19700 (450 kB)smf_log_topics # of records and the size decreased from 1,600,000 (55 MB) to 1,260,000 (51 MB)
Quote from: shawnb61 on November 24, 2019, 11:48:26 PMBTW, it only defaults to processing 500 users at a time. You may need to run it multiple times. Not sure if that was clear.