vb.org Archive - Hellban 0.1

Page 3 of 4

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

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

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - Hellban 0.1 (https://vborg.vbsupport.ru/showthread.php?t=35308)

Overgrow

03-02-2002 11:58 AM

I did a quick & dirty hack that has much of the same effect but without the query JOIN -- (removes a person's posts but lets them see 'em normally so they don't know what happened)...

https://vborg.vbsupport.ru/showthrea...threadid=35589

Freddie Bingham

03-02-2002 03:59 PM

JOINS are only a problem if the field(s) you are joining are not-indexed.

Overgrow

03-02-2002 04:08 PM

Freddie, you so smart... and it appears usergroupid is already indexed. So his original showthread join with the user would not have been a problem eh? Sorry intellected! I see you already changed it to use a new field, post.hellban. If the original way really didn't add much overhead, it was probably the more elegant solution rather than adding a new field to post.

Freddie Bingham

03-02-2002 10:30 PM

I don't know, I didn't look at his code so I have no comment on it's effectiveness at utilizing the database.

Jawelin

04-19-2002 10:42 AM

I think the usergroup is already read at showpost / newreply / newthread time.
So there is that info at postbit level, and we can use it without adding the hellban field to post & thread tables.

What do you think about ?
Thnx

FFMania

05-06-2002 10:28 AM

Same thing.....same error....can't get the query to work....help plz?

GenSec

05-13-2002 02:10 PM

I like hellban idea, but there is another way.
If you created 666 usergroup you find in admin/ functions.php

PHP Code:


		
			
    if (!$ignore[$post[userid]]) {

        eval("\$retval = \"".gettemplate("postbit")."\";");

    } else {

        eval("\$retval = \"".gettemplate("postbit_ignore")."\";");

    }

add below

PHP Code:


		
			
    if ($post[usergroupid]==666 AND $bbuserinfo[usergroupid]!=666) {

           eval("\$retval = \"".gettemplate("postbit_ignore")."\";");

    }

and all your hellbanned user are on common ignore list.

Or change postbit_ignore template for more suited.

Brad	05-31-2002 03:20 AM

Quote:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: INSERT INTO usergroup VALUES("666","Ultimate ban","","0","1","1","1","1","0","1","0","0","0","1 ","1","1","1","0","0","1","1","1","0","0","1","0", "0","0","0","0","0","0","0","1");

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Friday 31st of May 2002 05:20:26 AM
Script: http://www.kousetsu.net/forums/forums/admin/query.php
Referer: http://www.kousetsu.net/forums/admin/query.php?s=<?php echo 6ed374efbed9b32d097264f97d3a4586; ?>

Brad	05-31-2002 02:43 PM

n/m, got it to work in phpmyadmin

Brad	06-01-2002 07:00 AM

i found a better method if you got admins out there that like members you ban. simalar to the one above but im using it and it works
in functions.php

find

PHP Code:


		
			
if (!$ignore[$post[userid]]) {

        eval("\$retval = \"".gettemplate("postbit")."\";");

    } else {

        eval("\$retval = \"".gettemplate("postbit_ignore")."\";");

    }

under add

PHP Code:


		
			
if ($post[userid]==*users id here* AND $bbuserinfo[userid]!=*users ID here*) {

           eval("\$retval = \"".gettemplate("postbit_ignore")."\";");

      }

replace *user id here* with their user id

then deleate everything from postbit_ignore

All times are GMT. The time now is 06:13 AM.

Page 3 of 4

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01206 seconds Memory Usage 1,747KB 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 (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: