PHP XDb::xSql方法代码示例

function isGeokretInCache($cacheid)
{
    $res = XDb::xSql("SELECT wp_oc, wp_gc, wp_nc, wp_ge, wp_tc\n        FROM caches WHERE cache_id = ? LIMIT 1", $cacheid);
    $cache_record = XDb::xFetchArray($res);
    // get cache waypoint
    $cache_wp = '';
    if ($cache_record['wp_oc'] != '') {
        $cache_wp = $cache_record['wp_oc'];
    } else {
        if ($cache_record['wp_gc'] != '') {
            $cache_wp = $cache_record['wp_gc'];
        } else {
            if ($cache_record['wp_nc'] != '') {
                $cache_wp = $cache_record['wp_nc'];
            } else {
                if ($cache_record['wp_ge'] != '') {
                    $cache_wp = $cache_record['wp_ge'];
                } else {
                    if ($cache_record['wp_tc'] != '') {
                        $cache_wp = $cache_record['wp_tc'];
                    }
                }
            }
        }
    }
    $gkNum = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM gk_item\n        WHERE id IN (\n            SELECT id FROM gk_item_waypoint\n            WHERE wp = :1\n            )\n            AND stateid<>1 AND stateid<>4\n            AND stateid <>5 AND typeid<>2", 0, $cache_wp);
    if ($gkNum == 0) {
        return 0;
    } else {
        return 1;
    }
}

function get_cache_size_from_database()
{
    $cache_size = array();
    $resp = XDb::xSql("SELECT * FROM cache_size ORDER BY id ASC");
    while ($row = XDb::xFetchArray($resp)) {
        $cache_size[] = $row;
    }
    return $cache_size;
}

 function run()
 {
     $sql = "delete from CACHE_ACCESS_LOGS where date_sub(now(), INTERVAL 5 DAY) > event_date";
     set_time_limit(360);
     $s = XDb::xSql($sql);
     $total_deleted = XDb::xNumRows($s);
     set_time_limit(60);
     unset($db);
     echo "total_deleted={$total_deleted}\n";
 }

function online_user()
{
    // add check users id who want to by username hidden
    $rs = XDb::xSql("SELECT `user_id` FROM `sys_sessions`\n        WHERE user_id!=1 AND `sys_sessions`.last_login >(NOW()-INTERVAL 10 MINUTE)\n        GROUP BY `user_id`");
    $online_users = array();
    while ($r = XDb::xFetchArray($rs)) {
        $online_users[] = $r['user_id'];
    }
    return $online_users;
}

function find_news($start, $end)
{
    global $tpl;
    global $lang;
    global $znalezione;
    $wp = XDb::xEscape($_GET['wp']);
    $query = "select id,type,user_id,date,text,deleted from cache_logs where cache_id = (select cache_id from caches where wp_oc = '" . $wp . "') order by date desc limit " . $start . "," . $end;
    $wynik = XDb::xSql($query);
    $query = "select name,cache_id from caches where cache_id = (select cache_id from caches where wp_oc = '" . $wp . "');";
    $wynik2 = XDb::xSql($query);
    $caches = XDb::xFetchArray($wynik2);
    $tpl->assign("name", $caches['name']);
    // detailed cache access logging
    global $enable_cache_access_logs;
    if (@$enable_cache_access_logs) {
        $dbc = OcDb::instance();
        $cache_id = $caches['cache_id'];
        $user_id = @$_SESSION['user_id'] > 0 ? $_SESSION['user_id'] : null;
        $access_log = @$_SESSION['CACHE_ACCESS_LOG_VL_' . $user_id];
        if ($access_log === null) {
            $_SESSION['CACHE_ACCESS_LOG_VL_' . $user_id] = array();
            $access_log = $_SESSION['CACHE_ACCESS_LOG_VL_' . $user_id];
        }
        if (@$access_log[$cache_id] !== true) {
            $dbc->multiVariableQuery('INSERT INTO CACHE_ACCESS_LOGS
                        (event_date, cache_id, user_id, source, event, ip_addr, user_agent, forwarded_for)
                     VALUES
                        (NOW(), :1, :2, \'M\', \'view_logs\', :3, :4, :5)', $cache_id, $user_id, $_SERVER['REMOTE_ADDR'], $_SERVER['HTTP_USER_AGENT'], $_SERVER['HTTP_X_FORWARDED_FOR']);
            $access_log[$cache_id] = true;
            $_SESSION['CACHE_ACCESS_LOG_VL_' . $user_id] = $access_log;
        }
    }
    $znalezione = array();
    while ($logs = XDb::xFetchArray($wynik)) {
        if ($logs['deleted'] == 0) {
            $query = "select username from user where user_id = '" . $logs['user_id'] . "';";
            $wynik3 = XDb::xSql($query);
            $user = XDb::xFetchArray($wynik3);
            $logs2['id'] = $logs['id'];
            $logs2['user_id'] = $logs['user_id'];
            $logs2['newtype'] = $logs['type'];
            $logs2['newdate'] = date('j.m.Y', strtotime($logs['date']));
            $logs2['username'] = $user[0];
            $logs2['newtext'] = html2log($logs['text']);
            $znalezione[] = $logs2;
        }
    }
    $tpl->assign("wp_oc", $wp);
    $tpl->assign("logs", $znalezione);
}

function find_news($start, $end)
{
    global $tpl;
    $query = "SELECT id,date_posted,content FROM `news` order by id desc limit " . $start . "," . $end;
    $wynik = XDb::xSql($query);
    $ile = XDb::xNumRows($wynik);
    $znalezione = array();
    while ($odp2 = XDb::xFetchArray($wynik)) {
        $odp['date_posted'] = $odp2['date_posted'];
        //$odp['content']=strip_tags($odp2['content'],'<b></b><p></p><a></a><br><br/>');
        $odp['content'] = html2desc($odp2['content']);
        $znalezione[] = $odp;
    }
    $tpl->assign('news', $znalezione);
    return $ile;
}

 function find_news($start, $end)
 {
     global $lang;
     global $ile;
     global $url;
     global $znalezione;
     $query = "select cache_id from cache_watches where user_id=" . $_SESSION['user_id'] . " limit " . $start . "," . $end;
     $wynik = XDb::xSql($query);
     $ile2 = XDb::xNumRows($wynik);
     if ($ile2 > 0) {
         $znalezione = array();
         while ($rek = XDb::xFetchArray($wynik)) {
             $query = "select status,cache_id,name, score, latitude, longitude, wp_oc, user_id, type from caches where cache_id=" . $rek['cache_id'] . " order by name";
             $wynik2 = XDb::xSql($query);
             while ($rekord = XDb::xFetchArray($wynik2)) {
                 if (isset($_SESSION['user_id'])) {
                     $query2 = "select 1 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '1' and deleted='0' and cache_id ='" . $rekord['cache_id'] . "';";
                     $wynik2 = XDb::xSql($query2);
                     $if_found = XDb::xFetchArray($wynik2);
                     if ($if_found[0] != '1') {
                         $query2 = "select 2 from cache_logs where user_id = '" . $_SESSION['user_id'] . "' and type = '2' and deleted='0' and cache_id ='" . $rekord['cache_id'] . "';";
                         $wynik2 = XDb::xSql($query2);
                         $if_found = XDb::xFetchArray($wynik2);
                     }
                     $if_found = $if_found[0];
                 }
                 $query = "select username from user where user_id = " . $rekord['user_id'] . ";";
                 $wynik2 = XDb::xSql($query);
                 $wiersz = XDb::xFetchArray($wynik2);
                 $query = "select " . $lang . " from cache_type where id = " . $rekord['type'] . ";";
                 $wynik2 = XDb::xSql($query);
                 $wiersz2 = XDb::xFetchArray($wynik2);
                 $rekord['if_found'] = $if_found;
                 $rekord['username'] = $wiersz['username'];
                 $rekord['N'] = cords($rekord['latitude']);
                 $rekord['E'] = cords($rekord['longitude']);
                 $rekord['typetext'] = $wiersz2[0];
                 $znalezione[] = $rekord;
             }
         }
     }
 }

function genStatPieUrl()
{
    $startDate = mktime(0, 0, 0, 1, 1, 2006);
    global $lang;
    if (checkField('cache_type', $lang)) {
        $lang_db = XDb::xEscape($lang);
    } else {
        $lang_db = "en";
    }
    // Get data
    $rsTypes = XDb::xSql("SELECT COUNT(`caches`.`type`) `count`, `cache_type`.`{$lang_db}` AS `type`, `cache_type`.`color`\n        FROM `caches` INNER JOIN `cache_type` ON (`caches`.`type`=`cache_type`.`id`)\n        WHERE `status`=1\n        GROUP BY `caches`.`type`\n        ORDER BY `count` DESC");
    $yData = array();
    $xData = array();
    $colors = array();
    $url = "http://chart.apis.google.com/chart?chs=550x200&chd=t:";
    $sum = 0;
    while ($rTypes = XDb::xFetchArray($rsTypes)) {
        $yData[] = ' (' . $rTypes['count'] . ') ' . $rTypes['type'];
        $xData[] = $rTypes['count'];
        $colors[] = substr($rTypes['color'], 1);
        $sum += $rTypes['count'];
    }
    XDb::xFreeResults($rsTypes);
    foreach ($xData as $count) {
        $url .= normTo100($count, $sum) . ",";
    }
    $url = substr($url, 0, -1);
    $url .= "&cht=p3&chl=";
    foreach ($yData as $label) {
        $url .= urlencode($label) . "|";
    }
    $url = substr($url, 0, -1);
    $url .= "&chco=";
    foreach ($colors as $color) {
        $url .= urlencode($color) . ",";
    }
    return $url = substr($url, 0, -1);
}

/**
 * Reads user map settings from the DB
 * @param int $user_id - user identifier
 */
function getDBFilter($user_id)
{
    global $MIN_SCORE, $MAX_SCORE, $powerTrailModuleSwitchOn;
    // defined in settings.inc/php
    $filter = array("h_u" => 1, "h_t" => 1, "h_m" => 1, "h_v" => 1, "h_w" => 1, "h_e" => 1, "h_q" => 1, "h_o" => 1, "h_owncache" => 1, "h_ignored" => 0, "h_own" => 1, "h_found" => 1, "h_noattempt" => 1, "h_nogeokret" => 1, "h_avail" => 0, "h_temp_unavail" => 1, "map_type" => 1, "h_arch" => 0, "be_ftf" => 0, "powertrail_only" => 0, "min_score" => $MIN_SCORE, "max_score" => $MAX_SCORE, "h_noscore" => 1);
    // default filter
    $query = XDb::xSql("SELECT * FROM map_settings WHERE `user_id`= ? LIMIT 1", $user_id);
    while ($row = XDb::xFetchArray($query)) {
        $filter["h_u"] = $row['unknown'];
        $filter["h_t"] = $row['traditional'];
        $filter["h_m"] = $row['multicache'];
        $filter["h_v"] = $row['virtual'];
        $filter["h_w"] = $row['webcam'];
        $filter["h_e"] = $row['event'];
        $filter["h_q"] = $row['quiz'];
        $filter["h_o"] = $row['mobile'];
        $filter["h_owncache"] = $row['owncache'];
        $filter["h_ignored"] = $row['ignored'];
        $filter["h_own"] = $row['own'];
        $filter["h_found"] = $row['found'];
        $filter["h_noattempt"] = $row['notyetfound'];
        $filter["h_nogeokret"] = $row['geokret'];
        $filter["h_avail"] = $row['active'];
        $filter["h_temp_unavail"] = $row['notactive'];
        $filter["map_type"] = $row['maptype'];
        $filter["h_arch"] = $row['archived'];
        $filter["be_ftf"] = $row['be_ftf'];
        if ($powerTrailModuleSwitchOn) {
            $filter["powertrail_only"] = $row['powertrail_only'];
        }
        $filter["min_score"] = $row['min_score'];
        $filter["max_score"] = $row['max_score'];
        $filter["h_noscore"] = $row['noscore'];
    }
    return $filter;
}

function event_notify_new_cache($cache_id)
{
    global $rootpath;
    //prepare the templates and include all neccessary
    require_once $rootpath . 'lib/search.inc.php';
    $rs = XDb::xSql('SELECT `caches`.`latitude`, `caches`.`longitude`
        FROM `caches`
        WHERE `caches`.`cache_id`= ? ', $cache_id);
    $r = XDb::xFetchArray($rs);
    $latFrom = $r['latitude'];
    $lonFrom = $r['longitude'];
    XDb::xFreeResults($rs);
    $distanceMultiplier = 1;
    // TODO: Seeking pre-select `user`. `latitude` like with max_lon / min_lon / max_lat / min_lat
    XDb::xSql('INSERT INTO `notify_waiting` (`id`, `cache_id`, `user_id`, `type`)
        SELECT NULL, ' . XDb::xEscape($cache_id) . ', `user`.`user_id`, ' . NOTIFY_NEW_CACHES . '
        FROM `user`
        WHERE NOT ISNULL(`user`.`latitude`)
          AND NOT ISNULL(`user`.`longitude`)
          AND `user`.`notify_radius` > 0
          AND (acos(cos((90- ? ) * 3.14159 / 180) * cos((90-`user`.`latitude`) * 3.14159 / 180) +
              sin((90-?) * 3.14159 / 180) * sin((90-`user`.`latitude`) * 3.14159 / 180) * cos(( ? -`user`.`longitude`) *
              3.14159 / 180)) * 6370 * ?) <= `user`.`notify_radius`', $latFrom, $latFrom, $lonFrom, $distanceMultiplier);
}

<?php

use Utils\Database\XDb;
global $lang, $rootpath;
if (!isset($rootpath)) {
    $rootpath = './';
}
//include template handling
require_once $rootpath . 'lib/common.inc.php';
setlocale(LC_TIME, 'pl_PL.UTF-8');
echo '<table width="97%"><tr><td align="center"><center><b>' . tr('Stats_t5_01') . '</b><br /><br />' . tr('Stats_t5_02') . ': (z% - <b><font color="green">X</font>/<font color="blue">Y</font></b>) X- ' . tr('Stats_t5_03') . ', Y - ' . tr('Stats_t5_04') . ', <br /> z - ' . tr('Stats_t5_05') . ' % ' . tr('Stats_t5_06') . ' (X/Y)*100<br /><br /></center></td></tr> </table>';
echo '<table border="1" bgcolor="white" width="97%" style="font-size:11px; line-height:1.6em;">' . "\n";
$linie = XDb::xSql("SELECT count(*) count, user.username username, user.user_id user_id\n    FROM caches, cache_rating, user\n    WHERE `cache_rating`.`cache_id`=caches.cache_id\n        AND caches.user_id=user.user_id\n        AND caches.type <> 6\n    GROUP BY `user`.`user_id`\n    ORDER BY `count` DESC, `user`.`username` ASC");
echo '<tr><td class="bgcolor2" align="right"><b>' . tr('Stats_t5_07') . '</b>&nbsp;&nbsp;</td><td class="bgcolor2" align="center"><img src="images/rating-star.png" border="0" alt="Recommendations" />&nbsp;<b>' . tr('Stats_t5_08') . '</b>&nbsp;&nbsp;</td><td class="bgcolor2" align="center"><b>' . tr('Stats_t5_09') . '</b>&nbsp;&nbsp;</td></tr><tr><td>';
$l2 = "";
$licznik = 0;
while ($linia = XDb::xFetchArray($linie)) {
    $l1 = $linia['count'];
    $x = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM caches\n        WHERE `caches`.`topratings` >= 1\n            AND caches.type <> 6\n            AND caches.user_id= :1 ", 0, $linia['user_id']);
    $y = XDb::xMultiVariableQueryValue("SELECT COUNT(*) FROM caches\n        WHERE user_id= :1\n            AND status <> 4 AND status <> 5\n            AND status <> 6 AND type <> 6", 0, $linia['user_id']);
    if ($y != 0) {
        $xy = sprintf("%.u", $x / $y * 100);
    } else {
        $xy = 0;
    }
    if ($l2 != $l1) {
        $licznik++;
        echo "</td></tr><tr><td class=\"bgcolor2\" align=\"right\">&nbsp;&nbsp;<b>{$licznik}</b>&nbsp;&nbsp;</td><td class=\"bgcolor2\" align=\"right\">&nbsp;&nbsp;<b>{$l1}</b>&nbsp;&nbsp;</td>";
        echo "<td class=\"bgcolor2\"><a class=\"links\" href=\"viewprofile.php?userid=" . $linia['user_id'] . "\">" . htmlspecialchars($linia['username']) . " (<font color=\"firebrick\">{$xy}% - </font><font color=\"green\">{$x}</font>/<font color=\"blue\">{$y}</font>)</a>";
        $l2 = $l1;
    } else {

             $allOk = false;
         }
         if ($text <= "") {
             $message_errnotext = $errnotext;
             $allOk = false;
         }
         if ($allOk) {
             $subject = mb_ereg_replace('{subject}', $subject, $mailsubject);
             $subject = mb_ereg_replace('{from_username}', $from_username, $subject);
             $text = mb_ereg_replace('{{text}}', $text, $send_emailaddress == 1 ? $mailtext_email : $mailtext_anonymous);
             $text = mb_ereg_replace('{from_userid}', $usr["userid"], $text);
             $text = mb_ereg_replace('{from_email}', $from_email, $text);
             $text = mb_ereg_replace('{from_username}', $from_username, $text);
             $text = mb_ereg_replace('{to_email}', $to_email, $text);
             $text = mb_ereg_replace('{to_username}', $to_username, $text);
             XDb::xSql("INSERT INTO `email_user`\n                              SET `ipaddress`=? , `date_generated`=NOW(), `date_sent`='0',\n                                  `from_user_id`= ? , `from_email`=?, `to_user_id`=?,\n                                  `to_email`=?, `mail_subject`=?, `mail_text`=?, `send_emailaddress`=?", $_SERVER["REMOTE_ADDR"], $usr['userid'], $from_email, $userid, $to_email, $subject, $text, $send_emailaddress);
             tpl_redirect('mailto.php?userid=' . urlencode($userid) . '&message=' . urlencode($message_sent));
         }
     }
 }
 // display
 tpl_set_var('userid', htmlspecialchars($userid, ENT_COMPAT, 'UTF-8'));
 tpl_set_var('to_username', htmlspecialchars($to_username, ENT_COMPAT, 'UTF-8'));
 if ($message) {
     tpl_set_var('message_start', '');
     tpl_set_var('message_end', '');
     tpl_set_var('message', strip_tags($message));
     tpl_set_var('formular_start', '<!--');
     tpl_set_var('formular_end', '-->');
 } else {
     tpl_set_var('message_start', '<!--');

                // end of read
                //we get the point data in to an array called $points:
                if (!$error) {
                    for ($i = 0; $i < count($coords) - 1; $i = $i + 2) {
                        $points[] = array("lon" => $coords[$i], "lat" => $coords[$i + 1]);
                        if ($coords[$i] + 0 == 0 or $coords[$i + 1] + 0 == 0) {
                            $error .= "Invalid Co-ords found in import file.<br>\n";
                            break;
                        }
                    }
                }
                // add it to the route_points database:
                $point_num = 0;
                foreach ($points as $point) {
                    $point_num++;
                    $result = XDb::xSql('INSERT into route_points (route_id, point_nr, lat, lon)
                                VALUES ( ?, ?, ?, ?)', $route_id, $route_id, $point['lat'], $point['lon']);
                }
            }
            //end update points
            tpl_redirect('myroutes.php');
            exit;
        }
        //end submit
        tpl_set_var('name', htmlspecialchars($record['name'], ENT_COMPAT, 'UTF-8'));
        tpl_set_var('desc', htmlspecialchars($record['description'], ENT_COMPAT, 'UTF-8'));
        tpl_set_var('radius', $record['radius']);
        tpl_set_var('routeid', $route_id);
    }
}
//make the template and send it out
tpl_BuildTemplate();

<?php

use Utils\Database\XDb;
//prepare the templates and include all neccessary
require_once './lib/common.inc.php';
//Preprocessing
if ($error == false) {
    //get the news
    $tplname = 'news';
    $newscontent = '';
    require $stylepath . '/news.inc.php';
    $rsNewsTopics = XDb::xSql('SELECT `name`, `id` FROM `news_topics` ORDER BY `id` ASC');
    while ($rNewsTopics = XDb::xFetchArray($rsNewsTopics)) {
        $rsNews = XDb::xSql("SELECT `date_posted`, `content` FROM `news`\n            WHERE `topic`= ? AND `display`=1\n            ORDER BY `date_posted` DESC LIMIT 0, 20", $rNewsTopics['id']);
        while ($rNews = XDb::xFetchArray($rsNews)) {
            $thisnewscontent = $tpl_newstopic_without_topic;
            $thisnewscontent = mb_ereg_replace('{date}', date('d-m-Y', strtotime($rNews['date_posted'])), $thisnewscontent);
            $thisnewscontent = mb_ereg_replace('{message}', $rNews['content'], $thisnewscontent);
            $newscontent .= $thisnewscontent . "\n";
        }
        XDb::xFreeResults($rsNews);
    }
    XDb::xFreeResults($rsNewsTopics);
    //$newscontent .= "</table>";
    tpl_set_var('list_of_news', $newscontent);
}
//make the template and send it out
tpl_BuildTemplate();

<?php

use Utils\Database\XDb;
//prepare the templates and include all neccessary
global $rootpath;
require_once './lib/common.inc.php';
//Preprocessing
if ($error == false) {
    //user logged in?
    if ($usr == false) {
        $target = urlencode(tpl_get_current_page());
        tpl_redirect('login.php?target=' . $target);
    } else {
        $tplname = 'myroutes';
        $user_id = $usr['userid'];
        $route_rs = XDb::xSql("SELECT `route_id` ,`description` `desc`, `name`,`radius`,`length`\n            FROM `routes`  WHERE `user_id`= ?\n            ORDER BY `route_id` DESC", $user_id);
        if ($routes_record = XDb::xFetchArray($route_rs)) {
            $routes .= '<div class="headitems">';
            $routes .= '<div style="width:80px;" class="myr">' . tr('route_name') . '</div><div class="ver">&nbsp;</div><div style="width:295px;" class="myr">&nbsp;' . tr('route_desc') . '</div><div class="ver">&nbsp;</div><div style="width:60px;" class="myr">&nbsp;' . tr('radius') . '</div><div class="ver">&nbsp;</div><div style="width:60px;" class="myr">&nbsp;' . tr('length') . '</div><div class="ver">&nbsp;</div><div style="width:70px;" class="myr">&nbsp;' . tr('caches') . '</div><div class="ver">&nbsp;</div><div style="width:50px;" class="myr">' . tr('edit') . '</div><div class="ver">&nbsp;</div><div style="width:20px;" class="myr">&nbsp;' . tr('delete') . '</div></div>';
            do {
                $desc = $routes_record['desc'];
                if ($desc != '') {
                    require_once $rootpath . 'lib/class.inputfilter.php';
                    $myFilter = new InputFilter($allowedtags, $allowedattr, 0, 0, 1);
                    $desc = $myFilter->process($desc);
                }
                $routes .= '<div class="listitems">';
                //                          $routes .= '<div style="margin-left:5px;width:75px;" class="myr">'.$routes_record['name']. '</div><div class="ver35">&nbsp;</div><div style="width:295px;" class="myr">'.nl2br($desc).'</div><div class="ver35">&nbsp;</div><div style="width:60px;text-align:center;" class="myr">'.$routes_record['radius']. ' km</div><div class="ver35">&nbsp;</div><div style="width:60px;text-align:center;" class="myr">'.round($routes_record['length'],0). ' km</div><div class="ver35">&nbsp;</div><div style="width:70px;float:left;text-align:center;"><a class="links" href="myroutes_search.php?routeid='.$routes_record['route_id'].'"><img src="tpl/stdstyle/images/action/16x16-search.png" alt="" title="Search caches along route" /></a></div><div class="ver35">&nbsp;</div><div style="width:50px;float:left;text-align:center;"><a class="links" href="myroutes_edit.php?routeid='.$routes_record['route_id'].'"><img src="images/actions/edit-16.png" alt="" title="Edit route" /></a></div><div class="ver35">&nbsp;</div><div style="width:20px;float:left;text-align:center;"><a class="links" href="myroutes_edit.php?routeid='.$routes_record['route_id'].'&delete" onclick="return confirm(\'Czy chcesz usunąć tę trase?\');"><img src="tpl/stdstyle/images/log/16x16-trash.png" alt="" title="Usuń" /></a></div></div>';
                $routes .= '<table border="0" class="myr"><tr><td style="margin-left:3px;width:75px;" class="myr">' . $routes_record['name'] . '</td><td width="2" style="border-right:solid thin #7fa2ca"></td>
                            <td style="width:297px;" class="myr">' . nl2br($desc) . '</td><td width="2" style="border-right:solid thin #7fa2ca"></td>
                            <td style="width:65px;" class="myr">' . $routes_record['radius'] . ' km</td><td width="2" style="border-right:solid thin #7fa2ca"></td>