Help Please

[SMOKEY_TEK]

I know I am asking for a lot of help, but I am just stuck on a situation.. Ok I have coded in a mailban, shoutban, and banned from game. But I want it to automatically remove that ban when their days are up..

 

The way I coded it into my game was like this ...

 

In classes.php I added

 

$this->reason = $worked['reason'];
$this->days = $worked['days'];
$this->mailban = $worked['mailban'];
$this->banned = $worked['banned'];
$this->shoutban = $worked['shoutban'];

 

SQL

[mysql]

ALTER TABLE `grpgusers` ADD `reason` text NOT NULL,

`days` int(20) NOT NULL default="0",

`mailban` int(5) NOT NULL default="0",

`shoutban` int(5) NOT NULL default="0",

`banned` int(5) NOT NULL default="0",

[/mysql]

And I added in pms.php

 

if($user_class->mailban == 1) {
echo '
<tr><td class="contenthead">Mailbox</td></tr>
<tr><td class="contentcontent">
<b style="font-size:18px"><center>You have been mail banned for <span style="color:#FF0000;">';
?>
<? echo $user_class->days; ?> </span> days.[/b]


[b]Reason:[/b]

<? echo $user_class->reason; ?></center>
<?
die();
}

 

In shoutbox.php I did the same thing as in pms.php

 

I have coded in rollover.php to remove 1 day at day update, but I am stuck at when the player is done with their ban it will remove the ban automatically ...

 

Any solutions on how I could do this, or if you have a better way to do all of this... ? Please help if you could....

[SMOKEY_TEK]

Nevermind, I figured it out.. lol And I apologize for double posting