its make's High load iam right cuz my Pc restarting while the server is on
Btw my ram is 16 GP !!
its make's High load iam right cuz my Pc restarting while the server is on
Btw my ram is 16 GP !!
When i start do this Query i got error !!
this errorPHP Code:USE SRO_VT_SHARD
GO
CREATE PROCEDURE _GetRandomTime /*by Caipi*/
@TodaysDate datetime,
@EndDate datetime OUTPUT
AS BEGIN
SET @EndDate = GETDATE();
WHILE (@EndDate <= GETDATE())
BEGIN
DECLARE
@BasicDate varchar(12) = CONVERT(VARCHAR(10), @TodaysDate, 120),
@Hour varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*23,0))),
@Minutes varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*59,0))),
@Seconds varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*59,0)))
SET @EndDate = CONVERT(DATETIME,@BasicDate + ' ' + @Hour + ':' + @Minutes + ':' + @Seconds)
END
END
Code:Msg 156, Level 15, State 1, Procedure _GetRandomTime, Line 14 Incorrect syntax near the keyword 'CONVERT'. Msg 137, Level 15, State 2, Procedure _GetRandomTime, Line 19 Must declare the scalar variable "@BasicDate".
Same here :) Can you guys help? :) ThanksOriginally Posted by modog1545
You're using SQL'05,
you can't declare+set a variable at the same time there so simply..
instead of..PHP Code:DECLARE @BasicDate varchar(12), @Hour varchar(2), @Minutes varchar(2), @Seconds varchar(2);
SET @BasicDate = CONVERT(VARCHAR(10), @TodaysDate, 120),
SET @Hour = CONVERT(varchar(2),(ROUND(RAND()*23,0))),
SET @Minutes = CONVERT(varchar(2),(ROUND(RAND()*59,0))),
SET @Seconds = CONVERT(varchar(2),(ROUND(RAND()*59,0)))
PHP Code:DECLARE
@BasicDate varchar(12) = CONVERT(VARCHAR(10), @TodaysDate, 120),
@Hour varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*23,0))),
@Minutes varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*59,0))),
@Seconds varchar(2) = CONVERT(varchar(2),(ROUND(RAND()*59,0)))
There cud be more incompatibilities!
nice m8:D keep it up :) i have it already running hahahah nice
How To Change Time Of Give Silk And Change Number silk fast Please
Can u pls share query's for SQL'05 ?
Please :(
If you'll keep on doing this I'll prolly regret releasing this one ;x
7 hours of reading but it works now perfectly! Thanks Caipi :)
Not Work With SQL 2005 :(
when i user SRO_VT_ACCOUNTPHP Code:GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_extraSilk] /*by Caipi*/
@CharID int,
@Silk int
as
Declare @JID int, @Multiplier int = (SELECT [Silk/Hour] FROM SRO_VT_SHARDLOG.dbo._OnlineOffline WHERE CharID = @CharID);
SET @JID = (
SELECT usert.UserJID FROM SRO_VT_SHARD.dbo._User as usert
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
WHERE chart.CharID = @CharID
);
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
Give me ThatPHP Code:Msg 102, Level 15, State 1, Procedure _extraSilk, Line 9
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure _extraSilk, Line 23
Must declare the scalar variable "@Multiplier".
Last edited by st0o0ry; 30-05-12 at 07:09 AM.
there it is
oky Thank You
After using this cleanup script this auto silk stoped working.
It still count the minuntes and eSilk in the _onlineoffline table, but it does not load them to the sk_silk table.
Any idea what could have been changed so it stoped working?
Code:USE [SRO_VT_SHARD] GO TRUNCATE TABLE [dbo].[_Chest] TRUNCATE TABLE [dbo].[_ChestInfo] TRUNCATE TABLE [dbo].[_User] TRUNCATE TABLE [dbo].[_OpenMarket] DELETE FROM [dbo].[_AccountJID] TRUNCATE TABLE [dbo].[_GuildWar] TRUNCATE TABLE [dbo].[_GuildMember] TRUNCATE TABLE [dbo].[_GuildChest] TRUNCATE TABLE [dbo].[_SiegeFortressStruct] TRUNCATE TABLE [dbo].[_SiegeFortressObject] TRUNCATE TABLE [dbo].[_SiegeFortressItemForge] DELETE FROM [dbo].[_SiegeFortress] INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6) UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0' DELETE FROM [dbo].[_Guild] WHERE ID > 0 DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0 TRUNCATE TABLE [dbo].[_InventoryForAvatar] TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint] TRUNCATE TABLE [dbo].[_BlockedWhisperers] TRUNCATE TABLE [dbo].[_TrainingCampMember] TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade] DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_TimedJob] TRUNCATE TABLE [dbo].[_StaticAvatar] TRUNCATE TABLE [dbo].[_Inventory] TRUNCATE TABLE [dbo].[_Memo] TRUNCATE TABLE [dbo].[_FleaMarketNetwork] TRUNCATE TABLE [dbo].[_Friend] TRUNCATE TABLE [dbo].[_CharSkillMastery] TRUNCATE TABLE [dbo].[_CharSkill] TRUNCATE TABLE [dbo].[_InvCOS] DELETE FROM [dbo].[_CharCOS] WHERE ID > 0 DELETE FROM [dbo].[_Char] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_CharCollectionBook] TRUNCATE TABLE [dbo].[_CharInstanceWorldData] TRUNCATE TABLE [dbo].[_CharNameList] TRUNCATE TABLE [dbo].[_CharNickNameList] TRUNCATE TABLE [dbo].[_CharQuest] TRUNCATE TABLE [dbo].[_ClientConfig] TRUNCATE TABLE [dbo].[_DeletedChar] TRUNCATE TABLE [dbo].[_GPHistory] TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage] TRUNCATE TABLE [dbo].[_ItemPool] DELETE FROM [dbo].[_Items] WHERE ID64 > 0 TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET] TRUNCATE TABLE [dbo].[_TimedJobForPet] TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus] TRUNCATE TABLE [dbo].[_TrainingCampHonorRank] INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50) EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] DELETE FROM [dbo].[_TrainingCamp] TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution] USE [Log_DB] 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] USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[__SiegeFortressStatus__] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[_ShardCurrentUser] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[SK_DownLevelLog] 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_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_partnerInfo] TRUNCATE TABLE [dbo].[tb_paygate_trans] TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[Test_HN] UPDATE [dbo].[_ShardService] SET ShardID = '64'
Thx Caipi
But How i can Change The Silk Value ?
i don't Understand your Reply about it i don't Found The Silk Value To Change>
u can set it up on
USE SRO_VT_SHARDLOG
BEGIN TRY
DROP TABLE [_Silk/Hour-Config]
END TRY
BEGIN CATCH END CATCH;
CREATE TABLE [_Silk/Hour-Config] (
[Desc] varchar(max) NULL,
[DefaultSilk] int NOT NULL,
[Step1Silk] int NOT NULL,
[Step2Silk] int NOT NULL,
[Step3Silk] int NOT NULL,
[RewardSilk] int NOT NULL,
[WEEKDAYS] varchar(15) NULL
CHECK (
[WEEKDAYS] like 'Monday' OR
[WEEKDAYS] like 'Tuesday' OR
[WEEKDAYS] like 'Wednesday' OR
[WEEKDAYS] like 'Thursday' OR
[WEEKDAYS] like 'Friday' OR
[WEEKDAYS] like 'Saturday' OR
[WEEKDAYS] like 'Sunday'
)
);
INSERT INTO [_Silk/Hour-Config] SELECT 'Rates', 1, 2, 3, 4, 5, NULL <<<<<<<<<<<<<<<<<<<<<<<<<<<<< Setup your own lik 5,10 blblalba
INSERT INTO [_Silk/Hour-Config] SELECT 'Requirements', 0, (60*24*7), (60*24*30), (60*24*365), 0, NULL
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #1', 0, 0, 0, 0, 0, 'Monday' also u can changes this crap to
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #2', 0, 0, 0, 0, 0, 'Tuesday'
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #3', 0, 0, 0, 0, 0, 'Wednesday'
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #4', 0, 0, 0, 0, 0, 'Thursday'
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #5', 0, 0, 0, 0, 0, 'Friday'
i have it here already working :D nice job anyway :D
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #6', 0, 0, 0, 0, 0, 'Saturday'
INSERT INTO [_Silk/Hour-Config] SELECT 'allowed Day #7', 0, 0, 0, 0, 0, 'Sunday'
Reply With Quote