[Release] *DNT MSSQL Row Changer(SQUERY) /Mini Guide

[major333]

Hello forum!

I've encountered some weird methods of changing a lot of rows in different types of colums which didn't work out when converting back to *DNT from *CSV by using "DNTableConverter"

I noticed that if you convert one of the large *DNT tables to *CSV it doesn't fully get all of what supposed to convert to.

Soooooo in that case use the "DB2DNT" tool and once you have injected the table in to your Database use this query to change 1 entire row of any of the column.


Be sure to select the table you want to edit and then select "New Query"
[MS SQL Query]

/* [This query is was made by major333/sirmajor] */
/* [All Row Select/Replace] */

Update
    [COLOR=#ff0000]enchanttable_temp[/COLOR]   /* <----[Change this to the table in your DB of which you want to edit in]*/
SET 
    [COLOR=#ff0000]_EnchantRatio[/COLOR]=[COLOR=#ff0000]1.0[/COLOR]  /*[The first line of this is the [COLOR=#ff0000]Column [/COLOR]that you want to modify and ='[COLOR=#ff0000]value[/COLOR]' ]*/
WHERE [COLOR=#ff0000]1[/COLOR] <= [COLOR=#ff0000]999999[/COLOR];  /*[From row 1 to what ever row you want it to go to]*/

After executing that and everything should be changed.
Open up the "DB2DNT" tool and select "Table to DNT" then save the file to where ever then it should convert fully =]



Hope this helps out any to you who are having problems with changing multiple large rows in the DB or such. If anyone want's to code a better query than this then just post it in the comments below and i will update this.

 

[GuitarZ]

You know how to change EXP or Drop ?

sorry i bad eng

 

[major333]

You know how to change EXP or Drop ?

sorry i bad eng

Not just yet.

 

[GuitarZ]

Drop rate low

 

[kokominaruse]

Can you give the file enchanttable_temp.dnt ?

 

[Oktavina01]

item drop rate easy to find, but gold drop rate is difficult

 

[LeSwrd]

If you want to change exp, the easiest would be changing the channel bonus exp. Find ChannelInfo.xml in your server files folder and it should look like this.

<MeritBonusTable>
  <Bonus ID="1" MinLevel="1" MaxLevel="9" BonusType="CompleteExp" ExtendValue="[COLOR=#ff0000]60[/COLOR]"></Bonus>
  <Bonus ID="2" MinLevel="9" MaxLevel="16" BonusType="CompleteExp" ExtendValue="[COLOR=#ff0000]50[/COLOR]"></Bonus>
  <Bonus ID="3" MinLevel="16" MaxLevel="32" BonusType="CompleteExp" ExtendValue="[COLOR=#ff0000]15[/COLOR]"></Bonus>
  <Bonus ID="4" MinLevel="24" MaxLevel="70" BonusType="CompleteExp" ExtendValue="[COLOR=#ff0000]10[/COLOR]"></Bonus>
  <Bonus ID="5" MinLevel="1" MaxLevel="1" BonusType="CompleteExp" ExtendValue="0"></Bonus>
</MeritBonusTable>

Change the red numbers to what you want.

As for item drop, i'm not too sure. I tried changing the dnt files of itemdropgrouptable_item.dnt and itemdroptable_item.dnt etc.. but it only drops more gold. Although i've only tested this with the lvl 70 gaurdian nest chest.

 

[Oktavina01]

but with that i have level mismatch, between myDB and in game ie:my db=40, in game=70
how to fix it?

 

[major333]

item drop rate easy to find, but gold drop rate is difficult

I know how to change the drop rate of the coins.

 

[Oktavina01]

I know how to change the drop rate of the coins.

can you give me a clue major333? what file should i look for to edit?

 

[major333]

can you give me a clue major333? what file should i look for to edit?

monsteritem.dnt

 

[fhansiwadon]

hey i can't find DB2DNT where are u download?