Profile Enhancements - Lt - Ban Info

Desc:

Show ban info on user profile..

Installation:

1. Download Lt_Ban_Info_113.zip.
2. Copy 'Leftenant' folder to Forum root directory
3. Import product-lacyc_ban_bilgileri_english.xml file on Product Manamegent.
4. Go to vBulletin Options/Lt - Ban Info and change variables.

Note:if you upgrade for Lt - Ban Info 1.1.1, go to forum root directory and rename Lt folder to Leftenant or copy Leftenant folder to Forum root...
This product id is changed. Please don't forget to delete the others version before your install version 1.1.3

Change Log:

Version 1.0:

• First release.

Version 1.1:

• Added vBulletin 4 compatible.
• Added Lift ban and edit reason options.

Version 1.1.1:

• Unnecessary query's removed.
• Some bugs fixed.
• Lt folder renamed to Leftenant.

Version 1.1.2:

• Query problems fixed.
  

Version 1.1.3:

• Added Appearance At Permanent Ban User Option.

For vBulletin 3.8: https://vborg.vbsupport.ru/showthread.php?t=235675

[acast]

Originally Posted by Leftenant

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

PHP Code:

$cid = htmlspecialchars($_GET["mode"]); 
if($cid != 'threaded' AND $cid != 'hybrid')
{
$hook_query_fields .= ", lt_userban.userid AS lt_ban_id";
$hook_query_joins .= " LEFT JOIN " . TABLE_PREFIX . "userban AS lt_userban ON ( lt_userban.userid = post.userid ) ";
} 


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,4 498107,4499481,4499804,4499819,4499830,4500038,450 0045,4500050,4500056,4500227,4500243,4500500,45011 70,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:

PHP Code:

$lt_ban_gruplar = explode(',',$vbulletin->options['lt_ban_gorebilecek_gruplar']);
if (($vbulletin->options['lt_ban_etkin']) AND (is_member_of($vbulletin->userinfo,$lt_ban_gruplar)))
    {                
                    $lt_sql_sorgu = $vbulletin->db->query_first("
                    SELECT usergrp.usergroupid, usergrp.adminpermissions AS adminperforgroup, admins.adminpermissions
                    FROM " . TABLE_PREFIX . "user AS user
                    LEFT JOIN " . TABLE_PREFIX . "usergroup usergrp ON(user.usergroupid = usergrp.usergroupid)
                    LEFT JOIN " . TABLE_PREFIX . "administrator admins ON (user.userid = admins.userid)
                    WHERE user.userid = '".$vbulletin->userinfo['userid']."'
                    ");
                    if(($lt_sql_sorgu['adminperforgroup'] & 1) == 1)
                    {
                        $lt_allow_per = 1;
                    }
            
                    if($lt_allow_per != 1)
                    {
                        if(($lt_sql_sorgu['adminpermissions'] & 256) == 256)
                        {
                            $lt_allow_per = 1;
                            
                        }
                        if($lt_allow_per != 1)
                        {
                                if (in_array($vbulletin->userinfo['userid'], preg_split('#\s*,\s*#s', $vbulletin->
                                config['SpecialUsers']['superadministrators'], -1, PREG_SPLIT_NO_EMPTY)) ) 
                                {    
                                    $lt_allow_per = 1;
                                }
                        }
                    }

        
        
        if ((THIS_SCRIPT == 'misc') && ($_REQUEST['do'] == 'lt_ban_bilgileri' || $_REQUEST['do'] == 'lt_lift_ban'))
            {
                $vbulletin->input->clean_gpc('r', 'userid', TYPE_UINT);

                if ($vbulletin->GPC['userid'] AND $post = verify_id('user', $vbulletin->GPC['userid'], 0, 1))
                {

                }
            }


    } 


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.