bluestallion Posted June 18, 2003 Posted June 18, 2003 I just can't seemed to figure out why the order status is not showing in the admin section as shown below. I have restored the database, replaced the entire admin section but it still doesn't show. However, I can still receive the orders via emails and it is captured in the database. What could be the problem? I would appreciate if anybody could help me on this.
bluestallion Posted June 18, 2003 Author Posted June 18, 2003 My adminindex.php file has the related following code on that particular orders area: <?php $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => 'osCommerce'); $contents[] = array('params' => 'class="infoBox"', 'text' => '<a href="http://www.oscommerce.com" target="_blank">' . BOX_ENTRY_SUPPORT_SITE . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/forum" target="_blank">' . BOX_ENTRY_SUPPORT_FORUMS . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/mlists" target="_blank">' . BOX_ENTRY_MAILING_LISTS . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/bugs" target="_blank">' . BOX_ENTRY_BUG_REPORTS . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/faq" target="_blank">' . BOX_ENTRY_FAQ . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/irc" target="_blank">' . BOX_ENTRY_LIVE_DISCUSSIONS . '</a><br>' . '<a href="http://www.oscommerce.com/community.php/cvs" target="_blank">' . BOX_ENTRY_CVS_REPOSITORY . '</a><br>' . '<a href="http://www.oscommerce.com/about.php/portal" target="_blank">' . BOX_ENTRY_INFORMATION_PORTAL . '</a>'); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; $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); $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_ORDERS); $contents[] = array('params' => 'class="infoBox"', 'text' => $orders_contents); $box = new box; echo $box->menuBox($heading, $contents); echo '<br>'; $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); $heading = array(); $contents = array(); $heading[] = array('params' => 'class="menuBoxHeading"', 'text' => BOX_TITLE_STATISTICS); $contents[] = array('params' => 'class="infoBox"', 'text' => BOX_ENTRY_CUSTOMERS . ' ' . $customers['count'] . '<br>' . BOX_ENTRY_PRODUCTS . ' ' . $products['count'] . '<br>' . BOX_ENTRY_REVIEWS . ' ' . $reviews['count']); $box = new box; echo $box->menuBox($heading, $contents); ?> Is this the right code?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.