شـريـط الاهـداءات
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ]
04-03-2018, 07:52 AM
#1
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
مشكله فى Create acc
المشكله بعد ما فتحت الجيم بتجبلى رساله ان اسم الاكونت دا معمول يا اما
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
مع ان الجيم لسه نيو انا لسه عاملها ومفيهاش حد والاكونتات اللى كانت فى ال SQL انا حذفتها كلها مش عارف بقى دا ايه وانا مش عارف اخش الجيم اعمل تست
إعلانات google
04-03-2018, 09:44 AM
#3
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
ممكن توضح اكتر بعد ازنك
انا لسه مبتدئ
04-03-2018, 12:29 PM
#4
• الانـتـسـاب » Apr 2015
• رقـم العـضـويـة » 121546
• المشـــاركـات » 4,033
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة » MIS
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 45
رد: مشكله فى Create acc
افتح Jangan و Const واعمل ده
كود:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 3/4/2018 11:26:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS
SET NOCOUNT ON
DECLARE @Slot INT
DECLARE @temp INT
DECLARE @NewCharID INT
SET @NewCharID = 0
-----------------------------------------------------------------------------
-- 1. أ„³¸¯أ…أچ ½½·أ” ³أ‘¹أ¶°آ، validأ‡أ‘ °أچأ€أژأپأ¶, ±×¸®°أ* آ؛أ³½½·أ”أ€أŒ ¸أ‚´أ‚أپأ¶ ¸أ•أ€أ؛ أƒ¼أ…©أ‡أ‘´أ™.
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³أٹ¹« ¸¹أ€أڑ³آھ
RETURN -2
END
-- finish by novice.
-----------------------------------------------------------------------------
-- 2. أ„³¸¯أ…أچ أƒأں°آ،أ‡أڈ±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 أ€أŒ´أ™!
BEGIN
-- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ! ½آ؛أ„أ‰أ€أڈ °آھأ€أŒ أ€أŒ»أ³أ‡أڈ´أ™!
RETURN -3
END
EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- أ€أŒ¹أŒ »çآ؟ëأپأںأ€أژ أ€أŒ¸§أ€أŒ¶أ³´أ‚µ¥?
RETURN -4
END
BEGIN TRANSACTION
-- أ€أژ´أ¸½أƒ½آ؛أ…أ›أ€أŒ أ€ûآ؟ëµأ‡¸é¼* ¸¶أپأ¶¸·آ؟آ، WorldIDآ؟أچ 1°آھأ€» ´أµ ³أ–¾î أپأ–¾أ؛´أ™!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)
SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -5
END
-- start by novice.
-- أ€أŒأپ¦ Slot ¾أˆ¾´´أ™.. ±×³أ‰ Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. أ€أ¥آ؛أ± ½½·أ” أƒ¤آ؟أ¬±â
-- [أ€أژآ؛¥أ…أ¤¸® ½½·أ” 96°³] + [أ€أ¥آ؛أ±½½·أ” 13°³] <- أ€أژآ؛¥أ…أ¤¸® أˆ®أ€أ¥ ¼*آ؛أ±½آ؛ أˆأ„ 48°³آ؟آ،¼* 96°³·أژ أپأµ°آ،!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109
IF (@@ERROR <> 0)
BEGIN
-- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -7
END
DECLARE @ItemID BIGINT
SET @ItemID = 0
-- Chest
IF (@RefMailID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- Pants
IF (@RefPantsID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- Shield
IF (@RefShield <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- Arror/Bolt
IF (@DefaultArrow <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END
-----------------------------------------------------------------------------
-- 3-2. ¾أ†¹أ™أ…¸ Inventory ½½·أ” أƒ¤آ؟أ¬±â
-- [¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® ½½·أ” 5°³]
-- APPLY_AVATAR_SYSTEMأ€أŒ أ€ûآ؟ëµأ‡¸é¼* أƒأں°آ،µأ‡´أ‚ آ؛أژآ؛أگ
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5
IF (@@ERROR <> 0)
BEGIN
-- ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-----------------------------------------------------------------------------
-- default skill³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±âآ؛» أ„ù½آ؛أ†® ³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³أ–±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob أƒ¤آ؟أ¶³أ–±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- CharListآ؟آ، ID ³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
IF Not Exists (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserJID)
Begin
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 0, 0, 0);
End
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION
RETURN @NewCharID
05-03-2018, 11:07 AM
#5
• الانـتـسـاب » Oct 2012
• رقـم العـضـويـة » 106331
• المشـــاركـات » 947
• الـدولـة » GIZZA
• الـهـوايـة » Babel.SRO only
• اسـم الـسـيـرفـر » Lepus
• الـجـنـس » Male
• نقـاط التقييم » 576
رد: مشكله فى Create acc
المشكلة دية انك قافل المدينة البينزل فيها البلاير
05-03-2018, 11:12 AM
#6
Never ForGive
• الانـتـسـاب » Feb 2010
• رقـم العـضـويـة » 68924
• المشـــاركـات » 3,580
• الـدولـة » Egypt - Giza - Imbaba
• الـهـوايـة » * افْعَل مَا تُؤْمِن بهِ وَدَع الجَمِيع يُفَكِر بمَا يَشَاء .
• اسـم الـسـيـرفـر » Serpens
• الـجـنـس » Male
• نقـاط التقييم » 1145
رد: مشكله فى Create acc
اقتباس:
المشاركة الأصلية كتبت بواسطة Dev.Ri3o
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
افتح Jangan و Const واعمل ده
كود:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 3/4/2018 11:26:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS
SET NOCOUNT ON
DECLARE @Slot INT
DECLARE @temp INT
DECLARE @NewCharID INT
SET @NewCharID = 0
-----------------------------------------------------------------------------
-- 1. أ„³¸¯أ…أچ ½½·أ” ³أ‘¹أ¶°آ، validأ‡أ‘ °أچأ€أژأپأ¶, ±×¸®°أ* آ؛أ³½½·أ”أ€أŒ ¸أ‚´أ‚أپأ¶ ¸أ•أ€أ؛ أƒ¼أ…©أ‡أ‘´أ™.
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³أٹ¹« ¸¹أ€أڑ³آھ
RETURN -2
END
-- finish by novice.
-----------------------------------------------------------------------------
-- 2. أ„³¸¯أ…أچ أƒأں°آ،أ‡أڈ±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 أ€أŒ´أ™!
BEGIN
-- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ! ½آ؛أ„أ‰أ€أڈ °آھأ€أŒ أ€أŒ»أ³أ‡أڈ´أ™!
RETURN -3
END
EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- أ€أŒ¹أŒ »çآ؟ëأپأںأ€أژ أ€أŒ¸§أ€أŒ¶أ³´أ‚µ¥?
RETURN -4
END
BEGIN TRANSACTION
-- أ€أژ´أ¸½أƒ½آ؛أ…أ›أ€أŒ أ€ûآ؟ëµأ‡¸é¼* ¸¶أپأ¶¸·آ؟آ، WorldIDآ؟أچ 1°آھأ€» ´أµ ³أ–¾î أپأ–¾أ؛´أ™!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)
SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -5
END
-- start by novice.
-- أ€أŒأپ¦ Slot ¾أˆ¾´´أ™.. ±×³أ‰ Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. أ€أ¥آ؛أ± ½½·أ” أƒ¤آ؟أ¬±â
-- [أ€أژآ؛¥أ…أ¤¸® ½½·أ” 96°³] + [أ€أ¥آ؛أ±½½·أ” 13°³] <- أ€أژآ؛¥أ…أ¤¸® أˆ®أ€أ¥ ¼*آ؛أ±½آ؛ أˆأ„ 48°³آ؟آ،¼* 96°³·أژ أپأµ°آ،!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109
IF (@@ERROR <> 0)
BEGIN
-- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -7
END
DECLARE @ItemID BIGINT
SET @ItemID = 0
-- Chest
IF (@RefMailID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- Pants
IF (@RefPantsID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- Shield
IF (@RefShield <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- Arror/Bolt
IF (@DefaultArrow <> 0) BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0) BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END
-----------------------------------------------------------------------------
-- 3-2. ¾أ†¹أ™أ…¸ Inventory ½½·أ” أƒ¤آ؟أ¬±â
-- [¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® ½½·أ” 5°³]
-- APPLY_AVATAR_SYSTEMأ€أŒ أ€ûآ؟ëµأ‡¸é¼* أƒأں°آ،µأ‡´أ‚ آ؛أژآ؛أگ
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5
IF (@@ERROR <> 0)
BEGIN
-- ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-----------------------------------------------------------------------------
-- default skill³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±âآ؛» أ„ù½آ؛أ†® ³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³أ–±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob أƒ¤آ؟أ¶³أ–±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- CharListآ؟آ، ID ³أ–¾îأپأ–±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
IF Not Exists (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserJID)
Begin
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 0, 0, 0);
End
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION
RETURN @NewCharID
تابع ..
05-03-2018, 11:54 AM
#7
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
05-03-2018, 08:18 PM
#9
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
بص دا القديم
اقتباس:
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 03/05/2018 09:25:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewChar]
@UserJID INT,
--@CharSlot INT,
@RefCharID INT,
@CharName varchar (64),
@CharScale tinyINT,
@StartRegionID INT,
@StartPos_X real,
@StartPos_Y real,
@StartPos_Z real,
@DefaultTeleport INT,
@RefMailID INT,
@RefPantsID INT,
@RefBootsID INT,
@RefWeaponID INT,
@RefShield INT,
@DurMail tinyINT,
@DurPants tinyINT,
@DurBoots tinyINT,
@DurWeapon tinyINT,
@DurShield tinyINT,
@DefaultArrow INT
AS
SET NOCOUNT ON
DECLARE @Slot INT
DECLARE @temp INT
DECLARE @NewCharID INT
SET @NewCharID = 0
-----------------------------------------------------------------------------
-- 1. ?³¸¯?? ½½·O ³?¹?°? validC? °?AI??, ±×¸®°? ??½½·OA? ¸A´A?? ¸?A? ?¼?©C?´U.
-----------------------------------------------------------------------------
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³E¹« ¸¹A?³?
RETURN -2
END
-- finish by novice.
-----------------------------------------------------------------------------
-- 2. ?³¸¯?? ??°?CI±â
-----------------------------------------------------------------------------
IF (@CharScale > 68) -- 0100 0100 --> 68 A?´U!
BEGIN
-- ?³¸¯?? »?¼? ½C??! ½??EAI °?A? A?»?CI´U!
RETURN -3
END
EXEC @temp = _IsExistingCharName @CharName
IF (@temp <> 0)
BEGIN
-- A?¹? »ç?ë??AI A?¸§A?¶?´Aµ¥?
RETURN -4
END
BEGIN TRANSACTION
-- AI´?½?½??UA? Aû?ëµC¸é¼* ¸¶??¸·?? WorldID?? 1°?A» ´? ³?¾î ??¾?´U!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 10000000, 0, 1000000, 200,200, 1, 1, 1, 1)
SET @NewCharID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
-- ?³¸¯?? »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -5
END
-- start by novice.
-- A??¦ Slot ¾E¾´´U.. ±×³E Insert ¸¸..
INSERT INTO _User VALUES (@UserJID, @NewCharID)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. A??? ½½·O ?¤??±â
-- [AI?¥??¸® ½½·O 96°³] + [A???½½·O 13°³] <- AI?¥??¸® E®A? ¼*??½? E? 48°³??¼* 96°³·I ??°?!!!(woos0)
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _Inventory(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 109
IF (@@ERROR <> 0)
BEGIN
-- AI?¥??¸® »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -7
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-- µ????®·I ¼±??C? ¾?A??UA» ´U½? ³?¾î??A?...
/* ??·± ¼?¼*·I ?¤ACµC¾î A?´U.
0: EQUIP_SLOT_HELM
1: EQUIP_SLOT_MAIL,
2: EQUIP_SLOT_SHOULDERGUARD,
3: EQUIP_SLOT_GAUNTLET,
4: EQUIP_SLOT_PANTS,
5: EQUIP_SLOT_BOOTS,
6: EQUIP_SLOT_WEAPON,
7: EQUIP_SLOT_SHIELD or ARROW,
8: EQUIP_SLOT_EARRING,
9: EQUIP_SLOT_NECKLACE,
10: EQUIP_SLOT_L_RING,
11: EQUIP_SLOT_R_RING,
*/
DECLARE @ItemID BIGINT
SET @ItemID = 0
-- »?°©
IF (@RefMailID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 1, @RefMailID, @DurMail
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -8
END
END
-- ¹U??
IF (@RefPantsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 4, @RefPantsID, @DurPants
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -9
END
END
-- Boots
IF (@RefBootsID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 5, @RefBootsID, @DurBoots
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -10
END
END
-- Weapon
IF (@RefWeaponID <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 6, @RefWeaponID, @DurWeapon
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -11
END
END
-- ¹???
IF (@RefShield <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @RefShield, @DurShield
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -12
END
END
-- E¤½? default·I ¼±??C? ¹«±â°? E°A?¶?¸é E*»? 250°³µéA? E°?ëµµ CO²² ??´U. ?????
IF (@DefaultArrow <> 0)
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 7, @DefaultArrow, 250
IF (@ItemID <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -13
END
END
-----------------------------------------------------------------------------
-- 3-2. ¾?¹U?¸ Inventory ½½·O ?¤??±â
-- [¾?¹U?¸ AI?¥??¸® ½½·O 5°³]
-- APPLY_AVATAR_SYSTEMA? Aû?ëµC¸é¼* ??°?µC´A ?I??
-----------------------------------------------------------------------------
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
INSERT INTO _InventoryForAvatar(CharID, Slot, ItemID)
SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5
IF (@@ERROR <> 0)
BEGIN
-- ¾?¹U?¸ AI?¥??¸® »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -14
END
--PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!PATCH WARNING!!!
-----------------------------------------------------------------------------
-- default skill³?¾î??±â
-----------------------------------------------------------------------------
DECLARE @country tinyINT
EXEC @country = _GetObjCountry @RefCharID
INSERT INTO _CharSkillMastery (CharID, MasteryID, Level)
SELECT @NewCharID, MasteryID, 0
FROM _RefCharDefault_SkillMastery with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -15
END
INSERT INTO _CharSkill (CharID,SkillID,Enable)
SELECT @NewCharID, SkillID, 1
FROM _RefCharDefault_Skill with(nolock)
WHERE Race = @country or Race = 3
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -16
END
-----------------------------------------------------------------------------
-- ±â?» ?ù½??® ³?¾î??±â
-----------------------------------------------------------------------------
INSERT INTO _CharQuest (CharID, QuestID, Status, AchievementCount, StartTime, EndTime, QuestData1, QuestData2)
SELECT @NewCharID, ID, 1, 0, getdate(), getdate(), 0, 0
FROM _RefQuest
WHERE CodeName in (SELECT CodeName FROM _RefCharDefault_Quest with(nolock) WHERE (Race = @country or Race = 3) and RequiredLevel = 1 and Service = 1)
IF (@@error <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -17
END
-----------------------------------------------------------------------------
-- Static Avatar Initial Record ³?±â
-----------------------------------------------------------------------------
INSERT INTO _StaticAvatar(CharID) values(@NewCharID)
IF (@@ERROR <> 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -18
END
-----------------------------------------------------------------------------
-- Trijob ?¤??³?±â!!!!!
-----------------------------------------------------------------------------
INSERT INTO _CharTrijob VALUES (@NewCharID, 0, 1, 0, 0, 0)
IF (@@ERROR <> 0)
BEGIN
-- AI?¥??¸® »?¼? ½C??!
ROLLBACK TRANSACTION
RETURN -19
END
-----------------------------------------------------------------------------
-- CharList?? ID ³?¾î??±â
-----------------------------------------------------------------------------
INSERT _CharNameList VALUES(@CharName, @NewCharID)
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RETURN_SCROLL_HIGH_SPEED',20 ,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL' ,10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL', 3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL', 3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_RESURRECTION_100P_SCROLL',11 ,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_P_MYOWON_SCROLL',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_KOREANDRESS',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_KOREANDRESS',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_MP_POTION_05',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_HP_POTION_05',1000,1
-- Quick Slot ?¤?¸ A?A??ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION
RETURN @NewCharID
05-03-2018, 08:18 PM
#10
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
كود PHP:
GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 03/05/2018 09:25:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ].[ _AddNewChar ] @ UserJID INT , --@ CharSlot INT , @ RefCharID INT , @ CharName varchar ( 64 ), @ CharScale tinyINT , @ StartRegionID INT , @ StartPos_X real , @ StartPos_Y real , @ StartPos_Z real , @ DefaultTeleport INT , @ RefMailID INT , @ RefPantsID INT , @ RefBootsID INT , @ RefWeaponID INT , @ RefShield INT , @ DurMail tinyINT , @ DurPants tinyINT , @ DurBoots tinyINT , @ DurWeapon tinyINT , @ DurShield tinyINT , @ DefaultArrow INT AS SET NOCOUNT ON DECLARE @ Slot INT DECLARE @ temp INT DECLARE @ NewCharID INT SET @ NewCharID = 0 ----------------------------------------------------------------------------- -- 1. ? ³¸¯ ?? ½½·O ³ ? ¹ ? ° ? validC ? ° ? AI ??, ±×¸®° ? ?? ½½·OA ? ¸A´A ?? ¸ ? A ? ? ¼ ? ©C ? ´U . ----------------------------------------------------------------------------- -- start by novice . SELECT @ temp = count ( CharID ) FROM _User WITH ( NOLOCK ) WHERE UserJID = @ UserJID IF (@ temp >= 4 ) BEGIN -- ³E¹« ¸¹A ? ³ ? RETURN - 2 END -- finish by novice . ----------------------------------------------------------------------------- -- 2. ? ³¸¯ ?? ?? ° ? CI±â ----------------------------------------------------------------------------- IF (@ CharScale > 68 ) -- 0100 0100 --> 68 A ? ´U ! BEGIN -- ? ³¸¯ ?? » ? ¼ ? ½C ??! ½ ?? EAI ° ? A ? A ? » ? CI´U ! RETURN - 3 END EXEC @ temp = _IsExistingCharName @ CharName IF (@ temp <> 0 ) BEGIN -- A ? ¹ ? »ç ? ë ?? AI A ? ¸§A ? ¶ ? ´Aµ¥ ? RETURN - 4 END BEGIN TRANSACTION -- AI´ ? ½ ? ½ ?? UA ? Aû ? ëµC¸é¼ * ¸¶ ?? ¸· ?? WorldID ?? 1° ? A» ´ ? ³ ? ¾î ?? ¾ ? ´U ! INSERT INTO _Char ( RefObjID , CharName16 , Scale , Strength , Intellect , LatestRegion , PosX , PosY , PosZ , AppointedTeleport , InventorySize , LastLogout , CurLevel , MaxLevel , RemainGold , RemainStatPoint , RemainSkillPoint , HP , MP , JobLvl_Trader , JobLvl_Hunter , JobLvl_Robber , WorldID ) VALUES (@ RefCharID , @ CharName , @ CharScale , 20 , 20 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 45 , GetDate (), 1 , 1 , 10000000 , 0 , 1000000 , 200 , 200 , 1 , 1 , 1 , 1 ) SET @ NewCharID = @@ IDENTITY IF (@@ ERROR <> 0 OR @@ ROWCOUNT = 0 ) BEGIN -- ? ³¸¯ ?? » ? ¼ ? ½C ??! ROLLBACK TRANSACTION RETURN - 5 END -- start by novice . -- A ?? ¦ Slot ¾E¾´´U .. ±×³E Insert ¸¸ .. INSERT INTO _User VALUES (@ UserJID , @ NewCharID ) -- finish by novice . ----------------------------------------------------------------------------- -- 3 - 1. A ??? ½½·O ? ¤ ?? ±â -- [ AI ? ¥ ?? ¸® ½½·O 96°³ ] + [ A ??? ½½·O 13°³ ] <- AI ? ¥ ?? ¸® E®A ? ¼ *?? ½ ? E ? 48°³ ?? ¼ * 96°³·I ?? ° ?!!!( woos0 ) ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _Inventory ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 109 IF (@@ ERROR <> 0 ) BEGIN -- AI ? ¥ ?? ¸® » ? ¼ ? ½C ??! ROLLBACK TRANSACTION RETURN - 7 END -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! -- µ ???? ®·I ¼± ?? C ? ¾ ? A ?? UA» ´U½ ? ³ ? ¾î ?? A ?... /* ??·± ¼?¼*·I ?¤ACµC¾î A?´U. 0: EQUIP_SLOT_HELM 1: EQUIP_SLOT_MAIL, 2: EQUIP_SLOT_SHOULDERGUARD, 3: EQUIP_SLOT_GAUNTLET, 4: EQUIP_SLOT_PANTS, 5: EQUIP_SLOT_BOOTS, 6: EQUIP_SLOT_WEAPON, 7: EQUIP_SLOT_SHIELD or ARROW, 8: EQUIP_SLOT_EARRING, 9: EQUIP_SLOT_NECKLACE, 10: EQUIP_SLOT_L_RING, 11: EQUIP_SLOT_R_RING, */ DECLARE @ ItemID BIGINT SET @ ItemID = 0 -- » ? °© IF (@ RefMailID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 1 , @ RefMailID , @ DurMail IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 8 END END -- ¹U ?? IF (@ RefPantsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 4 , @ RefPantsID , @ DurPants IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 9 END END -- Boots IF (@ RefBootsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 5 , @ RefBootsID , @ DurBoots IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 10 END END -- Weapon IF (@ RefWeaponID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 6 , @ RefWeaponID , @ DurWeapon IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 11 END END -- ¹ ??? IF (@ RefShield <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ RefShield , @ DurShield IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 12 END END -- E¤½ ? default·I ¼± ?? C ? ¹«±â° ? E°A ? ¶ ? ¸é E * » ? 250°³µéA ? E° ? ëµµ CO²² ?? ´U . ????? IF (@ DefaultArrow <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ DefaultArrow , 250 IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 13 END END ----------------------------------------------------------------------------- -- 3 - 2. ¾ ? ¹U ? ¸ Inventory ½½·O ? ¤ ?? ±â -- [ ¾ ? ¹U ? ¸ AI ? ¥ ?? ¸® ½½·O 5°³ ] -- APPLY_AVATAR_SYSTEMA ? Aû ? ëµC¸é¼ * ?? ° ? µC´A ? I ?? ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _InventoryForAvatar ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 5 IF (@@ ERROR <> 0 ) BEGIN -- ¾ ? ¹U ? ¸ AI ? ¥ ?? ¸® » ? ¼ ? ½C ??! ROLLBACK TRANSACTION RETURN - 14 END -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! ----------------------------------------------------------------------------- -- default skill³ ? ¾î ?? ±â ----------------------------------------------------------------------------- DECLARE @ country tinyINT EXEC @ country = _GetObjCountry @ RefCharID INSERT INTO _CharSkillMastery ( CharID , MasteryID , Level ) SELECT @ NewCharID , MasteryID , 0 FROM _RefCharDefault_SkillMastery with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 15 END INSERT INTO _CharSkill ( CharID , SkillID , Enable ) SELECT @ NewCharID , SkillID , 1 FROM _RefCharDefault_Skill with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 16 END ----------------------------------------------------------------------------- -- ±â ? » ? ù½ ?? ® ³ ? ¾î ?? ±â ----------------------------------------------------------------------------- INSERT INTO _CharQuest ( CharID , QuestID , Status , AchievementCount , StartTime , EndTime , QuestData1 , QuestData2 ) SELECT @ NewCharID , ID , 1 , 0 , getdate (), getdate (), 0 , 0 FROM _RefQuest WHERE CodeName in ( SELECT CodeName FROM _RefCharDefault_Quest with ( nolock ) WHERE ( Race = @ country or Race = 3 ) and RequiredLevel = 1 and Service = 1 ) IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 17 END ----------------------------------------------------------------------------- -- Static Avatar Initial Record ³ ? ±â ----------------------------------------------------------------------------- INSERT INTO _StaticAvatar ( CharID ) values (@ NewCharID ) IF (@@ ERROR <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 18 END ----------------------------------------------------------------------------- -- Trijob ? ¤ ?? ³ ? ±â !!!!! ----------------------------------------------------------------------------- INSERT INTO _CharTrijob VALUES (@ NewCharID , 0 , 1 , 0 , 0 , 0 ) IF (@@ ERROR <> 0 ) BEGIN -- AI ? ¥ ?? ¸® » ? ¼ ? ½C ??! ROLLBACK TRANSACTION RETURN - 19 END ----------------------------------------------------------------------------- -- CharList ?? ID ³ ? ¾î ?? ±â ----------------------------------------------------------------------------- INSERT _CharNameList VALUES (@ CharName , @ NewCharID ) exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_60EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RETURN_SCROLL_HIGH_SPEED' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_HWAN_POTION' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_REVERSE_RETURN_SCROLL' , 10 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL' , 10 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL' , 3 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL' , 3 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RESURRECTION_100P_SCROLL' , 11 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_COS_P_MYOWON_SCROLL' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_AVATAR_W_NASRUN' , 3 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_AVATAR_M_NASRUN' , 3 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_MALL_AVATAR_M_KOREANDRESS' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_MALL_AVATAR_W_KOREANDRESS' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_MP_POTION_05' , 1000 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_HP_POTION_05' , 1000 , 1 -- Quick Slot ? ¤ ? ¸ A ? A ?? ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
05-03-2018, 08:21 PM
#11
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
ودا الجديد
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 03/05/2018 19:12:13 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [ dbo ].[ _AddNewChar ] @ UserJID INT , --@ CharSlot INT , @ RefCharID INT , @ CharName varchar ( 64 ), @ CharScale tinyINT , @ StartRegionID INT , @ StartPos_X real , @ StartPos_Y real , @ StartPos_Z real , @ DefaultTeleport INT , @ RefMailID INT , @ RefPantsID INT , @ RefBootsID INT , @ RefWeaponID INT , @ RefShield INT , @ DurMail tinyINT , @ DurPants tinyINT , @ DurBoots tinyINT , @ DurWeapon tinyINT , @ DurShield tinyINT , @ DefaultArrow INT AS SET NOCOUNT ON DECLARE @ Slot INT DECLARE @ temp INT DECLARE @ NewCharID INT SET @ NewCharID = 0 ----------------------------------------------------------------------------- -- 1. أ„³¸¯أ…أچ ½½·أ” ³أ‘¹أ¶°آ، validأ‡أ‘ °أچأ€أژأپأ¶ , ±×¸®°أ * آ؛أ³½½·أ”أ€أŒ ¸أ‚´أ‚أپأ¶ ¸أ•أ€أ؛ أƒ¼أ…©أ‡أ‘´أ™ . ----------------------------------------------------------------------------- -- start by novice . SELECT @ temp = count ( CharID ) FROM _User WITH ( NOLOCK ) WHERE UserJID = @ UserJID IF (@ temp >= 4 ) BEGIN -- ³أٹ¹« ¸¹أ€أڑ³آھ RETURN - 2 END -- finish by novice . ----------------------------------------------------------------------------- -- 2. أ„³¸¯أ…أچ أƒأں°آ،أ‡أڈ±â ----------------------------------------------------------------------------- IF (@ CharScale > 68 ) -- 0100 0100 --> 68 أ€أŒ´أ™ ! BEGIN -- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ ! ½آ؛أ„أ‰أ€أڈ °آھأ€أŒ أ€أŒ»أ³أ‡أڈ´أ™ ! RETURN - 3 END EXEC @ temp = _IsExistingCharName @ CharName IF (@ temp <> 0 ) BEGIN -- أ€أŒ¹أŒ »çآ؟ëأپأںأ€أژ أ€أŒ¸§أ€أŒ¶أ³´أ‚µ¥ ? RETURN - 4 END BEGIN TRANSACTION -- أ€أژ´أ¸½أƒ½آ؛أ…أ›أ€أŒ أ€ûآ؟ëµأ‡¸é¼ * ¸¶أپأ¶¸·آ؟آ، WorldIDآ؟أچ 1°آھأ€» ´أµ ³أ–¾î أپأ–¾أ؛´أ™ ! INSERT INTO _Char ( RefObjID , CharName16 , Scale , Strength , Intellect , LatestRegion , PosX , PosY , PosZ , AppointedTeleport , InventorySize , LastLogout , CurLevel , MaxLevel , RemainGold , RemainStatPoint , RemainSkillPoint , HP , MP , JobLvl_Trader , JobLvl_Hunter , JobLvl_Robber , WorldID ) VALUES (@ RefCharID , @ CharName , @ CharScale , 20 , 20 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 45 , GetDate (), 1 , 1 , 0 , 0 , 0 , 200 , 200 , 1 , 1 , 1 , 1 ) SET @ NewCharID = @@ IDENTITY IF (@@ ERROR <> 0 OR @@ ROWCOUNT = 0 ) BEGIN -- أ„³¸¯أ…أچ »أ½¼آ؛ ½أ‡أ†أگ ! ROLLBACK TRANSACTION RETURN - 5 END -- start by novice . -- أ€أŒأپ¦ Slot ¾أˆ¾´´أ™ .. ±×³أ‰ Insert ¸¸ .. INSERT INTO _User VALUES (@ UserJID , @ NewCharID ) -- finish by novice . ----------------------------------------------------------------------------- -- 3 - 1. أ€أ¥آ؛أ± ½½·أ” أƒ¤آ؟أ¬±â -- [ أ€أژآ؛¥أ…أ¤¸® ½½·أ” 96°³ ] + [ أ€أ¥آ؛أ±½½·أ” 13°³ ] <- أ€أژآ؛¥أ…أ¤¸® أˆ®أ€أ¥ ¼ * آ؛أ±½آ؛ أˆأ„ 48°³آ؟آ،¼ * 96°³·أژ أپأµ°آ، !!!( woos0 ) ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _Inventory ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 109 IF (@@ ERROR <> 0 ) BEGIN -- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ ! ROLLBACK TRANSACTION RETURN - 7 END DECLARE @ ItemID BIGINT SET @ ItemID = 0 -- Chest IF (@ RefMailID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 1 , @ RefMailID , @ DurMail IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 8 END END -- Pants IF (@ RefPantsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 4 , @ RefPantsID , @ DurPants IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 9 END END -- Boots IF (@ RefBootsID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 5 , @ RefBootsID , @ DurBoots IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 10 END END -- Weapon IF (@ RefWeaponID <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 6 , @ RefWeaponID , @ DurWeapon IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 11 END END -- Shield IF (@ RefShield <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ RefShield , @ DurShield IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 12 END END -- Arror / Bolt IF (@ DefaultArrow <> 0 ) BEGIN EXEC @ ItemID = _FN_ADD_INITIAL_EQUIP @ NewCharID , 7 , @ DefaultArrow , 250 IF (@ ItemID <= 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 13 END END ----------------------------------------------------------------------------- -- 3 - 2. ¾أ†¹أ™أ…¸ Inventory ½½·أ” أƒ¤آ؟أ¬±â -- [ ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® ½½·أ” 5°³ ] -- APPLY_AVATAR_SYSTEMأ€أŒ أ€ûآ؟ëµأ‡¸é¼ * أƒأں°آ،µأ‡´أ‚ آ؛أژآ؛أگ ----------------------------------------------------------------------------- -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! INSERT INTO _InventoryForAvatar ( CharID , Slot , ItemID ) SELECT @ NewCharID , cnt , 0 FROM _RefDummySlot with ( nolock ) WHERE cnt < 5 IF (@@ ERROR <> 0 ) BEGIN -- ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ ! ROLLBACK TRANSACTION RETURN - 14 END -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! ----------------------------------------------------------------------------- -- default skill³أ–¾îأپأ–±â ----------------------------------------------------------------------------- DECLARE @ country tinyINT EXEC @ country = _GetObjCountry @ RefCharID INSERT INTO _CharSkillMastery ( CharID , MasteryID , Level ) SELECT @ NewCharID , MasteryID , 0 FROM _RefCharDefault_SkillMastery with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 15 END INSERT INTO _CharSkill ( CharID , SkillID , Enable ) SELECT @ NewCharID , SkillID , 1 FROM _RefCharDefault_Skill with ( nolock ) WHERE Race = @ country or Race = 3 IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 16 END ----------------------------------------------------------------------------- -- ±âآ؛» أ„ù½آ؛أ†® ³أ–¾îأپأ–±â ----------------------------------------------------------------------------- INSERT INTO _CharQuest ( CharID , QuestID , Status , AchievementCount , StartTime , EndTime , QuestData1 , QuestData2 ) SELECT @ NewCharID , ID , 1 , 0 , getdate (), getdate (), 0 , 0 FROM _RefQuest WHERE CodeName in ( SELECT CodeName FROM _RefCharDefault_Quest with ( nolock ) WHERE ( Race = @ country or Race = 3 ) and RequiredLevel = 1 and Service = 1 ) IF (@@ error <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 17 END ----------------------------------------------------------------------------- -- Static Avatar Initial Record ³أ–±â ----------------------------------------------------------------------------- INSERT INTO _StaticAvatar ( CharID ) values (@ NewCharID ) IF (@@ ERROR <> 0 ) BEGIN ROLLBACK TRANSACTION RETURN - 18 END ----------------------------------------------------------------------------- -- Trijob أƒ¤آ؟أ¶³أ–±â !!!!! ----------------------------------------------------------------------------- INSERT INTO _CharTrijob VALUES (@ NewCharID , 0 , 1 , 0 , 0 , 0 ) IF (@@ ERROR <> 0 ) BEGIN -- أ€أژآ؛¥أ…أ¤¸® »أ½¼آ؛ ½أ‡أ†أگ ! ROLLBACK TRANSACTION RETURN - 19 END ----------------------------------------------------------------------------- -- CharListآ؟آ، ID ³أ–¾îأپأ–±â ----------------------------------------------------------------------------- INSERT _CharNameList VALUES (@ CharName , @ NewCharID ) exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_SCROLL_RETURN_NEWBIE_01' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_MALL_REVERSE_RETURN_SCROLL' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_HP_SUPERSET_5_BAG' , 1000 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_MP_SUPERSET_5_BAG' , 1000 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_EVENT_RENT_ARCHEMY_POTION_SPEED_11' , 20 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_60EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1 IF Not Exists ( Select * From SRO_VT_ACCOUNT . dbo . SK_Silk Where JID = @ UserJID ) Begin INSERT INTO SRO_VT_ACCOUNT . dbo . SK_Silk ( JID , silk_own , silk_gift , silk_point ) VALUES (@ UserJID , 0 , 0 , 0 ); End -- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
05-03-2018, 08:24 PM
#12
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
06-03-2018, 11:17 AM
#14
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
06-03-2018, 12:20 PM
#15
• الانـتـسـاب » Nov 2015
• رقـم العـضـويـة » 128305
• المشـــاركـات » 63
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكله فى Create acc
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك
كود HTML معطلة
الساعة الآن 07:43 PM .