Sell ​​AP npc exploit

[IlusionXtreme]

x

[edsonne2020]

[Mike__]

my suggestion is to change the actiontype to when item is used, then put cooldown on these items.

better yet, create a webmall and put those items there, that is what i did in mine.
(they cannot purchase when they are online)

hope it helps.

[[ADMIN]Phreak]

Originally Posted by IlusionXtreme

..

Can people buy AP cards from NPC?

[Mike__]

I see, as mentioned, i never had this issue because i have mine in our Webmall.

I suggest that you remove it in your IM first before your server is wrecked.

[joins.dj]

el problema es causado al tener

ticket de AP. en su item all. del mismo valor

una solucion es si tiene agregada la funcion de comandos atraves de sql.

y contar las veces que compra y vende items.

si son demaciadas genere un kick. o ban al usuario. atraves de sql.

como se genera el error.

usando un mouse recoder. y teniendo una cantidad X de puntos en item

y se repite la accion de comprar y vender x cantidad de veces.

[ShaiyaDead]

that bug did not came from the AP system its from your item mall if you have 11x DC issue on the server then that thing exist

[nick4ever]

Try to set item count in item mall to 1, and ensure that there is no free item in item mall.

Hope this helps.

[sominus]

Someone could be using a python script to do the buy/sell thing many times per second or a mouse recorder as Joins said.
So, remove any free item and the AP cards from the ItemMall.

[[-Silomatx]]

You might as well consider using a WAITFOR command in your sql script. This way the AP will be updated after, let's say, 1 minute (or 30 seconds).
But I personally did not come across this issue, so I do not know the exact problem with it. But I'm guessing this exploit is possible due to fast transactions, therefore WAITFOR will slow this whole process down and might fix this issue?

Edit: I always thought you have to relog to get the AP refreshed in your item mall? Am I outdated on this?

[SnickQ]

Create table for SP point. Then add to 114 instead Users Master to table let name it "point" Then add to 108 actiontype update users_master point from "point" table after update remove from point.
I hope you understand what i mean. :P

[SnickQ]

Like that:

USE [PS_UserData]
GO

/****** Object: Table [dbo].[Users_Point] Script Date: 07/24/2019 23:04:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Users_Point](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[UserUID] [int] NOT NULL,
[Point] [int] NOT NULL
) ON [PRIMARY]

GO

IF ( @ActionType = 114 )
BEGIN
IF @itemID = 100180) -- guess is your AP sell item
BEGIN

if not exists (Select * from PS_UserData.dbo.Users_Point where UserUID =@UserUID)
insert into PS_UserData.dbo.Users_Point (UserUID, Point) values (@UserUID, @vaLue4)
else
update PS_UserData.dbo.Users_Point
SET Point = (Point + @vaLue4) --@value4 guess is your AP point
WHERE UserUID = @UserUID
end
END

IF ( @ActionType = 108 )
BEGIN
if exists (Select * from PS_UserData.dbo.Users_Point where UserUID =@UserUID)
begin
update PS_UserData.dbo.Users_Master
Set Point = Point + (select Point from PS_UserData.dbo.Users_Point where UserUID=@UserUID)
WHERE UserUID = @UserUID

delete from PS_UserData.dbo.Users_Point where UserUID=@UserUID

end

After that your sell AP will be updated only after relog