شـريـط الاهـداءات
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ]
04-10-2017, 04:27 AM
#1
• الانـتـسـاب » Aug 2017
• رقـم العـضـويـة » 133321
• المشـــاركـات » 203
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
مشكلة جااااامدة اووي يريت حل
كل ما اعمل ايميل جديد ! يكون الاسم متسمي يقولي Vaild ID و ادول confirm يقولي S1030
و اللي مش متسمي يقولي Vaild ID و يخش عادي
انا شيلت addnewchar اللي عندي و استخدمت ديه
بتاعة Hamzafigo
كود PHP:
USE [ SRO_VT_SHARD ]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 22/02/2015 07:33:11 م ******/
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 , HwanLevel )
VALUES (@ RefCharID , @ CharName , @ CharScale , 20 , 20 , @ StartRegionID , @ StartPos_X , @ StartPos_Y , @ StartPos_Z , @ DefaultTeleport , 109 ,
GetDate (), 1 , 1 , 1000000 , 0 , 1000000 , 200 , 200 , 1 , 1 , 1 , 1 , 0 )
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
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
-- µأ°أ†أ؛أ†®·أژ ¼±أ…أƒأ‡أ‘ ¾أ†أ€أŒأ…أ›أ€» ´أ™½أƒ ³أ–¾îأپأ–أ€أڑ ...
/* آ؟أ¤·± ¼أ¸¼*·أژ أپ¤أ€أ‡µأ‡¾î أ€أ–´أ™.
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
-- ¹أ™أپأ¶
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
-- أˆ¤½أƒ default·أژ ¼±أ…أƒأ‡أ‘ ¹«±â°آ، أˆ°أ€أŒ¶أ³¸é أˆ * »أ¬ 250°³µéأ€أŒ أˆ°أ…ëµµ أ‡أ”²² أپأک´أ™ . أپأ’أ„آ، ?
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 )
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!!
exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ...
COMMIT TRANSACTION
RETURN @ NewCharID
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
إعلانات google
04-10-2017, 10:33 PM
#2
• الانـتـسـاب » Apr 2017
• رقـم العـضـويـة » 132672
• المشـــاركـات » 1,355
• الـدولـة » GB
• الـهـوايـة » miMobXD
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 38
رد: مشكلة جااااامدة اووي يريت حل
اتفضيل يا معلم اعمل New Query و دوس F5
بعد ما تخالص الثلاثة دول تقفل game_server وتفتحوا تانى بعين إنزيل اللعبة اعمل الشخصية و مالكش دعوة B AddnewChar
كود:
USE [SRO_VT_ACCOUNT]---By= Erixon
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
كود:
USE [SRO_VT_SHARD]---By= Erixon
GO
truncate table _CharCollectionBook
truncate table _OpenMarket
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _Inventory
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampHonorRank
truncate table _TrainingCampBuffStatus
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _GPHistory
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
truncate table Guncel_Unique
truncate table UniqueRanking
truncate table Uniques
كود:
USE [SRO_VT_SHARDLOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]
[/QUOTE]
التعديل الأخير تم بواسطة Scrox ; 04-10-2017 الساعة 10:35 PM
05-10-2017, 03:11 AM
#3
• الانـتـسـاب » Aug 2017
• رقـم العـضـويـة » 133321
• المشـــاركـات » 203
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكلة جااااامدة اووي يريت حل
اقتباس:
المشاركة الأصلية كتبت بواسطة Erixon
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
اتفضيل يا معلم اعمل New Query و دوس F5
بعد ما تخالص الثلاثة دول تقفل game_server وتفتحوا تانى بعين إنزيل اللعبة اعمل الشخصية و مالكش دعوة B AddnewChar
كود:
USE [SRO_VT_ACCOUNT]---By= Erixon
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]
TRUNCATE TABLE [dbo].[_ShardCurrentUser]
TRUNCATE TABLE [dbo].[_PrivilegedIP]
كود:
USE [SRO_VT_SHARD]---By= Erixon
GO
truncate table _CharCollectionBook
truncate table _OpenMarket
truncate table _CharSkill
truncate table _CharSkillMastery
truncate table _GuildMember
truncate table _BlockedWhisperers
truncate table _Inventory
truncate table _InventoryForAvatar
truncate table _InventoryForLinkedStorage
truncate table _TrainingCampMember
truncate table _TrainingCampSubMentorHonorPoint
truncate table _TrainingCampHonorRank
truncate table _TrainingCampBuffStatus
delete from _TrainingCamp
truncate table _StaticAvatar
truncate table _User
truncate table _Friend
truncate table _GPHistory
truncate table _Memo
truncate table _TimedJob
truncate table _CharTrijobSafeTrade
delete from _CharTrijob
truncate table _InvCOS
delete from _CharCOS where ID > 0
delete from _Char where charid > 0
truncate table _Chest
truncate table _ChestInfo
truncate table _ItemPool
delete from _Items where ID64 > 0
delete from _AccountJID
truncate table _GuildChest
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0
truncate table _GuildWar
delete from _Guild where ID > 0
delete from _AlliedClans where ID > 0
truncate table _CharNameList
truncate table _CharQuest
truncate table _ClientConfig
truncate table _DeletedChar
truncate table _SiegeFortressStruct
truncate table _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
delete from _SiegeFortress
truncate table Guncel_Unique
truncate table UniqueRanking
truncate table Uniques
كود:
USE [SRO_VT_SHARDLOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]
[/QUOTE]
نعممممم ؟ الجيم فيها بلاير يا باشا الجيم اونلاين
06-10-2017, 05:26 PM
#4
• الانـتـسـاب » Mar 2015
• رقـم العـضـويـة » 121247
• المشـــاركـات » 3,304
• الـدولـة » مصر
• الـهـوايـة » ذكر الله ~ لا اله الا الله ~
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 98
رد: مشكلة جااااامدة اووي يريت حل
إتاكد انك فاتح الخرايط
وإعمل Restore
توقيع Neoon
:
سبحان الله وبحمده
لا اله الا الله محمد رسول الله
الله اكبر - ماشاء الله
اللهم ارزقنا حسن الخاتمة
اللهم انك عفو كريم تحب العفو فأعف عنا
اللهم صل وسلم على سيدنا محمد
[ اسماء الله الحسنى ]
قال رسول الله صلى الله عليه وسلم
إن لله تسعة وتسعين اسما ، مائة إلا واحدا ، من أحصاها دخل الجنة [/CENTER]
06-10-2017, 05:50 PM
#5
• الانـتـسـاب » Aug 2017
• رقـم العـضـويـة » 133321
• المشـــاركـات » 203
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكلة جااااامدة اووي يريت حل
اقتباس:
المشاركة الأصلية كتبت بواسطة Iron.Man
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
إتاكد انك فاتح الخرايط
وإعمل Restore
يافندم الجيم اونلاين ! و الخرايط كلها مفتوحة
06-10-2017, 06:02 PM
#6
• الانـتـسـاب » Mar 2015
• رقـم العـضـويـة » 121247
• المشـــاركـات » 3,304
• الـدولـة » مصر
• الـهـوايـة » ذكر الله ~ لا اله الا الله ~
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 98
رد: مشكلة جااااامدة اووي يريت حل
طيب حط الـ addnewchar دي بدل الي عندك
كود PHP:
USE [ SRO_VT_SHARD ] GO /****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 01/09/2014 06:22:06 ******/ 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 -- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! -- µأ°أ†أ؛أ†®·أژ ¼±أ…أƒأ‡أ‘ ¾أ†أ€أŒأ…أ›أ€» ´أ™½أƒ ³أ–¾îأپأ–أ€أڑ ... /* آ؟أ¤·± ¼أ¸¼*·أژ أپ¤أ€أ‡µأ‡¾î أ€أ–´أ™. 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 -- ¹أ™أپأ¶ 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 -- أˆ¤½أƒ default·أژ ¼±أ…أƒأ‡أ‘ ¹«±â°آ، أˆ°أ€أŒ¶أ³¸é أˆ * »أ¬ 250°³µéأ€أŒ أˆ°أ…ëµµ أ‡أ”²² أپأک´أ™ . أپأ’أ„آ، ? 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_E060118_60EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1 exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_SCROLL_RETURN_NEWBIE_01' , 20 , 1 -- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!! exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ... COMMIT TRANSACTION RETURN @ NewCharID
او حضرتك مغير اسامى الداتا بيز
خليهم زى كده بالظبط
توقيع Neoon
:
سبحان الله وبحمده
لا اله الا الله محمد رسول الله
الله اكبر - ماشاء الله
اللهم ارزقنا حسن الخاتمة
اللهم انك عفو كريم تحب العفو فأعف عنا
اللهم صل وسلم على سيدنا محمد
[ اسماء الله الحسنى ]
قال رسول الله صلى الله عليه وسلم
إن لله تسعة وتسعين اسما ، مائة إلا واحدا ، من أحصاها دخل الجنة [/CENTER]
07-10-2017, 03:34 PM
#7
• الانـتـسـاب » Aug 2017
• رقـم العـضـويـة » 133321
• المشـــاركـات » 203
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 10
رد: مشكلة جااااامدة اووي يريت حل
اقتباس:
المشاركة الأصلية كتبت بواسطة Iron.Man
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
طيب حط الـ addnewchar دي بدل الي عندك
كود PHP:
USE [ SRO_VT_SHARD ]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 01/09/2014 06:22:06 ******/
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
-- PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!! PATCH WARNING !!!
-- µأ°أ†أ؛أ†®·أژ ¼±أ…أƒأ‡أ‘ ¾أ†أ€أŒأ…أ›أ€» ´أ™½أƒ ³أ–¾îأپأ–أ€أڑ ...
/* آ؟أ¤·± ¼أ¸¼*·أژ أپ¤أ€أ‡µأ‡¾î أ€أ–´أ™.
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
-- ¹أ™أپأ¶
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
-- أˆ¤½أƒ default·أژ ¼±أ…أƒأ‡أ‘ ¹«±â°آ، أˆ°أ€أŒ¶أ³¸é أˆ * »أ¬ 250°³µéأ€أŒ أˆ°أ…ëµµ أ‡أ”²² أپأک´أ™ . أپأ’أ„آ، ?
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_E060118_60EXP_HELP' , 1 , 1
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_E060118_100EXP_HELP' , 1 , 1
exec _ADD_ITEM_EXTERN @ CharName , 'ITEM_ETC_SCROLL_RETURN_NEWBIE_01' , 20 , 1
-- Quick Slot أپ¤آ؛¸ أ€أ؛أ€أ¥آ؟ë !!!
exec _AddNewClientConfig @ NewCharID -- by novice ...... for saving client configurations ...
COMMIT TRANSACTION
RETURN @ NewCharID
او حضرتك مغير اسامى الداتا بيز
خليهم زى كده بالظبط
لا الداتا زي ما هي مش مغير بس انا هجرب Addnewchar ده
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك
كود HTML معطلة
الساعة الآن 10:47 PM .