Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    214
    Plugin Contributions
    0

    Default Admin section layout

    By default the admin section shows the last 5 customers and the last 5 orders. how/where would I change this to display the last 20?

  2. #2
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,846
    Plugin Contributions
    25

    Default Re: Admin section layout

    In your_admin/index.php
    find
    PHP Code:
            $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"); 
    and change limit5 to 20

    also find
    PHP Code:
            $customers $db->Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, c.customers_email_address as customers_email_address, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id, c.COWOA_account 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"); 
    and change limit5 to 20

  3. #3
    Join Date
    Jul 2011
    Posts
    214
    Plugin Contributions
    0

    Default Re: Admin section layout

    Perfect, thanks!


    Quote Originally Posted by Design75 View Post
    In your_admin/index.php
    find
    PHP Code:
            $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"); 
    and change limit5 to 20

    also find
    PHP Code:
            $customers $db->Execute("select c.customers_id as customers_id, c.customers_firstname as customers_firstname, c.customers_lastname as customers_lastname, c.customers_email_address as customers_email_address, a.customers_info_date_account_created as customers_info_date_account_created, a.customers_info_id, c.COWOA_account 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"); 
    and change limit5 to 20

 

 

Similar Threads

  1. v137 Simplifying and Cleaning Up the Layout of My Products Listing (In Categories Section)
    By nchgalleries in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 21 May 2014, 11:04 PM
  2. Recently uploaded a backup admin folder now admin section is missing
    By Robert Thomas Kirby in forum General Questions
    Replies: 2
    Last Post: 23 May 2013, 10:20 AM
  3. Broken layout on one section only
    By paulmd in forum Templates, Stylesheets, Page Layout
    Replies: 16
    Last Post: 9 Mar 2011, 10:25 PM
  4. Replies: 3
    Last Post: 25 Jul 2007, 07:13 AM
  5. Help with layout of center section
    By Wilkesy in forum Templates, Stylesheets, Page Layout
    Replies: 11
    Last Post: 14 May 2007, 02:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR