User:Angela/useful stuff

As of Saturday, 7 June, there are 7,004,957 articles.

boilerplates | MW namespace | All (changes)
{{msg:stub}} {{msg:disambig}}* {{subst:vfd}}
{{msg:protected}} {{msg:inclusion}}
''This page has been listed on [[Wikipedia:Votes for deletion]].''
''Please see that page for justifications and discussion.''

Welcome to my useful stuff page! :)
Edits | 10000 | 3000 | 1000 | Deletion | Is not |
Stubs | Sandbox | SQL | Problem | Useless |
Talk | Summary | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |

Goings-on | Village pump

Images

<div style="float:right;margin:0 0 1em 1em;font-style:italic;">[[Image:image name|alt text]]<br>Caption</div>

Sysops

==Sysop==

Congratulations! You are now an [[Wikipedia:Administrators|administrator]]. You should read the relevant policies and other pages linked to from the [[Wikipedia:administrators' reading list|administrators' reading list]] before carrying out tasks like deletion, protection, banning users, and editing protected pages such as the [[Main Page]]. Most of what you do is easily reversible by other sysops, apart from page history merges and image deletion, so please be especially careful with those. Good luck. ~~~~

Delete debates

Wikipedia:Archived delete debates

'''This page is an archive of the discussion surrounding the proposed deletion of a page entitled [[PAGE NAME]].'''

'''Further comments should be made on the [[Talk:PAGE NAME|talk page]] rather than here as this page is kept as an historic record.'''

'''The result of the debate was RESULT.'''

Copyright violation

Put this on a page with possible copyright violation;
Removed possible [[Wikipedia:Copyrights|copyright infringement]]. Text that was previously posted here is the same as text from this webpage:
:

This page is now listed on [[Wikipedia:Possible copyright infringements]]. To the poster: If there was permission to use this material under terms of our [[Wikipedia:Text of the GNU Free Documentation License|license]] or if you are the copyright holder of the externally linked text, then please indicate so on [[Talk:PAGE NAME|the talk page]]. If there was no permission to use this text then please rewrite the page at:
:[[Talk:PAGE NAME/temp]]

or leave this page to be deleted. Deletion will occur about one week from the time this page title was placed on the Votes for deletion page. If a temp page is created, it will be moved here following deletion of the original.

It also should be noted that the posting of copyrighted material that does ''not'' have the express permission from the copyright holder is possibly in violation of applicable law and of our [[wikipedia:copyright|policy]]. Those with a history of violations may be temporarily [[Special:Ipblocklist|suspended]] from editing pages. If this is in fact an infringement of copyright, we still welcome any original contributions by you.

Thanks, ~~~~

New users

New user log, welcoming committee
Hello, [[Wikipedia:Welcome, newcomers|welcome]] to Wikipedia.

You might find these links helpful in creating new pages or helping with the above tasks: [[Wikipedia:How to edit a page|]], [[Wikipedia:show preview|]], [[Wikipedia:How to write a great article|]], [[Wikipedia:Naming conventions|]], [[Wikipedia:Manual of Style|]]. You should read our [[Wikipedia:Policies and guidelines|policies]] at some point too.

If you have any questions, see the [[Wikipedia:Help|help pages]], add a question to the [[Wikipedia:village pump|]] or ask me on [[User_talk:Angela|my talk page]]. I hope you enjoy editing here and being a [[Wikipedia:Wikipedians|Wikipedian]]!

~~~~

Unregistered users

Hello and [[Wikipedia:Welcome, newcomers|welcome]] to Wikipedia. Thanks for all your contributions. Why not [[Special:Userlogin|create an account]] so your user name will be attributed to your articles?

Here are some useful links in case you haven't already found them:
*[[Wikipedia:How to edit a page|How to edit a page]]
*[[Wikipedia:show preview|]]
*[[Wikipedia:How to write a great article|]]
*[[Wikipedia:Naming conventions|Naming conventions]]
*[[Wikipedia:Help|Help]]
*[[Wikipedia:Village pump|Village pump]]

I hope you continue to enjoy editing here . ~~~~

Database queries

Special:Asksql - Database queries - SQL results - Log

This one finds new users. Finds 20 users, starting at the tenth one.
SELECT user_name, COUNT(*) FROM user, cur WHERE user_id=cur_user GROUP BY user_id ORDER BY user_id DESC LIMIT 10,20

This one find pages where the title word is not in bold.
SELECT cur_title FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text NOT LIKE "%'''%" AND cur_text NOT LIKE "%<b>%" AND cur_text NOT LIKE "%disambiguation%" AND cur_text NOT LIKE "%list%" and cur_title NOT LIKE "1%" LIMIT 200,150 ;

This one finds pages that may have a misused "it's".
select cur_title from cur where cur_namespace=0 and cur_text like "%it's%" and limit 3000,200;

This one finds broken redirects.
<nowiki>select cur_title, cur_namespace from cur,brokenlinks where cur_id=bl_from and cur_is_redirect=1 group by cur_id limit 100

This one finds protected pages.
select cur_title,cur_namespace from cur where cur_restrictions<>""

Alphabet bar instead of a TOC

__NOTOC__ [[#A|A]] [[#B|B]] [[#C|C]] [[#D|D]] [[#E|E]] [[#F|F]] [[#G|G]] [[#H|H]] [[#I|I]] [[#J|J]] [[#K|K]] [[#L| L]] [[#M|M]] [[#N|N]] [[#O|O]] [[#P|P]] [[#Q|Q]] [[#R|R]] [[#S|S]] [[#T|T]] [[#U|U]] [[#V|V]] [[#W|W]] [[#X|X]] [[#Y|Y]] [[#Z|Z]]

Warnings

Some of the following are based on User:Sj/boiler and Mediawiki:test

Tests

Your test worked. It has now been deleted. Future tests should be done in the [[Wikipedia:Sandbox]]. Please see the [[Wikipedia:Welcome, newcomers|welcome page]] if you would like to learn more about contributing here. Thanks. ~~~~

Unhelpful

The contributions you are making are not helpful. Please bear this in mind before making further edits. If you would like to experiment, please use the [[Wikipedia:Sandbox]]. ~~~~

Vandalism

Please stop vandalising [[PAGE NAME]] or you may be [[Special:Ipblocklist|blocked]] from editing. Please read the [[Wikipedia:Welcome, newcomers|welcome]] page if you are interested in contributing here. Thanks. ~~~~

NPOV

Welcome to Wikipedia. Your contributions are very welcome. Your contribution to [[]], however, fell outside the bounds of a [[Wikipedia:Neutral point of view|neutral point of view]] and was removed. Please bear this in mind while making further contributions. ~~~~

Copyright

Hello, [[Wikipedia:Welcome, newcomers|welcome]] to Wikipedia. The article you created at [[ARTICLE NAME]] appears to be copied from WEBSITE. Unless you are the author of the original information and you are able to release it under the [[Wikipedia:Text of the GNU Free Documentation License|GFDL]] then the page will need to be deleted. Please see [[Wikipedia:Copyrights]] for further information. Even if this is a copyright violation, we would still welcome any original contributions from you. See the instructions on [[Wikipedia:how to edit a page|how to edit a page]] for more info. Thanks. ~~~~

Toolbar experiments

0230 æ
0232 è