Forum Home Enhancements - Cyb - Last Post Info Enhancements

Info:
This will enable you to show several latest posts for selected forums instead of standard last post info. Number of latest posts is set for each forum separately in Forum Manager. Be noted that this executes 1 new query on forumhome/forumdisplay per forum where you choose to show 2 or more latest posts. In combination with "Cyb - Sub-Forum Manager" this can really improve your forum listing look.


Installation:
-Import XML file (as product) through AdminCP: Plugin System > Manage Products > [Add/Import Product]


To set options:
Go to: vBulletin Options > Cyb - Last Post Info Enhancements


Versions:
v1.0 - Sep 01. 2007.
-Initial release
v1.1 - Sep 11. 2007.
-Fixed bug with last poster username linking
v1.2 - May 03. 2008.
-Compatible with vBulletin 3.7
v1.3 - May 27. 2009.
-Fixed bug: Redirects with the wrong links shown in thread list
-Fixed bug: Trying to display thread icon even when it's disabled
-New: Integration with 'Cyb - Advanced Permissions Based on Post Count'
-Minor bugs fixed


LIVE DEMO:
http://www.bihforum.com


Mark as INSTALLED to get updates and support.

[Valter]

You mean username or Thread title?

Usernames are not trimmed, and titles are trimmed as they are without this product.

Forum Listings Display Options > Last Thread Title Maximum Displayed Characters

[lange]

Originally Posted by Cybernetec

You mean username or Thread title?

Usernames are not trimmed, and titles are trimmed as they are without this product.

Forum Listings Display Options > Last Thread Title Maximum Displayed Characters

Yes. I mean Username. Username are not trimmed.

[Valter]

You can not trim usernames with the current version and it's not planned to add such feature. vBulletin's LastPostInfo also does not do this.

[Skydiver10]

Thanks for this mod! Awesome addition to the: Cyb - Sub-Forum Manager

[iyama]

Port to vb4?

[carubmun]

Originally Posted by iyama

Port to vb4?

That would be awesome.

[iyama]

Originally Posted by carubmun

That would be awesome.

+1 :up:

[Valter]

Updated for vB4:
https://vborg.vbsupport.ru/showthread.php?t=239944

[Alfa1]

Originally Posted by Valter

Be noted that this executes 1 new query on forumhome/forumdisplay per forum where you choose to show 2 or more latest posts.

This is causing 20 queries on my forum index. Some of them take 0.01 seconds, others take 0.1 - 0.2 seconds. This is too much for my busy board.
I had to turn this off, but its a shame, because my users and I really like this enhancement.
Isnt there any way to reduce queries and loading time?

[GoD2.0]

For big forum at one point it runs an absolutely strupid query, that blocks forum loading. In my case the query left joined tread and user on username and lastposter respectively, wich caused mysql to do " Copying to tmp table " on and on. Here is an example of such a query:

SELECT thread.forumid, thread.threadid, thread.title, thread.lastpost, thread.lastpostid, thread.lastposter, thread.iconid, user.userid
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON ( user.username = thread.lastposter )
WHERE threadid >0
AND visible =1
AND OPEN !=10
AND forumid
IN ( 395, 741, 4948, 742, 1866, 743, 744, 4919, 745, 746, 4949, 750, 4950, 1865, 4951, 1864, 4920, 4947, 2739, 2740, 2741, 2742, 2743, 2744, 2745, 2885, 2747, 2746, 2762, 2883, 2748, 3265, 2884, 2886, 2887, 2749, 4621, 4622, 4623, 4624, 4625, 4627, 4626, 4628, 4630, 4631, 4629, 4633, 4635, 9, 430, 874, 49, 2325, 876, 877, 2307, 54, 875, 50, 52, 51, 53, 727, 2308, 55, 2309, 2310, 878, 2326, 5427, 5428, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5436, 5437, 5438, 5439, 5273, 5274, 5275, 5276, 5402, 5277, 5278, 5279, 5280, 5281, 5282, 5283, 5284, 4386, 4387, 4388, 4389, 4390, 4391, 4414, 4392, 4393, 4394, 4395, 4396, 4397, 4398, 2443, 2444, 2445, 2446, 2447, 2448, 2449, 2450, 2483, 2451, 2480, 2482, 2452, 5108, 5109, 5110, 5111, 5112, 5113, 5114, 5115, 5116, 5117, 5118, 5150, 5119, 5120, 5121, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 5300, 5301, 5302, 5303, 5304, 5305, 5306, 5307, 5308, 5309, 5310, 5311, 5312, 5313, 2782, 2783, 2784, 2896, 3503, 3504, 2785, 2786, 2787, 2788, 3263, 2789, 2790, 2791, 2792, 5235, 5236, 5237, 5238, 5239, 5240, 5241, 5242, 5243, 5244, 5245, 5246, 5247, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5409, 5044, 2426, 2427, 2428, 2429, 2430, 2431, 2432, 2433, 2434, 2435, 4140, 2436, 3552, 2536, 4696, 2437, 12, 75, 76, 2296, 77, 78, 79, 80, 81, 82, 624, 829, 124, 2232, 178, 2575, 880, 180, 181, 182, 4361, 184, 185, 4363, 186, 2355, 1339, 5137, 5138, 5139, 5140, 5574, 5141, 5142, 5575, 5143, 5144, 5145, 5576, 5146, 5147, 5577, 5148, 5578, 5579, 5149, 3783, 3784, 3785, 3786, 3787, 3788, 3789, 3790, 3791, 4139, 4211, 4212, 3792, 3793, 4342, 3794, 5162, 3795, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3495, 3496, 3499, 3500, 3497, 3915, 5365, 5366, 5367, 5368, 5369, 5370, 5371, 5372, 5373, 5374, 5375, 5376, 5377, 5123, 5124, 5125, 5126, 5127, 5128, 5129, 5130, 5131, 5132, 5133, 5134, 5135, 5136, 704, 705, 767, 706, 707, 708, 709, 710, 4734, 712, 4735, 3507, 5152, 2277, 4054, 4197, 4198, 4207, 4199, 4200, 4201, 4203, 4213, 4202, 4208, 4209, 4210, 4204, 4205, 4206, 5561, 5562, 5563, 5564, 5565, 5566, 5567, 5568, 5569, 5570, 5571, 5572, 5573, 4586, 4587, 4588, 4589, 4590, 4591, 4592, 5403, 4593, 5179, 4594, 4620, 4738, 4595, 5323, 5324, 5325, 5326, 5327, 5328, 5329, 5330, 5331, 5332, 5334, 5335, 5408, 5336, 5337, 5339, 5248, 5249, 5250, 5251, 5252, 5253, 5254, 5255, 5256, 5257, 5258, 5259, 5260, 1786, 1787, 1788, 1789, 2662, 1790, 1791, 1792, 1794, 1793, 1795, 1796, 2377, 1797, 4973, 4974, 4975, 4976, 4977, 4978, 4979, 4980, 4981, 4982, 4983, 4984, 4985, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5447, 5448, 5449, 5452, 5450, 5451, 5353, 5354, 5355, 5356, 5357, 5358, 5359, 5360, 5361, 5362, 5363, 5426, 5364, 5595, 5596, 5597, 5598, 5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 2956, 2957, 2958, 2959, 3815, 2960, 2961, 2962, 2963, 2964, 2995, 2965, 5535, 2966, 4875, 4876, 4877, 4878, 4879, 4880, 4881, 4999, 4882, 4884, 5178, 4885, 4886, 4887, 4273, 4274, 4663, 4275, 4276, 4277, 4278, 4279, 4280, 4281, 4282, 4283, 4284, 5062, 5063, 5064, 5106, 5066, 5067, 5068, 5070, 5069, 5071, 5072, 5074, 5075, 17, 21, 29, 22, 23, 24, 25, 26, 27, 2261, 28, 5298, 608, 2442, 465, 2260, 922, 923, 2236, 924, 4755, 925, 926, 4756, 927, 928, 929, 930, 4757, 5558, 934, 931, 4719, 4679, 4680, 4681, 4682, 4683, 4684, 4685, 4686, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694, 4695, 5453, 5454, 5455, 5456, 5457, 5458, 5459, 5460, 5461, 5462, 5463, 5464, 5465, 1430, 1431, 1432, 1433, 1437, 1439, 1435, 1438, 1440, 1436, 1434, 1442, 3483, 1441, 1613, 1614, 1615, 5508, 5509, 5510, 5511, 5512, 5513, 5514, 5515, 5516, 5517, 5518, 5519, 5520, 4895, 4896, 4897, 4898, 4899, 4900, 4901, 4903, 4902, 4904, 4905, 4906, 4907, 4908, 196, 264, 1444, 265, 267, 268, 271, 272, 1765, 274, 1880, 1448, 200, 331, 1000, 342, 343, 344, 345, 346, 347, 348, 350, 2240, 5197, 5466, 5467, 5468, 5469, 5470, 5471, 5472, 5473, 5474, 5475, 5476, 5477, 5478, 5412, 5413, 5414, 5415, 5416, 5417, 5418, 5419, 5420, 5421, 5422, 5423, 5424, 5425, 3088, 3089, 3090, 3091, 3092, 3093, 3094, 3095, 3096, 3097, 3137, 3098, 3099, 20, 30, 817, 31, 32, 33, 34, 35, 36, 37, 1631, 38, 818, 5180, 5181, 5182, 5183, 5184, 5185, 5186, 5187, 5188, 5190, 5189, 5191, 5192, 5193, 4475, 4476, 4477, 4478, 4636, 4479, 4480, 4481, 4482, 4637, 4483, 4484, 4638, 4485, 4487, 5607, 5608, 5609, 5610, 5611, 5612, 5613, 5614, 5615, 5616, 5617, 5618, 5619, 751, 752, 1461, 753, 754, 755, 756, 758, 1382, 5407, 4643, 5411, 4666, 4667, 4668, 4671, 4669, 4670, 4672, 4673, 4674, 4675, 4676, 4736, 4737, 4677, 4678, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 4721, 4722, 4731, 4723, 4724, 4725, 4726, 4733, 4728, 5220, 4729, 4732, 519, 520, 528, 521, 522, 3654, 523, 524, 525, 1661, 526, 527, 725, 529, 625, 4432, 4433, 4434, 4435, 5400, 4441, 4503, 4504, 4437, 4438, 4440, 4442, 5055, 4554, 4439, 4443, 5054, 4505, 4506, 4445, 4446, 4507, 4444, 4447, 5003, 5016, 5017, 5018, 5019, 5020, 5022, 5023, 5024, 5025, 5026, 5027, 5410, 5029, 5198, 5199, 5200, 5201, 5202, 5203, 5204, 5205, 5206, 5207, 5208, 5209, 5210, 5211, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5299, 5232, 5233, 5234, 1769, 1770, 1771, 1772, 3501, 1773, 1774, 1775, 1776, 1784, 2337, 3914, 1777, 1778, 1867, 2338, 2339, 2336, 5580, 5581, 5582, 5583, 5584, 5585, 5586, 5587, 5588, 5589, 5590, 5591, 5592, 5593, 5594, 900, 911, 5194, 912, 913, 914, 915, 916, 917, 1632, 918, 919, 3367, 4890, 531, 532, 1881, 765, 533, 534, 799, 535, 4015, 4016, 537, 762, 539, 764, 614, 3553, 3554, 1018, 3222, 862, 863, 872, 864, 865, 866, 867, 868, 2378, 869, 873, 870, 2379, 1783, 2229, 871, 3898, 3899, 3900, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3910, 4831, 4832, 4833, 4834, 4835, 4836, 5058, 4837, 4838, 4893, 4839, 5267, 5268, 5269, 4840, 4841, 4857, 4858, 4859, 4860, 4861, 4862, 4863, 4864, 4865, 4866, 4867, 4872, 4868, 4869, 19, 100, 780, 102, 103, 104, 106, 107, 109, 110, 127, 761, 617, 5387, 5388, 5389, 5390, 5391, 5392, 5393, 5394, 5395, 5396, 5397, 5398, 5399, 3150, 3152, 3161, 3151, 3154, 3158, 3155, 3157, 3153, 3160, 3162, 2871, 2872, 2873, 2874, 2875, 2876, 2877, 2878, 2879, 2880, 2881, 2882, 5078, 5079, 5080, 5081, 5082, 5083, 5084, 5085, 5086, 5087, 5088, 5089, 5090, 5091, 5002, 5004, 5005, 5006, 5007, 5008, 5009, 5010, 5011, 5012, 5013, 5014, 5021, 5015, 4181, 4182, 4183, 4184, 4185, 4186, 4187, 4188, 4189, 4562, 4190, 4191, 4192, 5522, 5523, 5524, 5525, 5526, 5527, 5528, 5529, 5530, 5531, 5532, 5533, 5534, 5482, 5483, 5484, 5485, 5486, 5487, 5488, 5489, 5490, 5491, 5492, 5493, 5494, 204, 288, 660, 289, 290, 4794, 291, 292, 293, 294, 4795, 4798, 4796, 295, 4799, 1417, 661, 4797, 296, 4792, 989, 990, 1220, 991, 992, 993, 994, 995, 996, 1221, 997, 4502, 998, 5560, 2425, 374, 375, 702, 376, 377, 378, 379, 380, 381, 382, 834, 703, 466, 2502, 383, 1401, 2479, 1222, 2826, 2827, 2828, 2829, 2830, 2831, 2832, 2833, 2834, 2835, 2836, 2837, 2838, 4769, 4770, 4772, 4773, 4774, 4775, 4776, 4777, 5404, 4778, 5405, 4779, 4780, 5495, 5496, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 5504, 5557, 5505, 5506, 5507, 195, 247, 248, 250, 251, 252, 254, 255, 256, 258, 261, 1487, 2295, 3223, 3224, 4417, 3225, 3226, 3227, 3229, 3230, 4418, 3231, 5175, 4143, 3232, 2411, 2412, 2413, 2414, 2415, 5479, 2416, 2417, 2418, 2661, 2420, 5322, 4560, 2534, 5521, 4559, 4800, 4801, 4802, 4803, 5077, 4992, 5052, 4972, 4804, 4805, 4806, 4807, 4808, 4809, 5406, 5401, 5221, 4810, 4811, 5122, 4813, 4814, 468, 469, 1488, 5059, 470, 4416, 3025, 471, 472, 473, 4053, 474, 475, 476, 3028, 3894, 607, 3026, 1489, 4415, 3024, 999 , -1 )
ORDER BY lastpost DESC
LIMIT 0 , 5