<?php

	class revo {
		
		
		var $table;
		var $id;
		var $title;
		var $imggroup;
		var $text;
		var $dDate;
		
		function revo(){
		}
		
		function setData($tName,$tiName,$iGroup,$txtName,$ivalue="", $dDate = ""){
			$this->table = $tName;
			$this->title = $tiName;
			$this->imggroup = $iGroup;
			$this->text = $txtName;
			
			if($ivalue != ""){
				$this->id = $ivalue;
			}
			
			if($dDate != ""){
				$this->dDate = $dDate;
			}
		}
		
		function insertData($title, $imggroup, $text, $date=""){
		include 'config.php';
			$stat = "";
			$dbcon = db_con();
			$sql = "INSERT INTO " . $dbname . "." . $this->table . " SET " . $this->title . "=\"" . $title . "\", " . $this->imggroup . "=\"" . $imggroup . "\", " . $this->text . "=\"" . $text . "\"" ;
					if($this->dDate !=""){
						if($date !=""){
							$sql = $sql . ", " . $this->dDate . "=\"" . $date . "\"";
						}
					}
			$dbact = mysql_query($sql);
				if(!$dbact){
					$stat = "Error with Revo() class inserData <br> Error: " . mysql_error() ;
					mysql_close($dbcon);
					return $stat;
				} else {
					$stat = "Inserted data into " . $this-table . " successfully!";
					mysql_close($dbcon);
					return $stat;
				}

		}
		
		function pullData($id="", $field="", $fSort="", $sBy="", $limit=""){
		include 'config.php';
			$all = false;
			
			if($id == "" && $field == "" && $fSort == "" && $sBy == "" && $limit ==""){
					$sql = "SELECT * FROM " . $dbname . "." . $this->table  . " ORDER BY " . $this->id . " DESC "; 
					$all = true; 
			}
				
			if($field == "" && $id == "" && $all == false){
				$sql = "SELECT * FROM " . $dbname . "." . $this->table . " " ;
						if($fSort != ""){
								$sql = $sql . " ORDER BY " . $fSort . " ";
						}
						if($sBy != ""){
								$sql = $sql . $sBy;
						}
						if($limit != ""){
							$sql  = $sql . " LIMIT " . $limit;
						}
			}
			
			if($id != "" && $all == false ){
			
				if($field != ""){
					$sel = $field;
				}else{
					$sel = "*";
				}
					$sql = "SELECT " . $sel . " FROM " . $dbname . "." . $this->table . " WHERE " . $this->id . " = " . $id;
			}
			
			if($field != "" && $id =="" && $all == false ){
			
				$sql = "SELECT " . $field . " FROM " . $dbname . "." . $this->table . " " ;
				
						if($fSort != ""){
							$sql = $sql . "ORDER BY " . $fSort . " ";
						}else{
							$sql = $sql . "ORDER BY " . $this->id . " ";
						}
						if($sBy != ""){
							$sql = $sql . $sBy . " ";
						}
						if($limit != ""){
							$sql = $sql . "LIMIT " . $limit;
						}
			
			}
			
			if($limit != "" && $fSort == "" && $field == "" && $all == false   ){
			
				if($sBy == ""){
					$acdc = "DESC";
				}else{
					$acdc = $sBy;
				}
				
				$sql = "SELECT * FROM " . $dbname . "." . $this->table . " ORDER BY " . $this->id . " " . $acdc . " LIMIT " . $limit ;
			}
			
			$dbData = array();
			$dbcon = db_con();
			//echo($sql);
			$dbq = mysql_query($sql);
				if(!$dbq){
					echo("Error With SQL Query <br> " . mysql_error());
					return "error";
				}else{
					while($row = mysql_fetch_assoc($dbq)){
						$dbData[] = $row;
					}
					mysql_close($dbcon);
					return $dbData;
				}
	
		}
		
		function delData($id){
			include 'config.php';
			
			//$dbcon = db_con();
			
			$sql = "DELETE * FROM " . $dbname . "." .  $this->table . " WHERE " . $this->id . " = " . $id;
			
			echo($sql);
		
		
		}
		
	
	
	}




?>