- 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
Q: No Gunner Class on Character Creation? (Neo)
A: Create a new query in RanGame1 and Execute the script.
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.
Q: How to edit Item / Mob / Skill (Neo)
A:
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:
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
You must be registered to see links
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
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
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: