Debug Line 181 $queryfindorders->where

Debug Line 182
Orders found that need reminders i.e.
within the time period since order CONFIRMED (0.5 MINUTEs),
within the time period since reminder LAST SENT (1 MINUTEs),
correct Status C,
have no review OR have no reminder AND send_email = 1

Debug Line 183 $orders
Array
(
    [0] => stdClass Object
        (
            [virtuemart_order_id] => 405
            [email] => test2@gjcwebdesign.com
            [user_realname] => Test Name
        )

)

Debug Line 236 $queryfindproducts
JDatabaseQueryElement Object
(
    [name:protected] => WHERE
    [elements:protected] => Array
        (
            [0] => `a`.`virtuemart_order_id`=405
        )

    [glue:protected] =>  AND 
)

Debug Line 237 $products
Array
(
    [0] => stdClass Object
        (
            [id] => 2
            [state] => 0
            [virtuemart_order_id] => 405
            [order_number] => 4XDR0404
            [user_id] => 330
            [user_name] => test2
            [email] => test2@gjcwebdesign.com
            [user_realname] => web
            [user_city] => web
            [user_country] => United Kingdom
            [product_id] => 263
            [product_name] => Polychrome Jasper
            [product_image] => /images/stories/virtuemart/product/polychrome-jasper-polished-oval.jpg
            [product_desc] => 
            [catid] => 13
            [catname] => Crystals Rocks Minerals
            [manuid] => 0
            [manuname] => 
            [cost] => 19.99
            [review] => Wonderful... bought as a gift for my wife...  very pleased
            [rating] => 5
            [reminder] => 0
            [helpful] => 0
            [datestamp] => 2021-01-02 16:32:52
            [lastdatesent] => 0000-00-00 00:00:00
            [admin_comment] => 
            [send_email] => 1
            [order_status] => C
            [order_language] => en-GB
            [modified] => 2018-07-20 18:53:52
        )

    [1] => stdClass Object
        (
            [id] => 3
            [state] => 0
            [virtuemart_order_id] => 405
            [order_number] => 4XDR0404
            [user_id] => 330
            [user_name] => test2
            [email] => test2@gjcwebdesign.com
            [user_realname] => web
            [user_city] => web
            [user_country] => United Kingdom
            [product_id] => 515
            [product_name] => test
            [product_image] => /images/stories/virtuemart/product/polychrome-jasper-polished-oval.jpg
            [product_desc] => 
            [catid] => 0
            [catname] => 
            [manuid] => 0
            [manuname] => 
            [cost] => 0.01
            [review] => 
            [rating] => 0
            [reminder] => 0
            [helpful] => 0
            [datestamp] => 2021-01-02 16:32:52
            [lastdatesent] => 0000-00-00 00:00:00
            [admin_comment] => 
            [send_email] => 1
            [order_status] => C
            [order_language] => en-GB
            [modified] => 2018-07-20 18:53:52
        )

)

Debug Line 253 $products_text

1: Polychrome Jasper
2: test

Debug Line 292 $siteurl
https://www.stonemania.co.uk

Debug Line 293 order lang
en-GB

Debug Line 294 $htmlmail
Dear {name},

On the {date} you bought our {product}

If you are satisfied with this product we would be delighted if you would leave a review on our site.

If registered simply login and browse to 'Your Account' where you will be able to submit your review.

If you purchased as a guest then click the link below.
{link}

If you wish to opt out from these reminders then click the link below.
{optoutlink}


Yours faithfully,
{site}

Debug Line 295 $url
https://www.stonemania.co.uk/index.php?option=com_vmreview&view=orderrev1ewsform&enter_email=test2@gjcwebdesign.com&enter_ordernumber=4XDR0404

Debug Line 296 $link
Stone Mania - Leave A Review

Debug Line 306 $subject
Review reminder from  : Stone Mania

Debug Line 307 $link
Stone Mania - Leave A Review

Debug Line 340 $body
Dear Test Name,

On the 2018-07-20 18:53:52 you bought our
1: Polychrome Jasper
2: test


If you are satisfied with this product we would be delighted if you would leave a review on our site.

If registered simply login and browse to 'Your Account' where you will be able to submit your review.

If you purchased as a guest then click the link below.
Stone Mania - Leave A Review

If you wish to opt out from these reminders then click the link below.
Stone Mania - Opt out from these reminders


Yours faithfully,
Stone Mania

Debug Line 346 $reminder2
1

Debug Line 389 $sento
Array
(
    [0] => test2@gjcwebdesign.com | Test Name | 4XDR0404 |  1: Polychrome Jasper 2: test  | Reminder: 1 | Status C Date: 2018-07-20 18:53:52
)

Crystals Rocks Minerals from Around the World
Crystals Rocks Minerals to Tempt and Tantalise You
 x 

Crystals Rocks Minerals

 

 

Results 1 - 24 of 132

Agate Stone

Product Code: LBVL
COM_VIRTUEMART_PRODUCT_SALESPRICE2£24.50

Amethyst Geode

Product Code: SAAX
COM_VIRTUEMART_PRODUCT_SALESPRICE2£88.00

Amethyst Point

Product Code: AMHB
COM_VIRTUEMART_PRODUCT_SALESPRICE2£68.99

Amethyst Point

Product Code: AMAY
COM_VIRTUEMART_PRODUCT_SALESPRICE2£71.10

Black Quartz Cluster

Product Code: GLQZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2£161.00

Blue Calcite Stones

Product Code: BCRC
COM_VIRTUEMART_PRODUCT_SALESPRICE2£0.48

Blue Chalcedony

Product Code: FTHB
COM_VIRTUEMART_PRODUCT_SALESPRICE2£14.99

Briolette Crystals

Product Code: BRCR
COM_VIRTUEMART_PRODUCT_SALESPRICE2£1.20

Charoite Stone

Product Code: CCCZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2£23.99

Green Fluorite Crystal

Product Code: GKKG
COM_VIRTUEMART_PRODUCT_SALESPRICE2£18.99

Kambaba Jasper Stone

Product Code: XEYO
COM_VIRTUEMART_PRODUCT_SALESPRICE2£17.99

Purple Fluorite

Product Code: FTOK
COM_VIRTUEMART_PRODUCT_SALESPRICE2£13.35

Pyrite Cluster

Product Code: PPTV
COM_VIRTUEMART_PRODUCT_SALESPRICE2£23.50

Pyrite Nugget

Product Code: IPYN
COM_VIRTUEMART_PRODUCT_SALESPRICE2£24.75

Rainbow Fluorite Crystal

Product Code: FLXT1
COM_VIRTUEMART_PRODUCT_SALESPRICE2£16.99

Rainbow Fluorite Crystal

Product Code: FLXT
COM_VIRTUEMART_PRODUCT_SALESPRICE2£14.99

Rhodonite Crystal

Product Code: RXXZ
COM_VIRTUEMART_PRODUCT_SALESPRICE2£6.99

Sugilite Sphere

Product Code: ASYU
COM_VIRTUEMART_PRODUCT_SALESPRICE2£382.00

Kyanite

Product Code: OFPK
COM_VIRTUEMART_PRODUCT_SALESPRICE2£12.99

Petrified Wood

Product Code: LIRP
COM_VIRTUEMART_PRODUCT_SALESPRICE2£38.50

Sodalite Points

Product Code: TSPT
COM_VIRTUEMART_PRODUCT_SALESPRICE2£10.20

Black Tigers Eye

Product Code: BPOT
COM_VIRTUEMART_PRODUCT_SALESPRICE2£18.99

Rhodochrosite Stones

Product Code: TNRS
COM_VIRTUEMART_PRODUCT_SALESPRICE2£7.99

Aquamarine

Product Code: BCOB
COM_VIRTUEMART_PRODUCT_SALESPRICE2£42.99

Account Login

Follow Us On...

Reviews on Trustpilot

Available Right Now
Online Support

Have a Question? Chat with Us.

Start Chat with