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");