Changeset 6203

Show
Ignore:
Timestamp:
08/20/08 16:07:19 (5 months ago)
Author:
dduponchelle
Message:

#156 CSV and XML export with all datas (no pagination).

Location:
trunk/centreon/www/include/eventLogs
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/centreon/www/include/eventLogs/GetODSCSVLog.php

    r6068 r6203  
    3838         
    3939        // save of the XML flow in $flux 
     40        $csv_flag = 1; //setting the csv_flag variable to change limit in SQL request of getODSXmlLog.php when CSV exporting 
    4041        ob_start(); 
    4142        require_once $centreon_path."www/include/eventLogs/GetODSXmlLog.php"; 

  • trunk/centreon/www/include/eventLogs/GetODSXmlLog.php

    r6040 r6203  
    463463         * Full Request 
    464464         */ 
    465         $req .= " ORDER BY ctime DESC,log_id DESC LIMIT $lstart,$limit"; 
     465    if(isset($csv_flag) && ($csv_flag == 1)) 
     466    $req .= " ORDER BY ctime DESC,log_id DESC LIMIT 0,64000"; //limit a little less than 2^16 which is excel maximum number of lines 
     467    else 
     468    $req .= " ORDER BY ctime DESC,log_id DESC LIMIT $lstart,$limit"; 
     469 
    466470 
    467471        $DBRESULT =& $pearDBO->query($req);