August 2001 - Developers - lists.phpmyadmin.net

Re: [Phpmyadmin-devel] look of main.php3 (suggestion)
by Loïc 22 Aug '01

22 Aug '01

Hi All! I've sent to Olivier an XHTML1.0 validated version of this script a few hours ago. With a bit of luck it will be on the CVS soon. Dan, I can't reach your server! 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

Re: [Phpmyadmin-devel] $cfgPmaAbsoluteUri
by Loïc 22 Aug '01

22 Aug '01

Hi Marc! >what do I put there if I have more than one host? ??? You're using the same phpMyAdmin script on more than one server ??? This setting is the uri to the phpMyAdmin script itself, not to the sql host. 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] $cfgPmaAbsoluteUri
by Marc Delisle 22 Aug '01

22 Aug '01

Hi, what do I put there if I have more than one host? Marc

2 2

[Phpmyadmin-devel] Pbs with left.php3
by Loïc 22 Aug '01

22 Aug '01

Hi All! Well the current left.php3 script is not really optimized: it always use mysql_list_dbs (even if $cfgServers[n]['only_db'] is set in order to ensure these db trully exists) and this query may requires a huge amount of memory if you're an ISP for example. I've actaully done some tests with the ISP I suscribed to... and this query make fails left.php3 indeed. So I've rewritten a bit this script but I would like some of you to test it before I submit this new version. Lines 21 to 52 have been replaced by: --- new code starts here --- if ($server > 0) { $num_dbs = count($dblist); // 1. $cfgServers[n]['only_db'] exists -> gets the valid databases list if ($num_dbs) { $true_dblist = array(); for ($i = 0; $i < $num_dbs; $i++) { $dblink = @mysql_select_db($dblist[$i]); if ($dblink) { $true_dblist[] = $dblist[$i]; } // end if } // end for unset($dblist); $dblist = $true_dblist; unset($true_dblist); $num_dbs = count($dblist); } // end if // 2. no $cfgServers[n]['only_db'] else { $dbs = mysql_list_dbs() or mysql_die(); $num_dbs = @mysql_num_rows($dbs); for ($i = 0; $i < $num_dbs; $i++) { $dblist[] = mysql_dbname($dbs, $i); } // end for } // end else } else { $num_dbs = 0; } --- end of new code --- Greetz, 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

Re: [Phpmyadmin-devel] Problem with rc4
by Loïc 22 Aug '01

22 Aug '01

Hi Lance! >Just adding another string "Drop table" and using it there would achieve >the required result without affecting the other code at all ?? You must be an english/american user else you would know what is the cost of each added string ;) OK I've added $strDropTable. Cheers, 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

Re: [Phpmyadmin-devel] Problem with rc4
by Loïc 22 Aug '01

22 Aug '01

Hi Lance! >Call to undefined function: is_defined() in sql.php3 on line 15 My fault :o I've fixed it. >BTW descending is missing its 'c' in the select query frame . Also fixed. Thanks. >At the bottom of the database frame shouldnt it say :- >'Drop table xxxx' rather than just 'Drop xxxx' which may be >confusing if you have both a database and a table of the same >name ?? Well the same string is used here and in the first html table generated by db_details.php3. Having more characters in this string would lead to a non-friendly design in the second case. But what do you think of: 'Drop db_name.table_name' ? 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] /db_stats.php3 : stats about all databases
by Olivier M. 22 Aug '01

22 Aug '01

Hello, Sorry sorry, I know we're supposed to be in "code freeze" period, but I really needed this feature :) And it can't break anything anyway, because it's a new script, hacked in a few minutes tonight. (not sure if the html output is 100% correct: not checked yet) Link ("Databases Statistics") is displayed on main.php3 only if the user may also access mysql.user (root). I hope you will also find it useful! Greetings, Olivier -- _________________________________________________________________ Olivier Mueller - om(a)8304.ch - PGPkeyID: 0E84D2EA - Switzerland qmail projects: http://omail.omnis.ch - http://webmail.omnis.ch

2 6

[Phpmyadmin-devel] Problem with rc4
by lance 22 Aug '01

22 Aug '01

I have a problem when editing the result of a select query, when you post the edit the db gets updated but phpmyadmin then comes back with an sql error trying to redisplay the results - every time ... Thought I'd post it here as I know you are close to release ... Also a suggestion - in the right hand frame when you click on the db in the lh frame, could not the table properties be collapsed under a link that said 'properties' so you can expand it if you want, but all the other options would be visible on the screen. There are a lot more options in the new version .... 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 ... Regards Lance

3 7

[Phpmyadmin-devel] Niggly point
by lance 22 Aug '01

22 Aug '01

At the bottom of the database frame shouldnt it say :- 'Drop table xxxx' rather than just 'Drop xxxx' which may be confusing if you have both a database and a table of the same name ?? Lance

1 0

[Phpmyadmin-devel] MySQL-4.0 support
by Loïc 21 Aug '01

21 Aug '01

Done in the CVS: MYSQL_MAJOR_VERSION and MYSQL_MINOR_VERSION constants have been replaced by MYSQL_INT_VERSION. Jocelyn, please test 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