schmutly

Thanks Stuart,
will do.

Thanks guys…IDIOT!!! (me lol) why on earth was i passing the $product for when
it’s only used for the activation of the software, nothing to do with the IPN side.
Sorry..see, sometimes it just takes another pair of eyes.
It didn’t click for me to change it (tired? hmm.)
thanks:

$wpdb->update($table_name, array(
	'payment_status' => $payment_status
) , array(
	'payer_email' => $payer_email,
	'item_name' => $item_name
));

All good now. Thank you both.Great plugin and support.
Kind, and expert PayPal professionals.. ??
Cheers,
Rob

• This reply was modified 6 years ago by schmutly.
• This reply was modified 6 years ago by schmutly.

Hi Oliver,
i must be misunderstanding the codex at that point. I thought THAT array was my “where”
statement. I’m coming from Mysql side and the serial/product are strings compared from a software activation.
So if there was a refund i wanted to update that row in database to “Refunded” from being “Completed” in my DB.
So it was meant to be: update payment_status where payer_email = &serial AND item_name= $product. I might have the 2nd array incorrect :/
I must have that part wrong as you pointed out i am “adding” those 2 variables when in fact i’m wanting to update a row on condition of those 2 variables so that the correct row is updated from Completed to Refund.
hmm..scratching head, I’ll go sleep on it and try again tomorrow.

• This reply was modified 6 years ago by schmutly.

Oh, forgot… while waiting for reply
just donated too. Thanks…great plugin and support.
Transaction ID: 2G479203JT333531A
Rob

Oliver and Angell have always been extremely helpful even if we ask dumb questions.
It’d be nice to borrow their brains for a day, I’d get a lot done.
If you have issues with PayPal plugins or just PayPal in general these are the guys to goto ??
Thanks again for the clean code
Rob.

Thanks muchly Oliver.
I will try that shortly. While waiting i went looking and came up with this (which works too) but now i need to process yours to see what i did wrong (to learn and understand)
I came up with https://pastebin.com/LLnJcPAJ but i will go with your paste ??
Thank you..will leave a review after this.
Rob
ps where’s the “leave a support review” link again?

• This reply was modified 6 years, 1 month ago by schmutly.

ok thanks, but whats the correct syntax ?
Is it:
UPDATE nsvideo_nvmain.sd_options SET option_value = ‘a:2:{i:2;a:33:{s:5:”title”;s:42:”Recently Released.. ECT..ECT.. ??
I tried this and had to restore my DB lol. Sorry, just not sure.
I think i supposed to put WHERE option_id= field.?
Thanks
Rob

ps: usually i’d click in a field change it then hit enter. But i want to send a command each week to just update the option value field with automation script.

Hello,love your plugin ??
In the: “…by selected IDs: Please enter Product IDs with comma separated. ” each week i need o change these ids. Can you tell me the Mysql command to update just these IDs for the plugin?
I tried:
REPLACE INTO sd_options (option_id, option_name, option_value, autoload) VALUES
(994370, ‘widget_woocommerce_products_carousel_all_in_one’, ‘a:2:{i:2;a:33:{s:5:”title”;s:42:”Recently Released DVD & Blu-Ray Movies…”;s:8:”template”;s:10:”simple.css”;s:9:”all_items”;s:2:”55″;s:9:”show_only”;s:6:”newest”;s:8:”products”;s:384:”713371,713331,713508″;

ETC…..But it says OK, when i go back to widget it has disappeared !?
Can you tell me way of doing this please?
Thank you
rob

Hello..
I need to have this show in my rightbar but i cant add it as a widget
and need to add it as a SHORTCODE or to a html page.
Is there a SHORTCODE?
Thank you,
Rob

Ok…ill give that a try, thanks.

Daniel, that above code..where does it go?
One of my modal windows is an image heavy instructions popup so i need that content only to load if they click on the button..The above code should do it? And placed where? At the moment it takes 10 secs to load the page because of the content and images in the modal window, and iss there a way to make it cached so its not needed to load each time they visit the page?
Thanks muchly,
Rob

On the issue of loading…my sites been excruciatingly slow and i couldnt work out why. Then i turned off the last few plugins till i found it was this one. According to https://gtmetrix.com/ its taking 18 seconds to load?
WHY? turn it off and site loads in few secs.
Only have 3 modals that load on a different page, and SET for that page…not SITE wide..so dont know why its affecting everything.
Any ideas because there is no other plugin as good as this.
Thank you,
robbie

UPDATE:
I had a CLONE of one of my modals still set to SITEWIDE and i think i know whats wrong…the POPUP has many images in it to explain to customers how to add products and things like that.

Can i please ask..is it possible to only LOAD this modal when its clicked? I’m not totally sure its this but I’d suspect so.

Install Easy Modal plugin…post your shortcode in there.
If you start to fill it out and click outside modal window or even CLOSE the box the data you put in it will still be there (i use it on my site so people can add other rental titles to the form).
Its probably using JavaScript LocalStorage feature i gather but give it a try,..and the modal forms and features are great too.
Easy Modal

OK…well the above didnt work but thats ok ??
I went to the Contact Form 7 forum and found that someone just used a Javascript page refresh, namely: on_sent_ok: “location.reload(true);”
So now:
(1): on_sent_ok: “$(‘.wpcf7-mail-sent-ok’).ajaxComplete(function() {$(this).delay(1000).fadeOut(‘slow’);});” <–This Fades out the SUCCESS BOX
(2):on_sent_ok: “setTimeout(function()$(‘.modal.active’).emodal(‘close’);},5000);”
<–This closes the Modal window after 5 secs.
(3): on_sent_ok: “hideSubmit();” <–my JS to hide the submit button and show an INFO box telling others to add each movie title to the form and when complete to click here…which hides the infobox and shows the submit button (i dont want people submit for 5 movies when they can add 5 to the same form, even when modal window is closed it still retains the inputted info until a “submit” (I’m glad for that..must be using cookies or localStorage)
(4): And finally i needed to do a “REFRESH” to the page because for some reason the “success” box still wasn’t clearing but this refreshed and cleared it–>on_sent_ok: “location.reload(true);” So that’s great…

Just in case someone else needed some info.
Will rate plugin after..thanks again for your help
Robbie

on_sent_ok: “$(‘.wpcf7-mail-sent-ok’).ajaxComplete(function() {$(this).delay(1000).fadeOut(‘slow’);});”

Damn,no good…if i do a CTRL+F5 refresh its gone.
The first code you gave me, when i click to open modal it popups up the closes then opens again..so not sure if its in right place.
I copied it to my:
0:/public_html/wp-content/themes/self-titled/styles/capital-boxed/js/
so assuming this is correct..will have a bit more of a check in case of typos. thx