Mediawiki - Removendo Spam: mudanças entre as edições

De Pontão Nós Digitais
Ir para navegaçãoIr para pesquisar
Sem resumo de edição
Sem resumo de edição
Linha 17: Linha 17:


As queries usados foram:
As queries usados foram:
remove o conteúdo de mw_categorylinks
'''remove o conteúdo de mw_categorylinks'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 32: Linha 32:




remove o conteúdo de mw_pagelinks
'''remove o conteúdo de mw_pagelinks'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 46: Linha 46:
</source>
</source>


remove o conteúdo de mw_externallinks
 
'''remove o conteúdo de mw_externallinks'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 60: Linha 61:
</source>
</source>
   
   
remove o conteúdo de mw_imagelinks
 
'''remove o conteúdo de mw_imagelinks'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 74: Linha 76:
</source>
</source>


remove o conteúdo de mw_user
 
'''remove o conteúdo de mw_user'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 81: Linha 84:
</source>
</source>


remove o conteúdo de mw_recentchanges
 
'''remove o conteúdo de mw_recentchanges'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 88: Linha 92:
</source>
</source>


remove o conteúdo de mw_oldimage
 
'''remove o conteúdo de mw_oldimage'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 95: Linha 100:
</source>
</source>


remove o conteúdo de mw_logging
 
'''remove o conteúdo de mw_logging'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 102: Linha 108:
</source>
</source>


remove o conteúdo de mw_image
 
'''remove o conteúdo de mw_image'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 109: Linha 116:
</source>
</source>


remove o conteúdo de mw_archive
 
'''remove o conteúdo de mw_archive'''
<source lang="mysql">
<source lang="mysql">
delete
delete
Linha 116: Linha 124:
</source>
</source>


remove o conteúdo de page  
 
'''remove o conteúdo de page'''
<source lang="mysql">
<source lang="mysql">
delete
delete

Edição das 14h25min de 22 de agosto de 2013

O seguinte documentação funciona da seguinte forma:

  • Crie as regras de restrições de edição e criando grupo no MediaWiki, adicionando em LocalSettings.php

$wgGroupPermissions['*']['edit'] = false; $wgGroupPermissions['user']['edit'] = false; $wgGroupPermissions['human']['edit'] = true; $wgGroupPermissions['sysop']['edit'] = true;

  • Adicionar os usuários humanos no grupo "human". Há duas formas de fazer, via interface administratica web do MediaWiki, indo emPáginas especiais > Gestão de privilégios de usuários > Localize o usuário > acrescente no grupo "human"

ou pela linha de comando no MySQL: <source lang="mysql"> INSERT INTO mw_user_groups ( ug_user, ug_group ) VALUES ( 3, "human"); </source>

Depois um conjunto queries que identificará tudo criado por usuário que não está no grupo human e removerá esse conteúdo e depois os usuários.

As queries usados foram: remove o conteúdo de mw_categorylinks <source lang="mysql"> delete from mw_categorylinks where cl_from in (select pg.page_id

 from mw_page pg 
 where pg.page_id in (select rev_page
  from `mw_revision`
  where `rev_user` not in(select ug_user from mw_user_groups)
  and `rev_timestamp` in (select MIN(`rev_timestamp`) from `mw_revision` group by rev_page)
  )

); </source>


remove o conteúdo de mw_pagelinks <source lang="mysql"> delete from mw_pagelinks where pl_from in (select pg.page_id

 from mw_page pg 
 where pg.page_id in (select rev_page
  from `mw_revision`
  where `rev_user` not in(select ug_user from mw_user_groups)
  and `rev_timestamp` in (select MIN(`rev_timestamp`) from `mw_revision` group by rev_page)
 )

); </source>


remove o conteúdo de mw_externallinks <source lang="mysql"> delete from mw_externallinks where el_from in (select pg.page_id

from mw_page pg 
where pg.page_id in (select rev_page
  from `mw_revision`
  where `rev_user` not in(select ug_user from mw_user_groups)
  and `rev_timestamp` in (select MIN(`rev_timestamp`) from `mw_revision` group by rev_page)
 )

); </source>


remove o conteúdo de mw_imagelinks <source lang="mysql"> delete from mw_imagelinks where il_from in (select pg.page_id

from mw_page pg 
where pg.page_id in (select rev_page
 from `mw_revision`
 where `rev_user` not in(select ug_user from mw_user_groups)
 and `rev_timestamp` in (select MIN(`rev_timestamp`) from `mw_revision` group by rev_page)
)

); </source>


remove o conteúdo de mw_user <source lang="mysql"> delete from mw_user where user_id not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de mw_recentchanges <source lang="mysql"> delete from mw_recentchanges where rc_user not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de mw_oldimage <source lang="mysql"> delete from mw_oldimage where oi_user not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de mw_logging <source lang="mysql"> delete from mw_logging where log_user not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de mw_image <source lang="mysql"> delete from mw_image where img_user not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de mw_archive <source lang="mysql"> delete from mw_archive where ar_user not in(select ug_user from mw_user_groups) </source>


remove o conteúdo de page <source lang="mysql"> delete from mw_page where page_id in (select rev_page

from `mw_revision`
where `rev_user` not in(select ug_user from mw_user_groups)
and `rev_timestamp` in (select MIN(`rev_timestamp`) from `mw_revision` group by rev_page)

) </source>


Referências