Problem ist hab WebAdminPanel in PHP gecodet auch alles soweit fertig hab jetzt aber einfach nur das die ganzen Item ID's drinne stehen hätte halt jetzt 2 möglichkeiten entweder ich übertrag alle Items aus der SHN also ID/InxName/Name und Lvl in ne DB das der das da ausließt oder einfacher wär halt ne shn weil dan müsst ich net immer neue items in die DB einfügen. bräuchte es halt in php D:
USE [OperatorTool]
GO
/****** Object: Table [dbo].[tItemInfo] Script Date: 14.04.2014 16:23:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tItemInfo](
[No] [int] IDENTITY(1,1) NOT NULL,
[ID] [nchar](50) NOT NULL,
[InxName] [nchar](50) NOT NULL,
[Name] [nchar](50) NOT NULL,
[Type] [nchar](50) NOT NULL,
[Class] [nchar](50) NOT NULL,
[MaxLot] [nchar](50) NOT NULL,
[Equip] [nchar](50) NOT NULL,
[TwoHand] [nchar](50) NOT NULL,
[AktSpeed] [nchar](50) NOT NULL,
[DemandLv] [nchar](50) NOT NULL,
[Grade] [nchar](50) NOT NULL,
[MinWC] [nchar](50) NOT NULL,
[MaxWC] [nchar](50) NOT NULL,
[AC] [nchar](50) NOT NULL,
[MinMA] [nchar](50) NOT NULL,
[MaxMa] [nchar](50) NOT NULL,
[MR] [nchar](50) NOT NULL,
[WCRate] [nchar](50) NOT NULL,
[MARate] [nchar](50) NOT NULL,
[ACRate] [nchar](50) NOT NULL,
[MRRate] [nchar](50) NOT NULL,
[CriRate] [nchar](50) NOT NULL,
[CriMinWc] [nchar](50) NOT NULL,
[CriMaxWc] [nchar](50) NOT NULL,
[CriMinMa] [nchar](50) NOT NULL,
[CriMaxMa] [nchar](50) NOT NULL,
[MaxHP] [nchar](50) NOT NULL,
[MaxSP] [nchar](50) NOT NULL,
[WhoEquip] [nchar](50) NOT NULL,
[BuyPrice] [nchar](50) NOT NULL,
[SellPrice] [nchar](50) NOT NULL,
[BuyFame] [nchar](50) NOT NULL,
[BuyGToken] [nchar](50) NOT NULL,
[WeaponType] [nchar](50) NOT NULL,
[ArmorType] [nchar](50) NOT NULL,
[UpLimit] [nchar](50) NOT NULL,
[UpSucRatio] [nchar](50) NOT NULL,
[UpLuckRatio] [nchar](50) NOT NULL,
[UpResource] [nchar](50) NOT NULL,
[BasicUPInx] [nchar](50) NOT NULL,
[AddUpInx] [nchar](50) NOT NULL,
[TH] [nchar](50) NOT NULL,
[TB] [nchar](50) NOT NULL,
[ShieldAC] [nchar](50) NOT NULL,
[HitRatePlus] [nchar](50) NOT NULL,
[EvaRatePlus] [nchar](50) NOT NULL,
[MACriPlus] [nchar](50) NOT NULL,
[CriDamPlus] [nchar](50) NOT NULL,
[MagCriDamPlus] [nchar](50) NOT NULL,
[Belonged] [nchar](50) NOT NULL,
[NoDrop] [nchar](50) NOT NULL,
[NoSell] [nchar](50) NOT NULL,
[NoStorage] [nchar](50) NOT NULL,
[NoTrade] [nchar](50) NOT NULL,
[NoDelete] [nchar](50) NOT NULL,
[TitleName] [nchar](50) NOT NULL,
[ItemGradeType] [nchar](50) NOT NULL,
[ItemUseSkill] [nchar](50) NOT NULL,
[SetItemIndex] [nchar](50) NOT NULL,
[ItemFunc] [nchar](50) NOT NULL,
[AutoMon] [nchar](50) NOT NULL
) ON [PRIMARY]
GO