<?




// Editar el banner seleccionado
/////////////////////////////////////////////////
function editar_banner($texto, $url, $File_Name, $id){

	$conn=db_connect();
	$query=	" UPDATE home_banners set texto='$texto', url='$url'  WHERE id='$id' ";
	$result = mysql_query($query);
	if($File_Name)
	agregar_imagen($id, 'home_banners', 'imagen', $File_Name );
	return true;
}


// obtener el valor del texto del banner
/////////////////////////////////////////////////
function editar_banner_return_text($id){

	$conn=db_connect();
	$query=	"SELECT * from home_banners WHERE id='$id' ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	foreach ($result as $row)
	{
		return $row['texto'];
	}
}


// Obtener el valor de la URL del banner
/////////////////////////////////////////////////
function editar_banner_return_url($id){

	$conn=db_connect();
	$query=	"SELECT * from home_banners WHERE id='$id' ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	foreach ($result as $row)
	{
		return $row['url'];
	}
}



// Obtener imagen del banner / web
/////////////////////////////////////////////////
function editar_banner_g_i($id){

	$conn=db_connect();
	$query=	"SELECT * from home_banners WHERE id='$id' ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	foreach ($result as $row)
	{
		return $row['imagen'];
	}
}


// Obtener texto del banner // web
/////////////////////////////////////////////////
function editar_banner_g_t($id){

	$conn=db_connect();
	$query=	"SELECT * from home_banners WHERE id='$id' ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	foreach ($result as $row)
	{
		return $row['texto'];
	}
}



///////////
///////////








// Editar el banner seleccionado
/////////////////////////////////////////////////
function agregar_banner_home($link, $File_Name){
	$conn=db_connect();
	$query=	" insert into home_banner_prin (link) values ('$link') ";
	$idd=id_next('home_banner_prin');
	$result = mysql_query($query);
	
	if($File_Name)
	agregar_imagen($idd, 'home_banner_prin', 'imagen', $File_Name );
	return true;
}


// 
/////////////////////////////////////////////////
function get_admin__banner_home(){

	$conn=db_connect();
	$query=	"SELECT * from home_banner_prin ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	foreach ($result as $row)
	{
?>
<li>
<a href="<?=$row['link']?>"><img src="<?=$row['imagen']?>" border="0" width="850" height="424" /></a>
<span><form action="edit-home-banners.php" method="post" enctype="multipart/form-data">
<a href="edit-home-banners.php?delbanner=<?=$row['id']?>">BORRAR</a>&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" id="AdminHome_banner_princ_input" name="new_link" value="<?=$row['link']?>" />
<input type="hidden" name="id" value="<?=$row['id']?>" />
<input type="submit" id="AdminHome_banner_princ_btn" value="ACTUALIZAR URL" />
</form></span>
</li>
<?

	}
}


// 
/////////////////////////////////////////////////
function delete_banner_home($id){

	$conn=db_connect();
	$query=	"DELETE from home_banner_prin WHERE id='$id' ";
	$result = mysql_query($query);
	return true;
}


// 
/////////////////////////////////////////////////
function update_banner_home($link, $id){

	$conn=db_connect();
	$query=	" UPDATE home_banner_prin set link='$link' WHERE id='$id' ";
	$result = mysql_query($query);
	return true;
}


// Obtener banner en la web
/////////////////////////////////////////////////
function get_web__banner_home(){

	$conn=db_connect();
	$query=	"SELECT * from home_banner_prin ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	$a=1;
	foreach ($result as $row)
	{
	if($a==1){?>
    
    <a href="<?=$row['link']?>" class="active" title="Ver detalles">
    <img src="newcolor/<?=$row['imagen']?>" border="0" width="850" height="424" alt="newcolor-banner" />
    </a>
    
	<? } else{?>
    
    <a href="<?=$row['link']?>" title="Ver detalles">
    <img src="newcolor/<?=$row['imagen']?>" border="0" width="850" height="424" alt="newcolor-banner" />
    </a>
    
    <? }
	$a++;
	}
}


// 
/////////////////////////////////////////////////
function get_admin_slide_banner_home(){

	$conn=db_connect();
	$query=	"SELECT * from home_banner_prin ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	$a=1;
	foreach ($result as $row)
	{
	if($a==1){?><img src="<?=$row['imagen']?>" width="850" height="424"   class="active" /><?	}
	else{?><img src="<?=$row['imagen']?>" width="850" height="424"  /> <? }
	$a++;
	}
}



























// 
/////////////////////////////////////////////////
function get_index_destacado(){

	$conn=db_connect();
	$query=	"SELECT * from catalogo_productos where destaque='si' ";
	$result = mysql_query($query);
	$result = db_result_to_array($result);
	$a=1;
	foreach ($result as $row)
	{
	
	?>
	
     <li><a href="producto.php?prod=<?=$row['id']?>" title="<?=$row['nombre']?>">
     <img src="cms/timthumb.php?src=<?=$row['thumb']?>&amp;h=150&amp;w=150&amp;zc=1" alt="<?=$row['nombre']?>" />
     </a></li>
    
	<?
	}
}













?>