 | [Solved] What does [ IN-LINE INSERT ] mean ? |  |
 Posted: 05/25/2007 4:32 AM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 10:30 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
| Code:
|
##############################################################
## Title: "The Time Here Is" Hack
## Author: Kai <kai@winternightex.com>
## www.winternightex.com
## Kai WT on phpbbhacks.com
##
## 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:
## viewtopic.php
## templates/subSilver/viewtopic_body.tpl
##
## Included Files:
## none
##
## 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 ]------------------------------------------
#
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
$limit_posts_time
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];
#
#-----[ IN-LINE INSERT ]------------------------------------------
#
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from,
--> u.user_timezone,
u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
$limit_posts_time
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];
#
#-----[ FIND ]------------------------------------------
#
$poster_joined = ( $postrow[$i]['user_id'] != ANONYMOUS ) ? $lang['Joined'] . ': ' . create_date($lang['DATE_FORMAT'], $postrow[$i]['user_regdate'], $board_config['board_timezone']) : '';
#
#-----[ 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 ]------------------------------------------
#
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}</span><br /></td>
#
#-----[ IN-LINE INSERT ]------------------------------------------
#
<td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a><b>{postrow.POSTER_NAME}</b></span><br /><span class="postdetails">{postrow.POSTER_RANK}<br />{postrow.RANK_IMAGE}{postrow.POSTER_AVATAR}<br /><br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}
--><br /><br/>The Time Here Is: {postrow.POSTER_TIME}
</span><br/></td>
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# End
|
I'm not sure what the command is...?
I installed this mod the other week but I couldn't get it to work properly I think it's because of not following the IN-LINE INSERT command properly |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 6:00 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 1:30 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
I have heard this
and than
commands so it might be some mistake in the MOD script  |
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 7:49 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 9:30 AM
|
|
|
|
|
|
I think it means add the code in the same line (not a new line)
At the end maybe? |
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 3:15 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:30 AM
Location: St Pete, FL
|
|
|
|
|
|
This MOD author didn't know how to write a MOD script. This is the EM Friendly version of the MOD, which is totally untested...
The_Time_Here_Is_102.zip
| Code:
|
##############################################################
## 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
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 3:26 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 9:30 AM
|
|
|
|
|
|
Looks like a god mod, I might add theat myself  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 3:50 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 10:30 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Cheers Nightrider, I just changed the "This Is The Time" to Local time same as yours! Apart from that the mod works fine thanks  |
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 3:56 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:30 AM
Location: St Pete, FL
|
|
|
|
|
|
If you look to the left of everyone's message, you will see that we have a similar MOD installed here too...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 3:59 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:30 AM
Location: St Pete, FL
|
|
|
|
|
|
| Chris Powell wrote:
|
|
Cheers Nightrider, I just changed the "This Is The Time" to Local time same as yours! Apart from that the mod works fine thanks
|
Excellent. I figured it would install but how it worked afterwards, I wasn't sure of. I'm glad it works as advertised...
|
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 4:05 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 9:30 AM
|
|
|
|
|
|
| Nightrider wrote:
|
If you look to the left of everyone's message, you will see that we have a similar MOD installed here too...
|
 I never noticed! Ooh so what you having for tea then?  |
|
|
|
|
| Back to Top |
|
|
| Re: What does [ IN-LINE INSERT ] mean ? | |
| Posted: 05/25/2007 4:08 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:30 AM
Location: St Pete, FL
|
|
|
|
|
|
I'm not a tea drinker but I would go out for a Coke with you...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
