[Alan_SP]

Excellent, problem with queries is fixed, so I started using your mod.

But, there's still bug with postbit.

Just tested it, showing info in pop-up is "stuck", no matter what option I choose, I see information about banning there, even if I choose that there's no info in postbit.

And, to repeat my feature request, could you disable showing info for permanently banned users? As an option, of course, not for all, some of us would like to show that information.

Excellent mod and quick and good support. Giving 5 stars and nominating it for mod of the month.

[Leftenant]

Thanks Alan_Sp.
This product upgrdaded to 1.1.3 version.

[megabink]

Installed and working on my 4.2.0 pl2.
Thanks buddy.

[Alan_SP]

Originally Posted by Leftenant

This product upgrdaded to 1.1.3 version.

Just to report.

Not showing information for permanently banned users works as it should.

Information in postbit pop-up is still stuck, no matter what I select, there it is (I consider it small bug, but want to inform you about it).

Also, you changed product id (from Turkish to English), which resulted in having older version and newer after I tried to upgrade. When I found this out, I uninstalled both versions and installed only new one. Everything works, phrases wasn't lost (if anyone needs translation to Croatian of front end, ask).

Small suggestion, for next version, you have at settings for permanently banned users text:
Only Show As Profile (and Postbit)
As should be in.

Also phrase: Appearance At Permanent Ban User would better sound as Appearance for Permanently Banned Users.

These are just minor corrections, but just to mention them.

Excellent mod.

[Jigglez]

The mod seems great! I think I'm going to try it on my website. I'll let you know how it pans out on 4.2.0 pl3.

[acast]

Originally Posted by Leftenant

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.

It doesn't work. Still the same error:

I disable the plugin, too.

[Rhodium]

The plugin works fine but i get db errors

Database error in vBulletin 4.2.3:

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, IF(lt_userban.liftdate > 0, lt_userban.userid, NULL) as lt_ban_lift
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 = 10 AND postparsed.languageid = 3)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 10 AND sigparsed.languageid = 3)
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 (4498063,4498064,4498068,4498088,4498288,4498324,4498107,4499481,4499804,4499819 ,4499830,4500038,4500045,4500050,4500056,4500227,4500243,4500500,4501170,4500971 ,4500084);

MySQL Error : Column 'displaygroupid' in field list is ambiguous
Error Number : 1052
Request Date : Sunday, July 3rd 2016 @ 02:01:18 AM
Error Date : Sunday, July 3rd 2016 @ 02:01:18 AM
Script : http://xxx.xxx.com/forums/forums/thr...-de-fotografia
Referrer : http://xxx.xxx.com/forums/forums/200-Menorca
IP Address : xxxxxxxxxxxxxxxxxxxxxxxxxxx
Username : No registrado
Classname : vB_Database_MySQLi
MySQL Version :

Any one knows how to fix?

[Elixar]

I had DB errors but it now works. The following changes were made to the plugin called Lt - Ban Bilgileri - GS:

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

Thanks to MarkFL for his help on this.

[Alan_SP]

Can you post fixed version of mod here as attachment? It would make things easier for the rest of us.