Re: [greg] Create page on admin & hide record with same name

Thu, 13 Sep 2012 11:52:40 -0700

Thanks for your quick reply

I'm using 2.17
Membership 1.07
Table "accounts" (default)
Separate Log in is set to false

The issue is as you suspect the iframe is not using the "main" page's (CMB'S) session rather its own.

I know this will work if it opens in a new page but I specifically wan this to work seamlessly within CMSB.

Any help would be greatly appreciated.

Regards,

PS. I actually was the one who commissioned CMSB to build this feature, it would be great if the "include pages" where actually php includes and not iframes.

Re: [Jason] Create page on admin & hide record with same name

Tue, 11 Sep 2012 09:55:40 -0700

I have membership plugin.

I've included viewer_functions.php in the iframe include file

I've added if (!$CURRENT_USER) { websiteLogin_redirectToLogin(); } to the iframe include file

When i access the include page from within CMSB, I'm required to log in again (the log in screen appears within the iframe) even though I'm already logged in.

What can i do to avoid this double log in?

Thank you

Re: [Jason] Advanced select query within CMSB framework?

Mon, 02 Jul 2012 13:00:30 -0700

Also, the way i had it... there was a single call the the database.. using $count_of_children would add say 30 database calls (on per record listing)

Re: [Jason] Advanced select query within CMSB framework?

Mon, 02 Jul 2012 12:57:16 -0700

Thanks for the suggestion, two questions.

1 .From an efficiency perspective is using getRecord() much more overhead then how I had it? (say we were taking about 10,000 records)?

2. If its true that there is a significant difference between calling a few fields (the way I had it) vs every field (getRecords) is there a way to specify the desired field while using gerRecords?

Thank you.

Advanced select query within CMSB framework?

Fri, 29 Jun 2012 11:46:03 -0700

I have an advanced query that works as expected.
(lists forum treads with a comment count and the most recent comment date if exists...)

I would like to incorporate this query into the CMSB standard "list... getRecord" method so that I can use CMSB's pagination.

Any ideas?

==================================================================

$result = mysql_query("
SELECT p.num, p.subject, p.user_id, c.hidden, c.type, COUNT(CASE WHEN c.hidden=0 AND c.type='F' then c.num ELSE NULL END) as count_of_children, CASE WHEN COUNT(CASE WHEN c.hidden=0 AND c.type='F' then c.num ELSE NULL END)=0 THEN p.createdDate ELSE MAX(c.createdDate) END as last_date
FROM {$TABLE_PREFIX}forum_threads p
LEFT JOIN {$TABLE_PREFIX}comments c ON p.num=c.parent_id
GROUP BY p.num, p.subject, p.createdDate
ORDER BY last_date DESC
");

==================================================================

Re: [Tom P] No updates since December 11?

Mon, 16 Apr 2012 14:50:39 -0700

Thank you for the update, impressive...

Re: [Tom P] No updates since December 11?

Mon, 16 Apr 2012 09:45:04 -0700

Any updates?

Re: [Damon] No updates since December 11?

Thu, 29 Mar 2012 12:42:08 -0700

• The ability to managed child records from within the parent record is currently possible only using hacks; it would be great if this was a built-in fully functional future.

• The view screens can use a facelift

• This one is big [:)] maybe it can make its way into Dave’s BIG PLANS – Take CMS Build to the Major Leagues by developing the system to look something

like this http://themeforest.net/item/dream-works-responsive-admin-template/full_screen_preview/1988987

or this http://revaxarts-themes.com/whitelabel/dashboard.html

Re: [Tom P] No updates since December 11?

Wed, 21 Mar 2012 12:11:01 -0700

So your saying that the silence will be followed by a boom?

Would you have a eta on the storm?

Just slightly concerned about the future of CMSB.

No updates since December 11?

Wed, 21 Mar 2012 00:05:07 -0700

Hi,

Whats going on in the kitchen at interactivetools?

There have not been any updates in close to 4 months.

Is all well?

Re: [Toledoh] OR...

Tue, 28 Feb 2012 20:13:17 -0800

Try this

// load records 
list($sponsorsRecords, $sponsorsMetaData) = getRecords(array( 
	'tableName'   => 'sponsors', 
	'where'       => "category != 'Energex' OR category !='Fitzpatrick' ", 
 ));

Re: [Perchpole] Quickie Request: createdByUserNum

Wed, 27 Oct 2010 20:03:24 -0700

This should do the trick
"createdBy.fullname"

Re: [Dave] Notice: CMSB Upcoming Features and Development Plan

Wed, 27 Oct 2010 19:44:54 -0700

Here are a few features that would be great.

Dependable Fields: For example - if field "has_dvd_palyer" is checked, then show this filed "dvd_palyer_color"

Dynamic Fields: (When a filed is set as dynamic the field will have a plus symbol near it, when clicked a additional filed of the same type would be added) For example - For example - say we have family section which has three fields father, mother and child when the child field is set as dynamic the user can simply click on the plus symbol to add additional children. this can be further enhanced by enable fields to be grouped allowing for the plus symbol to add multiple fields. For example - say we have a company section and a group of fields called contact which contains name email and phone, when the user would click on the plus symbol the system would add the fields in the group.

Re: [Dave] css conflict bug version 1.23

Wed, 17 Dec 2008 18:20:14 -0800

thanks

Re: [Dave] css conflict bug version 1.23

Wed, 17 Dec 2008 16:09:16 -0800

wonderful,
on a different note, when will cms builder be able to accept content from site visitors? ie though a feedback form

css conflict bug version 1.23

Tue, 16 Dec 2008 08:29:48 -0800

if a field is created with the Field Name as "main" and the Field Type as "wysiwyg" when one attempts to view the section in the back-end that contains this Field the display is totally out of whack

Re: [Dave] Sorting

Wed, 28 May 2008 22:48:28 -0700

thanks

Re: [Dave] Sorting

Wed, 28 May 2008 19:38:25 -0700

Is it true that once "dragSortOrder" is placed in the "Order By" field, newly cerated items are displayed on the bottom of the list. if however, "dragSortOrder DESC" is used, newly cerated items are displayed on top?

I would like my items listed by "updatedDate" then by "title" until i manually use drag sort to rearrange them, is this possible?

Re: [Dave] Editable field from the editor list view

Wed, 28 May 2008 09:07:42 -0700

I checked out the "dragSortOrder" feature its really great, nice work.

Re: [Dave] Sorting

Wed, 28 May 2008 09:06:09 -0700

the "dragSortOrder" feature is superb! good work.

Editable field from the editor list view

Tue, 27 May 2008 16:03:24 -0700

I'd vote for the drag sort order. but it would also be cool to have a option in the properties of a given field, some thing like "make editable in list viewer" this will enable users to easily change an articles status say to "featured" or "active"... by using a check-box or drop-down.

Sorting

Tue, 27 May 2008 15:48:34 -0700

It would be great if items of a section could be sorted in the back end using ajax (similar to the way sections are sorted in the back end) and for this order to display on the front end as well

What do you say?

Re: [Dave] Is there a jump to page feature?

Mon, 19 May 2008 17:47:31 -0700

exactly, thanks much.

Page Numbers

Mon, 19 May 2008 13:55:50 -0700

I have been using CMS Builder for a few months and i'm loving its power and flexibility... great job!

The current page numbers display "<< prev - page 5 of 8 - next >>"
it would be nice to see the page numbers displayed "<< prev - 1 2 3 4 5 6 7 8 - next >>" with the ability to click on any of the numbers and go directly to the specified page.

$options['where']

Tue, 19 Feb 2008 13:29:25 -0800

Example: 'fieldname = "value"'

I’d like to call a variable for the value, what do I do? == Example: 'fieldname = "$var"' == dose not work