require_once ( "GLOBALS.php" );
include_once ( $GLOBALS['DATA_DIR'] . "scripts/fudapi.inc.php" );
fud_use ( 'db.inc' );
include_once ( '../include/users_adm.inc' );

define ( 'forum_debug', 1 );

$num_days = 60; /* Number of days to keep stale users */

$query = "SELECT * FROM " . $GLOBALS['DBHOST_TBL_PREFIX']
            . "users ORDER BY join_date ASC ";

$listing = _fud_simple_fetch_query( 0, $query );

$fh = fopen ( 'users.dump', 'w' );

foreach ( $listing as $user ) {
    if ( ( $user->posted_msg_count == 0 ) && ( $user->id != 1 )
            && ( time() - $user->join_date >= ( $num_days * 24 * 60 * 60 ) ) ) {
        print "Deleted ID: " . $user->id . " ";
        print "Login: " . $user->login . " ";
        print "Joined: " . date('m/d/Y',$user->join_date) . " ";
        print "Posts: " . $user->posted_msg_count . "\n";
        while ( list ( $key, $val ) = each ($user) )
            $vals[] = "'".$val."'";
        $sqlcode = 'INSERT INTO users VALUES ('.join(', ', $vals).');';
        fwrite ( $fh, $sqlcode."\n" );
        usr_delete($user->id);
    }
    $vals = "";
}

fclose ( $fh );