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