[release] ep6 itemmall fixed

[Big_]

Shen1l made a youtube vid of how to install it and it is here

[_Diavolino_]

i understood it, this is not the problem...

i would like to get some feedback of the use, what it do in game etc
just it

Thank you

[superklamus]

Originally Posted by Namikaz3

I removed the dll, and now works. But the game does not appear to amount of points in my account. Does anyone know anything about that?

Because you removed the Itemmall.DLL , thats why it does not show.

[Underworld™]

Itemmall fix works fine when i have items with one pcs,but when i have a item with a Stack of 5 i become DC ,anyway to fix this.

*Nice Work for the Fix

[XIBOSDLL]

Originally Posted by shen1l

how to install item mall?


how to install gm tool?


how to use the function from gm tool?


db_agent.exe from Trayne01,seems dupe fixed,i didnt test,cz i dont even know whats dupe packet hack..
i added 1 bytes change for item mall on ps_dbagent.exe

i didnt install backdoor and i will never do it,u guys can download my all source code,and build a new one

for sql 2012,i will add a config.ini later,cause sql2012 require sql user account information,or u guys can use my source code to rebuild one!

plz press ty button if it helps for u

plz add into the "index",if this release not worth less

25-7 updated:add 1 storeproduct

OMG Are you using DLL for the fixes go HIDE.

[yoyosisi]

My bad

[dorrigro]

O itemmallfix.dll está funcionando perfeitamente..




Talvez essas informações possa ajudar quem ainda está com duvidas, estou usando: (x86), (by Philipp_), EP6(by Stinka), Windows 7.

Boa sorte!

[DarwinR]

I get error 10053 when select character and stops ps_game please help

[GkRock]

Originally Posted by sominus

It works for me:

Client: USA EP 5.4
SQL: 2008 R2 Express

Server: [GERMANY] <= (from Logs, you know what I mean)

 Spoiler

But... since we don't have the source, can anyone confirm those files are 'clean' ?

Note: I get a 'memory read error' when stoping the ps_game service (Win XP, Virtualbox)

It would be so kind as to share the file germany
in which the error does not itemmall conxion
German searched the files for all tube side but no luck

Originally Posted by sominus

It works for me:

Client: USA EP 5.4
SQL: 2008 R2 Express

Server: [GERMANY] <= (from Logs, you know what I mean)

 Spoiler

But... since we don't have the source, can anyone confirm those files are 'clean' ?

Note: I get a 'memory read error' when stoping the ps_game service (Win XP, Virtualbox)

It would be so kind as to share the file germany
in which the error does not itemmall conxion
German searched the files for all tube side but no luck

[Agridulce.]

Hi; I used this fix and can buy more than 10 items. But later I obtained this error:

"Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2) 2016-08-08 03:47:42 ::LoadCharacter 1855 test5 qerr=-1, EXEC usp_Read_Chars_PointLog_R 1855"

I tried to fix it on my own but I got a new error:

"Procedure or function 'usp_Read_Chars_PointLog_R' expects parameter '@UserUID', which was not supplied., SQL STATE: 42000, NATIVE ERROR: 201 (0xC9)"

Surely I did something wrong, maybe someone could guide me.

[Agridulce.]

Thanks, I resolved it.
But, I actually had these problems when I wanted to fix error on my own.
I can not still solve it and the script of that post is incorrect.

appeared after using the fix. No one else had that problem?

[Agridulce.]

I edited the proc "usp_Read_Chars_PointLog_R" in this way:

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_Chars_PointLog_R] Script Date: 08/11/2016 00:02:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


ALTER Proc [dbo].[usp_Read_Chars_PointLog_R]

@D int
--@UseType tinyint

AS

SET NOCOUNT ON

SELECT UseType,UserUID,UsePoint,ProductCode,RemainPoint,O rderNumber,
DATEPART(yyyy, UseDate) AS MakeTime_YYYY,
DATEPART(mm, UseDate) AS MakeTime_MM,
DATEPART(dd, UseDate) AS MakeTime_DD,
DATEPART(hh, UseDate) AS MakeTime_HH,
DATEPART(mi, UseDate) AS MakeTime_MI,
DATEPART(ss, UseDate) AS MakeTime_SS

FROM PointLog

WHERE CharID @D

SELECT TOP 10 ProductCode, UseDate, UsePoint FROM PointLog WITH (READUNCOMMITTED) WHERE CharID @D
ORDER BY UseDate desc

SET NOCOUNT OFF

I will no longer get the above error but I get this one:
"[ODBC SQL Server Driver]Invalid cursor state, SQL STATE: 24000, NATIVE ERROR: 0 (0x0)
2016-08-11 00:10:36 ::LoadCharacter 1924 holi qerr=-1, EXEC usp_Read_Chars_PointLog_R 1924"

I greatly appreciate any help.

[Agridulce.]

In case someone else has this problem, I solved it by adding

DATEPART(yyyy, UseDate) AS MakeTime_YYYY,
DATEPART(mm, UseDate) AS MakeTime_MM,
DATEPART(dd, UseDate) AS MakeTime_DD,
DATEPART(hh, UseDate) AS MakeTime_HH,
DATEPART(mi, UseDate) AS MakeTime_MI,
DATEPART(ss, UseDate) AS MakeTime_SS

in the PointLog_R proc and change the variable "@UseDate" from datetime to varchar(10) in the script given by shen1l.

[balongskie123]

I got dc after i buy this is my log

 Spoiler

2017-02-26 02:01:12 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2017-02-26 02:01:15 ### Connect[7864] : Game[?][0x00E1EB30], Addr=127.0.0.1, DBJobEnd=1

2017-02-26 02:01:15 ### DB_SYSTEM_CONNECT[6152] :Game[1][0x00E1EB30], Name=Game01, Addr=127.0.0.1

2017-02-26 02:02:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Save_User_BuyPointItems2'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)

2017-02-26 02:02:13 SaveBuyPointItem 7 adb qerr=-1, {?=call usp_Save_User_BuyPointItems2(1,7,2499,'PK_0002','2 017-02-26 02:02:13')}

2017-02-26 02:03:30 1 1 SAgent:isconnect: (4, 64)

this is what i think my problem is. I got an issue for "name already in use" so i use this code to fix it.

DBCC DBReIndex ('PS_GameData.dbo.Chars')

do you think that this might be the problem if not then what is it? i give thanks to the person with a greatful heart

[davidinus]

Originally Posted by sominus

The one posted in the forums as 'Ep 5.4 by Stinka' (had to fix some Procs in the db first)

What procs did you fixed to make the item mall to show the points ?