Auto-Detect Delimiter: Find delimiter by analyzing a specific number of
rows to determine most probable delimiter character
public auto ( $file = null, $parse = true, $search_depth = null, $preferred = null, $enclosure = null ) : delimiter | ||
return | delimiter | character |
function csvDataToMemcache($csvList, $csvDir, $memIP, $memPort) { $memcached = new Memcache(); $memcached->connect($memIP, $memPort); foreach ($csvList as $key => $value) { $csvObj = new parseCSV(); $csvObj->auto($csvDir . '/' . $value); list($fileName, $fileType) = explode('.', $value); $memcached->set($fileName, $csvObj->data, MEMCACHE_COMPRESSED, 0); //debug info //echo "<br/>--------------------------------------------$fileName.csv to memcache-------------------------------------------<br/>"; print_r($memcached->get($fileName)); } $memcached->close(); echo "success"; }
public static function getCSV($file_path, $limit = false, $offset = false) { if (file_exists($file_path) && is_readable($file_path)) { if (!class_exists('parseCSV')) { require_once GMEMBER_DIR . '/assets/libs/parsecsv-for-php/parsecsv.lib.php'; } $csv = new parseCSV(); $csv->encoding('UTF-16', 'UTF-8'); if ($offset) { $csv->offset = $offset; } if ($limit) { $csv->limit = $limit; } $csv->auto($file_path); return array('titles' => $csv->titles, 'data' => $csv->data); } return false; return array('titles' => array(), 'data' => array()); }
function index() { if (!empty($this->data) && !empty($_POST['submit'])) { $string = explode(",", trim($this->data['InventoryMaster']['all_item'])); $prsku = $string[0]; if (!empty($string[1])) { $prname = $string[1]; } if (!empty($prsku) && !empty($prname)) { $conditions = array('InventoryMaster.category LIKE' => '%' . $prname . '%', 'InventoryMaster.category LIKE' => '%' . $prsku . '%'); $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'InventoryMaster.id ASC', 'conditions' => $conditions); } if (!empty($prsku)) { $conditions = array('OR' => array('InventoryMaster.product_code LIKE' => "%{$prsku}%", 'InventoryMaster.category LIKE' => "%{$prsku}%")); $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'InventoryMaster.id ASC', 'conditions' => $conditions); } $this->InventoryMaster->recursive = 1; $this->set('inventorymasters', $this->paginate()); } else { if (!empty($_POST['checkid']) && !empty($_POST['exports'])) { // echo 'dfbgghbfg';die(); $checkboxid = $_POST['checkid']; App::import("Vendor", "parsecsv"); $csv = new parseCSV(); $filepath = "C:\\Users\\Administrator\\Downloads" . "inventorymasterdb.csv"; $csv->auto($filepath); $this->set('inventorymasters', $this->InventoryMaster->find('all', array('conditions' => array('InventoryMaster.id' => $checkboxid)))); $this->layout = null; $this->autoLayout = false; Configure::write('debug', '2'); } else { $this->InventoryMaster->recursive = 1; //$users = $this->InventoryMaster->User->find('list'); $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'InventoryMaster.id ASC'); $this->set('inventorymasters', $this->paginate()); } } }
function csvFileread($target_file) { # include parseCSV class. require_once 'parsecsv.lib.php'; # create new parseCSV object. $csv = new parseCSV(); # Parse '_books.csv' using automatic delimiter detection... $csv->auto("uploads/{$target_file}.csv"); //$csv->auto("abc.csv"); # ...or if you know the delimiter, set the delimiter character # if its not the default comma... $csv->delimiter = "\t"; # tab delimited # ...and then use the parse() function. // $csv->parse('_books.csv'); # Output result. echo "hello"; print_r($csv->data); $i = 0; foreach ($csv->data as $key => $row) { print_r($row); if ($i == 5) { die; } $i++; } }
function index() { if (!empty($this->data) && !empty($_POST['submit'])) { $string = explode(",", trim($this->data['EbayenglishListing']['all_item'])); $prsku = $string[0]; if (!empty($string[1])) { $prname = $string[1]; } if (!empty($prsku) && !empty($prname)) { $conditions = array('EbayenglishListing.title LIKE' => '%' . $prname . '%', 'EbayenglishListing.title LIKE' => '%' . $prsku . '%'); $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'EbayenglishListing.sku id', 'conditions' => $conditions); } if (!empty($prsku)) { $conditions = array('OR' => array('EbayenglishListing.title LIKE' => "%{$prsku}%", 'EbayenglishListing.sku LIKE' => "%{$prsku}%")); $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'EbayenglishListing.id ASC', 'conditions' => $conditions); } $this->set('ebayenglishlistings', $this->paginate()); } else { if (!empty($_POST['checkid']) && !empty($_POST['exports'])) { $checkboxid = $_POST['checkid']; App::import("Vendor", "parsecsv"); $csv = new parseCSV(); $filepath = "C:\\Users\\Administrator\\Downloads" . "ebayenglishlistings.csv"; $csv->auto($filepath); $this->set('ebayenglishlistings', $this->EbayenglishListing->find('all', array('conditions' => array('EbayenglishListing.id' => $checkboxid)))); $this->layout = null; $this->autoLayout = false; Configure::write('debug', '2'); } else { $this->EbayenglishListing->recursive = 1; $this->paginate = array('limit' => 1000, 'totallimit' => 2000, 'order' => 'EbayenglishListing.id ASC'); $this->set('ebayenglishlistings', $this->paginate()); } } }
public function upload() { ini_set("auto_detect_line_endings", true); ini_set('memory_limit', '512M'); set_time_limit(600); require_once ROOT . DS . 'vendor' . DS . 'parsecsv.lib.php'; try { $numberListTable = TableRegistry::get('NumberLists'); $numberTable = TableRegistry::get('Numbers'); // Generate temp file name $uploadFullPath = TMP . DS . Text::uuid(); // Move file to temp location if (!move_uploaded_file($_FILES['file']['tmp_name'], $uploadFullPath)) { throw new \Exception('Cannot copy file to tmp location'); } $dateTimeUtc = new \DateTimeZone('UTC'); $now = new \DateTime('now', $dateTimeUtc); // Create new list $newNumberListData = ['list_name' => $this->request->data['list_name'], 'list_description' => $this->request->data['list_description'], 'create_datetime' => $now, 'update_datetime' => $now]; $numberList = $numberListTable->newEntity($newNumberListData); $numberListTable->save($numberList); // Get the data from the file $csv = new \parseCSV(); $csv->heading = false; $csv->auto($uploadFullPath); if (count($csv->data) == 0) { throw new \Exception('File is empty'); } $newNumberData = []; foreach ($csv->data as $row) { $responseM360 = $this->M360->optInTfn($row[1]); // $response['d'][] = $responseM360; $newNumberData = ['number_list_id' => $numberList->number_list_id, 'country_code' => $row[0], 'phone_number' => $row[1], 'opt_in_tfn' => (bool) $responseM360['Message360']['OptIns']['OptIn']['Status'] === 'updated', 'add_datetime' => $now]; $number = $numberTable->newEntity($newNumberData); $numberTable->save($number); } // $numbers = $numberTable->newEntity($newNumberData); // // $numberTable->connection()->transactional(function () use ($numberTable, $numbers) { // foreach ($numbers as $number) { // $numberTable->save($number, ['atomic' => false]); // } // }); unlink($uploadFullPath); $response['i'] = $newNumberData; $response['status'] = 1; } catch (\Excaption $ex) { $response['status'] = 0; $response['message'] = $ex->getMessage(); } $this->set(compact('response')); $this->set('_serialize', ['response']); }
public function saveimport() { $response = array("status" => 0, "msg" => "Gagal simpan data"); include APPPATH . "libraries/parsecsv.lib.php"; // echo "<pre>"; // print_r($_FILES); // echo "</pre>"; if (isset($_FILES['inputFile']) && !empty($_FILES['inputFile']['name'])) { $files = $_FILES['inputFile']; $allowed_extension = array('csv'); $extension = end(explode('.', strtolower($files['name']))); if (in_array($extension, $allowed_extension)) { $newname = date('YmdHis') . "_import_cpns.csv"; if (move_uploaded_file($files['tmp_name'], _ROOT . "files/import/{$newname}")) { if (file_exists(_ROOT . "files/import/{$newname}")) { $response = array("status" => 0, "msg" => "sukses simpan data"); $destination = _ROOT . "files/import/{$newname}"; $csv = new parseCSV(); $data = $csv->auto($destination); $datashipping = array(); foreach ((array) $csv->data as $index => $row) { $save = $this->pengadaan_model->simpanDataCPNSimport($row); } $response = array("status" => 1, "msg" => "Sukses import file"); } } } else { $response = array("status" => 0, "msg" => "Ekstensi file harus .csv"); } } // echo "<pre>"; // print_r($response); // echo "</pre>"; echo json_encode($response); exit; }
<?php require_once 'parsecsv.lib.php'; require_once 'Excel/reader.php'; session_start(); include 'inc.db.php'; $active_user = $_SESSION['user_id']; if (isset($_POST['upfile']) && $_POST['upfile'] != "") { $allowedExts = array("csv", "xls"); $temp = explode(".", $_POST['upfile']); $extension = end($temp); if ($extension == "csv") { $csv = new parseCSV(); $csv->auto('uploads/' . $_POST['upfile']); foreach ($csv->data as $key => $row) { $asin = $row['asin']; $res = mysql_query("select * from asins_table where asins='" . $asin . "' and UserID=" . $active_user . ""); if (!mysql_num_rows($res)) { mysql_query("INSERT INTO asins_table(asins,UserID,processed,provider) values('" . $asin . "'," . $active_user . ",0,'Amazon')"); } } } else { if ($extension == "xls") { $data = new Spreadsheet_Excel_Reader(); //$data->setOutputEncoding('CP1251'); $data->read('uploads/' . $_POST['upfile']); for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) { $asin = rawurlencode($data->sheets[0]['cells'][$i][1]); $res = mysql_query("select * from asins_table where asins='" . $asin . "' and UserID=" . $active_user . ""); if (!mysql_num_rows($res)) { mysql_query("INSERT INTO asins_table(asins,UserID,processed,provider) values('" . $asin . "'," . $active_user . ",0,'Amazon')");
function download() { App::import("Vendor", "parsecsv"); $csv = new parseCSV(); $filepath = "C:\\Users\\Administrator\\Downloads" . "projects.csv"; $csv->auto($filepath); $this->set('projects', $this->Listing->find('all')); $this->layout = null; $this->autoLayout = false; Configure::write('App.encoding', 'utf8_unicode_ci'); Configure::write('debug', '0'); }
/** * import_gradebook_screen( $vars ) * * Hooks into screen_handler * Imports a CSV file data into the gradebook_screen(). It doesn't save anything! * * @param Array $vars a set of variables received for this screen template * @return Array $vars a set of variable passed to this screen template */ function import_gradebook_screen($vars) { $is_nonce = nxt_verify_nonce($_POST['_nxtnonce'], 'gradebook_import_nonce'); if (!$is_nonce) { $vars['die'] = __('BuddyPress Courseware Nonce Error while importing gradebook.', 'bpsp'); return $this->gradebook_screen($vars); } $grades = array(); if (isset($_FILES['csv_filename']) && !empty($_FILES['csv_filename'])) { require_once 'parseCSV.class.php'; // Load CSV parser $csv = new parseCSV(); $csv->auto($_FILES['csv_filename']['tmp_name']); foreach ($csv->data as $grade) { $id = bp_core_get_userid_from_nicename($grade['uid']); if ($id) { $grades[$id] = $grade; } } if (count($csv->data) == count($grades)) { $vars['message'] = __('Data imported successfully, but it is not saved yet! Save this form changes to keep the data.', 'bpsp'); } else { $vars['error'] = __('File data contains error or entries from other gradebook. Please check again.', 'bpsp'); } } $vars['grades'] = $grades; $vars['assignment_permalink'] = $vars['assignment_permalink'] . '/gradebook'; unset($_POST); return $this->gradebook_screen($vars); }
public function actionUpload() { // $assetPrefix = Yii::$app->assetManager->publish(dirname(__FILE__) . '/../assets', array('forceCopy' => true)); // Yii::$app->clientScript->registerScriptFile($assetPrefix . '/md5.min.js'); // Yii::$app->clientScript->registerScriptFile($assetPrefix . '/jdenticon-1.3.0.min.js'); require_once dirname(__FILE__) . "/../lib/parsecsv.lib.php"; $csv = new \parseCSV(); $model = new BulkImportForm(); $validImports = array(); $invalidImports = array(); if (isset($_POST['BulkImportForm'])) { $model->attributes = $_POST['BulkImportForm']; if (!empty($_FILES['BulkImportForm']['tmp_name']['csv_file'])) { $file = \yii\web\UploadedFile::getInstance($model, 'csv_file'); $group_id = 1; $csv->auto($file->tempName); foreach ($csv->data as $data) { // Make a username from the first and last names if username is mising if (empty($data['username'])) { // $data['username'] = substr(str_replace(" ", "_", strtolower(trim($data['firstname']) . "_" . trim($data['lastname']))), 0, 25); $data['username'] = substr(ucfirst(trim($data['firstname'])) . " " . ucfirst(trim($data['lastname'])), 0, 25); } // Put data into correct format $importData = array('username' => $data['username'], 'password' => $data['password'], 'firstname' => $data['firstname'], 'lastname' => $data['lastname'], 'email' => $data['email'], 'space_names' => explode(",", $data['space_names']), 'group_id' => $group_id); // Register user if ($this->registerUser($importData)) { $validImports[] = $importData; } else { $invalidImports[] = $importData; } } } } return $this->render('import_complete', array('validImports' => $validImports, 'invalidImports' => $invalidImports)); }
public function importProductsMap() { $file = Input::file('file'); if ($file == null) { Session::flash('error', 'Debe seleccionar un archivo'); return Redirect::to('importar/productos'); } $name = $file->getRealPath(); require_once app_path() . '/includes/parsecsv.lib.php'; $csv = new parseCSV(); $csv->heading = false; $csv->encoding('ISO-8859-1', 'UTF-8'); $csv->auto($name); Session::put('data', $csv->data); $headers = true; $hasHeaders = true; $mapped = array(); $columns = array('', Product::$fieldProductKey, Product::$fieldNotes, Product::$fieldCost); if (count($csv->data) > 0) { $headers = $csv->data[0]; for ($i = 0; $i < count($headers); $i++) { $title = strtolower($headers[$i]); $mapped[$i] = ''; $map = array('Nombre' => Product::$fieldProductKey, 'Razón Social' => Product::$fieldNotes, 'Nit' => Product::$fieldCost); foreach ($map as $search => $column) { foreach (explode("|", $search) as $string) { if (strpos($title, 'sec') === 0) { continue; } if (strpos($title, $string) !== false) { $mapped[$i] = $column; break 2; } } } } } $data = array('data' => $csv->data, 'headers' => $headers, 'hasHeaders' => $hasHeaders, 'columns' => $columns, 'mapped' => $mapped, 'categories' => Category::where('account_id', '=', Auth::user()->account_id)->orderBy('id')->get()); return View::make('importar.import_products_map', $data); }
<pre> <?php # include parseCSV class. require_once '../parsecsv.lib.php'; # create new parseCSV object. $csv = new parseCSV(); # Parse '_books.csv' using automatic delimiter detection... $csv->auto('PercFramesLoadedonQA_092915.csv'); # ...or if you know the delimiter, set the delimiter character # if its not the default comma... // $csv->delimiter = "\t"; # tab delimited # ...and then use the parse() function. // $csv->parse('_books.csv'); # Output result. //echo '<pre>';print_r($csv->data);die; $i = 1; //$j=2; $html = ''; $aFPC = array(); foreach ($csv->data as $key => $row) { $aFPC[] = $row['FPC Code']; //$html .= '<LineItem Id="'.$i.'" Quantity="'.$i.'"><FPC Value="'.$row["FPC"].'"/><Patient FirstName="New"'.$i.' LastName="Order"'.$i.' PatientId="'.$j.'"/></LineItem>'; //echo $result; //$i++; //$j++; } //echo '<pre>';print_r(array_unique($aFPC));die; foreach (array_unique($aFPC) as $key => $row) { //$html = ( htmlentities('<LineItem Id="'.$i.'" Quantity="'.$i.'"><FPC Value="'.$row.'"/><Patient FirstName="New"'.$i.' LastName="Order"'.$i.' PatientId="'.$j.'"/></LineItem>')); $html .= '<LineItem Id="' . $i . '" Quantity="' . $i . '"><FPC Value="' . $row . '"/><Patient FirstName="New' . $i . '" LastName="Order' . $i . '" PatientId="' . $i . '"/></LineItem>'; $i++;
public function mapFile($entityType, $filename, $columns, $map) { require_once app_path() . '/Includes/parsecsv.lib.php'; $csv = new parseCSV(); $csv->heading = false; $csv->auto($filename); Session::put("{$entityType}-data", $csv->data); $headers = false; $hasHeaders = false; $mapped = array(); if (count($csv->data) > 0) { $headers = $csv->data[0]; foreach ($headers as $title) { if (strpos(strtolower($title), 'name') > 0) { $hasHeaders = true; break; } } for ($i = 0; $i < count($headers); $i++) { $title = strtolower($headers[$i]); $mapped[$i] = ''; if ($hasHeaders) { foreach ($map as $search => $column) { if ($this->checkForMatch($title, $search)) { $mapped[$i] = $column; break; } } } } } $data = array('entityType' => $entityType, 'data' => $csv->data, 'headers' => $headers, 'hasHeaders' => $hasHeaders, 'columns' => $columns, 'mapped' => $mapped); return $data; }
function csvFileread($target_file) { # include parseCSV class. require_once 'parsecsv.lib.php'; $conn = mysql_connect("localhost", "root", "proggasoft123") or die("unable to connect localhost" . mysql_error()); $db = mysql_select_db("testfile", $conn) or die("unable to select db name"); # create new parseCSV object. $csv = new parseCSV(); # Parse '_books.csv' using automatic delimiter detection... $csv->auto("uploads/{$target_file}.csv"); //$csv->auto("abc.csv"); # ...or if you know the delimiter, set the delimiter character # if its not the default comma... $csv->delimiter = "\t"; # tab delimited # ...and then use the parse() function. // $csv->parse('_books.csv'); # Output result. // print_r($csv->data); $i = 0; foreach ($csv->data as $key => $row) { //print_r($row); //if ($i == 5) //die(); //Work on Main category........... $main_category = mysql_real_escape_string($row['Categories']); $maincatesql = "INSERT INTO main_catagories (main_catagory) values ('" . $main_category . "')"; //echo $catesql; $result = mysql_query($maincatesql); if ($result) { //$main_cat_id = "query of last id"; $main_cat_id = mysql_insert_id(); } else { die('not successfuly'); } //Work on Category........... $category = mysql_real_escape_string($row['Mypafway Categories']); $catesql = "INSERT INTO categories (main_cat_id,title) values ('" . $main_cat_id . "','" . $category . "')"; $result = mysql_query($catesql); if ($result) { //$cat_id = "query of last id"; $cat_id = mysql_insert_id(); } else { die('not successfuly'); } //Work on Subcategory........... $subcategory = mysql_real_escape_string($row['Mypafway Sub Categories']); $subcatesql = "INSERT INTO sub_categories (main_cat_id,cat_id,title) values ('" . $main_cat_id . "','" . $cat_id . "','" . $subcategory . "')"; $subcatresult = mysql_query($subcatesql); if ($subcatresult) { //$cat_id = "query of last id"; $subcat_id = mysql_insert_id(); } else { die('not successfuly'); } //Work on Make table........... $make = mysql_real_escape_string($row['Make']); $makesql = "INSERT INTO auto_makes (text) values ('" . $make . "')"; $makeresult = mysql_query($makesql); if ($makeresult) { //$cat_id = "query of last id"; $make_id = mysql_insert_id(); } else { die('not successfuly make'); } //Work on Model table........... $model = mysql_real_escape_string($row['Model']); $modelsql = "INSERT INTO auto_models (auto_make_id,text,year,Cylinders,Engine_Code,Engine_Bore,Engine_Size,Comments_on_file) \n values ('" . $make_id . "','" . $model . "','','','','','','')"; $modelresult = mysql_query($modelsql); if ($modelresult) { //$cat_id = "query of last id"; $model_id = mysql_insert_id(); } else { die('not successfuly model'); } //Work on Product........... $product_name = mysql_real_escape_string($row['Name']); //echo $product_make = $row['Make']; //echo $product_model = $row['Model']; $product_yaer = mysql_real_escape_string($row['Year']); $product_price = mysql_real_escape_string($row['Price']); $product_image = mysql_real_escape_string($row['Images']); //echo $product_desc = $row['Short Description']; $product_desc = mysql_real_escape_string($row['Long Description']); $product_metatitle = mysql_real_escape_string($row['Meta Title']); $product_metadesc = mysql_real_escape_string($row['Meta Description']); $product_tags = mysql_real_escape_string($row['Tags']); // echo $product ="INSERT INTO products (name,company,description,price,categories,subcategories,picture,year,make,model) // values ('".$product_name."', 'mypafway', '".$product_desc."','".$product_price."','".$cat_id."','".$subcat_id."','".$product_image."','".$product_yaer."','".$product_make."','".$product_model."')"; $product = "INSERT INTO products (user_id,title,partno,company,url,description,price,\n product_type,Quantity,headings,categories,subcategories,show_address,show_phone,show_cell,show_fax,\n picture,year,make,model,location,time,supp1,supp2,supp3,supp4,supp5,search_count,pushed,downloads,\n meta_title,meta_description,tags)\n \n values ('','" . $product_name . "','','','','{$product_desc}','" . $product_price . "','','','','" . $cat_id . "','" . $subcat_id . "',\n 'a','a','a','a','" . $product_image . "','" . $product_yaer . "','" . $make_id . "',\n '" . $model_id . "','','','','','','','','','','','" . $product_metatitle . "','" . $product_metadesc . "','" . $product_tags . "')"; $productresult = mysql_query($product); if ($productresult) { //$cat_id = "query of last id"; $subcat_id = mysql_insert_id(); } else { die('not successfuly product'); } //Work on Search keyword table........... $searchkey = $row['Meta Keywords']; $searchkeysql = "INSERT INTO search (date,keyword) values ('','" . $searchkey . "')"; $result = mysql_query($searchkeysql); if ($result) { //$cat_id = "query of last id"; $cat_id = mysql_insert_id(); //echo "CSV file upload successfuly."; } else { die('not successfuly'); } //$i++; } }
function updateAllObjects($mySforceConnection) { $files = scandir('data/'); foreach ($files as $file) { $fieldArray = array(); echo 'Processing file : ' . $file . "\n"; $validObj = true; try { $objName = basename($file, '.csv'); $describedObj = $mySforceConnection->describeSObject($objName); } catch (Exception $e) { $validObj = false; } if ($validObj) { //loop through fields of object and determine if field should be set in object. foreach ($describedObj->fields as $field) { if ($field->updateable == '1' && $field->name != 'OwnerId') { //echo $field->name . ' ~!: ' . $field->type . "\n"; $fieldArray[$field->name] = true; if (!(strrpos($field->type, 'date') === false)) { //echo $field->type . " ISDATE\n"; $fieldArray[$field->name] = 'date'; } } } } $csv = new parseCSV(); $csv->auto('data/' . $file); $sObjects = array(); foreach ($csv->data as $key => $row) { $sObject = new stdClass(); $sObject->Id = $row["Id"]; print_r($row); foreach ($row as $column => $value) { if ($fieldArray[$column] === 'date' && strlen($value) > 0) { $sObject->{$column} = gmdate("Y-m-d\\TH:i:s\\Z", $value); //echo 'DATEFORMAT ' . $value . ' === ' . $fieldsToUpdate[$column] . "\n"; } else { if ($fieldArray[$column] && strlen($value) > 0) { echo $column . ' == ' . $value . "\n"; $sObject->{$column} = utf8_encode($value); } } } print_r($sObject); array_push($sObjects, $sObject); } $sObjectsToUpdate = array(); foreach ($sObjects as $sObject) { //print_r($sObjectsToUpdate); $results = $mySforceConnection->update($sObjectsToUpdate, $objName); print_r($results); $sObjectsToUpdate = array(); array_push($sObjectsToUpdate, $sObject); } } }
closedir($handle); } if ($csvfile == '') { exit; } //Nothing to process, quit here. //Initialize data $data_array = explode('-', $file); $userID = $data_array[0]; $listID = str_replace('.csv', '', $data_array[1]); $csv = new parseCSV(); if (isset($_GET['offset'])) { $csv->offset = $_GET['offset']; } $csv->heading = false; $csv->auto($csvfile); $databasetable = "subscribers"; $fieldseparator = ","; $lineseparator = "\n"; $time = time(); //Check if CSV is currently processing $q = 'SELECT currently_processing, prev_count, total_records FROM lists WHERE id = ' . $listID; $r = mysqli_query($mysqli, $q); if ($r) { while ($row = mysqli_fetch_array($r)) { $current_processing = $row['currently_processing']; $prev_count = $row['prev_count']; $total_records = $row['total_records']; } } //If CSV is not processed before, process it
$db->connect(); //database connection details $connect = mysql_connect('localhost', 'node', 'node'); if (!$connect) { die('Could not connect to MySQL: ' . mysql_error()); } //your database name $cid = mysql_select_db('node', $connect); // path where your CSV file is located define('CSV_PATH', '/var/www/crud/import/'); // Name of your CSV file $csv_file = CSV_PATH . "test2.csv"; //error_log(print_r($csv_file,true)); //error_log(print_r($value,true)); $csv = new parseCSV($csv_file); $csv->auto('data.csv'); //error_log(print_r($csv->data,true)); $bomImport = new BomImporter(); $bomImport->download($csv_file); $bomImport->process(); //error_log(print_r($bomImport->getHeaders(),true)); //error_log(print_r($bomImport->getData(),true)); //die(); foreach ($bomImport->getData() as $value) { $pieces = explode(";", $value[0]); error_log(print_r($pieces[0], true)); $query = "INSERT INTO csvtbl(ID,name,city) VALUES('" . $pieces[0] . "','" . $pieces[1] . "','" . $pieces[2] . "')"; $s = mysql_query($query, $connect); } mysql_close($connect); $db = new Database();
/** * define map field value * * @since */ public function rtlib_defined_map_field_value() { $form_id = $_REQUEST['map_form_id']; if (isset($_REQUEST['mapSourceType']) && 'gravity' == $_REQUEST['mapSourceType']) { $field_id = intval($_REQUEST['field_id']); $tableName = RGFormsModel::get_lead_details_table_name(); global $wpdb; $result = $wpdb->get_results($wpdb->prepare("select distinct value from {$tableName} where form_id= %d and field_number = %d ", $form_id, $field_id)); } else { $field_id = $_REQUEST['field_id']; $csv = new parseCSV(); $csv->auto($form_id); $result = array(); $field_id = str_replace('-s-', ' ', $field_id); foreach ($csv->data as $cdt) { $tmpArr = array('value' => $cdt[$field_id]); if (!in_array($tmpArr, $result)) { $result[] = $tmpArr; } if (count($result) > 15) { break; } } } header('Content-Type: application/json'); if (count($result) < 15) { echo json_encode($result); } else { echo json_encode(array()); } die(0); }
function options_panel() { global $wpdb; $isedit = false; $message = ""; $editrow = ""; if (isset($_POST['eddem']) && $_POST['eddem'] == "1") { $editrow = ""; $isedit = false; global $wpdb; $nonce = $_POST['nonce-eventify']; if (!wp_verify_nonce($nonce, 'eventify-nonce')) { die('Security Check - If you receive this in error, log out and back in to WordPress'); } $table_name = $wpdb->prefix . "em_main"; $sql = "update " . $table_name . " set em_date='" . $_POST['datepicker'] . "', em_time='" . $_POST['timepick_from'] . "-" . $_POST['timepick_to'] . "', em_desc='" . str_ireplace("'", "\\'", $_POST['em_desc']) . "', em_title='" . str_ireplace("'", "\\'", $_POST['em_title']) . "', em_venue='" . str_ireplace("'", "\\'", $_POST['em_venue']) . "', em_timezone='" . $_POST['em_timezone'] . "', em_timestamp='" . strtotime($_POST['datepicker']) . "' where em_id='" . $_POST['emidd'] . "';"; //echo $sql; $wpdb->query($sql); update_option("em_timezone", $_POST['em_timezone']); $message = "Event Updated!"; $wpdb->print_error(); } if (isset($_POST['eem'])) { //show the edit event form and display the values from the db $isedit = true; global $wpdb; $nonce = $_POST['nonce-eventify']; if (!wp_verify_nonce($nonce, 'eventify-nonce')) { die('Security Check - If you receive this in error, log out and back in to WordPress'); } $table_name = $wpdb->prefix . "em_main"; $sqlqry = "Select * from " . $table_name . " where em_id='" . $_POST['eem'] . "'"; $editrow = $wpdb->get_results($sqlqry); } if (isset($_POST['addem']) && $_POST['addem'] == "1") { $nonce = $_POST['nonce-eventify']; if (!wp_verify_nonce($nonce, 'eventify-nonce')) { die('Security Check - If you receive this in error, log out and back in to WordPress'); } $message = "Event Added! :)"; //add the event to the db and the table :) $table_name = $wpdb->prefix . "em_main"; if ($_POST['saveitaspopup'] == "posted") { // Create post object $my_post = array(); $my_post['post_title'] = $_POST['em_title']; $my_post['post_content'] = "<h2>Event Description:</h2>" . $_POST['em_desc'] . "<br/><h2>Event Date</h2>" . $_POST['datepicker'] . "<br/><h2>Event Time</h2> From: " . $_POST['timepick_from'] . " - To: " . $_POST['timepick_to'] . " <br/><h2>Event Venue</h2>" . $_POST['em_venue'] . "<br/><h2>Event TimeZone</h2>" . $_POST['em_timezone']; $my_post['post_status'] = 'publish'; $my_post['post_author'] = 1; $my_post['post_category'] = array(99 => 'Events'); // Insert the post into the database $postedid = wp_insert_post($my_post); $sql = "insert into " . $table_name . " values(null,'" . $_POST['datepicker'] . "','" . $_POST['timepick_from'] . "-" . $_POST['timepick_to'] . " ','" . str_ireplace("'", "\\'", $_POST['em_desc']) . "','" . str_ireplace("'", "\\'", $_POST['em_title']) . "','" . str_ireplace("'", "\\'", $_POST['em_venue']) . "','" . $_POST['em_timezone'] . "','" . $postedid . "','" . strtotime($_POST['datepicker']) . "')"; } else { $sql = "insert into " . $table_name . " values(null,'" . $_POST['datepicker'] . "','" . $_POST['timepick_from'] . "-" . $_POST['timepick_to'] . "','" . str_ireplace("'", "\\'", $_POST['em_desc']) . "','" . str_ireplace("'", "\\'", $_POST['em_title']) . "','" . str_ireplace("'", "\\'", $_POST['em_venue']) . "','" . $_POST['em_timezone'] . "','0','" . strtotime($_POST['datepicker']) . "')"; } $wpdb->query($sql); update_option("em_timezone", $_POST['em_timezone']); $wpdb->print_error(); } if (isset($_POST['delem']) && $_POST['delem'] == "1") { if (!empty($_POST['delemid'])) { $nonce = $_POST['nonceeventify']; if (!wp_verify_nonce($nonce, 'eventify-nonce')) { die('Security Check - If you receive this in error, log out and back in to WordPress'); } //$message = "Selected Event(s) Deleted! :)"; $delidsem = implode(",", $_POST['delemid']); //echo $delidsem; //delete the event(s) from the db and the table :) $table_name = $wpdb->prefix . "em_main"; $sql_qury = "delete from " . $table_name . " where em_id in (" . $delidsem . ")"; $message = "Event(s) Deleted. :)"; $wpdb->query($sql_qury); $wpdb->print_error(); } else { $message = "<span style='color:red;'>No events selected for deletion</span>"; } } /*code for backing up events*/ if (isset($_POST['backemall']) && $_POST['backemall'] == "1") { global $wpdb; $table_name = $wpdb->prefix . "em_main"; $qry = "select * from " . $table_name . " order by em_timestamp ASC"; $results = $wpdb->get_results($qry); $backupfilename = "events.csv"; $backup_file_handle = fopen(WP_PLUGIN_DIR . "/eventify/uploads/" . $backupfilename, 'w') or die('Something terribly went wrong with creating the file'); require_once WP_PLUGIN_DIR . '/eventify/php/parsecsv.lib.php'; $csv = new parseCSV(); //print_r($results); $i = 1; $data[0] = array('title' => 'title', 'date' => 'date', 'time' => 'time', 'desc' => 'desc', 'venue' => 'venue', 'timezone' => 'timezone'); foreach ($results as $row) { $data[$i] = array('title' => $row->em_title, 'date' => $row->em_date, 'timefromtimeto' => $row->em_time, 'desc' => $row->em_desc, 'venue' => $row->em_venue, 'timezone' => $row->em_timezone); $i++; } $csv->save(WP_PLUGIN_DIR . "/eventify/uploads/" . $backupfilename, $data, true); fclose($backup_file_handle); $message = "Events backup complete. <a href=\"" . WP_PLUGIN_URL . "/eventify/uploads/" . $backupfilename . "\">Save file</a> by right click->save as. Save the file as .csv file"; } //code for backing up events ends here if (isset($_POST['uploadems']) && $_POST['uploadems'] == "1") { $nonce = $_POST['nonce-eventify']; if (!wp_verify_nonce($nonce, 'eventify-nonce')) { die('Security Check - If you receive this in error, log out and back in to WordPress'); } if (isset($_POST['postedfpc'])) { $uploaddir = WP_PLUGIN_DIR . "/eventify/uploads/"; $target_path = $uploaddir . basename($_FILES['csvfile']['name']); //echo $target_path; //echo getcwd(); //$allowedExtensions_ = ; function isAllowedExtension($fileName) { global $allowedExtensions_; return in_array(end(explode(".", $fileName)), array("csv")); } if ($_FILES["csvfile"]["type"] == 'text/plain' && isAllowedExtension($_FILES['csvfile']['name'])) { if (move_uploaded_file($_FILES['csvfile']['tmp_name'], $target_path)) { require_once WP_PLUGIN_DIR . '/eventify/php/parsecsv.lib.php'; $csv = new parseCSV($target_path); $csv->auto(); //print_r($csv); use for debuggin $no_of_rows = count($csv->data); $no_of_cols = count($csv->data[0]); if ($no_of_cols != "6") { die('Uploaded file is in the wrong format.. <a href="http://designerfoo.com/wordpress-plugin-eventify-simple-events-management">please click here for the tutorial..</a>'); } global $wpdb; $table_name = $wpdb->prefix . "em_main"; $sql_q = "insert into " . $table_name . " values "; for ($i = 0; $i < $no_of_rows; $i++) { //insert the data into the database.. $sql_q .= "(null,'" . $csv->data[$i][$csv->titles[$no_of_cols - 5]] . "','" . $csv->data[$i][$csv->titles[$no_of_cols - 4]] . "','" . str_ireplace("'", "\\'", $csv->data[$i][$csv->titles[$no_of_cols - 3]]) . "','" . str_ireplace("'", "\\'", $csv->data[$i][$csv->titles[$no_of_cols - 6]]) . "','" . str_ireplace("'", "\\'", $csv->data[$i][$csv->titles[$no_of_cols - 2]]) . "','" . str_ireplace("'", "\\'", $csv->data[$i][$csv->titles[$no_of_cols - 1]]) . "','0','" . strtotime($csv->data[$i][$csv->titles[$no_of_cols - 5]]) . "')"; if ($no_of_rows - $i != 1) { $sql_q .= ", "; } //echo //echo //echo ; //echo ; } $sql_q .= ";"; //echo $sql_q; $wpdb->query($sql_q); $wpdb->print_error(); $message = "Bulk upload of events complete :)"; //print count($csv->data[0]); } //nested if for uploading part ends here if... } //uploading part ends here if... } //postedfpc if ends here } //main if ends here ?> <div class="wrap"> <h2>Eventify - Control Panel</h2> <h4>A plugin to store and show upcoming events in wordpress widgets/sidebar.</h4> <h4>It's alright if you don't donate, just help spread the word about <a href="http://foo.tc/singledin" target="_new">Singled.in - A Webcomic Series about Online & New Age Dating.</a> and if you like it, do subscribe!</h4> <?php if ($message) { ?> <div id="message" class="updated fade"><p><?php echo $message; ?> </p></div> <?php } ?> <br/> <div style="float:left;clear:both;"> <h3>Enter Events To Display</h3> <div id="wrapper"> <script type="text/javascript"> jQuery(function() { jQuery("#datepicker").datepicker(); jQuery("#timepick_from").timePicker(); jQuery("#timepick_to").timePicker(); jQuery("#backeventifyform").validate(); }); </script> <Style> div.row { padding-top: 5px; clear: both; width:960px;} div.left { float: left; text-align: left;margin-left:20px; width:80px;} div.right { margin-left: 110px; } div.time-picker { position: absolute; height: 200px; width:4em; /* needed for IE */ overflow: auto; background: #fff; border: 1px solid #000; z-index: 99; } div.time-picker-12hours { width:6em; /* needed for IE */ } div.time-picker ul { list-style-type: none; margin: 0; padding: 0; } div.time-picker li { padding: 1px; cursor: pointer; } div.time-picker li.selected { background: #316AC5; color: #fff; } </style> <form action="" method="post" id="backeventifyform"> <div class="row"> <div class="left"><strong>Event Title:</strong></div> <div class="right"><input type="text" size="25" id="em_title" name="em_title" class="required" <?php if ($isedit) { ?> value="<?php echo $editrow[0]->em_title; ?> " <?php } ?> ></div> </div> <div class="row"> <div class="left"><strong>Event Date:</strong></div> <div class="right"><input type="text" size="25" id="datepicker" name="datepicker" READONLY class="required" <?php if ($isedit) { ?> value="<?php echo $editrow[0]->em_date; ?> " <?php } ?> >*For displaying the date in a particular format use the widget :)</div> </div> <div class="row"> <div class="left"><strong>Time - From</strong></div> <div class="right"><input type="text" size="25" id="timepick_from" name="timepick_from" READONLY class="required" <?php if ($isedit) { ?> value="<?php echo substr($editrow[0]->em_time, 0, -6); ?> " <?php } ?> ></div> </div> <div class="row"> <div class="left"><strong>Time - To</strong></div> <div class="right"><input type="text" size="25" id="timepick_to" name="timepick_to" READONLY class="required" <?php if ($isedit) { ?> value="<?php echo substr($editrow[0]->em_time, -5); ?> " <?php } ?> ></div> </div> <div class="row"> <div class="left"><strong>Event Venue:</strong></div> <div class="right"><input type="text" size="25" id="em_venue" name="em_venue" class="required" <?php if ($isedit) { ?> value="<?php echo $editrow[0]->em_venue; ?> " <?php } ?> ></div> </div> <div class="row"> <div class="left"><strong>Event Details:</strong></div> <div class="right"><textarea id="em_desc" name="em_desc"><?php if ($isedit) { ?> <?php echo $editrow[0]->em_title; ?> <?php } ?> </textarea></div> </div> <div class="row"> <div class="left"><strong>Event TimeZone:</strong></div> <div class="right"><select name="em_timezone" id="em_timezone"> <option <?php if (preg_match('/none/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="none" >Select your local timezone....</option> <option <?php if (preg_match('/Canada\\/Atlantic/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Atlantic">Canada/Atlantic</option> <option <?php if (preg_match('/Canada\\/Central/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Central">Canada/Central</option> <option <?php if (preg_match('/Canada\\/East-Saskatchewan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/East-Saskatchewan">Canada/East-Saskatchewan</option> <option <?php if (preg_match('/Canada\\/Eastern/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Eastern">Canada/Eastern</option> <option <?php if (preg_match('/Canada\\/Mountain/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Mountain">Canada/Mountain</option> <option <?php if (preg_match('/Canada\\/Newfoundland/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Newfoundland">Canada/Newfoundland</option> <option <?php if (preg_match('/Canada\\/Pacific/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Pacific">Canada/Pacific</option> <option <?php if (preg_match('/Canada\\/Saskatchewan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Saskatchewan">Canada/Saskatchewan</option> <option <?php if (preg_match('/Canada\\/Yukon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="Canada/Yukon">Canada/Yukon</option> <option <?php if (preg_match('/US\\/Alaska/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Alaska">US/Alaska</option> <option <?php if (preg_match('/US\\/Aleutian/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Aleutian">US/Aleutian</option> <option <?php if (preg_match('/US\\/Arizona/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Arizona">US/Arizona</option> <option <?php if (preg_match('/US\\/Central/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Central">US/Central</option> <option <?php if (preg_match('/US\\/East-Indiana/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/East-Indiana">US/East-Indiana</option> <option <?php if (preg_match('/US\\/Eastern/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Eastern">US/Eastern</option> <option <?php if (preg_match('/US\\/Hawaii/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Hawaii">US/Hawaii</option> <option <?php if (preg_match('/US\\/Indiana-Starke/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Indiana-Starke">US/Indiana-Starke</option> <option <?php if (preg_match('/US\\/Michigan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Michigan">US/Michigan</option> <option <?php if (preg_match('/US\\/Mountain/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Mountain">US/Mountain</option> <option <?php if (preg_match('/US\\/Pacific/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Pacific">US/Pacific</option> <option <?php if (preg_match('/US\\/Samoa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="US/Samoa">US/Samoa</option> <option <?php if (preg_match('/Pacific\\/Apia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-11) Pacific/Apia">(GMT-11) Pacific/Apia</option> <option <?php if (preg_match('/Pacific\\/Midway/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-11) Pacific/Midway">(GMT-11) Pacific/Midway</option> <option <?php if (preg_match('/Pacific\\/Niue/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-11) Pacific/Niue">(GMT-11) Pacific/Niue</option> <option <?php if (preg_match('/Pacific\\/Pago_Pago/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-11) Pacific/Pago_Pago">(GMT-11) Pacific/Pago_Pago</option> <option <?php if (preg_match('/Pacific\\/Samoa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-11) Pacific/Samoa">(GMT-11) Pacific/Samoa</option> <option <?php if (preg_match('/America\\/Adak/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) America/Adak">(GMT-10) America/Adak</option> <option <?php if (preg_match('/America\\/Atka/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) America/Atka">(GMT-10) America/Atka</option> <option <?php if (preg_match('/Pacific\\/Fakaofo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) Pacific/Fakaofo">(GMT-10) Pacific/Fakaofo</option> <option <?php if (preg_match('/Pacific\\/Honolulu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) Pacific/Honolulu">(GMT-10) Pacific/Honolulu</option> <option <?php if (preg_match('/Pacific\\/Johnston/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) Pacific/Johnston">(GMT-10) Pacific/Johnston</option> <option <?php if (preg_match('/Pacific\\/Rarotonga/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) Pacific/Rarotonga">(GMT-10) Pacific/Rarotonga</option> <option <?php if (preg_match('/Pacific\\/Tahiti/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-10) Pacific/Tahiti">(GMT-10) Pacific/Tahiti</option> <option <?php if (preg_match('/Pacific\\/Marquesas/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9.5) Pacific/Marquesas">(GMT-9.5) Pacific/Marquesas</option> <option <?php if (preg_match('/America\\/Anchorage/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9) America/Anchorage">(GMT-9) America/Anchorage</option> <option <?php if (preg_match('/America\\/Juneau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9) America/Juneau">(GMT-9) America/Juneau</option> <option <?php if (preg_match('/America\\/Nome/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9) America/Nome">(GMT-9) America/Nome</option> <option <?php if (preg_match('/America\\/Yakutat/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9) America/Yakutat">(GMT-9) America/Yakutat</option> <option <?php if (preg_match('/Pacific\\/Gambier/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-9) Pacific/Gambier">(GMT-9) Pacific/Gambier</option> <option <?php if (preg_match('/America\\/Dawson/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Dawson">(GMT-8) America/Dawson</option> <option <?php if (preg_match('/America\\/Ensenada/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Ensenada">(GMT-8) America/Ensenada</option> <option <?php if (preg_match('/America\\/Los_Angeles/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Los_Angeles">(GMT-8) America/Los_Angeles</option> <option <?php if (preg_match('/America\\/Tijuana/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Tijuana">(GMT-8) America/Tijuana</option> <option <?php if (preg_match('/America\\/Vancouver/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Vancouver">(GMT-8) America/Vancouver</option> <option <?php if (preg_match('/America\\/Whitehorse/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) America/Whitehorse">(GMT-8) America/Whitehorse</option> <option <?php if (preg_match('/Pacific\\/Pitcairn/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-8) Pacific/Pitcairn">(GMT-8) Pacific/Pitcairn</option> <option <?php if (preg_match('/America\\/Boise/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Boise">(GMT-7) America/Boise</option> <option <?php if (preg_match('/America\\/Cambridge_Bay/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Cambridge_Bay">(GMT-7) America/Cambridge_Bay</option> <option <?php if (preg_match('/America\\/Chihuahua/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Chihuahua">(GMT-7) America/Chihuahua</option> <option <?php if (preg_match('/America\\/Dawson_Creek/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Dawson_Creek">(GMT-7) America/Dawson_Creek</option> <option <?php if (preg_match('/America\\/Denver/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Denver">(GMT-7) America/Denver</option> <option <?php if (preg_match('/America\\/Edmonton/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Edmonton">(GMT-7) America/Edmonton</option> <option <?php if (preg_match('/America\\/Hermosillo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Hermosillo">(GMT-7) America/Hermosillo</option> <option <?php if (preg_match('/America\\/Inuvik/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Inuvik">(GMT-7) America/Inuvik</option> <option <?php if (preg_match('/America\\/Mazatlan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Mazatlan">(GMT-7) America/Mazatlan</option> <option <?php if (preg_match('/America\\/Phoenix/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Phoenix">(GMT-7) America/Phoenix</option> <option <?php if (preg_match('/America\\/Shiprock/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Shiprock">(GMT-7) America/Shiprock</option> <option <?php if (preg_match('/America\\/Yellowknife/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-7) America/Yellowknife">(GMT-7) America/Yellowknife</option> <option <?php if (preg_match('/America\\/Belize/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Belize">(GMT-6) America/Belize</option> <option <?php if (preg_match('/America\\/Cancun/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Cancun">(GMT-6) America/Cancun</option> <option <?php if (preg_match('/America\\/Chicago/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Chicago">(GMT-6) America/Chicago</option> <option <?php if (preg_match('/America\\/Costa_Rica/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Costa_Rica">(GMT-6) America/Costa_Rica</option> <option <?php if (preg_match('/America\\/El_Salvador/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/El_Salvador">(GMT-6) America/El_Salvador</option> <option <?php if (preg_match('/America\\/Guatemala/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Guatemala">(GMT-6) America/Guatemala</option> <option <?php if (preg_match('/America\\/Knox_IN/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Knox_IN">(GMT-6) America/Knox_IN</option> <option <?php if (preg_match('/America\\/Managua/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Managua">(GMT-6) America/Managua</option> <option <?php if (preg_match('/America\\/Menominee/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Menominee">(GMT-6) America/Menominee</option> <option <?php if (preg_match('/America\\/Merida/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Merida">(GMT-6) America/Merida</option> <option <?php if (preg_match('/America\\/Mexico_City/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Mexico_City">(GMT-6) America/Mexico_City</option> <option <?php if (preg_match('/America\\/Monterrey/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Monterrey">(GMT-6) America/Monterrey</option> <option <?php if (preg_match('/America\\/Rainy_River/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Rainy_River">(GMT-6) America/Rainy_River</option> <option <?php if (preg_match('/America\\/Rankin_Inlet/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Rankin_Inlet">(GMT-6) America/Rankin_Inlet</option> <option <?php if (preg_match('/America\\/Regina/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Regina">(GMT-6) America/Regina</option> <option <?php if (preg_match('/America\\/Swift_Current/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Swift_Current">(GMT-6) America/Swift_Current</option> <option <?php if (preg_match('/America\\/Tegucigalpa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Tegucigalpa">(GMT-6) America/Tegucigalpa</option> <option <?php if (preg_match('/America\\/Winnipeg/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) America/Winnipeg">(GMT-6) America/Winnipeg</option> <option <?php if (preg_match('/Pacific\\/Easter/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) Pacific/Easter">(GMT-6) Pacific/Easter</option> <option <?php if (preg_match('/Pacific\\/Galapagos/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-6) Pacific/Galapagos">(GMT-6) Pacific/Galapagos</option> <option <?php if (preg_match('/America\\/Atikokan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Atikokan">(GMT-5) America/Atikokan</option> <option <?php if (preg_match('/America\\/Bogota/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Bogota">(GMT-5) America/Bogota</option> <option <?php if (preg_match('/America\\/Cayman/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Cayman">(GMT-5) America/Cayman</option> <option <?php if (preg_match('/America\\/Coral_Harbour/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Coral_Harbour">(GMT-5) America/Coral_Harbour</option> <option <?php if (preg_match('/America\\/Detroit/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Detroit">(GMT-5) America/Detroit</option> <option <?php if (preg_match('/America\\/Fort_Wayne/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Fort_Wayne">(GMT-5) America/Fort_Wayne</option> <option <?php if (preg_match('/America\\/Grand_Turk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Grand_Turk">(GMT-5) America/Grand_Turk</option> <option <?php if (preg_match('/America\\/Guayaquil/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Guayaquil">(GMT-5) America/Guayaquil</option> <option <?php if (preg_match('/America\\/Havana/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Havana">(GMT-5) America/Havana</option> <option <?php if (preg_match('/America\\/Indianapolis/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Indianapolis">(GMT-5) America/Indianapolis</option> <option <?php if (preg_match('/America\\/Iqaluit/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Iqaluit">(GMT-5) America/Iqaluit</option> <option <?php if (preg_match('/America\\/Jamaica/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Jamaica">(GMT-5) America/Jamaica</option> <option <?php if (preg_match('/America\\/Lima/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Lima">(GMT-5) America/Lima</option> <option <?php if (preg_match('/America\\/Louisville/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Louisville">(GMT-5) America/Louisville</option> <option <?php if (preg_match('/America\\/Montreal/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Montreal">(GMT-5) America/Montreal</option> <option <?php if (preg_match('/America\\/Nassau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Nassau">(GMT-5) America/Nassau</option> <option <?php if (preg_match('/America\\/New_York/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/New_York">(GMT-5) America/New_York</option> <option <?php if (preg_match('/America\\/Nipigon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Nipigon">(GMT-5) America/Nipigon</option> <option <?php if (preg_match('/America\\/Panama/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Panama">(GMT-5) America/Panama</option> <option <?php if (preg_match('/America\\/Pangnirtung/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Pangnirtung">(GMT-5) America/Pangnirtung</option> <option <?php if (preg_match('/America\\/Port-au-Prince/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Port-au-Prince">(GMT-5) America/Port-au-Prince</option> <option <?php if (preg_match('/America\\/Resolute/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Resolute">(GMT-5) America/Resolute</option> <option <?php if (preg_match('/America\\/Thunder_Bay/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Thunder_Bay">(GMT-5) America/Thunder_Bay</option> <option <?php if (preg_match('/America\\/Toronto/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-5) America/Toronto">(GMT-5) America/Toronto</option> <option <?php if (preg_match('/America\\/Caracas/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4.5) America/Caracas">(GMT-4.5) America/Caracas</option> <option <?php if (preg_match('/America\\/Anguilla/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Anguilla">(GMT-4) America/Anguilla</option> <option <?php if (preg_match('/America\\/Antigua/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Antigua">(GMT-4) America/Antigua</option> <option <?php if (preg_match('/America\\/Aruba/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Aruba">(GMT-4) America/Aruba</option> <option <?php if (preg_match('/America\\/Asuncion/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Asuncion">(GMT-4) America/Asuncion</option> <option <?php if (preg_match('/America\\/Barbados/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Barbados">(GMT-4) America/Barbados</option> <option <?php if (preg_match('/America\\/Blanc-Sablon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Blanc-Sablon">(GMT-4) America/Blanc-Sablon</option> <option <?php if (preg_match('/America\\/Boa_Vista/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Boa_Vista">(GMT-4) America/Boa_Vista</option> <option <?php if (preg_match('/America\\/Campo_Grande/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Campo_Grande">(GMT-4) America/Campo_Grande</option> <option <?php if (preg_match('/America\\/Cuiaba/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Cuiaba">(GMT-4) America/Cuiaba</option> <option <?php if (preg_match('/America\\/Curacao/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Curacao">(GMT-4) America/Curacao</option> <option <?php if (preg_match('/America\\/Dominica/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Dominica">(GMT-4) America/Dominica</option> <option <?php if (preg_match('/America\\/Eirunepe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Eirunepe">(GMT-4) America/Eirunepe</option> <option <?php if (preg_match('/America\\/Glace_Bay/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Glace_Bay">(GMT-4) America/Glace_Bay</option> <option <?php if (preg_match('/America\\/Goose_Bay/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Goose_Bay">(GMT-4) America/Goose_Bay</option> <option <?php if (preg_match('/America\\/Grenada/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Grenada">(GMT-4) America/Grenada</option> <option <?php if (preg_match('/America\\/Guadeloupe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Guadeloupe">(GMT-4) America/Guadeloupe</option> <option <?php if (preg_match('/America\\/Guyana/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Guyana">(GMT-4) America/Guyana</option> <option <?php if (preg_match('/America\\/Halifax/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Halifax">(GMT-4) America/Halifax</option> <option <?php if (preg_match('/America\\/La_Paz/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/La_Paz">(GMT-4) America/La_Paz</option> <option <?php if (preg_match('/America\\/Manaus/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Manaus">(GMT-4) America/Manaus</option> <option <?php if (preg_match('/America\\/Marigot/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Marigot">(GMT-4) America/Marigot</option> <option <?php if (preg_match('/America\\/Martinique/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Martinique">(GMT-4) America/Martinique</option> <option <?php if (preg_match('/America\\/Moncton/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Moncton">(GMT-4) America/Moncton</option> <option <?php if (preg_match('/America\\/Montserrat/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Montserrat">(GMT-4) America/Montserrat</option> <option <?php if (preg_match('/America\\/Port_of_Spain/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Port_of_Spain">(GMT-4) America/Port_of_Spain</option> <option <?php if (preg_match('/America\\/Porto_Acre/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Porto_Acre">(GMT-4) America/Porto_Acre</option> <option <?php if (preg_match('/America\\/Porto_Velho/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Porto_Velho">(GMT-4) America/Porto_Velho</option> <option <?php if (preg_match('/America\\/Puerto_Rico/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Puerto_Rico">(GMT-4) America/Puerto_Rico</option> <option <?php if (preg_match('/America\\/Rio_Branco/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Rio_Branco">(GMT-4) America/Rio_Branco</option> <option <?php if (preg_match('/America\\/Santiago/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Santiago">(GMT-4) America/Santiago</option> <option <?php if (preg_match('/America\\/Santo_Domingo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Santo_Domingo">(GMT-4) America/Santo_Domingo</option> <option <?php if (preg_match('/America\\/St_Barthelemy/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/St_Barthelemy">(GMT-4) America/St_Barthelemy</option> <option <?php if (preg_match('/America\\/St_Kitts/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/St_Kitts">(GMT-4) America/St_Kitts</option> <option <?php if (preg_match('/America\\/St_Lucia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/St_Lucia">(GMT-4) America/St_Lucia</option> <option <?php if (preg_match('/America\\/St_Thomas/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/St_Thomas">(GMT-4) America/St_Thomas</option> <option <?php if (preg_match('/America\\/St_Vincent/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/St_Vincent">(GMT-4) America/St_Vincent</option> <option <?php if (preg_match('/America\\/Thule/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Thule">(GMT-4) America/Thule</option> <option <?php if (preg_match('/America\\/Tortola/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Tortola">(GMT-4) America/Tortola</option> <option <?php if (preg_match('/America\\/Virgin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) America/Virgin">(GMT-4) America/Virgin</option> <option <?php if (preg_match('/Antarctica\\/Palmer/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) Antarctica/Palmer">(GMT-4) Antarctica/Palmer</option> <option <?php if (preg_match('/Atlantic\\/Bermuda/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) Atlantic/Bermuda">(GMT-4) Atlantic/Bermuda</option> <option <?php if (preg_match('/Atlantic\\/Stanley/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-4) Atlantic/Stanley">(GMT-4) Atlantic/Stanley</option> <option <?php if (preg_match('/America\\/St_Johns/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3.5) America/St_Johns">(GMT-3.5) America/St_Johns</option> <option <?php if (preg_match('/America\\/Araguaina/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Araguaina">(GMT-3) America/Araguaina</option> <option <?php if (preg_match('/America\\/Bahia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Bahia">(GMT-3) America/Bahia</option> <option <?php if (preg_match('/America\\/Belem/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Belem">(GMT-3) America/Belem</option> <option <?php if (preg_match('/America\\/Buenos_Aires/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Buenos_Aires">(GMT-3) America/Buenos_Aires</option> <option <?php if (preg_match('/America\\/Catamarca/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Catamarca">(GMT-3) America/Catamarca</option> <option <?php if (preg_match('/America\\/Cayenne/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Cayenne">(GMT-3) America/Cayenne</option> <option <?php if (preg_match('/America\\/Cordoba/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Cordoba">(GMT-3) America/Cordoba</option> <option <?php if (preg_match('/America\\/Fortaleza/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Fortaleza">(GMT-3) America/Fortaleza</option> <option <?php if (preg_match('/America\\/Godthab/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Godthab">(GMT-3) America/Godthab</option> <option <?php if (preg_match('/America\\/Jujuy/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Jujuy">(GMT-3) America/Jujuy</option> <option <?php if (preg_match('/America\\/Maceio/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Maceio">(GMT-3) America/Maceio</option> <option <?php if (preg_match('/America\\/Mendoza/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Mendoza">(GMT-3) America/Mendoza</option> <option <?php if (preg_match('/America\\/Miquelon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Miquelon">(GMT-3) America/Miquelon</option> <option <?php if (preg_match('/America\\/Montevideo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Montevideo">(GMT-3) America/Montevideo</option> <option <?php if (preg_match('/America\\/Paramaribo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Paramaribo">(GMT-3) America/Paramaribo</option> <option <?php if (preg_match('/America\\/Recife/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Recife">(GMT-3) America/Recife</option> <option <?php if (preg_match('/America\\/Rosario/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Rosario">(GMT-3) America/Rosario</option> <option <?php if (preg_match('/America\\/Santarem/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Santarem">(GMT-3) America/Santarem</option> <option <?php if (preg_match('/America\\/Sao_Paulo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) America/Sao_Paulo">(GMT-3) America/Sao_Paulo</option> <option <?php if (preg_match('/Antarctica\\/Rothera/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-3) Antarctica/Rothera">(GMT-3) Antarctica/Rothera</option> <option <?php if (preg_match('/America\\/Noronha/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-2) America/Noronha">(GMT-2) America/Noronha</option> <option <?php if (preg_match('/Atlantic\\/South_Georgia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-2) Atlantic/South_Georgia">(GMT-2) Atlantic/South_Georgia</option> <option <?php if (preg_match('/America\\/Scoresbysund/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-1) America/Scoresbysund">(GMT-1) America/Scoresbysund</option> <option <?php if (preg_match('/Atlantic\\/Azores/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-1) Atlantic/Azores">(GMT-1) Atlantic/Azores</option> <option <?php if (preg_match('/Atlantic\\/Cape_Verde/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT-1) Atlantic/Cape_Verde">(GMT-1) Atlantic/Cape_Verde</option> <option <?php if (preg_match('/Africa\\/Abidjan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Abidjan">(GMT+0) Africa/Abidjan</option> <option <?php if (preg_match('/Africa\\/Accra/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Accra">(GMT+0) Africa/Accra</option> <option <?php if (preg_match('/Africa\\/Bamako/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Bamako">(GMT+0) Africa/Bamako</option> <option <?php if (preg_match('/Africa\\/Banjul/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Banjul">(GMT+0) Africa/Banjul</option> <option <?php if (preg_match('/Africa\\/Bissau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Bissau">(GMT+0) Africa/Bissau</option> <option <?php if (preg_match('/Africa\\/Casablanca/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Casablanca">(GMT+0) Africa/Casablanca</option> <option <?php if (preg_match('/Africa\\/Conakry/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Conakry">(GMT+0) Africa/Conakry</option> <option <?php if (preg_match('/Africa\\/Dakar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Dakar">(GMT+0) Africa/Dakar</option> <option <?php if (preg_match('/Africa\\/El_Aaiun/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/El_Aaiun">(GMT+0) Africa/El_Aaiun</option> <option <?php if (preg_match('/Africa\\/Freetown/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Freetown">(GMT+0) Africa/Freetown</option> <option <?php if (preg_match('/Africa\\/Lome/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Lome">(GMT+0) Africa/Lome</option> <option <?php if (preg_match('/Africa\\/Monrovia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Monrovia">(GMT+0) Africa/Monrovia</option> <option <?php if (preg_match('/Africa\\/Nouakchott/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Nouakchott">(GMT+0) Africa/Nouakchott</option> <option <?php if (preg_match('/Africa\\/Ouagadougou/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Ouagadougou">(GMT+0) Africa/Ouagadougou</option> <option <?php if (preg_match('/Africa\\/Sao_Tome/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Sao_Tome">(GMT+0) Africa/Sao_Tome</option> <option <?php if (preg_match('/Africa\\/Timbuktu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Africa/Timbuktu">(GMT+0) Africa/Timbuktu</option> <option <?php if (preg_match('/America\\/Danmarkshavn/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) America/Danmarkshavn">(GMT+0) America/Danmarkshavn</option> <option <?php if (preg_match('/Atlantic\\/Canary/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/Canary">(GMT+0) Atlantic/Canary</option> <option <?php if (preg_match('/Atlantic\\/Faeroe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/Faeroe">(GMT+0) Atlantic/Faeroe</option> <option <?php if (preg_match('/Atlantic\\/Faroe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/Faroe">(GMT+0) Atlantic/Faroe</option> <option <?php if (preg_match('/Atlantic\\/Madeira/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/Madeira">(GMT+0) Atlantic/Madeira</option> <option <?php if (preg_match('/Atlantic\\/Reykjavik/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/Reykjavik">(GMT+0) Atlantic/Reykjavik</option> <option <?php if (preg_match('/Atlantic\\/St_Helena/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Atlantic/St_Helena">(GMT+0) Atlantic/St_Helena</option> <option <?php if (preg_match('/Europe\\/Belfast/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Belfast">(GMT+0) Europe/Belfast</option> <option <?php if (preg_match('/Europe\\/Dublin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Dublin">(GMT+0) Europe/Dublin</option> <option <?php if (preg_match('/Europe\\/Guernsey/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Guernsey">(GMT+0) Europe/Guernsey</option> <option <?php if (preg_match('/Europe\\/Isle_of_Man/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Isle_of_Man">(GMT+0) Europe/Isle_of_Man</option> <option <?php if (preg_match('/Europe\\/Jersey/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Jersey">(GMT+0) Europe/Jersey</option> <option <?php if (preg_match('/Europe\\/Lisbon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/Lisbon">(GMT+0) Europe/Lisbon</option> <option <?php if (preg_match('/Europe\\/London/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+0) Europe/London">(GMT+0) Europe/London</option> <option <?php if (preg_match('/Africa\\/Algiers/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Algiers">(GMT+1) Africa/Algiers</option> <option <?php if (preg_match('/Africa\\/Bangui/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Bangui">(GMT+1) Africa/Bangui</option> <option <?php if (preg_match('/Africa\\/Brazzaville/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Brazzaville">(GMT+1) Africa/Brazzaville</option> <option <?php if (preg_match('/Africa\\/Ceuta/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Ceuta">(GMT+1) Africa/Ceuta</option> <option <?php if (preg_match('/Africa\\/Douala/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Douala">(GMT+1) Africa/Douala</option> <option <?php if (preg_match('/Africa\\/Kinshasa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Kinshasa">(GMT+1) Africa/Kinshasa</option> <option <?php if (preg_match('/Africa\\/Lagos/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Lagos">(GMT+1) Africa/Lagos</option> <option <?php if (preg_match('/Africa\\/Libreville/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Libreville">(GMT+1) Africa/Libreville</option> <option <?php if (preg_match('/Africa\\/Luanda/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Luanda">(GMT+1) Africa/Luanda</option> <option <?php if (preg_match('/Africa\\/Malabo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Malabo">(GMT+1) Africa/Malabo</option> <option <?php if (preg_match('/Africa\\/Ndjamena/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Ndjamena">(GMT+1) Africa/Ndjamena</option> <option <?php if (preg_match('/Africa\\/Niamey/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Niamey">(GMT+1) Africa/Niamey</option> <option <?php if (preg_match('/Africa\\/Porto-Novo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Porto-Novo">(GMT+1) Africa/Porto-Novo</option> <option <?php if (preg_match('/Africa\\/Tunis/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Tunis">(GMT+1) Africa/Tunis</option> <option <?php if (preg_match('/Africa\\/Windhoek/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Africa/Windhoek">(GMT+1) Africa/Windhoek</option> <option <?php if (preg_match('/Atlantic\\/Jan_Mayen/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Atlantic/Jan_Mayen">(GMT+1) Atlantic/Jan_Mayen</option> <option <?php if (preg_match('/Europe\\/Amsterdam/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Amsterdam">(GMT+1) Europe/Amsterdam</option> <option <?php if (preg_match('/Europe\\/Andorra/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Andorra">(GMT+1) Europe/Andorra</option> <option <?php if (preg_match('/Europe\\/Belgrade/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Belgrade">(GMT+1) Europe/Belgrade</option> <option <?php if (preg_match('/Europe\\/Berlin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Berlin">(GMT+1) Europe/Berlin</option> <option <?php if (preg_match('/Europe\\/Bratislava/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Bratislava">(GMT+1) Europe/Bratislava</option> <option <?php if (preg_match('/Europe\\/Brussels/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Brussels">(GMT+1) Europe/Brussels</option> <option <?php if (preg_match('/Europe\\/Budapest/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Budapest">(GMT+1) Europe/Budapest</option> <option <?php if (preg_match('/Europe\\/Copenhagen/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Copenhagen">(GMT+1) Europe/Copenhagen</option> <option <?php if (preg_match('/Europe\\/Gibraltar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Gibraltar">(GMT+1) Europe/Gibraltar</option> <option <?php if (preg_match('/Europe\\/Ljubljana/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Ljubljana">(GMT+1) Europe/Ljubljana</option> <option <?php if (preg_match('/Europe\\/Luxembourg/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Luxembourg">(GMT+1) Europe/Luxembourg</option> <option <?php if (preg_match('/Europe\\/Madrid/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Madrid">(GMT+1) Europe/Madrid</option> <option <?php if (preg_match('/Europe\\/Malta/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Malta">(GMT+1) Europe/Malta</option> <option <?php if (preg_match('/Europe\\/Monaco/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Monaco">(GMT+1) Europe/Monaco</option> <option <?php if (preg_match('/Europe\\/Oslo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Oslo">(GMT+1) Europe/Oslo</option> <option <?php if (preg_match('/Europe\\/Paris/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Paris">(GMT+1) Europe/Paris</option> <option <?php if (preg_match('/Europe\\/Podgorica/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Podgorica">(GMT+1) Europe/Podgorica</option> <option <?php if (preg_match('/Europe\\/Prague/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Prague">(GMT+1) Europe/Prague</option> <option <?php if (preg_match('/Europe\\/Rome/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Rome">(GMT+1) Europe/Rome</option> <option <?php if (preg_match('/Europe\\/San_Marino/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/San_Marino">(GMT+1) Europe/San_Marino</option> <option <?php if (preg_match('/Europe\\/Sarajevo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Sarajevo">(GMT+1) Europe/Sarajevo</option> <option <?php if (preg_match('/Europe\\/Skopje/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Skopje">(GMT+1) Europe/Skopje</option> <option <?php if (preg_match('/Europe\\/Stockholm/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Stockholm">(GMT+1) Europe/Stockholm</option> <option <?php if (preg_match('/Europe\\/Tirane/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Tirane">(GMT+1) Europe/Tirane</option> <option <?php if (preg_match('/Europe\\/Vaduz/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Vaduz">(GMT+1) Europe/Vaduz</option> <option <?php if (preg_match('/Europe\\/Vatican/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Vatican">(GMT+1) Europe/Vatican</option> <option <?php if (preg_match('/Europe\\/Vienna/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Vienna">(GMT+1) Europe/Vienna</option> <option <?php if (preg_match('/Europe\\/Warsaw/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Warsaw">(GMT+1) Europe/Warsaw</option> <option <?php if (preg_match('/Europe\\/Zagreb/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Zagreb">(GMT+1) Europe/Zagreb</option> <option <?php if (preg_match('/Europe\\/Zurich/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+1) Europe/Zurich">(GMT+1) Europe/Zurich</option> <option <?php if (preg_match('/Africa\\/Blantyre/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Blantyre">(GMT+2) Africa/Blantyre</option> <option <?php if (preg_match('/Africa\\/Bujumbura/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Bujumbura">(GMT+2) Africa/Bujumbura</option> <option <?php if (preg_match('/Africa\\/Cairo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Cairo">(GMT+2) Africa/Cairo</option> <option <?php if (preg_match('/Africa\\/Gaborone/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Gaborone">(GMT+2) Africa/Gaborone</option> <option <?php if (preg_match('/Africa\\/Harare/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Harare">(GMT+2) Africa/Harare</option> <option <?php if (preg_match('/Africa\\/Johannesburg/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Johannesburg">(GMT+2) Africa/Johannesburg</option> <option <?php if (preg_match('/Africa\\/Kigali/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Kigali">(GMT+2) Africa/Kigali</option> <option <?php if (preg_match('/Africa\\/Lubumbashi/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Lubumbashi">(GMT+2) Africa/Lubumbashi</option> <option <?php if (preg_match('/Africa\\/Lusaka/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Lusaka">(GMT+2) Africa/Lusaka</option> <option <?php if (preg_match('/Africa\\/Maputo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Maputo">(GMT+2) Africa/Maputo</option> <option <?php if (preg_match('/Africa\\/Maseru/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Maseru">(GMT+2) Africa/Maseru</option> <option <?php if (preg_match('/Africa\\/Mbabane/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Mbabane">(GMT+2) Africa/Mbabane</option> <option <?php if (preg_match('/Africa\\/Tripoli/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Africa/Tripoli">(GMT+2) Africa/Tripoli</option> <option <?php if (preg_match('/Asia\\/Amman/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Amman">(GMT+2) Asia/Amman</option> <option <?php if (preg_match('/Asia\\/Beirut/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Beirut">(GMT+2) Asia/Beirut</option> <option <?php if (preg_match('/Asia\\/Damascus/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Damascus">(GMT+2) Asia/Damascus</option> <option <?php if (preg_match('/Asia\\/Gaza/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Gaza">(GMT+2) Asia/Gaza</option> <option <?php if (preg_match('/Asia\\/Istanbul/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Istanbul">(GMT+2) Asia/Istanbul</option> <option <?php if (preg_match('/Asia\\/Jerusalem/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Jerusalem">(GMT+2) Asia/Jerusalem</option> <option <?php if (preg_match('/Asia\\/Nicosia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Nicosia">(GMT+2) Asia/Nicosia</option> <option <?php if (preg_match('/Asia\\/Tel_Aviv/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Asia/Tel_Aviv">(GMT+2) Asia/Tel_Aviv</option> <option <?php if (preg_match('/Europe\\/Athens/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Athens">(GMT+2) Europe/Athens</option> <option <?php if (preg_match('/Europe\\/Bucharest/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Bucharest">(GMT+2) Europe/Bucharest</option> <option <?php if (preg_match('/Europe\\/Chisinau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Chisinau">(GMT+2) Europe/Chisinau</option> <option <?php if (preg_match('/Europe\\/Helsinki/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Helsinki">(GMT+2) Europe/Helsinki</option> <option <?php if (preg_match('/Europe\\/Istanbul/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Istanbul">(GMT+2) Europe/Istanbul</option> <option <?php if (preg_match('/Europe\\/Kaliningrad/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Kaliningrad">(GMT+2) Europe/Kaliningrad</option> <option <?php if (preg_match('/Europe\\/Kiev/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Kiev">(GMT+2) Europe/Kiev</option> <option <?php if (preg_match('/Europe\\/Mariehamn/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Mariehamn">(GMT+2) Europe/Mariehamn</option> <option <?php if (preg_match('/Europe\\/Minsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Minsk">(GMT+2) Europe/Minsk</option> <option <?php if (preg_match('/Europe\\/Nicosia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Nicosia">(GMT+2) Europe/Nicosia</option> <option <?php if (preg_match('/Europe\\/Riga/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Riga">(GMT+2) Europe/Riga</option> <option <?php if (preg_match('/Europe\\/Simferopol/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Simferopol">(GMT+2) Europe/Simferopol</option> <option <?php if (preg_match('/Europe\\/Sofia/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Sofia">(GMT+2) Europe/Sofia</option> <option <?php if (preg_match('/Europe\\/Tallinn/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Tallinn">(GMT+2) Europe/Tallinn</option> <option <?php if (preg_match('/Europe\\/Tiraspol/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Tiraspol">(GMT+2) Europe/Tiraspol</option> <option <?php if (preg_match('/Europe\\/Uzhgorod/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Uzhgorod">(GMT+2) Europe/Uzhgorod</option> <option <?php if (preg_match('/Europe\\/Vilnius/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Vilnius">(GMT+2) Europe/Vilnius</option> <option <?php if (preg_match('/Europe\\/Zaporozhye/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+2) Europe/Zaporozhye">(GMT+2) Europe/Zaporozhye</option> <option <?php if (preg_match('/Africa\\/Addis_Ababa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Addis_Ababa">(GMT+3) Africa/Addis_Ababa</option> <option <?php if (preg_match('/Africa\\/Asmara/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Asmara">(GMT+3) Africa/Asmara</option> <option <?php if (preg_match('/Africa\\/Asmera/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Asmera">(GMT+3) Africa/Asmera</option> <option <?php if (preg_match('/Africa\\/Dar_es_Salaam/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Dar_es_Salaam">(GMT+3) Africa/Dar_es_Salaam</option> <option <?php if (preg_match('/Africa\\/Djibouti/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Djibouti">(GMT+3) Africa/Djibouti</option> <option <?php if (preg_match('/Africa\\/Kampala/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Kampala">(GMT+3) Africa/Kampala</option> <option <?php if (preg_match('/Africa\\/Khartoum/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Khartoum">(GMT+3) Africa/Khartoum</option> <option <?php if (preg_match('/Africa\\/Mogadishu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Mogadishu">(GMT+3) Africa/Mogadishu</option> <option <?php if (preg_match('/Africa\\/Nairobi/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Africa/Nairobi">(GMT+3) Africa/Nairobi</option> <option <?php if (preg_match('/Antarctica\\/Syowa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Antarctica/Syowa">(GMT+3) Antarctica/Syowa</option> <option <?php if (preg_match('/Asia\\/Aden/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Aden">(GMT+3) Asia/Aden</option> <option <?php if (preg_match('/Asia\\/Baghdad/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Baghdad">(GMT+3) Asia/Baghdad</option> <option <?php if (preg_match('/Asia\\/Bahrain/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Bahrain">(GMT+3) Asia/Bahrain</option> <option <?php if (preg_match('/Asia\\/Kuwait/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Kuwait">(GMT+3) Asia/Kuwait</option> <option <?php if (preg_match('/Asia\\/Qatar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Qatar">(GMT+3) Asia/Qatar</option> <option <?php if (preg_match('/Asia\\/Riyadh/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Asia/Riyadh">(GMT+3) Asia/Riyadh</option> <option <?php if (preg_match('/Europe\\/Moscow/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Europe/Moscow">(GMT+3) Europe/Moscow</option> <option <?php if (preg_match('/Europe\\/Volgograd/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Europe/Volgograd">(GMT+3) Europe/Volgograd</option> <option <?php if (preg_match('/Indian\\/Antananarivo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Indian/Antananarivo">(GMT+3) Indian/Antananarivo</option> <option <?php if (preg_match('/Indian\\/Comoro/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Indian/Comoro">(GMT+3) Indian/Comoro</option> <option <?php if (preg_match('/Indian\\/Mayotte/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3) Indian/Mayotte">(GMT+3) Indian/Mayotte</option> <option <?php if (preg_match('/Asia\\/Riyadh87/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3.11777777778) Asia/Riyadh87">(GMT+3.11777777778) Asia/Riyadh87</option> <option <?php if (preg_match('/Asia\\/Riyadh88/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3.11777777778) Asia/Riyadh88">(GMT+3.11777777778) Asia/Riyadh88</option> <option <?php if (preg_match('/Asia\\/Riyadh89/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3.11777777778) Asia/Riyadh89">(GMT+3.11777777778) Asia/Riyadh89</option> <option <?php if (preg_match('/Asia\\/Tehran/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+3.5) Asia/Tehran">(GMT+3.5) Asia/Tehran</option> <option <?php if (preg_match('/Asia\\/Baku/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Asia/Baku">(GMT+4) Asia/Baku</option> <option <?php if (preg_match('/Asia\\/Dubai/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Asia/Dubai">(GMT+4) Asia/Dubai</option> <option <?php if (preg_match('/Asia\\/Muscat/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Asia/Muscat">(GMT+4) Asia/Muscat</option> <option <?php if (preg_match('/Asia\\/Tbilisi/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Asia/Tbilisi">(GMT+4) Asia/Tbilisi</option> <option <?php if (preg_match('/Asia\\/Yerevan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Asia/Yerevan">(GMT+4) Asia/Yerevan</option> <option <?php if (preg_match('/Europe\\/Samara/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Europe/Samara">(GMT+4) Europe/Samara</option> <option <?php if (preg_match('/Indian\\/Mahe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Indian/Mahe">(GMT+4) Indian/Mahe</option> <option <?php if (preg_match('/Indian\\/Mauritius/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Indian/Mauritius">(GMT+4) Indian/Mauritius</option> <option <?php if (preg_match('/Indian\\/Reunion/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4) Indian/Reunion">(GMT+4) Indian/Reunion</option> <option <?php if (preg_match('/Asia\\/Kabul/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+4.5) Asia/Kabul">(GMT+4.5) Asia/Kabul</option> <option <?php if (preg_match('/Asia\\/Aqtau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Aqtau">(GMT+5) Asia/Aqtau</option> <option <?php if (preg_match('/Asia\\/Aqtobe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Aqtobe">(GMT+5) Asia/Aqtobe</option> <option <?php if (preg_match('/Asia\\/Ashgabat/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Ashgabat">(GMT+5) Asia/Ashgabat</option> <option <?php if (preg_match('/Asia\\/Ashkhabad/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Ashkhabad">(GMT+5) Asia/Ashkhabad</option> <option <?php if (preg_match('/Asia\\/Dushanbe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Dushanbe">(GMT+5) Asia/Dushanbe</option> <option <?php if (preg_match('/Asia\\/Karachi/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Karachi">(GMT+5) Asia/Karachi</option> <option <?php if (preg_match('/Asia\\/Oral/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Oral">(GMT+5) Asia/Oral</option> <option <?php if (preg_match('/Asia\\/Samarkand/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Samarkand">(GMT+5) Asia/Samarkand</option> <option <?php if (preg_match('/Asia\\/Tashkent/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Tashkent">(GMT+5) Asia/Tashkent</option> <option <?php if (preg_match('/Asia\\/Yekaterinburg/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Asia/Yekaterinburg">(GMT+5) Asia/Yekaterinburg</option> <option <?php if (preg_match('/Indian\\/Kerguelen/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Indian/Kerguelen">(GMT+5) Indian/Kerguelen</option> <option <?php if (preg_match('/Indian\\/Maldives/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5) Indian/Maldives">(GMT+5) Indian/Maldives</option> <option <?php if (preg_match('/Asia\\/Calcutta/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5.5) Asia/Calcutta">(GMT+5.5) Asia/Calcutta</option> <option <?php if (preg_match('/Asia\\/Colombo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5.5) Asia/Colombo">(GMT+5.5) Asia/Colombo</option> <option <?php if (preg_match('/Asia\\/Kolkata/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5.5) Asia/Kolkata">(GMT+5.5) Asia/Kolkata</option> <option <?php if (preg_match('/Asia\\/Kathmandu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5.75) Asia/Kathmandu">(GMT+5.75) Asia/Kathmandu</option> <option <?php if (preg_match('/Asia\\/Katmandu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+5.75) Asia/Katmandu">(GMT+5.75) Asia/Katmandu</option> <option <?php if (preg_match('/Antarctica\\/Mawson/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Antarctica/Mawson">(GMT+6) Antarctica/Mawson</option> <option <?php if (preg_match('/Antarctica\\/Vostok/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Antarctica/Vostok">(GMT+6) Antarctica/Vostok</option> <option <?php if (preg_match('/Asia\\/Almaty/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Almaty">(GMT+6) Asia/Almaty</option> <option <?php if (preg_match('/Asia\\/Bishkek/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Bishkek">(GMT+6) Asia/Bishkek</option> <option <?php if (preg_match('/Asia\\/Dacca/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Dacca">(GMT+6) Asia/Dacca</option> <option <?php if (preg_match('/Asia\\/Dhaka/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Dhaka">(GMT+6) Asia/Dhaka</option> <option <?php if (preg_match('/Asia\\/Novosibirsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Novosibirsk">(GMT+6) Asia/Novosibirsk</option> <option <?php if (preg_match('/Asia\\/Omsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Omsk">(GMT+6) Asia/Omsk</option> <option <?php if (preg_match('/Asia\\/Qyzylorda/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Qyzylorda">(GMT+6) Asia/Qyzylorda</option> <option <?php if (preg_match('/Asia\\/Thimbu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Thimbu">(GMT+6) Asia/Thimbu</option> <option <?php if (preg_match('/Asia\\/Thimphu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Asia/Thimphu">(GMT+6) Asia/Thimphu</option> <option <?php if (preg_match('/Indian\\/Chagos/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6) Indian/Chagos">(GMT+6) Indian/Chagos</option> <option <?php if (preg_match('/Asia\\/Rangoon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6.5) Asia/Rangoon">(GMT+6.5) Asia/Rangoon</option> <option <?php if (preg_match('/Indian\\/Cocos/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+6.5) Indian/Cocos">(GMT+6.5) Indian/Cocos</option> <option <?php if (preg_match('/Antarctica\\/Davis/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Antarctica/Davis">(GMT+7) Antarctica/Davis</option> <option <?php if (preg_match('/Asia\\/Bangkok/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Bangkok">(GMT+7) Asia/Bangkok</option> <option <?php if (preg_match('/Asia\\/Ho_Chi_Minh/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Ho_Chi_Minh">(GMT+7) Asia/Ho_Chi_Minh</option> <option <?php if (preg_match('/Asia\\/Hovd/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Hovd">(GMT+7) Asia/Hovd</option> <option <?php if (preg_match('/Asia\\/Jakarta/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Jakarta">(GMT+7) Asia/Jakarta</option> <option <?php if (preg_match('/Asia\\/Krasnoyarsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Krasnoyarsk">(GMT+7) Asia/Krasnoyarsk</option> <option <?php if (preg_match('/Asia\\/Phnom_Penh/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Phnom_Penh">(GMT+7) Asia/Phnom_Penh</option> <option <?php if (preg_match('/Asia\\/Pontianak/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Pontianak">(GMT+7) Asia/Pontianak</option> <option <?php if (preg_match('/Asia\\/Saigon/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Saigon">(GMT+7) Asia/Saigon</option> <option <?php if (preg_match('/Asia\\/Vientiane/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Asia/Vientiane">(GMT+7) Asia/Vientiane</option> <option <?php if (preg_match('/Indian\\/Christmas/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+7) Indian/Christmas">(GMT+7) Indian/Christmas</option> <option <?php if (preg_match('/Antarctica\\/Casey/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Antarctica/Casey">(GMT+8) Antarctica/Casey</option> <option <?php if (preg_match('/Asia\\/Brunei/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Brunei">(GMT+8) Asia/Brunei</option> <option <?php if (preg_match('/Asia\\/Choibalsan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Choibalsan">(GMT+8) Asia/Choibalsan</option> <option <?php if (preg_match('/Asia\\/Chongqing/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Chongqing">(GMT+8) Asia/Chongqing</option> <option <?php if (preg_match('/Asia\\/Chungking/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Chungking">(GMT+8) Asia/Chungking</option> <option <?php if (preg_match('/Asia\\/Harbin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Harbin">(GMT+8) Asia/Harbin</option> <option <?php if (preg_match('/Asia\\/Hong_Kong/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Hong_Kong">(GMT+8) Asia/Hong_Kong</option> <option <?php if (preg_match('/Asia\\/Irkutsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Irkutsk">(GMT+8) Asia/Irkutsk</option> <option <?php if (preg_match('/Asia\\/Kashgar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Kashgar">(GMT+8) Asia/Kashgar</option> <option <?php if (preg_match('/Asia\\/Kuala_Lumpur/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Kuala_Lumpur">(GMT+8) Asia/Kuala_Lumpur</option> <option <?php if (preg_match('/Asia\\/Kuching/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Kuching">(GMT+8) Asia/Kuching</option> <option <?php if (preg_match('/Asia\\/Macao/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Macao">(GMT+8) Asia/Macao</option> <option <?php if (preg_match('/Asia\\/Macau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Macau">(GMT+8) Asia/Macau</option> <option <?php if (preg_match('/Asia\\/Makassar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Makassar">(GMT+8) Asia/Makassar</option> <option <?php if (preg_match('/Asia\\/Manila/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Manila">(GMT+8) Asia/Manila</option> <option <?php if (preg_match('/Asia\\/Shanghai/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Shanghai">(GMT+8) Asia/Shanghai</option> <option <?php if (preg_match('/Asia\\/Singapore/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Singapore">(GMT+8) Asia/Singapore</option> <option <?php if (preg_match('/Asia\\/Taipei/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Taipei">(GMT+8) Asia/Taipei</option> <option <?php if (preg_match('/Asia\\/Ujung_Pandang/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Ujung_Pandang">(GMT+8) Asia/Ujung_Pandang</option> <option <?php if (preg_match('/Asia\\/Ulaanbaatar/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Ulaanbaatar">(GMT+8) Asia/Ulaanbaatar</option> <option <?php if (preg_match('/Asia\\/Ulan_Bator/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Ulan_Bator">(GMT+8) Asia/Ulan_Bator</option> <option <?php if (preg_match('/Asia\\/Urumqi/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Asia/Urumqi">(GMT+8) Asia/Urumqi</option> <option <?php if (preg_match('/Australia\\/Perth/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Australia/Perth">(GMT+8) Australia/Perth</option> <option <?php if (preg_match('/Australia\\/West/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8) Australia/West">(GMT+8) Australia/West</option> <option <?php if (preg_match('/Australia\\/Eucla/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+8.75) Australia/Eucla">(GMT+8.75) Australia/Eucla</option> <option <?php if (preg_match('/Asia\\/Dili/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Dili">(GMT+9) Asia/Dili</option> <option <?php if (preg_match('/Asia\\/Jayapura/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Jayapura">(GMT+9) Asia/Jayapura</option> <option <?php if (preg_match('/Asia\\/Pyongyang/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Pyongyang">(GMT+9) Asia/Pyongyang</option> <option <?php if (preg_match('/Asia\\/Seoul/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Seoul">(GMT+9) Asia/Seoul</option> <option <?php if (preg_match('/Asia\\/Tokyo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Tokyo">(GMT+9) Asia/Tokyo</option> <option <?php if (preg_match('/Asia\\/Yakutsk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Asia/Yakutsk">(GMT+9) Asia/Yakutsk</option> <option <?php if (preg_match('/Pacific\\/Palau/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9) Pacific/Palau">(GMT+9) Pacific/Palau</option> <option <?php if (preg_match('/Australia\\/Adelaide/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/Adelaide">(GMT+9.5) Australia/Adelaide</option> <option <?php if (preg_match('/Australia\\/Broken_Hill/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/Broken_Hill">(GMT+9.5) Australia/Broken_Hill</option> <option <?php if (preg_match('/Australia\\/Darwin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/Darwin">(GMT+9.5) Australia/Darwin</option> <option <?php if (preg_match('/Australia\\/North/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/North">(GMT+9.5) Australia/North</option> <option <?php if (preg_match('/Australia\\/South/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/South">(GMT+9.5) Australia/South</option> <option <?php if (preg_match('/Australia\\/Yancowinna/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+9.5) Australia/Yancowinna">(GMT+9.5) Australia/Yancowinna</option> <option <?php if (preg_match('/Antarctica\\/DumontDUrville/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Antarctica/DumontDUrville">(GMT+10) Antarctica/DumontDUrville</option> <option <?php if (preg_match('/Asia\\/Sakhalin/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Asia/Sakhalin">(GMT+10) Asia/Sakhalin</option> <option <?php if (preg_match('/Asia\\/Vladivostok/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Asia/Vladivostok">(GMT+10) Asia/Vladivostok</option> <option <?php if (preg_match('/Australia\\/ACT/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/ACT">(GMT+10) Australia/ACT</option> <option <?php if (preg_match('/Australia\\/Brisbane/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Brisbane">(GMT+10) Australia/Brisbane</option> <option <?php if (preg_match('/Australia\\/Canberra/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Canberra">(GMT+10) Australia/Canberra</option> <option <?php if (preg_match('/Australia\\/Currie/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Currie">(GMT+10) Australia/Currie</option> <option <?php if (preg_match('/Australia\\/Hobart/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Hobart">(GMT+10) Australia/Hobart</option> <option <?php if (preg_match('/Australia\\/LHI/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/LHI">(GMT+10) Australia/LHI</option> <option <?php if (preg_match('/Australia\\/Lindeman/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Lindeman">(GMT+10) Australia/Lindeman</option> <option <?php if (preg_match('/Australia\\/Lord_Howe/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Lord_Howe">(GMT+10) Australia/Lord_Howe</option> <option <?php if (preg_match('/Australia\\/Melbourne/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Melbourne">(GMT+10) Australia/Melbourne</option> <option <?php if (preg_match('/Australia\\/NSW/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/NSW">(GMT+10) Australia/NSW</option> <option <?php if (preg_match('/Australia\\/Queensland/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Queensland">(GMT+10) Australia/Queensland</option> <option <?php if (preg_match('/Australia\\/Sydney/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Sydney">(GMT+10) Australia/Sydney</option> <option <?php if (preg_match('/Australia\\/Tasmania/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Tasmania">(GMT+10) Australia/Tasmania</option> <option <?php if (preg_match('/Australia\\/Victoria/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Australia/Victoria">(GMT+10) Australia/Victoria</option> <option <?php if (preg_match('/Pacific\\/Guam/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Pacific/Guam">(GMT+10) Pacific/Guam</option> <option <?php if (preg_match('/Pacific\\/Port_Moresby/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Pacific/Port_Moresby">(GMT+10) Pacific/Port_Moresby</option> <option <?php if (preg_match('/Pacific\\/Saipan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Pacific/Saipan">(GMT+10) Pacific/Saipan</option> <option <?php if (preg_match('/Pacific\\/Truk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Pacific/Truk">(GMT+10) Pacific/Truk</option> <option <?php if (preg_match('/Pacific\\/Yap/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+10) Pacific/Yap">(GMT+10) Pacific/Yap</option> <option <?php if (preg_match('/Asia\\/Magadan/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Asia/Magadan">(GMT+11) Asia/Magadan</option> <option <?php if (preg_match('/Pacific\\/Efate/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Pacific/Efate">(GMT+11) Pacific/Efate</option> <option <?php if (preg_match('/Pacific\\/Guadalcanal/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Pacific/Guadalcanal">(GMT+11) Pacific/Guadalcanal</option> <option <?php if (preg_match('/Pacific\\/Kosrae/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Pacific/Kosrae">(GMT+11) Pacific/Kosrae</option> <option <?php if (preg_match('/Pacific\\/Noumea/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Pacific/Noumea">(GMT+11) Pacific/Noumea</option> <option <?php if (preg_match('/Pacific\\/Ponape/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11) Pacific/Ponape">(GMT+11) Pacific/Ponape</option> <option <?php if (preg_match('/Pacific\\/Norfolk/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+11.5) Pacific/Norfolk">(GMT+11.5) Pacific/Norfolk</option> <option <?php if (preg_match('/Antarctica\\/McMurdo/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Antarctica/McMurdo">(GMT+12) Antarctica/McMurdo</option> <option <?php if (preg_match('/Antarctica\\/South_Pole/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Antarctica/South_Pole">(GMT+12) Antarctica/South_Pole</option> <option <?php if (preg_match('/Asia\\/Anadyr/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Asia/Anadyr">(GMT+12) Asia/Anadyr</option> <option <?php if (preg_match('/Asia\\/Kamchatka/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Asia/Kamchatka">(GMT+12) Asia/Kamchatka</option> <option <?php if (preg_match('/Pacific\\/Auckland/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Auckland">(GMT+12) Pacific/Auckland</option> <option <?php if (preg_match('/Pacific\\/Fiji/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Fiji">(GMT+12) Pacific/Fiji</option> <option <?php if (preg_match('/Pacific\\/Funafuti/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Funafuti">(GMT+12) Pacific/Funafuti</option> <option <?php if (preg_match('/Pacific\\/Kwajalein/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Kwajalein">(GMT+12) Pacific/Kwajalein</option> <option <?php if (preg_match('/Pacific\\/Majuro/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Majuro">(GMT+12) Pacific/Majuro</option> <option <?php if (preg_match('/Pacific\\/Nauru/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Nauru">(GMT+12) Pacific/Nauru</option> <option <?php if (preg_match('/Pacific\\/Tarawa/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Tarawa">(GMT+12) Pacific/Tarawa</option> <option <?php if (preg_match('/Pacific\\/Wake/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Wake">(GMT+12) Pacific/Wake</option> <option <?php if (preg_match('/Pacific\\/Wallis/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12) Pacific/Wallis">(GMT+12) Pacific/Wallis</option> <option <?php if (preg_match('/Pacific\\/Chatham/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+12.75) Pacific/Chatham">(GMT+12.75) Pacific/Chatham</option> <option <?php if (preg_match('/Pacific\\/Enderbury/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+13) Pacific/Enderbury">(GMT+13) Pacific/Enderbury</option> <option <?php if (preg_match('/Pacific\\/Tongatapu/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+13) Pacific/Tongatapu">(GMT+13) Pacific/Tongatapu</option> <option <?php if (preg_match('/Pacific\\/Kiritimati/', get_option("em_timezone")) == '1') { ?> Selected="selected" <?php } ?> value="(GMT+14) Pacific/Kiritimati">(GMT+14) Pacific/Kiritimati</option> </select></div> </div> <?php if ($isedit) { ?> <div class="row"> <div class="left"> </div> <div class="right"><input type="submit" name="submit" id="eddevent" value="Edit Event"/></div> </div> <input type="hidden" name="eddem" id="eddem" value="1" /> <input type="hidden" name="emidd" id="emidd" value="<?php echo $editrow[0]->em_id; ?> "/> <?php } else { ?> <div class="row"> <div class="left"><strong>Save it as:</strong></div> <div class="right">A Popup?<input type="radio" name="saveitaspopup" id="saveitas" value="popup" selected/>OR A Post?<input type="radio" name="saveitaspopup" id="saveitas" value="posted"/></div> </div> <div class="row"> <div class="left"> </div> <div class="right"><input type="submit" name="submit" id="adddevent" value="Add Event"/></div> </div> <input type="hidden" name="addem" id="addem" value="1" /> <?php } ?> <input type="hidden" name="nonce-eventify" value="<?php echo wp_create_nonce('eventify-nonce'); ?> " /> </form> <?php /* Showing all events entered in the database to allow deletion */ ?> <br/><br/> <h3>Bulk Upload Events (See <a href="http://designerfoo.com/wordpress-plugin-eventify-simple-events-management">How to Video</a> )</h3> <form action="" enctype="multipart/form-data" method="POST"> <input name="csvfile" type="file" /> <input type="hidden" name="uploadems" id="uploadems" value="1" /> <input type="hidden" name="nonce-eventify" value="<?php echo wp_create_nonce('eventify-nonce'); ?> " /> <input type="submit" value="Upload Bulk Events" name="postedfpc"/> </form> <h3>Back up Events? See HowTo video to Backup/Restore events</h3> <form action="" method="post"> <div class="row"> <div class="left"> </div> <div class="right"> <input type="submit" value="Backup all Events" name="submit" id="backupallevents"></div> </div> <input type="hidden" name="nonce-eventify" value="<?php echo wp_create_nonce('eventify-nonce'); ?> " /> <input type="hidden" name="backemall" id="backemall" value="1" /> </form> <br/><br/> <h3>Events added (Events already present in the database)</h3> <table cellpadding="1" cellspacing="1" border="0"><tr> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Sr No.</strong></th> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Event Title</strong></th> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Event Date(mm/dd/yyyy)</strong></th> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Event Time</strong></th> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Event Venue</strong></th> <th style="background:#464646;color:#fff;text-align:center;padding:5px;"><strong>Event Details</strong></th> <th style="background:#464646;color:#fff;padding:5px;"><strong>Event Timzone</strong></th> <th style="background:#464646;color:#fff;padding:5px;"><strong>Event Saved As</strong></th> <th style="background:#464646;color:#fff;padding:5px;"><strong>Select to delete</strong></th> <th style="background:#464646;color:#fff;padding:5px;"><strong>Edit Event</strong></th> </tr> <?php $table_name = $wpdb->prefix . "em_main"; $sqlqry = "Select * from " . $table_name; $results_list = $wpdb->get_results($sqlqry); $i_list = 1; foreach ($results_list as $row_list) { ?> <tr> <td style="text-align:center;padding:5px;"><?php echo $i_list; ?> </td> <td style="text-align:center;padding:5px;"><?php echo $row_list->em_title; ?> </td> <td style="text-align:center;padding:5px;"><?php echo $row_list->em_date; ?> </td> <td style="text-align:center;padding:5px;"><?php echo $row_list->em_time; ?> </td> <td style="text-align:center;padding:5px;"><?php echo $row_list->em_venue; ?> </td> <td style="text-align:center;padding:5px;"><?php echo substr($row_list->em_desc, 0, 12) . "..."; ?> </td> <td style="text-align:center;padding:5px;"><?php echo $row_list->em_timezone; ?> </td> <td style="text-align:center;padding:5px;"><?php if ($row_list->em_savetype > 0) { echo 'POST'; } else { echo 'POPUP'; } ?> </td> <td style="text-align:center;padding:5px;"><input type="checkbox" name="delemid[]" id="delemid" value="<?php echo $row_list->em_id; ?> " /></td> <td style="text-align:center;padding:5px;"><form method="post" action=""><input type="submit" value="Edit Event" /><input type="hidden" value="<?php echo $row_list->em_id; ?> " name="eem"/><input type="hidden" name="nonce-eventify" value="<?php echo wp_create_nonce('eventify-nonce'); ?> " /></form></td> </tr> <?php $i_list++; } $wpdb->print_error(); ?> </table> <div class="row"> <div class="left"><div id="deleting"></div></div> <div class="right"><input type="button" name="submit" id="deldevent" value="Delete Selected Event(s)" onclick="javascript:postbackdel();"/></div> <input type="hidden" id="delnon" name="nonce-eventify" value="<?php echo wp_create_nonce('eventify-nonce'); ?> " /> <input type="hidden" name="delem" id="delem" value="1" /> </div><br/> <script language="javascript"> function postbackdel() { jQuery("#deleting").html("<em>Deleting Event(s)<\/em>"); var url = '<?php echo $_SERVER['REQUEST_URI']; ?> '; var nonce = jQuery("#delnon").val(); var delm = jQuery("#delem").val(); var delid = jQuery("#delemid").val(); var allVals = []; jQuery('#delemid:checked').each(function() { allVals.push(jQuery(this).val()); //alert(jQuery(this).val()); }); jQuery.post(url,{nonceeventify: nonce, delem: delm, 'delemid[]': allVals },function(data){jQuery("#deleting").html("<em>Event Deleted Reloading...<\/em>");location.reload(true);},"text"); } </script> <br/><br/> <div style="float:left"> <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="hidden" name="cmd" value="_s-xclick"> <input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHLwYJKoZIhvcNAQcEoIIHIDCCBxwCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYAMLVXUISBgs8zwEMpjwajr8j4EHkAt0XC5mkQGS19rbFJ7+HrGaFUH53zbCYxDgEERj6Osx6HPRbg76lvsIDbXgCsV5/cVoviG6Fc4fNlccwHBmedRXqQaFexXWYqsLMTjHGZR2XDELyVj/Ir/7oexM1mOQ5zaHexAuZkYhVpnyTELMAkGBSsOAwIaBQAwgawGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIBIU1gxCvc5eAgYj6lhT8+HaNApprqvq8WMz24g18OAoKlpa1jEADKGE67cPiXWdpbg564EKaxdk2A0eLs7HZdat0IQ+4Np9FltV53lUrDZ0dGf8iUWEb9UUFwJivSR/WyO617IYFTmnbIWrm7cEgcBCfwb47tHPPlGKsNcyWM+TAEiFKLJ9XYU6mK6zoM1ySQp4XoIIDhzCCA4MwggLsoAMCAQICAQAwDQYJKoZIhvcNAQEFBQAwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMB4XDTA0MDIxMzEwMTMxNVoXDTM1MDIxMzEwMTMxNVowgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDBR07d/ETMS1ycjtkpkvjXZe9k+6CieLuLsPumsJ7QC1odNz3sJiCbs2wC0nLE0uLGaEtXynIgRqIddYCHx88pb5HTXv4SZeuv0Rqq4+axW9PLAAATU8w04qqjaSXgbGLP3NmohqM6bV9kZZwZLR/klDaQGo1u9uDb9lr4Yn+rBQIDAQABo4HuMIHrMB0GA1UdDgQWBBSWn3y7xm8XvVk/UtcKG+wQ1mSUazCBuwYDVR0jBIGzMIGwgBSWn3y7xm8XvVk/UtcKG+wQ1mSUa6GBlKSBkTCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb22CAQAwDAYDVR0TBAUwAwEB/zANBgkqhkiG9w0BAQUFAAOBgQCBXzpWmoBa5e9fo6ujionW1hUhPkOBakTr3YCDjbYfvJEiv/2P+IobhOGJr85+XHhN0v4gUkEDI8r2/rNk1m0GA8HKddvTjyGw/XqXa+LSTlDYkqI8OwR8GEYj4efEtcRpRYBxV8KxAW93YDWzFGvruKnnLbDAF6VR5w/cCMn5hzGCAZowggGWAgEBMIGUMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbQIBADAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDkxMDMwMTYyMTIzWjAjBgkqhkiG9w0BCQQxFgQUU0Bs1GFXXrV03dertBwfNOQf4BMwDQYJKoZIhvcNAQEBBQAEgYCpuVu4RuXvzJPrn1qRi2vwNqcCqiF2I7MA94GSgPRDW4dUBH5sULBV/sPxvBBVWS30t0Q24BkC3hzwQKhuP20/jdmQCDPD7NCRhyHv/CKgvNFCWJiypSfFqjDTGHFRlpMGqR8Kxg/QtMakOW051eNVs3kTjLDvAFo75SmGXAbs2g==-----END PKCS7----- "> Buy me a beer :)<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!" stlye="margin:0;float:left;padding:0;position:relative;" align="left"> <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1"> </form> </div><div style="float:left"> | Need help? <a target="_blank" title="Follow me on twitter" href="http://twitter.com/designerfoo">Follow me on twitter</a><br/><br/><h4><a href="http://feeds.feedburner.com/Designerfoo" target="_blank">Subscribe to the RSS feed</a> or <a href="http://feedburner.google.com/fb/a/mailverify?uri=Designerfoo&loc=en_US" target="_blank">subscribe via Email</a>, to know what other updates/plugins/themes I am releasing</h4></div> </div> <?php }
private function mapFileInvoice() { $file = Input::file('file'); if ($file == null) { Session::flash('error', trans('texts.select_file')); return Redirect::to('company/import_export'); } $name = $file->getRealPath(); require_once app_path() . '/includes/parsecsv.lib.php'; $csv = new parseCSV(); $csv->heading = false; $csv->auto($name); Session::put('data', $csv->data); $headers = false; $hasHeaders = false; $mapped = array(); $columns = array('', Invoice::$fieldCodClient, Invoice::$fieldProduct, Invoice::$fieldAmount); if (count($csv->data) > 0) { $headers = $csv->data[0]; foreach ($headers as $title) { if (strpos(strtolower($title), 'name') > 0) { $hasHeaders = true; break; } } for ($i = 0; $i < count($headers); $i++) { $title = strtolower($headers[$i]); $mapped[$i] = ''; if ($hasHeaders) { $map = array('cod_client' => Invoice::$fieldCodClient, 'product' => Invoice::$fieldProduct, 'amount' => Invoice::$fieldAmount); foreach ($map as $search => $column) { foreach (explode("|", $search) as $string) { if (strpos($title, 'sec') === 0) { continue; } if (strpos($title, $string) !== false) { $mapped[$i] = $column; break 2; } } } } } } $data = array('data' => $csv->data, 'headers' => $headers, 'hasHeaders' => $hasHeaders, 'columns' => $columns, 'mapped' => $mapped); $data['branches'] = Branch::where('account_id', '=', Auth::user()->account_id)->orderBy('id')->get(); return View::make('accounts.import_map_invoice', $data); }
<?php include_once '../../../_includes/framework.php'; require_once '_includes/vendor/parsecsv.lib.php'; require_admin(); $csv = new parseCSV(); $csv->auto($_FILES['file']['tmp_name']); $forms = []; $errors = []; try { db_start_transaction(); foreach ($csv->data as $line_number => $row) { $line_number++; $form = new CSVImportAttendeeForm($row); $forms[] = $form; if (!$form->valid()) { $errors[$line_number] = $form; } else { $form->save(); } } if (empty($errors)) { db_commit_transaction(); } else { db_rollback_transaction(); } } catch (Exception $e) { db_rollback_transaction(); throw $e; } if (empty($errors)) {
function download() { App::import("Vendor", "parsecsv"); $csv = new parseCSV(); $filepath = "C:\\Users\\Administrator\\Downloads" . "german_listings.csv"; $csv->auto($filepath); $this->set('german_listings', $this->GermanListing->find('all')); $this->layout = null; $this->autoLayout = false; Configure::write('debug', '0'); }
private function mapFile() { $file = Input::file('file'); if ($file == null) { Session::flash('error', trans('texts.select_file')); return Redirect::to('company/import_export'); } $name = $file->getRealPath(); require_once app_path() . '/includes/parsecsv.lib.php'; $csv = new parseCSV(); $csv->heading = false; $csv->auto($name); if (count($csv->data) + Client::scope()->count() > Auth::user()->getMaxNumClients()) { $message = trans('texts.limit_clients', ['count' => Auth::user()->getMaxNumClients()]); Session::flash('error', $message); return Redirect::to('company/import_export'); } Session::put('data', $csv->data); $headers = false; $hasHeaders = false; $mapped = array(); $columns = array('', Client::$fieldName, Client::$fieldPhone, Client::$fieldAddress1, Client::$fieldAddress2, Client::$fieldCity, Client::$fieldState, Client::$fieldPostalCode, Client::$fieldCountry, Client::$fieldNotes, Contact::$fieldFirstName, Contact::$fieldLastName, Contact::$fieldPhone, Contact::$fieldEmail); if (count($csv->data) > 0) { $headers = $csv->data[0]; foreach ($headers as $title) { if (strpos(strtolower($title), 'name') > 0) { $hasHeaders = true; break; } } for ($i = 0; $i < count($headers); $i++) { $title = strtolower($headers[$i]); $mapped[$i] = ''; if ($hasHeaders) { $map = array('first' => Contact::$fieldFirstName, 'last' => Contact::$fieldLastName, 'email' => Contact::$fieldEmail, 'mobile' => Contact::$fieldPhone, 'phone' => Client::$fieldPhone, 'name|organization' => Client::$fieldName, 'street|address|address1' => Client::$fieldAddress1, 'street2|address2' => Client::$fieldAddress2, 'city' => Client::$fieldCity, 'state|province' => Client::$fieldState, 'zip|postal|code' => Client::$fieldPostalCode, 'country' => Client::$fieldCountry, 'note' => Client::$fieldNotes); foreach ($map as $search => $column) { foreach (explode("|", $search) as $string) { if (strpos($title, 'sec') === 0) { continue; } if (strpos($title, $string) !== false) { $mapped[$i] = $column; break 2; } } } } } } $data = array('data' => $csv->data, 'headers' => $headers, 'hasHeaders' => $hasHeaders, 'columns' => $columns, 'mapped' => $mapped); return View::make('accounts.import_map', $data); }
<?php require_once '/lib/csv/parsecsv.lib.php'; require_once '/config.php'; $file = "one"; #file name of csv # create new parseCSV object. $csv = new parseCSV(); #Parse '_books.csv' using automatic delimiter detection... $csv->auto('./uploads/' . $file . '.csv'); //print_r($csv->data); $parent = basename(dirname($_SERVER['PHP_SELF'])); $mysql = mysqli_connect(DBHOST, DBUSER, DBPASSWORD); mysqli_select_db($mysql, DBNAME); $result = mysqli_query($mysql, "Truncate table mailinglist"); $result = mysqli_query($mysql, "\n\t LOAD DATA INFILE '" . UPLOADS . $file . ".csv' INTO TABLE mailinglist FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (email)\n\t"); // LOAD DATA INFILE 'C://xampp//htdocs//DEMLa//uploads//one.csv' INTO TABLE mailinglist FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' (email) header('Content-Type: application/json'); if (!$result) { $error = mysqli_error($mysql); $data2 = array('dbload' => 'failed', 'error' => $error); echo json_encode($data2); } else { $result = mysqli_query($mysql, "SELECT * FROM mailinglist"); // Return the number of rows in result set $rowcount = mysqli_num_rows($result); $data2 = array('dbload' => 'success', 'indb' => $rowcount, 'incsv' => count($csv->data) + 1); echo json_encode($data2); } mysqli_close($mysql);
private function __importMultilanguage() { // Get the ID of the field which values should be imported: $fieldID = $_REQUEST['multilanguage-field-import']; // Get the nodes provided by this CSV file: $csv = new parseCSV(); $csv->auto($_FILES['csv-file-ml']['tmp_name']); // Get the CSV Data: $csvData = $csv->data; // Get the languages: $supported_language_codes = $this->__getLanguages(); // Itterate throught each row: $count = 0; foreach ($csvData as $row) { if (isset($row['entry_id'])) { $data = array(); $first = true; // Itterate according to the languages that are available, not the ones that are defined in the CSV: foreach ($supported_language_codes as $code) { // Check if this language code exists in the CSV data: if (isset($row[$code])) { // The first language in the CSV data is used as the default language: if ($first) { $data['handle'] = General::createHandle($row[$code]); $data['value'] = General::sanitize($row[$code]); } // Store the value for this specific language: $data['handle-' . $code] = General::createHandle($row[$code]); $data['value-' . $code] = $row[$code]; $data['value_format-' . $code] = $row[$code]; $data['word_count-' . $code] = substr_count($row[$code], ' ') + 1; $first = false; } } // Update the data in the database: Symphony::Database()->update($data, 'tbl_entries_data_' . $fieldID, '`entry_id` = ' . trim($row['entry_id'])); $count++; } } // Show the message that the import was successfull. $this->Form->appendChild(new XMLElement('p', __('Import successfull: ') . $count . ' ' . __('entries updated'))); $p = new XMLElement('p'); $p->appendChild(new XMLElement('a', __('Import another field'), array('href' => '?#multi'))); $this->Form->appendChild($p); }
return $hashMap; } function hkey($title) { return strtolower($title); } if (isset($_POST["source"])) { $source = $_POST["source"]; } $fileName = upload($source); echo $fileName . "<br/>"; echo $source . "<br/>"; if ($fileName != null) { $db = new MongoHQ(array('collectionName' => 'watched')); $csv = new parseCSV($fileName); $csv->auto(); $data = $csv->data; //print_r($data); if ($source == "imdb") { $movies = IMDB::buildMovies($data); var_dump(Movie::toMoviesDB($movies)); $db->saveMany(Movie::toMoviesDB($movies)); } else { if ($source == "google") { $hashMap = buildHash($data); $db_movies = $db->find(); $mismatched = array(); foreach (Movie::toMovies($db_movies) as $movie) { $title = $movie->TITLE; //echo "<br/><div>[" . $$movie->POSITION . "] processing movie title: " . $title . " [db/rotten]</div>"; if (isset($hashMap[hkey($title)])) {
/** * Process a step * * @since 2.6 * @return bool */ public function process_step() { $more = false; if (!$this->can_import()) { wp_die(__('You do not have permission to import data.', 'edd'), __('Error', 'edd'), array('response' => 403)); } $csv = new parseCSV(); $csv->auto($this->file); if ($csv->data) { $i = 0; $more = true; foreach ($csv->data as $key => $row) { // Done with this batch if ($i >= 19) { break; } // Import Download $args = array('post_type' => 'download', 'post_title' => '', 'post_name' => '', 'post_status' => '', 'post_author' => '', 'post_date' => '', 'post_content' => '', 'post_excerpt' => ''); foreach ($args as $key => $field) { if (!empty($this->field_mapping[$key]) && !empty($row[$this->field_mapping[$key]])) { $args[$key] = $row[$this->field_mapping[$key]]; } } $download_id = wp_insert_post($args); // setup categories if (!empty($row[$this->field_mapping['categories']])) { $categories = $this->str_to_array($row[$this->field_mapping['categories']]); if (!empty($categories)) { wp_set_object_terms($download_id, $terms, 'download_category'); } } // setup tags if (!empty($row[$this->field_mapping['tags']])) { $tags = $this->str_to_array($row[$this->field_mapping['tags']]); if (!empty($tags)) { wp_set_object_terms($download_id, $terms, 'download_tag'); } } // setup price(s) if (!empty($row[$this->field_mapping['price']])) { $price = $row[$this->field_mapping['price']]; if (is_numeric($price)) { update_post_meta($download_id, 'edd_price', edd_sanitize_amount($price)); } else { $prices = $this->str_to_array($price); if (!empty($prices)) { $variable_prices = array(); foreach ($prices as $price) { // See if this matches the EDD Download export for variable prices if (false !== strpos($price, ':')) { $price = array_map('trim', explode(':', $price)); $variable_prices[] = array('name' => $price[0], 'amount' => $price[1]); } } update_post_meta($download_id, 'edd_variable_prices', $variable_prices); } } } // setup files // setup other metadata // Once download is imported, remove row unset($csv->data[$key]); $i++; } $csv->save(); } return $more; }
<?php # include parseCSV class. require_once '../parsecsv.lib.php'; # create new parseCSV object. $csv = new parseCSV(); # Parse '_books.csv' using automatic delimiter detection... $csv->auto('_books.csv'); # ...or if you know the delimiter, set the delimiter character # if its not the default comma... // $csv->delimiter = "\t"; # tab delimited # ...and then use the parse() function. // $csv->parse('_books.csv'); # now we have data in $csv->data, at which point we can modify # it to our hearts content, like removing the last item... array_pop($csv->data); # then we output the file to the browser as a downloadable file... $csv->output('books.csv'); # ...when the first parameter is given and is not null, the # output method will itself send the correct headers and the # data to download the output as a CSV file. if it's not set # or is set to null, output will only return the generated CSV # output data, and will not output to the browser itself.
public function updateProductByDatafeed($debug = false) { $rowCount = 0; $sessionRotation = 10; if (!file_exists(self::DATAFEED_DIR)) { mkdir(self::DATAFEED_DIR, 0777, true); } $files = scandir(self::DATAFEED_DIR); foreach ($files as $file) { if ($file === '.' || $file === '..') { continue; } $path = self::DATAFEED_DIR . DIRECTORY_SEPARATOR . $file; $ext = pathinfo($path, PATHINFO_EXTENSION); if ($ext === '') { continue; } if ($ext == 'csv') { $csv = new parseCSV(); $csv->auto($path); $data = $csv->data; if ($debug === true) { echo 'get ' . count($data) . ' data from ' . $path . PHP_EOL; } foreach ($data as $row) { if ($rowCount === 0 || $rowCount % $sessionRotation == 0) { $connector = CatelogConnector::getConnector(B2BConnector::CONNECTOR_TYPE_CATELOG, SystemSettings::getSettings(SystemSettings::TYPE_B2B_SOAP_WSDL), SystemSettings::getSettings(SystemSettings::TYPE_B2B_SOAP_USER), SystemSettings::getSettings(SystemSettings::TYPE_B2B_SOAP_KEY), true); } if (!isset($row["sku"]) || !isset($row["price"]) || !isset($row["all_ln_stock"])) { if ($debug === true) { echo '***warining***' . 'invalid row deteched' . PHP_EOL; } continue; } $sku = trim($row["sku"]); $price = doubleval(trim($row["price"])); if ($price === doubleval(0)) { if ($debug === true) { echo '***warining***' . 'invalid price deteched' . PHP_EOL; } continue; } $stockLevel = trim($row["all_ln_stock"]); $stockLevelNo = self::mageStockNameToValue($stockLevel); if ($debug === true) { echo $rowCount . ': sku "' . $sku . '", price "' . $price . '", stockLevel "' . $stockLevel . '"[' . $stockLevelNo . ']' . PHP_EOL; } $param = array('price' => $price, 'status' => '1', 'additional_attributes' => array('single_data' => array(array('key' => 'all_ln_stock', 'value' => $stockLevelNo)))); $connector->updateProductInfo($sku, $param); if ($rowCount === 0 || $rowCount % $sessionRotation == 0) { if ($debug === true) { echo 'session => ' . $connector->_session . PHP_EOL; } } $rowCount++; } } } }