Sell ​​AP npc exploit

x

[Only registered and activated users can see links. Click Here To Register...]

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.

Quote:

Originally Posted by IlusionXtreme ..

Can people buy AP cards from NPC?

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.

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.

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

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

Hope this helps.

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.

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?

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

Like that:

Quote:

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

Quote:

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