Code:
INSERT INTO [RohanGame].[dbo].[TEventItem]
SELECT xxxxxxx -- [type]
,0x00 -- attr
,1 -- stack
,0 -- rank
,0 -- equip level
,0 -- str
,0 -- dex
,0 -- int
,id -- char id
, GETDATE() -- date
FROM RohanGame.dbo.TCharacter
change xxxxxxx to your ID items
0x00 -- attr
01 = str
02 = dex
03 = int
04 = psy
05 = vit
06 = agi
07 = weapon attk
08 = armor def
09 = hp reco
0A = mana reco
0B = mobility
0C = attk speed
0D = % crit
0e = hp abso
0f = mana abso
10 = fire resist
11 = water resist
12 = dark resist
13 = holi resist
14 = accuracy
15 = evasion
16 = pdef
17 = %hp
18 = % mp
19 = % magic att
1a = % melee att
1b = % range att
1c = phy def
1d = magic def
1e = weight
1f = potion recovery rate
20 = Mana efficiency
21 = futile attk
22 = Dmg Drop
23 = saved arrow
24 = Heal magic recovery rate
25 = Element attk
26 = Cool off time
27 = % block
28 = %Dmg reflect
29 = pet level (ped only)
2b = pet feed (pet only)
2d = feed time remain(?)
30 = Max HP
31 = Max MP
32 = Dmg reflect
33 = Min Dmg Drop
34 = % stun resist
35 = % poison resist
36 = 20%hp reco
37 = 20%mp reco
3b = crit dmg drop
46 = all stats (r u finding this? )
47 = % attack (all)
48 = defense (all?)
4b = socket
4c = bind when equiped
4f = accessory boost level (crafted accessory)
55 = enchanted weapon
56 = armor enchanted
hexa numbers
