FUDforum: How To » Adding users to a group using a script

Home » FUDforum » How To » Adding users to a group using a script

Show: Today's Messages :: Polls :: Message Navigator

Re: Adding users to a group using a script [message #30371 is a reply to message #30191]

Mon, 20 February 2006 20:45

djechelon

Messages: 46
Registered: July 2005

Karma:

Member

Here's what I tried to do now.

A user tried to access the restricted zone as described.
He was displayed in Groups Management Panel, but couldn't access restricted zone.

I went into the database and searched for his user ID.
Nothing related to that ID was found inside the group cache table.
I ran consistency checker and re-checked for user ID in the database.
I emptied the group cache table using TRUNCATE TABLE Forum_group_cache from phpMyAdmin
I ran consistency checker but still no entry in the group cache.

I went into Groups Admin, deleted that user and re-added it manually by username.
His ID was found in the group cache as finally expected, and he can now enter the forums.

I think there is nothing wrong with the query
"INSERT INTO Forum_group_members (user_id , group_id , group_members_opt) VALUES ('".$uid."', '".$gid."', '".$group_opts."');

Because I copied it from FUDforum source.
I found a way to avoid cache rebuilding by sending direct queries to the group cache table. I haven't tested it yet but it could be a good solution for MY CASE only.
But I found that even if I set permissions 312975 (that SHOULD be all permissions except edit, del, sticky, attach, break, close, move) the option field in group cache table is set to 378511. Is it normal?
But still: when I run consistency check it does actually not rebuild group cache correctly. I mean that if I empty the group cache table and run the consistency check the table is filled with old values. I think there is a problem with the checker.

Report message to a moderator

[Message index]

		Adding users to a group using a script By: djechelon on Fri, 10 February 2006 11:44
		Re: Adding users to a group using a script By: Ilia on Sat, 11 February 2006 20:03
		Re: Adding users to a group using a script By: djechelon on Thu, 16 February 2006 16:45
		Re: Adding users to a group using a script By: Ilia on Fri, 17 February 2006 14:44
		Re: Adding users to a group using a script By: djechelon on Fri, 17 February 2006 15:22
		Re: Adding users to a group using a script By: Ilia on Fri, 17 February 2006 19:57
		Re: Adding users to a group using a script By: djechelon on Mon, 20 February 2006 20:45
		Re: Adding users to a group using a script By: Ilia on Tue, 21 February 2006 15:20

Previous Topic:	Serious issue with mailing list - thread breaks when a message is modified
Next Topic:	How to fix error when can't accesss admin control panel?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 00:00:18 GMT 2024

Total time taken to generate the page: 0.06359 seconds