########################################################
##
## Hack Title:		Personal Date- & Timeformat
## Hack Version:	1.0.0
## Author:		Christoph "Toxic" Hellings (toxic@freenet.de)
## Date Created:	08-31-02
## Thread Location:	http://www.tforumhacks.com/tforum/viewtopic.php?TopicID=1076
## Working Example:	
## Description:		Users can choose how Dates and Times are displayed
##			
##			
## Installation Level:	Intermediate
## Installation Time:	10 Minutes
## Files To Edit:	4
## Edit Database:	yes
## Included Files:	none
##
########################################################
## 
## Installation/Author Notes:
##
##	I think it works but no warranty...
##	To change the default date/time format, always type your 
##	date format where i have 'm-d-y' or 'h:i A'
##
########################################################
#
#-----[ ACTION: BACKUP ]------------------------------------------
#
	Every time you edit your files, you should always back them
	up first. Although all of these hacks have been tested on various
	systems, they may not work with your configuration or you may not
	like what it does. Backing up protects yourself and your users
	from downtime.
#
#-----[ ACTION:  EDIT DATABASE ]----------------------------------
#
ALTER TABLE t_users ADD dateformat TINYTEXT NOT NULL;
ALTER TABLE t_users ADD timeformat TINYTEXT NOT NULL;
UPDATE t_users SET dateformat = 'm-d-y';
UPDATE t_users SET timeformat = 'h:i A';
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	forum_template.php
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function PrintRegForm()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
					<option value="13">GMT +13</option>
				</select>
		</td>
	</tr>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
  <tr>
    <td align="left" width="240" nowrap bgcolor="<?echo $fSettings["msg_backcolor"]?>"><b><?echo $txt['dateformat']?>:</b></td>
    <td align="left" width="100%" bgcolor="<?echo $fSettings["msg_backcolor"]?>"><input type="text" name="dateformat" size=25 maxlength=15 value="m-d-Y"></td>
  </tr>
  <tr>
    <td align="left" width="240" nowrap bgcolor="<?echo $fSettings["msg_backcolor"]?>"><b><?echo $txt['timeformat']?>:</b></td>
    <td align="left" width="100%" bgcolor="<?echo $fSettings["msg_backcolor"]?>"><input type="text" name="timeformat" size=25 maxlength=15 value="h:i A"></td>
  </tr>
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function PrintEditProfile()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
					<option value="13" <?if ($UserInfo["timezone"] == 13) {echo "selected";}?>>GMT +13</option>
				</select>
		</td>
	</tr>
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
	<tr>
		<td align="left" width="240" nowrap bgcolor="<?echo $fSettings["msg_backcolor"]?>"><b><?echo $txt['dateformat']?>:</b></td>
		<td align="left" width="100%" bgcolor="<?echo $fSettings["msg_backcolor"]?>"><input type="text" name="dateformat" value="<?echo $UserInfo["dateformat"]?>" size=25 maxlength=15></td>
	</tr>
	<tr>
		<td align="left" width="240" nowrap bgcolor="<?echo $fSettings["msg_backcolor"]?>"><b><?echo $txt['timeformat']?>:</b></td>
		<td align="left" width="100%" bgcolor="<?echo $fSettings["msg_backcolor"]?>"><input type="text" name="timeformat" value="<?echo $UserInfo["timeformat"]?>" size=25 maxlength=15></td>
	</tr>
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	functions.php
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
function FormatDate($timestamp,$timezone)
{	if ($timezone)
		$timeoffset = $timezone*3600;
	$timestamp = $timestamp+$timeoffset;
	$FormatDate = gmdate("m-d-Y",$timestamp);
	return $FormatDate;
}

function FormatTime($timestamp,$timezone)
{	if ($timezone)
		$timeoffset = $timezone*3600;
	$timestamp += $timeoffset;
	$FormatTime = gmdate("h:i A",$timestamp);
	return $FormatTime;
}
#
#-----[ ACTION:  REPLACE ]-----------------------------------------
#
function FormatDate($timestamp,$timezone)
{	global $CurrentUserInfo;
	$dateformat = "d.m.y";
	if ($CurrentUserInfo["dateformat"]) $dateformat = $CurrentUserInfo["dateformat"];
	if ($timezone)
		$timeoffset = $timezone*3600;
	$timestamp += $timeoffset;
	$FormatDate = gmdate($dateformat,$timestamp);
	return $FormatDate;
}

function FormatTime($timestamp,$timezone)
{	global $CurrentUserInfo;
	$timeformat = "H:i";
	if ($CurrentUserInfo["timeformat"]) $timeformat = $CurrentUserInfo["timeformat"];
	if ($timezone)
		$timeoffset = $timezone*3600;
	$timestamp += $timeoffset;
	$FormatTime = gmdate($timeformat,$timestamp);
	return $FormatTime;
}
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
		$UserInfo["timezone"] = $row["timezone"];
#
#-----[ ACTION:  ADD AFTER ]--------------------------------------
#
		$UserInfo["dateformat"] = $row["dateformat"];
		$UserInfo["timeformat"] = $row["timeformat"];
#
#-----[ ACTION:  OPEN ]-------------------------------------------
#
	member.php
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function AddMember()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
{	global $username,$password,$email,$homepage,$country,$icqnumber,$aolhandle,$msnhandle,$yahoohandle,$signature,$savepass,$timezone,$avatar;
#
#-----[ ACTION:  REPLACE ]-----------------------------------------
#
{	global $username,$password,$email,$homepage,$country,$icqnumber,$aolhandle,$msnhandle,$yahoohandle,$signature,$savepass,$timezone,$dateformat,$timeformat,$avatar;
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	$query = "INSERT INTO t_users (UserName,Password,Email,Homepage,Country,ICQNumber,YahooHandle,MSNHandle,AOLHandle,Signature,NumPost,RegDate,SavePass,timezone,Avatar) ";
	$query .= "VALUES('".AddSlash($username)."','$password','$email','$homepage','$country','$icqnumber','$yahoohandle','$msnhandle','$aolhandle','$signature',0,UNIX_TIMESTAMP(),'$savepass','$timezone','$avatar')";
#
#-----[ ACTION:  REPLACE ]-----------------------------------------
#
	$query = "INSERT INTO t_users (UserName,Password,Email,Homepage,Country,ICQNumber,YahooHandle,MSNHandle,AOLHandle,Signature,NumPost,RegDate,SavePass,timezone,dateformat,timeformat,Avatar) ";
	$query .= "VALUES('".AddSlash($username)."','$password','$email','$homepage','$country','$icqnumber','$yahoohandle','$msnhandle','$aolhandle','$signature',0,UNIX_TIMESTAMP(),'$savepass','$timezone','$dateformat','$timeformat','$avatar')";
#
#-----[ ACTION:  LOCATE ]-----------------------------------------
#
	function EditProfile()
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
{	global $username,$password,$newpassword,$email,$homepage,$icqnumber,$aolhandle,$yahoohandle,$signature,$savepass,$txt,$timezone,$country,$msnhandle,$avatar;
#
#-----[ ACTION:  REPLACE ]-----------------------------------------
#
{	global $username,$password,$newpassword,$email,$homepage,$icqnumber,$aolhandle,$yahoohandle,$signature,$savepass,$txt,$timezone,$country,$msnhandle,$dateformat,$timeformat,$avatar;
#
#-----[ ACTION:  FIND ]-------------------------------------------
#
	if ($newpassword)
		$query = "UPDATE t_users SET Password='$newpassword',Email='$email',Homepage='$homepage',Country='$country',ICQNumber='$icqnumber',YahooHandle='$yahoohandle',MSNHandle='$msnhandle',AOLHandle='$aolhandle',Signature='$signature',SavePass='$savepass',timezone='$timezone',Avatar='$avatar' WHERE ID = '$ID'";
	else
		$query = "UPDATE t_users SET Email='$email',Homepage='$homepage',Country='$country',ICQNumber='$icqnumber',YahooHandle='$yahoohandle',MSNHandle='$msnhandle',AOLHandle='$aolhandle',Signature='$signature',SavePass='$savepass',timezone='$timezone',Avatar='$avatar' WHERE ID = '$ID'";
#
#-----[ ACTION:  REPLACE ]-----------------------------------------
#
	if ($newpassword)
		$query = "UPDATE t_users SET Password='$newpassword',Email='$email',Homepage='$homepage',Country='$country',ICQNumber='$icqnumber',YahooHandle='$yahoohandle',MSNHandle='$msnhandle',AOLHandle='$aolhandle',Signature='$signature',SavePass='$savepass',timezone='$timezone',dateformat='$dateformat',timeformat='$timeformat',Avatar='$avatar' WHERE ID = '$ID'";
	else
		$query = "UPDATE t_users SET Email='$email',Homepage='$homepage',Country='$country',ICQNumber='$icqnumber',YahooHandle='$yahoohandle',MSNHandle='$msnhandle',AOLHandle='$aolhandle',Signature='$signature',SavePass='$savepass',timezone='$timezone',dateformat='$dateformat',timeformat='$timeformat',Avatar='$avatar' WHERE ID = '$ID'";
#
#-----[ ACTION:  OPEN ]--------------------------------------------
#
	english_lg.php
#
#-----[ ACTION:  FIND ]--------------------------------------------
#
$txt['selecttime'] = "Time Zone";
#
#-----[ ACTION:  ADD AFTER ]-----------------------------------------
#
$txt['dateformat'] = "Date format";
$txt['timeformat'] = "Time format";
#
#-----[ ACTION: SAVE & UPLOAD ]-----------------------------------
#
	forum_template.php
	functions.php
	member.php
	english_lg.php
#
#-----------------------------------------------------------------
#
EOF