Jump to content


  • Content count

  • Joined

  • Last visited

Posts posted by bibliopolis

  1. hello. i am trying show retail_price at admin/invoice.php an i haven't managed.

    i have tryed to pull it from the products table as i do with other fields. and drom the orders table as normal proce does.

    any ideas?

    the perfect would be to show retail, list, & special price.

    Thanks in advace

  2. Hi vey nice contribution


    look o how they use the functionality .






    they have multiple authors per book but the url per author is like that:





    and by clicking on an author when taken to the authors page you see all the entries even those that he is the second or third author .


    Again thanks everyone involved in this contribution

  3. hi . i have successfully installed this amazing/handy/fantastik contribution and the products list nicely under their manufacturer. i also list extra fields per products as author and isbn. from the products table


    what i try to do is to display the manufacturer_url from the manufacturers_info table but i cant make the join of the tables at admin/includes/order.php


    i have tried to improvise by looking at the manufacturers_info box from the catalog side but i cant understand it



    *********************************this is the place that the join has to happen :-)



    $orders_products_query = tep_db_query("select op.orders_products_id, op.products_id, op.products_name,products_person, products_isbn, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price, p.manufacturers_id,m.manufacturers_name from " . TABLE_ORDERS_PRODUCTS . " op left join " . TABLE_PRODUCTS . " p on p.products_id = op.products_id left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id = p.manufacturers_id where op.orders_id = '" . (int)$order_id . "' order by p.manufacturers_id");




    while ($orders_products = tep_db_fetch_array($orders_products_query)) {

    $this->products[$index] = array('qty' => $orders_products['products_quantity'],

    'products_person' => $orders_products['products_person'],

    'products_isbn' => $orders_products['products_isbn'],

    'name' => $orders_products['products_name'],

    'products_id' => $orders_products['products_id'],

    'model' => $orders_products['products_model'],

    'tax' => $orders_products['products_tax'],

    'price' => $orders_products['products_price'],

    'id' => $orders_products['products_id'],

    'final_price' => $orders_products['final_price'],

    'manufacturers_id' => $orders_products['manufacturers_id'],


    'manufacturers_name' => $orders_products['manufacturers_name']);


    regards from greece


  4. 0 -


    select count(p.products_id) as nbr, m.manufacturers_id, m.manufacturers_name from products p join specials s using (products_id) join manufacturers m using(manufacturers_id) where p.products_status = '1' and s.status = '1' group by manufacturers_name having nbr > 5 order by nbr DESC



    that shows up in my left column when i add the include for the box



    nice idea this box.