900 points up for grabs!!

[theaeblackthorn.livejournal.com]

So. Sas made a massive hash up last night as some of you may know. And now I need people to help me fix it.

I accidentally deleted all of the knuts on the system. These can be restored through a silly amount of hard work.

This is what I need.

Using the past point sheets I need people to compile a list of usernames, knuts and activity id's.
So, you'd open up the points sheet for the month, scroll through and make a list of:

knuts : username : act_id

1. Select a month, tell me which one, and work through each activity making a list of username, knuts.

January: http://hih.leaky-sponge.com/points/2008-01-01-2008-02-01.php
February: http://hih.leaky-sponge.com/points/2008-02-01-2008-03-01.php
March: http://hih.leaky-sponge.com/points/2008-03-01-2008-03-31.php
April: http://hih.leaky-sponge.com/points/2008-04-01-2008-04-30.php
May: http://hih.leaky-sponge.com/points/2008-05-01-2008-05-31.php
June: http://hih.leaky-sponge.com/points/2008-06-01-2008-06-30.php
July: http://hih.leaky-sponge.com/points/2008-07-01-2008-07-31.php
August: http://hih.leaky-sponge.com/points/2008-08-01-2008-08-31.php
September: http://hih.leaky-sponge.com/points/2008-09-01-2008-09-30.php

ALL GONE!

2. Then using a page I've made that displays activity id based on activity names for each activity list the activity ID next to EACH persons name & knuts that participated.

Find Act ID: http://hih.leaky-sponge.com/act_id.php

It should look like this when you're done:

So, for example for one of the October activities it looked like this:

59	amaelgreenleaf	1004
5	niicole_m	1004
21	pack1ife	1004
17	planetgal471	1004
7	themarisa	1004
7	crazychic3	1004
23	lost_in_dreamz_	1004
15	shann	1004
15	stellazeee	1004
7	tiger_flame	1004
13	cookie_pixie	1004
133	emeryboard	1004
5	et_tu_lj	1004
5	gluedupsidedown	1004
9	keakealani 	1004
27	musikurt	1004
11	sanggre_habagat	1004
147	absolutelybatty 	1004
17	abusing_sarcasm	1004
23	slyferret	1004

I'm give 100 points for each month a person does. There is no limit to how many each member can do, but I want these done within a 3 days. It's about 2 hours work for a month if you're quick enough.

So, comment here and pick a month and then get to it :) Any questions feel free to ask.

- sas x




ETA: EXAMPLE FILE: http://hih.leaky-sponge.com/october-example.txt