vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   SuperMods can Unban from ModCP! (https://vborg.vbsupport.ru/showthread.php?t=48814)

N9ne 03-16-2003 11:45 AM

vBt uses vB 3.0.0...and it doesn't allow them to unban users? I'm sure it does :confused:

TraceyPRO 03-25-2003 07:22 PM

For those who've been having problems with the unban link not showing up, I've found the problem.

In /mod/user.php Find:
PHP Code:

  $users=$DB_site->query("SELECT userid,username FROM user WHERE username LIKE '%".addslashes(htmlspecialchars($findname))."%' ORDER BY username"); 

Replace that with:
PHP Code:

  $users=$DB_site->query("SELECT userid,username,usergroupid FROM user WHERE username LIKE '%".addslashes(htmlspecialchars($findname))."%' ORDER BY username"); 

The reason the unban link wasn't showing up was simply because the 'usergroupid' column wasn't selected from the database. Therefore when it tried to search for the usergroupid of the banned user (in this case '8') it couldn't find anything because the 'usergroupid' column wasn't selected to look in.

N9ne 03-25-2003 08:03 PM

Hmm, that's odd how it didn't select the usergroupid, thanks for posting up the fix though, I was clueless as I had it working on my forum, I probably did modify that query as you've posted in your post, but just forgotten to add it into the instructions!

monstergamer 04-08-2003 02:51 AM

i cant get this to work on 2.3.0

Darkwaltz4 11-23-2003 12:49 AM

First of all, this was actually originally found HERE by n9ne

However the code was erroring, and it also had excess code in it and proved to be insufficient.

I took the code and fiddled around with it, because i had been looking for something similar and didnt feel like writing my own hack, however i ended up doing it anyway ~_~ and also rewrote the instructions.

Now anyway, this will replace the [ban] link in the MOD control panel, with [unban] for users which are banned when searching for them. Then it unbans (i bet you werent expecting that), similarly to the way in which you ban users in the first place. The instructions include information for things like changing the usergroupid which the banned users are in, and also for multiple banned groups, and for changing the usergroup the unbanned users go into. changing things is simple enough however if you need specific coding done just post it and ill post back the fix.

Works for ALL 2.x.x boards, 4 edits to mod/user.php

have fun...


All times are GMT. The time now is 07:01 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01382 seconds
  • Memory Usage 1,727KB
  • 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
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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