User:Iritscen/PageCountAudit: Difference between revisions

Revision as of 18:09, 18 March 2013

Magic words

These first two poorly-documented magic words provide easy answers to the amount of content on the wiki. However, unless they are based on something logical that I haven't discovered yet, they are completely useless.

NUMBEROFPAGES: 4,605

MW code says: Simply count all entries in page table.

Iritscen says: What gives, MW? This number is higher than the total of files, articles, and talk pages, so what the heck is the software looking at? Totally unhelpful.

NUMBEROFARTICLES: 896

MW code says: From MW 1.18 on, the software gets a distinct count of the entries in the pagelinks table, "pl_from" field, that match those page ids. In other words, it filters out pages that do not link to other pages (the reasoning presumably being that "those aren't real wiki pages" if they're not connecting to anything else). Does this mean redirects are counted?

Iritscen says:

PAGESINNS, AKA PAGESINNAMESPACE: These counts agree with the number of pages displayed for each namespace on the Special:AllPages page, which provides some much-needed verifiability. However, since Allpages counts redirect pages, that means that PAGESINNS does too. Therefore, we can't use a straight sum of PAGESINNS results as our page count. See final section for the adjusted number.

PAGESINNS breakdown:

Namespace Media has ID -2, but we can't get a page count
Namespace Special has ID -1, but we can't get a page count
Namespace Main does not return an ID number, but apparently it's 0, because {{PAGESINNS:0}} returns 740 pages, which agrees with Special:AllPages
Namespace Talk has ID 1 and 113 pages
Namespace User has ID 2 and 122 pages
Namespace User talk has ID 3 and 51 pages
Namespace OniGalore has ID 4 and 15 pages
Namespace OniGalore talk has ID 5 and 2 pages
Namespace File has ID 6 and 2,637 pages
Namespace File talk has ID 7 and 17 pages
Namespace MediaWiki has ID 8 and 38 pages
Namespace MediaWiki talk has ID 9 and 0 pages
Namespace Template has ID 10 and 131 pages
Namespace Template talk has ID 11 and 6 pages
Namespace Help has ID 12 and 2 pages
Namespace Help talk has ID 13 and 2 pages
Namespace Category has ID 14 and 191 pages
Namespace Category talk has ID 15 and 6 pages
Namespace BSL has ID 100 and 64 pages
Namespace BSL talk has ID 101 and 6 pages
Namespace OBD has ID 102 and 191 pages
Namespace OBD talk has ID 103 and 36 pages
Namespace AE has ID 104 and 23 pages
Namespace AE talk has ID 105 and 15 pages
Namespace Oni2 has ID 108 and 37 pages
Namespace Oni2 talk has ID 109 and 18 pages
Namespace XML has ID 110 and 125 pages
Namespace XML talk has ID 111 and 17 pages

All articlespaces (without File) totalled using PAGESINNS: 1679

All talkspaces totalled using PAGESINNS: 272

The grand total for all namespaces (including File) is: 4605

Redirects

There were 305 redirects as of 3/18/13 according to Special:ListRedirects.

Redirect breakdown:

Main: 266
Talk: 0
Help: 1
Help talk: 1
File: 0
File talk: 0
AE: 5
AE talk: 1
BSL: 2
BSL talk: 0
OBD: 22
OBD talk: 0
OniGalore: 3
Oni2: 3
Oni2 talk: 1
User: 0
User talk: 0
XML: 0
XML talk: 0

Conclusion

NUMBEROFPAGES is worse than useless, and I cannot reconcile NUMBEROFARTICLES with PAGESINNS. On the other hand, PAGESINNS reconciles with AllPages, which makes it verifiable. So we need to get the true count by using PAGESINNS and subtracting redirects (which is unfortunate because the redirect part has to be counted manually).

Namespaces Main, User, BSL, OBD, XML, AE, and Oni2 totaled using PAGESINNS: 1302

True count (above total minus redirects in those namespaces): 1004

@@ Line 1: / Line 1: @@
-==Page count project==
+==Magic words==
-===Magic words===
 These first two poorly-documented magic words provide easy answers to the amount of content on the wiki. However, unless they are based on something logical that I haven't discovered yet, they are completely useless.
@@ Line 43: / Line 42: @@
 *Namespace '''{{ns:105}}''' has ID 105 and {{PAGESINNS:105}} pages
 *Namespace '''{{ns:108}}''' has ID 108 and {{PAGESINNS:108}} pages
-*Namespace '''{{ns:109}}''' has ID 109 and {{PAGESINNAMESPACE:109}} pages
+*Namespace '''{{ns:109}}''' has ID 109 and {{PAGESINNS:109}} pages
+*Namespace '''{{ns:110}}''' has ID 110 and {{PAGESINNS:110}} pages
+*Namespace '''{{ns:111}}''' has ID 111 and {{PAGESINNS:111}} pages
-'''All articlespaces''' (without File) totalled using PAGESINNS: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:4}}+{{PAGESINNS:8}}+{{PAGESINNS:10}}+{{PAGESINNS:12}}+{{PAGESINNS:14}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}}}
+'''All articlespaces''' (without File) totalled using PAGESINNS: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:4}}+{{PAGESINNS:8}}+{{PAGESINNS:10}}+{{PAGESINNS:12}}+{{PAGESINNS:14}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}+{{PAGESINNS:110}}}}
-'''All talkspaces''' totalled using PAGESINNS: {{#expr:{{PAGESINNS:1}}+{{PAGESINNS:3}}+{{PAGESINNS:5}}+{{PAGESINNS:9}}+{{PAGESINNS:11}}+{{PAGESINNS:13}}+{{PAGESINNS:15}}+{{PAGESINNS:101}}+{{PAGESINNS:103}}+{{PAGESINNS:105}}+{{PAGESINNS:109}}}}
+'''All talkspaces''' totalled using PAGESINNS: {{#expr:{{PAGESINNS:1}}+{{PAGESINNS:3}}+{{PAGESINNS:5}}+{{PAGESINNS:9}}+{{PAGESINNS:11}}+{{PAGESINNS:13}}+{{PAGESINNS:15}}+{{PAGESINNS:101}}+{{PAGESINNS:103}}+{{PAGESINNS:105}}+{{PAGESINNS:109}}+{{PAGESINNS:111}}}}
-The '''grand total''' for all namespaces (including File) is: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:1}}+{{PAGESINNS:2}}+{{PAGESINNS:3}}+{{PAGESINNS:4}}+{{PAGESINNS:5}}+{{formatnum:{{PAGESINNS:6}}|R}}+{{PAGESINNS:7}}+{{PAGESINNS:8}}+{{PAGESINNS:9}}+{{PAGESINNS:10}}+{{PAGESINNS:11}}+{{PAGESINNS:12}}+{{PAGESINNS:13}}+{{PAGESINNS:14}}+{{PAGESINNS:15}}+{{PAGESINNS:100}}+{{PAGESINNS:101}}+{{PAGESINNS:102}}+{{PAGESINNS:103}}+{{PAGESINNS:104}}+{{PAGESINNS:105}}+{{PAGESINNS:108}}+{{PAGESINNS:109}}}}
+The '''grand total''' for all namespaces (including File) is: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:1}}+{{PAGESINNS:2}}+{{PAGESINNS:3}}+{{PAGESINNS:4}}+{{PAGESINNS:5}}+{{formatnum:{{PAGESINNS:6}}|R}}+{{PAGESINNS:7}}+{{PAGESINNS:8}}+{{PAGESINNS:9}}+{{PAGESINNS:10}}+{{PAGESINNS:11}}+{{PAGESINNS:12}}+{{PAGESINNS:13}}+{{PAGESINNS:14}}+{{PAGESINNS:15}}+{{PAGESINNS:100}}+{{PAGESINNS:101}}+{{PAGESINNS:102}}+{{PAGESINNS:103}}+{{PAGESINNS:104}}+{{PAGESINNS:105}}+{{PAGESINNS:108}}+{{PAGESINNS:109}}+{{PAGESINNS:110}}+{{PAGESINNS:111}}}}
-===Redirects===
+==Redirects==
 There were 305 redirects as of 3/18/13 according to [[Special:ListRedirects]].
@@ Line 72: / Line 73: @@
 *User:        0
 *User talk:   0
+*XML:         0
+*XML talk:    0
-===Conclusion===
+==Conclusion==
 NUMBEROFPAGES is worse than useless, and I cannot reconcile NUMBEROFARTICLES with PAGESINNS. On the other hand, PAGESINNS reconciles with AllPages, which makes it verifiable. So we need to get the true count by using PAGESINNS and subtracting redirects (which is unfortunate because the redirect part has to be counted manually).
-Namespaces '''Main, User, BSL, OBD, AE, and Oni2''' totaled using PAGESINNS: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}}}
+Namespaces '''Main, User, BSL, OBD, XML, AE, and Oni2''' totaled using PAGESINNS: {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}+{{PAGESINNS:110}}}}
-'''''True count''''' (above total minus redirects in those namespaces): {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}-289-2-2-21-10-8}}
+'''''True count''''' (above total minus redirects in those namespaces): {{#expr:{{PAGESINNS:0}}+{{PAGESINNS:2}}+{{PAGESINNS:100}}+{{PAGESINNS:102}}+{{PAGESINNS:104}}+{{PAGESINNS:108}}+{{PAGESINNS:110}}-266-0-2-22-0-5-3}}

User:Iritscen/PageCountAudit: Difference between revisions

Revision as of 18:09, 18 March 2013

Magic words

Redirects

Conclusion

Navigation menu

Search