public function registrar() { $proteccion = new Proteccion(); $nombre = $proteccion->html($_POST['nombre']); $apellido = $proteccion->html($_POST['apellido']); $sexo = $proteccion->html($_POST['sexo']); $fecha_nacimiento = $proteccion->html($_POST['fecha_nacimiento']); $direccion = $proteccion->html($_POST['direccion']); $email = $proteccion->html($_POST['email']); $dni = $proteccion->html($_POST['dni']); $pass = $proteccion->html($_POST['password']); $persona = new Usuario($email, $pass); $existe = $persona->existe(); if ($existe) { $tp = new TemplatePower("templates/registro.html"); $tp->prepare(); $tp->gotoBlock("_ROOT"); $tp->newblock("no_registro"); $tp->assign("usuario", $email); $webapp = $tp->getOutputContent(); } else { $persona->setDatosUsuario($nombre, $apellido, $sexo, $fecha_nacimiento, $direccion, $dni); $persona->insertar(); $_SESSION['user'] = $email; $tp = new TemplatePower("templates/index.html"); $tp->prepare(); $tp->gotoBlock("_ROOT"); $tp->newBlock("sesion"); $tp->assign("usuario", $_SESSION['user']); $webapp = $tp->getOutputContent(); } echo $webapp; }
public function consultarReserva() { $proteccion = new Proteccion(); $cod_reserva = $proteccion->html($_POST['cod_reserva']); $reserva = new Reserva(); $result = $reserva->BuscarReserva($cod_reserva); foreach ($result['result'] as $r) { $cod_reserva = $r['cod_reserva']; } $nom_hotel = $r['nom_hotel']; $nombre = $r['nombre']; $apellido = $r['apellido']; $email = $r['email']; $fec_llegada = $r['fec_llegada']; $fec_salida = $r['fec_salida']; $fec_reserva = $r['fec_reserva']; $piso = $r['piso']; $ubicacion = $r['ubicacion']; $tp = new TemplatePower("templates/reserva.html"); $tp->prepare(); $tp->gotoBlock("_ROOT"); $tp->newBlock("generarreserva"); $tp->assign("cod_reserva", $cod_reserva); $tp->assign("nom_hotel", $nom_hotel); $tp->assign("nombre", $nombre); $tp->assign("apellido", $apellido); $tp->assign("email", $email); $tp->assign("fec_llegada", $fec_llegada); $tp->assign("fec_salida", $fec_salida); $tp->assign("fec_reserva", $fec_reserva); $tp->assign("piso", $piso); $tp->assign("ubicacion", $ubicacion); echo $tp->getOutputContent(); }
function makePlanetTooltip($options, $actions, $actionName = 'missiontype') { global $lang; if (!$options or !is_array($options)) { return false; } $tp = new TemplatePower(PATH . TEMPLATE_DIR . TEMPLATE_NAME . "/planet_actions.tpl"); $tp->prepare(); switch ($options[type]) { case "planet": $tp->newBlock("planet"); break; case "moon": $tp->newBlock("moon"); break; case "debris": $tp->newBlock("debris"); break; case "ally": $tp->newBlock("ally"); break; default: return false; break; } $actionName = $lang[$actionName]; foreach ($options as $k => $v) { $tp->assign($k, $v); } if ($actions and is_array($actions)) { foreach ($actions[id] as $k => $actionId) { //echo $actionId . "<-- <br>"; $tp->newBlock($options[type] . "_actions"); $tp->assign("action_name", $actionName[$actionId]); $tp->assign("action_link", $actions[alink][$k]); } } $tool = $tp->getOutputContent(); $find = array('"', "'", "\n", "\r"); $rep = array('\\"', "\\'", "", ""); $tool = str_replace($find, $rep, $tool); return $tool; }
function hotel($idHotel) { $mhotels = new MHotels(); $result = $mhotels->buscar_id($idHotel); foreach ($result['result'] as $r) { $nombreHotel = $r['nom_hotel']; $prov = $r['provincia']; $local = $r['localidad']; $calle = $r['calle']; $ncalle = $r['nro_calle']; $tel = $r['telefono']; $precio = $r['precio_persona']; $cant_imagenes = $r['cant_imagenes']; $descripcion = $r['descripcion']; } $tp = new TemplatePower("templates/hotel.html"); $tp->prepare(); $tp->gotoBlock("_ROOT"); $tp->assign("nombre", $nombreHotel); for ($i = 1; $i <= $cant_imagenes; $i++) { $tp->newBlock("imagenes"); $tp->assign("nombre", $nombreHotel); $tp->assign("numero", $i); } $tp->gotoBlock("_ROOT"); $tp->assign("descripcion", $descripcion); $tp->assign("prov", $prov); $tp->assign("local", $local); $tp->assign("calle", $calle); $tp->assign("ncalle", $ncalle); $tp->assign("tel", $tel); $tp->assign("precio", $precio); if (isset($_SESSION['user'])) { $tp->newBlock("reservar"); $tp->assign("idHotel", $idHotel); } if (!isset($_SESSION['user'])) { $tp->newBlock("iniciarSesion"); } echo $tp->getOutputContent(); }
function savePluginFile($tplName, $fileName, $fields) { $pluginTpl = PATH_GULLIVER_HOME . 'bin' . PATH_SEP . 'tasks' . PATH_SEP . 'templates' . PATH_SEP . $tplName . '.tpl'; $template = new TemplatePower($pluginTpl); $template->prepare(); if (is_array($fields)) { foreach ($fields as $block => $data) { $template->gotoBlock("_ROOT"); if (is_array($data)) { foreach ($data as $rowId => $row) { $template->newBlock($block); foreach ($row as $key => $val) { $template->assign($key, $val); } } } else { $template->assign($block, $data); } } } $content = $template->getOutputContent(); $iSize = file_put_contents($fileName, $content); return $iSize; }
$action = NULL; } switch ($action) { case "toevoegen": if (!empty($_POST['username']) && !empty($_POST['Text'])) { // insert // insert $insert_comment = $db->prepare("INSERT INTO comments SET\n Username = :username,\n Text = :text,\n Accounts_idAccounts = :accountid"); $insert_comment->bindParam(":username", $_POST['username']); $insert_comment->bindParam(":text", $_POST['Text']); $insert_comment->bindValue(":accountid", 4); $insert_comment->execute(); $userid = $db->lastInsertId(); } else { // formulier $content->newBlock("COMMENTFORM"); $content->assign("ACTION", "index.php?pageid=10&action=toevoegen"); $content->assign("BUTTON", "Toevoegen Comment"); } break; case "wijzigen": if (isset($_POST['accountid'])) { $update_comment = $db->prepare("UPDATE comments\n SET Text = :text\n WHERE idComments=:commentid"); $update_comment->bindParam(":text", $_POST['Text']); $update_comment->bindParam(":commentid", $_POST['commentid']); $update_comment->execute(); $content->newBlock("MELDING"); $content->assign("MELDING", "comment is gewijzigd"); } else { $get_comment = $db->prepare("SELECT comments.*, accounts.* FROM comments, accounts\n WHERE idComments = :commentid\n "); $get_comment->bindParam(":commentid", $_GET['commentid']);
} if ($id_codigo != '') { //Editar $tpl->assign("discodigo", "disabled='disabled'"); $tpl->assign("id_codigo", $id_codigo); $objcodigo->setID($id_codigo); $codigo = $objcodigo->codigoByid(); /* echo "<pre>"; print_r($codigo); echo "</pre>"; */ $tpl->assign("pulsera", $codigo['codigo_pulsera']); $lista_eventos = $objeventos->listaEventos(); foreach ($lista_eventos as $evento) { $tpl->newBlock("eventos"); $tpl->assign("nombre", $evento['nombre']); $tpl->assign("id", $evento['id']); if ($evento['id'] == $codigo['id_evento']) { $tpl->assign("seleve", "selected='selected'"); } $tpl->gotoBlock("_ROOT"); } if ($codigo['tipo_entrada'] == 1) { $tpl->assign("atotal", "selected='selected'"); } else { $tpl->assign("adias", "selected='selected'"); } $tpl->assign("dias_valido", $codigo['dias_valido']); if ($codigo['id_asociado'] != '') { //Tiene un asociado
/** * DEPRECATED createPropelClasses() * * Don't use this method, it was left only for backward compatibility * for some external plugins that still is using it */ public function createPropelClasses($sTableName, $sClassName, $aFields, $sAddTabUid, $connection = 'workflow') { try { /* $aUID = array('FLD_NAME' => 'PM_UNIQUE_ID', 'FLD_TYPE' => 'INT', 'FLD_KEY' => 'on', 'FLD_SIZE' => '11', 'FLD_NULL' => '', 'FLD_AUTO_INCREMENT' => 'on'); array_unshift($aFields, $aUID); */ $aTypes = array( 'VARCHAR' => 'string', 'TEXT' => 'string', 'DATE' => 'int', 'INT' => 'int', 'FLOAT' => 'double' ); $aCreoleTypes = array( 'VARCHAR' => 'VARCHAR', 'TEXT' => 'LONGVARCHAR', 'DATE' => 'TIMESTAMP', 'INT' => 'INTEGER', 'FLOAT' => 'DOUBLE' ); if ($sClassName == '') { $sClassName = $this->getPHPName($sTableName); } $sPath = PATH_DB . SYS_SYS . PATH_SEP . 'classes' . PATH_SEP; if (!file_exists($sPath)) { G::mk_dir($sPath); } if (!file_exists($sPath . 'map')) { G::mk_dir($sPath . 'map'); } if (!file_exists($sPath . 'om')) { G::mk_dir($sPath . 'om'); } $aData = array(); $aData['pathClasses'] = substr(PATH_DB, 0, -1); $aData['tableName'] = $sTableName; $aData['className'] = $sClassName; $aData['connection'] = $connection; $aData['GUID'] = $sAddTabUid; $aData['firstColumn'] = isset($aFields[0]) ? strtoupper($aFields[0]['FLD_NAME']) : ($aFields[1]['FLD_NAME']); $aData['totalColumns'] = count($aFields); $aData['useIdGenerator'] = 'false'; $oTP1 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'Table.tpl'); $oTP1->prepare(); $oTP1->assignGlobal($aData); file_put_contents($sPath . $sClassName . '.php', $oTP1->getOutputContent()); $oTP2 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'TablePeer.tpl'); $oTP2->prepare(); $oTP2->assignGlobal($aData); file_put_contents($sPath . $sClassName . 'Peer.php', $oTP2->getOutputContent()); $aColumns = array(); $aPKs = array(); $aNotPKs = array(); $i = 0; foreach ($aFields as $iKey => $aField) { $aField['FLD_NAME'] = strtoupper($aField['FLD_NAME']); if ($aField['FLD_TYPE'] == 'DATE') { $aField['FLD_NULL'] = ''; } $aColumn = array( 'name' => $aField['FLD_NAME'], 'phpName' => $this->getPHPName($aField['FLD_NAME']), 'type' => $aTypes[$aField['FLD_TYPE']], 'creoleType' => $aCreoleTypes[$aField['FLD_TYPE']], 'notNull' => ($aField['FLD_NULL'] == 'on' ? 'true' : 'false'), 'size' => (($aField['FLD_TYPE'] == 'VARCHAR') || ($aField['FLD_TYPE'] == 'INT') || ($aField['FLD_TYPE'] == 'FLOAT') ? $aField['FLD_SIZE'] : 'null'), 'var' => strtolower($aField['FLD_NAME']), 'attribute' => (($aField['FLD_TYPE'] == 'VARCHAR') || ($aField['FLD_TYPE'] == 'TEXT') || ($aField['FLD_TYPE'] == 'DATE') ? '$' . strtolower($aField['FLD_NAME']) . " = ''" : '$' . strtolower($aField['FLD_NAME']) . ' = 0'), 'index' => $i, ); if ($aField['FLD_TYPE'] == 'DATE') { $aColumn['getFunction'] = '/** * Get the [optionally formatted] [' . $aColumn['var'] . '] column value. * * @param string $format The date/time format string (either date()-style or strftime()-style). * If format is NULL, then the integer unix timestamp will be returned. * @return mixed Formatted date/time value as string or integer unix timestamp (if format is NULL). * @throws PropelException - if unable to convert the date/time to timestamp. */ public function get' . $aColumn['phpName'] . '($format = "Y-m-d") { if ($this->' . $aColumn['var'] . ' === null || $this->' . $aColumn['var'] . ' === "") { return null; } elseif (!is_int($this->' . $aColumn['var'] . ')) { // a non-timestamp value was set externally, so we convert it if (($this->' . $aColumn['var'] . ' == "0000-00-00 00:00:00") || ($this->' . $aColumn['var'] . ' == "0000-00-00") || !$this->' . $aColumn['var'] . ') { $ts = "0"; } else { $ts = strtotime($this->' . $aColumn['var'] . '); } if ($ts === -1 || $ts === false) { // in PHP 5.1 return value changes to FALSE throw new PropelException("Unable to parse value of [' . $aColumn['var'] . '] as date/time value: " . var_export($this->' . $aColumn['var'] . ', true)); } } else { $ts = $this->' . $aColumn['var'] . '; } if ($format === null) { return $ts; } elseif (strpos($format, "%") !== false) { return strftime($format, $ts); } else { return date($format, $ts); } }'; } else { $aColumn['getFunction'] = '/** * Get the [' . $aColumn['var'] . '] column value. * * @return string */ public function get' . $aColumn['phpName'] . '() { return $this->' . $aColumn['var'] . '; }'; } switch ($aField['FLD_TYPE']) { case 'VARCHAR': case 'TEXT': $aColumn['setFunction'] = '// Since the native PHP type for this column is string, // we will cast the input to a string (if it is not). if ($v !== null && !is_string($v)) { $v = (string) $v; } if ($this->' . $aColumn['var'] . ' !== $v) { $this->' . $aColumn['var'] . ' = $v; $this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . '; }'; break; case 'DATE': $aColumn['setFunction'] = 'if ($v !== null && !is_int($v)) { // if($v == \'\') // $ts = null; // else $ts = strtotime($v); if ($ts === -1 || $ts === false) { // in PHP 5.1 return value changes to FALSE //throw new PropelException("Unable to parse date/time value for [' . $aColumn['var'] . '] from input: " // . var_export($v, true)); } } else { $ts = $v; } if ($this->' . $aColumn['var'] . ' !== $ts) { $this->' . $aColumn['var'] . ' = $ts; $this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . '; }'; break; case 'INT': $aColumn['setFunction'] = '// Since the native PHP type for this column is integer, // we will cast the input value to an int (if it is not). if ($v !== null && !is_int($v) && is_numeric($v)) { $v = (int) $v; } if ($this->' . $aColumn['var'] . ' !== $v || $v === 1) { $this->' . $aColumn['var'] . ' = $v; $this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . '; }'; break; case 'FLOAT': $aColumn['setFunction'] = 'if ($this->' . $aColumn['var'] . ' !== $v || $v === 0) { $this->' . $aColumn['var'] . ' = $v; $this->modifiedColumns[] = ' . $aData['className'] . 'Peer::' . $aColumn['name'] . '; }'; break; } $aColumns[] = $aColumn; if ($aField['FLD_KEY'] == 1 || $aField['FLD_KEY'] === 'on') { $aPKs[] = $aColumn; } else { $aNotPKs[] = $aColumn; } if ($aField['FLD_AUTO_INCREMENT'] == 1 || $aField['FLD_AUTO_INCREMENT'] === 'on') { $aData['useIdGenerator'] = 'true'; } $i++; } $oTP3 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'map' . PATH_SEP . 'TableMapBuilder.tpl'); $oTP3->prepare(); $oTP3->assignGlobal($aData); foreach ($aPKs as $iIndex => $aColumn) { $oTP3->newBlock('primaryKeys'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP3->assign($sKey, $aColumn[$sKey]); } } $oTP3->gotoBlock('_ROOT'); foreach ($aNotPKs as $iIndex => $aColumn) { $oTP3->newBlock('columnsWhitoutKeys'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP3->assign($sKey, $aColumn[$sKey]); } } file_put_contents($sPath . PATH_SEP . 'map' . PATH_SEP . $sClassName . 'MapBuilder.php', $oTP3->getOutputContent()); $oTP4 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'om' . PATH_SEP . 'BaseTable.tpl'); $oTP4->prepare(); switch (count($aPKs)) { case 0: $aData['getPrimaryKeyFunction'] = 'return null;'; $aData['setPrimaryKeyFunction'] = ''; break; case 1: $aData['getPrimaryKeyFunction'] = 'return $this->get' . $aPKs[0]['phpName'] . '();'; $aData['setPrimaryKeyFunction'] = '$this->set' . $aPKs[0]['phpName'] . '($key);'; break; default: $aData['getPrimaryKeyFunction'] = '$pks = array();' . "\n"; $aData['setPrimaryKeyFunction'] = ''; foreach ($aPKs as $iIndex => $aColumn) { $aData['getPrimaryKeyFunction'] .= '$pks[' . $iIndex . '] = $this->get' . $aColumn['phpName'] . '();' . "\n"; $aData['setPrimaryKeyFunction'] .= '$this->set' . $aColumn['phpName'] . '($keys[' . $iIndex . ']);' . "\n"; } $aData['getPrimaryKeyFunction'] .= 'return $pks;' . "\n"; break; } $oTP4->assignGlobal($aData); foreach ($aColumns as $iIndex => $aColumn) { $oTP4->newBlock('allColumns1'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns2'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns3'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns4'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns5'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns6'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns7'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns8'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } $oTP4->newBlock('allColumns9'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } } $oTP4->gotoBlock('_ROOT'); foreach ($aPKs as $iIndex => $aColumn) { $oTP4->newBlock('primaryKeys1'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } } $oTP4->gotoBlock('_ROOT'); foreach ($aPKs as $iIndex => $aColumn) { $oTP4->newBlock('primaryKeys2'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } } $oTP4->gotoBlock('_ROOT'); foreach ($aNotPKs as $iIndex => $aColumn) { $oTP4->newBlock('columnsWhitoutKeys'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP4->assign($sKey, $aColumn[$sKey]); } } file_put_contents($sPath . PATH_SEP . 'om' . PATH_SEP . 'Base' . $sClassName . '.php', $oTP4->getOutputContent()); $oTP5 = new TemplatePower(PATH_TPL . 'additionalTables' . PATH_SEP . 'om' . PATH_SEP . 'BaseTablePeer.tpl'); $oTP5->prepare(); $sKeys = ''; foreach ($aPKs as $iIndex => $aColumn) { $sKeys .= '$' . $aColumn['var'] . ', '; } $sKeys = substr($sKeys, 0, -2); //$sKeys = '$pm_unique_id'; if ($sKeys != '') { $aData['sKeys'] = $sKeys; } else { $aData['sKeys'] = '$DUMMY'; } $oTP5->assignGlobal($aData); foreach ($aColumns as $iIndex => $aColumn) { $oTP5->newBlock('allColumns1'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns2'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns3'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns4'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns5'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns6'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns7'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns8'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns9'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } $oTP5->newBlock('allColumns10'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } } $oTP5->gotoBlock('_ROOT'); foreach ($aPKs as $iIndex => $aColumn) { $oTP5->newBlock('primaryKeys1'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } } foreach ($aPKs as $iIndex => $aColumn) { $oTP5->newBlock('primaryKeys2'); $aKeys = array_keys($aColumn); foreach ($aKeys as $sKey) { $oTP5->assign($sKey, $aColumn[$sKey]); } } file_put_contents($sPath . PATH_SEP . 'om' . PATH_SEP . 'Base' . $sClassName . 'Peer.php', $oTP5->getOutputContent()); } catch (Exception $oError) { throw($oError); } }
<?php $content = new TemplatePower("template/files/login.tpl"); $content->prepare(); if (isset($_SESSION['accountid'])) { // is al ingelogd, dus niks doen $content->newBlock("MELDING"); $content->assign("MELDING", "Je bent al ingelogd"); } else { if (!empty($_POST['gnaam']) and !empty($_POST['password'])) { // formulier is verstuurd $check_user = $db->prepare("SELECT count(*) FROM accounts a, users u\n WHERE a.Users_idUsers = u.idUsers\n AND a.Username = :username\n AND a.Password = :password"); $check_user->bindParam(":username", $_POST['gnaam']); $password = sha1($_POST['password']); $check_user->bindParam(":password", $password); $check_user->execute(); if ($check_user->fetchColumn() == 1) { // gebruiker gevonden $get_user = $db->prepare("SELECT a.*, u.* FROM accounts a, users u\n WHERE a.Users_idUsers = u.idUsers\n AND a.Username = :username\n AND a.Password = :password"); $get_user->bindParam(":username", $_POST['gnaam']); $get_user->bindParam(":password", $password); $get_user->execute(); $user = $get_user->fetch(PDO::FETCH_ASSOC); $_SESSION['accountid'] = $user['idAccounts']; $_SESSION['username'] = $user['Username']; $_SESSION['roleid'] = $user['Role_idRole']; $content->newBlock("MELDING"); $content->assign("MELDING", "Je bent ingelogd"); } else { // gebruiker niet gevonden: combinatie username + password klopt niet $errors->newBlock("ERRORS");
//primero comprobamos que el usuario NO este logeado, si esta logeado redirigimos a index.php if (isset($_SESSION['logueado'])) { header("Location: index.php"); exit; } if (isset($_GET['token'])) { $token = $_GET['token']; //en caso de que haya un token en la querystring gestionamos el proceso para nueva contraseña //debemos comprobar que el toquen sea valido, sino mostramos un mensaje de error $fecha = new DateTime(date("Y-m-d H:m:s")); $fecha->modify("-1 day"); $query = "SELECT token, usuarios.usuario FROM usuarios_recuperar_clave, usuarios\n WHERE token='{$token}' \n AND fecha>'" . $fecha->format("Y-m-d H:m:s") . "'\n AND usuarios_recuperar_clave.idusuario = usuarios.idusuario"; $datos = mysql_fetch_assoc(mysql_query($query)); if (!$datos) { //token invalido o no presente en la base de datos $tplClave->newBlock("errortoken"); $tplClave->newBlock("generar_token"); } else { //token valido $tplClave->newBlock("nueva_clave"); //mostramos el usuario para el cual se va a asignar la nueva clave $tplClave->assign("user", $datos['usuario']); $tplClave->assign("token", $datos['token']); } } else { //comprobamos si ha ocurrido un error durante la recepcion del formulario para generar el token if (isset($_GET['error'])) { $tplClave->newBlock("error" . $_GET['error']); } //si no hay token mostramos el html para que se pueda recuperar la contraseña $tplClave->newBlock("generar_token");
//Name: index.php //Function: code for converting the chart data and seeding the html //Last Modified: 10-02-2016 //By: Arno Inen //General Modification: debugging //Requires: //-TemplatePower //-Canvas.js //Includes/requires include_once 'class.TemplatePower.inc.php'; //Call template engine $template_url = "./templates/"; $template = new TemplatePower($template_url . "chart.html"); $template->prepare(); //Functions ////Main Code $json = file_get_contents('http://www.mixtup.nl/dev/techradar/data.json'); $data_array = json_decode($json); $counter = 0; //var_dump($data_array); $totalObjects = count($data_array); while ($counter < $totalObjects - 1) { $template->newBlock("data_row"); $template->assign("date", $data_array[$counter]->{'x'}); $template->assign("ycoord", $data_array[$counter]->{'y'}); $counter++; } $template->gotoBlock("_ROOT"); $template->assign("finaldate", $data_array[$counter]->{'x'}); $template->assign("finalycoord", $data_array[$counter]->{'y'}); $template->printToScreen();
<?php $errors = new TemplatePower('../html/errors.tpl'); $errors->prepare(); try { $db = new PDO('mysql:host=localhost;dbname=mydb;charset=utf8', 'root', ''); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $error) { //print "er is een error: ".$error->getFile()." ".$error->getLine(); $errors->newBlock("ERRORS"); $errors->assign("ERROR", "er is een error: " . $error->getFile() . " " . $error->getLine()); }
<?php //llamamos al contructor de la plantilla y la preparamos para mostrar $tplPacientes = new TemplatePower("plantilla/pacientes.html"); $tplPacientes->prepare(); //creamos el mensaje a mostrar en función de la acción realizada $tplPacientes->assign("titulo", "Pacientes"); if (isset($_GET['msg'])) { $tplPacientes->newBlock('notificacion_ok'); switch ($_GET['msg']) { case 'pac_add': $msg = 'Paciente añadido con éxito'; break; case 'pac_del': $msg = 'Paciente eliminado con éxito'; break; case 'pac_edit': $msg = 'Paciente editado con éxito'; break; case 'pac_noedit': $msg = 'No se ha modificado nigún campo'; break; default: $msg = ''; break; } $tplPacientes->assign("msg", $msg); } if (isset($_POST) && isset($_POST['buscar'])) { //gestionamos el buscar $query = "SELECT DISTINCT * FROM pacientes \r\n WHERE historia LIKE '%" . $_POST['buscar'] . "%'\r\n OR nombre_pac LIKE '%" . $_POST['buscar'] . "%'\r\n OR especie LIKE '%" . $_POST['buscar'] . "%' \r\n OR edad LIKE '%" . $_POST['buscar'] . "%'\r\n OR sexo LIKE '%" . $_POST['buscar'] . "%'\r\n OR raza LIKE '%" . $_POST['buscar'] . "%' \r\n OR dni_propietario LIKE '%" . $_POST['buscar'] . "%'\r\n OR remitente LIKE '%" . $_POST['buscar'] . "%'\r\n OR clinica_remitente LIKE '%" . $_POST['buscar'] . "%'\r\n OR tel_remitente LIKE '%" . $_POST['buscar'] . "%' \r\n OR mail_remitente LIKE '%" . $_POST['buscar'] . "%' \r\n ORDER BY especie";
$pagina = $_GET['pagina']; $class_inferior = ""; //print_r($_SESSION);echo usuario_logeado(); exit(); if (!usuario_logeado() && $pagina != "" && $pagina != "login" && $pagina != "recuperar_clave") { header("Location: /gicorec/index.php"); exit; } //en función de la página solicitada para mostrar incluimos un archivo de control u otro switch ($pagina) { case 'principal': include_once 'principal.php'; $class_inferior = "center"; break; case 'pacientes': include_once 'pacientes.php'; $tplIndex->newBlock("menu_principal_link"); break; case 'login': include_once 'login.php'; break; case 'almacen': include_once 'almacen.php'; $tplIndex->newBlock("menu_principal_link"); break; case 'cirugias': include_once 'cirugias.php'; $tplIndex->newBlock("menu_principal_link"); break; case 'agenda': include_once 'agenda.php'; $tplIndex->newBlock("menu_principal_link");
public function bajau($email) { global $db; $tp = new TemplatePower("templates/BajaUsuario.html"); $tp->prepare(); $tp->gotoBlock("_ROOT"); $sql = "delete from usuario where(email='{$email}')"; $db->ejecutar($sql); $tp->newBlock("mensaje"); echo $tp->getOutputContent(); }
} } } } } } $changeCount--; } $oDataset = ArrayBasePeer::doSelectRs($c); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); $changeCount = 0; while ($oDataset->next()) { $aRow = $oDataset->getRow(); $changeCount++; $changedValues = unserialize($aRow['HISTORY_DATA']); $tpl->newBlock("DYNLOG"); $tableName = "_TCHANGE_" . $changeCount; $changeCountA = $changeCount + 1; $tableNameA = "_TCHANGE_" . $changeCountA; $tpl->assign("dynTitle", addslashes($aRow["DYN_TITLE"])); $tpl->assign("dynDate", $aRow["HISTORY_DATE"]); $tpl->assign("dynUser", addslashes($aRow["USR_NAME"])); $tpl->assign("changes", G::LoadTranslation("ID_CHANGES")); $tpl->assign("dynUID", $aRow["DYN_UID"]); $tpl->assign("tablename", $tableName); $tpl->assign("viewForm", $aRow["OBJ_TYPE"] == "DYNAFORM" ? "<a href=\"javascript:;\" onclick=\"showDynaformHistory('" . $aRow["DYN_UID"] . "', '{$tableName}', '" . $aRow["HISTORY_DATE"] . "', '" . addslashes($aRow["DYN_TITLE"]) . "'); return false;\">" . G::LoadTranslation("ID_VIEW") . "</a>" : ""); $tpl->assign("dynaform", G::LoadTranslation("ID_DYNAFORM")); $tpl->assign("date", G::LoadTranslation("ID_DATE")); $tpl->assign("user", G::LoadTranslation("ID_USER")); $tpl->assign("fieldNameLabel", G::LoadTranslation("ID_FIELDS")); $tpl->assign("previousValuesLabel", G::LoadTranslation("ID_PREV_VALUES"));
$oMenu->load('setup'); $toolItems = array(); foreach ($oMenu->Options as $i => $option) { $toolItems[] = array('id' => $oMenu->Id[$i], 'link' => $oMenu->Options[$i] != '' ? $oMenu->Options[$i] : '#', 'onclick' => $oMenu->JS[$i] != '' ? $oMenu->JS[$i] : '', 'label' => $oMenu->Labels[$i], 'icon' => $oMenu->Icons[$i] != '' ? $oMenu->Icons[$i] : 'icon-pmlogo.png', 'target' => $oMenu->JS[$i] != '' ? '' : 'admToolsContent'); } $template = new TemplatePower(PATH_TPL . 'setup' . PATH_SEP . 'tools.html'); $template->prepare(); $template->assign('LeftWidth', '230'); $template->assign('contentHeight', '520'); if (isset($_GET['i18'])) { $_SESSION['TOOLS_VIEWTYPE'] = true; $template->assign('displayLanguageTool', 'block'); } else { $template->assign('displayLanguageTool', 'none'); } if (isset($_GET['newSite'])) { $template->assign('displayNewSiteTool', 'block'); } else { $template->assign('displayNewSiteTool', 'none'); } foreach ($toolItems as $item) { $template->newBlock('tool_options'); foreach ($item as $propertyName => $propertyValue) { $template->assign($propertyName, $propertyValue); } } $G_PUBLISH->AddContent('template', '', '', '', $template); G::RenderPage('publish'); if (isset($_GET['module'])) { print "\n <script>\n admToolsContent.location='" . $_GET['module'] . "';\n </script>\n "; }
$sql = "UPDATE projects SET enabled='1' WHERE id={$id}"; // Prepare statement $stmt = $conn->prepare($sql); $enabled = 1; // execute the query $stmt->execute(); } else { $sql = "UPDATE projects SET enabled='0' WHERE id={$id}"; // Prepare statement $stmt = $conn->prepare($sql); $enabled = 0; // execute the query $stmt->execute(); } } $tpl->newBlock("project"); $title = $row["title"]; $content = $row["content"]; $id = $row["id"]; $tpl->assign("enabled", "{$enabled}"); $tpl->assign("title", "{$title}"); $tpl->assign("content", "{$content}"); $tpl->assign("id", "{$id}"); if ($enabled == 1) { $tpl->assign("checked", "checked"); } else { $tpl->assign("checked", ""); } $tpl->gotoBlock("_ROOT"); } }
<?php include 'tplutil.inc'; include 'class.TemplatePower.inc.php'; $tpl = new TemplatePower('presentations/slides/intro/templatepower.tpl'); $tpl->prepare(); $tpl->assign("TITLE", 'My Title'); $tpl->assign("USER", get_user()); foreach (get_users() as $user) { $tpl->newBlock('USERS'); $tpl->assign('USER', $user); } $tpl->printToScreen();
$tpl->assign("node_msg", "This host is up and running."); } else { $tpl->assign("node_msg", "This host is down."); } $cluster_url = rawurlencode($clustername); $tpl->assign("cluster_url", $cluster_url); $tpl->assign("graphargs", "h={$hostname}&{$get_metric_string}&st={$cluster['LOCALTIME']}"); # For the node view link. $tpl->assign("node_view", "./?p=2&c={$cluster_url}&h={$hostname}"); # No reason to go on if this node is down. if ($hosts_down) { $tpl->printToScreen(); return; } $tpl->assign("ip", $hosts_up['IP']); $tpl->newBlock('columns_dropdown'); $tpl->assign("metric_cols_menu", $metric_cols_menu); $g_metrics_group = array(); foreach ($metrics as $name => $v) { if ($v['TYPE'] == "string" or $v['TYPE'] == "timestamp" or isset($always_timestamp[$name]) and $always_timestamp[$name]) { $s_metrics[$name] = $v; } elseif ($v['SLOPE'] == "zero" or isset($always_constant[$name]) and $always_constant[$name]) { $c_metrics[$name] = $v; } else { if (isset($reports[$name]) and $reports[$metric]) { continue; } else { $graphargs = "c={$cluster_url}&h={$hostname}&v={$v['VAL']}" . "&m={$name}&r={$range}&z=medium&jr={$jobrange}" . "&js={$jobstart}&st={$cluster['LOCALTIME']}"; # Adding units to graph 2003 by Jason Smith <*****@*****.**>. if ($v['UNITS']) { $encodeUnits = rawurlencode($v['UNITS']);
if ($_SESSION['roleid'] == 2) { switch ($action) { case "toevoegen": if (!empty($_POST['username']) && !empty($_POST['title']) && !empty($_POST['content'])) { // insert // insert $insert_blog = $db->prepare("INSERT INTO blog SET\n Username = :username,\n Title = :title,\n Content = :content,\n Accounts_idAccounts = :accountid"); $insert_blog->bindParam(":username", $_POST['username']); $insert_blog->bindParam(":title", $_POST['title']); $insert_blog->bindParam(":content", $_POST['content']); $insert_blog->bindValue(":accountid", 4); $insert_blog->execute(); $userid = $db->lastInsertId(); } else { // formulier $content->newBlock("BLOGFORM"); $content->assign("ACTION", "index.php?pageid=3&action=toevoegen"); $content->assign("BUTTON", "Toevoegen Blog"); } break; case "wijzigen": if (isset($_POST['accountid'])) { $update_blog = $db->prepare("UPDATE blog\n SET Title = :title,\n Content= :content\n WHERE idBlog=:blogid"); $update_blog->bindParam(":title", $_POST['title']); $update_blog->bindParam(":content", $_POST['content']); $update_blog->bindParam(":blogid", $_POST['blogid']); $update_blog->execute(); $content->newBlock("MELDING"); $content->assign("MELDING", "blog is gewijzigd"); } else { $get_blog = $db->prepare("SELECT blog.*, accounts.* FROM blog, accounts\n WHERE blog.idBlog = :blogid\n ");
} if ($system < 1 or !$system) { $system = 1; } if ($system > MAX_SYSTEM_IN_GALAXY) { $system = MAX_SYSTEM_IN_GALAXY; } } $position[galaxy] = empty($galaxy) ? $planetrow['galaxy'] : $galaxy; $position[system] = empty($system) ? $planetrow['system'] : $system; $position[planet] = empty($planet) ? $planetrow['planet'] : $planet; $position[planet_type] = empty($planet_type) ? $planetrow['planet_type'] : $planet_type; $tp = new TemplatePower($ugamela_root_path . TEMPLATE_DIR . TEMPLATE_NAME . "/galaxy_body_new.tpl"); $tp->prepare(); // MOVEMENT BLOCK $tp->newBlock("movement"); foreach ($position as $name => $trans) { $tp->assign($name, $trans); } // SHORT DEFINITION $g = $position[galaxy]; $s = $position[system]; // GALAXY TABLE BLOCK // PREPARE THE $galaxy:$system $lang['Solar_system_at'] = $lang['Solar_system'] . " " . $g . ":" . $s; // PLANET INFORMATION $sql = "SELECT \r\n\t\t\t\tl.temp_min, l.diameter, l.name as moon_name,\r\n\t\t\t\tg.*, g.metal as debris_metal, g.crystal as debris_crystal, g.planet as planetpos,\r\n\t\t\t\tp.*, p.name as planet_name,\r\n\t\t\t\tu.*,\r\n\t\t\t\ts.total_points, s.total_rank,\r\n\t\t\t\ta.ally_tag, a.ally_name, a.ally_web, a.ally_members\r\n\t\t\tFROM {{table}}planets as p\r\n\t\t\t\t\r\n\t\t\t\tLEFT JOIN {{table}}galaxy as g ON g.id_planet = p.id\r\n\t\t\t\tLEFT JOIN {{table}}users as u ON u.id = p.id_owner\r\n\t\t\t\tLEFT JOIN {{table}}alliance as a ON a.id = u.ally_id\r\n\t\t\t\tLEFT JOIN {{table}}planets as l ON l.id = g.id_luna AND l.planet_type = 3\r\n\t\t\t\tLEFT JOIN {{table}}statpoints as s ON s.id_owner = u.id AND stat_type = 1 AND stat_code = 1 \r\n\t\t\t\t\r\n\t\t\tWHERE \r\n\t\t\t\t\tg.galaxy = {$g} \r\n\t\t\t\tAND g.system = {$s} \r\n\t\t\tORDER BY g.planet ASC"; $rs = doquery($sql, ''); if ($temprow = mysql_fetch_assoc($rs)) { do { $planetsrow[$temprow[planetpos]] = $temprow;
$servername = "localhost"; $username = "******"; $password = ""; $dbname = "grid_imo"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM projects WHERE enabled = 1"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $tpl->newBlock("project"); $title = $row["title"]; $content = $row["summary"]; $id = $row["id"]; $tpl->assign("title", "{$title}"); $tpl->assign("content", "{$content}"); $tpl->assign("id", "{$id}"); $tpl->gotoBlock("_ROOT"); } } else { $tpl->newBlock("no_found"); $tpl->assign("no_found", "<h3>Op het moment zijn er geen projecten beschikbaar</h3>"); $tpl->gotoBlock("_ROOT"); } $tpl->printToScreen(); $conn->close();
$tpl->prepare(); $servername = "localhost"; $username = "******"; $password = ""; $dbname = "grid_imo"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM news"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $tpl->newBlock("News"); $title = $row["title"]; $news_content = $row["text"]; $tpl->assign("news_title", "{$title}"); $tpl->assign("news_content", "{$news_content}"); $tpl->gotoBlock("_ROOT"); } } else { $tpl->newBlock("News"); $tpl->assign("news_title", "Geen nieuws beschikbaar."); $tpl->assign("news_content", "Er is op dit moment geen nieuws aanwezig."); $tpl->gotoBlock("_ROOT"); } $tpl->printToScreen(); $conn->close();
require_once 'classes/model/Step.php'; $oStep = new Step(); $sUidGrids = $oStep->lookingforUidGrids($sPRO_UID, $sDYNAFORM); $template->assign("URL_MABORAK_JS", G::browserCacheFilesUrl("/js/maborak/core/maborak.js")); $template->assign("URL_TRANSLATION_ENV_JS", G::browserCacheFilesUrl("/jscore/labels/" . SYS_LANG . ".js")); $template->assign("siteUrl", $http . $_SERVER["HTTP_HOST"]); $template->assign("sysSys", SYS_SYS); $template->assign("sysLang", SYS_LANG); $template->assign("sysSkin", SYS_SKIN); $template->assign("processUid", $sPRO_UID); $template->assign("dynaformUid", $sDYNAFORM); $template->assign("taskUid", $sTASKS); $template->assign("dynFileName", $sPRO_UID . "/" . $sDYNAFORM); $template->assign("formId", $G_FORM->id); $template->assign("scriptCode", $scriptCode); if (sizeof($sUidGrids) > 0) { foreach ($sUidGrids as $k => $v) { $template->newBlock('grid_uids'); $template->assign('siteUrl', $http . $_SERVER['HTTP_HOST']); $template->assign('gridFileName', $sPRO_UID . '/' . $v); } } print_r('<textarea cols="77" rows="26" style="width:100%; height:99%">' . htmlentities(str_replace('</body>', '</form></body>', str_replace('</form>', '', $template->getOutputContent()))) . '</textarea>'); G::auditLog('WebEntry', 'Generate web entry with single HTML (dynaform uid: ' . $sDYNAFORM . ') in process "' . $resultProcess['PRO_TITLE'] . '"'); } } catch (Exception $e) { $G_PUBLISH = new Publisher(); $aMessage['MESSAGE'] = $e->getMessage(); $G_PUBLISH->AddContent('xmlform', 'xmlform', 'login/showMessage', '', $aMessage); G::RenderPage('publish', 'raw'); }
<?php $tpl = new TemplatePower('template/eventos/consultaEventos.tpl'); $tpl->prepare(); foreach ($_POST as $nombre_campo => $valor) { $asignacion = '$' . $nombre_campo . '=\'' . $valor . '\';'; if (!is_numeric($nombre_campo)) { eval($asignacion); } } $eventos = new Eventos($conn); $lista_eventos = $eventos->listaEventos(); foreach ($lista_eventos as $evento) { $tpl->newBlock("eventos"); $tpl->assign("nombre", $evento['nombre']); $tpl->assign("f_inicio", $evento['f_inicio']); $tpl->assign("f_fin", $evento['f_fin']); $tpl->assign("logotipo", $evento['logotipo']); $tpl->assign("descripcion", $evento['descripcion']); $tpl->assign("id", $evento['id']); $tpl->gotoBlock("_ROOT"); } //$tpl->assign('anterior', $anterior); //$tpl->assign('siguiente', $siguiente); $tpl->printToScreen(); ?>
<?php session_start(); include "inc.includes.php"; $db = new BaseDatos($config['dbhost'], $config['dbuser'], $config['dbpass'], $config['db']); $tpl = new TemplatePower("templates/index.html"); $tpl->prepare(); $tpl->gotoBlock("_ROOT"); //isset determina si una variable esta definida o es null //$_REQUEST tiene el contenido de get y post if (!isset($_REQUEST["action"]) || $_REQUEST["action"] == "") { $tpl->newBlock("contenido"); $mhotels = new MHotels(); $result = $mhotels->allhoteles(); if ($result['found']) { foreach ($result['result'] as $r) { $tpl->newblock("hotels"); $tpl->assign("idHotel", $r['id_hotel']); $tpl->assign("name", $r['nom_hotel']); $tpl->assign("prov", $r['provincia']); $tpl->assign("local", $r['localidad']); $tpl->assign("calle", $r['calle']); $tpl->assign("ncalle", $r['nro_calle']); $tpl->assign("tel", $r['telefono']); $tpl->assign("precio", $r['precio_persona']); } } else { $tpl->newblock("no_hotels"); } $webapp = $tpl->getOutputContent(); } else {
$MessageType = array(100, 0, 1, 2, 3, 4, 5, 15, 99); $TitleColor = array(0 => '#FFFF00', 1 => '#FFFF00', 2 => '#FFFF00', 3 => '#FFFF00', 4 => '#FFFF00', 5 => '#FFFF00', 15 => '#FFFF00', 99 => '#FFFF00', 100 => '#FFFF00'); $BackGndColor = array(0 => '#663366', 1 => '#663366', 2 => '#663366', 3 => '#663366', 4 => '#663366', 5 => '#663366', 15 => '#663366', 99 => '#663366', 100 => '#663366'); for ($MessType = 0; $MessType < 101; $MessType++) { if (in_array($MessType, $MessageType)) { $WaitingMess[$MessType] = $UnRead[$messfields[$MessType]]; $TotalMess[$MessType] = 0; } } while ($CurMess = mysql_fetch_array($UsrMess)) { $MessType = $CurMess['message_type']; $TotalMess[$MessType] += 1; $TotalMess[100] += 1; } foreach ($MessageType as $k => $id) { $tp->newBlock("message_type"); $replace[type] = $id; $replace[unread] = $WaitingMess[$id]; $replace[total] = $TotalMess[$id]; $replace[name] = $lang['type'][$id]; foreach ($replace as $k => $v) { $tp->assign($k, $v); } } switch ($MessPageMode) { case 'write': if ($_REQUEST['subject']) { $subject = $_REQUEST['subject']; } if (!is_numeric($OwnerID)) { message($lang['mess_no_ownerid'], $lang['mess_error']);
// insert $insert_user = $db->prepare("INSERT INTO users SET\n Surename = :achternaam,\n Name = :voornaam,\n Email = :email"); $insert_user->bindParam(":achternaam", $_POST['achternaam']); $insert_user->bindParam(":voornaam", $_POST['voornaam']); $insert_user->bindParam(":email", $_POST['email']); $insert_user->execute(); $userid = $db->lastInsertId(); $insert_account = $db->prepare("INSERT INTO accounts SET\n Username = :username,\n Password = :password,\n salt = :salt,\n Users_idUsers = :userid,\n Role_idRole = :roleid"); $insert_account->bindParam(":username", $_POST['gebruikersnaam']); $password = sha1($_POST['password1']); $insert_account->bindParam(":password", $password); $insert_account->bindParam(":salt", $userid); $insert_account->bindParam(":userid", $userid); $insert_account->bindValue(":roleid", 1); $insert_account->execute(); $content->newBlock("MELDING"); $content->assign("MELDING", "Gebruiker is toegevoegd"); print "Gelukt"; } else { $errors->newBlock("ERRORS"); $errors->assign("ERROR", "Wachtwoord komt niet overeen!"); $content->newBlock("FORMULIER"); $content->assign("ACTION", "index.php?pageid=1&action=registreren"); $content->assign("BUTTON", "Toevoegen Gebruiker"); } } else { // formulier $content->newBlock("FORMULIER"); $content->assign("ACTION", "index.php?pageid=3&action=registreren"); $content->assign("BUTTON", "Toevoegen Gebruiker"); }
<?php // Hier laad ik de header.html in $header = new TemplatePower("template/files/header.tpl"); $header->prepare(); if (!empty($_SESSION['accountid'])) { $header->newBlock("LOGGEDIN"); $header->assign("USERNAME", $_SESSION['username']); // if($_SESSION['roleid'] == 2){ // $header->newBlock("ADMINMENU"); // } } else { $header->newBlock("LOGINTOP"); }