[Release]Anti-NameHack

[.Shaco.]

Hello,

I've seen that on some pservers you can use this hack and you can be anything you want like [GM]/[GM]/[GS] and so on. This is big problem and can get confused to players who don't know. I haven't seen this on most pserver because i've tested them on most server. I know there are a few like professional coder's servers. So here is a fix for servers which doesn't have patched this yet.

1. Open [dbo].[usp_Create_Char_R]

and Add this after: SET NOCOUNT ON

DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0
DECLARE @charcheck AS INT

SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)
SET @charcheck = PATINDEX('%[^a-zA-Z0-9]%',@CharName)
IF @charcheck > 0
  RETURN -1

2. And click Execute!

Done, easy isn't it? I didn't show full info about where to find it how to find it, but IF you really a dev or new dev you have to find that out your self. I did same way, that will teach you alot of things, believe me. So Good luck!

PS: Have fun trying for it hackers. *Never grow up kids*

[[DN]]

It's simple as fck, you need to change the name during creating a character with ollydbg (you need to change it before it will be sent to the server side) but I won't tell how and where not so many ppl know how to do it so thanks to *** lmao, anyway thanks for the release maybe it will be useful for someone.

[JohnHeatz]

#Added to the Index

[.Shaco.]

Originally Posted by DnSnh

It's simple as fck, you need to change the name during creating a character with ollydbg (you need to change it before it will be sent to the server side) but I won't tell how and where not so many ppl know how to do it so thanks to *** lmao, anyway thanks for the release maybe it will be useful for someone.

Are you saying that you "can" still create a char with tag on, shile this script is patched?
If it is so prove me that you can on my server.

Regards,
Shaco

[cypherxxl]

Huston we got a Problem here!

Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 56
Must declare the scalar variable "@Ret".

Any help? ^^

[anton1312]

add to usr_Create_Char_R
DECLARE @Ret int

SET @Ret = 0

[tracker62]

Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@CharName".
Msg 178, Level 15, State 1, Line 9
A RETURN statement with a return value cannot be used in this context.


??

[[DN]]

Originally Posted by .Shaco.

Are you saying that you "can" still create a char with tag on, shile this script is patched?
If it is so prove me that you can on my server.

Regards,
Shaco

Where did I said that It's possible even with the patched script? I said "it's simple as fck" and I mean the name"hack" not simple to name"hack" with your script patched.
and btw I'm not playing games a long time ago and I don't have Shaiya at my PC so I can't test it on any server <.<
and btw about the name"hack" you need to turn on shaiya client, run Ollydbg and connect it to the game process (file> attach)
Then click on the play (olly will stop the application after the analysis), now you will need to return to the game, log in to your account, create a character, give it a name etc
but yeah we don't "create" it yet, only set a profession, name etc or it won't work.
Now we will go back to ollydbg and go to the address (Ctrl + G) 589370 and click ok and blah blah blah blah maybe I'll just make a tut later with screen shots but first I need to know if the patched script is working at all or I won't make a tut. Does anyone tested it ?

Peace and regards.
DnSnh

[<Admin>Zynx]

Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@CharName".
Msg 178, Level 15, State 1, Line 9
A RETURN statement with a return value cannot be used in this context.

[X-51]

Originally Posted by <Admin>Zynx

Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@CharName".
Msg 178, Level 15, State 1, Line 9
A RETURN statement with a return value cannot be used in this context.

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 01/24/2013 03:48:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 2000000
SET @Map = 42
SET @Posx = 54
SET @Posy = 1
SET @Posz = 66

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 2000000
SET @Map = 42
SET @Posx = 54
SET @Posy = 1
SET @Posz = 66

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Hard mode
BEGIN
SET @Grow = 3
SET @Level = 70
SET @StatPoint = 630
SET @SkillPoint = 9999
SET @money = 2000000
SET @Map = 42
SET @Posx = 54
SET @Posy = 1
SET @Posz = 66

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 75
SET @StatPoint = 675
SET @SkillPoint = 9999
SET @money = 2000000
SET @Map = 42
SET @Posx = 54
SET @Posy = 1
SET @Posz = 66

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END

BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF

[adminganicus]

I used that, i have made an restart on server and still can do hackname :|

[grecu36]

Msg 137, Level 15, State 1, Procedure usp_Create_Char_R, Line 22
Must declare the scalar variable "@NameCnt".

little help pls.

[Aleni]

any one can tell me where [dbo].[usp_Create_Char_R]?

[Twilight360]

Originally Posted by Aleni

any one can tell me where [dbo].[usp_Create_Char_R]?

GameData > Stored Procedures > usp_Create_Char_R table > Edit Table.

[Cansas59]

Msg 134, Level 15, State 1, Procedure usp_Create_Char_R, Line 106
The variable name '@Ret' has already been declared. Variable names must be unique within a query batch or stored procedure.
anyone help?^^