February 2010 - skunkworks - Skunkworks Site

Chile and Haiti: A Tale of Two Earthquakes
by aki 28 Feb '10

28 Feb '10

This is from Time : http://www.time.com/time/world/article/0,8599,1968576,00.html?xid=rss-topst… The 8.8-magnitude earthquake that hit Chile early on Feb. 27 was 500 times stronger than the 7.0 quake that killed an estimated 200,000 Haitians last month. And yet the number of casualties in Chile appears to be exponentially smaller, with the official death toll still in the hundreds. Far fewer people were rendered homeless than in Haiti, and much of the telephone service in Santiago and parts of central Chile had been restored within five hours. Comparisons between the two countries will no doubt be much discussed when the U.N. hosts a conference in New York City on March 31 to hash out how best to help Haiti rebuild. Donor governments already know why there was so much less destruction in Chile: it's because the government there forces builders to adhere to rigorous codes, while Haiti's incorrigible corruption and carelessness left such regulation all but non-existent. On the global corruption index put out by Transparency International, a Berlin-based nonprofit that lists countries from the least to most corrupt, Chile ranks 25th and Haiti 168th. And while Chilean President Michelle Bachelet hit the streets on Saturday reassuring citizens about her government's earthquake response, Haitian President Rene Preval has been seemingly AWOL for weeks.

3 4

Some scripting help needed
by Tony Likhanga 28 Feb '10

28 Feb '10

Hi folks, I have tonnes of CSV files whose sample content is as shown below: Choice|*123456780*|20|1|*YES*|Y|2010-02-26 10:42:51.239772| Choice|*123456781*|10|1|NO|Y|2010-02-26 12:42:51.243603| Choice|*123456782*|20|1|NA|Y|2010-02-26 14:42:51.247464| Choice|*123456783*|10|1|*YES*|Y|2010-02-26 14:42:51.251320| Choice|*123456780*|20|1|OK|Y|2010-02-26 15:42:51.255169| My aim is to extract the contents of the 2nd field alongside the count of similar choice result in 5th field. Desired output: UserId Occurences (*YES*) ====== =============== 123456780 465 123456781 25 I managed to achieve this on a linux box running mysql using the steps below (which can of course be wrapped into a script): 1. grep YES *raw_files* | awk 'BEGIN{FS=OFS="|"}{print $2}' > /tmp/in_file 2. Log in to mysql and perform the steps: 3. mysql> create table nums(num varchar(16)); 4. mysql> load data infile '/tmp/in_file' into table nums(num); 5. mysql> select num,count(*) thecnt from nums group by num; I'm still exploring how to achieve the same using some (simple?) script, possibly not involving the database bit. Any takers? NB: The only bit we know before-hand is desired choice result (YES/NO/NA). Thanks. Tony.

3 5

<ADVERT> ZTE 1X MG880 CDMA MODEM FOR SALE</ADVERT>
by Dennis Kioko 28 Feb '10

28 Feb '10

image: [image: mg880.jpg] Price Kenya Shillings: 1999/- contact me offlist. -- with Regards: Road Safety Begins with You: Do not share seats in the matatu , report & resist bad driving. Together we can make a big change

1 0

Re: [Skunkworks] Scholarships
by Barrack Otieno 28 Feb '10

28 Feb '10

Hello Skunks just in case you are interested http://www.utwente.nl/internationalstudents/news/deadlinesapproaching/ Blessings On Sat, Feb 27, 2010 at 12:23 AM, Eva Kimathi <evakimathi(a)gmail.com> wrote: > Tet's just say they blinked!?? > > On Fri, Feb 26, 2010 at 11:28 PM, Haggai Nyang <haggai.nyang(a)gmail.com> > wrote: >> >> Maybe I should take that back...but I swear I saw the database was >> offline... >> >> On Fri, Feb 26, 2010 at 11:26 PM, Haggai Nyang <haggai.nyang(a)gmail.com> >> wrote: >>> >>> Seems events in the offline world have spilled to the online side... >>> >>> http://www.kenya.go.ke/ >>> >>> Who are these site admins sleeping on the job? >> >> >> _______________________________________________ >> Skunkworks mailing list >> Skunkworks(a)lists.my.co.ke >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks >> ------------ >> Skunkworks Server donations spreadsheet >> >> http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1… >> ------------ >> Skunkworks Rules >> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 >> ------------ >> Other services @ http://my.co.ke >> Other lists >> ------------- >> Announce: >> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce >> Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science >> kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general > > > _______________________________________________ > Skunkworks mailing list > Skunkworks(a)lists.my.co.ke > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > Skunkworks Server donations spreadsheet > http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1… > ------------ > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke > Other lists > ------------- > Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce > Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science > kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general > -- Barrack O. Otieno Administrative Manager Afriregister Ltd (Ke) P.o.Box 21682 Nairobi 00100 Tel: +254721325277 +254733206359 +254202498789 Riara Road, Bamboo Lane www.afriregister.com www.afriregister.co.ke ICANN accredited registrar. Skype: barrack.otieno

1 0

Fiber optic cables and outsourcing
by justus 27 Feb '10

27 Feb '10

are these seacom cables really of high speed as it was speculated,and which are the chances of kenya becoming an outsourcing centre upon the deployment.

1 0

decoding - encoding
by pithon kamau 27 Feb '10

27 Feb '10

Hi, i am trying to edit a wordpress footer .php but its in the foremat shown below. how can i encode it? <?php eval(base64_decode('Pz4gICA8ZGl2IHN0eWxlPSJ2aXNpYmlsaXR5OmhpZGRlbjsgY2xlYXI6Ym90aCI+IDwvZGl2Pg0KDQo8L2Rpdj4NCg0KPGRpdiBpZD0iZm9vdGVyIj4NCg0KICA8ZGl2IGlkPSJmb290ZXJfYmciPjwvZGl2Pg0KDQogIDxkaXYgY2xhc3M9ImZvb3Rlci1yZWNlbnQtcG9zdHMiPg0KDQogICAgPGg0PlJlY2VudCBQb3N0cyA8L2g0Pg0KDQogICAgPHVsPg0KDQo8P3BocCB3cF9nZXRfYXJjaGl2ZXMoJ3RpdGxlX2xpPSZ0eXBlPXBvc3RieXBvc3QmbGltaXQ9NScpOyA/Pg0KDQogICAgPC91bD4NCg0KICA8L2Rpdj4NCg0KICA8ZGl2IGNsYXNzPSJmb290ZXItcmVjZW50LWNvbW1lbnRzIj4NCg0KICAgIDxoND5SZWNlbnQgQ29tbWVudHMgPC9oND4NCg0KICAgIDx1bD4NCg0KPD9waHAgaWYgKGZ1bmN0aW9uX2V4aXN0cygnbWR2X3JlY2VudF9jb21tZW50cycpKSB7IG1kdl9yZWNlbnRfY29tbWVudHMoNSk7IH0gPz4NCg0KICAgIDwvdWw+DQoNCiAgPC9kaXY+DQoNCiAgPGRpdiBjbGFzcz0iZm9vdGVyLWFib3V0Ij4NCg0KICAgIDxoND5BYm91dCBNZTwvaDQ+DQoNCiAgICA8cD5XZWxsLCBJIGFtIGEgdGVtcGxhdGUsIGxpdmluZyBpbiB0aGUgcmVhbG1zIG9mIExpcXVpZCBEZXNpZ24sIG9yIHdob2V2ZXIgY2hvb3NlcyB0byBob3N0IG15IGRlc2lnbiA8L3A+DQoNCiAgPC9kaXY+DQoNCiAgPGhyIGNsYXNzPSJjbGVhciIgLz4NCg0KPC9kaXY+DQoNCjxkaXYgaWQ9ImNyZWRpdHMiPg0KDQogIDxkaXYgY2xhc3M9ImFsaWdubGVmdCI+PD9waHAgaWYoaXNfaG9tZSgpKSA6ID8+PGEgaHJlZj0iaHR0cDovL3d3dy5kaWV0LXBpbGxzLWV4cHJlc3MuY29tLyIgdGl0bGU9IldlaWdodCBsb3NzIj5XZWlnaHQgbG9zczwvYT48P3BocCBlbmRpZjsgPz4gICA8L2Rpdj4NCg0KICANCg0KPC9kaXY+DQoNCjw/cGhwIHdwX2Zvb3RlcigpOyA/Pg0KDQo8L2JvZHk+DQoNCjwvaHRtbD4NCg0KIDw/'));?> Please Help -- Pithon K. Kamau Mobile: 0723 588705 / 0737 686562 Tel: +254 20 8083989 Website: www.heartbitsolutions.com / www.yesiamablogger.com / www.pithonkamau.com Website Design, Domain Registration, Website Hosting, Corporate Email Solutions, Website Maintainance, Website Marketing, Logo Design and Branding, Bulk SMS Solutions, Computer Hardware and Maintainance, Network Design and Set Up............. "Love Your Neighbour as You Love Yourself"

7 8

M-pesa Account
by Kevin Ouma 27 Feb '10

27 Feb '10

Does anyone know the process of registering an M-Pesa/ ZAP account or a business. Please let me know. Kevin

2 3

(no subject)
by nancy muito 27 Feb '10

27 Feb '10

I am a lady JKUAT Diploma holder in IT looking for a internship from any organisation within Nairobi because i am a part time student pursuing a degree in IT(JKUAT) program at Inoorero University Parklands.Here are my contacts,Email nankirigz@yahoo.com:Phone no.0722210408

1 0

Government of Kenya - Offline
by Haggai Nyang 27 Feb '10

27 Feb '10

Seems events in the offline world have spilled to the online side... http://www.kenya.go.ke/ Who are these site admins sleeping on the job?

2 2

Re: [Skunkworks] Blackberry Unlocking
by tonniemacharia＠gmail.com 26 Feb '10

26 Feb '10

Did any one get help from this website in regards to the topic? --- Original Message --- From: "Dennis Kioko" <dmbuvi+skunkworks(a)gmail.com> Sent: 2010/2/17 10:47:45.000 To: "Skunkworks Forum" <skunkworks(a)lists.my.co.ke> Subj: Re: [Skunkworks] Blackberry Unlocking try forum.gsmhosting.com

3 2