[TUT] How add Artemis's Hat.

i have this error
[SQL]SET IDENTITY_INSERT [dbo].[Items_Gear] ON


[Err] 42000 - [SQL Server]Table 'dbo.Items_Gear' does not have the identity property. Cannot perform SET operation.


any ideas?

any extra help adding it to the SQL database would be greatly appreciated :)

Try add it manually

sorry im pretty noob when it comes to adding items to the server

I added it to the ItemDB.xml and the SQL server. When i spawn it into the server it shows as an EMPTY ITEM and if you drop it, the whole server crashes xD

Quote:

---

Originally Posted by KlausVander

Try add it manually

---

yea, i added manually, thank you Klaus

so where is the .sco file?

Quote:

---

Originally Posted by DontShootImWhit

sorry im pretty noob when it comes to adding items to the server

I added it to the ItemDB.xml and the SQL server. When i spawn it into the server it shows as an EMPTY ITEM and if you drop it, the whole server crashes xD

---

You add all files, build the solutions and do the rsbuild?
It is not necessary sco files, only the files i upload will work normally :P

fix sql

Code:

---

use [warz]
go

--SET IDENTITY_INSERT [dbo].[Items_Gear] ON
--GO
INSERT INTO [Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (N'20210', N'hgear_hat_artemis_01', N'Artemis Hat', N'Cowboy', N'13', N'300', N'2', N'300', N'1', N'0', N'0', N'0', N'0', N'0', N'140', N'1', N'1', N'0', N'0', N'0', N'0', N'0')
GO

---