December 2007 Archives

I have recently purchased a USB Network Interface Adapter trying to make it work with my neighbor's wifi hot spot. I'm always mobile so, applying for a dsl subscription is not a good idea. I am working with my pc at home inside a cave to be more specific, I have some trouble connecting to the hotspot which is right beside our house. What is the range of a typical wifi hotspot?

Google is my friend, instead of giving me the range, i found a wifi range extender instead. It's so creative with just the following items needed:
1 - Metal Strainer/Steamer
1 - USB WIFI Adaptor
1 - USB Extension Cable (I chose a 10ft long)
½" Drill Bit (I like to use stepper bits for metal)
Gorilla Glue (Epoxy works well too)
2 - Zip Ties

I am tempted and I'm sure I'm going to miss our home strainer. Not sure if it's going to work inside a cave. I tried searching some more and found Smart bros latest wireless modem. It's very tempting, based on the operator's messages, as long as there is a signal from your phone; the modem should work! I have changed my mind ill try the modem first and later, if its not going to work; ill experiment on the strainer.

-----
Market demand for IT certified, especially Microsoft 70-294 certified professionals, has increased tremendously. Therefore, fresh graduates prefer go for 70-647 certification before starting their professional career so that their skills can earn good money. People, who have skills as well as CISCO 640-863 certification are more in demand in networking field. 70-293 certified people are supposed to perform better in complex networking environment. 70-536 certified personnel can earn more money than the average certified professionals.

I've been here for a while now. Here's a list of places to play badminton in davao. I'd really like to play here but i don't know where is the best place for me. I'm here staying at somewhere at Guerrero Street, but my location does not matter as long as the courts are good to play. I also hate to wait, and i really do not know how many courts does these list below have.

Holiday Spa & Fitness Center
Address:
F. Torres st.,
Davao City
Contact:
(042)225-5577

Wheels 'n More Badminton Courts
Address:
JP Laurel Avenue,
Davao City
Contact:
300-8999

Smash Ville Fitness Center
Address:
AGL Bldg., R. Magsaysay Ave.,
Davao City
Contact:
305-5999

4Play
Address:
V. Mapa Street,
Davao City
Contact:
222-7529

Smash 'N Drop
Address:
San Pedro Extension,
Davao City
Contact:
305-2200

Rematch Badminton Courts
Address:
Tulip Drive, Juna Subd., Matina,
Davao City
Contact:
298-4503

Search engines ignore these keywords because they are common in most articles, may also slow down the search process and they does not contribute to relevance. These stop words contains conjunctions, prepositions, and articles.

In contrary, when we are optimizing for a keyword that contains any of the stop words(e.g. IT, one, two etc), it would then become troublesome for the seo department. So, it is best to choose the right keywords to optimize for your website beforehand.

a
able
about
above
abroad
according
accordingly
across
actually
ad

The search bar in IE7 will become redundant if we install another toolbar for like the google toolbar. we could then use the extra space for our address bar. To disable the built in search bar in internet explorer 7 :

1. Start -> Run -> regedit -> OK
2. Navigate to
* HKEY_LOCAL_MACHINE
* Software
* Policies
* Microsoft
* Internet Explorer
* Infodelivery
* Restrictions
3. Right click on an empty space select: New -> DWORD value
4. Rename New Value #1 to NoSearchBox : Right click on New Value #1 -> Rename
5. Double click on NoSearchBox name
6. On the Value data textbox change it to 1 from zero
7. Click on OK

Your Search bar in IE7 will be gone, to enable it back again, just change the value data 1 back to 0.

Usually when doing some 'copy' 'and paste' stuff would end with so many duplicates. It would be very tedious in manually editing them. when collecting sites for link exchanges, we will get lots of duplicate domains especially from google and wikipedia which most of the links.

Normally, we use advanced filter but something is wrong with it, its not filtering the character 'a'. I got two of them and the result still has two of them. Here is how i did it with advanced filter.

1. Click On an empty cell column
2. On the menu choose: Data -> Filter -> Advanced Filter
3. In the dialog box, type in the range of cells to filter at the List Range text box. e.g. type in $A$2:$A$1319 for cell A2 to cell A1319
4. On the Copy to text box type in the cell location of the output (filtered list)
5. Click on the Unique records only check box
6. Press OK

With the tool duplicate remover, we could remove repeating domain names in an instant. But if we are just simply collecting words and similar list that we become another story. Usually we collect word or phrases and paste them in an excel worksheet. but the question is how to filter the list and remove the duplicates? well i run unto the same problems and luckily i found a macro on the internet, so it saved me the time in creating one.

1. Open Excel.
2. Alt + F11 to open the Visual Basic Editor (VBE).
3. Insert-Module.
4. Paste the code below.
5. Close the VBE (Alt + Q or the X in the top-right corner).

Excel Macro

Option Explicit 
 
Sub DeleteDups() 
     
   Dim x               As Long 
   Dim LastRow         As Long 
     
   LastRow = Range("A65536").End(xlUp).Row 
   For x = LastRow To 1 Step -1 
       If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then 
           Range("A" & x).EntireRow.Delete 
       End If 
   Next x 
     
End Sub 
			

Test the Code
1. In Column A add any data.
2. Tools-Macro-Macros
3. Select DeleteDups and press Run.

source: remove duplicates

Philippines has so many dialects, xxx of them to be exact. Below is a compiled list local dialects of the Philippines saying "Merry Christmas and a happy new year". got it from flw.com

Aklanon - Malipayon nga Paskwa ag Mahigugmaon nga Bag-ong Dag-on
Atá - Maroyan na Pasko woy kaopia-an ng Bag-ong Tuig kaniyo't langon mga sulod
Bicolano - Maugmang Capascuhan asin Masaganang Ba-gong Taon!
Blaan - Pye duh di kaut Kristo klu munt ug Felemi Fali!
Bolanon - Malipajong Pasko
Cebuano - Malipayong Pasko ug Bulahang Bag-ong Tuig!
Dibabawon - Marayaw na Pasko aw Bag-ong Tui g kaniyo tibo na mga soon
Gaddang - Mangamgam Bawa a dawun sikua diaw amin
Hiligaynon - Malipayon nga paskua & Malipayon Nga Bag-ong tuig
Hungduan - Maphon au nitungawan. Apo Dios Kituwen baron di toon
Ilocano - Naimbag a Pascua ken Naragsac nga Baro nga Tawen!
Ilonggo - Malipayong Paskwa kag Masinadyahong Bag-ong Tuig
Mandobo - Mepiya Pagasaulog sa pagka-otawni Jesus aw maontong kaling Omay!
Mangyan - Mayad paq Pasko kag
Mansaka - Madyaw na Pasko aw malipayong Bag-ong Tuig kamayo, mga lumon
Pompangan - Malugud Pascu at saca Masayang Bayung Banua!
Pangasinan - Maabig ya pasko & Maliket ya balon taon
Sambal - Maligayang Pasko at Masayang Ba-yon Taon!
Subanen - Piak Pasko Pu Piag Bago Tawn
Surigaonon - Malipayon na pasko sanan bag-on tuig!
Tagalog - Maligayang Pasko at Manigong Bagong Taon
Tala Andig - Maayad ha pasko daw bag-ong tuig
Waray-Waray - Maupay nga Pasko ngan Mainuswagon nga Bag-o nga Tuig!

If you knew other local dialects we could add them here. ill even credit you name for it.

i kept on forgetting this until i reinstalled xampp. i keep receiving this error, and i am sure IIS was not installed with my windows xp installation.

Installing Apache2.2 as an Service
Installing the Apache2.2 service
The Apache2.2 service is successfully installed.
Testing httpd.conf....
Errors reported here must be corrected before the service can be started.
(OS 10048)Only one usage of each socket address (protocol/network address/port)
is normally permitted. : make_sock: could not bind to address 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
Now we Start Apache2.2 :)
The Apache2.2 service is starting.
The Apache2.2 service could not be started.

A service specific error occurred: 1.

More help is available by typing NET HELPMSG 3547.

Its making me insane @#$^#. And then somebody sent me a message from Skype !!!! There it goes, i remembered, Skype is using port 80, and I dont know why. Closed Skype, runned the installed again and viola! It works.

One problem with POP3 mail is that when you are downloading mails and suddenly an error has occurred, when you try to restart your download you will get duplicate mails!!! Now my inbox has over 8000 emails and its about 900MB in size, that would be very hard to manually delete those duplicate emails.

With IMAP hopefully that problem will be resolved since it has two-way syncing capabilities. IMAP stands for Internet Message Access Protocol. When using IMAP with GMAIL, all your labeled messages would arrive in folders, that is a label and inside the individual messages with its corresponding marks. Deleting a message in IMAP wont de deleted in GMAIL, you have to move it to the trash or delete it at GMAIL.

You can set your client to work offline to be able to download all your email messages, otherwise on most IMAP clients, it will only download the mail headers. When sending messages from your client creates new labels on GMAIL, they are marked as Sent Messages which indicates that the messages are sent from your mail client. When you create folders on your client they will be treated as label on GMAIL. There folder names which are reserved, they are Chats and Sent, when you try to create a folder with this name on IMAP they have a prefix IMAP/folder name on GMAIL.

Taken from GMAIL help center, How do actions sync in IMAP?

Action on mobile device/client (e.g. iPhone/Outlook)	Result in Gmail on the web
Open a message	Mark a message as read
Flag a message	Apply a star to the message
Move a message to a folder	Apply a label to the message
Move a message to a folder within a folder*	Apply a label showing folder hierarchy ('MainFolder/SubFolder')*
Create a folder	Create a label
Move a message to [Gmail]/Spam	Report a message as spam
Move a message to [Gmail]/Trash	Move a message to Trash
Send a message	Store message in Sent Mail
Delete a message in inbox	Remove the message from inbox
Delete a message from a folder	Remove that label from the message
Delete a message from [Gmail]/Spam or [Gmail]/Trash	Delete the message permanently

Enabling IMAP 1. Login to your GMAIL account 2. Click on the Settings Link on top of the page just beside your email address 3. Click on forwarding and POP/IMAP tab 4. On the IMAP access section, select enable IMAP if its not yet selected 5. Save Changes.

Configuring your client I'm using Outlook 2003, well use it as our client. Or you can click on the link below for your client. On user Information Your Name: the name that will appea in the From: field of outgoing messages. Email Address: your GMAIL email address

On Server Information Incoming mail server (IMAP): imap.gmail.com Outgoing mail server (SMTP): smtp.gmail.com

On Login Information User Name: Your Gmail username (including @gmail.com) Password: Your Gmail password

* Click on More Settings button and on the Outgoing Server tab, Check the box next to My outgoing server (SMTP) requires authentication. * Select Use same settings as my incoming mail server radio button.

On the Advanced tab make the following changes: Check the box next to This server requires an encrypted connection (SSL) under Incoming Server (IMAP) and also under Outgoing server (SMTP) * IMAP port is 993 * Outgoing SMTP port is 465 * Click OK * If you want to you click on Test Account Settings button to check if there are mistakes.

However, IMAP for GMAIL supports the following clients: * Outlook Express (Windows) * Outlook 2003 (Windows) * Outlook 2007 (Windows) * Apple Mail * Apple Mail 3.0 (Leopard) * Windows Mail * Thunderbird 2.0

For more info you can visit the Gmail help center regarding setting up Gmail with IMAP and POP3

----- CISSP certified person can work in all IT industries; banks, manufacturing companies and service businesses. Increase in demand for 350-018 certified persons in networking field shows that this certification can fulfill the requirements of employees training. 640-816 certification identify people with expertise in installing, managing and trouble shooting networks. Increased corporate IT spending is fueling demand for 70-297 certified persons. 156-215 certification validates your knowledge and expertise of administrating security issues on corporate level.