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!

Have a question about "EP7v1/Neo" ? Ask it here!

StoP Callin me MentaL
Loyal Member
Joined
Dec 26, 2008
Messages
3,228
Reaction score
1,017
You can ask any Question/Problem base on EP7v1 & Neo Server files here. Solution will be update on 1st Post, Against Rules will Receive Infraction.

Thread Rules:
1. You can only Ask Question about EP7 Gunner.
2. Do not Ask Question about other EP or other Version.
3. Do not Spam or Advertising.
4. Do not ask Question that already been answered.

Q: Connecting to Server (Please Wait) (Neo)
A: Try connect on another PC.

Q: Retrieving data from the Server... (Neo)
A: It just takes too long to retrieve the servers data. mostly happens when your using lower spec.

Q: Vending Crash (Neo)
A: Replace your xml's inside gui with this Edit also your param.ini with "PE" as your language.

Q: No Gunner Class on Character Creation? (Neo)
A: Create a new query in RanGame1 and Execute the script.
PHP:
USE [RanGame1]
GO
/****** Object:  StoredProcedure [dbo].[sp_Extreme]    Script Date: 01/30/2012 21:22:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   PROCEDURE [dbo].[sp_Extreme]
    @nUserNum    int

AS    
    DECLARE
        @error_var int, 
        @rowcount_var int    

    SET NOCOUNT ON

Select 9 As M, 9 As F
From
(
    Select isnull(Sum(M),1) As MSum, isnull(Sum(F),1) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
    From
    (
    Select ChaClass
    ,
    Case ChaClass
    When 1 Then 1
    When 2 Then 1
    When 256 Then 1
    When 512 Then 1
    Else 0
    End As M
    ,
    Case ChaClass
    When 4 Then 1
    When 8 Then 1
    When 64 Then 1
    When 128 Then 1
    Else 0
    End As F
    ,
    Case ChaClass
    When 16 Then 
        Case ChaDeleted
        When 1 Then 0
        Else 1
        End
    Else 0
    End As MS
    ,
    Case ChaClass
    When 32 Then 
        Case ChaDeleted
        When 1 Then 0
        Else 1
        End
    Else 0
    End As FS
    From ChaInfo Where UserNum=@nUserNum And (
    ( ChaClass=16 OR ChaClass=32 ) OR 
    ( ( ChaClass=1 OR ChaClass=2 OR ChaClass=4 OR ChaClass=8 OR 
         ChaClass=64 OR ChaClass=128 OR ChaClass=256 OR ChaClass=512 ) AND ChaLevel>=0 ) )
    ) As t
) As tt

Q: [SQL Server]Invalid object name 'PhindoGame.dbo.ChaInfo' (Neo)
A: Open RanGame1 expand to chainfo, modify your table, PhindoGame, about Type just put Int, for Temp NULL then Save.

Q: Decrypt and Encrypt EP7 Gunner Server Files (Neo)
A: http://forum.ragezone.com/f444/decrypt-encrypt-ep7-files-812156/

Q: [SQL Server]Invalid column name 'PetSkinMID'
A: Create a new query in RanGame1 and Execute the script.
PHP:
USE [RanGame1]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetName]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetName]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetChaNum]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetChaNum]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetType]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetType]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetStyle]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetStyle]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetColor]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetColor]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetFull]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetFull]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeleted]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeleted]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCreateDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCreateDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetDeletedDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetDeletedDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetPutOnItems]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetPutOnItems]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardMID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetCardSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetCardSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinStartDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinStartDate]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinTime]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinTime]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinScale]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinScale]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinSID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinSID]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_PetInfo_PetSkinMID]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[PetInfo] DROP CONSTRAINT [DF_PetInfo_PetSkinMID]
END

GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PetInfo]') AND type in (N'U'))
DROP TABLE [dbo].[PetInfo]
GO

USE [RanGame1]
GO

/****** Object: Table [dbo].[PetInfo] Script Date: 08/08/2011 11:50:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PetInfo](
[PetNum] [int] NOT NULL,
[PetName] [varchar](20) NOT NULL,
[PetChaNum] [int] NOT NULL,
[PetType] [int] NOT NULL,
[PetMID] [int] NOT NULL,
[PetSID] [int] NOT NULL,
[PetStyle] [int] NOT NULL,
[PetColor] [int] NOT NULL,
[PetFull] [int] NOT NULL,
[PetDeleted] [int] NOT NULL,
[PetCreateDate] [datetime] NOT NULL,
[PetDeletedDate] [datetime] NOT NULL,
[PetPutOnItems] [image] NOT NULL,
[PetCardMID] [int] NOT NULL,
[PetCardSID] [int] NOT NULL,
[PetUniqueNum] [int] IDENTITY(1,1) NOT NULL,
[PetSkinStartDate] [datetime] NULL,
[PetSkinTime] [datetime] NULL,
[PetSkinScale] [int] NULL,
[PetSkinSID] [int] NULL,
[PetSkinMID] [int] NULL,
CONSTRAINT [PK_PetInfo] PRIMARY KEY CLUSTERED 
(
[PetUniqueNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [SECONDARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetNum] DEFAULT ((0)) FOR [PetNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetName] DEFAULT ('') FOR [PetName]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetChaNum] DEFAULT ((0)) FOR [PetChaNum]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetType] DEFAULT ((0)) FOR [PetType]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetMID] DEFAULT ((0)) FOR [PetMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSID] DEFAULT ((0)) FOR [PetSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetStyle] DEFAULT ((0)) FOR [PetStyle]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetColor] DEFAULT ((0)) FOR [PetColor]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetFull] DEFAULT ((1000)) FOR [PetFull]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeleted] DEFAULT ((0)) FOR [PetDeleted]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCreateDate] DEFAULT (getdate()) FOR [PetCreateDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetDeletedDate] DEFAULT (getdate()) FOR [PetDeletedDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetPutOnItems] DEFAULT ('') FOR [PetPutOnItems]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardMID] DEFAULT ((0)) FOR [PetCardMID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetCardSID] DEFAULT ((0)) FOR [PetCardSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinStartDate] DEFAULT (getdate()) FOR [PetSkinStartDate]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinTime] DEFAULT (getdate()) FOR [PetSkinTime]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinScale] DEFAULT ((0)) FOR [PetSkinScale]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinSID] DEFAULT ((0)) FOR [PetSkinSID]
GO

ALTER TABLE [dbo].[PetInfo] ADD CONSTRAINT [DF_PetInfo_PetSkinMID] DEFAULT ((0)) FOR [PetSkinMID]
GO

Q: How to edit Item / Mob / Skill (Neo)
A:
Decrypt Crow.mnsf / Item.isf / Skill.ssf with CryptionRCC
Decrypt CrowStrTable.txt / ItemStrTable.txt / SkillStrTable.txt with CryptionRCC

Re-Encrypt the TXT files with EP7 V1 REditor.

Open the MNSF / ISF / SSF with the editor.

and then, do what you need to edit.

Lastly,
Re-encrypt the updated TXT files with NEO REditor
then,
Encrypt the updated files with CryptionRCC

Q: Why something about CHF / CPS is popping out while I'm loading the mnsf / isf to the editor?
A: You need to extract the skinobject.rcc first to data\skinobject for the editor to load properly.

Q: I extracted the skinobject.rcc already but the pop up persist.
A: Ignore the error. Just press OK

Q: I can buy items at the item shop. And then when I try to get it from the Item Bank, can't move it to the inventory. It's stuck!
A:
USE [RanShop]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurPrice]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurPrice]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurFlag]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurFlag]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurDate]
END

GO

USE [RanShop]
GO

/****** Object: Table [dbo].[ShopPurchase] Script Date: 05/20/2010 19:17:31 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShopPurchase]') AND type in (N'U'))
DROP TABLE [dbo].[ShopPurchase]
GO

USE [RanShop]
GO

/****** Object: Table [dbo].[ShopPurchase] Script Date: 05/20/2010 19:17:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ShopPurchase](
[PurKey] [varchar](21) NOT NULL,
[UserUID] [varchar](20) NOT NULL,
[ProductNum] [int] NOT NULL,
[PurPrice] [int] NOT NULL,
[PurFlag] [int] NOT NULL,
[PurDate] [datetime] NOT NULL,
[PurChgDate] [datetime] NULL,
CONSTRAINT [PK_ShopPurchase] PRIMARY KEY CLUSTERED
(
[PurKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurPrice] DEFAULT ((0)) FOR [PurPrice]
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurFlag] DEFAULT ((0)) FOR [PurFlag]
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurDate] DEFAULT (getdate()) FOR [PurDate]
GO
 
Last edited:
Custom Title Activated
Loyal Member
Joined
Jun 16, 2009
Messages
1,146
Reaction score
258
Re: Have a question about "EP7v1/Neo" ? Ask it here !

mobeditor for gunner or ep7 edition is already been shared,
 
Upvote 0
Custom Title Activated
Loyal Member
Joined
Jun 16, 2009
Messages
1,146
Reaction score
258
Re: Have a question about "EP7v1/Neo" ? Ask it here !

extract all files inside skinobject.rcc to your skinobject folder.
 
Upvote 0
Banned
Banned
Joined
Feb 6, 2011
Messages
545
Reaction score
291
Re: Have a question about "EP7v1/Neo" ? Ask it here !

Copy and paste your animation folder into editor data folder...
 
Upvote 0
Good to be back.
Joined
Feb 1, 2009
Messages
631
Reaction score
59
Re: Have a question about "EP7v1/Neo" ? Ask it here !

i get an npc_sc_teacher.chf and failure to load file in mobnpceditor :) already decrypted all but still the same error :)
 
Upvote 0
Joined
Sep 5, 2010
Messages
471
Reaction score
17
Re: Have a question about "EP7v1/Neo" ? Ask it here !

I still have that error, i already extract the animation and the skinobject but still error all chf files.

i get an npc_sc_teacher.chf and failure to load file in mobnpceditor :) already decrypted all but still the same error :)

yeah, i follow all guide the fail no luck to edit crow
 
Upvote 0
Graveyard Networks
Joined
Dec 19, 2005
Messages
472
Reaction score
264
Re: Have a question about "EP7v1/Neo" ? Ask it here !

I will be watching this thread, make sure to post your problems here and not request a file. If you people doesnt like to be corrected be smart enough to know what you are posting and the ruling of this section.

Good luck
 
Upvote 0
Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Re: Have a question about "EP7v1/Neo" ? Ask it here !

Q: How to edit Item / Mob / Skill on EP7 Neo Version

HOW TO USE RAN EDITORS OF EP7V1 to NEO VERSION (Item , Skill, Mob)

Requirements:
Editors (of course)
EP7V1 Reditor
Neo Reditor
CryptionRCC
Common Sense* (teh most important thing)

Guide:
Decrypt Crow.mnsf / Item.isf / Skill.ssf with CryptionRCC
Decrypt CrowStrTable.txt / ItemStrTable.txt / SkillStrTable.txt with CryptionRCC

Re-Encrypt the TXT files with EP7 V1 REditor.

Open the MNSF / ISF / SSF with the editor.

and then, do what you need to edit.

Lastly,
Re-encrypt the updated TXT files with NEO REditor
then,
Encrypt the updated files with CryptionRCC


As simple as that. :D:
 
Upvote 0
Joined
Sep 5, 2010
Messages
471
Reaction score
17
Re: Have a question about "EP7v1/Neo" ? Ask it here !

Q: How to edit Item / Mob / Skill on EP7 Neo Version

HOW TO USE RAN EDITORS OF EP7V1 to NEO VERSION (Item , Skill, Mob)

Requirements:
Editors (of course)
EP7V1 Reditor
Neo Reditor
CryptionRCC
Common Sense* (teh most important thing)

Guide:
Decrypt Crow.mnsf / Item.isf / Skill.ssf with CryptionRCC
Decrypt CrowStrTable.txt / ItemStrTable.txt / SkillStrTable.txt with CryptionRCC

Re-Encrypt the TXT files with EP7 V1 REditor.

Open the MNSF / ISF / SSF with the editor.

and then, do what you need to edit.

Lastly,
Re-encrypt the updated TXT files with NEO REditor
then,
Encrypt the updated files with CryptionRCC


As simple as that. :D:

I try your guide sir but still .chf error come up when i load the crow.mnsf.
 
Upvote 0
Joined
Sep 16, 2007
Messages
1,206
Reaction score
541
Re: Have a question about "EP7v1/Neo" ? Ask it here !

@metal666
that means. you successfully loaded teh crow.mnsf now proceed to this.

Q: Why something about CHF / CPS is popping out while I'm loading the mnsf / isf to the editor?
A: You need to extract the skinobject.rcc first to data\skinobject for the editor to load properly.

Q: I extracted the skinobject.rcc already but the pop up persist.
A: Ignore teh error. Just press OK
 
Upvote 0
Joined
Apr 26, 2009
Messages
928
Reaction score
109
Re: Have a question about "EP7v1/Neo" ? Ask it here !

Seifer has posted all the the fix for you, but why still come up with error, i think you did not done it properly.
 
Upvote 0
Junior Spellweaver
Joined
Oct 2, 2009
Messages
159
Reaction score
2
i have a problem for restoring ep7 database
kindly help me please thanks


I'm Not MentaL - Have a question about "EP7v1/Neo" ? Ask it here! - RaGEZONE Forums
 
Upvote 0
Back
Top