[release] ep6 itemmall fixed

04/25/2015 22:08 Boul27#91
Quote:
Originally Posted by SkuulCandy View Post
Check your charapplyskills table (many query exist for rune 30day actived when the character is created)
So u had edit itemallfix.dll or ps-game ? @Trayne01
Actually we are trying to find how to fix it.

The dll is disassembled.

There is a lot of data that we don't understand ...
Without source code, it's not very understandable.

In all of the code (49515 lines ..), we only found 3 util function :
Initialize the db connexion
- SWC10019688_Provider_SQLOLEDB_1_Integrated_S:
unicode 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=(Local)',0000h
dd L10019DE0

Read the points
- SWC10019840_select_point_from_ps_userdata_db:
unicode 'select point from ps_userdata.dbo.users_master where useruid=%d',0000h

Update the points
- SWC100198D0_update_ps_userdata_dbo_users_mas:
unicode 'update ps_userdata.dbo.users_master set point=%d where useruid=%d',0000h


All the rest of the code is about some strange function, or mathematical function, like sin, tan .. vector .. etc..
04/25/2015 22:13 SkuulCandy#92
Quote:
Originally Posted by Boul27 View Post
Actually we are trying to find how to fix it.

The dll is disassembled.

There is a lot of data that we don't understand ...
Without source code, it's not very understandable.

In all of the code (49515 lines ..), we only found 3 util function :
Initialize the db connexion
- SWC10019688_Provider_SQLOLEDB_1_Integrated_S:
unicode 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=(Local)',0000h
dd L10019DE0

Read the points
- SWC10019840_select_point_from_ps_userdata_db:
unicode 'select point from ps_userdata.dbo.users_master where useruid=%d',0000h

Update the points
- SWC100198D0_update_ps_userdata_dbo_users_mas:
unicode 'update ps_userdata.dbo.users_master set point=%d where useruid=%d',0000h


All the rest of the code is about some strange function, or mathematical function, like sin, tan .. vector .. etc..
Euhm nice ;)
04/25/2015 22:43 Trayne01#93
Quote:
The dll is disassembled.
Credits? lol
04/25/2015 23:13 Cansas59#94
its working fine
04/26/2015 05:29 SkuulCandy#95
Quote:
Originally Posted by Trayne01 View Post
Credits? lol
Yes :3 credit to Trayne01 \0/
04/26/2015 05:54 arjulie#96
you want the fix of this the full fix i will think if i will release.
04/26/2015 07:11 Big_#97
please if you can arjulie
04/26/2015 10:58 Boul27#98
Quote:
Originally Posted by Trayne01 View Post
Credits? lol
God are you serious ?

I didn't tell that I HAVE disassamble the dll ...

WE are working on it, i don't give a shit about who make what.

The only goal is to avoid crash at the 11th buy, and make it work on sql 2012.

I read all the line, and tried to interpret them.
Am i crying for the credit of reading more that 45k of ASM line-code ?
04/26/2015 11:47 Cansas59#99
idk what your problem is...install 2008 r2 and works fine
04/26/2015 11:56 SnickQ#100
Quote:
Originally Posted by Cansas59 View Post
idk what your problem is...install 2008 r2 and works fine
As i remember is impossible using 2012 DATABASE with players in 2008 version
04/26/2015 11:57 Boul27#101
Quote:
Originally Posted by Cansas59 View Post
idk what your problem is...install 2008 r2 and works fine
I have 2008 R2, and the problem is that at the 11th purchase, client crash ..
04/26/2015 12:15 SkuulCandy#102
Quote:
Originally Posted by Boul27 View Post
God are you serious ?

I didn't tell that I HAVE disassamble the dll ...

WE are working on it, i don't give a shit about who make what.

The only goal is to avoid crash at the 11th buy, and make it work on sql 2012.

I read all the line, and tried to interpret them.
Am i crying for the credit of reading more that 45k of ASM line-code ?
+1 but i think, for the community we have to work together and not alone.
04/26/2015 13:59 Trayne01#103
This fix now working with SQL Server 2012, we work now to fix 11+ crash.
04/26/2015 15:03 SkuulCandy#104
Quote:
Originally Posted by Trayne01 View Post
This fix now working with SQL Server 2012, we work now to fix 11+ crash.
We know ;)
04/26/2015 15:52 Cansas59#105
Quote:
UPDATED:fix DC when buy items from itemmall over 11 times
he have to fix oO