/    Sign up×
Community /Pin to ProfileBookmark

user rights permission problem

Copy linkTweet thisAlerts:
Aug 29.2003

hi,

i got probelm regarding user rights permission for directories for eg. if parent directory have child directories let say child1 and for child1 there is one child let say child2,

so if i give user no rights on paren directory he will not be able to see child1 and child2 ther is no sense to see,

im struggling from last 2-3 days if anybody interested i can post the link and code

thanks in advance

to post a comment
PHP

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@GavinPearceAug 30.2003 — link and code, mite be able to understand a bit better.
Copy linkTweet thisAlerts:
@zuzupusauthorSep 01.2003 — thanks gavi

but im struggling with database

i got problem regarding tree structure for assigning user permission rights so that when user permission set to No Rights he dont have acess to particular parent directory then he wont able to see child as well as grandchilds,for eg.

if i set no rights to PARENT1 he wont able to see CHILD1,2 and 3

PARENT1 (pk_dir = 1, diradress= 1)

__CHILD1 (pk_dir = 23, diradress= 1|23)

_____GRANDCHILD11 (pk_dir = 345, diradress= 1|23|345)

_____GRANDCHILD12 (pk_dir = 346, diradress= 1|23|346)

_____GRANDCHILD13 (pk_dir = 347, diradress= 1|23|347)

__CHILD2 (pk_dir = 35, diradress = 1|35)

_____GRANDCHILD21 (pk_dir = 456, diradress= 1|35|456)

_____GRANDCHILD22 (pk_dir = 457, diradress= 1|35|457)

__CHILD3 (pk_dir = 46, diradress = 1|46)

_____GRANDCHILD31 (pk_dir = 506, diradress= 1|46|506)

________GRANDGRANDCHILD311 (pk_dir = 657, diradress= 1|46|506|657)

so i thought add a variable (say 'diradress') inside the t_directories table + need to fill in the value for all records

but im confused how to insert all records as the list is too long if i start inserting manually it will take ages to do,anybody lnows querry for this

CREATE TABLE t_directories (

sys_pk int(11) NOT NULL auto_increment,

diradress int(11) NOT NULL // is is correct or it should auto_inc

PRIMARY KEY (sys_pk))

im sending my PHP files and link is

http://server2.vitodesign.com/scripts/thepage.phtml

hope this is clear for you

thanks

[upl-file uuid=0f4498c5-6ad9-4716-b88f-4bf828b6c62b size=3kB]php.zip[/upl-file]
×

Success!

Help @zuzupus spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.7,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...