This topic is locked

Knowledge Base Template

10/19/2008 2:57:18 PM
PHPRunner General questions
J
jje author

I need some help with the Knowledge Base Template. What is the easiest way to change the security settings to 'add users register form' without verification of an email and somebody to approve the new user details. This means once the user has registered; he/she should be login and add a problem & resolution or a comment right away.

J
Jane 10/20/2008

Hi,
I suppose you need to create registration page on the User login settings dialog on the Security tab.

J
jje author 10/20/2008

Hi,

I suppose you need to create registration page on the User login settings dialog on the Security tab.


Hi Jane,
Somewhere I miss something. I get this message all the time "You don't have permission to access this table" (kbmain_list). Is this possible to change the security without adding or editing any coding on the Knowledge Base templates?

J
Jane 10/22/2008

Hi,
Please make sure you have set up list/view permissions for <Default> group on the User group permissions dialog on the Security tab.

If it doesn't help publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

J
jje author 10/27/2008

Hi,

Please make sure you have set up list/view permissions for <Default> group on the User group permissions dialog on the Security tab.

If it doesn't help publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.


Hi Jane,
Thanks for your help.

I use the standard template as in v5 without any changes. Only add the registration page on the 'User login' as mention by you and after that I add the <Default> group to the list/view group as well.
My problem now is that the Default group have the same rights as the Admin group, seeing articles that is not approved yet.
Is this possible to setup the security rights for the Default group to add new articles and comments but not seeing any data that is not yet approved?
Johan

J
Jane 10/28/2008

Johan,
I see what you're saying.

You need to create custom view on theDatasource tables tab, then add where clause to the SQL query on the Edit SQL query tab for this view and set up different permissions for main table and this view on the User group permissions dialog on the Security tab. For example admin can see main table only, <Defaul> users can see this custom view only.

Here is a sample query:

select field1,

field2,

...

from TableName

where FieldName='approved'