Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by kesaven

  1. Hello You are referring to the top menu in Prestashop I am talking about the Advanced Top Menu module. I am using prestashop Thanks
  2. Hello I have bought the advanced top menu module, installed and configured correctly. However i have an issue. I do not want to have titles on my links when we hover them. Can anyone suggest how to solve this?
  3. Hello May i know hoe to remove the titles on the menu items? There is a popup title that appear when we hover the elements And i do not want that Thanks
  4. I have tested the proposed solution with Prestashop and paypal europe module: 3.10.1 Thanks a lot guys
  5. Hello I have setup paypal checkout express on my website http://www.sashiahtrading.com My website has 2 currencies: EUR MUR(Mauritian rupees) My default currency is mauritian rupees. Below is the error: Please try to contact the merchant: <b>PayPal response:</b> TIMESTAMP -> 2015-08-13T04:47:59Z L_ERRORCODE0 -> 10605 L_SHORTMESSAGE0 -> Transaction refused because of an invalid argument. See additional error messages for details. L_LONGMESSAGE0 -> Currency is not supported L_SEVERITYCODE0 -> Error Please help!!!
  6. Any luck on this issue?
  7. I am having the same issue. Have you been able to correct it?
  8. kesaven

    Currency issue

    Hello I am having an issue with paypal 3.10.1 I have successfully changed the currency to EUR before posting to paypal. The user pays successfully However when the user comes back to the website from paypal: 1. the order is created 2. order status changed to payment accepted 3. We have a blank page ERROR 500 (internal server error) Please help!!!
  9. In fact I need small images to remain the same except that it is put in a white background box of fixed size and that larger images are resized correctly.
  10. we have a website running prestashop version: the following code is in a class called annonce.php $newwidth = 45; $newheight = round($height * $newwidth / $width); $tmp=imagecreatetruecolor($newwidth,$newheight); $white = imagecolorallocate($tmp, 255, 255, 255); imagefilledrectangle($tmp, 0, 0, $newwidth, $newheight, $white); $newwidth1 = 400; $newheight1 = round($height * $newwidth1 / $width); $tmp1=imagecreatetruecolor($newwidth1,$newheight1); $white = imagecolorallocate($tmp1, 255, 255, 255); imagefilledrectangle($tmp1, 0, 0, $newwidth1, $newheight1, $white); $newwidth2 = 430; $newheight2 = round($height * $newwidth2 / $width); $tmp2=imagecreatetruecolor($newwidth2,$newheight2); $white = imagecolorallocate($tmp2, 255, 255, 255); imagefilledrectangle($tmp2, 0, 0, $newwidth2, $newheight2, $white); $newwidth3 = 600; $newheight3 = round($height * $newwidth3 / $width); $tmp3=imagecreatetruecolor($newwidth3,$newheight3); $white = imagecolorallocate($tmp3, 255, 255, 255); imagefilledrectangle($tmp3, 0, 0, $newwidth3, $newheight3, $white); $newwidth4 = 183; $newheight4 = round($height * $newwidth4 / $width); $tmp4=imagecreatetruecolor($newwidth4,$newheight4); $white = imagecolorallocate($tmp4, 255, 255, 255); imagefilledrectangle($tmp4, 0, 0, $newwidth4, $newheight4, $white); imagecopyresampled($tmp, $src, (int)(($newwidth - $newwidth) / 2), (int)(($newheight - $newheight) / 2), 0, 0, $newwidth, $newheight, $width, $height); imagecopyresampled($tmp1, $src, (int)(($newwidth1 - $newwidth1) / 2), (int)(($newheight1 - $newheight1) / 2), 0, 0, $newwidth1, $newheight1, $width, $height); imagecopyresampled($tmp2, $src, (int)(($newwidth2 - $newwidth2) / 2), (int)(($newheight2 - $newheight2) / 2), 0, 0, $newwidth2, $newheight2, $width, $height); imagecopyresampled($tmp3, $src, (int)(($newwidth3 - $newwidth3) / 2), (int)(($newheight3 - $newheight3) / 2), 0, 0, $newwidth3, $newheight3, $width, $height); imagecopyresampled($tmp4, $src, (int)(($newwidth4 - $newwidth4) / 2), (int)(($newheight4 - $newheight4) / 2), 0, 0, $newwidth4, $newheight4, $width, $height); $filename = "img/p/".$id_product."-".$id_image."-small.jpg"; //45/45 $filename1 = "img/p/".$id_product."-".$id_image."-medium.jpg"; //400/300 $filename2 = "img/p/".$id_product."-".$id_image."-large.jpg"; //430/400 $filename3 = "img/p/".$id_product."-".$id_image."-thickbox.jpg"; //600/600 $filename3 = "img/p/".$id_product."-".$id_image.".jpg"; //600/600 $filename4 = "img/p/".$id_product."-".$id_image."-home.jpg"; //183/156 imagejpeg($tmp,$filename,100); imagejpeg($tmp1,$filename1,100); imagejpeg($tmp2,$filename2,100); imagejpeg($tmp3,$filename3,100); imagejpeg($tmp4,$filename4,100); imagedestroy($src); imagedestroy($tmp); imagedestroy($tmp1); imagedestroy($tmp2); imagedestroy($tmp3); imagedestroy($tmp4); It is used to resize an uploaded in different sizes to fit different views This function code is not working However when we upload an image from the backoffice, it is always correctly resized and placed in a white box and is not distorted. can anyone please help?
  11. Hello We wish to change the page title here: http://www.vente2site.fr/modules/feedback/viewfeedback.php We have searched in vain where we could do this in code. we wish to add this title: <title>Témoignages de cédants ayant vendu leur site Internet, leur e-business ou leur start-up</title> Can anyone please help? Thanks in advance
  12. Bonjour, On viens d'acheter et d'installer le module : jcaccountgroup de Netcodes On a un souci lors de la creation d'un nouveau compte: Merci de trouver en PJ une description de notre problem. Issue Account Group Module.pdf
  13. Nous sommes un site de petites annonces (spécialisé sur la vente de biens) entièrement basé sur Prestashop : Version de Prestashop: Informations sur votre serveur: Linux #2 SMP Fri May 17 05:56:23 CEST 2013 x86_64 Version du logiciel serveur: Apache Version de PHP: 5.4.4-14+deb7u5 Version de MySQL: 5.5.31-0+wheezy1 Nous utilisons un thème customisé. Tout le site (les rubriques, les annonces) est visible en mode "Visiteur". Le business model est basé sur le paiement lors de la parution de l'annonce, le prix étant fonction de la durée de l'annonce. Nous avons désormais l'objectif de "qualifier" nos visiteurs, pour développer une activité d'intermédiation (courtage). Par qualifier le visiteur, nous entendons inviter le visiteur à s'inscrire sur le site et remplir donc un questionnaire sur son profil et ses besoins. Pour inciter à s'inscrire, nous voulons donc scinder l'annonce de vente en 2 : - une version courte pour les visiteurs (où l'on ne voit par exemple pas le contact du vendeur) - une version détaillée (la version actuelle pour les inscrits au service , qui s'identifient sur le site) Y a-t-il un module ou une fonction interne à Prestashop qui nous éviterait de tout re-développer afin de différencier l'annonce publique (en mode non loggé) de l'annonce détaillée en mode abonné/inscrit (annonce actuelle) ? Une façon de paramétrer les éléments du catalogue? Merci d'avance pour vos pistes. Cordialement Kesaven
  14. Hello Here is the link : <a href="?tab=AdminCustomers&id_customer=1&viewcustomer&token=27e657370785f8b4b82208b5bdb5449c" target="_blank"><img title="Voir" alt="" src="../img/admin/details.gif"></a>
  15. Hello I have added a new tab to my admin However when I am trying to add a link in a list as follows: $customer = new Customer($val['id_customer']); echo '</td><td><a href="?tab=AdminCustomers&id_customer='.$customer->id.'&viewcustomer&token='.Tools::getAdminToken('AdminCustomers'.(int)(Tab::getIdFromClassName('AdminCustomers')).(int)("5")).'"><img title="Voir" alt="" src="../img/admin/details.gif" /></a></td> I am getting a warning that there is a risk when opening the page. I tried to print $cookie->id_employee I found it empty However I am logged on the admin. Please help!
  16. Hello I have eventually found a solution to my problem: $exsql = ' SELECT distinct c.id_customer FROM vs_customer c LEFT OUTER JOIN vs_customer_group g ON g.id_customer = c.id_customer INNER JOIN vs_group_lang l on l.id_group = g.id_group WHERE l.id_lang = 2 AND 1 =1 '; $idds = explode(",", $_GET['ids']); foreach($idds as $idd) { $exsql = $exsql.' AND EXISTS ( SELECT * FROM vs_customer LEFT OUTER JOIN vs_customer_group g ON g.id_customer = vs_customer.id_customer INNER JOIN vs_group_lang l on l.id_group = g.id_group WHERE 1 =1 AND g.id_group ='.$idd.' AND vs_customer.id_customer = c.id_customer ) '; } //echo $exsql; $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($exsql); $num_rows = mysql_num_rows($result); } else { $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('SELECT distinct * FROM vs_customer c INNER JOIN vs_customer_group g ON g.id_customer = c.id_customer INNER JOIN vs_group_lang l on l.id_group = g.id_group WHERE id_lang = 2 '); $num_rows = mysql_num_rows($result); }
  17. Hello Paul Thanks for your response. However the proposed solution is not working It is actually excluding the customer which is actually in all the groups when it should have excluded groups where the customer is not IN
  18. Hello I am having difficulty in doing the following: My tables are as follows: vs_customer_group vs_customer One customer may belong to many groups. When I select 2 or more groups I need to get only customers that belong to all the selected groups at the same time. Below is my actual query: SELECT distinct * FROM vs_customer c INNER JOIN vs_customer_group g ON g.id_customer = c.id_customer INNER JOIN vs_group_lang l on l.id_group = g.id_group WHERE id_lang = 2 AND l.id_group IN('.$_GET['ids'].')' It is returning all customers who are on any of the selected group. can you please help?
  19. Hello I am trying to add a new page in admin but with no success: Here are my prestashop details: Version: I copied an existing admin tab and added the following code: <?php include_once(PS_ADMIN_DIR.'/../classes/AdminTab.php'); class GestionDates.php extends AdminTab { public function __construct() { // Initialise the tab by linking it to a database table and setting its default permissions parent::__construct(); } public function postProcess() { // This function is executed when the Submit button is clicked // Use it to store the value of text fields in the database parent::postProcess(); } public function displayForm($token=NULL) { // This function can be used to create a form with text fields echo '<span>Test Span</span>'; echo 'sadadasdasdasd'; } public function display() { // This function can be used to create a form with text fields echo '<span>Test Span</span>'; echo 'sadadasdasdasd'; } } ?> However I still have a blank page Can anyone help me out please Thanks in advance Kesaven Mautech Consulting Ltd
  20. Ecoute, j'ai bien l'impression que ça marche, regarde leur page de témoignages (pas dégueulasse) : http://www.vente2site.com/PBGuestBook.asp?PBMInit=1 Du reste, je vois de plus en plus de grosses affaires sur cette plateforme, et je crois bien que je vais tenter de vendre l'un des apps mobiles dans leur nouvelle section dédiée : http://www.vente2site.com/PBRealEstateType.asp?CatID=328461
  21. Hello I finally found the solution In fact in the module "BlockLayered" i had to add this: LEFT JOIN `'._DB_PREFIX_.'annonce` an ON an.`id_product` = pl.`id_product` and include debut in the select fields.
  22. When i enable show errors i get this message: <span> Notice: Undefined index: debut in /home/vente22site/public_html/tools/smarty/compile/ab4ef3ec958682a6e374dac7c2b5c392f36dd947.file.product-list.tpl.php on line 61 </span> any idea on this?
  23. Hello I still have not been able to correct my issue. Below is my function public function getProducts($id_lang, $p, $n, $orderBy = NULL, $orderWay = NULL, $getTotal = false, $active = true, $random = false, $randomNumberProducts = 1, $checkAccess = true) { global $cookie; if (!$checkAccess OR !$this->checkAccess($cookie->id_customer)) return false; if ($p < 1) $p = 1; if (empty($orderBy)) $orderBy = 'position'; else /* Fix for all modules which are now using lowercase values for 'orderBy' parameter */ $orderBy = strtolower($orderBy); if (empty($orderWay)) $orderWay = 'ASC'; if ($orderBy == 'id_product' OR $orderBy == 'date_add') $orderByPrefix = 'p'; elseif ($orderBy == 'name') $orderByPrefix = 'pl'; elseif ($orderBy == 'manufacturer') { $orderByPrefix = 'm'; $orderBy = 'name'; } elseif ($orderBy == 'position') $orderByPrefix = 'cp'; if ($orderBy == 'price') $orderBy = 'orderprice'; if (!Validate::isBool($active) OR !Validate::isOrderBy($orderBy) OR !Validate::isOrderWay($orderWay)) die (Tools::displayError()); $id_supplier = (int)(Tools::getValue('id_supplier')); /* Return only the number of products */ if ($getTotal) { $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow(' SELECT COUNT(cp.`id_product`) AS total FROM `'._DB_PREFIX_.'product` p LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = '.(int)($this->id).($active ? ' AND p.`active` = 1' : '').' '.($id_supplier ? 'AND p.id_supplier = '.(int)($id_supplier) : '')); return isset($result) ? $result['total'] : 0; } $sql = ' SELECT ann.*,p.*, pa.`id_product_attribute`, pl.`description`, pl.`description_short`, pl.`duree_forfait` , pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, i.`id_image`, il.`legend`, m.`name` AS manufacturer_name, tl.`name` AS tax_name, t.`rate`, cl.`name` AS category_default, DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY)) > 0 AS new, (p.`price` * IF(t.`rate`,((100 + (t.`rate`))/100),1)) AS orderprice FROM `'._DB_PREFIX_.'category_product` cp LEFT JOIN `'._DB_PREFIX_.'product` p ON p.`id_product` = cp.`id_product` LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (p.`id_product` = pa.`id_product` AND default_on = 1) LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = '.(int)($id_lang).') LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)($id_lang).') LEFT JOIN `'._DB_PREFIX_.'annonce` ann ON (ann.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)($id_lang).') LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1) LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)($id_lang).') LEFT JOIN `'._DB_PREFIX_.'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group` AND tr.`id_country` = '.(int)Country::getDefaultCountryId().' AND tr.`id_state` = 0) LEFT JOIN `'._DB_PREFIX_.'tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN `'._DB_PREFIX_.'tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = '.(int)($id_lang).') LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE cp.`id_category` = '.(int)($this->id).($active ? ' AND p.`active` = 1' : '').' '.($id_supplier ? 'AND p.id_supplier = '.(int)$id_supplier : ''); if ($random === true) { $sql .= ' ORDER BY RAND()'; $sql .= ' LIMIT 0, '.(int)($randomNumberProducts); } else { $sql .= ' ORDER BY '.(isset($orderByPrefix) ? $orderByPrefix.'.' : '').'`'.pSQL($orderBy).'` '.pSQL($orderWay).' LIMIT '.(((int)($p) - 1) * (int)($n)).','.(int)($n); } $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($sql); if ($orderBy == 'orderprice') Tools::orderbyPrice($result, $orderWay); if (!$result) return false; /* Modify SQL result */ return Product::getProductsProperties($id_lang, $result); } and this is my tpl {if isset($products)} <!-- Products list --> <ul id="product_list" class="clear" > {foreach from=$products item=product name=products} <li class="ajax_block_product {if $smarty.foreach.products.first}first_item{elseif $smarty.foreach.products.last}last_item{/if} {if $smarty.foreach.products.index % 2}alternate_item{else}item{/if} clearfix" > <h2><a href="{$product.link|escape:'htmlall':'UTF-8'}" title="{$product.name|escape:'htmlall':'UTF-8'}">{$product.name|truncate:35:'...'|escape:'htmlall':'UTF-8'}</a></h2> <div class="left_block"> <a class="product_img_link" title="" href="{$product.link|escape:'htmlall':'UTF-8'}" > <img src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home')}" alt="{$product.legend|escape:'htmlall':'UTF-8'}" width="146" height="114" /> </a> <p class="product_desc">{$product.description_short|truncate:220:'...'|strip_tags:'UTF-8'}</p> </div> <div class="right_block"> <span class="visiteur_prod" >{l s='Date de parution :'}<span>{$product.debut}</span></span><br /> <span class="prix_prod" >{l s='Prix de cession :'} {if isset($product.show_price) && $product.show_price && !isset($restricted_country_mode)} <span class="price" style="display: inline;" > {if (double)$product.price >0} {if !$priceDisplay} {convertPrice price=$product.price} {else} {convertPrice price=$product.price_tax_exc} {/if} {else} Faire offre {/if} </span> {/if} </span><br /> <a href="{$product.link|escape:'htmlall':'UTF-8'}" class="detail_prod" >{l s='Détail'}</a> </div> </li> {/foreach} </ul> <!-- /Products list --> {/if} Do i need to add the field $debut in the product class?
  24. Hello Thanks for the reply I have just activated errors. Do you find any possible reasons for these errors? Thanks
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More