If you want certain character's mastery's at a certain level.. Input their name here, and set their skill level you desire.
To change a characters Username... A.K.A. ID.
If you don't have Roc Mountain opened, here's a query to move Demon Shaitan to a new spawn ( this one in example is Central Asia )
Also, you can change the position, and mob name, will also work for other uniques.
Credits ; nukertube
Regards,
ღ ∂ropp
Don't be a fatass, press thanks!
:facepalm:
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)
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 = @ActualID
If you don't have Roc Mountain opened, here's a query to move Demon Shaitan to a new spawn ( this one in example is Central Asia )
Also, you can change the position, and mob name, will also work for other uniques.
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'))
Regards,
ღ ∂ropp
Don't be a fatass, press thanks!
:facepalm:
