Physical Representation Of A Virtual Occurrence by Sean Mahan, qwerty uiop
November 3rd, 2005 11:06 PM / Location: 37.77387,-122.4318
We set up a light to turn on whenever players submit proof of a completed task. In fact, the light is on...right now!When we approve the proof, the light turns off again.
The light originally comes from ikea. We found it on the street on a table with a bunch of other stuff. it looked like someone had made a lot of impulse ikea purchases and then had a change of heart and threw everything out. we got some convex mirrors too.
anyway, putting up the thing was pretty easy, just drilled some holes in the wall. for some reason, the power drill wasn't working so well, so we used a regular screw driver.
I approved the task, and now the light is off again.
18 vote(s)
SNORLAX
5
YellowBear
5
Blue
5
The Villain
5
Lincøln
5
susy derkins
5
Jellybean of Thark
5
Bex.
5
Twenty Four
5
Vee
5
Augustus deCorbeau
5
Adam
5
GYØ Ben
5
zer0gee
5
anna one
5
Spidere
3
Mr Everyday
5
Dela Dejavoo
Favorite of:
Terms
everyoneshouldsee6 comment(s)
< ?php
$c = mysql_connect([the server], [the user], [the password]);
$d =mysql_select_db([the database],$c);
$thepending=mysql_query("SELECT [the field] FROM [the table] WHERE [the field]=1",$c);
$counter=mysql_num_rows($thepending);
mysql_close($c);
if ($counter>0){
echo 'yes';
}
else {
echo 'no';
}
? >
How it works
A script runs every x minutes (currently, x=1) on a computer at our apartment, which checks a url that spits out either "yes" or "no". That answer comes from a script that checks the SF0 database to see if there are any tasks that are completed, but haven't yet been approved. The local computer runs a command line utility called Bottle Rocket ("br"), which is so named because it controls the FireCracker [Warning: hideous website] serial X-10 interface. Depending on whether it got a "yes" or a "now", it sends either the "on" or "off" command (respectively) to a box sitting between our an outlet and our light.
And don't give me shit about the FireCracker kit ostensibly costing $39.99. I picked it up for $6 (well, "free" + S&H) a couple years ago, when x10.com occasionally ran such a promotion. It didn't succeed in spurring me to buy an entire smarthome's worth of x10 gear, but it did end up being perfectly suited to this task...
I fucking love you guys…
If there were more like you on SFØ there would be a lot better tasks coming out of equivalenz.
Ya'll make being nerds look so fucking cool…
We should make SFØ the møvie!
P.S. How dare you spend $39.99 on firecracker… sheesh!
*Sarcasm triggered light illuminates*
Umm... is SFØ the movie still on track?
Also, no one told me bout the light. I have basked in its glow, ignorant but pleased.
Actually, the best part of going to your place was seeing that light on. I totally geeked out. It was like meeting a celebrity for the first time after only knowing them on screen. The first hour or so of that party I was totally out of it. And it had a lot to do with that light right there. I mean sure, I met p00n and Dax and Ms. Envy and Zemaluco and Sh'laco and Eddy and JTony and everybody else, but this light made me all giddy.
#!/usr/bin/php -q
< ?php
$anypending=fopen('[whatever url]',r);
while (!feof($anypending)){
$buffer = fgets($anypending, 30);
$any = $buffer;
}
fclose($anypending);
if ($any=='yes'){
$yadda= popen("br -c A -n 1",r);
}
else if ($any=='no'){
$yadda= popen("br -c A -f 1",r);
}
? >