File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/CronJobs/IPOJob/OpenLiveIPO.php
Back
<?php $curl_session = curl_init(); date_default_timezone_set("Asia/Kolkata"); $ttime = date("h:i:sa"); require_once("Connection.php"); $tdate = date("d-m-Y"); $sql = "UPDATE `ipo_post` SET `islive`='YES' WHERE `ipo_open` = '$tdate'"; $con->query($sql); $sql = "SELECT `c_name` AS 'CNAME',`islive` AS 'ISLIVE' FROM `ipo_post` WHERE `ipo_open` = '$tdate'"; $result = $con->query($sql); $opt = ""; while($row = $result -> fetch_assoc()) { if($row['ISLIVE'] == "YES") $opt = $opt . "[OPEN] - " . $row["CNAME"] . "\n"; else $opt = $opt . "[CLOSE] - " . $row["CNAME"] . "\n"; } mysqli_close($con); if($opt == "") { exit(1); } $path_to_fcm = "https://fcm.googleapis.com/fcm/send"; $server_key = "AAAAzvFKC6k:APA91bGwplf3DZMMEsvtWCoeCXnBttNVgS2h3s5GuPDA6RkYvnFZuYNLy-zYt5TlVAm2fusnmh3ZFZbTxpLs1xMVIRfXmYd-yQe-CpjItU0Im6zUcjbq9bLFuj9-2y7LSkBfp2eS2Qoo"; $con=mysqli_connect("localhost:3306", "marketdatauser", "d7o7A8%s2d7", "marketdataci"); $sql = "SELECT `fcmid` as 'FCM' FROM `admin_fcm`"; $result = $con->query($sql); while($row = $result -> fetch_assoc()) { $title = "IPO CLOSE Status " . $ttime; $msg = $opt; $headers = array( 'Authorization: key=' . $server_key, 'Content-Type: application/json' ); $fields = array( 'to' => $row['FCM'], 'notification'=> array( 'title'=> $title, 'body'=> $msg, 'click_action' => 'MAIN' )); $payload = json_encode($fields); curl_setopt($curl_session, CURLOPT_URL,$path_to_fcm); curl_setopt($curl_session, CURLOPT_POST, true); curl_setopt($curl_session, CURLOPT_HTTPHEADER, $headers); curl_setopt($curl_session, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl_session, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($curl_session, CURLOPT_POSTFIELDS, $payload); $res = curl_exec($curl_session); curl_close($curl_session); } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings