[Request] Roika Flyff Database

Cloud' · 05/21/2018, 08:31

#FIXED

~~Tweeney~~ · 05/21/2018, 11:47

just use v15 database?

Cloud' · 05/21/2018, 19:56

done but still the same. Cannot create character

Flogolo · 05/21/2018, 23:52

why you dont use the aio of sedrika?

Cloud' · 05/22/2018, 05:03

I did. Now im having rollback everytime i restart the server

Flogolo · 05/22/2018, 06:17

Did you use the released db fixes? (e.g. U can find them in GOH Files)

Ecrypter · 05/22/2018, 08:46

remove in the source database folder DManager.cpp Check char database part,
they have include CHECK.CHAR add that in your sql database CHARACTER part

~~Tweeney~~ · 05/23/2018, 09:28

why removing? if you can create a check char database?

Code:

USE [CHARACTER_01_DBF]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[CHECK_CHARS] 
 [MENTION=323619]aCCount[/MENTION] VARCHAR(32) = '',
 [MENTION=792744]Players[/MENTION]lot int = 0
AS
SET NOCOUNT ON
  SELECT * FROM CHARACTER_TBL WHERE account [MENTION=323619]aCCount[/MENTION] AND playerslot = [MENTION=792744]Players[/MENTION]lot AND isblock ='F'
SET NOCOUNT OFF

/* FOR CHARACTER OVERRIDE BUG */
GO