mates server files

[sumfuka]

anyone know why you cant sell any items to any of the npcs? The script files seem fine and im unable 2 put my fingure on the problem.
​

 

[Zen2]

Duno if the wool files work the same as mir files but you usualy have to delete the npc saved or something and if they are new items you have added there may be something in the db u missed that u need to allow the items to be sold to the npc?

Sorry if this doesnt help, just off the top of my head.

 

[HASSIS_JUPINU]

lock in D:\DMXYV018\data\script to edit yout npc seling item
end in site of npc you need to have

+10 <+item thing > +10 is for armors (m)

[goods]
<item name> 0 10

end

you need to delete all files wat is insite of D:\DMXYV018\data\Market_Save

good lock

 

[sumfuka]

Is their a decent program to edit these in as notepad sucks?
​

 

[howie]

I have just set up this server on a fresh PC and all the NPC`s can be sold to ?

 

[sumfuka]

I guess i must have something set up wrong then. It's strange as everything work's perfect, apart from not being able to sell to any npcs. I can buy, repair fine. I got some red chinese msg when ever I try to sell, followed by the this item cannot be sold. happen's on all the npc's, they even display the sell price when you place the item in the window

 

[EMPEROR]

I guess i must have something set up wrong then. It's strange as everything work's perfect, apart from not being able to sell to any npcs. I can buy, repair fine. I got some red chinese msg when ever I try to sell, followed by the this item cannot be sold. happen's on all the npc's, they even display the sell price when you place the item in the window

Take a screenshot off the red chinese bit.. I will try help you.

Also do you get and NPC Errors when your Game Engine loads up?.

 

[sumfuka]

I beleve I may have found the problem. looking at the TBL_CHARACTER_Info.sql file, the 1 included with the mats server files looks like,

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHARACTER_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_CHARACTER_INFO]
GO

CREATE TABLE [dbo].[TBL_CHARACTER_INFO] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ACCOUNT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CLASS] [tinyint] NOT NULL ,
[SEX] [tinyint] NOT NULL ,
[VLEVEL] [smallint] NOT NULL ,
[MAPNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[POSX] [smallint] NOT NULL ,
[POSY] [smallint] NOT NULL ,
[HAIR] [tinyint] NOT NULL ,
[SERVER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ODATE] [datetime] NOT NULL ,
[DELFLAG] [tinyint] NOT NULL ,
[DELDATE] [datetime] NOT NULL ,
[CREATEDATE] [datetime] NOT NULL ,
[CUREXP] [int] NOT NULL ,
[HP] [smallint] NOT NULL ,
[MP] [smallint] NOT NULL ,
[MAXHP] [smallint] NOT NULL ,
[MAXMP] [smallint] NOT NULL ,
[MINDC] [tinyint] NOT NULL ,
[MAXDC] [tinyint] NOT NULL ,
[MINMC] [tinyint] NOT NULL ,
[MAXMC] [tinyint] NOT NULL ,
[MINSC] [tinyint] NOT NULL ,
[MAXSC] [tinyint] NOT NULL ,
[MINAC] [tinyint] NOT NULL ,
[MAXAC] [tinyint] NOT NULL ,
[MINMAC] [tinyint] NOT NULL ,
[MAXMAC] [tinyint] NOT NULL ,
[WEIGHT] [smallint] NOT NULL ,
[HANDWEIGHT] [tinyint] NOT NULL ,
[BODYWEIGHT] [tinyint] NOT NULL ,
[GOLD] [int] NOT NULL ,
[MAPID] [int] NOT NULL ,
[YUANBAO] [int] NOT NULL ,
[FLAG1] [int] NOT NULL ,
[FLAG2] [int] NOT NULL ,
[FLAG3] [int] NOT NULL ,
[FLAG4] [int] NOT NULL ,
[GUILDNAME] [varchar] (50) NOT NULL
) ON [PRIMARY]
GO

However when you try to start this up, it comes back with error's saying there a problem with the forge point and prop1-7 rows.

With a different version of the files (found on ragezone) the TBL_CHARACTER_Info.sql looks like

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_CHARACTER_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TBL_CHARACTER_INFO]
GO

CREATE TABLE [dbo].[TBL_CHARACTER_INFO] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ACCOUNT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[NAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CLASS] [tinyint] NOT NULL ,
[SEX] [tinyint] NOT NULL ,
[VLEVEL] [smallint] NOT NULL ,
[MAPNAME] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[POSX] [smallint] NOT NULL ,
[POSY] [smallint] NOT NULL ,
[HAIR] [tinyint] NOT NULL ,
[SERVER] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ODATE] [datetime] NOT NULL ,
[DELFLAG] [tinyint] NOT NULL ,
[DELDATE] [datetime] NOT NULL ,
[CREATEDATE] [datetime] NOT NULL ,
[CUREXP] [int] NOT NULL ,
[HP] [smallint] NOT NULL ,
[MP] [smallint] NOT NULL ,
[MAXHP] [smallint] NOT NULL ,
[MAXMP] [smallint] NOT NULL ,
[MINDC] [tinyint] NOT NULL ,
[MAXDC] [tinyint] NOT NULL ,
[MINMC] [tinyint] NOT NULL ,
[MAXMC] [tinyint] NOT NULL ,
[MINSC] [tinyint] NOT NULL ,
[MAXSC] [tinyint] NOT NULL ,
[MINAC] [tinyint] NOT NULL ,
[MAXAC] [tinyint] NOT NULL ,
[MINMAC] [tinyint] NOT NULL ,
[MAXMAC] [tinyint] NOT NULL ,
[WEIGHT] [smallint] NOT NULL ,
[HANDWEIGHT] [tinyint] NOT NULL ,
[BODYWEIGHT] [tinyint] NOT NULL ,
[GOLD] [int] NOT NULL ,
[MAPID] [int] NOT NULL ,
[YUANBAO] [int] NOT NULL ,
[FLAG1] [int] NOT NULL ,
[FLAG2] [int] NOT NULL ,
[FLAG3] [int] NOT NULL ,
[FLAG4] [int] NOT NULL ,
[GUILDNAME] [varchar] (50) NOT NULL ,
[FORGEPOINT] [int] NOT NULL ,
[PROP1] [int] NOT NULL ,
[PROP2] [int] NOT NULL ,
[PROP3] [int] NOT NULL ,
[PROP4] [int] NOT NULL ,
[PROP5] [int] NOT NULL ,
[PROP6] [int] NOT NULL ,
[PROP7] [int] NOT NULL ,
[PROP8] [int] NOT NULL
) ON [PRIMARY]
GO



I've made bold the extra rows for easy viewing. I possabley couldve over looked something else, but this seems to have sorted out my problem. Ive deleted the bottem part of the tbl files as my post was to long to.
​

 

[howie]

I guess i must have something set up wrong then. It's strange as everything work's perfect, apart from not being able to sell to any npcs. I can buy, repair fine. I got some red chinese msg when ever I try to sell, followed by the this item cannot be sold. happen's on all the npc's, they even display the sell price when you place the item in the window

check you have not maxed out your gold that you can carry.