// JavaScript Document
function tzOffset() {
   var rightNow = new Date();
   var date1 = new Date(rightNow.getFullYear(), 0, 1, 0, 0, 0, 0);
   var date2 = new Date(rightNow.getFullYear(), 6, 1, 0, 0, 0, 0);
   var temp = date1.toGMTString();
   var date3 = new Date(temp.substring(0, temp.lastIndexOf(" ")-1));
   var temp = date2.toGMTString();
   var date4 = new Date(temp.substring(0, temp.lastIndexOf(" ")-1));
   var hoursDiffStdTime = (date1 - date3) / (1000 * 60 * 60);
   var hoursDiffDaylightTime = (date2 - date4) / (1000 * 60 * 60);

   if (hoursDiffDaylightTime == hoursDiffStdTime) { 
     return hoursDiffStdTime;
   }
   return hoursDiffDaylightTime;
}

/*

timeleft query
------------------------
SELECT  60-SUM(time) as timeleft
FROM  `ssk_log_book` 
WHERE  `player_id`  =1 AND  `date`  = NOW()  group by `date`


SELECT DATE_ADD( DATE_ADD( NOW(  ) ,  INTERVAL  -1 HOUR  ) ,  INTERVAL -30 MINUTE ) 

*/