How to auto give new players premium, stats, mapcodes etc

There are several different ways of giving mapcodes, stats, alz and other things but all require several individual edits. There is a much much easier way but i have not seen anybody share it yet so here you are.

Most people know you can make all new accounts premium my editing the cabal_tool_registeraccount stored procedure in the account database but in case you don't look for this line in the stored procedure...

Code:

---

values(@UserNum, 0, DATEADD(day, 100 , getdate()), 0)

---

The red number is the account type. 0 is a free account and 1 is charged (premium). The blue number is the expiry date (the dateadd function is adding 100 days to today's date). Simply change the 0 to 1 to make all new chars premium and change the 100 if you want them to have more than 100 days of prem.

Here are the prem types from SAUR0N's client synch patch:
http://i344.photobucket.com/albums/p.../premtypes.gif

I have squashed the columns up a bit to get it all in but the actual column titles (in left to right order) are:

[DurationSvc] = The row index. This always starts at 0 and increments by values of 1.
DurationSvcIdx = The premium ServiceIdx number
Type = Not completely sure. I *think* 0 means premium expires by expiry date and 1 uses the PayMinutes values and counts down the minutes until expiry.
Exp = Bonus EXP
SklExp = Bonus Skill EXP
Drop = Bonus droprate
Craft = Bonus craft EXP
CraftSuccess = Bonus craft success
Inventory = Extra inventory tab
Warehouse = Extra warehouse tab
Str = Bonus STR
Dex = Bonus DEX
Int = Bonus INT
Attk = Bonus Attack
MgAttk = Bonus Magic Attack
AR = Bonus Attack Rate
DR = Bonus Defense rate
Defense = Bonus DEF
MoveSpeed = Bonus move speed
SP = Bonus EXP
UseSP = Not sure
BombAlz = Bonus Alz bomb rate
Inventory2 = 2nd extra inventory tab
Warehouse2 = 2nd extra warehouse tab
dummy = Use of training dummies

So, from this you can tell that a DurationSvcIdx of 1 gives you an extra 25% to all exp and drop rates and 200% Alz bomb but no training dummies. DurationSvcIdx of 2 give you the same, but Skill EXP is at 50%, you get 2 extra inventory tabs, 1 extra warehouse tab and access to training dummies.

Now comes the interesting bit. Execute the following statement in the account database and then try making a new char, it should be level 150 with a full mithril set and lots of points to add.

Code:

---

update cabal_newflagdata_table set chardataidx=8, etcdataidx=8 where channel=25

---

All very interesting, but why does it do that? To find out you need to look at some other tables in the account database...

http://i344.photobucket.com/albums/p.../newchars3.gif

cabal_character_count_table is the first place to look. Find an existing userid on your server and check the server idx, don't assume the server idx will be 24 like your configs.

http://i344.photobucket.com/albums/p.../newchars2.gif

If i look through cabal_newflagdata_table i can see my channel number has a chardataidx and an etcdataidx of 8 (we just changed this to 8 from 10). These 2 values are important as it tells the server what set of new character stats/equips etc. to use when creating new chars.

http://i344.photobucket.com/albums/p.../newchars1.gif

This table (cabal_newchardata_table for those that can't read title bars) holds the default stats, alz, mapcodes and a whole bunch of other stuff that gets used for new chars. Inventory, equips, quest data and some other stuff can be found in cabal_newetcdata. We have just told the server to use set 8 which you can see are not noobie stats, it was using 10 before just below the area i hilighted which are the normal new char stats.

If you look through these tables you will see that there are several different configurations. You can even mix and match the 2 values to use combinations of newchardata and newetcdata. You can even modify the sets using the info in darkxl's sticky to suit your own server, or even have multiple sets to have different new char data for high and low rate servers.

Warning: Most of the higher sets here have the equips already equipped but your stats aren't actually high enough to wear them as all of your points are unassigned. This does cause errors in the server logs and i have not done much testing for problems if you don't assign your stats high enough for the equips, but if you raise the stats straight away it should be fine. Obviously the better way is to alter the stats in the cabal_newchardata_table to match the kit the chars will be wearing though ;)

very nice and useful guide for everyone. thanks chump ;)

Very usefull, thanks. =]

this guide rocks.. good job sir chumpy...^^

Wowwww!!! goood aport THANKSSSSSSSSSSSSSSSS!!!

thanks for this good guide. And what statement I should do to disable that function?

hi nice guide... just tip...
type

Code:

---

0 = normal player
1 = charged/premium state
2 = Free time (everyday PM 21~22)/old style not f2p
3~? = is same type 1

---

here u set premium type
servicekind
server: etc/cabal/data/const.scp

Code:

---

[DurationSvc]        DurationSvcIdx        Type        Exp        SklExp        Drop        Craft        CraftSuccess        Inventory        Warehouse        Str        Dex        Int        Attk        MgAttk        AR        DR        Defense        MoveSpeed        SP        UseSP        BombAlz        Inventory2        Warehouse2        dummy
0        0        0        25        25        25        25        0        0        0        0        0        0        0        0        0        0        0        0        0        0        200        0        0        0
1        1        0        0        0        0        25        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0
2        2        0        25        0        0        0        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0
3        3        0        0        0        25        0        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0
4        4        0        0        25        0        0        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0
5        5        0        25        25        25        25        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        1
6        6        0        0        0        0        0        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0
7        7        0        0        25        0        0        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        1
8        8        0        50        50        50        50        0        1        1        0        0        0        0        0        0        0        0        0        0        0        0        0        0        0

---

ps: u dont use chinese client... u need sync server side for u client...

i love the procedures and db ++
Nice release

for those who still don't get it.

this is editing the character templates. every time you create a hero... it will go to this and read from it.

Thank ^^

Or use to edit all existent accounts to give premium :

Quote:

---

update cabal_charge_auth set Type=5

---

wut i done this thing and create character and see for yourself LOL :P

http://img176.imageshack.us/img176/3...8162354oi0.jpg


i only edited to add ALZ and maps and see what hapened ;/





OK FIXED !!!
i use 1 ;/ and now it's 10 and working

Thank ^ ^
give some item for new character ^ ^
http://images.torrentmove.com/il/cab...1700230000.jpg

what is the exact number for char that is level 1 with all map enable and warp with some items.

how do i revert back to defualt becuase i used this querry and don't like the idea players being level 150 with all this stuff update cabal_newflagdata_table set chardataidx=8, etcdataidx=8 where channel=25

Use the same query, but set chardataidx and etcdataidx back to 10.

sir need help with this

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

sir how to add pets on signup?

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

Quote:

---

Originally Posted by jaeker1

Thank ^ ^
give some item for new character ^ ^
http://images.torrentmove.com/il/cab...1700230000.jpg

---

im interested in how hdid this sorry for sounded dumb but kind of lost on how he was able to add certain things

Make a new char with the basic kit you want to add, then copy the equip and inventory values into the entries in the newEtcData_table for that class and dataidx.

im still unable to understand properly how do i modify what is giving the character data after i created new character and gave the starting items to him i check in db but his inventory is binary how am i supose to tell it hey new characters gonna get this?
binary data i want each new character to have in there inventory is

Code:

---

0x050000000000630000000400000000F8080000000000630000000500000000F80C0000000000630000000600000000F8D00102000010000000000800000000F8B30302000010000000000C00000000F8190500000000000000000E00000000F8F50400000000630000000700000000F8

---

but i fail to see how to get this done.

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

Quote:

---

Originally Posted by cypher

How hard can it be: add all your items u want to a character, get his inventory data and then just edit the new flag data. Is it that hard? gezzz

---

my god man how you became a mod? but anyway if the data binary was curious on how to edit it is all there is no need for hostilities to me or anyoe else in this forum i been reading this forum and fail to see any type in depth guide on how to change things like this.

Quote:

---

Originally Posted by Advocate

i been reading this forum and fail to see any type in depth guide on how to change things like this.

---

The fact is cabal is still very new to us, we have not had the files long and not many people even understand the basics let along the harder things like this. There are no guides simply because nobody understands it well enough, at least nobody that wants to write a guide anyway.

Once i get that far along i will document it but i am still dealing with other more basic problems at the moment. I'm not even thinking about stuff like this until we have something stable and the server/client is far from stable let along hackproof right now.

Well first time thnx for share it tutorial but i need a little help.

In my server i want Make:

1 - Premiun account free for all
2 - All Maps Free For Premiun Account

any1 have it owns ur server? if have please share or send procedure for pm.

im reality need it

so sry for my low experience on cabal, and so sry for ask and dont make but one day i will...

thnx and have a nice day.

I need help
I need help
I need help
I need help in approaching the web T_T
not anything that I've fallen and I do not tend to work if someone misses a pass please :D

anybody help how to give all player


Premiun account free for all and All Maps Free For Premiun Account

just follow the guide read the post

Thanks man u are the best!

I tried

Code:

---

update cabal_newCharData_table set WarpBField=1023, MapsBField=1023

---

To give all the maps and it works so yeah.

This Guide is Very Very Nice...

Thanks for this...

Big Thanks....

nice release it works perfect,

but is there any way to add a start Style, which includes rank19/bm/aura/SP/ ?

would be awsome

thanks for help, Iam sorry if this question is already answered

Your sincerly

Automatisch

Yes and no. Class rank 19 can be done fairly easily but it requires changes to sp_newchar. Aura is more complex as it requires altering the style value even further and everybody would get exactly the same aura. SP is pretty easy but it's useless unless you can also give the combo skill which needs a decode, edit and recode of the skill data unless you make 6 template chars with the skills you need and copy their quest data back into the templates.

Put simply it's too hard for just about everyone to do unless they have a really good understaning of the server database and binary decoding/encoding. I'm working on template editing and some other stuff for my gm tools which should hopefully help out but it's going to be a while.

and what changes exactly do we need to make to sp_newchar?

just wanted to give class rank 8 to the new chars. no need for aura/combo, just make their ranks to 8 and nothing else...

should be simple no? D:

It is very simple if you actually look at the SP and see what it does. It takes 2 seconds to figure it out if you have done ANY studying of your db and how it works.

Code:

---

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

/****** Object:  Stored Procedure dbo.cabal_sp_newchar    Script Date: 2008-4-14 5:52:47 ******/

ALTER      PROCEDURE [dbo].[cabal_sp_newchar] (@charname varchar(16), @characteridx  int, @style int, @stylemast int)
AS
begin
SET NOCOUNT ON
        if( exists ( select * from cabal_badwoard where badword=@charname ) ) select convert(int,0x04)       
        else if( exists ( select * from cabal_character_table where Name=@charname ) ) select convert(int,0x03)
        else if( exists ( select * from cabal_character_table where characteridx=@characteridx ) ) select convert(int,0x02)
        else if( @stylemast < 0x01 or @stylemast > 0x06 ) select convert(int,0x02)
        else
        begin
                -----------------------------------------------------------------------------------------------
                declare @RegTime dateTime, @userNum int, @serverIdx int, @result int
                set @userNum = @characterIdx/8
                set @serverIdx = dbo.getServerIdx()
                set @RegTime = getDate()
                set @result = convert(int, 0xA0) + @stylemast
                ------------------------------------------------------------------------------------------------

                select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,
                          etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData
                into #tempTable
                from account.dbo.cabal_newCharData_table as charTable,
                        account.dbo.cabal_newEtcData_table as etcTable,
                        ( select top 1 charDataIdx, etcDataIdx from account.dbo.cabal_newFlagData_table
                          where channel = @serverIdx) as flagTable
                where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx
                          and charTable.classType = etcTable.classType and charTable.classType = @stylemast
               
                IF( NOT EXISTS ( select * from #tempTable))
                BEGIN
                        select convert(int, 0x01)
                        drop table #tempTable
                        return
                END
                -----------------------------------------------------------------------------------------------               
                -- ??? ??? ??
                EXEC account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1
               
                --??? ??
                -- Change @style here for auto class
                -- @style + (8* class level)
                -- i set class 10 here
                insert into cabal_character_table( CharacterIdx, Name, LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
                        WorldIdx, [Position], Style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 )
                select  @characteridx, @charname, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
                                WorldIdx, Position, @style + (8* 10), HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
                from #TempTable
               
                begin tran
                insert into cabal_equipment_table (characterIdx, data) select @characteridx, equipmentData from #TempTable
                insert into cabal_inventory_table (characterIdx, data) select @characteridx, inventoryData from #TempTable
                insert into cabal_skilllist_table (characterIdx, data) select @characteridx, skillData from #TempTable
                insert into cabal_quickslot_table (characterIdx, data) select @characteridx, quickSlotData from #TempTable
                insert into cabal_questdata_table (characterIdx, data, flags) select @characteridx, questData, questFlagsData from #TempTable
                commit tran
                ----------------------------------------------------------------------------------------------

                -- ??? 0xA1 ~ 0xA6
                drop table #tempTable
                select convert(int, @result)
                -----------------------------------------------------------------------------------------------       
        end

SET NOCOUNT OFF
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

---

Quote:

---

Originally Posted by mrpsycho

and what changes exactly do we need to make to sp_newchar?

just wanted to give class rank 8 to the new chars. no need for aura/combo, just make their ranks to 8 and nothing else...

should be simple no? D:

---

if it`s simple why not try it, do not put others to do your work. don`t be lazy!

i did try and i did spend some time reading and figuring out the script but i am not that experienced so i just thought id ask for help since i think were alowed to in this forum <.<

you are not allowed to ask people to do your entire work!

Quote:

---

Most people know you can make all new accounts premium my editing the cabal_tool_registeraccount stored procedure in the account database but in case you don't look for this line in the stored procedure...


Code:
values(@UserNum, 0, DATEADD(day, 100 , getdate()), 0)
The red number is the account type. 0 is a free account and 1 is charged (premium). The blue number is the expiry date (the dateadd function is adding 100 days to today's date). Simply change the 0 to 1 to make all new chars premium and change the 100 if you want them to have more than 100 days of prem.

---

Thanks chumpy for this tuto.

So i have just one probleme for the premium account.
Nobody have teleport for Mutant Forest and Pontus !?
have you an idee for resolve it ??

You have to win nation war to get those warps. The only other way i know of is to create a custom npc and a custom pair of warps and that is not easy. I doubt many people will be able to create custom warps until some guides are done.

please tell me where the location of "cabal_tool_registeraccount"
because i want to set the premium user..

tq

It`s located in account`s stored procedures.

Quote:

---

Originally Posted by cypher

It`s located in account`s stored procedures.

---

that in server sentos or database ?

In the database, under account->stored procedures. Familiarise yourself with the contents of this folder in each db ;)

Quote:

---

Originally Posted by chumpywumpy

In the database, under account->stored procedures. Familiarise yourself with the contents of this folder in each db ;)

---

haha..tq cumpy..hehehe...

Thats just great! Many thanks! :hail:

Use the thanks button (http://forum.ragezone.com/zoomtube/b...ost_thanks.gif) rather than posting, it leaves less clutter for me to clean up later ;)

Quote:

---

Originally Posted by cypher

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

---

Off-topic but why do I see this post on just about every cabal thread? I see he is a mod, but I see it as a type of spam for each thread ><. Not a complaint or a problem just asking :tongue:

Quote:

---

Originally Posted by Unrealx420

Off-topic but why do I see this post on just about every cabal thread? I see he is a mod, but I see it as a type of spam for each thread ><. Not a complaint or a problem just asking :tongue:

---

This was due to a hack some time ago where the hacker replaced all of Cypher's posts with that message. We cleaned up most of it but there are still a few around. If you see one hit the "report" icon and we can clean it.

hi chumpywumpuy' i was problem at( rank 10 and honor 768000), i run *update cabal_newflagdata_table set chardataidx=10, etcdataidx=10 where channel=25*
dono why after i create new char , after i rejoin my char > rank class 10 and honor 7680000. how to do make new char normal rank class 0 and honor 0. thanks

You must have different data to me. You will need to look n the tables and see which ones start off at level zero as i have messed around with my templates and databases so much they don't have the default templates anymore. Idx 1 should be it but check first.

Quote:

---

Originally Posted by chumpywumpy

You must have different data to me. You will need to look n the tables and see which ones start off at level zero as i have messed around with my templates and databases so much they don't have the default templates anymore. Idx 1 should be it but check first.

---

Thanks u again chumpywumpy.

---------- Post added at 09:13 PM ---------- Previous post was at 07:53 PM ----------

sry again, i run * values(@UserNum, 0, DATEADD(day, 100 , getdate()), 0) * this msg show *Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'values'.*

You don't run that as it isn't a query. That is the line to edit in the cabal_tool_registeraccount stored procedure. Open the account database in the tree view, go into programmability and ceck the stored procedures.

Quote:

---

Originally Posted by chumpywumpy

You don't run that as it isn't a query. That is the line to edit in the cabal_tool_registeraccount stored procedure. Open the account database in the tree view, go into programmability and ceck the stored procedures.

---

XD thanks again and again chumpywumpy ,success my premium acc.:thumbup:

How to auto give new players skill,combo/bike/board
Please I want more.

erm i dont get i tryd
update cabal_charge_auth set Type=1
and
update cabal_charge_auth set Type=5
stil a free user :S
well auto prem is working now with



CREATE TRIGGER [premiumforall] ON [dbo].[cabal_charge_auth]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [account].[dbo].[cabal_charge_auth] SET
[Type] = 2
,[ExpireDate] = DATEADD(year, 10, getdate())
,[PayMinutes] = 999999
,[ServiceKind] = 1

hope this helps for other people here

onlie auto alz is problem now

Quote:

---

Originally Posted by kogame

How to auto give new players skill,combo/bike/board

---

Take a look at this table: account.cabal_newEtcData_table
It's pretty self-explanatory.

Quote:

---

Originally Posted by kogame

Please I want more.

---

O RLY? :P:

I would like change item at start.
But in cabal_newetcdata He has written <Binary Data> .
So I can't edit.

Quote:

---

Originally Posted by wesley2811

erm i dont get i tryd
update cabal_charge_auth set Type=1
and
update cabal_charge_auth set Type=5
stil a free user :S
well auto prem is working now with



CREATE TRIGGER [premiumforall] ON [dbo].[cabal_charge_auth]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [account].[dbo].[cabal_charge_auth] SET
[Type] = 2
,[ExpireDate] = DATEADD(year, 10, getdate())
,[PayMinutes] = 999999
,[ServiceKind] = 1

hope this helps for other people here

onlie auto alz is problem now

---

Triggers are not a good idea for things like this. With that trigger every single time cabal_charge_auth is inserted into, updated or deleted from your SQL server will go through every single row in the table updating it. The more rows you have the harder your SQL is having to work constantly updating rows.

Also as cabal_charge_auth doesn't really get changed this will only trigger when a new user is inserted. You would be better off using the infinite premium from my xmas gift box as it will constantly update and not add extra load onto SQL.

Quote:

---

Originally Posted by foxyyy

I would like change item at start.
But in cabal_newetcdata He has written <Binary Data> .
So I can't edit.

---

Yes it is in binary format and you need to be able to decode the binary data to change it. There isn't much you can do about this. Yet *hint* :wink:

how to add skill all new chatacter
help me please

Share All Skill/All Skill Bike /Unlock Quest Etc

Quote:

---

/****** Object: Stored Procedure dbo.cabal_sp_newchar Script Date: 2008-4-14 5:52:47 ******/



CREATE PROCEDURE [dbo].[cabal_sp_newchar] (@charname varchar(16), @characteridx int, @style int, @stylemast int)
AS
begin
SET NOCOUNT ON
if( exists ( select * from cabal_badwoard where badword=@charname ) ) select convert(int,0x04)
else if( exists ( select * from cabal_character_table where Name=@charname ) ) select convert(int,0x03)
else if( exists ( select * from cabal_character_table where characteridx=@characteridx ) ) select convert(int,0x02)
else if( @stylemast < 0x01 or @stylemast > 0x06 ) select convert(int,0x02)
else
begin
-----------------------------------------------------------------------------------------------
declare @RegTime dateTime, @userNum int, @serverIdx int, @result int, @sty int
set @userNum = @characterIdx/8
set @serverIdx = dbo.getServerIdx()
set @RegTime = getDate()
set @result = convert(int, 0xA0) + @stylemast
------------------------------------------------------------------------------------------------

select charTable.*, etcTable.equipmentData, etcTable.inventoryData, etcTable.skillData,
etcTable.quickSlotData, etcTable.questData, etcTable.questFlagsData
into #tempTable
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 = @serverIdx) as flagTable
where flagTable.etcDataIdx = etcTable.dataIdx and flagTable.charDataIdx = charTable.dataIdx
and charTable.classType = etcTable.classType and charTable.classType = @stylemast

IF( NOT EXISTS ( select * from #tempTable))
BEGIN
select convert(int, 0x01)
drop table #tempTable
return
END
-----------------------------------------------------------------------------------------------
-- ??? ??? ??
EXEC GAMESERVER.account.dbo.cabal_sp_update_character_count @userNum, @serverIdx, 1

--??? ??
insert into cabal_character_table( CharacterIdx, Name, LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
WorldIdx, [Position], Style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1 )
select @characteridx, @charname, LEV, [EXP], [STR], [DEX], [INT], [PNT], Rank, Alz,
WorldIdx, Position, @style, HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField, Reputation, Reserved1
from #TempTable

begin tran
insert into cabal_equipment_table (characterIdx, data) select @characteridx, equipmentData from #TempTable
insert into cabal_inventory_table (characterIdx, data) select @characteridx, inventoryData from #TempTable
insert into cabal_skilllist_table (characterIdx, data) select @characteridx, skillData from #TempTable
insert into cabal_quickslot_table (characterIdx, data) select @characteridx, quickSlotData from #TempTable
insert into cabal_questdata_table (characterIdx, data, flags) select @characteridx, questData, questFlagsData from #TempTable
commit tran

UPDATE cabal_character_table SET Alz=10000000,Style = Style+(21-1)*8, SP = 1638425000, Reputation = 99999999, Style_Old = @style,Nation=2 WHERE CharacterIdx = @characteridx
set @Sty = @Style/8
set @Sty = @Style-@Sty*8
if (@Sty < 9) begin
set @Sty = @Sty+8
end

if(@Sty=9)--war
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=63308333,MAGPNT=658435300,RankEXP=7143634,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444D01014654010148550101497C01014E7D01014F7E0101507F0101519001014BD0000903CD0014052200090ACA00140B3700090DD900140FDA001410DC001411DD001412330009002B000901E6000420DF0014212C01C8522E0108532F01085437010355390103563A010357A5010166A6010167 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x61E64f0400042828F8200100000000f867E6190200042828F8200200000000f86DE6580200042828F8200300000000f873E6210300042828F8200000000000f852E6630000042828F8200400000000f8 where CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data=0x73E00b050004d818d0100100000000f8A0E069020004d818d0100200000000f8CDE02e030004d818d0100300000000f8fAE0e6020004d418d0100000000000f864E084010004d418d0100400000000f8 where CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data=0x70800b050004d818d0100100000000f89d8069020004d818d0100200000000f8ca802e030004d818d0100300000000f8618084010004d418d0100400000000f8f780e6020004d418d0100000000000f8 where CharacterIdx = @characteridx
end
if(@Sty=10)--BL
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=63308333,MAGPNT=658435300,RankEXP=7143634,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444D01014656010148570101498001014E8101014F82010150830101519201014BD000090346000905CD0014062300090ACA00090B3800090DCF001410D300141228000913E6000420DF0014212C01C8522E0108532F010854370103553A01035639010357A5010166A6010167 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x65E64f0400042828F8200100000000f86BE6190200042828F8200200000000f871E6580200042828F8200300000000f877E6210300042828F8200000000000f850E6630000042828F8200400000000f850E6620000042828F8200500000000f8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x46E0d8010004d418d0100400000000f846E0d9010004d418d0100500000000f8EBE018020004d818d0100300000000f891E04e040004d818d0100100000000f8BEE056020004d818d0100200000000f818E11f030004d418d0100000000000f8 WHERE CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data= 0xe88018020004d818d0100300000000f84380d8010004d418d0100400000000f84380d9010004d418d0100500000000f88e804e040004d818d0100100000000f8bb8056020004d818d0100200000000f815811f030004d418d0100000000000f8 WHERE CharacterIdx = @characteridx
end
if(@Sty=11)--wi
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=64356909,MAGPNT=77557783,RankEXP=13697134,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444D01014658010148590101499401014BD1000902D0000903E6000423E700142AE800142DE300142FE20014308D000931E40014328B000933EB0014348C000935E5001436EC001437EA0009388A000939DF00142089000921F20014272C01C8522F0108533001085437010355380103563A010357 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x66E64f0400042929F9200100000000f86CE6190200042929F9200200000000f872E6580200042929F9200300000000f878E6210300042929F9200000000000f84DE6630000042929F9200400000000f84DE6620000042929F9200500000000f8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x19E063000004d919d0100400000000f819E062000004d919d0100500000000f892E04f040004d919d0100100000000f8ECE019020004d919d0100300000000f819E121030004d419d0100000000000f8bFE058020004d919d0100200000000f8 WHERE CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data= 0x8e804f040004d919d0100100000000f8e88019020004d919d0100300000000f8178063000004d919d0100400000000f8178062000004d919d0100500000000f8158121030004d419d0100000000000f8bb8058020004d919d0100200000000f8 WHERE CharacterIdx = @characteridx
end
if(@Sty=12)--FA
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=64356909,MAGPNT=77557783,RankEXP=13697134,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444B0101434D0101465A0101485B0101498701014E8801014F890101508A0101519601014BD1000902D0000903120114239C000924F70014259B00092611011427F500142ADF00142DF300142FF4001431F000143595000937EE0014382C01C8522F0108533001085437010355380103563A010357 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x64E64f0400042929F9200100000000f86AE6190200042929F9200200000000f870E6580200042929F9200300000000f876E6210300042929F9200000000000f84DE6630000042929F9200400000000f84DE6620000042929F9200500000000f8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x28E052000004d419d0100500000000f828E053000004d419d0100400000000f8B0E091020004d919d0100200000000f8DDE080020004d919d0100300000000f80AE1c7020004d419d0100000000000f883E0aa040004d919d0100100000000f8 WHERE CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data= 0x268052000004d419d0100500000000f8ac8091020004d919d0100200000000f8d98080020004d919d0100300000000f80681c7020004d419d0100000000000f8268053000004d419d0100400000000f87f80aa040004d919d0100100000000f8 WHERE CharacterIdx = @characteridx
end
if(@Sty=13)--FS
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=64356909,MAGPNT=73220948,RankEXP=10420384,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444C0101434D0101465C0101485D0101498401014E8501014F860101509801014B390009012400090235000903290009060F0009091C00090AD000090DD1000900E6000421F9001423FA001425DF001426E0001428E1001429FB0014202C01C8522E0108532F01085437010355390103563A010357 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x50E6da0100042929F9200400000000f84EE6550000042929F9200500000000f862E60c0500042929F9200100000000f868E66a0200042929F9200200000000f86EE62f0300042929F9200300000000f874E6e60200042929F9200000000000f8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x50E6da0100042828F8200400000000f84EE6550000042828F8200500000000f862E60c0500042828F8200100000000f868E66a0200042828F8200200000000f86EE62f0300042828F8200300000000f874E6e60200042828F8200000000000f8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x46E0da010004d418d0100400000000f828E055000004d418d0100500000000f874E00c050004d818d0100100000000f8A1E06a020004d818d0100200000000f8CEE02f030004d818d0100300000000f8fBE0e6020004d418d0100000000000f8 WHERE CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data= 0x70800c050004d818d0100100000000f89d806a020004d818d0100200000000f8ca802f030004d818d0100300000000f84380da010004d418d0100400000000f8268055000004d418d0100500000000f8f780e6020004d418d0100000000000f8 WHERE CharacterIdx = @characteridx
end
if(@Sty=14)--FB
begin
UPDATE cabal_character_table SET str=250,Int=250,dex=250,PNT=500,RANK=2570,SWDPNT=64356909,MAGPNT=73220948,RankEXP=10420384,WARPBFIELD=1023,MAPSBFIELD=1023 WHERE CharacterIdx = @characteridx
UPDATE cabal_questdata_table SET Flags = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF WHERE CharacterIdx = @characteridx
UPDATE cabal_skilllist_table SET Data = 0xA3010147C4010145A40101444D0101465E0101485F0101499A01014BD1000902D00009052100090B2A00090F250009123A000913E600042200011423FD00142403011425FF00142602011427FE00142EDF0014302C01C8522E0108532F01085437010355390103563A010357A5010166A6010167 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x63E64f0400042828F8200100000000f869E6190200042828F8200200000000f86FE6580200042828F8200300000000f875E6210300042828F8200000000000f84FE6630000042828F8200400000000f84DE6620000042828F8200500000000f8 WHERE CharacterIdx = @characteridx
UPDATE cabal_equipment_table set Data= 0x37E016020004D418D0100400000000F8AFE090020004D818D0100200000000F819E061000004D418D0100500000000F882E0A9040004D818D0100100000000F8DCE07F020004D818D0100300000000F809E1C6020004D418D0100000000000F8 WHERE CharacterIdx = @characteridx
--UPDATE cabal_equipment_table set Data= 0x348016020004D418D0100400000000F8AC8090020004D818D0100200000000F8178061000004D418D0100500000000F87F80A9040004D818D0100100000000F8D9807F020004D818D0100300000000F80681C6020004D418D0100000000000F8 WHERE CharacterIdx = @characteridx
end


--UPDATE cabal_character_table SET str=0,Int=0,dex=0 WHERE CharacterIdx = @characteridx
UPDATE cabal_character_table SET Style = Style+25165824 WHERE CharacterIdx = @characteridx
UPDATE cabal_inventory_table SET Data = 0x840200000000000000000000000000F8B0034700002800000000020000000000050000000000E70300000300000000F829033D08000424F400200400000000F829033C08000424F400200500000000F83A010F0B000425F500200600000000F83A010E0B000425F500200700000000F8 WHERE CharacterIdx = @characteridx


----------------------------------------------------------------------------------------------

-- ??? 0xA1 ~ 0xA6
drop table #tempTable
select convert(int, @result)
-----------------------------------------------------------------------------------------------
end

SET NOCOUNT OFF
end
GO

---

im use CharDataIdx,EtcDataIdx =2
lv 99 set +4 and changekit face,color,hair style,renamecard.X-gencard
i want delete changekit face,color,hair style,renamecard.X-gencard
where i fix that?

dafuq. i cant seem to find where the account database is located !
where can i actually find it !?

how i give ponta inferno warp and map for all new users i don't know code ...