Finally Installed but.....

BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp..._ban_dates.php it says ban_dates table updated from userban but it does not work?

Also I noticed that when I click in admin cp the view banned users it says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor" but I have already done this and changed the settings in the warnings options stating what the banned usergroup is.

Any ideas?

[sv1cec]

Originally Posted by The Realist

Now thats a good questions. I have over the months installed and deinstalled a few banning hacks and this could be a problems from one of these hacks.

I did first install Zero Tolerances hack then yours, but another banning hack could be lurking in the DB somewhere?

How can I find out if thats the case and how is this fixed?

Regards,

Brian (GW0WGW)

I would suggest that you create a new test user. Then ban him, without using the AWS. Check if there is an entry for that user in your userban table. That's where vB is normally putting the banned user entries. If it's not, then something is acting on the banning procedure. Ban the user with the same way you have banned your other banned user, the first time.

Let's try to get to the bottom of this,

Rgds

[The Realist]

I have created a test user and banned this member by going into the users details and changing his usergroup from registered user to banned.

If I then look in Phpmyadmin and look at the table called userban I see the following:

Field Type Null Default
userid int(10) No 0
usergroupid smallint(5) No 0
displaygroupid smallint(5) No 0
usertitle varchar(250) No
customtitle smallint(6) No 0
adminid int(10) No 0
bandate int(10) No 0
liftdate int(10) No 0
reason mediumtext Yes NULL

If I click browes I see that there seams to be banned members in there?:

userid usergroupid displaygroupid usertitle customtitle adminid bandate liftdate reason
36 5 5 Banned 0 1 1085062234 0 NULL
95 7 7 Banned 0 1 1083491037 0 NULL
1782 2 0 Junior Member 0 1 1100366018 0 NULL
1860 2 0 Junior Member 0 1 1101248173 0 NULL
1974 2 0 Junior Member 0 1 1101643754 0 NULL
1774 2 0 1st Time Leecher 0 1 1105013792 1168084800 NULL
2471 11 0 Loyal Member 0 95 1105224396 0 NULL
2109 2 0 1st Time Leecher 0 1 1105294304 1168365600 NULL
1682 14 0 Member 0 1 1108470061 0 User received a Permanent Ban Warning and was perm...

The test member with the userID of 2689 is not in there?

I have noticed this in the users in the vb admin panel...

A link saying Ban Users (see attached pic)


Thanks.

Brian

[sv1cec]

OK, so you banned the test user using the "Ban User" selection in Users. And that user does not appear (after he is banned) in the userban table. That means that somewhere in your modcp/banning.php file, you have changed something to register that ban somewhere else.

Open that file (modcp/banning.php) and go through it, until you find something like:

PHP Code:

else
    {
        // insert a record into the userban table
        $DB_site->query("
            INSERT INTO " . TABLE_PREFIX . "userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
            VALUES
            ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . addslashes($user['usertitle']) . "', $bbuserinfo[userid], " . TIMENOW . ", $liftdate,  '" . addslashes($reason) . "')
        ");
    } 


Probably the table name, at the INSERT INTO, should be different. Tell me what it says there.

In any case, if you want AWS to work properly, the banned user should be recorded in the userban table. AWS will put the banned users in there, no matter what, but it is better if all your banned users are put there too. If you will depend solely on AWS for your bans, there is no worry, but if you ban a user without using AWS, then you've got two different places where bans are stored, confusing to say the least.

I can't tell you what to do from now on, because I am not sure what hack you have used which alters that thing. The easiest way would be to use the original banning.php, and modify it per AWS instructions. But this may create problems elsewhere in your software.

Let me know.

[The Realist]

I have just logged into my forums as the test banned user and the page text says:

You do not have permission to access the forums, because you are temporarily banned, until the 01-01-1970.

1970 where does that come from?

Brian

My bannibg.php file says:

else
{
// insert a record into the userban table
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "userban
(userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
VALUES
($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . addslashes($user['usertitle']) . "', $bbuserinfo[userid], " . TIMENOW . ", $liftdate, '" . addslashes($reason) . "')
");
}

Looks ok to me or am I missing something? but when ever I have ran a query I have had to remove the words TABLE_PREFIX would this have anything to do with it?

Originally Posted by sv1cec

OK, so you banned the test user using the "Ban User" selection in Users. And that user does not appear (after he is banned) in the userban table. That means that somewhere in your modcp/banning.php file, you have changed something to register that ban somewhere else.

Open that file (modcp/banning.php) and go through it, until you find something like:

PHP Code:

else
    {
        // insert a record into the userban table
        $DB_site->query("
            INSERT INTO " . TABLE_PREFIX . "userban
            (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)
            VALUES
            ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . addslashes($user['usertitle']) . "', $bbuserinfo[userid], " . TIMENOW . ", $liftdate,  '" . addslashes($reason) . "')
        ");
    } 


Probably the table name, at the INSERT INTO, should be different. Tell me what it says there.

In any case, if you want AWS to work properly, the banned user should be recorded in the userban table. AWS will put the banned users in there, no matter what, but it is better if all your banned users are put there too. If you will depend solely on AWS for your bans, there is no worry, but if you ban a user without using AWS, then you've got two different places where bans are stored, confusing to say the least.

I can't tell you what to do from now on, because I am not sure what hack you have used which alters that thing. The easiest way would be to use the original banning.php, and modify it per AWS instructions. But this may create problems elsewhere in your software.

Let me know.

[sv1cec]

Originally Posted by The Realist

I have just logged into my forums as the test banned user and the page text says:

You do not have permission to access the forums, because you are temporarily banned, until the 01-01-1970.

1970 where does that come from?

Brian

My bannibg.php file says:



Looks ok to me or am I missing something? but when ever I have ran a query I have had to remove the words TABLE_PREFIX would this have anything to do with it?

When you run a query manually, you have to remove the "TABLE_PREFIX" thing, or replace it with whatever table prefix you are using, if you are using one. That's strange, the file looks OK, why don't the bans appear in the View Banned users?????

As for the date, first make sure you have edited file functions.php per the instructions. But if your banned user is not in the userban table, it will not show the date properly, because the program can't find any date for that user.

Do me a favor, ban a user using AWS and see if the same thing happens when he tries to log in.

Rgds

[The Realist]

Banned a test user using AWS and it placed them in the banned usergroup. When I login using the banned users data the page says "You do not have permission to access the forums, because you are perminantly banned"

But if I click the View Warnings Log the banned user is in there but does not show up at all in the View Banned Users link, it just says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor"

Strange or what?

Originally Posted by sv1cec

When you run a query manually, you have to remove the "TABLE_PREFIX" thing, or replace it with whatever table prefix you are using, if you are using one. That's strange, the file looks OK, why don't the bans appear in the View Banned users?????

As for the date, first make sure you have edited file functions.php per the instructions. But if your banned user is not in the userban table, it will not show the date properly, because the program can't find any date for that user.

Do me a favor, ban a user using AWS and see if the same thing happens when he tries to log in.

Rgds

[sv1cec]

Originally Posted by The Realist

Banned a test user using AWS and it placed them in the banned usergroup. When I login using the banned users data the page says "You do not have permission to access the forums, because you are perminantly banned"

But if I click the View Warnings Log the banned user is in there but does not show up at all in the View Banned Users link, it just says "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor"

Strange or what?

Wait a minute, what user group do you use normally in vBulletin for your banned users? Is it the same with the one you have specified in AWS Options page?

Check that the vBulletin groups and the ones you have specified in AWS are the same.

Rgds

[The Realist]

AWS automatically shows me my usergroups and all I do is pick the banned group.

SEE ATTACHED PICS

Done another test ban on a test user. My banning points is set at 30 so I choose a few warnings that take the user to 30 points and the system banned them.

But (yes another one)

I have set my 1st ban limit to 7 days but the test users banned screen says:

"You do not have permission to access the forums, because you are temp banned until the 16/02/05."

Its the 16th today?

Should that date be 7 days from now 23/02/05.

Laters

I just unbanned the test user and noticed the AWS system does not automatically move the banned user from the banned group back to there original group?

Doing my head in now.

[sv1cec]

Originally Posted by The Realist

AWS automatically shows me my usergroups and all I do is pick the banned group.

SEE ATTACHED PICS

Done another test ban on a test user. My banning points is set at 30 so I choose a few warnings that take the user to 30 points and the system banned them.

But (yes another one)

I have set my 1st ban limit to 7 days but the test users banned screen says:

"You do not have permission to access the forums, because you are temp banned until the 16/02/05."

Its the 16th today?

Should that date be 7 days from now 23/02/05.

Laters

I just unbanned the test user and noticed the AWS system does not automatically move the banned user from the banned group back to there original group?

Doing my head in now.

AWS is supposed to move the user back to whichever group you told it to, in the Warning Options. And yes, if your ban limit is set to 7 days, then the ban should be valid until the 23rd. What does it show you when you go to the View Banned Users? What does it shows you when you go to the Warnings Log? Are the dates there correct? If the user does not appear in the userban table, there is no way that the date shown in the login message be correct.

Check your userban table again. Is the banned user there? If not, you have to solve that problem first. Why the banned user does not appear in the userban table. After that, we can see what other problems you have. Reinstall the banning.php file from the original vBulletin software you use and see what happens.

[The Realist]

Originally Posted by sv1cec

AWS is supposed to move the user back to whichever group you told it to, in the Warning Options.

But it dont for some unknown reason.

And yes, if your ban limit is set to 7 days, then the ban should be valid until the 23rd. What does it show you when you go to the View Banned Users?

It shows "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor."

As explained before, this dont work for sone reason.

What does it shows you when you go to the Warnings Log? Are the dates there correct?

It shows the 16th not the 23rd.

If the user does not appear in the userban table, there is no way that the date shown in the login message be correct. Check your userban table again. Is the banned user there? If not, you have to solve that problem first. Why the banned user does not appear in the userban table. After that, we can see what other problems you have.

Yes he is in there.

Reinstall the banning.php file from the original vBulletin software you use and see what happens.

Trying this now.

NOW THIS IS STRANGE.

I removed the test banned user a few housr ago when the banning system did not work so I just rebanned the user again to answer the above questions.

Low and he hold.........

He is in the banned users table along with 9 other ghost bans that dont show in VB and I did not know about (any ideas of a command to clear theres). The banned users banning screen now shows the 23rd not the 16th as it did earlier today (strange) .

But the view banned users still shows the "The administrator has not specified any groups that contain banned users. Please do so using the usergroup editor"

Confused!

Regards.