Jump to content


  • Posts

  • Joined

  • Last visited

About strandoo

  • Birthday 09/19/1961

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

1,744 profile views

strandoo's Achievements

Sr. Member

Sr. Member (5/6)



  1. Ok, a little more research turned up a topic about merging different arrays and that led me to explode my page array then use the above-mentioned json_decode/encode thing to convert to a standard array. I don't quite understand how that works, but it does, so I'm a happy camper. $entriesList = wire('pages')->find("template=options-page, title=$id, limit=1")->explode(['title', 'sku_code', ... ]); $entriesList = json_decode(json_encode($entriesList), true); /// CONVERT TO STANDARD ARRAY
  2. Hi all. This is where my lack of actual PHP knowledge is getting to me. I've inherited a never-completed WordPress website that I'm trying to redo in PW. There are products, categories and product options all supplied as separate CSV files. (These will be edited and uploaded every day, so I will need to eventually import the data with a chron script). Importing and displaying the category and product data isn't a problem, but the product options files contains numerous fields with comma- and pipe-delimited strings which need to be converted into arrays. So, when viewing the product-page (template) for 'Chair 123' (product code 'c123'), I'd normally get all the options like '$options = $pages->find('template=options-page, pcode=c123'); But since there are fields in the options-page that look like "505|501|512" (for color codes), I'll need to get these into an array. Thats' very simplified; the actual options page has about 45 fields, used to present various options in 3 worldwide territories with multiple parts/color combinations for each conditional territory! I should also mention that I have the old WordPress site and can see the custom functions the previous guy had set up and (for me) it's very complicated. Most of it is standard PHP, so I was hoping to use much of it 'as is' as I can. For instance, there's a function on the products page that returns an associative array that looks like this (in the WordPress php): $bt_options = bt_get_product_options($entry["code"]); foreach($bt_options['spec_docs'] as $key => $bt_spec_doc) { $bt_show_download = ""; if($bt_options['spec_docs_territory'][$key] == "E" && $bt_this_territory == "EU") { $bt_show_download = "Y"; } elseif($bt_options['spec_docs_territory'][$key] == "U" && $bt_this_territory == "US") { $bt_show_download = "Y"; } ... } And the bt_get_product_options function starts with this (again from WordPress) function bt_get_product_options($id) { global $wpdb, $bt_colours, $mysql_table; $entriesList = $wpdb->get_results("SELECT * FROM ".$mysql_table['options']." WHERE web_product_code = '".$id."' ORDER BY id ASC LIMIT 1"); $entriesList = json_decode(json_encode($entriesList), true); /// CONVERT TO STANDARD ARRAY if(count($entriesList) > 0){ $output = array(); $output['jquery'] = ""; foreach($entriesList as $entry) { ... /// COMBINATION TERRITORY elseif($key == "comb_territory" || $key == "addnl_subtabs_territory" || $key == "spec_docs_territory"){ $ter_array = explode("|", $tt); foreach ($ter_array as $k => $tr) { $output[$key][] = $tr; } } ... loads more like this ... } } return $output; } TL;DR: Can I use the above in my PW code, provided I swap the WP MySQL bit with $entriesList = $(wire)pages->find("template=options-page, product_code=$id, limit=1) ? (I tried this on a limited set of fields but didn't return anything). Or do I need to do a MySQL request too? And from what I can tell, thet json_decode/encode line should covert the page object to an associative array, correct? Should that work in this case? Thanks for reading this far.
  3. @Robin S Ok, that is concise, clear and – now that I see it – much simpler than I thought. As usual, things are always easier with PW. Many, many thanks.
  4. Hi. Sorry about the confusing title. I suspect this might be a case for the owner selector, but I can't figure it out. I've got Video pages (about 140) where each video can be tagged according to subject (tags are a Page Field displayed with checkboxes). Videos are then added to a Client page, also with a multiple checkbox Page field. A client logs onto his/her page to see a number of videos selected for this client, displayed in a grid with a list of the aforementioned tags in a sidebar. Clicking the tags displays/limits the videos via Ajax. All pretty simple (getting all tags, selecting vids by tag page field). Now the client wants to limit the tag list based on the clients' available videos (so they only see the categories of 'their' videos). I'm not sure how to select just the tags that are included in the videos that are included in the client page. It's probably simpler than I think. I suspect I need to get the 'owners' of the PageField for the videos of the client, but I'm not sure how to construct that. Any pointers? Thanks in advance. Oh, and these are fitness videos. Although, I suppose they could be just about anything... Paul
  5. @AndZyk Thanks for the response, but this doesn't work. I'm using the Body field, a CKEdit textarea field. When the text was imported, wasn't formatted with <p> tags. Those tags are added (via javascript presumably) when a page of that field type is loaded for the first time in the admin. I think one solution might be to just do a find/replace on that field using the API and add <p> and </p> tags, maybe replacing double line breaks with </p><p> or something. Of course, while working on the site, many of those fields are now properly formatted, so I may make things worse on those pages. I'll have a look at the database content before proceeding.
  6. Hi folks. I've just imported about 200 entries into a site. There's a 'biography' text field that imported into a Body field using the CKEditor. My problem is that when I visit any page with this biography field, the text doesn't look properly formatted (the line-spacing is too tight) because it isn't contained by <p> tags. It looks like the <p> tags are added by CKEditor only when you open/save that page in the Admin editor. I don't want to have to open and save every one of those 200 pages. Does anyone know of a way to do this in the API or something? Cheers!
  7. @Zeka I had a chance to try this. Your selector worked perfectly, thanks again!.
  8. Thanks @Zeka! I didn’t know about ‘owner’. That sounds awesome. I’ve clocked off for the day (with a large Negroni) but look forward to trying this first thing in the morning. Reading that post was enlightening.
  9. Hi. Sorry if this has been covered someplace. I've got a Conventions site with Events pages. Among other things, each Event has a bunch of Topics and each Topic can have one or more Speakers. The same Speakers crop up again and again, so I've set up a page field for them. I'd like to display all the Speakers involved in the Event (basically, 'crawl' all the Topics and retrieve the Speakers, deal with duplicates and display them). And, the Topics are 'grandchildren' of the Events page (since I have other items on the Events page and want to keep things tidy🙂). Speakers -- Jane Doe -- John Smith -- Bob Jones Events -- Event One (Event Speakers: Jane Doe, Bob Jones, John Smith) ---- Topics ------- Topic 1 (Speakers: Jane Doe, Bob Jones) (assigned with a Multiple Page field from Speakers) ------- Topic 2 (Speakers: Bob Jones, John Smith) -- Event Two ... Once I found out how to access data on a grandchild page, I did used this selector: $speakers = $page->find('template=topic-page')->event_speakers(); That returned an array which when looped gave me this: 1840|1843 1843|1841 So, that's the IDs of the 3 speaker pages, with one duplicate, but I don't know what to do with this! Any ideas folks? Or is there another way that I'm missing? Thanks!
  10. @Flashmaster82 I've just had a look at how I did this before. I used a select option field to list a booking times (10:00am, 10:30am, etc). I probably got this from someone else on these forums because my comments for the code were more detailed than I usually do! Rather than use the message in the module settings, override it and use a message.php file: $scf = $modules->get('SimpleContactForm'); include("./message.php"); $options = array( 'emailMessage' => $emailMessage, ... Note: you shouldn't need 'offert_typeoffacility' => 'offert_typeoffacility->title' in the options. In message.php, sanitise and get the field title like this: $facility = $sanitizer->int($input->post->offert_typeoffacility); // (other fields)... // To get the value of an Options Field Type, you need to // first get the id submitted // then get all the options for that field // then use the eq for that option to get the title (eq starts with 0, so subtract 1 from the id) $field = $fields->get('offert_typeoffacility'); $all_options = $field->type->getOptions($field); $theFacility = $all_options->eq($facility - 1)->title; $emailMessage = "Hello, Option: {$theFacility} ... "; I try to use Page Reference fields for SimpleContactForm selects now because it's even easier: $theFacility = $pages->get($facility)->title;
  11. I've just encountered the same issue. Tried to install a module on a site I had finished about 5 months ago. Tried adding the various config settings, etc. k07n's suggestion to check the php zip rang a bell. Only then did I see that I was on php 5.x (which I updated to 7.3) and had zip disabled. That did the trick!
  12. Sorry folks. I've decided to restore and do over. Please disregard; I was a bit stressed when I first posted!
  13. Hi all. I'm in a bit of a jam: I've been working on a site and suddenly received the following error (TraceyDebugger installed): Exception: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined (in ....... /public_html/clients/omnia/wire/core/PageFinder.php line 627) I get it on all front end pages. I'm not sure what I did to trigger it but I desperately need to fix it. I do have a backup from yesterday, but I've done loads of updates. Any ideas where to start? Or should I restore and do over?
  14. My 2cents worth: I frequently add a credit line in the footer of my sites and like to provide a field in my settings to add links. To keep the rich text capabilities but strip out the paragraph tags so the content can be used inline, I use this function on the field: function stripParas($string) { $string = str_replace(array("<p>", "</p>"), "", $string); return $string; }
  15. @PWaddict Happy to help. SimpleContactForm and FlyDev's ReCaptcha did all the real work.
  • Create New...