From: Alvaro d. C. <ac...@ba...> - 2001-03-13 14:13:09
|
Chris Nandor wrote: > > At 07:26 +0100 2001.03.13, Alvaro del Castillo wrote: > >Chris Nandor wrote: > >> > >> Actually, users_param just uses a text field for "value" now. So the only > >> issue would be picking a better limit for "name". > > > > > >Ops, in 1.1.5 ... > > Yep, it was changed back to varchar, and then back to text. > > > > >mysql> desc users_param; > >+----------+--------------+------+-----+---------+----------------+ > >| Field | Type | Null | Key | Default | Extra | > >+----------+--------------+------+-----+---------+----------------+ > >| param_id | int(11) | | PRI | 0 | auto_increment | > >| uid | int(11) | | MUL | 1 | | > >| name | varchar(32) | | | | | > >| value | varchar(254) | | | | | > >+----------+--------------+------+-----+---------+----------------+ > > > >If the value is a text field it is perfect :-) > > Yeah, however, as I noted as a possibility, and Brian echoed, I think it is > best if users_acl is a separate table, just to keep it cleaner. Just take > the users_param schema from CVS (or this one, changing value to a text > field), and duplicate exactly for a users_acl table. Ok, the setUser functions is very flexible and this changes are very easy to do. ¡Great job! And now in the users_param table I save the color which has selected the user for the site (our orange color doesn't like to some of our community), the myslash flag which tells if a user want to have its own slash and the title for the user slash. I send you a patch to create the new table. I have change the field names to describe better the information. The patch is for MySQL but it is also ok for PostgreSQL and Oracle because it's SQL. Now, I am going to change the ACL funtions to Slash::Utility and test everything against 1.1.5. Bye -- Alvaro > > -- > Chris Nandor pu...@po... http://pudge.net/ > Open Source Development Network pu...@os... http://osdn.com/ > > _______________________________________________ > Slashcode-development mailing list > Sla...@li... > http://lists.sourceforge.net/lists/listinfo/slashcode-development -- =================================================== Alvaro del Castillo San Félix ac...@ba... Barrapunto.com |