familiarize first this Number code of Character Classes
If you want to make an edit Beginning or starting items when you first creating a character this is the easy way for me. First Create a WARRIOR CLASS Character for example name that character "test" then give that character all the items you want for example full set of MITHRIL with +6 and complete accessories.0 - No Class 1 - Warrior Class 2 - Blader Class 3 - Wizard Class 4 - Force Archer Class 5 - Force Shielder Class 6 - Force Blader Class
then go to your SQL GAMEDB DATABASE and make this query:
SELECT CharacterIdx FROM cabal_character_table WHERE Name = 'test'
why test ?? its because thats the name of the example character you've created as an example ..now the query will give you the IDX of your character
for example the query gives you an IDX of 11
So you must run a new QUERY like this
Dont run this code first if you dont know what you put here on ACCOUNT Database just take a look first
You dont know what you will put there so you need this./*The CharacterIdx you're copying from*/ DECLARE @x CHAR(2) SET @x = '11' <---- The Character IDX gave to you by the Query above /*The Idx you're copying to*/ DECLARE @y CHAR(2) SET @y = 'IDX' <--The Idx you're copying to so WHAT I WILL PUT HERE? UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table] SET [InventoryData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x), [EquipmentData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x) WHERE [Idx] = @y
you must look first at this code and table below :
for Example we will used the cabal_newEtcData_table (DATA IDX 2 for all the NEW CHARACTERS created on your GAME.
You can see at the cabal_newCharData_table below if what is the corresponding options of the DATA IDX 2 that the character have like LEVEL,STATS,ALZ etc etc.
example of cabal_newEtcData_table:
this is your cabal_newEtcData_table from your ACCOUNT DATABASE
this only the summary of cabal_newEtcData_table DATA IDX 2 above .1 1 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 2 1 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 3 1 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 4 1 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 5 1 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 6 1 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 7 2 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 8 2 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 9 2 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 10 2 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 11 2 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 12 2 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 13 3 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 14 3 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 15 3 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 16 3 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 17 3 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 18 3 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 19 4 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 20 4 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 21 4 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 22 4 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 23 4 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 25 4 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 26 5 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 27 5 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 28 5 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 29 5 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 30 5 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 31 5 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 32 6 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 33 6 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 35 6 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 36 6 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 37 6 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 38 6 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 39 7 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 40 7 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 41 7 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 42 7 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 43 7 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 44 7 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 45 8 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 46 8 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 47 8 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 48 8 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 49 8 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 50 8 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 51 10 1 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 52 10 2 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 53 10 3 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 54 10 4 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 55 10 5 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data> 56 10 6 <Binary data> <Binary data> <Binary data> <Binary data> NULL <Binary data>
example of cabal_newCharData_table:7 2 1 so this is Warrior Class 8 2 2 so this is Blader Class 9 2 3 so this is Wizard Class 10 2 4 so this is Force Archer Class 11 2 5 so this is Force Shielder Class 12 2 6 so this is Force Blader Class
This is your ACCOUNT DATABASE "cabal_newCharData_table
SO THIS IS THE FINAL CODE OF THE IDX 21 1 1 1 0 24 8 3 0 257 0 1 1376293 3276850 1310740 0 0 0 0 0 1023 1023 -5108668643680969908 0 2 1 2 1 0 16 16 3 0 257 0 2 4915405 3276850 1310740 0 0 0 0 0 1023 1023 -5108668643680969908 0 3 1 3 1 0 3 6 26 0 257 0 2 4915405 2621480 2293795 0 0 0 0 0 1023 1023 -5108668643680969908 0 4 1 4 1 0 6 12 17 0 257 0 3 10485821 2621480 2293795 0 0 0 0 0 1023 1023 -5108668643680969908 0 5 1 5 1 0 15 9 11 0 257 0 1 1376293 2949165 1966110 0 0 0 0 0 1023 1023 -5108668643680969908 0 6 1 6 1 0 12 11 12 0 257 0 3 10485821 2949165 1966110 0 0 0 0 0 1023 1023 -5108668643680969908 0 7 2 2 99 266000000 16 16 3 706 1799 100000000 2 4849874 49087213 26673675 1638425000 15007745 25886721 0 0 1023 1023 -5108668643587261876 20000 8 2 4 99 266000000 6 12 17 706 1799 100000000 3 10682429 42009217 41353847 1638425000 17891329 21757953 0 0 1023 1023 -5108668643587261876 20000 9 2 6 99 266000000 12 11 12 706 1799 100000000 3 10485821 45548215 37814849 1638425000 15007745 21757953 0 0 1023 1023 -5108668643587261876 20000 10 2 5 99 266000000 15 9 11 706 1799 100000000 1 1310754 45548215 37814849 1638425000 15007745 21757953 0 0 1023 1023 -5108668643587261876 20000 11 2 1 99 266000000 24 8 3 706 1799 100000000 1 1572900 49087213 34275851 1638425000 15007745 25886721 0 0 1023 1023 -5108668643587261876 20000 12 2 3 99 266000000 3 6 26 706 1799 100000000 2 4915405 42009217 41353847 1638425000 17891329 21757953 0 0 1023 1023 -5108668643587261876 20000 14 3 2 125 876678800 16 16 3 892 2056 200000000 2 4915405 62063539 43844253 1638425000 18612225 32440321 0 0 1023 1023 -5108668643821758132 50000 15 3 4 125 876678800 6 12 17 892 2056 200000000 3 10879031 52953901 52626211 1638425000 22151169 27328513 0 0 1023 1023 -5108668643821758132 50000 16 3 6 125 876678800 12 11 12 892 2056 200000000 3 10747961 57672560 48235232 1638425000 18939905 27787265 0 0 1023 1023 -5108668643821758132 50000 17 3 5 125 876678800 15 9 11 892 2056 200000000 1 1376300 57672560 48235232 1638425000 18939905 27787265 0 0 1023 1023 -5108668643821758132 50000 18 3 1 125 876678800 24 8 3 892 2056 200000000 1 1703970 62063539 43844253 1638425000 18612225 32440321 0 0 1023 1023 -5108668643821758132 50000 19 3 3 125 876678800 3 6 26 892 2056 200000000 2 4915405 53281581 52626211 1638425000 22151169 27328513 0 0 1023 1023 -5108668643821758132 50000 20 4 1 99 266000000 24 8 3 570 262 50000000 1 1769509 35652128 14287066 1638425000 20643841 1 0 0 1023 1023 -5108668643705426996 10000 21 4 5 99 266000000 15 9 11 570 262 50000000 1 1900583 32113130 17826064 1638425000 15728641 1 0 0 1023 1023 -5108668643705426996 10000 22 4 6 99 266000000 12 11 12 570 262 50000000 3 10616884 32113130 17826064 1638425000 15728641 1 0 0 1023 1023 -5108668643705426996 10000 23 4 4 99 266000000 6 12 17 570 1537 50000000 3 10485814 22020432 27918762 1638425000 1 20643841 0 0 1023 1023 -5108668643705426996 10000 24 4 3 99 266000000 3 6 26 570 1537 50000000 2 4915405 22020432 27918762 1638425000 1 20643841 0 0 1023 1023 -5108668643705426996 10000 25 4 2 99 266000000 16 16 3 570 262 50000000 2 4915405 35652128 14287066 1638425000 20643841 1 0 0 1023 1023 -5108668643705426996 10000 26 5 1 125 876678700 24 8 3 728 263 100000000 1 1048611 45351604 18284823 1638425000 28901377 1 0 0 1023 1023 -5108668643587261876 20000 27 5 5 125 876678700 15 9 11 728 263 100000000 1 1441839 40960625 22675802 1638425000 22020097 1 0 0 1023 1023 -5108668643587261876 20000 28 5 6 125 876678700 12 11 12 728 263 100000000 3 10747955 40960625 22675802 1638425000 22020097 1 0 0 1023 1023 -5108668643587261876 20000 29 5 4 125 876678700 6 12 17 728 1793 100000000 3 10616894 27722151 35914276 1638425000 1 28901377 0 0 1023 1023 -5108668643587261876 20000 30 5 2 125 876678700 16 16 3 728 263 100000000 2 4915405 45351604 18284823 1638425000 28901377 1 0 0 1023 1023 -5108668643587261876 20000 31 5 3 125 876678700 3 6 26 728 1793 100000000 2 5112012 27722151 35914276 1638425000 1 28901377 0 0 1023 1023 -5108668643587261876 20000 32 6 1 99 266000000 24 8 3 706 1799 100000000 1 1572900 49087213 34275851 1638425000 28901377 15138817 0 0 1023 1023 -5108668643587261876 20000 33 6 5 99 266000000 15 9 11 706 1799 100000000 1 1310754 45548215 37814849 1638425000 22020097 22020097 0 0 1023 1023 -5108668643587261876 20000 35 6 6 99 266000000 12 11 12 706 1799 100000000 3 10485821 45548215 37814849 1638425000 22020097 22020097 0 0 1023 1023 -5108668643587261876 20000 36 6 4 99 266000000 6 12 17 706 1799 100000000 3 10682429 42009217 41353847 1638425000 15138817 28901377 0 0 1023 1023 -5108668643587261876 20000 37 6 2 99 266000000 16 16 3 706 1799 100000000 2 4849874 49087213 26673675 1638425000 28901377 15138817 0 0 1023 1023 -5108668643587261876 20000 38 6 3 99 266000000 3 6 26 706 1799 100000000 2 4915405 42009217 41353847 1638425000 15138817 28901377 0 0 1023 1023 -5108668643587261876 20000 39 7 1 125 876678800 24 8 3 892 2056 200000000 1 1703970 62063539 43844253 1638425000 38535169 20185089 0 0 1023 1023 -5108668643821758132 50000 40 7 5 125 876678800 15 9 11 892 2056 200000000 1 1376300 57672560 48235232 1638425000 29360129 29360129 0 0 1023 1023 -5108668643821758132 50000 41 7 6 125 876678800 12 11 12 892 2056 200000000 3 10747961 57672560 48235232 1638425000 29360129 29360129 0 0 1023 1023 -5108668643821758132 50000 42 7 4 125 876678800 6 12 17 892 2056 200000000 3 10879031 52953901 52626211 1638425000 20185089 38535169 0 0 1023 1023 -5108668643821758132 50000 43 7 2 125 876678800 16 16 3 892 2056 200000000 2 4915405 62063539 43844253 1638425000 38535169 20185089 0 0 1023 1023 -5108668643821758132 50000 44 7 3 125 876678800 3 6 26 892 2056 200000000 2 4915405 53281581 52626211 1638425000 20185089 38535169 0 0 1023 1023 -5108668643821758132 50000 45 8 1 150 3847000000 24 8 3 1073 2313 500000000 1 1114158 75826309 54330173 1638425000 49545217 25952257 0 0 1023 1023 -5108668643987325364 100000 46 8 5 150 3847000000 15 9 11 1073 2313 500000000 1 1179690 70583349 59507596 1638425000 37748737 37748737 0 0 1023 1023 -5108668643987325364 100000 47 8 6 150 3847000000 12 11 12 1073 2313 500000000 3 10485808 70583349 59507596 1638425000 37748737 37748737 0 0 1023 1023 -5108668643987325364 100000 48 8 4 150 3847000000 6 12 17 1073 2313 500000000 3 10682423 65405926 64750556 1638425000 25952257 49545217 0 0 1023 1023 -5108668643987325364 100000 49 8 2 150 3847000000 16 16 3 1073 2313 500000000 2 5046472 75826309 54330173 1638425000 49545217 25952257 0 0 1023 1023 -5108668643987325364 100000 50 8 3 150 3847000000 3 6 26 1073 2313 500000000 2 4915405 65405926 64750556 1638425000 25952257 49545217 0 0 1023 1023 -5108668643987325364 100000 51 10 1 1 0 24 8 3 0 257 0 1 1376293 3276850 1310740 0 0 0 0 0 1023 1023 0 0 52 10 2 1 0 16 16 3 0 257 0 2 4915405 3276850 1310740 0 0 0 0 0 1023 1023 0 0 53 10 3 1 0 3 6 26 0 257 0 2 4915405 2621480 2293795 0 0 0 0 0 1023 1023 0 0 54 10 4 1 0 6 12 17 0 257 0 3 10485821 2621480 2293795 0 0 0 0 0 1023 1023 0 0 55 10 5 1 0 15 9 11 0 257 0 1 1376293 2949165 1966110 0 0 0 0 0 1023 1023 0 0 56 10 6 1 0 12 11 12 0 257 0 3 10485821 2949165 1966110 0 0 0 0 0 1023 1023 0 0
SO YOU CAN NOW RUN THIS QUERY ON YOUR ACCOUNT DATABASE:7 2 1 so this is Warrior Class 8 2 2 so this is Blader Class 9 2 3 so this is Wizard Class 10 2 4 so this is Force Archer Class 11 2 5 so this is Force Shielder Class 12 2 6 so this is Force Blader Class
WHY i put 7 ??/*The CharacterIdx you're copying from*/ DECLARE @x CHAR(2) SET @x = '11' /*The Idx you're copying to*/ DECLARE @y CHAR(2) SET @y = '7' UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table] SET [InventoryData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x), [EquipmentData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x) WHERE [Idx] = @y
7 2 1 so this is Warrior Class
So do all the same thing make first a Items suitable for every CHARACTER for example you've finished editing the WIZARD then you set like this.
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = 'IDX' The character of your wizard
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '9'
UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table] SET
[InventoryData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),
[EquipmentData] = (SELECT [Data] FROM [GAMEDB].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x)
WHERE [Idx] = @y
Why 9?
9 2 3 so this is Wizard Class
then after you've done all of that on every character you must now use the IDX 2 on your serverYou must run a new QUERY ON ACCOUNT DATABASE:
window123update cabal_newflagdata_table set chardataidx=2, etcdataidx=2
Ragezone