D7437.diff
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

D7437.diff
View Options

	diff --git a/keyserver/src/updaters/account-updaters.js b/keyserver/src/updaters/account-updaters.js
	--- a/keyserver/src/updaters/account-updaters.js
	+++ b/keyserver/src/updaters/account-updaters.js
	@@ -127,13 +127,25 @@
	UPDATE uploads
	SET container = NULL
	WHERE uploader = ${viewer.userID}
	- AND container = ${viewer.userID};
	+ AND container = ${viewer.userID}
	+ AND (
	+ ${mediaID} IS NULL
	+ OR EXISTS (
	+ SELECT 1
	+ FROM uploads
	+ WHERE id = ${mediaID}
	+ AND uploader = ${viewer.userID}
	+ AND container IS NULL
	+ AND thread IS NULL
	+ )
	+ );

	UPDATE uploads
	SET container = ${viewer.userID}
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	- AND container IS NULL;
	+ AND container IS NULL
	+ AND thread IS NULL;

	UPDATE users
	SET avatar = ${newAvatarValue}
	@@ -146,6 +158,7 @@
	WHERE id = ${mediaID}
	AND uploader = ${viewer.userID}
	AND container = ${viewer.userID}
	+ AND thread IS NULL
	)
	);