Filter is not working properly on manage-files.php

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Select All status + 0 time + click filter
2.Select Hidden + click filter
3.Select Visible + click filter

What is the expected output? What do you see instead?
The filter is not returning the result
Only indistinct seems to give result

What version of the product are you using? On what operating system?
r412

Please provide any additional information below.
I'm having a javascript error 
Uncaught SyntaxError: Unexpected identifier 
Uncaught TypeError: Cannot read property '1' of undefined

File: jquery.tablesorter.min.js

Original issue reported on code.google.com by access_c...@hotmail.com on 7 May 2013 at 2:48

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I have checked to make sur I have all files situations 

I have selected the options like this to make the test:
Select
Hidden and download count= nothing
Hidden and indistinct = nothing
Hidden and 0 download = nothing
Hidden and 1+ download = nothing

Visible and download count = nothing
Visible and indistinct = nothing
visible and 0 download = nothing
visible and 1+ download = nothing

All status and download count = show all files even the one never downloaded
All status and indistinct = show all files
All status and 0 download = nothing
All status and 1+ download = nothing 

Original comment by access_c...@hotmail.com on 23 Jun 2013 at 3:04

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Here's the solution!! :D

You need to replace this part (lines 259 to 278 included)

        /** Add the status filter */    
        if(isset($_POST['status']) && $_POST['status'] != 'all') {
            $status_filter = $_POST['status'];
            $cq .= " AND hidden='$status_filter'";
            $no_results_error = 'filter';
        }

        /** Add the download count filter */    
        if(isset($_POST['download_count']) && $_POST['download_count'] != 'all') {
            $count_filter = $_POST['download_count'];
            switch ($count_filter) {
                case '0':
                    $cq .= " AND download_count='$count_filter'";
                    break;
                case '1':
                    $cq .= " AND download_count >='$count_filter'";
                    break;
            }
            $no_results_error = 'filter';
        }

with

        /** Add the status filter */    
        if(isset($_POST['status']) && $_POST['status'] != 'all') {
            $set_and = true;
            $status_filter = $_POST['status'];
            $cq .= " WHERE hidden='$status_filter'";
            $no_results_error = 'filter';
        }

        /** Add the download count filter */    
        if(isset($_POST['download_count']) && $_POST['download_count'] != 'all') {
            $count_filter = $_POST['download_count'];
            if (isset($set_and)) {
                $cq .= " AND ";
            }
            else {
                $cq .= " WHERE ";
            }
            switch ($count_filter) {
                case '0':
                    $cq .= "download_count='$count_filter'";
                    break;
                case '1':
                    $cq .= "download_count >='$count_filter'";
                    break;
            }
            $no_results_error = 'filter';
        }

Let me know if this worked for you too.

Original comment by i...@subwaydesign.com.ar on 10 Jul 2013 at 10:31

[GoogleCodeExporter]

Hi, here are my new tests:

I'm not sure what mean 'download count' is this mean downloaded?

Hidden and download count= not working show items that have 0 download (let me 
know if I'm wrong)
Hidden and indistinct = working
Hidden and 0 download = working
Hidden and 1+ download = working

Visible and download count = not working show items that have 0 download (let 
me know if I'm wrong)
Visible and indistinct = working
visible and 0 download = not working show items that have 1+
visible and 1+ download = working

All status and download count = not working show items that have 0 download 
(let me know if I'm wrong)
All status and indistinct = Working 
All status and 0 download = not working show items that have 1+
All status and 1+ download = working  

Thanks

Original comment by access_c...@hotmail.com on 11 Jul 2013 at 2:09

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Any news?

Original comment by access_c...@hotmail.com on 8 Aug 2013 at 1:39

[GoogleCodeExporter]

The problem is that this was looking into a column in the files table that 
doesn't exist anymore, since download count is now handled per assignation and 
not globally. Removing it for now, will re do in the future.

Original comment by i...@subwaydesign.com.ar on 22 Oct 2013 at 5:11

• Changed state: Done

[GoogleCodeExporter]

Hi Guys,
I'm Have a serious issues about : my clientDetail.php page.
I would like to display all the contacts that are in relation with a particular 
client.
The problem is that, When the page is load, the syntax displays only One 
Contact Row rather more rows that are related to the client table.
Ref: Contact table, Client table. 
relationship: 1 client - Many contact

This is my coding.
------------------
$rowCount2 = count($_POST["clients"]);
            for($e=0;$e<$rowCount2;$e++) {
            $result = mysql_query("SELECT * FROM Contact_table INNER JOIN Client_table ON clientID_fk LIKE '" . $_POST["clients"][$e] . "'");
            $row[$e]= mysql_fetch_array($result);
            ?>
            <table class="names">
                    <tr>
                        <th>Names</th>
                        <th>Telephone</th>
                        <th>Cellphone</th>
                        <th>Email</th>
                    </tr> 

            <tr>
                    <td><input type="hidden" name="Contact_Id[]"  value="<?php echo $row[$e]['Contact_Id']; ?>">
                    <input type="text" value="<?php echo $row[$e]['Names']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Telephone']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Cellphone']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Email']; ?>"></td>

            </tr>
            <tr>

                    <td><input type="text" value="<?php echo $row[$e]['Names']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Telephone']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Cellphone']; ?>"></td>
                    <td><input type="text" value="<?php echo $row[$e]['Email']; ?>"></td>
                <?php   
                    }
                    ?>
            </tr>
            </table>

Please any one with the idea or with Help is highly welcome.

Thank you

Original comment by mbuyamba...@gmail.com on 17 Sep 2014 at 11:38