Plus Auto Notice(Sample + Source)

[>>LiNkS<<]

What if i want to know other Operation? for example i want to know when a item has been destroyed.

[herolord46]

How To Fix ITEM NAMES ?

[>>LiNkS<<]

How To Fix ITEM NAMES ?

Read the post lemoniscool said how to do:

for everyone that wants to change code name into the real item name ..
copy the lines for all items from textdata_equip&skill.txt then remove everything but the Name code name (SN_ITEM_BLABLA) and the real name, after that remove the SN_ from name code names and then seperate them with one tab. after that copy it all to a database named SRO_VT_SHARD.sbo._ItemName (create that table with 2 columns first one named CodeName128 varchar and the other one named Name also varchar)

after that all you have to do is change the query inside _AddLogItem:

select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid) 

Attachment 132687

[PX2000]

What if i want to know other Operation? for example i want to know when a item has been destroyed.

"Destroy" operation is 41 .. correct me if i'm wrong

How To Fix ITEM NAMES ?

/****** Object:  Table [dbo].[_RefObjItemName]    Script Date: 06/26/2013 11:37:48 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[_RefObjItemName](
	[Service] [int] NOT NULL,
	[NameStrID128] [varchar](128) NOT NULL,
	[Lang1] [varchar](128) NULL,
	[Lang2] [varchar](128) NULL,
	[Lang3] [varchar](128) NULL,
	[Lang4] [varchar](128) NULL,
	[Lang5] [varchar](128) NULL,
	[Lang6] [varchar](128) NULL,
	[Lang7] [varchar](128) NULL,
	[Lang8] [varchar](128) NULL,
	[Lang9] [varchar](128) NULL,
	[Lang10] [varchar](128) NULL,
	[Lang11] [varchar](128) NULL,
	[Lang12] [varchar](128) NULL,
	[Lang13] [varchar](128) NULL,
	[Lang14] [varchar](128) NULL,
	[Lang15] [varchar](128) NULL,
	[Lang16] [varchar](128) NULL,
	[Lang17] [varchar](128) NULL,
	[Lang18] [varchar](128) NULL,
	[Lang19] [varchar](128) NULL,
	[Lang20] [varchar](128) NULL,
	[Index] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK__RefObjItemName] PRIMARY KEY CLUSTERED 
(
	[Index] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO


ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang1]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang2]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang3]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang4]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang5]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang6]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang7]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang8]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang9]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang10]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang11]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang12]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang13]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang14]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang15]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang16]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang17]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang18]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang19]
GO
ALTER TABLE [dbo].[_RefObjItemName] ADD  DEFAULT (0) FOR [Lang20]
GO

[herolord46]

lemoniscool you share please dbo._ItemName I dont maked :S

[Showtek]

lemoniscool you share please dbo._ItemName I dont maked :S

Use PX2000 query and insert this: items.txt

[herolord46]

Working Fine now. Adv Not Woking ? I using +2 adv Notice Not Write :S ?

[omega0511]

hep The version is incorrect, please restart the programm !

[lemoniscool]

lemoniscool you share please dbo._ItemName I dont maked :S

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_ItemName]    Script Date: 06/26/2013 18:01:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemName](
    [CodeName128] [varchar](50) NOT NULL,
    [Name] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 

after creating it insert the lines from the attached text file into the table



btw, im almost done with the newer version of this tool

[Mixizi]

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_ItemName]    Script Date: 06/26/2013 18:01:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemName](
    [CodeName128] [varchar](50) NOT NULL,
    [Name] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 

after creating it insert the lines from the attached text file into the table



btw, im almost done with the newer version of this tool

Will you release the source code ?

[Csarmy]

Fixx :)

[Caosfox]

Will you release the source code ?

yup, source is going to be released

[onurgs59]

Can we do it and above +8 ?

[PX2000]

Can we do it and above +8 ?

if(@strDesc_separado >= 8) //+8 or above +8

[blackblood9]

Guys any One Can Upload the Fixed One Because the last Version saying Version is Wrong all the time