|
You last visited: Today at 19:38
Advertisement
trad disappear after DC i need any fix
Discussion on trad disappear after DC i need any fix within the SRO Private Server forum part of the Silkroad Online category.
02/21/2020, 20:18
|
#1
|
elite*gold: 0 
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
trad disappear after DC i need any fix
trad disappear after DC when open again not found trad i need any fix
|
|
|
|
02/27/2020, 00:27
|
#2
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
any fix
|
|
|
|
|
03/01/2020, 02:54
|
#3
|
elite*gold: 0
Join Date: Apr 2016
Posts: 201
Received Thanks: 47
|
try to explain more exactly what your problem is
|
|
|
|
|
03/01/2020, 11:02
|
#4
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
Quote:
Originally Posted by Piskota
try to explain more exactly what your problem is
|
some time when go make trad job take dc and when open acc again not found pet trad or goods trad
trad disappear after DC
|
|
|
|
|
03/02/2020, 01:11
|
#5
|
elite*gold: 0
Join Date: Oct 2018
Posts: 27
Received Thanks: 2
|
sounds like you have a old anti cheat proc in you log DB
|
|
|
|
|
03/02/2020, 16:40
|
#6
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
Quote:
Originally Posted by TopDowg
sounds like you have a old anti cheat proc in you log DB
|
yes i have anti cheat proc in you log DB
|
|
|
|
|
03/07/2020, 17:50
|
#7
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
any fix
|
|
|
|
|
03/09/2020, 11:39
|
#8
|
elite*gold: 0
Join Date: Jun 2019
Posts: 14
Received Thanks: 5
|
trade dissapear
Quote:
Originally Posted by M@hmoud
any fix
|
yes....
go to you LOG DB store Procedures inside a procedure
_AddLogChar or _JobCoins
find and delete this code
If @  D = '6' -- CAN BE EVENT 6 OR EVENT 4 …. 6 = logout 4 = login
begin
Declare @ D int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @ D)
----------------------------------------------------------Begin Delete pet if he loggout.
Delete from SRO_VT_SHARD.dbo._InvCOS where COSID = @ D
Delete from SRO_VT_SHARD.dbo._CharCOS where
OwnerCharID = @ D and RefCharID between '2187' and '2189'
or OwnerCharID = @ D and RefCharID between '3915' and '3917'
or OwnerCharID = @ D and RefCharID between '3912' and '3914'
or OwnerCharID = @ D and RefCharID between '2184' and '2186'
or OwnerCharID = @ D and RefCharID between '23250' and '23257'
or OwnerCharID = @ D and RefCharID between '23258' and '23265'
or OwnerCharID = @ D and RefCharID between '23905' and '23912'
end
|
|
|
|
|
03/10/2020, 16:40
|
#9
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
Quote:
Originally Posted by ^Nitro^
yes....
go to you LOG DB store Procedures inside a procedure
_AddLogChar or _JobCoins
find and delete this code
If @ D = '6' -- CAN BE EVENT 6 OR EVENT 4 …. 6 = logout 4 = login
begin
Declare @ D int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @ D)
----------------------------------------------------------Begin Delete pet if he loggout.
Delete from SRO_VT_SHARD.dbo._InvCOS where COSID = @ D
Delete from SRO_VT_SHARD.dbo._CharCOS where
OwnerCharID = @ D and RefCharID between '2187' and '2189'
or OwnerCharID = @ D and RefCharID between '3915' and '3917'
or OwnerCharID = @ D and RefCharID between '3912' and '3914'
or OwnerCharID = @ D and RefCharID between '2184' and '2186'
or OwnerCharID = @ D and RefCharID between '23250' and '23257'
or OwnerCharID = @ D and RefCharID between '23258' and '23265'
or OwnerCharID = @ D and RefCharID between '23905' and '23912'
end |
not found _JobCoins
this my Procedure
Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 10/03/2020 04:34:48 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 10/04/2014 19:56:16 ******/
ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
DECLARE @SWACHRNAME varchar(64) = (select CharName16 from [SRO_VT_SHARD].._Char Where CharID = @CharID)
DECLARE @Exists int = (select Count(Charname) From [SRO_VT_SHARDLOG].._OnlinePlayers Where Charname = @SWACHRNAME)
IF (@EventID = 6) -- LOG OFF
BEGIN
IF (@Exists = 0)
BEGIN
Insert into SRO_VT_SHARDLOG.._OnlinePlayers (Service, Charname) Values (0, @SWACHRNAME)
END
ELSE IF (@Exists = 1)
BEGIN
Update SRO_VT_SHARDLOG.._OnlinePlayers SET Service = 0 Where Charname = @SWACHRNAME
END
END
IF (@EventID = 4) -- LOG ON
BEGIN
IF (@Exists = 0)
BEGIN
Insert into SRO_VT_SHARDLOG.._OnlinePlayers (Service, Charname) Values (1, @SWACHRNAME)
END
ELSE IF (@Exists = 1)
BEGIN
Update SRO_VT_SHARDLOG.._OnlinePlayers SET Service = 1 Where Charname = @SWACHRNAME
END
END
declare @len_pos int
declare @len_desc int
set @len_pos = len(@strPos)
set @len_desc = len(@Desc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
end
DECLARE @CharName varchar(max) = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if @EventID = 19
begin
exec Survival_Arena_Axmed @CharID , @Desc
end
if @EventID = 6
begin
if exists (select CharName from Survival_Registered where CharName = @CharName)
begin
delete from Survival_Registered where CharName = @CharName
exec SRO_VT_SHARD.dbo._Memo_Add @CharName,'[SYSTEM]','i would like to inform you that your registertion for survival arena has been cancelled',50
update SRO_VT_SHARD.dbo._Char set DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where CharName16 = @CharName
update SRO_VT_SHARD.dbo._Char set PosX = 954, PosY = -32.60888 , PosZ =1353, LatestRegion = 25000 where CharID = @CharID
end
end
if @EventID = 9 and @strPos like 'Town_%'
begin
if exists (select CharName from Survival_Registered where CharName = @CharName) and (Select service from Survival_Service) = 1
begin
delete from Survival_Registered where CharName = @CharName
update SRO_VT_SHARD.dbo._Char set DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where CharName16 = @CharName
insert into SRO_VT_SHARD.._Notification (Type,Content,Target,Executor,Notified)
values (3,'You are out of survival event',@CharName,'BOT1',0)
end
end
declare @Service int = (select service from JobService )
IF (@EventID = 19 and @Service = 1)
begin
declare @LRegion int = (select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
IF (@Desc LIKE '%Robber, Neutral, no freebattle team%' -- thief
and @LRegion like '25584' ) BEGIN
exec _JobSystem @CharID , @Desc
end
end
if (@EventID = 4)
begin
Declare @DynIP varchar(max);
exec @DynIP = SRO_VT_ACCOUNT.dbo.split_ip @Data2
INSERT INTO _IPLogs (CharID,Charname,IP,[Date]) VALUES (@CharID, (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID),@DynIP,GETDATE())
end
if (@EventID = 6)
begin
delete from ._IPLogs Where CharID = @CharID
end
-- Trade Coins + Anti Cheat
if @EventID = '6' and exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID and Contribution >= '37711285' )
begin Exec [dbo].[Jocs_Job_Reward] @charid , @eventid
end
If @EventID = 6
begin
update SRO_VT_SHARD.._InvCOS set itemid = 0
where COSID = (select id from sro_vt_shard.._CharCOS where OwnerCharID = @CharID and RefCharID in (select id from sro_vt_Shard.._RefObjCommon where codename128 like '%COS_T%'))
update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0
where
OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%')
end
-------Survival System by Aeron
declare @SUR int = (select latestregion from SRO_VT_SHARD.._Char where CharID = @CharID)
declare @S int = (select service from Survival_Service)
IF @EventID = 20 and @S = 1 and @SUR = 25580
BEGIN
DECLARE
@KillerName VARCHAR(max),
@KillerID INT,
@KilledName varchar(Max),
@StartPos TINYINT
Select @KilledName = (select Charname16 from SRO_VT_SHARD.._Char where CharID = @CharID)
SELECT @StartPos = (SELECT CHARINDEX('(',@desc)) + 1
SELECT @KillerName = (SELECT SUBSTRING(@Desc, @StartPos, CHARINDEX(')', @Desc, @StartPos) - @StartPos))
SELECT @KillerID = (SELECT CharID FROM SRO_VT_SHARD.._Char WHERE CharName16 = @KillerName)
---------system start
Delete from Survival_Registered where CharName = @KilledName
insert SRO_VT_sHARD.._Notification (type,Content,Target,Executor,Notified) values (2,0,@KilledName,'BOT1',0)
update Survival_Remain set Rem = (select count(*) from Survival_Registered)
insert SRO_VT_SHARD.._Notification (type,Content,Target,Executor,Notified) values (3,''+@KillerName+' killed you !,Better luck next time',@KilledName,'BOT1',0)
insert SRO_VT_SHARD.._Notification (type,Content,Target,Executor,Notified) values (3,'You killed '+@KilledName+'',@KillerName,'BOT1',0)
end
If @EventID = 20
begin
declare @rm int
select @rm = (Select rem from Survival_Remain)
If @rm = 1
begin
Declare [MENTION=299941]winna[/MENTION]me varchar(MAX)
select [MENTION=299941]winna[/MENTION]me = (select Charname from Survival_Registered)
insert SRO_VT_SHARD.._Notification (type,Content,Target,Executor,Notified) values (1,'' [MENTION=299941]winna[/MENTION]me+' won the survival event',0,'BOT1',0)
insert SRO_VT_SHARD.._Notification (type,Content,Target,Executor,Notified) values (2,0 [MENTION=299941]winna[/MENTION]me,'BOT1',0)
update Survival_Remain set Rem = 0
truncate table survival_registered
update Survival_Service set Service = 0,Reg_Service = 0
update SRO_VT_SHARD.._Char set DailyPK = 0,TotalPK=0,PKPenaltyPoint=0 where CharName16 = [MENTION=299941]winna[/MENTION]me
exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [MENTION=299941]winna[/MENTION]me,'ITEM_MALL_HWAN3',1,1
end
end
If @EventID = 6 and exists (select charid from Survival_Registered where charid = @CharID) and @CharID not like '3880'
begin
delete from Survival_Registered where charid = @CharID
end
declare @lotteryregs int = (select count(*) from _LotteryReg)
If @lotteryregs = 50
begin
declare [MENTION=344009]Winx[/MENTION] varchar(max) = (SELECT TOP 1 CharName FROM _LotteryReg
ORDER BY NEWID())
declare @CCount int = (select Count1 from _LotteryCount)
insert SRO_VT_SHARD.._Notification (type,Content,Target,Executor,Notified) values (1,'' [MENTION=344009]Winx[/MENTION]+' has won the lottery event',0,'BOT1',0)
exec SRO_VT_SHARd.._ADD_ITEM_EXTERN [MENTION=344009]Winx[/MENTION],'ITEM_ETC_ARENA_COIN',@CCount,1
update _LotteryCount set count1 = 0
truncate table _Lotteryreg
end
---
If not exists (select charid from Survival_Registered where charid = @CharID) and @s = 1 and Not exists (select charid from Survival_Niggas where CharID = @CharID)
begin
declare @Zo VARCHAR(MAX) = (SELECT LATESTREGION FROM SRO_VT_SHARD.._Char WHERE CharID = @CharID)
declare @chariz varchar(max) = (Select charname16 from sro_vt_shard.._Char where charid = @CharID)
if @Zo = '25580'
begin
insert sro_vt_shard.dbo._Notification (type,Content,Target,Executor,Notified)
values
(2,0,@chariz,'BOT1',0)
end
end
/*Extension*/--> by Caipi
IF 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, [MENTION=456996]today[/MENTION] datetime = GETDATE(), @FirstCharID int;
exec @FirstCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime [MENTION=456996]today[/MENTION], @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, [MENTION=348406]Tomorrow[/MENTION] datetime = GETDATE()+1, @NewCharID int;
exec @NewCharID = SRO_VT_SHARD.dbo._RandomPlayerID
exec SRO_VT_SHARD.dbo._GetRandomTime [MENTION=348406]Tomorrow[/MENTION], @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 [MENTION=3394895]Tmi[/MENTION]nutes bigint = (SELECT [Minutes] from _OnlineOffline WHERE CharID = @CharID), @Silk int;
IF [MENTION=3394895]Tmi[/MENTION]nutes >= 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
/*!Calc*/
/*!Extension*/
|
|
|
|
|
03/10/2020, 18:45
|
#10
|
elite*gold: 0
Join Date: Jun 2019
Posts: 14
Received Thanks: 5
|
Delete
Delete this lines
If @ D = 6 begin update SRO_VT_SHARD.._InvCOS set itemid = 0 where COSID = (select id from sro_vt_shard.._CharCOS where OwnerCharID = @ D and RefCharID in (select id from sro_vt_Shard.._RefObjCommon where codename128 like '%COS_T%')) update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0 where OwnerCharID = @ D and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%') end
|
|
|
|
|
03/10/2020, 21:37
|
#11
|
elite*gold: 0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
|
Quote:
Originally Posted by ^Nitro^
Delete this lines
If @ D = 6 begin update SRO_VT_SHARD.._InvCOS set itemid = 0 where COSID = (select id from sro_vt_shard.._CharCOS where OwnerCharID = @ D and RefCharID in (select id from sro_vt_Shard.._RefObjCommon where codename128 like '%COS_T%')) update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0 where OwnerCharID = @ D and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%') end |
thx bro for help
|
|
|
|
Similar Threads
|
[Questions]Mailed item disappear of mailbox after restart the server
05/04/2016 - Flyff Private Server - 0 Replies
Fixed, the error is in call MAIL_STR, in my case m_tmCreate is not called properly in the sprintf.
Regards :rolleyes:
|
[04.09.13] GigaByte v2.6 [FIX, FIX, FIX, FIX AND FIX]
09/11/2013 - WarRock Hacks, Bots, Cheats & Exploits - 79 Replies
http://www.elitepvpers.com/forum/warrock-hacks-bot s-cheats-exploits/2843300-11-09-gigabyte-public-v2 -7-a.html
|
drop item disappear after 1 minute
04/03/2012 - Metin2 Private Server - 0 Replies
hi epvp you know when you drop a item the item will disappear after 3 minutes and i wana now how to change this 3 minutes to 1 minute how can i do this?
edit:#closerquest
|
Item disappear after Death
07/25/2011 - Shaiya Private Server - 4 Replies
Hello guys, does anyone know what value i have to edit in the DB to make a noss do not disappear if u get killed? Like the 30 day conty and some kind of nosses?
Ty
|
All times are GMT +1. The time now is 19:46.
|
|
