sunfffd

Hello,

What if I will not be storing any of those data? The check should only happens within the validation step.

Or can I do it at the checkout page form before the transaction?

Hi @alexmigf

Thanks! Does that mean the translated strings in WPML will be displayed correctly with the Pro version?

@templateinvaders

Thank you!

Hi @templateinvaders
Thanks, will do!

However if we change the above query, the wishlist in another language does not work.

In a clean install, the function all works. I guess there are some problems with the element_id and trid.

We found that if we change trid to element_id in the query, the function works

SELECT wp_tinvwl_items.ID, t.element_id AS product_id, t2.element_id AS variation_id, wp_tinvwl_items.formdata,wp_tinvwl_items.author,wp_tinvwl_items.date,wp_tinvwl_items.quantity,wp_tinvwl_items.price,wp_tinvwl_items.in_stock,wp_tinvwl_lists.ID as wishlist_id, wp_tinvwl_lists.status as wishlist_status, wp_tinvwl_lists.title as wishlist_title, wp_tinvwl_lists.share_key as wishlist_share_key FROM wp_tinvwl_items INNER JOIN wp_tinvwl_lists ON wp_tinvwl_items.wishlist_id = wp_tinvwl_lists.ID AND wp_tinvwl_lists.type = ‘default’LEFT JOIN wp_icl_translations t ON
wp_tinvwl_items.product_id = t.element_id AND t.element_type = ‘post_product’ AND t.language_code = ‘en’
LEFT JOIN wp_icl_translations t2 ON
wp_tinvwl_items.variation_id != 0
AND wp_tinvwl_items.variation_id = t2.element_id
AND t2.element_type = ‘post_product_variation’
AND t2.language_code = ‘en’
JOIN wp_icl_languages l ON
(
t.language_code = l.code OR t2.language_code = l.code
) AND l.active = 1 WHERE wp_tinvwl_items.author=’2′ ORDER BY date DESC LIMIT 0,99999;

we found that the SQL from the ajax.php script is not getting any results:

SELECT
wp_tinvwl_items.ID, t.element_id AS product_id,
t2.element_id AS variation_id, wp_tinvwl_items.formdata,wp_tinvwl_items.author,
wp_tinvwl_items.date,wp_tinvwl_items.quantity,wp_tinvwl_items.price,wp_tinvwl_items.in_stock,
wp_tinvwl_lists.ID as wishlist_id,
wp_tinvwl_lists.status as wishlist_status, wp_tinvwl_lists.title as wishlist_title,
wp_tinvwl_lists.share_key as wishlist_share_key FROM wp_tinvwl_items

INNER JOIN wp_tinvwl_lists ON wp_tinvwl_items.wishlist_id = wp_tinvwl_lists.ID
AND wp_tinvwl_lists.type = ‘default’
LEFT JOIN wp_icl_translations t ON
wp_tinvwl_items.product_id = t.trid AND t.element_type = ‘post_product’ AND t.language_code = ‘en’
LEFT JOIN wp_icl_translations t2 ON
wp_tinvwl_items.variation_id != 0 AND wp_tinvwl_items.variation_id = t2.trid AND t2.element_type = ‘post_product_variation’ AND t2.language_code = ‘en’
JOIN wp_icl_languages l ON
(
t.language_code = l.code OR t2.language_code = l.code
) AND l.active = 1 WHERE wp_tinvwl_items.author=’46’ ORDER BY date DESC LIMIT 0,99999;

Hi,

I found the Verify column in the settings, thank you very much for the help.

Hi Thanks I have updated to 1.9.5 and also Admin Columns 4.2.2

I can confirm that when I have admin columns enabled, the Verify column will not be shown.

Screenshots:
https://sandbox.curiousfew.com/ev/1.png
https://sandbox.curiousfew.com/ev/2.png
https://sandbox.curiousfew.com/ev/3.png

Thanks, is there a hook I can use from your plugin to add the extra options fields?