Removing Duplication Bug.

[Chaitanya]

I want to remove the Duplication bug in the server.
Where the stuffs of merce gets duplicated.


Anyone who knows it please reply to this thread !

 

[cvrdheeraj]

What duplication bug?

 

[cigu]

I think its a problem related to MSSQL database.
Check data type of HSDB.HSTABLE.HSExp : make it 'bigint' and all shud be ok.

 

[Chaitanya]

Thx for the reply,,
I'll try it once,

@Cvr, Let me check its working or not, I'll tell u what was the bug !

 

[ast009]

I'll to check it

let see what happens

 

[Chaitanya]

Thnx for the reply Cigu.
It worked.

Can u tell me how did u got to know about it, OR What was happening if the data type was not bigint ? ?

 

[cigu]

Thnx for the reply Cigu.
It worked.

Can u tell me how did u got to know about it, OR What was happening if the data type was not bigint ? ?

If data type is 'int', at some level ( around 168 i think), Merc exp will exceed maximum value for that data type.

Maybe this table can clarify:

Data type || Range
bigint (-9,223,372,036,854,775,808) to (9,223,372,036,854,775,807)
int (-2,147,483,648) to (2,147,483,647)
smallint (-32,768) to (32,767)
tinyint 0 to 255

or check this link

You must be registered to see links

 

[Chaitanya]

Nice Description,

Thnx for the reply & The link :

 

[atharvz]

thanx for link nd nw making sm changes in sql nd making a gud server stuffs

 

[Prot]

btw there is another bug which makes merc lvl 300 directly from lvl 1.. donno much how it works but does this fix corrects that bug too ?

 

[cigu]

btw there is another bug which makes merc lvl 300 directly from lvl 1.. donno much how it works but does this fix corrects that bug too ?

I dnt know abt tht bug. Can u tell something more abt it ?

 

[atharvz]

its error dat last party member's merc will get all overflowd xp frm creeps nd get to lvl 300

 

[Deadlykill3r]

btw there is another bug which makes merc lvl 300 directly from lvl 1.. donno much how it works but does this fix corrects that bug too ?

the bug works with a Level 1 char ...
The lvl 1 char has to join the party the Last and hence he gets all the Exp

but thing is somtyms It works and somtyms it doesnt

 

[darksoul14]

that bug was fixed in TTA3, by making merc XP from creeps = 0 in Temoz, Quanato maps .... but this bug still working there in Tao