[Phpmyadmin-devel] Problem with rc4 - $cfgAllowUserDropDatabase

[Olivier M.]

On Tue, Aug 21, 2001 at 06:27:13PM +0100, lance wrote:
> using SELECT in the interface and then editing one of the resulting
> records, when you save it doesnt redisplay but says sql error.
> 
> I'll set up a database to demonstrate it if you want ...

yes, but with the newest cvs then please :) 


> Just the main database page is now too big, so the properties could by
> default be not shown , but under a bullet and link - database properties
> like the bullet and link for 'Print view'

Well, this kind of stuff (redesign of the properties pages, etc) is planed
for next release (PMA 3.0): it's quite a lot of work, and would need to 
re-think lots of pages.

> > > Also - any chance of the 'drop database' option being configurable to not
> > > be available ... we run an isp and offer phpmyadmin - its a real pain when
> > > users drop their databases without going through our interface ...
> >
> > that is a _good_ idea. also got the same problem here with my own
> > customers...
> :)

voila Sir, feature implemented in current CVS. 
Extract of the docs:

$cfgAllowUserDropDatabase boolean 
      Defines whether standard users (non administrator) are allowed to delete
      their own database or not. If set as FALSE, the link "Drop Database" will 
      not be shown, and even a "DROP DATABASE mydatabase" will be rejected. Quite 
      practical for ISP's with many customers. 

If you could try it and tell me it if it works fine, that would be nice!
(looks ok on my test server).

> > a link "reset database" which would remove all the tables at once
> > would also be practical (is somewhere in the feature requests tracker
> > as far as I can remember) : often requested by users here.
> 
> or maybe call it - 'drop all tables' - like phorum tech support tell my
> users to do - but they only see 'drop database' and do that instead :(

ok, this is already a more complex operation. anybody on the list willing
to work on it ? (I can't, have to work on my university stuff tonight :/)

Would simply need a confirmation page (with list of all tables which are
going to be deleted), with one or two checkboxes "are you sure", 
and a function which would simply DROP TABLE ***** for each table. 

> > these 2 things are not too complex, maybe it can be done before the
> > end of the week...
> 
> Great - I must take a look at the code and see if I can help with anything

you're welcome!


Regards,
Olivier
-- 
_________________________________________________________________
 Olivier Mueller - om at 8304.ch - PGPkeyID: 0E84D2EA - Switzerland
qmail projects: http://omail.omnis.ch  -  http://webmail.omnis.ch