One Hat Cyber Team

View File Name : config.php

<?php


$servername = "wh-db51.csloxinfo.com";
$database = "wineddthaidb";
$username = "windd_user";
$password = "meroot";


// Create connection
$conn = new mysqli($servername, $username, $password, $database);
$conn->set_charset("utf8");

if ($conn->connect_error) {
  $json['connect'] = ("Connection failed: " . $conn->connect_error);
  mysqli_close($conn);
  $json["date_now"] = date("Y-m-d H:i:s");
  echo json_encode($json);
  die();
}

/*error_reporting(E_ALL);
ob_start();
ini_set('display_errors', 1);
date_default_timezone_set("Asia/Bangkok");

// mail('kanaphol.a@gmail.com', 'Subject Line Here', 'Body of Message Here');
mail('kanaphol@sut.ac.th', 'Subject Line Here WINEDD', 'Body of Message Here', "From: kanaphol.a@gmail.com");

  $strTo = "kanaphol.a@gmail.com";
  $strSubject = "Test Send Email";
  $strHeader = "From: kanaphol.a@gmail.com";
  $strMessage = "My Body & My Description";
  $flgSend = @mail($strTo,$strSubject,$strMessage,$strHeader);  // @ = No Show Error //
  if($flgSend)
  {
    echo "Email Sending.";
  }
  else
  {
    echo "Email Can Not Send.";
  }
*/
/*
include_once('mimemail.inc.php');

$mail = new MIMEMAIL("HTML");

$mail->senderName = "WINEDD THAILAND";
$mail->senderMail = "kanaphol.a@gmail.com";
// $mail->bcc = "bcc@email";

$mail->subject = "This is the subject line";

$mail->body = "Hello! This is a message for you.";   // OR: $mail->body = "path/to/file";


$mail->create();

$recipients ='kanaphol.a@gmail.com';
if(!$mail->send($recipients)) echo $mail->error;
*/


/*
      $mail->senderName = "WINEDD THAILAND";//$map['title'];
      $mail->senderMail = "kanaphol.a@gmail.com";// $map['emailReader'];//"wineddth@wineddthailand.com";//$map['emailReader'];
      $mail->bcc = "kanaphol.a@gmail.com";
      //$mail->senderMail = "kanapol0088@gmail.com";
      //$mail->bcc = "kanapol0088@gmail.com";

      $mail->subject = "Detail Ordering No. ";


      // $strMass = orderTable($order_shopInstance->id);
      $strMass="คุณสามารถเข้าไปส่งหลักฐานการชำระเงินได้ที่เมนู ";

      $mail->body = $strMass;

      $mail->create();
      $recipients = "kanaphol.a@gmail.com";
      if(!$mail->send($recipients)) echo $mail->error;
*/

/*
$subject = "Detail Ordering No. ";

$strMass="คุณสามารถเข้าไปส่งหลักฐานการชำระเงินได้ที่เมนู โดยระบุเลขที่ใบสั่งซื้อและอีเมล์ที่ใช้สั่งซื้อ ให้ถูกต้อง<br>หรือ ";

//$headers = "From: "\r\n";
//$headers .= "Reply-To: ". strip_tags($map['emailReader']) . "\r\n";
$headers = "From: kanaphol.a@gmail.com\r\n";
$headers .= "Reply-To: kanaphol.a@gmail.com\r\n";
$headers = "Cc: kanaphol.a@gmail.com". '\r\n';
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=UTF-8\r\n";
@mail('kanaphol.a@gmail.com, w_khunawat@hotmail.com, kanaphol@sut.ac.th', $subject, $strMass, $headers);
//@mail('w_khunawat@hotmail.com, kanaphol.a@gmail.com', $subject, $strMass, $headers);

*/

/*$servername = "wh-db51.csloxinfo.com";
$database = "wineddthaidb";
$username = "windd_user";
$password = "meroot";


// Create connection
$conn = new mysqli($servername, $username, $password, $database);
$conn->set_charset("utf8");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$imageInFoder = dirToArray("src/file/ProductImg/picture");
$imageInDB = array();

// print_r($xx);

$sqlQuery = "SELECT picture FROM ProductImg";
$query = mysqli_query($conn, $sqlQuery);
$i=0;$a=0;$b=0;$notIn=0;$db=0;
while ($instance=mysqli_fetch_assoc($query)) { $db++;
  $imageInDB[] = $instance['picture']; 
}

foreach ($imageInFoder as $data) {$i++;
  if (!in_array($data, $imageInDB)){  $notIn++;
  echo $data;
  $flgDelete = unlink("src/file/ProductImg/picture/".$data);
  if($flgDelete){
    echo " File Deleted";
    $a++;
  }
  else{
    $b++;
    echo " File can not delete";
  }
  echo '<br>';
  }
}

echo "FORDER=".$i.', DB='.$db.', NOTIN='.$notIn.', SUCCESS='.$a.', FAIL='.$b;

function dirToArray($dir) { 

  $result = array(); 

  $cdir = scandir($dir); 
  foreach ($cdir as $key => $value) { 
    if (!in_array($value,array(".",".."))) { 
      if (is_dir($dir . DIRECTORY_SEPARATOR . $value)) { 
        $result[$value] = dirToArray($dir . DIRECTORY_SEPARATOR . $value); 
      } 
      else { 
        $result[] = $value; 
      } 
    } 
  } 

  return $result; 
} */
?>