Last X threads in forumhome for a specific forum {Version 2.9}

Description::.

This hack Shows last X threads for a specific forum in forumhome
Requested By Allan

[Hack Features::.

1-easy yo install
2-admin Controllable
Version 2.5

3-Now you have 3 columns
4-every column is controllable
5-for every coloumn you have three options

1.ON/OFF
2.Forum ID You Can put more than one forum id by puting id then , then id eg:1,2
3.Forum Name

6-When You Put the mouse on any thread an alt views with

1.Posted By
2.Last Rebly By
3.Replies
4.Views
5.# of Attachment

Admin Controllable

From vBulletin Options ==> vBulletin Options ==> Last X threads in forumhome for a specific forum(s).]

Installation::.

1-Import The Product.
2-Edit template FORUMHOME
find:

$navbar

add below:

<if condition="$vboptions[endislastx]">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
	<tr>
		<td class="tcat">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('developer')"><img id="collapseimg_developer" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_developer].gif" alt="" border="0" /></a>
			<img border="0" src="$stylevar[imgdir_misc]/subscribed_event.gif"> $vbphrase[ltff]$forumnamedevel
		</td>
	</tr>
</thead>
<tbody id="collapseobj_developer" style="$vbcollapse[collapseobj_developer]">
	<tr>
		<td class="alt1">
			<table width='100%' cellspacing="0" border="0">
<tr>
		<if condition="$vboptions[endislastx1]"><td width="33%" align="left"><img border="0" src="$stylevar[imgdir_misc]/sticky.gif"> $vbphrase[ltfff]$forumnamedevel1</td></if>
		<if condition="$vboptions[endislastx2]"><td width="33%" align="left"><img border="0" src="$stylevar[imgdir_misc]/sticky.gif"> $vbphrase[ltfff]$forumnamedevel2</td></if>
		<if condition="$vboptions[endislastx3]"><td width="33%" align="left"><img border="0" src="$stylevar[imgdir_misc]/sticky.gif"> $vbphrase[ltfff]$forumnamedevel3</td></if>
	</tr>
	<tr>
		<if condition="$vboptions[endislastx1]"><td width="33%" align="left">$lastxdevelt1</td></if>
		<if condition="$vboptions[endislastx2]"><td width="33%" align="left">$lastxdevelt2</td></if>
		<if condition="$vboptions[endislastx3]"><td width="33%" align="left">$lastxdevelt3</td></if>
	</tr>
</table>
		</td>
	</tr>
</tbody>
</table><br></if>

History::.

1.0 On 30. Jan 2006 Initial Version.
2.5 On 31. Jan 2006 Fix On/Off the hack add many features(see features)
2.7 On 9. Feb 2006 Now You Can put more than one forum id by puting id then , then id eg:1,2
2.8 On 13. Feb 2006 Column 3 Font Size Fixed
2.9 On 21. Mar 2006 Add Max Title Characters Length.
3.0 On 8. Apr 2006 Add setting for order by:dateline,lastpost time

Hack Languages

allan Had translate the hack to french. here
Hellraider Had translate the hack to german. here

Details

3 plugins , 21 phrases , 13 options , 3 Queries
NOTE:If you won't use any of the columns except 1 or 2 column, disable the unused column because it's uses a query

Donation::.

Feel Free To

aT lAsT

IF YOu lIkE iT cLIcK InsTall

Support Given For Who Clicked Install {ONLY}

[MarsNIIT]

Yes, i have try, but have error when import

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO marsniit_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'endislastx',
'lastxtdevel',
'1',
'',
'',
'yesno',
10,
0,
1,
'lasxtdevel2'
),
(
'endislastx1',
'lastxtdevel',
'1',
'',
'',
'yesno',
20,
0,
1,
'lasxtdevel2'
),
(
'lastxforumid1',
'lastxtdevel',
'209,210,211,51,86,80,81,82,83,146,147,84,85,148,4 9,26,27,28,241,14,59,15,60,16,17,18,19,20,25,57,16 9,23,69,21,171,24,170,58,22',
'2',
'numeric',
'',
30,
0,
1,
'lasxtdevel2'
),
(
'lastxlimit1',
'lastxtdevel',
'10',
'10',
'numeric',
'',
40,
0,
1,
'lasxtdevel2'
),
(
'forumnamedevel1',
'lastxtdevel',
'<b><a href=\"/forumdisplay.php?f=62\"><span style=\"color: Red; font-size: 14px;\"> V.N.S.A</span></a></b> <img src=\"/images/ABC/SugarwareZ-091.gif\" border=\"0\">',
'Main Forum',
'free',
'',
50,
0,
1,
'lasxtdevel2'
),
(
'endislastx2',
'lastxtdevel',
'1',
'',
'',
'yesno',
60,
0,
1,
'lasxtdevel2'
),
(
'lastxforumid2',
'lastxtdevel',
'104,48,76,217,216,74,65,66,68,67,75,215,218,219,2 20,221,222,223,63,247,246,248,249,250,244,245,71,6 4,73,243,70,72,65',
'3',
'numeric',
'',
70,
0,
1,
'lasxtdevel2'
),
(
'lastxlimit2',
'lastxtdevel',
'10',
'10',
'numeric',
'',
80,
0,
1,
'lasxtdevel2'
),
(
'forumnamedevel2',
'lastxtdevel',
'<b><a href=\"/forumdisplay-f_212.html\"><span style=\"color: Red; font-size: 14px;\"> SHARE ZONE</span></a></b> <img src=\"/images/ABC/SugarwareZ-118.gif\" border=\"0\">',
'Sub Forum',
'free',
'',
90,
0,
1,
'lasxtdevel2'
),
(
'endislastx3',
'lastxtdevel',
'1',
'',
'',
'yesno',
100,
0,
1,
'lasxtdevel2'
),
(
'lastxforumid3',
'lastxtdevel',
'174,175,176,188,228,189,190,227,230,192,193,194,1 95,202,203,204,205,206,178,196,179,231,181,182,184 ,185,186,118,121,122,123,124,125,119,126,127,128,1 29,130,137,120,226,131,132,199,133,134,135,117,838 ,262,263,264,265,839,267,836',
'4',
'numeric',
'',
110,
0,
1,
'lasxtdevel2'
),
(
'lastxlimit3',
'lastxtdevel',
'10',
'10',
'numeric',
'',
120,
0,
1,
'lasxtdevel2'
),
(
'forumnamedevel3',
'lastxtdevel',
'<b><a href=\"/forumdisplay.php?f=114\"><span style=\"color: Red; font-size: 14px;\"> TEENS ZONE</span></a></b> <img src=\"/images/ABC/SugarwareZ-014.gif\" border=\"0\">',
'New Forum',
'free',
'',
130,
0,
1,
'lasxtdevel2'
),
(
'devel_copyright1',
'lastxtdevel',
'History::\r\n 1.0 On 30. Jan 2006 Initial Version.<br>\r\n 2.5 On 31. Jan 2006 Fix On/Off the hack add many features(see features)<br>\r\n2.7 On 9. Feb 2006 Now You Can put more than one forum id by puting id the , then id eg:1,2',
'History::\r\n 1.0 On 30. Jan 2006 Initial Version.<br>\r\n 2.5 On 31. Jan 2006 Fix On/Off the hack add many features(see features)<br>\r\n2.7 On 9. Feb 2006 Now You Can put more than one forum id by puting id the , then id eg:1,2',
'free',
'History::\r\n 1.0 On 30. Jan 2006 Initial Version.<br>\r\n 2.5 On 31. Jan 2006 Fix On/Off the hack add many features(see features)<br>\r\n2.7 On 9. Feb 2006 Now You Can put more than one forum id by puting id the , then id eg:1,2',
140,
0,
1,
'lasxtdevel2'
);

MySQL Error : Duplicate entry 'endislastx' for key 1
Error Number : 1062
Date : Friday, February 10th 2006 @ 11:50:03 PM
Script : http://2it.in/x_AdminCP/plugin.php
Referrer : http://2it.in/x_AdminCP/plugin.php?do=productadd
IP Address : 58.186.118.139
Username : MarsNIIT
Classname : vB_Database

[Developer]

sorry for this i'll attach the right product for forum display

[Developer]

attached

[MarsNIIT]

Thank you verry much, all thing fine now

[Gizmo5h1t3]

so does the file attrached in post #93 now get it working on both forumhome, and forumdisplay??

[Developer]

Originally Posted by Gizmo5h1t3

so does the file attrached in post #93 now get it working on both forumhome, and forumdisplay??

you have to import the 2 product in posts 1,93

[MarsNIIT]

Seem it only display new theard, old theard with new reply can't display??

[Developer]

yes, not latest active threads

[Gizmo5h1t3]

Originally Posted by Developer

you have to import the 2 product in posts 1,93

thanks for that mate, works a treat now....

[lexx27]

For some reason column three has bigger font size? Any idea?