Nanus FlyFF

[wataru]

senpai Ketchup how can i fix this error

uspShopCloseLog '1623650400', '0000784', '120,20888,0,0,,1,0,4500000,0,0,0,1478081199,0,0,0,0,0,-1/133,20851,0,0,,1,0,4500000,0,0,0,1606287753,10,0,0,0,0,-1/175,21039,0,0,,1,0,-1,0,0,0,-584165127,0,0,0,0,0,-1/126,20367,0,0,,1,0,7200000,0,0,0,607051666,0,0,0,0,0,-1/11,31295,0,0,,567,0,-1,0,0,0,158790816,0,0,0,0,0,-1/115,20367,0,0,,1,0,7200000,0,0,0,92347328,0,0,0,0,0,-1/127,41381,0,0,,1,0,3600000,0,0,0,-1951868812,0,0,0,0,0,-1/17,20844,0,0,,1,0,4050000,0,0,0,872112100,0,0,0,0,0,-1/23,44540,0,0,,1,0,3600000,0,0,0,-1814917058,0,0,0,0,0,-1/137,20860,0,0,,1,0,4050000,0,0,0,670342546,0,0,0,0,0,-1/59,41381,0,0,,1,0,3600000,0,0,0,471449694,0,0,0,0,0,-1/134,20855,0,0,,1,0,4500000,0,0,0,-1302600110,0,0,0,0,0,-1/105,41382,0,0,,1,0,3600000,0,0,0,967800406,0,0,0,0,0,-1/86,20884,0,0,,1,0,4500000,0,0,0,1954823304,0,0,0,0,0,-1/61,20835,0,0,,1,0,4500000,0,0,0,-816370730,0,0,0,0,0,-1/102,20884,0,0,,1,0,4500000,0,0,0,427664178,0,0,0,0,0,-1/121,70146,0,0,,1,0,50000,0,0,0,-141718765,0,0,0,0,0,-1/114,20890,0,0,,1,0,4050000,0,0,0,-2141923196,0,0,0,0,0,-1/60,30943,0,0,,1,0,-1,0,0,0,303677447,0,0,0,0,0,-1/94,20883,0,0,,1,0,4500000,0,0,0,1230187814,0,0,0,0,0,-1/$', '0/0/1,0,5,0,1500,99,1,3,5,7,9,/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$', '0,0,0,0/0,0,1387530968765827328,0/0,0,5293231833856,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,1351449600357827328,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/0,0,0,0/$', '$'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'uspShopCloseLog'.

[Ketchup]

USE [CHARACTER_01_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblShopCloseLog](
	[tmTime] [int] NULL,
	[idPlayer] [char](7) NULL,
	[szItem] [varchar](max) NULL,
	[szPet] [varchar](max) NULL,
	[szExt] [varchar](max) NULL,
	[szPiercing] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

USE [CHARACTER_01_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[uspShopCloseLog]
		@itmTime		int,
		@iidPlayer		char(7),
		@iszItem		varchar(MAX),
		@iszPet			varchar(MAX),
		@iszExt			varchar(MAX),
		@iszPiercing	varchar(MAX)
AS
SET NOCOUNT ON

	INSERT INTO [dbo].[tblShopCloseLog]
		([tmTime]
			,[idPlayer]
           ,[szItem]
           ,[szPet]
           ,[szExt]
           ,[szPiercing])
	VALUES
		(@itmTime
			,@iidPlayer
		   ,@iszItem
		   ,@iszPet
		   ,@iszExt
		   ,@iszPiercing)
SET NOCOUNT OFF

GO

[wataru]

USE [CHARACTER_01_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblShopCloseLog](
	[tmTime] [int] NULL,
	[idPlayer] [char](7) NULL,
	[szItem] [varchar](max) NULL,
	[szPet] [varchar](max) NULL,
	[szExt] [varchar](max) NULL,
	[szPiercing] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

USE [CHARACTER_01_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[uspShopCloseLog]
		@itmTime		int,
		@iidPlayer		char(7),
		@iszItem		varchar(MAX),
		@iszPet			varchar(MAX),
		@iszExt			varchar(MAX),
		@iszPiercing	varchar(MAX)
AS
SET NOCOUNT ON

	INSERT INTO [dbo].[tblShopCloseLog]
		([tmTime]
			,[idPlayer]
           ,[szItem]
           ,[szPet]
           ,[szExt]
           ,[szPiercing])
	VALUES
		(@itmTime
			,@iidPlayer
		   ,@iszItem
		   ,@iszPet
		   ,@iszExt
		   ,@iszPiercing)
SET NOCOUNT OFF

GO

thank you senpai

- - - Updated - - -

Msg 102, Level 15, State 1, Line 10
Incorrect syntax near 'NUSE'.

i got this error senpai

- - - Updated - - -

and senpai i found a bug on this files when the red chips is being LOCK by ITEMLOCK and when you buy RED PERIN the red chip will not consume or remove

[kikolindo]

i'm testing this server and when I compile the solution it gices sucess but the .exe files are not created, or they don't appear in the output folder

[Ketchup]

thank you senpai

- - - Updated - - -



i got this error senpai

- - - Updated - - -

and senpai i found a bug on this files when the red chips is being LOCK by ITEMLOCK and when you buy RED PERIN the red chip will not consume or remove

Should hire a dev then if you cannot figure out all these problems.

i'm testing this server and when I compile the solution it gices sucess but the .exe files are not created, or they don't appear in the output folder

Change the output directory?

[wataru]

i'm testing this server and when I compile the solution it gices sucess but the .exe files are not created, or they don't appear in the output folder

go to download and find NANUS folder

[kikolindo]

I could find it, it's going to my local disk c:

another question i can't find the gmlogin.ini file, i created one but apparently it doesn't work, what do i put inside the file? or can you pass me what's in it for me to see


other bug

when I click 'z' teleport and click upresia or sanpress the client closes

[Sponglogix]

I could find it, it's going to my local disk c:

another question i can't find the gmlogin.ini file, i created one but apparently it doesn't work, what do i put inside the file? or can you pass me what's in it for me to see


other bug

when I click 'z' teleport and click upresia or sanpress the client closes

check crash log in client. :) should give you the answer i believe.

[deltadroop]

I'm using Visual Studio 2017, does anyone know how to fix this error?

https://ibb.co/QkyLgsx

[Ketchup]

I'm using Visual Studio 2017, does anyone know how to fix this error?

https://ibb.co/QkyLgsx

Visual Studio 2019: Build All
Visual Studio 2017 & Lower: Batch Build with Rebuild All

[anonymouslyme]

Link for sql management studio and sql server please
I dont know what specific version to use. I now have VS 2019. Only SQL left

[Ketchup]

Link for sql management studio and sql server please
I dont know what specific version to use. I now have VS 2019. Only SQL left

Step 2 - https://forum.ragezone.com/f724/setu...files-1192396/

[deltadroop]

Good morning community, I'm going to release these files, does it have a lot of bugs? Am I being brave?

Does anyone know how to change this sign? :dormir:
https://ibb.co/Yk0K6DP

[lukamodrid1]

Good morning community, I'm going to release these files, does it have a lot of bugs? Am I being brave?

Does anyone know how to change this sign? :dormir:
https://ibb.co/Yk0K6DP

You change the text in Announce.inc

[naxzy]

Good morning community, I'm going to release these files, does it have a lot of bugs? Am I being brave?

Does anyone know how to change this sign? :dormir:
https://ibb.co/Yk0K6DP

I recommend not using these files for a public release. Use them to snippet systems and add to Clean files. I recommend using Ketchups VS19v18 as base source. There is multiple exploits in these files witch is going to ruin your server really fast. Example: Sql injection via Equipment switcher where a player can move around on chars, fill his inventory with perins and much much more. so no. Dont release anything with these files.