Kullanılabilir itemleri listelemek (Doğru plus adları ile birlikte)

E.m.R.a.H · 25 Kasım 2013

Bildiğiniz gibi item tablosunda item plus numaraları +9 sonra düzgün adlandırılmamış örnek vericek olursak,

+0 -> +10
+1 -> +11
..
+0 ->30

Liste bu şekilde gidiyor. Birkaç gündür item tablosunu temize çekiyorum hemen hemen %60'ı bitti sayılır. Bunun için pratik scriptler hazırlıyorum. Birkaçını paylaşmak istedim.

Armorlar için mantık şu şekilde. Warrior shell helmet'i ele alalım +0 saf halinin item numarasını tanımlanmış değere yazıyorsunuz ve size kullanılabilir helmetleri listeliyor. Aynı zamanda item plus numarlarını doğru şekilde çağırıyor. +11 ise +11 çağırır. Race itemler dahil değildir.

Listelediği item listesi,

View hidden content is available for registered users!

Armor için,

PHP:

DECLARE @ItemID int = 567005001



SELECT * FROM ITEM WHERE

	(Num BETWEEN @ItemID+10000000 AND @ItemID+10000008) OR

	(Num BETWEEN @ItemID+10000030 AND @ItemID+10000038) OR

	(Num BETWEEN @ItemID+10000060 AND @ItemID+10000068) OR

	(Num BETWEEN @ItemID+10000090 AND @ItemID+10000098) OR

	(Num BETWEEN @ItemID+10000120 AND @ItemID+10000128) OR

	(Num BETWEEN @ItemID+10000150 AND @ItemID+10000158) OR

	(Num BETWEEN @ItemID+10000180 AND @ItemID+10000188) OR

	(Num BETWEEN @ItemID+10000210 AND @ItemID+10000218) UNION



SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Upgrade item(+0 to +10)

	(Num BETWEEN @ItemID AND @ItemID+39) OR

	(Num BETWEEN @ItemID+500 AND @ItemID+549) UNION

SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +10)

Num IN(	@ItemID+10000009,

		@ItemID+10000039,

		@ItemID+10000069,

		@ItemID+10000099,

		@ItemID+10000129,

		@ItemID+10000159,

		@ItemID+10000189,

		@ItemID+10000219,

		@ItemID+10000249) UNION

SELECT Num,REPLACE(strName,'(+1)','(+11)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+1 to +11)

Num IN(	@ItemID+10000010,

		@ItemID+10000040,

		@ItemID+10000070,

		@ItemID+10000100,

		@ItemID+10000130,

		@ItemID+10000160,

		@ItemID+10000190,

		@ItemID+10000220,

		@ItemID+10000250) UNION

SELECT Num,REPLACE(strName,'(+2)','(+12)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+2 to +12)

Num IN(	@ItemID+10000011,

		@ItemID+10000041,

		@ItemID+10000071,

		@ItemID+10000101,

		@ItemID+10000131,

		@ItemID+10000161,

		@ItemID+10000191,

		@ItemID+10000221,

		@ItemID+10000251) UNION

SELECT Num,REPLACE(strName,'(+3)','(+13)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+3 to +13)

Num IN(	@ItemID+10000012,

		@ItemID+10000042,

		@ItemID+10000072,

		@ItemID+10000102,

		@ItemID+10000132,

		@ItemID+10000162,

		@ItemID+10000192,

		@ItemID+10000222,

		@ItemID+10000252) UNION

SELECT Num,REPLACE(strName,'(+4)','(+14)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+4 to +14)

Num IN(	@ItemID+10000013,

		@ItemID+10000043,

		@ItemID+10000073,

		@ItemID+10000103,

		@ItemID+10000133,

		@ItemID+10000163,

		@ItemID+10000193,

		@ItemID+10000223,

		@ItemID+10000253) UNION

SELECT Num,REPLACE(strName,'(+5)','(+15)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+5 to +15)

Num IN(	@ItemID+10000014,

		@ItemID+10000044,

		@ItemID+10000074,

		@ItemID+10000104,

		@ItemID+10000134,

		@ItemID+10000164,

		@ItemID+10000194,

		@ItemID+10000224,

		@ItemID+10000254) UNION

SELECT Num,REPLACE(strName,'(+6)','(+16)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+6 to +16)

Num IN(	@ItemID+10000015,

		@ItemID+10000045,

		@ItemID+10000075,

		@ItemID+10000105,

		@ItemID+10000135,

		@ItemID+10000165,

		@ItemID+10000195,

		@ItemID+10000225,

		@ItemID+10000255) UNION

SELECT Num,REPLACE(strName,'(+7)','(+17)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+7 to +17)

Num IN(	@ItemID+10000016,

		@ItemID+10000046,

		@ItemID+10000076,

		@ItemID+10000106,

		@ItemID+10000136,

		@ItemID+10000166,

		@ItemID+10000196,

		@ItemID+10000226,

		@ItemID+10000256) UNION

SELECT Num,REPLACE(strName,'(+8)','(+18)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+8 to +18)

Num IN(	@ItemID+10000017,

		@ItemID+10000047,

		@ItemID+10000077,

		@ItemID+10000107,

		@ItemID+10000137,

		@ItemID+10000167,

		@ItemID+10000197,

		@ItemID+10000227,

		@ItemID+10000257) UNION

SELECT Num,REPLACE(strName,'(+9)','(+19)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+9 to +19)

Num IN(	@ItemID+10000018,

		@ItemID+10000048,

		@ItemID+10000078,

		@ItemID+10000108,

		@ItemID+10000138,

		@ItemID+10000168,

		@ItemID+10000198,

		@ItemID+10000228,

		@ItemID+10000258) UNION

SELECT Num,REPLACE(strName,'(+0)','(+20)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +20)

Num IN(	@ItemID+10000019,

		@ItemID+10000049,

		@ItemID+10000079,

		@ItemID+10000109,

		@ItemID+10000139,

		@ItemID+10000169,

		@ItemID+10000199,

		@ItemID+10000229,

		@ItemID+10000259) UNION

SELECT Num,REPLACE(strName,'(+1)','(+21)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+1 to +21)

Num IN(	@ItemID+10000020,

		@ItemID+10000050,

		@ItemID+10000080,

		@ItemID+10000110,

		@ItemID+10000140,

		@ItemID+10000170,

		@ItemID+10000200,

		@ItemID+10000230,

		@ItemID+10000260) UNION

SELECT Num,REPLACE(strName,'(+2)','(+22)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+2 to +22)

Num IN(	@ItemID+10000021,

		@ItemID+10000051,

		@ItemID+10000081,

		@ItemID+10000111,

		@ItemID+10000141,

		@ItemID+10000171,

		@ItemID+10000201,

		@ItemID+10000231,

		@ItemID+10000261) UNION

SELECT Num,REPLACE(strName,'(+3)','(+23)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+3 to +23)

Num IN(	@ItemID+10000022,

		@ItemID+10000052,

		@ItemID+10000082,

		@ItemID+10000112,

		@ItemID+10000142,

		@ItemID+10000172,

		@ItemID+10000202,

		@ItemID+10000232,

		@ItemID+10000262) UNION

SELECT Num,REPLACE(strName,'(+4)','(+24)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+4 to +24)

Num IN(	@ItemID+10000023,

		@ItemID+10000053,

		@ItemID+10000083,

		@ItemID+10000113,

		@ItemID+10000143,

		@ItemID+10000173,

		@ItemID+10000203,

		@ItemID+10000233,

		@ItemID+10000263) UNION

SELECT Num,REPLACE(strName,'(+5)','(+25)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+5 to +25)

Num IN(	@ItemID+10000024,

		@ItemID+10000054,

		@ItemID+10000084,

		@ItemID+10000114,

		@ItemID+10000144,

		@ItemID+10000174,

		@ItemID+10000204,

		@ItemID+10000234,

		@ItemID+10000264) UNION

SELECT Num,REPLACE(strName,'(+6)','(+26)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+6 to +26)

Num IN(	@ItemID+10000025,

		@ItemID+10000055,

		@ItemID+10000085,

		@ItemID+10000115,

		@ItemID+10000145,

		@ItemID+10000175,

		@ItemID+10000205,

		@ItemID+10000235,

		@ItemID+10000265) UNION

SELECT Num,REPLACE(strName,'(+7)','(+27)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+7 to +27)

Num IN(	@ItemID+10000026,

		@ItemID+10000056,

		@ItemID+10000086,

		@ItemID+10000116,

		@ItemID+10000146,

		@ItemID+10000176,

		@ItemID+10000206,

		@ItemID+10000236,

		@ItemID+10000266) UNION

SELECT Num,REPLACE(strName,'(+8)','(+28)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+8 to +28)

Num IN(	@ItemID+10000027,

		@ItemID+10000057,

		@ItemID+10000087,

		@ItemID+10000117,

		@ItemID+10000147,

		@ItemID+10000177,

		@ItemID+10000207,

		@ItemID+10000237,

		@ItemID+10000267) UNION

SELECT Num,REPLACE(strName,'(+9)','(+29)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+9 to +29)

Num IN(	@ItemID+10000028,

		@ItemID+10000058,

		@ItemID+10000088,

		@ItemID+10000118,

		@ItemID+10000148,

		@ItemID+10000178,

		@ItemID+10000208,

		@ItemID+10000238,

		@ItemID+10000268) UNION

SELECT Num,REPLACE(strName,'(+0)','(+30)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +30)

Num IN(	@ItemID+10000029,

		@ItemID+10000059,

		@ItemID+10000089,

		@ItemID+10000119,

		@ItemID+10000149,

		@ItemID+10000179,

		@ItemID+10000209,

		@ItemID+10000239,

		@ItemID+10000269)

ORDER BY Num ASC

GO

Weapon için biraz daha farklı, aslında aynı fakat ardışık numalardaki sıralama sistemi farklı.

Listeleme şu şekilde,

Kod:

Shard(Non-posion)(1-10)

Shard(Posion)(1-10)

Shard(Non-posion)(Reduce)(1-10)



Shard(Posion)(1-30)

Shard(Non-posion)(Reduce)(1-30)

Weapon için,

PHP:

DECLARE @ItemID int = 150450001



SELECT * FROM ITEM WHERE

	(Num BETWEEN @ItemID+1000 AND @ItemID+1008) OR

	(Num BETWEEN @ItemID+1030 AND @ItemID+1038) OR

	(Num BETWEEN @ItemID+1060 AND @ItemID+1068) OR

	(Num BETWEEN @ItemID+1090 AND @ItemID+1098) OR

	(Num BETWEEN @ItemID+1120 AND @ItemID+1128) OR

	(Num BETWEEN @ItemID+1150 AND @ItemID+1158) OR

	(Num BETWEEN @ItemID+1180 AND @ItemID+1188) OR

	(Num BETWEEN @ItemID+1210 AND @ItemID+1218) UNION



SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Upgrade item(+0 to +10)

(Num BETWEEN @ItemID AND @ItemID+9) OR

(Num BETWEEN @ItemID+30 AND @ItemID+49) UNION



SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +10)

Num IN(	@ItemID+1009,

		@ItemID+1039) UNION

SELECT Num,REPLACE(strName,'(+1)','(+11)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+1 to +11)

Num IN(	@ItemID+1010,

		@ItemID+1040) UNION

SELECT Num,REPLACE(strName,'(+2)','(+12)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+2 to +12)

Num IN(	@ItemID+1011,

		@ItemID+1041) UNION

SELECT Num,REPLACE(strName,'(+3)','(+13)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+3 to +13)

Num IN(	@ItemID+1012,

		@ItemID+1042) UNION

SELECT Num,REPLACE(strName,'(+4)','(+14)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+4 to +14)

Num IN(	@ItemID+1013,

		@ItemID+1043) UNION

SELECT Num,REPLACE(strName,'(+5)','(+15)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+5 to +15)

Num IN(	@ItemID+1014,

		@ItemID+1044) UNION

SELECT Num,REPLACE(strName,'(+6)','(+16)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+6 to +16)

Num IN(	@ItemID+1015,

		@ItemID+1045) UNION

SELECT Num,REPLACE(strName,'(+7)','(+17)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+7 to +17)

Num IN(	@ItemID+1016,

		@ItemID+1046) UNION

SELECT Num,REPLACE(strName,'(+8)','(+18)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+8 to +18)

Num IN(	@ItemID+1017,

		@ItemID+1047) UNION

SELECT Num,REPLACE(strName,'(+9)','(+19)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+9 to +19)

Num IN(	@ItemID+1018,

		@ItemID+1048) UNION

SELECT Num,REPLACE(strName,'(+0)','(+20)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +20)

Num IN(	@ItemID+1019,

		@ItemID+1049) UNION

SELECT Num,REPLACE(strName,'(+1)','(+21)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+1 to +21)

Num IN(	@ItemID+1020,

		@ItemID+1050) UNION

SELECT Num,REPLACE(strName,'(+2)','(+22)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+2 to +22)

Num IN(	@ItemID+1021,

		@ItemID+1051) UNION

SELECT Num,REPLACE(strName,'(+3)','(+23)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+3 to +23)

Num IN(	@ItemID+1022,

		@ItemID+1052) UNION

SELECT Num,REPLACE(strName,'(+4)','(+24)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+4 to +24)

Num IN(	@ItemID+1023,

		@ItemID+1053) UNION

SELECT Num,REPLACE(strName,'(+5)','(+25)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+5 to +25)

Num IN(	@ItemID+1024,

		@ItemID+1054) UNION

SELECT Num,REPLACE(strName,'(+6)','(+26)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+6 to +26)

Num IN(	@ItemID+1025,

		@ItemID+1055) UNION

SELECT Num,REPLACE(strName,'(+7)','(+27)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+7 to +27)

Num IN(	@ItemID+1026,

		@ItemID+1056) UNION

SELECT Num,REPLACE(strName,'(+8)','(+28)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+8 to +28)

Num IN(	@ItemID+1027,

		@ItemID+1057) UNION

SELECT Num,REPLACE(strName,'(+9)','(+29)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+9 to +29)

Num IN(	@ItemID+1028,

		@ItemID+1058) UNION

SELECT Num,REPLACE(strName,'(+0)','(+30)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE

-- Rebirth upgrade item (+0 to +30)

Num IN(	@ItemID+1029,

		@ItemID+1059)

ORDER BY Num ASC

GO

Ceronimo · 28 Kasım 2013

Cevap: Kullanılabilir itemleri listelemek (Doğru plus adları ile birlikte)

teşekkurler

0limpiA · 30 Ocak 2018

teşekkürler

Kullanılabilir itemleri listelemek (Doğru plus adları ile birlikte)

E.m.R.a.H

Ceronimo

Kayıtlı Üye

0limpiA

Kayıtlı Üye