I'm looking at the table issue right now. What browser are you using?

You can send details to me (claire@interactivetools.com) and I'll take a look.

Thanks!

Can you give us a better idea of exactly what you're trying to do? Have you tried the Send Test SMS link on the plugins admin page?

This is not standard in PHP! Normally you'd want to escape every possible input, but the mysql functions built into CMSB handle escaping for arrays as a convenience.

If you're passing in an array, you shouldn't need to escape the data in the array. You should only need to escape if you're passing non-array variables, such as a string for a WHERE clause.

What kind of behaviour do you see? Do you get any error message, or does nothing happen?

The new version of CMSBuilder will be responsive, so hopefully you won't have to deal with this issue then.

And this: https://productsfeed.wordpress.com/2015/03/26/how-to-stop-spam-referrals-and-filter-them-from-google-analytics-using-htaccess/

I'll check in with the other devs and get an answer for you - I'm not sure offhand.

If I recall correctly, the permalinks plugin should have a database of all the permalinks and you should be able to copy it normally to a new CMSB install. Have you got that plugin on your old site?

I believe we don't have anything like this, unfortunately. It would have to be  a custom plugin. Please email consulting@interactivetools.com with some more information and we'll see what we can do for you.

This sounds like something very custom, so I'd have to refer you to consulting. Can you email consulting@interactivetools.com with more information please?

// load record from 'code_types'
  list($code_typesRecords, $code_typesMetaData) = getRecords(array(
    'tableName'   => 'code_types',
    'where'       => 'num = '. mysql_escape($_REQUEST['num']),
    'orderBy'     => 'title',
    ));
  $code_typesRecord = @$claim_typesRecords[0]; // get first record

There's no built-in functionality to do this - it would have to be custom made. There is no official way of doing anything on the front end of CMSB, so it's really up to you! If you're having issues with the code you've already written for this, we could take a look at it through consulting. The email address is consulting@interactivetools.com if you want to send us a query.

Also, this getRecords for the code type doesn't appear to be getting any specific record - is that intended?

// load record from 'code_types'
  list($code_typesRecords, $code_typesMetaData) = getRecords(array(
    'tableName'   => 'code_types',
    'orderBy'     => 'title',
    ));
  $code_typesRecord = @$claim_typesRecords[0]; // get first record

I don't see anything offhand that looks wrong about this code.

Can you send in a support request please? I'd like to take a closer look at this.

Thanks

Désolé, il n'y a pas de filtre comme ça dans CMSB. Nous pouvons créer un filtre si vous avez besoin - envoyer un email à consulting@interactivetools.com s'il vous plait.

Sorry, there is no filter like that in CMSB. We can create a filter if you need it - please email consulting@interactivetools.com.

I'll refer this to Dave for possible inclusion in a future CMSB release, but if you need something sooner for this problem, just let us know.

I think the CSV Export plugin may do this for you. I'll take a look and see if it'll work.

<?php
  require_once "........./lib/viewer_functions.php";

  list($afishRecords, $afishMetaData) = getRecords(array(
    'tableName'   => 'afish',
    'where' => 'date <= "'.date('Y-m-d H:i:s', time()+(60*60*24*7)).'" AND date >= "'.date('Y-m-d H:i:s', time()).'"',
  ));

?>