hi AZNative.
I've just merged your codes.
The coding technique using 'UNIX_TIMESTAMP' looks very cool!
I tested the new routine of rrule extraction with America/LosAngels and it works perfect.
Note:
After changing server's timezone, don't forget restart httpd and mysqld.
This fact bothers me critically.