Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Terry's Show Banned Users List Hack Details »»
Terry's Show Banned Users List Hack
Version: 1.00, by wrongful wrongful is offline
Developer Last Online: Oct 2011 Show Printable Version Email this Page

Version: 3.0.3 Rating:
Released: 10-06-2004 Last Update: 10-06-2004 Installs: 26
DB Changes
 
No support by the author.

Well, this is my first major hack, and my first php script to boot. It's not my original idea since there were several versions of this hack that existed for previous versions of vB, but I don't believe that one has been made for vB3 yet.


Anyhow, enough talk. This is a list that shows the past 30 banned users on your forums. When I update the hack I will make this number configurable, but in the meantime it works great like it is.

When you ban a user you can fill in a reason and if applicable, a URL to the offending post. When the user is banned their name goes into a list that displays all of this information and more. All users except guests have permission to view this list.


I could keep talking, but it's pretty self explanatory and the screenshots should explain anything I haven't said. Like I said, I am pretty new to PHP, so if anyone has any suggestions or feedback, please let me know. I hope I didn't forget anything.


Also, don't forget to click install and enjoy!

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 05-07-2005, 03:34 PM
frankenberrie's Avatar
frankenberrie frankenberrie is offline
 
Join Date: Dec 2002
Location: N.Y.
Posts: 69
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am also having issues where users that I unbanned still show on the list.. ANy ideas?
Reply With Quote
  #43  
Old 05-12-2005, 06:30 PM
HeloHi's Avatar
HeloHi HeloHi is offline
 
Join Date: Feb 2005
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.

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?
Reply With Quote
  #44  
Old 05-16-2005, 10:03 PM
bigcurt's Avatar
bigcurt bigcurt is offline
 
Join Date: Nov 2004
Location: KierDarby.php
Posts: 1,009
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please wrongful help us make pages .
Reply With Quote
  #45  
Old 07-06-2005, 08:11 PM
the_red_chimp the_red_chimp is offline
 
Join Date: Aug 2004
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #46  
Old 07-06-2005, 10:17 PM
Kirk Y's Avatar
Kirk Y Kirk Y is offline
 
Join Date: Apr 2005
Location: Tallahassee, Florida
Posts: 2,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #47  
Old 07-07-2005, 09:41 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #48  
Old 07-21-2005, 10:12 PM
Nuckolsc.com Nuckolsc.com is offline
 
Join Date: Mar 2005
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #49  
Old 07-22-2005, 05:00 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Probably yes.
Reply With Quote
  #50  
Old 07-28-2005, 09:10 AM
GoTTi GoTTi is offline
 
Join Date: Jun 2002
Posts: 1,346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

any1 figure out a way that the name is removed from the list after the user serves out his sentence?
Reply With Quote
  #51  
Old 07-31-2005, 03:26 AM
MB Dreamz MB Dreamz is offline
 
Join Date: Jan 2005
Location: Houston, TX
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05113 seconds
  • Memory Usage 2,302KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete