Been using it for some time and I think its working fine

This will let you set private timers. The bot will send you a tell
when the timer expires, and also 1 hour before it expires.

You need to edit the users array and put your player name or multiple multiple names in it.
It should be easy to make a command to add users, too many timers would lag the bot though.

$this -> users = array("wanuarmi");
$this -> users = array("wanuarmi", "user2");

Commands were made this way to be simple and fast to type

!st HH:MM:SS <description> (sets a timer with hour, minutes and seconds)
!st MM:SS <description> (sets a timer with minutes and seconds)
!st MM <description> (sets a timer with minutes)
!t (shows timers with number, description and remaining time)
!t del <ID> (deletes a timer using the number)
!t sort (id|name|time) (changes timer list sorting; superadmin only)
!t color (id|description|time|alert) (just to test colors without restarting the bot, after you are done you should edit the file; superadmin only)

enjoy


modules/PersonalTimers.php
<?
$personalTimers = new PersonalTimers($bot);

$db -> query("CREATE TABLE IF NOT EXISTS `personaltimers` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`setby` VARCHAR( 100 ) NOT NULL ,
`description` VARCHAR( 255 ) NOT NULL ,
`expires` INT( 11 ) NOT NULL ,
PRIMARY KEY ( `id` )
);"); 

$commands["tell"]["t"] = &$personalTimers;
$commands["tell"]["st"] = &$personalTimers;

$cron["2sec"][] = &$personalTimers;


class PersonalTimers
{
var $bot;
var $timers;
var $users;

var $id_color;
var $description_color;
var $time_color;
var $alert_color;

var $sort_order;


function PersonalTimers (&$bot)
{
$this -> bot = &$bot;

$this -> id_color = "#dddddd";
$this -> description_color = "#31D6FF";
$this -> time_color = "#dddddd"; //#C6D6FF
$this -> alert_color = "#FF3131";

$this -> sort_order = "expires";

$this -> users = array("wanuarmi");

$this -> get_timers();
}


function tell($name, $msg)
{
$this -> bot -> send_tell($name, $this -> process_command($name, $msg));
}



// check permissions and return messages
function process_command($name, $msg)
{
$users = $this -> users;
if (!in_array(strtolower($name), $users))
return "You don't have access to this command.";

if (preg_match("/^" . $this -> bot -> commpre . "t$/i", $msg))
return $this -> show_timers($name);
else if (preg_match("/^" . $this -> bot -> commpre . "t del ([0-9]+)$/i", $msg, $info))
return $this -> delete_timer($name, $info[1]);
else if (preg_match("/^" . $this -> bot -> commpre . "st ([0-9][0-9]?) (.*)$/i", $msg, $info))
return $this -> set_timer($name, 0, $info[1], 0, $info[2]);
else if (preg_match("/^" . $this -> bot -> commpre . "st ([0-9][0-9]?):([0-9][0-9]?) (.*)$/i", $msg, $info))
return $this -> set_timer($name, 0, $info[1], $info[2], $info[3]);
else if (preg_match("/^" . $this -> bot -> commpre . "st ([0-9][0-9]?):([0-9][0-9]?):([0-9][0-9]?) (.*)$/i", $msg, $info))
return $this -> set_timer($name, $info[1], $info[2], $info[3], $info[4]);
else if (preg_match("/^" . $this -> bot -> commpre . "t sort (id|name|time)$/i", $msg, $info))
{
if ($this -> bot -> admin -> in_group($name, "superadmin"))
return $this -> change_sort($info[1]);
}
else if (preg_match("/^" . $this -> bot -> commpre . "t color (id|description|time|alert) (.*)$/i", $msg, $info))
{
if ($this -> bot -> admin -> in_group($name, "superadmin"))
return $this -> change_color($info[1], $info[2]);
}

return "Invalid syntax. Please use !st HH:MM:SS &lt;description&gt; // !st MM:SS &lt;description&gt; // !st MM &lt;description&gt; // !t // !t del <number>";
}


function set_timer($name, $hours, $minutes, $seconds, $description)
{
$stamp = gmmktime() + ($hours*60*60) + ($minutes*60) + $seconds;
$this -> bot -> db -> query("INSERT INTO personaltimers (setby, description, expires) VALUES ('$name', '$description', $stamp)");
$this -> get_timers();
return "Personal timer set.";
}


function get_timers()
{
$sort_order = $this -> sort_order;
$this -> timers = $this -> bot -> db -> select("SELECT * FROM personaltimers WHERE expires > ".gmmktime()." ORDER BY $sort_order ASC");
}


function change_sort($new)
{
if ($new == "id") { $this -> sort_order = "id"; }
else if ($new == "name") { $this -> sort_order = "description"; }
else if ($new == "time") { $this -> sort_order = "expires"; }
else { return "Invalid sort mode. Valid modes are (id|name|time)."; }
$this -> get_timers();
return "Sort mode changed to '$new'.";
}


function change_color($change, $color)
{
if ($change == "id") { $this -> id_color = $color; }
else if ($change == "description") { $this -> description_color = $color; }
else if ($change == "time") { $this -> time_color = $color; }
else if ($change == "alert") { $this -> alert_color = $color; }
else { return "Invalid color option. Valid options are (id|description|time|alert)."; }
return ucfirst($change)." color changed to $color.";
}


function delete_timer($name, $id)
{
        $result = $this -> bot -> db -> select ("SELECT id, setby, description FROM personaltimers WHERE id = $id");
        if (empty($result)) { return "No timer with that number."; }
if (strtolower($result[0][1]) != strtolower($name)) { return "No timer with that number."; }
$description = $result[0][2];
$this -> bot -> db -> query("DELETE FROM personaltimers WHERE id = $id");
$this -> get_timers();
return "Personal timer '$description' deleted.";
}


function show_timers($name)
{
if (empty($this -> timers))
{
return "No personal timers set.";
}
else
{
$idcolor = $this -> id_color;
$desccolor = $this -> description_color;
$timecolor = $this -> time_color;

// make output
//$output = "\n<font color=#ffff00>--------------------------------------------------------</font>\n";
$output = "Personal timers";
foreach($this -> timers as $timer)
{
if ($timer[1] == $name)
{
$time = $this -> format_seconds($timer[3] - gmmktime());
$output .= "\n    <font color=$idcolor>$timer[0]. <font color=$desccolor>$timer[2] <font color=$timecolor>$time";
}
}
//$output = "<font color=#ffff00>--------------------------------------------------------</font>";
return $output;
}
}


function format_seconds($totalsec)
{
$hours = floor( $totalsec / (60*60) );
$rest = $totalsec % (60*60);
$minutes = floor( $rest / 60 );
$seconds = $rest % 60;
return sprintf("%02d:%02d:%02d", $hours, $minutes, $seconds);
}



function cron()
{
$alertcolor = $this -> alert_color;
$tcolor = $this -> time_color;
if (!empty($this -> timers))
{
foreach($this -> timers as $timer)
{
$secleft = $timer[3] - gmmktime();
if( $secleft <= 3600 && $secleft >= 3599 ) {
$this -> bot -> send_tell($timer[1], "Timer: <font color=$alertcolor>$timer[2] in <font color=$tcolor>1 hour</font>!");
}
else if( $secleft <= 1 ) {
$this -> bot -> send_tell($timer[1], "Timer: <font color=$alertcolor>$timer[2] <font color=$tcolor>now</font>!");
$this -> bot -> db -> query("DELETE FROM personaltimers WHERE id = ".$timer[0]);
$this -> get_timers();
}
}
}
}

}
?>

You need to edit the users array and put your player name or multiple multiple names in it.
It should be easy to make a command to add users, too many timers would lag the bot though.

$this -> users = array("wanuarmi");
$this -> users = array("wanuarmi", "user2");

Could you explain a bit more what needs to be done to the db? array? Im some what confused

It works great! want a couple more functions, if possible 

!stg sets a global timer that everyone can see
!tg shows global timers
!ta admin users can show all timers global and personal

Possibiliy to set alert at 1 min left and 10 sek left of timer in addition to the 1 hour warning..

You can add the aoc -> buddy_online in each instance where it is sending tells to ensure that no tells are sent if member is offline.  Should speed it up somewhat.

IE:

$msg = "ZODSNET TIMER: <font color=$dcolor>$timer[2] <font color=$tcolor>now</font>!";
if($timer[4] == 1)
{
foreach($members AS $member)
if ($this -> bot -> aoc -> buddy_online($member[1]))
$this -> bot -> send_tell($member[1], $msg);
$this -> bot -> send_pgroup($msg);
$this -> bot -> send_gc($msg);
}
You could use this SQL to pull names from a particular admin group (in this case "Zodsnet"):

$this -> users = $this -> bot -> db -> select ("SELECT admin_members.name FROM admin_members, admin_groups WHERE admin_members.admin_group = admin_groups.id AND admin_groups.name = 'zodsnet'");