Evo--Querry's

All Mastery Lvl xxx

PHP Code:

---

USE [SRO_VT_SHARD]
GO
--by Evo
Declare @CharName Varchar (64)
Set @CharName    =    '[GM]BlackBerry'

UPDATE    [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName) 


---

your Server no Have Roc mountain??

Demon has Appeared on Central Asia querry

PHP Code:

---

USE [SRO_VT_SHARD]

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')) 


---

How to Change ID

PHP Code:

---

USE [SRO_VT_ACCOUNT]
declare @AtualID varchar (30)
declare @NewID varchar (30)
set @AtualID = 'youridhere'
set @NewID = 'newidhere'
update tb_user set struserid = @NewID
where struserid = @AtualID 


---

...

Thx

Quote:

---

USE [SRO_VT_SHARD]

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'))

---

so in this query if i change the pos and the code name of monster i can add any unqiue i want in place that i want too ?

ofcourse c;

This query will only change the monster spawn and respawn time of entering the code mob

Now I'm working on a query that banning an account by charname

thx...

Demon Appeared

http://d1205.hizliresim.com/x/9/5kb5w.png

XD All I'm learning I'm posting

Please Click Like

how to Change Ather monster

Change name monster or?

Quote:

---

Originally Posted by ahmedelbeah

how to Change Ather monster

Change name monster or?

---

in your textdata_object.txt

Any Know how to add new spawn to Uniques ?
example Jupiter, Yuno, The Earth ...