[Release] Rappelz RDB Tool with tabs

Page 3 of 27 12 3 4513 Last »
02/09/2014 22:09 Bethduna#31
Quote:
Originally Posted by glandu2 View Post
ya indeed 1433 not 1443. You can use [Only registered and activated users can see links. Click Here To Register...] to post images
For how to add a data source, i will add a mini tutorial
ok thx you VM i'm waiting for it :)
02/10/2014 01:51 glandu2#32
I am trying to support nvarchar, that is unicode characters, but the RDB file is using non unicode data (which is why there are many ??? in db_string.rdb), and unicode things are used differently on windows than on linux, so you can have broken characters when dealing with non native characters from the SQL table or the RDB.

Any way, here are the screen of how I add a data source (I did not change anything not shown in these screens) :
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
02/10/2014 03:10 rootJacker#33
nice tools thank
02/10/2014 03:40 sona998#34
With this type,

{MAKEINDEXEDVAR(2, 1), TYPE_DECIMAL, "delay_cast"}, it doesn't saves the value correctly. I.e. if a spell has a 1 second cast time, it will save it as a 0.1 second cast time.

The same happens with debuff durations. E.g. Siren's Painful Noise lasts for 10s, but it state it only lasts for 1s.

How to correctly save decimals?
02/10/2014 12:25 glandu2#35
{MAKEINDEXEDVAR(2, 1), TYPE_DECIMAL, "delay_cast"}

indicate that the value is a decimal number stored as an integer with two digits after the comma.
So: the integer 500 in the RDB will be read as 5.00, 1203 would be read as 12.03
So if there is only one digit after the comma, replace the 2 with 1.
If you need to put a 0 instead of the 2, just make it a TYPE_INT32:
{1, TYPE_INT32, "delay_cast"}

Because a decimal with 0 digit after the comma is just a int32

Quote:
Originally Posted by Bethduna View Post
Sorry glandu2 but i still can't connet to my database :( i tryed to mace ODBC conection but it couldn't helt... I make sql conection with 1334 port; the rest configuration is in this img. :) Help me plz if u can :) Thx you a lot!
You need to put SQL as data source, as the text select in your screen.
02/10/2014 16:15 Bethduna#36
Quote:
Originally Posted by glandu2 View Post
I am trying to support nvarchar, that is unicode characters, but the RDB file is using non unicode data (which is why there are many ??? in db_string.rdb), and unicode things are used differently on windows than on linux, so you can have broken characters when dealing with non native characters from the SQL table or the RDB.

Any way, here are the screen of how I add a data source (I did not change anything not shown in these screens) :
Thx u VM :) Now all work ur my superman :D Ty again
02/10/2014 17:51 eziorav#37
does your tool import non english chars? cause i tried to import koréan string resource but that didn't work very well
02/10/2014 20:15 glandu2#38
Quote:
Originally Posted by eziorav View Post
does your tool import non english chars? cause i tried to import koréan string resource but that didn't work very well
Working on that ^^ ATM I can import the arabic stringresource from the DB on my computer which use franch characters, and it works on linux. I have some issue with iconv on windows, but I just found a way to bundle it within my tool (so no additionnal libiconv.dll)

The target locale will be set by the new combobox at the left of the search field, which allow anyone to load any RDB and SQL strings on any computers.
02/10/2014 22:01 mongreldogg#39
Quote:
Originally Posted by glandu2 View Post
Indeed, but which way would be better to add that feature ?

I think of a checkbox, that tell when opening/saving a RDB file to either use the default filename or the hashed default filename as the default name in the file dialogbox

So with that, I will add default RDB filename and default SQL table name (CSV filename would be the rdb one but with csv extension)
this tool is more than any noob like me ever used, so any way wont make this tool worse=) btw idk how anyone thinks about it but i think if you will add a hasher in additional window (combobox where user can chose one of default rdb names or type own and textbox where hashed file name will be shown) with correct hasher for any filename, even not included in client as default, it will be the greatest
02/11/2014 00:09 julioclitwin#40
@glandu2
You have my respect! It is very rare to have people like you, who like to contribute.
02/11/2014 02:09 sona998#41
Quote:
Originally Posted by glandu2 View Post
{MAKEINDEXEDVAR(2, 1), TYPE_DECIMAL, "delay_cast"}

indicate that the value is a decimal number stored as an integer with two digits after the comma.
So: the integer 500 in the RDB will be read as 5.00, 1203 would be read as 12.03
So if there is only one digit after the comma, replace the 2 with 1.
If you need to put a 0 instead of the 2, just make it a TYPE_INT32:
{1, TYPE_INT32, "delay_cast"}

Because a decimal with 0 digit after the comma is just a int32
Yes, I pretty much worked that out. This works when you are reading from a rdb and saving into sql. That's wasn't my problem. My problem is when loading from sql then saving to rdb, it doesn't works like intended.

I.e. If a spell has a 1s delay cast, it will save it as 10 in the rdb, which is wrong, it needs to be saved as 100.

If a spell has a 0.5s delay cast, it will save it as 5 in the rdb, but it needs to be saved as 50.

See what I am saying? For now, I'm just multiplying all delay casts by 10 pre-hand, then load from sql and save into rdb.
02/11/2014 14:14 glandu2#42
(Irrelevant questions was here)

[edit]
I just found that i have the same problem as you, the SQL table has delay_cast / 10, working on it
Seems more of a bug of the SQL reader than a version problem, my sql table as a type of decimal(2, 10), and quering it give me correct values.

I found the problem, it will be corrected in the next version (which should be posted today)

Keep {MAKEINDEXEDVAR(2, 1), TYPE_DECIMAL, "delay_cast"} for the next version, it a SQL read problem

[edit]
Last issue I hope, with the newest sql driver ...

I posted the new version (2.3.0) on the original post. I will not remove old versions anymore, if the latest as serious bugs having the older version is nice.

A dialog to hash filenames will be added for a next version, but this one allow to choose hashed default filename when opening/saving a file
02/12/2014 05:20 sona998#43
Testing the updated version. I believe the save rdb button is broken. I load from sql then hit save to rdb, it auto names it db_skill.rdb but then I hit save, the program crashes (standard Windows crash report error dialog).

Looks like type_decimal is fixed, as when I load from sql, delay cast values looks fine. But cannot really test to see since I cannot save into rdb and run test server/client. XD
02/12/2014 12:18 glandu2#44
Quote:
Originally Posted by sona998 View Post
Testing the updated version. I believe the save rdb button is broken. I load from sql then hit save to rdb, it auto names it db_skill.rdb but then I hit save, the program crashes (standard Windows crash report error dialog).

Looks like type_decimal is fixed, as when I load from sql, delay cast values looks fine. But cannot really test to see since I cannot save into rdb and run test server/client. XD
Weird, I don't have this crash, but found a crash when loading SQL table with 0 length strings

Does it crash before loading anything (ie: the progress bar stay at 0% ?)

I updated the post with the correction about SQL table and 0 length strings crash. But I definitely didn't have any crashes when saving the file to RDB, maybe it was related to the corrected bug
02/12/2014 23:48 eziorav#45
Glandu im getting these errors while trying to compile a new dll
help please
[Only registered and activated users can see links. Click Here To Register...]
Page 3 of 27 12 3 4513 Last »