fong hong

i also need to find this answer??? did any one know ??

Is there Anyone can help me in this case. How can i add customer phone mobile at my Invoice Template (invoice.tpl) Below {$invoice_address}, What should i add the code??

Thanks suthichai Since I need to search in Thai which is a non-Latin language, I workaround by changing my_shop\classes\Search.php, llok for define('PREG_CLASS_SEARCH_EXCLUDE', ------------->> around line 31 remove \x{e31}\x{e34}-\x{e3f}\x{e46}-\x{e4f} So that these characters are not excluded (these are Thai vowels). It works for me. Keep in mind that you may have to include different characters than mine. I have not done extensive test, so don't know whether it also work for other languages. I believe that there must be more elegant way of doing this, I am appreciate if someone would enlighten me. i am using 1.5.6.1.. Is it work for me . 7zhop

Hi Denisnadal, thanks for your post. Can u help me with this issue... Does it work for PS1.5.6.1? i used this version www.7zhop.com PS1.5.6.1 my robots.txt on bellow , Pls help me WHERE & HOW to add in this code Disallow: /*content_only=1 **************************************************** User-agent: Googlebot Allow: User-agent: googlebot-image Allow: User-agent: googlebot-mobile Allow: User-agent: MSNBot Allow: User-agent: Slurp Allow: User-agent: Teoma Allow: User-agent: twiceler Allow: User-agent: Gigabot Allow: User-agent: Scrubby Allow: User-agent: Robozilla Allow: User-agent: Nutch Allow: User-agent: ia_archiver Allow: User-agent: baiduspider Allow: User-agent: naverbot Allow: User-agent: yeti Allow: User-agent: yahoo-mmcrawler Allow: User-agent: psbot Allow: User-agent: asterias Disallow: User-agent: yahoo-blogs/v3.9 Allow: User-agent: * Allow: Disallow: /cgi-bin/ Sitemap: http://www.7zhop.com/index.php?controller=sitemap **************************************************** THANKs YOU

SOLVED ps1.5.6.1 /public_html/modules/statslive/statslive.php Start <?php /* * 2007-2014 PrestaShop * * NOTICE OF LICENSE * * This source file is subject to the Academic Free License (AFL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/afl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to [email protected] so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author PrestaShop SA <[email protected]> * @copyright 2007-2014 PrestaShop SA * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ if (!defined('_PS_VERSION_')) exit; class StatsLive extends Module { private $html = ''; public function __construct() { $this->name = 'statslive'; $this->tab = 'analytics_stats'; $this->version = '1.2.2'; $this->author = 'PrestaShop'; $this->need_instance = 0; parent::__construct(); $this->displayName = $this->l('Visitors online'); $this->description = $this->l('Adds a list of customers and visitors who are currently online to the Stats dashboard.'); $this->ps_versions_compliancy = array('min' => '1.6', 'max' => _PS_VERSION_); } public function install() { return parent::install() && $this->registerHook('AdminStatsModules'); } /** * Get the number of online customers * * @return array(array, int) array of online customers entries, number of online customers */ private function getCustomersOnline() { if ($maintenance_ips = Configuration::get('PS_MAINTENANCE_IP')) $maintenance_ips = implode(',', array_map('ip2long', array_map('trim', explode(',', $maintenance_ips)))); if (Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS')) { $sql = 'SELECT u.id_customer, u.firstname, u.lastname, pt.name as page FROM `'._DB_PREFIX_.'connections` c LEFT JOIN `'._DB_PREFIX_.'connections_page` cp ON c.id_connections = cp.id_connections LEFT JOIN `'._DB_PREFIX_.'page` p ON p.id_page = cp.id_page LEFT JOIN `'._DB_PREFIX_.'page_type` pt ON p.id_page_type = pt.id_page_type INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest INNER JOIN `'._DB_PREFIX_.'customer` u ON u.id_customer = g.id_customer WHERE cp.`time_end` IS NULL '.Shop::addSqlRestriction(false, 'c').' AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', cp.`time_start`)) < 900 '.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').' GROUP BY u.id_customer ORDER BY u.firstname, u.lastname'; } else { $sql = 'SELECT u.id_customer, u.firstname, u.lastname, "-" as page FROM `'._DB_PREFIX_.'connections` c INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest INNER JOIN `'._DB_PREFIX_.'customer` u ON u.id_customer = g.id_customer WHERE TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', c.`date_add`)) < 900 '.Shop::addSqlRestriction(false, 'c').' '.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').' GROUP BY u.id_customer ORDER BY u.firstname, u.lastname'; } $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql); return array($results, Db::getInstance()->NumRows()); } /** * Get the number of online visitors * * @return array(array, int) array of online visitors entries, number of online visitors */ private function getVisitorsOnline() { if ($maintenance_ips = Configuration::get('PS_MAINTENANCE_IP')) $maintenance_ips = implode(',', array_map('ip2long', array_filter(array_map('trim', explode(',', $maintenance_ips))))); if (Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS')) { $sql = 'SELECT c.id_guest, c.ip_address, c.date_add, c.http_referer, pt.name as page FROM `'._DB_PREFIX_.'connections` c LEFT JOIN `'._DB_PREFIX_.'connections_page` cp ON c.id_connections = cp.id_connections LEFT JOIN `'._DB_PREFIX_.'page` p ON p.id_page = cp.id_page LEFT JOIN `'._DB_PREFIX_.'page_type` pt ON p.id_page_type = pt.id_page_type INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest WHERE (g.id_customer IS NULL OR g.id_customer = 0) '.Shop::addSqlRestriction(false, 'c').' AND cp.`time_end` IS NULL AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', cp.`time_start`)) < 900 '.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').' GROUP BY c.id_connections ORDER BY c.date_add DESC'; } else { $sql = 'SELECT c.id_guest, c.ip_address, c.date_add, c.http_referer, "-" as page FROM `'._DB_PREFIX_.'connections` c INNER JOIN `'._DB_PREFIX_.'guest` g ON c.id_guest = g.id_guest WHERE (g.id_customer IS NULL OR g.id_customer = 0) '.Shop::addSqlRestriction(false, 'c').' AND TIME_TO_SEC(TIMEDIFF(\''.pSQL(date('Y-m-d H:i:00', time())).'\', c.`date_add`)) < 900 '.($maintenance_ips ? 'AND c.ip_address NOT IN ('.preg_replace('/[^,0-9]/', '', $maintenance_ips).')' : '').' ORDER BY c.date_add DESC'; } $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql); return array($results, Db::getInstance()->NumRows()); } public function hookAdminStatsModules($params) { list($customers, $total_customers) = $this->getCustomersOnline(); list($visitors, $total_visitors) = $this->getVisitorsOnline(); $irow = 0; $this->html .= '<script type="text/javascript"> $("#calendar").remove(); </script>'; if (!Configuration::get('PS_STATSDATA_CUSTOMER_PAGESVIEWS')) $this->html .= ' <div class="alert alert-info">'. $this->l('You must activate the "Save page views for each customer" option in the "Data mining for statistics" (StatsData) module in order to see the pages that your visitors are currently viewing.').' </div>'; $this->html .= ' <h4> '.$this->l('Current online customers').'</h4>'; if ($total_customers) { $this->html .= $this->l('Total:').' '.(int)$total_customers.' <table class="table"> <thead> <tr> <th class="center"><span class="title_box active">'.$this->l('Customer ID').'</span></th> <th class="center"><span class="title_box active">'.$this->l('Name').'</span></th> <th class="center"><span class="title_box active">'.$this->l('Current page').'</span></th> <th class="center"><span class="title_box active">'.$this->l('View customer profile').'</span></th> </tr> </thead> <tbody>'; foreach ($customers as $customer) $this->html .= ' <tr'.($irow++ % 2 ? ' class="alt_row"' : '').'> <td class="center">'.$customer['id_customer'].'</td> <td class="center">'.$customer['firstname'].' '.$customer['lastname'].'</td> <td class="center">'.$customer['page'].'</td> <td class="center"> <a href="'.Tools::safeOutput('index.php?tab=AdminCustomers&id_customer='.$customer['id_customer'].'&viewcustomer&token='.Tools::getAdminToken('AdminCustomers'.(int)Tab::getIdFromClassName('AdminCustomers').(int)$this->context->employee->id)).'" target="_blank"> <img src="../modules/'.$this->name.'/logo.gif" /> </a> </td> </tr>'; $this->html .= ' </tbody> </table>'; } else $this->html .= '<p class="alert alert-warning">'.$this->l('There are no active customers online right now.').'</p>'; $this->html .= ' <h4> '.$this->l('Current online visitors').'</h4>'; if ($total_visitors) { $this->html .= $this->l('Total:').' '.(int)$total_visitors.' <div> <table class="table"> <thead> <tr> <th class="center"><span class="title_box active">'.$this->l('Guest ID').'</span></th> <th class="center"><span class="title_box active">'.$this->l('IP').'</span></th> <th class="center"><span class="title_box active">'.$this->l('Last activity').'</span></th> <th class="center"><span class="title_box active">'.$this->l('Current page').'</span></th> <th class="center"><span class="title_box active">'.$this->l('Referrer').'</span></th> </tr> </thead> <tbody>'; foreach ($visitors as $visitor) $this->html .= '<tr'.($irow++ % 2 ? ' class="alt_row"' : '').'> <td class="center">'.$visitor['id_guest'].'</td> <td class="center">'.long2ip($visitor['ip_address']).'</td> <td class="center">'.Tools::substr($visitor['date_add'], 11).'</td> <td class="center">'.(isset($visitor['page']) ? $visitor['page'] : $this->l('Undefined')).'</td> <td class="center">'.(empty($visitor['http_referer']) ? $this->l('None') : parse_url($visitor['http_referer'], PHP_URL_HOST)).'</td> </tr>'; $this->html .= ' </tbody> </table> </div>'; } else $this->html .= '<p class="alert alert-warning">'.$this->l('There are no visitors online.').'</p>'; $this->html .= ' <h4>'.$this->l('Notice').'</h4> <p class="alert alert-info">'.$this->l('Maintenance IPs are excluded from the online visitors.').'</p> <a class="btn btn-default" href="'.Tools::safeOutput('index.php?controller=AdminMaintenance&token='.Tools::getAdminTokenLite('AdminMaintenance')).'"> <i class="icon-share-alt"></i> '.$this->l('Add or remove an IP address.').' </a> '; return $this->html; } } End SOLVED Pls visit www.7zhop.com Link https://github.com/PrestaShop/statslive/blob/master/statslive.php

Thanks for mr. teerachai above post Posted 10 July 2013 - 02:32 PM. i solved on my ps1.5.6.1. www.7zhop.com i also add Thank you, This has solved the same problem for generating Friendly URL in Thai Language. http://www.prestashop.com/forums/topic/213603-solved-what-is-ps-allow-accented-chars-url-friendly-url/ The SQL code I used is: INSERT INTO `ps_configuration` (`id_configuration`, `id_shop_group`, `id_shop`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, NULL, NULL, 'PS_ALLOW_ACCENTED_CHARS_URL', '1', '2014-00-00 00:00:00', '2014-00-00 00:00:00'); Thanks All http://www.7zhop.com/th/cosmetic/167-ครีมทาผิวขาวตัว-constanta-whitening-uv-protec-powder-cake.html

hi Mr Suthichai, Friendly URL in THAI LANGUAGE 1.how to insert phpMyAdmin Step by step ??? THIS below database i already insert. Am i do the right step ?? id_configuration id_shop_ group id_shop name value date_add date_upd 690 NULL NULL PS_ALLOW_ACCENTED_CHARS_URL 1 0000-00-00 00:00:00 0000-00-00 00:00:00 Hope u can Help me with above first issue. . .. Am i do the right step ?? 2. i solved it. Basically, I override \pL to \pL\pM in three files: a. classes\Dispatcher.php (28 of them) b. classes\Validate.php c. classes\Tools.php ong Link here @ 7zhop.com

1. edit classes/Controller/FrontController.php public static function getTotalViewed($id_product){ $view1 = Db::getInstance()->getRow('SELECT SUM(pv.counter) AS total FROM '._DB_PREFIX_.'page_viewed pv LEFT JOIN '._DB_PREFIX_.'page p ON pv.id_page = p.id_page LEFT JOIN '._DB_PREFIX_.'page_type pt ON p.id_page_type = pt.id_page_type WHERE pt.name = \'product\' AND p.`id_object` = '.intval($id_product).' group by pv.id_page'); return isset($view1['total']) ? $view1['total'] : 0; } 2. edit /thems/your-theme/products.tpl {FrontController::getTotalViewed(Tools::getValue('id_product'))} solved PS 1.5.6.1 Collect all your visitor that visit your page . pls visit this product pages 7zhop.com

thanks. this solved with me. 1.5.6.1 7zhop

Hi. suthichai what prestashop version do u used ?? i am using 1.5.6.1.. Is it work for me ?? 7zhop

md5sum generator link http://www.miraclesa...ebtools/md5.php pls visit this link more at 7zhop.com

Previous for me is truncate:25 NOW i change to truncate:55 Solved for me 1.5.6.1 here 1. for changing product's name lenght in categories go to: /public_html/themes/your theme/product_list.tpl and search for: {$product.name|truncate:32:'...'|escape:'htmlall':'UTF-8'}change truncate(this is the number of characters) into what number you need. Solved for me 1.5.6.1 here www.7zhop.com

I'm also interested in such a paypal module for Thailand... anyone can help... www.7zhop.com. 7zhop easy shop at thailand

do u found any good payment gateway at malaysia ??