|
You last visited: Today at 21:13
Advertisement
How to modify the shaiya novice birth site to map 42
Discussion on How to modify the shaiya novice birth site to map 42 within the Shaiya Private Server forum part of the Shaiya category.
04/24/2017, 11:16
|
#1
|
elite*gold: 0
Join Date: Feb 2017
Posts: 3
Received Thanks: 0
|
How to modify the shaiya novice birth site to map 42
How to modify the shaiya novice birth site to map 42。
Thank
|
|
|
04/24/2017, 20:48
|
#2
|
elite*gold: 0
Join Date: Sep 2011
Posts: 390
Received Thanks: 375
|
Go to map.ini
And change this
Quote:
[BASE]
MapCount = 109
HUGameStartMapPos = (1,577.98, 78.56, 1762.12)
ELGameStartMapPos = (1,1678.92, 38.92, 1776.91)
BAGameStartMapPos = (2,165.25, 118.50, 397.89)
DEGameStartMapPos = (2,1838.93, 129.33, 443.43)
|
|
|
|
04/25/2017, 02:06
|
#3
|
elite*gold: 0
Join Date: Jul 2016
Posts: 12
Received Thanks: 5
|
Quote:
Originally Posted by wuzekai
How to modify the shaiya novice birth site to map 42。
Thank
|
USE [PS_GameData]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Create_Char_R]
@ServerID tinyint, @ varchar(12), @ID int,
@CharName varchar(50) ,
@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint, @point Smallint, @Skillpoint Smallint, @ Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint, @ Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,
/* 여기까지 인자값 주어져야 함 */
/* SP 내부 참조용 변수 */
@CharID int = 0,
@NameCnt tinyint = 0
AS
SET NOCOUNT ON
DECLARE @Ret int
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @Point = 126
SET @SkillPoint = 9999
SET @money = 2000000
IF @Job = 0
BEGIN
SET @ = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @ = 28
END
END
ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @Point = 261
SET @SkillPoint = 9999
SET @money = 2000000
IF @Job = 0
BEGIN
SET @ = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @ = 43
END
END
ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 60
SET @Point = 531
SET @SkillPoint = 9999
SET @money = 2000000
IF @Job = 0
BEGIN
SET @ = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @ = 73
END
END
ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 90
SET @Point = 810
SET @SkillPoint = 9999
SET @money = 2000000
IF @Job = 0
BEGIN
SET @ = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @ = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END
SET @Map = 42
SET @PosX = X
SET @PosY = Y
SET @PosZ = Z
BEGIN TRANSACTION
INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)
VALUES(@ServerID @, @ID, @CharName, @Slot, @Family, @Grow, @Hair, @Face, @Size, @Job, @Sex, @Level, @Point, @SkillPoint,
@, @Dex, @Rec, @Int, @Luc, @, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)
IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END
SET @CharID = IDENT_CURRENT('Chars')
END
RETURN @CharID
SET NOCOUNT OFF
Add the bolded part in your PS_GameData.dbo.usp_Create_Char_R stored procedure. Obviously edit PosX, PosY and PosZ with your coords
|
|
|
Similar Threads
|
[Selling] Jackpot Site | Site + Bot + SQL File + Setup Guide of Site + BOT Setup
08/29/2015 - Counter-Strike Trading - 0 Replies
Hello, who is willing to buy invite you to steam a private message : Steam Community :: NINJAGO. Drejku?
Witam, kto jest chetny do kupienia zapraszam na steam wiadomosc prywatna: Steam Community :: NINJAGO. Drejku?
|
All times are GMT +2. The time now is 21:13.
|
|