Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Admin Access With Levels


chooch

Recommended Posts

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 by chooch

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Link to comment
Share on other sites

anyone please?

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...