(help)Cabal Items

Im confused on how to put a beginner Items for example. if i create a new character with Full Set of Items... HOw to make it. when i see the newetcdata its on <binary data>.. can somebody guide me step by step how to make this one. thanks in advance...

I use these queries to view and save modified data.

Select what row you want to view by setting @x to the idx. Execute and you'll get the data. Modify to your liking but you'll need to have a look at the thread mentioned below about item binary code to know what to do.

After you're done editing take the second query and insert your data. You'll have to adjust the number in DECLARE @x BINARY(48) to avoid it adding extra 0's or if your new data is longer, cutting it off too soon.

Code:

---

DECLARE @x CHAR(2)
SET @x = '1'


SELECT [InventoryData] FROM [ACCOUNT].[dbo].[cabal_newEtcData_table]
WHERE Idx = @x
SELECT [EquipmentData] FROM [ACCOUNT].[dbo].[cabal_newEtcData_table]
WHERE Idx = @x
SELECT [SkillData] FROM [ACCOUNT].[dbo].[cabal_newEtcData_table]
WHERE Idx = @x
SELECT [QuickSlotData] FROM [ACCOUNT].[dbo].[cabal_newEtcData_table]
WHERE Idx = @x

---

Code:

---

DECLARE @y CHAR(200)

/*Insert changed data*/
SET @y = '0x0300000000000500000000000000000006000000000005000000010000000000F0000000000000000000020000000000'

DECLARE @x BINARY(48)

DECLARE @sql NVARCHAR(200)

SET @sql = 'SELECT @x = ' + @y

EXEC sp_executesql

@sql,

N'@x BINARY(200) OUTPUT',

@x OUTPUT

SELECT @x

UPDATE [ACCOUNT].[dbo].[cabal_newEtcData_table]
SET [InventoryData] = @x
WHERE [Idx] = '1'

---

These are some threads you might want to take a look at.
http://forum.ragezone.com/f460/tips-...binary-430732/
http://forum.ragezone.com/f460/auto-...remium-452000/

Greetz,
Speedy

Thanks so very useful.


so for example there are 6 classes of character...
*so first if i will edit the Class 1 Warrior character. i need a character first to create and make it as my test account and give that character the item accessories or pet that i want to make a beginner items.
*then find the binary code of that character class and make the things and thread that you've been posted
*then after that i execute the code that you've gave?

That could be one way to do it. Make a character, fill his inventory with what you want new characters to start with. Do the same for his equipment and then use this query to directly copy the data into the newEtcData_table.

Easiest way to create the items would be http://forum.ragezone.com/f459/playe...ol-new-517871/.
Very good toolkit.

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 = '1'

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

---

Greetz,
Speedy