dkobia’s gists

dkobia / gist:624677

Created October 13, 2010 19:15

	<?php
	function update_translations($lang,$file,$translations){
	global $USERID;

	foreach($translations as $key => $string){

	// First find out if we need to do an update.
	// This helps us create a history entry if there's a change
	$query = 'SELECT `'.mysql_escape_string($lang).'` FROM `base` WHERE CONVERT( `file` USING utf8 ) = \''.mysql_escape_string($file).'\' AND CONVERT( `key` USING utf8 ) = \''.mysql_escape_string($key).'\' LIMIT 1';
	$result = mysql_query($query);

dkobia / gist:635437

Created October 19, 2010 23:47

SELECT COUNT(id) as count FROM incident WHERE incident_active=1 AND id IN (7,16,45,48,75,149,161,249,290,458,563,631,681,739,751,805,840,880,903,906,916,987,994,1045,1048,1054,1065,1074,1083,1102,1108,1199,1238,1282,1298,1337,1380,1421,1478,1573,1579,1586,1603,1618,1621,1633,1646,1738,1761,1781,1805,1819,1830,1876,1902,1932,1963,1975,1999,2017,2045,2050,2051,2062,2075,2081,2117,2120,2125,2130,2137,2153,2172,2181,2191,2202,2207,2208,2220,2232,2259,2277,2296,2302,2319,2326,2333,2334,2336,2344,2345,2346,2350,2362,2374,2389,2394,2404,2409,2413,2414,2427,2437,2445,2447,2448,2453,2467,2470,2471,2473,2482,2488,2489,2492,2514,2534,2539,2540,2543,2549,2561,2564,2565,2571,2574,2575,2579,2580,2585,2586,2616,2617,2628,2647,2655,2659,2676,2690,2697,2699,2704,2707,2708,2709,2711,2718,2723,2731,2745,2755,2763,2764,2768,2772,2775,2779,2780,2785,2787,2797,2802,2806,2811,2812,2819,2821,2826,2830,2834,2840,2843,2853,2855,2858,2863,2867,2878,2885,2886,2897,2901,2904,2908,2911,2925,2931,2972,2982,2997,3008,3013,3019,3030,3034,305

dkobia / gist:640970

Created October 22, 2010 17:12

	<?php

	private function _get_release_version()
	{
	// From version.ushahidi.com/2/
	$release_version = $this->release->version;

	$release_version

	$version_ushahidi = Kohana::config('settings.ushahidi_version');

dkobia / gist:641155

Created October 22, 2010 18:55

	<?php

	function _fetch_core_release()
	{
	// Current Version
	$current = urlencode(Kohana::config('settings.ushahidi_version'));

	// Extra Stats
	$url = urlencode(preg_replace("/^https?:\/\/(.+)$/i","\\1", url::base()));
	$ip_address = (isset($_SERVER['REMOTE_ADDR'])) ? urlencode($_SERVER['REMOTE_ADDR']) : "";

dkobia / gist:647981

Created October 26, 2010 22:33

	2010-10-26 18:32:48.143 Ushahidi_iPhone[31865:207] -[TextTableCell getImage]: unrecognized selector sent to instance 0x79686b0
	2010-10-26 18:32:48.144 Ushahidi_iPhone[31865:207] *** Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[TextTableCell getImage]: unrecognized selector sent to instance 0x79686b0'
	*** Call stack at first throw:
	(
	0 CoreFoundation 0x02782919 __exceptionPreprocess + 185
	1 libobjc.A.dylib 0x02b425de objc_exception_throw + 47
	2 CoreFoundation 0x0278442b -[NSObject(NSObject) doesNotRecognizeSelector:] + 187
	3 CoreFoundation 0x026f4116 ___forwarding___ + 966
	4 CoreFoundation 0x026f3cd2 _CF_forwarding_prep_0 + 50
	5 Ushahidi_iPhone 0x0000e087 -[ViewIncidentViewController tableView:didSelectRowAtIndexPath:] + 881

dkobia / gist:649355

Created October 27, 2010 16:11

	{
	"payload": {
	"domain": "http:\/\/ushahidi.dev\/",
	"incidents": [
	{
	"incident": {
	"incidentid": "3494",
	"incidenttitle": "National Palace damaged",
	"incidentdescription": "National Palace has extensive damage. President and First Lady are safe.",
	"incidentdate": "2010-01-12 10:43:00",

dkobia / gist:661275

Created November 3, 2010 16:12

	## RUN THE FOLLOWING BEFORE PULLING FROM https://github.com/ushahidi/Ushahidi_Web ##

	git branch -m master 1.2
	git branch -m 2.0 master

dkobia / gist:672711

Created November 11, 2010 16:19

	[Thu Nov 11 10:02:36 2010] [error] [client 41.212.36.70] ModSecurity: Access denied with code 403 (phase 2). Pattern match "(< ?(?:script\|about\|applet\|activex\|chrome).(?:script\|about\|applet\|activex\|chrome) ?>\|> ?< ?(img ?src\|a ?href) ?= ?(ht\|f)tps?:/\|" ?> ?<\|" ?[a-z]+ ?<.>\|> ?"? ?(>\|<)\|< ?/?i?frame\|\\%env)" at ARGS:sms*flsms_instructions. [file "/hsphere/shared/apache2/conf/modsecurity.d/10_asl_rules.conf"] [line "690"] [id "340147"] [rev "56"] [msg "Atomicorp.com - FREE UNSUPPORTED DELAYED FEED - WAF Rules: Generic XSS filter"] [data ".php?"] [severity "CRITICAL"] [hostname "tafsiri.ushahidi.com"] [uri "/turk.php"] [unique_id "TNwTm0MWihgAAGFWNf4AAAAr"]

	[Thu Nov 11 09:57:10 2010] [error] [client 98.230.7.14] ModSecurity: Access denied with code 403 (phase 2). Match of "rx (\\\\.(?:gif\|jpe?g\|png\|bmp\|wct\|pdf)\|^docs$\|^http://$\|^[0-9]+\\\\\|?\|^$\|^true$\|^false$\|^product_image/$\|^submit$)" against "ARGS:image" required. [file "/hsphere/shared/apache2/conf/modsecurity.d/10_asl_rules.conf"] [line "781"] [id "34016

dkobia / gist:674745

Created November 12, 2010 21:48

	{
	"payload": {
	"domain": "http:\/\/demo.ushahidi.com\/",
	"incidents": [
	{
	"incident": {
	"incidentid": "1",
	"incidenttitle": "Hello Ushahidi!",
	"incidentdescription": "Welcome to Ushahidi. Please replace this report with a valid incident",
	"incidentdate": "2010-11-12 15:16:27",

dkobia / gist:674797

Created November 12, 2010 22:16

	{
	"payload": {
	"domain": "http:\/\/demo.ushahidi.com\/",
	"incidents": [
	{
	"incident": {
	"incidentid": "1",
	"incidenttitle": "Hello Ushahidi!",
	"incidentdescription": "Welcome to Ushahidi. Please replace this report with a valid incident",
	"incidentdate": "2010-11-12 15:16:00",

David Kobia dkobia