- Joined
- Jul 24, 2011
- Messages
- 806
- Reaction score
- 614
Hi guy's
i give a tutorial how you can add titles, how you can edit your title data!
You need 2 stored procedures for editing:
exec these query's on Server01 database:
Now you need get an TitleData:
CharacterIDHere -> this need to edit to editable characterid
Now you got something like this:
This is an Endless Achiever title
0x[titlecode] ->every title code is 12 character long i think so...
Now you need edit to titledata:
if you know which titles want to give than do just
for an example
this titledata included titles: Nevareth Frontier, 50 Billionaire, Enthusiastic Achiver
if you finished with title code editing than need exec an Server01 again: DaTa = Your Title Data
Query with example
Titles what i found already:
I hope you will share more title code
I used materials from GM buff release, so half credit just my own!
Edit fixed the USER error..
i give a tutorial how you can add titles, how you can edit your title data!
You need 2 stored procedures for editing:
exec these query's on Server01 database:
Code:
USE [Server01]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_GetATitleData] Script Date: 03/01/2013 13:00:31 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[cabal_tool_GetATitleData]( @CharacterIdx int )
AS
BEGIN
if ( SELECT CharacterIdx FROM cabal_achievement_title WHERE CharacterIdx = @CharacterIdx ) is Null
BEGIN
INSERT cabal_achievement_title ( CharacterIdx, TitleData )
VALUES( @CharacterIdx, 0x )
END
SELECT TitleData
FROM cabal_achievement_title
WHERE CharacterIdx = @CharacterIdx
END
Code:
USE [Server01]
GO
/****** Object: StoredProcedure [dbo].[cabal_tool_SetATitleData] Script Date: 03/01/2013 13:02:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[cabal_tool_SetATitleData]
( @CharacterIdx int, @Data varbinary(1024)
)
AS
BEGIN
BEGIN TRAN
IF @Data = null
BEGIN
DELETE cabal_achievement_title
WHERE CharacterIdx = @CharacterIdx
END
ELSE
BEGIN
IF NOT EXISTS( SELECT CharacterIdx
FROM cabal_achievement_title
WHERE CharacterIdx = CharacterIdx )
BEGIN
INSERT cabal_achievement_title (@CharacterIdx, @TitleData)
VALUES (CharacterIdx, Data )
END
ELSE
BEGIN
UPDATE cabal_achievement_title
SET TitleData = @Data
WHERE CharacterIdx = @CharacterIdx
END
END
COMMIT TRAN
END
Now you need get an TitleData:
CharacterIDHere -> this need to edit to editable characterid
Code:
USE [Server01]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[cabal_tool_GetATitleData] @CharacterIdx = CharacterIDHere
SELECT 'Return Value' = @return_value
GO
Now you got something like this:
Code:
0xF90300000000
This is an Endless Achiever title
0x[titlecode] ->every title code is 12 character long i think so...
Now you need edit to titledata:
if you know which titles want to give than do just
for an example
Code:
0xF60300000000F50300000000F80300000000
this titledata included titles: Nevareth Frontier, 50 Billionaire, Enthusiastic Achiver
if you finished with title code editing than need exec an Server01 again: DaTa = Your Title Data
Query with example
Code:
USE [Server01]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[cabal_tool_SetATitleData] @CharacterIdx = EdtiableCharIDHere, @Data = 0xF60300000000F50300000000F80300000000
SELECT 'Return Value' = @return_value
GO
Titles what i found already:
Code:
F30300000000 - Billionaire
F20300000000 - World Walker
F40300000000 - 10 Billionaire
F50300000000 - 50 Billionaire
F10300000000 - Ascetic
F90300000000 - Endless Achiever
F80300000000 - Enthusiastic Achiver
F70300000000 - Nevareth Pioneer
F60300000000 - Nevareth Frontier
E90300000000 - Warderer
//Dungeon Releated title's
B90B00000000 - Ripplet of Dusk Lake I ->start
9B0C00000000 - Lightning Fast Tragedy Dismantler ->finish
DD0B00000000 - Lava Cave Explorer I
DF0B00000000 - Lava Cave Explorer III
E20B00000000 - Lava Cave Explorer VI
E60B00000000 - Lava Cave Explorer X
E80B00000000 - Lava Cave Explorer XII
You can find a pattern in this!
I hope you will share more title code
I used materials from GM buff release, so half credit just my own!
Edit fixed the USER error..
Last edited: