Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Old" Blue GUI Screen


Guest

Recommended Posts

Hi

 

Hope this makes sense.

 

Does anyone know where I could get Something like the old blue screen. It shows statistics, orders pending orders dispatched etc.

 

Cheers

 

Grandpa

Link to comment
Share on other sites

Hi,

 

Have a look at the Generate Orderlist contribution

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

Hi

 

Thanks for that. Its not really what Im looking for. If I knew how to upload an image I would be able to show what I'm after.

 

Cheers

 

Grandpa

I know exactly what you are talking about. You are looking for the stats that were displayed on the admins index page.

 

This is a little rough but it will show the stats you want.

 

First make sure you have a backup of your file.

 

In admin/index.php find

       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

Change to

       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
<?php
 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
 $customers = tep_db_fetch_array($customers_query);
 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
 $products = tep_db_fetch_array($products_query);
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);
 $reviews = tep_db_fetch_array($reviews_query);
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="4">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent">Statistics</td>
               <td class="dataTableHeadingContent">Total</td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Customers</td>
               <td class="dataTableContent"><?php echo $customers['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Products</td>
               <td class="dataTableContent"><?php echo $products['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Reviews</td>
               <td class="dataTableContent"><?php echo $reviews['count']; ?></td>
             </tr>
<?php
 $orders_contents = '';
 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
   $orders_pending = tep_db_fetch_array($orders_pending_query);
   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';
 }
 $orders_contents = substr($orders_contents, 0, -4);
?>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent" valign="top">Orders</td>
               <td class="dataTableContent" valign="top"><?php echo $orders_contents; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

Link to comment
Share on other sites

I know exactly what you are talking about. You are looking for the stats that were displayed on the admins index page.

 

This is a little rough but it will show the stats you want.

 

First make sure you have a backup of your file.

 

In admin/index.php find

       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

Change to

       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
<?php
 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
 $customers = tep_db_fetch_array($customers_query);
 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
 $products = tep_db_fetch_array($products_query);
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);
 $reviews = tep_db_fetch_array($reviews_query);
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="4">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent">Statistics</td>
               <td class="dataTableHeadingContent">Total</td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Customers</td>
               <td class="dataTableContent"><?php echo $customers['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Products</td>
               <td class="dataTableContent"><?php echo $products['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Reviews</td>
               <td class="dataTableContent"><?php echo $reviews['count']; ?></td>
             </tr>
<?php
 $orders_contents = '';
 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
   $orders_pending = tep_db_fetch_array($orders_pending_query);
   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';
 }
 $orders_contents = substr($orders_contents, 0, -4);
?>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent" valign="top">Orders</td>
               <td class="dataTableContent" valign="top"><?php echo $orders_contents; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

 

Hi

Many many thanks for that. Will give it a go.

 

Cheers

 

Grandpa

Link to comment
Share on other sites

Hi

 

I did as instructed (I think) but nothing seemed to have happened. There wasn't a heading in the Admin called Statistics (the index.php prior to amending had 19,105 KB)

 

I must have done something wrong.

 

Shall I post the amended file.

 

Cheers

 

Grandpa

Link to comment
Share on other sites

Hi

 

I did as instructed (I think) but nothing seemed to have happened. There wasn't a heading in the Admin called Statistics (the index.php prior to amending had 19,105 KB)

 

I must have done something wrong.

 

Shall I post the amended file.

 

Cheers

 

Grandpa

Yes post your file.

 

I'm assumming you are using osc rc2a. Is that right? I also assume the stats you are looking for were the ones from an osc version prior to the rc releases.

Link to comment
Share on other sites

Yes post your file.

 

I'm assumming you are using osc rc2a. Is that right? I also assume the stats you are looking for were the ones from an osc version prior to the rc releases.

Hi

 

Ive got 2.2RC2. We also have 2 other web sites and these are about 8/9 years old, and both have the Blue Admin panel, which on the left amongst other things has Orders then sub Pending, Processing, Despatched, Order update etc. Then heading Statistics etc.

 

Cheers

 

John

Link to comment
Share on other sites

Hi

 

Ive got 2.2RC2. We also have 2 other web sites and these are about 8/9 years old, and both have the Blue Admin panel, which on the left amongst other things has Orders then sub Pending, Processing, Despatched, Order update etc. Then heading Statistics etc.

 

Cheers

 

John

The sites that are 8/9 years old are probably using this admin screen, the one you are talking about.

adminscreen_2.jpg

 

The one for the rc2a version looks like this. I will also post the code for that index page nelow.

adminscreen.jpg

 

Make sure to backup your file first.

 

This is for admin/index.php for rc2a version only.

<?php
/*
 $Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2007 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 $languages = tep_get_languages();
 $languages_array = array();
 $languages_selected = DEFAULT_LANGUAGE;
 for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
   $languages_array[] = array('id' => $languages[$i]['code'],
                              'text' => $languages[$i]['name']);
   if ($languages[$i]['directory'] == $language) {
     $languages_selected = $languages[$i]['code'];
   }
 }
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="robots" content="noindex,nofollow">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2" height="40">
         <tr>
           <td class="pageHeading"><?php echo STORE_NAME; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_form('adminlanguage', FILENAME_DEFAULT, '', 'get') . tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"') . tep_hide_session_id() . '</form>'; ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
 $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
 $files = array();
 if ($dir = @dir(DIR_FS_ADMIN . 'includes/modules/index')) {
   while ($file = $dir->read()) {
     if (!is_dir($module_directory . $file)) {
       if (substr($file, strrpos($file, '.')) == $file_extension) {
         $files[] = $file;
       }
     }
   }
   sort($files);
   $dir->close();
 }

 $col = 0;

 for ($i=0, $n=sizeof($files); $i<$n; $i++) {
   if (file_exists(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i])) {
     include(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i]);
   }

   if ($col < 1) {
     echo '          <tr>' . "\n";
   }

   $col++;

   if ($col <= 2) {
     echo '            <td width="50%" valign="top">' . "\n";
   }

   include('includes/modules/index/' . $files[$i]);

   if ($col <= 2) {
     echo '            </td>' . "\n";
   }

   if ( !isset($files[$i+1]) || ($col == 2) ) {
     if ( !isset($files[$i+1]) && ($col == 1) ) {
       echo '            <td width="50%" valign="top"> </td>' . "\n";
     }

     $col = 0;

     echo '  </tr>' . "\n";
   }
 }
?>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
<?php
 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
 $customers = tep_db_fetch_array($customers_query);
 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
 $products = tep_db_fetch_array($products_query);
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);
 $reviews = tep_db_fetch_array($reviews_query);
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="4">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent">Statistics</td>
               <td class="dataTableHeadingContent">Total</td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Customers</td>
               <td class="dataTableContent"><?php echo $customers['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Products</td>
               <td class="dataTableContent"><?php echo $products['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Reviews</td>
               <td class="dataTableContent"><?php echo $reviews['count']; ?></td>
             </tr>
<?php
 $orders_contents = '';
 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
   $orders_pending = tep_db_fetch_array($orders_pending_query);
   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';
 }
 $orders_contents = substr($orders_contents, 0, -4);
?>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent" valign="top">Orders</td>
               <td class="dataTableContent" valign="top"><?php echo $orders_contents; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

The sites that are 8/9 years old are probably using this admin screen, the one you are talking about.

adminscreen_2.jpg

 

The one for the rc2a version looks like this. I will also post the code for that index page nelow.

adminscreen.jpg

 

Make sure to backup your file first.

 

This is for admin/index.php for rc2a version only.

<?php
/*
 $Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2007 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 $languages = tep_get_languages();
 $languages_array = array();
 $languages_selected = DEFAULT_LANGUAGE;
 for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
   $languages_array[] = array('id' => $languages[$i]['code'],
                              'text' => $languages[$i]['name']);
   if ($languages[$i]['directory'] == $language) {
     $languages_selected = $languages[$i]['code'];
   }
 }
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="robots" content="noindex,nofollow">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2" height="40">
         <tr>
           <td class="pageHeading"><?php echo STORE_NAME; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_form('adminlanguage', FILENAME_DEFAULT, '', 'get') . tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"') . tep_hide_session_id() . '</form>'; ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
 $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
 $files = array();
 if ($dir = @dir(DIR_FS_ADMIN . 'includes/modules/index')) {
   while ($file = $dir->read()) {
     if (!is_dir($module_directory . $file)) {
       if (substr($file, strrpos($file, '.')) == $file_extension) {
         $files[] = $file;
       }
     }
   }
   sort($files);
   $dir->close();
 }

 $col = 0;

 for ($i=0, $n=sizeof($files); $i<$n; $i++) {
   if (file_exists(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i])) {
     include(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i]);
   }

   if ($col < 1) {
     echo '          <tr>' . "\n";
   }

   $col++;

   if ($col <= 2) {
     echo '            <td width="50%" valign="top">' . "\n";
   }

   include('includes/modules/index/' . $files[$i]);

   if ($col <= 2) {
     echo '            </td>' . "\n";
   }

   if ( !isset($files[$i+1]) || ($col == 2) ) {
     if ( !isset($files[$i+1]) && ($col == 1) ) {
       echo '            <td width="50%" valign="top"> </td>' . "\n";
     }

     $col = 0;

     echo '  </tr>' . "\n";
   }
 }
?>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
<?php
 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
 $customers = tep_db_fetch_array($customers_query);
 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
 $products = tep_db_fetch_array($products_query);
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);
 $reviews = tep_db_fetch_array($reviews_query);
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="4">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent">Statistics</td>
               <td class="dataTableHeadingContent">Total</td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Customers</td>
               <td class="dataTableContent"><?php echo $customers['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Products</td>
               <td class="dataTableContent"><?php echo $products['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Reviews</td>
               <td class="dataTableContent"><?php echo $reviews['count']; ?></td>
             </tr>
<?php
 $orders_contents = '';
 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
   $orders_pending = tep_db_fetch_array($orders_pending_query);
   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';
 }
 $orders_contents = substr($orders_contents, 0, -4);
?>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent" valign="top">Orders</td>
               <td class="dataTableContent" valign="top"><?php echo $orders_contents; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Hi

 

Many thanks for that.

 

Yes it is the top blue one that I would like. Is it possible to get the code for this and use it, or is not advisable to use,

 

Cheers

 

Grandpa

Link to comment
Share on other sites

The sites that are 8/9 years old are probably using this admin screen, the one you are talking about.

adminscreen_2.jpg

 

The one for the rc2a version looks like this. I will also post the code for that index page nelow.

adminscreen.jpg

 

Make sure to backup your file first.

 

This is for admin/index.php for rc2a version only.

<?php
/*
 $Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2007 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 $languages = tep_get_languages();
 $languages_array = array();
 $languages_selected = DEFAULT_LANGUAGE;
 for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
   $languages_array[] = array('id' => $languages[$i]['code'],
                              'text' => $languages[$i]['name']);
   if ($languages[$i]['directory'] == $language) {
     $languages_selected = $languages[$i]['code'];
   }
 }
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="robots" content="noindex,nofollow">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2" height="40">
         <tr>
           <td class="pageHeading"><?php echo STORE_NAME; ?></td>
           <td class="pageHeading" align="right"><?php echo tep_draw_form('adminlanguage', FILENAME_DEFAULT, '', 'get') . tep_draw_pull_down_menu('language', $languages_array, $languages_selected, 'onChange="this.form.submit();"') . tep_hide_session_id() . '</form>'; ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
 $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.'));
 $files = array();
 if ($dir = @dir(DIR_FS_ADMIN . 'includes/modules/index')) {
   while ($file = $dir->read()) {
     if (!is_dir($module_directory . $file)) {
       if (substr($file, strrpos($file, '.')) == $file_extension) {
         $files[] = $file;
       }
     }
   }
   sort($files);
   $dir->close();
 }

 $col = 0;

 for ($i=0, $n=sizeof($files); $i<$n; $i++) {
   if (file_exists(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i])) {
     include(DIR_WS_LANGUAGES . $language . '/modules/index/' . $files[$i]);
   }

   if ($col < 1) {
     echo '          <tr>' . "\n";
   }

   $col++;

   if ($col <= 2) {
     echo '            <td width="50%" valign="top">' . "\n";
   }

   include('includes/modules/index/' . $files[$i]);

   if ($col <= 2) {
     echo '            </td>' . "\n";
   }

   if ( !isset($files[$i+1]) || ($col == 2) ) {
     if ( !isset($files[$i+1]) && ($col == 1) ) {
       echo '            <td width="50%" valign="top"> </td>' . "\n";
     }

     $col = 0;

     echo '  </tr>' . "\n";
   }
 }
?>
       </table></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td valign="top">
<?php
 $customers_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
 $customers = tep_db_fetch_array($customers_query);
 $products_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
 $products = tep_db_fetch_array($products_query);
 $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS);
 $reviews = tep_db_fetch_array($reviews_query);
?>
           <table border="0" width="100%" cellspacing="0" cellpadding="4">
             <tr class="dataTableHeadingRow">
               <td class="dataTableHeadingContent">Statistics</td>
               <td class="dataTableHeadingContent">Total</td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Customers</td>
               <td class="dataTableContent"><?php echo $customers['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Products</td>
               <td class="dataTableContent"><?php echo $products['count']; ?></td>
             </tr>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent">Reviews</td>
               <td class="dataTableContent"><?php echo $reviews['count']; ?></td>
             </tr>
<?php
 $orders_contents = '';
 $orders_status_query = tep_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'");
 while ($orders_status = tep_db_fetch_array($orders_status_query)) {
   $orders_pending_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
   $orders_pending = tep_db_fetch_array($orders_pending_query);
   $orders_contents .= '<a href="' . tep_href_link(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id']) . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br>';
 }
 $orders_contents = substr($orders_contents, 0, -4);
?>
             <tr class="dataTableRow" onmouseover="rowOverEffect(this);" onmouseout="rowOutEffect(this);">
               <td class="dataTableContent" valign="top">Orders</td>
               <td class="dataTableContent" valign="top"><?php echo $orders_contents; ?></td>
             </tr>
           </table></td>
         </tr>
       </table></td>
     </tr>
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Hi

 

Many thanks for that.

 

Yes it is the top blue one that I would like. Is it possible to get the code for this and use it, or is not advisable to use,

 

Cheers

 

Grandpa

Link to comment
Share on other sites

The code I provided above brings in the stats you were looking for. If you look at the picture you will see a table with the headings of Statistics and Total. Those are the stats from the old version.

 

Sorry, but making the entire page look like the old one is more work than I am willing to do.

Link to comment
Share on other sites

The code I provided above brings in the stats you were looking for. If you look at the picture you will see a table with the headings of Statistics and Total. Those are the stats from the old version.

 

Sorry, but making the entire page look like the old one is more work than I am willing to do.

Hi

 

Many many thanks for that. I didn't realize that you had to do it.

 

Thanks again soooo much.

 

Kind regards

 

Grandpa

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...