User:Cyberpower678/ListGen.php

<?php /* Created by Cyberpower678 */ //Edit these to suit the criteria for eligibility $registrationTimestamp = "20251001000000"; //When the user 

<?php
/* Created by Cyberpower678 */

//Edit these to suit the criteria for eligibility
$registrationTimestamp = "20251001000000";  //When the user needs to have registered by
$votingStart = "20251118000000";            //When the voting period starts
$votingEnd = "20251201235959";              //When the voting period ends
$editCountEndTimestamp = "20251101000000";  //The timestamp of when the edit count requirements need to be fulfilled
$inactivityPeriod = "$editCountEndTimestamp - 1 year";    //When the activity period ends
$editCountRequirement = 150;    //Overall edit count requirement
$qualifyingNamespaces = [ 0 ];    //Leave empty for all namespaces
$activityEditCount = 10;        //Edits required within the activity as defined by inactivity value
$activityNamespaces = [];       //Leave empty for all namespaces

//Users to exclude that are a member of this category
$excludeCategoryMembers = [
        'Wikipedia_alternative_accounts',
        'Wikipedia_doppelganger_accounts',
        'Deceased_Wikipedians',
        'Users_who_do_not_wish_to_receive_ACE_messages'
];

$forcedCategoryExclusions = [];

//Don't edit this
if( !isset( $argv[1] ) || !isset( $argv[2] ) || !isset( $argv[3] ) || !isset( $argv[4] ) || !isset( $argv[5] ) || !isset( $argv[6] ) ) {
        echo "Missing operational arguments\n";
        exit( 1 );
}

//Location of DB within WMF Cloud
$dbHost = "enwiki.labsdb";
$dbDB = "enwiki_p";
$dbPort = 3306;

//Don't edit these
$ini = parse_ini_file( "{$_SERVER['HOME']}/replica.my.cnf" );

$dbUser = $ini['user'];
$dbPass = $ini['password'];

unset( $ini );

$removeBlocked = (bool) (int) $argv[1];
$removeCategories = (bool) (int) $argv[2];
$removeInactive = (bool) (int) $argv[3];
$securePoll = (bool) (int) $argv[4];
$removeBots = (bool) (int) $argv[5];
$removeVanished = (bool) (int) $argv[6];
$debug = (bool) (int) $argv[7];

if( $removeBots ) {
        $forcedCategoryExclusions[] = 'All_Wikipedia_bots';
}

$dbObject = mysqli_connect( $dbHost, $dbUser, $dbPass, $dbDB, $dbPort );

if( $dbObject === false ) {
        echo "Unable to connect to the DB, please verify connections settings.\n";
        echo "Error details: ";
        echo mysqli_errno( $dbObject );
        echo " - ";
        echo mysqli_error( $dbObject );
        exit( 1 );
}

$offset = 0;
$qualifyingUsersSP = [];
$qualifyingUsersMM = [];

$batchSize = 10000;

$scriptStart = time();

$inactivityPeriod = strtotime( $inactivityPeriod );
$editCountEndTimestamp = strtotime( $editCountEndTimestamp );

$timeStart = time();

//Let's get busy with actually populating a list
echo "Counting the number of users to check...\n";

//Get a total count of users being thoroughly vetted.  Ideal for tracking the script's total progress.
$countSQL = "Select count(*) as userCount
                                                                        from user
                                                                        where user_id > 0
                                                                          AND (user_registration < $registrationTimestamp OR user_registration is null)
                                                                          AND user_editcount >= $editCountRequirement ";
//If desired, filter out users blocked through the end of the voting period
if( $removeBlocked ) $countSQL .= "   AND user_id not in (select bt_user
                                                                                              from block_target 
											      join block on bl_target = bt_id
                                                                                              where bt_user > 0
                                                                                                AND bl_sitewide = 1
                                                                                                AND (bl_expiry > '$votingEnd' OR bl_expiry = 'infinity')) ";
//If desired, filter out bot flagged accounts
if( $removeBots ) $countSQL .= "AND user_id not in (select ug_user from user_groups where ug_group = 'bot')";
$countSQL .= ";";

if( $debug ) echo "$countSQL\n";

$res = mysqli_query( $dbObject, $countSQL );
//$res = true;
if( $res ) {
        $result = mysqli_fetch_assoc( $res );
        //$result['userCount'] = 171946;

        echo "Found {$result['userCount']} potentially qualifying users...\n";

        $totalUserCount = $result['userCount'];

        mysqli_free_result( $res );
        unset( $result, $res );
} else {
        echo "Unable to get total users\n";
	if( $debug ) echo mysqli_error( $dbObject );
        exit( 1 );
}

$processedUsers = 0;

//We get the job done faster by doing a multiquery.  Get maximum size of string we can send to the DB.
$res = mysqli_query( $dbObject, "show variables like 'max_allowed_packet';" );
if( $res ) {
        $result = mysqli_fetch_assoc( $res );
        $maxQuerySize = $result['Value'];
} else {
        echo "Unable to retrieve max query size\n";
        exit( 1 );
}

do {
        if( isset( $res ) ) {
                mysqli_free_result( $res );
                unset( $res, $result );
        }
        //Pull a list of user having meet the registration deadline, and basic edit count requirements
        $userListSQL = "Select user_id, user_name, user_registration, actor_id, ";
        if( $removeInactive ) {
                $userListSQL .= "(select rev_timestamp from revision_userindex ";
                if( !empty( $activityNamespaces ) ) $userListSQL .= "join page on page_id = rev_page ";
                $userListSQL .= "where rev_actor = actor_id
                                                  AND rev_timestamp > " . date( "YmdHis", $inactivityPeriod ) . "
                                                  AND rev_timestamp < " . date( "YmdHis", $editCountEndTimestamp ) . " ";
                if( !empty( $activityNamespaces ) ) $userListSQL .= "AND page_namespace IN (" .
                                                                    implode( ", ", $activityNamespaces ) . ") ";
                $userListSQL .= "limit " . ( $activityEditCount - 1 ) . ",1) is not null AND ";
        }
        $userListSQL .= "(select rev_timestamp from revision_userindex ";
        if( !empty( $qualifyingNamespaces ) ) $userListSQL .= "join page on page_id = rev_page ";
        $userListSQL .= "where rev_actor = actor_id ";
        if( !empty( $qualifyingNamespaces ) ) $userListSQL .= "AND page_namespace IN (" .
                                                              implode( ", ", $qualifyingNamespaces ) . ") ";
        $userListSQL .= "AND rev_timestamp < " . date( "YmdHis", $editCountEndTimestamp ) . " ";
        $userListSQL .= "limit " . ( $editCountRequirement - 1 ) . ",1) is not null as is_eligible ";
        $userListSQL .= "from user
                                        join actor_revision on actor_user = user_id
                                        where user_id > $offset
                                          AND (user_registration < $registrationTimestamp OR user_registration is null)
                                          AND user_editcount >= $editCountRequirement ";
        //If desired, filter out users that are at least blocked through the end of the voting period
        if( $removeBlocked ) $userListSQL .= "AND user_id not in (select bt_user
                                                                                                              from block_target
													      join block on bl_target = bt_id
                                                                                                              where bt_user > 0
                                                                                                                AND bl_sitewide = 1
                                                                                                                AND (bl_expiry > '$votingEnd' OR bl_expiry = 'infinity')) ";
        //If desired, filter out bot flagged account
        if( $removeBots ) $userListSQL .= "AND user_id not in (select ug_user from user_groups where ug_group = 'bot') ";
        //This optimizes the query for faster pagination
        $userListSQL .= "order by user_id asc limit $batchSize;";

        $res = mysqli_query( $dbObject, $userListSQL );

        $multiQuery = "";
        $multiList = [];
        while( $result = mysqli_fetch_assoc( $res ) ) {
                $offset = $result['user_id'];

                if( $result['is_eligible'] == 1 &&
                    ( $removeVanished === false ||
                        (stripos( $result['user_name'], 'vanished' ) === false && stripos( $result['user_name'], 'renamed' ) === false )
                    )
                ) {
                        //This directs how to format the list for the appropriate use.
                        $qualifyingUsersMM[] = "User talk:{$result['user_name']}";
                        $qualifyingUsersSP[] = "{$result['user_name']}@enwiki";
                }

                $processedUsers++;
        }

        //Give a progress report and an ETA on completion.
        $toEcho = "Processed: $processedUsers of $totalUserCount; ETA: ";
        $seconds = ( ( $totalUserCount / $processedUsers ) * ( time() - $timeStart ) ) - ( time() - $timeStart );
        $minutes = floor( $seconds / 60 );
        $seconds = $seconds % 60;
        $hours = floor( $minutes / 60 );
        $minutes = $minutes % 60;
        $toEcho .= "$hours:" . str_pad( $minutes, 2, "0", STR_PAD_LEFT ) . ":" . str_pad( $seconds, 2, "0", STR_PAD_LEFT );
        $toEcho .= "; Qualifying users found: " . count( $qualifyingUsersMM ) . "\n";

        echo $toEcho;

} while( mysqli_num_rows( $res ) == $batchSize );

if( $removeCategories ) {
        $forcedCategoryExclusions = array_merge( $forcedCategoryExclusions, $excludeCategoryMembers );
}

echo "Eliminating users in defined categories...\n";
//Get a list of users in the defined list of categories
$query =
        "select page_title
        from page
               join categorylinks on page_id = cl_from
        where cl_to IN ( '" . implode( "', '", $forcedCategoryExclusions ) . "' );";

$res = mysqli_query( $dbObject, $query );

//Remove them from the final list of qualifying users
while( $result = mysqli_fetch_assoc( $res ) ) {
        $result['page_title'] = str_replace( "_", " ", $result['page_title'] );
        $index = array_search( "User talk:{$result['page_title']}", $qualifyingUsersMM );
        if( $index !== false ) {
                unset( $qualifyingUsersMM[$index] );
                unset( $qualifyingUsersSP[$index] );
        }
}

//Write results to a file in the appropriate format.  Either Mass Message, or SecurePoll
file_put_contents( 'UserListMessageList',
                   "*{{#target:" . implode( "}}\n*{{#target:", $qualifyingUsersMM ) . "}}\n"
);
if( $securePoll === true ) file_put_contents( 'UserListSecurePoll', implode( "\n", $qualifyingUsersSP ) . "\n" );

//Output run stats
$seconds = time() - $scriptStart;
$minutes = floor( $seconds / 60 );
$seconds = $seconds % 60;
$hours = floor( $minutes / 60 );
$minutes = $minutes % 60;
$toEcho = "$hours:" . str_pad( $minutes, 2, "0", STR_PAD_LEFT ) . ":" . str_pad( $seconds, 2, "0", STR_PAD_LEFT );

echo "Script finished.  Final user count: " . count( $qualifyingUsersMM ) . "; Execution time: $toEcho\n";

//We're done.  Let's do it again sometime. :-)

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.