Title: schmutly's Replies | WordPress.org --- # schmutly [ ](https://wordpress.org/support/users/schmutly/) * [Profile](https://wordpress.org/support/users/schmutly/) * [Topics Started](https://wordpress.org/support/users/schmutly/topics/) * [Replies Created](https://wordpress.org/support/users/schmutly/replies/) * [Reviews Written](https://wordpress.org/support/users/schmutly/reviews/) * [Topics Replied To](https://wordpress.org/support/users/schmutly/replied-to/) * [Engagements](https://wordpress.org/support/users/schmutly/engagements/) * [Favorites](https://wordpress.org/support/users/schmutly/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/schmutly/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/schmutly/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] Serial Number from custom table not appear in woocommerce_email_before_order_tab](https://wordpress.org/support/topic/serial-number-from-custom-table-not-appear-in-woocommerce_email_before_order_tab/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [3 years, 11 months ago](https://wordpress.org/support/topic/serial-number-from-custom-table-not-appear-in-woocommerce_email_before_order_tab/#post-15922956) * Thanks Stuart, will do. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PayPal IPN for WordPress] Updating WordPress table with refund hook …](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [7 years, 4 months ago](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/#post-11233711) * 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 7 years, 4 months ago by [schmutly](https://wordpress.org/support/users/schmutly/). - This reply was modified 7 years, 4 months ago by [schmutly](https://wordpress.org/support/users/schmutly/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PayPal IPN for WordPress] Updating WordPress table with refund hook …](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [7 years, 4 months ago](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/#post-11231481) * 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 7 years, 4 months ago by [schmutly](https://wordpress.org/support/users/schmutly/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PayPal IPN for WordPress] Updating WordPress table with refund hook …](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [7 years, 4 months ago](https://wordpress.org/support/topic/updating-wordpress-table-with-refund-hook/#post-11229733) * Oh, forgot… while waiting for reply just donated too. Thanks…great plugin and support. Transaction ID: 2G479203JT333531A Rob * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PayPal IPN for WordPress] Updating WordPress table with hook not working..](https://wordpress.org/support/topic/updating-wordpress-table-with-hook-not-working/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [7 years, 5 months ago](https://wordpress.org/support/topic/updating-wordpress-table-with-hook-not-working/#post-11192532) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[PayPal IPN for WordPress] Updating WordPress table with hook not working..](https://wordpress.org/support/topic/updating-wordpress-table-with-hook-not-working/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [7 years, 5 months ago](https://wordpress.org/support/topic/updating-wordpress-table-with-hook-not-working/#post-11191663) * 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](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 7 years, 5 months ago by [schmutly](https://wordpress.org/support/users/schmutly/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Products Carousel all in one] Include Other Custom Post Types](https://wordpress.org/support/topic/include-other-custom-post-types/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [10 years, 9 months ago](https://wordpress.org/support/topic/include-other-custom-post-types/#post-6347855) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce Products Carousel all in one] Include Other Custom Post Types](https://wordpress.org/support/topic/include-other-custom-post-types/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [10 years, 9 months ago](https://wordpress.org/support/topic/include-other-custom-post-types/#post-6347853) * 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 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce My Account Widget] Register link is missing](https://wordpress.org/support/topic/register-link-is-missing-1/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 2 months ago](https://wordpress.org/support/topic/register-link-is-missing-1/#post-4832308) * 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 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Easy Modal] Lazy Load](https://wordpress.org/support/topic/lazy-load-4/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/lazy-load-4/#post-4576160) * Ok…ill give that a try, thanks. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Easy Modal] Lazy Load](https://wordpress.org/support/topic/lazy-load-4/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/lazy-load-4/#post-4576157) * 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 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Easy Modal] Lazy Load](https://wordpress.org/support/topic/lazy-load-4/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/lazy-load-4/#post-4576152) * 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 [http://gtmetrix.com/](http://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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Contact Form 7] save unfinished form for later submission](https://wordpress.org/support/topic/save-unfinished-form-for-later-submission/) * [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/save-unfinished-form-for-later-submission/#post-4764226) * 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](http://wordpress.org/support/plugin/easy-modal/page/6) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Easy Modal] Contact shortcode not reseting](https://wordpress.org/support/topic/contact-shortcode-not-reseting/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/contact-shortcode-not-reseting/#post-4725398) * 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’);});” * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Easy Modal] Contact shortcode not reseting](https://wordpress.org/support/topic/contact-shortcode-not-reseting/) * Thread Starter [schmutly](https://wordpress.org/support/users/schmutly/) * (@schmutly) * [12 years, 3 months ago](https://wordpress.org/support/topic/contact-shortcode-not-reseting/#post-4725391) * 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 Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/schmutly/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/schmutly/replies/page/2/?output_format=md)