Group Office Scalability!

[Intermesh]

do:

echo get_acl($acl_id);

[lightningfullmoon]

Hi,

Thanks for reply...

I got result by this...

I have 2 question?
1)May i know, What are the tables affected when i add a user and its values?
ie. what are the entries will insert or update in the tables?
2) In acl table there are few records having user_id is 0, but it had group_id? for what purpose we did this.

I sortly breif what i learn?

1) Adding user -> insert into table users
2) Get the max of id from acl_items, update to users, acl_id column as (max(acl_id)+1)
3) Insert in to acl table, read & write module id for the user, along with this insert the email id into the acl_item table, get that id and insert into acl table for that user, also update group id.
4) Put the entry in the users_group table for this user.

Is the above steps is correct... if not, pls.. tell me...

Thanks & Regards
Rumesh

[Intermesh]

The user is added to the group "Everyone"

A row in the ACL always has a either a group_id or a user_id. not both.

[lightningfullmoon]

Hi,

Thanks for your reply....

I have one question...

In our GO, Admin can set the Resource Group and Resource, Is there any option to set the Resource Group and Resource by other Group head, ( the group head user is not in admin group, also the Group head is not an admin).
Todo this, what's things todo, what are table entries and file we change?

Thanks & Regards
Rumesh

[lightningfullmoon]

Hi,

Thanks for your reply....

I have one question...

In our GO, Admin can set the Resource Group and Resource, Is there any option to set the Resource Group and Resource by other Group head, ( the group head user is not in admin group, also the Group head is not an admin).
Todo this, what's things todo, what are table entries and file we change?

Thanks & Regards
Rumesh

[Intermesh]

You need to give the user admin permissions for the calendar module.

[lightningfullmoon]

Hi,

Thanks for you reply.

Yes, i give the user as admin permission... Now, it works.

I have two doubts,

1) When i create link, in which table it stores, there are two tables "links" and "fs_links", for example i create a link for calendar where it stores...

2) In cal_events table there is a column name event_id, it remains zero, in other tables we have event id column, is it refer the id column of the cal_event or any other



Regards
Rumesh

[Intermesh]

all links are stored in links.
fs_links is used for file linking.

[lightningfullmoon]

Hi,

Thanks...

I need one more clarification...

In links table there are four columns named like "type1","link_id1","type2","link_id2"

What type1 and type 2 means and also what link_id1 and link_id2 represents....

If i create a calendar link, i put the link id in the event table link column... where it refer the links in link table...



Regards
Rumesh

[Intermesh]

See classes/base/links.class.inc

there is a table of link types:

1=event
2=contact
3=company
etc..

[lightningfullmoon]

Hi,

Thanks for imm. reply.

I need little bit briefly..

For eg. in calevent i have link_id column... this column value is relate to which column...

becuase have type1,link_id1,type2,link_id2 column... in which column it insert....

I go thru... to class.links. file... but... little bit i need clarification from you...


Thanks & Regards
Rumesh

[Intermesh]

any item in GO can have a link_id. It's a unique ID for each item.

For example

Event (link_type=1) with link_id=123

Must be linked to:

Contact (link_type=2) with link_id=321

Then the row in links must be:

type1=1, link_id1=123, type2=2, link_id=321

[webwolfi]

please can you post the full list of link IDs?

[lightningfullmoon]

Hi,

Thanks for your kind reply...

I need little bit clarification...

we link types id are:
1=cal_events
2=ab_contacts
3=ab_companies
4=no_notes
5=pmProjects
6=folders & files
7=bs_orders
8=tr_projects

In my links table i have entry and cloumns are..
type1 link_id1 type2 link_id2
6 7 6 8
1 9 1 10
1 15 1 15
1 41 1 42
1 41 6 43

link_id2 43 is in the fs_links table
link_id2 42 is in the cal_events table
link_id1 41 is in the cal_events table

Here, what is different between the type1 type id 1 and type2 type id 1, its corresponding link_id1 41 and link_id2 42 (pls. refer the 4th row)

And What about the fs_status_history table link id and fs_share table link id.


hi webwolfi....

Pls. see above in this msg.




Regards
Rumesh

[Intermesh]

There are no differences. Its just link 1 linked to link 2