vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   Banned Users List (with reason/date/who) (https://vborg.vbsupport.ru/showthread.php?t=36819)

kidney 03-31-2002 10:00 PM

Banned Users List (with reason/date/who)
 
Here is a modification to a hack that already exist, but it adds by who the ban was made.

Here is an example of this hack
http://forum.dishwacker.com/showbanned.php

and here is the original hack
https://vborg.vbsupport.ru/showthrea...threadid=35979

Enjoy and let me if any problems occur

Floris 04-01-2002 07:45 AM

Can I limit this to only super/mods/admins can see this? I do not wish guests or registered members to see this.

vertex 04-01-2002 11:57 AM

great addon to supreem's hack, i believe i requested that = ] thanks, it would be better if only staff can see by who though.

Q8vbhacks 04-01-2002 12:54 PM

thanks for hack but i have this problem

Database error in vBulletin: Invalid SQL:
SELECT
userfield.field6, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field7, userfield.field8
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'usergroup.showgroup' in 'where clause'
mysql error number: 1054

vertex 04-01-2002 03:37 PM

ok if i have the hack already by supreemball what is there to add thats different? is showbanned.php different?

kidney 04-02-2002 01:55 AM

Quote:

Originally posted by Q8vbhacks
thanks for hack but i have this problem

Database error in vBulletin: Invalid SQL:
SELECT
userfield.field6, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field7, userfield.field8
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'usergroup.showgroup' in 'where clause'
mysql error number: 1054

You must create your fields before anything else and then add the mod to the config.php.

If you still have send your files i'll look into it when I have time.

kidney 04-02-2002 02:22 AM

Quote:

Originally posted by vertex
ok if i have the hack already by supreemball what is there to add thats different? is showbanned.php different?
Firts make sure that you create the extra and take down the ID that field and add to you config.php the following:
$bannedbyfieldid=7;

and the in the mod/user.php find:
Quote:

$banuser=$DB_site->query_first("SELECT username,userid,usergroupid,customtitle,posts FROM user WHERE userid=$userid");
$ismod=$DB_site->query_first("SELECT moderatorid FROM moderator WHERE userid=$userid");
and replace it by:
Quote:

$banby = $bbuserinfo['username'];
$banuser=$DB_site->query_first("SELECT username,userid,usergroupid,customtitle,posts FROM user WHERE userid=$userid");
$ismod=$DB_site->query_first("SELECT moderatorid FROM moderator WHERE userid=$userid");
in the same file look for:
Quote:

$DB_site->query("UPDATE userfield SET field$banreasonfieldid='$banreason', field$banuntilfieldid='$banuntil', WHERE userid=$banuser[userid]");
and replace it with
Quote:

$DB_site->query("UPDATE userfield SET field$banreasonfieldid='$banreason', field$banuntilfieldid='$banuntil', field$bannedbyfieldid='$banby' WHERE userid=$banuser[userid]");
and use my showbanned.php, and replace all the template with mine, it should be working fine after all that.



xiphoid
Quote:

Can I limit this to only super/mods/admins can see this? I do not wish guests or registered members to see this.
That's on my todo list.....

voogru 04-20-2002 11:50 PM

i keep getting this

Code:

Database error in vBulletin 2.2.5:

Invalid SQL:
        SELECT
                userfield.field8, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
                user.usergroupid, user.lastactivity, user.lastvisit, userfield.field, userfield.field9
                FROM usergroup
                LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
                LEFT JOIN userfield ON (userfield.userid = user.userid)
                WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10
       
mysql error: Unknown column 'userfield.field' in 'field list'

mysql error number: 1054

Date: Saturday 20th of April 2002 08:45:42 PM
Script: http://forums.voogru.com/showbanned.php
Referer:


voogru 04-20-2002 11:59 PM

ok, it works now but now when i ban someone it will not show up in the showbanned thing

voogru 04-21-2002 12:20 AM

n/m got it


All times are GMT. The time now is 01:59 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.01009 seconds
  • Memory Usage 1,739KB
  • 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
  • (1)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
  • (10)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