Choose what usergroups can view the board while deactivated

[Mephisteus]

Hack name: Choose what usergroups can view the board while deactivated
Version: 1.0
Author: DarkSSJ3
Thanks to: Kier, Boofo

Installation Time:
1-2 minutes

Steps:
1 query
admin/global.php (1 edit)

Info:
This will allow you to choose usergroups that can view the board while it is deactivated.

MAKE AN BACKUP
I will not be held responsible for any damage this hack causes to your forum.

Please keep any bug reports in this thread.

PS
If this hack has already been released I didn't know :p

PPS
Ported to vB3 by Faranth
https://vborg.vbsupport.ru/showthread.php?t=60125

[Mephisteus]

Screenshot

[N9ne]

Nice idea, never thought of it myself :).

[FlyingDutchman]

nice hack!
will install it now, it's small but very nice!!!

[Boofo]

Great hack. ;)

The query is wrong in it. It will give you a db error. You need to take the " out after the last ). ;)

Like this:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it\'s off','canviewclosed','6,5,7','What usergroups can view the board even if it\'s closed (seperate with a comma)','','3')

[Dean C]

Very nice hack, i have wanted this for a long time :)

- miSt

[Mephisteus]

Today at 07:50 PM Boofo said this in Post #5 (https://vborg.vbsupport.ru/showthread.php?postid=369386#post369386)
Great hack. ;)

The query is wrong in it. It will give you a db error. You need to take the " out after the last ). ;)

Like this:




thanks again boofo, bugfixer for life :)

I removed the last " after the last )

[Boofo]

No problem, glad to help. ;)

[Poggyuk]

How are people meant to log in? Because it comes up saying the boards are closed, so obviously... you can't log in!

Or is the idea to put the login form in the reason for the boards been closed?

[Davey]

Good point Poggyuk.
Admins can log in through the AdminCP, whereas Moderators and Super Moderators cannot.

Dave.

[Poggyuk]

Okay i've just tried putting the login form with the reason for the boards being closed, and sorry to say: it doesn't work!

The only way, is to log in via the admin cp...
however, this only applys for administrators. What about other user groups?

[Davey]

I told ya so.
Guess that was never thought of/tested when he released it lol.

Dave.

[Poggyuk]

Sorry DarkSSJ3 but your hack doesn't work :-(
Nice idea though!

I'll carry on working on this idea on my test forums, and if i manage to find a way round it, i'll release it on here! But i doubt it'll work...

[Mephisteus]

it doesn't work? It works for me :s Be sure to do the query.

PS
Mods/smods can login using the modcp

[EDIT]
I'll create an system that will alow an user to login without using admin/mod cp. For now at least admins and smods and mods that are assigned to an forum can login using the cp's.

But I asumed users would simply be logged in :p

[Frozen Dreams]

03-20-03 at 12:24 AM DarkSSJ3 said this in Post #14 (https://vborg.vbsupport.ru/showthread.php?postid=369539#post369539)
it doesn't work? It works for me :s Be sure to do the query.
I'll create an system that will alow an user to login without using admin/mod cp. For now at least admins and smods and mods that are assigned to an forum can login using the cp's.

That would be great - since on our board we are looking for something just like that.

Your hack created an error for me ... also I couldnt find the script in admin/global.php ... it was in ./global.php
is it supposed to be like that

Sorry if this sounds dumb ... I am fairly new to this :)

[Mephisteus]

it's supposed to be in global.php :) So that's ok :)

[David Coutts]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it\'s off','canviewclosed','6,5,7','What usergroups can view the board even if it\'s closed (seperate with a comma)','','3')


I get this:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,1,'What usergroups can view the board while it's off','canviewclosed','6,5,7','What usergroups can view the board even if it's closed (seperate with a comma)','','3')
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'r) VALUES (NULL,1,'What usergroups can view the board while it'

mysql error number: 1064

Date: Sunday 07th of March 2004 01:53:11 PM
Script: http://www.blahblah.com/admin/query.php
Referer: http://www.blahblah.com/admin/query.php

So like... what's wrong, doya think? I tried the edited bit up a few posts, but that didn't work either, sadly. Any help would be greatly appreciated.

[David Coutts]

Never mind, fixed it.

[Cle]

Ahh finally found a hack that I need :D However, it doesn't work for me :(
I use 2.3.5 and I cannot find the code that needs to be edited in global.php

Can someone help me with a code for 2.3.5?