One Hat Cyber Team

Your IP: 216.73.216.142
Server IP: 217.76.53.76
Server: Linux vmi1397931.contaboserver.net 5.4.0-105-generic #119-Ubuntu SMP Mon Mar 7 18:49:24 UTC 2022 x86_64
Server Software: Apache
PHP Version: 8.2.27
Buat File | Buat Folder
Dir : ~/www/wwwroot/extra.spread.com.ng/app/Models/
View File Name : Message.php

<?php

namespace Texter\Models;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\File;

class Message extends Model
{
    
	/* message */
	
	public static function saveMessage($record)
	{
   
      DB::table('message')->insert($record);
     
 
    }
	
	public static function saveYoutube($record)
	{
   
      DB::table('youtube_download')->insert($record);
     
 
    }
	
	public static function saveShare($record)
	{
   
      DB::table('image_share')->insert($record);
     
 
    }
	
	public static function viewShare($token)
  {
     $value = DB::table('image_share')->where('image_url', $token)->first();
	 return $value;
  }
	
	public static function viewWebp($image_url)
  {
     $value = DB::table('webp_convertor')->where('image_url', $image_url)->first();
	 return $value;
  }
	
	public static function CountShare($token)
  {
     $get = DB::table('image_share')->where('image_url', $token)->get();
	 $value = $get->count();
     return $value;
  }
	
	public static function dropYoutube($id){
    
	DB::table('youtube_download')->where('download_id', '=', $id)->delete();	
	
	
  }
	
  public static function checkMessage($token)
  {
    
    $get=DB::table('message')->where('message_drop_status', 'no')->where('message_token','=',$token)->get(); 
	$value = $get->count();
    return $value;
	
  }
  
  
  public static function checkPassword($password,$token)
  {
    
    $get=DB::table('message')->where('message_drop_status','=','no')->where('message_password','=',$password)->where('message_token','=',$token)->get(); 
	$value = $get->count();
    return $value;
	
  }
  
  
  public static function dropMessage($token,$data){
    DB::table('message')
      ->where('message_token', $token)
      ->update($data);
  }	
  
  
  public static function viewMessage($token)
  {
     $value = DB::table('message')->where('message_drop_status', 'no')->where('message_token', $token)->first();
	 return $value;
  }
  
  
  
   public static function getmessageData()
  {

    $value=DB::table('message')->where('message_drop_status', 'no')->orderBy('message_id', 'desc')->get(); 
    return $value;
	
  }	
  
  public static function getyoutubeData()
  {

    $value=DB::table('youtube_download')->orderBy('download_id', 'desc')->get(); 
    return $value;
	
  }	
  
  public static function getshareData()
  {

    $value=DB::table('image_share')->orderBy('img_id', 'desc')->get(); 
    return $value;
	
  }	
  
  public static function getwebpData()
  {

    $value=DB::table('webp_convertor')->orderBy('img_id', 'desc')->get(); 
    return $value;
	
  }	
  
  public static function dropWebp($id)
  {
    $image = DB::table('webp_convertor')->where('img_id', $id)->first();
        $file= $image->file_name;
        $filename = public_path().'/storage/webp/'.$file;
        File::delete($filename);  
	DB::table('webp_convertor')->where('img_id', '=', $id)->delete();	
	
	
  }
  
  public static function saveWebp($record)
	{
   
      DB::table('webp_convertor')->insert($record);
     
 
    }
  
  public static function dropShare($id)
  {
    $image = DB::table('image_share')->where('img_id', $id)->first();
        $file= $image->image_name;
        $filename = public_path().'/storage/share/'.$file;
        File::delete($filename);  
	DB::table('image_share')->where('img_id', '=', $id)->delete();	
	
	
  }
  public static function totalMessage()
  {

    $get=DB::table('message')->where('message_drop_status', 'no')->orderBy('message_id', 'desc')->get(); 
    $value = $get->count();
    return $value;
	
  }
  
  public static function todayMessage()
  {
    $today = date('Y-m-d');
    $get=DB::table('message')->where('message_drop_status', 'no')->where('message_update','=',$today)->orderBy('message_id', 'desc')->get(); 
    $value = $get->count();
    return $value;
	
  }
  public static function lastMessage()
  {
    $last = date('Y-m-d',strtotime("-1 days"));
    $get=DB::table('message')->where('message_drop_status', 'no')->where('message_update','=',$last)->orderBy('message_id', 'desc')->get(); 
    $value = $get->count();
    return $value;
	
  }
  
  public static function totalVisitors()
  {

    $get=DB::table('message')->where('message_drop_status', 'no')->groupBy('message_user_ip')->get(); 
    $value = $get->count();
    return $value;
	
  }
  /* message */
  
  
  
  
}