Hi all,
Im newbie in making private rohan server, i saw many people asking for edit weapon/amor/pet, this is the way I edit these items stats via sql management studio.
If you can make a private server, you should have sql server and management studio, im using MS SQL Server 2008 R2 and its management studio.
I m using server version from
First you need connect to SQL server, then make new query. To run a sql command, simply select command block then hit F5 or click Execute button.
Use this command to select DB:
Use this command to find character id:
Code:
select * from RohanGame.dbo.TCharacter;
Get your character id (id column), then use it in this command:
Code:
select t.name, i.* from TItem as i join BA_database_item as t
on i.type = t.id
where i.char_id = your_char_id_here
order by t.name asc;
Find your item, and get its id in TItem table (id column) and some fields we need, this is my Fenaty's Ray:
Code:
id=94
attr=0x0329000414000B14000C14000D0F00177800224600467800473C00550F00000000000000000000000000
equip_level=75
equip_strength=0
equip_dexterity=0
equip_intelligent=0
To edit item, just change field by update command (dont forget the comma (,) between updated fields)
Code:
update TItem set
attr= your_new_attr,
equip_level = 1,
equip_strength=0,
equip_dexterity=0,
equip_intelligent=0
where id = 94;
Now we see the attr value:
Code:
0x0329000414000B14000C14000D0F00177800224600467800473C00550F00000000000000000000000000
represented by hex character string after "0x", hex character: 0-9,A-F, each item option is represented by 6 character: 2 option type, 4 option value, as my weapon, these are options:
032900 --- 03: psy, 0x0029 = 30 ------------------- +30 psy
041400 --- 04: int, 0x0014 = 20 ------------------- +20 int
0B1400 --- 0B: mobility --------------------------- +20 %mobi
0C1400 --- 0C: attk speed ------------------------- +20 %attk speed
0D0F00 --- 0D: %crit, 0x000F ---------------------- +15 % crit
177800 --- 17: %HP, 0x0078 = 120 ------------------ +120% HP
224600 --- 22: % Dmg Drop, 0x0046 = 70 ------------ +70% DD
467800 --- 46: All stats, 0x0078 = 120 ------------ +120 All stats
473C00 --- 47: %all attack, 0x003C = 60 ----------- +60% attack
550F00 --- 55: weapon enchanted, 000F = 15 -------- enchanted 15
And all "00.." left is just filled for hex string length.
I used calculator (programmer mode) to calculate value, ex: DEC 430 => HEX 1AE = 01 AE, switch position and fill to hex string: AE01
and update to DB:
Code:
update TItem set
attr=0x0329000414000B14000C14000D0F00177800224600467800473C00550F00000000000000000000000000
where id = 94;
This is some option I known:
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
By the way, Im new in setting private server, Gratt underground and ronelia dont have mobs in my server, is there anyone can give me monster file or show me the way to make mobs for these maps.
Thanks
