Restricting a view

Wed, 25 Jun 2008 04:47:35 -0700

I'm writing a quick application for a telesales team on which to log their contacts. The ADMIN side is fine and the viewable listings and details are just what is required. However, contrary to initial requirements I've now been asked if I can secure the viewable listings and details so that a salesperson (other than someone with an admin privilege) can view listings of only their own records.

I'm sure CMS Builder was not set up to do this, so does anybody have any ideas that I could integrate please?

Thanks in advance.

List Options

Tue, 20 May 2008 05:57:14 -0700

Hi All,

When using Admin to set up a 'list option', I would like the option to show, for example, 'UNITED KINGDOM', but actually return 'UK', to the database. How do I achieve this in CMSBuilder? Or do I create a little section and then have the list reference it instead of hardcoding?

Have I just answered my own question!?!?! [blush]

Re: [Dave] Hyperlinking to other table data

Mon, 12 May 2008 04:26:27 -0700

Thank you Dave. It's easy when you nkow how! [;)] Yes, I get it. All pages are searchable, therefore you just append the correct parameter then copy & paste that into your code and add on the PHP bit that adds on that parameter. It can't all be that easy though, I'm sure.

Just for the record in case it helps any other newbie, then here is my final code:

       
      Issue for:

Hyperlinking to other table data

Sun, 11 May 2008 09:15:05 -0700

Hello there. I have looked to an answer for the following and I cannot find it in the knowledgebase. I suspect that this is probably because I am new to PHP, so please bear with me. I hope you can help.

I have two sections/tables. The first is called ‘issue’ and has one text field called ‘issuemonth’ into which a year and month are typed in the format ‘yyyymm’. This list viewer appears as I want it:
Issue - List Page Viewer
Issue for: 200806
Issue for: 200805

The second section/table is called ‘page’ and has two fields: a text field called ‘page_number’ into which a page number (001, 002, …) is typed, and ‘assign_issue’ which uses a picklist generated from the ‘issuemonth’ field in the ‘issue’ table. The list viewer page appears like this:
Page - List Page Viewer
Issue: 200806 - Page Number: 001 - Link: pageDetail.php?8
Issue: 200806 - Page Number: 002 - Link: pageDetail.php?6
Issue: 200805 - Page Number: 001 - Link: pageDetail.php?1
Issue: 200805 - Page Number: 002 - Link: pageDetail.php?2

What I am struggling to achieve is that I want to be able to click on a link in the Issue - List Page Viewer page and be sent to something that looked like the Page - List Page Viewer page, but only showing records that related to the ‘issuemonth’ that had been clicked.

Code – top of Issue - List Page Viewer:
list($issueRecords, $issueDetails) = getRecords(array(
'tableName' => 'issue',
));

Code – body of Issue - List Page Viewer:

Issue for:

Code – top of Page - List Page Viewer:
list($pageRecords, $pageDetails) = getRecords(array(
'tableName' => 'page',
));

Code – body of Page - List Page Viewer:

Issue: - Page Number: - Link:

Thanks for any assistance in advance, George

Is Interactivetools right for me please?

Mon, 17 May 2004 05:01:19 -0700

Hello all. Apologies for posting something which maybe answered elsewhere but after reviewing umpteen CMS packages I am suffering from 'CMS-blindness' - I can't see the wood for the trees any more! Having said that, I am quite taken with all the InteractiveTools lurvin I see going on around these boards. And the people responsible for the tools respond. A lot. [:)]

Here's what I want and I would be grateful if you could tell me whether InteractiveTools is the 'one' for me. The biggest hing I am after is granular access control.

I run a local football (soccer if you really must- but it is football really) league made up of 15+ teams. I am fed-up with keeping the web site updated. Here is the URL http://www.justfooty.co.uk/eastches/.

I want a CMS that I can set up so that 'users' can update their own sections. For instance, I want to let one or two people edit the front page, but nothing else. I want to let the League Secretary upload a PDF version of the Rule Book to a certain area and edit the list of banned players on the relevant page. You get the idea.

Further down the 'tree' I want each team secretary to be able to go in and enter their contact information, team colours and so on and even create a picture gallery if they want. And certainly to be able to put up a pen-pic of each player.

And within all of the above, I want to limit the items (blocks?) on a page that each user can touch - I don't want them messing anything up meaning more work for me. Oh no. Just enter where I want them to and that's it.

I would like a threaded messageboard just like this one too!

I am also looking to try and run banner ads - not for me, but rather to allocate banner-ad rotations to each team in order to help them gain team sponsorship. Its a nice extra seling point for them as no company really benfits from having their company name emblazoned on the chest of a panting, overweight person smelling of beer on a Sunday morning.

And a poll.

All that would be lovely.

But then, players from two other leagues in my area are badgering me about doing their league websites because thei websites are truly are awful. You think mine is bad? The others are dire!

So next I want to create sub-folders for each league and just kind of copy & paste files and set these guys up to run their part themselves - seperate messagesboard, poll, etc too. Maybe they can have a different look and feel - that would be a nice feature.

So Interactivetools gurus, how does this product measure up to my requirements? From what I have read I guess I would have to integrate with some other product. But I really like yours and want to be part of the lurvin'!!!

Many thanks in advance, George