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

Online istatistikleri

OnlineHile Links

En yeni üyeler

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

E.m.R.a.H

Ceronimo

Kayıtlı Üye

0limpiA

Kayıtlı Üye

Online istatistikleri

OnlineHile Links

En yeni üyeler

OnlineHile Sosyal