Регистрация Ssq

USE [lin2world]
GO
/****** Object: StoredProcedure [dbo].[lin_SaveSSQUserInfo] Script Date: 11/03/2009 03:40:03 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO



/**
* @procedure lin_SaveSSQUserInfo
* @brief Save user's ssq parameter to ssq_user_data
*
* @date 2004/11/18
* @author sonai <[email protected]>
*
* 레코드가 없는 경우에는 새로운 값을 넣는다.
*
* @param[in] ssq_part SSQ 소속(황혼 : 1, 새벽 : 2)
* @param[in] ssq_position SSQ 직위
* @param[in] seal_selection_no 가입시 선택한 봉인 번호
* @param[in] ssq_point SSQ 공헌도 점수
*/

ALTER PROCEDURE [dbo].[lin_SaveSSQUserInfo]
(
@char_id INT,
@round_number INT,
@ssq_join_time INT,
@ssq_part INT,
@ssq_position INT,
@seal_selection_no INT,
@ssq_point INT,
@twilight_a_item_num INT,
@twilight_b_item_num INT,
@twilight_c_item_num INT,
@dawn_a_item_num INT,
@dawn_b_item_num INT,
@dawn_c_item_num INT,
@ticket_buy_count INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT * FROM ssq_user_data WHERE char_id = @char_id)
BEGIN

UPDATE ssq_user_data SET round_number = @round_number,
ssq_join_time = @ssq_join_time,
ssq_part = @ssq_part,
ssq_position = @ssq_position,
seal_selection_no = @seal_selection_no,
ssq_point = @ssq_point,
twilight_a_item_num = @twilight_a_item_num,
twilight_b_item_num = @twilight_b_item_num,
twilight_c_item_num = @twilight_c_item_num,
dawn_a_item_num = @dawn_a_item_num,
dawn_b_item_num = @dawn_b_item_num,
dawn_c_item_num = @dawn_c_item_num,
ticket_buy_count = @ticket_buy_count
WHERE char_id = @char_id

END
ELSE
BEGIN

INSERT INTO ssq_user_data (char_id, round_number, ssq_join_time, ssq_part, ssq_position,
seal_selection_no, ssq_point,
twilight_a_item_num, twilight_b_item_num, twilight_c_item_num,
dawn_a_item_num, dawn_b_item_num, dawn_c_item_num,
ticket_buy_count)
VALUES (@char_id, @round_number, @ssq_join_time, @ssq_part, @ssq_position,
@seal_selection_no, @ssq_point,
@twilight_a_item_num, @twilight_b_item_num, @twilight_c_item_num,
@dawn_a_item_num, @dawn_b_item_num, @dawn_c_item_num,
@ticket_buy_count)
END