vb.org Archive - Terry's Show Banned Users List Hack

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Terry's Show Banned Users List Hack (https://vborg.vbsupport.ru/showthread.php?t=70293)

frankenberrie

05-07-2005 03:34 PM

I am also having issues where users that I unbanned still show on the list.. ANy ideas?

HeloHi

05-12-2005 06:30 PM

Quote:

Originally Posted by djjeffa

ok I found this
Find:

Code:

$getbanned = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "banlist ORDER BY banid DESC LIMIT 30");

replace with:

Code:

$getbanned = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "banlist ORDER BY banid DESC LIMIT 50");

but i would like to find a way to make pages.

I would like to see this hack make pages as well, to keep a public record. After the limit is reached for it to create another page. :cool:

I am installing this though, just what I was looking for, thanks wrongful!

edit: Is there any way of making the style this shows up in anything but default? Where might I change that?

bigcurt

05-16-2005 10:03 PM

Please wrongful help us make pages :) :).

the_red_chimp

07-06-2005 08:11 PM

Code:

Database error in vBulletin 3.0.7:



Invalid SQL: CREATE TABLE banlist (

         banid int(10) unsigned NOT NULL DEFAULT '' auto_increment,

         userid smallint(5) NOT NULL DEFAULT '',

         username varchar(50) NOT NULL DEFAULT '',

         dateline int(10) unsigned NOT NULL DEFAULT '',

         bannedpost varchar(255) NOT NULL DEFAULT '',

         reason varchar(255) NOT NULL DEFAULT '',

         sentbywhom varchar(50) NOT NULL DEFAULT '',

         howlong int(10) unsigned NOT NULL DEFAULT '',

         INDEX (banid, userid)

                )

        

mysql error: Invalid default value for 'banid'



mysql error number: 1067



Date: Wednesday 06th of July 2005 02:10:21 PM

Script: website

Referer: 

Username: Chimp

IP Address: 66.137.177.2

Kirk Y

07-06-2005 10:17 PM

Any way to make this show the users that are already banned? If it's supposed to be doing this, then it's not doing it for me.

Marco van Herwaarden

07-07-2005 09:41 AM

Change:
[sql] banid int(10) unsigned NOT NULL DEFAULT '' auto_increment,
[/sql]
into:
[sql] banid int(10) unsigned NOT NULL auto_increment,
[/sql]
You can not have a default value for an auto-increment field in MySQL 4.1 and higher.

Nuckolsc.com

07-21-2005 10:12 PM

Sorry to bring this thread back up, but I have a question. You know how it only store the lastest 30 people banned.. Is there a way to up that #? When I hit control + f in the code I found this: "banlist ORDER BY banid DESC LIMIT 30"); Could I change that to like 100 or something and still ahve it function right?

Marco van Herwaarden

07-22-2005 05:00 AM

Probably yes.

GoTTi

07-28-2005 09:10 AM

any1 figure out a way that the name is removed from the list after the user serves out his sentence?

MB Dreamz

07-31-2005 03:26 AM

Quote:

Originally Posted by Da_GoTTi

any1 figure out a way that the name is removed from the list after the user serves out his sentence?

I need this too! Thanks.

GoTTi

08-06-2005 07:13 AM

Quote:

any1 figure out a way that the name is removed from the list after the user serves out his sentence?

any1?

MB Dreamz

08-17-2005 03:40 PM

Has anyone figured this out yet?

GoTTi

08-19-2005 06:06 AM

ok so um......

i was installing the AWS hack, and the entire thing is the same as the Terry's Show Banned Users hack...well, the code pertaining to the banning.php file. whats this about?

one of yall need to give someone credit for that, cuz your stealing code to use it for your own benefit, and that sucks without giving credit.

Terry's Show Banned User List Hack: https://vborg.vbsupport.ru/showthread.php?t=70293
Advanced Warning System: https://vborg.vbsupport.ru/showthrea...threadid=71992

yall can see in the instructions its the same thing...if ya care...

so whats this about?

lucky64

09-20-2005 12:26 AM

Quote:

Originally Posted by GoTTi

any1 figure out a way that the name is removed from the list after the user serves out his sentence?

Also interested in knowing if anyone has...also any chance of coding this for 3.5 rc3?

Mikecp421

10-21-2005 08:06 PM

does this work for 3.0.8??

DISREGARD, I got it! Thanks

lucky64

10-21-2005 10:24 PM

I'd like to see this a plugin for 3.5 :D

djjeffa

11-24-2005 05:47 PM

Quote:

Originally Posted by lucky64

I'd like to see this a plugin for 3.5 :D

yea bump!!
also i want to be able tou use my old list if posible lol

bigcurt

08-07-2006 05:13 PM

I was going to try to port this over to 3.5/6 for you guys, but I am getting no reply from him on whether I am allowed to do it or not...so, we will see how things go.

HeloHi

10-22-2006 07:14 PM

Quote:

Originally Posted by bigcurt

I was going to try to port this over to 3.5/6 for you guys, but I am getting no reply from him on whether I am allowed to do it or not...so, we will see how things go.

I know him from elsewhere on the internet. He doesn't have his license anymore. However, I also would like to see this ported over, I'll try and do something about it! :up:

wrongful

10-22-2006 07:44 PM

I thought I had told someone that they could port this hack but I guess they never got around to it.

I hereby give anyone and everyone permission to port this hack to anything they want. I do not have plans to update it.

SnapOff Racing

12-13-2006 08:08 AM

bump for this thread...i need this banned list on my site for 3.6.4 please :D

HeloHi

01-24-2007 05:05 AM

Quote:

Originally Posted by SnapOff Racing (Post 1137633)

bump for this thread...i need this banned list on my site for 3.6.4 please :D

this hack works for me on my 3.6.4

https://vborg.vbsupport.ru/showthread.php?t=103190

All times are GMT. The time now is 03:22 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01175 seconds Memory Usage 1,765KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (22)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: