[Release] Useful queries for some people (Part I)

[ღ ∂ Ropp]

If you want certain character's mastery's at a certain level.. Input their name here, and set their skill level you desire.

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) 


To change a characters Username... A.K.A. 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 = @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')) 


Credits ; nukertube

Regards,
ღ ∂ropp


Don't be a fatass, press thanks!

[rushcrush]

you mean ppl not players..

[ღ ∂ Ropp]

No, in-game players....

Anyways, don't you got a server to be failing? Don't want to argue with anyone atm.

[Kape7]

Here rushcrush said nothing, srsly what is wrong with you all?
He just pointed that the thread title is wrong, since the release that ღ ∂ Ropp did aims for the people in general (serverfiles owners) not players (people that actually play the game), since they don't have access to the DB after all.

Don't make every thread a flame war...

[Disco Teka]

Avoid posting unrelated bulshit in this thread.

Renamed it to "[Release] Useful queries for some people (Part I)" if you want to release other useful queries.

[Neko*]

Would you mind to add this quires to my collection ?
In ------>

of course i will add the credits and thanks

[xxnukertube]

lol
Where My Credits?

[ღ ∂ Ropp]

Originally Posted by ღ ∂ Ropp

If you want certain character's mastery's at a certain level.. Input their name here, and set their skill level you desire.

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) 


To change a characters Username... A.K.A. 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 = @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')) 


Credits ; nukertube

Regards,
ღ ∂ropp


Don't be a fatass, press thanks!

Is that big enough for ya there bud?

[ღ•Imagine•]

useful ty .

[xxnukertube]

Originally Posted by ღ ∂ Ropp

Is that big enough for ya there bud?

^^ '

[sarkoplata]

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 


And if the @NewID already exists...

[PortalDark]

#moved

[CrazyGirL_ZSZC]

Originally Posted by Neko*

Would you mind to add this quires to my collection ?
In ------>

of course i will add the credits and thanks

yeah urs awesome too

[SunSoon]

Nice one.. Ty

[YOUNG SINATRA]

Awesme Query Mercí