- Joined
- Feb 27, 2004
- Messages
- 1,378
- Reaction score
- 50
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 tt1: )
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
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
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?
24 = Server ID template ( 24 -28 )
1 = class ( 1 - 6 )
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 tt1: )
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
Code:
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
Code:
where channel = @serverIdx + 2 ) as flagTable
i guess that is a setting for Level 99 + free Shineguard set .
Happy expermenting folks ...
Additional Stuff:
How to Query a template?
Code:
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
1 = class ( 1 - 6 )