function __construct($ter)
{
parent::__construct();
require_once 'connexio.php';
$bd = new connexio();
$bd->query("INSERT INTO territori (territori) VALUES ('" . utf8_decode($ter) . "')");
$bd->close();
}
function __construct($cat)
{
parent::__construct();
require_once 'connexio.php';
$bd = new connexio();
$bd->query("INSERT INTO categoria (categoria) VALUES ('" . utf8_decode($cat) . "')");
$bd->close();
}
public function llistar()
{
require_once 'connexio.php';
include_once '../lang.php';
global $lang;
$bd = new connexio();
$usuaris = $bd->query("SELECT id,nom,cognoms,correu FROM usuaris ORDER BY id");
while ($usuari = $usuaris->fetch_array(MYSQLI_ASSOC)) {
echo '<tr><td>' . $usuari['id'] . '</td><td>' . utf8_encode($usuari['nom']) . ' ' . utf8_encode($usuari['cognoms']) . '</td><td>' . $usuari['correu'] . '</td><td><button type="button" class="btn btn-warning btn-xs" onclick="window.location.href=\'edituser.php?id=' . $usuari['id'] . '\'"><span class="glyphicon glyphicon-pencil"></span> ' . $lang['EDIT'] . '</button></td><td><button type="button" class="btn btn-danger btn-xs" onclick="if (confirm(\'' . $lang['CONFIRM_DELETE_USER'] . '\')){window.location.href=\'deleteuser.php?id=' . $usuari['id'] . '\'}"><span class="glyphicon glyphicon-trash"></span> ' . $lang['DELETE'] . '</button></td></tr>';
}
$bd->close();
}
public function view_all()
{
$db = new connexio();
$sql = "SELECT * FROM Partida_Enemigo;";
$query = $db->query($sql);
$rtn = array();
while ($obj = $query->fetch_assoc()) {
$Partida_Enemigo = new Partida_Enemigo($obj["id_enemigo"], $obj["id_partida"]);
//var_dump($Partida_Enemigo);
array_push($rtn, $Partida_Enemigo);
}
$db->close();
return $rtn;
}
public function view_all()
{
$db = new connexio();
$sql = "SELECT * FROM Usuari_Partida;";
$query = $db->query($sql);
$rtn = array();
while ($obj = $query->fetch_assoc()) {
$Usuari_Partida = new Usuari_Partida($obj["id_usuari"], $obj["id_partida"], $obj["master"]);
//var_dump($Usuari_Partida);
array_push($rtn, $Usuari_Partida);
}
$db->close();
return $rtn;
}
public function view_all()
{
$db = new connexio();
$sql = "SELECT * FROM Partida_Item;";
$query = $db->query($sql);
$rtn = array();
while ($obj = $query->fetch_assoc()) {
$Partida_Item = new Partida_Item($obj["id_partida"], $obj["id_item"]);
//var_dump($Usuari_Partida);
array_push($rtn, $Partida_Item);
}
$db->close();
return $rtn;
}
public function llistar()
{
require_once 'connexio.php';
$bd = new connexio();
$sql = "SELECT * FROM newsletter";
$n = $bd->query($sql);
$i = 1;
while ($news = $n->fetch_array(MYSQLI_ASSOC)) {
echo '<tr>';
echo "<td>" . $i . "</td>";
echo "<td>" . utf8_encode($news['nom']) . "</td>";
echo "<td>" . utf8_encode($news['cognoms']) . "</td>";
echo "<td>" . $news['correu'] . "</td>";
echo "</tr>";
$i++;
}
}
public function get_all($id)
{
$db = new connexio();
$sql = "SELECT * FROM Enemigo WHERE id_enemigo = '{$id}'";
$query = $db->query($sql);
$count = 0;
$datos = "";
if ($query->num_rows > 0) {
while ($row = $query->fetch_assoc()) {
$count++;
$datos = $row;
}
} else {
$count = 0;
}
$db->close();
if ($count == 1) {
return $datos;
} else {
return null;
}
}
<?php
$id = $_REQUEST['id'];
$url = $_REQUEST['url'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET url={$url} WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("DELETE from usuaris WHERE id={$id}");
$bd->close();
header('Location: index2.php');
<?php
session_start();
$nom = utf8_decode(filter_input(INPUT_POST, 'nom'));
$cognom = utf8_decode(filter_input(INPUT_POST, 'cognom'));
$edat = filter_input(INPUT_POST, 'edat');
$pais = utf8_decode(filter_input(INPUT_POST, 'pais'));
$correu = filter_input(INPUT_POST, 'correu');
$tipus = filter_input(INPUT_POST, 'tipus');
$contrasenya = filter_input(INPUT_POST, 'contrasenya');
require_once 'class/connexio.php';
$encriptada = crypt($contrasenya);
$sql = "INSERT INTO usuaris(nom,cognom,edat,pais,correu,tipus,contrasenya) VALUES ('{$nom}','{$cognom}',{$edat},'{$pais}','{$correu}','{$tipus}','{$encriptada}')";
$sqlcheck = "SELECT id FROM usuaris WHERE correu='{$correu}'";
$db = new connexio();
$a = $db->query($sqlcheck);
if ($a->num_rows === 0) {
if ($db->query($sql)) {
$iduser = $db->insert_id;
setcookie('personatge[id]', $iduser);
setcookie('personatge[nom]', $nom);
setcookie('personatge[cognom]', $cognom);
setcookie('personatge[tipus]', $tipus);
switch ($tipus) {
case 'lite':
$sqlfoto = "INSERT INTO fotos (usuari,foto,llegenda) VALUES ('{$iduser}','fotos/{$tipus}/M40A9006.jpg','Foto: Salvador Maluquer.'),('{$iduser}','M40A9028.jpg','Foto: Salvador Maluquer.'),('{$iduser}','Tortosa_026.jpg','Foto: Archivo General Militar de Ávila.')";
$db->query($sqlfoto);
$sqlvideo = "INSERT INTO videos (usuari,video,llegenda) VALUES " . "('{$iduser}','videos/{$tipus}/GuillermoBores_RegressioPerduaPerSempre','Guillermo Borés, propietari de la part privada de l’illa de Buda, explica quina és la principal característica de l’indret: la seva fragilitat.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_ArrivadaDelta','Josep M. Espinàs explica quina va ser la seva sensació en trepitjar per primer cop el Delta després de setmanes seguint el curs de l’Ebre.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_GranExperienciaBuda','Josep M. Espinàs recorda la seva experiència en penetrar a l’illa de Buda.')," . "('{$iduser}','videos/{$tipus}/JMEspinas_SensacioForaster','Josep M. Espinàs recorda les seves sensacions a la platja de l’illa de Buda.')";
$db->query($sqlvideo);
$sqltextos = "INSERT INTO textos (usuari,imatge,url) VALUES ('{$iduser}','textos/{$tipus}/Arbo.jpg','textos/{$tipus}/Arbo.html')," . "('{$iduser}','textos/{$tipus}/Blade.jpg','textos/{$tipus}/Blade.html')," . "('{$iduser}','textos/{$tipus}/Espinas.jpg','textos/{$tipus}/Espinas.html')";
$db->query($sqltextos);
<?php
$videoid = $_REQUEST['i'];
$d = $_REQUEST['d'];
require_once 'classes/connexio.php';
require_once 'classes/videos.php';
require_once './lang.php';
$v = new video();
$v->seleccionar($videoid);
$bd = new connexio();
$dades = $bd->query("SELECT nom FROM empresa LIMIT 1");
$empresa = $dades->fetch_array(MYSQLI_ASSOC);
$bd->close();
?>
<script>
function tancar(){
$(".desc").hide("slow",function(){
$(".desc").remove();
});
$(".descexistent").hide("slow",function(){
$(".descexistent").remove();
});
history.pushState('', document.title, window.location.pathname);
document.title = "<?php
echo $empresa['nom'];
<?php
require_once 'class/connexio.php';
$db = new connexio();
$per = $_COOKIE['personatge'];
switch ($per['tipus']) {
case 'lite':
$c = 'groc';
break;
case 'cine':
$c = 'blau';
break;
case 'foto':
$c = 'roig';
break;
case 'orni':
$c = 'verd';
break;
}
$f = $db->query('SELECT * FROM fotos WHERE usuari=' . $per['id']);
$v = $db->query('SELECT * FROM videos WHERE usuari=' . $per['id']);
$t = $db->query('SELECT * FROM textos WHERE usuari=' . $per['id']);
$apac = $db->query('SELECT * FROM ap_actual WHERE usuari=' . $per['id']);
$apfi = $db->query('SELECT * FROM ap_final WHERE usuari=' . $per['id']);
?>
<div class="col-lg-offset-1 col-md-offset-1 col-lg-10 col-md-10 col-sm-12 dossierapartat">
<div class="blau">
<img src="img/tancar.png" alt="icona tancar" onclick="tancarvideo()"/>
</div>
<h1>Llibreta de viatge</h1>
<div id="objectes" class="col-md-12">
<?php
ob_start();
session_start();
require_once '../classes/connexio.php';
require_once '../classes/videos.php';
if (isset($_SESSION['id'])) {
$id = $_REQUEST['id'];
$bd = new connexio();
$dades = $bd->query("SELECT nom FROM empresa LIMIT 1");
$empresa = $dades->fetch_array(MYSQLI_ASSOC);
$v = new video();
$v->seleccionar($id);
require_once '../lang.php';
?>
<!DOCTYPE html>
<html>
<head>
<title><?php
echo $empresa['nom'];
?>
</title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/style.css">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script>
<script src="js/scripts.js" type="text/javascript"></script>
<script>
<?php
session_start();
// Recollida de dades
$msg = filter_input(INPUT_POST, 'missatge');
$fot = filter_input(INPUT_POST, 'fotografia');
$per = $_COOKIE['personatge']['id'];
$dat = date("Y-m-d H:i:s");
$lik = 0;
$val = 1;
require_once 'class/connexio.php';
$db = new connexio();
$msg = $db->real_escape_string($msg);
$sql = "INSERT INTO mur(comentari,foto,data,usuari,validat) VALUES ('" . utf8_decode($msg) . "','{$fot}','{$dat}',{$per},{$val})";
if ($db->query($sql)) {
$user = $_COOKIE['personatge'];
switch ($user['tipus']) {
case 'lite':
$c = 'groc';
break;
case 'cine':
$c = 'blau';
break;
case 'foto':
$c = 'roig';
break;
case 'orni':
$c = 'verd';
break;
}
?>
<?php
$id = $_REQUEST['id'];
$cat = $_REQUEST['cat'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET categoria='" . utf8_decode($cat) . "' WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
$r = $_REQUEST['r'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET referit2='" . utf8_decode($r) . "' WHERE id={$id}");
$bd->close();
<?php
$thumb = $_FILES['imatge']['name'];
$thumbtemp = $_FILES['imatge']['tmp_name'];
$arxiu = $_SERVER['DOCUMENT_ROOT'] . '/media/' . $thumb;
$id = $_REQUEST['id'];
if (move_uploaded_file($thumbtemp, $arxiu)) {
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET imatge='{$thumb}' WHERE id={$id}");
$bd->close();
echo 'OK';
header("Location: //{$_SERVER['HTTP_HOST']}/login/editvideo.php?id={$id}");
} else {
echo 'Error';
}
switch ($per['tipus']) {
case 'lite':
$c = 'groc';
break;
case 'cine':
$c = 'blau';
break;
case 'foto':
$c = 'roig';
break;
case 'orni':
$c = 'verd';
break;
}
require_once 'class/connexio.php';
$db = new connexio();
$f = $db->query('SELECT * FROM fotos WHERE usuari=' . $per['id']);
$v = $db->query('SELECT * FROM videos WHERE usuari=' . $per['id']);
$t = $db->query('SELECT * FROM textos WHERE usuari=' . $per['id']);
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Buda, l'illa del Delta</title>
<meta name="description" content="Documental interactiu sobre Buda, la illa del Delta">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="css/estil.css" rel="stylesheet" type="text/css"/>
<link href="css/registre.css" rel="stylesheet" type="text/css"/>
<?php
$id = $_REQUEST['id'];
$desc = $_REQUEST['desc'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET descripcio='" . utf8_decode(addslashes($desc)) . "' WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
$l = $_REQUEST['l'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET latitud='{$l}' WHERE id={$id}");
$bd->close();
<?php
}
?>
<li><a href="#" id="menu1"><img src="img/menu-menu.png" alt="menú"/></a></li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<!--Fi capçalera-->
<!--Menú lateral-->
<div id="m"></div>
<!--Fi menú lateral-->
<div class="col-lg-offset-1 col-md-offset-1 col-lg-10 col-md-10 col-sm-12 col-xs-12">
<?php
$db = new connexio();
$i = 0;
while ($msg = $msgs->fetch_array(MYSQLI_ASSOC)) {
$query = "SELECT nom,cognom FROM usuaris WHERE id=" . $msg['usuari'];
$us = $db->query($query);
$u = $us->fetch_array(MYSQLI_ASSOC);
$dia = new DateTime($msg['data']);
?>
<div class="col-lg-3 col-md-3 col-sm-12 col-xs-12">
<div class="fotomur text-center">
<img src="<?php
echo $msg['foto'];
?>
" alt="Imatge del mur" class="fotom">
<img src="img/polaroid.png" alt="Superposició" class="polaroid"/>
public function test3($var)
{
$db = new connexio();
$sql = "SELECT * FROM Usuari WHERE telefon= '{$var}';";
$query = $db->query($sql);
if ($query->num_rows > 0) {
while ($row = $query->fetch_assoc()) {
$res = true;
}
} else {
$res = false;
}
$db->close();
return $res;
}
<?php
$id = $_REQUEST['id'];
$title = $_REQUEST['title'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET titol='" . utf8_decode(addslashes($title)) . "' WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
$ln = $_REQUEST['ln'];
$p = $_REQUEST['p'];
require_once '../classes/connexio.php';
$bd = new connexio();
switch ($p) {
case "0":
$bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='0',pastillanegra='0' WHERE id={$id}");
break;
case "1":
$bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='1',pastillanegra='0' WHERE id={$id}");
break;
case "2":
$bd->query("UPDATE videos SET lletranegra='{$ln}',pastillablanca='0',pastillanegra='1' WHERE id={$id}");
break;
}
$bd->query("UPDATE videos SET referit1='" . utf8_decode($r) . "' WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
$a = $_REQUEST['a'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("UPDATE videos SET autorvideo='" . utf8_decode($a) . "' WHERE id={$id}");
$bd->close();
<?php
$id = $_REQUEST['id'];
require_once '../classes/connexio.php';
$bd = new connexio();
$bd->query("DELETE from videos WHERE id={$id}");
$bd->close();
header('Location: index2.php');
</a></li>
<li><a href="#categories" data-toggle="tab"><?php
echo $lang['MANAGE_CATEGORY'];
?>
</a></li>
<li><a href="#territoris" data-toggle="tab"><?php
echo $lang['MANAGE_TERRITORY'];
?>
</a></li>
<li><a href="#newsletter" data-toggle="tab">Newsletter</a></li>
</ul>
<div id="contingut" class="tab-content">
<div id="home" class="tab-pane col-md-12">
<?php
include_once '../classes/connexio.php';
$bd = new connexio();
$dades = $bd->query("SELECT * FROM empresa WHERE id=1");
$empresa = $dades->fetch_array(MYSQLI_ASSOC);
?>
<img class="img-responsive imgprincipal center-block" src="../media/<?php
echo $empresa['logo'];
?>
" alt="Logo empresa"/>
</div>
<div class="tab-pane col-md-6 col-md-offset-3" id="insertar">
<form id="fnouvideo" class="form" method="post" enctype="multipart/form-data" accept-charset="UTF-8" action="insertavideo.php">
<input type="text" class="form-control" name="url" placeholder="<?php
echo $lang['URL'];
?>
">
<input type="text" class="form-control" name="titol" placeholder="<?php
public function seleccionar($id)
{
require_once 'connexio.php';
$bd = new connexio();
$sql = "SELECT * FROM videos WHERE id = {$id} LIMIT 1";
$consulta = $bd->query($sql);
$video = $consulta->fetch_array(MYSQLI_ASSOC);
$this->setId($video['id']);
$this->setUrl($video['url']);
$this->setTitol($video['titol']);
$this->setCategoria($video['categoria']);
$this->setTerritori($video['territori']);
$this->setDescripcio($video['descripcio']);
$this->setAutor($video['autor']);
$this->setAutorVideo($video['autorvideo']);
$this->setData($video['data']);
$this->setImatge($video['imatge']);
if ($video['lletranegra'] != 0) {
$this->setLletraNegra(1);
} else {
$this->setLletraNegra(0);
}
if ($video['pastillablanca'] != 0) {
$this->setPastillaBlanca(1);
} else {
$this->setPastillaBlanca(0);
}
if ($video['pastillanegra'] != 0) {
$this->setPastillaNegra(1);
} else {
$this->setPastillaNegra(0);
}
$this->setTags($video['tags']);
$this->setReferit1($video['referit1']);
$this->setLatitud($video['latitud']);
$this->setLongitud($video['longitud']);
$bd->close();
}
<?php
session_start();
$url = $_GET['url'];
$correu = filter_input(INPUT_POST, 'correu');
$contrasenya = filter_input(INPUT_POST, 'contrasenya');
require_once 'class/connexio.php';
$sql = "SELECT * FROM usuaris WHERE correu='{$correu}'";
$db = new connexio();
$data = $db->query($sql);
$db->close;
$usuari = $data->fetch_array(MYSQLI_ASSOC);
if ($a->num_rows === 0) {
echo 'Usuari no existeix, torna a entrar i registra\'t';
} else {
if (crypt($usuari['contrasenya'] == $contrasenya, $usuari['contrasenya'])) {
setcookie('personatge[id]', $usuari['id']);
setcookie('personatge[nom]', $usuari['nom']);
setcookie('personatge[cognom]', $usuari['cognom']);
setcookie('personatge[tipus]', $usuari['tipus']);
setcookie('personatge[sexe]', $usuari['sexe']);
if (isset($url)) {
header('Location: ' . $url);
} else {
header('Location: inici.php');
}
} else {
echo 'Contrasenya incorrecta';
}
}
