MaRDI4NFDI / portal-compose

docker-composer repo for mardi
https://portal.mardi4nfdi.de
GNU General Public License v3.0
3 stars 1 forks source link

Delete spam accounts #431

Closed physikerwelt closed 8 months ago

physikerwelt commented 8 months ago

Delete blocked accounts currently


<block user="VincentDarrow"/>
<block user="TrinaCarter9"/>
<block user="TawannaSilver3"/>
<block user="StacyCintron"/>
<block user="RoseannaParmley"/>
<block user="RosalindaHirst"/>
<block user="PLJShani69133440"/>
<block user="MorrisAguilar0"/>
<block user="MauraLorenzini8"/>
<block user="MarissaRosales4"/>
<block user="MaricruzMarshbur"/>
<block user="Lavonne82T"/>
<block user="KristaToler121"/>
<block user="KoryConway208"/>
<block user="KingTgd050283"/>
<block user="KieraLade78"/>
<block user="KelleyLemons5"/>
<block user="JeffryAult581"/>
<block user="GrazynaDelancey"/>
<block user="FrancineToohey"/>
<block user="EusebiaVanwagene"/>
<block user="ElenaNolette"/>
<block user="ElenaLaufer220"/>
<block user="DinoStaley16098"/>
<block user="DenishaHubbs"/>
<block user="DeclanSpeight9"/>
<block user="CatherineRosas7"/>
<block user="CallieLeverette"/>
<block user="BriannaAlicea9"/>
<block user="BettyLumpkins"/>
<block user="AlvaroDonohue"/>
<block user="AlenaClare6506"/>
<block user="AdelaidaSeder5"/>
physikerwelt commented 8 months ago

I merged all edits to a single user, spam, delete them now from the db. Keep the original userids, to null them, in case of problems


<block userid="34"/>
<block userid="23"/>
<block userid="24"/>
<block userid="29"/>
<block userid="30"/>
<block userid="25"/>
<block userid="45"/>
<block userid="13"/>
<block userid="32"/>
<block userid="37"/>
<block userid="44"/>
<block userid="19"/>
<block userid="40"/>
<block userid="33"/>
<block userid="18"/>
<block userid="27"/>
<block userid="22"/>
<block userid="35"/>
<block userid="20"/>
<block userid="21"/>
<block userid="31"/>
<block userid="28"/>
<block userid="36"/>
<block userid="16"/>
<block userid="26"/>
<block userid="15"/>
<block userid="17"/>
<block userid="42"/>
<block userid="14"/>
<block userid="43"/>
<block userid="38"/>
<block userid="41"/>
physikerwelt commented 8 months ago

Done.


Update actor set actor_user = null
    WHERE actor_user in
        (34,23,24,29,30,25,45,13,32,37,44,19,40,33,18,27,22,35,20,21,31,28,36,16,26,15,17,42,14,43,38,41);

Delete from user where user_id in
                       (34,23,24,29,30,25,45,13,32,37,44,19,40,33,18,27,22,35,20,21,31,28,36,16,26,15,17,42,14,43,38,41);