%3$s'), bb_get_post_time(), get_topic_link( $bb_post->topic_id ), get_topic_title( $bb_post->topic_id ));?> IP:
'.$mass_delete_users_options['mass_delete_users_css'].'';
?>
$limit) {$text=substr($text,0,$limit)."…";}
return $text;
}
function mdu_install() {
global $bbdb;
$bbdb->query("CREATE TABLE IF NOT EXISTS `bb_users_deleted`
CHARSET utf8 COLLATE utf8_general_ci
SELECT * FROM $bbdb->users WHERE 1=0");
$bbdb->query("CREATE INDEX IF NOT EXISTS `ID` ON `bb_users_deleted` (`ID`)");
$bbdb->query("CREATE TABLE IF NOT EXISTS `bb_usermeta_deleted` (
`user_id` bigint(20) UNSIGNED NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext default NULL,
INDEX (`user_id`),
) CHARSET utf8 COLLATE utf8_general_ci");
}
/*
// This will show all users older than at least a month who have never posted:
SELECT ID,user_login,user_registered FROM wp_users
LEFT JOIN bb_posts ON ID=poster_id
WHERE user_registered