/admin/app/controllers/sitead_controller.php

<?php

class SiteadController extends AppController

{

	var $name='Sitead';

	var $components = array('Pagination','Upload');

	var $helpers = array('Pagination', 'error');



	function index()

	{

		$this->checkSession();

		$this->layout = 'default_user_cat';

		if($_SESSION['Admin_role']==1)

		{

			$categorysql = "SELECT * from siteads";

			$categorysql_res = mysql_query($categorysql);

			$categorysql_num = mysql_num_rows($categorysql_res);

			if($categorysql_num>0)

			{

				$listarr=array();

				while($categorysql_array = mysql_fetch_array($categorysql_res))

				{

					$listarr[]=array('id'=>$categorysql_array['id'],'size'=> $categorysql_array['size'],'adtext'=> $categorysql_array['adtext']) ; 

				}

				

				$this->set('siteadarr',$listarr);

			}

			$this->set('siteadNumber',$categorysql_num);

			

		}

	}

	function addsitead()

	{

		$this->checkSession();

		$this->layout = 'default_user_cat';

	}

	function savesitead($adid=null)

	{

		//pr($_REQUEST);

		$this->checkSession();

		$this->layout = 'default_user_cat';



		if($adid)

		{

			$usqlquery = "UPDATE siteads SET size='".$this->data['sitead']['size']."' ,adtext='".$this->data['sitead']['adtext']."' where id='".$adid."' ";

		}

		else 

		{

			$usqlquery = "INSERT INTO siteads SET size='".$this->data['sitead']['size']."' ,adtext='".$this->data['sitead']['adtext']."'";

		}

		@mysql_query($usqlquery);

		$this->redirect('sitead/index');

	}

	function delsitead($adid=null)

	{

		$this->checkSession();

		$this->layout = 'default_user_cat';



		if($adid)

		{

			$usqlquery = "DELETE  FROM siteads where id='".$adid."' ";

			@mysql_query($usqlquery);

		}

		$this->redirect('sitead/index');



	}

	

	function editsitead($adid=null)

	{

		$this->checkSession();

		$this->layout = 'default_user_cat';

			$categorysql = "SELECT * from siteads where id='".$adid."'";

			$categorysql_res = mysql_query($categorysql);

			$categorysql_num = mysql_num_rows($categorysql_res);

			if($categorysql_num>0)

			{

				$listarr=array();

				$categorysql_array = mysql_fetch_array($categorysql_res);

					$listarr[]=array('id'=>$categorysql_array['id'],'size'=> $categorysql_array['size'],'adtext'=> $categorysql_array['adtext']) ; 

				

				$this->set('siteadarr',$listarr);

			}

			$this->set('siteadNumber',$categorysql_num);

			$this->set('siteadId',$adid);

	}

	function viewsitead($adid=null)

	{

		$this->checkSession();

		$this->layout = 'default_user_cat';

		$categorysql = "SELECT * from siteads where id='".$adid."'";

		$categorysql_res = mysql_query($categorysql);

			$categorysql_num = mysql_num_rows($categorysql_res);

			if($categorysql_num>0)

			{

				$listarr=array();

				$categorysql_array = mysql_fetch_array($categorysql_res);

					$listarr[]=array('id'=>$categorysql_array['id'],'size'=> $categorysql_array['size'],'adtext'=> $categorysql_array['adtext']) ; 

				

				$this->set('siteadarr',$listarr);

			}



	}

	

}

?>