vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Advanced Warning System (AWS) (https://vborg.vbsupport.ru/forumdisplay.php?f=105)
-   -   Finally Installed but..... (https://vborg.vbsupport.ru/showthread.php?t=76356)

The Realist 02-15-2005 10:14 AM
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?

Delphiprogrammi 02-15-2005 10:27 AM
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 02-15-2005 10:55 AM
Quote:
Originally Posted by The Realist
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?
Read my answer in the other thread. What you mean that the script for the ban_dates does not work?

The Realist 02-15-2005 11:06 AM
I have this is why Im confused (see pic)



Quote:
Originally Posted by 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
Im using the one from the warning menu.

Quote:
Originally Posted by sv1cec
Read my answer in the other thread. What you mean that the script for the ban_dates does not work?

sv1cec 02-15-2005 11:09 AM
Quote:
Originally Posted by The Realist
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 02-15-2005 11:10 AM
John,

Is that a amature radio call you have there?

sv1cec 02-15-2005 11:13 AM
Quote:
Originally Posted by The Realist
John,

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

The Realist 02-15-2005 11:13 AM
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.

Quote:
Originally Posted by sv1cec
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

Quote:
Originally Posted by sv1cec
Yes Sir, it is.

sv1cec 02-15-2005 11:18 AM
Quote:
Originally Posted by 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.



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 02-15-2005 11:22 AM
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)

Quote:
Originally Posted by sv1cec
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 02-15-2005 11:30 AM
Quote:
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 02-15-2005 11:56 AM
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:


Quote:
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?:

Quote:
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 02-15-2005 12:18 PM
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 02-15-2005 12:30 PM
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:

Quote:
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?




Quote:
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 02-15-2005 12:56 PM
Quote:
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 02-15-2005 01:25 PM
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?

Quote:
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 02-16-2005 12:10 PM
Quote:
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 02-16-2005 03:02 PM
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 02-16-2005 06:01 PM
Quote:
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 02-16-2005 06:24 PM
Quote:
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.

Quote:
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.

Quote:
What does it shows you when you go to the Warnings Log? Are the dates there correct?
It shows the 16th not the 23rd.

Quote:
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.

Quote:
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 02-17-2005 06:37 AM
Quote:
Originally Posted by The Realist
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 02-17-2005 09:16 AM
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.



Quote:
Originally Posted by sv1cec
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 02-17-2005 01:42 PM
Quote:
Originally Posted by 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.





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


All times are GMT. The time now is 03:06 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02278 seconds
  • Memory Usage 1,853KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (26)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (23)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete