''>ZITAT(marcopolo @ Apr 7 2007, 19:44) 24249
und wie bekomme ich das in meinen Adminbereich ?
Sorry, kenn mich wirklich nicht so gut aus
[/b]
Hier ne´ Quick'n'dirty Lösung. Basiert auf stats_products_purchased.php
<?php
/ --------------------------------------------------------------
** $Id: stats_products_purchased.php 899 2005-04-29 02:40:57Z hhgag $**
** XT-Commerce - community made shopping
** http://www.xt-commerce.com
** Copyright (c) 2003 XT-Commerce
** --------------------------------------------------------------
** based on:
** (c) 2000-2001 The Exchange Project**(earlier name of osCommerce)
** (c) 2002-2003 osCommerce(stats_products_purchased.php,v 1.27 2002/11/18); www.oscommerce.com
** (c) 2003**** nextcommerce (stats_products_purchased.php,v 1.9 2003/08/18); www.nextcommerce.org
** Released under the GNU General Public License
** -------------------------------------------------------------- /
**require('includes/application_top.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Tranistional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $_SESSION['language_charset']; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<table border="0" width="100%" cellspacing="2" cellpadding="2">
**<tr>
****<td class="columnLeft2" width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
********</table></td>
****<td class="boxCenter" width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
******<tr>
********<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
**<tr>
****<td width="80" rowspan="2"><?php echo xtc_image(DIR_WS_ICONS.'heading_statistic.gif'); ?></td>
****<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
**</tr>
**<tr>
****<td class="main" valign="top">XT Statistics</td>
**</tr>
</table></td>
******</tr>
******<tr>
********<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
**********<tr>
************<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
**************<tr class="dataTableHeadingRow">
****************<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td>
****************<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
****************<td class="dataTableHeadingContent" align="center"><?php echo "Kunde"; ?></td>
**************</tr>
<?php
**if ($_GET['page'] > 1) $rows = $_GET['page'] '20' - '20';
//**$products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name";
**$products_query_raw = "select op.products_id, op.products_model, o.customers_id, o.customers_name, o.customers_email_address from orders o, orders_products op where o.orders_id = op.orders_id";
**$products_split = new splitPageResults($_GET['page'], '20', $products_query_raw, $products_query_numrows);
**$products_query = xtc_db_query($products_query_raw);
**while ($products = xtc_db_fetch_array($products_query)) {
****$rows++;
****if (strlen($rows) < 2) {
******$rows = '0' . $rows;
****}
?>
**************<tr>
****************<td class="dataTableContent"><?php echo $rows; ?>.</td>
****************<td class="dataTableContent"><?php echo $products['products_id'].' - '.$products['products_model']; ?></td>
****************<td class="dataTableContent" align="center"><?php echo $products['customers_id'].' - '. $products['customers_name'].' - '.$products['customers_email_address']; ?></td>
**************</tr>
<?php
**}
?>
************</table></td>
**********</tr>
**********<tr>
************<td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2">
**************<tr>
****************<td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, '20', $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
****************<td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, '20', MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?></td>
**************</tr>
************</table></td>
**********</tr>
********</table></td>
******</tr>
****</table></td>
**</tr>
</table>
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Einfach irgendwie in den Adminbereich einbinden.