table("trace") . " As T, " . $DB->table("user"). " As U " . "WHERE T.user = U.id " . "AND T.public=1 AND T.official=0 " . "AND T.user<>$user " . "ORDER BY T.group, T.name"; } else if ($mode == 'official') { $sql = "SELECT T.id, T.type, T.group, T.name, T.url, " . "T.km, T.asc, T.dsc, T.latitude, T.longitude, T.date, '' As pseudo " . "FROM " . $DB->table("trace") . " As T " . "WHERE T.public=1 " . "AND T.official=0 " . "AND T.user<>$user " . "ORDER BY T.group, T.name"; } else if ($mode == 'official') { $sql = "SELECT T.id, T.type, T.group, T.name, T.url, " . "T.km, T.asc, T.dsc, T.latitude, T.longitude, T.date, '' As pseudo " . "FROM " . $DB->table("trace") . " As T " . "WHERE T.user=$user " . "ORDER BY T.group, T.name"; } echo "SQL = $sql
\n"; $stm = $DB->query($sql); $fd = null; $type = ""; $data = Array(); $groups = Array(); while( $row = $stm->fetch() ) { $groups[] = $row["group"]; //echo $row["id"] . " : " . $row["group"] . " / " . $row["name"] . "\n"; if (!isset($data[$row["group"]])) { $data[$row["group"]] = Array(); } $data[$row["group"]][] = Array("I" => intval($row["id"]), "N" => $row["name"], "U" => $row["url"], "T" => $row["type"], "#" => $row["date"], "K" => floatval($row["km"]), "A" => floatval($row["asc"]), "D" => floatval($row["dsc"]), "Y" => floatval($row["latitude"]), "X" => floatval($row["longitude"]), "P" => $row["pseudo"]); } $result[$mode] = $data; } return $result; } ?>