mirror of
https://github.com/WhatCD/Gazelle.git
synced 2024-12-12 18:36:29 +00:00
39 lines
1.2 KiB
PHP
39 lines
1.2 KiB
PHP
<?
|
|
// perform the back end of subscribing to collages
|
|
authorize();
|
|
|
|
if (!is_number($_GET['collageid'])) {
|
|
error(0);
|
|
}
|
|
|
|
$CollageID = (int)$_GET['collageid'];
|
|
|
|
if (!$UserSubscriptions = $Cache->get_value('collage_subs_user_'.$LoggedUser['ID'])) {
|
|
$DB->query('
|
|
SELECT CollageID
|
|
FROM users_collage_subs
|
|
WHERE UserID = '.db_string($LoggedUser['ID']));
|
|
$UserSubscriptions = $DB->collect(0);
|
|
$Cache->cache_value('collage_subs_user_'.$LoggedUser['ID'], $UserSubscriptions, 0);
|
|
}
|
|
|
|
if (($Key = array_search($CollageID, $UserSubscriptions)) !== false) {
|
|
$DB->query('
|
|
DELETE FROM users_collage_subs
|
|
WHERE UserID = '.db_string($LoggedUser['ID'])."
|
|
AND CollageID = $CollageID");
|
|
unset($UserSubscriptions[$Key]);
|
|
Collages::decrease_subscriptions($CollageID);
|
|
} else {
|
|
$DB->query("
|
|
INSERT IGNORE INTO users_collage_subs
|
|
(UserID, CollageID, LastVisit)
|
|
VALUES
|
|
($LoggedUser[ID], $CollageID, NOW())");
|
|
array_push($UserSubscriptions, $CollageID);
|
|
Collages::increase_subscriptions($CollageID);
|
|
}
|
|
$Cache->replace_value('collage_subs_user_'.$LoggedUser['ID'], $UserSubscriptions, 0);
|
|
$Cache->delete_value('collage_subs_user_new_'.$LoggedUser['ID']);
|
|
$Cache->delete_value("collage_$CollageID");
|