Saturday, August 27, 2011

Convert mysql datetime into some other format!!

Simply change your sql statement to :


SELECT DATE_FORMAT(thedate, '%M %e, %Y, %l:%i%p') as newdate FROM your_table; 



Sunday, May 8, 2011

Change Carriers for Iphone to Custom Logos or Text!!

This has been tested on IOS 4.3.2 on 3gs working Perfectly with Vodafone India.
Now to change it follow the procedure :

  • Go to /System/Library/Carrier Bundles/Your_Carrier.bundle
  • Replace both the FSO_CARRIER_Your_Carrier.png and the Default_CARRIER_Your_Carrier.png files with the images you want (image can’t be any higher that 20 pixels).
  • The same thing applies for any other carrier, just select the correct .bundle for you carrier.

Have Fun!!

Enable GPRS/Edge/Internet on iPhone for india!!

If you have a jailbroken iPhone 3G with Vodafone connection but the problem is with the Internet connection. Despite having an activated Edge or GPRS service iPhone is facing the internet connectivity problems and is not able to run the internet.

I needed to set up my internet settings manually but those who use iPhone know that there isn’t a way to do that. So if you are also facing internet problem on the iPhone and wanted to manually configure the internet settings, you can do that easily in just 2 minutes even if you don’t have a wifi connection.

1. To be able to setup the APN settings, you need to download software called “iPhone Configuration Utility” and install it on your computer.
2. Launch the tool on your computer and connect your iPhone via the USB cable.
3. Your iPhonewould show in the list.
4. Click on Configuration Profiles on the left side and click New button to create a new profile.
5. A new profile would open and from the options select Advanced, click Configure

6. Enter Access Point Name (APN) in the box, for Vodafone India users it is “portalnmms”.
7. You also need to enter Proxy Server (for Vodafone India it is 10.10.1.100) and the Proxy Port (enter 9401 for Vodafone India).
8. On the General options, give it a name, say Vodafone and click somewhere outside to save it.


9. The profile would display in the section above.
10. Click on your device on the left hand side and choose Configuration Profiles tab.

11. Click on the Install button in the list, and you will notice that the same profile asks for permission on your iPhone. Allow it and it will list itself in the Settings -> General -> Profile
Note: Restart the iPhone for the profile to get activated.
Above steps solved my problem and I was able to surf internet using the GPRS/EDGE service on my iPhone. If you want to remove the profile later then you can do that by going in the Profile (Settings -> General -> Profile) and selecting the Remove option.
For Internet settings for Post paid plans instead of "portalnmms" put "www" and rest of the fields blank.

Thursday, March 24, 2011

403 Forbidden Apache2 on Ubuntu Desktop

I setup an apache2 sever. However whenever I try to get onto any other page than the index.html (or if i move that it shows a list of the files on the root), It displays a 403 Forbidden message and says I do not have permission to access bla bla bla. I fixed the problem by implementing these set of commands :

sudo chown -R root:root /var/www

sudo chmod -R 755 /var/www

sudo /etc/init.d/apache2 restart

Friday, October 29, 2010

How To: Factory Reset Samsung Wave

Here's a quick tip for Samsung Wave owners. If you need to wipe your device completely clean (maybe you're selling it or returning it), you'll need to perform a hard reset (also known as a factory reset). The reset function in the Wave's settings menu does not remove all data, making it pretty much useless in this situation.

To hard/factory reset your Wave, type *2767*3855# into the telephone dialer. Note that once you type this code into your Wave, it will IMMEDIATELY begin the reset procedure ; there is no confirmation. ONLY type this code in when you need to delete all personal data on your Wave.

Friday, August 13, 2010

Females vs computers!


Multitasking possible

Faster processor

Upgradable

Expandable

Multinetwork mode (social,lan,wan)

Secure mode (encryption possible)

Uses own language to communicate bet each other

Dependent on foreign sources for one thing only - input!

Any comments?

Posted via Blogaway

Saturday, April 24, 2010

Fix Certificate Error for Nokia E71,E71xE72,E75,E63,E61i And 5800 Themes

By default, some Nokia devices have the security settings set too high and a couple of changes need to be made in order to install Nokia themes. Nokia E61i, E63 and E71 and E71x in particular suffer this problem. However the fix is easy.

Go to “App. Mgr.”,
press “Options”,
press “Settings”,
make sure “Software installation” is set to “All”,
and “Online certif. check” is set to “Off”.
After Doing This Every Theme will work fine without any error on your Nokia E71x,E71,E63,E61i.