In my system I create user with their own pages and directories etc.
I'm able to create masks, groups, users and all the pages needed with the same script to qls, also. The problem is when I try to couple the permissions for a page with mask created. Every newly added page creates a columb at the end of masks table with some crypted string as their name. My best ques to form the column name was like this:
Code: Select all
$crypt_pagename = sha1($_POST['pagename']);
$column_name = "auth_".$crypt_pagename;
$set = array($column_name => 1);
$return = $qls->SQL->update('masks', $set, array('id' => array('=', $_SESSION['mask_id'])));
..but that gives me an error of "1054: Unknown column 'auth_02aa5d5e00c82807fde9b573b1a89392a24b5455' in 'field list'" =(
So how can I refer to a column referring to page name in masks table, to automatically give a new mask a permission to a new page? Does the qls system make some string modification to the pagename before hashing it with sha1?