1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

VSRO SQL Qeury


  1. AmIMad

    AmIMad Bakalım be. moderator rank8

    Kayıt:
    7 Şubat 2015
    Mesajlar:
    373
    Beğenilen Mesajlar:
    33
    Ödül Puanları:
    28
    Meslek:
    Mermerci :)
    Ş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
     
  2. sarkolata

    sarkolata zaa xD olduser rank8

    Kayıt:
    15 Temmuz 2009
    Mesajlar:
    8.601
    Beğenilen Mesajlar:
    69
    Ödül Puanları:
    58
    Meslek:
    İt Kopuk
    Şehir:
    Istanbul City
    teşekkürler dostm