function eliminar_grupo($group)
{
include_once 'conexion.php';
$conn = cogerConexion();
//elimnar gente perteneciente al grupo
$sql = "select user_id from groups_users where group_id = {$group}";
$result = mysqli_query($conn, $sql);
print_r($result);
$querys = "";
foreach ($result as $a) {
$querys .= "delete from groups_users where group_id = " . $group . " and user_id = " . $a['user_id'] . ";";
}
$porciones = explode(";", $querys);
for ($j = 0; $j < count($porciones) - 1; $j++) {
$result = mysqli_query($conn, $porciones[$j]);
}
// elimnar grupo
$sql = "DELETE from groups where id = {$group}";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
$conn->close();
}
function traer_ficheos_eventos($evento)
{
include_once 'conexion.php';
$conn = cogerConexion();
$sql = "SELECT * FROM files WHERE event_id = {$evento}";
$result = mysqli_query($conn, $sql);
return $result;
}
<?php
session_start();
if (isset($_POST["add"])) {
include_once 'conexion.php';
$conn = cogerConexion();
$sql = "SELECT * FROM groups_users WHERE user_id= " . $_POST['usuarioAdd'] . " and group_id = " . $_SESSION['idGrupo'];
$result = mysqli_query($conn, $sql) or die("Error: " . mysqli_error($conn));
if (!mysqli_num_rows($result) > 0) {
//no a sido invitado
include_once './accionesGrupos.php';
add_contacto($_SESSION['idGrupo'], $_POST['usuarioAdd']);
}
header('location: addcontactos.php');
}
<?php
include_once 'conexion.php';
$activation_key = $_GET["activation"];
$dbh = cogerConexion();
// Busca la entrada en la tabla de usuarios para la clave de activación recibida
$stm = $dbh->prepare("select count(*) from users where activation_key=?");
$stm->bind_param("s", $activation_key);
$stm->bind_result($total);
$message = "";
$stm->execute();
$stm->fetch();
$stm->close();
if ($total == 1) {
// Si se ha encontrado...
// Retrieve the email address
$stm = $dbh->prepare("select email from users where activation_key=?");
$stm->bind_param("s", $activation_key);
$stm->bind_result($email);
$stm->execute();
$stm->fetch();
$stm->close();
$stm = $dbh->prepare("update users set active='y' , habilitado= 'y' where activation_key = ? and email = ?");
$stm->bind_param("ss", $activation_key, $email);
$stm->execute();
$stm->close();
header('location: success.php');
}
function comprobar_pass($pass, $userid)
{
//comprobar si la pass que introduzco es la misma que tiene
include_once 'conexion.php';
$conn = cogerConexion();
$sql = "SELECT password FROM users WHERE id = {$userid}";
$rec = mysqli_query($conn, $sql);
$count = 0;
$row = mysqli_fetch_array($rec);
if (strcmp($row['password'], sha1($pass)) == 0) {
return 1;
//son iguales
} else {
return 2;
//no son iguales
}
}
function traer_usuario_editar($id)
{
require_once 'conexion.php';
$conn = cogerConexion();
$sql = "SELECT * FROM users WHERE id='{$id}'";
$result = mysqli_query($conn, $sql);
return mysqli_fetch_array($result);
}
function eliminar_evento($evento)
{
include_once 'conexion.php';
$conn = cogerConexion();
//elimnar gente invitada al evento
$sql = "select user_id from events_users where event_id = {$evento}";
$result = mysqli_query($conn, $sql);
$querys = "";
foreach ($result as $a) {
$querys .= "delete from events_users where event_id = " . $evento . " and user_id = " . $a['user_id'] . ";";
}
$porciones = explode(";", $querys);
for ($j = 0; $j < count($porciones) - 1; $j++) {
$result = mysqli_query($conn, $porciones[$j]);
}
//elimnar archivos pertenecientes al evento
$sql = "select id, url from files where event_id = {$evento}";
$result = mysqli_query($conn, $sql);
$querys = "";
foreach ($result as $a) {
$querys .= "delete from files where id = " . $a['id'] . ";";
unlink($a['url']);
//borramos archivos del servidor
}
$porciones = explode(";", $querys);
for ($j = 0; $j < count($porciones) - 1; $j++) {
$result = mysqli_query($conn, $porciones[$j]);
}
$sql = "DELETE from events where id = {$evento}";
if ($conn->query($sql) === TRUE) {
echo "Record updated successfully";
} else {
echo "Error updating record: " . $conn->error;
}
$conn->close();
}
