How to Make Use of Character Templates

[john_d]

Ever wanted to Give Items or Item Set to PLayers when create an Character?
Ever wanted to Automatically Give Quest?
Ever wanted to give them Level 99 Free or More?

Look no more folks ( ahahhaha i sould like im selling magic potions )

There is a bunch of Character Creation settings u can play with..

and the easiest way to test this is to edit 1 Simple Stored Procedure.

Go to > GameDB ( database ) > Stored procedures > cabal_sp_newChar
( note right+click trigger and select Modify )
Then Find a this

where channel = @serverIdx ) as flagTable

Now you could i possibly do there? it is easy.
by default ur setting IDX is 24.
and according to the ACCOUNT > cabal_newFlagData_table
you have 10 (TEN) server settings.

now just simply do a simple addition like this

where channel = @serverIdx + 2 ) as flagTable

that's 24 + 2 = 26 ( now ur using server id 26 )

i guess that is a setting for Level 99 + free Shineguard set .

Happy expermenting folks ...

Additional Stuff:

How to Query a template?

select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,
			   etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData
		
		from GAMESERVER.account.dbo.cabal_newCharData_table as charTable, 
			 GAMESERVER.account.dbo.cabal_newEtcData_table as etcTable,
			( select top 1 charDataIdx, etcDataIdx from GAMESERVER.account.dbo.cabal_newFlagData_table
			  where channel = 24) as flagTable
		where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx
			  and charTable.classType = etcTable.classType and charTable.classType = 1

24 = Server ID template ( 24 -28 )
1 = class ( 1 - 6 )

[MentaL]

[cypher]

not bad john_d ^^

[chumpywumpy]

Just change the value in the FlagData_Table instead. I posted this a while ago (near the bottom) :P
http://forum.ragezone.com/f460/how-t...es-etc-452000/

Also, if you experiment with changng the serveridx in the getidx function expect things to break! Not everybody's default is 25.

[john_d]

it goes like this

i got tired of testing ^^
@serverIdx+2 lvl99 +shinguard +rings+amulets+complete quest
@serverIdx+4 lvl99 +shinguard +4+slot +rings+amulets+complete quest
@serverIdx+6 lvl125 +forcium +4+ +rings+amulets+complete quest

sample:



also i notice most server will have their flag data bad.. here is the fix

Just change the value in the FlagData_Table instead. I posted this a while ago (near the bottom) :P
http://forum.ragezone.com/f460/how-t...es-etc-452000/

Also, if you experiment with changng the serveridx in the getidx function expect things to break! Not everybody's default is 25.

now i remember..

when u edit the stored procedure it doesn't really do much damage as in editing ur flagdata of server 25.

one use of this is to add a new service in ur website

let say.
1. one lazy person want a lvl99 character ( which is in template 26 ). so he ask u to make him one.
2. as a website shop item. selling premade characters :p

[chumpywumpy]

when u edit the stored procedure it doesn't really do much damage as in editing ur flagdata of server 25.

I suppose it is a bit safer for those that don't know mssql too well but many people here are pretty confused about basic queries let alone SPs. I bet a few went purple looking at that query of yours hehehe.

one use of this is to add a new service in ur website

let say.
1. one lazy person want a lvl99 character ( which is in template 26 ). so he ask u to make him one.
2. as a website shop item. selling premade characters :p

That is actually a very very good point! I'm stealing that idea for my cash shop but i will credit you for it

[john_d]

I suppose it is a bit safer for those that don't know mssql too well but many people here are pretty confused about basic queries let alone SPs. I bet a few went purple looking at that query of yours hehehe.


That is actually a very very good point! I'm stealing that idea for my cash shop but i will credit you for it

LOL

i wasn't planning to make one anyway... maybe an Administration side via cabaltoolz3/4 backend

[Jeffijoe]

Lol, cool :D

But why would you give someone a lvl 99 char? Then there is no fun in playing the game :P

[master_unknown]

Lol, cool :D

But why would you give someone a lvl 99 char? Then there is no fun in playing the game :P

maybe an Administration side via cabaltoolz3/4 backend

Its for the admins. :D

[cypher]

this is how i understand a admin:
lv1 hero with 999999 hp and defence and 0 attack
and a tag in front of his name, why a admin needs all this?

[Yamachi]

You could also use this to use different character templates depending on the account. ie. you log in with a normal account, create a character, and it's created like any other character. Then, you log in with an admin, create a character, and you get all quests completed, level 170, full epic Mithril gear, the works. You could also use it to automatically add an admin or GM tag to a character's name when it's created. I'll definitely be toying around with this :)

[MisterMinister]

hi there.....

Really nice Guide....but...

when i chage it to IDX + 2 it works... got lvl 99 Armour etc. as you said..

but when i trying out +4 +6 i got an Unknown DB Error....

Dont know,why ...i restarted SQL..Server...but Still get that error...

how to fix that ????

thnx...

EDIT: when i change it to IDX +2 i only get the Full shineguard Set...no rings..no amulet...
Du i have to edit another Table to get other Items ???
if yes...what Table ?? thnx for answers...

[chumpywumpy]

Look at my method of doing it and look at how the data in the table is used when creating new chars. If you get different items then obviously your template data is different, getting errors with +4 and +6 would confirm this as there are 10 templates as john says and i have tested all 10 personally. The template data i have used is based on the data in the databases i posted.