1 UIO_SECOND_HWAN_CH_NAME_LEVEL_7 ???? 0 0 0 0 0 King King 0 0 0 0 0 0
textobjdata
Code:
1 SN_ITEM_SRONAY_TITLE_01 ???? ?? 0 0 0 0 0 Scroll King Scroll King 0 0 0 0 0 0
_AddLogChar
Code:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 5/11/2017 00:36:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddLogChar]
[MENTION=395373]Chari[/MENTION]D int,
[MENTION=1134588]item[/MENTION]RefID int, [MENTION=1059401]operation[/MENTION] tinyint,
[MENTION=2220328]Eventi[/MENTION]D tinyint,
[MENTION=2397832]data1[/MENTION] int,
[MENTION=336745]DaTa[/MENTION]2 int, [MENTION=414808]str[/MENTION]Pos varchar(64),
[MENTION=316630]DEsc[/MENTION] varchar(128)
as
-- Title Scroll
IF [MENTION=1059401]operation[/MENTION] = '16'
BEGIN
IF [MENTION=1134588]item[/MENTION]RefID = 418222)
BEGIN
DECLARE [MENTION=325360]hwan[/MENTION]Level tinyint
SELECT [MENTION=325360]hwan[/MENTION]Level=HwanLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=395373]Chari[/MENTION]D
UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 3 WHERE CharID = [MENTION=395373]Chari[/MENTION]D
END
END
IF ( -- Skips over the unnecessary Records
[MENTION=2220328]Eventi[/MENTION]D != 11) AND
[MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 21 AND 27) AND
[MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 200 AND 202) AND
[MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 204 AND 206) AND
[MENTION=2220328]Eventi[/MENTION]D != 210) AND [MENTION=2220328]Eventi[/MENTION]D != 214) AND [MENTION=2220328]Eventi[/MENTION]D != 244)
)BEGIN
declare [MENTION=319410]Len[/MENTION]_pos int
declare [MENTION=319410]Len[/MENTION]_desc int
set [MENTION=319410]Len[/MENTION]_pos = len [MENTION=414808]str[/MENTION]Pos)
set [MENTION=319410]Len[/MENTION]_desc = len [MENTION=316630]DEsc[/MENTION])
if [MENTION=319410]Len[/MENTION]_pos > 0 and [MENTION=319410]Len[/MENTION]_desc > 0)
begin
insert _LogEventChar values [MENTION=395373]Chari[/MENTION]D, GetDate(), [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2, [MENTION=414808]str[/MENTION]Pos, [MENTION=316630]DEsc[/MENTION])
end
else if [MENTION=319410]Len[/MENTION]_pos > 0 and [MENTION=319410]Len[/MENTION]_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values [MENTION=395373]Chari[/MENTION]D, GetDate(), [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2, [MENTION=414808]str[/MENTION]Pos)
end
else if [MENTION=319410]Len[/MENTION]_pos = 0 and [MENTION=319410]Len[/MENTION]_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values [MENTION=395373]Chari[/MENTION]D, GetDate(), [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2, [MENTION=316630]DEsc[/MENTION])
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values [MENTION=395373]Chari[/MENTION]D, GetDate(), [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2)
end
/*Extension*/--> by Caipi
IF not exists (SELECT CharID FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D)
BEGIN
INSERT INTO _OnlineOffline (CharID, Charname, [Status], [Date], [Minutes], [tMinutes], eSilk, mOnline, [Silk/Hour], [stillOnline@])
VALUES (
[MENTION=395373]Chari[/MENTION]D,
(SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=395373]Chari[/MENTION]D),
'OnHold',
GETDATE(),
0,0,0,
NULL,(SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates'),
NULL
);
END
IF [MENTION=2220328]Eventi[/MENTION]D = 4 OR [MENTION=2220328]Eventi[/MENTION]D = 6)
BEGIN
IF [MENTION=2220328]Eventi[/MENTION]D = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) like 'OnHold'))
BEGIN
UPDATE _OnlineOffline
SET [Status] = 'Offline'
WHERE CharID = [MENTION=395373]Chari[/MENTION]D
END
IF [MENTION=2220328]Eventi[/MENTION]D = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) 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 = [MENTION=395373]Chari[/MENTION]D
END
IF [MENTION=2220328]Eventi[/MENTION]D = 4)
BEGIN
UPDATE _OnlineOffline
SET
[Status] = 'Online',
[Date] = GETDATE(),
[stillOnline@] = GETDATE()
WHERE CharID = [MENTION=395373]Chari[/MENTION]D
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 [MENTION=2220328]Eventi[/MENTION]D = '4' OR [MENTION=2220328]Eventi[/MENTION]D = '6')
BEGIN
UPDATE SRO_VT_SHARD.DBO._Items SET OptLevel = '12' where OptLevel > '13'
end
IF ((SELECT [tMinutes] from _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements'))
BEGIN
Declare [MENTION=955435]SPH[/MENTION] int;
exec [MENTION=955435]SPH[/MENTION] = [_GetSilkperHour] [MENTION=395373]Chari[/MENTION]D
UPDATE _OnlineOffline SET [Silk/Hour] = [MENTION=955435]SPH[/MENTION] WHERE CharID = [MENTION=395373]Chari[/MENTION]D
END
/*!Silk/Hour basic calc*/
IF (((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') IS NULL))
BEGIN
DECLARE [MENTION=486595]First[/MENTION]Date datetime, [MENTION=456996]today[/MENTION] datetime = GETDATE(), [MENTION=486595]First[/MENTION]CharID int;
exec [MENTION=486595]First[/MENTION]CharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime [MENTION=456996]today[/MENTION], [MENTION=486595]First[/MENTION]Date OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = [MENTION=486595]First[/MENTION]Date,
RefreshedDate = GETDATE(),
CharID = [MENTION=486595]First[/MENTION]CharID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=486595]First[/MENTION]CharID)
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
[MENTION=3483390]CurSi[/MENTION]lkperHour int,
[MENTION=2256426]OldC[/MENTION]harID int = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Current');
IF [MENTION=2256426]OldC[/MENTION]harID IS NOT NULL)
BEGIN
exec [MENTION=3483390]CurSi[/MENTION]lkperHour = _GetSilkperHour [MENTION=2256426]OldC[/MENTION]harID
UPDATE _OnlineOffline
SET [Silk/Hour] = [MENTION=3483390]CurSi[/MENTION]lkperHour
WHERE CharID = [MENTION=2256426]OldC[/MENTION]harID;
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 [MENTION=2919027]nextdate[/MENTION] datetime, [MENTION=348406]Tomorrow[/MENTION] datetime = GETDATE()+1, [MENTION=993253]newchar[/MENTION]ID int;
exec [MENTION=993253]newchar[/MENTION]ID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime [MENTION=348406]Tomorrow[/MENTION], [MENTION=2919027]nextdate[/MENTION] OUTPUT
UPDATE [_RandomPlayer&Date]
SET
NextDate = [MENTION=2919027]nextdate[/MENTION],
RefreshedDate = GETDATE(),
CharID = [MENTION=993253]newchar[/MENTION]ID,
Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=993253]newchar[/MENTION]ID)
WHERE [Desc] like 'Next'
/*!new Random...*/
END
/*Calculation of the silk amount*/
Declare [MENTION=3394895]Tmi[/MENTION]nutes bigint = (SELECT [Minutes] from _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D), [MENTION=292158]Silk[/MENTION] int;
IF [MENTION=3394895]Tmi[/MENTION]nutes >= 60)
BEGIN
SET [MENTION=292158]Silk[/MENTION] = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) / 60) as int)
UPDATE _OnlineOffline
SET [Minutes] = [Minutes] % 60
WHERE CharID = [MENTION=395373]Chari[/MENTION]D
IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like DATENAME(WEEKDAY, GETDATE()))
BEGIN
UPDATE _OnlineOffline
SET [eSilk] = [eSilk] + [MENTION=292158]Silk[/MENTION]*[Silk/Hour])
WHERE CharID = [MENTION=395373]Chari[/MENTION]D
exec SRO_VT_ACCOUNT.dbo._extraSilk [MENTION=395373]Chari[/MENTION]D, [MENTION=292158]Silk[/MENTION]
END
END
/*!Calc*/
/*!Extension*/
END -- !Skipping
and i try with this
Code:
IF ( [MENTION=1059401]operation[/MENTION]=41) AND [MENTION=1134588]item[/MENTION]RefID=418222))
BEGIN
UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 7 Where CharID = [MENTION=395373]Chari[/MENTION]D
END
if (@ItemRefID = 50137 and [MENTION=1059401]operation[/MENTION] = 16)begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 40 where CharID = [MENTION=395373]Chari[/MENTION]D end
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_40 ???? 0 0 0 0 0 Your Title Your Title 0 0 0 0 0 0
textdata_object
PHP Code:
1 SN_ITEM_VALTYR_TITLE_1 ?? 0 0 0 0 0 Your Title Your Title Your Title
1 SN_ITEM_VALTYR_TITLE_1_TT_DESC ?? 0 0 0 0 0 <sml2>Gives you a title once used.</sml2> <sml2>Gives you a title once used.</sml2> <sml2>Gives you a title once used.</sml2>
if (@ItemRefID = 50137 and [MENTION=1059401]operation[/MENTION] = 16)begin
update SRO_VT_SHARD.dbo._Char set HwanLevel = 40 where CharID = [MENTION=395373]Chari[/MENTION]D
end
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_40 ???? 0 0 0 0 0 Your Title Your Title 0 0 0 0 0 0
textdata_object
PHP Code:
1 SN_ITEM_VALTYR_TITLE_1 ?? 0 0 0 0 0 Your Title Your Title Your Title
1 SN_ITEM_VALTYR_TITLE_1_TT_DESC ?? 0 0 0 0 0 <sml2>Gives you a title once used.</sml2> <sml2>Gives you a title once used.</sml2> <sml2>Gives you a title once used.</sml2>
Title as textfile added
Hello Thanks for replying, check again and I have everything right and it still does not work and now I have this error
[Q] Scroll of Title (custom) ? 01/10/2014 - Flyff Private Server - 11 Replies Hallo,
ich wollte mal fragen wie man eine Scroll of 'Custom'-Title erstellen kann.
Also eine Scroll, wo man sich selber dann einen Titel geben kann.
Geht das?
About Title Scroll 11/18/2013 - SRO Private Server - 2 Replies Can you give me the procedure for AddTimedJop?
Thanks.
[WTS] Account including all 4 campaigns + Wisdom Title [3] + Treasure title [near 3] 09/06/2009 - Guild Wars Trading - 6 Replies :
Hi, I'm sellin an Account including all 3 campaigns & EOTN.
It has no characters on it except an PvP Elementalist.
There are some green items and materials on storage, and 11 golden rin relicts
It's not plaync-bounded!!
I'm open for offers. (ectos, zkeys, rare pets or rare items only)
Contact:
..: 195759396
How edit topic title? New title. 09/01/2007 - Conquer Online 2 - 2 Replies Since forum turned vbulletin, i cant edit topic title
(Solved) Problem with Scroll Title
