Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 13:59

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Release] Rappelz RDB Tool with tabs

Reply
 
Old   #61
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,041
Received Thanks: 977
Did you import that db_string_rdb to the database with the database manager



ThunderNikk is offline  
Old   #62
 
elite*gold: 0
Join Date: Jun 2013
Posts: 16
Received Thanks: 1
Quote:
Originally Posted by thndr View Post
Did you import that db_string_rdb to the database with the database manager
no :/


rcadil is offline  
Old   #63
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
Are you sure to use Arabic locale when importing data from the database ?

It seems that it's ok as you have correct characters in sframe. What's wrong in the screen ? the 0.00000Def 0.00000 .... ?
If you didn't find the problem until now, consider posting your SQL table and db_string.rdb as attachment (fo the sql table, export as a sql script preferably)
glandu2 is offline  
Old   #64
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Thank you.
Just wanted to know is your ItemResource Saving/Reading bugged ?
I read ItemResource using Item83Database.dll & Saved to my Database , all looks fine.

After saving to RDB using your tool or Raskim tool => Items are not working at all. like potions,galactic stone etc ...


.BlackCat. is offline  
Old   #65
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,412
Most likely db related, if you sent from item_db directly to your db chances are there is blank data missing somewhere or quiet literally you have the columns in the wrong order, the GS loads using SELECT * FROM dbo.ItemResource WHERE

meaning it is expecting the data in a specific order, so try this:

1. Restore your original 8.2 Arcadia or 8.1 Arcadia (the one who works)

2. Now truncate it (TRUNCATE TABLE dbo.ItemResource)

3. Now rename it to dbo.ItemResourceWAIT

4. Now send the db_item.rdb (8.3) to the database

5. Right click on the new 8.3 itemresource and click Tasks>Generate Scripts make sure to click Advanced and set Schema Only to Schema + Data and then generate it to a new SQL Query Window

6. Now in the new query window drop the "CREATE TABLE" part and switch the dbo.ItemResource to dbo.ItemResourceWAIT and execute

7. Tell me what happens
ismokedrow is offline  
Old   #66
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
With my file, I have korean characters in drop_type column for several rows (although using the FR db_item.rdb file). I am using linux with freetds to do test, and it complain about not being able to convert these chars to target server charset (which is for me an arabic collation).
So I think I need to use utf16 too when writing varchar and char columns to prevents these problems ...

Anyway, for you it should not be the cause of your problem (or indirectly).
Can you add details to what you do to have this problem, is it:
- read rdb
- write sql

- read sql
- write rdb

?

The column order can be the issue, there is a new column in the rdb file (at the end of a record, which I have named unknownValue2.

But this column is at the end, so if the GS use SELECT * from ... and use index, it should just ignore the last one ?

Other columns seems to be the same as for 8.2 db_item.rdb, except unknownValue1 which has 0 now instead of 49

Also describe better what's wrong, I just see that you have an empty cell and potions are not stacked, that's all ? In that case, maybe there are new flags too
glandu2 is offline  
Old   #67
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Quote:
Originally Posted by glandu2 View Post
With my file, I have korean characters in drop_type column for several rows (although using the FR db_item.rdb file). I am using linux with freetds to do test, and it complain about not being able to convert these chars to target server charset (which is for me an arabic collation).
So I think I need to use utf16 too when writing varchar and char columns to prevents these problems ...

Anyway, for you it should not be the cause of your problem (or indirectly).
Can you add details to what you do to have this problem, is it:
- read rdb
- write sql

- read sql
- write rdb

?
1)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using Item83Database.dll
Results : NOT Even one Item working (no icons, no models , nothing)


2)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using ItemDatabase.dll
Results : Some items not working(if I have 10 Stamina for example , they are not stacked,no effects (EXP) etc ...)


3)Reading using Item83Database.dll , saving to SQL.
SQL => RDB using Database Manager of Raskim
Results : Some items not working(same thing as case 2)

After removing the last column "UnknownValue2" , Game server wouldn't start for some reasons :x

EDIT : there "unknownValue1" ? where exactly ?
It's not new Item_use_flag since I checked with my Other Arcadia .
.BlackCat. is offline  
Old   #68
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
unknownValue1 is not put as a column. So the GS dont even see the difference (value was 49 before, 0 now)

If your client is 8.1, It's normal that a 8.3 db_item.rdb will not work (exporting using item83database will make a 8.3 db_item.rdb) ^^ so no problem here

If you remove unknownValue2 column, you have the same columns than the old ItemResource table that was working ?

unknownValue1 is only used in the rdb file, it does not appear as a SQL column (and always have the value 49 for the 8.1 db_item.rdb, 0 for 8.3 one)

My tool and/or Raskim's one was working before ? Or it's the first time you try them ? (for exporting to RDB)
glandu2 is offline  
Old   #69
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Yea , I guess its' wrong values from your program ... even when I use any Item I get in chat "string["2..]:an expected error..."

Edit : Never tried your program , Always use Raskim tools or mine . and working fine
wanted to try your since it's much much faster
.BlackCat. is offline  
Old   #70
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
The sql table generated from the 8.3 db_item.rdb has the same columns + unknownValue2 than the original table that you were using ?

What data you have for the item with ID 900000 ? (stamina saver) For me, drop_type is drop_etc_potion_purple, icon_file_name is icon_item_etc_0108. And what have you for the drop_type for the ID 601100284 ?

I have the exact same values for a db_item.rdb of august 2013 and for the one up to date today (fr).
glandu2 is offline  
Thanks
1 User
Old   #71
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
I found the issue , it was my mistake on Columns order , thanks
.BlackCat. is offline  
Old   #72
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,412
ismokedrow is offline  
Old   #73
 
elite*gold: 0
Join Date: Oct 2012
Posts: 124
Received Thanks: 12
what about hashed names ?
the first letter from hashed name is always wrong
& thanks for useful tool.
MrStubborn is offline  
Old   #74
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
Quote:
Originally Posted by MrStubborn View Post
what about hashed names ?
the first letter from hashed name is always wrong
& thanks for useful tool.
For which name ? For me it works with db_string.rdb, it give me sdXwe'vmvdeHga$, db_item.rdb = U{W.Y(_ZdT!JV

You have an example with the name, the hashing result and the correct hash ?

[edit]
Indeed, the bug is random and I found the problem, it will be corrected in next version (which will be there in less than one week)
glandu2 is offline  
Old   #75
 
elite*gold: 0
Join Date: Apr 2012
Posts: 449
Received Thanks: 770
A new version 2.3.6 with these changes (since 2.3.3):
  • Support NVARCHAR column (for db_string) with unicode data (it's possible to store a french StringResource in an Arabic database along with the Arabic StringResource without character loss)
  • Save to sql script: the table name is the filename without ".sql"
  • Fixed hash conversion issue as discovered by MrStubborn
  • Removed primary keys as official tables dont use them and sometime rows are duplicated
  • I renamed all database description dll to have the epic number (I put 8.1 for all of them, them can work for older epic's still) (it's just to remember for which epic these dll were done, databases description dll without epic number still work)
  • Always use dot as decimal separator in the GUI, CSV and SQL script
  • The tool should not crash anymore when loading a non-rdb file as rdb (it will give "Invalid argument" in this cas)
  • Updated and added some 8.3 rdb struct description dll (about npc and items)
Attached Files
File Type: zip RappelzRDBToolQt-2.3.6.zip (953.3 KB, 61 views)
File Type: zip RappelzRDBTool-2.3.6-db-src.zip (60.4 KB, 48 views)
File Type: zip RappelzRDBTool-2.3.6-dev.zip (7.0 KB, 34 views)


glandu2 is offline  
Thanks
6 Users
Reply



« Previous Thread | Next Thread »

Similar Threads
[Release]Shiva-Rappelz GM-Tool V1
Download VirusTotal GM-Tool not update since the first post, you can update it easily with your Arcadia.
7 Replies - Rappelz Private Server
[Release]e*PvP - Rappelz Section Tool
Well, here is the tool to make accessing/using this board easier a LOT! It has many functions, which i will put SS and explain about each one ( and...
14 Replies - Rappelz Private Server
[RELEASE] Rappelz Ban-Tool
NCarbon left, Silent left, Smokey left, Raskim left... Finally Xij will left, too! NULL
10 Replies - Rappelz Private Server



All times are GMT +2. The time now is 13:59.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.