How many section editors?

18 posts by 5 authors in: Forums > CMS Builder
Last Post: February 3, 2011   (RSS)

By roddruce - August 23, 2008

Each single page section editor I create has its own sub-domain and a user (client) for a restaurant menu.

How many of these SE can I create using the one database? Would a thousand be too much for CMS builder? I would hate for any corruption to occur.



Cheers - Rod

Re: [roddruce] How many section editors?

By Jake - August 24, 2008

Hi Rod,

Thanks for posting!

The main limit here is going to be the MySQL database on your server. I'd suggest emailing your web hosting company to see if they have any restrictions on the amount of tables that could be added to a database. You might notice that things slow down a bit, but MySQL should be able to handle that much data.

CMS Builder should also be able to handle it, but note that your section editor drop-down menu would get pretty unwieldy if it contained a thousand entries.

I hope this helps. [:)]
-----------------------------------------------------------
Cheers,
Jake Marvin - Product Specialist
support@interactivetools.com

Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

Re: [Jake] How many section editors?

By roddruce - August 25, 2008 - edited: August 25, 2008

Jake I could have, in time, 2000 clients. But I am happy to buy one, two, three copies of CMS Builder, whatever it takes, and have each copy with its own database.

I assume I can do this by simply installing each new copy of CMS Builder into a folder name csmAdmin1, csmAdmin2 etc?

My host says I can have unlimited sub-domains, thousands...

Rod

Re: [roddruce] How many section editors?

By Dave - August 25, 2008

Hi Rod,

There's no hard coded limits with sections editors, but their settings files are all loaded each time the program runs so loading 1000 files will slow things down and could pose a problem.

Is it possible to put these all in one section with one record per user? I think that might be a better way to organize everything. Let me know if that would work for you.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] How many section editors?

By roddruce - August 25, 2008

[font "Verdana"]
Is it possible to put these all in one section with one record per user?


This is exactly what I would like. What I hope to have is hundreds or even thousands of Users. I just couldn't or can't see how to generate different records for each user so they would all be editing the same section.



I am giving each new client an ID number rmh712, rmh713 etc. The generated code is title index.php file (along with any html coding) and place this file in to their own sub-domain folder. This client will now have their own url to promote to their restaurant customers with a live menu.

<?php if (!$rmh712Record): ?>
No record found!<br/><br/>

This is how I have CMS Builder temporarily setup now but would dearly like to be able to remove all the "rmh712" section editors and have just one title "Menu". [url "http://www.ourmenus.com.au/se.gif"]http://www.ourmenus.com.au/se.gif[/#800080][/url][font "Arial"]

[font "Arial"]Dave what do I need to do for this to function? I'll happily pay for any changes to the code etc.

Rod

Re: [roddruce] How many section editors?

By Dave - August 25, 2008

Hi Rod,

So all the sections have the same fields right? If that's the case create a new "multi-record" section.

Next, under Section Editors > Advanced. Set "Max records per user" to 1.

Next, for each user you create, give them "writer" access to the section. They'll only be able to create or manage one record. They won't be able to see other users records.

Finally, in your viewer, look up their record by their user num:
'where' => "createdByUserNum = '123'",

Also, note that if you give clients the ability to copy and paste (and run) PHP code they'll may be able to access any files and info in your database or server. So it's probably best that you do that part them. Although there is ways you could securely automate it.

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] How many section editors?

By roddruce - August 25, 2008

Dave I'll make up the multi records and test a couple of demo users. Users will only be using rich text format no php, so that side will be okay. I'll post back to let you how everything looks.

Thanks- Rod

Re: [Dave] How many section editors?

By roddruce - August 26, 2008

Dave,
I am not understanding everything yet. I am no good without step x step written instructions but I am getting there.

Set "Max records per user" to 1.[/#804040]

I have done this! Do I need to keep Order & Title? The User will only be editing one page over and over again and nothing else. It is a one page sub-domain website.
http://www.ourmenus.com.au/mr.gif

Next, for each user you create, give them "writer" access to the section. They'll only be able to create or manage one record.[/#804040]

In maximum records do I just insert the number "1"?
http://www.ourmenus.com.au/ua.gif


This is where I am confused...

Finally, in your viewer, look up their record by their user num:
'where' => "createdByUserNum = '123'",
[/#804040]http://www.ourmenus.com.au/codeg.gif

Do I select List Page or Detailed Page for the viewer code?

This screenshot below is the detailed page but where do I insert "createdByUserNum = '123' What is this number and how do I create one for each user?
http://www.ourmenus.com.au/codedetailed.gif

Rod

Re: [roddruce] How many section editors?

By Dave - August 27, 2008

Hi Rod,

If you have two browsers (Firefox, Safari, IE, etc), the easiest way to test how things work is to login into CMS in one browser as an Admin user and the other browser as a regular user to see how they would see things.

>Do I need to keep Order & Title?

Order won't matter unless you're listing all the records somewhere and want them sorted. Title isn't needed unless you want to display it on your pages somewhere.

>In maximum records do I just insert the number "1"?

When you set "Max records per user" to 1 it overrides that setting, so even if you leave it blank users can't create more than one record. Try logging in as a regular user to try it out.

>Do I select List Page or Detailed Page for the viewer code?

Details page, then select "Advanced: Loading first record matching MySQL "Where" clause:" or just copy this into the code:

'where' => "createdByUserNum = '123'",

And replace 123 with the number of the user who's record you want to display.

You'll either need to create a page for each user or have some method to figure out when to show which record.

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com