/*
작성자 : 한영민
작성일 : 2003-11-04
설 명 : 각 사용자가 로그인 했을때 러브의 배경음악 선물, 프로포즈를 확인 할수 있게 함
*/
ALTER Procedure dbo.music_getBiz_sp
@UserID NVarchar(12) = 'system'
AS
DECLARE @effectRow INT, @strUserID NVarchar(12)
IF @UserID = 'system'
Goto Err
Select mp_CD , file_Code, Song_Subject ,Artist_Name,PrimaryUserID = @strUserID , Message, RegDate, Biztype, mp.Pro_Gender
From musicBiz_tbl AS mb INNER JOIN meet_profile AS mp
ON mb.PrimaryUserID = mp.Pro_ID
Where ForeignUserID = @UserID and active = 1
SELECT mp.pro_Photo, mp.Pro_ID, Pro_Age
, dbo.fn_GetGender(Pro_Gender) AS Pro_Genders
, dbo.fn_GetUser_Area(SubString(Pro_Profile, 2, 1)) AS AREA
, Pro_Gender
FROM meet_profile AS mp INNER JOIN meet_AlbumPhoto AS map ON mp.Pro_ID=map.Pro_ID
Where map.Apt_Admin = 1 and Apt_View = 1 and mp.Pro_ID = @strUserID
IF @@Error <> 0 Goto Err
Execute @effectRow = music_setBiz_Confirm_sp @UserID
IF @effectRow = 0 Goto Err
return 1
Err:
Select 0
Select 0
return 0
music_getBiz_sp 'ICDTL'
Declare @strUserID NVARchar(12)
Select mp_CD , file_Code, Song_Subject ,Artist_Name, PrimaryUserID , Message, RegDate, Biztype, mp.Pro_Gender
From musicBiz_tbl AS mb INNER JOIN meet_profile AS mp
ON mb.PrimaryUserID = mp.Pro_ID
Where ForeignUserID = 'icdtl' and active = 1
Select @strUserID
Update musicBiz_tbl SET active = 1 Where mp_CD in
(184,185,186,187,188,189)
Declare @strUserID NVARchar(12)
Select @strUserID = PrimaryUserID
From musicBiz_tbl AS mb INNER JOIN meet_profile AS mp
ON mb.PrimaryUserID = mp.Pro_ID
Where ForeignUserID = 'icdtl' and active = 1
Select @strUserID
@strUserID
Select * From musicAlbum_tbl Where UserID = 'icdtl' and ma_BestAlbumActive = 0
Select * From musicAlbum_tbl
Alter Table musicAlbum_tbl
Add bestRegCount INT default(0)
Update musicAlbum_tbl SET bestRegCount = 1 Where ma_BestAlbumActive = 1
sp_helptext music_setAlbumTOBestAlbum
/*
작성자 : 한영민
작성일 : 2003-10-14
설 명 : 베스트 앨범으로 신청하기
*/
ALTER Procedure dbo.music_setAlbumTOBestAlbum
@ma_BestReg INT = 0
, @ma_CD INT
, @ma_BestTitle NVarchar(50)
, @ma_BestContent NVarchar(200)
AS
IF @ma_BestReg = 0 Begin
Return 0
End
Update musicAlbum_tbl Set ma_BestReg = @ma_BestReg, ma_BestTitle = @ma_BestTitle, ma_BestContent = @ma_BestContent, bestRegCount = bestRegCount + 1 Where ma_CD = @ma_CD
IF @@Error <> 0 Begin
GOTO Err
End
Return @@RowCount
Err:
Return 0
SP_HELPTEXT music_UserAlbumDetail_sp
/*
작성자 : 한영민
작성일 : 2003-10-15
설 명 : 나의 앨범 상세정보 현황
*/
ALTER Procedure dbo.music_UserAlbumDetail_sp
@ma_CD INT
AS
Select ma_CD, ma_Title, ma_Content, ma_image, meeting.dbo.fn_Getdate10(regDate) AS regDate, UserID ,hits, ma_BestAlbumActive
from musicAlbum_tbl
Where ma_CD = @ma_CD
/*
위 앨범에 수록된 곡목 리스팅
*/
EXECUTE music_UserAlbumContents_sp @ma_CD
UPDATE musicAlbum_tbl SET hits = hits + 1 Where ma_CD = @ma_CD
SP_HELP musicAlbum_tbl
sp_helptext music_BgSound_sp
sp_helptext music_getBiz_sp
/*
작성자 : 한영민
작성일 : 2003-11-04
설 명 : 각 사용자가 로그인 했을때 러브의 배경음악 선물, 프로포즈를 확인 할수 있게 함
*/
ALTER Procedure dbo.music_getBiz_sp
@UserID NVarchar(12) = 'system'
AS
DECLARE @effectRow INT, @strUserID NVarchar(12)
IF @UserID = 'system'
Goto Err
Select @strUserID = PrimaryUserID
From musicBiz_tbl AS mb INNER JOIN meet_profile AS mp
ON mb.PrimaryUserID = mp.Pro_ID
Where ForeignUserID = @UserID and active = 1
SELECT mp.pro_Photo, mp.Pro_ID, Pro_Age
, dbo.fn_GetGender(Pro_Gender) AS Pro_Genders
, dbo.fn_GetUser_Area(SubString(Pro_Profile, 2, 1)) AS AREA
, Pro_Gender
FROM meet_profile AS mp Left Outer JOIN meet_AlbumPhoto AS map ON mp.Pro_ID=map.Pro_ID
Where mp.Pro_ID = @strUserID
Select mp_CD , file_Code, Song_Subject ,Artist_Name,PrimaryUserID, Message, RegDate, Biztype, mp.Pro_Gender
From musicBiz_tbl AS mb INNER JOIN meet_profile AS mp
ON mb.ForeignUserID = mp.Pro_ID
Where ForeignUserID = @UserID and active = 1
IF @@Error <> 0 Goto Err
return 1
Err:
Select 0
Select 0
return 0
Select * from musicAlbum_tbl Where ma_CD =31
update musicAlbum_tbl set regdate = getdate() Where ma_CD =31
