Mediawiki - Removendo Spam: mudanças entre as edições
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>