Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
CritYouDown
i have this error when i try to edit AddLogChar
http://www14.0zz0.com/2014/07/29/04/948851985.jpg
any help ? this my AddLogChar
Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 7/29/2014 6:01:45 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddLogChar] @CharID int, @eventID tinyint, @data1 int, @data2 int,
@strPos varchar(64), @desc varchar(128)
as
IF @eventID = 4 OR @eventID = 6)
BEGIN
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
--For the new IPLog table
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
-- Banned IP stuff
IF exists (SELECT IP FROM _BannedIPs WHERE IP like @DyniP)
BEGIN
Declare @Charname varchar(max) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
exec SRO_VT_ACCOUNT.dbo._BannPlayerSP @Charname,'usage of a banned IP'
-- END banned IP stuff
END
END
iam not going to answer
cuz when i do i'll insult you
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
POWEREDSHELL
iam not going to answer
cuz when i do i'll insult you
_AddLogChar Procedure
Dont use it in query just open procedure and put this code in the end of it
i donot understand what should i do with this :blush:
help me
Re: Since Silkroad Section is Dead i'll Release something good
Copy all Line from the first post not some of them it's not by your choice
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
POWEREDSHELL
Copy all Line from the first post not some of them it's not by your choice
i have dbo.Killsystem ==> procedure
and IPLogs ===> Table
and ===> _Check table
what should i do with
Code:
DECLARE @DyniP VARCHAR(12)
DECLARE @CoSID int
DECLARE @CoSlevel TINYINT
DECLARE @Aha INT
DECLARE @petOption tinyint
DECLARE @CharName Varchar(64)
DECLARE @JiD int
DECLARE @CharLevel tinyint = (SELECT CurLevel from SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
IF @eventID = 4)
BEGIN
SELECT @CharName = CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID
exec @DyniP = SRO_VT_ACCOUNT.dbo.split_ip @data2
INSERT INTO _IPLogs (CharID,Charname,IP,[Date]) VALUES @CharID, @CharName, @DyniP, GETDATE())
END
IF @eventID = 6)
BEGIN
DELETE FROM _IPLogs WHERE CharID = @CharID
END
IF @eventID = 19 AND @desc like '%My: Robber%' OR @eventID = 19 AND @desc like '%My: Trader%' OR @eventID = 19 AND @desc like '%My: Hunter%')
EXEC KillSystem @CharID, @CharLevel, @desc
i donot understand
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
CritYouDown
i have dbo.Killsystem ==> procedure
and IPLogs ===> Table
and ===> _Check table
what should i do with
Code:
DECLARE @DyniP VARCHAR(12)
DECLARE @CoSID int
DECLARE @CoSlevel TINYINT
DECLARE @Aha INT
DECLARE @petOption tinyint
DECLARE @CharName Varchar(64)
DECLARE @JiD int
DECLARE @CharLevel tinyint = (SELECT CurLevel from SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
IF @eventID = 4)
BEGIN
SELECT @CharName = CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID
exec @DyniP = SRO_VT_ACCOUNT.dbo.split_ip @data2
INSERT INTO _IPLogs (CharID,Charname,IP,[Date]) VALUES @CharID, @CharName, @DyniP, GETDATE())
END
IF @eventID = 6)
BEGIN
DELETE FROM _IPLogs WHERE CharID = @CharID
END
IF @eventID = 19 AND @desc like '%My: Robber%' OR @eventID = 19 AND @desc like '%My: Trader%' OR @eventID = 19 AND @desc like '%My: Hunter%')
EXEC KillSystem @CharID, @CharLevel, @desc
i donot understand
add these lines to _AddLogChar Procedure
in the end of procedure not in query
- - - Updated - - -
and press F5
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
CritYouDown
i have this error when i try to edit AddLogChar
http://www14.0zz0.com/2014/07/29/04/948851985.jpg
any help ? this my AddLogChar
Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 7/29/2014 6:01:45 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddLogChar] @CharID int, @eventID tinyint, @data1 int, @data2 int,
@strPos varchar(64), @desc varchar(128)
as
IF @eventID = 4 OR @eventID = 6)
BEGIN
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
--For the new IPLog table
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
-- Banned IP stuff
IF exists (SELECT IP FROM _BannedIPs WHERE IP like @DyniP)
BEGIN
Declare @Charname varchar(max) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
exec SRO_VT_ACCOUNT.dbo._BannPlayerSP @Charname,'usage of a banned IP'
-- END banned IP stuff
END
END
bro this is from Procedure not a Query :(:
http://www7.0zz0.com/2014/07/30/04/128095139.jpg
Re: Since Silkroad Section is Dead i'll Release something good
one of the many tips to check:
IF @eventID = 4 OR @eventID = 6)
i saw the ending ")".. but where is the opening one? AKA "(" ?
and i saw many of that mistakes on the procedure
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
Caosfox
one of the many tips to check:
IF @
eventID = 4 OR @
eventID = 6)
i saw the ending ")".. but where is the opening one? AKA "(" ?
and i saw many of that mistakes on the procedure
lemme check :):
iam not interested
- - - Updated - - -
here's the fixed code
Code:
DECLARE @DyniP VARCHAR(12) DECLARE @CoSID int
DECLARE @CoSlevel TINYINT
DECLARE @Aha INT
DECLARE @petOption tinyint
DECLARE @CharName Varchar(64)
DECLARE @JiD int
DECLARE @CharLevel tinyint = (SELECT CurLevel from SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
IF @eventID = 4)
BEGIN
SELECT @CharName = CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID
exec @DyniP = SRO_VT_ACCOUNT.dbo.split_ip @data2
INSERT INTO _IPLogs (CharID,Charname,IP,[Date]) VALUES @CharID, @CharName, @DyniP, GETDATE())
END
IF @eventID = 6)
BEGIN
DELETE FROM _IPLogs WHERE CharID = @CharID
END
IF @eventID = 19 AND @desc like '%My: Robber%' OR @eventID = 19 AND @desc like '%My: Trader%' OR @eventID = 19 AND @desc like '%My: Hunter%')
EXEC KillSystem @CharLevel, @desc
END
- - - Updated - - -
#EDITED1STPOST
Re: Since Silkroad Section is Dead i'll Release something good
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
ilowe
from where you got --for new iplog table proc lines?
are you fucking idiot ?
are you blinded?
GTFO
Re: Since Silkroad Section is Dead i'll Release something good
thx alot tested ( 100% ) work
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
Adel Samir
thx alot tested ( 100% ) work
you Are welcome :)
Re: Since Silkroad Section is Dead i'll Release something good
Little Hint --> IP Logs is Useless for Proxy users ..
So .. the whole system is useless for them :P:
Re: Since Silkroad Section is Dead i'll Release something good
Quote:
Originally Posted by
NourAyman
Little Hint --> IP Logs is Useless for Proxy users ..
So .. the whole system is useless for them :P:
i dont care :P:
- - - Updated - - -
what a funny errors
even my dick can fix them
btw i fixed the _AddLogChar Proc
Edited First Post
have fun
