Experienced Elementalist
- Joined
- Sep 13, 2014
- Messages
- 232
- Reaction score
- 86
[DB] C9World
1. Game.UspCreatePc
we can set money / level / skill point / add news item for new player
1.1 Set Level
- found
you will see
change @pLev to '20' ( 20 is a level that you want )
1.2 Set Money / Skill point / Tired Rate / Normal Boost
@pMoney = Set money here.
@PSKillPoint = Set SP here.
@pDFTiredRate = Set Tired Rate Here.
@pDFNormalBst = Set normal boost here.
example change @pMoney to '5000' that character will get 5000 gold when create character
if want more just copy and past my code again.
1.4 add Point to new character
look at this line
insert cWB behind cSurvivalCoin
insert '500' behind @pDFSurvivalCoin ( 500 is you point )
AUTO UPDATE / ADD / ACCEPT GUILD MARK
execute this code
1. Game.UspCreatePc
we can set money / level / skill point / add news item for new player
1.1 Set Level
- found
Code:
-- PC 스탯정보 입력
you will see
Code:
INSERT Game.TblPcStat(cPcNo, cLev, cExp, cMapId)
VALUES(@pPcNo, @pLev, @pExp, @pMapId)
change @pLev to '20' ( 20 is a level that you want )
1.2 Set Money / Skill point / Tired Rate / Normal Boost
Code:
-- PC 주요정보 입력
INSERT Game.TblPcInfo(cPcNo, cMoney, cRsrtCoin, cSkillPoint, cTiredRate, cNormalBst, cPcRoomBst, cPcRoomRsrtCoin, cSurvivalCoin)
VALUES(@pPcNo, @pMoney, @pDFRsrtCoin, @[I][B][URL="https://forum.ragezone.com/members/2000049360.html"]PSK[/URL][/B][/I]illPoint, @pDFTiredRate, @pDFNormalBst, @pDFPcRoomBst, @pDFPcRoomRsrtCoin, @pDFSurvivalCoin)
@pMoney = Set money here.
@PSKillPoint = Set SP here.
@pDFTiredRate = Set Tired Rate Here.
@pDFNormalBst = Set normal boost here.
example change @pMoney to '5000' that character will get 5000 gold when create character
if want more just copy and past my code again.
1.4 add Point to new character
look at this line
Code:
-- PC 주요정보 입력
INSERT Game.TblPcInfo(cPcNo, cMoney, cRsrtCoin, cSkillPoint, cTiredRate, cNormalBst, cPcRoomBst, cPcRoomRsrtCoin, cSurvivalCoin)
VALUES(@pPcNo, @pMoney, @pDFRsrtCoin, @[I][B][URL="https://forum.ragezone.com/members/2000049360.html"]PSK[/URL][/B][/I]illPoint, @pDFTiredRate, @pDFNormalBst, @pDFPcRoomBst, @pDFPcRoomRsrtCoin, @pDFSurvivalCoin)
insert cWB behind cSurvivalCoin
insert '500' behind @pDFSurvivalCoin ( 500 is you point )
AUTO UPDATE / ADD / ACCEPT GUILD MARK
execute this code
Code:
USE [C9World]
GO
/****** Object: StoredProcedure [Game].[UspSetGuildMarkState] Script Date: 12/16/2015 11:02:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
** Name: UspSetGuildMarkState
** Desc: 길드마크 심의 테이블 등록
**
** Auth: 채석현
** Date: 20111024
*******************************************************************************
** Change History
*******************************************************************************
** Date: Author: Description:
** -------- -------- ---------------------------------------
*******************************************************************************/
ALTER PROCEDURE [Game].[UspSetGuildMarkState]
@pGuildNo BIGINT,
@pGuildMark BINARY(4096),
@pGuildMarkState TINYINT
AS
SET NOCOUNT ON -- 설명 : 결과 레코드 셋을 반환 안 시킨다.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
--- 변수 선언
DECLARE @[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo INT,
@aRowCnt INT
--- 변수 초기화
SELECT @[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = 0, @aRowCnt = 0 -- 한줄에 초기화
-- 길드 존재하는지 확인
IF NOT EXISTS (
SELECT *
FROM Game.TblGuildBase
WHERE cGuildNo = @pGuildNo
)
BEGIN
SET @[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = 1 -- 존재하지 않는 길드
END
ELSE
BEGIN
IF EXISTS (
SELECT *
FROM Game.TblGuildMarkJudge
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMarkJudge
SET cGuildMarkJudge = @pGuildMark, cGuildMarkJudgeState = 3
WHERE cGuildNo = @pGuildNo
IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END
END
-- 아무것도 없는 상태라면
ELSE
BEGIN
INSERT INTO Game.TblGuildMarkJudge (cGuildNo, cGuildMarkJudge, cGuildMarkJudgeState)
VALUES (@pGuildNo, @pGuildMark, 3)
IF EXISTS (
SELECT *
FROM Game.TblGuildMark
WHERE cGuildNo = @pGuildNo
)
BEGIN
UPDATE Game.TblGuildMark
SET cGuildMark = @pGuildMark
WHERE cGuildNo = @pGuildNo
END
ELSE
BEGIN
INSERT INTO Game.TblGuildMark (cGuildNo, cGuildMark)
VALUES (@pGuildNo, @pGuildMark)
END
END
SELECT @[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = @@Error, @aRowCnt = @@RowCount
IF (@aRowCnt <> 1)
SET @[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo = 3 -- DB오류
END
RETURN (@[I][B][URL="https://forum.ragezone.com/members/2000075974.html"]Aer[/URL][/B][/I]rNo) -- 0이면 성공
Last edited: