Printable View
first one is when i click Query in SR-UserPunishment i get this msg and nothing happens
http://i45.tinypic.com/2w56h5i.png
second is i don't have any in game logs using the perfection server pack
http://i47.tinypic.com/2e0rcs9.png
how can i enable logs and what causing the punishment fail ?
thx.
first in SR-UserPunishment you must put the userID not the charname
second change your log_db with another that can record logs but it will make your server lags, that's why perfection was disabling it in this pack.
i did by charr name before and it worked fine also tryed with charr ID took from DB and still failed for logs i have good dedicated server which can hold logs anyway i will delete them every few days
bro, ur no have procedure punishment in db :(... look first imagem, failed query punishment
Execut this and done problem.PHP Code:USE [SRO_VT_ACCOUNT]
GO
/****** Procedure By Jangan @RageZone ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--
-----------------------------------------------------------------------------------
-----------------------------------------------------------------------------------
CREATE procedure [dbo].[_RegisterPunishment]
@UserJID int,
@Type tinyint,
@Executor varchar(128),
@Shard smallint,
@CharName varchar(16),
@CharInfo varchar(256),
@PosInfo varchar(64),
@Guide varchar(512),
@Description varchar(1024),
@RaiseTime datetime,
@BlockStartTime datetime,
@BlockEndTime datetime,
@PunishTime datetime
as
-- Author: Jangan @ RageZone
if( exists( select UserJID from _BlockedUser with(NOLOCK) where UserJID = @UserJID and Type = @Type))
begin
select -1
RETURN
end
declare @NewSerialNo int
set @NewSerialNo = 0
insert _Punishment values( @UserJID, @Type, @Executor, @Shard, @CharName, @CharInfo,
@PosInfo, @Guide, @Description, @RaiseTime, @BlockStartTime, @BlockEndTime, @PunishTime, 0)
set @NewSerialNo = @@identity
if( @@rowcount = 0 or @@error <> 0 or @NewSerialNo = 0 or @NewSerialNo is null)
begin
select -2
return
end
declare @UserID varchar(128)
set @UserID = (SELECT StrUserID FROM TB_User where JID = @UserJID)
if( @@rowcount = 0 or @@error <> 0 or @UserID is null)
begin
select - 2
return
end
insert _BlockedUser values( @UserJID, @UserID, @Type, @NewSerialNo, @BlockStartTime, @BlockEndTime)
select 0
Credits procedure, Jangan :)
Msg 2714, Level 16, State 3, Procedure _RegisterPunishment, Line 44
There is already an object named '_RegisterPunishment' in the database. yes problem is i have it but i still don't know what may cause this. this thing happened after some 1 hacked db and deleted some of the accounts i restored the databases secured the server but this issue still persists any ideas how to fix it?
need block ports and security ur website.Quote:
Originally Posted by antoha
i blocked ports and secured my website how do i fix the punishment error? so i be able to ban via SMC and not DB thats the question