0){ $record['noOrders'] = "noOrders - 1"; $where = "customer_id = ".$_GET['customer_id']; $update = $db->update($glob['dbprefix']."CubeCart_customer", $record, $where); $where = "cart_order_id = ".$db->mySQLSafe($_GET['delete']); $delete = $db->delete($glob['dbprefix']."CubeCart_order_sum", $where, ""); $delete = $db->delete($glob['dbprefix']."CubeCart_order_inv", $where, ""); if($delete == TRUE){ $msg = "

".$lang['admin']['orders']['delete_success']."

"; } else { $msg = "

".$lang['admin']['orders']['delete_fail']."

"; } } $sqlQuery = ""; if(isset($_GET['oid']) && !isset($_GET['delete'])){ $sqlQuery = "WHERE cart_order_id = ".$db->mySQLsafe($_GET['oid']); } elseif(isset($_GET['customer_id']) && $_GET['customer_id']>0){ $sqlQuery = "WHERE ".$glob['dbprefix']."CubeCart_customer.customer_id = ".$db->mySQLsafe($_GET['customer_id']); } // query database if(isset($_GET['page'])){ $page = $_GET['page']; } else { $page = 0; } $ordersPerPage = 25; $query = "SELECT ".$glob['dbprefix']."CubeCart_customer.customer_id, status, cart_order_id, time, title, firstName, lastName, ip, prod_total, ".$glob['dbprefix']."CubeCart_customer.email FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id ".$sqlQuery." ORDER BY time DESC"; $results = $db->select($query, $ordersPerPage, $page); $numrows = $db->numrows($query); $pagination = $db->paginate($numrows, $ordersPerPage, $page, "page"); ?>

href="javascript:decision('','?delete=&customer_id=');" class="txtLink" >