Admin log in problem

[Chuck S]

Well you may want to look at your bbuser_group table and see if you have a backup.

You seem to have dumped that entirely and then only added back 3 users. Basically your user's are going to have no permissions for nuke or photopost from what I see.

[stuartn]

INSERT INTO `nuke_bbuser_group` (`group_id`, `user_id`, `user_pending`) VALUES ('1', '-1', '0');
INSERT INTO `nuke_bbuser_group` (`group_id`, `user_id`, `user_pending`) VALUES ('3', '2', '0');
INSERT INTO `nuke_bbuser_group` (`group_id`, `user_id`, `user_pending`) VALUES ('4', '181', '0');
INSERT INTO `nuke_bbuser_group` (`group_id`, `user_id`, `user_pending`) VALUES ('5', '363', '0');

This is a copy from a backup should I dump the table and insert as above

[Chuck S]

Nope leave it along and see what happens.

Register a normal user and do some testing

[stuartn]

registered as a new user, and placed an advert no problem, however I have access to admin which I shouldn't have.

[Chuck S]

What usergroup does that user get placed in?

Have you altered usergroup permissions again? Last time I found you gave regular registered users mod access.

Resend phpmyadmin access as I cleaned out my PM bin today

[stuartn]

I haven't changed a thing, from what I can see its in group 2, going off the user_group_cp in the users table.

I'll PM the login

[Chuck S]

Yep I found the login. Again I went into the Classifieds Admin Usergroups Editor and Registered Users were set to admin access

I found some more Nuke groups that were not part of phpBB and added them to Photopost

You can test now

[stuartn]

works fine, but still any registered user can get access too admin..

[stuartn]

p.s. I haven't changed anything in phpadmin

[Chuck S]

I suggest you verify your user you think is a normal user. The only Classifieds usergroups that has admin access if usergroup 3 which is admin

Here are the inserts from your pp_usergroups table

INSERT INTO pp_usergroups VALUES (1, 'Anonymous', 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0);
INSERT INTO pp_usergroups VALUES (2, 'Registered', 0, 0, 1, 1, NULL, NULL, 1, 1, 0, 0);
INSERT INTO pp_usergroups VALUES (3, 'Admin', 1, 1, 1, 1, NULL, NULL, 1, 1, 0, 0);
INSERT INTO pp_usergroups VALUES (4, 'Personal Users', 0, 0, 1, 1, NULL, NULL, 1, 1, 0, 0);
INSERT INTO pp_usergroups VALUES (7, 'Moderators', 0, 0, 1, 1, NULL, NULL, 1, 1, 0, 0);
INSERT INTO pp_usergroups VALUES (5, 'Personal User', 0, 0, 1, 1, NULL, NULL, 1, 1, 0, 0);

I tried registering a regular user but no email to me confirming. I suggest you verify the user you think is a normal user is exactly that.

[stuartn]

Okay, I'll check it out....what I was thinking was then when installed it had a group error and I did find a post that mentioned changing the coding bit love nor money I can't find the same post....

You mentioned that it has no connection with nuke_bbuser_group, but I can find this code that joins two tables

Content visible to verified customers only.

is this written correctly

[Chuck S]

Yes it is written correctly. That hold the user's usergroup for nuke and checks it for

{$Globals['dprefix']}bbgroups.group_id = {$Globals['dprefix']}bbuser_group.group_id

See that line it checks for where nuke group is equal to board group

You will notice I posted server posts up that your bbuser_group table had no entries but 3.

Like I said it looks to me like you dumped it. There is definately something not standard with your install at all.

[stuartn]

Okay it would appear that my database isn't as near to the norm

I've managed to make some changes that get part of the way now, members can log in and post ads now with no link to admin, but that's not to say if they put the link in they can't get it, But I've a way round that.

So I'll run some more testing and I should be done bar putting a header in for my site name...

thanks for all your help

[Chuck S]

Well I beleive if I remember NUKE when a user registers an insert gets put into bbuser_group that records there usergroup.

In your install I beleive that is not happening. At anyrate the tough part here is we write integrations based on normal coding and configs. If there is any modifications etc to your nuke that can mess things up. I would be concerned as I stated before why you dont have any records in that table.

[stuartn]

Are you ready for a Photopost Review :-)