FORUM.M.NU

Kod: Markera allt

<?php
setlocale(LC_ALL, "sv_SE.ISO8859-1");

$nu = date("y-m-d H:i:s");

function translateDateSE($string) {
        $date = array(
                "/January/", "/February/", "/March/", "/May/", "/June/", "/July/", "/August/", "/October/",
                "/May/", "/Oct/",
                "/Monday/", "/Tuesday/", "/Wednesday/", "/Thursday/", "/Friday/", "/Saturday/", "/Sunday/",
                "/Mon/", "/Tue/", "/Wed/", "/Thu/", "/Fri/", "/Sat/", "/Sun/"
        );
        $dateSE = array(
                "Januari", "Februari", "Mars", "Maj", "Juni", "Juli", "Augusti", "Oktober",
                "Maj", "Okt",
                "mandag", "tisdag", "onsdag", "torsdag", "fredag", "lïrdag", "sïndag",
                "man", "tis", "ons", "tor", "fre", "lïr", "sïn"
        );
        return preg_replace($date, $dateSE, $string);}

set_include_path('/adress/till/gdata/ZendGdata-1.9.5/library');

require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata');
Zend_Loader::loadClass('Zend_Gdata_AuthSub');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Gdata_Calendar');

$user = 'EPOST_GOOGLEKONTO';
$pass = 'LÖSENORD_GOOGLEKONTO';
$service = Zend_Gdata_Calendar::AUTH_SERVICE_NAME; // predefined service name for calendar

$client = Zend_Gdata_ClientLogin::getHttpClient($user,$pass,$service);

  $startDate=date("y-m-d H:i");
  $endDate=date('Y-m-d', strtotime('+1 days'));
  $gdataCal = new Zend_Gdata_Calendar($client);
  $query = $gdataCal->newEventQuery();
  $query->setUser('default');
  $query->setVisibility('private');
  $query->setProjection('full');
  $query->setOrderby('starttime');
  $query->setSortorder('ascending');
  $query->setStartMin($startDate);
  $query->setStartMax($endDate);
$eventFeed = $gdataCal->getCalendarEventFeed($query);


// börjar på rad 0
$i = 0;


$rad0text = date("d/m") . " idag " . utf8_decode(translateDateSE(date("l")));
$rad0 = substr($rad0text, 0, 20);

$username="DBANVÄNDARE";
$password="DBLÖSEN";
$database="DATABAS";
mysql_connect("ADRESS",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "UPDATE t_lcd set f_rad0='$rad0', f_rad1=' ', f_rad2=' ', f_rad3=' ', f_datumtid='$nu' where id=2";
mysql_query($query);


// loopa events
foreach ($eventFeed as $event)
{
        // räkna upp fil-nummer
        $i++;


        // kört 4 loops? avbryt
        if( $i > 3 )
        {
                break;
        }

        // skriv rad 2,3,4
        else
        {
                // hämta ur datum ur google-objekt
                foreach ($event->when as $when)
                {
                        // start
                        $start_data = explode('T', $when->startTime);
                        $start = explode('.', $start_data[1]);
                        $start = substr($start[0], 0, 5);

                        // end
                        $end_data = explode('T', $when->endTime);
                        $end = explode('.', $end_data[1]);
                        $end = substr($end[0], 0, 5);
                }

                // hämta titel
                $title = $event->title->text;


                // formatera titel-data
                $replace_array = array('Å', 'å');
                $title = str_replace($replace_array, "a", $title);

                $replace_array = array('Ä', 'ä');
                $title = str_replace($replace_array, 'á', $title);

                $replace_array = array('Ö', 'ö');
                $title = str_replace($replace_array, 'ï', $title);


                // sträng-data

                $texten =  utf8_decode("$start $title");
                $string = substr($texten, 0, 20);


                $query = "UPDATE t_lcd set f_rad$i='$string' where id=2";
                mysql_query($query);

        }
}

mysql_close();

?>

Kod: Markera allt

                skriv till fil
                $myFile = "/mnt/1wire/FF.830400000100/line20.$i";
                $fh = fopen($myFile, 'w') or die("can't open file");
                fwrite($fh, $string);
                fclose($fh);