Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

How to Give Beginner ITEMS ON NEW CHARACTER

window123

window123

Newbie Spellweaver
Joined
Jan 10, 2011
Messages
55
Reaction score
24

familiarize first this Number code of Character Classes
Code: 
0 - No Class 
[COLOR="Red"]1[/COLOR] - Warrior Class 
[COLOR="Red"]2[/COLOR] - Blader Class  
[COLOR="Red"]3[/COLOR] - Wizard Class 
[COLOR="Red"]4[/COLOR] - Force Archer Class  
[COLOR="Red"]5[/COLOR] - Force Shielder Class
[COLOR="Red"]6[/COLOR] - Force Blader Class


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.


then go to your SQL GAMEDB DATABASE and make this query:

Code: 
SELECT CharacterIdx FROM cabal_character_table WHERE Name = '[COLOR="Red"]test[/COLOR]'

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
Code: 
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = '[COLOR="Red"]11[/COLOR]' [COLOR="Red"]<---- [/COLOR][COLOR="Red"]The Character IDX gave to you by the Query above[/COLOR]
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '[COLOR="Red"]IDX[/COLOR]' [COLOR="Red"]<--The Idx you're copying to so WHAT I WILL PUT HERE?[/COLOR] 

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 dont know what you will put there so you need this.

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
Code: 
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	[COLOR="Red"]2[/COLOR]	1	<Binary data>	<Binary data>	<Binary data>	<Binary data>	NULL	<Binary data>
8	[COLOR="Red"]2[/COLOR]	2	<Binary data>	<Binary data>	<Binary data>	<Binary data>	NULL	<Binary data>
9	[COLOR="Red"]2[/COLOR]	3	<Binary data>	<Binary data>	<Binary data>	<Binary data>	NULL	<Binary data>
10	[COLOR="Red"]2[/COLOR]	4	<Binary data>	<Binary data>	<Binary data>	<Binary data>	NULL	<Binary data>
11	[COLOR="Red"]2[/COLOR]	5	<Binary data>	<Binary data>	<Binary data>	<Binary data>	NULL	<Binary data>
12	[COLOR="Red"]2[/COLOR]	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>


this only the summary of cabal_newEtcData_table DATA IDX 2 above .
Code: 
7	2	[COLOR="Red"]1[/COLOR]	so this is Warrior Class 
8	2	[COLOR="Red"]2[/COLOR]	so this is Blader Class  
9	2	[COLOR="Red"]3[/COLOR]	so this is Wizard Class 
10	2	[COLOR="Red"]4[/COLOR]	so this is Force Archer Class  
11	2	[COLOR="Red"]5[/COLOR]	so this is Force Shielder Class
12	2	[COLOR="Red"]6[/COLOR]	so this is Force Blader Class




example of cabal_newCharData_table:
This is your ACCOUNT DATABASE "cabal_newCharData_table
Code: 
1	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	[COLOR="Red"]2[/COLOR]	2	99	266000000	16	16	3	706	1799	100000000	2	4849874	49087213	26673675	1638425000	15007745	25886721	0	0	1023	1023	-5108668643587261876	20000
8	[COLOR="Red"]2[/COLOR]	4	99	266000000	6	12	17	706	1799	100000000	3	10682429	42009217	41353847	1638425000	17891329	21757953	0	0	1023	1023	-5108668643587261876	20000
9	[COLOR="Red"]2[/COLOR]	6	99	266000000	12	11	12	706	1799	100000000	3	10485821	45548215	37814849	1638425000	15007745	21757953	0	0	1023	1023	-5108668643587261876	20000
10	[COLOR="Red"]2[/COLOR]	5	99	266000000	15	9	11	706	1799	100000000	1	1310754	45548215	37814849	1638425000	15007745	21757953	0	0	1023	1023	-5108668643587261876	20000
11	[COLOR="Red"]2[/COLOR]	1	99	266000000	24	8	3	706	1799	100000000	1	1572900	49087213	34275851	1638425000	15007745	25886721	0	0	1023	1023	-5108668643587261876	20000
12	[COLOR="Red"]2[/COLOR]	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 THIS IS THE FINAL CODE OF THE IDX 2
Code: 
[/COLOR][/B]
[COLOR="Red"]7[/COLOR]	2	1	so this is Warrior Class 
[COLOR="Red"]8[/COLOR]	2	2	so this is Blader Class  
[COLOR="Red"]9[/COLOR]	2	3	so this is Wizard Class 
[COLOR="Red"]10[/COLOR]	2	4	so this is Force Archer Class  
[COLOR="Red"]11[/COLOR]	2	5	so this is Force Shielder Class
[COLOR="Red"]12[/COLOR]	2	6	so this is Force Blader Class

SO YOU CAN NOW RUN THIS QUERY ON YOUR ACCOUNT DATABASE:

Code: 
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = '[COLOR="Red"]11[/COLOR]' 
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '[COLOR="Red"]7[/COLOR]'   

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 i put 7 ??
Code: 
[COLOR="Red"]7[/COLOR]	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.


Code: 
/*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 = '[COLOR="Red"]9[/COLOR]'   

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?
Code: 
[COLOR="Red"]9[/COLOR]	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 server
You must run a new QUERY ON ACCOUNT DATABASE:

Code: 
update cabal_newflagdata_table set chardataidx=2, etcdataidx=2

Note on this final code: I dont know if this is complete code .. but still this is working...


CREDITS TO ALL RAGEZONERS MEMBERS:
 
Last edited:
The Best DDoS Protected Servers
window123

window123

Newbie Spellweaver
Joined
Jan 10, 2011
Messages
55
Reaction score
24
Yes!!! thats a separated threads so i created and merge and edit a single thread from those Threads, which can help and much understandable for other members so they will not use SEARCH BUTTON to find all of that threads.... and when some members will post a thread regarding this question some other members posting "USE SEARCH BUTTON" so next time the other members will not recieved that answer from other members who knows how to do this one.


For More Info:
im not OWNING this one im not like OTHERS owning a Released or tutorials so when somebody asking about the problem of there released they cant answer or do something to fix that problem 'coz they are not the one do that??? Before i posted a tutorial I tested it first and read all some thread similar from my thread before i make it visible to public ;)

IM USING CREDITS.. thats All. ^^
 
Last edited:
Y

Yamachi

Banned
Banned
Joined
Oct 20, 2006
Messages
3,245
Reaction score
1,652
Please provide proper credits. Giving credits to "ALL RAGEZONER MEMBERS" is not sufficient. Thank you.
 
Snorfiets

Snorfiets

Initiate Mage
Joined
Apr 22, 2011
Messages
1
Reaction score
0
Since this says ALL RAGEZONER MEMBERS I am also entitled to the credits? :)
 
3

337513

Newbie Spellweaver
Joined
Jan 31, 2014
Messages
9
Reaction score
0
i done like in tutorial and the query works fine ... but when i done all things and i create new char dont work, the char is still lvl 1without equip...pls help
i changed query too from GAMEDB IN Server01 like this
DECLARE @x CHAR(2)
SET @x ='109'


DECLARE @y CHAR(2)
SET @y ='12'


UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table] SET
[InventoryData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),
[EquipmentData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_equipment_table] WHERE [CharacterIdx] = @x)
WHERE [Idx] = @y
 
Last edited:
M

MadMaxx

Banned
Banned
Joined
Oct 24, 2016
Messages
15
Reaction score
0
Hello im new here. but I try to run this query on my database. followed all steps Mentioned on 1st post,

But when I create new Character, Nothing has changed to its Inventory,

Can anyone help me point out the Problem?

thanks!


Code: 
[COLOR=#666666]UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table] SET[/COLOR]
[COLOR=#666666][InventoryData] = (SELECT [Data] FROM [[/COLOR][COLOR=#ff0000]Server01[/COLOR][COLOR=#666666]].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),[/COLOR]
[COLOR=#666666][EquipmentData] = (SELECT [Data] FROM [[/COLOR][COLOR=#ff0000]Server01[/COLOR][COLOR=#666666]].[dbo].[cabal_equipment_table] WHERE [CharacterIdx] = @x)[/COLOR]
[COLOR=#666666]WHERE [Idx] = @y[/COLOR]
 
P

paperamodez

Initiate Mage
Joined
Feb 9, 2011
Messages
3
Reaction score
0
however i try this, i can't get it to work :$:

Code: 
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = '16' 
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '7'   

UPDATE [Server01].[dbo].[cabal_new_character_data] SET
    [InventoryData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),
    [EquipmentData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x)
WHERE [ClassType] = @y

and this is what i get in my dbo.cabal_new_character_data

window123 - How to Give Beginner ITEMS ON NEW CHARACTER - RaGEZONE Forums


any tips what i've done wrong?
or what am I missing not doing..
thanks in advance...


update: i get it work.. Thank you for the tips..
 
Last edited:
P

paperamodez

Initiate Mage
Joined
Feb 9, 2011
Messages
3
Reaction score
0
PunkS7yle said:
You're running an update query on classtype = 7 , which obviously doesn't exist.
Click to expand...

yes sir, i figured that out and im thinking that's one of my problem,
i try to make new Idx from my cabal_newCharData_table by copying line 1 (warrior class) up to line 6 (force blader class) and edit DataIdx from 1 to 2
then execute the query
which i honestly dont know what its going to be as result
window123 - How to Give Beginner ITEMS ON NEW CHARACTER - RaGEZONE Forums


by doing that and the code from the tutorial
Code: 
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = '8' 
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '7'   

UPDATE [Server01].[dbo].[cabal_new_character_data] SET
    [InventoryData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),
    [EquipmentData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x)
WHERE [ClassType] = @y

after that i run query in Account database
Code: 
update cabal_newflagdata_table set chardataidx=2, etcdataidx=2

restart client and server in CentOS

still i can't get it to work..:$:

by the way thank you sir PunkS7yle for the reply..

i wonder how to properly edit this table
new_character_data
window123 - How to Give Beginner ITEMS ON NEW CHARACTER - RaGEZONE Forums


gives me error when i try to edit data column

window123 - How to Give Beginner ITEMS ON NEW CHARACTER - RaGEZONE Forums
 
Last edited:
G

GODSKIN

Banned
Banned
Joined
Aug 2, 2011
Messages
1,427
Reaction score
979
Code: 
## CODE Skill  BM 1 2 3 COMBO ##
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F010151000100010100A501016600A601016700DA01016800E101016900E201016A00E301016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003601035700D10001020003000103000A00010400CB00010500D000010600160001070006000108001E00010900CC00010A000E00010B004400010C001A00010D002700010E00D800010F0026000110002B00011100CD000112003300011300CE000114002200011500CA00011600D2000117003700011800D900011900DB00011A00DA00011B003F00011C00DC00011D00DD00011E000C00011F00E600012000DF00012100DB01014A00
WHERE ClassType = 1
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004D01014600560101480057010149009201014B008001014E008101014F00820101500083010151000100010100A501016600A601016700DA01016800E601016900E701016A00E801016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003701035700D100010200D0000103001000010400CB000105001200010600CC0001070016000108001F00010900D300010A004400010B002800010C002600010D002C00010E004600010F00CD000110003400011100D4000112002300011300CA00011400D2000115003800011600D500011700D6000118004000011900CF00011A00D700011B00E600012000DF000121000400011C001800011D000700011E001B00011F00DC01014A00
WHERE ClassType = 2
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x64000120004D01014600580101480059010149009401014B008100012100A501016600A601016700DA01016800EB01016900EC01016A00ED01016B00A301014700A401014400C4010145002C010A52002F01085400300108530038010355003A010356003601035700E200012200A7000123008B00012400E300012500E4000126008D00012700EB00012800E5000129008C00012A008A00012B00DF00012C00EC00012D00EA00012E008800012F008900013000E900013100F200013200E8000133008000013400E60001350078000136007300013700850001380084000139007700013A007500013B007600013C008200013D008300013E007200013F007D0001400074000141008700014200DD01014A00
WHERE ClassType = 3
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x4B010143004D010146005A010148005B010149009601014B008701014E008801014F0089010150008A01015100A501016600A601016700DA01016800F001016900F101016A00F201016B00A301014700A401014400C4010145002F010852002C010A5300300108540038010355003A010356003601035700E600012200ED000123009500012400EE00012500BB010126009600012700B601012800B701012900B801012A00B901012B00F000012C00BA01012D00BC01012E00EF00012F00C201013100F100013300BD01013400C101013500BE010137009800013900F300013A00F200013B00F400013C009900013D00DF00013E00F500013F00F6000140009A0001410010010142009B000120001101013600F7000138009C000132001201013000A800012100DE01014A00
WHERE ClassType = 4
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004C010143004D010146005C010148005D010149009801014B008401014E008501014F0086010150009D00012000A501016600A601016700DA01016800F501016900F601016A00F701016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003601035700E100012100F800012200E6000123009E00012400DF00012500F900012600FA000127009F00012800E000012900FB00012A0041000101000500010200D1000103000B0001040008000105000D00010600D000010700160001080020000109000F00010A001C00010B004400010C002600010D002900010E004700010F002D00011000D5010111003500011200D40101130024000114003900011500DF01014A00
WHERE ClassType = 5
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x020001000064000120004D010146005E010148005F010149009A01014B00FC00012100D001014E00D101014F00D201015000D301015100A501016600A601016700DA01016800FA01016900FB01016A00FC01016B000500010100A301014700A401014400C401014500D100010200D0000103001100010400130001050042000106003A00010700150001080021000109001600010A004400010B003600010C002E00010D002A00010E002500010F00FF00012200FD0001230000010124000301012500E6000126000201012700FE00012800F1000129007E00012A007F00012B007D00012C007C00012D007B00012E007A00012F0079000130000401013100DF000132000501013300060101340007010135000D010136000E010137000F010138002C010A52002E010853002F010854003A0103550039010356003701035700EF000139000101013A00E001014A00
WHERE ClassType = 6
 
M

MadMaxx

Banned
Banned
Joined
Oct 24, 2016
Messages
15
Reaction score
0
GODSKIN said:
Code: 
## CODE Skill  BM 1 2 3 COMBO ##
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F010151000100010100A501016600A601016700DA01016800E101016900E201016A00E301016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003601035700D10001020003000103000A00010400CB00010500D000010600160001070006000108001E00010900CC00010A000E00010B004400010C001A00010D002700010E00D800010F0026000110002B00011100CD000112003300011300CE000114002200011500CA00011600D2000117003700011800D900011900DB00011A00DA00011B003F00011C00DC00011D00DD00011E000C00011F00E600012000DF00012100DB01014A00
WHERE ClassType = 1
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004D01014600560101480057010149009201014B008001014E008101014F00820101500083010151000100010100A501016600A601016700DA01016800E601016900E701016A00E801016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003701035700D100010200D0000103001000010400CB000105001200010600CC0001070016000108001F00010900D300010A004400010B002800010C002600010D002C00010E004600010F00CD000110003400011100D4000112002300011300CA00011400D2000115003800011600D500011700D6000118004000011900CF00011A00D700011B00E600012000DF000121000400011C001800011D000700011E001B00011F00DC01014A00
WHERE ClassType = 2
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x64000120004D01014600580101480059010149009401014B008100012100A501016600A601016700DA01016800EB01016900EC01016A00ED01016B00A301014700A401014400C4010145002C010A52002F01085400300108530038010355003A010356003601035700E200012200A7000123008B00012400E300012500E4000126008D00012700EB00012800E5000129008C00012A008A00012B00DF00012C00EC00012D00EA00012E008800012F008900013000E900013100F200013200E8000133008000013400E60001350078000136007300013700850001380084000139007700013A007500013B007600013C008200013D008300013E007200013F007D0001400074000141008700014200DD01014A00
WHERE ClassType = 3
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x4B010143004D010146005A010148005B010149009601014B008701014E008801014F0089010150008A01015100A501016600A601016700DA01016800F001016900F101016A00F201016B00A301014700A401014400C4010145002F010852002C010A5300300108540038010355003A010356003601035700E600012200ED000123009500012400EE00012500BB010126009600012700B601012800B701012900B801012A00B901012B00F000012C00BA01012D00BC01012E00EF00012F00C201013100F100013300BD01013400C101013500BE010137009800013900F300013A00F200013B00F400013C009900013D00DF00013E00F500013F00F6000140009A0001410010010142009B000120001101013600F7000138009C000132001201013000A800012100DE01014A00
WHERE ClassType = 4
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x02000100004C010143004D010146005C010148005D010149009801014B008401014E008501014F0086010150009D00012000A501016600A601016700DA01016800F501016900F601016A00F701016B00A301014700A401014400C4010145002C010A52002E010853002F0108540039010355003A010356003601035700E100012100F800012200E6000123009E00012400DF00012500F900012600FA000127009F00012800E000012900FB00012A0041000101000500010200D1000103000B0001040008000105000D00010600D000010700160001080020000109000F00010A001C00010B004400010C002600010D002900010E004700010F002D00011000D5010111003500011200D40101130024000114003900011500DF01014A00
WHERE ClassType = 5
UPDATE [Server01].dbo.cabal_new_character_data
SET SkillData =
0x020001000064000120004D010146005E010148005F010149009A01014B00FC00012100D001014E00D101014F00D201015000D301015100A501016600A601016700DA01016800FA01016900FB01016A00FC01016B000500010100A301014700A401014400C401014500D100010200D0000103001100010400130001050042000106003A00010700150001080021000109001600010A004400010B003600010C002E00010D002A00010E002500010F00FF00012200FD0001230000010124000301012500E6000126000201012700FE00012800F1000129007E00012A007F00012B007D00012C007C00012D007B00012E007A00012F0079000130000401013100DF000132000501013300060101340007010135000D010136000E010137000F010138002C010A52002E010853002F010854003A0103550039010356003701035700EF000139000101013A00E001014A00
WHERE ClassType = 6
Click to expand...

Hello GODSKIN may I know whats this Starter Set contain? :D
 
PunkS7yle

PunkS7yle

Cya nerds
Loyal Member
1000 Posts 10 Happy Years
Joined
Feb 26, 2010
Messages
1,374
Reaction score
780
Nothing, those are just skills.

Code: 
/*The CharacterIdx you're copying from*/
DECLARE @x CHAR(2)
SET @x = '8' 
/*The Idx you're copying to*/
DECLARE @y CHAR(2)
SET @y = '7'   

UPDATE [Server01].[dbo].[cabal_new_character_data] SET
    [InventoryData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = @x),
    [EquipmentData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = @x)
WHERE [ClassType] = @y

This query will never work because theres no classtype = 7 !

What you need to do is equip a character with the items you want and then run

Code: 
UPDATE [Server01].[dbo].[cabal_new_character_data] SET
    [InventoryData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Inventory_table] WHERE [CharacterIdx] = [COLOR="#FF0000"]that_chars_idx)[/COLOR],
    [EquipmentData] = (SELECT [Data] FROM [Server01].[dbo].[cabal_Equipment_table] WHERE [CharacterIdx] = [COLOR="#FF0000"]that_chars_idx[/COLOR])
WHERE [ClassType] = [COLOR="#FF0000"]1 -- 1= WA , max 6.[/COLOR]

So for example you make a WA, equip it and run the above query just with the edited char id in, if you make a BL you have to change the classtype to 2, 3 for WI and so on
Class type list is
Code: 
<msg id="class1" cont="Warrior" />
		<msg id="class2" cont="Blader" />
		<msg id="class3" cont="Wizard" />
		<msg id="class4" cont="Force Archer" />
		<msg id="class5" cont="Force Shielder" />
		<msg id="class6" cont="Force Blader" />
 
L

lordgell

Newbie Spellweaver
Joined
Mar 28, 2019
Messages
44
Reaction score
0
Msg 515, Level 16, State 2, Line 8Cannot insert the value NULL into column 'InventoryData', table 'Server01.dbo.cabal_new_character_data'; column does not allow nulls. UPDATE fails.The statement has been terminated.


why does it say like that? i even checked inventorydata of the specific character but it has, how come it says null? but if i use the other account it works, but not this.
 
pizzagaming0812

pizzagaming0812

Newbie Spellweaver
Joined
Oct 30, 2023
Messages
22
Reaction score
1
lordgell said:
Msg 515, Level 16, State 2, Line 8Cannot insert the value NULL into column 'InventoryData', table 'Server01.dbo.cabal_new_character_data'; column does not allow nulls. UPDATE fails.The statement has been terminated.


why does it say like that? i even checked inventorydata of the specific character but it has, how come it says null? but if i use the other account it works, but not this.
Click to expand...
still working?.. i tried this set query on navicat not working
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
189
Guests online
7,255
Total visitors
7,444
Totals may include hidden visitors.

Forum statistics

Threads
429,078
Messages
4,590,185
Members
280,598
Latest member
dinero2024
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top