: How can I delete all Wiki pages created by spammers except mine in MediaWiki? I Implemented a MediaWiki site but unfortunately somebody created thousands of pages through thousand of users. Which

I Implemented a MediaWiki site but unfortunately somebody created thousands of pages through thousand of users.

Which query could I run for deleting all pages created by these users except mine?

MediaWiki pages are in wiki_page and wiki_text inside MediaWiki database but there is no field about who created those pages.

Largest table:

wiki_text: 682MB
wiki_externallinks: 162.5 MB
wiki_recentchange: 95 MB
wiki_page: 43 MB

Here, I find a possible answer to my problem but I'm blocked at the first step:

"Export articles created by you (presumably logged in as the WikiSysop user or similar)"

How can I export article made by me if in the table there is no field about user who created pages?

10.01% popularity Vote Up Vote Down

: How do I transition to SSL without affecting PageRank? Here at Stack Exchange we're working on moving all traffic to SSL. The reason we're not doing logged-in-users only is that one side of

@Phylliss660

Posted in: #Https #Pagerank #Seo

5 Comments

: What does the keyword 'impression' mean or constitute in web analytics I would like to understand what does the keyword 'clicks' mean or constitute in web analytics. I have asked a similar question

@Phylliss660

Posted in: #Analytics #GoogleAnalytics

1 Comments

: Using gmail for automated site emails - recommended? allowed? is it okay to use gmail to send automated emails for your website via SMTP? i know there are services like Amazons SES, but i

@Phylliss660

Posted in: #Email #Smtp

1 Comments

: Looking for a Domain Manager I am looking for the best Domain "management" company. Have about 500+ domains at the moment and acquire more on a daily basis. Would prefer to have a full-service

@Phylliss660

Posted in: #Domains #Management

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Deb1703797

If you know some Python (or are not afraid to learn) you should approach this with pywikibot.

You can loop through wiki.allpages() and you can add some logic to decide whether to delete a page or not. Good criteria:

Does the page contain specific words? E.g. related to drugs or porn.
Does the page have wikilinks to other pages?
Does the page have links from other pages?

(I can add a couple of Python lines here if there's any interest. Just let me know.)

10% popularity Vote Up Vote Down

Feed

: How can I delete all Wiki pages created by spammers except mine in MediaWiki? I Implemented a MediaWiki site but unfortunately somebody created thousands of pages through thousand of users. Which

More posts by @Phylliss660

: How do I transition to SSL without affecting PageRank? Here at Stack Exchange we're working on moving all traffic to SSL. The reason we're not doing logged-in-users only is that one side of

: What does the keyword 'impression' mean or constitute in web analytics I would like to understand what does the keyword 'clicks' mean or constitute in web analytics. I have asked a similar question

: Using gmail for automated site emails - recommended? allowed? is it okay to use gmail to send automated emails for your website via SMTP? i know there are services like Amazons SES, but i

: Looking for a Domain Manager I am looking for the best Domain "management" company. Have about 500+ domains at the moment and acquire more on a daily basis. Would prefer to have a full-service

Login to post a comment!

1 Comments

Back to top | Use Dark Theme