function erro($msg, $id_conn) { echo $msg; execute_query("END TRANSACTION", $id_conn); execute_query("ROLLBACK", $id_conn); close_database($id_conn); return; }
function print_footer($msg = "") { if ($msg != "") { print "<hr/>\n"; print "{$msg}\n"; } print "<hr/>\n"; print "<div style='float: left'><a href='http://pecanproject.org'>PEcAn Project</a></div>\n"; print "<div style='float: right'><a href='http://betydb.org'>BETY Project</a></div>\n"; print "</body>\n"; print "</html>\n"; close_database(); }
function grava_usuario() { $filename = upload_foto(); require '../config/infodbcon.php'; require '../config/database.php'; $id_conn = open_database(); $post = array_map("mysql_real_escape_string", $_POST); execute_query("START TRANSACTION", $id_conn); if ($post['cmb_cadastro'] == '0') { $sql = 'INSERT INTO tb_usuario '; $sql .= '(usuario_nome, usuario_login, usuario_senha, usuario_email, usuario_foto, usuario_info, usuario_ativo)'; $sql .= 'VALUES '; $sql .= '(\'' . addslashes(utf8_decode($_POST['nome'])) . '\', \'' . utf8_decode($post['login']) . '\', '; $sql .= '\'' . md5('123mudar') . '\', \'' . $post['email'] . '\','; $sql .= '\'' . $filename . '\', \'' . addslashes(utf8_decode($_POST['infor'])) . '\', \'' . ($post['ativo'] ? 1 : 0) . '\')'; } else { $sql = 'UPDATE tb_usuario SET '; $sql .= 'usuario_nome = \'' . addslashes(utf8_decode($_POST['nome'])) . '\', usuario_login = \'' . $post['login'] . '\', '; $sql .= 'usuario_email = \'' . $post['email'] . '\', '; $sql .= 'usuario_info=\'' . addslashes(utf8_decode($_POST['infor'])) . '\', '; $sql .= 'usuario_ativo=\'' . (isset($post['ativo']) ? 1 : 0) . '\' '; if ($post['trocoufoto']) { $sql .= ',usuario_foto=\'' . $filename . '\' '; } $sql .= 'WHERE '; $sql .= 'usuario_id=' . $post['cmb_cadastro']; } if (!execute_query($sql, $id_conn)) { $messagem = utf8_decode('Query Inválida: ') . mysql_error() . "\n"; $messagem .= 'Pesquisa Inteira: ' . $sql; echo $messagem; execute_query("ROLLBACK", $id_conn); } else { execute_query('COMMIT', $id_conn); echo '1'; } execute_query("END TRANSACTION", $id_conn); close_database($id_conn); }
*/ // Check login require "common.php"; if ($authentication) { open_database(); if (!check_login()) { header("Location: index.php"); close_database(); exit; } if (get_page_acccess_level() > $min_run_level) { header("Location: history.php"); close_database(); exit; } close_database(); } ?> <!DOCTYPE html> <html> <head> <title>EBI Sites</title> <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no" /> <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> <link rel="stylesheet" type="text/css" href="sites.css" /> <script type="text/javascript" src="jquery-1.7.2.min.js"></script> <script type="text/javascript"> function validate() { $("#error").html(""); }
<?php /* @Autor: Clésio Teixeira da Silva @Versão: 2.2 @Última Alteração: 14/09/2015 */ session_start(); // arquivo de funções. require "../funcoes/php/funcao.php"; //Função encontrada dentro do arquivo funcao.php. Tem como incumbência verificar se o usuário está logado. session_checker(); require "../config/infodbcon.php"; require "../config/database.php"; $id_conn = open_database(); libera_acesso('colecao', $id_conn); close_database($id_conn); require '../html/colecao.html'; echo '<script>foto_usuario(\'' . $_SESSION['usuario_id'] . '\')</script>'; exit;
function DeleteFileFromDatabase($md5) { if (!open_database()) { return array(); } $results = exec_query("DELETE FROM storage WHERE md5 = '" . escape_string($md5, false) . "'", false); close_database(); return $results; }
function cleanSearchTables() { // Clean up the database tables before performing a new search or updating the collection debuglog("Cleaning Search Results", "MYSQL", 6); // Any track that was previously hidden needs to be re-hidden generic_sql_query("UPDATE Tracktable SET Hidden = 1, isSearchResult = 0 WHERE isSearchResult = 3"); // Any track that was previously a '2' (added to database as search result) but now // has a playcount needs to become a zero and be hidden. hide_played_tracks(); // remove any remaining '2's generic_sql_query("DELETE FROM Tracktable WHERE isSearchResult = 2"); // Set '1's back to '0's generic_sql_query("UPDATE Tracktable SET isSearchResult = 0 WHERE isSearchResult = 1"); // This may leave some orphaned albums and artists remove_cruft(); // // remove_cruft creates some temporary tables and we need to remove them because // remove cruft will be called again later on if we're doing a collection update. // Sadly, DROP TABLE runs into locking problems, at least with SQLite, so instead // we close the DB connection and start again. // So this function must be called BEFORE prepareCollectionUpdate, as that creates // temporary tables of its own. // close_database(); sleep(1); connect_to_database(); }
function erro($msg, $id_conn) { echo json_encode(array('id' => '-1', 'msg' => $msg)); execute_query("END TRANSACTION", $id_conn); execute_query("ROLLBACK", $id_conn); close_database($id_conn); return; }