|
You last visited: Today at 11:59
Advertisement
Scroll's Title Not working
Discussion on Scroll's Title Not working within the SRO Private Server forum part of the Silkroad Online category.
01/13/2015, 06:55
|
#1
|
elite*gold: 0
Join Date: Jan 2012
Posts: 107
Received Thanks: 0
|
Scroll's Title Not working
Help please after i use Query FOR Rest time Guild .
my scroll.s title not working any more
how i fixed it !
|
|
|
01/13/2015, 11:32
|
#2
|
elite*gold: 77
Join Date: Jan 2015
Posts: 1,314
Received Thanks: 856
|
Did you add your title scroll trigger in the _AddTimedJob @ SHARD DB?
if yes, then you have to add the triggers again.
|
|
|
01/13/2015, 14:53
|
#3
|
elite*gold: 0
Join Date: Jan 2012
Posts: 107
Received Thanks: 0
|
they was working good,but after add query Guild scroll don't want working any more
|
|
|
01/13/2015, 18:32
|
#4
|
elite*gold: 77
Join Date: Jan 2015
Posts: 1,314
Received Thanks: 856
|
Quote:
Originally Posted by kubed
they was working good,but after add query Guild scroll don't want working any more
|
dude, if you made them by yourself, then you have to make them again.
if you didn't make them by yourself, then you have to restore your shard with a different name and open _AddtimedJob procedure. copy everything in it and put it @ your current _AddTimedJob @ your real shard db.
I hope i helped you.
|
|
|
01/13/2015, 18:48
|
#5
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Simply use Log, making triggers for scroll? You just update hwanlevel so log sp is okay
|
|
|
01/13/2015, 18:52
|
#6
|
elite*gold: 0
Join Date: Oct 2014
Posts: 93
Received Thanks: 22
|
Quote:
Originally Posted by xExorcist
Simply use Log, making triggers for scroll? You just update hwanlevel so log sp is okay
|
he's still a beginner. explain him more ^^
Quote:
Originally Posted by Jocs
dude, if you made them by yourself, then you have to make them again.
if you didn't make them by yourself, then you have to restore your shard with a different name and open _AddtimedJob procedure. copy everything in it and put it @ your current _AddTimedJob @ your real shard db.
I hope i helped you.
|
this is the only solution
|
|
|
01/14/2015, 03:47
|
#7
|
elite*gold: 0
Join Date: Jan 2012
Posts: 107
Received Thanks: 0
|
I Do that,Still don't want work
|
|
|
01/14/2015, 19:26
|
#8
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Can you show me your query... And I really don't know why you're using a **** trigger for that...
|
|
|
01/14/2015, 20:57
|
#9
|
elite*gold: 0
Join Date: Jan 2012
Posts: 107
Received Thanks: 0
|
that's query Make my tittle scrolls not working +
Quote:
USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
|
********************
|
|
|
01/16/2015, 05:21
|
#10
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
sure it makes your scrolls didnt work .. Cuz you depends on addtimejob to do the changes
This Query Didnt have the Correct usage Scrolls Like
if(@JobID = '33838')
begin
update bla bla bla
end
simply re add them
|
|
|
01/16/2015, 05:42
|
#11
|
elite*gold: 0
Join Date: Jan 2012
Posts: 107
Received Thanks: 0
|
Done thanks all for help
|
|
|
Similar Threads
|
[RELEASE] How to add Title name Scroll.
09/20/2022 - SRO PServer Guides & Releases - 18 Replies
Hello elitepvpers community. Today i'm going to show you how to add title name scroll to your server correctly without bugs.:)
I Assume you have already " Elitepvpers " title name in your media.pk2 ( at textuisystem.txt ). Lets get started:
First Data base lines:
dbo._RefObjCommon:
1 41802 ITEM_MALL_CHANGETITLE_ELITEPVPERS ???? ???? ???...
|
[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.
|
All times are GMT +2. The time now is 11:59.
|
|