JSON API Auth WordPress Plugin

Thanks to ‘mattberg’ who developed the auth controller. I have authored it as a WordPress plugin so that it could easily be searched and installed. mattberg made Auth controller available here https://github.com/mattberg/wp-json-api-auth JSON API Auth plugin extends the JSON API Plugin with a new Controller to allow user authentication. JSON API for WordPress Plugin allows…

Redmine Email Configuration – Resolve Sending Email Notifications

I upgraded my Redmine installation after a while to 2.3.1 and I noticed email notifications weren’t being sent out. I tried to send a test email from “Administration => Settings => Email notifications” and received the following error message: An error occurred while sending mail (wrong argument (Fixnum)! (Expected kind of OpenSSL::SSL::SSLContext)) After trying different…

Calculating MySQL Age from Date of Birth Column and Selecting Records Between Age Range

While developing a Facebook Dating app recently, I needed to return records for a date range between minimum and maximum age from users table but the data was in the date format (birthday). Following select command will calculate the age from the `birthday` column value for you for each record: SELECT EXTRACT(YEAR FROM (FROM_DAYS(DATEDIFF(NOW(),`birthday`))))+0 AS…