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]Send items to your character. Edit them. Add titles

Newbie Spellweaver
Joined
Aug 3, 2010
Messages
68
Reaction score
2
not 100% sure but there's a section in the costumes table that i think determinates the version the item should be available in, (Ko-KR/CN/EU/US/TW) i think the table said shop class/type or something, havn't looked into it recently

Do you mean EquipItemInfo? There's a column called Feature and next to it are region names, that's the only thing I found in the database (dumped the db as an .sql file and searched for the item name)

PunkS7yle - [How To]Send items to your character. Edit them. Add titles - RaGEZONE Forums


It already says zhTW though
 
Newbie Spellweaver
Joined
Jul 12, 2016
Messages
63
Reaction score
1
yup i think that's it, make it only tw btw, see if that works
 
Newbie Spellweaver
Joined
Aug 21, 2016
Messages
18
Reaction score
0
Yo, how do I reset "Push Items," everytime I add an item all the prior items are also added.

ex. Push gold, get gold. Next push erg, get gold and erg. Push sword, get gold, erg, and sword.

It's kinda getting out of hand.
 
Newbie Spellweaver
Joined
Aug 25, 2016
Messages
17
Reaction score
0
hey guys has anyone figured out how to add regina equips? like either the shards or the feathers, or the whole equip itself?
 
Newbie Spellweaver
Joined
Aug 21, 2016
Messages
18
Reaction score
0
I still don't know how to add them, but what you can do is cheat to wreck Regina once and craft a Regina item. Look for it in ItemAttribute and it should look some thing like this.

COMBINATION 0;3;1;4;2;5;3;6;4;7
PS_0 0;1000;9;25000;1;1000
PS_1 16;101;19;101
PS_2 19;2;3;1;4;9999;5;3;6;2
PS_3 14;450;16;101
PS_4 0;138;1;170;3;7;4;3;23;50;6;2

I'm not too sure what the COMBINATION line is for, but I do know what the next lines do.

PS_0 is the Regina feather/wing thingy,
Ex: 0;1000;9;25000;1;1000
Here 0(idk);1000(ATK);9(Attribute);25000(Attribute Variable);1(IDK);1000(MATK)

You can modify ATK and MATK to whatever, but don't mess with 0&1.
Attributes are the fun part!

Here's what I know so far:

1 = Cause Crash
2 = DEF
3 = STR
4 = AGI
5 = INT
6 = WIL
7 = LUK
8 = HP
9 = STA
10-13 = Nothing
14 = ATK SPD
15 = Additional Damage
16 = Crit
17 = Nothing (Crit limit?)
18 = Crit Res
19 = Balance
20 = PvP ATK
21 = PvP MATK
22 = PvP DEF
23 = Town SPD

The number after the ";" is the value of the variable.

Ex:pS_1 16;101;19;101

16 = Crit, 101 is the value, so the item provides 101 Crit
19 = Balance, 101 is the value, to the item provides 101 balance

You can also go to heroescontents.db3 and modify the items in "VariableStatInfo"
 
Newbie Spellweaver
Joined
Aug 25, 2016
Messages
17
Reaction score
0
Oh wow I'll have to look into this. Btw I can't run any of the season 3 raids besides the rest gives me errors. Know how to fix that??
 
Newbie Spellweaver
Joined
Aug 21, 2016
Messages
18
Reaction score
0
I haven't played Vindi in 2/3 years, idk how to access the S3 raids. I've only ran Regina, but the Ep2&3 items are in the game so those bosses should be accessible somehow.
 
Newbie Spellweaver
Joined
Aug 25, 2016
Messages
17
Reaction score
0
I haven't played Vindi in 2/3 years, idk how to access the S3 raids. I've only ran Regina, but the Ep2&3 items are in the game so those bosses should be accessible somehow.[/QUOTE]

They are I just don't know whats causing the errors to show up
 
Newbie Spellweaver
Joined
Aug 30, 2016
Messages
5
Reaction score
0

How do I straight up view a table like this in SSMS? This is what mssql 2008 was like where I can just go in and view/edit things at my leisure. In 2014 I can right click and select top 1000 rows to bring some info up but sometimes the tables exceed that count.
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Sep 2, 2016
Messages
3
Reaction score
0
When trying to do the push items thing the HeroesCommand logs this error
Code:
09-02 08:22:36 > System.FormatException: String was not recognized as a valid DateTime.09-02 08:22:36 >    at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
09-02 08:22:36 >    at HeroesCommandClient.Commands.Cmd_pushitem(String command, IList`1 args) in z:\062B\global\HeroesCode\misc\RCSystem\HeroesCommandClient\Commands.cs:line 93
09-02 08:22:36 >    at HeroesCommandClient.HeroesCommandBridge.ProcessCommand(String rawCommand) in z:\062B\global\HeroesCode\misc\RCSystem\HeroesCommandClient\Main.cs:line 164
09-02 08:22:36 >    at Devcat.Core.Threading.JobProcessor.<Loop>b__0()
09-02 08:22:36 >    at Devcat.Core.ExceptionHandler.Util.Filter(Action body, Action`1 filter, Action`1 handler)
Could anyone tell me the correct format for date and time? Is the date and time it feeds into that function decided by the Windows date format settings?
 
Newbie Spellweaver
Joined
Aug 21, 2016
Messages
9
Reaction score
0
Does anyone know how to update an existing Attribute in the database?

ItemAttribute.PNG - [How To]Send items to your character. Edit them. Add titles - RaGEZONE Forums

Or how to push 'SPIRIT_INJECTION' on an item in the optool?
not sure how you would enter the 'value' and the 'arg'

example: s2_champion_hammer[ENHANCE:15][QUALITY:5][PREFIX:justice][SUFFIX:judgment][SPIRIT_INJECTION:????]
 

Attachments

You must be registered for see attachments list
Last edited:
Back
Top