-
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 ;)
-
Re: How to auto give new players premium, stats, mapcodes etc
very nice and useful guide for everyone. thanks chump ;)
-
Re: How to auto give new players premium, stats, mapcodes etc
-
Re: How to auto give new players premium, stats, mapcodes etc
this guide rocks.. good job sir chumpy...^^
-
Re: How to auto give new players premium, stats, mapcodes etc
Wowwww!!! goood aport THANKSSSSSSSSSSSSSSSS!!!
-
Re: How to auto give new players premium, stats, mapcodes etc
thanks for this good guide. And what statement I should do to disable that function?
-
Re: How to auto give new players premium, stats, mapcodes etc
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...
-
Re: How to auto give new players premium, stats, mapcodes etc
i love the procedures and db ++
Nice release
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
-
Re: How to auto give new players premium, stats, mapcodes etc
Or use to edit all existent accounts to give premium :
Quote:
update cabal_charge_auth set Type=5
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
-
Re: How to auto give new players premium, stats, mapcodes etc
what is the exact number for char that is level 1 with all map enable and warp with some items.
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
Use the same query, but set chardataidx and etcdataidx back to 10.
-
Re: How to auto give new players premium, stats, mapcodes etc
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
sir how to add pets on signup?
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
Quote:
Originally Posted by
jaeker1
im interested in how hdid this sorry for sounded dumb but kind of lost on how he was able to add certain things
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
anybody help how to give all player
Premiun account free for all and All Maps Free For Premiun Account
-
Re: How to auto give new players premium, stats, mapcodes etc
just follow the guide read the post
-
Re: How to auto give new players premium, stats, mapcodes etc
Thanks man u are the best!
-
Re: How to auto give new players premium, stats, mapcodes etc
I tried
Code:
update cabal_newCharData_table set WarpBField=1023, MapsBField=1023
To give all the maps and it works so yeah.
-
Re: How to auto give new players premium, stats, mapcodes etc
This Guide is Very Very Nice...
Thanks for this...
Big Thanks....
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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:
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
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!
-
Re: How to auto give new players premium, stats, mapcodes etc
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 <.<
-
Re: How to auto give new players premium, stats, mapcodes etc
you are not allowed to ask people to do your entire work!
-
Re: How to auto give new players premium, stats, mapcodes etc
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 ??
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
please tell me where the location of "cabal_tool_registeraccount"
because i want to set the premium user..
tq
-
Re: How to auto give new players premium, stats, mapcodes etc
It`s located in account`s stored procedures.
-
Re: How to auto give new players premium, stats, mapcodes etc
Quote:
Originally Posted by
cypher
It`s located in account`s stored procedures.
that in server sentos or database ?
-
Re: How to auto give new players premium, stats, mapcodes etc
In the database, under account->stored procedures. Familiarise yourself with the contents of this folder in each db ;)
-
Re: How to auto give new players premium, stats, mapcodes etc
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...
-
Re: How to auto give new players premium, stats, mapcodes etc
Thats just great! Many thanks! :hail:
-
Re: How to auto give new players premium, stats, mapcodes etc
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 ;)
-
Re: How to auto give new players premium, stats, mapcodes etc
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:
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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'.*
-
Re: How to auto give new players premium, stats, mapcodes etc
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.
-
Re: How to auto give new players premium, stats, mapcodes etc
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:
-
Re: How to auto give new players premium, stats, mapcodes etc
How to auto give new players skill,combo/bike/board
Please I want more.
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
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:
-
Re: How to auto give new players premium, stats, mapcodes etc
I would like change item at start.
But in cabal_newetcdata He has written <Binary Data> .
So I can't edit.
-
Re: How to auto give new players premium, stats, mapcodes etc
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:
-
Re: How to auto give new players premium, stats, mapcodes etc
how to add skill all new chatacter
help me please
-
Re: How to auto give new players premium, stats, mapcodes etc
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
-
Re: How to auto give new players premium, stats, mapcodes etc
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?
-
Re: How to auto give new players premium, stats, mapcodes etc
dafuq. i cant seem to find where the account database is located !
where can i actually find it !?
-
Re: How to auto give new players premium, stats, mapcodes etc
how i give ponta inferno warp and map for all new users i don't know code ...