public function logSearch($searchTerm, $searchType) { $userId = UsersController::getUserIdByHash(); $userId = $userId != null ? $userId : 0; //if no user is returned, the request will be logged as if the user_id = 0 was making the request. DB::insert('INSERT INTO ns_searches (user_id, search_term, type) VALUES (?, ?, ?)', [$userId, $searchTerm, $searchType]); }
public function deletePlaylist($playlistId) { $userId = UsersController::getUserIdByHash(); DB::delete('DELETE FROM ns_playlists WHERE (user_id = ? AND playlist_id = ?)', [$userId, $playlistId]); return DB::delete('DELETE FROM ' . T_PLAYLIST_TRACKS . ' WHERE playlist_id = ?', [$playlistId]); }
public function isExisting($releaseId) { $userId = UsersController::getUserIdByHash(); return DB::select('SELECT id FROM ' . T_SAVED_ALBUMS . ' WHERE user_id = ? AND id = ?', [$userId, $releaseId]); }