From 2f2907357ce494ec6aa33254686b9bdb70e3cf96 Mon Sep 17 00:00:00 2001
From: Kazuki Przyborowski <kazuki.przyborowski@gmail.com>
Date: Wed, 27 Jun 2007 16:53:58 +0000
Subject: [PATCH] Added minute offset to User Time Zone.

git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@29 2b68903e-0b30-0410-9a39-a2e4f3c5be39
---
 inc/endpage.php        |  9 +++++----
 inc/filename.php       |  6 +++---
 inc/members.php        | 36 +++++++++++++++++++++++++++++-------
 inc/misc/functions.php | 45 +++++++++++++++++++++++++++++++++++----------
 inc/misc/setcheck.php  |  4 +---
 inc/profilemain.php    | 50 +++++++++++++++++++++++++++++++++++++++++++++++---
 mysql.php              | 29 ++++++++++++++++++-----------
 setup/mkconfig.php     | 12 +++++++++---
 setup/setup.php        | 15 ++++++++++++++-
 9 files changed, 161 insertions(+), 45 deletions(-)

diff --git a/inc/endpage.php b/inc/endpage.php
index 6843bf7..a97da3b 100644
--- a/inc/endpage.php
+++ b/inc/endpage.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: endpage.php - Last Update: 06/26/2007 SVN 28 - Author: cooldude2k $
+    $FileInfo: endpage.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="endpage.php"||$File3Name=="/endpage.php") {
@@ -19,10 +19,11 @@ if ($File3Name=="endpage.php"||$File3Name=="/endpage.php") {
 	exit(); }
 if(!isset($_GET['time'])) { $_GET['time'] = true; }
 if($_GET['time']=="show"||$_GET['time']==true) {
-if($_SESSION['UserDST']=="on") { $MyDST = $_SESSION['UserTimeZone']+1; }
-if($_SESSION['UserDST']=="off") { $MyDST = $_SESSION['UserTimeZone']; }
+if($_SESSION['UserDST']=="on") { $MyDST = $checktimea['hour']+1; }
+if($_SESSION['UserDST']=="off") { $MyDST = $checktimea['hour']; }
+$MyDST = $MyDST.":".$checktimea['minute'];
 $MyTimeNow = GMTimeGet('g:i a',$_SESSION['UserTimeZone'],0,$_SESSION['UserDST']);
-$endpagevar=$endpagevar."<br />All times are GMT ".$MyDST.". The time now is ".$MyTimeNow; }
+$endpagevar=$endpagevar."<br />The time now is ".$MyTimeNow." ".$ThemeSet['LineDivider']." All times are GMT ".$MyDST; }
 if($_GET['debug']=="true"||$_GET['debug']=="on") {
 	$endpagevar=$endpagevar."<br />\nFiles included: ".count_included_files()." &amp; Extensions Enabled: ".count_extensions().$ThemeSet['LineDivider']."<a href=\"http://validator.w3.org/check/referer?verbose=1\" title=\"Validate HTML\" onclick=\"window.open(this.href);return false;\">HTML</a>".$ThemeSet['LineDivider']."<a href=\"http://jigsaw.w3.org/css-validator/check/referer?profile=css3\" title=\"Validate CSS\" onclick=\"window.open(this.href);return false;\">CSS</a>"; }
 	$endpagevar=$endpagevar."</div>\n";
diff --git a/inc/filename.php b/inc/filename.php
index e64b366..b50ca9b 100644
--- a/inc/filename.php
+++ b/inc/filename.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: filename.php - Last Update: 06/26/2007 SVN 28 - Author: cooldude2k $
+    $FileInfo: filename.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="filename.php"||$File3Name=="/filename.php") {
@@ -44,8 +44,8 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) {
 	if($showsvn!=true&&$showsvn!=null) { $return_var .= " ".$showsvn." ".$svnver; }
 	return $return_var; }
 $VER1[0] = 0; $VER1[1] = 1; $VER1[2] = 5; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2];
-$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 28; $RName = "iDB"; $SFName = "IntDB";
-$SVNDay[0] = 06; $SVNDay[1] = 26; $SVNDay[2] = 2007; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2];
+$VER2[0] = "Pre-Alpha"; $VER2[1] = "PA"; $VER2[2] = "SVN"; $SubVerN = 29; $RName = "iDB"; $SFName = "IntDB";
+$SVNDay[0] = 06; $SVNDay[1] = 27; $SVNDay[2] = 2007; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2];
 $VerInfo['iDB_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,false);
 $VerInfo['iDB_Ver_SVN'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,true);
 $VerInfo['iDB_Full_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[0],$SubVerN,false);
diff --git a/inc/members.php b/inc/members.php
index eb1c16c..e475b90 100644
--- a/inc/members.php
+++ b/inc/members.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: members.php - Last Update: 06/18/2007 SVN 26 - Author: cooldude2k $
+    $FileInfo: members.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="members.php"||$File3Name=="/members.php") {
@@ -448,27 +448,42 @@ $membertitle = " ".$ThemeSet['TitleDivider']." Signing up"; ?>
 </tr><tr>
 	<td><label class="TextBoxLabel" for="YourOffSet">Your TimeZone:</label></td>
 	<td><select id="YourOffSet" name="YourOffSet" class="TextBox"><?php
+$tsa_mem = explode(":",$Settings['DefaultTimeZone']);
+$TimeZoneArray = array("offset" => $Settings['DefaultTimeZone'], "hour" => $tsa_mem[0], "minute" => $tsa_mem[1]);
 $plusi = 1; $minusi = 12;
 $plusnum = 13; $minusnum = 0;
 while ($minusi > $minusnum) {
-if($Settings['DefaultTimeZone']==-$minusi) {
+if($TimeZoneArray['hour']==-$minusi) {
 echo "<option selected=\"selected\" value=\"-".$minusi."\">GMT - ".$minusi.":00 hours</option>\n"; }
-if($Settings['DefaultTimeZone']!=-$minusi) {
+if($TimeZoneArray['hour']!=-$minusi) {
 echo "<option value=\"-".$minusi."\">GMT - ".$minusi.":00 hours</option>\n"; }
 --$minusi; }
-if($Settings['DefaultTimeZone']==0) { ?>
+if($TimeZoneArray['hour']==0) { ?>
 <option selected="selected" value="0">GMT +/- 0:00 hours</option>
-<?php } if($Settings['DefaultTimeZone']!=0) { ?>
+<?php } if($TimeZoneArray['hour']!=0) { ?>
 <option value="0">GMT +/- 0:00 hours</option>
 <?php }
 while ($plusi < $plusnum) {
-if($Settings['DefaultTimeZone']==$plusi) {
+if($TimeZoneArray['hour']==$plusi) {
 echo "<option selected=\"selected\" value=\"".$plusi."\">GMT + ".$plusi.":00 hours</option>\n"; }
-if($Settings['DefaultTimeZone']!=$plusi) {
+if($TimeZoneArray['hour']!=$plusi) {
 echo "<option value=\"".$plusi."\">GMT + ".$plusi.":00 hours</option>\n"; }
 ++$plusi; }
 ?></select></td>
 </tr><tr>
+	<td style="width: 50%;"><label class="TextBoxLabel" for="MinOffSet">Minute OffSet:</label></td>
+	<td style="width: 50%;"><select id="MinOffSet" name="MinOffSet" class="TextBox"><?php
+$mini = 0; $minnum = 60;
+while ($mini < $minnum) {
+if(strlen($mini)==2) { $showmin = $mini; }
+if(strlen($mini)==1) { $showmin = "0".$mini; }
+if($mini==$TimeZoneArray['minute']) {
+echo "\n<option selected=\"selected\" value=\"".$showmin."\">0:".$showmin." minutes</option>\n"; }
+if($mini!=$TimeZoneArray['minute']) {
+echo "<option value=\"".$showmin."\">0:".$showmin." minutes</option>\n"; }
+++$mini; }
+?></select></td>
+</tr><tr>
 	<td style="width: 40%;"><label class="TextBoxLabel" for="DST">Is <span title="Daylight Savings Time">DST</span> / <span title="Summer Time">ST</span> on or off:</label></td>
 	<td style="width: 60%;"><select id="DST" name="DST" class="TextBox"><?php echo "\n" ?>
 <?php if($Settings['DefaultDST']=="off"||$Settings['DefaultDST']!="on") { ?>
@@ -647,6 +662,13 @@ $yourid = getnextid($Settings['sqltable'],"members");
 $_POST['Interests'] = @remove_spaces($_POST['Interests']);
 $_POST['Title'] = @remove_spaces($_POST['Title']);
 $_POST['Email'] = @remove_spaces($_POST['Email']);
+if(!is_numeric($_POST['YourOffSet'])) { $_POST['YourOffSet'] = "0"; }
+if($_POST['YourOffSet']>12) { $_POST['YourOffSet'] = "12"; }
+if($_POST['YourOffSet']<-12) { $_POST['YourOffSet'] = "-12"; }
+if(!is_numeric($_POST['MinOffSet'])) { $_POST['MinOffSet'] = "00"; }
+if($_POST['MinOffSet']>59) { $_POST['MinOffSet'] = "59"; }
+if($_POST['MinOffSet']<0) { $_POST['MinOffSet'] = "00"; }
+$_POST['YourOffSet'] = $_POST['YourOffSet'].":".$_POST['MinOffSet'];
 $query = query("insert into ".$Settings['sqltable']."members values (".$yourid.",'%s','%s','%s','%s','%s','%s','%i','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')", array($Name,$NewPassword,"iDBH",$_POST['Email'],$yourgroup,$ValidateStats,"0",$_POST['Interests'],$_POST['Title'],$_POST['Joined'],$_POST['LastActive'],"0",$NewSignature,'Your Notes',$Avatar,"100x100",$Website,$_POST['YourGender'],$_POST['PostCount'],$_POST['YourOffSet'],$_POST['DST'],$Settings['DefaultTheme'],$_POST['UserIP'],$HashSalt));
 mysql_query($query);
 $querylogr = query("select * from ".$Settings['sqltable']."members where `Name`='%s' AND `Password`='%s'", array($Name,$NewPassword));
diff --git a/inc/misc/functions.php b/inc/misc/functions.php
index 16c3f49..3b494d3 100644
--- a/inc/misc/functions.php
+++ b/inc/misc/functions.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: functions.php - Last Update: 06/26/2007 SVN 28 - Author: cooldude2k $
+    $FileInfo: functions.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="functions.php"||$File3Name=="/functions.php") {
@@ -198,13 +198,25 @@ $TCMonth = date("n",$timestamp);
 $TCDay = date("d",$timestamp);
 $TCYear = date("Y",$timestamp);
 unset($dstake); $dstake = null;
-if(!is_numeric($offset)) { $offset = 0; }
-if(!is_numeric($minoffset)) { $minoffset = 0; }
+if(!is_numeric($minoffset)) { $minoffset = "00"; }
+$ts_array = explode(":",$offset);
+if(count($ts_array)!=2) {
+	if(!isset($ts_array[0])) { $ts_array[0] = "0"; }
+	if(!isset($ts_array[1])) { $ts_array[1] = "00"; }
+	$offset = $ts_array[0].":".$ts_array[1]; }
+if(!is_numeric($ts_array[0])) { $ts_array[0] = "0"; }
+if($ts_array[0]>12) { $ts_array[0] = "12"; $offset = $ts_array[0].":".$ts_array[1]; }
+if($ts_array[0]<-12) { $ts_array[0] = "-12"; $offset = $ts_array[0].":".$ts_array[1]; }
+if(!is_numeric($ts_array[1])) { $ts_array[1] = "00"; }
+if($ts_array[1]>59) { $ts_array[1] = "59"; $offset = $ts_array[0].":".$ts_array[1]; }
+if($ts_array[1]<0) { $ts_array[1] = "00"; $offset = $ts_array[0].":".$ts_array[1]; }
+$tsa = array("offset" => $offset, "hour" => $ts_array[0], "minute" => $ts_array[1]);
+//$tsa['minute'] = $tsa['minute'] + $minoffset;
 if($dst!="on"&&$dst!="off") { $dst = "off"; }
 if($dst=="on") { if($dstake!="done") { 
-	$dstake = "done"; $offset = $offset+1; } }
-$TCHour = $TCHour + $offset;
-$TCMinute = $TCMinute + $minoffset;
+	$dstake = "done"; $tsa['hour'] = $tsa['hour']+1; } }
+$TCHour = $TCHour + $tsa['hour'];
+$TCMinute = $TCMinute + $tsa['minute'];
 return date($format,mktime($TCHour,$TCMinute,$TCSecond,$TCMonth,$TCDay,$TCYear)); }
 function TimeChange($format,$timestamp,$offset,$minoffset=null,$dst=null) {
 return GMTimeChange($format,$timestamp,$offset,$minoffset,$dst); }
@@ -221,12 +233,25 @@ function GMTimeGet($format,$offset,$minoffset=null,$dst=null) {
 	return GMTimeChange($format,GMTimeStamp(),$offset,$minoffset,$dst); }
 function GMTimeGetS($format,$offset,$minoffset=null,$dst=null) {
 unset($dstake); $dstake = null;
-if(!is_numeric($offset)) { $offset = 0; }
-if(!is_numeric($minoffset)) { $minoffset = 0; }
+if(!is_numeric($offset)) { $offset = "0"; }
+if(!is_numeric($minoffset)) { $minoffset = "00"; }
+$ts_array = explode(":",$offset);
+if(count($ts_array)!=2) {
+	if(!isset($ts_array[0])) { $ts_array[0] = "0"; }
+	if(!isset($ts_array[1])) { $ts_array[1] = "00"; }
+	$offset = $ts_array[0].":".$ts_array[1]; }
+if(!is_numeric($ts_array[0])) { $ts_array[0] = "0"; }
+if($ts_array[0]>12) { $ts_array[0] = "12"; $offset = $ts_array[0].":".$ts_array[1]; }
+if($ts_array[0]<-12) { $ts_array[0] = "-12"; $offset = $ts_array[0].":".$ts_array[1]; }
+if(!is_numeric($ts_array[1])) { $ts_array[1] = "00"; }
+if($ts_array[1]>59) { $ts_array[1] = "59"; $offset = $ts_array[0].":".$ts_array[1]; }
+if($ts_array[1]<0) { $ts_array[1] = "00"; $offset = $ts_array[0].":".$ts_array[1]; }
+$tsa = array("offset" => $offset, "hour" => $ts_array[0], "minute" => $ts_array[1]);
+//$tsa['minute'] = $tsa['minute'] + $minoffset;
 if($dst!="on"&&$dst!="off") { $dst = "off"; }
 if($dst=="on") { if($dstake!="done") { 
-	$dstake = "done"; $offset = $offset+1; } }
-return date($format,mktime(gmdate('h')+$offset,gmdate('i')+$minoffset,gmdate('s'),gmdate('n'),gmdate('j'),gmdate('Y'))); }
+	$dstake = "done"; $tsa['hour'] = $tsa['hour']+1; } }
+return date($format,mktime(gmdate('h')+$tsa['hour'],gmdate('i')+$tsa['minute'],gmdate('s'),gmdate('n'),gmdate('j'),gmdate('Y'))); }
 function GetSeverZone() {
 $TestHour1 = date("H");
 @putenv("OTZ=".@getenv("TZ"));
diff --git a/inc/misc/setcheck.php b/inc/misc/setcheck.php
index 5caa957..83b1995 100644
--- a/inc/misc/setcheck.php
+++ b/inc/misc/setcheck.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: setcheck.php - Last Update: 06/15/2007 SVN 24 - Author: cooldude2k $
+    $FileInfo: setcheck.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="setcheck.php"||$File3Name=="/setcheck.php") {
@@ -33,8 +33,6 @@ if($Settings['DefaultTheme']==null) {
 	$Settings['DefaultTheme'] = "iDB"; }
 if($Settings['DefaultTimeZone']==null) {
 	$Settings['DefaultTimeZone'] = SeverOffSet(null); }
-if(!is_numeric($Settings['DefaultTimeZone'])) {
-	$Settings['DefaultTimeZone'] = SeverOffSet(null); }
 if($Settings['DefaultDST']!="on"&&
 	$Settings['DefaultDST']!="off") { 
 	$Settings['DefaultDST'] = "off"; }
diff --git a/inc/profilemain.php b/inc/profilemain.php
index f031fce..919345d 100644
--- a/inc/profilemain.php
+++ b/inc/profilemain.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: profilemain.php - Last Update: 06/18/2007 SVN 26 - Author: cooldude2k $
+    $FileInfo: profilemain.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="profilemain.php"||$File3Name=="/profilemain.php") {
@@ -256,6 +256,8 @@ $num=mysql_num_rows($result);
 $i=0;
 $YourID=mysql_result($result,$i,"id");
 $User1TimeZone=mysql_result($result,$i,"TimeZone"); 
+$tsa_mem = explode(":",$User1TimeZone);
+$TimeZoneArray = array("offset" => $User1TimeZone, "hour" => $tsa_mem[0], "minute" => $tsa_mem[1]);
 $User1DST=mysql_result($result,$i,"DST");
 $settingsact = url_maker($exfile['profile'],$Settings['file_ext'],"act=settings",$Settings['qstr'],$Settings['qsep'],$prexqstr['profile'],$exqstr['profile']);
 $profiletitle = " ".$ThemeSet['TitleDivider']." Board Settings"; ?>
@@ -276,7 +278,7 @@ $profiletitle = " ".$ThemeSet['TitleDivider']." Board Settings"; ?>
 <tr style="text-align: left;">
 	<td style="width: 40%;"><label class="TextBoxLabel" for="YourOffSet">Your TimeZone:</label></td>
 	<td style="width: 60%;"><select id="YourOffSet" name="YourOffSet" class="TextBox">
-<option selected="selected" value="<?php echo $User1TimeZone; ?>">Old Value (<?php echo $User1TimeZone.":00 hours"; ?>)</option>
+<option selected="selected" value="<?php echo $TimeZoneArray['hour']; ?>">Old Value (<?php echo $TimeZoneArray['hour'].":00 hours"; ?>)</option>
 <?php
 $plusi = 1; $minusi = 12;
 $plusnum = 13; $minusnum = 0;
@@ -291,6 +293,18 @@ echo "<option value=\"".$plusi."\">GMT + ".$plusi.":00 hours</option>\n";
 ++$plusi; }
 ?></select></td>
 </tr><tr style="text-align: left;">
+	<td style="width: 40%;"><label class="TextBoxLabel" for="MinOffSet">Minute OffSet:</label></td>
+	<td style="width: 60%;"><select id="MinOffSet" name="MinOffSet" class="TextBox">
+<option selected="selected" value="<?php echo $TimeZoneArray['minute']; ?>">Old Value (<?php echo "0:".$TimeZoneArray['minute']." minutes"; ?>)</option>
+<?php
+$mini = 0; $minnum = 60;
+while ($mini < $minnum) {
+if(strlen($mini)==2) { $showmin = $mini; }
+if(strlen($mini)==1) { $showmin = "0".$mini; }
+echo "<option value=\"".$showmin."\">0:".$showmin." minutes</option>\n";
+++$mini; }
+?></select></td>
+</tr><tr style="text-align: left;">
 	<td style="width: 40%;"><label class="TextBoxLabel" for="skin">Pick a CSS Theme</label></td>
 	<td style="width: 60%;"><select id="skin" name="skin" class="TextBox">
 <option selected="selected" value="<?php echo $_SESSION['Theme']; ?>">Old Value (<?php echo $_SESSION['Theme']; ?>)</option><?php
@@ -340,6 +354,15 @@ if($_POST['act']=="settings"&&
 	$_SESSION['UserGroup']!=$Settings['GuestGroup']) {
 	$NewDay=GMTimeStamp();
 	$NewIP=$_SERVER['REMOTE_ADDR'];
+	if(!is_numeric($_POST['YourOffSet'])) { $_POST['YourOffSet'] = "0"; }
+	if($_POST['YourOffSet']>12) { $_POST['YourOffSet'] = "12"; }
+	if($_POST['YourOffSet']<-12) { $_POST['YourOffSet'] = "-12"; }
+	if(!is_numeric($_POST['MinOffSet'])) { $_POST['MinOffSet'] = "00"; }
+	if($_POST['MinOffSet']>59) { $_POST['MinOffSet'] = "59"; }
+	if($_POST['MinOffSet']<0) { $_POST['MinOffSet'] = "00"; }
+	$_POST['YourOffSet'] = $_POST['YourOffSet'].":".$_POST['MinOffSet'];
+	$_SESSION['UserTimeZone'] = $_POST['YourOffSet'];
+	$_SESSION['UserDST'] = $_POST['DST'];
 	$querynewskin = query("update ".$Settings['sqltable']."members set `UseTheme`='%s',`TimeZone`='%s',`DST`='%s',`LastActive`='%s',`IP`='%s' WHERE `id`=%i", array($_POST['skin'],$_POST['YourOffSet'],$_POST['DST'],$NewDay,$NewIP,$_SESSION['UserID']));
 	mysql_query($querynewskin); } } }
 if($_GET['act']=="profile") {
@@ -354,6 +377,8 @@ $User1Title=mysql_result($result,$i,"Title");
 $User1Website=mysql_result($result,$i,"Website"); 
 $User1Gender=mysql_result($result,$i,"Gender");
 $User1TimeZone=mysql_result($result,$i,"TimeZone"); 
+$tsa_mem = explode(":",$User1TimeZone);
+$TimeZoneArray = array("offset" => $User1TimeZone, "hour" => $tsa_mem[0], "minute" => $tsa_mem[1]);
 $User1DST=mysql_result($result,$i,"DST");
 $profileact = url_maker($exfile['profile'],$Settings['file_ext'],"act=profile",$Settings['qstr'],$Settings['qsep'],$prexqstr['profile'],$exqstr['profile']);
 $profiletitle = " ".$ThemeSet['TitleDivider']." Profile Editor";
@@ -384,7 +409,7 @@ $profiletitle = " ".$ThemeSet['TitleDivider']." Profile Editor";
 </tr><tr style="text-align: left;">
 	<td style="width: 40%;"><label class="TextBoxLabel" for="YourOffSet">Your TimeZone:</label></td>
 	<td style="width: 60%;"><select id="YourOffSet" name="YourOffSet" class="TextBox">
-<option selected="selected" value="<?php echo $User1TimeZone; ?>">Old Value (<?php echo $User1TimeZone.":00 hours"; ?>)</option>
+<option selected="selected" value="<?php echo $TimeZoneArray['hour']; ?>">Old Value (<?php echo $TimeZoneArray['hour'].":00 hours"; ?>)</option>
 <?php
 $plusi = 1; $minusi = 12;
 $plusnum = 13; $minusnum = 0;
@@ -399,6 +424,18 @@ echo "<option value=\"".$plusi."\">GMT + ".$plusi.":00 hours</option>\n";
 ++$plusi; }
 ?></select></td>
 </tr><tr style="text-align: left;">
+	<td style="width: 40%;"><label class="TextBoxLabel" for="MinOffSet">Minute OffSet:</label></td>
+	<td style="width: 60%;"><select id="MinOffSet" name="MinOffSet" class="TextBox">
+<option selected="selected" value="<?php echo $TimeZoneArray['minute']; ?>">Old Value (<?php echo "0:".$TimeZoneArray['minute']." minutes"; ?>)</option>
+<?php
+$mini = 0; $minnum = 60;
+while ($mini < $minnum) {
+if(strlen($mini)==2) { $showmin = $mini; }
+if(strlen($mini)==1) { $showmin = "0".$mini; }
+echo "<option value=\"".$showmin."\">0:".$showmin." minutes</option>\n";
+++$mini; }
+?></select></td>
+</tr><tr style="text-align: left;">
 	<td style="width: 40%;"><label class="TextBoxLabel" for="YourGender">Your Gender:</label></td>
 	<td style="width: 60%;"><select id="YourGender" name="YourGender" class="TextBox">
 <option selected="selected" value="<?php echo $User1Gender; ?>">Old Value (<?php echo $User1Gender; ?>)</option>
@@ -440,6 +477,13 @@ if($_POST['act']=="profile"&&
 	$_POST['Title'] = @remove_spaces($_POST['Title']);
 	$_POST['Website'] = htmlentities($_POST['Website'], ENT_QUOTES);
 	$_POST['Website'] = @remove_spaces($_POST['Website']);
+	if(!is_numeric($_POST['YourOffSet'])) { $_POST['YourOffSet'] = "0"; }
+	if($_POST['YourOffSet']>12) { $_POST['YourOffSet'] = "12"; }
+	if($_POST['YourOffSet']<-12) { $_POST['YourOffSet'] = "-12"; }
+	if(!is_numeric($_POST['MinOffSet'])) { $_POST['MinOffSet'] = "00"; }
+	if($_POST['MinOffSet']>59) { $_POST['MinOffSet'] = "59"; }
+	if($_POST['MinOffSet']<0) { $_POST['MinOffSet'] = "00"; }
+	$_POST['YourOffSet'] = $_POST['YourOffSet'].":".$_POST['MinOffSet'];
 	$_SESSION['UserTimeZone'] = $_POST['YourOffSet'];
 	$_SESSION['UserDST'] = $_POST['DST'];
 	$NewDay=GMTimeStamp();
diff --git a/mysql.php b/mysql.php
index 84a256f..9652af5 100644
--- a/mysql.php
+++ b/mysql.php
@@ -11,7 +11,7 @@
     Copyright 2004-2007 Cool Dude 2k - http://intdb.sourceforge.net/
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
 
-    $FileInfo: mysql.php - Last Update: 06/18/2007 SVN 26 - Author: cooldude2k $
+    $FileInfo: mysql.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 @error_reporting(E_ALL ^ E_NOTICE);
 @ini_set('session.use_trans_sid', false);
@@ -123,16 +123,23 @@ if(!isset($_SESSION['UserGroup'])) { $_SESSION['UserGroup'] = null; }
 if($_SESSION['UserGroup']==null) { 
 $_SESSION['UserGroup']=$Settings['GuestGroup']; }
 //Time Zone Set
-if(!isset($_SESSION['UserTimeZone'])) { $_SESSION['UserTimeZone'] = null; }
-if($_SESSION['UserTimeZone']==null||
-	!is_numeric($_SESSION['UserTimeZone'])) {
-	if($Settings['DefaultTimeZone']!=null&&
-	is_numeric($Settings['DefaultTimeZone'])) {
-	$_SESSION['UserTimeZone'] = $Settings['DefaultTimeZone']; }
-	if($Settings['DefaultTimeZone']==null) {
-	$_SESSION['UserTimeZone'] = SeverOffSet(); }
-	if(!is_numeric($Settings['DefaultTimeZone'])) {
-	$_SESSION['UserTimeZone'] = SeverOffSet(); } }
+if(!isset($_SESSION['UserTimeZone'])) { 
+	if(isset($Settings['DefaultTimeZone'])) { 
+	$_SESSION['UserTimeZone'] = $Settings['DefaultTimeZone'];
+	if(!isset($Settings['DefaultTimeZone'])) { 
+	$_SESSION['UserTimeZone'] = SeverOffSet().":00"; } } }
+$checktime = explode(":",$_SESSION['UserTimeZone']);
+if(count($checktime)!=2) {
+	if(!isset($checktime[0])) { $checktime[0] = "0"; }
+	if(!isset($checktime[1])) { $checktime[1] = "00"; }
+	$_SESSION['UserTimeZone'] = $checktime[0].":".$checktime[1]; }
+if(!is_numeric($checktime[0])) { $checktime[0] = "0"; }
+if($checktime[0]>12) { $checktime[0] = "12"; $_SESSION['UserTimeZone'] = $checktime[0].":".$checktime[1]; }
+if($checktime[0]<-12) { $checktime[0] = "-12"; $_SESSION['UserTimeZone'] = $checktime[0].":".$checktime[1]; }
+if(!is_numeric($checktime[1])) { $checktime[1] = "00"; }
+if($checktime[1]>59) { $checktime[1] = "59"; $_SESSION['UserTimeZone'] = $checktime[0].":".$checktime[1]; }
+if($checktime[1]<0) { $checktime[1] = "00"; $_SESSION['UserTimeZone'] = $checktime[0].":".$checktime[1]; }
+$checktimea = array("offset" => $_SESSION['UserTimeZone'], "hour" => $checktime[0], "minute" => $checktime[1]);
 if(!isset($_SESSION['UserDST'])) { $_SESSION['UserDST'] = null; }
 if($_SESSION['UserDST']==null) {
 if($Settings['DefaultDST']=="off") { 
diff --git a/setup/mkconfig.php b/setup/mkconfig.php
index 617fdfb..2680d54 100644
--- a/setup/mkconfig.php
+++ b/setup/mkconfig.php
@@ -12,7 +12,7 @@
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
     iDB Installer made by Game Maker 2k - http://idb.berlios.net/
 
-    $FileInfo: mkconfig.php - Last Update: 06/18/2007 SVN 26 - Author: cooldude2k $
+    $FileInfo: mkconfig.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="mkconfig.php"||$File3Name=="/mkconfig.php") {
@@ -88,7 +88,13 @@ $query = "INSERT INTO ".$_POST['tableprefix']."tagboard VALUES (1,-1,'Cool Dude
 */
 $query = "INSERT INTO ".$_POST['tableprefix']."categories VALUES (1,'Main','yes','category','yes',0,'The Main Category.')";
 mysql_query($query);
-$YourOffSet = $_POST['YourOffSet'];
+if(!is_numeric($_POST['YourOffSet'])) { $_POST['YourOffSet'] = "0"; }
+if($_POST['YourOffSet']>12) { $_POST['YourOffSet'] = "12"; }
+if($_POST['YourOffSet']<-12) { $_POST['YourOffSet'] = "-12"; }
+if(!is_numeric($_POST['MinOffSet'])) { $_POST['MinOffSet'] = "00"; }
+if($_POST['MinOffSet']>59) { $_POST['MinOffSet'] = "59"; }
+if($_POST['MinOffSet']<0) { $_POST['MinOffSet'] = "00"; }
+$YourOffSet = $_POST['YourOffSet'].":".$_POST['MinOffSet'];
 $AdminDST = $_POST['DST'];
 $MyDay = GMTimeGet("d",$YourOffSet,0,$AdminDST);
 $MyMonth = GMTimeGet("m",$YourOffSet,0,$AdminDST);
@@ -109,7 +115,7 @@ $YourWebsite = "http://".$_SERVER['HTTP_HOST'].$this_dir."index.php?act=view";
 $UserIP = $_SERVER['REMOTE_ADDR'];
 $PostCount = 2;
 $Email = "admin@".$_SERVER['HTTP_HOST'];
-$AdminTime = $_POST['YourOffSet'];
+$AdminTime = $_POST['YourOffSet'].":".$_POST['MinOffSet'];
 $GEmail = "guest@".$_SERVER['HTTP_HOST'];
 $grand = rand(6,16); $i = 0; $gpass = "";
 while ($i < $grand) {
diff --git a/setup/setup.php b/setup/setup.php
index 1a03a9b..6d41446 100644
--- a/setup/setup.php
+++ b/setup/setup.php
@@ -12,7 +12,7 @@
     Copyright 2004-2007 Game Maker 2k - http://upload.idb.s1.jcink.com/
     iDB Installer made by Game Maker 2k - http://idb.berlios.net/
 
-    $FileInfo: setup.php - Last Update: 06/26/2007 SVN 28 - Author: cooldude2k $
+    $FileInfo: setup.php - Last Update: 06/27/2007 SVN 29 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="setup.php"||$File3Name=="/setup.php") {
@@ -140,6 +140,19 @@ echo "<option value=\"".$plusi."\">GMT + ".$plusi.":00 hours</option>\n"; }
 ++$plusi; }
 ?></select></td>
 </tr><tr>
+	<td style="width: 50%;"><label class="TextBoxLabel" for="MinOffSet">Minute OffSet:</label></td>
+	<td style="width: 50%;"><select id="MinOffSet" name="MinOffSet" class="TextBox"><?php
+$mini = 0; $minnum = 60;
+while ($mini < $minnum) {
+if(strlen($mini)==2) { $showmin = $mini; }
+if(strlen($mini)==1) { $showmin = "0".$mini; }
+if($mini==0) {
+echo "\n<option selected=\"selected\" value=\"".$showmin."\">0:".$showmin." minutes</option>\n"; }
+if($mini!=0) {
+echo "<option value=\"".$showmin."\">0:".$showmin." minutes</option>\n"; }
+++$mini; }
+?></select></td>
+</tr><tr>
 	<td style="width: 50%;"><label class="TextBoxLabel" for="DST">Is <span title="Daylight Savings Time">DST</span> / <span title="Summer Time">ST</span> on or off:</label></td>
 	<td style="width: 50%;"><select id="DST" name="DST" class="TextBox"><?php echo "\n" ?>
 <?php if($mydstime=="off"||$mydstime!="on") { ?>
-- 
2.11.0