Esta sección te permite ver todos los mensajes escritos por este usuario. Ten en cuenta que sólo puedes ver los mensajes escritos en zonas a las que tienes acceso en este momento.
CitarScreen 0: minimum 320 x 200, current 1920 x 1080, maximum 16384 x 16384
DisplayPort-0 disconnected (normal left inverted right x axis y axis)
HDMI-0 connected 1920x1080+0+0 (normal left inverted right x axis y axis) 510mm x 290mm
1920x1080 60.0*+
1680x1050 59.9
1400x1050 59.9
1600x900 60.0
1280x1024 75.0 60.0
1440x900 59.9
1280x800 59.9
1152x864 75.0
1280x720 60.0
1024x768 75.1 60.0
832x624 74.6
800x600 75.0 60.3 56.2
640x480 75.0 60.0
720x400 70.1
DVI-0 connected 1920x1080+0+0 (normal left inverted right x axis y axis) 510mm x 290mm
1920x1080 60.0*+ 50.0 59.9
1920x1080i 60.1 50.0 60.0
1680x1050 59.9
1400x1050 59.9
1600x900 60.0
1280x1024 60.0
1440x900 59.9
1280x800 59.9
1152x864 60.0
1280x720 60.0 50.0 59.9
1024x768 60.0
800x600 60.3
720x576 50.0
720x480 60.0 59.9
640x480 60.0 59.9
DVI-1 connected 1920x1080+0+0 (normal left inverted right x axis y axis) 510mm x 290mm
1920x1080 60.0*+ 50.0 59.9
1920x1080i 60.1 50.0 60.0
1680x1050 59.9
1400x1050 59.9
1600x900 60.0
1280x1024 60.0
1440x900 59.9
1280x800 59.9
1152x864 60.0
1280x720 60.0 50.0 59.9
1024x768 60.0
800x600 60.3
720x576 50.0
720x480 60.0 59.9
640x480 60.0 59.9
SELECT user_uploads.*, -- esta es la tabla de las imagenes
(SELECT COUNT(*) FROM img_likes WHERE img_id = user_uploads.imgID) AS total_likes
FROM user_uploads
ORDER BY up_time DESC
$total_likes = $ItemInfo['total_likes'];SELECT
uu.*,
m.*,
(
SELECT COUNT(t.*)
FROM img_likes t
WHERE t.img_id = uu.imgID AND t.user_id = ?
) AS user_likes,
(
SELECT COUNT(t.*)
FROM img_likes t
WHERE t.img_id = uu.imgID
) AS total_likes
FROM user_uploads uu
INNER JOIN members m ON m.id = uu.user_id
ORDER BY uu.up_time DESCSELECT user_uploads.* AS uu, members.*, COUNT(img_id, user_id) AS usr_liked, COUNT(img_id) AS total_likes
FROM user_uploads
INNER JOIN members AS m ON m.id = uu.user_id -- owner info
INNER JOIN img_likes AS il ON il.img_id = uu.imgID AND il.user_id = ? -- check if logged in user already liked
INNER JOIN img_likes AS ilt ON ilt.img_id = uu.imgID -- total likes
GROUP BY img_id, user_id
ORDER BY up_time DESCif ($stmt = $mysqli->prepare("SELECT user_uploads.* AS uu, members.*, COUNT(img_id, user_id) AS usr_liked, COUNT(img_id) AS total_likes
FROM user_uploads
INNER JOIN members AS m ON m.id = uu.user_id
INNER JOIN img_likes AS il ON il.img_id = uu.imgID AND il.user_id = ?
INNER JOIN img_likes AS ilt ON ilt.img_id = uu.imgID
GROUP BY img_id, user_id
ORDER BY up_time DESC")) {
$stmt->bind_param('i', $id);
$Items = $stmt->execute(); // get photos
foreach ($Items as $ItemInfo) {
$liked = mysqli_num_rows($Items); // como hacerlo ahora?
$total_likes = mysqli_num_rows($Items);
$img_id = $aItemInfo['img_id'];
if ($liked == 0) {
$like = 'Me gusta';
}
else if ($liked == 1) {
$like = 'Ya no me gusta';
}
$photo_list .= '
// lista de fotos
// boton like
<span class="total_likes" id="lik' . $status_id . '">' . $totallikes . '</span>
<a id="' . $total_likes . '" class="likes">' . $like . '</a>
';
}
}if ($db_password == $password) {
// Password is correct!
// Get the user-agent string of the user.
$user_browser = $_SERVER['HTTP_USER_AGENT'];
// XSS protection as we might print this value
$user_id = preg_replace("/[^0-9]+/", "", $user_id);
$_SESSION['user_id'] = $user_id;
// XSS protection as we might print this value
$username = preg_replace("/[^a-zA-Z0-9_\-]+/", "", $username);
$_SESSION['username'] = $username;
// XSS protection as we might print this value
$acc_type = preg_replace("/[^a-zA-Z0-9_\-]+/", "", $acc_type);
$_SESSION['acc_type'] = $acc_type;
$_SESSION['pwd_changed'] = $pwd_changed;
$_SESSION['login_string'] = hash('sha512',
$password . $user_browser);
// Login successful.
$last_ip = get_ip_address();
$mysqli->query("UPDATE members SET last_ip='{$last_ip}' WHERE id='{$user_id}'");
return true;
}function sec_session_start() {
$session_name = 'sec_session_id'; // Set a custom session name
$secure = SECURE;
// This stops javascript being able to access the session id.
$httponly = true;
// Forces sessions to only use cookies.
if (ini_set('session.use_only_cookies', 1) === FALSE) {
header("Location: /error?err=No se pudo iniciar una sesión segura (ini_set)");
exit();
}
// Gets current cookies params.
$cookieParams = session_get_cookie_params();
session_set_cookie_params($cookieParams["lifetime"],
$cookieParams["path"],
$cookieParams["domain"],
$secure,
$httponly);
// Sets the session name to the one set above.
session_name($session_name);
session_start(); // Start the PHP session
session_regenerate_id(); // regenerated the session, delete the old one.
}// Unset all session values
$_SESSION = array();
// get session parameters
$params = session_get_cookie_params();
// Delete the actual cookie.
setcookie(session_name(),
'', time() - 42000,
$params["path"],
$params["domain"],
$params["secure"],
$params["httponly"]);
// Destroy session
session_destroy();
header('Location: /home');