'."\n"; echo ''."\n"; echo ''."\n"; echo ' Gigoit Inc :: Last 1000 Users'."\n"; echo ' 1'."\n"; echo ''."\n"; echo ' gigoit_earth_users.kml'."\n"; echo ' 1'."\n"; echo ' '."\n"; if($result = $db_connection->query($sql)){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ $filename = '/var/www/media/images/userprofiles/'.$row['username'].'.jpg'; if(file_exists($filename)) { echo ' '."\n"; } } } if($result = $db_connection->query($sql)){ while($row = $result->fetch_array(MYSQLI_ASSOC)){ if($row['longitude'] != '' && $row['latitude'] != ''){ $filename = '/var/www/media/images/userprofiles/'.$row['username'].'.jpg'; if(file_exists($filename)) { $style = '#gigoit_user_'.$row['username']; $filename = 'http://media.gigoit.org/images/userprofiles/'.$row['username'].'.jpg'; } else { $style = '#gigoit_user_default'; $filename = 'http://media.gigoit.org/images/userprofiles/default.gif'; } if($row['bio'] != '') { $bio = $row['bio']; } else { $bio = 'N/A'; } echo ' '."\n"; echo ' '."\n"; echo "
View ProfileMember Since: ".$row['created']."
Bio: ".$bio."]]>\n"; echo ' '."\n"; echo ' '.$row['longitude'].''."\n"; echo ' '.$row['latitude'].''."\n"; echo ' 0'."\n"; echo ' 3482723.18754794'."\n"; echo ' 0'."\n"; echo ' -3.181699366958458'."\n"; echo ' '."\n"; echo ' '.$style.''."\n"; echo ' '."\n"; echo ' '.$row['longitude'].','.$row['latitude'].',0'."\n"; echo ' '."\n"; echo ' '."\n"; } } } echo ''."\n"; echo ''."\n"; echo ''."\n"; ?>