// *********************************
// Francisco Javier Martínez
// francisco_javier_martinez@hotmail.com
// www.javiscript.com
// *********************************
include_once("GLOBAL_config.php");
include_once("LIB_db.php");
include_once("LIB_util.php");
/* ******************************************************************************************************************************************
CAMBIO DE BASE DE DATOS PARA TRATAMIENTO DE DATOS DEL BLOG
Cambiamos a la Base de Datos del BLOG, con el fin de tratar los datos contra su propia Base de Datos */
// LIB_db_change_db();
/* *************************************************************************************************************************************** */
include_once("LIB_fecha.php");
include_once("LIB_imagenes.php");
include_once("LIB_util.php");
$MOD_CATEGORIES_config["IMAGES_DIR"] = "images/categorias/";
$MOD_CATEGORIES_config["FILES_DIR"] = "images/categorias/files/";
$MOD_CATEGORIES_config["images"] = array();
$MOD_CATEGORIES_config["images"]["big"] = array();
$MOD_CATEGORIES_config["images"]["big"][0] = $MOD_CATEGORIES_config["images"]["big"]["MAX_WIDTH"] = 800;
$MOD_CATEGORIES_config["images"]["big"][1] = $MOD_CATEGORIES_config["images"]["big"]["MAX_HEIGHT"] = 680;
$MOD_CATEGORIES_config["images"]["big"][2] = $MOD_CATEGORIES_config["images"]["big"]["WIDTH"] = 800;
$MOD_CATEGORIES_config["images"]["big"][3] = $MOD_CATEGORIES_config["images"]["big"]["HEIGHT"] = 600;
$MOD_CATEGORIES_config["images"]["medium"] = array();
$MOD_CATEGORIES_config["images"]["medium"][0] = $MOD_CATEGORIES_config["images"]["medium"]["WIDTH"] = 745;
$MOD_CATEGORIES_config["images"]["medium"][1] = $MOD_CATEGORIES_config["images"]["medium"]["HEIGHT"] = 127;
// carga los datos
function MOD_CATEGORIES_load_categories ($id) {
global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config;
$connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"];
// cargamos los datos basicos
$datos = LIB_db_select_query("*", "t_categories", $connection, "CATEGORY_ID='".$id."' ");
// $datos = $datos[0];
$datos = MOD_CATEGORIES_get_categories_results ($datos, "load");
return $datos;
}
// realiza una busqueda
function MOD_CATEGORIES_search_categories ($index_element=0, $show_elements=10, $order_element=false, $order_order="ASC", $search_criteria=false, $destiny=false, $forceDB=false) {
global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config, $LIB_db_config;
$connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"];
$sql = "SELECT t_categories.* ".
"FROM t_categories ".
"WHERE t_categories.CATEGORY_options_erased=0 ";
if (is_array($search_criteria))
{
foreach ($search_criteria as $key=>$value)
{
if (!empty($value))
{
if (preg_match("/_ID$/", $key))
{
if (preg_match("/NOT_/", $key))
{
$key = explode("NOT_", $key);
$key = $key[0].$key[1];
$sql.= "AND ".$key." != '".addslashes($value)."' ";
}
else
{
$sql.= "AND ".$key." = '".addslashes($value)."' ";
}
}
else
{
if (preg_match("/EXACT_/", $key)) {
$key = explode("EXACT_", $key);
$key = $key[0].$key[1];
$sql.= "AND ".$key." = '".addslashes($value)."' ";
} else {
$sql.= "AND ".$key." LIKE '%".addslashes($value)."%' ";
}
}
}
}
}
$sql.= "GROUP BY t_categories.CATEGORY_ID ";
if ($order_element)
{
$sql.= "ORDER BY ".$order_element." ".$order_order." ";
} else {
$sql.= "ORDER BY t_categories.CATEGORY_name ASC ";
}
$sql.= "LIMIT ".$index_element.", ".$show_elements." ";
// echo "
".$sql."
";
$datos_results = LIB_db_generic_query($sql, $connection);
//print_r($datos_results);
// generamos los datos validos
$results = MOD_CATEGORIES_get_categories_results($datos_results, $destiny);
return $results;
}
// contabiliza el total de resultados de una busqueda
function MOD_CATEGORIES_search_total_categories ($search_criteria=false, $destiny=false, $forceDB=false) {
global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config;
$connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"];
$sql = "SELECT COUNT(DISTINCT(t_categories.CATEGORY_ID)) ".
"FROM t_categories ".
"WHERE t_categories.CATEGORY_options_erased=0 ";
if (is_array($search_criteria))
{
foreach ($search_criteria as $key=>$value)
{
if (!empty($value))
{
if (preg_match("/_ID$/", $key))
{
if (preg_match("/NOT_/", $key))
{
$key = explode("NOT_", $key);
$key = $key[0].$key[1];
$sql.= "AND ".$key." != '".addslashes($value)."' ";
}
else
{
$sql.= "AND ".$key." = '".addslashes($value)."' ";
}
}
else
{
if (preg_match("/EXACT_/", $key)) {
$key = explode("EXACT_", $key);
$key = $key[0].$key[1];
$sql.= "AND ".$key." = '".addslashes($value)."' ";
} else {
$sql.= "AND ".$key." LIKE '%".addslashes($value)."%' ";
}
}
}
}
}
// echo $sql;
$datos_results = LIB_db_generic_query($sql, $connection);
return $datos_results[0][0];
}
// muestrea los resultados de una busqueda
function MOD_CATEGORIES_get_categories_results ($complete_results, $destino='') {
global $GLOBAL_config, $MOD_CATEGORIES_config, $search_criteria;
if (is_array($complete_results))
{
foreach($complete_results as $key=>$result)
{
switch ($destino)
{
case "load":
default:
$final_results[$key]["CATEGORY_ID"] = $result["CATEGORY_ID"];
$final_results[$key]["CATEGORY_name"] = htmlentities($result["CATEGORY_name"]);
$final_results[$key]["CATEGORY_tag_search"] = htmlentities($result["CATEGORY_tag_search"]);
break;
}
}
}
else
{
$final_results[0]["CATEGORY_ID"] = "";
$final_results[0]["CATEGORY_name"] = "";
$final_results[$key]["CATEGORY_tag_search"] = "";
}
return $final_results;
}
// Función para generar un SELECT con las categorieas
function MOD_CATEGORIES_generate_categories_select ($selected=false, $selected_action="add_selecteds")
{
global $GLOBAL_config, $MOD_CATEGORIES_config, $LIB_db_config;
$connection = $LIB_db_config["VINTAGEWATCHPARTS_connection"];
$elements = LIB_db_select_query("CATEGORY_ID, CATEGORY_name", "t_categories", $connection, "CATEGORY_options_erased=0 ORDER BY CATEGORY_name ");
$html = "";
if (!is_array($selected))
{
$selected = explode(";", $selected);
}
if (is_array($elements))
{
foreach ($elements as $value)
{
// Si ESTE elemento NO ESTÁ en los elementos pasados como parámetro, lo incluimos en el listado
switch ($selected_action)
{
case "add_selecteds":
$html.= "";
break;
case "delete_selecteds":
if (!in_array($value[0], $selected))
{
$html.= "";
}
break;
case "only_selecteds":
if (in_array($value[0], $selected))
{
$html.= "";
}
break;
}
}
} else {
$html.= "";
}
return $html;
}
?>
Fatal error: Call to undefined function MOD_CATEGORIES_search_total_categories() in /var/www/vhosts/vintagewatchparts.com/httpdocs/index.php on line 11