Edit stats of existing item

Page 1 of 2

02/27/2014 15:51 namvfpx#1

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 [Only registered and activated users can see links. Click Here To Register...]

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:

Code:

use RohanGame;

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:

Spoiler

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

02/27/2014 16:24 zzerachiel#2

[Only registered and activated users can see links. Click Here To Register...]
That's the full list of attributes, extracted from the mapserver.

09/26/2014 05:15 kurinaixl#3

@namvfpx

can you please help me with this?

because i cant find

"attr=0x0329000414000B14000C14000D0F00177800224600 467800473C00550F00000000000000000000000000"

because in me i only see attr = binary data

09/26/2014 08:26 kelvz002#4

Quote:
Originally Posted by namvfpx
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 [Only registered and activated users can see links. Click Here To Register...]

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:
Code:
use RohanGame;
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:

Spoiler

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? :D)
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

if you downloaded ROHAN Server Files from Senzoku, just open C:/RoHan/RoHan/world/world
then put all of the files to the original folder of world

from C:/RoHan/RoHan/world/world
to C:/RoHan/RoHan/world

hope it will fix your problem

09/26/2014 15:12 Banana Bandit#5

Quote:

Originally Posted by kurinaixl

@namvfpx

can you please help me with this?

because i cant find

"attr=0x0329000B14000414000C14000D0F00177800224600 467800473C00550F00000000000000000000000000"

because in me i only see attr = binary data

Array of options in type - 1 byte type, 2-bytes value little endian format.

if you don't know what I just said means, don't fok with it.

09/27/2014 03:47 kurinaixl#6

Quote:

Originally Posted by Banana Bandit

Array of options in type - 1 byte type, 2-bytes value little endian format.

if you don't know what I just said means, don't fok with it.

thanks bro i find the solution...

now my problem is how to create new account TT
and mobs are not moving..

this are my current config @registry

ConnMap = 1-0|1-1|1-2|1-3|1-4|5-0|5-1|5-3|5-4|5-5|3-0|3-1
DBServer = 192.168.0.175:22500
LogServerClass = FAIRY.ROHAN_4.LOG.ROHAN_4
Module = C:\RoHan\RoHan\Fairy\AIServer\AIServer.exe
ServerClass = FAIRY.ROHAN_4.AI.ROHAN_4_1
ServerClassMap = FAIRY.ROHAN_4.MAP_AI.ROHAN_4
TreadSleep = 0x0000005f

and also name are not showing (in top of my ingame char)

09/27/2014 08:31 IncognitoOne#7

Turn AI server on and put all those map id's in there.

09/27/2014 08:57 kurinaixl#8

Quote:

Originally Posted by IncognitoOne

Turn AI server on and put all those map id's in there.

follow up question:

i opened the Ai server but nothing will appear,,,, but when i open again the Ai server it says server is already running.

my question is " is my Aiserver running good (normal that nothing will appear) or running bad (maybe corrupt).

09/27/2014 09:18 Milocinia#9

The AI server takes up a lot of resources. You might have a bugged version or you might not have a powerful enough computer (or allocated enough VMware resources) to run it.

If I want to make some extra fan noise and heat up my room, I turn on the AI server for fun.

09/27/2014 12:40 kurinaixl#10

Quote:

Originally Posted by Milocinia

The AI server takes up a lot of resources. You might have a bugged version or you might not have a powerful enough computer (or allocated enough VMware resources) to run it.

If I want to make some extra fan noise and heat up my room, I turn on the AI server for fun.

u mean even if i wont open the "Aiserver" the mobs will still moving/attack?

09/27/2014 13:09 Banana Bandit#11

Quote:

Originally Posted by kurinaixl

u mean even if i wont open the "Aiserver" the mobs will still moving/attack?

The AIserver is what makes the mobs move and attack. Without it running, mobs just stand around and don't fight back. It is the brains of rohan.

To do that it takes a lot of computer power and it takes a long time to start and the screen to appear. Don't get click happy. If you click anything except 'connect' it will want to close.

09/29/2014 06:23 kurinaixl#12

Quote:

Originally Posted by Banana Bandit

The AIserver is what makes the mobs move and attack. Without it running, mobs just stand around and don't fight back. It is the brains of rohan.

To do that it takes a lot of computer power and it takes a long time to start and the screen to appear. Don't get click happy. If you click anything except 'connect' it will want to close.

I see that's explain everything... my question has been answered...

thank you very much

very well appreciated.

hmm. anyway do u know the map code for whirlwind flied and r3?
(like 1-0 = kainon, 1-1 = vena which is used in aiserver )

09/29/2014 16:43 Dr.Dr.SheldonLeeCooper#13

Quote:

Originally Posted by kurinaixl

I see that's explain everything... my question has been answered...

thank you very much

very well appreciated.

hmm. anyway do u know the map code for whirlwind flied and r3?
(like 1-0 = kainon, 1-1 = vena which is used in aiserver )

Copy & Paste this:

0-1|0-2|0-3|1-0|1-1|1-2|1-3|1-4|2-0|2-1|2-2|2-3|2-4|3-0|3-1|3-2|3-3|3-4|4-0|4-1|4-3|4-5|5-0|5-1|5-2|5-3|5-4|5-5|6-0|6-1|6-2|6-3

Im sry if i forgot some Areas :D

11/11/2014 00:13 reason11#14

Hey where to download server file +db + client rohan?

05/01/2015 10:30 saszuke25#15

can i use this to edit my char weapon even if im not a server owner?? thx for ur feedback/reply ^_^

Page 1 of 2