schau dir mal den abschnitt in der templates/xtc4/source/boxes/admin.php an. das hilft dir dann weiter.
schau mal in er tabelle orders und orders_status nach.
-----------------------------------------------------------
// include needed functions
require_once(DIR_FS_INC . 'xtc_image_button.inc.php');
$orders_contents = '';
$orders_status_validating = xtc_db_num_rows(xtc_db_query("select orders_status from " . TABLE_ORDERS ." where orders_status ='0'"));
$orders_contents .='<a href="' . xtc_href_link_admin(FILENAME_ORDERS, 'selected_box=customers&status=0', 'SSL') . '">' . TEXT_VALIDATING . '</a>: ' . $orders_status_validating . '<br />';
$orders_status_query = xtc_db_query("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$_SESSION['languages_id'] . "'");
while ($orders_status = xtc_db_fetch_array($orders_status_query)) {
$orders_pending_query = xtc_db_query("select count(*) as count from " . TABLE_ORDERS . " where orders_status = '" . $orders_status['orders_status_id'] . "'");
$orders_pending = xtc_db_fetch_array($orders_pending_query);
$orders_contents .= '<a href="' . xtc_href_link_admin(FILENAME_ORDERS, 'selected_box=customers&status=' . $orders_status['orders_status_id'], 'SSL') . '">' . $orders_status['orders_status_name'] . '</a>: ' . $orders_pending['count'] . '<br />';
}
$orders_contents = substr($orders_contents, 0, -6);
$customers_query = xtc_db_query("select count(*) as count from " . TABLE_CUSTOMERS);
$customers = xtc_db_fetch_array($customers_query);
$products_query = xtc_db_query("select count(*) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
$products = xtc_db_fetch_array($products_query);
$reviews_query = xtc_db_query("select count(*) as count from " . TABLE_REVIEWS);
$reviews = xtc_db_fetch_array($reviews_query);
$admin_image = '<a href="' . xtc_href_link_admin(FILENAME_START,'', 'SSL').'">'.xtc_image_button('button_admin.gif', IMAGE_BUTTON_ADMIN).'</a>';
if ($product->isProduct()) {
$admin_link='<a href="' . xtc_href_link_admin(FILENAME_EDIT_PRODUCTS, 'cPath=' . $cPath . '&pID=' . $product->data['products_id']) . '&action=new_product' . '" onclick="window.open(this.href); return false;">' . xtc_image_button('edit_product.gif', IMAGE_BUTTON_PRODUCT_EDIT) . '</a>';
}
|