مواعيد نزول Unique
 

انا عايز انزل ال Unique كل ما تموت او كل 5 دقايق كدة ؟؟؟
و عايز انزل Unique بتنزل Coin بس كل سعتين او 3 ساعات

وى كل ما اعمل اى حاجة تيجى دية
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '26100'.

هيا المشكلة صعبة ولا اية :] :] :mf_death:

عموما الموضوع جميل جدا و شوفت حاجات كتير كنت محتجها
1- Alchemy3x

USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2044'
ادوس New Query بعدها Pasty Copy معلش انا لسا بتعلم :)



Fix The Fortress War Uniques. [ Some of them was not working ].


use SRO_VT_SHARD_INIT
UPDATE _RefObjCommon SET TypeID3=1, TypeID4=1, Rarity=3
WHERE (CodeName128 LIKE 'MOB_FW_KYKLOPES_%') OR
(CodeName128 LIKE 'MOB_FW_WHITETIGER_%') OR
(CodeName128 LIKE 'MOB_FW_DARKEAGLE%') OR
(CodeName128 LIKE 'MOB_FW_HAGIAZO%') OR
(CodeName128 LIKE 'MOB_FW_BIGSPIDER_%') OR
(CodeName128 LIKE 'MOB_FW_HANGA%')

و دى نفس الكلام ؟ صح

Moving Uniques from its spawns (E.G : DemonShitan )lol

USE [SRO_VT_SHARD]created by : Albert

Update Tab_RefNest Set
dwDelayTimeMin=600 ,
dwDelayTimeMax=1601 ,
--Posiçمo--
nRegionDBID=26737 ,
fLocalPosX=705 ,
fLocalPosY=272.922821 ,
fLocalPosZ=1466


WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET'))
دية بقا كل اليونك ولا demon معلش هتعبك عايو Code :)
اسف لو كترت المشاكل و انا كاتب مشكلة واحدة

مش فهمك ولله دلوقتى عايز معلش تقولى كود Unique اهوةة بس كدة :D :D :111 (9):

انــت حــط مكــان الكـود ده كــود الـ Unique اللـى أنــت عـايـزه..