PDA

View Full Version : Hideaways


amykhar
07-16-2005, 10:00 PM
This extension lets you allow certain usergroups to create a private forum and an associated public usergroup. There are no queries to run, and you only need to change the parentid of the forums in hideaway.php before you upload it.

Access to the hideaway is denied to anybody except admins and the associated public user group.

The member who creates the forum becomes the usergroup leader and the forum moderator.

Users are responsible to advertise their own forum. No invite link is created. This is not automated. Users can either post an invitation to join their hideaway in some other forum on your site, or they can pm people to invite them. It's up to you on establishing the rules of hideaway promotion.

Users can edit their hideaway descriptions, but not the style or the forum title. The style can not be changed to ensure that we don't run into licensing issus. The title can not be changed because I use it to identify the forum for editing purposes.

The hideaway usergroups permissions are based on the registered user group's permissions. You can change what group their permissions are based off of within the code.

-----------------
FEATURES I WILL NOT ADD:
The ability for people to have more than one hideaway.
The ability for hideaway owners to create a new style for their forum.
The ability for hideaway owners to change the forum title.
The ability for hideaway owners to change any forum permissions.

-------------
This hack will always be free, however your donations are kindly accepted and will help towards further development. If you donate, please leave me some info (either your forum site or username at vB.org) so that I can thank you. :)
https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/xclick/business=amykhar%40yahoo.com&item_name=UserPage+Donation&no_shipping=1&cn=Your+Comments&tax=0&currency_code=USD)

xxskullxx
07-17-2005, 08:17 PM
Looks like another great addon amy, I'll be testing it on my local. Thanks for the work :)

kall
07-18-2005, 06:53 AM
Oh man! This could be exactly what I am looking for in order to let people create 'Private Events' that they then invite people to...

I wonder if it can be applied to the calendar...

john1744
07-18-2005, 07:29 AM
Holy crap, Amy this is exactly one of the features I was wanting. *Prepares to install*

jluerken
07-18-2005, 10:42 AM
Sounds to me like the old advanced Superforum hack which was really great but banned from Jelsoft.

The author got much trouble and was not allowed to work on it anymore.

I do not hope that this hack allows some kind of hosting cause then this is against Jelsofts copyright.

I want to see a hack like this and hope that no one will ban this one also :tired:

Chris M
07-18-2005, 11:35 AM
Great hack amy :)

Satan

amykhar
07-18-2005, 02:53 PM
Sounds to me like the old advanced Superforum hack which was really great but banned from Jelsoft.

The author got much trouble and was not allowed to work on it anymore.

I do not hope that this hack allows some kind of hosting cause then this is against Jelsofts copyright.

I want to see a hack like this and hope that no one will ban this one also :tired:

It's different in a few key ways, and I discussed the mod with Jelsoft staff before I wrote it and go the green light.

Amy

amykhar
07-20-2005, 05:55 PM
I think you've posted in the wrong thread Brinnie. What you've posted has nothing to do with allowing users to create private forums. Also, I can tell from your postbit in this thread that you haven't clicked the install button; so I must assume you don't have this mod installed on your site.

aethro
07-20-2005, 07:10 PM
oh this is exactly what I needed for my forums, great hack :D

* aethro clicks install.

amykhar
07-20-2005, 07:23 PM
Glad you like it :)

aethro
07-20-2005, 07:25 PM
Actually i've hit a snag :(

I followed the instructions and when I try to edit the permissions for usergroups it spouts out the following mysql error:

MySQL Error : Unknown column 'hideawaypermissions' in 'field list'
Error Number : 1054

amykhar
07-20-2005, 07:29 PM
I love it. :D 8 installs and you're the first one to notice I forgot to put the query in the install file.

Run this query:

ALTER TABLE usergroup ADD hideawaypermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

aethro
07-20-2005, 07:31 PM
woo hoo! First one to notice somethin! :P Thanks that worked nicely! :D

aethro
07-20-2005, 07:33 PM
COURSE after I speak lol

Invalid SQL:
INSERT INTO usergroup (title,usertitle,showinlist,ispublicgroup) VALUES ('PaulForum Group','Registered Member',0,1);

MySQL Error : Unknown column 'showinlist' in 'field list'
Error Number : 1054

Guess theirs more queries :P

amykhar
07-20-2005, 07:37 PM
Hmm. That must be from an old hack? Let me go look at a couple of things. BRB.

Amy

amykhar
07-20-2005, 07:50 PM
For now, change that line to


$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

aethro
07-20-2005, 07:54 PM
Yep that works thanks! :D

john1744
07-21-2005, 05:07 AM
Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`hideawaypermissions` = '1',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '1000',
`profilepicmaxheight` = '1000',
`profilepicmaxsize` = '65535000',
`avatarmaxwidth` = '800',
`avatarmaxheight` = '800',
`avatarmaxsize` = '2000000'
WHERE usergroupid=6;

MySQL Error : Unknown column 'hideawaypermissions' in 'field list'
Error Number : 1054
Date : Thursday, July 21st 2005 @ 02:06:37 AM

I keep getting this error

aethro
07-21-2005, 05:32 AM
Read https://vborg.vbsupport.ru/showpost.php?p=739079&postcount=12

john1744
07-21-2005, 06:31 AM
Ok, now i have the same issue as that second error you posted, but Amy says to change that line, what line is she referring to?

$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

aethro
07-21-2005, 06:36 AM
open hideaway.php

Find

// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,showinlist,ispublicgroup) VALUES ('$title','$usertitle',$showinlist,$ispublicgroup)");


Replace with

// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

john1744
07-21-2005, 07:25 AM
Thanks that worked fine.

Is there anyway that it could be made that the user could not see the forum, until they visit it? Then once they post in the forum/visit it, the hideaway would appear on the main category page?

Its kinda hard to see what forums you belong to (as a regular user) if they do not appear on the forum listing.

aethro
07-21-2005, 07:45 AM
It should show up for those that are in that usergroup and admins. If you are not apart of the usergroup, you wont see it.

john1744
07-21-2005, 08:00 AM
Huh, well I created a Hideaway with my admin account, then used a test account to access the forum, well I posted in the Hideaway with the test account but when I returned to the forum listings page, the Hideaway was not listed.

Also the test account is not listed as part of the Admin's Hideaway Usergroup.

Is this an error? Or does the user need to do something to "join" the hideaway?

BTW thanks for all the help.

john1744
07-21-2005, 08:11 AM
huh disregard that last post, it seems users cannot just access the forum. It gives all users the "Insufficient privelages" when they click the link to the hideaway of mine.

amykhar
07-21-2005, 02:26 PM
Huh, well I created a Hideaway with my admin account, then used a test account to access the forum, well I posted in the Hideaway with the test account but when I returned to the forum listings page, the Hideaway was not listed.

Also the test account is not listed as part of the Admin's Hideaway Usergroup.

Is this an error? Or does the user need to do something to "join" the hideaway?

BTW thanks for all the help.

Users can only access the forum if they have joined the usergroup. Hence the term hideaway. ;)

john1744
07-21-2005, 03:05 PM
How woudl a user go about joining the usergroup? I mean I know there are ways for someone to join a public usergroup, but where is this? Is there a link that says, "Join this Hideaway usergroup?"

Sorry I'm not having luck with your hacks Amy.

amykhar
07-21-2005, 03:29 PM
John, the usergroups are like any other public user group and are joined the same way. In your usercp there is a link called member groups.

Also, until you are a bit more experienced with Vbulletin, you should install only one hack at a time. Let it run a day or so and make sure you don't have issues. That way, you don't end up with compounded errors that can't be narrowed down easily.

john1744
07-21-2005, 03:37 PM
That worked fine Amy, and thank you for the help. I will take your advice.

Benj
07-25-2005, 09:25 AM
anyway to make these forums publicly viewable but, only invited users can post?

amykhar
07-25-2005, 10:38 AM
Yes. But, I don't have time to do it for you at this point. If you don't read code, you are going to have to rely on the kindness of strangers and hope somebody else wants that change and posts it for you.

Amy

Benj
07-25-2005, 12:05 PM
ok i cant read code so anyone:D

wcbryant
08-14-2005, 07:46 AM
I've got it set up on a test forum, but for some reason the new usergroups aren't being given permission to even view the new forum.

So user 11 'Dotty' (name changed to protect the innocent) is in a usergroup allowed to create. She makes one, and both the 'Dottyhideaway' group and the 'Dotty's Hideaway Forum' are both successfully created. People can apply to Dotty's group, she can add people. But no one can see or access the forum, even with a direct link (except me, the administrator). When I go in to 'Edit Forum Permissions For Usergroup: Dottyhideaway in Forum Dotty's Hideaway Forum', it's set to all no straight down through the options.

Clearly I've done something wrong along the way if no one else has run into it, but after looking around with some help for a while at the hideaway.php code (stock from the download with the modifications directed in this thread), I'm not seeing where the problem is.

Thanks in advance, and great extensions, Amy. I've flagged a few of yours as features I'd like to go live with on my production site. :)

Holidazed
10-04-2005, 03:18 PM
I installed the mod and it seems to work. However, when somebody who already has a Hideaway forum clicks the "Create" link, it gives them an error that says:

Could not find phrase 'hideaway_exists'.

I went in and added the phrase, but I still get the same error.

amykhar
10-04-2005, 07:25 PM
It has to be in the right phrase group.

Holidazed
10-04-2005, 08:56 PM
It is in the "Permissions" group. What group is it supposed to be in?

amykhar
10-05-2005, 01:31 AM
When I wrote it, it worked in Permissions. Not sure where it needs to be since the upgrade and haven't had time to play with it. Won't have time to play with it for a while, either.

Holidazed
10-05-2005, 03:30 PM
Argh!! sorry to hear that. It is such a great mod. But this error causes problems. Maybe it should be pulled from the release list until it is working properly.

hbalagh1
10-07-2005, 05:57 AM
Yes this is a great mod, specially for your paid members, i hope that phrase issue is resolved soon :)

hbalagh1
10-07-2005, 07:32 AM
anyone know how to create if conditions for this, so if they haven't created their private forum yet the edit private forum link doesn't show, and if they have created it, the creat private forum link doesn't show???

Thanks :)

mfizzel
10-29-2005, 03:46 AM
Can usergroups who don't have permission to create hideways see the hideaway forums?

amykhar
10-29-2005, 01:16 PM
Not unless they have been given access to the hideaway by its owner.

lordnex
10-31-2005, 07:39 AM
Is it possible for hideaways to inherit the settings from the parent forum? I'd like my private hideaways to not give credit to posts or ushop cash. (I know ushop is here but can you just compare permissions from the users hideaway and set it identical to the parent forum?

Holidazed
10-31-2005, 12:17 PM
I installed the mod and it seems to work. However, when somebody who already has a Hideaway forum clicks the "Create" link, it gives them an error that says:

Could not find phrase 'hideaway_exists'.

I went in and added the phrase, but I still get the same error.

Any idea when this issue is going to be resolved?

Holidazed
11-10-2005, 08:29 PM
Is this mod even being supported? Maybe it should be moved to the "Beta" forums as it is not working yet.

amykhar
11-10-2005, 08:31 PM
It worked just fine for the version it was released for ;) Something changed somewhere along the line about the way vbulletin handles phrases during upgrades. Missing phrases are something you can easily fix.

Holidazed
11-10-2005, 08:41 PM
It worked just fine for the version it was released for ;) Something changed somewhere along the line about the way vbulletin handles phrases during upgrades. Missing phrases are something you can easily fix.
Except I do not know where to put this phrase. So, are you saying that this mod is incompatible with vbb3.5?

kewl1uk
11-13-2005, 03:27 PM
Excellent mod and a perfect addition to my community. But it would have to be updated to work with 3.5.1 before I can use it :disappointed: Is there any timeline for the next update. Anyway Amy thanks for your hard work on this.

lanoix
11-14-2005, 01:31 PM
I installed/modified this hack to use it has I needed (possibility for users to create groups/forums with specified titles)... I had to do some modifications for 3.5.1 but now it's okay.
Thank you :)

Holidazed
11-14-2005, 01:49 PM
Except I do not know where to put this phrase. So, are you saying that this mod is incompatible with vbb3.5?

So? Where do I put the phrase?

lanoix
11-14-2005, 02:23 PM
You must add it in the 'Front-End error messages' to have it works... Also, you can add something like 'hideaway_added' in the 'Front-end redirect message' and modify this line:
eval(print_standard_redirect(''));
by
eval(print_standard_redirect('hideaway_added'));
It's what I've done, it's working perfectly now, people can create groups/forums.

Vizionz
11-23-2005, 01:17 PM
well i dont know where i am at but i am not seeing anything in the permissions to even activate it to try to ad the actual phrazes that are missing :(

PennylessZ28
11-23-2005, 10:33 PM
Thanks, your cod was very simple to use, I got it so people can add more than one hideway and change the title. Thanks this was an awesome idea.

EasyTarget
11-28-2005, 04:42 AM
/me clicks install and waits patiently for update for 3.5.1

amykhar
11-28-2005, 04:44 AM
you're going to be wating a while. I'm swamped :)

EasyTarget
11-28-2005, 09:37 AM
haha np, I'll have it marked so that I can check in on it every now and then.
thanks for the great hack.

tassoman
11-30-2005, 04:50 PM
err... I've followed hideaway.txt instructions, I've installed.... I've created an ordinary test user, and now how to create his personal hideaway?

I've tried to visit hideaway.php?do=create as user and as admin too but it tells I haven't privileges. :ermm:

mindfrost82
12-16-2005, 01:58 AM
err... I've followed hideaway.txt instructions, I've installed.... I've created an ordinary test user, and now how to create his personal hideaway?

I've tried to visit hideaway.php?do=create as user and as admin too but it tells I haven't privileges. :ermm:

I get the same results :(

cd1986
12-16-2005, 04:55 PM
1.) Make sure you've run the query shown on the 1st page (https://vborg.vbsupport.ru/showpost.php?p=739079&postcount=12)

2.) Make sure you've changed the appropriate line (https://vborg.vbsupport.ru/showpost.php?p=739324&postcount=21) in hideaway.php

3.) The phrases you should have added are:

name: hideaway_permissions
type: permissions
text: Hideaway Permissions

name: can_create_hideaway
type: permissions
text: Can Create a Hideway Forum

name: hideaway_exists
type: Front-End error messages
text: Hideaway Exists

name: hideaway_added
type: Front-end redirect message
text: Hideaway Added

NB: final phrase not necessary, only if you've edited hideaway.php accordingly

4. ) The AdminCP usergroup permissions for this hack might not show because the bitfield xml contains the line product="vBulletin" when it should be product="vbulletin" (small b). Edit the xml and it should work fine.

Works well on vb 3.52 for me. :)

mindfrost82
12-20-2005, 12:15 AM
I found a small bug. Its not really a bug, just part of the functionality.

If someone deletes their Hideaway, it doesn't delete the usergroup associated with that Hideaway.

So if someone goes to UserCP > Group Memberships, they still have the option to join that usergroup even though that hideaway forum doesn't exist.

Hanif
12-20-2005, 06:31 AM
Thanks, your cod was very simple to use, I got it so people can add more than one hideway and change the title. Thanks this was an awesome idea.

Dude or anyone else, would you care to share this code plz??? Something like this would be ideal for my test board.

Speak soon,

Hanif

nexus851
01-02-2006, 11:28 AM
When a register user try to create a forum, it gives them a "you do not have permission to access this page. This could be due to one of several reasons: etc..." message, but yet still made the forums for then.

I have the "Registered" usergroup set to yes for making forums, so i dont understand why it would give that message.

Please help...

lordnex
01-05-2006, 08:20 PM
ug.. i missed the previous page. I've done the thing I hate the most! LOL.

Anyways just go back to the previous page. There is a fix there that deals with all the errors.

amykhar
03-15-2006, 01:44 PM
OK. I've updated this mod to work with 3.5.4 and to be a product. Installation is cake. Upload the files. Install the product.

amykhar
03-15-2006, 01:45 PM
Dude or anyone else, would you care to share this code plz??? Something like this would be ideal for my test board.

Speak soon,

Hanif
You risk violating your vb license if you do those things. Just warning you. The whole private forums thing is a fuzzy line and it's difficult to tell when things are within the license or not.

hotwheels
03-17-2006, 09:43 PM
hello amykhar.......quick question on this update?

In mysql database, all of my setting's are vb3, not vb........how can i change those in your .php in order for my server to accept the query update's.....also, my database to my website is forums, not forum.....do i need to change that stuff also in the .php?

hotwheels
03-17-2006, 11:24 PM
I figured it out, thanks. ALTER TABLE vb3usergroup ADD hideawaypermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

Hell?
04-03-2006, 09:03 AM
Does anyone have the original txt install instructions?, I had to re-read the thread to figure out most of the stuff I need to do to make this hack work like running that sql query and I'm still triying to figure out where to put a link/button to call the hideaway.php

Tyegurl
04-04-2006, 05:45 PM
okay will this work with vbpager? i tried to install b4 and it wouldn't let me set permissions....

djsydeburnz
04-06-2006, 12:48 AM
couple questions.

someone commented on the stuff not showing up in the admin cp and said to change the case of vBulletin to vbulletin. this makes no sense to me because there was no cpnav xml file included and there is no vBulletin in the regular xml file.

i cannot see anything in the admincp except for the spot in the usergroup permissions to allow.

i cannt see anything anywhere to add a forum.

im using 3.5.1 so I am guessing the new uploaded one will not work???

bada_bing
04-06-2006, 02:23 AM
Wow going to install tomorrow

Tyegurl
04-06-2006, 06:25 AM
thanks amy hope it works with vbpager now.!! will let you know in a few hours.

amykhar
04-06-2006, 11:45 AM
couple questions.

someone commented on the stuff not showing up in the admin cp and said to change the case of vBulletin to vbulletin. this makes no sense to me because there was no cpnav xml file included and there is no vBulletin in the regular xml file.

i cannot see anything in the admincp except for the spot in the usergroup permissions to allow.

i cannt see anything anywhere to add a forum.

im using 3.5.1 so I am guessing the new uploaded one will not work???
There's nothing to see in the admincp that's new. This script creates a forum for your users with certain parameters. It sets up the usergroup. It sets up the group leader. And, it sets up the moderator for the forum. You already HAVE tools in your admincp to manager forums, usergroups and group leaders.

djsydeburnz
04-06-2006, 12:18 PM
so, do i create a new joinable group to make the forum show up? how does a user add a forum?

amykhar
04-06-2006, 12:43 PM
The user clicks the link to the hideaway script. It automatically creates the forum and the usergroup they will need - if they have permission to do so.

Tyegurl
04-06-2006, 01:22 PM
i still get an error....

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`genericpermissions` = '239075327',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '3',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '31',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '125',
`avatarmaxheight` = '125',
`avatarmaxsize` = '250000',
`jukeboxpermissions` = '255',
`pagerpermissions` = '13',
`pagerquota` = '0',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '0',
`pagersendmax` = '0',
`pagersendmaxchar` = '300',
`vbppermissions` = '14233',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '10000.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`hideawaypermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'hideawaypermissions' in 'field list'
Error Number : 1054
Date : Thursday, April 6th 2006 @ 07:21:38 AM
Script : http://www.teamrespawn.com/vBulletin/admincp/usergroup.php
Referrer : http://www.teamrespawn.com/vBulletin/admincp/usergroup.php?do=edit&usergroupid=6

bada_bing
04-06-2006, 02:09 PM
How can you display all joinable groups with the forum titles? I wan to use this hack so that certain usergroups can create joinable forums but allow everyone to see the list is joinable groups. If a member that tries to join the group without being invited will get prompted with a permitions message asking them to upgrade there membership? Can this be done and how?

djsydeburnz
04-06-2006, 02:11 PM
where is the link supposed to be? or do i make one. sorry for asking so many questions but it seems the txt file that everyone had awhile back is not here to download

amykhar
04-06-2006, 02:36 PM
You make one and post it where you would like. I just noticed the install file seems to have disappeared. I'll write one up again when I get a chance. For now, go look at the hideaway support forum on my site and you'll see the format of the links.

I don't tell you where to put the create and edit link because I believe people will want to do different things with this mod.

djsydeburnz
04-06-2006, 02:40 PM
cool. thanks for the extra support!

djsydeburnz
04-07-2006, 11:13 AM
if i create the forum, i get this error: Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_forum in /includes/class_dm.php on line 758

then if i hit refresh it says i allready have a forum.

when i try to edit, i get this error:
Invalid Forum specified. If you followed a valid link, please notify the administrator.

i cannot see any forums, there are none listed in my adminCP either.

any help is appreciated!

amykhar
04-07-2006, 11:27 AM
First, tell me every change you made to hideaway.php. And, if you didn't make any, that's your first problem. You were supposed to ;)

Amy

djsydeburnz
04-08-2006, 12:30 AM
i would assume you are talking about post 21 in this thread. my hideaway.php says the following:

// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

post 21 says this:

open hideaway.php

Find

// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,showinlist,ispublicgroup) VALUES ('$title','$usertitle',$showinlist,$ispublicgroup)");


Replace with

// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

djsydeburnz
04-08-2006, 12:31 AM
seems like the file i got allready had this change in it. is there another edit?

djsydeburnz
04-08-2006, 12:36 AM
if its the edit about:

eval(print_standard_redirect('hideaway_added'));

i added that in both places in the hideway.php

how about the original install txt so i can try it the right way.

amykhar
04-08-2006, 02:44 AM
no, it's the edit about setting the parent forum id and the forum title names. :)

and as far as it telling you that you already have a hideaway, delete the usergroup that it created.

djsydeburnz
04-08-2006, 05:38 PM
ah...i think i might be getting somewhere now. i didnt think to look in the actual php script. thanks for being patient. i forsee visiting paypal in your near future.

SuperFly
04-08-2006, 07:59 PM
Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = '',
`opentag` = '<b><font color=\"gray\">',
`closetag` = '</font></b>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '23',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '92',
`avatarmaxheight` = '92',
`avatarmaxsize` = '20480',
`vbspacecomments` = '31',
`journalpermissions` = '34783',
`arcadepermissions` = '255',
`photoplogpermissions` = '32767',
`photoplogmaxfilesize` = '512000',
`photoplogmaxfilelimit` = '10',
`ecdownloadpermissions` = '4095',
`ecexcludecatlist` = '',
`ecmaxdailydl` = '-1',
`ecmaxuploadtotal` = '-1',
`hideawaypermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'hideawaypermissions' in 'field list'
Error Number : 1054
Date : Saturday, April 8th 2006 @ 03:55:30 PM
Script : http://www.beforums.net/admincp/usergroup.php
Referrer : http://www.beforums.net/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 24.131.110.97
Username : Terowin
Classname : vb_database

any ideas?

Tyegurl
04-08-2006, 08:34 PM
you are missing the file edits like the rest of us. if you go to amy's forum and pay $10 for the vbulletin membership you can find out the edits needed. i personally haven't sorry or i would give you the edits for free.

SuperFly
04-08-2006, 10:28 PM
That makes no difference if im using the admincp and geting it.

Tyegurl
04-08-2006, 10:30 PM
yes but her files have not been edited....not the templates the files you uploaded...i believe there are edits on them if i am not mistaken...look at post hold on...#82 have to make edits to hideaway.php

i have the same error...post #76

amykhar
04-08-2006, 11:59 PM
wait a sec gang - the file edits are't there. They're here in this support thread.

Tyegurl
04-09-2006, 12:07 AM
i must have missed them then....i thought they were for something else. lol sorry....i will look and read a little closer this time.

SuperFly
04-09-2006, 11:30 AM
ALTER TABLE xusergroup ADD hideawaypermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

Edit x with your userbase data table, for instance mine is vb

open hideaway.php
Find
// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,showinlist,ispublicgroup) VALUES ('$title','$usertitle',$showinlist,$ispublicgroup)");

Replace with
// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");

Tyegurl
04-10-2006, 02:53 AM
tyvm! finally got it to work....couldn't do the query for some reason through my vbulletin...contacted my host...but i went to mysql directly and ran it from there. perfect and finally!!! woohoo ty amy

okay not so perfect....still getting errors and i tried both ways of that code...

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_forum in /includes/class_dm.php on line 758

i do not understand i am sorry can someone treat me like a 2 year old and tell me what i haven't done?

i have my usergroup but i just don't get how i get this message after i hit my hideaway.php link....

amykhar
04-10-2006, 09:56 AM
Tyegurl, it looks like you also didn't do the required edits to the hideaway.php file to set the parent forum for the hideaways.

Tyegurl
04-10-2006, 10:41 AM
Find
// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,showinlist,ispublicgroup) VALUES ('$title','$usertitle',$showinlist,$ispublicgroup)");

Replace with
// Throw the whole mess in the database.
$db->query_write("INSERT INTO ".TABLE_PREFIX."usergroup (title,usertitle,ispublicgroup) VALUES ('$title','$usertitle',$ispublicgroup)");


these right? i did them....and my phrases are there i checked each one....
okay i reread that line about 20 times and now i see what you are saying....omg i am so frutsrated!! sorry it just wasn't registering in my brain....

i need to do the file edit dealing with the parent forum...i will go look through this again but i don't remember seeing it and i know the txt file is still missing because i tried to download and reinstall last night....

i get my line 758 error...i refresh and i get the all ready have a forum....then i delete the user group and i get try again...back to the beginning....

okay so i have looked through the thread again and i came up with the one post anywhere...and theput the link anywhere you want....what is the edit link? and what is the create link?(hideaway.php??) and they go in the hideaway.php file file right?

nm i guess if i actually read the php file it would tell to change the forum ID omg do i feel blond....

amykhar
04-10-2006, 11:44 AM
No. I'm talking about the line near the top of the code that is clearly commented and tells you to put in the parent forum id. Forums have parents - sometimes categories, sometimes other forums.

Amy

Tyegurl
04-10-2006, 12:15 PM
okay and finally lol i have it up and my own hideaway is running...phew

i think it might have been easier to just say read the the hideaway.php file where the main script starts and edit between the " " and then replace the code in this thread...IMO that is. There is no install text and you have been very vague about where to look. Alll you keep saying is code code code... I am not stupid but when you say file edits and i did the "file" edits listed in the thread...you could have just been a little clearer. but thanks i finally got it just before you posted. which btw is still very vague. We are not all coders like you Amy. Wish I was. I am still learning a lot here. I hope some day to be able to code. Until then well I just have to muddle through.

amykhar
04-10-2006, 01:08 PM
There was an install text file and I lost it somehow during the upgrade. I just haven't had time to rewrite the thing.

Tyegurl
04-10-2006, 03:43 PM
okay it worked once and i have not edited anything since i created my hideaway....now its reverted somehow and i can't create my hideaway again....and i get the error i had b4 line 758 one and wow this sucks!!!

worked great once but then it disappeared after i followed the link. i don't understand how this is happening....i am jinxed i swear to god.

wait could it be because i deleted the link for the forum?

oh i figured it out...when i set up the forum id to create the hideaways i created a link to them but that didn't work so i deleted it unfortunately it was the parent forum of the hideaways and it deleted them too....darnit!!

Replicators
04-10-2006, 09:59 PM
This is the first mod i have come across that has no instructions o0

I have tried to figure this out, and seems good, but there is so much room for improvement, like a better userface or something. This would confuse the hell out of my users. Could it be possible for you to make a readme giving installation instructions, as well as a user guide of some sort?

Tyegurl
04-10-2006, 10:34 PM
There was an install text file and I lost it somehow during the upgrade. I just haven't had time to rewrite the thing.


lol

just a few posts up should help you immensely if you are confused! i had problems too...LOTS

djsydeburnz
04-29-2006, 02:53 PM
amy, i have been testing fine for about 2 weeks, and i have a question. is there a limit to the number of forums allowed? been working fine and then all of the sudden, i am getting that same error:

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_forum in /includes/class_dm.php on line 758


it creates the usergroup and sets the leader, but then does not create the forum. i checked the hideaway.php file and all the changes I made are still in tact not sure what changed??

harry1951
05-18-2006, 10:39 AM
There was an install text file and I lost it somehow during the upgrade. I just haven't had time to rewrite the thing.
I knew that I was having it somewhere and found it on a backup :)

amykhar
05-22-2006, 05:09 PM
OK. I have just discovered an issue that makes this very much an ADVANCED modification. This mod will conflict with other mods, such as the forum statusicon mod and other modifications that impact the forum database table.

If you are getting datamanager errors when it tries to create the forum, this is what's going on. Go lookin in the forumdata_start plugins and see which ones have required variables and adjust your hideaway.php file to set those required variables.

If you are not a coder, I am sorry, but I can only provide compatibility fixes as a premium service. I'm going to leave the code here because many of you do not use conflicting modifications and others of you can modify the php.

amykhar
05-22-2006, 05:10 PM
I knew that I was having it somewhere and found it on a backup :)
Thank you :)

LBSources
05-23-2006, 05:17 PM
I've got it set up on a test forum, but for some reason the new usergroups aren't being given permission to even view the new forum.

So user 11 'Dotty' (name changed to protect the innocent) is in a usergroup allowed to create. She makes one, and both the 'Dottyhideaway' group and the 'Dotty's Hideaway Forum' are both successfully created. People can apply to Dotty's group, she can add people. But no one can see or access the forum, even with a direct link (except me, the administrator). When I go in to 'Edit Forum Permissions For Usergroup: Dottyhideaway in Forum Dotty's Hideaway Forum', it's set to all no straight down through the options.

Clearly I've done something wrong along the way if no one else has run into it, but after looking around with some help for a while at the hideaway.php code (stock from the download with the modifications directed in this thread), I'm not seeing where the problem is.

Thanks in advance, and great extensions, Amy. I've flagged a few of yours as features I'd like to go live with on my production site. :)have you figured this out wc? amy any ideas? same issues here ..

LBSources
05-23-2006, 05:27 PM
When a register user try to create a forum, it gives them a "you do not have permission to access this page. This could be due to one of several reasons: etc..." message, but yet still made the forums for then.

I have the "Registered" usergroup set to yes for making forums, so i dont understand why it would give that message.

Please help...
another similar happening here ...

i believe it has something to do with
// Now, to set up the basic usergroup permissions.
$usergroupid = $db->insert_id();
// I cloned the permissions from the Registered user group.
$usergroupinfo= $db->query_first("SELECT forumpermissions FROM ".TABLE_PREFIX."usergroup where usergroupid=23");
$db->query_write("UPDATE ".TABLE_PREFIX."usergroup set forumpermissions=$usergroupinfo[forumpermissions] where usergroupid=$usergroupid");

Im trying to clone/replicate user permissions based on usergroup 23, yet its all set to 'NO' in the forum permissions ..

any ideas?

amykhar
05-23-2006, 05:34 PM
The first thing you need to do when debugging the problem is to look at the $usergroupinfo array and make sure it's not empty.

Also, make sure that it's getting the right usergroupid when it inserts it.

Commenting out the database inserts and putting in print statements for debugging should help you figure out why it's failing with your changes in place.

LBSources
05-23-2006, 05:39 PM
The first thing you need to do when debugging the problem is to look at the $usergroupinfo array and make sure it's not empty.

Also, make sure that it's getting the right usergroupid when it inserts it.

Commenting out the database inserts and putting in print statements for debugging should help you figure out why it's failing with your changes in place.
hello amy, the only thing i have done is change change your original 2 to 23 :cross-eyed: i havent made any other drastic changes except whats in the install docs .. and the db changes needed here which have it working somewhat ..

amykhar
05-23-2006, 06:07 PM
yes, but to find the problem, you've got to see where in the process it's going wrong. I can't do that with the one running on my server because it works. I can't reproduce the problem :)

LBSources
05-23-2006, 07:24 PM
understood .. unfortunately i dont know how to set the output to print ... hmmm ... ok ..

can anyone else suggest a solution .. or have any of the other members having this problem resolve them ..

LBSources
05-23-2006, 07:43 PM
Well its ok .. Amy i understand your busy and dont have time to officially support this hack .. ill just uninstall since youve indicated that it can be problematic with other hacks and since i soo many hacks ill leave it at that ..