Re: [Dave] Web Membership Profile - Error checking a serial number

Thu, 11 Oct 2012 09:29:09 -0700

Hi Dave,

Thanks so much for this - I had been looking at preg_match as an option but wasn't sure how to proceed. This and the resource link are extremely helpful.

I plugged in the following and it's working brilliantly:

// serial error checking 
  $_REQUEST['serial'] = preg_replace("/[^\da-z]/i", '', @$_REQUEST['serial']); // remove chars that aren't a digit or a letter 
  $isValidSerial      = preg_match("/^\d\d[a-z]\d\d\d\d\d\d$/i", $_REQUEST['serial']); // valid format: 2 numbers, 1 letter, 6 numbers 
  if     (!$_REQUEST['serial'])                { $errorsAndAlerts .= "No serial number entered!
\n"; } 
  elseif (!$isValidSerial)                     { $errorsAndAlerts .= "You must enter a valid serial number.
\n"; }

As much as I would like to give our users some hints we're concerned about competitors accessing info only meant for product users. So I get to be a generic as possible with my error messages.

Thanks again - your support is always awesome!

Cricket7475

Web Membership Profile - Error checking a serial number

Wed, 10 Oct 2012 13:33:08 -0700

I've implemented the website membership plugin on our site and it's working wonderfully. Shortly after launching I got a request from Marketing to enhance security by adding a serial number field with error checking.

Here's what I'm trying to do:
- Limit entry to 9 characters (and stripping out any extra spaces introduced by the form user)
- First two must be numbers (i.e. last two digits of a year "12" or "13" etc.)
- Third must be a letter (entered as either upper or lower case)
- The last six should be numbers

Based on this post:
http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/Field_Validation_P92584/gforum.cgi?post=85966

I've modified the code for my purposes as such:

/// Check Serial Number 
   function format_serial_number($serial){ 
	//strip out spaces  
      $tmpSerial = str_replace(" ","",$serial);  
      $tmpSerial = str_split($tmpSerial); 
       
      if(@$tmpSerial[0]==1 && @$tmpSerial[1]==2|3|4|5 && @$tmpSerial[2]==a-z){ //number is in correct format.  Return it as is. 
         
        $serial = implode($tmpSerial); 
      } 
      else{ //error.  The number is in an invalid format. 
         
        return false;  
      } 
       
      return $serial;  
    }
	//format serial number. 
    $serial = format_serial_number(@$_REQUEST['serial']); 
    if(!$serial){ $errorsAndAlerts .= "You must enter a valid serial number! 
\n";}

My questions:
- Will the '$tmpSerial[1]==2|3|4|5' work to display either 2, 3, 4 or 5?
- How do I tell it to allow a-z and A-Z?
- How would I keep the field limited to 9 total characters?

Haven't had a chance to test anything out yet - was hoping to have more coded but got stuck. Any help is appreciated!

Cricket7475

Re: [greg] comments w/membership login redirect

Wed, 26 Sep 2012 10:28:48 -0700

Hi Greg,

Thanks for the response. So you know what I'm working with: CMS Builder 2.14 and Website Membership Plugin 1.07.

I'm not using the comments plugin, and so attempted to add the code to a test page I've been working on. Got an error message when trying to find the best placement for the snippet you provided. Eventually tried placing it at the very end of my page just before the closing body tag and no more visible errors on the page, but in the source I get the same error (minus actual DB info):

Warning: Cannot modify header information - headers already sent by (output started at /home/.../support-test.php:41) in /home/.../support-test.php on line 348

The line number is the line where the snippet has been inserted and as I moved it up and down in the code that line number would change accordingly. And since the cookie isn't being added my redirect isn't working.

Any ideas?

Thanks!
Cricket7475

Re: [charnushka] comments w/membership login redirect

Thu, 20 Sep 2012 15:30:41 -0700

I'm having this same issue - when changing this:
$GLOBALS['WEBSITE_LOGIN_POST_LOGIN_URL'] = '/';
to this:
$GLOBALS['WEBSITE_LOGIN_POST_LOGIN_URL'] = '';

and running through the sames steps as charnuska (minus the comments plugin which I'm not using) the link now directs nowhere, essentially 'working' as you've described - it 'keeps them on the same page' which in this example is the login page.

I'm looking for an immediate redirect back to the original page - the one the user initially clicked on to login. Is this possible? I also couldn't tell if there was ever a solution posted.

Thanks,
Cricket7475

Re: [pogo] CMS Builder v2.12 - wysiwyg boxes stripping hyperlinks - tinyMCE issue?

Mon, 09 Jan 2012 09:21:44 -0800

Hi Tom,

The workaround for my particular application was to replace the wysiwyg field with a text box, and then to stick all the raw html into that text box. All of that was first tested in a sandbox environment created specifically to determine feasibility. Once we confirmed my navigation was working again in the testing environment, I applied the change to my live site and after a slight bit of tweaking it was up and running. I've since upgraded to 2.14 without any issues with the workaround.

If you're experiencing similar issues I'll be the second to say reply with any info you can - your setup details may be vastly different from mine and if this is a tinyMCE bug then the more information about it we can collect the better.

Thanks,
Christine

Re: [Jason] CMS Builder v2.12 - wysiwyg boxes stripping hyperlinks - tinyMCE issue?

Wed, 12 Oct 2011 15:15:22 -0700

Done. Appreciate the help - thanks!

Re: [cricket7475] CMS Builder v2.12 - wysiwyg boxes stripping hyperlinks - tinyMCE issue?

Tue, 11 Oct 2011 14:43:22 -0700

Update - Here's what I've done thus far:

1. Duplicated the site in a sandbox environment.
2. Verified everything was working like the original site using CMS Builder 2.01.
3. Upgraded the CMS to 2.12. Upgrade appeared to install without issue, just like the previous attempt.
4. Checked navigation menus complete with flyouts - everything is working fine.
5. Cleared the cache.
6. Check the nav menus again - everything works fine.
7. Go into the Section Editor for the navigation and view the nav code via a wysiwyg box, and notice the tags have been removed from the code.
8. Save the entry.
9. Refresh the page and all my nav is gone (as would be expected if all the links are missing).
10. Go back into the section editor, wysiwyg box in the HTML view and attempt to add the links back into the code. Click Update.
11. Save the entry.
12. Refresh the page, still no nav.
13. Go back into the section editor, and confirm that specific entries have been 'stripped'.

At this point it appears that only tags contained within divs are being stripped. tags within

tags are left alone.

As in my earlier post, the 'home' link is still being stripped, and the reason my flyouts no longer work is because that code is also being stripped from the div tags. For example:

alt="Products" title="Products" href="/products.php">

becomes

I've tested other features of our site and at this point everything appears to function completely normally.

Ideas?

Thanks in advance,
Christine

Re: [Jason] CMS Builder v2.12 - wysiwyg boxes stripping hyperlinks - tinyMCE issue?

Wed, 05 Oct 2011 13:31:24 -0700

Hi Jason,

I'm not sure it's unrelated per say. The navigation is pulled into each page via a 'common' section editor where I've placed the common page elements like footer info, copyrights, and navigation. Within that section editor there's a wysiwyg box called 'navigation' where all the HTML is loaded that controls the sites nav menus. That entry is pulled into each page via

Here's what one link example for the home page looks like in the HTML Source Editor of that wysiwyg box when it's functioning 'normally' within 2.01:

with 2.12 I could paste that code in, click 'update' and then even before saving if I went in to verify the code was correct I would see this:

Thinking I may have forgotten to click 'update' I would put the code in again, click 'update' then save the entry, only to open it back up and find the 'stripped' version. I even changed around the order of the elements within the tag thinking that because it didn't see the href first it flagged it - still stripped it out.

So before even getting to the flyout issue I was having problems. I have not linked anything directly to an jquery files within the CMS folders, so I'm pretty sure that's not an issue, but I'll verify to be sure.

Everything else appeared to work fine. Images for various pages still appeared, links functioned from what I can tell, but the nav issue was so great I didn't take a whole lot of time to test other items out before restoring the working version. I'm using Firefox 7.0.1 in case that has any bearing on the issue.

I'll start on the subdomain sandbox and see if I can duplicate the issue there. Will keep you posted.

Thanks,
Christine

CMS Builder v2.12 - wysiwyg boxes stripping hyperlinks - tinyMCE issue?

Wed, 05 Oct 2011 12:20:42 -0700

Hi,
Last night I upgraded from 2.01 to 2.12. When viewing the site post-upgrade it appears that all the wysiwyg boxes are stripping code. Specifically any tags. I also found that any scripts no longer functioned. This was apparent as the upgrade effectively broke all the navigation on my site - including flyout menus. The navigation became 'blank'. I had been populating the navigation via one wysiwyg entry within CMS.

I've reverted back to 2.01 (which is unfortunate but at least it's working again). While on 2.12 I attempted the steps listed in this post as I've seen that issue in previous versions, however it did not fix this issue:
http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/2.12_upgrade%2C_WYSIWYG_graphics_gone%21_P90151/gforum.cgi?post=89879;search_string=tinyMCE;t=search_engine#89879

I'm assuming it has something to do with valid_elements and extended_valid_elements options in the tinyMCE.js file based on web searches, but I hesitate to change that file without checking with you to verify if you've seen this issue before and if so what the fix is.

Any insight you can provide would be helpful. Let me know what you'd have me upload regarding files (btw I left you a voicemail this morning). I want to upgrade so that we can use the membership plugin, which can't happen while running v2.01.

Thanks,
Christine

Re: [Dave] Limiting display of records based on multiple lists from db

Fri, 15 Jan 2010 10:41:31 -0800

OK - So here's the SQL

SELECT SQL_CALC_FOUND_ROWS `documents`.* FROM `ysicms_documents` as `documents` WHERE ('application' = 5) AND documents.hidden = 0 ORDER BY id

Which looks like it's doing what it's supposed to be doing, assuming that for 'documents.hidden' the '0' means false, as I have no hidden documents in that section right now.

When I apply the second test I get this:
Array ( )

Which is telling me that it's not displaying any documents that meet the 'where' criteria even though they exist.

If you see anything out of sorts with the above let me know - I'm not sure I'm seeing things right between the lack of sleep and the sinus meds :)

I'll send you what I can in an email - in the meantime, I'm going to try to recreate the scenario on a page which has the bare minimum and see if I can get it to work.

Thanks again!

Re: [Dave] Limiting display of records based on multiple lists from db

Thu, 14 Jan 2010 12:30:27 -0800

Thanks Dave,

So if I understand correctly, I should be able to set up a 'where' clause for the documents array that limits the documents pulled to just those whose selected application includes the applicationsRecords['num'] ...right?

Hypothetical:

If the 'application' selection list is no longer a multi value but rather a single radio button option, then I would think this (or something similar to this) would work:

list($applicationsRecords, $applicationsMetaData) = getRecords(array(
    'tableName'   => 'applications',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $applicationsRecord = @$applicationsRecords[0]; // get first record
  
  // show error message if no matching record is found
  if (!$applicationsRecord) {
    print "This application is no longer active.  Please go back and select another.  Thank you!";
    exit;
  }

list($documentsRecords, $documentsMetaData) = getRecords(array(
    'tableName'   => 'documents',
     'where'       => "'application' = ".mysql_escape($applicationsRecord['num'])."",
    'allowSearch' => '0',
  ));

and the php on the page

However, even after I make those changes and reassign values to the document entry, it still doesn't display. Which makes me think my 'where' clause isn't working. Before I get into the multi value fields I'd like to see if I can get the single value field to work.

I've attached the applicationsDetail.php viewer which is the one I'm currently working on and the one that is currently populating the live page (minus the db locations). This viewer applies to all applications available from this page: http://www.ysi.com/applications.php
Right now I have 5 documents in the system for testing, all of which should show at the bottom of the documents tab below the last horizontal rule.
1 under ocean application (record number 2):http://www.ysi.com/applicationsdetail.php?Ocean-and-Coastal-Monitoring-2
2 under surface water application (record number 5): http://www.ysi.com/applicationsdetail.php?Surface-Water-5
2 under wastewater application (record number 7): http://www.ysi.com/applicationsdetail.php?Wastewater-7

Thanks again!

Limiting display of records based on multiple lists from db

Wed, 13 Jan 2010 21:57:43 -0800

I've searched the forums and tried several things, but can't seem to get the code right. Here's my scenario:

I'm building a document repository with CMS Builder. Each document is assigned to several different categories, based on existing tables. In this case,

Document Type - a category menu I created
Application - a multi value check box list getting its values from the applications table (option values=num, option labels=title)
Related Products - a multi value pull down list getting its values from the products table (option values=num, option labels=title)

The code generated by CMSB for the head as well as Applications and related Products field is:

list($documentsRecords, $documentsMetaData) = getRecords(array(
    'tableName'   => 'documents',
    'allowSearch' => '0',
  ));

Application: 

Related Products:

On various pages within the site I want to only show specific combinations. For instance,

On individual applications pages (which are generated from a 'multi' menu type) , I want to show the specific document type of 'application note', and documents which have the same application as the application page I'm viewing (i.e. surface water application notes on the surface water application page).

In the code below, document_type '1' equals 'application note'

That code successfully shows all application notes on all application pages, which was not my goal [:P]

It seems that when I attempt to filter for application type, it's eliminating all types because of the multi value options. How do I tell the system essentially
"if your document_type is an application note, and if one of the selected application check box's names matches the title of the application page you're on, display in this list"? And how do I accomplish that on a 'detail page' viewer? My concern is that if I started using 'where' clauses in the head section that I would be setting up the viewer to only work for one application page as opposed to having it 'universal'. By the way, the code for the 'applications page title' is:

You can see a manually coded list example of what I'm trying to attempt on this page: http://www.ysi.com/applicationsdetail.php?Aquaculture-1
Check the Documents tab - I'll have multiple lists based on document_type on this tab, all hopefully coming from the document repository (manually keeping track of all our documents is a huge pain! :)

I'm going to be attempting to do the same thing with product pages, in the sense that on a product page, I'll have multiple lists of documents organized based on doc type. I'm thinking if I could understand how this application page stuff works, I'd have a better chance of correctly coding the product pages. That tab is currently hidden until I can figure this out.

I'm hoping the answer is simple, and it's eluding me simply because I've been staring at the code too long. Any insight would be a great help. Thanks!

Re: [chris] Passing variable in URL results in no CMS access

Mon, 12 Oct 2009 08:37:14 -0700

That worked - still learning php and all it's nuances. Thanks for the help!

Re: [dwelling] Passing variable in URL results in no CMS access

Fri, 09 Oct 2009 16:05:29 -0700

HI - I'm having an identical problem...

Here's the background for my issue:

1. It's a news page where the detail of the news story is in the right column, and a list of up to 10 news stories is in the left column, all populated from the same table.
2. The newsdetail.php page i created includes links back to the CMS for all the navigation menus, logo, footer content & links, etc.
3. When I click on the first article, the page loads beautifully - all the menus appear as well as all the footer links. The URL ends with a '1'.
4. When I click on the second news item everything breaks. No menus, an error where the logo should be, no footer content, etc. The URL ends with a '2'.

Changing the number on the end to a 1 or 0 loads the first news story and everything else on the page wonderfully.

Changing the number on the end of the URL to anything other than 1 or 0 results in a 'mis-loaded' page. The correct article shows, but none of my menus or footer content loads (essentially nothing else from the CMS loads).

And I need to load records greater than 1 as I'm anticipating many news stories to be populated in this page.

I've tried the 'allowSearch' => '0', also, but that doesn't help either.

That said, any ideas?

I've attached a slightly modified version of the file I'm having issues with. I took out the full URL in the 'require_once' line. Any insight & fixes would be appreciated.

Love the product by the way - using it on 2 company sites already and have 2-3 more planned after I finish up this project.

Thanks.