AmIMad

Bakalım be.
Kayıt
7 Şubat 2015
Mesajlar
412
Beğeniler
45
Şehir
Ankara
Silk Düzenleme
Kod:
USE SRO_VT_ACCOUNT 
UPDATE SK_Silk set silk_own = 10000 WHERE silk_own < 10000
Admin Panel
Kod:
USE SRO_VT_ACCOUNT 
SELECT * FROM TB_User 
WHERE StrUserID='GM' 
UPDATE srcms_userprofiles SET whois='admin' WHERE JID=9
Çarı İstedigin Yere Çekme
Kod:
USE SRO_VT_SHARD
UPDATE _Char SET LatestRegion= 27244, posX= 270 , posY= 180 ,posZ= 1421 ,AppointedTeleport=27244,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharName16 = ''
İtem Sorugulama
Kod:
USE SRO_VT_ACCOUNT 
         DECLARE @Serial bigint 
             declare @CID int 
             declare @AID int 
             declare @ItemCode varchar(50) 
             declare @loc varchar(50) 
             set @loc = 'inventory' 
         --------------------------------------------------- 
             SET @Serial = '' 
         --------------------------------------------------- 
             SET @CID = (select CharID from SHARD_VICTOR.dbo._Inventory where ItemID = (select ID64 from SHARD_VICTOR.dbo._Items where Serial64 like @Serial)) 
             if @CID is null 
             begin 
             SET @AID = (select UserJID from SHARD_VICTOR.dbo._Chest where ItemID = (select ID64 from SHARD_VICTOR.dbo._Items where Serial64 like @Serial)) 
             SET @loc = 'chest' 
             end 
             else if @AID is null 
             begin 
             SET @AID = (select UserJID from SHARD_VICTOR.dbo._User where CharID = (select OwnerCharID from SHARD_VICTOR.dbo._CharCOS where ID = (select COSID from SHARD_VICTOR.dbo._InvCOS where ItemID = (select ID64 from SHARD_VICTOR.dbo._Items where Serial64 like @Serial)))) 
             SET @loc = 'pet' 
             end 
             else 
             begin 
             SET @AID = (select UserJID from SHARD_VICTOR.dbo._User where CharID = @CID) 
             end 
             SET @ItemCode = (select CodeName128 from SHARD_VICTOR.dbo._RefObjCommon where ID = (select RefItemID from SHARD_VICTOR.dbo._Items where Serial64 like @Serial)) 
             SELECT top 1 tbuser.StrUserID as AccID, chart.CharName16 as CharName, @Serial as Serial, @ItemCode as ItemCode, @loc as Location 
             FROM TB_User as tbuser 
             JOIN SHARD_DB.dbo._AccountJID as accjid on tbuser.JID = accjid.JID 
             JOIN SHARD_DB.dbo._User as usert on accjid.JID = usert.UserJID 
             JOIN SHARD_DB.dbo._Char as chart on usert.CharID = chart.CharID 
             WHERE usert.UserJID = @AID
FB DEVİL YOLLAMA
Kod:
USE SRO_VT_SHARD 
UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898' 
WHERE ID64='0' 

6-To Back plus items 
USE SRO_VT_SHARD 
UPDATE _Items SET OptLevel = 20 WHERE OptLevel > 20
Premium Çar Ekle
Kod:
USE SRO_VT_SHARD 
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64) 

set @CharName = 'Albert'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_GLOBAL_GOLDTIME_PLUS' ,1,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE',1,11
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E080723_HWAN_POTION',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_04',1000,0
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GODBLESS',1,0
exec _ADD_ITEM_EXTERN @CharName,'HONOR_RANK_CROWN',1,0
exec _ADD_ITEM_EXTERN @CharName,'HONOR_RANK_COPPER',1,0
exec _ADD_ITEM_EXTERN @CharName,'HONOR_RANK_GOLD',1,0
FB İTEM YOLLAMA 15LER DGLERİDİR İSTEGİNİZ DGDE YOLLAYN
Kod:
USE SHARD   
--Usage:  
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl  
declare @CharName varchar(64)   
   
set @CharName = ''  

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_15_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_BA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_HA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_FA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_LA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_AA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_M_LIGHT_15_SA_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_15_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_15_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_15_C_RARE',1,8  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_ARCHEMY_UPPER_REINFORCE_RECIPE_WE_RARE_D_15',1,0
Teleport Ekleme
Kod:
USE SRO_VT_SHARD /* Add new Teleport By Albert */  


DECLARE @Teleport VARCHAR (64)  
DECLARE @CHARNAME1 VARCHAR (30)  
DECLARE @CHARNAME2 VARCHAR (30)  
DECLARE @OwnTeleport INT  
DECLARE @Fee INT  
DECLARE @RequiredLVL INT  

/* Put your settings here */  
SET @Teleport = 'unique_area1' -- any name you want ex: PK_ZONE or PVP_ZONE  
SET @CHARNAME1 = '[GM]WildOne' -- Teleport position  
SET @CHARNAME2 = 'Road' -- Spawn position after teleport  
SET @OwnTeleport = 1  -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople  
SET @Fee = 50000  -- Gold amount to Pass the teleport  
SET @RequiredLVL = 0  -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport  
/* settings area end here */  

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)  
 BEGIN  
  raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);  
  RETURN;  
 END  
      
    DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1  
    DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)  
    DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)  
    DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)  
    DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)  
    DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1  
       
    SET IDENTITY_INSERT _RefObjCommon ON  
    INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES  
    (1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,'quest\ins_quest_teleport.bsr','xxx','xxx','xxx','xxx',@link)  
    SET IDENTITY_INSERT _RefObjCommon OFF  
      
    print ''  
    print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'  
    print '1    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'STORE_'+@Teleport+'    '+@Teleport+'    xxx    '+'SN_STORE_'+@Teleport+'    xxx    0    0    4    1    1    0    0    3    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    '+CONVERT(varchar(max),@REGION1)+'    0    '+CONVERT(varchar(max),@POSX1)+'    '+CONVERT(varchar(max),@POSY1)+'    '+CONVERT(varchar(max),@POSZ1)+'    0    0    50    50    30    0    quest\teleport01.bsr    xxx    xxx    xxx    xxx    '+CONVERT(varchar(max),@link)  
    print ''  
    print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'  
    print ''  
    print '1    '+'SN_STORE_'+@Teleport+'                                '+@Teleport  
    print ''  
      print ''  

  SET IDENTITY_INSERT _RefObjStruct ON  
  INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES  
  (@LINK,0)  
  SET IDENTITY_INSERT _RefObjStruct OFF  
    
  DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1  
  DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)  
  DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)  
  DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)  
  DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)  
  DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)  

  INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,AssocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos_Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGotoResurrectPos,GenWorldID,BindInteractionMask,FixedService) VALUES  
  (1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport,@MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POSY2,@POSZ2,30,0,0,@WORLDID,1,0)  
    
  print ''  
  print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'  
  print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+'GATE_'+@Teleport+'    '+CONVERT(varchar(max),@MAXOBJ)+'    '+'SN_STORE_'+@Teleport+'    '+CONVERT(varchar(max),@REGION2)+'    '+CONVERT(varchar(max),@POSX2)+'    '+CONVERT(varchar(max),@POSY2)+'    '+CONVERT(varchar(max),@POSZ2)+'    30    0    0    '+CONVERT(varchar(max),@WORLDID)+'    1    0'  
  print ''  
  print ''  

  IF @RequiredLVL = 0  
  BEGIN  
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES  
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)  
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES  
    (1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)  
      
print ''  
    print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'  
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'  
    print '1    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0'  
    print ''  
  END  
  ELSE BEGIN  
    INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,RestrictBindMethod,RunTimeTeleportMethod,CheckResult,Restrict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Restrict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,Restrict5,Data5_1,Data5_2) VALUES  
    (1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLVL,999,0,0,0,0,0,0,0,0,0,0,0,0)  
      
    print ''  
    print ''  
    print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'  
    print '1    '+CONVERT(varchar(max),@OwnTeleport)+'    '+CONVERT(varchar(max),@MAXTELID)+'    '+CONVERT(varchar(max),@Fee)+'    0    0    0    1    '+CONVERT(varchar(max),@RequiredLVL)+'    999    0    0    0    0    0    0    0    0    0    0    0    0'  
    print ''  

  END  

print ''  
print 'Done!'
Unigelerin Yerini Degiştirme Veya Spawda Olmayanları Spawwa ekleme
Kod:
USE SRO_VT_SHARD   

DECLARE @UNIQUE VARCHAR (129)  
DECLARE @CHARNAME VARCHAR (64)  
DECLARE @mindealy INT  
DECLARE @maxdelay int  
DECLARE @INITRADIUS INT  
DECLARE @RADIUS int  
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1  
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1  
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1  

/* put your settings here */  
SET @UNIQUE = 'MOB_CH_TIGERWOMAN_L2' -- Unique code name from _RefobjCommon table  
SET @CHARNAME = 'WildOne' -- Character name from _Char table to get mob position X Y Z  
SET @mindealy = 1  -- Minimum time before appears in seconds  
SET @maxdelay = 5  -- Maximum time before appears in seconds  
SET @INITRADIUS = 100  -- Radius around spot unique can generated at  
SET @RADIUS = 200  -- Radius around spot Unique can move in  
/* end of settings area */  

/* get ID of mob by code name */  
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)  

--SET IDENTITY_INSERT Tab_RefTactics ON  
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES  
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)  
--SET IDENTITY_INSERT Tab_RefTactics OFF  

--SET IDENTITY_INSERT Tab_RefHive ON  
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES  
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)  
--SET IDENTITY_INSERT Tab_RefHive OFF  

/* get position coordinates of your character */  

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)  

--SET IDENTITY_INSERT Tab_RefNest ON  
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES  
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)  
--SET IDENTITY_INSERT Tab_RefNest OFF  


print ''  
print ''  
print 'Done!'
Magic Pop Rate
Kod:
USE [SRO_VT_SHARD]  
GO  
/* MsSQL Script For Change Magic Pop Rates  - ! ******** ! */  
DECLARE @Rate int  
SET @Rate = 10  
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
STONE RATEYİ DEGİŞTİRİN
Kod:
USE SRO_VT_SHARD  
GO  
UPDATE _RefObjItem  
SET Param4 = Here Put The Rate You Want %  
WHERE ID BETWEEN 4630 AND 5013
Mob Levellerini Düzenleyin
Kod:
USE SRO_VT_SHARD 

Declare @link int, @codename varchar(max), @level int, @newlevel int; 

set @codename = 'SN_MOB_SD_HIKE' /* <- from textdata_object.txt */ 



set @link = (SELECT Link FROM _RefObJCommon WHERE NameStrID128 = @codename) 
set @newlevel = ( 
case 
when (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 <= 120 THEN (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 
ELSE 120 
end); 

UPDATE _RefObjChar SET Lvl = @newlevel WHERE ID = @link 
UPDATE _RefObjChar SET ExpToGive = cast(ExpToGive*1.1 as bigint) WHERE ID = @link 
UPDATE _RefObjChar SET MaxHP = cast(MaxHP*1.1 as bigint) WHERE ID = @link
Guild Cezalarını 0 Yapın
Kod:
USE [SRO_VT_SHARD]   
GO   
/******By Albert ******/   
SET ANSI_NULLS ON   
GO   
SET QUOTED_IDENTIFIER ON   
GO   

ALTER   procedure [dbo].[_AddTimedJob]   
@CharID            int,   
@Category        tinyint,   
@JobID            int,   
@TimeToKeep    int,   
@Data1            int,   
@Data2            int,   
--##begin due to develop composite item   
@Data3            int,   
@Data4            int,   
@Data5            int,   
@Data6            int,   
@Data7            int,   
@Data8            int,   
@Serial64        bigint,   
@JID            int   
--##end due to develop composite item   
as   
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))   
                return -1   
            if (@TimeToKeep <= 0)   
                return -2   
            declare @NewJobID int   
            set @NewJobID = 0   

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader   
            --##If you want to only have one not both, then just modify the line below!   
            if (@JobID = 1 or @JobID = 2)   
            BEGIN   
                return -1   
            END   
            ELSE   
            BEGIN   
            --##begin due to develop composite item   
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)   
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)   
            END   
            --##end due to develop composite item   
            set @NewJobID = @@identity   
            if (@@error <> 0 or @@rowcount = 0)   
                   
                return -3   
     return @NewJobID
Artılı İtem Yollayın
Kod:
USE [SRO_VT_SHARD]

Declare @CharName Varchar (64)
Declare @Plus Varchar (64)
Declare @Slot Varchar (64)
Declare @CharID INT 
Declare @Item INT

Set @CharName = 'Albert' -- Enter Your CharName
Set @Plus = '250' -- Plus OptLevel
Set @Slot = '13' -- First Inventory Slot
Set @CharID = (select CharID from _Char where CharName16 = @CharName)
Set @Item = ( select ItemID from _Inventory where CharID = @CharID and Slot = @Slot )

update _Items
set OptLevel = @Plus 
where ID64 = @Item
Carın Butun Skillerini Açmak
Kod:
USE [SRO_VT_SHARD]  
DECLARE @CharName varchar(255)  
DECLARE @CharID INT  
SET @CharName='11'  
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName  
UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID  
INSERT INTO _CharSkill VALUES (@CharID,1,1)  
INSERT INTO _CharSkill VALUES (@CharID,2,1)  
INSERT INTO _CharSkill VALUES (@CharID,40,1)  
INSERT INTO _CharSkill VALUES (@CharID,70,1)  
INSERT INTO _CharSkill VALUES (@CharID,298,1)  
INSERT INTO _CharSkill VALUES (@CharID,306,1)  
INSERT INTO _CharSkill VALUES (@CharID,314,1)  
INSERT INTO _CharSkill VALUES (@CharID,322,1)  
INSERT INTO _CharSkill VALUES (@CharID,346,1)  
INSERT INTO _CharSkill VALUES (@CharID,378,1)  
INSERT INTO _CharSkill VALUES (@CharID,418,1)  
INSERT INTO _CharSkill VALUES (@CharID,463,1)  
INSERT INTO _CharSkill VALUES (@CharID,558,1)  
INSERT INTO _CharSkill VALUES (@CharID,569,1)  
INSERT INTO _CharSkill VALUES (@CharID,580,1)  
INSERT INTO _CharSkill VALUES (@CharID,588,1)  
INSERT INTO _CharSkill VALUES (@CharID,596,1)  
INSERT INTO _CharSkill VALUES (@CharID,604,1)  
INSERT INTO _CharSkill VALUES (@CharID,647,1)  
INSERT INTO _CharSkill VALUES (@CharID,655,1)  
INSERT INTO _CharSkill VALUES (@CharID,672,1)  
INSERT INTO _CharSkill VALUES (@CharID,689,1)  
INSERT INTO _CharSkill VALUES (@CharID,699,1)  
INSERT INTO _CharSkill VALUES (@CharID,708,1)  
INSERT INTO _CharSkill VALUES (@CharID,716,1)  
INSERT INTO _CharSkill VALUES (@CharID,724,1)  
INSERT INTO _CharSkill VALUES (@CharID,735,1)  
INSERT INTO _CharSkill VALUES (@CharID,746,1)  
INSERT INTO _CharSkill VALUES (@CharID,757,1)  
INSERT INTO _CharSkill VALUES (@CharID,765,1)  
INSERT INTO _CharSkill VALUES (@CharID,773,1)  
INSERT INTO _CharSkill VALUES (@CharID,781,1)  
INSERT INTO _CharSkill VALUES (@CharID,789,1)  
INSERT INTO _CharSkill VALUES (@CharID,797,1)  
INSERT INTO _CharSkill VALUES (@CharID,805,1)  
INSERT INTO _CharSkill VALUES (@CharID,813,1)  
INSERT INTO _CharSkill VALUES (@CharID,821,1)  
INSERT INTO _CharSkill VALUES (@CharID,829,1)  
INSERT INTO _CharSkill VALUES (@CharID,853,1)  
INSERT INTO _CharSkill VALUES (@CharID,885,1)  
INSERT INTO _CharSkill VALUES (@CharID,925,1)  
INSERT INTO _CharSkill VALUES (@CharID,933,1)  
INSERT INTO _CharSkill VALUES (@CharID,943,1)  
INSERT INTO _CharSkill VALUES (@CharID,952,1)  
INSERT INTO _CharSkill VALUES (@CharID,960,1)  
INSERT INTO _CharSkill VALUES (@CharID,968,1)  
INSERT INTO _CharSkill VALUES (@CharID,976,1)  
INSERT INTO _CharSkill VALUES (@CharID,984,1)  
INSERT INTO _CharSkill VALUES (@CharID,992,1)  
INSERT INTO _CharSkill VALUES (@CharID,1003,1)  
INSERT INTO _CharSkill VALUES (@CharID,1014,1)  
INSERT INTO _CharSkill VALUES (@CharID,1025,1)  
INSERT INTO _CharSkill VALUES (@CharID,1033,1)  
INSERT INTO _CharSkill VALUES (@CharID,1041,1)  
INSERT INTO _CharSkill VALUES (@CharID,1049,1)  
INSERT INTO _CharSkill VALUES (@CharID,1053,1)  
INSERT INTO _CharSkill VALUES (@CharID,1057,1)  
INSERT INTO _CharSkill VALUES (@CharID,1065,1)  
INSERT INTO _CharSkill VALUES (@CharID,1073,1)  
INSERT INTO _CharSkill VALUES (@CharID,1081,1)  
INSERT INTO _CharSkill VALUES (@CharID,1089,1)  
INSERT INTO _CharSkill VALUES (@CharID,1099,1)  
INSERT INTO _CharSkill VALUES (@CharID,1108,1)  
INSERT INTO _CharSkill VALUES (@CharID,1116,1)  
INSERT INTO _CharSkill VALUES (@CharID,1124,1)  
INSERT INTO _CharSkill VALUES (@CharID,1132,1)  
INSERT INTO _CharSkill VALUES (@CharID,1140,1)  
INSERT INTO _CharSkill VALUES (@CharID,1148,1)  
INSERT INTO _CharSkill VALUES (@CharID,1153,1)  
INSERT INTO _CharSkill VALUES (@CharID,1158,1)  
INSERT INTO _CharSkill VALUES (@CharID,1163,1)  
INSERT INTO _CharSkill VALUES (@CharID,1168,1)  
INSERT INTO _CharSkill VALUES (@CharID,1173,1)  
INSERT INTO _CharSkill VALUES (@CharID,1178,1)  
INSERT INTO _CharSkill VALUES (@CharID,1189,1)  
INSERT INTO _CharSkill VALUES (@CharID,1200,1)  
INSERT INTO _CharSkill VALUES (@CharID,1217,1)  
INSERT INTO _CharSkill VALUES (@CharID,1234,1)  
INSERT INTO _CharSkill VALUES (@CharID,1244,1)  
INSERT INTO _CharSkill VALUES (@CharID,1253,1)  
INSERT INTO _CharSkill VALUES (@CharID,1261,1)  
INSERT INTO _CharSkill VALUES (@CharID,1269,1)  
INSERT INTO _CharSkill VALUES (@CharID,1271,1)  
INSERT INTO _CharSkill VALUES (@CharID,1273,1)  
INSERT INTO _CharSkill VALUES (@CharID,1275,1)  
INSERT INTO _CharSkill VALUES (@CharID,1286,1)  
INSERT INTO _CharSkill VALUES (@CharID,1297,1)  
INSERT INTO _CharSkill VALUES (@CharID,1308,1)  
INSERT INTO _CharSkill VALUES (@CharID,1316,1)  
INSERT INTO _CharSkill VALUES (@CharID,1324,1)  
INSERT INTO _CharSkill VALUES (@CharID,1332,1)  
INSERT INTO _CharSkill VALUES (@CharID,1337,1)  
INSERT INTO _CharSkill VALUES (@CharID,1342,1)  
INSERT INTO _CharSkill VALUES (@CharID,1350,1)  
INSERT INTO _CharSkill VALUES (@CharID,1358,1)  
INSERT INTO _CharSkill VALUES (@CharID,1368,1)  
INSERT INTO _CharSkill VALUES (@CharID,1377,1)  
INSERT INTO _CharSkill VALUES (@CharID,1385,1)  
INSERT INTO _CharSkill VALUES (@CharID,1393,1)  
INSERT INTO _CharSkill VALUES (@CharID,1398,1)  
INSERT INTO _CharSkill VALUES (@CharID,1403,1)  
INSERT INTO _CharSkill VALUES (@CharID,1408,1)  
INSERT INTO _CharSkill VALUES (@CharID,1410,1)  
INSERT INTO _CharSkill VALUES (@CharID,1412,1)  
INSERT INTO _CharSkill VALUES (@CharID,1414,1)  
INSERT INTO _CharSkill VALUES (@CharID,1422,1)  
INSERT INTO _CharSkill VALUES (@CharID,1430,1)  
INSERT INTO _CharSkill VALUES (@CharID,1438,1)  
INSERT INTO _CharSkill VALUES (@CharID,1443,1)  
INSERT INTO _CharSkill VALUES (@CharID,1448,1)  
INSERT INTO _CharSkill VALUES (@CharID,1465,1)  
INSERT INTO _CharSkill VALUES (@CharID,1482,1)  
INSERT INTO _CharSkill VALUES (@CharID,1499,1)  
INSERT INTO _CharSkill VALUES (@CharID,1509,1)  
INSERT INTO _CharSkill VALUES (@CharID,1518,1)  
INSERT INTO _CharSkill VALUES (@CharID,1526,1)  
INSERT INTO _CharSkill VALUES (@CharID,1534,1)  
INSERT INTO _CharSkill VALUES (@CharID,1539,1)  
INSERT INTO _CharSkill VALUES (@CharID,1544,1)  
INSERT INTO _CharSkill VALUES (@CharID,1549,1)  
INSERT INTO _CharSkill VALUES (@CharID,1557,1)  
INSERT INTO _CharSkill VALUES (@CharID,1565,1)  
INSERT INTO _CharSkill VALUES (@CharID,1573,1)  
INSERT INTO _CharSkill VALUES (@CharID,1578,1)  
INSERT INTO _CharSkill VALUES (@CharID,1583,1)  
INSERT INTO _CharSkill VALUES (@CharID,1588,1)  
INSERT INTO _CharSkill VALUES (@CharID,1593,1)  
INSERT INTO _CharSkill VALUES (@CharID,1598,1)  
INSERT INTO _CharSkill VALUES (@CharID,1609,1)  
INSERT INTO _CharSkill VALUES (@CharID,1617,1)  
INSERT INTO _CharSkill VALUES (@CharID,1628,1)  
INSERT INTO _CharSkill VALUES (@CharID,3149,1)  
INSERT INTO _CharSkill VALUES (@CharID,3167,1)  
INSERT INTO _CharSkill VALUES (@CharID,3176,1)  
INSERT INTO _CharSkill VALUES (@CharID,3224,1)  
INSERT INTO _CharSkill VALUES (@CharID,3340,1)  
INSERT INTO _CharSkill VALUES (@CharID,3349,1)  
INSERT INTO _CharSkill VALUES (@CharID,3364,1)  
INSERT INTO _CharSkill VALUES (@CharID,3379,1)  
INSERT INTO _CharSkill VALUES (@CharID,3391,1)  
INSERT INTO _CharSkill VALUES (@CharID,3406,1)  
INSERT INTO _CharSkill VALUES (@CharID,3409,1)  
INSERT INTO _CharSkill VALUES (@CharID,3415,1)  
INSERT INTO _CharSkill VALUES (@CharID,3430,1)  
INSERT INTO _CharSkill VALUES (@CharID,3431,1)  
INSERT INTO _CharSkill VALUES (@CharID,3446,1)  
INSERT INTO _CharSkill VALUES (@CharID,3461,1)  
INSERT INTO _CharSkill VALUES (@CharID,3467,1)  
INSERT INTO _CharSkill VALUES (@CharID,3473,1)  
INSERT INTO _CharSkill VALUES (@CharID,7139,1)  
INSERT INTO _CharSkill VALUES (@CharID,7159,1)  
INSERT INTO _CharSkill VALUES (@CharID,7203,1)  
INSERT INTO _CharSkill VALUES (@CharID,7322,1)  
INSERT INTO _CharSkill VALUES (@CharID,7385,1)  
INSERT INTO _CharSkill VALUES (@CharID,7390,1)  
INSERT INTO _CharSkill VALUES (@CharID,7392,1)  
INSERT INTO _CharSkill VALUES (@CharID,7404,1)  
INSERT INTO _CharSkill VALUES (@CharID,7418,1)  
INSERT INTO _CharSkill VALUES (@CharID,7474,1)  
INSERT INTO _CharSkill VALUES (@CharID,7484,1)  
INSERT INTO _CharSkill VALUES (@CharID,7513,1)  
INSERT INTO _CharSkill VALUES (@CharID,7520,1)  
INSERT INTO _CharSkill VALUES (@CharID,7536,1)  
INSERT INTO _CharSkill VALUES (@CharID,7554,1)  
INSERT INTO _CharSkill VALUES (@CharID,7577,1)  
INSERT INTO _CharSkill VALUES (@CharID,7582,1)  
INSERT INTO _CharSkill VALUES (@CharID,7584,1)  
INSERT INTO _CharSkill VALUES (@CharID,7596,1)  
INSERT INTO _CharSkill VALUES (@CharID,7612,1)  
INSERT INTO _CharSkill VALUES (@CharID,7637,1)  
INSERT INTO _CharSkill VALUES (@CharID,7651,1)  
INSERT INTO _CharSkill VALUES (@CharID,7672,1)  
INSERT INTO _CharSkill VALUES (@CharID,7675,1)  
INSERT INTO _CharSkill VALUES (@CharID,7688,1)  
INSERT INTO _CharSkill VALUES (@CharID,7798,1)  
INSERT INTO _CharSkill VALUES (@CharID,7805,1)  
INSERT INTO _CharSkill VALUES (@CharID,7829,1)  
INSERT INTO _CharSkill VALUES (@CharID,7838,1)  
INSERT INTO _CharSkill VALUES (@CharID,7839,1)  
INSERT INTO _CharSkill VALUES (@CharID,7853,1)  
INSERT INTO _CharSkill VALUES (@CharID,7862,1)  
INSERT INTO _CharSkill VALUES (@CharID,7877,1)  
INSERT INTO _CharSkill VALUES (@CharID,7881,1)  
INSERT INTO _CharSkill VALUES (@CharID,7894,1)  
INSERT INTO _CharSkill VALUES (@CharID,7899,1)  
INSERT INTO _CharSkill VALUES (@CharID,7907,1)  
INSERT INTO _CharSkill VALUES (@CharID,7919,1)  
INSERT INTO _CharSkill VALUES (@CharID,7931,1)  
INSERT INTO _CharSkill VALUES (@CharID,7938,1)  
INSERT INTO _CharSkill VALUES (@CharID,7947,1)  
INSERT INTO _CharSkill VALUES (@CharID,7953,1)  
INSERT INTO _CharSkill VALUES (@CharID,7959,1)  
INSERT INTO _CharSkill VALUES (@CharID,7962,1)  
INSERT INTO _CharSkill VALUES (@CharID,7972,1)  
INSERT INTO _CharSkill VALUES (@CharID,7980,1)  
INSERT INTO _CharSkill VALUES (@CharID,7995,1)  
INSERT INTO _CharSkill VALUES (@CharID,7997,1)  
INSERT INTO _CharSkill VALUES (@CharID,8010,1)  
INSERT INTO _CharSkill VALUES (@CharID,8024,1)  
INSERT INTO _CharSkill VALUES (@CharID,8050,1)  
INSERT INTO _CharSkill VALUES (@CharID,8084,1)  
INSERT INTO _CharSkill VALUES (@CharID,8097,1)  
INSERT INTO _CharSkill VALUES (@CharID,8103,1)  
INSERT INTO _CharSkill VALUES (@CharID,8109,1)  
INSERT INTO _CharSkill VALUES (@CharID,8115,1)  
INSERT INTO _CharSkill VALUES (@CharID,8119,1)  
INSERT INTO _CharSkill VALUES (@CharID,8129,1)  
INSERT INTO _CharSkill VALUES (@CharID,8133,1)  
INSERT INTO _CharSkill VALUES (@CharID,8142,1)  
INSERT INTO _CharSkill VALUES (@CharID,8150,1)  
INSERT INTO _CharSkill VALUES (@CharID,8164,1)  
INSERT INTO _CharSkill VALUES (@CharID,8171,1)  
INSERT INTO _CharSkill VALUES (@CharID,8183,1)  
INSERT INTO _CharSkill VALUES (@CharID,8195,1)  
INSERT INTO _CharSkill VALUES (@CharID,8204,1)  
INSERT INTO _CharSkill VALUES (@CharID,8214,1)  
INSERT INTO _CharSkill VALUES (@CharID,8220,1)  
INSERT INTO _CharSkill VALUES (@CharID,8221,1)  
INSERT INTO _CharSkill VALUES (@CharID,8238,1)  
INSERT INTO _CharSkill VALUES (@CharID,8239,1)  
INSERT INTO _CharSkill VALUES (@CharID,8250,1)  
INSERT INTO _CharSkill VALUES (@CharID,8253,1)  
INSERT INTO _CharSkill VALUES (@CharID,8276,1)  
INSERT INTO _CharSkill VALUES (@CharID,8291,1)  
INSERT INTO _CharSkill VALUES (@CharID,8304,1)  
INSERT INTO _CharSkill VALUES (@CharID,8316,1)  
INSERT INTO _CharSkill VALUES (@CharID,8320,1)  
INSERT INTO _CharSkill VALUES (@CharID,8338,1)  
INSERT INTO _CharSkill VALUES (@CharID,8347,1)  
INSERT INTO _CharSkill VALUES (@CharID,8348,1)  
INSERT INTO _CharSkill VALUES (@CharID,8361,1)  
INSERT INTO _CharSkill VALUES (@CharID,8370,1)  
INSERT INTO _CharSkill VALUES (@CharID,8379,1)  
INSERT INTO _CharSkill VALUES (@CharID,8383,1)  
INSERT INTO _CharSkill VALUES (@CharID,8390,1)  
INSERT INTO _CharSkill VALUES (@CharID,8399,1)  
INSERT INTO _CharSkill VALUES (@CharID,8405,1)  
INSERT INTO _CharSkill VALUES (@CharID,8410,1)  
INSERT INTO _CharSkill VALUES (@CharID,8414,1)  
INSERT INTO _CharSkill VALUES (@CharID,8416,1)  
INSERT INTO _CharSkill VALUES (@CharID,20494,1)  
INSERT INTO _CharSkill VALUES (@CharID,20497,1)  
INSERT INTO _CharSkill VALUES (@CharID,20500,1)  
INSERT INTO _CharSkill VALUES (@CharID,21215,1)  
INSERT INTO _CharSkill VALUES (@CharID,21217,1)  
INSERT INTO _CharSkill VALUES (@CharID,30578,1)  
INSERT INTO _CharSkill VALUES (@CharID,30584,1)  
INSERT INTO _CharSkill VALUES (@CharID,30590,1)  
INSERT INTO _CharSkill VALUES (@CharID,30596,1)  
INSERT INTO _CharSkill VALUES (@CharID,30600,1)
Kayıb Dünya Sürelerini Düzenlemek
Kod:
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'  
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'  
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3'  
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4'  

UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35901'  
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35902'  
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35903'  
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35904'  





time in Sec = 10800
Şehir İsimleri
Kod:
CHINA    = Jangan 
TQ    = Qin-Shi Tomb (Jangan Cave) 
West_China    = Downhang 
Oasis_Kingdom    = Hotan 
Thief Village    = Thief town 
Roc    = Roc Mountain 
Eu    = Constantinople 
Am    = Asia Minor (Captain Ivy) 
Ca    = Central Asia (Samarkand) 
SD    = DESERT OF ALEX 
KingsValley    = ALEX DOWN 
Pharaoh= HOLY TEMPLE 
DELTA    = ALEXANDRIA TOWN 
TEMPLE    = JOB CAVE ALEXANDRIA 
FORT_JA_AREA    = Jangan FW 
FORT_DW_AREA    = Donwhang FW 
FORT_HT_AREA    = Hotan FW 
FORT_CT_AREA = Constantiple FW 
FORT_SK_AREA = Samarkand FW  
FORT_BJ_AREA    = Bandit FW 
FORT_HM_AREA    = - 
FORT_ER_AREA    = - 
ARENA_OCCUPY    = - 
ARENA_FLAG    = Arena Flag 
ARENA_SCORE    = Arena Score 
SIEGE_DUNGEON    = Capture the Flag 
ARENA_GNGWC    = Arena GNGWC 
GOD_TOGUI    = Forgotten World 
GOD_WRECK_IN    = Forgotten World 
GOD_FLAME    = Forgotten World 
GOD_WRECK_OUT    = Forgotten World 
EVENT_GHOST    = Forgotten World 
JUPITER    = Jupiter Temple 120 mob 
PRISON = Prison
Arkadaşlar Arsivden Paylaşımdır Güle Güle Kullanın
 
Yukarı Alt