return $theValue;
}
}
mysql_select_db($database_ha, $ha);
$query_cat = "SELECT * FROM categorias ORDER BY categoria ASC";
$cat = mysql_query($query_cat, $ha) or die(mysql_error());
$row_cat = mysql_fetch_assoc($cat);
$totalRows_cat = mysql_num_rows($cat);
mysql_select_db($database_ha, $ha);
$query_subcat = "SELECT * FROM subcategorias ORDER BY subcat ASC";
$subcat = mysql_query($query_subcat, $ha) or die(mysql_error());
$row_subcat = mysql_fetch_assoc($subcat);
$totalRows_subcat = mysql_num_rows($subcat);
// Make an insert transaction instance
$ins_paginas = new tNG_multipleInsert($conn_ha);
$tNGs->addTransaction($ins_paginas);
// Register triggers
$ins_paginas->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_paginas->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_paginas->registerTrigger("END", "Trigger_Default_Redirect", 99, "../includes/nxt/back.php");
// Add columns
$ins_paginas->setTable("paginas");
$ins_paginas->addColumn("id_cat", "NUMERIC_TYPE", "POST", "id_cat");
$ins_paginas->addColumn("id_subcat", "NUMERIC_TYPE", "POST", "id_subcat");
$ins_paginas->addColumn("pag", "STRING_TYPE", "POST", "pag");
$ins_paginas->addColumn("contenido", "STRING_TYPE", "POST", "contenido");
$ins_paginas->setPrimaryKey("id_pag", "NUMERIC_TYPE");
// Make an update transaction instance
$upd_paginas = new tNG_multipleUpdate($conn_ha);
$tNGs->addTransaction($upd_paginas);
// Register triggers
require_once 'userviews_class.php';
$userview = new userviews();
$user_id = $_SESSION['USER']->id;
mysql_select_db($CFG->dbname, $smart);
// Check whether this rating already exists
// INNER JOIN share_cohort_members ON {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_member = {$_SESSION['RealS_prefix']}webcells.webcell_member
// AND {$_SESSION['RealS_prefix']}share_cohort_members.s_c_m_share = 6107
$query_rs_evidence = sprintf("SELECT {$_SESSION['RealS_prefix']}items.item_id,\r\n\t\t \t{$_SESSION['RealS_prefix']}items.*,\r\n\t\t \t{$_SESSION['RealS_prefix']}webcells.*,\r\n\t\t \t{$_SESSION['RealS_prefix']}rafl_res.*\r\n\t FROM {$_SESSION['RealS_prefix']}items\r\n\t \tINNER JOIN {$_SESSION['RealS_prefix']}webcells ON {$_SESSION['RealS_prefix']}items.item_webcell = {$_SESSION['RealS_prefix']}webcells.webcell_id\r\n\t \tINNER JOIN {$_SESSION['RealS_prefix']}rafl_res ON {$_SESSION['RealS_prefix']}items.item_id = {$_SESSION['RealS_prefix']}rafl_res.rafl_res_item\r\n\t WHERE {$_SESSION['RealS_prefix']}items.item_parent_item = %s\r\n\t \tAND {$_SESSION['RealS_prefix']}items.item_default_type = 6\r\n\t \tAND rafl_res_share = " . GetSQLValueString($_GET['share_id'], "int") . "\r\n\t \tAND {$_SESSION['RealS_prefix']}webcells.webcell_member = %s", GetSQLValueString($colname_rs_evidence, "int"), GetSQLValueString($user_id, "int"));
$rs_evidence = mysql_query($query_rs_evidence, $smart) or die(mysql_error());
$row_rs_evidence = mysql_fetch_assoc($rs_evidence);
$totalRows_rs_evidence = mysql_num_rows($rs_evidence);
if ($totalRows_rs_evidence == 0) {
//insert New Evidence-----------------------------------
// Make an insert transaction instance
$ins_webcells = new tNG_insert($conn_smart);
$tNGs->addTransaction($ins_webcells);
// Register triggers
$ins_webcells->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "GET", "parent_id");
$ins_webcells->registerTrigger("AFTER", "Trigger_LinkTransactions", 98);
$ins_webcells->registerTrigger("ERROR", "Trigger_LinkTransactions", 98);
// Add columns
$ins_webcells->setTable("{$_SESSION['RealS_prefix']}webcells");
$ins_webcells->addColumn("webcell_title", "STRING_TYPE", "VALUE", "Evidence");
$ins_webcells->addColumn("webcell_text", "STRING_TYPE", "VALUE", "");
$ins_webcells->addColumn("webcell_member", "NUMERIC_TYPE", "VALUE", $user_id);
$ins_webcells->addColumn("webcell_school", "NUMERIC_TYPE", "SESSION", "RealS_schoolid");
$ins_webcells->setPrimaryKey("webcell_id", "NUMERIC_TYPE");
// Make an insert transaction instance
$ins_items = new tNG_insert($conn_smart);
$tNGs->addTransaction($ins_items);
// Register triggers
// Load the common classes
require_once '../includes/common/KT_common.php';
// Load the tNG classes
require_once '../includes/tng/tNG.inc.php';
// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("../");
// Make unified connection variable
$conn_ha = new KT_connection($ha, $database_ha);
//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_ha, "../");
//Grand Levels: Any
$restrict->Execute();
//End Restrict Access To Page
// Make a logout transaction instance
$logoutTransaction = new tNG_logoutTransaction($conn_ha);
$tNGs->addTransaction($logoutTransaction);
// Register triggers
$logoutTransaction->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "VALUE", "true");
$logoutTransaction->registerTrigger("END", "Trigger_Default_Redirect", 99, "../login.php");
// Add columns
// End of logout transaction instance
// Execute all the registered transactions
$tNGs->executeTransactions();
// Get the transaction recordset
$rscustom = $tNGs->getRecordset("custom");
$row_rscustom = mysql_fetch_assoc($rscustom);
$totalRows_rscustom = mysql_num_rows($rscustom);
?>
<!DOCTYPE HTML>
<html>
<head>
$formValidation->addField("apellidos", true, "text", "", "", "", "");
$formValidation->addField("email", true, "text", "email", "", "", "");
$formValidation->addField("usuario", true, "text", "", "", "", "");
$formValidation->addField("contrasena", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger
//start Trigger_CheckOldPassword trigger
//remove this line if you want to edit the code by hand
function Trigger_CheckOldPassword(&$tNG)
{
return Trigger_UpdatePassword_CheckOldPassword($tNG);
}
//end Trigger_CheckOldPassword trigger
// Make an insert transaction instance
$ins_usuarios = new tNG_multipleInsert($conn_ha);
$tNGs->addTransaction($ins_usuarios);
// Register triggers
$ins_usuarios->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_usuarios->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_usuarios->registerTrigger("END", "Trigger_Default_Redirect", 99, "../includes/nxt/back.php");
$ins_usuarios->registerConditionalTrigger("{POST.contrasena} != {POST.re_contrasena}", "BEFORE", "Trigger_CheckPasswords", 50);
// Add columns
$ins_usuarios->setTable("usuarios");
$ins_usuarios->addColumn("nombre", "STRING_TYPE", "POST", "nombre");
$ins_usuarios->addColumn("apellidos", "STRING_TYPE", "POST", "apellidos");
$ins_usuarios->addColumn("email", "STRING_TYPE", "POST", "email");
$ins_usuarios->addColumn("usuario", "STRING_TYPE", "POST", "usuario");
$ins_usuarios->addColumn("contrasena", "STRING_TYPE", "POST", "contrasena");
$ins_usuarios->setPrimaryKey("id_usuario", "NUMERIC_TYPE");
// Make an update transaction instance
$upd_usuarios = new tNG_multipleUpdate($conn_ha);
require_once 'includes/common/KT_common.php';
// Load the tNG classes
require_once 'includes/tng/tNG.inc.php';
// Make a transaction dispatcher instance
$tNGs = new tNG_dispatcher("");
// Make unified connection variable
$conn_ha = new KT_connection($ha, $database_ha);
// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("kt_login_user", true, "text", "", "", "", "");
$formValidation->addField("kt_login_password", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger
// Make a login transaction instance
$loginTransaction = new tNG_login($conn_ha);
$tNGs->addTransaction($loginTransaction);
// Register triggers
$loginTransaction->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "kt_login1");
$loginTransaction->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$loginTransaction->registerTrigger("END", "Trigger_Default_Redirect", 99, "{kt_login_redirect}");
// Add columns
$loginTransaction->addColumn("kt_login_user", "STRING_TYPE", "POST", "kt_login_user");
$loginTransaction->addColumn("kt_login_password", "STRING_TYPE", "POST", "kt_login_password");
// End of login transaction instance
// Execute all the registered transactions
$tNGs->executeTransactions();
// Get the transaction recordset
$rscustom = $tNGs->getRecordset("custom");
$row_rscustom = mysql_fetch_assoc($rscustom);
$totalRows_rscustom = mysql_num_rows($rscustom);
?>
//remove this line if you want to edit the code by hand
function Trigger_ImageUpload(&$tNG)
{
$uploadObj = new tNG_ImageUpload($tNG);
$uploadObj->setFormFieldName("imagen");
$uploadObj->setDbFieldName("imagen");
$uploadObj->setFolder("../imgs/");
$uploadObj->setMaxSize(1500);
$uploadObj->setAllowedExtensions("gif, jpg, jpe, jpeg, png");
$uploadObj->setRename("auto");
return $uploadObj->Execute();
}
//end Trigger_ImageUpload trigger
// Make an insert transaction instance
$ins_servicios = new tNG_multipleInsert($conn_ha);
$tNGs->addTransaction($ins_servicios);
// Register triggers
$ins_servicios->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_servicios->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_servicios->registerTrigger("END", "Trigger_Default_Redirect", 99, "../includes/nxt/back.php");
$ins_servicios->registerTrigger("AFTER", "Trigger_ImageUpload", 97);
// Add columns
$ins_servicios->setTable("servicios");
$ins_servicios->addColumn("servicio", "STRING_TYPE", "POST", "servicio");
$ins_servicios->addColumn("desc_serv", "STRING_TYPE", "POST", "desc_serv");
$ins_servicios->addColumn("imagen", "FILE_TYPE", "FILES", "imagen");
$ins_servicios->addColumn("pag_serv", "STRING_TYPE", "POST", "pag_serv");
$ins_servicios->setPrimaryKey("id_servicio", "NUMERIC_TYPE");
// Make an update transaction instance
$upd_servicios = new tNG_multipleUpdate($conn_ha);
$tNGs->addTransaction($upd_servicios);
//remove this line if you want to edit the code by hand
function Trigger_ImageUpload(&$tNG)
{
$uploadObj = new tNG_ImageUpload($tNG);
$uploadObj->setFormFieldName("banner");
$uploadObj->setDbFieldName("banner");
$uploadObj->setFolder("../imgs/");
$uploadObj->setMaxSize(1500);
$uploadObj->setAllowedExtensions("gif, jpg, jpe, jpeg, png");
$uploadObj->setRename("auto");
return $uploadObj->Execute();
}
//end Trigger_ImageUpload trigger
// Make an insert transaction instance
$ins_banner = new tNG_multipleInsert($conn_ha);
$tNGs->addTransaction($ins_banner);
// Register triggers
$ins_banner->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_banner->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_banner->registerTrigger("END", "Trigger_Default_Redirect", 99, "../includes/nxt/back.php");
$ins_banner->registerTrigger("AFTER", "Trigger_ImageUpload", 97);
// Add columns
$ins_banner->setTable("banner");
$ins_banner->addColumn("banner", "FILE_TYPE", "FILES", "banner");
$ins_banner->setPrimaryKey("id_banner", "NUMERIC_TYPE");
// Make an update transaction instance
$upd_banner = new tNG_multipleUpdate($conn_ha);
$tNGs->addTransaction($upd_banner);
// Register triggers
$upd_banner->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Update1");
$upd_banner->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$tNGs = new tNG_dispatcher("../");
// Make unified connection variable
$conn_ha = new KT_connection($ha, $database_ha);
//Start Restrict Access To Page
$restrict = new tNG_RestrictAccess($conn_ha, "../");
//Grand Levels: Any
$restrict->Execute();
//End Restrict Access To Page
// Start trigger
$formValidation = new tNG_FormValidation();
$formValidation->addField("categoria", true, "text", "", "", "", "");
$tNGs->prepareValidation($formValidation);
// End trigger
// Make an insert transaction instance
$ins_categorias = new tNG_multipleInsert($conn_ha);
$tNGs->addTransaction($ins_categorias);
// Register triggers
$ins_categorias->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_categorias->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_categorias->registerTrigger("END", "Trigger_Default_Redirect", 99, "../includes/nxt/back.php");
// Add columns
$ins_categorias->setTable("categorias");
$ins_categorias->addColumn("categoria", "STRING_TYPE", "POST", "categoria");
$ins_categorias->addColumn("liga_cat", "STRING_TYPE", "POST", "liga_cat");
$ins_categorias->setPrimaryKey("id_cat", "NUMERIC_TYPE");
// Make an update transaction instance
$upd_categorias = new tNG_multipleUpdate($conn_ha);
$tNGs->addTransaction($upd_categorias);
// Register triggers
$upd_categorias->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Update1");
$upd_categorias->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$rs_theloai = mysql_query($query_rs_theloai, $conn_cms) or die(mysql_error());
$row_rs_theloai = mysql_fetch_assoc($rs_theloai);
$totalRows_rs_theloai = mysql_num_rows($rs_theloai);
mysql_select_db($database_conn_cms, $conn_cms);
$query_rs_theloaitin = "SELECT ID_theloaitin, tentheloaitin FROM theloaitin ORDER BY tentheloaitin ASC";
$rs_theloaitin = mysql_query($query_rs_theloaitin, $conn_cms) or die(mysql_error());
$row_rs_theloaitin = mysql_fetch_assoc($rs_theloaitin);
$totalRows_rs_theloaitin = mysql_num_rows($rs_theloaitin);
mysql_select_db($database_conn_cms, $conn_cms);
$query_rs_phanloaitin = "SELECT ID_phanloaitin, tenphanloai FROM phanloaitin ORDER BY tenphanloai ASC";
$rs_phanloaitin = mysql_query($query_rs_phanloaitin, $conn_cms) or die(mysql_error());
$row_rs_phanloaitin = mysql_fetch_assoc($rs_phanloaitin);
$totalRows_rs_phanloaitin = mysql_num_rows($rs_phanloaitin);
// Make an insert transaction instance
$ins_tintuc = new tNG_multipleInsert($conn_conn_cms);
$tNGs->addTransaction($ins_tintuc);
// Register triggers
$ins_tintuc->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
$ins_tintuc->registerTrigger("BEFORE", "Trigger_Default_FormValidation", 10, $formValidation);
$ins_tintuc->registerTrigger("END", "Trigger_Default_Redirect", 99, "list_tintuc.php");
$ins_tintuc->registerTrigger("BEFORE", "Trigger_CheckUnique", 30);
$ins_tintuc->registerTrigger("AFTER", "Trigger_ImageUpload", 97);
// Add columns
$ins_tintuc->setTable("tintuc");
$ins_tintuc->addColumn("tieudetin", "STRING_TYPE", "POST", "tieudetin");
$ins_tintuc->addColumn("hinhtrichdan", "FILE_TYPE", "FILES", "hinhtrichdan");
$ins_tintuc->addColumn("trichdantin", "STRING_TYPE", "POST", "trichdantin");
$ins_tintuc->addColumn("noidungtin", "STRING_TYPE", "POST", "noidungtin");
$ins_tintuc->addColumn("ID_theloai", "NUMERIC_TYPE", "POST", "ID_theloai");
$ins_tintuc->addColumn("ID_theloaitin", "NUMERIC_TYPE", "POST", "ID_theloaitin");
$ins_tintuc->addColumn("ID_phanloaitin", "NUMERIC_TYPE", "POST", "ID_phanloaitin");
