Finally Installed but.....

[The Realist]

BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp/update_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?

[Delphiprogrammi]

hi,

yes goto this url http://www.yoursite.com/forums/$admincp/admin_warn.php?act=manageoptions there in your "banning options" section you must specify the id of your banned usergroups i have for example a custom group called "permanently banned" vbulletin standard has already a usergroup called "banned" you must first set your options before you can properly use it

[sv1cec]

BUT..........

I have 1 member already in my banned section and when I run http://www.yourforumsite.com/admincp/update_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?
Read my answer in the other thread. What you mean that the script for the ban_dates does not work?

[The Realist]

I have this is why Im confused (see pic)



hi,

yes goto this url http://www.yoursite.com/forums/$admincp/admin_warn.php?act=manageoptions there in your "banning options" section you must specify the id of your banned usergroups i have for example a custom group called "permanently banned" vbulletin standard has already a usergroup called "banned" you must first set your options before you can properly use it

Im using the one from the warning menu.

Read my answer in the other thread. What you mean that the script for the ban_dates does not work?

[sv1cec]

I have this is why Im confused (see pic)





Im using the one from the warning menu.
Realist,

Which "View Ban Users" link are you using? The one in the AWS menu or the one in the Users menu? If you have already a banned member, where do you see that? In the View Banned Users from the Users menu?

[The Realist]

John,

Is that a amature radio call you have there?

[sv1cec]

John,

Is that a amature radio call you have there?
Yes Sir, it is.

[The Realist]

The banned member was in my normal banned usergroup but the member did not show up when I clicked the view banned users link in the AWS menu.

What I had to do was find a post by the banned member and then choose the warning options, then ban him that way....

Then he showed up in the AWS banned members list. Running the update php file from admin did not pick him up in the first place.

Realist,

Which "View Ban Users" link are you using? The one in the AWS menu or the one in the Users menu? If you have already a banned member, where do you see that? In the View Banned Users from the Users menu?

Then on that score mine is GW0WGW

Laters

Yes Sir, it is.

[sv1cec]

The banned member was in my normal banned usergroup but the member did not show up when I clicked the view banned users link in the AWS menu.

What I had to do was find a post by the banned member and then choose the warning options, then ban him that way....

Then he showed up in the AWS banned members list. Running the update php file from admin did not pick him up in the first place.



Then on that score mine is GW0WGW

Laters
That's strange, because the update_ban_dates.php script reads your userban table and your banned user should be in there. If it couldn't find the user, then you are not using the userban table. Did you have Zero Tolerance's hack before? Or are you using another hack, which places the banned users in another table?

73 de SV1CEC

[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)

That's strange, because the update_ban_dates.php script reads your userban table and your banned user should be in there. If it couldn't find the user, then you are not using the userban table. Did you have Zero Tolerance's hack before? Or are you using another hack, which places the banned users in another table?

73 de SV1CEC

[sv1cec]

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:


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?




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:


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]

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?

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]

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]

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]

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.

[sv1cec]

But it dont for some unknown reason.


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.


It shows the 16th not the 23rd.


Yes he is in there.


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.
OK, there are two "View Banned Users" links in AdminCP. One is in AWS, the other in Users. Try both of them and tell me if they produce the same result.

If everything else fails, and if you so want, give me access to your server, so I can check things out.

[The Realist]

The both produce the same result.

I did not get a chance yesterday to re-upload a basic banning file, I'll do this now and see what goes.

Thanks.



OK, there are two "View Banned Users" links in AdminCP. One is in AWS, the other in Users. Try both of them and tell me if they produce the same result.

If everything else fails, and if you so want, give me access to your server, so I can check things out.

Uploaded a new banning.php file to modcp and I get the same result?

SOLVED THIS PROBLEM:

In the choosen usergroup, I did not say yes to "This usergroup is a 'Banned' group" and now the view banned users link works.

Now................

Lets see what else I can find that does not work :)

Thanks.

[sv1cec]

The both produce the same result.

I did not get a chance yesterday to re-upload a basic banning file, I'll do this now and see what goes.

Thanks.





Uploaded a new banning.php file to modcp and I get the same result?

SOLVED THIS PROBLEM:

In the choosen usergroup, I did not say yes to "This usergroup is a 'Banned' group" and now the view banned users link works.

Now................

Lets see what else I can find that does not work :)

Thanks.
Well, if you didn't tell the program that a group is a banned users group, it will get puzzled for sure.

Now, go and find some real bug!! LoL