############################################################## 
## MOD Title: "The Time Here Is" Hack - EM Friendly
## MOD Author: Kai <kai@winternightex.com> (Kai WT on phpbbhacks.com ) www.winternightex.com
## MOD Description: This hack adds a line in the poster block stating the 
##     				current time in the users timezone based on the 
##    				selection they made in their profile.   
## 
## Version History: 
##    1.0.2 - Current version.  Grammar corrections. 
##    1.0.1 - Semantics changes for 2.0.4 
##    1.0.0 - Initial version. 
## 
## Installation Level: Easy 
## 
## Verified Compatability: 
##    2.0.0 to 2.0.13 
## 
## Files To Edit: 2
##    viewtopic.php 
##    templates/subSilver/viewtopic_body.tpl 
## 
## Included Files: none 
## 
############################################################## 
## Author Notes: 
##    none 
############################################################## 
## Please Check: 
## http://www.phpbbhacks.com 
## http://www.204art.com/item.php?galleryid=2 
## 
## for support and the latest version of this hack 
############################################################## 
## ALWAYS back up all files to be edited before starting installation! 
############################################################## 
# 
#-----[ OPEN ]------------------------------------------ 
# 
viewtopic.php 
# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "SELECT u.username, u.user_id, u.user_posts,
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
u.user_from, 
# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
u.user_timezone, 
# 
#-----[ FIND ]------------------------------------------ 
# 
$poster_joined = ( 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
   //*************Time Here Is Hack *************************** 
   $poster_time = @gmdate("g:i a", time() + (3600 * $postrow[$i]['user_timezone'])); 
   //*************Time Here Is Hack *************************** 
# 
#-----[ FIND ]------------------------------------------ 
# 
'POSTER_JOINED' => $poster_joined, 
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
      //*********Time Here Is Hack*********** 
      'POSTER_TIME' => $poster_time, 
      //*********Time Here Is Hack*********** 
# 
#-----[ OPEN ]------------------------------------------ 
# 
templates/subSilver/viewtopic_body.tpl 
# 
#-----[ FIND ]------------------------------------------ 
# 
{postrow.POSTER_FROM} 
# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
{postrow.POSTER_FROM} 

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
<br /><br/>The Time Here Is: {postrow.POSTER_TIME} 
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM