Frank Park

If you receive this email from “Google”.. Be aware, this is a scam and you should not reveal your password.

Dear: Frank Park (xxxxxxxx@gmail.com),

Gmail Account Security has received a request to deactivate your
account. The request was received from IP address:

211.56.178.45 on 13 June 1111PM EST

If you did not request that your account be deactivated, or you
suspect another user made this request, simply reply back to
this email with your password in the message body to verify that
this request was made in error.

Your account will automatically remain active once the current
password is verified. This is the final email you will receive
before your account is terminated.

**Please note, your account cannot be recovered once deactivated.**

Sincerely,
Gmail Piracy Protection
************************************

There are very few occasions where you have to purely use MySQL statement to determine if a specified date falls within the daylight saving time. Since the daylight saving time starts on the second Sunday of March and ends on the first Sunday of November, we can write such query to figure out the start and end datetime of the boundary.

SELECT 
  CONCAT(DATE_ADD(CONCAT(YEAR(NOW()), "-03-01"), INTERVAL ((6 - WEEKDAY(CONCAT(YEAR(NOW()), "-03-01"))) + 7) DAY), " 02:00:00") AS dst_start, 
  CONCAT(DATE_ADD(CONCAT(YEAR(NOW()), "-11-01"), INTERVAL ((6 - WEEKDAY(CONCAT(YEAR(NOW()), "-11-01")))) DAY), " 02:00:00") AS dst_end;

With this information, you can now determine if a specific date falls between these two date. This example obviously looks at the current year, but it’s pretty easy to alter the above statement to check any year of your choosing.

Happy coding!

If you are familiar with Cisco SPA300 and SPA500 series, it allows a secretary to have a BLF (Busy Lamp Field)  + CP (Call Pickup) + SD (Speed Dial) features. Although setting up BLF and SD features are very trivial given a PBX box that supports it, CP can be a bit tricky. Attendant Console Pickup Call Code parameter is available under the Attendant Console/Keys tab, but only allows you to have a static CP code for all extensions!!

Well.. Here’s a simple solution to dynamically assign a pickup code such that the code is followed by an extension number (ie. *88101). Let’s say Secretary’s extension is 100 and the boss’s extensions is 101. When you have a BLF+CP+SD feature turned on by entering “fnc=blf+cp+sd;sub=101@$PROXY;ext=101@$PROXY;nme=101” in the Extended Function field. Be sure to note that I have included nme variable. This specifies the extension number that will be appended to the call pickup code. Once you have assigned the nme variable, go to the Attendant Console/Key tab and change the Attendant Console Call Pickup Code to “*88#”. The hash mark (#) will be replaced with the value of nme.

Enjoy this trick!

As with anything, there’s always a starting point.. Well.. Here I am! You may find my future blogs to be boring and useless, but my plans are to only post notes that I found either interesting or helpful for whatever I was trying to accomplish at the time. Feel free to contribute!