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

Comments

[theaeblackthorn.livejournal.com]

Cool, thank you! (also, I will totally reply to comments that I've got from you, I'm just trying to sort hih stuff out :) )

[alohachary1851.livejournal.com]

I'll take August, and lay off of my election drinking (or just do it very slowly as I do this.

[theaeblackthorn.livejournal.com]

lol, you can totally do it drunk, I did Oct half asleep. I jsut got hand cramp that slowed me after a while :)

[alohachary1851.livejournal.com]

LOL well, in that case i'll take July as well. I HAVE NOTHING ELSE TO DO TONIGHT.

[theaeblackthorn.livejournal.com]

lol, no fear if you can't finish one you can always give it up :)

[alohachary1851.livejournal.com]

excellent, my skills in EVERYTHING get better once drunk anyway ;)

[theaeblackthorn.livejournal.com]

lols, thus is the greatness of drinking thoughts :D

[clex_monkie89.livejournal.com]

I'll do February.

[theaeblackthorn.livejournal.com]

Thank you! I totes can't believe I actually executed a update commend whilst that asleep :(

[clex_monkie89.livejournal.com]

Aw, it's no problem! My only question, if your still up, is about the first activity on mine. Animagus: Batch 151-157. When I put that in the act_id thing nothing comes up, and when I put in Animagus that batch doesn't show.

[theaeblackthorn.livejournal.com]

an, it'll just be 'Batch 151-157' the file prints out the comm name with the activity name, should have probably changed that :)

[clex_monkie89.livejournal.com]

Ah, got it. Thank you!

[clex_monkie89.livejournal.com]

One more question, because iLose, you want us to skip the activities with no knuts, right? This isn't an all-inclusive chart, just knut only?

[theaeblackthorn.livejournal.com]

indeed, onyl activities where someone earnt knuts :)

[slyfoxesq.livejournal.com]

I'll take May and June if we're allowed to spit on two. XD (I need something to distract me from election nerves.) Does it matter that non-mods can't see the list of activity IDs? (Requires logging in)

[alohachary1851.livejournal.com]

ELECTION NERVES
-dry heaves-

[slyfoxesq.livejournal.com]

I think I possibly need to swear off ontd_political for the day, it's just making me freak out MORE. D: STOP GIVING ME CONFLICTING PREDICTIONS, NEWS. (Though I admit it was a small boost last night hearing Obama had won Dixville Notch and Hart's Location. XD GOGOBAMA.)

[alohachary1851.livejournal.com]

YES. WE DID

[slyfoxesq.livejournal.com]

AAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHHHHHH

[theaeblackthorn.livejournal.com]

It should be visible to anyone that's a member :) Anyone, even if they're not a mod, can use the site. It just has bugger all functionality for non-mods, that is something that's on the development list I can just never think what to add.

I did consider putting diagon on there, but we'll see. xx

[slyfoxesq.livejournal.com]

Head, meet desk. XD OKAY THEN I WILL GET RIGHT ON THIS. And not turn on the TV or think about elections until I am done. 8D

[theaeblackthorn.livejournal.com]

S'all good, s'all good :)

[darthsarah.livejournal.com]

I'll take March. I suppose I need something to do.
And we could use the points.
So we just look at all the usernames and how many KNUTS ONLY they have for that month?

[theaeblackthorn.livejournal.com]

Ah, no, it's for *each* activity how many knuts they had. So if someone earnt no knuts for an activity, then they don't need to be on the list.

I can put a .txt file up of october to give people an idea?

[darthsarah.livejournal.com]

Ok... so it's for each activity.
I'm sure I'll figure it out.

That's cool. I call March.

[theaeblackthorn.livejournal.com]

I just added an example to the post :)

[darthsarah.livejournal.com]

So do we send you the text file that we create?

[theaeblackthorn.livejournal.com]

Yeppers, just mail it over to sas.bratprincess at the site that is gmail.com.

[darthsarah.livejournal.com]

Coolio.
It shall be done tonight after work.

[slyfoxesq.livejournal.com]

Man the Slytherins are ALL OVER THIS.

Did we suddenly become helpful, or is it all brown-nosing? X)

[theaeblackthorn.livejournal.com]

lol, I would have guessed it's point-diving...

[darthsarah.livejournal.com]

Little of both.

The Gryffs jumped on them, too.
It's ON now. I feel bad, but I know there's no way we'll ever beat Ravenclaw, but I just want to beat the others soooooo bad. We're all like,
"*sniff*... I smell POINTS!"

[slyfoxesq.livejournal.com]

Whut! We're only 2300 points behind them. And we have people signed up for 1600 points worth of stuff we wouldn't otherwise have in the thing I just posted in the common room. X) WE CAN DO IT. We just have to beat them at everything. 8D

[rhye.livejournal.com]

I'll take whatever's left :)

Jan & April?

[theaeblackthorn.livejournal.com]

April or Jan?

Jan'll probably be the smaller month as April was the end of a term...

[theaeblackthorn.livejournal.com]

Cool cool, both are yours :)

[caketime.livejournal.com]

Crap, no Ravenclaws! :D

[theaeblackthorn.livejournal.com]

lol

[rhye.livejournal.com]

laaaaaaate :P

[caketime.livejournal.com]

Tee hee, DAMN MY TIME ZONE! <3

[darthsarah.livejournal.com]

... Come on... DO you really NEEEEED the points like we do?

;0P

[jademurasaki.livejournal.com]

LOL! I would have volunteered, but I didn't even see this until too late!

And yes, we can always use the points!

Who doesn't want points (actually I want my knuts personall...LOL as I finally wanted to buy a pet).

Hugs,
Jade//Owlie OvO

[theaeblackthorn.livejournal.com]

your knuts are totally safe, I've already fixed october knuts :)

everything else should already be in vaults.

[jademurasaki.livejournal.com]

Oh Hun, I was just joking around with Sarah :)

I'm sure you and all the volunteers have got things under control. I totally forgot you would get a copy of that post to Sarah.

If you need help though, the offer is still open!

Hugs,
Jade//Owlie OvO//Ravenclaw

[caketime.livejournal.com]

Hahaha, no! Too true! Hence the smiley. ;D

[jademurasaki.livejournal.com]

Thea, if someone can't do this or has to back out, let me know and I'll try to help out :) I've voted and I hate watching political stuff on TV or following stupid polls that constantly change anyway, they always do, it will end up as it ends up and thus I'm so not going to be glued to the TV tonight.

Jade//Ravenclaw

[theaeblackthorn.livejournal.com]

aye aye sas.bratprincess which is a gmail address, cool? x

[lotrangel17.livejournal.com]

If you need me to do anything let me know :) I'm terrible at coding stuff but if I can help with anything easy just give me a holler.