Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

mysql.php

<?php
class Db_Con
{
 public static $instance;
 public $global_dbh;
 //public $_myi;
 /**
 * row count from last select query
 *
 * @var integer
 */
 public $rcount;
 public $debug;
 public $error;
 public function __construct ( 
 $mysql_host , 
 $mysql_user , 
 $mysql_pass , 
 $mysql_db , 
 $debug = false )
 {
 $this->global_dbh = mysqli_connect($mysql_host, $mysql_user, $mysql_pass,$mysql_db);
 mysqli_select_db($this->global_dbh,$mysql_db);
 $this->debug = $debug;
 self::$instance = &$this;
 $this->error = "";
 }
 public static function getInstance ( 
 $mysql_host = false , 
 $mysql_user = false , 
 $mysql_pass = false , 
 $mysql_db = false , 
 $debug = false )
 { 
 
 if (! isset(self::$instance) && $mysql_host !== false)
 {
 
 self::$instance = new Db_Con($mysql_host, $mysql_user, $mysql_pass, $mysql_db, $debug);
 }elseif (isset(self::$instance)){
 
 return self::$instance;
 }
 else
 {
 
 return false;
 }
 }
 
 /**
 * use this for queries returning one row.
 * it returns the an associative array repsenting the results row.
 *
 * This will return false if more than one row is returned. USE LIMIT Clauses
 * 
 * @param string $query the query to be sent.
 * @return array or failse on failure
 */
 public function select_query ( 
 $query )
 {
 if ($this->debug)
 {
 
 echo "" . $query . "";
 }
 $result = mysqli_query($this->global_dbh,$query);
 if ($result === false)
 { 
 
 return false;
 }
 $this->error = mysqli_error($this->global_dbh);
 if (($this->rcount = mysqli_num_rows($result)) == 1)
 {
 
 $re = mysqli_fetch_assoc($result);
 
 } else
 {
 $re = false;
 }
 return $re;
 }
 /**
 * Use this for queries that return more than one row. It returns an array of result rows. 
 * The result rows are associative, the best way to use it is to for each through it 
 * and use each result row individually 
 *
 * @param unknown_type $query
 * @param unknown_type $both
 * @return array or false ... false if not found or bad query
 */
 public function select_query_multi ( 
 $query , 
 $both = true )
 {
	
 if ($this->debug)
 {
 echo "" . $query . "";
 }
 $result = mysqli_query($this->global_dbh,$query);
 $this->error = mysqli_error($this->global_dbh);
 if (($result !== FALSE) && ($this->rcount = mysqli_num_rows($result)) > 0)
 {
 $row = array();
 if ($both)
 {
 while ($temp = mysqli_fetch_array($result))
 {
 $row[] = $temp;
 }
 } else
 {
 while ($temp = mysqli_fetch_assoc($result))
 {
 $row[] = $temp;
 }
 }
 } else
 {
 if ($this->debug)
 {
 echo "" . $this->error . "";
			if(!empty($row)){
 print_r($row);
			}
			else{
				echo "No records found";
			}
 }
 $row = false;
 }
 return $row;
 }
 
 /**
 * This is used for graphing only
 *
 * @param unknown_type $query
 * @param unknown_type $datefill
 * @param unknown_type $limit
 * @return unknown
 */
 public function select_query_multi_graph ( 
 $query , 
 $datefill = false , 
 $limit = 10 )
 {
 if ($datefill)
 {
 include_once 'modules/dateclass.php';
 $span = new DateSpanClass();
 }
 if ($this->debug)
 {
 echo "" . $query . "";
 }
 $result = mysql_query($query);
 if (($result !== FALSE) && ($this->rcount = mysql_num_rows($result)) > 0)
 {
 $row = array();
 $temp = mysql_fetch_assoc($result);
 $keys = array_keys($temp);
 $keys[0] = "";
 $kcount = count($keys);
 $v = array_values($temp);
 for ($j = 0; $j < $kcount; $j ++)
 {
 $row[$j] = array(
 $keys[$j]);
 $row[$j][] = $v[$j];
 }
 if ($this->debug)
 {
 echo "<pre>";
 print_r($row);
 echo "</pre>";
 }
// 			echo "<pre>";
// print_r($row);
// echo "</pre>";
 $realCount = $limit;
			//echo " this count =".$this->rcount."real count = ".$realCount;
 for ($i = 1; $i < $this->rcount && $i < $realCount; $i ++)
 {//echo " i=".$i;
 $temp = mysql_fetch_row($result);
 //check if we are worrying about spans 
 if ($datefill && $i != 1 && $span->Days($row[0][$i], $temp[0]) > 1)
 {//echo " if";
 while ($i < $realCount && $span->Days($row[0][$i], $temp[0]) > 1)
 {
 $day = new DateClass($row[0][$i]);
 $day->Add("d", 1);$i ++;
 $row[0][$i] = $day->ToString('Y-m-d');
 
 for ($j = 1; $j < $kcount; $j ++)
 {
 $row[$j][$i] = 0;
 }
 }
 } else
 {
 //echo " did else";
 for ($j = 0; $j < $kcount; $j ++)
 {
 $row[$j][] = $temp[$j];
 }
 }
 if ($this->debug)
 {
 echo "<pre>";
 print_r($row);
 echo "</pre>";
 } 
// 					echo "<pre>";
// print_r($row);
// echo "</pre>";

for ($j = 0; $j < $kcount && $i < $realCount; $j ++)
 {
 $row[$j][] = $temp[$j];
 }
 }
 } else
 {
 if ($this->debug)
 {
 echo "";
 echo "ifailed";
 echo "";
 }
 $row = false;
 }
 return $row;
 }
 public function query_insert_id ( 
 $query )
 {
 if ($this->debug)
 {
 echo "" . $query . "";
 }
 $result = mysqli_query($this->global_dbh,$query);
 if ($result === false)
 {
 return false;
 }
 $re_num = mysqli_affected_rows($this->global_dbh);
 if (($re_num) == 0)
 {
 return false;
 } else
 {
 return mysqli_insert_id($this->global_dbh);
 }
 }
 /**
 *This function is for data manipulation queries,or procedural queries like
 * Insert/update/delete/Lock Table/ any thing that doesnt return rows.
 *
 * @param string $query This is query you want to run
 * @param boolean $affected this is deprecated
 * @return false on fail or no affected rows, return number of affected rows otherwise
 */
 public function query ( 
 $query , 
 $affected = false )
 {
 if ($this->debug)
 {
 echo "" . $query . "";
 }
 $result = mysqli_query($this->global_dbh,$query);
 if ($result === false)
 {//echo "result erroe";
 return false;
 }
 $this->error = mysqli_error($this->global_dbh);
 $re_num = mysqli_affected_rows($this->global_dbh);
 
 if ($affected ==false&&$re_num>0)
 {//echo "mysql_affected_rows gt 0";
 return true;
 } elseif($affected ==false&&$re_num==0){
 
 }else
 
 {//echo "mysql_affected_rows eq 0";
 return $re_num;
 }
 }
 public function today(){
 return date('Y-m-d');
 }
 public function NOW ()
 {
 return date('Y-m-d H:i:s');
 }
 public function datetimeFromUnix ( 
 $unixdate )
 {
 return date('Y-m-d H:i:s', $unixdate);
 }
 public function insert ( 
 $table , 
 $data )
 {
 if (is_array(current($data)))
 {
 $vals = current($data);
 $query = "INSERT INTO `$table` (`" . implode('`,`', array_map(array(
 $this , 
 'sanatize'), array_keys($vals))) . "`) VALUES('" . implode('\',\'', array_map(array(
 $this , 
 'sanatize'), $vals)) . "')";
 while (($vals = next($data)) !== false)
 {
 $query .= ",('" . implode('\',\'', array_map(array(
 $this , 
 'sanatize'), $vals)) . "')";
 }
 return $this->query($query);
 } else
 {
 return $this->query("INSERT INTO `$table` (`" . implode('`,`', array_map(array(
 $this , 
 'sanatize'), array_keys($data))) . "`) VALUES('" . implode('\',\'', array_map(array(
 $this , 
 'sanatize'), $data)) . "')");
 }
 }
}
 
?>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2023-08-28 11:47:26
..	dir	-	0/0	0777	2025-11-19 12:10:10
config.php	text/x-php	188 B	0/0	0666	2024-10-17 01:34:05
mysql.php	text/x-php	9.75 KB	0/0	0666	2021-09-16 11:30:03

Team Anon Force

https://t.me/Professor6T9x