function rp($from,$to) {
if ($from > $to && !empty($to)) {
$temp = $from;
$from = $to;
$to = $temp;
}
if ($from < 1 || (($to>10 && !empty($to)) || $from>10))
$ret = "Enter a number between 1 and 10.";
elseif (empty($to)) {
$qry = "select rp from level where level=$from";
$res = $this->bot->db->select($qry);
$qry2 = "select rp2 from level where level=$from";
$res2 = $this->bot->db->select($qry2);
$qry3 = "select capxp from level where level=$from";
$res3 = $this->bot->db->select($qry3);
$qry4 = "select capsk from level where level=$from";
$res4 = $this->bot->db->select($qry4);
$ret = $this->bot->colors->colorize("text","At research level ".$this->bot->colors->colorize("num",$from)." you need ".$this->bot->colors->colorize("num",number_format($res[0][0])." XP")." with a cap of ".$this->bot->colors->colorize("num",number_format($res3[0][0])." XP") ." or ".$this->bot->colors->colorize("num",number_format($res2[0][0])." SK")." with a cap of ".$this->bot->colors->colorize("num",number_format($res4[0][0])." SK").", to get the next research level.");
}
else {
$qry = "select sum(rp) as rp from level where level>$from AND level<=$to";
$res = $this->bot->db->select($qry);
$qry2 = "select sum(rp2) as rp2 from level where level>$from AND level<=$to";
$res2 = $this->bot->db->select($qry2);
$ret = $this->bot->colors->colorize("text","From the beginning of research level ".$this->bot->colors->colorize("num",$from)." to the end of research level ".$this->bot->colors->colorize("num",$to)." you need ".$this->bot->colors->colorize("num", number_format($res[0][0])." XP")." or ".$this->bot->colors->colorize("num", number_format($res2[0][0])." SK"));
}
return $ret;
}