<?php
header("Content-type: text/x-csv");
    header("Content-Disposition: attachment; filename=wplist.csv");

    /**
     * Created by JetBrains PhpStorm.
     * User: hkorsbaek
     * Date: 11-10-11
     * Time: 06:10
     * To change this template use File | Settings | File Templates.
     */

    require_once("./include/site_constants.php"); //JSH Server version
    require_once("./include/standard_functions.php");
    require_once("./include/gui_functions.php");
    require_once("./include/db_mysql.php");
    log_session_start();


    /* Create database object */
    $db = new DB_Spencer_Class(array(PRIMARY_DB_HOST, PRIMARY_DB_USER, PRIMARY_DB_PASSWORD, PRIMARY_DB_DATABASE, 0, 0));
	$db->query("SET NAMES 'utf8'");

    /* Create the class object in order to manage the site cookie */
    $coo = new Cookies_Manager_Class("UserCookie");

    start_page_session();

    /* Call this method in order to check for auto login and so if auto_login is set! NOTICE that this method must have a pointer to the cookie as an argument!*/
    check_for_autologin($coo);

    /* Call the method get_language in order to find out what language the page
        scould be in! NOTICE! that the method take one argument (the pointer og the cookie object)*/
    $page_language = get_language($coo);


    if ($page_language == "") {
        $page_language = "dk";
    }

    $page_id = @$_GET['id'];

    $sql_wpx = "select " .
               "tbl_wp_x.profile_id, " .
               "tbl_wp_x.species_id, "
               . $page_language . "_name as name, " .
               "latin_name, " .
               "wpx_dato, " .
               "tbl_wp_x.country_id, " .
               $page_language . "_country_name, " .
               "location, " .
               "lat, " .
               "longi " .
               "from tbl_wp_x inner join " .
               "tbl_bird_species on tbl_wp_x.species_id = tbl_bird_species.species_id left join " .
               "netfugl.tbl_country on tbl_wp_x.country_id = tbl_country.country_id " .
               "where profile_id = " . $page_id .
               " order by tbl_bird_species.placement";

    $db->query($sql_wpx, "wpx");
    echo "profile id;species id;bird name;latin bird name;date;country id;country;location;latitude;longitude;map" . "\n";
    while ($row = $db->row("wpx")) {
        $tick = "";
        $tick = $tick . $row["profile_id"];
        $tick = $tick . ";" . $row["species_id"];
        $tick = $tick . ";" . $row["name"];
        $tick = $tick . ";" . $row["latin_name"];

        if (is_null($row["wpx_dato"]) || $row["wpx_dato"] == "") {
            $tick = $tick . ";-";
        } else {
            $tick = $tick . ";" . $row["wpx_dato"];
        }

        if (is_null($row["country_id"]) || $row["country_id"] == "") {
            $tick = $tick . ";-";
            $tick = $tick . ";-";
        } else {
            $tick = $tick . ";" . $row["country_id"];
            $tick = $tick . ";" . $row[$page_language . "_country_name"];
        }

        if (is_null($row["location"]) || $row["location"] == "") {
            $tick = $tick . ";-";
        } else {
            $location = $row["location"];
            $location = str_replace(";", ",", $location);

            $tick = $tick . ";" . $location;
        }

        if (!is_null($row["lat"]) && $row["lat"] != "") {
            $tick = $tick . ";" . $row["lat"];
            $tick = $tick . ";" . $row["longi"];

            $tick = $tick . ";" . "http://maps.google.co.uk/maps?q=loc:" . $row["lat"] . ", " . $row["longi"] . "(" . $row["name"] . ")&z=7&iwloc=A";
        } else {
            $tick = $tick . ";-";
            $tick = $tick . ";-";
            $tick = $tick . ";-";
        }

        echo $tick . "\n";
    }