$languages[$i]['code'], 'text' => $languages[$i]['name']); if ($languages[$i]['directory'] == $language) { $languages_selected = $languages[$i]['code']; } } ?> > <?php echo TITLE; ?> Execute("select count(*) as count from " . TABLE_CUSTOMERS); $products = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'"); $products_off = $db->Execute("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '0'"); $reviews = $db->Execute("select count(*) as count from " . TABLE_REVIEWS); $reviews_pending = $db->Execute("select count(*) as count from " . TABLE_REVIEWS . " where status='0'"); $newsletters = $db->Execute("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'"); $counter_query = "select startdate, counter from " . TABLE_COUNTER; $counter = $db->Execute($counter_query); $counter_startdate = $counter->fields['startdate']; // $counter_startdate_formatted = strftime(DATE_FORMAT_LONG, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4))); $counter_startdate_formatted = strftime(DATE_FORMAT_SHORT, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4))); $specials = $db->Execute("select count(*) as count from " . TABLE_SPECIALS . " where status= '0'"); $specials_act = $db->Execute("select count(*) as count from " . TABLE_SPECIALS . " where status= '1'"); $featured = $db->Execute("select count(*) as count from " . TABLE_FEATURED . " where status= '0'"); $featured_act = $db->Execute("select count(*) as count from " . TABLE_FEATURED . " where status= '1'"); $salemaker = $db->Execute("select count(*) as count from " . TABLE_SALEMAKER_SALES . " where sale_status = '0'"); $salemaker_act = $db->Execute("select count(*) as count from " . TABLE_SALEMAKER_SALES . " where sale_status = '1'"); ?>
' . BOX_ENTRY_COUNTER_DATE . ' ' . $counter_startdate_formatted . '
'; echo '
' . BOX_ENTRY_COUNTER . ' ' . $counter->fields['counter'] . '
'; echo '
' . BOX_ENTRY_CUSTOMERS . ' ' . $customers->fields['count'] . '
'; echo '
' . BOX_ENTRY_PRODUCTS . ' ' . $products->fields['count'] . '
'; echo '
' . BOX_ENTRY_PRODUCTS_OFF . ' ' . $products_off->fields['count'] . '
'; echo '
' . BOX_ENTRY_REVIEWS . '' . $reviews->fields['count']. '
'; if (REVIEWS_APPROVAL=='1') { echo '
' . BOX_ENTRY_REVIEWS_PENDING . '' . $reviews_pending->fields['count']. '
'; } echo '
' . BOX_ENTRY_NEWSLETTERS . ' ' . $newsletters->fields['count']. '
'; echo '
' . BOX_ENTRY_SPECIALS_EXPIRED . ' ' . $specials->fields['count']. '
'; echo '
' . BOX_ENTRY_SPECIALS_ACTIVE . ' ' . $specials_act->fields['count']. '
'; echo '
' . BOX_ENTRY_FEATURED_EXPIRED . ' ' . $featured->fields['count']. '
'; echo '
' . BOX_ENTRY_FEATURED_ACTIVE . ' ' . $featured_act->fields['count']. '
'; echo '
' . BOX_ENTRY_SALEMAKER_EXPIRED . ' ' . $salemaker->fields['count']. '
'; echo '
' . BOX_ENTRY_SALEMAKER_ACTIVE . ' ' . $salemaker_act->fields['count']. '
'; ?>
Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'"); while (!$orders_status->EOF) { $orders_pending = $db->Execute("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status->fields['orders_status_id'] . "'"); $orders_contents .= '
' . $orders_status->fields['orders_status_name'] . ': ' . $orders_pending->fields['count'] . '
'; $orders_status->MoveNext(); } echo $orders_contents; ?>
Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_CUSTOMERS_INFO . " a on c.customers_id = a.customers_info_id order by a.customers_info_date_account_created DESC limit 5"); while (!$customers->EOF) { echo '
'. $customers->fields['customers_firstname'] . ' ' . $customers->fields['customers_lastname'] . '' . "\n"; echo zen_date_short($customers->fields['customers_info_date_account_created']); echo '
' . "\n"; $customers->MoveNext(); } ?>
Execute($counter_query); ?>
RecordCount()); ?>    ' . SESSION . ' - ' . TOTAL . ''; ?>
EOF) { $counter_startdate = $counter->fields['startdate']; $counter_startdate_formatted = strftime(DATE_FORMAT_SHORT, mktime(0, 0, 0, substr($counter_startdate, 4, 2), substr($counter_startdate, -2), substr($counter_startdate, 0, 4))); echo '
' . $counter_startdate_formatted . ' ' . $counter->fields['session_counter'] . ' - ' . $counter->fields['counter'] . '
' . "\n"; $counter->MoveNext(); } ?>
Execute("select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id) where class = 'ot_total' order by orders_id DESC limit 5"); while (!$orders->EOF) { echo '
' . $orders->fields['customers_name'] . '' . $orders->fields['order_total'] . '' . "\n"; echo zen_date_short($orders->fields['date_purchased']); echo '
' . "\n"; $orders->MoveNext(); } ?>
Zen Cart:: the art of e-commerce

E-Commerce Engine Copyright © 2003- Zen Cart™


Zen Cart is derived from: Copyright © 2003 osCommerce
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE
and is redistributable under the GNU General Public License