Queries Collection - Makes your life easier

[™ EgY_KhaN ™]

تسلم ايدك ع التجميعة دي
وادي كمان شوية حلوين

PET SPEED

 update _RefObjCommon set Speed1=200 , Speed2=200 where CodeName128 like  '%A_100%'

Disable PK

 ( add this to Addlogchar)


IF (@EventID = 4 OR @EventID = 6 OR @EventID = 11)
Update SRO_VT_SHARD.dbo._Char Set DailyPK = 15 where CharID = @CharID

change mob to unique

 USE SRO_VT_SHARD  
GO  

update _RefObjCommon set Rarity = 3 where CodeName128 = 'Code el mob hna'  

Print 'Mob has been changed to unique'

Fix auto Attack for wizz bug

 Use [SRO_VT_SHARD]

Update _RefSkill 
Set Service = 0 Where Basic_Code like 'SKILL_EU_STAFF_BASE_%'

Change a Teleport Place

 Use SRO_VT_SHARD
-----EgY_KhaN------
Go
DECLARE      @RefID int, 
                  @Cord_X int, 
                  @Cord_Y int, 
                  @Cord_Z int, 
                  @Region int 

SELECT @Cord_X = PosX, 
       @Cord_Y = PosY, 
       @Cord_Z = PosZ, 
       @Region = LatestRegion 
        
       FROM _Char WHERE CharName16 = 'test' 
	  
		
		UPDATE _RefObjCommon
SET OffsetX    = @CORD_X, 
      OffsetY    = @CORD_Y, 
      OffsetZ    = @CORD_Z, 
      RegionID = @Region 
WHERE CodeName128 = 'STORE_NPC_ZONE'

print ''
print 'Query full Coded By EgY_KhaN All Rights reserved'

CHANGE NPC PLACE

 USE SRO_VT_SHARD
DECLARE      @RefID int, 
                  @Cord_X int, 
                  @Cord_Y int, 
                  @Cord_Z int, 
                  @Region int 

SELECT @Cord_X = PosX, 
       @Cord_Y = PosY, 
       @Cord_Z = PosZ, 
       @Region = LatestRegion 
        
       FROM _Char WHERE CharName16 = 'test' 

SELECT       @RefID = R.dwTacticsID 
FROM   Tab_RefTactics R 
JOIN    _RefObjCommon O 
ON           O.ID = R.dwObjID 
WHERE O.CodeName128 LIKE 'NPC_CODE_HERE' 

UPDATE TAB_RefNest  
SET fLocalPosX    = @CORD_X, 
      fLocalPosY    = @CORD_Y, 
      fLocalPosZ    = @CORD_Z, 
      nRegionDBID = @Region 
WHERE dwTacticsID = @RefID