Admin Access With Levels

[chooch]

Hi

 

Is there anyone who has installed Admin Access With Levels that has subsequently added any other contribution?

 

Here is the SQL provided in the contribution download:.

 

DROP TABLE IF EXISTS admin_files;

CREATE TABLE admin_files (

admin_files_id int(11) NOT NULL auto_increment,

admin_files_name varchar(64) NOT NULL default '',

admin_files_is_boxes tinyint(5) NOT NULL default '0',

admin_files_to_boxes int(11) NOT NULL default '0',

admin_groups_id set('1','2') NOT NULL default '1',

PRIMARY KEY (admin_files_id)

);

 

INSERT INTO admin_files VALUES (1, 'administrator.php', 1, 0, '1');

INSERT INTO admin_files VALUES (2, 'configuration.php', 1, 0, '1');

INSERT INTO admin_files VALUES (3, 'catalog.php', 1, 0, '1,18');

INSERT INTO admin_files VALUES (4, 'modules.php', 1, 0, '1');

INSERT INTO admin_files VALUES (5, 'customers.php', 1, 0, '1,18');

INSERT INTO admin_files VALUES (6, 'taxes.php', 1, 0, '1');

INSERT INTO admin_files VALUES (7, 'localization.php', 1, 0, '1');

INSERT INTO admin_files VALUES (8, 'reports.php', 1, 0, '1');

INSERT INTO admin_files VALUES (9, 'tools.php', 1, 0, '1,18');

INSERT INTO admin_files VALUES (10, 'admin_members.php', 0, 1, '1');

INSERT INTO admin_files VALUES (11, 'admin_files.php', 0, 1, '1');

INSERT INTO admin_files VALUES (12, 'configuration.php', 0, 2, '1');

INSERT INTO admin_files VALUES (13, 'categories.php', 0, 3, '1');

INSERT INTO admin_files VALUES (14, 'products_attributes.php', 0, 3, '1');

INSERT INTO admin_files VALUES (15, 'manufacturers.php', 0, 3, '1');

INSERT INTO admin_files VALUES (16, 'reviews.php', 0, 3, '1');

INSERT INTO admin_files VALUES (17, 'specials.php', 0, 3, '1,18');

INSERT INTO admin_files VALUES (18, 'products_expected.php', 0, 3, '1');

INSERT INTO admin_files VALUES (19, 'modules.php', 0, 4, '1');

INSERT INTO admin_files VALUES (20, 'customers.php', 0, 5, '1,18');

INSERT INTO admin_files VALUES (21, 'orders.php', 0, 5, '1');

INSERT INTO admin_files VALUES (22, 'countries.php', 0, 6, '1');

INSERT INTO admin_files VALUES (23, 'zones.php', 0, 6, '1');

INSERT INTO admin_files VALUES (24, 'geo_zones.php', 0, 6, '1');

INSERT INTO admin_files VALUES (25, 'tax_classes.php', 0, 6, '1');

INSERT INTO admin_files VALUES (26, 'tax_rates.php', 0, 6, '1');

INSERT INTO admin_files VALUES (27, 'currencies.php', 0, 7, '1');

INSERT INTO admin_files VALUES (28, 'languages.php', 0, 7, '1');

INSERT INTO admin_files VALUES (29, 'orders_status.php', 0, 7, '1');

INSERT INTO admin_files VALUES (30, 'stats_products_viewed.php', 0, 8, '1');

INSERT INTO admin_files VALUES (31, 'stats_products_purchased.php', 0, 8, '1');

INSERT INTO admin_files VALUES (32, 'stats_customers.php', 0, 8, '1');

INSERT INTO admin_files VALUES (33, 'backup.php', 0, 9, '1');

INSERT INTO admin_files VALUES (34, 'banner_manager.php', 0, 9, '1,18');

INSERT INTO admin_files VALUES (35, 'cache.php', 0, 9, '1');

INSERT INTO admin_files VALUES (36, 'define_language.php', 0, 9, '1');

INSERT INTO admin_files VALUES (37, 'file_manager.php', 0, 9, '1');

INSERT INTO admin_files VALUES (38, 'mail.php', 0, 9, '1,18');

INSERT INTO admin_files VALUES (39, 'newsletters.php', 0, 9, '1,18');

INSERT INTO admin_files VALUES (40, 'server_info.php', 0, 9, '1');

INSERT INTO admin_files VALUES (41, 'whos_online.php', 0, 9, '1,18');

INSERT INTO admin_files VALUES (42, 'banner_statistics.php', 0, 9, '1,18');

 

this SQL caters for the standard fresh install of oscommerce. I have added Articles Manager, Newsdesk, Info Pages and others. Can someone please explain what technique i should follow to update the SQL for any contribution I add

 

I dont know much about SQl and am therefore bamboozled

 

Many thanks for looking

Edited December 31, 2005 by chooch

[chooch]

anyone please?

[scranmer]

anyone please?

 

 

Ah boo, when you PM'd me I thought you has some large SQL statement to normalise or that was running slow. These are raw SQL statements, you just need a copy of phpmyadmin or mysql administrator to run these against the database. Just highlight them all including the ; and paste then all in an SQL box to run them against the database. They will create a new table and all of the required preferences to start using the admin functionality. With phpMyAdmin you first select the db, then click the SQL tab and paste all the commands into the text box titles "Run SQL query/queries on database..."

 

HTH

 

Si. :thumbsup:

[chooch]

Ah boo, when you PM'd me I thought you has some large SQL statement to normalise or that was running slow. These are raw SQL statements, you just need a copy of phpmyadmin or mysql administrator to run these against the database. Just highlight them all including the ; and paste then all in an SQL box to run them against the database. They will create a new table and all of the required preferences to start using the admin functionality. With phpMyAdmin you first select the db, then click the SQL tab and paste all the commands into the text box titles "Run SQL query/queries on database..."

 

HTH

 

Si. :thumbsup:

Si

 

what i was trying to achieve was the pattern of what the SQL should be for new contributions added

 

for example i have articles manager and newsdesk etc, so how do i know what to execute in phpmyadmin for the new contributions only?

 

sone of the SQL end in '1, 18' and some dont... i cant see the pattern that i should use to add to my database when everythime a new contribution is added

 

it is doing my head in...

 

i presume that anything in a box has the prefix '1' such as:

 

INSERT INTO admin_files VALUES (1, 'administrator.php', 1, 0, '1');

INSERT INTO admin_files VALUES (2, 'configuration.php', 1, 0, '1');

INSERT INTO admin_files VALUES (3, 'catalog.php', 1, 0, '1,18');

INSERT INTO admin_files VALUES (4, 'modules.php', 1, 0, '1');

INSERT INTO admin_files VALUES (5, 'customers.php', 1, 0, '1,18');

INSERT INTO admin_files VALUES (6, 'taxes.php', 1, 0, '1');

INSERT INTO admin_files VALUES (7, 'localization.php', 1, 0, '1');

INSERT INTO admin_files VALUES (8, 'reports.php', 1, 0, '1');

INSERT INTO admin_files VALUES (9, 'tools.php', 1, 0, '1,18');

 

so articles manager and newsdesk should be like this because they are headings in boxes:

INSERT INTO admin_files VALUES (43, 'articles.php', 1, 0, '1');

INSERT INTO admin_files VALUES (44, 'newsdesk.php', 1, 0, '1,18');

 

and the link under each heading should be like this:

INSERT INTO admin_files VALUES (45, 'NAME.php', 0, 10, '1,18');

INSERT INTO admin_files VALUES (46, 'NAME.php', 0, 10, '1,18');

INSERT INTO admin_files VALUES (47, 'NAME.php', 0, 11, '1,18');

INSERT INTO admin_files VALUES (48, 'NAME.php', 0, 11, '1,18');

 

the only thing that bamboozles me is that i dont know where and why to apply a ' 1, 0, '1'); instead of a 1, 0, '1,18');

 

why do sone lines of SQL end in 18 some dont

 

as stupid as this may sound, i really need to install this contribution but cannot unless all contributions are controlled by Admin Access and that only be done with the correct SQL

 

please advise, thanks

[scranmer]

Chooch,

 

Sorry for the delay, these settings are not specific to SQL, they are specific to the application or contribution. Unfortunatly I do not use this BUT but by looking at them and having a guess at how these tings work I would say the following...

 

first column is a unique ref (UID),

second column is the program it allows access too,

third is program level 1=top or box info, 2=a program

fourth being a pointer to its top or box level UID

fifth could be a list of group ids identifying which user groups have access

 

but you need to check the programs to confirm

 

HTH

 

SI.

[chooch]

Chooch,

 

Sorry for the delay, these settings are not specific to SQL, they are specific to the application or contribution. Unfortunatly I do not use this BUT but by looking at them and having a guess at how these tings work I would say the following...

 

first column is a unique ref (UID),

second column is the program it allows access too,

third is program level 1=top or box info, 2=a program

fourth being a pointer to its top or box level UID

fifth could be a list of group ids identifying which user groups have access

 

but you need to check the programs to confirm

 

HTH

 

SI.

Hi Si

 

Thanks for the reply... i will check it out