Bulbapedia talk:Top contributors of the month

From Bulbapedia, the community-driven Pokémon encyclopedia.
Jump to navigationJump to search

And...what is the importance of do so many edits? Haruka uzumaki 21:54, 5 October 2007

Cause these guys have contributed a lot. And that's good for Bulbapedia, so they deserve atleast one mention *nod nod* TinaTheKirlia ♥ 22:16, 5 October 2007 (UTC)

What the heck?! I made way over 1000 edits in September! Look at my contributions page! --Shiny NoctowlTalk|Contribs 12:11, 6 October 2007 (UTC)

Hey, sorry, I dídnt want to offend someone!--Haruka uzumaki 13:13, October 6 2007

Maybe only edits in the (Main)-namespace count... MewX 12:15, 6 October 2007 (UTC)
Absolutely the case. TTEchidna 20:00, 21 October 2007 (UTC)

Don't you think it's odd..

..that a vandal is listed for November 07? Tina δ 23:34, 2 December 2007 (UTC)

Yeah, that is wierd-ass. Maybe somebody out to tell Zhen about that. -ニョロトノ666
(And it's the sockpuppet that posed as the section creator.)
Zhen Lin might fix that. After all, Zhen Lin edited a statistic page when Bob, a vandal, made his way into Bulbapedia:Top Contributors in an update on January 8, 2006. On the other hand, we can still see this vandal sockpuppet's edits in their contributions, while Bob's are invisible...--Shiningpikablu252 23:41, 2 December 2007 (UTC)

aww man, and i thought i would make it this time...KPF 12:09, 2 February 2008 (UTC)


We've got no one with above 1000 EPM in the past two months. C'mon guys, edit something outside of your userspace! TTEchidna 09:12, 11 March 2008 (UTC)

-points out- Dude, you haven't exactly beaten BulbaBot...OptimatumTalk|09:17 11 Mar 2008
Ah, but I did. Then it took the title back. So I'm aiming to re-beat it. TTEchidna 09:32, 11 March 2008 (UTC)
You also have to do something about the...total contribs...OptimatumTalk|09:40 11 Mar 2008
Cool! I got the highest this month! --Theryguy512 11:06, 11 March 2008 (UTC)
Last month. OptimatumTalk|11:12 11 Mar 2008
Yea, that's what I meant. --Theryguy512 11:14, 11 March 2008 (UTC)
BTW, I never remembered you getting over 2000 in a month...which month was it? OptimatumTalk|11:16 11 Mar 2008
I never said I did. I don't have that tag on my page. --Theryguy512 19:17, 11 March 2008 (UTC)
Should BulbaBot really count as a user?? Origamiguy 19:24, 11 March 2008 (UTC)
Well though he isn't a user, he's a bot; we still count him. --Theryguy512 20:24, 11 March 2008 (UTC)
my goal of the month was to get in the top 10 (being i just missed it last month with 11th) looks like i did it! and then some.. MAGNEDETH 21:44, 11 March 2008 (UTC)

Umm in Feb, i made 134 edits, why am i not on there!? KPF 18:24, 12 March 2008 (UTC)

PLEASE CHANGE IT!! I COUNTED!!!!KPF 18:33, 12 March 2008 (UTC)

Dude, calm down. You probably just counted all your edits, while this is only about main-space edits. --Theryguy512 21:11, 12 March 2008 (UTC)

aaw man, talk pages dont count? sheesh...KPF 21:24, 12 March 2008 (UTC)

Yea, they don't count. That'll be kinda cheating if they did... --Theryguy512 21:29, 12 March 2008 (UTC)
do minor edits and redirects count? i guess a more straight to the point question would be, what counts? MAGNEDETH 22:14, 12 March 2008 (UTC)
No, minor and redirects don't count. On your contrib. page, their should be a button that says all. Next to that button is an arrow. Click on the arrow and select main to see the edits that DO count. --Theryguy512 00:05, 13 March 2008 (UTC)
Minor edits count, but redirects and talk pages don't. --PAK Man Talk 00:23, 13 March 2008 (UTC)
Really, minor edits count? I always thought they didn't...--Theryguy512 00:44, 13 March 2008 (UTC)
Me too. After all, I marked 99% of my mainspace edits minor. OptimatumTalk|05:38 13 Mar 2008
well, it at least explains why the 200 or so redirects i made didnt boost me higher. oh well, it isnt a race. (or is it?) MAGNEDETH 21:34, 13 March 2008 (UTC)
Selecting "Main" doesn't really show the ones that "do count"...redirects are shown. Porygon-Z 23:00, 13 March 2008 (UTC)

Do you see it?

Do you see it? It's so easy to get onto this list. That means that we're not contributing enough. What are you looking at me for? I can't edit! I'm in the middle of nowhere! Posted by the OptimatumTalk|Links12:42 4 May 2008

Considering I've made some 475 minor edits in 2 days, I'd say I'm doing my job. :) Glinn Mgraw 12:55, 4 May 2008 (UTC)
-sweatdrop- Oh well, Good night, bucko. Posted by the OptimatumTalk|Links13:01 4 May 2008
The minimum this month was 142. That's still quite a lot. --FabuVinny |Talk Page| 14:23, 4 May 2008 (UTC)
i cant beleive i had that many, i dont even remember doing much besides those damn move tables. -- MAGNEDETH 16:35, 4 May 2008 (UTC)
I can't believe I got on it either. Last month I was actually doing alot of stuff, but not alot this month. Porygon-Z 16:48, 4 May 2008 (UTC)

Well on PokéWiki we have months in which you get on our list with around 20 edits... o.O [Greets,mewX (TALK)] 12:41, 11 June 2008 (UTC)


When willthe august one be up? I really want to see it and I'm hopingI'm on it but i probably not.--Davidaipom 08:21, 1 September 2008 (UTC)

Well, now that's up, I'm wondering where the September one is, however, Zhen Lin is probably too stressed out. Just speculation. ht14 21:07, 5 October 2008 (UTC)
Poli said he was gonna do it. TTEchidna 21:19, 5 October 2008 (UTC)
Ugh. Yeah, I know I said I would *was hoping you guys would forget*. Alright, I'll take care of it right now. --ニョロトノ666 21:31, 5 October 2008 (UTC)
Actually, I just looked at it and other user info, and I have no idea how to go about this. See, for the Top contributors, the administration has a "special way" of counting edits, but I have no idea how Zhen managed this. Anybody know? --ニョロトノ666 21:38, 5 October 2008 (UTC)
When's Zhen Lin usually on? ht14 21:48, 5 October 2008 (UTC)
When he stepped down as editor-in-chief, it seemed to me that he indicated he wasn't ever going to be on anymore. We can probably contact him on the forums though. --((Marton imos)) 21:57, 5 October 2008 (UTC)
But didn't he give that position to TTE? That would mean TTE would be able to do it. Gligar 20:37, 9 October 2008 (UTC)
This actually requires a bit of math, unlike the other one, which is an autolist. TTEchidna 20:37, 9 October 2008 (UTC)
Frankly, it's not so much that TTE's able to do it and I'm not. I have the same range of access as he does to all the wiki functions (to my knowledge), but I just can't figure out how to do it. --ニョロトノ666 20:39, 9 October 2008 (UTC)
A possible way is to Copy and Paste to Word. Replace diff with another word, and see how many replacements occurred...that's how I figured mine...I got 429... ht14 03:11, 10 October 2008 (UTC)

I'm sorry, I wasn't being specific. If using Microsoft, Ctrl+F, then go to Replace. That's what I mean. ht14 03:12, 10 October 2008 (UTC)


Since when has this become an "add yourself by your own count" page? This should be protected, and someone needs to figure out how Zhen did it. --electAbuzzzz 18:15, 13 October 2008 (UTC)

Right....sorry...honesty thing... ht14 18:17, 13 October 2008 (UTC)
True. Jmath actually only made 855. I counted. Others may be wrong as well, since some are counting their userspaces... ht14 18:18, 13 October 2008 (UTC)
Baby G had himself there for 800+ edits I believe. He counted ones besides mainspace, and I told him. He fixed it without argument, luckily. I counted Deth's myself since if you watched recent changes it wouldn't be too hard to tell he made it if you are a recent changes watcher. I know how Zhen did it...kinda. If he'd teach me fully, I'd do it... Porygon-Z 18:21, 13 October 2008 (UTC)
Even checking every number, the "add it yourself" method is not ideal as it could still be missing contributors. This page does need to be protected but I'll leave it as it is until we get Zhen's method. --FabuVinny |Talk Page| 20:45, 13 October 2008 (UTC)

Zhen Lin had a PHP script on the server which counted the edits (automatically) right from the database. (He sent it to me some time ago.) Some admin with server access should run the script. I think it should be pretty simple ;) --[Greets, mewX (TALK)] 11:01, 28 October 2008 (UTC)

Someone really needs to complete this

It's November now and we don't have of all September finished. If you look at an above post, someone said that Zhen used a special server script that only admins can use. So, an admin really needs to use said script and complete the listings. Chocolate 00:06, 4 November 2008 (UTC)

Try pestering TTEchidna into pestering MewX into sharing a copy of the script. There was some sharing of resources between the latter (the head of our German affiliate) and Zhen Lin, including the script in question. --Shiningpikablu252 00:21, 4 November 2008 (UTC)

*coughs* Glinn Mgraw 03:14, 19 November 2008 (UTC)

SERIOUSLY GUYS!--RexRacer -talk 03:21, 19 November 2008 (UTC)
Well, guess what. Zhen Lin is the only person who ever knew how to do this...and he hasn't been on any part of Bulbagarden for a month and a half. I e-mailed him today to try to find out how to finish this, but he hasn't answered back yet. MaverickNate 03:29, 19 November 2008 (UTC)
You might want to take a peek at the last comment in the section above this one. Glinn Mgraw 03:37, 19 November 2008 (UTC)
That script is only for the Top contributors page, not the top contributors of the month page. Don't you think we would have done that already? MaverickNate 03:58, 19 November 2008 (UTC)
Wouldn't you just take away Total before the month from total after the month to get a total for a month? Glinn Mgraw 04:04, 19 November 2008 (UTC)
Well, do you happen to have the totals for October, September and August? ...I didn't think so. There is something else that is used, not the script that is being talked about, but something different, and both evkl and Pie told me to go to Zhen Lin, and he hasn't responded. MaverickNate 04:07, 19 November 2008 (UTC)
Plus, that wouldn't take into account maybe a new user who made it on the list in October, but wasn't even a user in September. Using your way wouldn't work. There is a different tool that is used that Zhen knows about, but he won't respnd. MaverickNate 04:09, 19 November 2008 (UTC)
Did I say anything about having the totals for August, September and October? No. I was merely asking a question of whether it could be done, and all you had to say was "No." and give a short explanation why. Glinn Mgraw 04:15, 19 November 2008 (UTC)
He's got no access to any computer with which to check his email. TTEchidna 04:11, 19 November 2008 (UTC)
T_T Then where is he? Hanging out w/ electAbuzz?--RexRacer -talk 04:12, 19 November 2008 (UTC)
I think everyone should post their total edits on a specific pages then we can ranked it using Excel! Yeah, I know this is a bad idea but what could we do to complete the list?-Billy4b2004 07:27, 17 December 2008 (UTC)

Well as far as I can see the script Zhen gave me should be able to get edit counts for specific time ranges. Just define a $starttime and an $endtime.
I think it should be no problem to post the script here... ;) It should anyway work on every wiki.

header('Content-Type: text/html; charset=utf-8');
$db = mysql_connect('localhost', ' username ', ' password');

mysql_select_db(' database ');

if (!$db)
	trigger_error('MySQL error #' . mysql_errno() . ': ' . mysql_error(), E_USER_ERROR);

mysql_query("SET NAMES 'utf8'");

function requestVar($name, $default = '')
	if (isset($_GET[$name]))
		return $_GET[$name];
	if (isset($_POST[$name]))
		return $_POST[$name];
	return $default;

$starttime = requestVar('starttime', '00000000000000');

// HINT: set here, for example: requestVar('starttime', mktime  (0,0,0, $month, 1, 2008) );

$endtime = requestVar('endtime', '99999999999999');
$limit = requestVar('limit', 100);

$query = 'SELECT COUNT(*) AS x
FROM page
LEFT JOIN revision ON rev_page = page_id
LEFT JOIN user ON rev_user = user_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_timestamp >= ' . "'${starttime}'" . '
AND rev_timestamp <= ' . "'${endtime}'";

$result = mysql_query($query);
$row = mysql_fetch_row($result);
$totaledits = $row[0];

print '<p>There have been ' . number_format($totaledits) . ' edits to the main namespace, excluding the pages which are currently redirects.</p>';


$query = 'SELECT COUNT(*) AS x, user_name
FROM page
LEFT JOIN revision ON rev_page = page_id
LEFT JOIN user ON rev_user = user_id
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_timestamp >= ' . "'${starttime}'" . '
AND rev_timestamp <= ' . "'${endtime}'" . '
GROUP BY user_id
ORDER BY x DESC, user_id ASC';

if ($limit > 0)
	$query .= ' LIMIT 0, ' . $limit;

$result = mysql_query($query);

$topeditlist = array();

while ($row = mysql_fetch_row($result))
	$topeditlist[] = array($row[1], intval($row[0]));

$cumulative = 0.0;

if ($topeditlist[0][0] == 'BulbaBot')
	echo '<ol start="0">';
	echo '<ol>';
foreach($topeditlist as $data)
	$user = $data[0];
	$user1 = htmlspecialchars(urlencode(str_replace(' ', '_', $user)));
	$count = $data[1];
	$fraction = floatval($count) / $totaledits;
	$cumulative += $fraction;
	echo '<li>';
	echo '<a href="http://bulbapedia.bulbagarden.net/wiki/User:' . $user1 .'">';
	echo $user;
	echo '</a> has made ';
	echo '<a href="http://bulbapedia.bulbagarden.net/w/index.php?title=Special:Contributions&target=' . $user1 .'">';
	echo $count;
	if ($count == 1)
		echo ' edit</a>. <small>(';
		echo ' edits</a>. <small>(';
	echo round($fraction, 3) * 100.0;
	echo '%, ';
	echo round($cumulative, 3) * 100.0;
	echo '% cumulative)</small></li>';
	echo "\n";
echo '</ol>';

$cutoff = 21;

echo '<pre>';
foreach($topeditlist as $data)
	$user = $data[0];
	$count = $data[1];

	if ($cutoff == 0)
	if ($count < $minedits)
	echo '# ';
	echo '{{u|' . $user . '}}';
	echo ' <small>(';
	echo $count;
	if ($count == 1)
		echo ' Edit';
		echo ' Edits';
	echo ")</small>\n";


For example, set the times like this:

$starttime = mktime (0,0,0, 8, 1, 2008) ; // from 8 = august, 1st, 0:00:00
$endtime = mktime (0,0,0, 9, 1, 2008) ; // to 9 = september, 1st, 0:00:00

I have not tested this, but I guess it should work. - [Greets, mewX (TALK)] 21:19, 29 December 2008 (UTC)

...and of course, remember to fill in the database data after copying it from here :P (it wasn't mentioned anywhere IMO) UltimateSephiroth (about me · chat · edits) 21:21, 29 December 2008 (UTC)
So, how exactly would one use the script? Chocolate (Chat with Me) 21:48, 29 December 2008 (UTC)
It's PHP, so it'd work by creating a new file on the server with that content. Then one would just need to open that file in the browser. UltimateSephiroth (about me · chat · edits) 21:52, 29 December 2008 (UTC)
Either that, or someone with the MySQL data to remotely login to the sql.. if it takes remote. Gywall Talk 21:53, 29 December 2008 (UTC)


Top contributors goes back to January, 2005 (when Bulbapedia had just started). Should we go back and do TCOTM for the months that are there but not here? I mean, sure... 2006 allows people with single-digit edit counts on... but... eh? TTEchidna 19:27, 8 March 2009 (UTC)

I think that we should, its only fair. (Wow...I was on hiatus for like a year, but for all the time I was gone, my name was still on the TC.) --Theryguy512 19:34, 8 March 2009 (UTC)

How do I know how many contributions I've made?

When I go on my contributions list, all I see is the list of contrubutions with nothing telling me how many I've made so far or in a certain month. Am I missing something obvious? If not, how do I found out my contribution count? It's just I feel I'm making a lot of edits, especially to pages about Glitches, and I want to know how many I'll need to get onto top contributors of the month page.Dusknoir477 12:30, 15 March 2009 (UTC)

Well...only certain admins (if not, all) can see them. ht14 19:46, 15 March 2009 (UTC)
Apart from using a specially developed script (sections of which you can see above), the only real way is counting. I trust you can do that :D — THE TROM — 20:20, 15 March 2009 (UTC)
Only those strictly from the mainspace, and not from talkpages... ht14 21:18, 15 March 2009 (UTC)

Shipping articles

Do shipping article edits count, because it is not mentioned that they don't on the article.--Smartkidhen 16:33, 18 January 2010 (UTC)

No, they do not count. Only articles in the mainspace (articles without prefixes) count. - Kogoro | Talk to me - 16:36, 18 January 2010 (UTC)


Why does 2009 June appear on a separate column than all other months? It is deliberate, accidental, or just my computer? Turtwig A (talk | contribs) 21:09, 2 February 2010 (UTC)

Users with longer names cause issues with the way it's currently set up. Does this happen to look better? - Kogoro | Talk to me - 21:12, 2 February 2010 (UTC)
*guilty* Why, yes it does Kogsie. —darklordtrom 21:23, 2 February 2010 (UTC)


Maybe we should note that we have 21 parts instead of 20 because one of them will always have BulbaBot in it. TorchicBlaziken (talkedits) 20:19, 17 January 2011 (UTC)

if Botty is beaten, it will show 21 users. if he isnt, then it will show the first human as #1. look at May vs. April. -- MAGNEDETH 21:53, 17 January 2011 (UTC)

Appendix namespaces

don't count? --☆YoshisWorld☆ 00:30, 4 September 2011 (UTC)

Nope, just mainspace articles do with no prefix. --P S Yライダー 00:39, 4 September 2011 (UTC)

German Interwiki

Exactly this Interwiki is wrong or rather outdatet. The new InterWiki is: de:PokéWiki:Top-Benutzer des Monats Empoleon96Talk 01:33, 1 November 2011 (UTC)

Done. ♫♪エイディニズ♪♫ 01:43, 1 November 2011 (UTC)

First time

I've been on a top contributors list. Nice. :) Frozen Fennec 00:19, 1 March 2012 (UTC)


Beaten for first by the person who updates the list. Is there a usertag applicable for 2nd place? --Abcboy (talk) 01:06, 1 November 2012 (UTC)

Template:User TCM. --Pokemaster97 01:11, 1 November 2012 (UTC)
Thanks! --Abcboy (talk) 01:12, 1 November 2012 (UTC)


Checked the page out of interest, saw that I was Number 3 for September which wasn't bad. Really enjoy contributing to Bulbapedia, long may it continue.--BigDocFan (talk) 16:58, 8 January 2018 (UTC)

Congrats! :D Here's to another great month and a great year! --Raltseye prata med mej 17:11, 8 January 2018 (UTC)


Is this page going to update ever again? sumwun (talk, contribs) 22:40, 1 June 2019 (UTC)

Dunno, ask Kogoro if you want to know, she's the one that used to update these. --Raltseye prata med mej 23:40, 1 June 2019 (UTC)
Don't take my word for it, but I'm almost certain that it's not going to be updated any time soon. A notice at the top of the page explaining that would be nice, though. Dannyboy601 (talk) 01:04, 2 June 2019 (UTC)
Agreed. --Raltseye prata med mej 02:55, 2 June 2019 (UTC)
Who can I ask if Kogoro seems to be inactive? sumwun (talk, contribs) 14:40, 2 June 2019 (UTC)
Any active member of staff, I suppose. Check the recent changes to see who's actually made edits recently. That, or go to the Bulbawiki forum (though I don't know how active it is). Dannyboy601 (talk) 00:36, 5 June 2019 (UTC)