<?php
	Class MySQL
	{
		private $sqlhost="localhost";
		private $sqluser="chaosscr";
		private $sqlpass="a1293";
		public $sqldb="pastebin";
		protected $mysql;
		function __construct()
		{
			$this->mysql=mysql_connect($this->sqlhost,$this->sqluser,$this->sqlpass) or $this->error();
			if($this->sqldb)
				mysql_select_db($this->sqldb,$this->mysql) or $this->error();
		}
		public function close()
		{
			if(!mysql_close($this->mysql))
				$this->error();
			else
				return 1;
		}
		protected function error()
		{
			die(printf("<br /><b>MySQL ERROR</b>: %s (%d)",mysql_error(),mysql_errno()));
		}
		public function is_db_empty($db="")
		{
			if($db=="")
				$db=$this->sqldb;
			$tables=mysql_query("show tables from `$db`",$this->mysql);
			$intable="Tables_in_$db";
			while($table=@mysql_fetch_array($tables))
				$tablelist[]=$table[$intable];
			if(!isset($tablelist[0]))
				return 1;
			else
				return 0;
		}
		public function list_all()
		{
			$dbs=$this->list_dbs();
			for($a=0;$dbs[$a];$a++)
			{
				if($this->is_db_empty($dbs[$a]))
					$dbs[$dbs[$a]]=$dbs[$a];
				else
					$dbs[$dbs[$a]]=$this->list_tables($dbs[$a]);
				unset($dbs[$a]);
			}
			return $dbs;
		}
		public function list_dbs()
		{
			$dbs=mysql_query("show databases",$this->mysql) or $this->error();
			while($db=mysql_fetch_array($dbs))
				$dblist[]=$db['Database'];
			return $dblist;
		}
		public function list_tables($db="")
		{
			if($db=="")
				$db=$this->sqldb;
			$tables=mysql_query("show tables from `$db`",$this->mysql) or $this->error();
			$intable="Tables_in_$db";
			while($table=mysql_fetch_array($tables))
				$tablelist[]=$table[$intable];
			return $tablelist;
		}
		public function query($query)
		{
			return mysql_query($query,$this->mysql);
		}
		public function sdb($newdb)
		{
			mysql_select_db($newdb,$this->mysql) or $this->error();
			$this->sqldb=$newdb;
		}
		public function select($query)
		{
			$query=mysql_query($query,$this->mysql) or $this->error();
			while($row=mysql_fetch_array($query))
				for($a=0;$row[$a];$cont[]=$row[$a],$a++);
			return $cont;
		}
	}
?>