24-10-2013, 11:37 AM
|
#3
|
|
|
• الانـتـسـاب » Dec 2012
|
|
• رقـم العـضـويـة » 107695
|
|
• المشـــاركـات » 1,556
|
|
• الـدولـة » الاسكندرية
|
|
• الـهـوايـة » Database Editor
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 83
|
|
|
 
|
بـوص اسـتخدم الـكويرى ده هـيحددلك الـناس اللى معاها +250 بـالـ ID بتاع الايتم
|
|
|
USE [SRO_VT_SHARD]
GO
select ID64, item.OptLevel, adv.nOptValue, ref.CodeName128, chars.CharName16
FROM _Items as item
left join _RefObjCommon as ref on item.RefItemID = ref.ID
left join _BindingOptionWithItem as adv on item.ID64 = adv.nItemDBID
left join _Inventory as inv on item.ID64 = inv.ItemID
left join _Char as chars on inv.CharID = chars.CharID
WHERE
ref.CodeName128 not like 'item_etc%'
and ref.CodeName128 not like 'item_mall%'
and adv.bOptType = 2
and chars.CharName16 is not NULL
order by OptLevel desc
|
بـعد كدة خود الـ ID واكتبو فى الـ Query ده و نـزل الـسلاح الـ Plus اللى انت عايزو
|
|
|
UPDATE [SRO_VT_SHARD].[dbo].[_Items]
SET [OptLevel] = 7
WHERE ID64= 681147
|
|
|
|
|