e-steki Banlist v1.2

[Lea Verou]

Its functionality and installation instructions are the same as v1: https://vborg.vbsupport.ru/showthread.php?t=103190 so go read there.

v1.1 is better only under the hood: I fixed some bugs and optimized the code.

It works for 3.6.x as well and it might work with 3.5.x.


Changelog:

v1.2

Fixed bug that showed the liftdate as 1/1/70
Fixed bug that required someone to set the users per page for the hack to function
Added new setting for the banned usergroupids (useful if you have many)
Fixed bug that showed one less user per page (if you had set it to 10 per page, it showed 9)

[macc]

installed - works fine !

thanks and regards

macc

[anestetic]

error :

Warning: Division by zero in [path]/includes/functions.php on line 2342

[technom8t]

exact same message as above, uninstalled for now!

im using 3.7.3

[Gemma]

Did you set how many usernames you want per page?

Works fine for me on 3.7.3 pl1

[technom8t]

Did you set how many usernames you want per page?

Works fine for me on 3.7.3 pl1


That worked for me :-) thanks,

would have been handy if someone told us that first LOL

[Jhonnyf]

error :

Warning: Division by zero in [path]/includes/functions.php on line 2342

exact same message as above, uninstalled for now!

im using 3.7.3

vBulletin Options-> e-steki Banlist Settings -> Usernames per page

put the number of users to show per page

[Robbed]

For temp bans the lift date shows as 12-31-1969

[macc]

same for me ...lift date ... january 1970 ???

reg

macc

[Lea Verou]

Oops, you are correct. I'll look into the issue.

[Lea Verou]

v1.2 is out, with that bug (and some others) fixed.

[Martell]

error :(

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
userban.userid, adminid, bandate, liftdate, reason,
user.username as username,
admin.username as adminname, admin.displaygroupid as admindisplaygroupid, admin.usergroupid as adminusergroupid
FROM vB_userban as userban
LEFT JOIN vB_user as user ON(user.userid = userban.userid)
LEFT JOIN vB_user as admin ON(admin.userid = userban.adminid)
WHERE user.usergroupid IN ()
ORDER BY bandate DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY bandate DESC' at line 8

[Lea Verou]

go to the settings and set what your banned usergroupids are.
(strange... I thought I had set a default there)

[saviola8x]

Nice mod. Thanks somuch !

[HoGGeT]

http://img530.imageshack.us/img530/5222/errorwo9.th.jpg (http://img530.imageshack.us/my.php?image=errorwo9.jpg)


My banlist doesn't show banned user. What's my mistake?

[ShadowOne]

You Also Need To Go To Template Navbar....
Insert This....
<if condition="$show['member']">
<td class="vbmenu_control"><a href="banlist.php">Banned Members</a></td>
</if>

Put It Where You Want It..
If You Want Everyone To see It, Take Out The Condition....

[Whitey Bear]

Would it be possible to show all bans, including expired?

[suvari1794]

It doesn't show members who banned before the intstall this add-on. There are many banned members in my site, but shown anyone :S How can I fix it?

[RTMdotORG]

It doesn't show members who banned before the intstall this add-on. There are many banned members in my site, but shown anyone :S How can I fix it?

change the usergroup id for banned members...

[suvari1794]

Thank you.

[Oblivion Knight]

The total count is out by one, since you start with $i=1; and continue counting up.

To combat this, you need to subtract 1 from the total counter on the stats.
$banned_stats['total'] = $i - 1;

[muratcan25]

Thank You