phoenixdigital.com

Reset an old Nokia Mobiles

phoenixdigital — Fri, 20 Aug 2010 08:33:28 +0000

Some useful sites for factory reset of old nokia phones.

I am normally reluctant posting up my IMEI code but this site actually worked when trying to reset an old Nokia 3100.

http://nfader.su/

and

http://www.bhatt.id.au/blog/nokia-mobile-phone-service-codes-activate-hidden-features/

Useful Android Applications

phoenixdigital — Wed, 18 Aug 2010 00:32:39 +0000

System Settings
Curve Fish – Widget to put phone in silent/vibrate mode

Other
Flash Player – Hi Steve Jobs

Admin/Modding Utilities
ROM Manager – Allows quick swapping of firmwares
Titanium Backup – Backup of EVERYTHING (Required Root)
Root Explorer – File Explorer

GPS Apps
Runkeeper – Great App for tracking your excercise

Games/Entertainment
Unblock Me – Great Puzzle Game
Galcon – Strategy Game (Multiplayer)

Data Visualisation with Javascript or Flash

phoenixdigital — Wed, 21 Jul 2010 02:37:24 +0000

Great little time line viewer and other cool visualisations.

http://www.simile-widgets.org/

Serializing Mail Messages

phoenixdigital — Tue, 13 Jul 2010 23:23:27 +0000

Useful classes for serializing mail messages

http://nayyeri.net/how-to-serialize-a-mailmessage
and
http://gopi.codeplex.com/

Import/Export MySQL databases and other commands

phoenixdigital — Wed, 16 Jun 2010 22:18:31 +0000

Just a quick reminder of how to backup and restore MySQL databases.

1	mysqldump --opt -u [user_name] -p [database_name] \| gzip > [backup_file].dump.gz

To restore

1 2	gzip -d [backup_file].dump.gz mysql [database_name] < [backup_file].dump

To create a database

1 2	mysql -u root -p create database [the_database_name]

Javascript inArray functionality

phoenixdigital — Tue, 15 Jun 2010 22:39:27 +0000

Some useful examples of prototyping functions in javascript. As well as an efficient method of searching the contents of an an array for a particular value.

From http://stackoverflow.com/questions/237104/javascript-array-containsobj thanks to Damir.

As others have said, the iteration through the array is probably the best way, but it has been proven that decreasing while loop is the fastest way to iterate in JavaScript. So you may want to rewrite your code as follows:

1
2
3
4
5
6
7
8
9

function contains(a, obj) {
var i = a.length;
while (i--) {
if (a[i] === obj) {
return true;
}
}
return false;
}

Of course, you may as well extend Array prototype:

1
2
3
4
5
6
7
8
9

Array.prototype.contains = function(obj) {
var i = this.length;
while (i--) {
if (this[i] === obj) {
return true;
}
}
return false;
}

And now you can simply use the following:

1 2	alert([1, 2, 3].contains(2)); // => true alert([1, 2, 3].contains('2')); // => false

.NET Execution Order

phoenixdigital — Sun, 06 Jun 2010 23:46:41 +0000

When a page is loaded the execution order is

1
2
3
4
5

Page_Init(object sender, EventArgs e) {}
Page_Load(object sender, EventArgs e) {}
Page_DataBind(object sender, EventArgs e) {}
Page_PreRender(object sender, EventArgs e) {}
Page_Unload(object sender, EventArgs e) {}

http://support.microsoft.com/kb/305141

C# Primitive Types

phoenixdigital — Thu, 03 Jun 2010 00:01:59 +0000

Useful lookup of variable types available in c#

C# Type	.Net Framework (System) type	Signed?	Bytes Occupied	Possible Values
sbyte	System.Sbyte	Yes	1	-128 to 127
short	System.Int16	Yes	2	-32768 to 32767
int	System.Int32	Yes	4	-2147483648 to 2147483647
long	System.Int64	Yes	8	-9223372036854775808 to 9223372036854775807
byte	System.Byte	No	1	0 to 255
ushort	System.Uint16	No	2	0 to 65535
uint	System.UInt32	No	4	0 to 4294967295
ulong	System.Uint64	No	8	0 to 18446744073709551615
float	System.Single	Yes	4	Approximately ±1.5 x 10^-45to ±3.4 x 10³⁸with 7 significant figures
double	System.Double	Yes	8	Approximately ±5.0 x 10^-324to ±1.7 x 10³⁰⁸with 15 or 16 significant figures
decimal	System.Decimal	Yes	12	Approximately ±1.0 x 10^-28to ±7.9 x 10²⁸with 28 or 29 significant figures
char	System.Char	N/A	2	Any Unicode character (16 bit)
bool	System.Boolean	N/A	1 / 2	true or false

Javascript escape all single and double quotes

phoenixdigital — Mon, 31 May 2010 05:56:26 +0000

Global replace of ‘s and or “s

1 2	value = value.replace(/\'/g, "'"); value = value.replace(/\"/g, """);

Retrieve rows where count of linked items greater than zero

phoenixdigital — Sun, 30 May 2010 23:57:44 +0000

Say you have two tables where one is linked to the other by it’s ID or CODE and you only want to retrieve a list of Table1 items which have linked Table2 items. You also want to get the count of Table2 items for each.

Table1
id(int)
title(varchar)
another_id(int)

Table2
id(int)
table1_id(int)
title(varchar)
date_added(date)

1
2
3
4
5
6

SELECT t1.id, t1.title, count(t2.id)
FROM Table1 t1
JOIN Table2 t2 ON t2.table1_id = t1.id
WHERE t1.another_id = 32
GROUP BY t1.code, t1.title
HAVING count(t2.id) > 0

Now say you want a list of Table1 with the most recent Table2 item ONLY

1
2
3
4
5
6
7
8

SELECT t1.*, t2.*
FROM Table1 t1
INNER JOIN Table2 t2
ON t2.table1_id = t1.id
LEFT JOIN Table2 t2later
ON t2.table1_id = t2later.table1_id
AND t2later.date_added > t2.date_added
WHERE t2later.table1_id is null

Ref