Bulbapedia talk:Top contributors of the month

And...what is the importance of do so many edits? Haruka uzumaki File:Ani038MS.gif 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 ♥ File:281MS.gif 22:16, 5 October 2007 (UTC)

What the heck?! I made way over 1000 edits in September! Look at my contributions page! --Shiny Noctowl^{Talk|Contribs}File:Ani164MS.gif 12:11, 6 October 2007 (UTC)

Hey, sorry, I dídnt want to offend someone!--Haruka uzumaki File:Ani038MS.gif 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. -File:Spr 3e 186.gifニョロトノ666File:Spr 3e 186.gif

(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...KPF30px 30px 12:09, 2 February 2008 (UTC)

Hmm...

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

-points out- Dude, you haven't exactly beaten BulbaBot...Optimatum^Talk|♊09:17 11 Mar 2008

Ah, but I did. Then it took the title back. So I'm aiming to re-beat it. TTEchidnaFire echy 09:32, 11 March 2008 (UTC)

You also have to do something about the...total contribs...Optimatum^Talk|♊09:40 11 Mar 2008

Cool! I got the highest this month! --Theryguy512 11:06, 11 March 2008 (UTC)

Last month. Optimatum^Talk|♊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? Optimatum^Talk|♊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!? KPF30px 30px 18:24, 12 March 2008 (UTC)

PLEASE CHANGE IT!! I COUNTED!!!!KPF30px 30px 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...KPF30px 30px 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. Optimatum^Talk|♊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 Optimatum^Talk|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 Optimatum^Talk|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, (TALK)] 12:41, 11 June 2008 (UTC)

August

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)

Huh...?

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. ^Maverick_Nate 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? ^Maverick_Nate 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. ^Maverick_Nate 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. ^Maverick_Nate 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.

<?php
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>';

flush();

$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">';
else
	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>(';
	else
		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)
		break;
	$cutoff--;
	if ($count < $minedits)
		break;
	echo '# ';
	echo '{{u|' . $user . '}}';
	echo ' <small>(';
	echo $count;
	if ($count == 1)
		echo ' Edit';
	else
		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)