Wednesday, April 13, 2016

Sending data to controller via Jquery post method

Controller: ViewTest.php
==================

<?php defined('SYSPATH') or die('No direct script access.');
class Controller_ViewTest extends Controller {

public function action_index()
{
$this->response->body(View::factory('viewTestView'));
}

public function action_processPostData(){
// echo will send the value of division back to viewTestView
echo $this->request->post('division');
}
}

View file: viewTestView.php
=====================
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>

<div class="container">
<?php
$selection = array('dhaka' =>'Dhaka', 'chittagong' => 'Chittagong', 'khulna' => 'Khulna', 'rajshahi' => 'Rajshahi', 'rangpur' => 'Rangpur', 'barisal' => 'Barisal');
$selected=array();
$attributes=array('class'=>'selectpicker', 'data-live-search'=>'true');
echo form::select('input_dropdown',$selection);

?>

<div id="x">Je suis desole></div>

</div>
<script>
$('select[name=input_dropdown]').change(function(){
// alert('hh');
var u='http://localhost/project/ViewTest/processPostData';
var division=$(this).val();
// alert(division);
$.post(u,
{division:division},
function(data,status){
$('#x').html(data + "-"+status)
});
});

// $.post(u,{
// bid:bid,
// reason:deny_reason
// },
// function(data, status){
// location.reload();
// });

</script>
</body>
</html>

Sunday, April 10, 2016

Using JQuery post method to update table.

Controller:
=======
<?php defined('SYSPATH') or die('No direct script access.');
class Controller_moderate extends Controller {

public function Action_getEvents()
{

    $allEvents = DB::select('idevnt','event_name','event_dtls','status')->from('t_event')
    ->where('status','=',0)->execute();
    $this->response->body(View::factory('moderatorView')
       ->bind('data',$allEvents));
}

public function Action_approve()
{

    $eventid=$_POST['uid'];
    $query = DB::update('t_event')->set(array('status' => 1))->where('idevnt', '=', $eventid)->execute();

}

public function Action_deny()
{
    $eventid=$_POST['uid'];
    $query = DB::update('t_event')->set(array('status' => 2))->where('idevnt', '=', $eventid)->execute();
}

}

View: moderatorView.php
==================
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
    
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>

<div class="container">
<table id="mt" class="table table-responsive table-striped">
<?php
$i = 0;
$firstRow=$data[0];
?>
<thead>
<?php
foreach($firstRow as $key => $value):
    echo "<th>". $key . "</th>";
endforeach;
?>
</thead>


<?php
foreach($data as $point):
echo "<tr>";

$id= $point['idevnt'];
$event_name=$point['event_name'];
$event_dtls=$point['event_dtls'];
$status=$point['status'];

echo "<td>". $id . "</td>";
echo "<td>". $event_name . "</td>";
echo "<td>". $event_dtls . "</td>";
echo "<td>". $status . "</td>";

echo "<td>". Form::submit("approve$id",'Approve', array('class'=>'btn btn-primary approve','data-id'=>$id, 'id' => $id )) . "</td>";
echo "<td>". Form::submit("deny$id",'Deny', array('class'=>'btn btn-danger deny', 'id' => $id )) . "</td>";
echo "</tr>";
endforeach; ?>
</table>

<div class="jumbotron">
    Lorem ipsum dolor sit amet, consectetur adipisicing elit. Totam explicabo suscipit quod porro saepe rerum repellendus, ipsam quas facere, magnam in quis id eveniet vitae quos corporis, dolor tempora deserunt.

</div>

</div>
<script>
    $('.approve').click(function(){
        var uid=$(this).attr('id');
        var u="http://localhost/kohana/moderate/approve";
        $.post(u,{uid: uid}, function(data, status){
        location.reload();

    });
        });


    $('.deny').click(function(){
        var uid=$(this).attr('id');
        var u="http://localhost/kohana/moderate/deny";
        $.post(u,{uid: uid}, function(data, status){
        location.reload();

    });
        });
</script>

</body>
</html>

table schema:
=========

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `t_event` (
`idevnt` int(10) NOT NULL,
`event_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`event_dtls` longtext NOT NULL,
`id_cat_id` int(10) NOT NULL,
`id_ucid` int(10) NOT NULL,
`event_location` longtext NOT NULL,
`event_date_time` varchar(30) NOT NULL,
`end_date_time` varchar(30) NOT NULL,
`special_deals` longtext NOT NULL,
`org_name` varchar(256) NOT NULL,
`org_image` longtext NOT NULL,
`event_lat` double NOT NULL,
`event_lng` double NOT NULL,
`is_open` varchar(256) NOT NULL,
`is_del` int(1) NOT NULL,
`contact_dtls` longtext NOT NULL,
`rel_event` int(10) NOT NULL,
`evnt_sponsor` varchar(256) NOT NULL,
`status` int(1) NOT NULL DEFAULT '1',
`deny_reason` varchar(256) NOT NULL,
`create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`up_date` datetime NOT NULL,
`del_date` datetime NOT NULL,
`is_free` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=533 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `t_event`
--

INSERT INTO `t_event` (`idevnt`, `event_name`, `event_dtls`, `id_cat_id`, `id_ucid`, `event_location`, `event_date_time`, `end_date_time`, `special_deals`, `org_name`, `org_image`, `event_lat`, `event_lng`, `is_open`, `is_del`, `contact_dtls`, `rel_event`, `evnt_sponsor`, `status`, `deny_reason`, `create_date`, `up_date`, `del_date`, `is_free`) VALUES
(1, 'admin1', 'info@ebssbd1.com', 1, 0, '1', '2016-12-03 00:12:00', '2016-12-03 20:12:00', '01829616787', '', '', 0, 0, '0', 0, 'dsfs', 1, 'No', 0, '', '2015-12-02 20:03:09', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(4, 'Pitha Party', 'It's a pitha party where everyone has to come with one meal.', 7, 0, 'Ocean Tower, Uttor Badda, Dhaka', '0000-00-00 00:00:00', '0000-00-00', 'Come and have pithas free', '', '', 0, 0, '0', 0, 'Ocean Tower, 5th Floor', 0, 'No', 1, '', '2016-01-04 10:01:06', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(5, 'Pitha Party', 'It's a pitha party where everyone has to come with one meal.', 7, 0, 'Ocean Tower, Uttor Badda, Dhaka', '0000-00-00 00:00:00', '0000-00-00', 'Come and have pithas free', '', '', 0, 0, '0', 0, 'Ocean Tower, 5th Floor', 0, 'No', 1, '', '2016-01-04 10:02:20', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(6, 'Pitha Party', 'It's a pitha party where everyone has to come with one meal.', 7, 0, 'Ocean Tower, Uttor Badda, Dhaka', '0000-00-00 00:00:00', '0000-00-00', 'Come and have pithas free', '', '', 0, 0, '0', 0, 'Ocean Tower, 5th Floor', 0, 'No', 1, '', '2016-01-04 10:06:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(7, '', '', 0, 0, '', '0000-00-00 00:00:00', '0000-00-00', '', '', '', 0, 0, '0', 0, '', 0, 'No', 1, '', '2016-01-04 10:08:30', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(8, 'Pitha Party', 'It's a pitha party where everyone has to come with one meal.', 7, 0, 'Ocean Tower, Uttor Badda, Dhaka', '0000-00-00 00:00:00', '0000-00-00', 'Come and have pithas free', '', '', 0, 0, '0', 0, 'Ocean Tower, 5th Floor', 0, 'No', 1, '', '2016-01-04 10:13:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(9, 'Pitha Party', 'It's a party where everyone has to come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Come and enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:18:25', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(10, 'Pitha Party', '', 7, 0, 'Ocean Tower, Uttor Badda', '2016-02-25 11:41:00', '2016-02-27 11:41:00', 'Come and enjoy free pitha', '', '(null)', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:19:30', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(11, 'Pitha Party', 'It's a party where everyone has to come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Come and enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:21:01', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(12, 'Pitha Party', 'Come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:27:31', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(13, 'Pitha Party', 'Come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:30:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(14, '', '', 0, 0, '', '2016-01-04 04:36:17', '0000-00-00', '', '', '', 0, 0, '0', 0, '', 0, 'No', 1, '', '2016-01-04 10:36:17', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(15, 'Pitha Party', 'Come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:38:11', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(16, 'Pitha Party', 'Come with one pitha menu', 7, 0, 'Ocean Tower, Uttor Badda', '0000-00-00 00:00:00', '0000-00-00', 'Enjoy free pitha', '', '', 0, 0, '0', 0, 'Uttor Badda', 0, 'No', 1, '', '2016-01-04 10:42:08', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(17, 'One Dish Party', 'Come with one dish', 1, 0, 'Dhaka, Dhaka Division, Bangladesh', '0000-00-00 00:00:00', '0000-00-00', 'No', '', '', 0, 0, '0', 0, 'Badda Dhaka', 0, 'No', 1, '', '2016-01-04 10:45:36', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(26, 'test', '', 1, 0, 'dhaka', '2016-01-10 10:29:00', '0000-00-00', '', '', '', 0, 0, 'O', 0, '', 0, 'No', 1, '', '2016-01-10 09:25:36', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(31, 'party', 'Event Details', 1, 11, 'Uttar Badda, Dhaka, Bangladesh', '0000-02-09 10:37:59', '', 'Cv bbbb', 'windmill', '/9j/4AAQSkZJRgABAQEASABIAAD/4QBYRXhpZgAATU0AKgAAAAgAAgESAAMAAAABAAEAAIdpAAQAAAABAAAAJgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABLKADAAQAAAABAAABLAAAAAD/7QA4UGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAAA4QklNBCUAAAAAABDUHYzZjwCyBOmACZjs EJ /8AAEQgBLAEsAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5 v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5 jp6vLz9PX29/j5 v/bAEMAHBwcHBwcMBwcMEQwMDBEXERERERcdFxcXFxcdIx0dHR0dHSMjIyMjIyMjKioqKioqMTExMTE3Nzc3Nzc3Nzc3P/bAEMBIiQkODQ4YDQ0YOacgJzm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5v/dAAQAE//aAAwDAQACEQMRAD8A6SiiigAooooAQ8jFVWG3g1bqGQUAVlI3j61dqlkKwNXevShgJTAKfTakYUUwsM4zz6UuaQxacvSmUq9aAKN2zK/B6Yq0jb0DeoqtejkH1H8qdatuix6U2PoTSjK/UVDZnt FWDyv0qpD8spHvQiS1P1BrPl 9WlOPlB96zpuxqJlRITSUtJWRqRt1q/Cfkqgx9KuW5yvNVHcmRaFSCohUgNamY8UopopwpiHUuOKbmjNMRBB/rCParlUYT x9avUkNhWZckiXAPB61p1mXQPm0pDjuVgBnin0hUg80pzWTNRppKU0Uij//Q6SiiigAooooAKawyMUtQFjnigRWcYpEmaP5eoqwy/KWP4VSNUI0UdXGVpTWbHIY3z271o9eRUNFJkDIBLv7kYp4PNKwzQDkVJQtAPNJSZoAiuxwp oqtZNyy1auuYs hFULdtlx9f60x9DXVc5BpwjQHIHNA61JTRBDMP3dZ033M1qOMoR7VnSDKGpmVEp0lFJWBsIasW5qsTUkLbTTW4NaGhmnjJFRRMGOG4PamTTf8s89fStbmfKyyDTxmq6yoifPx6VXkvQTtjp3JszQYhfvGmGRUTexwBWUJsEmU4z0pJpvOjCKCBmi43EngnL3a7eFOa2qwLTiZAFPXrW/TRLCqcv8Arx7irlUpjidT7US2HEHxiqjnLmpnbPQ1C/3jWTNEMaikajFSUf/R6SiiigAooooAa3Q1WPXjrVo8iqbU0Sx0r5Qe9U2qZjkVA1MQw1fgbdEM9uKzz1q3bsBGc tKQ0WajJ2n2NRPN6VTe4Qdyx9qixZpB1BxnrTM1jmdm56VohjgUMESTHMLD2rM3YdWrRY5Uj1rLAJUHsKEUjoNw4NTVnJIPLXNXY2yKEyWSVnuOCKukqDkmqj/AHyPeiQIzKvx2aSIGLHkZqg3DEVqRuRGpBwMVlBXNJNrYT7BF3LU5bKFfX86ha8RYy27p dZUmpXG/IOB6VpyonmkdALaIetJ9lh9P1rLt9Qkmbyn4J6EVsDgYoshXfcj y256rn65pRbwDogp9JTsK7Kf7pHbbHufPpx7c1aiiVUAIGetOpKVgI5yqlQMZzVkHNZs3En41fTpQBJWZe/eU1pVm338NEthx3Kq4p9QpUuayNgNLTT1p9ID//0ukooooAKKKKAEPSqr1bqo/BIpomRD7VA1WO9V261RJEacJdkbKOpxTWqMnBzSGROWf7xzSKcA4pCQBzSKkj8qMD1NIZAvJ21qRPmMetZ5EKHJO9vbpR9obGAAv0qZK5SZqbqpQwyzllTgZ69qgink8wAng8VZ86aByYuh7UtirmqlsqR7SSfen79o2rwBVWOaWcYxTZQ6oSeopCJ2kQjGc0rHJzWfaDPBrRbgCkMy5hiU1ciJeARryxBFVbrhwau6eBsY980o7lvYxrlWWTyup6cVYGnYTe7fN6UkQ8y8LvwEJzn68VpSSRpwx61TYtznQWhnBHVTXXKSQM9a5i9jG9ZV6NxXSRDKq3bbTTJZLSUA5x70jsEUu3QUxEcsqxLuY4rIbVH3DaoA96pXVy075PA7CqpPNAG4bqOfleD6VsJXFqxUhh1FdVZTrcR7h1HBFIZerNvxwprSqjfY8sE0nsEdzNXpT/AEqEyoq9c1CLoZ5HFZ2ZrdF09aXNQh1blTmn1Iz/0 kooppYL1oAdRTA6mnUALVaYc1ZqCamhS2KhNREck1NtJBI6CopMDj8aogrtUB5OalY1ATQAbwg4XJ9TULM8nLnint0pjfKo96RSI22gfLzUe4VZFpKy7zxmoZoHi56ilcdhgbDA lXy3OfWs2rStlRUsaNe1YBx7irMq5BHqKzbdsEH0rQuH2Rl/apGZ0UiQ8yHFaRIeMMpyPWubJeVuOSantZ5LeTyZMhW4wexosMu3Q UH3qWxfCyAexplzzEfao7BsSsPValbldCwtuZI3DfKS5Jp8sMTOFf0xTpHJJ29Dg8VVbI YDOfU0McdiO7jX5UXoDWjb31s6KC4U46HisS7chQAeSazx71cFcmR2BuIC4AdT NVNVlEcAQHlj lc7wKR3Z8DJOOBVtEkkMTTPtHTvWu9pCUwFwfWmW0Xkpg9TzTpZ1jO3v39qycjRRMua3aNsdR1ratX8lvm 7jBNV4CZA0jDrx FPztXbjg8fhScgsbZdVQux UDOa5u7uTO5JOFHQVYmmYwrZqPp9BU8FgkYDScmquTymNtzy34Uxj2rengjcdKwZVMTlTQmDQqOUbIrRVwwBHesfdUyuwHBxSlG41Kx//1OkqvJwasVG/HzdaAZVzS7yKkkQD7vX0qtg9 KognE5AwakkyYwTVM4FTb2kUgjAHegBY8BGY/SqUnXirDjCbR16mqzAFNwPfmgGVn9KjNPcYNR1RIw8g0LhmQkZ7UMaltiN2T/CQallxL ePSqNwyEmPOSRUtxbyNKWHSmtAiybj6ZrI1Mggjg1IjcU2Q5Y0wMR0rQzNCB cVevGLWwI/GsaFsSZNa0bhwqHseah6FLUktoxHEOOTzVa8RJCBn5qmljmV87ief0qFrc aWY 9Rc1aXQcX82DOOoqCzbE6 RVQTsjkKcr6GiNz5ilTgg5p2JRr39wbfZHGBzyfpVY3cLLuUHdjpVC5m8 UyH/OKrfWrcbkp2JZHLtk0wdae6qr4TJXqCah9apaAx5PFKDg59KYaCeKYjdWVNgcng9Kq7PMck8574qlFlgFOSBWvB 5jIfp1rBqxqncepWNMUyRgFzVYkytxx3ptwSowT1qbFF62VWuwx7JmtM1j2j7XMgGSFxV3zTKh7euKdybDzKmSo5 lVZ4UnX37VXLyBCYwODjFXYVkKZkouNo5t1MbFT2pQeKu3yZkDDvVCtE7ozaP/9XpKaagMyj3NV3lLHnp6UAWXlQDPU0hnHGOhqiWHpTc lMlmiTGwyyipAiYBHpWasuOCauTy7YNy/xdKARUlkUMQDketVxIoBHY1GW9aaI2k5HSmLcfKAEVgcg/pUGD25qZMwuFY8Gpd TRzFKF1cosrehqSKNo8zMOFq4WEahsbmY4UVVnYKT9pfe3ZB0Bo3C1h7zMYgx5yKpszk5Jpm8hAG4z0pPMZht7d6ixVydDcMmFjRgOOQM1HNEQMvF5ZPQjoahmhkVRMRw36UkEjBvKJyr8Y/kaokSCN5ZAiDk1dDGO5CR/MD8pqRP3Nq8o4Zvl nrVeyG 8jB9c/lUvUtLqbc3XGe1Z0u9MknOa0irFyw4qndphBnpuAP41LRSZgHg0mSCCKsTxlGKntVbrxVIT0HsM8 tM7VbitzNkZwAMkmriafEsm12LDGfStJaBysylVm VQWI9KjIKnDDB966yBYoz5cSgcVn6lDvXzAOV/lWSmJxMOjvSdqKskeHKnKnBq558nlhZVI9D61DaIryjecAVelVpQ0aEyA9B1IIocb7mkU9yKF1Pfp1qtPNvkyOgpDBOnLxsPqDVdgQcGoUQcjTsnZpCqdSMVq2sLq0juSQemax9MYC7TPuP0roZmk2nyxUtWGncjWCLdkVI3AxUKBlXdIcsad15qSjOux8uaxzwcVr3zAREVjVcNiJH//Wus3amFhTGaoyaYh5am76lVARk1GYxmi4WLdtEk43Menai92oEjXgDNQ2j XcBM8NxRqB/fAe1AFaNfMfHYVZaRUG0dqrWx/eH6VadEzupMaRTuGBAI6jmnLkjce9F2qFS6mpbZfNjUnoOv4UuhUd9RxJEkRHUIxH15rFJz9a2JZAXjkUbQrbT9DWaECXIR itirREtzWaFPKWNxkAY/Gq8dlEHG5iR71YmnWJQzDOTiopJuB5Y3KRnPpipAtS XgxtyD7VzUi XIVHODV2S6kO5Acq2MZ7VXdDJITwM0wLUj5tdg6CQ023SaGVLjGAGx BpwAeAs3Zxk1dckjbEfm6AZqGzRbF0S8kelQSq8yMq9TjH1zVlVwCD1of5SDQSUriwlm5GAfesW4tLi2IaVfl9RyK6ok5znNQ3Ui SVcA57GmmDbMW0nCbhjPGfyqUzqCHzxt71NGAwJZRtAOeMVTjs5pmWOI/IVBJPQVUnctTJLe4Z7sY6YIrRlOQc89aIrGGCPzFyz8jJq6lsgAL5JrJx1shcxxxgmAz5bY hqIKxbaBye1d9tUDiq00ULjzSo3qMg1pcgwI4vstuXbBYnp6VHa3iwTguMjPX0Bpsk4nXPQDtUNvb/aJSoOAOSaleZo yOulYeUWzkVy99Hu/0gHvtq1I0kC ShJUDvVYuGsWXjIYUk9RNWM9HaNg6HBByK6pZGmiV1OFYZzXJ1s6ZdCMGGU4U9CackEWWxEHPJJqYnYMUjXMKg4IrNlnaThehrKxruVrubzG2joKq4p7j5selNzWy2Mpbn//13kHG7tTUwx5PFTEH7o7HBpEXDlO1Fx2HmRUHHNM80N2xiiSMbs0zyiw2qcnqTSGMLjzFYHpzTGkMjljTGGADVfcelUiGWIJQj896t7i3KmsqnrMyHik0NMsSvtO0jr2qzYvmN4/9k1lvI0jbm61esiQ3C8HIJ tFtAT1Htho3jHU9KinikdxKPQZ oo3FJefpUxkylK9imkyKY ZEFPByKtSYRNgOABgLUSRvNgL14NWpdkeQ5yT2pMSKkNitwFl5RcY57/AErTihiiG1FGTxmoIJnb5NvA7iq9xM7MyKcAelMRYmhiMUkSYDMOcdM1n21z5F0FuD8oBXPv61Ytmy7Bum2k zROxdhkmpbSLjFs1MqxJQgg9CKRuUPqKroPKXAG32xSb2J Y0uYfJrYguNSiiysI3P0yeAKhhuvNi3S4LCpGtoN28rkmmfYkA3rkj 7T6EW1CSf90WHO4YArSs1AtYwO45qoEkG3bwPyokkuoDi2TI6njiiI2acex1KgHg55qbNZ0F1LNGWdNpBwQKl89zwq02SWuT9Kw9R1CMIbe3OSeGI6AUapIwhVMkFj0HpTNO05XUXFwMg/dX ppoDKgtLifmJTj16CtSK2ezicPgsRniuhCgDArF1K4WNtkZ fv7UnqNMozSoJA7cgr2rOJ5J6ZoJphNNKw27i5GMUZpuaKZIucU4SMvQ1HSUWHclLAjjrTabTgaAP//QnVj5j46ZpSCrk opxIAzjGeTVd519aTKJJG4pizeUAMZHrULSK4xmmvt6CkMZM2Rxxmquac7c49Kjq0Zsdmm5pM0maYh1XbJ8S7D0b dUc1JEJDIPKBZgcjFDA1LxOC/p/Wo4xGU3Oa1ZLVp15O3I5qEaWgGC5OPapZSY61liZWjjIUjpnvS/Z0Y7pDux2FZs0TWUodjlhyMdMVqGVApzweuKlhcJHCrgDA7AVnrHJIxbbjJ78VoG9tYwD1bHQDmqLXoZ8xoASercmhLqMkgjKO6t94cYqePCSYqFH8x938Zqf7LI7CT7pFJ6mkdE7j5SSQTUJHPFXZoWkXAxkHNUmZ0bDcGk0TF2Vinc3SxNsUbiB FNt2dh50p5z AFRSoXbPXHWrcS71Kih9ikr6svqcjNLmmptRQgHAp5YBSfSt4xsrHHJ3ZSknZLghTgEYPvVjcxFZEzFpDjt3pVnutu0AfWsJ3vodahdImu2BcDrgVsRgMqup4x0rnWDJl5DuZqs6dcS72t25AGQO/0oiE3okWb24eMbg2CfujuPesBjuO4nOat3s3nTFh0HAqixxVpGY0k000ZpKYC0lFJTAKKKKADFLRRSA//9GCaYufaqxJpze9NCu33RTAbk0CRhVlbSVuvFK1kw70rodmU2yD9aYanaMp8rVCRimiWhuauW1pJcfN91fWoreNZZQrHCjk/QVrvc7PlUfSk2NIkS2gt1yACfU9as2rRRnYgADdxVHzTIPQikTO7K8E9v8ACouy7G8Dmo2kwwRBknr7CooPN3M0gwvbPWs 5vo49yW3LN1aqWpDEv5EmnEY52D9aVlDhd3XFUIULfMa34YlEalhk4psSMRoZU4VSw9aiiiMkwiUfN/L610THsKr20aJcSY 8cUityxBbxwDjlj1NWAaKKBEEkpU7VGSKzZ5S5w/UVZuFfzSyNgY5x61T8oqu9zzQwDYFUnrmlgYxkGp44zLwOlXFt4l5PP1qLdTbmSViEuoP3arzykIT0ArTG3oAKxr3d5xT Hg/WtuY5uTUpopZgO9a0UCoo3jJpLa38sb3 8f0q6I88mkordlzm3pErNBBIMMg/DisW7hEMxKNyvQ10Mzqg2r1rnbr/WH60MiO9ig55wKjNOJ5NMpFjaKDTlQt0oAbSVYEDUwxNS5kVysioqURNnpTXXbTuKwwdKXNJRTEf/SrhAetXolVQMCqydatoOKhs0SJS9Ru2aOB1OKadvrUjKlwNyH2rOzWpM8aqQ3esnkGtIEyLkUUTwuSPmUZz7 lD8QoSeaqjJHNIB2NU0ZmrDd2Sj542z dWDqcKL 4j/PisMCpwo20gJZry4ueHbA9BwKiRaafQVJHzTEaNuuNuOmOa0hOocA9MVnW5/hqyRyD6Uhiy3WCVRce5qugkkYsCVxyWNTSRb R1pxjYxqBwMc/WkNMV7qRFwvzY6se9RC6lfKv0PpxUUy/LheRSRb9pCngetS5DSJIYTDuIbcrHPv NTSfPG2OwoibLbfzqFi54J4ouUo3JbM4V29Ksmb04HrVSKRUY7hwRzUskq4KxqDgcFulK1wcbFgyoq734qnE6XErSjqvQe3rVKeZ3H708joO1RWk2JB VXEzmjoY1zyaWWQRjA61X8xwODVK4nESl26/wA6uxF9LIZdXIhUnqx6VnyrttFkc5kZsn2FVXdpWLv1rd1CFXtN6jlQCPpUyZUUc6fakAJOBSZqeEc5pN2RpFXZJFb7ua0Y7YAc02EYqdpNvuaxbvub2tsQugHTioii1M25 vFNxikBFswKo3A5rTPSs 5B61UdyZbFKiiitzA//9MgGW5q2xAHNNVQrbvWh1DcGsmbFC4ZGPPPoBUMUeZNvIIq61sf4MfjTooQh9SadxWKL7jMFPQVVfO8565rcliQkMRVSS0Rt0mSCelUmS0ZtaNvpt1LhmAQf7XX8q0raK0tYw6/O57nr/8AWq/JIQhYU3JIgoJpMY5ZyT7CmzaY2C0TZ9jVhLjDYY4zV5DuGelKMkwsciFwxB4IqSBQzgHvUl3j7VJt9afbD94KskvpEqDAqyQq571GKtRxrjJpDGBeKCcdelWdq0uBQUZssCyHI/Sm7TjDcVam QgjoapTyfKdtQ0UtR7yJGML1NRHkZqvDExO Tr2q1sLdKRaVhgA25rOkWWQ4jyfpWvsVRzzTPMCjC/pTtbcl1FsjFa3lH3gfxpYbaeZsRqcdM9q3UZH/wBYPujPNXFZSo29Pancz3Ofka tMK GXsaoyvJK26Q5rrWVXUqwyDWFd2Lx5ki5X07iqTJcexl4roLC5jni zycsg6HuKwu1Qksj71JBHIIoGkXzYqrNvbGCRUqRoBgGqjvPcgSOc54z06VEqOrcn9azkrm0XY20QqKheRYyS3apYZQVANVrhdz57VmjQha9XsDUQu2z0pCkSn5uadut87duKvTsQ7k6yq1I2D1pojjcZjNShcDBqWUjOlh25ZelQVqSICp lZlaxdzKasf/9S0 VAz2pwwears24E5zRFJkEVkbEzygCqRmZAXB5NMmYhSRUCK/VqaBjjczuORkDrVzefKBHcVVIT7ufwpnmYOBzTZJahlUuGHFXkaSRCvPtWfDE0kvy9D19q3hAgXA4FZyi3sJsjhhKr6ntT5pvs1vvc/Njj3NJ5gtoy85x6Cufubh7mTe3AHAHpWkFZEMbGskrMRyeprSgi8sZPU021i8uPJ6tzVmrEOFTwn95iqLSYOB1rThTYi p5NMCeiikpDI5VBX6VnumQa0nOENUgecmk0VFkQwoG7r6Ubi/yjjNLMr YNoyD3qVY9vJpNdEZuV3qQlSq4X5qVYtvXpVjDH/Vrn3PAqJrWd/vuB7Ckqf8AMF30KtxIqRN5fUiqVnemPEU3TsatPatvw7gqOw702S3iYcqKJNbI0hHuaytuGRSM4AzWOly9pGVfLKOh/oapS3ctywC5CjtRcfKSXrwtJ 6AB74qgwzV3yYQhJJDdv8A69UzTQmrE8aSPbAKOjHNWbqKDyV8nBI6gdc pq1p65tz9TSmBix2jGaluzLSujOtt4IU5qaXrir0duEJY9cVTkQE8VD3uaIS2dIpN0i59O9Q3ke YtEOG5OatrDuXcODQwkPBFNSsJxuZsaurYPFaCqdvNTRwnq1SMMDFJu4baFM lZBHJrXbg1luPmP1qoETP/VzfMKHKmgTEHNMYVEabQJl8OG4z1qTbuXGcVlhiOlODPjrUcpfOWFAWTC8knArZWxJPNYELyLKGjPzDpWqNQuhwzAH1xQ43JubkUQiXsPWq1xqMEAIQ729B0/OsKaWab/AFku4enaqygn5RyaqwiaWeW4ffIee3tVu1ty53t0/nUtppzyfPLwtbKtbwlY1IyeBQBCIZD0GPrS/Z5BzxV6qzxzOOSPYUgM6WIxtuxjNa0ciMBtI6VGsReHZL1rJ aOXbVC2Nwui9SKjaWPOc9PSssSpnk/hTxOo 6pNBVi3JOGwuKj61VZiWJIxVmFS BSKtYliLtlR29asiMDk8mnKoUYFKaLkWDIFVLqYRqBnGanLEVj6o SqrzkVDkVFaiCYMcA5qXNV4IgkLZHzkgc9hUtQzQjkXNU2RI0LDjFXGYVnXTcY9acdWD0RW8x/WkL5qPNFb2RgdFprAW34mrTP6VlafJ 6ZfQ5/OrnmfvB6VhJ2djeK0LDAlN1Z8uUNXxIGU1XLRh8sallIiinAbY4xnpV7AqhOUkKhOTmrSSYO1vwoAlIwKrOQKsO3FUXOTSYIikqLah5IqVqjpoTP/WzWqI1ZIqIgVZJXIpKewphqRigndkcUuSetMHWngZNAxyjJrodNtw0fmMOM/nWTZW/wBqmEf8I5Y 1dcoCKAowB0FIDH1CZ0lWMcKBnimWSrLLz/DzVq6shcSbycUKFtU2RY3Dqaze5SNFRin1BFKH4bgip6tEhWPKMzHHY1qSuIo2kPYVzySM4bnnrTAnChWP1qZQKgjcuPmHNTKD3qbmyWgsgzg1ftk2pu9ao1qLhEAPGBTRM9rDicVHnPXpTyAeDUbrxxSkQhjZKkDr71nlSoLNww6Vfwc lRvErZyeT6VkykzMDyN8pBp 1wMkU RGhO6MljjvUqxvJjNLcq5nlXJrMnbLAeldO1usaGRjwBmuVb5ua1irEOVyKlpDkdaStCS9ZPiUr/eFW95VzWVGWVwyjkGtWZBIoYVlNa3NYPSxO4kxvFQHn3NMAmjYeYTs9R2rQjgaQArIpB5z3qLF3KSBx0FSO7bcGpXjjQlTKSQpPGO1Z7yPIcR5xjnPrTsFy5HKWGD1FITzUFupySakPWpaGDDioc1LI3GKqlqpENn/9egT2qNiBQWqLrzVki555phHcUtFIYzpTqSkBpAdVpUIjtRIfvSHP4dq1KrWuBbRj/ZFWKQypJNyEU5JbFQOoG5M9zTVfy2DYzjNRbsnJrJs0SJG 9n2q1aTyykqw4Udfest5Du56VbF1tgEafex1qoikhupXGcRJ0B5 tZ0Hc0SIW4zTkQIMCqILcPQ/WpSe1QRMMGgyVJrFqxNnirzB5oF8vvjNYxlz05NXrC5Gfs7nnqtUiJSuao44opaKZIwjNREMBhRViipcbjuUxAzNuerKoF6U6q1zdxWqbpDknoB1NCikDZR1a58uIQL1fr9K5unzTPPKZXOSajpiCmMAKdTiMjmgCMEgcHFaFrIzoVbnHes6rcbOq4Q8A5 tOSuiovU2A4VcHpR5aNyOKYm2VMjvUDRSKflbisTZCPGqHk/hTQMDNLsfOW5pjZoAljOAaM85NRqcCmM BSsFxsr1TLHPFDvk0ytYxMZM//0MhjSUnU0tUIbRRSUAB65o6c0hpe1IDp9NulkiEJPzL0 lama4VXZDlaux6ldoMbt31GaQzQdiHaM9QTSk8VQS4e4lLyYBPpxVxj8tZNGsXoQse9LGwNMkP6CobRslgeuc1UUTNmgI93XpUhQAYqVcY4pjEdKZBCQF4FU5WO7Bq23Wqc3BBpgKDiopSRh1OCKA3rTjyMUAadpqykCO64P97/ABraR0kG5CGHtXDuNppFd0OUJH0pgd5UMk8MQzI4Fcabm4YbTIxH1NQEk8k5oA6K51hANtsMn1NYMkjytvc5JplLQAqjJp5Apm7FNLMenFADiQKRlJXcaQDFSEgpikBBU0bkKyj61DWrpsQKySOOPuiqGhtrIUT2zV0ODTjDCgIUYI61lIzlmAP3fWonHqjRM0mYYqo7iq7XHaoGcsalRYORMZSTUDuTUnl7V3P AqBjk1aiQ5CUUlO2mqJP/9HHFBopDTEJSUtFACUDpRSUAJRRQKAJBwKn89hAYV7sCT9O1QU2mBYE24YbrUqqowyjBqtGAzYNaEeAAmOBUMosI74GTUisGNLsUr0phUAcUgJGAqlOvyk lWwxIzUMv3T9KAM3NPBpmKXGKYhxANRGOpRTSxHSmBAVpuKezE8moiTTAfnFJkmmUtIBaM0lFAC5p2flNR1YtkWSZEboWGaANDTrUlhcP/wEf1rULpkqnbr9aM4zjsvFVoABGX7nNUWkRFyr7Tznkis688pZMRcZGT9a2YkUhnPWufmJMhJoYSIqmjdY SMmoKcBSIHuzOcmm4p1FACYpcUopaYH/9k=', 23.782043, 90.423123, 'Open For All', 0, '01775544987', 0, '7 Days/tk.500', 1, '', '2016-02-09 09:46:41', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(32, 'xcggcdv', 'Ffgggg', 0, 11, 'Uttar Badda, Dhaka, Bangladesh', '0000-02-09 10:55:36', '', 'Cbhgj de', 'ccvvvv', '/9j/4AAQSkZJRgABAQEASABIAAD/4QBYRXhpZgAATU0AKgAAAAgAAgESAAMAAAABAAEAAIdpAAQAAAABAAAAJgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABLKADAAQAAAABAAABLAAAAAD/7QA4UGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAAA4QklNBCUAAAAAABDUHYzZjwCyBOmACZjs EJ /8AAEQgBLAEsAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5 v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5 jp6vLz9PX29/j5 v/bAEMAHBwcHBwcMBwcMEQwMDBEXERERERcdFxcXFxcdIx0dHR0dHSMjIyMjIyMjKioqKioqMTExMTE3Nzc3Nzc3Nzc3P/bAEMBIiQkODQ4YDQ0YOacgJzm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5v/dAAQAE//aAAwDAQACEQMRAD8A3aQmgmkANSMcKWkpaYBRRRQAUtFLQIWikozTADTadSGgBppp5p1NpDEApSKTNFIBpFLRSZoAKM0ZozQAUUZooAWkpM0uaACjFGaKAFAp2KZmnUABFJilzRkUAJilxS5FGRQAmKXFGfSigAoozQaAEpOKWkoA/9DbAp1FBqRhRQKKACjNJRTAWlzTaWgQ7NFNooAXNGabRQAuabS5pDQAUUlRTMyRM6DJAyBQMkpKzodRik WQbG/Sr29ByWH50gH0hqMSxsdquCfrSNKq9TUykoq7BIl4oqr5/pSpOGO01lGum7WK5WWOKKz5dSgiYpySPSrFvdRXK5jPI6g9a3JLFGaTNJQA4GnA1HS4NAEmaM00U6gApaSlzQAUUUUAGKWkpKAA00mlooA/9Hdoo5o6VIwooooAKKKWmISloptAC4oozSc0ALSUUUAFMNLSUAGBQeKQ1m3GoRxZWL52/QUASXFnbzqWb5T/eFc3MvlOUDB8dxV ivV2yTklWGeOg9qkk01HeCKD5S6bmJ/CmkBjBiDuHBFWGup3O5m5q6 lSx3KQk5RzjcKr3Vm8F19nX5s42 aGk9wuRfarj 9SfaZs53VNFYzSXX2RvlYcnPpSzWE8MTTPjarbT/jS5F2HdlDJq/Z3SWxJ2biR1qEWlwyo4Q4kOF9zUUkTwyGOQYYdaYjZW9u7g/uFAH fWtkZwM9e9cYrMh3ISD7Vq2 psuFnGfcf4Umhm/0pahjlSVdykEeoqWkA6lpAaWgBaKbSigB1FJmigBaTFLRxQA2lIo4ozQB//9LdopKWpGFGaKSgB1FJRTELTeDRmigBcCikpKAHU0mkzS5oAaaazKilmOAKVmA69K5 8uzM21fuDp7 9G4C3V68zbEO1P1NZpNOJqMnPSqEdPpomktStyAYzwuepFMvlAvLSNeADj8OKmjNteQRSbyvlYJAOMEetVH1K0a6EjqSEGFPvnrQAsMh 3XM7klIgcDtT5yJxa6gvB3AH8aq3F/aNDOkCkNKeT6 9MsryGO1NvN1Dgj86BnQmFTcLOPvKCp hpk9vDOjRSZwWBIHrVD7bFDqDoTlZAvOeAcVLHcxjUJhvG3Yp9sigAlkUXtvZqOE b8gQKwdVYtfSZ7YH6V0YitGnF7v YjjnjFU77T0u2aeBxvxyOxxQBy9Pd2kbc5yabRQBNBcSW77oz9R2NdLbXaXCZTr3HcVydSxSvC4kQ4IpNAdnkEUVTtbhLmPevB7j0q1UgPzRTcmlyaBi0optLQA6lwKSjNACYFLxRmigD//09ylpKWpGBpKKKAFpKWkNMApKKSgBTSUUlAgpM5parXEwgiL/l9aQFHULnH7hP8AgX FZDE96V3LEs3JPWomParSsIQmmmjNIaBhSUtJQAUUUlABS4IGcVf02BLi7VX5AG7HriuhEqzzyWTxYCjg44oA4/BxuxxSqzLypI lbdogOm3KHnaT lYVABRRS0AJS0UUAT287W0gkXp3HqK6uN1kQSJyCK43Fa mXOx/Ic/K3T61LQG9TqQjuKQUhjhRR9KWgBaWm0vagApKDRQB/9TaB5qTNRCn1IxSaaTQaKAFpOKKKAA02lNJQAc0UUhoAaTWDqM Xyh0T dbE8giiaQ9hXKFixLMck04iFJptFJVAFFFakUEbacXC5ld9q tAGVRUoglLOoU5T73tipFtLhkDqhwxwPfNAFail2nOMc9KkMEwcxlDuAyR7UAJDM8EgljOCK6CHVJrl/KgjUOQep9K5upYZXhlWWP7wPFAGzYBzZ3Vuw cZ4 orNs7NroseVVVJz/SthdXtznzYyrEYOO9UbnUpbgeRbrsQ8YHU0CMmiiloGJS0UtABSjIOR1FJS0AdZaTC4gWTv0P1qxg1g6VNsmMJ6PyPqK6E1ADRSmk4NLTATnPFLSdKU5oASjijJpKQz/9XaAFOpmaXNSMdSUUUAHNBooNADTzSU6igBKYTT2PFRmkwMjVZcKsQ7nJ/CsWrmoSiS5OOi8VSq1sIKKKSmAuCeBXWeQkUUCA4MTKT/AMC9a5yzlihuFlmXco7Vbi1EJNNJIpYSYwPTHSgRrbILdnZMsZNzNn/Z7fnUMdzNOtqzYG Q8D0HSqU pK9xHPGpwoIYHvnqKtfabJVt5IztWMt8vcZH NAEMyRx2jGJw4aYE8Yx7Uye6NtqckmNwIAI9sCi2e0mtmjuH8tmk3HHf0q2Bp0lybsyZIIGD0z0BoArS2kUNtNcIAyOoKZ6jJq0q7p5DAFEojTZn070y7uI3s5IzMrtkdBgde1SP5f2hvs7L53lKEJ/X8cUAUtSZxFElwo845JI9Kh0zCySSkfcjJH1p2piRfJE339nJ981YsilpamWcZEzBQO 2gDDq5cwxxRQFOrpuNXfslvarJLdAsu7agH55q7JawN5DEExpGzYPUgYOKAKbWlvLbecgKt5W4AdyDzSC2gS2gaZCGaTDdjiraXELQJME8tFYoR7MOtM1ISLBCzkNtfOR39KAKK2iHUGtz9wE/ljIqhjmuna7T7WsLRjLAAP3wwrnZYzFI0bdVOKYDI3aKRZV6qc12UbrIiuvRhmuNxxXS6ZIHtFXuuRUyGi6eDRmnMKZSAXIozSCloASiiikM//1tnFKBTsUnfFSMWkpabQACl60gooEFJilo60wGNUEzbYmb0BqU1DP/qXHsakZyZ9fWkpKWtBBRRRQAUUUUAFFFFAEkUbSyCNeprZTT4FHzZY1jwSeVMsnYHmukV1cBlOQa5cRKSasVFFf7Db/wB2oW09M7omKkcitCnBtpzWEakr7lWRz961y0v knJHT0xUctw8yxo2MRjAqxqE0crKqHO3OTWfXfBtq7M2a41QyArcxhxwQPcVM r7mQiPG08/T0rDpasRuSalb UYIovlIPX1NUpLx5LVLYgYXHP0qkKUUAWxdObhbiQBiuOPpUc0rTyNMw5Y1F9KUUwEHFa2lSqsrQsfvcj61ljrmht0bB14I6UmgO0xUXTim2s4uIFl7kc/WpGGGNQMZS5oooASiilxQB//19ykozSe1IY6kpvNLQIWikooAKQnAp1RtQAys3ULnyl8pRy4/IVpVzupZ 1HPoKlDM6lpKK0ELRRRQAUUUfWgAopCaTd6UALuwcip1uXWMxpwDVSlFJq 4yyk8uMbjgU4XEy5G4nPHNVqUEd6XKgFxS0nHSlyQM1QheacKaCD7UtADxTgKYKeM1QhQaCCq5zRjNO6cHpQBH8ykZOc/pT3YNwOoNSiONV4JLHue30poRPOjHYkZ/OkB0WlxlLNSf4iTV5 oNPCgAAcAdKa/SoGR0GikoAO9LSUuaAP//Q26TNJz1ozxUjAUtJmg0ALmjIpD1ppPFAhxNNJzRnH4UnegBtYmpx/Mso78VtmqV5F5sBA6jkfhSQzmaWg9aStBC0UUUAFJmlpKAEpKWkoASilooATNBpaAMnAoAcg/iNOBBFKcABRRtFABjHNKOeaTGacKAHCnAZ5po5pwHPNUIAcHpUg5J/SmVKhJ5xQA8D2qKY4Ixxip d2ccVTlJzg9qGCOvsZvPtUc9cYP1FWX 7WJojnZJEexBH41tv901AxlJRSUgFpKKKAP/R2qKMHNIQelSMWkPNHtS0AJ9KTFLSUCG4NIetOxSY5oGIelY9/eNE3kxdccmtk9K5S8LG5ct1zQkIrHnmigdKKsBKWiigApKWigBppKcabQAUYop1ABiiiloAPenZJptLQA6lptKOtMQ ncd6QUoxzTAcvNTKAOR1/nUQBB4qVOGz VADmO0cZ/wqizEkn1qxI/ylT1qOCMSzxxHgMQD NJgja0RG/eSduBW6/wB002KKOBBHGMAUsn3TUjIs0maSkpAOzTqjpc0Af//S26Q8UtBqRiUUtJTEFJ9aKKQBTfSnUhoATtXPalAVl80dG/nXRVBLGsqlHGQaSYHIr1xQRVy6tHgO4cr61VPIzWiAZRRS9aAEooooAKSlpKAExS0UUAFLSUtABS0lLQAtKKSlpiHUuRTKUGgCdducGpWHO3pUCkd RTS/P0pgI5DN7Uts2LmNj2YfzqI9PrUluC0yAd2H86ljO8qGX7tS1DJ2qQI6SlpKAEpaSloA/9Pc4NJSUmeakY6kxSUc0CClopM0wCkNLmigAHSmkc05fShh3qQMjU5THEEHV/5VgqecH8K1NWB81D22/wBayT7VaAVhj8aBUwG9MHr/AFqCmA7rTaWloAbSUGigAooooAKKKKAFpaSigBadTaUUwHUmKKWgQcigDPFITSg44pDEkxkAdq1tKtGkmE7D5E6e5qrpiLJeKGGRya7AAKMDgUgFNV2OW gqc1Wzk5pAFFFFABRzRRQB/9TZpKU02pGLRRSUAOopATRQAUnFFFAgzhgalx2qHqKmU5XNAGffW/nw4X7y8iuXI2nkV2zCs 4sYpzu 63qKEwOciIDbW6Hg1LLEcnjkdf8addWUlsNxIK tQidjgP271SYEVFWDGH5Xr6VXIIODTASikooAKKKKACiiigApaSigB1LTaM0AOzRmm9elOC9zQAdBk0zOac5zwO1IBQBs6Kmbhn/ALq/zrp6xtIhMcJlb M8fQVrdKlgI54NQe1Pc5OPSmZoAWiijNABS0maM0Af/9XYNFFFSMTvRmiigAoooNABSUUlADqcp2nHY0yjrQBYxmo8U5G3D3HWlIpCOe1gncidsZrExXRarbs4WZRnaMH6VzxGKtAORypwamIDjJ59/wDGq31qUPxzwfWmA0rimU7d60daAG0UtNoAWiikoAWikzRQAtKBmgU8ECgBvSkzmkJLGl60gJ7aE3EyxDua3l0qHguenYd6g0m1/wCXlvov NbtSwBQFAAGAKRmwMmnVAx3NjsKAEoopKYDqQ0UhoAB1p9MFPoA/9bZpKM0vapGJRRRQAlFHFJQAlLSUUAFLSUtAACVbcPxqyCCMiq1OR9hwehoESsorGuNLEhLQnbnselbtNK5oA5KTTbpOi7voaoOjRsVcEEdq7ciuT1BCt2 ec8/nTTAo0lOz2pKoBd1JmkxTioxnNACUcUYA60beM0AAIpSabinAUAN5p1HSnpG8jbUBJPYUAPSGSRS6jIFS21s9xKIwMDufQV0lnB5dqiSLyOtWwFX7oxU3ASNFjQRoMADAp9FMZsVICM3YdaYOnFN5zk0uaYDqSgUZpgFFFJmgAp9Mp1AH//X2aMUtJUjEpaTFOoAaabTqMCgBKSg0tACClpaSgQYoxRzRmgY5HKcHp/Kp81WyMUiuUOOooEWCM1nXlilwd cN61oqwYZFLSA5B9PuQcBM0z7BcDGVxn3rscCmlFPandgcg1myKSzLkdqqciu1NtCTu2jPrWbNpcbOCp25oT7jOboxXSrpUQTaecnOe KaukRbssTj0p8wjEgtpLh9kYz79hWrJpnlwbVOX65/pW1FFHCmyMYFSUmwOPWyuWfYEOf0ro7KzW1Tnlz1NXMUtFwCikJqNnxwOTSAczYqLqcnrSc9TThTGJQaWimIUUlKKSgApaSloASloooA//Q2qSnYoqRjaKKSgANFFJmgBaKKKYBSGlpMUgDNN96XFLQAmcUmeacabgUCE5XlatqcqDVSrER QUASUlLSUgCkIB60tJQAUlIWAqPzU9aAJKKhMq9s00yE9B dAE aYzgdahO49TRjFMBSzH2FAHpSUooGGfWlFFJ0oAdijmgGnUxCZpKWkNACZpeaKUUAGKdgUlJnNAH/9HbpKWkNSMTrRRSUAFJ0oooAXNJmkpaAFpM0ZpvagBaORRmigBM0ZoJooAKkiOCV9eRUeKQnHI7UCLlJSA5ANLSAKaTS9qgmJ4X160AQsd7Z7dqAKdSUxhilxRSUALmkzR1paAEpaTtRmgB1HJpBTxQAm2nCkoFMQGkxS0lAC0CkooAdTeaWloGf//Z', 23.782043, 90.423123, 'Open For All', 0, '014455555', 0, '7 Days/tk.500', 0, '', '2016-02-09 10:57:38', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(33, 'dilir Vaia', 'Cv be bhj', 1, 11, 'Uttar Badda, Dhaka, Bangladesh', '0000-02-09 11:07:07', '2016-02-09 05:09:54', 'Fb bjgdg', 'Baghdad', '/9j/4AAQSkZJRgABAQEASABIAAD/4QBYRXhpZgAATU0AKgAAAAgAAgESAAMAAAABAAEAAIdpAAQAAAABAAAAJgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABLKADAAQAAAABAAABLAAAAAD/7QA4UGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAAA4QklNBCUAAAAAABDUHYzZjwCyBOmACZjs EJ /8AAEQgBLAEsAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5 v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5 jp6vLz9PX29/j5 v/bAEMAHBwcHBwcMBwcMEQwMDBEXERERERcdFxcXFxcdIx0dHR0dHSMjIyMjIyMjKioqKioqMTExMTE3Nzc3Nzc3Nzc3P/bAEMBIiQkODQ4YDQ0YOacgJzm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5v/dAAQAE//aAAwDAQACEQMRAD8AsUmR0NNPvSMMxsB6UiluPDBuVNFQQoyAhhip6AYtLTaWgQtFJS0AGaTNBppoAWkpKMmgBaKTIpaACikyKM0gCik5oxQAZFJn0pcCigBhBNJtNPooAbxS0UUAFJS0UAJSEgdaWkIB4NAEJuIh3z9Kck0bnAPPvSeTF6U8Kq/dGKAH0UlJkUALRTcn0oyaAFIpucUtJigBMijNHSlzQB//0Js0lRbqeG8tfMIz2ANIY/nrSc1YRYmRnI5PQVV3UAOzS03NGRQIfRTM lJlqBklJTOe5peKAFzSZNLSZoAME0m0UhbAyai 0R0AT9KM00MGGRS0gHUU2kyaAHUU3NGaAFooHJwOalWCZjgKfxoAioq4tlKfvYFSrZKOXYn6UWAzaaeOlbItYVGQu4 5qVY0UfIoX8KdguYOTjOKTJroXRJF2uMiqUtgmMwnB/SiwjL5oqWSGWI/OvHr2qKkMKSikoAWikpMigBaKbkUZNADqSk5owfWmB//0WOgpw bG/nHrUrLxTAKQybO7gdKiMY7VKg4p2KBt3K/lt2NJ847VYxSYoEQB6XdTSnJwabtYUAS5pOKjyR1FIHBoAlzRmo80uaAH5pOPSmfjTHJHSgCfIozUYNLuNAD80c0zcKM0AOxRgUmaTNAFyO6dOG Yfkatrexk4OR9ayM0u6gDfWRDyCD9DmpAwPTFc6Gwcjg tTfaZj3zRcVjczkkelIenP61im7nIwWqNpZG 8xP40XCxuMwUDLBahe5tweZPy/ tWIcUZouFjVa/i3EbSw/wA tZ80kchyibT9f6VDmii4xvzUfjS0lIAwKKSjNAC0zef7pp9FMBASRyMU6kopAf/StMvFRhatEcVDipGOQdaVuBmnIKVsgZHamIqhvUg vb8qkxVUT7iA68A9KvYzzQFyuRzSYqQjmkxQMiK0zYD1qfFM9aAITGO1IUI71MaKAK3zelNLDoas4qvLEZCMHGKADcBSbyegqUJ8u080wxkdDQA3J6Uc tIQw96TJHUUASfjRUeTS5NAD80uaj59aWgAy f8KehO4Z9abT1 8PrSACaSkJGaM0ALk0ZNFFAC0UYNJzQAUUnPeloAKKWkoAT6UZ9admjNACUUH2pPmoA//9O6JlNL3qDZt6VOOeaQkyVBTitLGKZcSGEBgM5NBSVyl5Y87aB3q3io4SZJC ODVnbQK1iqw5oxUjD5qTFAERFR7eTVkioX3AnaM0AM20u2oWmdeWU4pv2lO4xQBMVqNsLyTQJ4274qKdfOG1SMetAE/WmkURL5cYTOcUrAkcUDISMtxTsetGw5zmnYoAj2CmlB24qakxQBBsYd6TkdRVjFIRQBX3Ctm3toFQPIdzfoKycVbjkkC4BGPeompP4R6dSe6to0QyR8Y6is2p555CNhPBqrk0oKSXvA7dB9Lk0zNLmrEXBdSBNgwB9KrU3NHFAC0UmaXNAChfSk5HarSXbRpsUD64qsWyc0wHKpfoQPrU4tmP8AEP61VzS7mHAJoAufZDnBP5D lOFqvc5/HFUvMc9ST NJuoEf/9S7jipMYIPrTakP3R9KRKJoxzUd4uYSfQ5qWP71PmQvEyjqRQXF2ZiRyNE2V/EVqxusq7l/GskqVOGGDV6yQ5Zu3SpTOirFWuTOPmpuKdct5Sl/QVzzzSM2WJqjCMbm/imEcms23uXVgGJK981q96BNWM2/GICfeqK9Iz6itHUB/ozfWs9B8sX0/pTERAkysp7CrGwelQKP9If6f4VdxQBDgjoSKd5kgGM5 op KaRQAnmv3Ao871FMIpuOaAJvOXvkU9XVuMj86qsQoyaiEgb2oA08UhXvVGKZI3OTxV0yAgYIIbpSGMIqTyg4Bzimkc1aQLtGTQhMqSoAQPaoStWbhkWTBPaouD0oAgwR3pCWFT4ppHFAyLdRuFPxUZFABuFG8UBaUCgBUeMsN5IHfFSSmEH9ySR71Gy8VGVNAD91G6oec07mgCwkqoCGQMfU1HuqPBowaAP/1dCpf4RUVSj7opEoli 9irNVV 8CKtdaZQxo0f7yg/WlAAGBxT6SgCrcRCVdjcA1Q/s2E9Sa1X603FA02Zv9nQjoWFWdu04HYVYxUZHNAmzO1Af6K1ZyD93F/nsa1NQH ivWbGP3UR n8qAIlH kv/u/4VexVVB/pT/7oq7igCPFNIqXFIRQBARzTMc1ORTcUAVY4/tMxQnaq1sMtukQiXaQv0qgsCPvDnYDg5qLyrWOJlL7mbpUspDZkjkb5cD6VBA5EgiPTNOWKNed3NPhTdPuA70A0XyOar3gwYvpVsjmp3tFnCMxIIGOKYjnZmZSq5/hH61Ki/JnvSX6BLoxr0UKP0FWUX5B9KYiCMuc89KeWf609EwTSleKQAORk4FQvIB0qRgc4FVXjYnkUATo 44qcLSIGY7mGOMCp0WgZWkbaeR3qIutWbleRVPbQA7ryKXn0oAPUVKBQBHhvSl2tUoFOxQB/9a/Uy/dFQ1Kv3fxpEomT7wqzVVOoq3TKCiikLAdaAGP1FNpWYEjBpB9aACoz1p59jTOp/CgRSvx/or/AErLi/1Ef4VrX3/Hs/0rLi/490 o/nQAij/Sm/3RVyqy/wDHy3 6P51aoAbSGnUhoAiNJTjTSQOTQMjkVmXAqi23ABOCPXOasTXIX5U6 tZ S455NFgTJNyg8GrtnNCrFX4J6HtWZt5x3qdExzRYLm5vRiSpBrTT7g lcgz44U00SyLyrsPoaLAWb8/6e/1H8qtDhRWeoeeXzHYZ7571dJYjHy/nSHYkAw Pahh/OmgvuzgdMfeFT7QR1H50XCzGGMcNSFasryMcfnTSkg5CMfpQAwCpEHSlCMVzg/TilQMTgKwPuOP50rjsypccvj0qtir0kTbvmz A/wDr0 K1RuXJ mMU7isY0jsGwDimeZJ/eNbcunQY3lj HNV/sVvjhnz9KC0Zvmyf3jS bJ/eNaQ01SM7m/Kk/s33P5Glceh//9e6WAPJqZPu/jUbW7MQSOlTrGVXBpCSHr1q3VQVaoGBNZl9I3lFlOCKuu3aqU0TTIY170Ma3McTSt6n6ZqQm4ADLv5 tbEUMdumxPxPrUorO5rzeRhB7ztvp4kvh/eraNQyNxii4c3kZTXVyvDE/iKQXkuMfL QptyCHyTn0qtTNIpNbF0Xj5yVXP0qaK6eRxGEXJ9qzKu2SnzhKfupyTTCUUlsa3ky/wByM/nTTDIOsSfmaRruTPygCmfapu2B FO6OexVa4iXIMQyPesp5MnLGrd0VVeAMtWOfvU4hO3QsNhhUYO1KTPFHU/SqIHIu3k9aVnz8q1GzUqkD60ABAFNzTyR6UzigZoWVvFMrmV9hyMVc wQdpx VUIR8gxUwSQ9FNZt6nTGGm5Y/s PtOv5f/XpPsA7TJUfky mPqajbcnDd6Vx8vmb0IiSNUyuQOSKc WBVcYIxXO8HqKMjsKLk x8y69jIB 7OT9ai x3Xp oqvuIpfMfsx/Ogvll3J/st36H86b5F2OzfnUfnSf3j ZpfPl/vH86AtId5d2Oz0bbodn/AFpBczjoxpftU/8AeNAWYqi7JwN1Juuu /8AWj7XN60fbJ/X9KCXGR//0N6kbpSFlHU0hIxUgJUxPFQAihnGOtMAY5oVsr0qIuPWlj5X8TUSKRI2cUU00wsAKkY9iAKqscmopLqNe arLeo7bVUmnZgmhl194fSqlXLhWYjAzVQqy8MMU0dEXoSwxNM 1ePU grTO1FEcfCj9fc1Usz8jj6VZNJmc3d2E60mQOaKpXshWMAdzQtSGVZ5d7FvyqptZuQOKeMH71OeQcAdAMVsZjAh7mlwM4zTd4ppYUCH7V/GjIHSoyx tNzQMeT6UhNJniprePzZQv40gNa1QqgJ64qyxNIOBgUE1kzUYTVC4zvHpV1qz5zlxTRQoPFLUSmn5oN0x1FJRQMKKKSgBaSiigApKKKAP//Rsi4iPJU/hzUct/EnyxqWP5YrDGR0pu47jmpURmi oTA8ACo/t83oPyqkxzTKqwjQ 3ze35VKmpyqMbVrKzRmiyC5tDVf7yfkabLdCZMRkqfesgVMkpjORS5UFxzMVbEgyaes4XpxWzb/AGS4iXzipfGOan/s2zfkAH6GlzBYw0nZzgOE96eIXf7rh/xrcXTrdOiD8eam zgfdFS2XF2Me2jePcHGM4qyatSxlVqtjjmpbKvfUZthbiU/hnFVbqJZU2RkcdOc1NJbJKd5zzQLcxgLEpIPWq6EmG1tcDqv5VB7GuieOSNDI AAK51vvVcXcloTikp4GaQiqEJzRRRQAtXLH/XH/dqnV2xB80n0FS9hrc16ZTjTDWZqMY1nTHL1oMazZT89NDQgp4NR04GmaJkmaWmZpc0i7jqKSloGFFFJQAtJRRQB/9LJqNxjmrDBWOUOfpSywskZLkA/3e9ICpRSZoqgJEkaI7k6/nUdFFAC9KTqaSlxgUgJUmdOmD9atJfleqfkcVQpKVgNtNTUd2X9atLqYPSQfiMVzNLilygdcLsSD5gGHsakW4t16rj8K43kcjirIlmRQVcj8aXKO51omt3OQ2KlHlt0YVyAvJx1w31FSrfH JB BIosBoavMBtgU 5/pXPgE5YU WQuxY8k0sfC5rSKJY05HBptSvtI96hoYCUUUUDCrlpIsQZm74xVRRk89Kl5bp0FJgXDduT8qik 1yd1FQDpS4qbId2SG5yORVdiGbNSYo209B3ZHS80/YPSjYKB87G5pwIo2leRV2BYphhlGRSaLVRlTNLWibOE9OKYbFf4WNTc09oUaKtGykHRv0phtZx6GgftEQUU8wzj CmbZB/AfyoHzo//06QRkGR8v86iC8MParDzL0qtvAzn0oAqUUYNJTAWrEdrNKN4GF9TwKS2khik3zIXA6CrF1dT3RCqNq9AopO4FVo1Tq2TSMytjr0xSsET5Ordz6VHQAcds0lLSUAFLRRQAtSH7i/jUVTMP3afjQwI6KWk74oAZjFJkjpUjDFMNUITOepp2PQ00DJxVgKAOKEBFsz3FJsNSnio9xoADwMChWx0NMJoFSMnDmnhx3FVaXJFFgLokSpA0Z71Q3Gjd7UrAaQVT0pdgrODj3qQSMOjUrAXPLpLL/j4CeuRUImce9Ngl2TrJ6HNFgOk8k lJ5Zpq6hCeCCKsLcwN/F dZmlyHZRsq0Gjb7pBpSBQFyoUphSrhQGk2Cgdz//1Mb5j0o256kCmsr96QMBwaYEmxf71Hlr2YUmBjOaj6nAGaAJDG3bmp13xRhg2CcioooX80I2V559cUsjfOQDxmgCA tKeDTioJzSN60gG0lFJmgApRSZpc0ALVh/9VH P86hSN5DiNSx9q1006aSNA ExnPrSbAyaekckhxGpY 1by2FpAN0p3H/AGj/AEp5u4YxthXP6ClzDM2PSp35kIQfmatNp1lGuJGOfXPP5U17uZ M4HtVfOetK7HylaS2RW3RMSB61HvH8VXaikjz8y9auMhOJTdlPSojT2xmkUVTJIxS0EYNFSMKWm0tAC0lFGaYC0UlFIBc08HHIqOigC0t3IPvAGpBdJ/EmPoao0tKwGktxCf4mWp0uMfclFYtLS5QOiW5uB0IYVJ9tlHVa5oEryDipRPMP4zS5R3P/9W88yS9FX dVJra1b53G336ViecR0GD7GmtNI/3iTTETzCFD 7JNQBiORxUdTLC7AEdKBksVwY1Ydcjj2quakMEgphjYUgDcKaTmlRHc7UBJ9q0YtLuJOXwg9 tAGVg05I3kO1FLH2rpYtLt4 Xy59 BU5uLa3G1MfRanmAxItJuH5kwg9 TWlHpdrCN0nzfXgU176RuEAX9TVRndzlyTSux2NQ3VvCNsQz9OBVSS9lfhflHtVSikVYUsWOW5pKKKYBS0lLSGFLRS0CK00G8bl6/wA6rBcDBrSqKSPcMjrVJiaKRUHioihFT9ODR2NUSVsUlKeDRuNACUU7I7ij5aAG0U7j1pKAEopKKAFzSg02loAk4NLgUgpwoATbSYp1JQB//9bApaACxwoyfarcdlO/JG0e9FwK2KtRPIVCoM1cj09c/OS1aqCC3QAkL7DrS5gM2O1u5PvfKPer0enxjl8ufyFI9 i8RLn3NUpLqaX7zceg4FK47GqXt7cbcgewqpJqB6RLj3NZ1FSOxK80sv32JqKkpKYx1GabRnNAxwpaQZpaBBRS0UAFFJS0AFKKKKAFopM0UgIpkBUsOoqlvXBq/J9w/SsurRLEbrSCnUdKoQ2inU0igBKKKkiiaVsDp3NIBgBPAp3luO1aIjWNcComwOTTAokEdaBUjyZPFMFIB9LTaWgB1JRSUAf/15gsUI7LUbXKD7ozVIknk0lZ2LsTtcSNxnA9qhJptHNMBwpaaKdQAUlFFABSU7FFACY9adSUtABRSUUALRRRQAUtJRQA6koooAKWiigBkv8Aq2 lZtaMv rb6VnVUSWFJS0VQhMUUtFAAFLHA71oIoiXaKhgUBd56mpGagQM2apyPu6dKdK BtFRHgYoGMpwplOBpAOpabmlFAC0tJS0Af/QpUUUVBoFLSYp2KAEFLRRQIWikooAWikooAWikpaACiikoAWiijNABS0lLQAUtFFAC0UlFAEc3 rNZ9aE3 rNUKpEsSiloqhCUUtJQABmX7pp3mt3plMoAkUb35pJDzTgwC8daYRnmkAylpcUlABSgkUlLQA7dS7hTKKAP//Rp4pcUUlQaC0UUUAFFJRQAtFFJQIWikooAWiiigAooPSkoAXNFFLQAUtFFABRSCigB1FJRQBHOf3ZqjkVbuP9X NUM1SJZJRTM0uTVCHUlJmmk0AKabg05Rk81NtGaQEQFLUhAxmk6igBmKMU6kBNADcDtSYqSkPWmAzFJT6MUgP/2Q==', 23.782043, 90.423123, 'Invite Only', 0, '0155495793', 0, '15 Days/tk.1000', 1, '', '2016-02-09 11:09:54', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
(37, 'can', 'Xccvb', 1, 11, 'ChÃ¢teau de Fleurac, 24580 Fleurac, France', '0000-02-09 11:32:59', '2016-02-09 05:36:22', 'Bbbbvbbbjjihbnhnnn', 'ghjhghbjjjjj', '/9j/4AAQSkZJRgABAQEASABIAAD/4QBYRXhpZgAATU0AKgAAAAgAAgESAAMAAAABAAEAAIdpAAQAAAABAAAAJgAAAAAAA6ABAAMAAAABAAEAAKACAAQAAAABAAABLKADAAQAAAABAAABLAAAAAD/7QA4UGhvdG9zaG9wIDMuMAA4QklNBAQAAAAAAAA4QklNBCUAAAAAABDUHYzZjwCyBOmACZjs EJ /8AAEQgBLAEsAwEiAAIRAQMRAf/EAB8AAAEFAQEBAQEBAAAAAAAAAAABAgMEBQYHCAkKC//EALUQAAIBAwMCBAMFBQQEAAABfQECAwAEEQUSITFBBhNRYQcicRQygZGhCCNCscEVUtHwJDNicoIJChYXGBkaJSYnKCkqNDU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6g4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2drh4uPk5ebn6Onq8fLz9PX29/j5 v/EAB8BAAMBAQEBAQEBAQEAAAAAAAABAgMEBQYHCAkKC//EALURAAIBAgQEAwQHBQQEAAECdwABAgMRBAUhMQYSQVEHYXETIjKBCBRCkaGxwQkjM1LwFWJy0QoWJDThJfEXGBkaJicoKSo1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoKDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uLj5OXm5 jp6vLz9PX29/j5 v/bAEMAHBwcHBwcMBwcMEQwMDBEXERERERcdFxcXFxcdIx0dHR0dHSMjIyMjIyMjKioqKioqMTExMTE3Nzc3Nzc3Nzc3P/bAEMBIiQkODQ4YDQ0YOacgJzm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5ubm5v/dAAQAE//aAAwDAQACEQMRAD8AyIRCz4nYqvqBk1JttdhO9t27gY4x6/lValpgW9ll5hHmPsxwdvOaiZYBEpRmMmeQRx dRUuKALTR2wPytxk49xjim XDjORnHTPfPr9KhVQck9hR AoAfshLsN3GOPr6U/y7fH3 QTn3H NQ/gKPwFAErRwZJV MnH50vlW /l/lz mR/SoPwFGfYUAOdI1QMr5J7URLGzfvDgfWneU AwUEHpg5oWKRjgJQA7y4ccN2PPv6YqvipdjYzt4/GkIxwRigCLFGKl/AUfgKAEiVGfEhwMH8 1TGO33sA2QOnOMnj2 tQ/gKT8BQBJIsAVvLYkhsD3HrU2yy3qpZscZPbpzUMKq77WHarX2eL0pAV5Et1jJjfc Rj6H o71WrR zxelH2eL0oHYzaK0DDCCFPU0CGA9O/vRcLGfRV7y4MZpfJh/yaAsUKKveVB/k0ohhP/66YihRV/yYP8mn/Z4vT9aAM2itP7NF6UfZovSkBVVICqktz3pNkGWBY xqzJbxqhYDBAqhQBYjjt/tCrI37s9SKvywaUsTGKQlwDgZ7/lWPRQA4BSfm4HtzTKKKYH/0MSlqPcacm92CL1JwKYD6cBVo2NyvUrx VRzW88CCRsEHjigQ1ccg9xRt9xUCu7EKoyT0p484sUC5YdqYEm33FJt9xUW96Te M0AS7fcUm33FRb26UBmJwOtICwHcAKGGBkY vWpBLJnO4cdOOnGOOKrESrkkdOtN3tSGXhLJkZIODnH6VGQWJYkEmq4aQ5wOnWk816ALGz3FJt9xUHmv7Uea3tQBMV9xTCvuKj8xqTe1AFmEqj7mPGKtefF61l7jRuNAzU8 L1o8 L1rL3GjcaQ7mmZYDyT7U0Pbjof59qztxo3GlYdzR8yAd/50m AdD/Os/caNxpiuXw8A6H dAeD1/nWfuNLuNMRo77c9/bv2qQTQgYBrK3Gl3mmI1/Ph9aXz4fWsfeaN7UgNSWaIxkA5JFZ Kj3tSb2oAeabQNx5pCGoAKSm7jRk0Af/9Hn6ejFHDjOQc06lpgX2v8AIxlm9mxjNRT3jTxeVsA5Bz34qtS0eYDIyyyKyjJBzipknkBBC5I6n1HbNNBIOQcEVIZZT/EfWgCPzJCpjAIOAOOvy07z2Jzt9T YAoDuG3gnd6/WkBIyB34oAQztt2gY4xnv1z1ppkYyCQjkY/SlpKAHee/zZH3ufpzml88gkquCW3dfr/jTKWkA4zsQQBjIxn8c1G7M53EdgPyp9LQBBg0YNT0UAV8Gjmp6SgCHmkqaigCHml5qWikMi5o5qakoAi5pKmpKAIqWn0UwGUc1JRQIj5o5qWloAh5pOanpKAGhuMEUm7HQU6koAioqSkoA/9LFoopaYBS0U7FIBURpHCJyWOBUotZy7xheUGTSQ7xKpiGWB4 tWfOuAAFZWxkcdTnj8fagZU8mXOApPToM9aTypCBhSc5x HWrbPcthSvcHp/dGKVpbrB3rwc54/vHP86AKXkykkBDkdeKEikkk8pR83oeOlWZJbjYVcYU4HT 70FKWuUm 1Y Yjdnt8woEVzbyhQ2MgnHHPv2pqxSN91Sc89KtLLdoFGCcHjIz1GCPyp6yXIGAoAVcYx2J/xoAq RNt3hTgkj8utRYq8ZrhdspwNrnHHc9eKi8k7N RgnHXvQBXwaMGrBhljYqVOc4pG3rgMMUAV8UmKtNFMHI25K8ce1MKybdxU4xnPtTAr0VO0cvdT19O5pvky5xtPrSAiop4ViMgcZxTvKkwTtPH9KVxkVFSFGGcg8dfxpRG5XcFOPWlcZFSVO0EqtsKnOAfzphjkBwVOef060ARUVIsbv9wE/Sk8t8Z2ngZ/D1qgGUtP8qXn5TxSbHGcg8cn8elAhtLT0jdwxUZCjJpzwSodrKeuOPWgRDRT2Rk 8CM04wShiu0kj0oAhpKl8qTAO089OPWmMjIcMMUwG0lLSUAf/08WlopaYC06m06kBJGXDgx/ezxirIE6gOigZPYDt/SqqsyMGU4IqUTyqMKcDngD1oAk/0jBULgc8AcfNTf3 NwHVQPwH/wCqmieUHcDz9KDO BjAKjGcc/55oAdJ9ok VhnnP4kUm6cruC/w7c45x0phmkPXB oB9qPPlC7c8Yx07UAWSbsP5eADux7Z6VErXCKWQbRjsMcZqP7RLu3ZwSckgDkijzpSuwnjGPwoAX944GF4JJGB3707bLsC4 UHd dMWVljaMfxdad50nryRjOOcD3oAk8ydCz9DuyfrzSSrMwDMMjbkY9DUbSu4IbucnjvR50mMe23OOcUATFrncGK5OcjjoTUWZ85x/DjPt9aDcTE53c1H5rjgYweMYGKYFkyXGT5abWLAk /b881ExuWGwjggj9QTURmlOOehBH4dKFmlXhT6/r1pASx bAHfGCMDn36H9KjE0gA6ZAwD3ANNaR3zu74/SmUrDJjM7KVOOQAeOTjpSLM6LsGMc/rUdJSsBN58gJPGTgdPTpQ1w7Kynq5yT9euPr3qGm0wJI5ni4THXP40ouZRwCMZJ6evb6e1Q0lMCdbmVehGeeSPXrR55KLHgEL69//ANXaoKXFAhyuyAgfxDBqQXEoYuDgsQSfcVDilxQMdJK8mA3QdKk 1TevfP41BijFAiX7RKF28du3pUckry43dqZRQAlJS0UwP//UxqKKWmAUtJS0APVWdgqjJPAFSCGYsyBTleSPSkgLrMjRjLAjA9TVpbqfaWCg44Y9zkEDP07UgKZVgcEUmGwDjr0q2bmf7oXByp4z/CMUfaZiSuz 9kDOfmOfwoAp4PTFKiPI2xBkntVlrmYgqBjdtHGc/LTVml89rtVGQST6DdxTAhaKRAGZeDxmmgE9BVtLidAgK7urD3BGD0pyTyqoCIAqjb/7NQBU2PtD4OD3 lJmrouZ JFXAUl DniqZRh1BFACUmaeocdATQdyqpI4PI/lQBHmm5qd45Eb5gMjjGRmm4buuOCaAIqKcQxwdp56cUznrQAtLmkKsBkggU8RSEA4xnpkgZ/OgBuaM0pRxkFTx14puGxuwcetFgDNJShSRkDNIQV 8CPrQAlFLtbG7Bx605I3kzsGdoyfpQAylp6xSMm9R8ucZ96Ta2M4OPWgBtLTtjgkYPHWja2N2Dj1pANpKWkoASkpaSmAlFFFAH/1calopaYwp1JTqQySHeJUMYy2Rj61Mkk4Vj94AgnPr2qBHMbh16qcipEuJU6HPIPPPSkOxOJZeVZOiN6jg9aQPKymHZn7oGM8Yz3/GofOYLtUADnj69ad9pkLBiASDuHsaYWHGWXaxKnJPB7DtxUCvJGrKuRnAJ9MVJ9ocKVwOQR BpsspkwOgH6n1NBJLunKDeAQV7nkjOfWm dMT0/TsRt/lTVndRgAdMf5HSlE7DsOgBPfAxj VMQ8yTDO5OWAByDzjHb8Kk82UsAUPB3YAPfj8qj 0uGLIAuW3f5/OgzyMpXsRj9c0gHpJKdzKBtBHXoPQVA6yNhdudvHHPXmlRymcDr/ntUguZA27AzkHp6UAI8szMHK8nDDGex9M 1MEkiIS4yGLAfUjBpftEgGOMYxj8Sf61DJI0n3vUn86YExeduThS D1wTjpgE8VFP5j4fZtTGRjpz3/E00zE4LKpKjAJHp0pPOk/Jdn4UASSSzOmwpgMQeh6j0pP3hUeZHnYB1yOM8fWlN3MTu4yTk /amrcSR/6vC8Y4 uaYh3nzmQZGWUk4x3PXilMtwV8rbztA6c4FQiRlcyLgE5HHuMUvnvs8s4K4xj8c/wBaYD0lnQ8Lk7gendc/40wNMYwR91O/ 8ff6U77VMCSD1x GOOPwqN5nfdnHzY6dselIB4uXCbMDBXb FNWeRckHkjGfxz/AEqGlpDLQupAcgAAEEAdBjn tN89 n zs/CoKWkMtfaZC28gZDFh16mmec56/wB3Z FRUUDsJikxTqSgVhpptPNNNAhtJS0lMD//1sOpoI/OmSLONzAZ tRbTT0LxuJE4KnIpjOiGlWecbn v RVK9sYbeHzYi3UAhvegavdf3E/I/41Xub6e6QRuFC5zxSAqIpdwgPU4p3luenPbrTF3KQy8EU8SSjocUirjvJfBJ4wM/hnFNMcg7Z6dPfpR5kvr2x FKJJBk55Ixn2phcXyWwDkc57 lI8TpjPQ4x75poZwMA8DP60b5eufT9OlBIMjoAW6Gm5pWZ2GGPHWm4NADs07NMwaXBoEOzSZpMGkwaAAmmE07BpuDTAbmkp200m00AJRml2mjaaYhM0Zpdpo2mmA2il2mjaaQCUUu00bTSGGaXNJg0uDSGLmlzTcGlwaB3FzSZowaTBoC5MIxjcxppQH7ppoZgMdaQsx9qYiOkpdpo2mgR//9fHpaKKYwooopASwx dKsQONxxmpRbSNgrggkjI9utRwKXmVFO0k9R2qYLcNhw5I5GcnjHWgANo6qzOwXaFPsQ1J9knzjA4ODz04zk 2KkEV1v27z2GcnnPIqOPzW82Mtjglj1Jx2z1oADasF3bgfk38emcUslnLHJ5fBySB7470CKcgDf8uOOTjBP/ANanCG53EbiCCe55I6mgCvLC8JG/HzDIx6VHU6q80bO7n5MdcnrT/srjvzkj8AM5oAr7DQFYnAqyYJF ZmAHHPPfpS/Z3VPMB9c/gcUCKuxvSkII61ZjjklHykDBxQ0BwDnJ27iO9AFSkq41q4bbkcsVH1FQLGWbB4APJ9KYENFWhbE9DxjPTnrjpSLEgmaN dob8xQBWxRir0kCfwjHIHUY5HuaQ2wAB3dfb3xQBSxRip/KJcqDwp5P44zUn2cd2AGCcnjoaAKeKKufZ1wCGznHb1OKbLAIkyeTuwPSgCpRTypABPerCWu9QVbr2xQBUpanaFVbaXxxnkVILXLABsg4Gfrz3NAFSirQt84weoz098VFJH5chTOccUARUU7FJikA2kp1JTAbRS0lAH//0MiiilpjEpaKKBEsADTKDnk9qnGyTBDkNg9M me5qnVmODcBkkE9MDjH1oAeIyQD5hy31/n0pDCyt94gnqeg/P1pPK2xGTJHAPHucU JUMQyuTz mP8AGgBkqNF8wcknGex5GakH3QQTjAJy3c8etN8hGlKZxyBgHJ5qNo0Clg2cAfrQBOkW0lQTw2Mg4zzigQncBuIzk57enXNNQR7FJ4JBJyepzijyRyMnhiD6DHrSAfsYcl2B2g/mcdc0ph2qG3nv/kfnUbRhU3ZORjg8fhSxxo65LYoAmNuY0LBzxnge1RNEqk5k6ce9O8gbthb9eemelN8kNyM4xnPb8KAAEh2iZiQu78x/ qkkiUcp8nOM5x1HvQYYw2GYgZwSfpmoZU2Mqkk5GeaAJDDgL855xx OPxqAIWdlU8jP1NTNCipv3 uPTj0NO zKMZJyWA/TNACCEswUtkcgfh9aa0ZDImevTPGMmkhVZSdzEEdKkWFWAJJ6H8MdqAAQnJIJBHTtQYM8FjkEj16Y/wAaeIVIyHye/NVM0ASyxeWOCSOn9arHpinZppoAbSdOaWkpgGSetLk5zSUUCHgn1oOScmkopAFJS0lACGm0402gYlFFFMD/0cmiiigYUUUUAFLT4ozLIsQOCxxTxbynG3BBJGQRjimFiGirJtZArM5C7cHk9Q1J9lnzjb3x19s/yoCxXoqybVwN2Qfk38emcUSWk0cnlkckkD3x3pAVqWnSRPEQHGMjI lMpgOzS5o2NSBWJIAyRQIcrshypwaQknqaTa3pTSCODQAuaSkpKAFopKKAHUuaZS0AOzRmm0lIB2abRSUwCkoooAKWm0tADqKbRQIdSUlJQAtJRSUDCiiigD//0sqkpaKBiUUUUhksAZplVDtYng lTD7S2GV8jkZB496hgAMygkjnqOtTjDgFZCGweOemM0AO23ZbZv54HXg55FMjeZhLHuwSCWJ6nHbNKFk4zKQWxgf5OKb5Tq/DkMc5NAAFuCAob5dvHPGCf8RTwt3ub5jkEk89x1pkqyRDd5hOce3bNToC MO2Sobqc88GmBWw8yF3fhMDn3o zyDHrnH6ZzTo42CF0cgYJ/L6f1pqea3zB8c8kn27/WgQrRTLlmIA45z69KXyZVTzQeOc/gacFlOSXPAB/CmbXEjJuPyZyf5/nQAIsso Ujg496RoHwGyCdu7HfFSJFIB8jEE846fj1oWFmI c8j fbrTERtbOG25HLFRk9SKhWMs2Dxg4JPQfWp5HlTCbyf4vzquGKnKnFAEwtyeh4xnP6UixKJWjc52g9PUVH5j/wB4/nSbjndnk96ALLwJ/BnqB2I5FIbYgA7h/hzioCzMMMSQKQsxxknjp7UgHeWd5UHoeT264zUn2fPRhjBOfpxUIZgdwPNDMzfeJOPWgZN9n6YbOcdB6nFJLB5SZbrnHtUO5sYzxSZONueOuKBAVYAEjg1OtqzqGDDmq1KCRyDjFMCYwYO0sOmacLViQAcg4Ge3PSq5JPU5pctkHPSgRMLcnGD1GenviopE8tymc4oDMOhPpSEljljkmgBtJTqSmAlJS0UhiUUUUAf/08ukpaKBiUlOopDG8jkVPHAWxzgnpgdj3zUOKXnpmgCcRMsRkDEDGcD3OKdGqNENwJ6kjJ7Ee/vVbn1pBkdDigRa8jfKVyRyB6nmo2iCgsGztAx J/Soec5opgW4wm0N3ZTnPfnHrTRDtPykg5K8e3qarUuT69aALDIVUuHOeM9v8miKLeN4fB/rVcknqaSgC4YG3bC5GT39cZPGaaISTwT90HP9Peq6uyNuU4PrSFmPGeKALJt13bWfGDtyR7Z9ahki8tlUnqM n86jJJ6mkpiLLW6qm4t6/p6HvTvsuMZJ5IHT1Gaqe1GT60hk0MQlz82MfrTlgDY5PIJ6enaq1Lk4xmkBa zAjIYHHX2qpRRQMSiiigAooopiCloopiCiiigQUlLSUAJSU6koGJRS0UAf/9TLpaKKRQUUUtAh0cZlkWNerHHNO zy8YGc5GQRjiiEOZVEZw2eDUwa54Ktxz0xj3oAj yy4YsANuOp9elN zTZA2nJOPx6/wAqsf6WzFCecAYOOfSmpJOwlTOCRlifQdvSmBEbaQDccfd3cHPGcUSWs0cnlsOc4Hvj0p4FyQEB424HT7uf8adm8LE5O4Ek9OvegCrJG8RAcYyMimVOfMnQuzDCYHPHWk8iQYPfOMfhnNAEexvTrSbWJwByKnMc6klsDocnGOelL5cyJ5o6HOT6YNICvtb0NIQRwasIJpF THGM0jQyYDZB Xd9B9KYFeipzbyA7eOpUcjkiolRmbb05wSeAPrQIZRU4gY8gjGM57elCxDzWjc/dB6eooGQUVbeBf4M9cevWm/ZmxnI/wAOcUgK1FSeWd5Qdjgnt6VILdj0IIwTn6cUrjK9FWfs57MDnHTJ6nFNkhMSkv1zjFO4EFFOKsACQQDU62zsMgjmmBWpanMBBxuHTNOFs5IAIOccjpzQIrUVY8gnkEdM/hnFRumxyhOcUAR0lPxSYoAbSU6koAbRRRQB/9XMopuaM0ih1FNzRmgRPBzMoyRz1FWBlgCsmCQeM/ieKoBiDkcGpo4mOMNtY9B9R1 lAFj99xmQAnGAevsaj2SK/DfOwOfpSBJFi3hiABkCnIFaIbyx6kjPcEf40AJJ50a7t QcDj8xSqZ2wfMwzcgHqc00wNJKQWPUDnk89OhppR41JDnAwePegBUSRYywbaCMketS7Jg3MuMsR PSmIoaNRuPKnIzjoaYYjuzuO4sR I980CFDykt8/Cjn6A8cU4CRhkSdif6mo9hQeYj8jBOOoz606KFpBuDYJ/rSAmjjKABW Yn6dsimMjn5lfIOV gHX dIbdydrMce/sPr6U0RNkKrHgbvpn/AD2pgOkeZFUh8gkkEetRrHKD8pAJ4xnrnmpDCzNtaTvjn6ZqJlkj2puPzD f1oAfiUL5m8/dz74B/wDr1GFdvnzy fcn1qUwuI X45GPYc/TvSiB1AXeRuIGP1/pQMQxSNgFsgkAHt0pRDI4B39Og vSmRK8xJ3kFen405I2O0ByOCw46YpAR4ZB5m7ljx7juamEEkoBLZ9KDbOw3Fs4/T9aqhipypIxSGXFgYjbu6Y6emTTCqFVXcSCCeTjnOP6VW3NnOTkUhJPU5piLSwLjltxOMY6ckikKFF3xvwBnGeQc1W3NjGeKcXdhhiTTACS33jmnbm4OTxjH4dKjpaAJA7joT6f1ppJYlmOSaSigYUlFFACGm0pptMQlJS0lAj/1sjNGabRQMdmikooAWnB3AwCR NEcbSyLGnVjgU4wTAgbTz0/CgQzc2MZOOnWgMw6EipRbTEMduNuM59 lN8ibIGw5Jx NAyPcwO4Hn1pMn86nNtMoyRxt3fhnFI9tNG/lsvOcfX6UAQ89PSnbn5GTz1560rxvGQHGM8imUCHlmYYYk/jTaXafSjBpDHK7q28Hn1PNG98YyQPTPFNwaKAsBLN1OaCSepzSUtAByRgngU7c56sfXrTaKYAOKfufGMnHXrTKWlYBQSOhxSUUUWAKSikosAtFJSUwHUtMooAfmjNMopAOzSUlJTAWkopKACkpaKBH//18einUUANxS4paXFAD4BJ5yeUcNng 9Th7oY24A56Yxnv NRwDMy4O054NWAHKgo4Gc8cfjwB7UhXGlrxyY2AOQAQQOe4pI5bhxKg 8wyxPHA447Cnj7QcHeMnGB39uMVGElVzhhuYHI9u/tQFxoNzjYOm3Hb7ufX61JvvWYseWUnrjIPekfz413bgQcDjp6ipQzkrhzlhnOO569qYysfOuE3MQRHgdh1pnkSAZxznGPwzU6oY4zuOMkcEYGOcHkVIqyb8mTjJ ucf4CmBVMUwPIx0POMc9KXypVXzMcHOT6YNWJS2zcGJAA4IBHqO3vUIM5Gd2BgnnGME8/rQMYiyuCUHA4JoaGTAbqCu7j0qaOOZPukKd2OfWog0jZbdwBtJ9j2pDENvKDjHcj6kUxUZm2j1xzxVsmfaDnoS2ccg9 3FMEMilvmHvnv ntQBF5DnuMYzntSrEPMaNzjaD09qVnlRtpbkcf1qPc24vnk5z PWgRO9uBjYSeccj opv2d8ZyP88Uwu7DBNBkc4yTx0piuN2NuKDqDj2qQW8hPGD7/TimBmBLA8nrQzs2MnpRYVxxt39R2/U4pHhMaksec4xSb3AwD/nrSM7su1iSAc80DuRlSBkiphbSMMjFRHJ4NOWSRMbWIxSGOMDg4yM4zSi2kLBRgk46cjnpzUbMzcsc0vmScfMeMY/DpQOwvkN1BHTP4ZxTHQxsUPUelPEjjoe2P601iXYs3JPWkOxHijFPxSYoCw3FGKdiimKw3FGKdSUCP//QyaWiigApaKKRLHAlTkcEVKkbHkEKT0Hc5FQ08PIOASMUhEwSRY9 7gDIB/pT0AeMF2Y9T17g/wD16rbn27cnHTFIGdehI/8Ar0AWGheSQgseoGW/SmMkkYLbugH4gmogzht4Jz6035uR60xloJ5iAkkkjJ/A4pojdeFbGWIA9xVf5iAPSn75ORk89aoZIyvszvBAA4H6Zp0UUjLlG49PeoSzsMMSaQZHSmK5aEc4OAxHOc Mmo1jdThG5xk/SmCSQNv6n35o8yTGASB6UBcm8qRj5e8dcfpmonEikKWzv5496YzO33iTnmkYs3LEntzQO5O0DkF2bJ5z68Un2ZuMkAk4/OoSWICknA6Cnb5D1Y tIY6KIy52kDFKsO7HzDkE/gKiG4cjinb5MYycdaZJL9mfGciq1OBcdCRSYNMQlJS4NGDSGhKSnYNJg0i0JS0YNGDUloKKXBowaRQlFLg0mDTBiUUuDRg0yGNopcGjBoJP//RyqKKKACiiigBaKSikKwtFFFAWCiiimOwUUUUwsFLSUUCsLRSUUwsFTKkZGWaoaKQWJ8QDuTRshPRsVBRQMewCnAOabSUUALRSUUXCwUUUUAFJS0lAwooopDuLRSUUDuLSUUUBcKKKKBBRRRQI//Z', 44.984475, 0.989097, 'Open For All', 0, '015554495684', 0, '7 Days/tk.500', 1, '', '2016-02-09 11:36:22', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0);

Thursday, April 7, 2016

Create a simple API

http://dilir.me/kohana/api/index/916

<?php defined('SYSPATH') or die('No direct script access.');

class Controller_Api extends Controller {

public function action_index()
{
$secretkey=$this->request->param('id');
//url-> http://dilir.me/kohana/api/index/916
if(isset($secretkey) && $secretkey==='916'){
$data= json_encode(array(
"status" => true,
"name" => "Dilir",
"mail" => "dilir.khan@example.com",
"quote" =>"Try Simple Solution First"
));

}else{
$data=json_encode(array(
"status" => false
));
}

header('Content-Type: application/json');
echo $data;
}
}

ORM Query with expression and Keeping the name of the table as singular

http://localhost/kohana/index.php/guide/database/query/builder#aggregate-functions

Table Schema
============
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE IF NOT EXISTS `example` (
`Name` varchar(100) NOT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

INSERT INTO `example` (`Name`, `id`) VALUES
('Robeul', 26),
('Asma', 27),
('Joy', 28),
('Tanvir', 29),
('Dilir', 48);

ALTER TABLE `example`
ADD PRIMARY KEY (`id`);
ALTER TABLE `example`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=49;

----------------

Model

=====

<?php defined('SYSPATH') or die('No Direct Access');

class Model_Example extends ORM

{

protected $_table_name = 'example';

}

Controller

==========

public function action_getMax()

{

$exampleTable=ORM::factory('example');

$m=$exampleTable->select(array(DB::expr('MAX(id)'), 'max_id'))->find();

echo $m->max_id;

}

Output: 48

Note:

Generally, if the name of the model class is 'Model_Example', there needs to be a table named 'examples' in your database. But, since we chose to name the table as 'example' (we skipped the 's'), we need to make a declaration: protected $_table_name = 'example';

Thursday, March 31, 2016

MySQL Trigger

CREATE TRIGGER `posttrigger` AFTER INSERT ON `posts`
FOR EACH ROW INSERT INTO posts2(postTitle, postBody) VALUES( NEW.postTitle,New.postBody)

Trigger is created on table posts. If data is inserted in posts, some other data (as defined in the trigger) is inserted in 'posts2' table;

Tuesday, March 29, 2016

error 1

ErrorException [ Warning ]: Creating default object from empty value

Probably you are not using Controller_Template

Form Validation

Controller file:project/test.php
======================
url: localhost/project/test/login

public function action_login(){
if($this->request->method()=='POST'){
$validatedData=Validation::factory($_POST)
->rule('password','not_empty')
->rule('password','min_length', array(':value',6));
if($validatedData->check()){
$logged_in=$this->password=$this->request->post('password');
$this->response->body(View::factory('afterlogin'));
}else {
$err= $validatedData->errors('post'); //Capture errors
$user_input=$_POST; //capture user input because we are going to return to the login page retaining the user input
}
}
$this->response->body(View::factory('login')->bind('error',$err)->bind('user_input',$user_input));
}

view file: login.php

==============

<?= Arr::get($error,'Success')?>

<?= Form::open('test/login',array('method'=>'post')); ?>

<hr>

<p>

<?= Form::label('password','Type Password: ',array('class'=>'test')); ?>

<?= Form::input('password',$user_input['password'],array('class'=>'test','type'=>'password')); ?>

<?= Arr::get($error,'password'); ?>

<?= Form::input('submit',NULL,array('type'=>'submit')); ?>

<?= Form::close(); ?>

Miscellaneous

echo URL::base();

Echo in ternary operator

echo isset($logged_in) ? "You have successfully logged in with password <h1>$logged_in</h1>." : "Try Again" ;

Redirect

HTTP::redirect('test');

Here 'test' is the name of the controller.

Validation - min_length

->rule('password','min_length', array(':value',6));

Sunday, March 27, 2016

Kohana Join Query

public function action_joinquery()
{
$data=DB::select('posts.postTitle','posts.postBody','authors.author_name')
->from('posts')
->join('authors')->on('posts.authorId','=','authors.author_id')
->execute();
// echo Debug::dump( $q);
echo View::factory('database')>bind('data',$data);
}

Kohana Query

public function action_query2()
{ $q=DB::select()->from('posts')->execute(); echo Debug::dump( $q);
}

Saturday, March 26, 2016

Kohana config

create a file named whatever you like in Application/config folder with following code:

<?php defined('SYSPATH') or die('No direct script access.');
return array(
'name' => 'William',
'Quote' => "To be or not to be."
);

Create an action method (function) in the controller (test.php) like so:

public function action_configtest()
{
echo Kohana::$config->load('myconfig.name');
}

Hit the url: http://localhost/project/test/configtest. You should see 'William' on the screen.

Like get, you can set a config variable:
public function action_configtest()
{

Kohana::$config->load('myconfig')->set('einstein','e=mc^2');
echo Kohana::$config->load('myconfig')->get('einstein');
}

Hit the url: http://localhost/project/test/configtest. You should see 'e=mc^2' on the screen.

Friday, March 25, 2016

Connecting to database, run a query and view the result

Create a controller file named test.php in the application/classes/controller folder and type the following code:

<?php defined('SYSPATH') or die('No direct script access.');
class Controller_Test extends Controller_Template {

public function action_database()
{
$p = DB::select()->from('posts')->execute();
echo View::factory('database')->bind('data',$p);
}

}

Now we need to create a view file named database.php in the views folder. So, create the database.php file and paste the following code:

<!DOCTYPE html>
<html>
<head>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" integrity="sha256-7s5uDGW3AHqw6xtJmNNtr+OBRJUlgkNJEo78P4b0yRw= sha512-nNo+yCHEyn0smMxSswnf/OnX6/KwJuZTlNZBjauKhTK0c+zT+q5JOCx0UFhXQ6rJR9jg6Es8gPuD2uZcYDLqSw==" crossorigin="anonymous">

<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.11/css/jquery.dataTables.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.0/jquery.min.js"></script>
<script type="text/javascript" src="//cdn.datatables.net/1.10.11/js/jquery.dataTables.min.js"></script>
<title><?php echo 'title' ;?></title>
<style type="text/css">
body{
background-color: #eee;
}
</style>
</head>
<body>

<div class="container">
<h2> Table Explorer </h2>
<h4>Pass me all data from a table and I shall show you all fields and its value.</h4>
<code>for example, following code was used in a Controller and then data passed to me:
<br>
$allUsers = DB::select()->from('users')->execute();
<br>
$this->response->body(View::factory('users')->bind('data',$allUsers));
</code>

<table id="mt" class="table table-responsive table-striped">
<?php
$i = 0;
$firstRow=$data[0];
?>
<thead>
<?php
foreach($firstRow as $key => $value):
echo "<th>". $key . "</th>";
endforeach;
?>
</thead>

<?php
foreach($data as $point):
echo "<tr>";
foreach($point as $key => $value):
echo "<td>". $value . "</td>";
endforeach ;
echo "</tr>";
endforeach ; ?>
</table>

</div>
</body>
<style type="text/css">

table{
margin-top: 5%;
background-color: #ddd;
border-radius:2px;
}

</style>

<script>
$(document).ready(function(){
$('#mt').DataTable();
// alert('Google');
});

</script>
</html>

Thursday, March 24, 2016

Creating a Kohana Module

Creating a Kohana module is simple. In this post we shall create a very basic Kohana 3 module, activate it and use it.

Let's say the name of our module is "Olive".

1. Create a folder named 'olive' in the modules folder.
2. Create a folder named 'classes' in 'olive' folder.
3. Create a file named olive.php in the classes folder.

Type the following code in 'olive.php' file:

<?php defined('SYSPATH') or die('No direct script access.');

class Olive {
function index()
{
echo "Hello from Olive Module";
}

static function pickle()
{
return "We have been making and serving Olive Pickles for the world since 1867";

}
static function oil()
{
return "We have been making and serving Olive Oil for the world since 1867";
}
}
?>

Kohana will look for olive.php file in modules/olive/classes folder.

Enable the Olive module in bootsrap.php file:

Now let's use the module in a controller. Create a file named OliveTest.php in application/classes/controller folder and type the following code in that file:

<?php defined('SYSPATH') or die('No direct script access.');
class Controller_OliveTest extends Controller_Template {

public function action_index()
{
echo "<h1>Welcome to Olive Module</h1>";
}

public function action_oil()
{
echo Olive::oil();
}

}

Point your browser to this url: http://localhost/project/olivetest/

You should see:

Welcome to Olive Module

Point your browser to this url: http://localhost/project/olivetest/oil

You should see:
We have been making and serving Olive Oil for the world since 1867

Further Experiment
------------------------
Now create a folder named 'controller' in the classes folder and copy the olive.php file in the controller folder. Add 'Controller_' before 'olive; in the class declaration file so that it looks like this: class Controller_Olive {

Point to url: http://localhost/project/olivetest/oil

You should get a Fatal error:

ErrorException [ Fatal Error ]: Class 'Olive' not found

That is because name of the class is now Controller_Olive. But, in the controller file named test.php, you are calling the controller as 'Olive'. We need to correct this. Go to test.php and edit the action_oil function like so:

public function action_oil()
{
echo Controller_Olive::oil();
}

Point to url: http://localhost/project/olivetest/oil. Everything should be okay.

Tuesday, March 22, 2016

Run MYSQL and import Large Data.

Windows 7
==========
Go to DOS prompt by typing cmd on Windows Start menu

cd C:\xampp\mysql\bin>
mysql

show databases
you are not logged in a administrator. to do so type \q

mysql -u root
show databases

use babycard
source E:\Babytika\windmill_babycard-app.sql

Monday, March 21, 2016

Kohana : PHP to PDF

public function action_PdfDownload()
{
$pdf=new FPDF();
$pdf->AddPage();
$pdf->SetFont('Arial','B',16);
$pdf->Cell(40,10,'Hello World!');
$pdf->Output();

}

Kohana - Change Header

$this->response->headers('Content-Type', 'application/pdf');

PHPMailer

public function action_email()
   {
                //Download this PHPMailer module from https://github.com/PHPMailer/PHPMailer

                // mail send process start

                require DOCROOT."modules/PHPMailer/PHPMailerAutoload.php";

                $mail = new PHPMailer;
                $mail->isSMTP();                                   // Set mailer to use SMTP
                $mail->Host = 'dilir.me'; // Specify main and backup SMTP servers
                $mail->SMTPAuth = true;                            // Enable SMTP authentication
                $mail->Username = 'info@dilir.me';                 // SMTP username
                $mail->Password = '***';                  // SMTP password
                $mail->SMTPSecure = '';                            // Enable TLS encryption, `ssl` also accepted
                $mail->Port = 25;                                  // TCP port to connect to

                $mail->setFrom('info@dilir.me', 'Mailer');
                $mail->addAddress('dilir.khan@gmail.com', 'Dilir');     // Add a recipient
                $mail->addReplyTo(dilir.khan@gmail.com', 'Dilir');
                $mail->addCC('cc@example.com');
                //$mail->addBCC('bcc@example.com');

                $mail->addAttachment(DOCROOT . 'documents/title.pdf'); // Add attachments
                $mail->isHTML(true);                                  // Set email format to HTML

                $mail->Subject = 'PHP Mailer Implementation';
                $mail->Body    = 'Yes, I was able to send email using PHPMailer again. Check attachment.';
                $mail->AltBody = 'Yes, I was able to send email using PHPMailer again. Check attachment.';

                if(!$mail->send()) {
                    echo 'Message could not be sent.';
                    echo 'Mailer Error: ' . $mail->ErrorInfo;
                } else {
                    echo 'Message has been sent. Check attachment.';
                }


                // mail sent process end

   }