<?php


require_once 'Excel/reader.php';
$excel = new Spreadsheet_Excel_Reader();
$excel->setOutputEncoding('UTF-8');
$excel->read('eset.xls');

include_once 'MailMaster.php';

$user = "horvathzoltan";
$pass = "2da1cexxxxxxxxxx3d3395b89b7";
$list_id = "47869";
$form_id = "97958";

//excel feldolgoz·sa
$x=2;
			while($x<=$excel->sheets[0]['numRows']) {
				$nev = isset($excel->sheets[0]['cells'][$x][1]) ? $excel->sheets[0]['cells'][$x][1] : '';
				$email = isset($excel->sheets[0]['cells'][$x][2]) ? $excel->sheets[0]['cells'][$x][2] : '';
				$iranyitoszam = isset($excel->sheets[0]['cells'][$x][3]) ? $excel->sheets[0]['cells'][$x][3] : '';
        $varos = isset($excel->sheets[0]['cells'][$x][4]) ? $excel->sheets[0]['cells'][$x][4] : '';
        $utca_hsz = isset($excel->sheets[0]['cells'][$x][5]) ? $excel->sheets[0]['cells'][$x][5] : '';
        $telefon = isset($excel->sheets[0]['cells'][$x][6]) ? $excel->sheets[0]['cells'][$x][6] : '';
        $termek = isset($excel->sheets[0]['cells'][$x][7]) ? $excel->sheets[0]['cells'][$x][7] : '';
        $mennyiseg = isset($excel->sheets[0]['cells'][$x][8]) ? $excel->sheets[0]['cells'][$x][8] : '';
        $felhasznaloinev = isset($excel->sheets[0]['cells'][$x][9]) ? $excel->sheets[0]['cells'][$x][9] : '';
        $jelszo = isset($excel->sheets[0]['cells'][$x][10]) ? $excel->sheets[0]['cells'][$x][10] : '';
        $licenckulcs = isset($excel->sheets[0]['cells'][$x][11]) ? $excel->sheets[0]['cells'][$x][11] : '';
        $status = isset($excel->sheets[0]['cells'][$x][12]) ? $excel->sheets[0]['cells'][$x][12] : '';
        $licenctipusa = isset($excel->sheets[0]['cells'][$x][13]) ? $excel->sheets[0]['cells'][$x][13] : '';
        $megbizasos = isset($excel->sheets[0]['cells'][$x][14]) ? $excel->sheets[0]['cells'][$x][14] : '';
        $kezdet = isset($excel->sheets[0]['cells'][$x][15]) ? $excel->sheets[0]['cells'][$x][15] : '';
        $lejarat = isset($excel->sheets[0]['cells'][$x][16]) ? $excel->sheets[0]['cells'][$x][16] : '';
        $rendeles = isset($excel->sheets[0]['cells'][$x][17]) ? $excel->sheets[0]['cells'][$x][17] : '';
        $teljesites = isset($excel->sheets[0]['cells'][$x][18]) ? $excel->sheets[0]['cells'][$x][18] : '';
        $kedvezmeny = isset($excel->sheets[0]['cells'][$x][19]) ? $excel->sheets[0]['cells'][$x][19] : '';
        $vfelhasznar = isset($excel->sheets[0]['cells'][$x][20]) ? $excel->sheets[0]['cells'][$x][20] : '';
        $viszontar = isset($excel->sheets[0]['cells'][$x][21]) ? $excel->sheets[0]['cells'][$x][21] : '';


$SA = new MailMaster($list_id, $form_id, $user, $pass);
if (isset($SA))
	$SA->update($email,
		array('szamitogepek_szama' => $mennyiseg,
		'trial_kezdet' => $kezdet,
		'trial_vege' => $lejarat,
		'trial_username' =>  $felhasznaloinev,
		'trial_jelszo' =>  $jelszo,
		'licenc_azonosito' =>  $status,
		'trial_licenc_kulcs' =>  $licenckulcs));

 $x++;

}

echo "mindenki boldog";

?>