$hostname = "mysql1.cyberfuel.com"; // Your MySQL-Host
$username = "usr_realestate"; // Your MySQL-Username
$password = "usr1realestate"; // Your MySQL-Password
$dbName = "newrealestate"; // Name of DataBase.
$CONECTION_DATABASE = MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db("$dbName") or die( "Unable to select database");
/*include("../configuration/config.php");
$hostname = trim($parametros['dbhost']);
$username = trim($parametros['dbuser']);
$password = trim($parametros['dbpass']);
$dbName = $parametros['dbname'];
$CONECTION_DATABASE = MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
mysql_select_db("$dbName") or die( "Unable to select database");*/
?>
function IncludesFiles($path){
// Example: $opendir = "/home/httpd/vhosts/cyberfuel.com/subdomains/desarrollos/httpdocs/selcyber/";
$opendir = $path;
if ($dir = opendir($opendir)) { // Abre el directorio.
$i = 0; // Inicializo i.
while (($file = readdir($dir)) !== false) { // Leo cada Directorio, dentro del Directorio Colones.
if (($file <> ".") && ($file <> "..")) {
include($path ."/". $file);
}
}// while (($file = readdir($dir)) !== false).
closedir($dir);// cierro directorio de Grafica de Colones.
}else{
echo "Path no found...";
}
}
/* Funcion que Trunca una Cadena */
function truncar($cadena,$size){
$tamanno = strlen($cadena);
if ($tamanno > $size){$cadena_nueva = substr($cadena,0,$size);$cadena_nueva = $cadena_nueva . "...";return $cadena_nueva;
}else{return $cadena;}
}
/* Funcion que Trunca una Cadena */
function truncartoSQL($cadena,$size){
$tamanno = strlen($cadena);
if ($tamanno > $size){
$cadena_nueva = substr($cadena,0,$size);
$cadena_nueva = $cadena_nueva;
return $cadena_nueva;
}else{return $cadena;}
}
function _pone_ext($var){
$pos = strpos($var, ".");
$len = strlen($var);
$tip = substr($var,$pos+1,$len);
//$tip = ($tip == "jpg") ? "jpe" : $tip;
return $tip;
}//end function
function pag($number,$totalnumbers,$brec,$erec,$DATOSXPAGINA,$PHP_SELF,$argv){
//if (strstr($_SERVER["QUERY_STRING"], "brec=")){
$strURL = $PHP_SELF."?SID=".$_GET["SID"]."&proc=".$_GET["proc"]."&idc=".$_GET["idc"]."&idItm=".$_GET["idItm"]."&flt=" . $_GET["flt"]. "&";
//}else{
// $strURL = $PHP_SELF."?";
//}//end if
$brecl = $brec - $DATOSXPAGINA;
$brecn = $brec + $DATOSXPAGINA;
$erecl = $DATOSXPAGINA;
$erecn = $DATOSXPAGINA;
$lastnumber = $number + $brec;
$brec = $brec + 1;
if ($number > 0){
if ($totalnumbers <= $DATOSXPAGINA){
$TABLEPAG = "($brec - $number) ".LAN_SYS_036." $totalnumbers";
}elseif ($totalnumbers < ($brec + $number)){
$TABLEPAG = "
".ucwords(LAN_SYS_099)." ($brec - $lastnumber ".LAN_SYS_036." $totalnumbers)";
}elseif (($brec - 1) < $DATOSXPAGINA) {
$TABLEPAG = "($brec - $number ".LAN_SYS_036." $totalnumbers) ".ucwords(LAN_SYS_005)."
";
}else{
$TABLEPAG = "
".ucwords(LAN_SYS_099)." ($brec - $lastnumber ".LAN_SYS_036." $totalnumbers) ".ucwords(LAN_SYS_005)."
";
}
return $TABLEPAG;
}
}//fun function
function CopyFileToServer($VAR_HTTP_POST_FILES,$PATH_TARGET_DIR,$NewNameFile){
echo $VAR_HTTP_POST_FILES[name];
echo $VAR_HTTP_POST_FILES[tmp_name];
echo $VAR_HTTP_POST_FILES[error];
echo $VAR_HTTP_POST_FILES[size];
if ($VAR_HTTP_POST_FILES[tmp_name] != ""){
if ($VAR_HTTP_POST_FILES[tmp_name]){ // Verifica si ingreso una foto
move_uploaded_file($VAR_HTTP_POST_FILES[name], $PATH_TARGET_DIR);
$exten = _pone_ext($VAR_HTTP_POST_FILES[name]);
$new_val = $NewNameFile . ".$exten";
if (copy($VAR_HTTP_POST_FILES[tmp_name],$PATH_TARGET_DIR.$new_val)){
echo "yes";
return $new_val;
}
}
}//fin if
}//function CopyFileToServer($FIELDNAME,$PATH_TARGET_DIR,$NewNameFile){
// Me Retorna el archivo unbicado en una Carpeta especifica.
//
function NameFileImagesInDir($path){
// Example: $opendir = "/home/httpd/vhosts/cyberfuel.com/subdomains/desarrollos/httpdocs/selcyber/";
$opendir = $path;
if ($dir = opendir($opendir)) { // Abre el directorio.
$i = 0; // Inicializo i.
while (($file = readdir($dir)) !== false) { // Leo cada Directorio, dentro del Directorio Colones.
if (($file <> ".") && ($file <> "..")) {
return $file;
}
}// while (($file = readdir($dir)) !== false).
closedir($dir);//
}else{
echo "images/noavailable.jpg";
}
}
//presenta las imagenes que se encuentran en la ruta especificada
function DisplayImages($path){
// Example: $opendir = "/home/httpd/vhosts/cyberfuel.com/subdomains/desarrollos/httpdocs/selcyber/";
$opendir = $path;
if ($dir = opendir($opendir)) { // Abre el directorio.
$i = 0; // Inicializo i.
while (($file = readdir($dir)) !== false) { // Leo cada Directorio, dentro del Directorio Colones.
if (($file <> ".") && ($file <> "..")) {
?>
}
}// while (($file = readdir($dir)) !== false).
closedir($dir);// cierro directorio de Grafica de Colones.
}else{
echo "No files found...";
}//fin else
}//fin function
function DisplayDir($path){
$opendir = $path;
if ($dir = opendir($opendir)) { // Abre el directorio.
$i = 0; // Inicializo i.
while (($file = readdir($dir)) !== false) { // Leo cada Directorio, dentro del Directorio Colones.
if (($file <> ".") && ($file <> "..")) {
?>
}
}// while (($file = readdir($dir)) !== false).
closedir($dir);// cierro directorio de Grafica de Colones.
}else{
echo "No files found...";
}//fin else
}//fin function
//LPM.
//Borra un directorio y todo su contenido
function rmdirr($dir) {
if($objs = glob($dir."/*")){
foreach($objs as $obj) {
is_dir($obj)? rmdirr($obj) : unlink($obj);
}//fin foreach
}//fin if
rmdir($dir);
}//fin delete
//LPM.
//pagina los datos en la parte publica.
function pagPublic($number,$totalnumbers,$brec,$erec,$DATOSXPAGINA,$PHP_SELF,$argv,$idCat){
$strURL = $PHP_SELF."?SID=".$_GET["SID"]."&proc=".$_GET["proc"]."&idc=".$_GET["idc"]."&idItm=".$_GET["idItm"]."&flt=" . $_GET["flt"]. "&";
$brecl = $brec - $DATOSXPAGINA;
$brecn = $brec + $DATOSXPAGINA;
$erecl = $DATOSXPAGINA;
$erecn = $DATOSXPAGINA;
$lastnumber = $number + $brec;
$brec = $brec + 1;
if ($number > 0){
if ($totalnumbers <= $DATOSXPAGINA){
$TABLEPAG = "($brec - $number) ".de." $totalnumbers";
}elseif ($totalnumbers < ($brec + $number)){
$TABLEPAG = "
($brec - $lastnumber ".de." $totalnumbers)";
}elseif (($brec - 1) < $DATOSXPAGINA) {
$TABLEPAG = "($brec - $number ".de." $totalnumbers)
";
}else{
$TABLEPAG = "
($brec - $lastnumber ".de." $totalnumbers)
";
}
return $TABLEPAG;
}
}//fin function
?>