iPhone SDK: Application failed codesign verification

Check the following:

1. We are using release | device - during compilation, if you cannot select release then chances are configuration for arvm6 was not selected (we need to use standard)

2. check that the codesign has distribution selected and not any other certs

3. the release shoudl be at: Release-iphoneos

4. if there is no popup that asks for permissions to do codesign, then chances are the setup is wrong some where.. for example the active executable is towards that of the iOS simulator and not for release.

Aaron

Get today's date mysql

"SELECT * FROM netl_hiscores WHERE DATE(scoreDateTime) = DATE(NOW())";

Weird floating DIVs

If you run into problems with div floating on the side of another div despite having clear seperators, then you need to inform the browser to 'stop' floating.. using the following command.

<div style="clear: both;"> </div>

Haversine Formula Calculation between two points

seems like safari does not support torad() function of javascript.

function getDistance(lat1, lon1, lat2, lon2) {

var R = 6371; // km
var dLat = (lat2-lat1) * Math.PI / 180;
var dLon = (lon2-lon1) * Math.PI / 180;
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(lat1 * Math.PI / 180) * Math.cos(lat2 * Math.PI / 180) *
Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

return d.toFixed(2);
}

mysqldump and restore

mysqldump -u [uname] -p [dbname] > bak.sql

mysql -u [uname] -p [dbname] < [bak.sql]

format base strip sscanf php

function stripCurrency($input) {

$input = str_replace(",","",$input);
$input = str_replace("$","",$input);

return $input;
}

function stripRoadTax($input) {

$input = str_replace(",","",$input);
$input = str_replace("$","",$input);
list($val) = sscanf($input, "%d per year");

return $val;
}

function stripMileage($input) {

$input = str_replace(",","",$input);
list($val) = sscanf($input, "%d km");

return $val;
}

mysql php installation errors server 2008 zlib.dll

When IIS is complaining about a missing DLL file either a zlib.dll or oci.dll, chances are soemthing is wrong with the msi file, disable some of the extensions and try to install again, as long as php-cgi.exe runs properly, the program should work.

after ensuring that php works, follow the insturctions to edit the php.ini file to point to the correct fastcgi settings.
http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis-7/

I installed PHP on C:\PHP and not within program files directory mainly because of the space.

lastly, take note of the appliaction pool, the manage pipeline mode should be integrated and the "enable 32 bit applications" setting should be set to true.