Popular Content

Showing most liked content since 10/22/2017 in all areas

  1. 1 point
    Create this snippet: Enabled: checked Unique ID: ordersumcustgroups@cubecart600+ Execution Order: 99 Description: Adds Customer Group Name(s) to Admin Order Summary Trigger: admin.order.index.display Version: 1.0 Author: forums.cubecart.com/topic/53037-orders-to-show-customer-group/ PHP Code: <?php $snippet_ordersumcustgroups = $GLOBALS['db']->misc('SELECT `group_name` FROM `'.$GLOBALS['config']->get('config', 'dbprefix').'CubeCart_customer_membership` AS M INNER JOIN `'.$GLOBALS['config']->get('config', 'dbprefix').'CubeCart_customer_group` AS G WHERE G.`group_id` = M.`group_id` AND M.`customer_id` = '.$summary[0]['customer_id'].';'); if (is_array($snippet_ordersumcustgroups)) { foreach ($snippet_ordersumcustgroups as $membership) {$member_groups[] = $membership['group_name'];} } $snippet_ordersumcustgroups_order['cust_groups'] = isset($member_groups) ? implode(',', $member_groups) : ''; unset($member_groups); $GLOBALS['smarty']->assign('CUST_GROUPS', $snippet_ordersumcustgroups_order['cust_groups']); Make this edit in the admin skin template: orders.index.php, near line 197, find: <div><label>{$LANG.common.email}</label><span><a href="mailto:{$OVERVIEW_SUMMARY.email}">{$OVERVIEW_SUMMARY.email}</a></span></div> On a new blank line after that, add: <div><label>{$LANG.customer.title_groups_membership}</label><span>{if $CUST_GROUPS}{$CUST_GROUPS}{else}{$LANG.common.unknown}{/if}</span></div>
  2. 1 point
    This may be the solution you are looking for: https://github.com/cubecart/v6/issues/1771
  3. 1 point
    Welcome son caocao! Glad to see you made it to the forums. One of the differences between CC615 and the latest version is that a lot of XSS deterrence has been implemented. That means for many events, the correct security token needs to accompany the request. If that correct token is not there, the session will get discarded.
  4. 1 point
    So, for a category record in CubeCart_category table, the 'cat_image' value could be an integer other than zero. Take note of an integer value, such as 36 for example. Then, in CubeCart_filemanager, find the record with file_id of the integer value noted earlier (36, for example). The 'filepath' column must be null or have the name of an actual folder. Does this record exist?
  5. 1 point
    There may be an issue with the database. I hear you say that you can verify that an assigned image will still be selected when returning to edit that category. So, the database should be structured correctly and hold valid data. That leaves the possibility that 'subcategory' images are not being created. In the folder /images/cache/, look for a filename that starts with the name of the master image of a category, and has a .105.jpg ending.
  6. 1 point
    Smarty would not have caused that extent of slowness - it was stupidly slow. Disabling the related product plugin fixed the issue and proved it was something to do with that - probably missing indexes, especially if you have lots of products. The search not working can often be caused by a missing index on the inventory table so do a table by table comparison of the indexes
  7. 1 point
    Sooo...., if the site administrator has implemented this anti-scrape mechanism, then AJAX exchanges of data may fail if the AJAX package does not send the correct cookie - or may actually fail even with all the correct cookies. I have no experience in this scenario. The template parser (Smarty) does not execute any code other than its own Smarty code. Having PHP code in a template is exactly the same as having any other text. It is just plain text and that plain text will be in the final output that Smarty creates. Also, any code that looks like Smarty code but is not Smarty code in a template could cause PHP to crash. For example: <?php echo "Hello {smiley} World" ?> will cause Smarty to quit parsing the template and stop PHP with a Fatal Error. Please know that you must not think the templates are PHP code scripts just because the filenames end in .php. (The templates can be named anything, and I do not know why the programmers chose '.php' as the filename suffix for the skin templates.)
  8. 1 point
    It is best to make sure the data going into the table is correct in the first place so bsmithers solution will do that. If you have a lot of data already in there you can change existing post codes by running queries on the tables with post codes in e.g In the order summary table you can update post codes by using the following queries UPDATE `cc_CubeCart_order_summary` SET `postcode` = UPPER( `postcode` ) UPDATE `cc_CubeCart_order_summary` SET `postcode_d` = UPPER( `postcode_d` )
  9. 1 point
    That worked. Thank you very much. RLN
  10. 1 point
    Can you believe that CubeCart has been around since 2003? What started out as a small project has snowballed powering thousands of stores globally. If you have a success story you would allow us to publish we would be truly very grateful if you could share it with us. We need new merchants to realise the potential they have using CubeCart. This will help contribute to further growth, new features and an all round brighter future for everyone. Please feel free to email me personally at al@cubecart.com with your company name, store URL and short success story of upto say 300 words. Many thanks to you all for your support.