Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Dreamer FlyFF (Src+ Resource)

Cyclopz

Cyclopz

Newbie Spellweaver
Joined
Sep 27, 2020
Messages
39
Reaction score
21
Another free release being sold by multiple people and now it's here to stay.
This files was originally made by Flyff Guru and adapted by Dhel Tampas then he start reselling this from 300 Euro to 600 Euro

This Source Contain Battlepass System / Temporal GS & Many More .
But i dont have the database for this .

Server Files :
You must be registered to see links
 
Last edited:
The Best DDoS Protected Servers
Mynameislim

Mynameislim

Newbie Spellweaver
Joined
May 6, 2013
Messages
21
Reaction score
0
Anyone working on database for this server?
Or have anyone run this server successfully?


Btw what is temporal system?
 
Sand

Sand

Newbie Spellweaver
Joined
Sep 7, 2021
Messages
33
Reaction score
7
Mynameislim said:
Anyone working on database for this server?
Or have anyone run this server successfully?


Btw what is temporal system?
Click to expand...
as mentioned previously in the thread by Lukamodrid, a database can easily be made by examining the functions and edits made by the custom systems and some edits with basic sql.
 
F

forceedge11

Newbie Spellweaver
Joined
Jun 15, 2014
Messages
20
Reaction score
2
Short story about the server:

I played for almost 3 months in this server. The community is good, but the devs and admins are somewhat greedy. I remember having those feature "Temporal System." He was selling it on other devs like its his own creation. The dev/owner opened real-money trading (RMT) in the community but when players don't donate anymore, they wanted a % of the money you can sell your items with. They revamped the server like twice but still many players only tend to play if they're bored. Finally, when things went south, because the server receives zero donation for the past 2 months of the so-called "server revamp", the server shuts down. There were an issue within the Philippines FlyFF Community devs that "someone" is selling sources to multiple devs and owner. Now they re-opened another server which is called "FlyFF University." The owner is different, but still Dhel is still the developer. I played on it once and I can easily spot the very same features from their "DreamerFlyFF" files.

Temporal System:

Free-for-all = When you enter free-for-all instance, all players are on fixed Level 130, with fixed items for players to fight inside the arena. It's basically an "experience" when you don't have the end-gear in the normal game. You can choose any class you want to fight players. (Seraph are OP due to their reflect damage)

Temporal Dungeon = You can enter a dungeon to kill the Red Clockworks (which has billions of HP) with, just like on free-for-all, a fixed level and item set with the ability to choose any class as well.
 
L

Lodelight

Inactive
Joined
Jan 20, 2009
Messages
1,014
Reaction score
1,830
forceedge11 said:
There were an issue within the Philippines FlyFF Community devs that "someone" is selling sources to multiple devs and owner.
Click to expand...

There is way more then just 1 person in the Flyff Filipino community doing this and it's been going on for 6 - 7+ years now lol.
 
Tratox

Tratox

Junior Spellweaver
Joined
Feb 27, 2021
Messages
106
Reaction score
9
Cyclopz said:
Another free release being sold by multiple people and now it's here to stay.
This files was originally made by Flyff Guru and adapted by Dhel Tampas then he start reselling this from 300 Euro to 600 Euro

This Source Contain Battlepass System / Temporal GS & Many More .
But i dont have the database for this .

Version Common :
You must be registered to see links
You must be registered to see links

Server Files :
You must be registered to see links
Click to expand...

thank you but how do we start it the database, the client, the worlds etc, we can have them or not, and for start server etc
 
Sand

Sand

Newbie Spellweaver
Joined
Sep 7, 2021
Messages
33
Reaction score
7
Tratox said:
thank you but how do we start it the database, the client, the worlds etc, we can have them or not, and for start server etc
Click to expand...

It has source and resource. Client can be made from that - all other custom images and such could probably be in one of the decrypted flyff clients, otherwise you can make your own. And then for items with missing assets you can just remove.

And as mentioned by myself and another, you can remake the Database by browsing changes in the Dbmanagersave, dbmanagerjoin, and dbmanager files in the database as they contain the logic for setting data from the mssql instance.
 
Cyclopz

Cyclopz

Newbie Spellweaver
Joined
Sep 27, 2020
Messages
39
Reaction score
21
I got multiple message that someone offering the database of Dreamer for 100 - 200 euro . so i want to tell everyone that the database can be easy to remake and dont buy on scammer .
 
Fenris

Fenris

Newbie Spellweaver
Joined
Sep 8, 2011
Messages
67
Reaction score
252
Cyclopz said:
I got multiple message that someone offering the database of Dreamer for 100 - 200 euro. so i want to tell everyone that the database can be easy to remake and don't buy on scammer.
Click to expand...

True. The source contains all the information to add any of the database entries.

Code: 
    sprintf(szQuery, "uspTemporalPresetsSave %d, %d, %d, '%s', '%s', '%s', '%s', '%s', '%s'",
        dwWorldID, dwSex, nJob, icsInventory.szItem, icsInventory.szPet, icsInventory.szExt, icsInventory.szPiercing, icsInventory.szIndex, icsInventory.szObjIndex)

Code: 
        DWORD       dwWorldID = (DWORD)pQueryChar->GetInt("dwWorldID");
        DWORD       dwSex = (DWORD)pQueryChar->GetInt("dwSex");
        DWORD       dwJob = (DWORD)pQueryChar->GetInt("dwJob");

        ItemContainerStruct icsInventory;
        pQueryChar->GetStr("szItem", icsInventory.szItem);
        pQueryChar->GetStr("szExt", icsInventory.szExt);
        pQueryChar->GetStr("szPet", icsInventory.szPet);
        pQueryChar->GetStr("szPiercing", icsInventory.szPiercing);
        pQueryChar->GetStr("szIndex", icsInventory.szIndex);
        pQueryChar->GetStr("szObjIndex", icsInventory.szObjIndex);

That's all the information you need to remake the Temporal database (well minus the 'get' stored procedure's name).
.
 
L

Lodelight

Inactive
Joined
Jan 20, 2009
Messages
1,014
Reaction score
1,830
If someone is kind enough to release the Temporal database then I will be kind and release the Battlepass database.
 
Tratox

Tratox

Junior Spellweaver
Joined
Feb 27, 2021
Messages
106
Reaction score
9
Hi, good tell for this base, but no DB ? Can you upload it pls ? Complete with battle pass, and full client if is possible, beacause i have take k18.3 theme etc, but my neuz doesn't start, no log error. And DatabaseServer.exe not starting, no error
 
Last edited:
L

luisfo

Newbie Spellweaver
10 Happy Years
Joined
Oct 28, 2008
Messages
33
Reaction score
3
Ketchup said:
If someone is kind enough to release the Temporal database then I will be kind and release the Battlepass database.
Click to expand...

Here we go. duck the PH "Devs"

PHP: 
USE [CHARACTER_01_DBF]
GO

/****** Object:  Table [dbo].[tblTemporalPresets]    Script Date: 8/16/2022 8:27:12 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblTemporalPresets](
	[dwWorldID] [int] NULL,
	[dwSex] [int] NULL,
	[dwJob] [int] NULL,
	[szItem] [varchar](max) NULL,
	[szPet] [varchar](max) NULL,
	[szExt] [varchar](max) NULL,
	[szPiercing] [varchar](max) NULL,
	[szIndex] [varchar](2500) NULL,
	[szObjIndex] [varchar](2500) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

PHP: 
USE [CHARACTER_01_DBF]
GO

/****** Object:  StoredProcedure [dbo].[uspTemporalPresetsGet]    Script Date: 8/16/2022 8:28:00 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO








CREATE PROCEDURE [dbo].[uspTemporalPresetsGet]
AS
SET NOCOUNT ON

	SELECT a.[dwWorldID]
		  ,a.[dwSex]
		  ,a.[dwJob]
		  ,a.[szItem]
		  ,a.[szPet]
		  ,a.[szExt]
		  ,a.[szPiercing]
		  ,a.[szIndex]
		  ,a.[szObjIndex]
		FROM tblTemporalPresets a

SET NOCOUNT OFF




GO

PHP: 
USE [CHARACTER_01_DBF]
GO

/****** Object:  StoredProcedure [dbo].[uspTemporalPresetsSave]    Script Date: 8/16/2022 8:28:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[uspTemporalPresetsSave]
	 [USER=521885]iworld[/USER]ID int,
		@iSex int,
		@iJob int,
		@iszItem		varchar(MAX),
		@iszPet			varchar(MAX),
		@iszExt			varchar(MAX),
		@iszPiercing	varchar(MAX),
		@iszIndex		varchar(2500),
		@iszObjIndex	varchar(2500)
AS
SET NOCOUNT ON

	IF NOT EXISTS ( SELECT * FROM [dbo].[tblTemporalPresets] WHERE dwWorldID = [USER=521885]iworld[/USER]ID AND dwSex = @iSex AND dwJob = @iJob)
		BEGIN 
			INSERT INTO [dbo].[tblTemporalPresets]
				([dwWorldID],
				[dwSex],
				[dwJob],
				[szItem],
				[szPet],
				[szExt],
				[szPiercing],
				[szIndex],
				[szObjIndex])
			VALUES
				 [USER=521885]iworld[/USER]ID,
				@iSex,
				@iJob,
				@iszItem,
				@iszPet,
				@iszExt,
				@iszPiercing,
				@iszIndex,
				@iszObjIndex)			
		END
	ELSE
		BEGIN
			UPDATE [dbo].[tblTemporalPresets]
				SET dwWorldID = [USER=521885]iworld[/USER]ID,
					dwSex = @iSex,
					dwJob = @iJob,
					szItem = @iszItem,			
					szPet = @iszPet,
					szExt = @iszExt,
					szPiercing = @iszPiercing,
					szIndex = @iszIndex,
					szObjIndex = @iszObjIndex
				WHERE dwWorldID = [USER=521885]iworld[/USER]ID AND dwSex = @iSex AND dwJob = @iJob
		END

SET NOCOUNT OFF

GO
 
Cyclopz

Cyclopz

Newbie Spellweaver
Joined
Sep 27, 2020
Messages
39
Reaction score
21
Ketchup said:
If someone is kind enough to release the Temporal database then I will be kind and release the Battlepass database.
Click to expand...


Battlepass Database .

Code: 
USE [CHARACTER_01_DBF]
GO

UPDATE [dbo].[CHARACTER_TBL]
      ,[m_nBPLevel] = <m_nBPLevel, int,>
      ,[m_nBPPoints] = <m_nBPPoints, int,>
      ,[m_nBPType] = <m_nBPType, int,>
      ,[m_nBPEnable] = <m_nBPEnable, int,>
      ,[m_szBPEndTime] = <m_szBPEndTime, varchar(13),>       
WHERE <Search Conditions,,>
GO

USE [CHARACTER_01_DBF].[CHARACTER_STR]

, @im_nBPLevel int = 0
, @im_nBPPoints int = 0
, @im_nBPType int = 0
, @im_nBPEnable int = 0
, @im_szBPEndTime varchar(13) = 20120202
    
    
, A.m_nBPLevel
, A.m_nBPPoints
, A.m_nBPType
, A.m_nBPEnable
, A.m_szBPEndTime

, m_nBPLevel =  @im_nBPLevel
, m_nBPPoints = @im_nBPPoints
, m_nBPType    = @im_nBPType
, m_nBPEnable = @im_nBPEnable
, m_szBPEndTime = @im_szBPEndTime
                        
, m_nBPLevel
, m_nBPPoints
, m_nBPType
, m_nBPEnable
, m_szBPEndTime
                                
-- Battle Pass
, 0
, 0
, 0
, 0
, 20120202
 
D

demolisher752

Newbie Spellweaver
Joined
Feb 10, 2022
Messages
11
Reaction score
0
Hi thanks for this, but it seems like I'm getting errors executing this query in SSMS. Database also crashes on world login


Edit: Im talking about the Battlepass DB entry that Cyclopz sent
 
Cyclopz

Cyclopz

Newbie Spellweaver
Joined
Sep 27, 2020
Messages
39
Reaction score
21
demolisher752 said:
Hi thanks for this, but it seems like I'm getting errors executing this query in SSMS. Database also crashes on world login


Edit: Im talking about the Battlepass DB entry that Cyclopz sent
Click to expand...

You need to put the database manually .
 
D

demolisher752

Newbie Spellweaver
Joined
Feb 10, 2022
Messages
11
Reaction score
0
Cyclopz said:
You need to put the database manually .
Click to expand...

I appreciate the response! But could you be a little more specific? All I did was create a new query on CHARACTER_01_DBF and executed the code. Apologies as I'm not that knowledgeable with SQL yet. Thank you!
 
Fenris

Fenris

Newbie Spellweaver
Joined
Sep 8, 2011
Messages
67
Reaction score
252
demolisher752 said:
I appreciate the response! But could you be a little more specific? All I did was create a new query on CHARACTER_01_DBF and executed the code. Apologies as I'm not that knowledgeable with SQL yet. Thank you!
Click to expand...
It's because what was shared wasn't a query. Just a base outline of what is required.


Add these to character_tbl either by editing the db table through design or using a query.
Code: 
m_nBPLevel  int
m_nBPPoints int
m_nBPType int
m_nBPEnable int,
m_szBPEndTime varchar(13)


Essentially, different stuff is ran based on iGu.
Variables that get added to character_str
Code: 
, @im_nBPLevel int = 0
, @im_nBPPoints int = 0
, @im_nBPType int = 0
, @im_nBPEnable int = 0
, @im_szBPEndTime varchar(13) = 20120202

iGu = S8
Code: 
, A.m_nBPLevel
, A.m_nBPPoints
, A.m_nBPType
, A.m_nBPEnable
, A.m_szBPEndTime

iGu = U1
Code: 
, m_nBPLevel =  @im_nBPLevel
, m_nBPPoints = @im_nBPPoints
, m_nBPType    = @im_nBPType
, m_nBPEnable = @im_nBPEnable
, m_szBPEndTime = @im_szBPEndTime

iGu = I1
Code: 
-- within INSERT CHARACTER_TBL at the bottom after idcampus or w/e if you have db edits
, m_nBPLevel
, m_nBPPoints
, m_nBPType
, m_nBPEnable
, m_szBPEndTime
Code: 
-- in the values that get inserted in to the character_tbl by default
-- Battle Pass
, 0
, 0
, 0
, 0
, 20120202
 
D

demolisher752

Newbie Spellweaver
Joined
Feb 10, 2022
Messages
11
Reaction score
0
Fenris said:
It's because what was shared wasn't a query. Just a base outline of what is required.


Add these to character_tbl either by editing the db table through design or using a query.
Code: 
m_nBPLevel  int
m_nBPPoints int
m_nBPType int
m_nBPEnable int,
m_szBPEndTime varchar(13)


Essentially, different stuff is ran based on iGu.
Variables that get added to character_str
Code: 
, @im_nBPLevel int = 0
, @im_nBPPoints int = 0
, @im_nBPType int = 0
, @im_nBPEnable int = 0
, @im_szBPEndTime varchar(13) = 20120202

iGu = S8
Code: 
, A.m_nBPLevel
, A.m_nBPPoints
, A.m_nBPType
, A.m_nBPEnable
, A.m_szBPEndTime

iGu = U1
Code: 
, m_nBPLevel =  @im_nBPLevel
, m_nBPPoints = @im_nBPPoints
, m_nBPType    = @im_nBPType
, m_nBPEnable = @im_nBPEnable
, m_szBPEndTime = @im_szBPEndTime

iGu = I1
Code: 
-- within INSERT CHARACTER_TBL at the bottom after idcampus or w/e if you have db edits
, m_nBPLevel
, m_nBPPoints
, m_nBPType
, m_nBPEnable
, m_szBPEndTime
Code: 
-- in the values that get inserted in to the character_tbl by default
-- Battle Pass
, 0
, 0
, 0
, 0
, 20120202
Click to expand...

Ah it makes sense now. Thanks both of you, appreciate the detailed explanation. Cheers
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
215
Guests online
6,819
Total visitors
7,034
Totals may include hidden visitors.

Forum statistics

Threads
429,073
Messages
4,590,159
Members
280,569
Latest member
Kalison
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top