Object type: Stored Procedure (MS-SQL)
Parent: CustomerDBSQL
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
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
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