[Alan_SP]

Excellent mod.

But, you have few small bugs. In zip you named your directory Lt, but in product you reference directory lt. Unix server differentiate between small and capital letters. It's easy to change, but as it is now, this reports error.

Also, I disabled in postbit pop-up, but it is still visible.

These are relatively small problems. A bigger problem is that you're not using English in variable names, so it is a bit of a problem to know what templates and variables actually do (so I have much harder time to correct such mistakes). Anyway, thank you very much...

Could you maybe add option that permanently banned users don't show this information about banning? I try to make them less obvious from those that are only banned for a certain period of time.

[Alan_SP]

Just noticed serious problem with queries. It adds about 130 queries on my index page, also adds queries on threadshow pages.

Till you solve this problem, I'm disabling this mod. When you solve it, I'll use it again, it looks really good, but so many queries is a too big problem.

[Leftenant]

Take care of the problems. Thank you for attention.

[TheSupportForum]

like this mod, tagged it for later use, would like to see an option
to only show it to admins,mods,supermods

[Leftenant]

This plugin upgraded.

[Nirjonadda]

Does it work on 4.1.10 without manual template edit ?

[Leftenant]

Originally Posted by Nirjonadda

Does it work on 4.1.10 without manual template edit ?

this hack tested and working on vB 4.0, 4.2 without having to change template.

[GPOClan]

Looks very good, tagged for later

[Alan_SP]

Originally Posted by TheSupportForum

to only show it to admins,mods,supermods

Actually, this option is already in it. You need to select usergroups that will see banning info, if you don't no one will see it.

[Alan_SP]

Originally Posted by Leftenant

Take care of the problems. Thank you for attention.

Just tested it for queries. Problem isn't solved.

My index page (forum.php) now has 149-150 queries, but without your mod I have 21-24 queries (it depends). It also rises a bit (about 5-10%) page generation time, but it is maybe because all this queries.

On showthread pages, each post has two queries, so, as I have 25 post per page, I have additional 50 queries if that thread page has all posts.

This is too much queries. Please, try to solve it. If not, however I like your mod and it's usefulness, it's a too big impact on server for my liking.

Didn't tested other things (queries are too serious problem for me). And, if you be able to sort this queries out, please add check if user is permanently banned and option that such user's don't show banning info.

I really hope you'll be able to solve this problem with queries, like your mod very much.

[Leftenant]

Originally Posted by Alan_SP

Just tested it for queries. Problem isn't solved.

My index page (forum.php) now has 149-150 queries, but without your mod I have 21-24 queries (it depends). It also rises a bit (about 5-10%) page generation time, but it is maybe because all this queries.

On showthread pages, each post has two queries, so, as I have 25 post per page, I have additional 50 queries if that thread page has all posts.

This is too much queries. Please, try to solve it. If not, however I like your mod and it's usefulness, it's a too big impact on server for my liking.

Didn't tested other things (queries are too serious problem for me). And, if you be able to sort this queries out, please add check if user is permanently banned and option that such user's don't show banning info.

I really hope you'll be able to solve this problem with queries, like your mod very much.

Event is now realized. Just interested...

[Leftenant]

Originally Posted by Alan_SP

Just tested it for queries. Problem isn't solved.

My index page (forum.php) now has 149-150 queries, but without your mod I have 21-24 queries (it depends). It also rises a bit (about 5-10%) page generation time, but it is maybe because all this queries.

On showthread pages, each post has two queries, so, as I have 25 post per page, I have additional 50 queries if that thread page has all posts.

This is too much queries. Please, try to solve it. If not, however I like your mod and it's usefulness, it's a too big impact on server for my liking.

Didn't tested other things (queries are too serious problem for me). And, if you be able to sort this queries out, please add check if user is permanently banned and option that such user's don't show banning info.

I really hope you'll be able to solve this problem with queries, like your mod very much.

Ok. Problem is fixed. Thank you for attention.

[Skyrider]

Installed, though currently disabled.

By Visiting a "&mode=threaded" URL, this pops up:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

, lt_userban.userid AS lt_ban_id
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

LEFT JOIN userban AS lt_userban ON ( lt_userban.userid = post.userid )
WHERE post.postid IN (1312708,1315013,1316647,1317613,1317778,1319370,1320438,1320483,1323953,1325486 ,1326748,1326766,1327288,1330991,1335287,1335964,1336122,1336131,1336145,1336482 ,1336526,1336957,1337061,1337303,1337893,1339027,1339483,1340754,1340832,1341819 ,1342339,1356457,1356473,1356505,1356621,1358098,1358567,1358909,1359817,1360056 );

MySQL Error : Column 'displaygroupid' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, November 14th 2012 @ 03:55:22 AM
Error Date : Wednesday, November 14th 2012 @ 03:55:23 AM
Script : http://xxx.xxx.com/threads/109622-Lo...&mode=threaded
Referrer :
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Leftenant]

Originally Posted by FF|Skyrider

Installed, though currently disabled.

By Visiting a "&mode=threaded" URL, this pops up:

Temporary Workaround:
Goto AdminCp->plugin management->Lt - Ban Info - SQ
Replace All to:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Note: Hack only work on normal mode.