<?php
error_reporting(0);
ini_set("display_errors", 0);
require_once "../mysql.class.php";
$db = new MySqlClass();
$db->conectar("casablancanew");
$dia = date('w');
$hora = date('H');
if ($hora >= 8 and $hora < 14) {
$hora = 1;
}
if ($hora >= 14 and $hora <= 23) {
$hora = 2;
}
if ($dia >= 1 and $dia <= 4) {
$dia = 1;
}
if ($dia == 6 or $dia == 5) {
if ($hora >= 8 and $hora < 14) {
$hora = 1;
}
if ($hora >= 14 and $hora <= 23) {
$hora = 2;
}
$dia = 2;
}
if ($dia == 0) {
if ($hora >= 8 and $hora < 14) {
$hora = 1;
}
<script type="text/javascript" src="js/jquery-1.5.min.js"></script>
<script src="js/thickbox-compressed.js" type="text/javascript"></script>
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script>
<script type="text/javascript">
//初始化地图
function initialize(){
var myOptions = {
zoom:9,
center:new google.maps.LatLng(39.9056266666667,116.38993),
mapTypeId: google.maps.MapTypeId.ROADMAP
}
var map = new google.maps.Map(document.getElementById("mainMap"),myOptions);
setMarkers(map,beaches);
}
<?php
$DB = new MySqlClass(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$sql = "SELECT a.code, c.username, note, latitude, longitude, create_date, altitude, address_zh FROM `cta_message` a JOIN cta_members_imei b ON a.send_account = b.imei JOIN cta_members c ON b.uid = c.uid ORDER BY `code` DESC LIMIT 0 , 10 ";
$result = $DB->ExeSql($sql);
echo "var beaches = [";
while ($row = $DB->getRowResult($result)) {
$code = $row['code'];
$username = $row['username'];
$note = $row['note'];
$latitude = $row['latitude'];
$longitude = $row['longitude'];
$altitude = $row['altitude'];
$create_date = $row['create_date'];
$address = $row['address_zh'];
echo "['{$username}:{$note}<br/>{$address}', {$latitude}, {$longitude}, 4],\n";
}
echo "['Maroubra Beach', -33.950198, 151.259302, 1]];";
<?php
require_once '../config.inc.php';
require_once '../include/db_class.php';
$colorArray = array("black", "brown", "green", "purple", "yellow", "blue", "gray", "orange", "red", "white");
$DB = new MySqlClass(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$_GET['uid']) {
//无此用户ID时显示所有信息
$sql = "";
} else {
$uid = $_GET['uid'];
$sql = "SELECT * FROM `cta_message` a JOIN `cta_members_imei` b on a.send_account=b.imei WHERE b.uid={$uid} ORDER BY `a`.`code` DESC LIMIT 0 , 8 ";
$result = $DB->ExeSql($sql);
$imgurl = "http://maps.google.com/maps/api/staticmap?&size=305x305&maptype=roadmap";
$listnote = "";
$bigMap = "";
$i = 1;
while ($row = $DB->getRowResult($result)) {
$note = $row['note'];
$latitude = $row['latitude'];
$longitude = $row['longitude'];
$create_date = $row['create_date'];
$imgurl .= "&markers=color:" . $colorArray[$i - 1] . "|label:{$i}|{$latitude},{$longitude}";
$listnote .= "<li>{$note}|{$create_date}</li>";
$bigMap .= "['{$note}', {$latitude}, {$longitude}, 4],";
$i += 1;
}
$imgurl .= "&sensor=false";
}
switch (@$_GET['fun']) {
case 'big':
<?
include("mysql.class.php");
$db= new MySqlClass();
$db->conectar("casablancanew");
$dia=date('w');
$hora=date('H');
if ($hora>=8 and $hora<14){
$hora=1;
}
if ($hora>=14 and $hora<=23){
$hora=2;
}
if ($dia>=1 and $dia<=4){
$dia=1;
}
if ($dia==6 or $dia==5){
if ($hora>=8 and $hora<14){
$hora=1;
}
if ($hora>=14 and $hora<=23){
$hora=2;
}
$dia=2;
}
