- Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] Learn more about how we use your information,
by info 01 May '02

01 May '02

File attachment: CAICD620.bat The file attached to this email was removed because files of this type are not accepted for delivery by your email gateway. File attachment: CAICD620.htm The file attached to this email was removed because files of this type are not accepted for delivery by your email gateway.

1 0

[Phpmyadmin-devel] Testings and opinions
by Lo�c 01 May '02

01 May '02

Hi List! I've modified the "common.lib.php3" library in order to "guess" what should be the value of "$cfgPmaAbsoluteUri" in case the user didn't complete it. But I'm not sure it's a so nice stuff, since it depends on some variables send by the server! Then if the server is not well configured or do not fit CGI/1.1 specifications we may face "bugs" that would be harder to find because it's easier to see that "$cfgPmaAbsoluteUri" is empty than it was "automagically" set with a wrong value. That's why I require both you testings (with different servers) and your opinions about this stuff. Thanks in advance, Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

4 3

[Phpmyadmin-devel] as i am basically a lazy person:
by Beck, Mike 01 May '02

01 May '02

just one idea: PMA always shows the SQL it created, so couldn't we just add a small checkbox and a textinput giving the user the possibility to add a variablename and then to have a second output of the SQL in the form of $var = "SELECT field FROM table "; $var .= "WHERE `field` = 'blub'"; so he could just copy & paste it to the code? Especially now that table_qbe is starting to be intelligent enough to come up with nice SQL it would make things easier for all those who develop in php (surely most of the users), but also other languages might be able to use it (c, perl etc. do have a rather similar syntax so it should be fine with them) -- Gruß Mike

2 1

Re: AW: Re(2): [Phpmyadmin-devel] Re: 2.3.0 Roadmap Discussion
by Jay F. Davis 30 Apr '02

30 Apr '02

I think the relations table should go in the user's database. I don't think we should get into user permissions issues. That is definitely something MySQL should handle, not phpMyAdmin. I'm not real familiar with the configuration scheme in phpMyAdmin, but isn't there a way to have separate configuration options for individual users? (So that each user can have a separate relations table?) If it is not possible to have separate configurations per user, then the relations table definitely belongs within each user database. (I guess it would have to have a default name.) Jay Davis On Tue, Apr 30, 2002, Beck, Mike <mike.beck(a)ibmiller.de> wrote: > >> Unless I'm misunderstanding the question, the appropriate >> place to manage >> user permissions is within MySQL. You grant select access to the >> relations table for everyone, but only the administrator gets >> access to >> UPDATE the relations table. >> > >this won't work for ISPs - can't see them handling the relations for a few >hundred clients databases. so there is only two possibilities: > >a) have the relationstable in the users database >or >b) >for modifying the relationtable test the users rights on the table. i have >written a script to modify the relationtable (without this feature) and sent >it to marc, hope it will be in cvs as soon as he finished restructuring the >tbl_properties page (it is suppossed to be called with a link from this >page). >i think the neat way to do it would be to make this script check if a user >wants to put in links from table "a" as mastertable to test if he has e.g. >the alterpriv for table "a". > >regards > >mike beck > >_______________________________________________ >Phpmyadmin-devel mailing list >Phpmyadmin-devel(a)lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

1 0

[Phpmyadmin-devel] Re: 2.3.0 Roadmap Discussion
by rcaskey＠arches.uga.edu 30 Apr '02

30 Apr '02

Heya all. Iv been working on a project which basically replicates alot of phpMyAdmin functionality, and I was about 600 lines of code into the project (nothing I know) when I thought to myself...*self*, before you go coding all that code to fake referential integrity, lets go see if you can use a table structure that phpMyAdmin is using... Anyway, I decided to check out the current state of the table and here I am. Basically, I am thinking that since phpMyAdmin has started to pollute the database with tables of its own that it might as well use a standard prefix to add a few more tables to enable more features (eventually down the road)... In short this is what I propose (to be quickly shot down I am sure): (BTW, alot of programs have variable table prefixes, is this really neccecerry?) CREATE TABLE phpMyAdmin_relationships ( id int(10) unsigned NOT NULL auto_increment, local_key_a varchar(32) NOT NULL default '', local_table varchar(32) NOT NULL default '', foreign_key_a varchar(32) NOT NULL default '', foreign_table_a varchar(32) NOT NULL default '', local_key_b varchar(32) default NULL, foreign_key_b varchar(32) default NULL, foreign_table_b varchar(32) default NULL, value_on_foreign_a_delete varchar(32) default NULL, value_on_foreign_b_delete varchar(32) default NULL, enable_cascade_actions enum('0','1') NOT NULL default '1', PRIMARY KEY (id) ) TYPE=MyISAM and two examples to clear things up a bit INSERT INTO qdb_relationships VALUES (1, 'dr_id', 'perscriptions', 'id', 'doctors', NULL, NULL, NULL, '', NULL, '1'); INSERT INTO qdb_relationships VALUES (2, 'trainer_id', 'apointments', 'id', 'personal_trainers', 'trainee_id', 'id', 'trainiees', NULL, NULL, '1'); The first example is for a table which lists perscriptions and their doctors. If the matching doctor is deleted, the perscriptions id is blanked out (blank value in value_on_foreign_a_delete. The second example is an example of a set of appointments between trainers and their clients. In either case, if a trainer or an employee is deleted, the corresponding record in the local table is deleted as well (symbolized by update value is null) enable_cascade_options can be set to 0 for testing purposes, or if you only want to create a link to help you quickly navigate around in phpmyadmin What do you think? Allows both many to one and many to many relationships... Additional things that im planning to add in my project but would love to be implemented in phpMyAdmin 3.0 and in the schema sooner... tbl_users, tbl_usergroups, tbl_groupmembership, tbl_columns, etc for managing different levels of access to phpMyAdmin all the way down to specific record locking if db designers include a phpMyAdmin_owner field or something like that Any thoughts, comments? Im thinking some of this is probably already slightly out of the scope of phpMyAdmin, although you guys have been doing an increadible job of filling out the current scope of the project and it has been creeping out in its features recently, so maby such a drastic expansion could be planned for to allow it to commence in a planned and orderly fashion? If not id settle for a schema so my app could play friendly phpMyAdmin and some extra features like the cascading updates :)

5 6

AW: Re(2): [Phpmyadmin-devel] Re: 2.3.0 Roadmap Discussion
by Beck, Mike 30 Apr '02

30 Apr '02

> Unless I'm misunderstanding the question, the appropriate > place to manage > user permissions is within MySQL. You grant select access to the > relations table for everyone, but only the administrator gets > access to > UPDATE the relations table. > this won't work for ISPs - can't see them handling the relations for a few hundred clients databases. so there is only two possibilities: a) have the relationstable in the users database or b) for modifying the relationtable test the users rights on the table. i have written a script to modify the relationtable (without this feature) and sent it to marc, hope it will be in cvs as soon as he finished restructuring the tbl_properties page (it is suppossed to be called with a link from this page). i think the neat way to do it would be to make this script check if a user wants to put in links from table "a" as mastertable to test if he has e.g. the alterpriv for table "a". regards mike beck

1 0

[Phpmyadmin-devel] Ideas
by Igor 30 Apr '02

30 Apr '02

Please don't kill me if this is not the right place to post my ideas for the new version but I don't know where to place it instead. 1. Default query My thought is that when you have for example a table t_persons and you place a query in the bookmark-table with the same name as the table that this query should be executed instead of the "select * ..." when you click "browse" 2. Execute button (or link) for bookmark-table That means that I think it would be nice if you browse the bookmark table that you get an additional button or link in each line to execute the defined query Regards Igor

2 1

[Phpmyadmin-devel] Re: Design chage of tbl_properties_links.php3
by Loïc 29 Apr '02

29 Apr '02

>If you like it, I'll commit it to our CVS tree. I do (like it) :) Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

2 1

[Phpmyadmin-devel] Design chage of tbl_properties_links.php3
by Alexander M. Turek 29 Apr '02

29 Apr '02

Hi list, I changed the design of the links on the top of the new tbl_properties pages. As we get more and more links there, I compressed it a bit to support our 800x600 pixel users :o) In addition to this, I changed the color of the 'drop' link to red to show the danger of this command. If you like it, I'll commit it to our CVS tree. Happy testing, Alexander

2 1

[Phpmyadmin-devel] Re: 2.3.0 tbl_properties split
by Lo�c 29 Apr '02

29 Apr '02

Hi again! >But I think that a small click on a [Structure] link is >easily done. Right :) >So there could be a [Main] page with: >- the links :) >- the Query box >- the bookmark stuff >- "Insert from a textfile". (?) OK but in my opinion these links should now be displayed at the top of all the pages you can reach with them. Maybe we should add a frame for them? About "Insert from a textfile", see my previous reply ;) Loïc ______________________________________________________________________________ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif

1 0