Few issues

07/10/2012 12:52 Dread123#1
Hey guys need help on a few things.

1 im looking for anyone that can upload the mob.csv and mobitems.csv for the ep 6 mobs and stuff. i have the ep5.3 csv but when i extract the files myself i dont get anywere near the same info of the ep5.3 as the ep6 ones i extract.
ive tryed shaiyahavens way i can extract the csv fils but they dont hav any info in it. but the 5.3 version has heaps of stuff in it.


also im trying to work on the item mall and i get n error everytime i try and upload the SQL into the DB and it doesnt work. ANY IDEAS plz.this is the error

[Only registered and activated users can see links. Click Here To Register...]

anyone can tell me how to place the minimaps in the game.exe when i follow the way the other maps are in the game.exe it crashes my game.exe but when i remove them the game.exe works.


any ideas will b great thanks
07/10/2012 15:19 Covea#2
For the Database Issue, try to execute this quiery.

Code:
USE [PS_GameDefs]
GO
/****** Objekt:  Table [dbo].[ProductList]    Skriptdatum: 08/16/2011 09:27:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
DROP TABLE [dbo].[ProductList]
CREATE TABLE [dbo].[ProductList](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[ProductName] [varchar](50) NOT NULL,
	[ProductCode] [varchar](20) NOT NULL,
	[BuyCost] [int] NOT NULL,
	[ItemID1] [int] NOT NULL,
	[ItemCount1] [tinyint] NOT NULL,
	[ItemID2] [int] NULL,
	[ItemCount2] [tinyint] NULL,
	[ItemID3] [int] NULL,
	[ItemCount3] [tinyint] NULL,
	[ItemID4] [int] NULL,
	[ItemCount4] [tinyint] NULL,
	[ItemID5] [int] NULL,
	[ItemCount5] [tinyint] NULL,
	[ItemID6] [int] NULL,
	[ItemCount6] [tinyint] NULL,
	[ItemID7] [int] NULL,
	[ItemCount7] [tinyint] NULL,
	[ItemID8] [int] NULL,
	[ItemCount8] [tinyint] NULL,
	[ItemID9] [int] NULL,
	[ItemCount9] [tinyint] NULL,
	[ItemID10] [int] NULL,
	[ItemCount10] [tinyint] NULL,
	[ItemID11] [int] NULL,
	[ItemCount11] [tinyint] NULL,
	[ItemID12] [int] NULL,
	[ItemCount12] [tinyint] NULL,
	[ItemID13] [int] NULL,
	[ItemCount13] [tinyint] NULL,
	[ItemID14] [int] NULL,
	[ItemCount14] [tinyint] NULL,
	[ItemID15] [int] NULL,
	[ItemCount15] [tinyint] NULL,
	[ItemID16] [int] NULL,
	[ItemCount16] [tinyint] NULL,
	[ItemID17] [int] NULL,
	[ItemCount17] [tinyint] NULL,
	[ItemID18] [int] NULL,
	[ItemCount18] [tinyint] NULL,
	[ItemID19] [int] NULL,
	[ItemCount19] [tinyint] NULL,
	[ItemID20] [int] NULL,
	[ItemCount20] [tinyint] NULL,
	[ItemID21] [int] NULL,
	[ItemCount21] [tinyint] NULL,
	[ItemID22] [int] NULL,
	[ItemCount22] [tinyint] NULL,
	[ItemID23] [int] NULL,
	[ItemCount23] [tinyint] NULL,
	[ItemID24] [int] NULL,
	[ItemCount24] [tinyint] NULL,
 CONSTRAINT [PK_ProductList] PRIMARY KEY CLUSTERED 
(
	[RowID] 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
Search for a decrypted ep6 game.exe.

Updated/Translated Monster.sdata/.mon
07/20/2012 08:06 Dread123#3
um since i ran that i loged off and then tryed to turn server on the nxt day and all of a sudden the dbo.mobitems is missing from the db any1 no how to get this back
07/20/2012 08:23 [Admin]Accident#4
Yes