Differences

This shows you the differences between two versions of the page.

--- internal.dbsql:customerdbsql:sp.spccpsetsocialnetworkinfo [2024/03/25 12:18]
Radu Butarascu
+++ internal.dbsql:customerdbsql:sp.spccpsetsocialnetworkinfo [2024/04/03 11:09] (current)
Radu Butarascu [4/3/2024]
@@ Line 3: / Line 3: @@
 Object type: Stored Procedure (MS-SQL)\\
 Parent: [[internal:dbsql:customerdbsql:start|CustomerDBSQL]]
-\\ \\
+===== 4/3/2024 =====
 <code sql>
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+-- =============================================
+-- Author:	www.allshore.us, Radu Butarascu
+-- Last update: 9/8/2011, 3/25/2024, 4/3/2024
+-- Description:	This procedure saves social media and contact links in CCP legacy.
+-- Pages that use this are SocialNetworkingLinks.aspx and AppSocialNetworking.aspx
+-- =============================================
+ALTER PROCEDURE [dbo].[spCCPSetSocialNetworkInfo]
+(
+	@CallLtr	varchar(40),
+	@SocialNetworkFacebook	varchar(255),
+	@SocialNetworkTwitter	varchar(255),
+	@SocialNetworkYouTube	varchar(255),
+	@SocialNetworkInstagram	varchar(255),
+    @SocialNetworkSnapchat	varchar(255),
+    @SocialNetworkTikTok	varchar(255),
+	@RequestEmail varchar(255),
+	@ContactPhone varchar(15)
+)
+AS
+BEGIN
+	UPDATE Stations
+	SET	SocialNetworkFacebook = @SocialNetworkFacebook,
+		SocialNetworkTwitter = @SocialNetworkTwitter,
+		SocialNetworkYouTube = @SocialNetworkYouTube,
+		SocialNetworkInstagram = @SocialNetworkInstagram,
+        SocialNetworkSnapchat = @SocialNetworkSnapchat,
+        SocialNetworkTikTok = @SocialNetworkTikTok,
+        RequestEmail = @RequestEmail,
+        ContactPhone = @ContactPhone
+	WHERE [CALL LTR] = @CallLtr
+	SELECT @@ROWCOUNT
+END
+GO
+</code>
+===== 3/25/2024 =====
+<code sql>
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+-- =============================================
+-- Author:	www.allshore.us, Radu Butarascu
+-- Last update: 9/8/2011, 3/25/2024
+-- Description:	This procedure saves social media and contact links in CCP legacy.
+-- Pages that use this are SocialNetworkingLinks.aspx and AppSocialNetworking.aspx
+-- =============================================
+ALTER Procedure [dbo].[spCCPSetSocialNetworkInfo]
+(
+	@CallLtr	varchar(40),
+	@SocialNetworkFacebook	varchar(255),
+	@SocialNetworkTwitter	varchar(255),
+	@SocialNetworkYouTube	varchar(255),
+	@SocialNetworkInstagram	varchar(255),
+    @SocialNetworkSnapchat	varchar(255),
+    @SocialNetworkTikTok	varchar(255),
+	@RequestEmail varchar(255),
+	@ContactPhone varchar(15)
+)
+as
+begin
+	update Stations
+	set	SocialNetworkFacebook = @SocialNetworkFacebook,
+		SocialNetworkTwitter = @SocialNetworkTwitter,
+		SocialNetworkYouTube = @SocialNetworkYouTube,
+		SocialNetworkInstagram = @SocialNetworkInstagram,
+        SocialNetworkSnapchat = @SocialNetworkSnapchat,
+        SocialNetworkTikTok = @SocialNetworkTikTok
+	where [CALL LTR] = @CallLtr
+	update player
+	set RequestEmail = @RequestEmail
+	where [Call LTR] = @CallLtr
+	-- added 2015-07-08 by RADU
+	DECLARE @mpID INT
+	SET @mpID = (SELECT id FROM MobilePlayer WHERE [CallLTR] = @CallLtr)
+	IF @mpID IS NULL
+		BEGIN
+			INSERT INTO MobilePlayer (CallLTR, ContactPhone)
+				VALUES (@CallLtr, @ContactPhone)
+		END
+	ELSE
+		BEGIN
+			UPDATE MobilePlayer
+			SET ContactPhone = @ContactPhone
+				WHERE [CallLTR] = @CallLtr
+		END
+	Select @@ROWCOUNT
+end
+GO
+</code>
+===== 9/8/2011 =====
+<code sql>
+SET ANSI_NULLS ON
+GO
+SET QUOTED_IDENTIFIER ON
+GO
+-- =============================================
+-- Author:		www.allshore.us
+-- Last update: 9/8/2011
+-- Description:	This procedure will return the User Information based upon [Call ltr]
+-- =============================================
+CREATE Procedure [dbo].[spCCPSetSocialNetworkInfo]
+(
+	@CallLtr	varchar(40),
+	@SocialNetworkFacebook	varchar(255),
+	@SocialNetworkTwitter	varchar(255),
+	@SocialNetworkYouTube	varchar(255),
+	@SocialNetworkInstagram	varchar(255),
+	@RequestEmail varchar(255),
+	@ContactPhone varchar(15)
+)
+as
+begin
+declare @SocialNetworkFacebookEnabled	as bit
+declare @SocialNetworkTwitterEnabled	as bit
+declare @SocialNetworkYouTubeEnabled	as bit
+declare @SocialNetworkInstagramEnabled	as bit
+declare @RequestEmailOnPlayer	as bit
+if(len(@SocialNetworkFacebook) <> 0)
+	set @SocialNetworkFacebookEnabled = 1
+	else
+	set	@SocialNetworkFacebookEnabled = 0
+if(len(@SocialNetworkTwitter) <> 0)
+	set @SocialNetworkTwitterEnabled = 1
+	else
+	set	@SocialNetworkTwitterEnabled = 0
+if(len(@SocialNetworkYouTube) <> 0)
+	set @SocialNetworkYouTubeEnabled = 1
+	else
+	set	@SocialNetworkYouTubeEnabled = 0
+if(len(@SocialNetworkInstagram) <> 0)
+	set @SocialNetworkInstagramEnabled = 1
+	else
+	set	@SocialNetworkInstagramEnabled = 0
+if(len(@RequestEmail) <> 0)
+	set @RequestEmailOnPlayer = 1
+	else
+	set	@RequestEmailOnPlayer = 0
+	update Stations
+	set	SocialNetworkFacebook = @SocialNetworkFacebook,
+		SocialNetworkFacebookEnabled = @SocialNetworkFacebookEnabled,
+		SocialNetworkTwitter = @SocialNetworkTwitter,
+		SocialNetworkTwitterEnabled = @SocialNetworkTwitterEnabled,
+		SocialNetworkYouTube = @SocialNetworkYouTube,
+		SocialNetworkYouTubeEnabled = @SocialNetworkYouTubeEnabled,
+		SocialNetworkInstagram = @SocialNetworkInstagram,
+		SocialNetworkInstagramEnabled = @SocialNetworkInstagramEnabled
+	where [CALL LTR] = @CallLtr
+	update player
+	set RequestEmail = @RequestEmail,
+		RequestEmailOnPlayer = @RequestEmailOnPlayer
+	where [Call LTR] = @CallLtr
+	-- added 2015-07-08 by RADU
+	DECLARE @mpID INT
+	SET @mpID = (SELECT id FROM MobilePlayer WHERE [CallLTR] = @CallLtr)
+	IF @mpID IS NULL
+		BEGIN
+			INSERT INTO MobilePlayer (CallLTR, ContactPhone)
+				VALUES (@CallLtr, @ContactPhone)
+		END
+	ELSE
+		BEGIN
+			UPDATE MobilePlayer
+			SET ContactPhone = @ContactPhone
+				WHERE [CallLTR] = @CallLtr
+		END
+	Select @@ROWCOUNT
+end
+GO
 </code>

User Tools

Site Tools

Differences

Page Tools