<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4807.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>This removes from the total sum of rows the incorrect row
counts from any tables that aren't ISAM/MyISAM/Heap.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>-Josh</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>[root@lars htdocs]# diff -u phpMyAdmin/db_details.php
phpMyAdmin-new/db_details.php <BR>---
phpMyAdmin/db_details.php Wed Feb 20 16:40:22 2002<BR>+++
phpMyAdmin-new/db_details.php Thu Feb 21
08:09:55 2002<BR>@@ -257,11 +257,11
@@<BR>
} else
{<BR>
list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3,
0);<BR>
}<BR>+
$sum_entries
+=
$sts_data['Rows'];<BR>
} else if ($cfgShowStats)
{<BR>
$formated_size
=
' - ';<BR>
$unit
=
'';<BR>
}<BR>-
$sum_entries
+=
$sts_data['Rows'];<BR>
}<BR> //
MyISAM MERGE
Table<BR>
else if ($cfgShowStats && $mergetable == TRUE) {</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=josh@boxcarmedia.com href="mailto:josh@boxcarmedia.com">Joshua
Nye</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=phpmyadmin-devel@lists.sourceforge.net
href="mailto:phpmyadmin-devel@lists.sourceforge.net">phpmyadmin-devel@lists.sourceforge.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, February 20, 2002 4:40
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [PATCH] Fix incorrect row count
in db_details.php</DIV>
<DIV><FONT size=2></FONT><FONT size=2></FONT><FONT size=2></FONT><BR></DIV>
<DIV><FONT size=2>I noticed that my row count displayed was incorrect for
InnoDB tables as opposed to a SELECT COUNT(*).</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>--Josh</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>---
../phpMyAdmin/db_details.php Tue Feb
19 18:35:40 2002<BR>+++ db_details.php Wed Feb
20 16:37:13 2002<BR>@@ -278,8 +278,10
@@<BR>
echo "\n" . '
';<BR>
if ($mergetable == TRUE)
{<BR>
echo '<i>' . number_format($sts_data['Rows'], 0,
$number_decimal_separator, $number_thousands_separator) . '</i>'
.<BR> "\n";<BR>-
} else
{<BR>+ }
elseif($nonisam == FALSE)
{<BR>
echo number_format($sts_data['Rows'], 0, $number_decimal_separator,
$number_thousands_separator) .
"\n";<BR>+ }
else
{<BR>+
echo
"-";<BR>
}<BR>
?><BR>
</td></FONT></DIV></BLOCKQUOTE></BODY></HTML>