/** * Automatically executed before the widget action. Can be used to set * class properties, do authorization checks, and execute other custom code. * * @return void */ public function before() { // get all categories if ($this->advanced != FALSE) { $this->cat_items = Model_Category::get_as_array(); $this->cat_order_items = Model_Category::get_multidimensional(); $this->selected_category = NULL; if (core::request('category')) { $this->selected_category = core::request('category'); } elseif (Model_Category::current()->loaded()) { $this->selected_category = core::config('general.search_multi_catloc') ? array(Model_Category::current()->seoname) : Model_Category::current()->seoname; } // get all locations $this->loc_items = Model_Location::get_as_array(); $this->loc_order_items = Model_Location::get_multidimensional(); $this->selected_location = NULL; if (core::request('location')) { $this->selected_location = core::request('location'); } elseif (Model_Location::current()->loaded()) { $this->selected_location = core::config('general.search_multi_catloc') ? array(Model_Location::current()->seoname) : Model_Location::current()->seoname; } } if ($this->custom != FALSE) { $fields = Model_Field::get_all(); $this->custom_fields = $fields; } }
public function action_create() { try { if (!Valid::email(core::request('email'))) { $this->_error(__('Invalid email'), 501); } elseif (!is_numeric(core::request('id_product'))) { $this->_error(__('Invalid product'), 501); } else { $product = new Model_Product(core::request('id_product')); if ($product->loaded()) { $user = Model_User::create_email(core::request('email'), core::request('name')); $order = Model_Order::new_order($user, $product); $order->confirm_payment(core::request('paymethod', 'API'), core::request('txn_id'), core::request('pay_date'), core::request('amount'), core::request('currency'), core::request('fee')); //adding the notes $order->notes = core::request('notes'); $order->save(); $this->rest_output(array('order' => self::get_order_array($order))); } else { $this->_error(__('Something went wrong'), 501); } } } catch (Kohana_HTTP_Exception $khe) { $this->_error($khe); } }
/** * get the affiliate from the query or from the cookie * @return Model_Affiliate */ public static function get_affiliate() { $id_affiliate = core::request('aff', Cookie::get(self::$_cookie_name)); $affiliate = new Model_User(); if (Core::config('affiliate.active') == 1 and is_numeric($id_affiliate) and Theme::get('premium') == 1) { $affiliate = new Model_User($id_affiliate); //the user exists so we set again the cookie, just in case it's a different user or to renew it if ($affiliate->loaded()) { Cookie::set(self::$_cookie_name, $id_affiliate, time() + 24 * 60 * 60 * Core::config('affiliate.cookie')); } } return $affiliate; }
function lili_search($item, $key, $cats) { ?> <?php if (count($item) == 0 and $cats[$key]['id_category_parent'] != 1) { ?> <option value="<?php echo $cats[$key]['seoname']; ?> " data-id="<?php echo $cats[$key]['id']; ?> " <?php echo core::request('category') == $cats[$key]['seoname'] ? "selected" : ''; ?> ><?php echo $cats[$key]['name']; ?> </option> <?php } ?> <?php if ($cats[$key]['id_category_parent'] == 1 or count($item) > 0) { ?> <option value="<?php echo $cats[$key]['seoname']; ?> " <?php echo core::request('category') == $cats[$key]['seoname'] ? "selected" : ''; ?> > <?php echo $cats[$key]['name']; ?> </option> <optgroup label="<?php echo $cats[$key]['name']; ?> "> <?php if (is_array($item)) { array_walk($item, 'lili_search', $cats); } ?> </optgroup> <?php } ?> <?php }
/** * * Loads a basic list info * @param string $view template to render */ public function action_index($view = NULL) { $this->template->title = __('Orders'); $this->template->styles = array('//cdn.jsdelivr.net/bootstrap.datepicker/0.1/css/datepicker.css' => 'screen'); $this->template->scripts['footer'] = array('//cdn.jsdelivr.net/bootstrap.datepicker/0.1/js/bootstrap-datepicker.js', 'js/oc-panel/crud/index.js', 'js/oc-panel/stats/dashboard.js'); $orders = new Model_Order(); $orders = $orders->where('status', '=', Model_Order::STATUS_PAID); //filter email if (core::request('email') !== NULL) { $user = new Model_User(); $user->where('email', '=', core::request('email'))->limit(1)->find(); if ($user->loaded()) { $orders = $orders->where('id_user', '=', $user->id_user); } } //filter date if (!empty(Core::request('from_date')) and !empty(Core::request('to_date'))) { //Getting the dates range $from_date = Core::request('from_date', strtotime('-1 month')); $to_date = Core::request('to_date', time()); $orders = $orders->where('pay_date', 'between', array($from_date, $to_date)); } //filter coupon if (is_numeric(core::request('id_coupon'))) { $orders = $orders->where('id_coupon', '=', core::request('id_coupon')); } //filter product if (is_numeric(core::request('id_product'))) { $orders = $orders->where('id_product', '=', core::request('id_product')); } //filter status if (is_numeric(core::request('status'))) { $orders = $orders->where('status', '=', core::request('status')); } //order by paid if we are filtering paid.... if (core::request('status') == Model_Order::STATUS_PAID) { $orders->order_by('pay_date', 'desc'); } else { $orders->order_by('id_order', 'desc'); } $items_per_page = core::request('items_per_page', 10); $pagination = Pagination::factory(array('view' => 'oc-panel/crud/pagination', 'total_items' => $orders->count_all(), 'items_per_page' => $items_per_page))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action())); $pagination->title($this->template->title); $orders = $orders->limit($items_per_page)->offset($pagination->offset)->find_all(); $pagination = $pagination->render(); $products = new Model_Product(); $products = $products->find_all(); $this->render('oc-panel/pages/order/index', array('orders' => $orders, 'pagination' => $pagination, 'products' => $products)); }
/** * Handle GET requests. */ public function action_get() { try { if (($coupon_name = $this->request->param('id')) != NULL) { $coupon = new Model_Coupon(); $coupon->where('name', '=', $coupon_name)->where('number_coupons', '>', 0)->where('valid_date', '>', Date::unix2mysql())->where('status', '=', 1); //filter by product if (is_numeric(core::request('id_product'))) { $coupon->where('id_product', '=', core::request('id_product')); } $coupon = $coupon->limit(1)->find(); $this->rest_output(array('coupon' => $coupon->loaded() ? $coupon->as_array() : FALSE)); } else { $this->_error('You need to specify a coupon'); } } catch (Kohana_HTTP_Exception $khe) { $this->_error($khe); } }
function lolo($item, $key, $locs) { ?> <?php if (core::config('general.search_multi_catloc')) { ?> <option value="<?php echo $locs[$key]['seoname']; ?> " <?php echo (is_array(core::request('location')) and in_array($locs[$key]['seoname'], core::request('location'))) ? "selected" : ''; ?> ><?php echo $locs[$key]['name']; ?> </option> <?php } else { ?> <option value="<?php echo $locs[$key]['seoname']; ?> " <?php echo core::request('location') == $locs[$key]['seoname'] ? "selected" : ''; ?> ><?php echo $locs[$key]['name']; ?> </option> <?php } ?> <?php if (count($item) > 0) { ?> <optgroup label="<?php echo $locs[$key]['name']; ?> "> <?php if (is_array($item)) { array_walk($item, 'lolo', $locs); } ?> </optgroup> <?php } ?> <?php }
/** * verifies pricing in an existing order * @return void */ public function check_pricing() { //update order based on the price and the amount of $days = core::get('featured_days'); if (is_numeric($days) and ($price = Model_Order::get_featured_price($days)) !== FALSE) { $this->amount = $price; //get price from config $this->featured_days = $days; $this->save(); } //original coupon so we dont lose it while we do operations $orig_coupon = $this->id_coupon; //remove the coupon forced by get/post if (core::request('coupon_delete') != NULL) { $this->id_coupon = NULL; } elseif (Model_Coupon::valid($this->id_product) and $this->id_coupon != Model_Coupon::current()->id_coupon) { $this->id_coupon = Model_Coupon::current()->id_coupon; } elseif ($this->coupon->loaded() and (Date::mysql2unix($this->coupon->valid_date) < time() or $this->coupon->status == 0 or $this->coupon->number_coupons == 0)) { Alert::set(Alert::INFO, __('Coupon not valid, expired or already used.')); $this->coupon->clear(); $this->id_coupon = NULL; } //add new discount $new_amount = Model_Coupon::price($this->id_product, $this->original_price()); //recalculate price since it change the coupon if ($orig_coupon != $this->id_coupon or $this->amount != $new_amount) { $this->amount = $new_amount; try { $this->save(); } catch (Exception $e) { throw HTTP_Exception::factory(500, $e->getMessage()); } } }
/** * installs the software * @return [type] [description] */ public static function execute() { $error_msg = ''; $install = TRUE; $TABLE_PREFIX = ''; /////////////////////////////////////////////////////// //check DB connection $link = @mysqli_connect(core::request('DB_HOST'), core::request('DB_USER'), core::request('DB_PASS')); if (!$link) { $error_msg = __('Cannot connect to server') . ' ' . core::request('DB_HOST'); $install = FALSE; } if ($link and $install === TRUE) { if (core::request('DB_NAME')) { //they selected to create the DB if (core::request('DB_CREATE')) { @mysqli_query($link, "CREATE DATABASE IF NOT EXISTS `" . core::request('DB_NAME') . "`"); } $dbcheck = @mysqli_select_db($link, core::request('DB_NAME')); if (!$dbcheck) { $error_msg .= __('Database name') . ': ' . mysqli_error($link); $install = FALSE; } } else { $error_msg .= '<p>' . __('No database name was given') . '. ' . __('Available databases') . ':</p>'; $db_list = @mysqli_query($link, 'SHOW DATABASES'); $error_msg .= '<pre>'; if (!$db_list) { $error_msg .= __('Invalid query') . ':<br>' . mysqli_error($link); } else { while ($row = mysqli_fetch_assoc($db_list)) { $error_msg .= $row['Database'] . '<br>'; } } $error_msg .= '</pre>'; $install = FALSE; } } //clean prefix $TABLE_PREFIX = core::slug(core::request('TABLE_PREFIX')); //save DB config/database.php if ($install === TRUE) { $_POST['TABLE_PREFIX'] = $TABLE_PREFIX; $_GET['TABLE_PREFIX'] = $TABLE_PREFIX; $search = array('[DB_HOST]', '[DB_USER]', '[DB_PASS]', '[DB_NAME]', '[TABLE_PREFIX]', '[DB_CHARSET]'); $replace = array(core::request('DB_HOST'), core::request('DB_USER'), core::request('DB_PASS'), core::request('DB_NAME'), $TABLE_PREFIX, core::request('DB_CHARSET')); $install = install::replace_file(INSTALLROOT . 'samples/database.php', $search, $replace, APPPATH . 'config/database.php'); if (!$install === TRUE) { $error_msg = __('Problem saving ' . APPPATH . 'config/database.php'); } } //install DB if ($install === TRUE) { //check if has key is posted if not generate self::$hash_key = core::request('HASH_KEY') != '' ? core::request('HASH_KEY') : core::generate_password(); //check if DB was already installed, I use content since is the last table to be created $installed = mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '" . $TABLE_PREFIX . "content'")) == 1 ? TRUE : FALSE; if ($installed === FALSE) { //if was installed do not launch the SQL. include INSTALLROOT . 'samples/install.sql' . EXT; } } /////////////////////////////////////////////////////// //AUTH config if ($install === TRUE) { $search = array('[HASH_KEY]', '[COOKIE_SALT]', '[QL_KEY]'); $replace = array(self::$hash_key, self::$hash_key, self::$hash_key); $install = install::replace_file(INSTALLROOT . 'samples/auth.php', $search, $replace, APPPATH . 'config/auth.php'); if (!$install === TRUE) { $error_msg = __('Problem saving ' . APPPATH . 'config/auth.php'); } } /////////////////////////////////////////////////////// //create robots.txt if ($install === TRUE) { $search = array('[SITE_URL]', '[SITE_FOLDER]'); $replace = array(core::request('SITE_URL'), core::request('SITE_FOLDER')); $install = install::replace_file(INSTALLROOT . 'samples/robots.txt', $search, $replace, DOCROOT . 'robots.txt'); if (!$install === TRUE) { $error_msg = __('Problem saving ' . DOCROOT . 'robots.txt'); } } /////////////////////////////////////////////////////// //create htaccess if ($install === TRUE) { $search = array('[SITE_FOLDER]'); $replace = array(core::request('SITE_FOLDER')); $install = install::replace_file(INSTALLROOT . 'samples/example.htaccess', $search, $replace, DOCROOT . '.htaccess'); if (!$install === TRUE) { $error_msg = __('Problem saving ' . DOCROOT . '.htaccess'); } } /////////////////////////////////////////////////////// //all good! if ($install === TRUE) { core::delete(INSTALLROOT . 'install.lock'); //core::delete(INSTALLROOT);//prevents from performing a new install } elseif ($link != FALSE) { if ($table_list = mysqli_query($link, "SHOW TABLES LIKE '" . $TABLE_PREFIX . "%'")) { while ($row = mysqli_fetch_assoc($table_list)) { mysqli_query($link, "DROP TABLE " . $row[0]); } } } self::$error_msg = $error_msg; return $install; }
<div class="col-sm-12"> <?php echo FORM::label('latitude', __('Latitude'), array('class' => 'control-label', 'for' => 'latitude')); ?> <?php echo FORM::input('latitude', core::request('latitude'), array('placeholder' => __('Longitude'), 'class' => 'form-control', 'id' => 'latitude')); ?> </div> </div> <div class="form-group"> <div class="col-sm-12"> <?php echo FORM::label('longitude', __('Longitude'), array('class' => 'control-label', 'for' => 'longitude')); ?> <?php echo FORM::input('longitude', core::request('longitude'), array('placeholder' => __('Longitude'), 'class' => 'form-control', 'id' => 'longitude')); ?> </div> </div> <div class="form-group"> <div class="col-sm-12"> <?php echo FORM::button('submit', __('Create'), array('type' => 'submit', 'class' => 'btn btn-primary', 'action' => Route::url('oc-panel', array('controller' => 'location', 'action' => 'create')))); ?> </div> </div> </fieldset> <?php echo FORM::close(); ?> </div>
<option value="<?php echo $locs[$key]['seoname']; ?> " <?php echo (is_array(core::request('location')) and in_array($locs[$key]['seoname'], core::request('location'))) ? "selected" : ''; ?> ><?php echo $locs[$key]['name']; ?> </option> <?else:?> <option value="<?php echo $locs[$key]['seoname']; ?> " <?php echo core::request('location') == $locs[$key]['seoname'] ? "selected" : ''; ?> ><?php echo $locs[$key]['name']; ?> </option> <?endif?> <?if (count($item)>0):?> <optgroup label="<?php echo $locs[$key]['name']; ?> "> <? if (is_array($item)) array_walk($item, 'lolo_search', $locs);?> </optgroup> <?endif?> <?}
echo __('Please now erase the folder'); ?> <code>/install/</code><br> <a class="btn btn-success btn-large" href="<?php echo core::request('SITE_URL'); ?> "><?php echo __('Go to Your Website'); ?> </a> <a class="btn btn-warning btn-large" href="<?php echo core::request('SITE_URL'); ?> oc-panel/home/">Admin</a> <?php if (core::request('ADMIN_EMAIL')) { ?> <span class="help-block">user: <?php echo core::request('ADMIN_EMAIL'); ?> pass: <?php echo core::request('ADMIN_PWD'); ?> </span> <?php } ?> </p> </div>
/** * gets data to the view and filters the ads * @param Model_Category $category * @param Model_Location $location * @return array */ public function list_logic($category = NULL, $location = NULL) { //user recognition $user = Auth::instance()->get_user() == NULL ? NULL : Auth::instance()->get_user(); $ads = new Model_Ad(); //filter by category or location if ($category !== NULL) { $ads->where('id_category', 'in', $category->get_siblings_ids()); } if ($location !== NULL) { $ads->where('id_location', 'in', $location->get_siblings_ids()); } //only published ads $ads->where('status', '=', Model_Ad::STATUS_PUBLISHED); //if ad have passed expiration time dont show if (core::config('advertisement.expire_date') > 0) { $ads->where(DB::expr('DATE_ADD( published, INTERVAL ' . core::config('advertisement.expire_date') . ' DAY)'), '>', Date::unix2mysql()); } //if sort by distance if (core::request('sort') == 'distance' and Model_User::get_userlatlng()) { $ads->select(array(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 69.172'), 'distance'))->where('latitude', 'IS NOT', NULL)->where('longitude', 'IS NOT', NULL); } // featured ads $featured = NULL; if (Theme::get('listing_slider') == 2) { $featured = clone $ads; $featured = $featured->where('featured', '>=', Date::unix2mysql())->order_by('featured', 'desc')->limit(Theme::get('num_home_latest_ads', 4))->find_all(); } elseif (Theme::get('listing_slider') == 3) { $featured = clone $ads; $featured = $featured->where('featured', '>=', Date::unix2mysql())->order_by(DB::expr('RAND()'))->limit(Theme::get('num_home_latest_ads', 4))->find_all(); } $res_count = clone $ads; $res_count = $res_count->count_all(); // check if there are some advet.-s if ($res_count > 0) { // pagination module $pagination = Pagination::factory(array('view' => 'pagination', 'total_items' => $res_count, 'items_per_page' => core::config('advertisement.advertisements_per_page')))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action(), 'category' => $category !== NULL ? $category->seoname : NULL, 'location' => $location !== NULL ? $location->seoname : NULL)); Breadcrumbs::add(Breadcrumb::factory()->set_title(__("Page ") . $pagination->current_page)); /** * order depending on the sort parameter */ switch (core::request('sort', core::config('advertisement.sort_by'))) { //title z->a case 'title-asc': $ads->order_by('title', 'asc')->order_by('published', 'desc'); break; //title a->z //title a->z case 'title-desc': $ads->order_by('title', 'desc')->order_by('published', 'desc'); break; //cheaper first //cheaper first case 'price-asc': $ads->order_by('price', 'asc')->order_by('published', 'desc'); break; //expensive first //expensive first case 'price-desc': $ads->order_by('price', 'desc')->order_by('published', 'desc'); break; //featured //featured case 'featured': $ads->order_by('featured', 'desc')->order_by('published', 'desc'); break; //rating //rating case 'rating': $ads->order_by('rate', 'desc')->order_by('published', 'desc'); break; //distance //distance case 'distance': if (Model_User::get_userlatlng()) { $ads->order_by('distance', 'asc')->order_by('published', 'asc'); } break; //oldest first //oldest first case 'published-asc': $ads->order_by('published', 'asc'); break; //newest first //newest first case 'published-desc': default: $ads->order_by('published', 'desc'); break; } //we sort all ads with few parameters $ads = $ads->limit($pagination->items_per_page)->offset($pagination->offset)->find_all(); } else { // array of categories sorted for view return array('ads' => NULL, 'pagination' => NULL, 'user' => $user, 'category' => $category, 'location' => $location, 'featured' => NULL); } // array of categories sorted for view return array('ads' => $ads, 'pagination' => $pagination, 'user' => $user, 'category' => $category, 'location' => $location, 'featured' => $featured); }
<?php } elseif ($values == 'INPUT') { ?> <div class="form-group"> <div class="input-group"> <input type="text" class="form-control" id="filter__<?php echo $field_name; ?> " name="filter__<?php echo $field_name; ?> " placeholder="<?php echo isset($captions[$field_name]) ? $captions[$field_name]['model'] . ' ' . $captions[$field_name]['caption'] : $field_name; ?> " value="<?php echo core::request('filter__' . $field_name); ?> " > </div> </div> <?php } ?> <?php } ?> <button type="submit" class="btn btn-primary btn-icon-left"><?php echo __('Filter'); ?> </button> </form>
public function action_listing() { if (Theme::get('infinite_scroll')) { $this->template->scripts['footer'][] = '//cdn.jsdelivr.net/jquery.infinitescroll/2.0b2/jquery.infinitescroll.js'; $this->template->scripts['footer'][] = 'js/listing.js'; } $this->template->scripts['footer'][] = 'js/sort.js'; Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Home'))->set_url(Route::url('default'))); /** * we get the model of category from controller to filter and generate urls titles etc... */ $category = NULL; $category_parent = NULL; if (Model_Category::current()->loaded()) { $category = Model_Category::current(); //adding the category parent if ($category->id_category_parent != 1 and $category->parent->loaded()) { $category_parent = $category->parent; } } //base title if ($category !== NULL) { //category image if (($icon_src = $category->get_icon()) !== FALSE) { Controller::$image = $icon_src; } $this->template->title = $category->name; if ($category->description != '') { $this->template->meta_description = $category->description; } else { $this->template->meta_description = $category->name . ' ' . __('sold in') . ' ' . Core::config('general.site_name'); } } else { $this->template->title = __('all'); $this->template->meta_description = __('List of all products in') . ' ' . Core::config('general.site_name'); } if ($category_parent !== NULL) { $this->template->title .= ' (' . $category_parent->name . ')'; Breadcrumbs::add(Breadcrumb::factory()->set_title($category_parent->name)->set_url(Route::url('list', array('category' => $category_parent->seoname)))); } if ($category !== NULL) { Breadcrumbs::add(Breadcrumb::factory()->set_title($category->name)->set_url(Route::url('list', array('category' => $category->seoname)))); } //user recognition $user = Auth::instance()->get_user() == NULL ? NULL : Auth::instance()->get_user(); $products = new Model_Product(); //filter by category if ($category !== NULL) { $products->where('id_category', 'in', $category->get_siblings_ids()); } //only published products $products->where('status', '=', Model_Product::STATUS_ACTIVE); $res_count = $products->count_all(); // check if there are some advet.-s if ($res_count > 0) { // pagination module $pagination = Pagination::factory(array('view' => 'pagination', 'total_items' => $res_count, 'items_per_page' => core::config('general.products_per_page')))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action(), 'category' => $category !== NULL ? $category->seoname : NULL)); Breadcrumbs::add(Breadcrumb::factory()->set_title(__("Page ") . $pagination->current_page)); /** * order depending on the sort parameter */ switch (core::request('sort', core::config('general.sort_by'))) { //title z->a case 'title-asc': $products->order_by('title', 'asc')->order_by('created', 'desc'); break; //title a->z //title a->z case 'title-desc': $products->order_by('title', 'desc')->order_by('created', 'desc'); break; //cheaper first //cheaper first case 'price-asc': $products->order_by('price', 'asc')->order_by('created', 'desc'); break; //expensive first //expensive first case 'price-desc': $products->order_by('price', 'desc')->order_by('created', 'desc'); break; //featured //featured case 'featured': default: $products->order_by('featured', 'desc')->order_by('created', 'desc'); break; //oldest first //oldest first case 'published-asc': $products->order_by('created', 'asc'); break; //newest first //newest first case 'published-desc': $products->order_by('created', 'desc'); break; } //we sort all products with few parameters $products = $products->limit($pagination->items_per_page)->offset($pagination->offset)->find_all(); // array of categories sorted for view $data = array('products' => $products, 'pagination' => $pagination, 'user' => $user, 'category' => $category); } else { // array of categories sorted for view $data = array('products' => NULL, 'pagination' => NULL, 'user' => $user, 'category' => $category); } $this->template->bind('content', $content); $this->template->content = View::factory('pages/product/listing', $data); }
/** * download theme from license key * @return [view] */ public function action_download() { // save only changed values if ($license = core::request('license')) { if (($theme = Theme::download($license)) != FALSE) { Alert::set(Alert::SUCCESS, __('Theme downloaded') . ' ' . $theme); $this->redirect(Route::url('oc-panel', array('controller' => 'theme', 'action' => 'license', 'id' => $theme)) . '?license=' . $license); } } Alert::set(Alert::ALERT, __('Theme could not be downloaded')); $this->redirect(Route::url('oc-panel', array('controller' => 'theme', 'action' => 'index'))); }
public function action_advanced_search() { if (Theme::get('infinite_scroll')) { $this->template->scripts['footer'][] = '//cdn.jsdelivr.net/jquery.infinitescroll/2.0b2/jquery.infinitescroll.js'; $this->template->scripts['footer'][] = 'js/listing.js'; } if (core::config('general.auto_locate') or core::config('advertisement.map')) { Theme::$scripts['async_defer'][] = '//maps.google.com/maps/api/js?libraries=geometry,places&v=3&key=' . core::config("advertisement.gm_api_key") . '&callback=initLocationsGMap'; } $this->template->scripts['footer'][] = 'js/jquery.toolbar.js'; $this->template->scripts['footer'][] = 'js/sort.js'; //template header $this->template->title = __('Advanced Search'); $this->template->meta_description = __('Search in') . ' ' . core::config('general.site_name'); //breadcrumbs Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Home'))->set_url(Route::url('default'))); Breadcrumbs::add(Breadcrumb::factory()->set_title($this->template->title)); $pagination = NULL; $ads = NULL; $res_count = NULL; $user = $this->user ? $this->user : NULL; if ($this->request->query()) { // variables $search_advert = core::get('title'); $search_loc = core::get('location'); // filter by each variable $ads = new Model_Ad(); //if sort by distance if ((core::request('sort', core::config('advertisement.sort_by')) == 'distance' or core::request('userpos') == 1) and Model_User::get_userlatlng()) { $ads->select(array(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 111.321'), 'distance'))->where('latitude', 'IS NOT', NULL)->where('longitude', 'IS NOT', NULL); } // early filter $ads = $ads->where('status', '=', Model_Ad::STATUS_PUBLISHED); //if ad have passed expiration time dont show if (core::config('advertisement.expire_date') > 0) { $ads->where(DB::expr('DATE_ADD( published, INTERVAL ' . core::config('advertisement.expire_date') . ' DAY)'), '>', Date::unix2mysql()); } if (core::request('userpos') == 1 and Model_User::get_userlatlng()) { if (is_numeric(Core::cookie('mydistance')) and Core::cookie('mydistance') <= 500) { $location_distance = Core::config('general.measurement') == 'imperial' ? Num::round(Core::cookie('mydistance') * 1.60934) : Core::cookie('mydistance'); } else { $location_distance = Core::config('general.measurement') == 'imperial' ? Num::round(Core::config('advertisement.auto_locate_distance') * 1.60934) : Core::config('advertisement.auto_locate_distance'); } $ads->where(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 111.321'), '<=', $location_distance); } if (!empty($search_advert) or core::get('search') !== NULL and strlen(core::get('search')) >= 3) { // if user is using search from header if (core::get('search')) { $search_advert = core::get('search'); } if (core::config('general.search_by_description') == TRUE) { $ads->where_open()->where('title', 'like', '%' . $search_advert . '%')->or_where('description', 'like', '%' . $search_advert . '%')->where_close(); } else { $ads->where('title', 'like', '%' . $search_advert . '%'); } } //cf filter arrays $cf_fields = array(); $cf_user_fields = array(); foreach ($this->request->query() as $name => $field) { if (isset($field) and $field != NULL) { // get by prefix cf if (strpos($name, 'cf_') !== FALSE and array_key_exists(str_replace('cf_', '', $name), Model_Field::get_all())) { $cf_fields[$name] = $field; //checkbox when selected return string 'on' as a value if ($field == 'on') { $cf_fields[$name] = 1; } elseif (empty($field)) { $cf_fields[$name] = NULL; } } elseif (strpos($name, 'cfuser_') !== FALSE and array_key_exists(str_replace('cfuser_', '', $name), Model_UserField::get_all())) { $name = str_replace('cfuser_', 'cf_', $name); $cf_user_fields[$name] = $field; //checkbox when selected return string 'on' as a value if ($field == 'on') { $cf_user_fields[$name] = 1; } elseif (empty($field)) { $cf_user_fields[$name] = NULL; } } } } $category = NULL; $location = NULL; if (core::config('general.search_multi_catloc') and Theme::$is_mobile === FALSE) { //filter by category if (is_array(core::get('category'))) { $cat_siblings_ids = array(); foreach (core::get('category') as $cat) { if ($cat !== NULL) { $category = new Model_Category(); $category->where('seoname', '=', $cat)->cached()->limit(1)->find(); if ($category->loaded()) { $cat_siblings_ids = array_merge($cat_siblings_ids, $category->get_siblings_ids()); } } } if (count($cat_siblings_ids) > 0) { $ads->where('id_category', 'IN', $cat_siblings_ids); } } //filter by location if (is_array(core::get('location'))) { $loc_siblings_ids = array(); foreach (core::get('location') as $loc) { if ($loc !== NULL) { $location = new Model_location(); $location->where('seoname', '=', $loc)->cached()->limit(1)->find(); if ($location->loaded()) { $loc_siblings_ids = array_merge($loc_siblings_ids, $location->get_siblings_ids()); } } } if (count($loc_siblings_ids) > 0) { $ads->where('id_location', 'IN', $loc_siblings_ids); } } } else { if (core::get('category') !== NULL) { $category = new Model_Category(); $category->where('seoname', is_array(core::get('category')) ? 'in' : '=', core::get('category'))->cached()->limit(1)->find(); if ($category->loaded()) { $ads->where('id_category', 'IN', $category->get_siblings_ids()); } } $location = NULL; //filter by location if (core::get('location') !== NULL) { $location = new Model_location(); $location->where('seoname', is_array(core::get('location')) ? 'in' : '=', core::get('location'))->cached()->limit(1)->find(); if ($location->loaded()) { $ads->where('id_location', 'IN', $location->get_siblings_ids()); } } } //filter by price(s) if (is_numeric($price_min = str_replace(',', '.', core::get('price-min')))) { // handle comma (,) used in some countries for prices $price_min = (double) $price_min; } // round((float)$price_min,2) if (is_numeric($price_max = str_replace(',', '.', core::get('price-max')))) { // handle comma (,) used in some countries for prices $price_max = (double) $price_max; } // round((float)$price_max,2) if (is_numeric($price_min) and is_numeric($price_max)) { // swap 2 values if ($price_min > $price_max) { $aux = $price_min; $price_min = $price_max; $price_max = $aux; unset($aux); } $ads->where('price', 'BETWEEN', array($price_min, $price_max)); } elseif (is_numeric($price_min)) { $ads->where('price', '>=', $price_min); } elseif (is_numeric($price_max)) { $ads->where('price', '<=', $price_max); } //filter by CF ads if (count($cf_fields) > 0) { foreach ($cf_fields as $key => $value) { //filter by range if (array_key_exists(str_replace('cf_', '', $key), Model_Field::get_all()) and Model_Field::get_all()[str_replace('cf_', '', $key)]['type'] == 'range') { $cf_min = isset($value[0]) ? $value[0] : NULL; $cf_max = isset($value[1]) ? $value[1] : NULL; if (is_numeric($cf_min = str_replace(',', '.', $cf_min))) { // handle comma (,) used in some countries $cf_min = (double) $cf_min; } if (is_numeric($cf_max = str_replace(',', '.', $cf_max))) { // handle comma (,) used in some countries $cf_max = (double) $cf_max; } if (is_numeric($cf_min) and is_numeric($cf_max)) { // swap 2 values if ($cf_min > $cf_max) { $aux = $cf_min; $cf_min = $cf_max; $cf_max = $aux; unset($aux); } $ads->where($key, 'BETWEEN', array($cf_min, $cf_max)); } elseif (is_numeric($cf_min)) { // only min cf has been provided $ads->where($key, '>=', $cf_min); } elseif (is_numeric($cf_max)) { // only max cf has been provided $ads->where($key, '<=', $cf_max); } } elseif (is_numeric($value)) { $ads->where($key, '=', $value); } elseif (is_string($value)) { $ads->where($key, 'like', '%' . $value . '%'); } elseif (is_array($value)) { if (!empty($value = array_filter($value))) { $ads->where($key, 'IN', $value); } } } } //filter by user if (count($cf_user_fields) > 0) { $users = new Model_User(); foreach ($cf_user_fields as $key => $value) { if (is_numeric($value)) { $users->where($key, '=', $value); } elseif (is_string($value)) { $users->where($key, 'like', '%' . $value . '%'); } elseif (is_array($value)) { if (!empty($value = array_filter($value))) { $ads->where($key, 'IN', $value); } } } $users = $users->find_all(); if ($users->count() > 0) { $ads->where('id_user', 'in', $users->as_array()); } else { $ads->where('id_user', '=', 0); } } // count them for pagination $res_count = $ads->count_all(); if ($res_count > 0) { // pagination module $pagination = Pagination::factory(array('view' => 'pagination', 'total_items' => $res_count, 'items_per_page' => core::config('advertisement.advertisements_per_page')))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action(), 'category' => $category !== NULL ? $category->seoname : NULL)); Breadcrumbs::add(Breadcrumb::factory()->set_title(__("Page ") . $pagination->offset)); /** * order depending on the sort parameter */ switch (core::request('sort', core::config('advertisement.sort_by'))) { //title z->a case 'title-asc': $ads->order_by('title', 'asc')->order_by('published', 'desc'); break; //title a->z //title a->z case 'title-desc': $ads->order_by('title', 'desc')->order_by('published', 'desc'); break; //cheaper first //cheaper first case 'price-asc': $ads->order_by('price', 'asc')->order_by('published', 'desc'); break; //expensive first //expensive first case 'price-desc': $ads->order_by('price', 'desc')->order_by('published', 'desc'); break; //featured //featured case 'featured': $ads->order_by('featured', 'desc')->order_by('published', 'desc'); break; //rating //rating case 'rating': $ads->order_by('rate', 'desc')->order_by('published', 'desc'); break; //favorited //favorited case 'favorited': $ads->order_by('favorited', 'desc')->order_by('published', 'desc'); break; //distance //distance case 'distance': if (Model_User::get_userlatlng() and core::config('general.auto_locate')) { $ads->order_by('distance', 'asc')->order_by('published', 'asc'); } break; //oldest first //oldest first case 'published-asc': $ads->order_by('published', 'asc'); break; //newest first //newest first case 'published-desc': default: $ads->order_by('published', 'desc'); break; } //we sort all ads with few parameters $ads = $ads->limit($pagination->items_per_page)->offset($pagination->offset)->find_all(); } else { $ads = NULL; } } $this->template->bind('content', $content); $this->template->content = View::factory('pages/ad/advanced_search', array('ads' => $ads, 'categories' => Model_Category::get_as_array(), 'order_categories' => Model_Category::get_multidimensional(), 'locations' => Model_Location::get_as_array(), 'order_locations' => Model_Location::get_multidimensional(), 'pagination' => $pagination, 'user' => $user, 'fields' => Model_Field::get_all(), 'total_ads' => $res_count)); }
/** * get the coupon from the query or from the sesion or the post in paypal * @return Model_Coupon or null if not found */ public static function get_coupon() { $coupon = new Model_Coupon(); /** * Deletes a coupon in use */ if (core::request('coupon_delete') != NULL) { Session::instance()->set('coupon', ''); Alert::set(Alert::INFO, __('Coupon deleted.')); } elseif (core::post('custom') != NULL or core::request('coupon') != NULL or Session::instance()->get('coupon') != '') { $slug_coupon = new Model_Coupon(); $coupon = $slug_coupon->where('name', '=', core::post('custom', core::request('coupon', Session::instance()->get('coupon'))))->where('number_coupons', '>', 0)->where('valid_date', '>', Date::unix2mysql())->where('status', '=', 1)->limit(1)->find(); if ($coupon->loaded()) { //only add it to session if its different than before if (Session::instance()->get('coupon') != $coupon->name) { Alert::set(Alert::SUCCESS, __('Coupon added!')); Session::instance()->set('coupon', $coupon->name); } } else { Alert::set(Alert::INFO, __('Coupon not valid, expired or already used.')); Session::instance()->set('coupon', ''); } } return $coupon; }
mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "content` (`id_content`, `locale`, `order`, `title`, `seotitle`, `description`, `from_email`, `created`, `type`, `status`)\n VALUES\n(30, 'ro_RO', 0, 'Anunțul dvs. `[AD.NAME]` a fost adăugat cu succes pe [SITE.NAME]!', 'ads-confirm', 'Bun venit, [USER.NAME].\n\nÎți mulțumim pentru adăugarea anunțului dvs. pe [SITE.NAME].\n\nTe rugăm să apeși un click pe acest link [URL.QL], pentru a confirma anunțul.\n\nToate cele bune!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:25:48', 'email', 1),\n(31, 'ro_RO', 0, 'Anunțul dvs. `[AD.NAME]` a fost adăugat pe [SITE.NAME].', 'ads-user-check', 'Bună [USER.NAME],\n\nAnunțul a fost adăugat în contul dvs. [USER.NAME]. Puteți vizita acest link pentru vizualizarea anunțului [URL.AD].\n\nDacă nu sunteți răspunzător pentru adăugarea acestui anunț, vă rugăm să ne contactați, folosind link-ul următor: [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:27:46', 'email', 1),\n(32, 'ro_RO', 0, 'Anunțul dvs. `[AD.NAME]` a fost adăugat cu succes pe [SITE.NAME]!', 'ads-notify', 'Bună [USER.NAME],\n\nVă mulțumim că folosii serviciul nostru de anunțuri, [SITE.NAME]\n\nPuteți edita anunțul dvs. aici: [URL.QL].\n\nAnunțul dvs. nu este publicat momentan, deoarece este necesară validarea lui de către un administrator. \nNe cerem scuze pentru eventualele neplăceri. Vom încerca să-l revizuim cât mai repede posibil.\n\nCu stimă.', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:30:59', 'email', 1),\n(33, 'ro_RO', 0, '[EMAIL.SENDER] dorește să ia legătura cu dvs.', 'contact-admin', 'Salut Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], are un mesaj pentru tine:\n\n[EMAIL.BODY]\n\nCu stimă.', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:32:57', 'email', 1),\n(34, 'ro_RO', 0, 'Anunțul dvs. pe [SITE.NAME] a fost activat!', 'ads-activated', 'Salutări [USER.OWNER],\n\nDorim să vă informăm că anunțul dvs. [URL.QL] a fost activat.\nAcum, el poate fi vizualizat de către toată lumea.\n\nSperăm că nu v-am făcut să așteptați prea mult timp.\n\nCu stimă.', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:35:35', 'email', 1),\n(36, 'ro_RO', 0, 'Bună [USER.NAME]!', 'user-contact', 'Ați fost contactat referitor la anunțul dvs. \n\nUtilizatorul [EMAIL.SENDER] [EMAIL.FROM], are un mesaj pentru dvs.:\n[EMAIL.BODY].\n\nCu stimă.', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:40:46', 'email', 1),\n(37, 'ro_RO', 0, 'Modificare parolă [SITE.NAME]', 'auth-remember', 'Salutare [USER.NAME],\n\nVizitează acest link: [URL.QL] \n\nMulțumim!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:41:59', 'email', 1),\n(38, 'ro_RO', 0, 'Bun venit pe [SITE.NAME]!', 'auth-register', 'Bun venit [USER.NAME],\n\nNe bucurăm că v-ați decis să vă alăturați echipei și serviciilor noastre! [URL.QL]\n\nIată detaliile contului dvs.:\nE-mail: [USER.EMAIL]\nParolă: [USER.PWD]\n\nDe acum, vă puteți autentifica folosind aceste date. (parola generată automat nu mai este valabilă).\n\nCu stimă!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:44:44', 'email', 1),\n\n(39, 'pl_PL', 0, 'Sukces! Twoje ogłoszenie `[AD.NAME]` zostało utworzone na [SITE.NAME]!', 'ads-confirm', 'Witaj [USER.NAME],\n\nDziękujemy za zamieszczenie ogłoszenia na [SITE.NAME]!\n\nKliknij na ten link [URL.QL] aby je zatwierdzić.\n\nMiłego dnia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:49:48', 'email', 1),\n(40, 'pl_PL', 0, 'Ogłoszenie utworzone na [SITE.NAME]!', 'ads-user-check', 'Witaj [USER.NAME],\n\nOgłoszenie zostało utworzone na Twoim koncie [USER.NAME]! Odwiedź ten link, aby zobaczyć ogłoszenie [URL.AD].\n\nJeśli to nie Ty utworzyłeś to ogłoszenie, kliknij na link, aby się z nami skontaktować [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:51:48', 'email', 1),\n(41, 'pl_PL', 0, 'Sukces! Twoje ogłoszenie `[AD.NAME]` zostało utworzone na [SITE.NAME]!', 'ads-notify', 'Witaj [USER.NAME],\n\nDziękujemy za zamieszczenie ogłoszenia na [SITE.NAME]!\n\nMożesz edytować swoje ogłoszenie tutaj [URL.QL].\n\nTwoje ogłoszenie jest wciąż nieopublikowane, najpierw musi być zatwierdzone przez administratora.\nPrzepraszamy za wszelkie niedogodności. Ogłoszenie zostanie zatwierdzone najszybciej jak to tylko możliwe.\n\nPozdrowienia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:53:51', 'email', 1),\n(42, 'pl_PL', 0, '[EMAIL.SENDER] chce się z Tobą skontaktować!', 'contact-admin', 'Drogi administratorze,\n\n[EMAIL.SENDER]: [EMAIL.FROM], ma dla Ciebie wiadomość:\n\n[EMAIL.BODY] \n\nPozdrowienia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:55:08', 'email', 1),\n(43, 'pl_PL', 0, 'Twoje ogłoszenie na [SITE.NAME] zostało aktywowane!', 'ads-activated', 'Witaj [USER.OWNER],\n\nInformujemy, że Twoje ogłoszenie [URL.QL] zostało aktywowane! Teraz może być widziane przez innych.\n\nMamy nadzieję, że nie musiałeś czekać długo.\n\nPozdrowienia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 10:56:23', 'email', 1),\n(45, 'pl_PL', 0, 'Witaj [USER.NAME]!', 'user-contact', 'Dostałeś/aś wiadomość związaną z Twoim ogłoszeniem. \n\nUżytkownik [EMAIL.SENDER] [EMAIL.FROM] ma dla Ciebie wiadomość:\n\n[EMAIL.BODY]. \n\nMiłego dnia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 11:00:12', 'email', 1),\n(46, 'pl_PL', 0, 'Zmień hasło [SITE.NAME]', 'auth-remember', 'Witaj [USER.NAME],\n\nKliknij na ten link [URL.QL]\n\nDziękujemy!!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 11:00:51', 'email', 1),\n(47, 'pl_PL', 0, 'Witamy na [SITE.NAME]!', 'auth-register', 'Witamy na [SITE.NAME].\n\nBardzo się cieszymy, że do nas dołączyłeś.\n\nZapamiętaj swoje dane logowania:\nEmail: [USER.EMAIL]\nHasło: [USER.PWD]\n\nNie posiadamy już Twojego poprzedniego hasła.\n\nPozdrowienia!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-29 11:03:08', 'email', 1),\n\n(48, 'ru_RU', 0, 'Готово! Ваше объявление `[AD.NAME]` размещено на [SITE.NAME]', 'ads-confirm', 'Здравствуйте, [USER.NAME],\n\nБлагодарим за публикацию объявления на [SITE.NAME]! \n\nДля подтверждения пройдите по ссылке [URL.QL].\n\nВсего доброго!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:08:43', 'email', 1),\n(49, 'ru_RU', 0, 'Объявление опубликовано на [SITE.NAME]!', 'ads-user-check', 'Здравствуйте, [USER.NAME],\n\nВ вашем аккаунте [USER.NAME] создано новое объявление! Посмотреть его вы можете, пройдя по ссылке [URL.AD]\n\nЕсли вы не создавали никакого объявления, сообщите нам, пройдя по этой ссылке [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:10:30', 'email', 1),\n(50, 'ru_RU', 0, 'Поздравляем! Ваше объявление опубликовано на [SITE.NAME]!', 'ads-notify', 'Здравствуйте, [USER.NAME],\n\nБлагодарим за публикацию объявления на [SITE.NAME]! \n\nРедактировать объявление вы можете здесь [URL.QL].\n\nВаше объявление будет опубликовано после проверки администратором. \nПриносим свои извинения за неудобства. Постараемся исправить как можно быстрее. \n\nВсего доброго!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:11:50', 'email', 1),\n(51, 'ru_RU', 0, '[EMAIL.SENDER] прислал сообщение!', 'contact-admin', 'Здравствуйте, Администратор!\n\n[EMAIL.SENDER]: [EMAIL.FROM], прислал для вас сообщение:\n\n[EMAIL.BODY]', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:12:56', 'email', 1),\n(52, 'ru_RU', 0, 'Ваше объявление на [SITE.NAME] опубликовано!', 'ads-activated', 'Здравствуйте, [USER.OWNER],\n\nСообщаем вам, что объявление на [URL.QL] опубликовано! Теперь его смогут увидеть другие. \n\nНадеемся, мы не заставили вас ждать слишком долго.\n\nУдачи!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:14:20', 'email', 1),\n(54, 'ru_RU', 0, 'Здравствуйте, [USER.NAME]!', 'user-contact', 'Это сообщение касается вашего объявления. \n\nПользователь [EMAIL.SENDER] [EMAIL.FROM] прислал сообщение: \n\n[EMAIL.BODY]. \n\nУдачи!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:16:48', 'email', 1),\n(55, 'ru_RU', 0, 'Изменить пароль на [SITE.NAME]', 'auth-remember', 'Здравствуйте, [USER.NAME]!\n\nПройдите по этой сылке [URL.QL]\n\nСпасибо!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:17:41', 'email', 1),\n(56, 'ru_RU', 0, 'Добро пожаловать на [SITE.NAME]!', 'auth-register', 'Добро пожаловать, [USER.NAME],\n\nРады, что вы к нам присоединились на [URL.QL]\n\nЗапомните ваши данные для входа:\nEmail: [USER.EMAIL]\nПароль: [USER.PWD]\n\nМы не сохраяем ваш первоначальный пароль.\n\nУдачи!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:18:35', 'email', 1),\n\n(57, 'cs_CZ', 0, 'Úspěch! Váš inzerát `[AD.NAME]` byl vytvořen na [SITE.NAME]!', 'ads-confirm', 'Vítejte [USER.NAME],\n\nDěkujeme za vytvoření inzerátu na [SITE.NAME]! \n\nPro potvrzení prosím klikněte na tento link [URL.QL]\n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:22:12', 'email', 1),\n(58, 'cs_CZ', 0, 'Inzerát je vytvořen na [SITE.NAME]!', 'ads-user-check', 'Dobrý den [USER.NAME],\n\nInzerát byl vytvořen pod Vaším účtem [USER.NAME]! Pro prohlédnutí inzerátu můžete kliknout na tento link [URL.AD]\n\nPokud jste inzerát nevytvořili Vy, prosím kontaktujte nás na [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:23:07', 'email', 1),\n(59, 'cs_CZ', 0, 'Úspěch! Váš inzerát `[AD.NAME]` byl vytvořen na [SITE.NAME]!', 'ads-notify', 'Dobrý den [USER.NAME],\n\nDěkujeme za zveřejnění inzerátu na [SITE.NAME]! \n\nVáš inzerát můžete upravit zde [URL.QL].\n\nVáš inzerát ještě není zveřejněn, potřebuje být schválen administrátorem.\nOmlouváme se za nepříjemností. Shlédneme ho, co nejdříve to bude možné.\n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:24:31', 'email', 1),\n(60, 'cs_CZ', 0, '[EMAIL.SENDER] Vás chce kontaktovat!', 'contact-admin', 'Dobrý den Admine,\n\n[EMAIL.SENDER]: [EMAIL.FROM], má pro Vás zprávu:\n\n[EMAIL.BODY] \n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:26:28', 'email', 1),\n(61, 'cs_CZ', 0, 'Váš inzerát na [SITE.NAME] byl aktivován!', 'ads-activated', 'Dobrý den [USER.OWNER],\n\nChceme Vás informovat, že Váš inzerát [URL.QL] byl aktivován!\nNyní si ho mohou prohlížet ostatní.\n\nDoufáme, že jste nečekali dlouho.\n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:27:36', 'email', 1),\n(63, 'cs_CZ', 0, 'Dobrý den [USER.NAME]!', 'user-contact', 'Byli jste kontaktování ohledně Vašeho inzerátu, uživatelem [EMAIL.SENDER] \n\n[EMAIL.FROM], má pro Vás tuto zprávu:\n\n[EMAIL.BODY]. \n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:30:08', 'email', 1),\n(64, 'cs_CZ', 0, 'Změna hesla [SITE.NAME]', 'auth-remember', 'Dobrý den [USER.NAME],\n\nKlikněte na tento link [URL.QL]\n\nDěkujeme!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:31:01', 'email', 1),\n(65, 'cs_CZ', 0, 'Vítejte na [SITE.NAME]!', 'auth-register', 'Vítejte [USER.NAME],\n\nJsme rádi, že jste se k nám připojili! [URL.QL]\n\nZapamatujte si Vaše přihlašovací údaje:\nEmail: [USER.EMAIL]\nHeslo: [USER.PWD]\n\nJiž nemáme Vaše původní heslo.\n\nPřejeme příjemný zbytek dne!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:32:10', 'email', 1),\n\n(75, 'da_DK', 0, 'Din annonce `[AD.NAME]` blev oprettet på [SITE.NAME]!', 'ads-confirm', 'Velkommen [USER.NAME],\n\nTak for din annonce på [SITE.NAME]!\n\nFølge dette link for at bekræfte annoncen.\n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:55:52', 'email', 1),\n(76, 'da_DK', 0, 'Annonce oprettet på [SITE.NAME]!', 'ads-user-check', 'Hej [USER.NAME],\n\nAnnoncen er oprettet under din profil [USER.NAME]! Du kan følge dette link for at se din annonce: [URL.AD]\n\nHvis det ikke er dig der har oprettet denne annonce, så kontakt os her: [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:56:56', 'email', 1),\n(77, 'da_DK', 0, 'Din annonce `[AD.NAME]` blev oprettet på [SITE.NAME]!', 'ads-notify', 'Hej [USER.NAME],\n\nTak for din annonce på [SITE.NAME]! \n\nDu kan redigere din annonce her [URL.QL].\n\nDin annonce er endnu ikke udgivet, da den skal valideres af en administrator. \n\nVi validerer annoncer så hurtigt vi kan, og undskylder på forhånd for ventetiden.\n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:58:35', 'email', 1),\n(78, 'da_DK', 0, '[EMAIL.SENDER] vil gerne i kontakt med dig', 'contact-admin', 'Hej Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], har skrevet en besked til dig:\n\n[EMAIL.BODY] \n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 08:59:54', 'email', 1),\n(79, 'da_DK', 0, 'Din annonce på [SITE.NAME] er blevet aktiveret!', 'ads-activated', 'Hej [USER.OWNER],\n\nDin annonce [URL.QL] er blevet aktiveret,\nden er nu synlig for alle!\n\nHeld og lykke med annoncen.\n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 09:01:26', 'email', 1),\n(81, 'da_DK', 0, 'Hej [USER.NAME]!', 'user-contact', 'Der er et svar til din annonce. \nBrugeren [EMAIL.SENDER] [EMAIL.FROM], har skrevet følgende besked til dig:\n\n[EMAIL.BODY]. \n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 09:04:57', 'email', 1),\n(82, 'da_DK', 0, 'Ændring af adgangskode på [SITE.NAME]', 'auth-remember', 'Hej [USER.NAME],\n\nFølg dette link: [URL.QL]\n\nTak!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 09:07:13', 'email', 1),\n(83, 'da_DK', 0, 'Velkommen til [SITE.NAME]!', 'auth-register', 'Velkommen [USER.NAME],\n\nVi er glade for du vil være med! [URL.QL]\n\nHusk venligst dine log ind oplysninger:\nEmail: [USER.EMAIL]\nAdgangskode: [USER.PWD]\n\nDin oprindelige adgangskode er ikke længere gyldig.\n\nMed venlig hilsen', '" . core::request('ADMIN_EMAIL') . "', '2013-07-30 09:08:14', 'email', 1),\n\n(84, 'no_NO', 0, 'Vellykket! Din annonse `[AD.NAME]` er opprettet på [SITE.NAME]!', 'ads-confirm', 'Velkommen [USER.NAME],\n\nTakk for at du la inn annonnse på [SITE.NAME]! \n\nVennligst klikk på denne lenken [URL.QL] for å godkjenne den.\n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:22:01', 'email', 1),\n(85, 'no_NO', 0, 'Annonse er opprettet på [SITE.NAME]!', 'ads-user-check', 'Hallo [USER.NAME],\n\nAnnonse er opprettet for din bruker [USER.NAME]! Du kan klikke på denne lenken for å se annonsen [URL.AD]\n\nHvis du ikke har opprettet denne annonse, klikk på lenken for å kontakte oss [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:22:55', 'email', 1),\n(86, 'no_NO', 0, 'Vellykket! Din annonse `[AD.NAME]` er opprettet på [SITE.NAME]!', 'ads-notify', 'Hallo [USER.NAME],\n\nTakk for at du la inn annonnse på [SITE.NAME]! \nDu kan editere annonsen her [URL.QL].\n\nDin annonse er fremdeles ikke publisert, den må godkjennes av en administrator. \n\nVi beklager ubeleiligheten. Vi vill se på det så snarest mulig.\n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:31:47', 'email', 1),\n(87, 'no_NO', 0, '[EMAIL.SENDER] ønsker å kontakte deg!', 'contact-admin', 'Hallo Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], har en melding til deg:\n\n[EMAIL.BODY] \n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:32:36', 'email', 1),\n(88, 'no_NO', 0, 'Din annonse påt [SITE.NAME], har blitt aktivert!', 'ads-activated', 'Hallo [USER.OWNER],\n\nVi vil informere deg om at din annonse [URL.QL] har blitt aktivert!\nDen kan nå ses av andre. \n\nVi håper du ikke måtte vente for lenge. \n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:33:29', 'email', 1),\n(90, 'no_NO', 0, 'Hallo [USER.NAME]!', 'user-contact', 'Du har blitt kontaktet angående din annonse. \nBruker [EMAIL.SENDER] [EMAIL.FROM], har en beskjed til deg: \n[EMAIL.BODY]. \n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:35:54', 'email', 1),\n(91, 'no_NO', 0, 'Endre passord [SITE.NAME]', 'auth-remember', 'Hallo [USER.NAME],\n\nKlikk på denne lenken [URL.QL]\n\nTakk!!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:37:12', 'email', 1),\n(92, 'no_NO', 0, 'Velkommen to [SITE.NAME]!', 'auth-register', 'Velkommen [USER.NAME],\n\nVi setter pris på at du har registrert deg! [URL.QL]\n\nHusk din brukerinformasjon:\nE-post: [USER.EMAIL]\nPassword: [USER.PWD]\n\nVi har ikke ditt opprinnelige passord lenger.\n\nHilsen!', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:38:06', 'email', 1),\n\n(93, 'ca_ES', 0, 'Èxit! El vostre anunci `[AD.NAME]` és creat damunt [SITE.NAME]!', 'ads-confirm', 'Benvingut [USER.NAME],\n\nGràcies Per crear un anunci a [SITE.NAME]! \n\nSi us plau clic en aquest enllaç [URL.QL] per confirmar-lo.\n\nConsideracions,', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:46:03', 'email', 1),\n(94, 'ca_ES', 0, 'El vostre anunci és creat damunt [SITE.NAME]!', 'ads-user-check', 'Hola [USER.NAME],\n\nL''anunci és creat sota el vostre compte [USER.NAME]! Pots visitar aquest enllaç per veure anunci [URL.AD].\n\nSi no ets responsable per crear aquest anunci, clic un enllaç per contactar-nos [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-07-31 11:55:59', 'email', 1),\n(95, 'ca_ES', 0, 'Èxit! El vostre anunci `[AD.NAME]` és creat damunt [SITE.NAME]!', 'ads-notify', 'Hola [USER.NAME],\n\nGràcies Per crear un anunci a [SITE.NAME]! \nEt Pot editar el vostre anunci aquí [URL.QL].\n\nEl vostre anunci és encara no publicat, necessita ser validat per un administrador. \nEns sap greu per qualsevol inconveniència. El revisarem al més aviat possible. \n\nConsideracions!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 09:29:57', 'email', 1),\n(96, 'ca_ES', 0, '[EMAIL.SENDER] vol contactarte!', 'contact-admin', 'Hola Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], té un missatge per tu:\n\n[EMAIL.BODY]\n\nConsideracions!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:17:04', 'email', 1),\n(97, 'ca_ES', 0, 'El vostre anunci a [SITE.NAME] ha estat activat!', 'ads-activated', 'Hola [USER.OWNER],\n\nEt volem informar que el vostre anunci [URL.QL] ha estat activat! Ara pugui ser vist per altres. \nEsperem no vam fer esperes per llarg. \n\nConsideracions!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:18:05', 'email', 1),\n(99, 'ca_ES', 0, 'Hola [USER.NAME]!', 'user-contact', 'T''Ha estat contactat pel que fa al vostre anunci. Usuari [EMAIL.SENDER] [EMAIL.FROM], té un missatge per tu: \n[EMAIL.BODY]\n\nConsideracions!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 09:47:07', 'email', 1),\n(100, 'ca_ES', 0, 'Canvi contrasenya [SITE.NAME]', 'auth-remember', 'Hola [USER.NAME],\n\nSeguir aquest enllaç [URL.QL]\n\nGràcies!!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 09:48:18', 'email', 1),\n(101, 'ca_ES', 0, 'Benvingut a [SITE.NAME]!', 'auth-register', 'Benvinguda [USER.NAME],\n\nSom realment feliços que te''ns ha unit! [URL.QL]\n\nRecordar els vostres detalls d''usuari:\nCorreu electrònic: [USER.EMAIL]\nContrasenya: [USER.PWD]\nNo tenim la vostra contrasenya original més.\n\nConsideracions!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 09:49:40', 'email', 1),\n\n(102, 'in_ID', 0, 'Berhasil! Iklan anda `[AD.NAME]` telah dibuat [SITE.NAME]!', 'ads-confirm', 'Selamat datang [USER.NAME],\n\nTerima kasih telah membuat iklan di [SITE.NAME]! \n\nSilahkan Klik link ini [URL.QL] untuk konfirmasi.\n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:04:14', 'email', 1),\n(103, 'in_ID', 0, 'Iklan telah dibuat [SITE.NAME]!', 'ads-user-check', 'Halo [USER.NAME],\n\nIklananda telah dibuat dibawah email [USER.NAME]! Anda dapat mengunjungi tutan ini untuk melihat iklan [URL.AD]\n\nJika anda tidak bertanggung jawab membuat iklan ini, klik tautan untuk hubungi kami [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:05:30', 'email', 1),\n(104, 'in_ID', 0, 'Berhasil! Iklan anda `[AD.NAME]` telah dibuat [SITE.NAME]!', 'ads-notify', 'Halo [USER.NAME],\n\nTerima kasih telah membuat iklan di [SITE.NAME]! \n\nAnda dapar mengedit iklan anda disini [URL.QL].\n\nIklan ada masih belum dipublikasi, harus disahkan oleh administrator.\nKami meminta maaf atas gangguan ini. Kami akan mengadakan peninjauan segera.\n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:07:03', 'email', 1),\n(105, 'in_ID', 0, '[EMAIL.SENDER] ingin menghubungi Anda!', 'contact-admin', 'Halo Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], Mempunyai pesan untuk anda:\n[EMAIL.BODY] \n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:07:54', 'email', 1),\n(106, 'in_ID', 0, 'Iklan ada pada situs [SITE.NAME] telah diaktifan!', 'ads-activated', 'Halo [USER.OWNER],\n\nKami akan menginformasikan bahwa iklan anda [URL.QL] telah diaktifkan!\nSekarang dapat terlihat oleh yang lain.\n\nKami harap tidak membuat anda menunggu lama.\n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:09:34', 'email', 1),\n(108, 'in_ID', 0, 'Halo [USER.NAME]!', 'user-contact', 'Anda telah dihubungi mengenai iklan Anda. Pengguna [EMAIL.SENDER] [EMAIL.FROM], mempunyai pesan untuk anda: \n[EMAIL.BODY]. \n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:12:05', 'email', 1),\n(109, 'in_ID', 0, 'Ubah kata sandi [SITE.NAME]', 'auth-remember', 'Halo [USER.NAME],\n\nIkutitautan ini [URL.QL]\n\nTerima kasih!!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:13:28', 'email', 1),\n(110, 'in_ID', 0, 'Selamat datang di [SITE.NAME]!', 'auth-register', 'Selamat datang [USER.NAME],\n\nKami sangat senang karena anda telah bergabung dengan kami! [URL.QL]\n\nMengingat rincian pengguna Anda:\nEmail: [USER.EMAIL]\nKata sandi: [USER.PWD]\n\nKami tidak mempunyai kata sandi anda yang asli lagi.\n\nRegard!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:14:44', 'email', 1),\n\n(111, 'sk_SK', 0, 'Blahoželáme! Váš inzerát `[AD.NAME]` je vytvorený na [SITE.NAME]!', 'ads-confirm', 'Vitajte [USER.NAME],\n\nĎakujeme za pridanie inzerátu na [SITE.NAME]!\n\nProsím kliknite na nasledujúci odkaz [URL.QL] pre potvrdenie.\n\nS pozdravom!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:19:56', 'email', 1),\n(112, 'sk_SK', 0, 'Inzerát je vytvorený na [SITE.NAME]!', 'ads-user-check', 'Dobrý deň [USER.NAME],\n\n Inzerát bol vytvorený pod Vaším účtom [USER.NAME]! Pre zobrazenie inzerátu môžete navštíviť túto stránku [URL.AD]\n\nAk ste nevytvorili tento inzerát, kliknite na nasledujúci link aby ste nás kontaktovali [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:21:41', 'email', 1),\n(113, 'sk_SK', 0, 'Blahoželáme! Váš inzerát `[AD.NAME]` je vytvorený na [SITE.NAME]!', 'ads-notify', 'Dobrý deň [USER.NAME],\n\nĎakujeme za zadanie inzerátu na stránke [SITE.NAME]! \nVáš inzerát môžete upraviť tu [URL.QL].\n\nVáš inzerát ešte nie je zverenený, musí ho schváliť administrátor.\nOspravedlňujeme sa za nepríjemnosť. Budeme sa tomu venovať hneď ako to bude možné.\n\nS pozdravom!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:23:18', 'email', 1),\n(114, 'sk_SK', 0, '[EMAIL.SENDER] má pre Vás správu', 'contact-admin', 'Dobrý deň Admin,\n\n[EMAIL.SENDER]: [EMAIL.FROM], má pre Vás správu:\n\nS pozdravom!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:27:37', 'email', 1),\n(115, 'sk_SK', 0, 'Váš inzerát na [SITE.NAME] bol aktivovaný!', 'ads-activated', 'Dobrý deň [USER.OWNER],\n\nOznamujeme Vám, že Váš inzerát [URL.QL] aktivovaný!\nTeraz to môžu vidieť aj ostatní.\n\nDúfame, že sme Vás nenechali čakať dlho.\n\nS pozdravom !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:28:44', 'email', 1),\n(117, 'sk_SK', 0, 'Dobrý deň [USER.NAME]!', 'user-contact', 'Boli ste kontaktovaní vzhľadom na Váš inzerát. \n\nUžívateľ [EMAIL.SENDER] [EMAIL.FROM], má pre Vás správu: \n\n[EMAIL.BODY]. \n\nS pozdravom!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:32:17', 'email', 1),\n(118, 'sk_SK', 0, 'Zmena hesla [SITE.NAME]', 'auth-remember', 'Dobrý deň [USER.NAME],\n\nNásledujte tento odkaz [URL.QL]\n\nĎakujeme!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:34:08', 'email', 1),\n(119, 'sk_SK', 0, 'Vitajte na [SITE.NAME]!', 'auth-register', 'Vitajte [USER.NAME],\n\nNaozaj nás teší, že ste sa k nám pripojili! [URL.QL]\nUchovajte si Vaše údaje:\nEmail: [USER.EMAIL]\nHeslo: [USER.PWD]\nUž nemáme vaše pôvodné heslo.\n\nĎakujeme!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 10:35:50', 'email', 1),\n\n(120, 'ml_IN', 0, '[SITE.NAME] - ല് താങ്കളുടെ `[AD.NAME]` പരസ്യം സ്വീകരിക്കപ്പെട്ടിരിക്കുന്നു. അഭിനന്ദനങ്ങള്!', 'ads-confirm', 'സ്വാഗതം [USER.NAME],\n\n[SITE.NAME] - ല് ഒരു പരസ്യം പ്രസിദ്ധീകരിക്കുവാന് മുമ്പോട്ടുവന്നതില് താങ്കളോട് നന്ദി അറിയിക്കുന്നു.\n\nദയവായി അത് ഉറപ്പാക്കുവാന് ഈ ലിങ്കില് ക്ലിക്ക് ചെയ്യുക [URL.QL] \n\nഅന്യേഷണങ്ങള് അറിയിക്കുന്നു !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:21:25', 'email', 1),\n(121, 'ml_IN', 0, '[SITE.NAME] - ല് പരസ്യം സ്വീകരിക്കപ്പെട്ടിരിക്കുന്നു!', 'ads-user-check', 'ഹെല്ലോ [USER.NAME],\n\nപ്രിയ [USER.NAME], താങ്കളുടെ അക്കൗണ്ടില് ഈ പരസ്യം ഞങ്ങള് സ്വീകരിച്ചിരിക്കുന്നു. താങ്കളുടെ പരസ്യം കാണുവാന് ഈ ലിങ്കില് ക്ലിക്ക് ചെയ്യുക [URL.AD]\n\nഈ പരസ്യം താങ്കള് തന്നിരിക്കുന്നതല്ല എങ്കില്, ദയവായി ഈ ലിങ്കില് ക്ലിക്ക് ചെയ്ത് ഞങ്ങളെ വിവരമറിയിക്കുക [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:23:21', 'email', 1),\n(122, 'ml_IN', 0, '[SITE.NAME] - ല് താങ്കളുടെ `[AD.NAME]` പരസ്യം സ്വീകരിക്കപ്പെട്ടിരിക്കുന്നു. അഭിനന്ദനങ്ങള്!', 'ads-notify', 'ഹെല്ലോ [USER.NAME],\n\n[SITE.NAME] - ല് ഒരു പരസ്യം പ്രസിദ്ധീകരിക്കുവാന് മുമ്പോട്ടുവന്നതില് താങ്കളോട് നന്ദി അറിയിക്കുന്നു.\n\nതാങ്കളുടെ പരസ്യത്തില് ഏതെങ്കിലും മാറ്റം വരുത്തുവാന് ഉണ്ടെങ്കില് ഈ ലിങ്ക് ഉപയോഗിക്കുക [URL.QL].\n\nതാങ്കളുടെ പരസ്യം ഇപ്പോഴും പ്രസിദ്ധീകരിക്കപ്പെട്ടില്ല. അത് അഡ്മിനിസ്ട്രേട്ടരുടെ വിലയിരുത്തലിനുകൂടി വിധേയമാവേണ്ടതുണ്ട്.\nതാങ്കള്ക്കുണ്ടായ അസൌകര്യങ്ങള്ക്ക് ക്ഷമാപണം നടത്തുന്നു.ഏറ്റവും വേഗത്തില് പരിശോധനാ നടപടികള് പൂര്ത്തീകരിക്കുന്നതാണ്.\n\nഅന്യേഷണങ്ങള് അറിയിക്കുന്നു !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:25:33', 'email', 1),\n(123, 'ml_IN', 0, '[SITE.NAME] - ല് തന്നിരുന്ന താങ്കളുടെ പരസ്യം ആക്ടിവേറ്റ് ചെയ്യപ്പെട്ടിരിക്കുന്നു. അഭിനന്ദനങ്ങള്', 'ads-activated', 'ഹെല്ലോ [USER.OWNER],\n\nതാങ്കളുടെ പരസ്യം [URL.QL] ആക്ടിവേറ്റ് ആയിരിക്കുന്നതായി അറിയിക്കുന്നതില് അതിയായ സന്തോഷമുണ്ട്.\nഇപ്പോള് താങ്കളുടെ പരസ്യം മറ്റുള്ളവര്ക്കും കാണുവാന് കഴിയും.\nതാങ്കളെ ഏറെ കാത്തിരുത്തിയില്ലായെന്നു കരുതട്ടെ.\nഅന്യേഷണങ്ങള് അറിയിക്കുന്നു !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:27:09', 'email', 1),\n(125, 'ml_IN', 0, 'ഹെല്ലോ [USER.NAME]!', 'user-contact', 'താങ്കളുടെ പരസ്യത്തിന് ഇതാ ഒരു അന്വേഷണം എത്തിയിരിക്കുന്നു. [EMAIL.SENDER] [EMAIL.FROM] - ല് നിന്നുമുള്ള പ്രതികരണമാണിത്.\n\n[EMAIL.BODY]\n\nഅന്യേഷണങ്ങള് അറിയിക്കുന്നു !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:29:59', 'email', 1),\n(126, 'ml_IN', 0, 'പാസ്വേഡ് മാറ്റം : [SITE.NAME]!', 'auth-remember', 'ഹെല്ലോ [USER.NAME],\n\nഈ ലിങ്ക് പിന്തുടരുക [URL.QL]\n\nനന്ദി!', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:31:21', 'email', 1),\n(127, 'ml_IN', 0, '[SITE.NAME] - ലേയ്ക്ക് സ്വാഗതം!', 'auth-register', 'സ്വാഗതം [USER.NAME],\n\nപ്രിയ [URL.QL], താങ്കള് ഞങ്ങളോടൊപ്പം ഒത്തുചേര്ന്നത്തില് അതിയായ സന്തോഷം അറിയിക്കുന്നു.\n\nതാങ്കളുടെ യൂസര് അക്കൌണ്ട് വിവരങ്ങള് ഓര്ത്തിരിക്കുക:\nഇമെയില് : [USER.EMAIL]\nപാസ്വേഡ് : [USER.PWD]\n\nതുടര്ന്ന് താങ്കളുടെ പാസ്വേഡ് ഞങ്ങളോടൊപ്പമല്ല, താങ്കളുടെ നിയന്ത്രണത്തിലാന്നെന്ന് അറിയുക.\n\nഅന്യേഷണങ്ങള് അറിയിക്കുന്നു !', '" . core::request('ADMIN_EMAIL') . "', '2013-08-02 11:32:29', 'email', 1),\n\n(128, 'ar', 0, 'تم بنجاح `[AD.NAME]` اضافة اعلانك على موقع [SITE.NAME]!', 'ads-confirm', '[right][USER.NAME] مرحبا[/right]\n[right]شكرا لك على وضع اعلانك على موقع [SITE.NAME][/right]\n[right]الرجاء الضغط على الرابط [URL.QL] للتاكيد[/right]\n[right]مع ارق التحيات[/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:07:44', 'email', 1),\n(129, 'ar', 0, 'تم ‘نشاء الاعلان على [SITE.NAME]!', 'ads-user-check', '[right][USER.NAME] مرحبا [/right]\n[right]تم انشاء اعلان بواسطة حسابك [USER.NAME]! اضغط على الرابط للتاكد من الاعلان [URL.AD][/right]\n[right]اذا لم تقم بانشاء هذا الاعلان , الرجاء الضغط على الرابط للتواصل معنا [URL.CONTACT][/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:13:12', 'email', 1),\n(130, 'ar', 0, 'تم بنجاح `[AD.NAME]` اضافة اعلانك على موقع [SITE.NAME]!', 'ads-notify', '[right]مرحبا[USER.NAME][/right]\n[right]شكرا لك لانشائك اعلان على موقع [SITE.NAME][/right]\n[right]بمكانك التعديل على الاعلان هنا [URL.QL][/right]\n[right]لم يتم نشر اعلانك حتى تتم الموافقة من الادارة.[/right]\n[right]ونحن نعتذر عن أي إزعاج. وسوف يتم مراجعة في أقرب وقت ممكن.[/right]\n[right]تحياتنا لك [/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:16:20', 'email', 1),\n(131, 'ar', 0, '!يريد الاتصال بك [EMAIL.SENDER]', 'contact-admin', '[right]اهلا مدير [/right]\n[right][EMAIL.SENDER] لديك رساله جديدة من [EMAIL.FROM][/right]\n[right][EMAIL.BODY][/right]\n[right]تحياتنا لك [/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:20:56', 'email', 1),\n(132, 'ar', 0, 'تم تفعيل علانك على موقع [SITE.NAME]!', 'ads-activated', '[right]مرحبا [USER.OWNER][/right]\n[right]نود اعلامك بان اعلانك [URL.QL] قد تم تفعيلة ![/right]\n[right]الان يمكن للاخرين مشاهدته[/right]\n[right]نتمنى ألا نكون قد اطلنا انتظارك [/right]\n[right]تحياتنا لك [/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:22:53', 'email', 1),\n(134, 'ar', 0, 'مرحبا [USER.NAME],', 'user-contact', '[right]تم الاتصال بك بسبب اعلانك المستخدم [EMAIL.FROM][EMAIL.SENDER] قام ارسالك رساله [/right]\n[right][EMAIL.BODY][/right]\n[right]تحياتنا لك [/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:26:01', 'email', 1),\n(135, 'ar', 0, 'تغيير كلمة المرور [SITE.NAME]', 'auth-remember', '[right]مرحبا [USER.NAME][/right]\n[right]الرجاء الضغط على الرابط التالي [URL.QL][/right]\n[right]وشكرا لك [/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:27:06', 'email', 1),\n(136, 'ar', 0, 'مرحبا [SITE.NAME]', 'auth-register', '[right]مرحبا [USER.NAME][/right]\n[right]نحن في غاية السعادة بنظمامك الينا! [URL.QL][/right]\n[right]تفااصيل حسابك [/right]\n[right]البريد الالكتروني: [USER.EMAIL][/right]\n[right]كلمة السر: [USER.PWD][/right]\n[right]لم نعد نملك كلمة السر الاصلية بعد الان.[/right]\n[right]تحياتنا لك[/right]', '" . core::request('ADMIN_EMAIL') . "', '2013-08-05 10:28:13', 'email', 1),\n\n(137, 'es_ES', 0, 'Cambiar Contraseña [SITE.NAME]', 'auth-remember', 'Hola [USER.NAME],\r\n\r\nSigue este enlace [URL.QL]\r\n\r\n¡Gracias!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:40:59', 'email', 1),\n(138, 'es_ES', 0, '¡Bienvenido a [SITE.NAME]!', 'auth-register', 'Bienvenido [USER.NAME],\r\n\r\n¡Estamos muy contentos de que te no hayas unido! [URL.QL]\r\n\r\nRecuerda tus detalles de usuario:\r\nEmail: [USER.EMAIL]\r\nContraseña: [USER.PWD]\r\n\r\nYa no tenemos más tu contraseña original.\r\n\r\n¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:43:35', 'email', 1),\n(139, 'es_ES', 0, '¡Hola [USER.NAME]!', 'user-contact', 'Has sido contactado en relación con tu anuncio: \r\n\r\n`[AD.NAME]`. \r\n\r\n Usuario [EMAIL.SENDER] [EMAIL.FROM], tiene un mensaje para ti: \r\n\r\n[EMAIL.BODY]. \r\n\r\n ¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:44:40', 'email', 1),\n(140, 'es_ES', 0, '¡Hola [USER.NAME]!', 'user-profile-contact', 'Usuario [EMAIL.SENDER] [EMAIL.FROM], tiene un mensaje para ti: \r\n\r\n[EMAIL.SUBJECT] \r\n\r\n[EMAIL.BODY]. \r\n\r\n ¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:45:17', 'email', 1),\n(141, 'es_ES', 0, '¡[EMAIL.SENDER] quiere contactarte!', 'contact-admin', 'Hello Admin,\r\n\r\n [EMAIL.SENDER]: [EMAIL.FROM], tiene un mensaje para ti:\r\n\r\n [EMAIL.BODY] \r\n\r\n ¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:46:09', 'email', 1),\n(142, 'es_ES', 0, '¡Tu anuncio `[AD.NAME]` en [SITE.NAME] ha sido activado!', 'ads-activated', 'Hola [USER.OWNER],\r\n\r\n ¡Queremos informate que tu anuncio [URL.QL] ha sido activado!\r\n\r\n Ahora puede ser visto por otros usuarios. \r\n\r\n Esperamos no habarte hecho esperar demasiado. \r\n\r\n¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:48:22', 'email', 1),\n(143, 'es_ES', 0, '¡Enhorabuena! Tu anuncio `[AD.NAME]` ha sido creado en [SITE.NAME]!', 'ads-notify', 'Hola [USER.NAME],\r\n\r\n¡Gracias por crear un anuncio en [SITE.NAME]! \r\n\r\nPuedes editar tu anuncio aquí [URL.QL].\r\n\r\n Tu anuncio aún no está publicado, necesita que sea validado por un administrador. \r\n\r\n Lamentamos el inconveniente. Lo revisaremos lo más pronto posible.\r\n\r\n¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:51:32', 'email', 1),\n(144, 'es_ES', 0, '¡Anuncio `[AD.NAME]` ha sido creado en [SITE.NAME]!', 'ads-user-check', 'Hola [USER.NAME],\r\n\r\n ¡[USER.NAME], un anuncio ha sido creado en tu cuenta! Puedes visitar este enlace para verlo [URL.AD]\r\n\r\n Si no eres el responsable de la creación de este anuncio, has clic en este enlace para contactarnos [URL.CONTACT].\r\n\r\n', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:08:50', 'email', 1),\n(145, 'es_ES', 0, '¡Anuncio `[AD.TITLE]` ha sido creado en [SITE.NAME]!', 'ads-subscribers', '¡Hola,\r\n\r\n ¡Quizás te interese esto!\r\n\r\nPuede visitar este enlace para ver el anuncio [URL.AD]\r\n\r\n', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:08:55', 'email', 1),\n(146, 'es_ES', 0, '¡Anuncio `[AD.TITLE]` ha sido creado en [SITE.NAME]!', 'ads-to-admin', 'Clic aquí para visitarlo [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:03:48', 'email', 1),\n(147, 'es_ES', 0, '¡Anuncio `[AD.TITLE]` ha sido vendido en [SITE.NAME]!', 'ads-sold', 'ID de la orden: [ORDER.ID]\r\n\r\nID del producto: [PRODUCT.ID]\r\n\r\nPor favor, verifica tu cuenta para el pago recibido.\r\n\r\nClic aquí para visitar [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:08:16', 'email', 1),\n(148, 'es_ES', 0, '¡El anuncio `[AD.TITLE]` ya no cuenta con stock en [SITE.NAME]!', 'out-of-stock', 'Hola [USER.NAME],\r\n\r\nMientras tu anuncio está fuera de stock, no estará disponible para que otros usuarios lo vean. Si deseas incrementar tu stock y activar tu anuncio, por favor sigue este enlace [URL.EDIT].\r\n\r\n¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:08:07', 'email', 1),\n(149, 'es_ES', 0, '¡El anuncio `[AD.TITLE]` ha sido comprado [SITE.NAME]!', 'ads-purchased', 'ID de la orden: [ORDER.ID]\r\n\r\nID del producto: [PRODUCT.ID]\r\n\r\nPor cualquier inconveniente por favor ponte en contacto con el administrador de [SITE.NAME]\r\n\r\nClic aquí para visitar [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:10:23', 'email', 1),\n(150, 'es_ES', 0, 'Recibo de [ORDER.DESC] #[ORDER.ID]', 'new-order', 'Hola [USER.NAME], gracias por comprar [ORDER.DESC].\r\n\r\nPor favor, completa tu pago aquí [URL.CHECKOUT]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:11:39', 'email', 1),\n(151, 'es_ES', 0, '¡Enhorabuena! Tu anuncio `[AD.NAME]` fue creado en [SITE.NAME]!', 'ads-confirm', 'Bienvenido [USER.NAME],\r\n\r\nGracias por crear un anuncio en [SITE.NAME]! \r\n\r\nPor favor, has clic en este enlace [URL.QL] para confirmarlo.\r\n\r\n¡Saludos!', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 04:12:51', 'email', 1),\n(152, 'es_ES', 0, 'Tu anuncio [AD.NAME] ha expirado', 'ad-expired', 'Hola [USER.NAME], Tu anuncio [AD.NAME] ha expirado \r\n\r\nPor favor, revisa tu anuncio aquí [URL.EDITAD]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:52:59', 'email', 1),\n(153, 'es_ES', 0, 'Opinión nueva para [AD.TITLE] [RATE]', 'ad-review', '[URL.QL]\r\n\r\n[RATE]\r\n\r\n[DESCRIPTION]', '" . core::request('ADMIN_EMAIL') . "', '2014-10-28 03:52:15', 'email', 1);"); mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "content` (`locale`, `title`, `seotitle`, `description`, `from_email`, `type`, `status`) VALUES\n('fr_FR', 'Félicitations! Votre annonce a bien été créée sur [SITE.NAME]!', 'ads-confirm', 'Bienvenue [USER.NAME],<br /><br />\n<br /><br />\nMerci d''avoir créé une anonnce sur [SITE.NAME]! <br /><br />\n<br /><br />\nVeuillez cliquer sur ce lien [URL.QL] pour la confirmer.<br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Félicitations! Votre annonce a été créée sur [SITE.NAME]!', 'ads-notify', 'Bonjour [USER.NAME],<br /><br />\n<br /><br />\nMerci d''avoir créé une anonnce sur [SITE.NAME]! <br /><br />\n<br /><br />\nVous pouvez modifier votre annonce ici [URL.QL].<br /><br />\n<br /><br />\nVotre annonce est en attente de publication, elle doit encore être validée par l''administrateur. Nous allons l''examiner dès que possible. <br /><br />\n<br /><br />\nNous sommes désolés pour le délai et la gène occasionnée. Merci de votre compréhension.<br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', '[EMAIL.SENDER] souhaite vous contacter!', 'contact-admin', 'Bonjour Administrateur,<br /><br />\n<br /><br />\n[EMAIL.SENDER]: [EMAIL.FROM], a un message pour vous:<br /><br />\n<br /><br />\n[EMAIL.BODY] <br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Votre annonce sur [SITE.NAME] a été activée!', 'ads-activated', 'Bonjour [USER.OWNER],<br /><br />\n<br /><br />\nNous vous informons que votre annonce [URL.QL] a été activée!<br /><br />\nElle est désormais visible de tous sur le site. <br /><br />\n<br /><br />\nEn espérant ne pas vous avoir fait trop attendre. <br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Bonjour [USER.NAME]!', 'user-new', 'Bienvenue sur [SITE.NAME]. <br /><br />\n<br /><br />\nNous sommes ravis de votre participation,<br /><br />\nVous pouvez vous connecter avec votre email: [USER.EMAIL], <br /><br />\net votre mot de passe: [USER.PWD]. <br /><br />\n<br /><br />\nLe mot de passe a été généré automatiquement; pour le remplacer par votre mot de passe préféré, cliquez sur ce lien: [URL.PWCH]. <br /><br />\n<br /><br />\nMerci de votre confiance! <br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Bonjour [USER.NAME]!', 'user-contact', 'Vous avez été contacté au sujet de votre annonce. <br /><br />\nL''utilisateur [EMAIL.SENDER] [EMAIL.FROM] vous a envoyé le message suivant:<br /><br />\n[EMAIL.BODY]. <br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Changement de mot de passe [SITE.NAME]', 'auth-remember', 'Bonjour [USER.NAME],<br /><br />\n<br /><br />\nVeuillez suivre ce lien [URL.QL]<br /><br />\n<br /><br />\nMerci!!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Bienvenue sur [SITE.NAME]!', 'auth-register', 'Bienvenue [USER.NAME],<br /><br />\n<br /><br />\nNous sommes ravis de votre participation! [URL.QL]<br /><br />\nVoici pour rappel vos informations de connexion:<br /><br />\nEmail: [USER.EMAIL]<br /><br />\nMot de passe: [USER.PWD]<br /><br />\n<br /><br />\nPour des raisons de sécurité, nous ne gardons pas votre mot de passe original.<br /><br />\n<br /><br />\nCordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Bonjour [USER.NAME]!', 'user-profile-contact', 'L''utilisateur [Email.SENDER] [EMAIL.From] a un message pour vous: [EMAIL.SUBJECT] [EMAIL.BODY]. Cordialement,', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.NAME]` a été créée sur [SITE.NAME]!', 'ads-user-check', 'Bonjour [USER.NAME], l''annonce a été créée avec votre compte [USER.NAME]! Vous pouvez visiter ce lien pour Cliquez ici pour accéder à votre annonce: [URL.AD] Si vous n''êtes pas l''auteur de cette annonce, cliquez sur le lien pour nous contacter: [URL.CONTACT].', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.TITLE]` vient d''être publiée sur [SITE.NAME]!', 'ads-subscribers', 'Bonjour, Vous êtes peut être intéressé(e) par cette nouvelle annonce! Cliquez sur ce lien pour Cliquez ici pour accéder à votre annonce: [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.TITLE]` vient d''être créée sur [SITE.NAME]!', 'ads-to-admin', 'Cliquez ici pour voir l''annnonce [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.TITLE]` a été vendue sur [SITE.NAME]!', 'ads-sold', 'Numéro de commande: [ORDER.ID] ID de produit: [PRODUCT.ID] Veuillez svp vérifier votre compte pour le paiement entrant. Cliquez ici pour accéder à votre annonce: [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.TITLE]` est en rupture de stock sur [SITE.NAME]!', 'out-of-stock', 'Bonjour [USER.NAME]. Comme votre annonce est en rupture de stock, il n''est pas posible pour les visiteurs du site de la voir. Si vous souhaitez augmenter sa disponibilité et ainsi activer votre annonce, veuillez svp cliquer sur le lien suivant: [URL.EDIT]. Cordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Reçu pour votre commande [ORDER.DESC] # [ORDER.ID]', 'new-order', 'Bonjour [USER.NAME], Merci pour votre commande [ORDER.DESC]. Veuillez svp régler votre commande et procéder à son paiement ici: [URL.CHECKOUT]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Votre annonce [AD.NAME] a expiré', 'ad-expired', 'Bonjour [USER.NAME], Votre annonce [AD.NAME] a expiré. Veuillez svp vérifier votre annonce ici: [URL.EDITAD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'L''annonce `[AD.TITLE]` a été achetée sur [SITE.NAME]!', 'ads-purchased', 'Numéro de commande: [ORDER.ID] ID du produit: [PRODUCT.ID] Pour toute question ou demande veuillez svp contacter l''administrateur du site [SITE.NAME] Cliquez ici pour accéder à votre annonce: [URL.AD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Mot de passe modifié [SITE.NAME]', 'password-changed', 'Bonjour [USER.NAME], Votre mot de passe a été changé. Voici vos nouvelles informations de connexion: Email: [USER.EMAIL] Mot de passe: [USER.PWD] . Pour des raisons de sécurité, nous ne gardons pas votre mot de passe original. Cordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Votre annonce [AD.NAME] va expirer', 'ad-to-expire', 'Bonjour [USER.NAME], Votre annonce [AD.NAME] va bientôt expirer. Veuillez svp vérifier votre annonce en cliquant sur ce lien: [URL.EDITAD]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Nouvelle réponse: [TITRE]', 'messaging-reply', '[URL.QL]\r\n\r\n[DESCRIPTION]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', '[FROM.NAME] vous a envoyé un message direct', 'messaging-user-contact', 'Bonjour [TO.NAME], [FROM.NAME] a un message pour vous: [description] [URL.QL] Cordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Nouveau commentaire sur votre annonce [AD.TITLE] [RATE]', 'ad-review', 'Bonjour, une nouveau commentaire et une appréciation ont été publiés pour votre annonce. [URL.QL]\r\n\r\n[RATE]\r\n\r\n[DESCRIPTION]', '" . core::request('ADMIN_EMAIL') . "', 'email', 1),\n('fr_FR', 'Bonjour [TO.NAME]!', 'messaging-ad-contact', 'Vous avez été contacté au sujet de votre annonce: `[AD.NAME]`. L''utilisateur [FROM.NAME] a un message pour vous: [DESCRIPTION] [URL.QL] Cordialement!', '" . core::request('ADMIN_EMAIL') . "', 'email', 1);"); /** * Access */ mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "roles` (`id_role`, `name`, `description`) VALUES \n (1, 'user', 'Normal user'), \n (5, 'translator', 'User + Translations'), \n (7, 'moderator', 'Moderator'), \n (10, 'admin', 'Full access');"); mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "access` (`id_role`, `access`) VALUES \n (10, '*.*'),\n (1, 'profile.*'),(1, 'stats.user'),(1, 'myads.*'),(1, 'messages.*'),\n (5, 'translations.*'),(5, 'profile.*'),(5, 'stats.user'),(5, 'content.*'),(5, 'myads.*'),(5, 'messages.*'),\n (7, 'profile.*'),(7, 'content.*'),(7, 'stats.user'),(7, 'blog.*'),(7, 'translations.*'),(7, 'ad.*'),\n (7, 'widgets.*'),(7, 'menu.*'),(7, 'category.*'),(7, 'location.*'),(7, 'myads.*'),(7, 'messages.*');"); /** * Create user God/Admin */ $password = hash_hmac('sha256', core::request('ADMIN_PWD'), install::$hash_key); mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "users` (`id_user`, `name`, `seoname`, `email`, `password`, `status`, `id_role`, `subscriber`) \nVALUES (1, 'admin', 'admin', '" . core::request('ADMIN_EMAIL') . "', '{$password}', 1, 10, 1)"); /** * Configs to make the app work * @todo refactor to use same coding standard * @todo widgets examples? at least at sidebar, rss, text advert, pages, locations... * */ mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "config` (`group_name`, `config_key`, `config_value`) VALUES\n('appearance', 'theme', 'default'),\n('appearance', 'theme_mobile', ''),\n('appearance', 'allow_query_theme', 0),\n('appearance', 'custom_css', 0),\n('appearance', 'custom_css_version', 0),\n('appearance', 'map_active', 0),\n('appearance', 'map_jscode', ''),\n('appearance', 'map_settings',''),\n('i18n', 'charset', 'utf-8'),\n('i18n', 'timezone', '" . core::request('TIMEZONE') . "'),\n('i18n', 'locale', '" . core::request('LANGUAGE') . "'),\n('i18n', 'allow_query_language', 0),\n('payment', 'paypal_currency', 'USD'),\n('payment', 'sandbox', 0),\n('payment', 'to_featured', 0),\n('payment', 'to_top', 0),\n('payment', 'pay_to_go_on_feature', '1'),\n('payment', 'featured_plans', '{\"5\":\"10\"}'),\n('payment', 'pay_to_go_on_top', '5'),\n('payment', 'paypal_account', ''),\n('payment', 'paypal_seller', '0'),\n('payment', 'stock', '0'),\n('payment', 'paymill_private', ''),\n('payment', 'paymill_public', ''),\n('payment', 'stripe_private', ''),\n('payment', 'stripe_public', ''),\n('payment', 'stripe_address', '0'),\n('payment', 'stripe_alipay', '0'),\n('payment', 'alternative', ''),\n('payment', 'bitpay_apikey', ''),\n('payment', 'authorize_sandbox', '0'),\n('payment', 'authorize_login', ''),\n('payment', 'authorize_key', ''),\n('payment', 'twocheckout_sid', ''),\n('payment', 'twocheckout_secretword', ''),\n('payment', 'twocheckout_sandbox', 0),\n('payment', 'fraudlabspro', ''),\n('payment', 'paysbuy', ''),\n('payment', 'paysbuy_sandbox', '0'),\n('general', 'api_key', '" . core::generate_password(32) . "'),\n('general', 'number_format', '%n'),\n('general', 'date_format', 'd-m-y'),\n('general', 'measurement', 'metric'),\n('general', 'base_url', '" . core::request('SITE_URL') . "'),\n('general', 'moderation', 0),\n('general', 'maintenance', 0),\n('general', 'analytics', ''),\n('general', 'translate', ''),\n('general', 'site_name', '" . core::request('SITE_NAME') . "'),\n('general', 'site_description', ''),\n('general', 'subscribe', 0),\n('general', 'akismet_key', ''),\n('general', 'alert_terms', ''),\n('general', 'contact_page', ''),\n('general', 'search_by_description', 0),\n('general', 'blog', 0),\n('general', 'blog_disqus',''),\n('general', 'minify', 0),\n('general', 'faq', 0),\n('general', 'faq_disqus', ''),\n('general', 'forums', '0'),\n('general', 'messaging', 1),\n('general', 'black_list', '1'),\n('general', 'ocacu', '0'),\n('general', 'landing_page', '{\"controller\":\"home\",\"action\":\"index\"}'),\n('general', 'disallowbots', 0),\n('general', 'html_head', ''),\n('general', 'html_footer', ''),\n('general', 'recaptcha_active', 0),\n('general', 'recaptcha_secretkey', ''),\n('general', 'recaptcha_sitekey', ''),\n('general', 'cookie_consent', 0),\n('general', 'auto_locate', 0),\n('general', 'social_auth', 0),\n('general', 'adblock', 0),\n('general', 'search_multi_catloc', 0),\n('general', 'gcm_apikey', ''),\n('general', 'email_domains', ''),\n('general', 'cron', 1),\n('image', 'allowed_formats', 'jpeg,jpg,png,'),\n('image', 'max_image_size', '5'),\n('image', 'height', ''),\n('image', 'width', '1200'),\n('image', 'height_thumb', '200'),\n('image', 'width_thumb', '200'),\n('image', 'quality', '90'),\n('image', 'watermark', '0'),\n('image', 'watermark_path', ''),\n('image', 'watermark_position', '0'),\n('image', 'aws_s3_active', 0),\n('image', 'aws_access_key', ''),\n('image', 'aws_secret_key', ''),\n('image', 'aws_s3_bucket', ''),\n('image', 'aws_s3_domain', 0),\n('image', 'disallow_nudes', 0),\n('advertisement', 'num_images', '4'),\n('advertisement', 'expire_date', '0'),\n('advertisement', 'description', 1),\n('advertisement', 'address', 1),\n('advertisement', 'phone', 1),\n('advertisement', 'upload_file', 0),\n('advertisement', 'location', 1),\n('advertisement', 'description_bbcode', 1),\n('advertisement', 'captcha', 1),\n('advertisement', 'website', 1),\n('advertisement', 'price', 1),\n('advertisement', 'contact', 1),\n('advertisement', 'tos', ''),\n('advertisement', 'thanks_page', ''),\n('advertisement', 'disqus', ''),\n('advertisement', 'fbcomments', ''),\n('advertisement', 'map', 0),\n('advertisement', 'map_style', ''),\n('advertisement', 'map_zoom', 14),\n('advertisement', 'center_lon', ''),\n('advertisement', 'center_lat', ''),\n('advertisement', 'auto_locate_distance', 100),\n('advertisement', 'ads_in_home', '0'),\n('advertisement', 'banned_words_replacement', 'xxx'),\n('advertisement', 'banned_words', ''),\n('advertisement', 'fields', ''),\n('advertisement', 'parent_category', 1),\n('advertisement', 'related', 5),\n('advertisement', 'map_pub_new', '0'),\n('advertisement', 'qr_code', '0'),\n('advertisement', 'login_to_post', '0'),\n('advertisement', 'reviews', '0'),\n('advertisement', 'reviews_paid', '0'),\n('advertisement', 'advertisements_per_page', '10'),\n('advertisement', 'feed_elements', '20'),\n('advertisement', 'map_elements', '100'),\n('advertisement', 'sort_by', 'published-desc'),\n('advertisement', 'count_visits', 1),\n('advertisement', 'login_to_contact', 0),\n('advertisement', 'only_admin_post', 0),\n('advertisement', 'sharing', '0'),\n('advertisement', 'logbee', 0),\n('advertisement', 'leave_alert', 1),\n('email', 'notify_email', '" . core::request('ADMIN_EMAIL') . "'),\n('email', 'smtp_active', 0),\n('email', 'new_ad_notify', 0),\n('email', 'smtp_host', ''),\n('email', 'smtp_port', ''),\n('email', 'smtp_auth', 0),\n('email', 'smtp_ssl', 0),\n('email', 'smtp_user', ''),\n('email', 'smtp_pass', ''),\n('email', 'elastic_active', 0),\n('email', 'elastic_username', ''),\n('email', 'elastic_password', ''),\n('user', 'user_fields', '{}'),\n('social', 'config', '{\"debug_mode\":\"0\",\"providers\":{\"OpenID\":{\"enabled\":\"0\"},\"Yahoo\":{\"enabled\":\"0\",\"keys\":{\"id\":\"\",\"secret\":\"\"}},\n\"AOL\":{\"enabled\":\"0\"},\"Google\":{\"enabled\":\"0\",\"keys\":{\"id\":\"\",\"secret\":\"\"}},\"Facebook\":{\"enabled\":\"0\",\"keys\":{\"id\":\"\",\"secret\":\"\"}},\n\"Twitter\":{\"enabled\":\"0\",\"keys\":{\"key\":\"\",\"secret\":\"\"}},\"Live\":{\"enabled\":\"0\",\"keys\":{\"id\":\"\",\"secret\":\"\"}},\"MySpace\":{\"enabled\":\"0\",\"keys\":{\"key\":\"\",\"secret\":\"\"}},\n\"LinkedIn\":{\"enabled\":\"0\",\"keys\":{\"key\":\"\",\"secret\":\"\"}},\"Foursquare\":{\"enabled\":\"0\",\"keys\":{\"id\":\"\",\"secret\":\"\"}}},\"base_url\":\"\",\"debug_file\":\"\"}');"); //base category mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "categories` \n (`id_category` ,`name` ,`order` ,`id_category_parent` ,`parent_deep` ,`seoname` ,`description` )\nVALUES (1, 'Home category', 0 , 0, 0, 'all', 'root category');"); //base location mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "locations` \n (`id_location` ,`name` ,`id_location_parent` ,`parent_deep` ,`seoname` ,`description`)\nVALUES (1 , 'Home location', 0, 0, 'all', 'root location');"); //sample values if (core::request('SAMPLE_DB') !== NULL) { //sample catpegories mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "categories` (`id_category`, `name`, `order`, `created`, `id_category_parent`, `parent_deep`, `seoname`, `description`, `price`) VALUES\n (2, 'Jobs', 1, '2013-05-01 16:41:04', 1, 0, 'jobs', 'The best place to find work is with our job offers. Also you can ask for work in the ''Need'' section.', 0),\n (3, 'Languages', 2, '2013-05-01 16:41:04', 1, 0, 'languages', 'You want to learn a new language? Or can you teach a language? This is your section!', 0),\n (4, 'Others', 4, '2013-05-01 16:41:04', 1, 0, 'others', 'Whatever you can imagine is in this section.', 0),\n (5, 'Housing', 0, '2013-05-01 16:41:53', 1, 0, 'housing', 'Do you need a place to sleep, or you have something to offer; rooms, shared apartments, houses... etc.\n\nFind your perfect roommate here!', 0),\n (6, 'Market', 3, '2013-05-01 16:41:04', 1, 0, 'market', 'Buy or sell things that you don''t need anymore in the City, you will find someone interested, or maybe you are going to find exactly what you need.', 0),\n (7, 'Full Time', 1, '2009-04-22 17:31:43', 2, 1, 'full-time', 'Are you looking for a fulltime job? Or do you have a fulltime job to offer? Post your Ad here!', 0),\n (8, 'Part Time', 2, '2009-04-22 17:32:15', 2, 1, 'part-time', 'Are you looking for a parttime job? Or do you have a partime job to offer? Post your Ad here!', 0),\n (9, 'Internship', 3, '2009-04-22 17:33:05', 2, 1, 'internship', 'Are you looking for a internship in the City? Or do you have an internship to offer? Post it here!', 0),\n (10, 'Au pair', 4, '2009-06-19 09:26:22', 2, 1, 'au-pair', 'Find or require for a Au Pair service. Here is the best place', 0),\n (11, 'English', 1, '2009-04-22 17:33:52', 3, 1, 'english', 'Do you speak English? Or can you teach it? Do you want to learn? This is your category.', 0),\n (12, 'Spanish', 2, '2009-04-22 17:34:29', 3, 1, 'spanish', 'You want to learn Spanish? Or can you teach Spanish? This is your section!', 0),\n (13, 'Other Languages', 3, '2009-04-22 17:35:34', 3, 1, 'other-languages', 'Are you interested in learning or teaching any other language that is not listed? Post it here!', 0),\n (14, 'Events', 0, '2013-05-01 16:41:11', 4, 1, 'events', 'Upcoming Parties, Cinema, Museums, Parades, Birthdays, Dinners.... Everything!', 0),\n (15, 'Hobbies', 1, '2013-05-01 16:41:11', 4, 1, 'hobbies', 'Share your hobby with someone! Football, running, cinema, music, cinema, party ... Post it here!', 0),\n (16, 'Services', 3, '2009-04-22 17:38:33', 4, 1, 'services', 'Do you need a service? Relocation? Insurance? Doctor? Cleaning? Here you can ask for it or offer services!', 0),\n (17, 'Friendship', 2, '2013-05-01 16:41:17', 1, 1, 'friendship', 'Are you alone in the City? Here you can find new friends! or a new boyfriend/girlfriend ;)', 0),\n (18, 'Apartment', 1, '2009-04-22 17:39:32', 5, 1, 'apartment', 'Apartments, flats, monthly rentals, long terms, for days... this is the section to have your apartment in the City!', 0),\n (19, 'Shared Apartments - Rooms', 2, '2009-05-03 21:53:57', 5, 1, 'shared-apartments-rooms', 'You want to share an apartment? Then you need a room! Ask for rooms or add yours in this section.', 0),\n (20, 'House', 3, '2009-04-22 17:40:50', 5, 1, 'house', 'Rent a house, or offer your house for rent! Here you can find your beach house close to the City!', 0),\n (21, 'TV', 1, '2009-04-22 17:41:39', 6, 1, 'tv', 'TV, Video Games, TFT, Plasma, your old TV, or your new one can find a new owner!', 0),\n (22, 'Audio', 2, '2009-04-22 17:42:13', 6, 1, 'audio', 'HI-FI systems, iPod, MP3 players, MP4, if you don''t use it anymore sell it! If you try to find a second hand one, this is your place!', 0),\n (23, 'Furniture', 3, '2009-04-22 17:43:16', 6, 1, 'furniture', 'Do you need to furnish your home? Or would you like to sell your furniture? Post it here!', 0),\n (24, 'IT', 4, '2009-04-22 17:43:48', 6, 1, 'it', 'You need a computer? Laptop? Or do you have some old components? This is the IT market of the City!', 0),\n (25, 'Other Market', 5, '2009-04-22 17:44:12', 6, 1, 'other-market', 'In this market you can sell everything you want! Or search for it!', 0);\n "); } //crontabs mysqli_query($link, "INSERT INTO `" . core::request('TABLE_PREFIX') . "crontab` (`name`, `period`, `callback`, `params`, `description`, `active`) VALUES\n('Sitemap', '0 3 * * *', 'Sitemap::generate', NULL, 'Regenerates the sitemap everyday at 3am',1),\n('Clean Cache', '0 5 * * *', 'Core::delete_cache', NULL, 'Once day force to flush all the cache.', 1),\n('Optimize DB', '0 4 1 * *', 'Core::optimize_db', NULL, 'once a month we optimize the DB', 1),\n('Unpaid Orders', '0 7 * * *', 'Cron_Ad::unpaid', NULL, 'Notify unpaid orders 2 days after was created', 1),\n('Expired Featured Ad', '0 8 * * *', 'Cron_Ad::expired_featured', NULL, 'Notify by email of expired featured ad', 1),\n('Expired Ad', '0 9 * * *', 'Cron_Ad::expired', NULL, 'Notify by email of expired ad', 1),\n('About to Expire Ad', '05 9 * * *', 'Cron_Ad::to_expire', NULL, 'Notify by email your ad is about to expire', 1);"); mysqli_close($link);
?> " class="form-control" data-toggle="tooltip" title="<?php echo __("Database charset"); ?> " required /> </div> </div> <div class="form-group adv"> <div class="col-md-12"> <label class="control-label"><?php echo __("Table prefix"); ?> :</label> <input type="text" name="TABLE_PREFIX" value="<?php echo core::request('TABLE_PREFIX', 'oc2_'); ?> " class="form-control" data-toggle="tooltip" title="<?php echo __("Allows multiple installations in one database if you give each one a unique prefix"); ?> . <?php echo __("Only numbers, letters, and underscores"); ?> ." required /> </div> </div> </div> </div> </div> <div class="clearfix"></div> <div class="form-actions">
?> ><?php echo $num; ?> </option> <?php } ?> </select> </div> <div class="form-group"> <input type="text" class="form-control input-sm search-query" name="email" placeholder="<?php echo __('email'); ?> " value="<?php echo core::request('email'); ?> "> </div> <button type="submit" class="btn btn-primary"><?php echo __('Filter'); ?> </button> <a class="btn btn-warning" href="<?php echo Route::url('oc-panel', array('controller' => 'order', 'action' => 'index')); ?> "> <?php echo __('Reset'); ?> </a>
echo core::config('image.height_thumb'); ?> ?<?php echo str_replace('+', ' ', http_build_query(array('text' => $ad->category->name, 'size' => 14, 'auto' => 'yes'))); ?> " class="img-responsive" alt="<?php echo HTML::chars($ad->title); ?> "> <?endif?> </figure> </a> </div> <ul> <?if (core::request('sort') == 'distance' AND Model_User::get_userlatlng()) :?> <li><b><?php echo __('Distance'); ?> :</b> <?php echo i18n::format_measurement($ad->distance); ?> </li> <?endif?> <?if ($ad->published!=0){?> <li><b><?php echo __('Publish Date'); ?> :</b> <?php echo Date::format($ad->published, core::config('general.date_format')); ?>
/** * Edit advertisement: Update * * All post fields are validated */ public function action_update() { //template header $this->template->title = __('Edit advertisement'); $this->template->meta_description = __('Edit advertisement'); Controller::$full_width = TRUE; //local files if (Theme::get('cdn_files') == FALSE) { $this->template->styles = array('css/jquery.sceditor.default.theme.min.css' => 'screen', '//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.1/css/selectize.bootstrap3.min.css' => 'screen', '//cdn.jsdelivr.net/sweetalert/1.1.3/sweetalert.css' => 'screen'); $this->template->scripts['footer'] = array('js/jquery.sceditor.bbcode.min.js', '//maps.google.com/maps/api/js?sensor=false&libraries=geometry&v=3.7', '//cdn.jsdelivr.net/gmaps/0.4.15/gmaps.min.js', '//cdn.jsdelivr.net/sweetalert/1.1.3/sweetalert.min.js', '//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.1/js/standalone/selectize.min.js', 'js/canvasResize.js', 'js/oc-panel/edit_ad.js'); } else { $this->template->styles = array('css/jquery.sceditor.default.theme.min.css' => 'screen', '//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.1/css/selectize.bootstrap3.min.css' => 'screen', '//cdn.jsdelivr.net/sweetalert/1.1.3/sweetalert.css' => 'screen'); $this->template->scripts['footer'] = array('js/jquery.sceditor.bbcode.min.js', '//maps.google.com/maps/api/js?sensor=false&libraries=geometry&v=3.7', '//cdn.jsdelivr.net/gmaps/0.4.15/gmaps.min.js', '//cdn.jsdelivr.net/sweetalert/1.1.3/sweetalert.min.js', '//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.12.1/js/standalone/selectize.min.js', 'js/canvasResize.js', 'js/oc-panel/edit_ad.js'); } Breadcrumbs::add(Breadcrumb::factory()->set_title(__('My ads'))->set_url(Route::url('oc-panel', array('controller' => 'myads', 'action' => 'index')))); $form = new Model_Ad($this->request->param('id')); if ($form->loaded() and (Auth::instance()->get_user()->id_user == $form->id_user or Auth::instance()->get_user()->id_role == Model_Role::ROLE_ADMIN or Auth::instance()->get_user()->id_role == Model_Role::ROLE_MODERATOR)) { // deleting single image by path if (is_numeric($deleted_image = core::request('img_delete'))) { $form->delete_image($deleted_image); $this->redirect(Route::url('oc-panel', array('controller' => 'myads', 'action' => 'update', 'id' => $form->id_ad))); } // end of img delete // set primary image if (is_numeric($primary_image = core::request('primary_image'))) { $form->set_primary_image($primary_image); $this->redirect(Route::url('oc-panel', array('controller' => 'myads', 'action' => 'update', 'id' => $form->id_ad))); } $original_category = $form->category; $extra_payment = core::config('payment'); if ($this->request->post()) { $data = $this->request->post(); //to make it backward compatible with older themes: UGLY!! if (isset($data['category']) and is_numeric($data['category'])) { $data['id_category'] = $data['category']; unset($data['category']); } if (isset($data['location']) and is_numeric($data['location'])) { $data['id_location'] = $data['location']; unset($data['location']); } $return = $form->save_ad($data); //there was an error on the validation if (isset($return['validation_errors']) and is_array($return['validation_errors'])) { foreach ($return['validation_errors'] as $f => $err) { Alert::set(Alert::ALERT, $err); } } elseif (isset($return['error'])) { Alert::set($return['error_type'], $return['error']); } elseif (isset($return['message'])) { // IMAGE UPLOAD // in case something wrong happens user is redirected to edit advert. $filename = NULL; for ($i = 0; $i < core::config("advertisement.num_images"); $i++) { if (Core::post('base64_image' . $i)) { $filename = $form->save_base64_image(Core::post('base64_image' . $i)); } elseif (isset($_FILES['image' . $i])) { $filename = $form->save_image($_FILES['image' . $i]); } } if ($filename !== NULL) { $form->last_modified = Date::unix2mysql(); try { $form->save(); } catch (Exception $e) { throw HTTP_Exception::factory(500, $e->getMessage()); } } Alert::set(Alert::SUCCESS, $return['message']); //redirect user to pay if (isset($return['checkout_url']) and !empty($return['checkout_url'])) { $this->redirect($return['checkout_url']); } } $this->redirect(Route::url('oc-panel', array('controller' => 'myads', 'action' => 'update', 'id' => $form->id_ad))); } //get all orders $orders = new Model_Order(); $orders = $orders->where('id_user', '=', $form->id_user)->where('status', '=', Model_Order::STATUS_CREATED)->where('id_ad', '=', $form->id_ad)->find_all(); Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Update'))); $this->template->content = View::factory('oc-panel/profile/edit_ad', array('ad' => $form, 'extra_payment' => $extra_payment, 'orders' => $orders)); } else { Alert::set(Alert::ERROR, __('You dont have permission to access this link')); $this->redirect(Route::url('default')); } }
/** * * NEW ADVERTISEMENT * */ public function action_index() { //Detect early spam users, show him alert if (core::config('general.black_list') == TRUE and Model_User::is_spam(Core::post('email')) === TRUE) { Alert::set(Alert::ALERT, __('Your profile has been disable for posting, due to recent spam content! If you think this is a mistake please contact us.')); $this->redirect('default'); } //advertisement.only_admin_post if (Core::config('advertisement.only_admin_post') == 1 and (!Auth::instance()->logged_in() or Auth::instance()->logged_in() and Auth::instance()->get_user()->id_role != Model_Role::ROLE_ADMIN)) { $this->redirect('default'); } if (Core::post('ajaxValidateCaptcha')) { $this->auto_render = FALSE; $this->template = View::factory('js'); if (captcha::check('publish_new', TRUE)) { $this->template->content = 'true'; } else { $this->template->content = 'false'; } return; } //template header $this->template->title = __('Publish new advertisement'); $this->template->meta_description = __('Publish new advertisement'); $this->template->styles = array('css/jquery.sceditor.default.theme.min.css' => 'screen', 'css/jasny-bootstrap.min.css' => 'screen', '//cdn.jsdelivr.net/sweetalert/0.1.2/sweet-alert.min.css' => 'screen'); $this->template->scripts['footer'][] = 'js/jquery.sceditor.bbcode.min.js'; $this->template->scripts['footer'][] = 'js/jasny-bootstrap.min.js'; $this->template->scripts['footer'][] = 'js/jquery.chained.min.js'; $this->template->scripts['footer'][] = '//cdn.jsdelivr.net/sweetalert/0.1.2/sweet-alert.min.js'; $this->template->scripts['footer'][] = '//cdnjs.cloudflare.com/ajax/libs/ouibounce/0.0.10/ouibounce.min.js'; if (core::config('advertisement.map_pub_new')) { $this->template->scripts['footer'][] = '//maps.google.com/maps/api/js?sensor=false&libraries=geometry&v=3.7'; $this->template->scripts['footer'][] = '//cdn.jsdelivr.net/gmaps/0.4.15/gmaps.min.js'; } $this->template->scripts['footer'][] = 'js/new.js?v=' . Core::VERSION; // redirect to login, if conditions are met if (core::config('advertisement.login_to_post') == TRUE and !Auth::instance()->logged_in()) { Alert::set(Alert::INFO, __('Please, login before posting advertisement!')); HTTP::redirect(Route::url('oc-panel', array('controller' => 'auth', 'action' => 'login'))); } //find all, for populating form select fields $categories = Model_Category::get_as_array(); $order_categories = Model_Category::get_multidimensional(); $order_parent_deep = Model_Category::get_by_deep(); // NO categories redirect ADMIN to categories panel if (count($order_categories) == 0) { if (Auth::instance()->logged_in() and Auth::instance()->get_user()->id_role == Model_Role::ROLE_ADMIN) { Alert::set(Alert::INFO, __('Please, first create some categories.')); $this->redirect(Route::url('oc-panel', array('controller' => 'category', 'action' => 'index'))); } else { Alert::set(Alert::INFO, __('Posting advertisements is not yet available.')); $this->redirect('default'); } } //get locations $locations = Model_Location::get_as_array(); $order_locations = Model_Location::get_multidimensional(); $loc_parent_deep = Model_Location::get_by_deep(); // bool values from DB, to show or hide this fields in view $form_show = array('captcha' => core::config('advertisement.captcha'), 'website' => core::config('advertisement.website'), 'phone' => core::config('advertisement.phone'), 'location' => core::config('advertisement.location'), 'address' => core::config('advertisement.address'), 'price' => core::config('advertisement.price')); $id_category = NULL; $selected_category = new Model_Category(); //if theres a category by post or by get if (Core::request('category') !== NULL) { if (is_numeric(Core::request('category'))) { $selected_category->where('id_category', '=', core::request('category'))->limit(1)->find(); } else { $selected_category->where('seoname', '=', core::request('category'))->limit(1)->find(); } if ($selected_category->loaded()) { $id_category = $selected_category->id_category; } } $id_location = NULL; $selected_location = new Model_Location(); //if theres a location by post or by get if (Core::request('location') !== NULL) { if (is_numeric(Core::request('location'))) { $selected_location->where('id_location', '=', core::request('location'))->limit(1)->find(); } else { $selected_location->where('seoname', '=', core::request('location'))->limit(1)->find(); } if ($selected_location->loaded()) { $id_location = $selected_location->id_location; } } //render view publish new $this->template->content = View::factory('pages/ad/new', array('categories' => $categories, 'order_categories' => $order_categories, 'order_parent_deep' => $order_parent_deep, 'locations' => $locations, 'order_locations' => $order_locations, 'loc_parent_deep' => $loc_parent_deep, 'form_show' => $form_show, 'id_category' => $id_category, 'selected_category' => $selected_category, 'id_location' => $id_location, 'selected_location' => $selected_location, 'fields' => Model_Field::get_all())); if ($this->request->post()) { if (captcha::check('publish_new')) { $data = $this->request->post(); $validation = Validation::factory($data); //validate location since its optional if (core::config('advertisement.location')) { if (count($locations) > 1) { $validation = $validation->rule('location', 'not_empty')->rule('location', 'digit'); } } //user is not logged in validate input if (!Auth::instance()->logged_in()) { $validation = $validation->rule('email', 'not_empty')->rule('email', 'email')->rule('name', 'not_empty')->rule('name', 'min_length', array(':value', 2))->rule('name', 'max_length', array(':value', 145)); } if ($validation->check()) { // User detection, if doesnt exists create if (!Auth::instance()->logged_in()) { $user = Model_User::create_email(core::post('email'), core::post('name')); } else { $user = Auth::instance()->get_user(); } //to make it backward compatible with older themes: UGLY!! if (isset($data['category']) and is_numeric($data['category'])) { $data['id_category'] = $data['category']; unset($data['category']); } if (isset($data['location']) and is_numeric($data['location'])) { $data['id_location'] = $data['location']; unset($data['location']); } //lets create!! $return = Model_Ad::new_ad($data, $user); //there was an error on the validation if (isset($return['validation_errors']) and is_array($return['validation_errors'])) { foreach ($return['validation_errors'] as $f => $err) { Alert::set(Alert::ALERT, $err); } } elseif (isset($return['error'])) { Alert::set($return['error_type'], $return['error']); } elseif (isset($return['message']) and isset($return['ad'])) { $new_ad = $return['ad']; // IMAGE UPLOAD $filename = NULL; for ($i = 0; $i < core::config('advertisement.num_images'); $i++) { if (isset($_FILES['image' . $i])) { $filename = $new_ad->save_image($_FILES['image' . $i]); } if ($filename) { $new_ad->has_images++; } } //since theres images save the ad again... if ($new_ad->has_images > 0) { try { $new_ad->save(); } catch (Exception $e) { throw HTTP_Exception::factory(500, $e->getMessage()); } } Alert::set(Alert::SUCCESS, $return['message']); //redirect user if (isset($return['checkout_url']) and !empty($return['checkout_url'])) { $this->redirect($return['checkout_url']); } else { $this->redirect(Route::url('default', array('action' => 'thanks', 'controller' => 'ad', 'id' => $new_ad->id_ad))); } } } else { $errors = $validation->errors('ad'); foreach ($errors as $f => $err) { Alert::set(Alert::ALERT, $err); } } } else { Alert::set(Alert::ALERT, __('Captcha is not correct')); } } }
<button id="setMyLocation" class="btn btn-default" type="button"><?php echo __('Ok'); ?> </button> </span> </div> <br> <div id="mapCanvas"></div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal"><?php echo __('Close'); ?> </button> <?php if (core::request('userpos') == 1) { ?> <a class="btn btn-danger" href="?<?php echo http_build_query(['userpos' => NULL] + Request::current()->query()); ?> "><?php echo __('Remove'); ?> </a> <?php } ?> </div> </div> </div> </div>
?> </div> </div> <div class="form-group"> <?php echo FORM::label('description', __('Description'), array('class' => 'control-label col-md-2', 'for' => 'description')); ?> <div class="col-sm-9"> <?php echo FORM::textarea('description', __('Description'), array('class' => 'form-control', 'id' => 'description', 'data-editor' => 'html')); ?> </div> </div> <?php if (core::request('type') == 'email') { ?> <div class="form-group"> <?php echo FORM::label('from_email', __('From email'), array('class' => 'control-label col-md-2', 'for' => 'from_email')); ?> <div class="col-sm-4"> <?php echo FORM::input('from_email', '', array('placeholder' => __('from_email'), 'class' => 'form-control', 'id' => 'from_email')); ?> </div> </div> <?php } ?>
echo HTML::entities($ad->category->name); ?> &size=14&auto=yes" class="img-responsive" alt="<?php echo HTML::chars($ad->title); ?> "> <?php } ?> </figure> </a> </div> <ul> <?php if (core::request('sort') == 'distance' and Model_User::get_userlatlng()) { ?> <li><b><?php echo __('Distance'); ?> :</b> <?php echo i18n::format_measurement($ad->distance); ?> </li> <?php } ?> <?php if ($ad->published != 0) { ?> <li><b><?php
?> "> <span class="glyphicon glyphicon-th-list"></span><?php echo __('List'); ?> </a> <a href="#" id="grid" class="btn btn-default btn-sm <?php echo core::cookie('list/grid') == 0 ? 'active' : ''; ?> "> <span class="glyphicon glyphicon-th"></span><?php echo __('Grid'); ?> </a> <button type="button" id="sort" data-sort="<?php echo core::request('sort'); ?> " class="btn btn-info btn-sm dropdown-toggle" data-toggle="dropdown"> <span class="glyphicon glyphicon-list-alt"></span><?php echo __('Sort'); ?> <span class="caret"></span> </button> <ul class="dropdown-menu" role="menu" id="sort-list"> <li><a href="?sort=title-asc"><?php echo __('Name (A-Z)'); ?> </a></li> <li><a href="?sort=title-desc"><?php echo __('Name (Z-A)'); ?>
<div class="col-md-8"> <?php echo FORM::input('address', $user->address, array('class' => 'form-control', 'id' => 'address', 'type' => 'address', 'maxlength' => '150', 'placeholder' => __('Address'))); ?> </div> </div> <div class="form-group"> <div class="col-md-offset-4 col-md-8"> <button type="submit" class="btn btn-primary"><?php echo __('Update'); ?> </button> </div> </div> <input type="hidden" name="order_id" value="<?php echo core::request('order_id'); ?> "> </form> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title"><?php echo __('Change password'); ?> </h3> </div> <div class="panel-body"> <form class="form-horizontal" method="post" action="<?php echo Route::url('oc-panel', array('controller' => 'profile', 'action' => 'changepass'));
<div class="form-group"> <label class="control-label">pass</label> <p class="form-control-static admin_pwd"></p> </div> <p> <a class="btn btn-default btn-block" href="<?php echo core::request('SITE_URL', install::$url); ?> "><?php echo __('Go to Your Website'); ?> </a> </p> <p> <a class="btn btn-default btn-block" href="<?php echo core::request('SITE_URL', install::$url); ?> oc-panel/">Admin</a> </p> </div> </div> </div> </div> <?php } ?> </div> </form> </div> </div> </div>