مشاهدة النسخة كاملة : عاوز احدد لفل الاكونت اللى بيشترى بسيلك
GM_Jo
09-09-2017, 03:43 AM
بعد إذن الناس انا بعيد بقالى فتره وفى حاجة مش قادر اوصلها
عاوز احدد لفل لاى حد يشترى بسيلك
بمعنى ان لو حد معاه سيلك مينفعش يشترى بيه غير لما يوصل لفل 100 مثلا
ولكم جزيل الشكر
Neoon
09-09-2017, 10:47 AM
انا مش عارف اوصل ل طلبك بالظبط
بس دور " هنا (http://www.silkroad4arab.com/vb/showthread.php?t=522775)" ان شاء الله تلاقي الي انت عايزه
GM_Jo
10-09-2017, 02:34 AM
انا مش عارف اوصل ل طلبك بالظبط
بس دور " هنا (http://www.silkroad4arab.com/vb/showthread.php?t=522775)" ان شاء الله تلاقي الي انت عايزه
مفيهوش حاجة بخصوص طلبى
فين عباقرة S4A مكنش فيه طلب صعب هنا
renomustdie
10-09-2017, 02:36 AM
طيب ممكن تعكسها مثلا محدش ياخد سيلك غير لما يوصل لفل 100
كده ممكن اساعدك فيها هتلاقي شرحها هنا
http://www.silkroad4arab.com/vb/showthread.php?t=604687
GM_Jo
10-09-2017, 04:29 AM
طيب ممكن تعكسها مثلا محدش ياخد سيلك غير لما يوصل لفل 100
كده ممكن اساعدك فيها هتلاقي شرحها هنا
http://www.silkroad4arab.com/vb/showthread.php?t=604687
انا بشكر حضرتك طبعآ على اهتمامك
بس انت مش فاهم قصدى انا عامل سيستم فرى سيلك كل ساعة
وطبعآ زى ما انت عارف ممكن واحد يفتح اكونتات ملهاش لازمة وتاخد سيلك فرى وطبعا من لفل 1 يقدر يشترى بيه اى حاجة
ف انا عاوز اخلى الكاركتر مينفعش يشترى ايتم سيلك غير لما يوصل لفل معين
وشكرآ لحضرتك كمان مره اتمنى حد يفيدنى
Neoon
10-09-2017, 11:31 AM
تحط دى مكان addlogchar يتاعت Silk Per Hour System
الليفل هوا اللى باللون الاحمر علشان لو حبيت تغيروه
IF (@CharID IN (select charid from SRO_VT_SHARD.dbo._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT.dbo.TB_User with (nolock) where sec_content = 3))
and exists (Select * from SRO_VT_SHARD.dbo._Char where CurLevel = '120' and CharID = @charid)
and not exists (SELECT CharID FROM _OnlineOffline WHERE CharID = @CharID) )
BEGIN
INSERT INTO _OnlineOffline (CharID, Charname, [Status], [Date], [Minutes], [tMinutes], eSilk, mOnline, [Silk/Hour], [stillOnline@])
VALUES (
@CharID,
(SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID),
'OnHold',
GETDATE(),
0,0,0,
NULL,(SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates'),
NULL
);
END
IF (@EventID = 4 OR @EventID = 6)
BEGIN
IF (@EventID = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = @CharID) like 'OnHold'))
BEGIN
UPDATE _OnlineOffline
SET [Status] = 'Offline'
WHERE CharID = @CharID
END
IF (@EventID = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = @CharID) like 'Online'))
BEGIN
UPDATE _OnlineOffline
SET
[Status] = 'Offline',
[Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[mOnline] = NULL,
[stillOnline@] = NULL
WHERE CharID = @CharID
END
IF (@EventID = 4)
BEGIN
UPDATE _OnlineOffline
SET
[Status] = 'Online',
[Date] = GETDATE(),
[stillOnline@] = GETDATE()
WHERE CharID = @CharID
END
END
UPDATE _OnlineOffline
SET
[mOnline] = CAST((DATEDIFF(MINUTE,[Date],GETDATE()))as varchar(max)) + ' minute(s) Online',
[Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[stillOnline@] = GETDATE()
WHERE [Status] like 'Online'
/*Silk/Hour basic calc*/
IF ((SELECT [tMinutes] from _OnlineOffline WHERE CharID = @CharID) >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements'))
BEGIN
Declare @sph int;
exec @sph = [_GetSilkperHour] @CharID
UPDATE _OnlineOffline SET [Silk/Hour] = @sph WHERE CharID = @CharID
END
/*!Silk/Hour basic calc*/
IF (((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') IS NULL))
BEGIN
DECLARE @FirstDate datetime, @Today datetime = GETDATE(), @FirstCharID int;
exec @FirstCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime @Today, @FirstDate OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = @FirstDate,
RefreshedDate = GETDATE(),
CharID = @FirstCharID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @FirstCharID)
WHERE [Desc] like 'Next';
END
IF ((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') <= GETDATE())
BEGIN
UPDATE _OnlineOffline
SET [Silk/Hour] = (SELECT RewardSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
WHERE CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next');
Declare
@CurSilkperHour int,
@OldCharID int = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Current');
IF (@OldCharID IS NOT NULL)
BEGIN
exec @CurSilkperHour = _GetSilkperHour @OldCharID
UPDATE _OnlineOffline
SET [Silk/Hour] = @CurSilkperHour
WHERE CharID = @OldCharID;
END
UPDATE [_RandomPlayer&Date]
SET
NextDate = NULL,
RefreshedDate = GETDATE(),
CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next'),
Charname = (SELECT Charname FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next')
WHERE [Desc] like 'Current'
/*new Random Time of Today+1*/
DECLARE @NextDate datetime, @Tomorrow datetime = GETDATE()+1, @NewCharID int;
exec @NewCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime @Tomorrow, @NextDate OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = @NextDate,
RefreshedDate = GETDATE(),
CharID = @NewCharID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @NewCharID)
WHERE [Desc] like 'Next'
/*!new Random...*/
END
/*Calculation of the silk amount*/
Declare @tMinutes bigint = (SELECT [Minutes] from _OnlineOffline WHERE CharID = @CharID), @Silk int;
IF (@tMinutes >= 60)
BEGIN
SET @Silk = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = @CharID) / 60) as int)
UPDATE _OnlineOffline
SET [Minutes] = [Minutes] % 60
WHERE CharID = @CharID
IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like DATENAME(WEEKDAY, GETDATE()))
BEGIN
UPDATE _OnlineOffline
SET [eSilk] = [eSilk] + (@Silk*[Silk/Hour])
WHERE CharID = @CharID
exec SRO_VT_ACCOUNT.dbo._extraSilk @CharID, @Silk
END
END
GM_Jo
11-09-2017, 10:41 AM
تحط دى مكان addlogchar يتاعت Silk Per Hour System
الليفل هوا اللى باللون الاحمر علشان لو حبيت تغيروه
IF (@CharID IN (select charid from SRO_VT_SHARD.dbo._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT.dbo.TB_User with (nolock) where sec_content = 3))
and exists (Select * from SRO_VT_SHARD.dbo._Char where CurLevel = '120' and CharID = @charid)
and not exists (SELECT CharID FROM _OnlineOffline WHERE CharID = @CharID) )
BEGIN
INSERT INTO _OnlineOffline (CharID, Charname, [Status], [Date], [Minutes], [tMinutes], eSilk, mOnline, [Silk/Hour], [stillOnline@])
VALUES (
@CharID,
(SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID),
'OnHold',
GETDATE(),
0,0,0,
NULL,(SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates'),
NULL
);
END
IF (@EventID = 4 OR @EventID = 6)
BEGIN
IF (@EventID = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = @CharID) like 'OnHold'))
BEGIN
UPDATE _OnlineOffline
SET [Status] = 'Offline'
WHERE CharID = @CharID
END
IF (@EventID = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = @CharID) like 'Online'))
BEGIN
UPDATE _OnlineOffline
SET
[Status] = 'Offline',
[Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[mOnline] = NULL,
[stillOnline@] = NULL
WHERE CharID = @CharID
END
IF (@EventID = 4)
BEGIN
UPDATE _OnlineOffline
SET
[Status] = 'Online',
[Date] = GETDATE(),
[stillOnline@] = GETDATE()
WHERE CharID = @CharID
END
END
UPDATE _OnlineOffline
SET
[mOnline] = CAST((DATEDIFF(MINUTE,[Date],GETDATE()))as varchar(max)) + ' minute(s) Online',
[Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
[stillOnline@] = GETDATE()
WHERE [Status] like 'Online'
/*Silk/Hour basic calc*/
IF ((SELECT [tMinutes] from _OnlineOffline WHERE CharID = @CharID) >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements'))
BEGIN
Declare @sph int;
exec @sph = [_GetSilkperHour] @CharID
UPDATE _OnlineOffline SET [Silk/Hour] = @sph WHERE CharID = @CharID
END
/*!Silk/Hour basic calc*/
IF (((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') IS NULL))
BEGIN
DECLARE @FirstDate datetime, @Today datetime = GETDATE(), @FirstCharID int;
exec @FirstCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime @Today, @FirstDate OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = @FirstDate,
RefreshedDate = GETDATE(),
CharID = @FirstCharID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @FirstCharID)
WHERE [Desc] like 'Next';
END
IF ((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') <= GETDATE())
BEGIN
UPDATE _OnlineOffline
SET [Silk/Hour] = (SELECT RewardSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
WHERE CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next');
Declare
@CurSilkperHour int,
@OldCharID int = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Current');
IF (@OldCharID IS NOT NULL)
BEGIN
exec @CurSilkperHour = _GetSilkperHour @OldCharID
UPDATE _OnlineOffline
SET [Silk/Hour] = @CurSilkperHour
WHERE CharID = @OldCharID;
END
UPDATE [_RandomPlayer&Date]
SET
NextDate = NULL,
RefreshedDate = GETDATE(),
CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next'),
Charname = (SELECT Charname FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next')
WHERE [Desc] like 'Current'
/*new Random Time of Today+1*/
DECLARE @NextDate datetime, @Tomorrow datetime = GETDATE()+1, @NewCharID int;
exec @NewCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime @Tomorrow, @NextDate OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = @NextDate,
RefreshedDate = GETDATE(),
CharID = @NewCharID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @NewCharID)
WHERE [Desc] like 'Next'
/*!new Random...*/
END
/*Calculation of the silk amount*/
Declare @tMinutes bigint = (SELECT [Minutes] from _OnlineOffline WHERE CharID = @CharID), @Silk int;
IF (@tMinutes >= 60)
BEGIN
SET @Silk = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = @CharID) / 60) as int)
UPDATE _OnlineOffline
SET [Minutes] = [Minutes] % 60
WHERE CharID = @CharID
IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like DATENAME(WEEKDAY, GETDATE()))
BEGIN
UPDATE _OnlineOffline
SET [eSilk] = [eSilk] + (@Silk*[Silk/Hour])
WHERE CharID = @CharID
exec SRO_VT_ACCOUNT.dbo._extraSilk @CharID, @Silk
END
END
تســــــــــــــــــــــــــــــــــــــــلم يا بطل هجربها دلوقتى وارد عليك
GM_Jo
11-09-2017, 11:31 AM
جربت وبردو نفس المشكلة اى اكونت لفل اقل من 120 بيشترى بسيلك
Neoon
11-09-2017, 12:42 PM
جرب كدا الكويري ده وباذن الله هينفع
Use SRO_VT_SHARD_INIT
GO
DECLARE @Level tinyint = 105 --Your Minimum Level here
UPDATE dbo.[_Silk/Hour-Config]
SET Value = @Level
WHERE ValueCodeName128='ENTER_LIMIT_CONDITION_LEVEL_MINI MUM_NUM'
لو منفعش معاك حاول تغير الـ dbo.[_Silk/Hour-Config غيرها للداتا بتاعت الbuy انا مش عارف اسمها بالظبط
GM_Jo
11-09-2017, 04:23 PM
جرب كدا الكويري ده وباذن الله هينفع
Use SRO_VT_SHARD_INIT
GO
DECLARE @Level tinyint = 105 --Your Minimum Level here
UPDATE dbo.[_Silk/Hour-Config]
SET Value = @Level
WHERE ValueCodeName128='ENTER_LIMIT_CONDITION_LEVEL_MINI MUM_NUM'
لو منفعش معاك حاول تغير الـ dbo.[_Silk/Hour-Config غيرها للداتا بتاعت الbuy انا مش عارف اسمها بالظبط
الكويرى منفعش
وده الجدول اللى عندى فى dbo.[_Silk/Hour-Config
Rates 1 2 3 4 1 NULL
Requirements 1 10080 43200 525600 1 NULL
allowed Day #1 1 0 0 0 1 Monday
allowed Day #2 1 0 0 0 1 Tuesday
allowed Day #3 1 0 0 0 1 Wednesday
allowed Day #4 1 0 0 0 1 Thursday
allowed Day #5 1 0 0 0 1 Friday
allowed Day #6 1 0 0 0 1 Saturday
allowed Day #7 1 0 0 0 1 Sunday
Neoon
11-09-2017, 04:24 PM
فين الجدول ؟
GM_Jo
11-09-2017, 04:26 PM
فين الجدول ؟
تم التعديل
Neoon
11-09-2017, 05:02 PM
بص انا الكويري الي ادتهولك ده الي بيحدد اللفل زي ماقلت لك بس مش عارف مش نافع ليه بصراحه انا مش عارف اكتر من كدة عشان ماكونش بفتي عليك او اديك حاجه غلط انا قلت لك الي اعرفه , و تقريبا الي انت بتقوله ده مينفعش لاني مشوفتوش قبل كدة هو اقصى حاجه ممكن تعملها انك تحدد لفل الاكونت الي بياخد سيلك لكن تحدد لفل اكونت بيشتري سيلك دي مشوفتهاش
حاول تجرب انت بقا او انتظر رد الاعضاء و اسف اني مقدرتش افيدك
GM_Jo
11-09-2017, 05:21 PM
بص انا الكويري الي ادتهولك ده الي بيحدد اللفل زي ماقلت لك بس مش عارف مش نافع ليه بصراحه انا مش عارف اكتر من كدة عشان ماكونش بفتي عليك او اديك حاجه غلط انا قلت لك الي اعرفه , و تقريبا الي انت بتقوله ده مينفعش لاني مشوفتوش قبل كدة هو اقصى حاجه ممكن تعملها انك تحدد لفل الاكونت الي بياخد سيلك لكن تحدد لفل اكونت بيشتري سيلك دي مشوفتهاش
حاول تجرب انت بقا او انتظر رد الاعضاء و اسف اني مقدرتش افيدك
الف شكر يا كبير على تعبك معايا ومتابعتك للموضوع
طيب ازاى احدد لفل اللى بياخد سيلك بلاش اللى بيشترى بسيلك
مع العلم ان البروسيدور اللى انت اديتهولى فوق منفعش اللى بحطه فى dbo_AddLogChar
عملته وجربت 2 اكونت واحد لفل 120 وواحد لفل 57 والاثنين جالهم سيلك
ياريت لو عندك ملفات السيستم ده متعدله باللفل ترفعهالى ويبقى كتر خير
Neoon
11-09-2017, 05:39 PM
اعمل سيستم جديد عشان شكل الي عندك فيه مشكلة من " هنا (http://www.silkroad4arab.com/vb/showthread.php?t=461170)"
ولو عاوز ملفات الـ txt حملها من هنا (http://www25.zippyshare.com/v/45095817/file.html) ( مش متعدلة بس انت اعمل زي ماقلتلك في الرد (http://www.silkroad4arab.com/vb/showpost.php?p=5327614&postcount=6) الي فوق في ملفات ال txt الي ادتهالك وهتشتغل باذن الله )
GM_Jo
11-09-2017, 05:52 PM
اعمل سيستم جديد عشان شكل الي عندك فيه مشكلة من " هنا (http://www.silkroad4arab.com/vb/showthread.php?t=461170)"
ولو عاوز ملفات الـ txt حملها من هنا (http://www25.zippyshare.com/v/45095817/file.html) ( مش متعدلة بس انت اعمل زي ماقلتلك في الرد (http://www.silkroad4arab.com/vb/showpost.php?p=5327614&postcount=6) الي فوق في ملفات ال txt الي ادتهالك وهتشتغل باذن الله )
هو ده السيستم اللى انا عامله
مش عارف بقى المشكلة فى ايه
GM_Jo
11-09-2017, 05:52 PM
اعمل سيستم جديد عشان شكل الي عندك فيه مشكلة من " هنا (http://www.silkroad4arab.com/vb/showthread.php?t=461170)"
ولو عاوز ملفات الـ txt حملها من هنا (http://www25.zippyshare.com/v/45095817/file.html) ( مش متعدلة بس انت اعمل زي ماقلتلك في الرد (http://www.silkroad4arab.com/vb/showpost.php?p=5327614&postcount=6) الي فوق في ملفات ال txt الي ادتهالك وهتشتغل باذن الله )
هو ده السيستم اللى انا عامله ونفس الملفات دى
مش عارف بقى المشكلة فى ايه
Neoon
11-09-2017, 06:14 PM
طب جرب سيستم غيره يمكن المشكلة من السيستم نفسو..
انصحك تعمل كلين داتا بيز وترجع تعمل البروسيدر الي قلتلك عليه
ده كلين داتا بيز
SRO_VT_ACCOUNT
USE [SRO_VT_ACCOUNT]
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]
SRO_VT_LOG
USE [SRO_VT_LOG]
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]
SRO_VT_SHARD
USE [SRO_VT_SHARD]
GO
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 _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 _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
truncate table _CharNickNameList
truncate table _GPHistory
واعمل الكويري ده برضو
USE[SRO_VT_SHARD]
UPDATE [_RefSkill]SET[Param24]=25 WHERE Basic_Code='SKILL_CH_COLD_GANGGI_A_04'--Restart GameServer
GM_Jo
11-09-2017, 09:25 PM
طب جرب سيستم غيره يمكن المشكلة من السيستم نفسو..
انصحك تعمل كلين داتا بيز وترجع تعمل البروسيدر الي قلتلك عليه
ده كلين داتا بيز
SRO_VT_ACCOUNT
USE [SRO_VT_ACCOUNT]
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]
SRO_VT_LOG
USE [SRO_VT_LOG]
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]
SRO_VT_SHARD
USE [SRO_VT_SHARD]
GO
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 _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 _SiegeFortressStoneState
truncate table _SiegeFortressRequest
truncate table _SiegeFortressObject
truncate table _SiegeFortressItemForge
truncate table _SiegeFortressBattleRecord
UPDATE _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL
truncate table _CharNickNameList
truncate table _GPHistory
واعمل الكويري ده برضو
USE[SRO_VT_SHARD]
UPDATE [_RefSkill]SET[Param24]=25 WHERE Basic_Code='SKILL_CH_COLD_GANGGI_A_04'--Restart GameServer
هجرب ان شاء الله ينفع الكلام ده
GM_Jo
12-09-2017, 12:06 PM
تمام تم حل المشكلة
وعشان الاعضاء تستفيد
تم التعديل على البورسيدور ده فى dbo._extraSilk
USE [SRO_R_Accountdb]
GO
/****** Object: StoredProcedure [dbo].[_extraSilk] Script Date: 12/09/2017 11:03:03 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_extraSilk] /*by GM_Jo*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_FEIER_SHARDDB_LOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_FEIER_SHARDDB.dbo._User as usert
JOIN SRO_FEIER_SHARDDB.dbo._Char as chart on usert.CharID = chart.CharID and CurLevel = '120'
WHERE chart.CharID = @CharID and CurLevel = '120'
);
IF not exists (SELECT JID FROM SK_Silk WHERE JID = @JID)
BEGIN
INSERT INTO SK_Silk SELECT @JID, 0, 0, 0
END
UPDATE SK_Silk
SET silk_own = silk_own + (@Silk*@Multiplier)
WHERE JID = @JID
## يغلق ومش عارف مين اللى اختار افضل اجابة ##
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc