public function saveAlbumData($albumID, $userID, $albumOld, $fields, $extra = array()) { // Is this a new album? if (!$albumID) { $extra['post_date'] = date_helper::now(); } // Do we have user id? if ($userID) { $extra['user_id'] = $userID; } // Save album if (!($newAlbumID = $this->fields_model->saveValues('picture_album', $albumID, $albumOld, $fields, $extra))) { return 0; } // Update counters if ($userID) { // Is this a new album? if (!$albumID) { $this->db->query("UPDATE `:prefix:users` SET `total_albums`=`total_albums`+1 WHERE `user_id`=? LIMIT 1", array($userID)); } } // Did we add a new album or privacy setting changed? if (!$albumID || $extra['privacy'] != $albumOld['privacy']) { // Clean up counters $this->counters_model->deleteCounters('user', $albumID ? $albumOld['user_id'] : $userID); } if ($albumID) { // Update timeline action timeline_helper::update(true, 'picture_post', $albumOld['user_id'], $newAlbumID, false, $extra['privacy']); // Action hook hook::action('pictures/albums/update', $newAlbumID, $extra); } else { // Action hook hook::action('pictures/albums/insert', $newAlbumID, $extra); } return $newAlbumID; }
public function toggleAdStatus($adID, $userID, $ad, $status = 1) { // Are you trying to assign the same status? if ($ad['active'] == $status) { return true; } // Update status $this->db->query("UPDATE `:prefix:classifieds_data` SET `active`=? WHERE `ad_id`=? LIMIT 1", array($status, $adID)); // Update counters if ($status == 1) { $this->db->query("UPDATE `:prefix:users` SET `total_classifieds`=`total_classifieds`+1, `total_classifieds_i`=`total_classifieds_i`-1 WHERE `user_id`=? LIMIT 1", array($userID)); } elseif ($ad['active'] != 9) { $this->db->query("UPDATE `:prefix:users` SET `total_classifieds`=`total_classifieds`-1, `total_classifieds_i`=`total_classifieds_i`+1 WHERE `user_id`=? LIMIT 1", array($userID)); } // Update timeline action timeline_helper::update(true, 'classified_ad_post', $ad['user_id'], $adID, $status); // Action hook hook::action('classifieds/status/update', $adID, $status); // Clean up counters $this->counters_model->deleteCounters('user', $userID); return true; }
public function togglePictureStatus($pictureID, $albumID, $userID, $picture, $album, $status = 1) { // Are you trying to assign the same status? if ($picture['active'] == $status) { return true; } // Update status $this->db->query("UPDATE `:prefix:pictures_data` SET `active`=? WHERE `picture_id`=? LIMIT 1", array($status, $pictureID)); // Update counters if ($status == 1) { $this->db->query("UPDATE `:prefix:pictures_albums_data` SET `total_pictures`=`total_pictures`+1, `total_pictures_i`=`total_pictures_i`-1 WHERE `album_id`=? LIMIT 1", array($albumID)); $this->db->query("UPDATE `:prefix:users` SET `total_pictures`=`total_pictures`+1, `total_pictures_i`=`total_pictures_i`-1 WHERE `user_id`=? LIMIT 1", array($userID)); } elseif ($picture['active'] != 9) { $this->db->query("UPDATE `:prefix:pictures_albums_data` SET `total_pictures`=`total_pictures`-1, `total_pictures_i`=`total_pictures_i`+1 WHERE `album_id`=? LIMIT 1", array($albumID)); $this->db->query("UPDATE `:prefix:users` SET `total_pictures`=`total_pictures`-1, `total_pictures_i`=`total_pictures_i`+1 WHERE `user_id`=? LIMIT 1", array($userID)); } // Update timeline action timeline_helper::update(true, 'picture_post', $userID, $albumID, $status); // Action hook hook::action('pictures/status/update', $pictureID, $albumID, $status); return true; }
public function toggleVerifiedStatus($userID, $user, $status = 1) { // Are you trying to assign the same status? if ($user['verified'] == $status) { return false; } // Update status $this->db->query("UPDATE `:prefix:users` SET `verified`=? WHERE `user_id`=? LIMIT 1", array($status, $userID)); // Update timeline action timeline_helper::update(true, 'user_signup', $userID, $userID, isset($user['active']) && $user['active'] && $status ? 1 : 0); // Action hook hook::action('users/verified/' . ($status ? 'approve' : 'decline'), $userID); return true; }