Exemplo n.º 1
0
 public function display($iPLID, $sColor, $iSTime, $iBTime)
 {
     $Player = $this->getPlayerByPLID($iPLID);
     # Skip displaying lap out data & AI.
     if ($iSTime >= 3600000 or $Player->isAI()) {
         return;
     }
     $sPName = $Player->PName . '^9';
     $sTime = $sColor . timeToStr($iSTime) . '^9';
     $sΔ = (($sΔ = $iSTime - $iBTime) < 0 ? '^2-' : '^3+') . timeToStr(abs($sΔ)) . '^9';
     //		Msg2Lfs()->PLID($iPLID)->Text("{$sPName} : {$sTime} ($sΔ)")->Send();
     $this->OSD($this->getClientByPLID($iPLID)->UCID, $sPName, $sTime, $sΔ);
 }
Exemplo n.º 2
0
 function getMyCustomerEx()
 {
     header('Access-Control-Allow-Origin:*');
     //跨域
     header("Content-type: text/html; charset=utf-8");
     $param = json_decode(file_get_contents('php://input'), true);
     $token = $param['xtoken'];
     init_verify_token($token);
     $coachid = $param['coachid'];
     // $coachid = 53;
     if (empty($coachid)) {
         err_ret(-205, 'lack of param', '缺少参数');
     }
     //最新付款的
     $sql = "SELECT user_info.id,user_info.username,user_info.username,user_info.name,user_info.header,user_info.birthday,user_info.gender,user_info.height,user_info.weight,my_plan.course_time,my_plan.pid,my_plan.pay_time,my_plan.begin_time,my_plan.end_time,my_plan.status,my_plan.iscontacted,my_plan.isfinished\n                FROM user_info,my_plan  \n                WHERE my_plan.coachid={$coachid} AND my_plan.uid=user_info.id AND user_info.type=2";
     $model = new Model();
     $result = $model->query($sql);
     $new_pay_list = array();
     //最新付款
     $complete_test = array();
     //完成测试
     $usual_remind = array();
     //日常督促
     // $update_plan    = array();     //更新计划
     for ($i = 0; $i < count($result); $i++) {
         //最新付款的
         if (isSameDay($result[$i]['pay_time'], time())) {
             //如果是今天付款的
             $new_pay_list[] = $result[$i];
         }
         //完成测试
         if ($result[$i]['status'] == 2) {
             $complete_test[] = $result[$i];
         }
         //日常督促(昨天,今天,明天有计划的)
         if (timeToStr($result[$i]['course_time']) == getYesterday() || timeToStr($result[$i]['course_time']) == getToday() || timeToStr($result[$i]['course_time']) == getTomorrow()) {
             $usual_remind[] = $result[$i];
         }
         //更新训练课程的
         // if( (getTomorrow() == timeToStr($result[$i]['course_time'])
         //    || getAfterTomorrow() == timeToStr($result[$i]['course_time']))
         //    && (timediffDay($result[$i]['course_time'],$result[$i]['end_time']) == 1
         //     ||( timediffDay($result[$i]['course_time'],$result[$i]['end_time']) == 2))){
         //     $update_plan[] = $result[$i];
         // }
     }
     $data['errno'] = 0;
     $data['new_pay_list'] = $new_pay_list;
     $data['complete_test'] = $complete_test;
     $data['usual_remind'] = $usual_remind;
     $data['update_plan'] = [];
     echo json_encode($data);
 }
Exemplo n.º 3
0
 $vyhledavace["Jyxo"] = "jyxo";
 $vyhledavace["Centrum"] = "centrum";
 $vyhledavace["Yahoo"] = "yahoo";
 $vyhledavace["MSN"] = "msn";
 foreach ($vyhledavace as $key => $value) {
     // Poslední dva výskyty
     $dotaz = Mysql_query("SELECT * FROM {$CONF['sqlPrefix']}statRobots WHERE LOWER(user_agent) LIKE '%{$value}%' ORDER BY time DESC");
     $radek = mysql_fetch_assoc($dotaz);
     $radek2 = mysql_fetch_assoc($dotaz);
     // Počet celkem
     $count = mysql_fetch_assoc(Mysql_query("SELECT COUNT(*) FROM {$CONF['sqlPrefix']}statRobots WHERE LOWER(user_agent) LIKE '%{$value}%' "));
     // Počet / měsíc
     $count2 = mysql_fetch_assoc(Mysql_query("SELECT COUNT(*) FROM {$CONF['sqlPrefix']}statRobots WHERE LOWER(user_agent) LIKE '%{$value}%' AND time<" . time() . " AND time>" . (time() - 60 * 60 * 24 * 30) . " "));
     // Zobrazení
     $bgcolor = $i % 2 ? "#EFEFEF" : "#DFDFDF";
     echo "<tr>\n                    <td bgcolor={$bgcolor}>{$key}</td>\n                    <td bgcolor={$bgcolor}>" . ($radek["time"] ? date("j.n.Y G:i", $radek["time"]) : "&nbsp;- bez návštěvy - ") . "</td>\n                    <td bgcolor={$bgcolor}>" . $count["COUNT(*)"] . "</td>                \n                    <td bgcolor={$bgcolor}>" . $count2["COUNT(*)"] . "x / měsíc</td>\n                    <td bgcolor={$bgcolor}>" . ($radek2["time"] ? timeToStr($radek["time"] - $radek2["time"]) : '') . "</td>\n                  </tr>";
     $i++;
 }
 echo "</table>";
 //////////////////////
 // Poslední návštěvy
 //////////////////////
 echo "<h3>Posledních 30 návštěv</h3>\n          <table border=0 width=100%>\n            <tr>\n              <td bgcolor=#CFCFCF width=40><strong>id</strong></td> \n              <td bgcolor=#CFCFCF><strong>Název vyhledávače</strong></td>\n              <td bgcolor=#CFCFCF width=160><strong>Datum</strong></td>     \n            </tr>\n          </table>\n          <div style=\"\"> <!--height: 200px; overflow: auto;-->\n          <table border=0 width=100%>\n          ";
 $dotaz = Mysql_query("SELECT * FROM {$CONF['sqlPrefix']}statRobots ORDER BY time DESC LIMIT 30");
 $i = 1;
 while ($radek = mysql_fetch_assoc($dotaz)) {
     $bgcolor = $i % 2 ? "#EFEFEF" : "#DFDFDF";
     echo "<tr>\n                  <td bgcolor={$bgcolor} width=40>{$radek['id']}</td>\n                  <td bgcolor={$bgcolor}>" . identifier($radek["user_agent"]) . "</td>\n                  <td bgcolor={$bgcolor} width=144>" . date("j.n.Y G:i", $radek["time"]) . "</td>\n                 </tr>";
     $i++;
 }
 echo "</table>\n          </div>";
Exemplo n.º 4
0
/**
 * This file is part of GrottoCenter.
 *
 * GrottoCenter is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * GrottoCenter is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with GrottoCenter.  If not, see <http://www.gnu.org/licenses/>.
 *
 * @copyright Copyright (c) 2009-2012 Cl�ment Ronzon
 * @license http://www.gnu.org/licenses/agpl.txt
 */
function getProperties($category, $id, $isConnected, $labelsBlank, $labelsSinceDate, $addTitle, $systemArray = array(), $for_printer = false, $opener)
{
    switch ($category) {
        case "entry":
            $AvgAe = getAvgAestheticism($id);
            $sqlAe = "SELECT round(Aestheticism) AS Aestheticism FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
            $AvgCa = getAvgCaving($id);
            $sqlCa = "SELECT round(Caving) AS Caving FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
            $AvgAp = getAvgApproach($id);
            $sqlAp = "SELECT round(Approach) AS Approach FROM `" . $_SESSION['Application_host'] . "`.`T_comment` WHERE Id_entry=" . $id;
            if (!$addTitle) {
                $histoAe = "<div onclick=\"JavaScript:infoHistoAe();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlAe, 'Aestheticism') . "\" alt=\"image\" /></div>\n";
                $histoCa = "<div onclick=\"JavaScript:infoHistoCa();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlCa, 'Caving') . "\" alt=\"image\" /></div>\n";
                $histoAp = "<div onclick=\"JavaScript:infoHistoAp();\" class=\"histo\"><img src=\"" . getHistoSrc($sqlAp, 'Approach') . "\" alt=\"image\" /></div>\n";
            } else {
                $histoAe = "";
                $histoCa = "";
                $histoAp = "";
            }
            $sql = "SELECT cat.*, ty." . $_SESSION['language'] . "_type AS typeName, ca.Name as NetwName, ca.Id as NetwId, ma.Name AS MasName, ma.Id AS MasId, ";
            //$sql .= "IF(ISNULL(ca.Id)=1,eybis.Min_depth,ca.Min_depth) AS Min_depth, ";
            //$sql .= "IF(ISNULL(ca.Id)=1,eybis.Max_depth,ca.Max_depth) AS Max_depth, ";
            $sql .= "IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth) AS Depth, ";
            $sql .= "IF(ISNULL(ca.Id)=1,eybis.Is_diving,ca.Is_diving) AS Is_diving, ";
            $sql .= "IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length) AS Length, ";
            $sql .= "IF(ISNULL(ca.Id)=1,eybis.Temperature,ca.Temperature) AS Temperature, ";
            $sql .= "IF(ISNULL(ca.Id)=1,NULL,(SELECT COUNT(*) FROM `" . $_SESSION['Application_host'] . "`.`J_cave_entry` WHERE ca.Id = Id_cave)) AS NumberOfEntries, ";
            $sql .= "GROUP_CONCAT(DISTINCT u.Url ORDER BY u.Url SEPARATOR '<br />\n') AS Partners ";
            $sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` cat ";
            $sql .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`T_single_entry` eybis ON cat.Id = eybis.Id ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_type` ty ON cat.Id_type = ty.Id ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON cat.Id = ce.Id_entry ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_cave` ca ON ce.Id_cave = ca.Id ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON (mc.Id_cave = ca.Id OR mc.Id_entry = cat.Id) ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_massif` ma ON ma.Id = mc.Id_massif ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_entry_url` eu ON eu.Id_entry = cat.Id ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_url` u ON u.Id = eu.Id_url ";
            break;
        case "cave":
            $listSQL = "SELECT DISTINCT e.Id, e.Name ";
            $listSQL .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` e ";
            $listSQL .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON ce.Id_entry = e.Id ";
            $listSQL .= "WHERE ce.Id_cave = " . $id . " AND e.Is_public = 'YES' ";
            if (!$isConnected) {
                $listSQL .= "AND e.Is_public = 'YES' ";
            }
            $listSQL .= "ORDER BY e.Name ";
            $entryList = getDataFromSQL($listSQL, __FILE__, "function", __FUNCTION__);
            $entriesList = "";
            for ($index = 0; $index < $entryList["Count"]; $index++) {
                $entriesList .= "<a href=\"JavaScript:openMe(" . $entryList[$index]['Id'] . ", 'entry', false);\">" . $entryList[$index]['Name'] . "</a>, ";
            }
            $entriesList = substr($entriesList, 0, strlen($entriesList) - 2);
            $sql = "SELECT cat.*, ma.Name AS MasName, ma.Id AS MasId ";
            $sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_cave` cat ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON mc.Id_cave = cat.Id ";
            $sql .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_massif` ma ON ma.Id = mc.Id_massif ";
            break;
        case "massif":
            $listSQL = "SELECT COUNT(*) AS Nb, ";
            $listSQL .= "-MAX(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Max_Depth, ";
            $listSQL .= "MAX(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Max_Length, ";
            $listSQL .= "SUM(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Sum_Length, ";
            $listSQL .= "-AVG(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Avg_Depth, ";
            $listSQL .= "STD(ABS(IF(ISNULL(ca.Id)=1,eybis.Depth,ca.Depth))) AS Std_Depth, ";
            $listSQL .= "AVG(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Avg_Length, ";
            $listSQL .= "STD(ABS(IF(ISNULL(ca.Id)=1,eybis.Length,ca.Length))) AS Std_Length ";
            $listSQL .= "FROM `" . $_SESSION['Application_host'] . "`.`T_entry` e ";
            $listSQL .= "INNER JOIN `" . $_SESSION['Application_host'] . "`.`T_single_entry` eybis ON e.Id = eybis.Id ";
            $listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_cave_entry` ce ON e.Id = ce.Id_entry ";
            $listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`T_cave` ca ON ca.Id = ce.Id_cave ";
            $listSQL .= "LEFT OUTER JOIN `" . $_SESSION['Application_host'] . "`.`J_massif_cave` mc ON (mc.Id_cave = ce.Id_cave OR mc.Id_entry = e.Id) ";
            $listSQL .= "WHERE mc.Id_massif = " . $id . " ";
            $entriesStats = getDataFromSQL($listSQL, __FILE__, "function", __FUNCTION__);
        default:
            $sql = "SELECT cat.* ";
            $sql .= "FROM `" . $_SESSION['Application_host'] . "`.`T_" . $category . "` cat ";
            break;
    }
    $sql .= "WHERE cat.Id = " . $id . " ";
    if (!$isConnected && $category == "entry") {
        $sql .= "AND cat.Is_public = 'YES' ";
    }
    if ($category == "entry") {
        $sql .= "GROUP BY cat.Id ";
        $sql .= "ORDER BY MasName DESC ";
    }
    $data = getDataFromSQL($sql, __FILE__, $opener, __FUNCTION__);
    if ($data['Count'] > 0) {
        $is_public = $data[0]['Contact_is_public'];
        $is_shown = $category == "caver" && ($is_public == Contact_for_registered && $isConnected || $is_public == Contact_for_everybody) || $category != "caver";
        if ($addTitle) {
            if (isset($data[0]['Nickname'])) {
                $title_name = $data[0]['Nickname'];
            } else {
                $title_name = $data[0]['Name'];
            }
            $innerHTML .= getTopMenu(getCloseBtn("JavaScript:resetDetails();", "<convert>#label=371<convert>") . "<div class=\"frame_title\">" . setTitle("#", "details", "<convert>#label=440<convert> " . $title_name, 1) . "</div>");
            //A propos de
        }
        if ($is_shown) {
            $innerHTML .= getInnerLine($data[0]['Name'], $data[0]['Name'], "<convert>#label=199<convert> :");
            //Nom
        }
        $innerHTML .= getInnerLine($entriesList, $entriesList, "<convert>#label=384<convert> :");
        //Entrées :
        $innerHTML .= getInnerLine($entriesStats[0]['Nb'], $entriesStats[0]['Nb'], "<convert>#label=384<convert> :");
        //Entrées :
        $innerHTML .= getInnerLine($entriesStats[0]['Max_Depth'], round($entriesStats[0]['Max_Depth']), "<convert>#label=758<convert> :", "", "<convert>#label=268<convert>");
        //Prof. Max. ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Avg_Depth'], round($entriesStats[0]['Avg_Depth']), "<convert>#label=759<convert> :", "", "<convert>#label=268<convert>");
        //Prof. Moy. ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Std_Depth'], round($entriesStats[0]['Std_Depth']), "<convert>#label=760<convert> :", "", "<convert>#label=268<convert>");
        //E.Type Prof. ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Max_Length'], round($entriesStats[0]['Max_Length']), "<convert>#label=761<convert> :", "", "<convert>#label=268<convert>");
        //Dev. Max. ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Sum_Length'], round($entriesStats[0]['Sum_Length']), "<convert>#label=762<convert> :", "", "<convert>#label=268<convert>");
        //Dev. Total ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Avg_Length'], round($entriesStats[0]['Avg_Length']), "<convert>#label=763<convert> :", "", "<convert>#label=268<convert>");
        //Dev. Moy. ://m
        $innerHTML .= getInnerLine($entriesStats[0]['Std_Length'], round($entriesStats[0]['Std_Length']), "<convert>#label=764<convert> :", "", "<convert>#label=268<convert>");
        //E.Type Dev. ://m
        if ($isConnected) {
            $innerHTML .= getInnerLine($data[0]['Locked'], convertYN($data[0]['Locked'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=443<convert> :");
            //Oui //Non //Est en cours de modification
            $innerHTML .= getInnerLine($data[0]['Is_public'], convertYN($data[0]['Is_public'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=444<convert> :");
            //Est publique
        }
        $innerHTML .= getInnerLine($data[0]['typeName'], $data[0]['typeName'], "<convert>#label=114<convert> :");
        //Type de sous-sol
        if ($is_shown) {
            $innerHTML .= getInnerLine($data[0]['Surname'], $data[0]['Surname'], "<convert>#label=200<convert> :");
            //Prénom
        }
        $innerHTML .= getInnerLine($data[0]['Nickname'], $data[0]['Nickname'], "<convert>#label=34<convert> :");
        //Alias
        if ($is_shown) {
            $innerHTML .= getInnerLine($data[0]['Date_birth'], timeToStr($data[0]['Date_birth']), "<convert>#label=445<convert> ", "", "<convert>#label=446<convert>", getSinceDateFromD(cDate($data[0]['Date_birth'], false), $labelsBlank), "", "<convert>#label=447<convert>");
            //Né(e) le //(mm/jj/aaaa) //ans
        }
        $innerHTML .= getInnerLine($data[0]['Year_discovery'], $data[0]['Year_discovery'], "<convert>#label=109<convert> :", "", "", getSinceDateFromD("01/01/" . $data[0]['Year_discovery'], $labelsSinceDate));
        //Année de découverte
        $innerHTML .= getInnerLine($data[0]['Year_birth'], $data[0]['Year_birth'], "<convert>#label=147<convert> :", "", "", getSinceDateFromD("01/01/" . $data[0]['Year_birth'], $labelsSinceDate));
        //Année de fondation
        if ($is_shown) {
            //$innerHTML .= getInnerLine($data[0]['Date_inscription'],"<br />".timeToStr($data[0]['Date_inscription']),"<convert>#label=448<convert> ".$_SESSION['Application_name']." :","","<convert>#label=446<convert><br />",getSinceDateFromD(cDate($data[0]['Date_inscription'],false),$labelsSinceDate));//Date d'inscription à //(mm/jj/aaaa)
            $innerHTML .= getInnerLine($data[0]['Connection_counter'], $data[0]['Connection_counter'], "<convert>#label=449<convert> ", "", "<convert>#label=450<convert> " . $_SESSION['Application_name']);
            //S'est connecté //fois sur
            //$innerHTML .= getInnerLine($data[0]['Date_last_connection'],"<br />".timeToStr($data[0]['Date_last_connection']),"<convert>#label=24<convert> :","","<convert>#label=446<convert><br />",getSinceDateFromDT(cDate($data[0]['Date_last_connection'],false),$labelsSinceDate));//Dernière connection //(mm/jj/aaaa)
        }
        if ($isConnected) {
            //$innerHTML .= getInnerLine($data[0]['Date_reviewed'],"<br />".timeToStr($data[0]['Date_reviewed']),"<convert>#label=451<convert> :","","<convert>#label=446<convert><br />",getSinceDateFromDT(cDate($data[0]['Date_reviewed'],false),$labelsSinceDate));//Dernière modification //(mm/jj/aaaa)
        }
        if ($is_shown) {
            $innerHTML .= getInnerLine($data[0]['Year_initiation'], $data[0]['Year_initiation'], "<convert>#label=204<convert> :");
            //Année d'initiation à la spéléo
            if ($category == "entry") {
                $innerHTML .= getInnerLine($data[0]['Contact'], $data[0]['Contact'], "<convert>#label=741<convert> :");
                //Contact
            } else {
                $innerHTML .= getInnerLine($data[0]['Contact'], $data[0]['Contact'], "<convert>#label=146<convert> :", "mailto:" . $data[0]['Contact']);
                //Contact
            }
            if (isset($data[0]['City'])) {
                $innerHTML .= "<div class=\"detail_line\"><span class=\"details_label\"><convert>#label=102<convert> :</span><br />\n";
                //Adresse
                if ($category != "entry") {
                    $innerHTML .= getInnerLine($data[0]['Address'], $data[0]['Address']) . "<br />\n";
                }
                $innerHTML .= getInnerLine($data[0]['City'], $data[0]['Postal_code'] . " " . $data[0]['City']) . "<br />\n";
                $innerHTML .= getInnerLine($data[0]['Region'], $data[0]['Region'] . ", " . strtoupper(getCountry($_SESSION['language'], $data[0]['Country']))) . "<br />\n";
                $innerHTML .= "</div>";
            } else {
                $innerHTML .= getInnerLine($data[0]['Country'], getCountry($_SESSION['language'], $data[0]['Country']), "<convert>#label=98<convert> :");
                //Pays
            }
            $innerHTML .= getInnerLine($data[0]['Language'], $data[0]['Language'], "<convert>#label=205<convert> :");
            //Langue
        }
        if ($is_shown) {
            if ($data[0]['Latitude'] != "" && $data[0]['Longitude'] != "") {
                $innerHTML .= "<div class=\"detail_line\"><span class=\"details_label\"><convert>#label=660<convert></span>";
                $innerHTML .= " <span class=\"details_data\"><convert>#label=286<convert></span></div>";
                //Système géodésique //(GPS) - WGS84 Décimal
                $innerHTML .= getInnerLine($data[0]['Latitude'], round($data[0]['Latitude'], 5), "<convert>#label=103<convert> :", "", "<convert>#label=104<convert> <convert>#label=293<convert>.");
                //Latitude //degrés N.
                $innerHTML .= getInnerLine($data[0]['Longitude'], round($data[0]['Longitude'], 5), "<convert>#label=105<convert> :", "", "<convert>#label=104<convert> <convert>#label=294<convert>.");
                //Longitude //degrés S.
                $innerHTML .= "<div class=\"detail_line\"><input type=\"button\" name=\"convert\" class=\"button1\" value=\"<convert>#label=31<convert>...\" onclick=\"JavaScript:";
                $innerHTML .= "openWindow('converter_" . $_SESSION['language'] . ".php?c=coords&amp;lat=" . $data[0]['Latitude'] . "&amp;lng=" . $data[0]['Longitude'] . "&amp;i=" . $data[0]['Country'] . "&amp;readonly=true', '', 434, 260);\" /></div>";
                //<!--Convertisseur...-->
            }
        }
        $innerHTML .= getInnerLine($data[0]['Altitude'], $data[0]['Altitude'], "<convert>#label=106<convert> :", "", "<convert>#label=66<convert>");
        //Altitude //mètres
        $innerHTML .= getInnerLine($data[0]['NetwId'], $data[0]['NetwName'], "<convert>#label=453<convert>", "JavaScript:detailMarker(undefined, 'cave', " . $data[0]['NetwId'] . ", '" . $_SESSION['language'] . "')", "", $data[0]['NumberOfEntries'], "<convert>#label=454<convert>", "<convert>#label=455<convert>");
        //Fait partie du réseau //ayant //entrées
        $innerHTML .= getInnerLine($data[0]['MasId'], $data[0]['MasName'], "<convert>#label=560<convert> ", "JavaScript:detailMarker(undefined, 'massif', " . $data[0]['MasId'] . ", '" . $_SESSION['language'] . "')");
        //Fait partie du massif
        //$innerHTML .= getInnerLine($data[0]['Min_depth'],$data[0]['Min_depth'],"<convert>#label=456<convert> :","","<convert>#label=66<convert>");//Profondeur Min. //mètres
        //$innerHTML .= getInnerLine($data[0]['Max_depth'],$data[0]['Max_depth'],"<convert>#label=457<convert> :","","<convert>#label=66<convert>");//Profondeur Max. //mètres
        $innerHTML .= getInnerLine($data[0]['Depth'], $data[0]['Depth'], "<convert>#label=64<convert> :", "", "<convert>#label=66<convert>");
        //Profondeur Min. //mètres
        $innerHTML .= getInnerLine($data[0]['Length'], $data[0]['Length'], "<convert>#label=68<convert> :", "", "<convert>#label=66<convert>");
        //Développement //mètres
        $innerHTML .= getInnerLine($data[0]['Temperature'], $data[0]['Temperature'], "<convert>#label=69<convert> :", "", "<convert>#label=70<convert>");
        //Température //degrés celsius
        $innerHTML .= getInnerLine($data[0]['Is_diving'], convertYN($data[0]['Is_diving'], "<convert>#label=441<convert>", "<convert>#label=442<convert>"), "<convert>#label=71<convert> :");
        //Oui //Non //Spéléo. plongée
        if ($category == "entry") {
            $innerHTML .= getInnerLine($data[0]['Partners'], replaceLinks($data[0]['Partners']), "<convert>#label=670<convert> :<br />\n");
            //Sites partenaires
        }
        $innerHTML .= getInnerLine($AvgAe, round($AvgAe, 1), "<convert>#label=458<convert> :", "", "<convert>#label=459<convert>");
        //Intérêt ///10
        if (isset($AvgAe)) {
            $innerHTML .= $histoAe;
        }
        $innerHTML .= getInnerLine($AvgCa, round($AvgCa, 1), "<convert>#label=460<convert> :", "", "<convert>#label=459<convert>");
        //Progression ///10
        if (isset($AvgCa)) {
            $innerHTML .= $histoCa;
        }
        $innerHTML .= getInnerLine($AvgAp, round($AvgAp, 1), "<convert>#label=461<convert> :", "", "<convert>#label=459<convert>");
        //Accès ///10
        if (isset($AvgAp)) {
            $innerHTML .= $histoAp;
        }
        if ($category == "entry" && $addTitle) {
            $innerHTML .= "<a href=\"#\" onclick=\"JavaScript:detailMarker(event, 'entry', '" . $id . "', '" . $_SESSION['language'] . "',true, {'geodesic': '" . $systemArray["geodesic"] . "','length': '" . $systemArray["length"] . "','temperature': '" . $systemArray["temperature"] . "'});\" title=\"<convert>#label=184<convert>\" style=\"color:red;\"><!--Voir la fiche détaillée de cette entrée-->\n";
            $innerHTML .= "<convert>#label=185<convert>\n";
            //Fiche détaillée...
            $innerHTML .= "</a><br />\n";
        }
        if ($isConnected && allowAccess(properties_view_all)) {
            $innerHTML .= "### Reserved for webmasters: ###<br />\n";
            foreach ($data[0] as $key => $value) {
                if ($key != "Custom_message") {
                    $innerHTML .= "<b>" . $key . "</b> : <i>" . replaceLinks(nl2br($value)) . "</i><br />\n";
                }
            }
        }
    }
    if ($addTitle) {
        $innerHTML .= getBotMenu();
    }
    $innerHTML = "<div class=\"menu\">" . $innerHTML . "</div>";
    return $innerHTML;
}
Exemplo n.º 5
0
 function getMyOneDayCourse()
 {
     header('Access-Control-Allow-Origin:*');
     //跨域
     header("Content-type: text/html; charset=utf-8");
     $param = json_decode(file_get_contents('php://input'), true);
     $token = $param['xtoken'];
     init_verify_token($token);
     $uid = $param['uid'];
     // $uid = 62;
     if (empty($uid)) {
         err_ret(-205, 'lack of param', '缺少参数');
     }
     $pid = $param['pid'];
     // $pid = 3;
     if (empty($pid)) {
         err_ret(-205, 'lack of param', '缺少参数');
     }
     $coachid = $param['coachid'];
     // $coachid = 51;
     if (empty($coachid)) {
         err_ret(-205, 'lack of param', '缺少参数');
     }
     $time = $param['time'];
     // $time = 1450022400;
     if (empty($time)) {
         err_ret(-205, 'lack of param', '缺少参数');
     }
     $t_my_plan = C('T_MY_PLAN');
     $t_course_record = C('T_COURSE_RECORD');
     $sql = "SELECT course_record.courseid,action.title,action.subtitle,action.desc,action.equipment,action.hard,t.course_time,action.url,action.type, course_record.actionid,course_record.group,course_record.count,course_record.order \n        FROM course_record,action, (SELECT my_plan.courseid ,my_plan.course_time FROM my_plan WHERE uid={$uid} AND pid={$pid} AND coachid={$coachid}) AS t\n        WHERE course_record.actionid=action.id AND course_record.courseid=t.courseid\n                ORDER BY course_record.order";
     $model = new Model();
     $result = $model->query($sql);
     $data_result = array();
     for ($i = 0; $i < count($result); $i++) {
         if (timeToStr($result[$i]['course_time']) == timeToStr($time)) {
             $data_result[] = $result[$i];
         }
     }
     $data['errno'] = 0;
     $data['uid'] = $uid;
     $data['pid'] = $pid;
     $data['coachid'] = $coachid;
     $data['course_time'] = $time;
     $data['action_list'] = $data_result;
     echo json_encode($data);
 }
Exemplo n.º 6
0
                }
                ?>
                  <div class="who_when">
                    <convert>#label=337<convert><!--Posté par--> <b><?php 
                echo $array[$i]["Author"];
                ?>
</b><br />
                    <convert>#label=338<convert><!--Le--> <b><?php 
                echo timeToStr($array[$i]["Date_inscription"]);
                ?>
</b><br /><br />
<?php 
                if (isset($array[$i]["Date_reviewed"]) && !$edition) {
                    ?>
                    <convert>#label=343<convert><!--Modifié le--> <b><?php 
                    echo timeToStr($array[$i]["Date_reviewed"]);
                    ?>
</b>
<?php 
                }
                ?>
                  </div>
                  <div style="padding-left:27px;margin-top:10px;">
<?php 
                if (!$edition) {
                    if ($array[$i]["E_t_trail"] != "") {
                        ?>
                    <div title="<convert>#label=363<convert>"><img src="../images/icons/hiking.gif" alt="<convert>#label=363<convert>" class="icon" style="vertical-align:middle;" /> <?php 
                        echo formatSimpleTime($array[$i]["E_t_trail"]);
                        ?>
</div><!--Temps d'approche (hh:mm)-->