Namespaces |
| namespace | admin |
Variables |
| | $version_check_index = true |
| | $languages = zen_get_languages() |
| | $languages_array = array() |
| | $languages_selected = DEFAULT_LANGUAGE |
| | for ($i=0, $n=sizeof($languages);$i< $n;$i++) |
| | $customers = $db->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_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'") |
| | if (REVIEWS_APPROVAL=='1') |
| | $orders_contents = '' |
| | $orders_status = $db->Execute("select orders_status_name, orders_status_id from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "'") |
| | while (!$orders_status->EOF) |
| | $orders = $db->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 and class = 'ot_total') order by orders_id DESC limit 5") |